|
|
|
Summary |
The PGPRGENE002 – GL Journal report lists details of the General Ledger Journal, and it creates a file for export into a specified General Ledger/Accounting package. You can specify the General Ledger type on the Company Settings | General Ledger tab. The following table explains the text file format for the Sun GL interface. |
Field No |
Field Width |
Source |
Description |
Character Position |
1 |
15 |
CostCentre.GeneralLedgerCode |
Left 4 chars of GL code |
1 – 15 |
2 |
16 |
sDate |
Accounting period + Transaction date |
16 – 32 |
3 |
15 |
‘M’ |
|
33 – 48 |
4 |
18 |
HistoricalAllowance.TotalAmount or HistoricalDeduction.TotalAmount |
Transaction total |
49 – 67 |
5 |
2 |
HistoricalAllowance.TotalAmount or HistoricalDeduction.TotalAmount |
‘D’ or ‘C’ (Debit or Credit) |
68 – 69 |
6 |
5 |
‘GJ’ |
Journal |
70 – 75 |
7 |
20 |
‘PGI’ |
Pay Global Interface |
76 – 96 |
8 |
25 |
‘Wages’ + date |
Transaction reference |
97 – 122 |
9 |
110 |
Year + Month + Day |
Date |
123 – 233 |
10 |
3 |
Pad ‘ ‘ |
|
234 – 237 |
11 |
15 |
CostCentre.GeneralLedgerCode |
1st char |
238 – 253 |
12 |
3 |
CostCentre.GeneralLedgerCode |
Right 3 chars |
254 – 257 |
