Contact Us
- Sales: sales@todaysystems.com
- Support: support@todaysystems.com
Ledger Transactions File Format
Introduction
The OCS applications have the ability to send ledger transaction to an external file for interfacing to third party financial system or other systems requiring ledger transaction from the feeder systems. The ledger file are created during the "Transfer Supplier Invoices" function.
Ledger Transactions File Format
The Invoice file format follows the standard OCS file format guidelines. Refer to the "OCS Standard File Format Guidelines" knowledge base article for this information. NOTE: Only the Fixed File Format is supported.
Unless otherwise indicated all fields left justified, alphanumeric and uppercase. Fields indicated numeric are Right Justified and the length includes the number of decimal places and the decimal point. All date fields are in the format CCYYMMDD.
Most fields correspond to common fields in financial transaction. Comments are only made if some restriction or other important note must be made about the field.
The format of the file is:
Field | Length | Comments |
Company | 2 | |
Ledger | 4 | |
Account | 32 | |
TransactionType | 10 | |
SourceSystem | 2 | |
FinancialYear | 4 | |
FinancialPeriod | 6 | |
TransactionDate | 8 | |
Value | 16 | Numeric, 2 decimal places |
Narration1 | 40 | |
Narration2 | 40 | |
Reference1 | 20 | First 4 characters consist of the reference type. The following 16 characters are the reference code. |
Reference2 | 20 | First 4 characters consist of the reference type. The following 16 characters are the reference code. |
Reference3 | 20 | First 4 characters consist of the reference type. The following 16 characters are the reference code. |
Reference4 | 20 | First 4 characters consist of the reference type. The following 16 characters are the reference code. |
Control Ledger | 4 | If this transaction is to a subsidiary account then this is the control ledger the transaction will post up to. |
Control Account | 32 | If this transaction is to a subsidiary account then this is the control account the transaction will post up to. |