Universal GL Link information
Description
- Universal G/L Link information
- Universal link output
Resolution
Required Fields:
- Period Posting Date
- Reference Number
Output File:
- GLLINK.ASC
- GLLINK.SDF
File Layout:
- Fixed Width ASCII
- Standard Comma-delimited
GLLINK.ASC and GLLINK.SDF Layout:
Field No. | Field Name | Data Type | Field Length | Start Position |
1 | G/L Account Number | Alphanumeric | 100 | 1 |
2 | File Creation Date | Numeric | 10 | 101 |
3 | Source | Alphanumeric | 8 | 111 |
4 | Period Posting Date | Numeric | 10 | 119 |
5 | Reference Number | Alphanumeric | 10 | 129 |
6 | Transaction Description | Alphanumeric | 24 | 144 |
7 | Path and File Name | Alphanumeric | 260 | 168 |
8 | Transaction Amount | Numeric | 12 | 428 |
9 | Credit/Debit Flag | Alphanumeric | 1 | 443 |