ia_bill - 单据主表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | cbillid | 单据标识 | CHAR | Y | 20 | 0 | | | | |
bauditedflag | 是否审核 | CHAR | | 1 | 0 | | | | |
bdisableflag | 是否作废 | CHAR | | 1 | 0 | | | | |
bestimateflag | 是否暂估 | CHAR | | 1 | 0 | | | | |
boutestimate | 是否发出商品标识 | CHAR | | 1 | 0 | | | | |
bwithdrawalflag | 是否假退料 | CHAR | | 1 | 0 | | | | |
caccountmonth | 会计月份 | CHAR | | 2 | 0 | | | | |
caccountyear | 会计年度 | CHAR | | 4 | 0 | | | | |
cagentid | 经手人标识 | CHAR | | 20 | 0 | | | | |
cbilltypecode | 单据类型 | VARCHAR | | 4 | 0 | | | | |
cbiztypeid | 业务类型标识 | CHAR | | 20 | 0 | | | | |
cbusinessbillid | 对应业务单据标识 | CHAR | | 20 | 0 | | | | |
ccustomvendorbasid | 客商基本档案标识 | CHAR | | 20 | 0 | | | | |
ccustomvendorid | 客商标识 | CHAR | | 20 | 0 | | | | |
cdeptid | 部门标识 | CHAR | | 20 | 0 | | | | |
cdispatchid | 收发标识 | CHAR | | 20 | 0 | | | | |
cemployeeid | 人员标识 | CHAR | | 20 | 0 | | | | |
clastoperatorid | 最后修改人 | CHAR | | 20 | 0 | | | | |
coperatorid | 制单人标识 | CHAR | | 20 | 0 | | | | |
cothercalbodyid | 对方库存组织ID | CHAR | | 20 | 0 | | | | |
cothercorpid | 对方公司ID | CHAR | | 4 | 0 | | | | |
coutcalbodyid | 调出库存组织ID | CHAR | | 20 | 0 | | | | |
coutcorpid | 调出公司ID | CHAR | | 4 | 0 | | | | |
crdcenterid | 库存组织标识 | CHAR | | 20 | 0 | | | | |
csourcemodulename | 来源模块 | VARCHAR | | 3 | 0 | | | | |
cstockrdcenterid | 仓储库存组织 | CHAR | | 20 | 0 | | | | |
cwarehouseid | 仓库标识 | CHAR | | 20 | 0 | | | | |
cwarehousemanagerid | 库管员标识 | CHAR | | 20 | 0 | | | | |
dbilldate | 单据日期 | CHAR | | 10 | 0 | | | | |
dcheckdate | 检验日期 | CHAR | | 10 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
fallocflag | 调拨类型 | SMALLINT | | 2 | 0 | 2 | | | |
fdispatchflag | 收发标志 | SMALLINT | | 2 | 0 | | | | |
idebtflag | 借方贷方标识 | SMALLINT | | 2 | 0 | | | | |
iprintcount | 打印次数 | SMALLINT | | 2 | 0 | 0 | | | |
ncost | 组装成本 | DECIMAL | | 20 | 8 | | | | |
pk_corp | 公司主键 | CHAR | | 4 | 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 | | | | |
tlastmaketime | 最后修改时间 | CHAR | | 19 | 0 | | | | |
tmaketime | 制单时间 | CHAR | | 19 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
vadjpricefilecode | 调价文件号 | VARCHAR | | 50 | 0 | | | | |
vbillcode | 单据号 | VARCHAR | | 30 | 0 | | | | |
vcheckbillcode | 检验单号 | VARCHAR | | 30 | 0 | | | | |
vdef1 | 自定义项1 | VARCHAR | | 100 | 0 | | | | |
vdef10 | 自定义项10 | VARCHAR | | 100 | 0 | | | | |
vdef11 | 自定义项11 | VARCHAR | | 100 | 0 | | | | |
vdef12 | 自定义项12 | VARCHAR | | 100 | 0 | | | | |
vdef13 | 自定义项13 | VARCHAR | | 100 | 0 | | | | |
vdef14 | 自定义项14 | VARCHAR | | 100 | 0 | | | | |
vdef15 | 自定义项15 | VARCHAR | | 100 | 0 | | | | |
vdef16 | 自定义项16 | VARCHAR | | 100 | 0 | | | | |
vdef17 | 自定义项17 | VARCHAR | | 100 | 0 | | | | |
vdef18 | 自定义项18 | VARCHAR | | 100 | 0 | | | | |
vdef19 | 自定义项19 | VARCHAR | | 100 | 0 | | | | |
vdef2 | 自定义项2 | VARCHAR | | 100 | 0 | | | | |
vdef20 | 自定义项20 | VARCHAR | | 100 | 0 | | | | |
vdef3 | 自定义项3 | VARCHAR | | 100 | 0 | | | | |
vdef4 | 自定义项4 | VARCHAR | | 100 | 0 | | | | |
vdef5 | 自定义项5 | VARCHAR | | 100 | 0 | | | | |
vdef6 | 自定义项6 | VARCHAR | | 100 | 0 | | | | |
vdef7 | 自定义项7 | VARCHAR | | 100 | 0 | | | | |
vdef8 | 自定义项8 | VARCHAR | | 100 | 0 | | | | |
vdef9 | 自定义项9 | VARCHAR | | 100 | 0 | | | | |
vnote | 备注 | VARCHAR | | 181 | 0 | | | | |
外键列表
索引列表