cahsupplyinit.md 2.49 KB

Edit Raw Blame History



cahsupplyinit


客户期初


Rows (estimated): 2

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:51:55

Updated: 2026-04-27 18:51:55


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO
PRI

auto_increment
自增列


2
sId
varchar(100)
NO
MUL


标准ID


3
sBrandsId
varchar(100)
NO


加工商ID


4
sSubsidiaryId
varchar(100)
NO


子公司ID


5
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
制单日期


6
sMakePerson
varchar(255)
NO


制单人


7
iOrder
int
NO

0

排序号


8
sSupplyId
varchar(100)
NO


供应商Id


9
dCheckingMoney
decimal(18,6)
NO

0.000000

对账金额


10
dNoCheckingMoney
decimal(18,6)
NO

0.000000

未对账金额


11
dNoInvoiceMoney
decimal(18,6)
NO

0.000000

未开票金额


12
dRealCheckMoney
decimal(18,6)
NO

0.000000

反写对账金额


13
dRealNoCheckingMoney
decimal(18,6)
NO

0.000000

反写未对账金额


14
dRealNoInvoiceMoney
decimal(18,6)
NO

0.000000

反写未开票金额


15
dPayMoney
decimal(18,6)
NO

0.000000

付款金额


16
sGetPayId
varchar(100)
YES


结算方式ID


17
sTaxId
varchar(100)
YES


税率Id


18
tPaymentDate
datetime
YES


付款日期


19
sMemo
text
YES


备注


20
bInvalid
bit(1)
NO

b'0'

作废


21
bPaymentComplete
bit(1)
NO

b'0'

付款强制完工


22
bAdvanceComplete
bit(1)
NO

b'0'

付款强制完工


23
bInvoiceComplete
bit(1)
NO

b'0'

发票强制完工


24
sBillNo
varchar(100)
YES


25
sCheckPerson
varchar(100)
YES


Indexes


Name
Unique
Type
Columns


IndexN_sisunit

BTREE

sId, sBrandsId, sSubsidiaryId, sSupplyId


IndexU_sisunit
✓
BTREE

sId, sBrandsId, sSubsidiaryId


PRIMARY
✓
BTREE
iIncrement


Narrative

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