salsalesproductionordervirtual.md 1.32 KB

Edit Raw Blame History



salsalesproductionordervirtual


Rows (estimated): 35

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb4_general_ci

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

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


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

0

排序号


6
sMakePerson
varchar(255)
NO


制单人


7
sProductId
varchar(100)
NO


产品ID


8
dProductQty
decimal(18,6)
NO


库存数量


9
sFormId
varchar(100)
NO


窗体ID


10
sBillId
varchar(100)
NO


单据ID


11
sBillSlaveId
varchar(100)
NO


单据从表ID


12
sBillNo
varchar(255)
NO


单据号


13
sMemo
text
YES


备注


14
tCreateDate
datetime
YES


制单日期


Narrative

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