salsalesorderdetail.md 2.26 KB

Edit Raw Blame History



salsalesorderdetail


Engine: InnoDB

Collation: utf8mb3_general_ci


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO

0

自增列


2
sId
varchar(100)
NO


唯一ID


3
sBrandsId
varchar(100)
NO


加工商ID


4
sSubsidiaryId
varchar(100)
NO


子公司ID


5
iOrder
int
NO

1

检验反写数量


6
sMakePerson
varchar(100)
NO


制单人


7
sParentId
varchar(100)
NO


父级ID


8
sProductId
varchar(100)
NO


产品ID


9
sSrcSlaveId
varchar(100)
NO


源单从表Id


10
sSrcId
varchar(100)
NO


源单ID


11
sSlaveMemo
text
YES


备注


12
sSReserve1
varchar(255)
YES


预留字符1


13
sSReserve2
varchar(255)
YES


预留字符2


14
sSReserve3
varchar(255)
YES


预留字符3


15
sSReserve4
varchar(255)
YES


预留字符4


16
sSReserve5
varchar(255)
YES


预留字符5


17
sSReserve6
varchar(255)
YES


预留字符6


18
dSReserve1
decimal(18,6)
YES


预留数字1


19
dSReserve2
decimal(18,6)
YES


预留数字2


20
dSReserve3
decimal(18,6)
YES


预留数字3


21
iSReserve1
int
YES


预留整型1


22
iSReserve2
int
YES


预留整型2


23
iSReserve3
int
YES


预留整型3


24
tSReserve1
datetime
YES


预留日期1


25
tSReserve2
datetime
YES


预留日期2


26
dCheckQty
decimal(18,6)
YES

0.000000

余数库库存


27
dUseStockQty
decimal(18,6)
YES

0.000000

本次使用余数库存数


28
tCreateDate
datetime
YES

CURRENT_TIMESTAMP
DEFAULT_GENERATED


29
dReleaseQty
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.