ic_general_h - 出入库单表头
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | cgeneralhid | 出入库单表头ID | CHAR | Y | 20 | 0 | | | | |
bassetcard | 已生成资产卡片 | CHAR | | 1 | 0 | N | | | |
bdelivedtorm | 是否已下发到零售 | CHAR | | 1 | 0 | | | | |
bdirecttranflag | 是否直接调拨 | CHAR | | 1 | 0 | N | | | |
boutretflag | 是否退回 | CHAR | | 1 | 0 | | | | |
bsalecooppur | 销售出是否已协同生成采购入 | CHAR | | 1 | 0 | N | | | |
cauditorid | 审核人 | CHAR | | 20 | 0 | | | | |
cbilltypecode | 库存单据类型编码 | VARCHAR | | 4 | 0 | | | | |
cbizid | 业务员ID | CHAR | | 20 | 0 | | | | |
cbiztype | 业务类型ID | CHAR | | 20 | 0 | | | | |
ccustomerid | 客户ID | CHAR | | 20 | 0 | | | | |
cdilivertypeid | 发运方式ID | CHAR | | 20 | 0 | | | | |
cdispatcherid | 收发类型ID | CHAR | | 20 | 0 | | | | |
cdptid | 部门ID | CHAR | | 20 | 0 | | | | |
cendreportid | 完工报告PK | CHAR | | 20 | 0 | | | | |
cinventoryid | 存货ID | CHAR | | 20 | 0 | | | | |
clastmodiid | 最后修改人 | CHAR | | 20 | 0 | | | | |
coperatorid | 制单人 | CHAR | | 20 | 0 | | | | |
cothercalbodyid | 对方库存组织PK | CHAR | | 20 | 0 | | | | |
cothercorpid | 对方公司ID | CHAR | | 4 | 0 | | | | |
cotherwhid | 其它仓库ID | CHAR | | 20 | 0 | | | | |
coutcalbodyid | 调出库存组织ID | CHAR | | 20 | 0 | | | | |
coutcorpid | 调出公司ID | CHAR | | 4 | 0 | | | | |
cproviderid | 供应商ID | CHAR | | 20 | 0 | | | | |
cregister | 库房签字人 | CHAR | | 20 | 0 | | | | |
csettlepathid | 结算路径 | CHAR | | 20 | 0 | | | | |
ctrancustid | 承运商 | CHAR | | 20 | 0 | | | | |
cwarehouseid | 仓库ID | CHAR | | 20 | 0 | | | | |
cwastewarehouseid | 废品仓库ID | CHAR | | 20 | 0 | | | | |
cwhsmanagerid | 库管员ID | CHAR | | 20 | 0 | | | | |
daccountdate | 库房签字日期 | CHAR | | 10 | 0 | | | | |
dauditdate | 审核日期 | CHAR | | 10 | 0 | | | | |
dbilldate | 单据日期 | CHAR | | 10 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
fallocflag | 调拨类型标志 | SMALLINT | | 2 | 0 | | | | |
fbillflag | 单据状态 | SMALLINT | | 2 | 0 | | | | |
freplenishflag | 退货标志 | CHAR | | 1 | 0 | | | | |
fspecialflag | 特殊业务标识 | SMALLINT | | 2 | 0 | | | | |
iprintcount | 打印次数 | SMALLINT | | 2 | 0 | 0 | | | |
ndiscountmny | 折扣额 | DECIMAL | | 20 | 8 | | | | |
nnetmny | 净额 | DECIMAL | | 20 | 8 | | | | |
pk_calbody | 库存组织PK | CHAR | | 20 | 0 | | | | |
pk_corp | 公司ID | CHAR | | 4 | 0 | | | | |
pk_cubasdoc | 供应商基本档案ID | CHAR | | 20 | 0 | | | | |
pk_cubasdocc | 客户基本档案ID | CHAR | | 20 | 0 | | | | |
pk_defdoc1 | 自定义项主键1 | CHAR | | 20 | 0 | | | | |
pk_defdoc10 | 自定义项主键10 | CHAR | | 20 | 0 | | | | |
pk_defdoc11 | 自定义项主键11 | CHAR | | 20 | 0 | | | | |
pk_defdoc12 | 自定义项主键12 | CHAR | | 20 | 0 | | | | |
pk_defdoc13 | 自定义项主键13 | CHAR | | 20 | 0 | | | | |
pk_defdoc14 | 自定义项主键14 | CHAR | | 20 | 0 | | | | |
pk_defdoc15 | 自定义项主键15 | CHAR | | 20 | 0 | | | | |
pk_defdoc16 | 自定义项主键16 | CHAR | | 20 | 0 | | | | |
pk_defdoc17 | 自定义项主键17 | CHAR | | 20 | 0 | | | | |
pk_defdoc18 | 自定义项主键18 | CHAR | | 20 | 0 | | | | |
pk_defdoc19 | 自定义项主键19 | CHAR | | 20 | 0 | | | | |
pk_defdoc2 | 自定义项主键2 | CHAR | | 20 | 0 | | | | |
pk_defdoc20 | 自定义项主键20 | CHAR | | 20 | 0 | | | | |
pk_defdoc3 | 自定义项主键3 | CHAR | | 20 | 0 | | | | |
pk_defdoc4 | 自定义项主键4 | CHAR | | 20 | 0 | | | | |
pk_defdoc5 | 自定义项主键5 | CHAR | | 20 | 0 | | | | |
pk_defdoc6 | 自定义项主键6 | CHAR | | 20 | 0 | | | | |
pk_defdoc7 | 自定义项主键7 | CHAR | | 20 | 0 | | | | |
pk_defdoc8 | 自定义项主键8 | CHAR | | 20 | 0 | | | | |
pk_defdoc9 | 自定义项主键9 | CHAR | | 20 | 0 | | | | |
pk_measware | 计量器具PK | CHAR | | 20 | 0 | | | | |
pk_purcorp | 采购公司 | CHAR | | 4 | 0 | | | | |
taccounttime | 库房签字时间 | CHAR | | 19 | 0 | | | | |
tlastmoditime | 最后修改时间 | CHAR | | 19 | 0 | | | | |
tmaketime | 制单时间 | CHAR | | 19 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
vbillcode | 单据号 | VARCHAR | | 30 | 0 | | | | |
vdiliveraddress | 发运地址 | VARCHAR | | 382 | 0 | | | | |
vheadnote2 | 表头备注2 | VARCHAR | | 254 | 0 | | | | |
vnote | 备注 | VARCHAR | | 181 | 0 | | | | |
vuserdef1 | 自定义项1 | VARCHAR | | 100 | 0 | | | | |
vuserdef10 | 自定义项10 | VARCHAR | | 100 | 0 | | | | |
vuserdef11 | 自定义项11 | VARCHAR | | 100 | 0 | | | | |
vuserdef12 | 自定义项12 | VARCHAR | | 100 | 0 | | | | |
vuserdef13 | 自定义项13 | VARCHAR | | 100 | 0 | | | | |
vuserdef14 | 自定义项14 | VARCHAR | | 100 | 0 | | | | |
vuserdef15 | 自定义项15 | VARCHAR | | 100 | 0 | | | | |
vuserdef16 | 自定义项16 | VARCHAR | | 100 | 0 | | | | |
vuserdef17 | 自定义项17 | VARCHAR | | 100 | 0 | | | | |
vuserdef18 | 自定义项18 | VARCHAR | | 100 | 0 | | | | |
vuserdef19 | 自定义项19 | VARCHAR | | 100 | 0 | | | | |
vuserdef2 | 自定义项2 | VARCHAR | | 100 | 0 | | | | |
vuserdef20 | 自定义项20 | VARCHAR | | 100 | 0 | | | | |
vuserdef3 | 自定义项3 | VARCHAR | | 100 | 0 | | | | |
vuserdef4 | 自定义项4 | VARCHAR | | 100 | 0 | | | | |
vuserdef5 | 自定义项5 | VARCHAR | | 100 | 0 | | | | |
vuserdef6 | 自定义项6 | VARCHAR | | 100 | 0 | | | | |
vuserdef7 | 自定义项7 | VARCHAR | | 100 | 0 | | | | |
vuserdef8 | 自定义项8 | VARCHAR | | 100 | 0 | | | | |
vuserdef9 | 自定义项9 | VARCHAR | | 100 | 0 | | | | |
外键列表
索引列表