ia_goodsledger - 发出商品委托代销明细账
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | cgoodsledgerid | 标识 | CHAR | Y | 20 | 0 | | | | |
caccountmonth | 会计月份 | CHAR | | 2 | 0 | | | | |
caccountyear | 会计年度 | CHAR | | 4 | 0 | | | | |
cauditorid | 审核人标识 | CHAR | | 20 | 0 | | | | |
cbill_bid | 单据分录标识 | CHAR | | 20 | 0 | | | | |
cbillid | 单据标识 | CHAR | | 20 | 0 | | | | |
cbilltypecode | 单据类型 | VARCHAR | | 4 | 0 | | | | |
cbiztypeid | 业务类型标识 | CHAR | | 20 | 0 | | | | |
ccsaleadviceitemid | 销售系统出库单分录标识 | CHAR | | 20 | 0 | | | | |
ccurrencytypeid | 原币币种标识 | CHAR | | 20 | 0 | | | | |
ccustomvendorid | 客商标识 | CHAR | | 20 | 0 | | | | |
cdeptid | 部门标识 | CHAR | | 20 | 0 | | | | |
cdispatchid | 收发标识 | CHAR | | 20 | 0 | | | | |
cemployeeid | 人员标识 | CHAR | | 20 | 0 | | | | |
cinventoryid | 存货标识 | CHAR | | 20 | 0 | | | | |
crdcenterid | 库存组织标识 | CHAR | | 20 | 0 | | | | |
csaleadviceid | 销售系统出库单标识 | CHAR | | 20 | 0 | | | | |
csourcebillid | 来源单据标识 | CHAR | | 20 | 0 | | | | |
csourcebillitemid | 来源单据分录标识 | CHAR | | 20 | 0 | | | | |
csourcebilltypecode | 来源单据类型 | VARCHAR | | 4 | 0 | | | | |
csourcemodulename | 来源模块 | CHAR | | 3 | 0 | | | | |
cwarehouseid | 仓库标识 | CHAR | | 20 | 0 | | | | |
dauditdate | 审核日期 | CHAR | | 10 | 0 | | | | |
dbilldate | 单据制单日期 | CHAR | | 10 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
fdatagetmodelflag | 数据获得方式 | SMALLINT | | 2 | 0 | | | | |
fdispatchflag | 收发标志 | SMALLINT | | 2 | 0 | | | | |
fpricemodeflag | 计价方式编码 | SMALLINT | | 2 | 0 | | | | |
nassistcurmny | 辅币金额 | DECIMAL | | 20 | 8 | | | | |
nassistcurprice | 辅币单价 | DECIMAL | | 20 | 8 | | | | |
ncrebitsaleprice | 贷方售价 | DECIMAL | | 20 | 8 | | | | |
ncreditmny | 贷方金额 | DECIMAL | | 20 | 8 | | | | |
ncreditnum | 贷方数量 | DECIMAL | | 20 | 8 | | | | |
ncreditprice | 贷方单价 | DECIMAL | | 20 | 8 | | | | |
ndebitmny | 借方金额 | DECIMAL | | 20 | 8 | | | | |
ndebitnum | 借方数量 | DECIMAL | | 20 | 8 | | | | |
ndebitprice | 借方单价 | DECIMAL | | 20 | 8 | | | | |
ndebitsaleprice | 借方售价 | DECIMAL | | 20 | 8 | | | | |
nexchangeotoarate | 折辅汇率 | DECIMAL | | 15 | 8 | | | | |
nexchangeotobrate | 折本汇率 | DECIMAL | | 15 | 8 | | | | |
ninvarymny | 收入差异 | DECIMAL | | 20 | 8 | | | | |
noriginalcurmny | 原币金额 | DECIMAL | | 20 | 8 | | | | |
noriginalcurprice | 原币单价 | DECIMAL | | 20 | 8 | | | | |
noutvarymny | 发出差异 | DECIMAL | | 20 | 8 | | | | |
pk_corp | 公司主键 | CHAR | | 4 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
vbatch | 批次号 | VARCHAR | | 30 | 0 | | | | |
vbillcode | 单据号 | VARCHAR | | 30 | 0 | | | | |
vnote | 备注 | VARCHAR | | 181 | 0 | | | | |
vsourcebillcode | 来源单据号 | VARCHAR | | 30 | 0 | | | | |
外键列表
索引列表
编码 | 显示名称 | i_ia_goods | i_ia_goods |