| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | RMCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | RMCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 3 | RMDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 4 | RMDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | RMKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 6 | RMSFX | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 7 | RMLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 8 | RMDRR | Revenue Recognition Date | Date | Generic Edit | 6 | 0 | |
| 9 | RMDGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 10 | RMAAR | Recognized Revenue Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | RMAARE | Remaining Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | RMAARN | Amount not Recognized | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | RMRSTU | Revenue Recognition Status | Character | UDC (03B SR) | 1 | 0 | Allow NULL? |
| 14 | RMAARI | Future Use Amount1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | RMRRC | Recognition Reason Code | Character | UDC (03B RR) | 1 | 0 | Allow NULL? |
| 16 | RMFAAR | Foreign Recognized Revenue Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | RMFAARE | Foreign Remaining Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | RMFAARN | Foreign Amount not Recognized | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | RMFAARI | Future Use Amount2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | RMUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 21 | RMUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 22 | RMUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | RMPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | RMJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | RMEDRR | Eligible for Recognition Date | Date | Generic Edit | 6 | 0 | |
| 26 | RMEPDA | Effective Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 27 | RMCH6 | Future Use Character | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | RMDJ6 | Future Use Date | Date | Generic Edit | 6 | 0 | |