expensereimbursementslave.md
3.69 KB
expensereimbursementslave
- Engine: InnoDB
- Collation: utf8mb3_general_ci
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 | sMakePerson |
varchar(255) |
NO | 制单人 | |||
| 6 | iOrder |
int |
NO | 0 | 排序号 | ||
| 7 | sParentId |
varchar(100) |
NO | 父级ID | |||
| 8 | sType |
varchar(255) |
NO | 类型(1:报销、2:调整) | |||
| 9 | sReimbursementType |
varchar(255) |
YES | 大类类型 | |||
| 10 | sDetail |
varchar(100) |
YES | 细项 | |||
| 11 | dMaterialsMoney |
decimal(18,6) |
NO | 0.000000 | 金额 | ||
| 12 | sMemo |
text |
YES | 备注 | |||
| 13 | sSReserve1 |
varchar(255) |
YES | 预留字符1 | |||
| 14 | sSReserve2 |
varchar(255) |
YES | 预留字符2 | |||
| 15 | sSReserve3 |
varchar(255) |
YES | 预留字符3 | |||
| 16 | sSReserve4 |
varchar(255) |
YES | 预留字符4 | |||
| 17 | sSReserve5 |
varchar(255) |
YES | 预留字符5 | |||
| 18 | sSReserve6 |
varchar(255) |
YES | 预留字符6 | |||
| 19 | dSReserve1 |
decimal(18,6) |
YES | 预留数字1 | |||
| 20 | dSReserve2 |
decimal(18,6) |
YES | 预留数字2 | |||
| 21 | dSReserve3 |
decimal(18,6) |
YES | 预留数字3 | |||
| 22 | iSReserve1 |
int |
YES | 预留整型1 | |||
| 23 | iSReserve2 |
int |
YES | 预留整型2 | |||
| 24 | iSReserve3 |
int |
YES | 预留整型3 | |||
| 25 | tSReserve1 |
datetime |
YES | 预留日期1 | |||
| 26 | tSReserve2 |
datetime |
YES | 预留日期2 | |||
| 27 | dTaxRate |
decimal(18,6) |
NO | 0.000000 | 税率 | ||
| 28 | dMaterialsTaxMoney |
decimal(18,6) |
NO | 0.000000 | 税额 | ||
| 29 | dMaterialsNoTaxMoney |
decimal(18,6) |
NO | 0.000000 | 不含税金额 | ||
| 30 | sTaxId |
varchar(255) |
YES | 税率Id | |||
| 31 | dMaterialsQty |
decimal(18,6) |
NO | 0.000000 | 数量 | ||
| 32 | dMaterialsPrice |
decimal(24,13) |
NO | 0.0000000000000 | |||
| 33 | sStartingPoint |
varchar(100) |
NO | 起点 | |||
| 34 | sEndingPoint |
varchar(100) |
NO | 目的地 | |||
| 35 | dAirfare |
decimal(18,6) |
NO | 0.000000 | 机票费 | ||
| 36 | dHotelExpense |
decimal(18,6) |
NO | 0.000000 | 住宿费 | ||
| 37 | dOtherExpense |
decimal(18,6) |
NO | 0.000000 | 其他费用 | ||
| 38 | dTravelAllowance |
decimal(18,6) |
NO | 0.000000 | 出差补助 | ||
| 39 | dAccountMoney |
decimal(18,6) |
NO | 0.000000 | 报销金额 | ||
| 40 | dAdjustMoney |
decimal(18,6) |
NO | 0.000000 | 调整金额 | ||
| 41 | sAdjustMemo |
text |
YES | 调整原因 | |||
| 42 | sExpenseCategoryId |
varchar(100) |
NO | 费用大项明细ID | |||
| 43 | sExpenseCategory |
varchar(100) |
NO | 费用大项 | |||
| 44 | sExpenseDetail |
varchar(100) |
NO | 费用细项 | |||
| 45 | sExpenseDetailId |
varchar(100) |
NO | 费用细项ID | |||
| 46 | sAccountNo |
varchar(100) |
NO | 科目代码 | |||
| 47 | sAccountId |
varchar(100) |
NO | 科目ID | |||
| 48 | dPayMoney |
decimal(18,6) |
NO | 0.000000 | 已付金额 | ||
| 49 | bPaymentComplete |
bit(1) |
NO | b'0' | 强制付款标记 |
Narrative
No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.