accjobslavesum.md 2.76 KB

Edit Raw Blame History



accjobslavesum


Rows (estimated): 0

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

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

Updated: 


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
iOrder
int
NO

0

排序号


6
sMakePerson
varchar(255)
YES


7
sParentId
varchar(100)
YES


8
sCustomerId
varchar(100)
YES


9
sManualNo
varchar(255)
YES


10
sCustomerOrderNo
varchar(255)
YES


11
sProductId
varchar(100)
YES


12
dProductQty
decimal(18,6)
NO

0.000000

产品数量


13
sSrcControlId
varchar(100)
YES


14
sPartsName
varchar(255)
YES


15
sMachineId
varchar(50)
YES


16
sOrderSlaveId
varchar(100)
YES


17
sOrderNo
varchar(255)
YES


18
sWorkOrderId
varchar(100)
YES


19
sWorkOrderSlaveId
varchar(100)
YES


20
sWorkOrderNo
varchar(255)
YES


21
sWorkOrderControlId
varchar(100)
YES


22
sCostPeriod
varchar(255)
YES


23
dBusinessHour
decimal(18,6)
NO

0.000000

业务系统生产时间


24
dBusinessQty
decimal(18,6)
NO

0.000000

业务系统上报数量


25
dBusinessConversionQty
decimal(18,6)
NO

0.000000

业务系统转换数量


26
dFinaHour
decimal(18,6)
NO

0.000000

财务系统生产时间


27
dFinaQty
decimal(18,6)
NO

0.000000

财务系统上报数量


28
dFinaConversionQty
decimal(18,6)
NO

0.000000

财务系统转换数量


29
bConfirmQty
bit(1)
NO

b'0'

是否确认数量


30
dBusinessWage
decimal(18,6)
NO

0.000000

业务系统计件工资


31
dFinaWage
decimal(18,6)
NO

0.000000

财务系统计件工资


32
bConfirmWage
bit(1)
NO

b'0'

是否确认工资


33
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
制单日期


34
sFormId
varchar(100)
YES


35
sBillNo
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.