| Pole | SQL | Typ | Popis |
|---|---|---|---|
| idpk | idpk | Long(18) | ID záznamu |
| oobDistrict | idpk_district | OobDistrict | |
| idpkWarehouse | idpk_warehouse | Long(18) | |
| CDiscount | c_discount | Short(4) | Sleva |
| CCreditLim | c_credit_lim | BigDecimal(16,4) | Limit |
| CLast | c_last | String(16) | Poslední |
| CFirst | c_first | String(16) | První |
| CCredit | c_credit | String(2) | Kredit |
| CBalance | c_balance | BigDecimal(16,4) | stav konta |
| CYtdPaymentCnt | c_ytd_payment_cnt | Integer(9) | Počet plateb od zač. roku |
| CPaymentCnt | c_payment_cnt | Integer(9) | Počet plateb |
| CDeliveryCnt | c_delivery_cnt | Integer(9) | Počet doručení |
| CStreet1 | c_street_1 | String(20) | Ulice 1 |
| CStreet2 | c_street_2 | String(20) | Ulice 2 |
| CCity | c_city | String(20) | Město |
| CState | c_state | String(2) | Stát |
| CZip | c_zip | String(9) | PSČ |
| CPhone | c_phone | String(16) | Telefon |
| CSince | c_since | Date(23) | Od |
| CMiddle | c_middle | String(2) | Střed |
| CData | c_data | String(500) | Data |