| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | R#HST | Status Code | Character | UDC (H00 HS) | 1 | 0 | Allow NULL? |
| 2 | R#REVR | Reverse | Character | UDC (H09 RF) | 1 | 0 | Allow NULL? |
| 3 | R#DCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 4 | R#DOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | R#SEN | Posting Sequence | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | R#DGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 7 | R#CTRY | Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 8 | R#RFAC | Rate Factor | Numeric | Generic Edit | 15 | 8 | Allow NULL? |
| 9 | R#EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 10 | R#CO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | R#RF | Frequency - Recurring | String | UDC (H00 RF) | 2 | 0 | Allow NULL? |
| 12 | R#ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 | Allow NULL? |
| 13 | R#AID | Account ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | R#AM | Account Mode - G/L | Character | UDC (H09 AM) | 1 | 0 | Allow NULL? |
| 15 | R#SBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | R#SBLT | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 17 | R#FCC | From Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 18 | R#FCCN | From Business Unit Category Code Number | String | Generic Edit | 2 | 0 | Allow NULL? |
| 19 | R#FCCC | From Business Unit Category Code | String | Generic Edit | 10 | 0 | Allow NULL? |
| 20 | R#FROM | From Account | String | Generic Edit | 15 | 0 | Allow NULL? |
| 21 | R#OBJF | Object Account From | String | Generic Edit | 6 | 0 | Allow NULL? |
| 22 | R#FSUB | From Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 23 | R#FSBL | From Subledger | String | Generic Edit | 8 | 0 | Allow NULL? |
| 24 | R#SLK | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 25 | R#FLT | From Ledger Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 26 | R#FMYI | From - MTD YTD ITD Amounts | Character | UDC (H09 FM) | 1 | 0 | Allow NULL? |
| 27 | R#FPN | From Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 28 | R#FFY | From Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 29 | R#FCTY | From Century - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 30 | R#THRU | Thru Account | String | Generic Edit | 15 | 0 | Allow NULL? |
| 31 | R#OBJT | Object Account Thru | String | Generic Edit | 6 | 0 | Allow NULL? |
| 32 | R#SUBT | Thru Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 33 | R#TSBL | Allocate Through Subledger | String | Generic Edit | 8 | 0 | Allow NULL? |
| 34 | R#BCCN | Based On Business Unit Category Code No. | String | Generic Edit | 2 | 0 | Allow NULL? |
| 35 | R#BCCC | Based Upon Business Unit Category Code | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | R#BFOB | Based Upon From Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 37 | R#BFSU | Based Upon From Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 38 | R#BFSL | Based Upon From Subledger | String | Generic Edit | 8 | 0 | Allow NULL? |
| 39 | R#BSLT | Based Upon Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 40 | R#BLT | Based Upon Thru Ledger Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 41 | R#BMYI | Based Upon MTD YTD ITD Amounts | Character | UDC (H09 BM) | 1 | 0 | Allow NULL? |
| 42 | R#BPNO | Based Upon Period Number | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 43 | R#BFY | Based Upon Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 44 | R#BCTR | Base Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 45 | R#BTOB | Based Upon Thru Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 46 | R#BTSU | Based Upon Thru Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 47 | R#BTSL | Based Upon Through Subledger | String | Generic Edit | 8 | 0 | Allow NULL? |
| 48 | R#AOBA | Apply To Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 49 | R#ASBA | Apply To Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 50 | R#ASBL | Apply To Subledger | String | Generic Edit | 8 | 0 | Allow NULL? |
| 51 | R#ALTA | Apply To Ledger Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 52 | R#USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 53 | R#LCT | Date - Last Changed | Date | Generic Edit | 6 | 0 | |
| 54 | R#SDTE | Date - Stop | Date | Generic Edit | 6 | 0 | |
| 55 | R#ASBT | Apply To Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 56 | R#PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 57 | R#UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 58 | R#JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 59 | R#UPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
