ia_bill_b - 单据子表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | cbill_bid | 分录标识 | CHAR | Y | 20 | 0 | | | | |
badjusteditemflag | 是否调整了分录标志 | CHAR | | 1 | 0 | | | | |
bauditbatchflag | 是否批次核算 | CHAR | | 1 | 0 | N | | | |
blargessflag | 是否赠品 | CHAR | | 1 | 0 | | | | |
bretractflag | 是否采购费用结算 | CHAR | | 1 | 0 | N | | | |
brtvouchflag | 是否已生成实时凭证 | CHAR | | 1 | 0 | N | | | |
btransferincometax | 是否进项税转出 | CHAR | | 1 | 0 | N | | | |
cadjustbillid | 调整单据标识 | CHAR | | 20 | 0 | | | | |
cadjustbillitemid | 调整单据分录标识 | CHAR | | 20 | 0 | | | | |
castunitid | 辅计量单位 | CHAR | | 20 | 0 | | | | |
cauditorid | 审核人标识 | CHAR | | 20 | 0 | | | | |
cbillid | 单据标识 | CHAR | | 20 | 0 | | | | |
cbilltypecode | 单据类型 | VARCHAR | | 4 | 0 | | | | |
ccalcbillid | 计算关系单据主表id | CHAR | | 20 | 0 | | | | |
ccalcbillitemid | 计算关系单据子表id | CHAR | | 20 | 0 | | | | |
ccrspbillitemid | 对应业务单据分录标识 | CHAR | | 20 | 0 | | | | |
ccsaleadviceitemid | 销售系统出库单分录标识 | CHAR | | 20 | 0 | | | | |
cfacardid | 固定资产卡片ID | CHAR | | 20 | 0 | | | | |
cfadeviceid | 固定资产附属设备ID | CHAR | | 20 | 0 | | | | |
cfirstbillid | 源头单据标识 | CHAR | | 20 | 0 | | | | |
cfirstbillitemid | 源头单据分录标识 | CHAR | | 20 | 0 | | | | |
cfirstbilltypecode | 源头单据类型 | VARCHAR | | 4 | 0 | | | | |
cicbillcode | IC单据号 | VARCHAR | | 30 | 0 | | | | |
cicbillid | IC主表ID | CHAR | | 20 | 0 | | | | |
cicbilltype | IC单据类型 | VARCHAR | | 4 | 0 | | | | |
cicitemid | IC子表ID | CHAR | | 20 | 0 | | | | |
cinbillitemid | 对应入库单分录标识 | CHAR | | 20 | 0 | | | | |
cinvbasid | 存货基本标识 | CHAR | | 20 | 0 | | | | |
cinventoryid | 存货标识 | CHAR | | 20 | 0 | | | | |
cprojectid | 项目标识 | CHAR | | 20 | 0 | | | | |
cprojectphase | 项目阶段 | CHAR | | 20 | 0 | | | | |
crdcenterid | 库存组织标识 | CHAR | | 20 | 0 | | | | |
csaleadviceid | 销售系统出库单标识 | CHAR | | 20 | 0 | | | | |
csaleaudititemid | 销售结算明细标识 | CHAR | | 20 | 0 | | | | |
csourcebillid | 来源单据标识 | CHAR | | 20 | 0 | | | | |
csourcebillitemid | 来源单据分录标识 | CHAR | | 20 | 0 | | | | |
csourcebilltypecode | 来源单据类型 | VARCHAR | | 4 | 0 | | | | |
csumrtvouchid | 汇总凭证ID | CHAR | | 20 | 0 | | | | |
cvendorbasid | 供应商基本档案标识 | CHAR | | 20 | 0 | | | | |
cvendorid | 供应商 | CHAR | | 20 | 0 | | | | |
cvoucherid | 会计凭证ID | CHAR | | 20 | 0 | | | | |
cwp | 工序 | VARCHAR | | 100 | 0 | | | | |
dauditdate | 审核日期 | CHAR | | 10 | 0 | | | | |
dbizdate | 业务日期 | CHAR | | 10 | 0 | | | | |
ddrawrate | 提取比例 | DECIMAL | | 9 | 6 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
fcalcbizflag | 计算关系的业务分类 | SMALLINT | | 2 | 0 | 0 | | | |
fdatagetmodelflag | 数据获得方式 | SMALLINT | | 2 | 0 | | | | |
folddatagetmodelflag | 成本计算前数据获得方式 | SMALLINT | | 2 | 0 | | | | |
foutadjustableflag | 出库是否可调整标志 | CHAR | | 1 | 0 | | | | |
fpricemodeflag | 计价方式编码 | SMALLINT | | 2 | 0 | | | | |
iauditsequence | 审核序号 | INT | | 4 | 0 | | | | |
irownumber | 行号 | SMALLINT | | 2 | 0 | | | | |
nadjustnum | 调整数量 | DECIMAL | | 20 | 8 | | | | |
nassistnum | 辅计量数量 | DECIMAL | | 20 | 8 | | | | |
nchangerate | 换算率 | DECIMAL | | 20 | 8 | | | | |
ndrawsummny | 累计提取金额 | DECIMAL | | 20 | 8 | | | | |
nexpaybacktax | 退税率 | DECIMAL | | 15 | 8 | | | | |
nfactor1 | 成本要素1金额 | DECIMAL | | 20 | 8 | | | | |
nfactor2 | 成本要素2金额 | DECIMAL | | 20 | 8 | | | | |
nfactor3 | 成本要素3金额 | DECIMAL | | 20 | 8 | | | | |
nfactor4 | 成本要素4金额 | DECIMAL | | 20 | 8 | | | | |
nfactor5 | 成本要素5金额 | DECIMAL | | 20 | 8 | | | | |
nfactor6 | 成本要素6金额 | DECIMAL | | 20 | 8 | | | | |
nfactor7 | 成本要素7金额 | DECIMAL | | 20 | 8 | | | | |
nfactor8 | 成本要素8金额 | DECIMAL | | 20 | 8 | | | | |
nincometax | 进项税率 | DECIMAL | | 20 | 8 | | | | |
ninvarymny | 收入差异 | DECIMAL | | 20 | 8 | | | | |
nmoney | 金额 | DECIMAL | | 20 | 8 | | | | |
nnumber | 数量 | DECIMAL | | 20 | 8 | | | | |
noriginalprice | 调整前单价 | DECIMAL | | 20 | 8 | | | | |
noutvarymny | 发出差异 | DECIMAL | | 20 | 8 | | | | |
nplanedmny | 计划金额 | DECIMAL | | 20 | 8 | | | | |
nplanedprice | 计划单价 | DECIMAL | | 20 | 8 | | | | |
nprice | 单价 | DECIMAL | | 20 | 8 | | | | |
nreasonalwastmny | 合理损耗金额 | DECIMAL | | 20 | 8 | | | | |
nreasonalwastnum | 合理损耗数量 | DECIMAL | | 20 | 8 | | | | |
nreasonalwastprice | 合理损耗单价 | DECIMAL | | 20 | 8 | | | | |
nsettledretractnum | 累计冲回数量 | DECIMAL | | 20 | 8 | | | | |
nsettledsendnum | 累计发出数量 | DECIMAL | | 20 | 8 | | | | |
nsimulatemny | 模拟成本 | 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 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
vbatch | 批次号 | VARCHAR | | 30 | 0 | | | | |
vbillcode | 单据号 | VARCHAR | | 30 | 0 | | | | |
vbomcode | 成本对象 | CHAR | | 20 | 0 | | | | |
vcalcbilltype | 计算关系的单据类型 | VARCHAR | | 4 | 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 | | | | |
vfirstbillcode | 源头单据号 | VARCHAR | | 30 | 0 | | | | |
vfirstrowno | 源头单据行号 | VARCHAR | | 20 | 0 | | | | |
vfree1 | 自由项1 | VARCHAR | | 100 | 0 | | | | |
vfree2 | 自由项2 | VARCHAR | | 100 | 0 | | | | |
vfree3 | 自由项3 | VARCHAR | | 100 | 0 | | | | |
vfree4 | 自由项4 | VARCHAR | | 100 | 0 | | | | |
vfree5 | 自由项5 | VARCHAR | | 100 | 0 | | | | |
vproducebatch | 生产批号 | VARCHAR | | 30 | 0 | | | | |
vsourcebillcode | 来源单据号 | VARCHAR | | 30 | 0 | | | | |
vsourcerowno | 来源单据行号 | VARCHAR | | 20 | 0 | | | | |
外键列表
编码 | 显示名称 | 字段编码 | 连接字段编码 | 连接表编码 | Reference_1 | 单据子表.单据标识$单据主表.单据标识 | cbillid | cbillid | ia_bill |
索引列表