accopsoutsideinstoremaster.md 2.8 KB

Edit Raw Blame History



accopsoutsideinstoremaster


Rows (estimated): 29983

Data size: 15.5 MB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:47:10

Updated: 2026-04-27 18:47:12


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
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
制单日期


6
sMakePerson
varchar(255)
YES


7
iOrder
int
NO

0

排序号


8
sFormId
varchar(100)
YES


9
sBillNo
varchar(255)
YES


10
sSupplyId
varchar(100)
YES


11
sManualNo
varchar(255)
YES


12
sMemo
text
YES


13
bCheck
bit(1)
NO

b'0'

是否审核


14
tCheckDate
datetime
YES


审核日期


15
sCheckPerson
varchar(255)
YES


16
bPrint
bit(1)
NO

b'0'

是否打印


17
bCopyLimit
bit(1)
NO

b'0'

禁止拷贝


18
sCurrency
varchar(255)
YES


19
dCurrencyRate
decimal(18,6)
YES


汇率


20
bInvalid
bit(1)
NO

b'0'

是否作废


21
sVoucherBillNo
varchar(255)
YES


22
sVoucherBillId
varchar(50)
YES


23
sVoucherBillminusNo
varchar(255)
YES


24
sVoucherBillminusId
varchar(50)
YES


25
sCostPeriod
varchar(255)
YES


26
sCostNextPeriod
varchar(255)
NO


下个会计期间


27
dMaterialsNoTaxPrice
decimal(24,13)
NO

0.0000000000000


28
dMaterialsNoTaxMoney
decimal(18,6)
YES


不含税金额


29
dMaterialsTaxMoney
decimal(18,6)
YES


税额


30
dMaterialsTaxForeignMoney
decimal(18,6)
YES


外币税额


31
dMaterialsForeignMoney
decimal(18,6)
YES


外币金额


32
sSrcId
varchar(100)
YES


主表id


33
dMaterialsMoney
decimal(18,6)
YES


金额


34
sSrcSlaveId
varchar(100)
YES


主表id


35
sMaterialsId
varchar(100)
YES


物料id


36
sTaxId
varchar(100)
YES


税码id


37
sDeliverNo
varchar(50)
YES


外协商送货单号


Narrative

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