The table below describes the standard debtor export file format.
The file naming convention for debtor files will be DEBTORS_<batch ID><ddmmyyyy><hhmmss>.CSV (e.g. DEBTORS_000001_2511201 4_152758.CSV).
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 |
Integer |
Debtor Code |
ID that uniquely identifies the debtor within the FastTrack360 system, as defined on the header of the Debtor record. |
9 |
Integer |
Debtor Name |
Name of the debtor as defined on the header of the Debtor record. |
100 |
Variable Character |
Corporate Identity Number |
ID that uniquely identifies the debtor company as a legal entity, as defined on the header of the Debtor record. |
40 |
Variable Character |
Taxation Number |
The taxation number under which the debtor is registered for collection of Goods and Services/Value Added Tax or similar, as defined on the Billing Details section of the Debtor record. |
40 |
Variable Character |
Customer Type |
Identifies the type of customer the debtor is linked to in the FastTrack360 system, as defined in the header of the Debtor record. This is one of the following: |
10 |
Variable Character |
Customer Name |
Name of the customer to which the debtor is linked to in the FastTrack360 system, as defined in the header of the Debtor record. |
50 |
Variable Character |
Customer ID |
ID that uniquely identifies the customer to which the debtor is linked within the FastTrack360 syste m, as defined on the header of the Debtor record. |
9 |
Variable Character |
Billing Contact Name |
Name of the debtor staff who acts as the bill to contact, as defined on the default set of Invoice Details on the Debtor record. |
50 |
Variable Character |
Billing Contact BH Phone |
Business hours telephone number of the debtor staff identified in the Billing Contact Name field, as defined on the corresponding Client Contact record in Recruitment Manager. |
25 |
Variable Character |
Billing Contact Mobile |
Mobile telephone number of the debtor staff identified in the Billing Contact Name field, as defined on the corresponding Client Contact record in Recruitment Manager. |
25 |
Variable Character |
Billing Contact Email |
Email address of the debtor staff identified in the Billing Contact Name field, as defined on the corresponding Client Contact record in Recruitment Manager. |
255 |
Variable Character |
Billing Address 1 |
Address line 1 of the debtor's billing address, as defined on the Contact Details section of the Debtor record. |
100 |
Variable Character |
Billing Address 2 |
Address line 2 of the debtor's billing address, as defined on the Contact Details section of the Debtor record. |
100 |
Variable Character |
Billing Suburb |
Suburb/city/town in which debtor's billing address is located, as defined on the Contact Details section of the Debtor record. |
40 |
Variable Character |
Billing State |
State/territory/province in which the debtor's billing address is located, as defined on the Contact Details section of the Debtor record. |
40 |
Variable Character |
Billing Postcode |
Postcode/zip code in which the debtor's billing address is located, as defined on the Contact Details section of the Debtor record. |
20 |
Variable Character |
Billing Country |
Country in which the debtor's billing address is located, as defined on the Contact Details section of the Debtor record. |
100 |
Variable Character |
Language |
Identifies the language that applies to the debtor, as derived from the debtor's billing country. |
100 |
Variable Character |
Currency Code |
ISO code that identifies the currency type that applies to the debtor's billing country. |
3 |
Variable Character |
Credit Limit Amount |
Credit limit that applies to the debtor, as specified on the Billing Details section of the Debtor record. |
18 |
Numeric |
Delivery Method |
Delivery method by which the debtor prefers to receive invoices, as defined on the Delivery Details section of the default Invoice Details on the Debtor record. |
10 |
Variable Character |
Debtor Status |
Identifies the status of the Debtor record in the FastTrack360 system. This is set to one of the following:
|
1 |
Integer |
Debtor Export Code |
Unique code that maps the Debtor record in the FastTrack360 system to the corresponding record in a 3rd party system for the purposes of exporting the debtor information. |
50 |
Variable Character |
Debtor Import Code |
Unique code that maps the corresponding record in a 3rd party system to a Debtor record in the Fa stTrack360 system for the purposes of importing the debtor information. |
50 |
Variable Character |
Country |
Identifies the country to which the Debtor record is linked, as defined on the header of the Debtor record. |
100 |
Variable Character |
GST Exempt |
Identifies if the debtor is exempt from Goods and Services/Value Added Tax or an equivalent tax. |
1 |
Integer |
Invoice Terms |
Default invoice payment terms for timesheet-based invoices that are issued to the debtor, as defined on the Invoice Details section of the Debtor record. |
50 |
Variable Character |
Invoice Message |
Default invoice message that is printed on timesheet-based invoices that are issued to the debtor, as defined on the Invoice Details section of the Debtor record. |
50 |
Variable Character |