productionreport.md 4.1 KB

Edit Raw Blame History



productionreport


Rows (estimated): 0

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

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

Updated: 


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
uWorkOrderGuid
varchar(100)
YES


2
sWorkOrderNo
varchar(100)
YES


3
sManualNo
varchar(100)
YES


4
iOrder
int
YES


5
sCustomerNo
varchar(100)
YES


6
sCustomerName
varchar(100)
YES


7
sSalesOrderNo
varchar(100)
YES


8
sProductNo
varchar(100)
YES


9
sProductName
varchar(100)
YES


10
sProductStyle
varchar(100)
YES


11
dProductQty
decimal(18,6)
YES


12
sProductUnit
varchar(100)
YES


13
dCostProductMoney
decimal(18,6)
YES


14
dCostNotLaborProductMoney
decimal(18,6)
YES


15
dProductTaxMoney
decimal(18,6)
YES


16
dProductMoney
decimal(18,6)
YES


17
dReceiptMoney
decimal(18,6)
YES


18
sMakePerson
varchar(100)
YES


19
tCreateDate
datetime
YES


20
tFactCountCost
datetime
YES


21
dFactCostProductMoney
decimal(18,6)
YES


22
dFactCostProductQty
decimal(18,6)
YES


23
dFactCostProductPrice
decimal(24,13)
NO

0.0000000000000


24
bSemigoods
bit(1)
NO

b'0'


25
dMaterialsCostProductMoney
decimal(18,6)
YES


26
dMaterialsStdProductMoney
decimal(18,6)
YES


27
dMaterialsDifMoney
decimal(18,6)
YES


28
dDirectMaterialsStdMoney
decimal(18,6)
YES


29
dDirectMaterialsCostMoney
decimal(18,6)
YES


30
dDirectMaterialsDifMoney
decimal(18,6)
YES


31
dAuxiliaryMaterialsStdMoney
decimal(18,6)
YES


32
dAuxiliaryMaterialsCostMoney
decimal(18,6)
YES


33
dAuxiliaryMaterialsDifMoney
decimal(18,6)
YES


34
dIndirectMaterialsMoney
decimal(18,6)
YES


35
dOutSideCostProductMoney
decimal(18,6)
YES


36
dOutSideStdCostProductMoney
decimal(18,6)
YES


37
dOutSideDifMoney
decimal(18,6)
YES


38
dShareMoney
decimal(18,6)
YES


39
uProcessGuid
varchar(100)
YES


40
sProcessName
varchar(100)
YES


41
sWorkCenterName
varchar(100)
YES


42
uWorkOrderProcessGuid
varchar(100)
YES


43
iType
int
YES


44
dSaleMoney
decimal(18,6)
YES


45
dSaleRate
decimal(18,6)
YES


46
dSaleProfit
decimal(18,6)
YES


47
dStandardSalary
decimal(18,6)
YES


48
dManufactureRate
decimal(18,6)
YES


49
dManufactureProfit
decimal(18,6)
YES


50
dNetRate
decimal(18,6)
YES


51
dNetProfit
decimal(18,6)
YES


52
dLaborMoney
decimal(18,6)
YES


53
dLaborDifMoney
decimal(18,6)
YES


54
bOutSide
bit(1)
NO

b'0'


55
bBillComplete
bit(1)
NO

b'0'


56
dInitMoney
decimal(18,6)
YES


57
dSumMoney
decimal(18,6)
YES


58
dEndMoney
decimal(18,6)
YES


59
bCarryOver
bit(1)
NO

b'0'


60
dProductCarryOverQty
decimal(18,6)
YES


Narrative

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