Skip to content

VIEWCOPMX1 销售明细表

字段编号字段名称类型长度字段说明
1IO类型C:Char10
2LA013成本N:Numeric20.6
3LA017成本-材料N:Numeric20.6
4LA018成本-人工N:Numeric20.6
5LA019成本-制费N:Numeric20.6
6LA020成本-加工N:Numeric20.6
7MA002客户名称C:Char50
8MA003品号类别名称C:Char50
9MB002工厂名称C:Char50
10MC002仓库名称C:Char55
11ME002部门名称C:Char50
12MG005客户品名V:Varchar255
13MG006客户规格V:Varchar255
14MR0031分类简称C:Char50
15MR0032分类简称C:Char50
16MR0033地区C:Char50
17MR0034分类简称C:Char50
18MR0035分类简称C:Char50
19MR0036分类简称C:Char50
20MV002业务员C:Char50
21TC012客户单号C:Char55
22TG003销货日期C:Char50
23TG004客户编号C:Char50
24TG006业务员C:Char55
25TG011币种C:Char55
26TG012汇率N:Numeric12.7
27TG016发票种类C:Char55
28TG017税种C:Char55
29TG036生成分录-收入C:Char5
30TG037生成分录-成本C:Char5
31TG076签收状态C:Char10
32TG077签收日期C:Char10
33TG079生成分录-发出商品C:Char5
34TH004品号C:Char50
35TH005品名V:Varchar255
36TH006规格V:Varchar255
37TH008数量N:Numeric20.6
38TH009单位C:Char55
39TH011小单位C:Char55
40TH012单价N:Numeric20.6
41TH013金额N:Numeric20.6
42TH017批号C:Char55
43TH019客户品号C:Char55
44TH024赠/备品量N:Numeric16.6
45TH026开票码C:Char50
46TH035原币税前金额N:Numeric20.6
47TH036原币税额N:Numeric20.6
48TH037本币税前金额N:Numeric20.6
49TH038本币税额N:Numeric20.6
50TH039包装数量N:Numeric20.6
51TH040赠/备品包装量N:Numeric20.6
52TH041包装单位C:Char4
53TH042已开票数量N:Numeric20.6
54TH055批号说明C:Char55
55TH056库位C:Char55
56TH123销货单别单号序号C:Char60
57TH456订单单别单号序号C:Char60
58TJ040验退数量N:Numeric20.6
59UDF05发货方式V:Varchar255COPTG_UDF05
60UDF06物流单号V:Varchar255COPTG_UDF06