序号字段说明数据类型长度自增主键允许空默认值
1id客户调货单单号char11××NULL
2row_id行号smallint2××NULL
3fas_id款式编号varchar20××(space(1))
4col_id颜色编号varchar8××(space(1))
5siz_id尺码编号varchar8××(space(1))
6prd_price结算价numeric9××(0)
7prd_price_pt批退结算价numeric9××(0)
8prd_cost成本价numeric9××(0)
9quantity数量numeric5××(0)
10distcount折扣numeric5××(1)
11sys_colo行色号varchar11××NULL
12sys_stdby1 varchar8××NULL
13sys_stdby2 varchar8××NULL
14distcount_show实际折扣numeric5××(1)
15distcount_show_pt批退实际折扣numeric5××(1)
16id2 varchar8×××(‘1’)
17id3 varchar20××NULL
18row_id2二维行号int4×××(1)
19Sys_Memo备注varchar200××NULL
20fas_pm varchar20××NULL
21pm_num smallint2××NULL
22prd_price_old_pf批发出货吊牌价numeric9××NULL
23prd_price_old_pt批退退货吊牌价numeric9××NULL
24prd_price_bas_pf numeric9××NULL
25prd_price_bas_pt numeric9××NULL
26bat_id nvarchar40××NULL
27inputType varchar16××NULL
28sys_sum numeric9××NULL
© 版权声明