accexpenseentryworkcenterslave.md 1.88 KB

Edit Raw Blame History Permalink



accexpenseentryworkcenterslave


Engine: InnoDB

Collation: utf8mb3_general_ci


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO

0

自增列


2
sId
varchar(100)
YES


3
sBrandsId
varchar(100)
YES


4
sSubsidiaryId
varchar(100)
YES


5
sMakePerson
varchar(255)
YES


6
iOrder
int
NO

0

排序号


7
sParentId
varchar(100)
YES


8
sWorkCenterId
varchar(50)
YES


9
dEnterMoney
decimal(18,2)
NO

0.00

对应部门分摊金额


10
dTransferMoney
decimal(18,2)
NO

0.00

转入金额


11
dTotalMoney
decimal(18,2)
NO

0.00

总金额


12
dApportionMoney
decimal(18,6)
NO

0.000000

未对应部门分摊金额


13
bTransferOut
bit(1)
NO

b'0'

是否转出


14
sDepartId
varchar(50)
YES


15
bWorkCenterInsert
bit(1)
NO

b'0'

是否工作中心转移插入数据


16
sTransferWorkCenterId
varchar(50)
YES


17
dTransferWorkCenterRate
decimal(18,6)
NO

0.000000

转入汇总比例


18
dTransferSumMoney
decimal(18,6)
NO

0.000000

转入汇总金额


19
bDepartInsert
bit(1)
NO

b'0'

是否部门成本转移插入数据


20
sTransferWorkCenterMemo
text
YES


21
bClientInsert
bit(1)
NO

b'0'

是否人工录入


22
dClientInsertMoney
decimal(18,6)
NO

0.000000

人工录入金额


Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.