CPM_ExpenseApportioneGroupDetail Table

Summary

费用分摊明细账

Columns

Column Name	Description	Datatype	Length	Allow Nulls
idSettlePartnerClass (T+16.0)	结算客户分类id	int	4	True
VoucherHeadpriuserdefdecm6 (T+16.0)	单据头字符自定义选项6	decimal	13	True
OrigSaleExpAlocAmount (T+16.0)	原币销售分摊金额	decimal	13	True
SourceVoucherId (T+16.0)	来源单据id	int	4	True
VoucherHeadpubuserdefnvc1 (T+16.0)	单据头公用字符自定义选项1	nvarchar	1000	True
VoucherHeadpubuserdefnvc2 (T+16.0)	单据头公用数值自定义选项2	nvarchar	1000	True
VoucherHeadpriuserdefdecm3 (T+16.0)	单据头数值自定义选项6	decimal	13	True
idSourceVoucherType (T+16.0)	来源单据类型id	int	4	True
idDepartment (T+16.0)	部门id	int	4	True
VoucherHeadpriuserdefdecm4 (T+16.0)	单据头数值自定义选项6	decimal	13	True
idDistrict (T+16.0)	地区id	int	4	True
VoucherDetailpubuserdefdecm4 (T+16.0)	单据明细数值自定义选项4	decimal	13	True
VoucherDetailpubuserdefdecm3 (T+16.0)	单据明细数值自定义选项3	decimal	13	True
VoucherHeadpubuserdefnvc5 (T+16.0)	单据头公用数值自定义选项5	nvarchar	1000	True
VoucherHeadpubuserdefdecm4 (T+16.0)	单据头公用数值自定义选项4	decimal	13	True
Partnerpriuserdefdecm2 (T+16.0)	往来单位数值自定义项2	decimal	13	True
Partnerpriuserdefnvc2 (T+16.0)	往来单位字符自定义项2	nvarchar	1000	True
idProjectClass (T+16.0)	项目类别id	int	4	True
SettlePartnerpriuserdefnvc4 (T+16.0)	结算客户字符自定义项4	nvarchar	1000	True
expenseType (T+16.0)	费用类型	int	4	True
ts (T+16.0)	时间戳	timestamp	8	True
SourceVoucherDetailId (T+16.0)	来源单据明细id	int	4	True
Partnerpriuserdefnvc1 (T+16.0)	往来单位字符自定义项1	nvarchar	1000	True
VoucherHeadpubuserdefdecm2 (T+16.0)	单据头公用数值自定义选项2	decimal	13	True
VoucherHeadpubuserdefdecm1 (T+16.0)	单据头公用数值自定义选项1	decimal	13	True
SettlePartnerpriuserdefnvc1 (T+16.0)	结算客户字符自定义项1	nvarchar	1000	True
VoucherDetailpriuserdefnvc2 (T+16.0)	单据明细字符自定义选项2	nvarchar	1000	True
VoucherHeadpriuserdefnvc5 (T+16.0)	单据头字符自定义选项5	nvarchar	1000	True
VoucherHeadpubuserdefnvc3 (T+16.0)	单据头公用数值自定义选项3	nvarchar	1000	True
VoucherDetailpriuserdefdecm3 (T+16.0)	单据明细公共数值自定义选项3	decimal	13	True
SourceVoucherDate (T+16.0)	来源单据日期	datetime	8	True
VoucherHeadpubuserdefnvc4 (T+16.0)	单据头公用数值自定义选项4	nvarchar	1000	True
idSaleExpenseAllocationDTO (T+16.0)	费用分摊单关联id	int	4	False
VoucherDetailpubuserdefnvc1 (T+16.0)	单据明细公用字符自定义选项1	nvarchar	1000	True
VoucherDetailpriuserdefdecm1 (T+16.0)	单据明细公共数值自定义选项1	decimal	13	True
OrigExpAlocTaxAmount (T+16.0)	原币费用分摊含税金额	decimal	13	True
idPerson (T+16.0)	业务员id	int	4	True
VoucherDetailpriuserdefnvc1 (T+16.0)	单据明细字符自定义选项1	nvarchar	1000	True
VoucherDetailpubuserdefnvc3 (T+16.0)	单据明细公用字符自定义选项3	nvarchar	1000	True
Partnerpriuserdefnvc3 (T+16.0)	往来单位字符自定义项3	nvarchar	1000	True
SettlePartnerpriuserdefnvc5 (T+16.0)	结算客户字符自定义项5	nvarchar	1000	True
VoucherHeadpriuserdefdecm5 (T+16.0)	单据头数值自定义选项6	decimal	13	True
Partnerpriuserdefdecm1 (T+16.0)	往来单位数值自定义项1	decimal	13	True
VoucherHeadpriuserdefnvc4 (T+16.0)	单据头字符自定义选项4	nvarchar	1000	True
createdtime (T+16.0)	创建时间	datetime	8	True
VoucherDetailpriuserdefdecm2 (T+16.0)	单据明细公共数值自定义选项2	decimal	13	True
OrigTax (T+16.0)	原币税率	decimal	13	True
VoucherDetailpubuserdefnvc4 (T+16.0)	单据明细公用字符自定义选项4	nvarchar	1000	True
Tax (T+16.0)	税率	decimal	13	True
VoucherDetailpubuserdefnvc2 (T+16.0)	单据明细公用字符自定义选项2	nvarchar	1000	True
SaleExpAlocAmount (T+16.0)	销售费用分摊金额	decimal	13	True
VoucherDetailpriuserdefdecm4 (T+16.0)	单据明细公共数值自定义选项4	decimal	13	True
Partnerpriuserdefnvc5 (T+16.0)	往来单位字符自定义项5	nvarchar	1000	True
VoucherHeadpubuserdefdecm3 (T+16.0)	单据头公用数值自定义选项3	decimal	13	True
idSaleDetailCPMCopartner (T+16.0)	销货单明细合伙人id	int	4	True
VoucherHeadpriuserdefdecm1 (T+16.0)	单据头数值自定义选项6	decimal	13	True
VoucherDetailpubuserdefdecm1 (T+16.0)	单据明细数值自定义选项1	decimal	13	True
ExpAlocTaxAmount (T+16.0)	含税费用分摊金额	decimal	13	True
idPartner (T+16.0)	往来单位id	int	4	True
SourceVoucherCode (T+16.0)	来源单据编码	nvarchar	100	True
VoucherHeadpriuserdefdecm2 (T+16.0)	单据头数值自定义选项6	decimal	13	True
idPartnerClass (T+16.0)	往来单位类别id	int	4	True
SettlePartnerpriuserdefnvc2 (T+16.0)	结算客户字符自定义项2	nvarchar	1000	True
VoucherHeadpriuserdefnvc1 (T+16.0)	单据头字符自定义选项1	nvarchar	1000	True
idCorpBrand (T+16.0)	品牌id	int	4	True
SettlePartnerpriuserdefnvc3 (T+16.0)	结算客户字符自定义项3	nvarchar	1000	True
VoucherDetailpriuserdefnvc4 (T+16.0)	单据明细字符自定义选项4	nvarchar	1000	True
VoucherHeadpriuserdefnvc6 (T+16.0)	单据头字符自定义选项6	nvarchar	1000	True
SettlePartnerpriuserdefdecm2 (T+16.0)	结算客户数值自定义项2	decimal	13	True
VoucherHeadpriuserdefnvc3 (T+16.0)	单据头字符自定义选项3	nvarchar	1000	True
id (T+16.0)	主键	int	4	False
VoucherHeadpubuserdefdecm5 (T+16.0)	单据头公用数值自定义选项5	decimal	13	True
idExpenseItem (T+16.0)	费用项目id	int	4	True
Partnerpriuserdefdecm4 (T+16.0)	往来单位数值自定义项4	decimal	13	True
Partnerpriuserdefdecm3 (T+16.0)	往来单位数值自定义项3	decimal	13	True
VoucherHeadpriuserdefnvc2 (T+16.0)	单据头字符自定义选项2	nvarchar	1000	True
VoucherDetailpubuserdefdecm2 (T+16.0)	单据明细数值自定义选项2	decimal	13	True
Partnerpriuserdefnvc4 (T+16.0)	往来单位字符自定义项4	nvarchar	1000	True
SettlePartnerpriuserdefdecm4 (T+16.0)	结算客户数值自定义项4	decimal	13	True
VoucherDetailpriuserdefnvc3 (T+16.0)	单据明细字符自定义选项3	nvarchar	1000	True
SettlePartnerpriuserdefdecm3 (T+16.0)	结算客户数值自定义项3	decimal	13	True
idInventoryClass (T+16.0)	存货类别id	int	4	True
SettlePartnerpriuserdefdecm1 (T+16.0)	结算客户数值自定义项1	decimal	13	True
idInventory (T+16.0)	存货id	int	4	True
VoucherHeadpubuserdefdecm6 (T+16.0)	单据头公用数值自定义选项6	decimal	13	True
Partnerpriuserdefdecm5 (T+16.0)	往来单位数值自定义项5	decimal	13	True
SettlePartnerpriuserdefdecm5 (T+16.0)	结算客户数值自定义项5	decimal	13	True
idProject (T+16.0)	项目id	int	4	True
VoucherHeadpubuserdefnvc6 (T+16.0)	单据头公用数值自定义选项6	nvarchar	1000	True
idSettlePartner (T+16.0)	结算客户id	int	4	True

Send feedback

CPM_ExpenseApportioneGroupDetail Table (CPM 合伙人管理) [T+16.0]

Summary

Columns