思迅专卖店10/数据库字典/t shd sheet detail
来自Blueidea
< 思迅专卖店10
字段名 | 字段类型(长度) | 是否为空 | 功能 |
---|---|---|---|
flow_id | numeric(14) | NO | |
sheet_no | char(18) | NO | |
item_no | char(20) | NO | |
orgi_price | numeric(16) | YES | |
valid_price | numeric(16) | YES | |
order_qty | numeric(16) | YES | |
real_qty | numeric(16) | YES | |
large_qty | numeric(16) | YES | |
sub_amt | numeric(16) | YES | |
tax | numeric(5) | YES | |
cost_price | numeric(16) | YES | |
send_qty | numeric(16) | YES | |
sale_price | numeric(16) | YES | |
memo | varchar(60) | YES | |
num1 | numeric(16) | YES | |
come_num | decimal(16) | YES | |
memo1 | varchar(255) | YES | |
del_day_num | numeric(16) | YES | |
del_time | varchar(1) | YES | |
del_startdate | datetime(1) | YES | |
del_enddate | datetime(1) | YES | |
del_week | varchar(7) | YES | |
del_day_one | varchar(2) | YES | |
del_sum_num | numeric(16) | YES | |
del_item_no | numeric(16) | YES | |
del_flag | varchar(1) | YES | |
del_subno_flag | varchar(1) | YES | |
del_subno | varchar(20) | YES | |
stop_day | varchar(4) | YES | |
stop_date | datetime(4) | YES |