| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | RSAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 2 | RSPART | Parent Child Relationship | Character | UDC (H01 PA) | 1 | 0 | Allow NULL? |
| 3 | RSCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | RSENBL | Amount - Ending Balance | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 5 | RSAHB | Amount - High Balance | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 6 | RSDHBJ | Date - High Balance | Date | Generic Edit | 6 | 0 | |
| 7 | RSACLH | Amount - High Credit Limit | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 8 | RSAVDL | Weighted Average Days Late | Numeric | Generic Edit | 13 | 0 | Allow NULL? |
| 9 | RSAVDN | Average Days Late - Non Weighted | Numeric | Generic Edit | 13 | 0 | Allow NULL? |
| 10 | RSAG | Amount - Gross | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | RSNINV | Number of Invoices | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 12 | RSSAG | Amount - Sales | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | RSCREE | Credits Entered | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | RSADSC | Discount Available | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | RSDFEE | Amount - Delinquency Fees | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | RSECBA | Amount - Chargeback | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | RSNCB | Number of Chargebacks | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 18 | RSDFIJ | Date - First Invoice | Date | Generic Edit | 6 | 0 | |
| 19 | RSDLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 | |
| 20 | RSDT1J | Date - Last Statement Date | Date | Generic Edit | 6 | 0 | |
| 21 | RSASTY | Amount - Invoiced This Year | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | RSSPYE | Amount - Invoiced Prior Year | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 23 | RSPAAP | Payment Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 24 | RSEDSC | Discount Earnable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | RSUDSC | Discount Unearned | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 26 | RSNINP | Number of Invoices Paid | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 27 | RSAIPL | Amount Paid Late | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 28 | RSNIPL | Number of Invoices Paid Late | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 29 | RSDDCA | Amount - Deductions | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 30 | RSDDCN | Number of Deductions | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 31 | RSMWO | Amount - Minor Write-Off | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | RSBDBT | Amount - Bad Debt | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | RSANSF | Amount - NSF | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 34 | RSNNSF | Number of NSF's | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 35 | RSDLP | Date - Last Paid | Date | Generic Edit | 6 | 0 | |
| 36 | RSALP | Amount - Last Applied | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 37 | RSNXPD | Next Period to Process | Date | Generic Edit | 6 | 0 | |
| 38 | RSNBR1 | Number of Sent Reminders - 1 | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 39 | RSDLQJ | Date - Last Dunning Letter | Date | Generic Edit | 6 | 0 | |
| 40 | RSCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 41 | RSCMGR | Credit Manager | String | UDC (01 CR) | 10 | 0 | Allow NULL? |
| 42 | RSCLMG | Collection Manager | String | Generic Edit (01 CM) | 10 | 0 | Allow NULL? |
| 43 | RSUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 44 | RSPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 45 | RSUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 46 | RSUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 47 | RSJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
