accexpenseentrybusinessslave.md
2.5 KB
accexpenseentrybusinessslave
- Engine: InnoDB
- Collation: utf8mb3_general_ci
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 | sMakePerson |
varchar(255) |
YES | ||||
| 6 | iOrder |
int |
NO | 0 | 排序号 | ||
| 7 | sParentId |
varchar(100) |
YES | ||||
| 8 | sDepartId |
varchar(50) |
YES | ||||
| 9 | dOtherOperateMoney |
decimal(18,6) |
NO | 0.000000 | 其他业务收入金额 | ||
| 10 | dMainBusinessCostMoney |
decimal(18,6) |
NO | 0.000000 | 主营业务成本 | ||
| 11 | dAdministrativeExpenses |
decimal(18,6) |
NO | 0.000000 | 管理费用 | ||
| 12 | bTransferOut |
bit(1) |
NO | b'0' | 是否转出 | ||
| 13 | bDepartInsert |
bit(1) |
NO | b'0' | 是否部门成本转移插入数据 | ||
| 14 | dAssetsImpairmentloss |
decimal(18,6) |
NO | 0.000000 | 资产减值损失 | ||
| 15 | dCreditImpairmentloss |
decimal(18,6) |
NO | 0.000000 | 信用减值损失 | ||
| 16 | dTaxMoney |
decimal(18,6) |
NO | 0.000000 | 税金及附加 | ||
| 17 | dSellingExpenses |
decimal(18,6) |
NO | 0.000000 | 销售费用 | ||
| 18 | dFinancialExpenses |
decimal(18,6) |
NO | 0.000000 | 财务费用 | ||
| 19 | dRDExpenses |
decimal(18,6) |
NO | 0.000000 | 研发费用 | ||
| 20 | dOtherbusinessCostMoney |
decimal(18,6) |
NO | 0.000000 | 其他业务成本 | ||
| 21 | dGainsIncomeloss |
decimal(18,6) |
NO | 0.000000 | 公允价值变动收益（损失） | ||
| 22 | dInvestmentIncomeloss |
decimal(18,6) |
NO | 0.000000 | 投资收益（损失） | ||
| 23 | dOtherIncome |
decimal(18,6) |
NO | 0.000000 | 其他收益 | ||
| 24 | dDisposalIncomeloss |
decimal(18,6) |
NO | 0.000000 | 处置收益（损失） | ||
| 25 | dNonbusinessIncome |
decimal(18,6) |
NO | 0.000000 | 营业外收入 | ||
| 26 | dNonBusinessExpenditure |
decimal(18,6) |
NO | 0.000000 | 营业外支出 | ||
| 27 | iPeople |
int |
NO | 0 | 月度总人数 | ||
| 28 | dElectricityFees |
decimal(18,6) |
NO | 0.000000 | 月度总电费 |
Narrative
No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.