# `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 |  |  |  |  |

## 说明

_暂无人工说明；当某个[垂直切片](../../slices/index.md)使用这张表时，请从切片反向链接到本页。_