sgdsemigoodsstorevirtual.md 1.55 KB

Edit Raw Blame History



sgdsemigoodsstorevirtual


Rows (estimated): 0

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb4_general_ci

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

Updated: 


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
dProcessQty
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
NO


制单日期


15
sPartsName
varchar(100)
NO


部件名称


16
dSinglePQty
decimal(18,6)
NO

0.000000

拼版数


17
sProcessId
varchar(100)
NO


工序ID


18
sVer
varchar(100)
NO


版本号


Narrative

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