| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | ROSY | Product Code | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 2 | ROAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 3 | ROKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | RODCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 5 | RODOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | ROSFX | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 7 | ROVINV | Supplier Invoice Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 8 | ROVR01 | Reference | String | Generic Edit | 25 | 0 | Allow NULL? |
| 9 | ROCTL | Control/Statement Field | String | Generic Edit | 13 | 0 | Allow NULL? |
| 10 | ROCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | ROMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 12 | RODGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 13 | RODIVJ | Date - Invoice - Julian | Date | Generic Edit | 6 | 0 | |
| 14 | RODDNJ | Date - Discount Due - Julian | Date | Generic Edit | 6 | 0 | |
| 15 | RODDJ | Date - Net Due | Date | Generic Edit | 6 | 0 | |
| 16 | ROSMTJ | Date - Statement | Date | Generic Edit | 6 | 0 | |
| 17 | RODSVJ | Date - Service/Tax | Date | Generic Edit | 6 | 0 | |
| 18 | ROFY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 19 | ROCTRY | Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 20 | ROPN | Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 21 | ROGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 22 | ROPOST | G/L Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | ROPST | Pay Status Code | Character | UDC (00 PS) | 1 | 0 | Allow NULL? |
| 24 | ROAG | Amount - Gross | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | ROAAP | Amount Open | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 26 | ROCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 27 | ROCRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 28 | ROACR | Amount - Currency | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 29 | ROFAP | Amount - Foreign Open | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 30 | ROCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 31 | ROFNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | RORP1 | A/R - A/P - Miscellaneous Code 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 33 | RORP2 | A/R - A/P - Miscellaneous Code 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 34 | RORP3 | A/R - A/P - Cash Rcpts/Inv Reg Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 35 | ROAC01 | Category Code - Address Book 01 | String | UDC (01 01) | 3 | 0 | Allow NULL? |
| 36 | ROAC02 | Category Code - Address Book 02 | String | UDC (01 02) | 3 | 0 | Allow NULL? |
| 37 | ROAC03 | Category Code - Address Book 03 | String | UDC (01 03) | 3 | 0 | Allow NULL? |
| 38 | ROAC04 | Category Code - Address Book 04 | String | UDC (01 04) | 3 | 0 | Allow NULL? |
| 39 | ROAC05 | Category Code - Address Book 05 | String | UDC (01 05) | 3 | 0 | Allow NULL? |
| 40 | ROAC06 | Category Code - Address Book 06 | String | UDC (01 06) | 3 | 0 | Allow NULL? |
| 41 | ROAC07 | Category Code - Address Book 07 | String | UDC (01 07) | 3 | 0 | Allow NULL? |
| 42 | ROAC08 | Category Code - Address Book 08 | String | UDC (01 08) | 3 | 0 | Allow NULL? |
| 43 | ROAC09 | Address Book 09 - Country Type | String | UDC (01 09) | 3 | 0 | Allow NULL? |
| 44 | ROAC10 | Address Book 10 - Nature of the Trade | String | UDC (01 10) | 3 | 0 | Allow NULL? |
| 45 | ROAT1 | Search Type | String | UDC (01 ST) | 3 | 0 | Allow NULL? |
| 46 | ROAT2 | AR/AP Netting Indicator | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 47 | ROAT3 | HRM Records Exist | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 48 | ROAT4 | Address Type - 4 | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 49 | ROAT5 | Address Type - 5 | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 50 | ROPYE | Payee Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 51 | ROPYR | Payor Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 52 | ROGLBA | G/L Bank Account | String | Generic Edit | 8 | 0 | Allow NULL? |
| 53 | ROAID2 | Account ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 54 | ROTNN | Flag for 1099 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 55 | ROSHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
