receivableswarning_data_sum.md
3.8 KB
receivableswarning_data_sum
- 预估行数： 90
- 数据大小： 80.0 KB
- 引擎： InnoDB
- 排序规则： utf8mb3_general_ci
- 创建时间： 2026-04-27 18:56:38
- 更新时间： 2026-04-27 18:56:38
字段
| # | 名称 | 类型 | 可空 | 键 | 默认值 | 额外属性 | 备注 |
|---|---|---|---|---|---|---|---|
| 1 | sId |
varchar(255) |
YES | ||||
| 2 | sSlaveId |
varchar(255) |
YES | ||||
| 3 | sCustomerId |
varchar(255) |
NO | ||||
| 4 | sCustomerName |
varchar(255) |
YES | ||||
| 5 | sCustomerNo |
varchar(255) |
YES | ||||
| 6 | sCustomerClassifyId |
varchar(255) |
YES | ||||
| 7 | sCustomerClassifyName |
varchar(255) |
YES | ||||
| 8 | dCreditLimit |
decimal(22,12) |
YES | ||||
| 9 | iCheckDate |
int |
NO | 0 | |||
| 10 | tCheckDate |
int |
NO | 0 | |||
| 11 | sSalesManId |
varchar(255) |
YES | ||||
| 12 | sSalesManNo |
varchar(255) |
YES | ||||
| 13 | sSalesManName |
varchar(255) |
YES | ||||
| 14 | sDepartId |
varchar(255) |
YES | ||||
| 15 | sDepartName |
varchar(255) |
YES | ||||
| 16 | sDepartNo |
varchar(255) |
YES | ||||
| 17 | sCustomerPropertyId |
varchar(255) |
YES | ||||
| 18 | sCustomerPropertyName |
varchar(255) |
YES | ||||
| 19 | sGetPayId |
varchar(100) |
YES | 结算方式 | |||
| 20 | sGetPayName |
varchar(100) |
YES | 结算方式 | |||
| 21 | dLastBalanceMoney |
decimal(22,2) |
NO | 0.00 | |||
| 22 | dSalesMoney |
decimal(22,2) |
NO | 0.00 | |||
| 23 | dReceiptMoney |
decimal(22,2) |
NO | 0.00 | |||
| 24 | dPayMoney |
decimal(22,2) |
NO | 0.00 | |||
| 25 | dAdjustMoney |
decimal(22,2) |
NO | 0.00 | |||
| 26 | dSlaveRoundingMoney |
decimal(22,2) |
NO | 0.00 | |||
| 27 | dThisBalanceMoney |
decimal(22,2) |
NO | 0.00 | |||
| 28 | dLastBalanceMoneyDq |
decimal(22,2) |
NO | 0.00 | |||
| 29 | dSalesMoneyDq |
decimal(22,2) |
NO | 0.00 | |||
| 30 | dReceiptMoneyDq |
decimal(22,2) |
NO | 0.00 | |||
| 31 | dPayMoneyDq |
decimal(22,2) |
NO | 0.00 | |||
| 32 | dAdjustMoneyDq |
decimal(22,2) |
NO | 0.00 | |||
| 33 | dSlaveRoundingMoneyDq |
decimal(22,2) |
NO | 0.00 | |||
| 34 | dThisBalanceMoneyDq |
decimal(22,2) |
NO | 0.00 | |||
| 35 | dDeliverMoney |
decimal(22,2) |
NO | 0.00 | |||
| 36 | dNoCheckMoney |
decimal(22,2) |
NO | 0.00 | |||
| 37 | dKpqc |
decimal(22,2) |
NO | 0.00 | |||
| 38 | dJqc |
decimal(22,2) |
NO | 0.00 | |||
| 39 | dSkqc |
decimal(22,2) |
NO | 0.00 | |||
| 40 | dKpqcDq |
decimal(22,2) |
NO | 0.00 | |||
| 41 | dJqcDq |
decimal(22,2) |
NO | 0.00 | |||
| 42 | dSkqcDq |
decimal(22,2) |
NO | 0.00 | |||
| 43 | iType1 |
int |
NO | 1 | |||
| 44 | iType2 |
int |
NO | 2 | |||
| 45 | iType3 |
int |
NO | 3 | |||
| 46 | iType4 |
int |
NO | 4 | |||
| 47 | iType5 |
int |
NO | 5 | |||
| 48 | iType6 |
int |
NO | 6 | |||
| 49 | iType7 |
int |
NO | 7 | |||
| 50 | iType8 |
int |
NO | 8 | |||
| 51 | iType9 |
int |
NO | 9 | |||
| 52 | iType10 |
int |
NO | 10 | |||
| 53 | iType11 |
int |
NO | 11 | |||
| 54 | iType12 |
int |
NO | 12 | |||
| 55 | iType13 |
int |
NO | 13 | |||
| 56 | iType14 |
int |
NO | 14 | |||
| 57 | iType15 |
int |
NO | 15 | |||
| 58 | sMemo |
longtext |
YES | ||||
| 59 | tStartDate |
datetime |
YES | ||||
| 60 | tEndDate |
datetime |
YES |
说明
暂无人工说明；当某个垂直切片使用这张表时，请从切片反向链接到本页。