accexpenseentrydepartmentslave.md 1.57 KB

Edit Raw Blame History Permalink



accexpenseentrydepartmentslave


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
sDepartId
varchar(50)
YES


9
dEnterMoney
decimal(18,6)
NO

0.000000

对应金额


10
dTransferMoney
decimal(18,6)
NO

0.000000

转入金额


11
dTotalMoney
decimal(18,6)
NO

0.000000

总金额


12
dApportionMoney
decimal(18,6)
NO

0.000000

分摊金额


13
bTransferOut
bit(1)
NO

b'0'

是否转出


14
bDepartInsert
bit(1)
NO

b'0'

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


15
sTransferDepartName
varchar(255)
YES


16
dTransferDepartRate
decimal(18,6)
NO

0.000000

转入汇总比例


17
dTransferSumMoney
decimal(18,6)
NO

0.000000

转入汇总金额


18
dEnterOldMoney
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.