accmaterialsinitmaster.md 2.71 KB

Edit Raw Blame History



accmaterialsinitmaster


Rows (estimated): 4

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:46:56

Updated: 2026-04-27 18:46:56


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
sFormId
varchar(100)
YES


8
iOrder
int
NO

0

排序号


9
sBillNo
varchar(255)
YES


10
sMemo
text
YES


11
bCheck
bit(1)
NO

b'0'

是否审核


12
tCheckDate
datetime
YES


审核日期


13
sCheckPerson
varchar(255)
YES


14
bPrint
bit(1)
NO

b'0'

是否打印


15
bCopyLimit
bit(1)
NO

b'0'

禁止拷贝


16
sStatus
varchar(255)
YES


17
sWareHouseId
varchar(100)
YES


18
sLocationId
varchar(100)
YES


19
sWareHouseLocationId
varchar(100)
YES


20
sEmployeeId
varchar(100)
YES


21
bInvalid
bit(1)
NO

b'0'

是否作废


22
sMReserve1
varchar(255)
YES


23
sMReserve2
varchar(255)
YES


24
sMReserve3
varchar(255)
YES


25
sMReserve4
varchar(255)
YES


26
sMReserve5
varchar(255)
YES


27
sMReserve6
varchar(255)
YES


28
dMReserve1
decimal(18,6)
YES


预留数字1


29
dMReserve2
decimal(18,6)
YES


预留数字2


30
dMReserve3
decimal(18,6)
YES


预留数字3


31
iMReserve1
int
YES


预留整型1


32
iMReserve2
int
YES


预留整型2


33
iMReserve3
int
YES


预留整型3


34
tMReserve1
datetime
YES


预留日期1


35
tMReserve2
datetime
YES


预留日期2


36
sCostPeriod
varchar(100)
YES


37
sConfirmMonth
varchar(100)
YES


38
bConfirm
bit(1)
NO

b'0'

是否确认


Narrative

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