accexpenseentrybusinessmaster.md 2.41 KB

Edit Raw Blame History



accexpenseentrybusinessmaster


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
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
制单日期


6
sMakePerson
varchar(255)
YES


7
iOrder
int
NO

0

排序号


8
sFormId
varchar(100)
YES


9
sBillNo
varchar(255)
YES


10
sManualNo
varchar(255)
YES


11
sMemo
text
YES


12
bCheck
bit(1)
NO

b'0'

是否审核


13
tCheckDate
datetime
YES


审核日期


14
sCheckPerson
varchar(255)
YES


15
bPrint
bit(1)
NO

b'0'

是否打印


16
bCopyLimit
bit(1)
NO

b'0'

禁止拷贝


17
sStatus
varchar(255)
YES


18
bInvalid
bit(1)
NO

b'0'

是否作废


19
sMReserve1
varchar(255)
YES


20
sMReserve2
varchar(255)
YES


21
sMReserve3
varchar(255)
YES


22
sMReserve4
varchar(255)
YES


23
sMReserve5
varchar(255)
YES


24
sMReserve6
varchar(255)
YES


25
dMReserve1
decimal(18,6)
YES


预留数字1


26
dMReserve2
decimal(18,6)
YES


预留数字2


27
dExpenseeMoney
decimal(18,6)
YES


费用总额


28
iMReserve1
int
YES


预留整型1


29
iMReserve2
int
YES


预留整型2


30
iMReserve3
int
YES


预留整型3


31
tMReserve1
datetime
YES


预留日期1


32
tMReserve2
datetime
YES


预留日期2


33
sCostPeriod
varchar(255)
YES


34
sExpenseeId
varchar(50)
YES


35
sSortName2
varchar(255)
YES


Narrative

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