A NEW TODAY IS DAWNING!

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.