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 |