Un-invoiced Sales File Export Format

Field Name

Description

Field Length

Field Type

Export Batch ID

Auto-generated ID that uniquely identifies the export batch in which the file was generated.

Integer

Export Date

Date on which the export batch was processed.

Date/Time

Posting Date

Date that identifies the financial reporting period to which the export corresponds, as specified when the export batch was created.

Date/Time

Export Status

Is one of the following depending on the status of the export batch in which the export file was generated:

1. – generated

2. – regenerated

3. - deleted.

1

Integer

Debtor Name

Name of the debtor who is linked to the job order to which this transaction line corresponds or is blank if the transaction is not linked to a job order.

100

Variable Character

Debtor Export Code

Export code of the debtor who is linked to the job order to which this transaction line corresponds, as defined on the header of the Debtor record.
Alternatively, this field is blank if this transaction is not linked to a job order.

50

Variable Character

Payee First Name

First name of the payee to whom this transaction line corresponds.

50

Variable Character

Payee Surname

Surname/family name of the payee to whom this transaction line corresponds.

50

Variable Character

Candidate No.

Candidate number that uniquely identifies the candidate to whom this transaction line corresponds.

9

Integer

Payee No.

Payee number that uniquely identifies the payee to whom this transaction line corresponds.

9

Integer

Job Order No.

Job number that uniquely identifies the job order to which this transaction line corresponds. Alternatively, this field is blank if this transaction line is not derived from a job order (i.e. is a manual item or a leave item from a leave request).

9

Integer

Item Type

Identifies the type of transaction this transaction line represents and is set to one of the following:

• Uninvoiced Sales BS

• Uninvoiced Sales PL

• Uninvoiced Sales Reversal PL

• Uninvoiced Sales Reversal BS

28

Variable Character

GL Account Segment 1

Account segment value that is configured in Finance Integration Maintenance for account segment 1.

50

Variable Character

GL Account Segment 2

Account segment value that is configured in Finance Integration Maintenance for account segment 2.

This field is set to blank if Segment 2 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 3

Account segment value that is configured in Finance Integration Maintenance for account segment 3.

This field is set to blank if Segment 3 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 4

Account segment value that is configured in Finance Integration Maintenance for account segment 4.

This field is set to blank if Segment 4 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 5

Account segment value that is configured in Finance Integration Maintenance for account segment 5.

This field is set to blank if Segment 5 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 6

Account segment value that is configured in Finance Integration Maintenance for account segment 6.

This field is set to blank if Segment 6 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 7

Account segment value that is configured in Finance Integration Maintenance for account segment 7.

This field is set to blank if Segment 7 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

GL Account Segment 8

Account segment value that is configured in Finance Integration Maintenance for account segment 8.

This field is set to blank if Segment 8 is undefined or there is no corresponding value for the listed item type.

50

Variable Character

Account Number

Billing company invoice type account group profit/loss export account or balance sheet export account to which this transaction item corresponds.

Note that if the transaction is a reversal, the posting account is reversed (i.e. where the transaction is a BS transaction it is posted to the PL account and vice versa).

50

Variable Character

Credit/Debit

Identifies if this transaction line represents a credit or debit transaction. This field is set to Debit if any of the following conditions apply:

• the transaction is a PL transaction & the transaction amount is a positive value

• the transaction is a BS transaction & the transaction amount is a negative value.

This field is set to Credit if any of the following conditions apply:

• the transaction is a BS transaction & the transaction amount is a positive value

• the transaction is a PL transaction & the transaction amount is a negative value.

6

Variable Character

Amount

Monetary amount that applies to this transaction line.

Numeric

Invoice Number

Invoice number of the invoice that has reversed this transaction line.

This field is blank unless this transaction line is a reversal transaction (i.e. Uninvoiced Sales Reversal BS or Uninvoiced Sales Reversal PL).

100+

Integer