General Ledger Account Codes Import
Information on the requirements for the General Ledger Account Codes Import available in RMS.
Import Information
- The file to be imported must be in a comma delimited .csv format (Field Delimiter).
- If a data field within this file contain commas, it should be surrounded with "double quotes" (Text Delimiter).
- Microsoft Excel is able to save using a .csv format that should match these requirements.
- RMS is able to determine whether the first record is a header record.
Field Order
| Order | Field Name | Field Type | Required | Unique | Max Characters | RMS Equivalent |
|---|---|---|---|---|---|---|
| 1 | GLCode | Alpha Numeric | Y | Y | 30 | GL Account Code |
| 2 | ShortDesc | Alpha Numeric | Y | N | 30 | Short Description |
| 3 | LongDesc | Alpha Numeric | N | N | Unlimited | Long Description |
| 4 | AccomRev | Y/N | N | N | 1 | Yes/No field - To Be used in Accommodation Revenue Calculations |
| 5 | Grouping |
Alpha Numeric |
N | N | 30 | GL Account Code Groupings |