期初同步临时数据
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
inventorypriuserdefdecm4 (T+12.2) | 存货自定义项 | decimal | 13 | True | |
origbalance (T+12.2) | 余额 | decimal | 13 | True | |
idAssetProp (T+12.2) | 资产属性 | int | 4 | True | |
idinvlocation (T+12.2) | 货位id | int | 4 | True | |
iddistrict (T+12.2) | 地区id | int | 4 | True | |
ts (T+12.2) | 时间戳 | timestamp | 8 | False | |
arrivalDate (T+12.2) | 到期日 | datetime | 8 | True | |
inventorypriuserdefdecm1 (T+12.2) | 存货自定义项 | decimal | 13 | True | |
idinventory (T+12.2) | 存货id | int | 4 | True | |
code (T+12.2) | 编号 | nvarchar | 30 | True | |
basequantity (T+12.2) | 主数量 | decimal | 13 | True | |
inventorypriuserdefdecm3 (T+12.2) | 存货自定义项 | decimal | 13 | True | |
baseprice (T+12.2) | 主价格 | decimal | 13 | True | |
inventorypriuserdefnvc1 (T+12.2) | 存货自定义项 | nvarchar | 500 | True | |
inventorypriuserdefdecm2 (T+12.2) | 存货自定义项 | decimal | 13 | True | |
inventorypriuserdefnvc3 (T+12.2) | 存货自定义项 | nvarchar | 500 | True | |
bizdataid (T+12.2) | 业务单据id | int | 4 | True | |
idinventoryclass (T+12.2) | 存货分类id | int | 4 | True | |
voucherDate (T+12.2) | 单据日期 | datetime | 8 | True | |
inventorypriuserdefnvc4 (T+12.2) | 存货自定义项 | nvarchar | 500 | True | |
idproject (T+12.2) | 项目id | int | 4 | True | |
inventorypriuserdefnvc0 (T+12.2) | 存货自定义项 | nvarchar | 500 | True | |
idcurrency (T+12.2) | 币种id | int | 4 | True | |
idProjectClass (T+12.2) | 项目分类id | int | 4 | True | |
balance (T+12.2) | 余额 | decimal | 13 | True | |
idbusitype (T+12.3) | 业务类型id | int | 4 | True | |
amPropNote (T+12.2) | 资产属性 | nvarchar | 200 | True | |
idbankaccount (T+12.2) | 账号id | int | 4 | True | |
idpartnerclass (T+12.2) | 往来单位分类 | int | 4 | True | |
idwarehouse (T+12.2) | 仓库id | int | 4 | True | |
inventorypriuserdefnvc2 (T+12.2) | 存货自定义项 | nvarchar | 500 | True | |
periodbeginsynctype (T+12.2) | 期初同步类型 | int | 4 | True | |
idperson (T+12.2) | 人员id | int | 4 | True | |
idpartner (T+12.2) | 往来单位 | int | 4 | True | |
iddepartment (T+12.2) | 部门id | int | 4 | True | |
idrdstyle (T+12.2) | 出入库类别id | int | 4 | True | |
name (T+12.2) | 名称 | nvarchar | 200 | True | |
id (T+12.2) | 主键 | int | 4 | False | |
idAssetClass (T+12.2) | 资产分类 | int | 4 | True | |
inventorypriuserdefdecm0 (T+12.2) | 存货自定义项 | decimal | 13 | True |
Copyright 2019 Chanjet Inc.