EDI File Formats

EDI File Formats

EDI File Format

Field Position
Num of Char
Example
Description
Required
Argos Data
Not Used
1-3
3
DTL
Record Type
Y


4-5
2
IF
Transaction Type
IF - Invoice
RF - Credit Return
PA - Price Adjustment
Y


6-8
3
1
Company Number
N

Y
9-20
12
IN1234567891
Invoice Number Any communication of up to 12 alpha-numeric characters
Y


21-28
8
20110302
Date Invoiced YYYYMMDD
Y


29-37
9
BMTD10000
Bailment Dealer Code 
Any combination of up to 9 alpha-numeric characters
Y
Y

38-47
10
FFP120
Free Floor Plan Profile
Y
Y (Bailment Loan Model)

48-52
5
1
Line Number
N

Y
53-54
5
1
Product Code
N


55-56
2
A2
Division
Y
Y (First Analysis Code)

57-76
20
XVS1100Y
Model Number
Y


77-106
30
VP058 D/STAR CUSTOM
Asset/Model Description
N


107-111
5
DRMK
Colour Code
N


112-141
30
DEEP RED METALLIC K
Colour Description

Y
142-148
7
1
Supplied Quantity
(value not required, just enter 0)

Y
149-159
11
913900
Amount (excl tax)
First character is sign. Last 2 are decimal places. This example is $9139.00.
An invoice must be a positive amount.
A credit return must be a negative amount and the same as the full asset value.
The Amount entered for a price adjustment is the amount by which the asset price is to be adjusted
Y


160-170
11
91390
This will only be entered in the EDI file if the Distributor is a non related party.
The sign for the GST must be the same as the sign of the Invoice Amount entered in the previous field
i.e. it will be positive for an invoice and negative for a credit return
(value not required, just enter 0)


171-181
11
0
Invoice Non Tax Amount
(value not required, just enter 0)

Y
182-186
5
1
Unit Number
N(value not required, just enter 0)

Y
187-191
5
AM01Y
Unit Serial Number Prefix
N

Y
192-198
7
42196
Unit Serial Number
N

Y
199-218
20
JYAVP05839A000971
VIN or HIN
Y (VINHIN or Engine Number must be supplied)


219-243
25
P604E0034873
Engine Number
Y


244-251
8
20030303
Date Created
(value not required, just enter 0)

Y
252-257
6
160417
Time Created
(value not required, just enter 0)

Y
258-260
3
AT
Item Category
N

Y
261-264
4
NEW
Asset Condition Options are NEW, USED, RACE DEMO
Y


Header Details

Field Position
Example
Description
Required
Argos Data
Not Used
1-3
HDR
Record Type
Y


4-8
ADFKW
Distributor Code
Y MUST be 5 characters
Y (Distributor Code)

9-17
000
Agency Number
N (value not required, just enter 0)

Y
18-25

File Sequence Number
N (value not required, just enter 0)


Field PositionExampleDescriptionRequiredArgos DataNot Used
1-3TRLRecord TypeY

4-9000002Number of recordsY

10-24"000000233316040Hash StringN (value not required, just enter 0)
Y

Credit Limit Export File Format

Field
From Position
To Position
Decimal Place
Company
1
5

Customer Number
6
14

Date
15
20

Sequence #
21
24
0
Sign (+ -)
25
25

Credit Limit
26
40
2
Sign (+ -)
41
41

Used Limit
42
56
2
Sign (+ -)
57
57

Available Limit
58
72
2



    • Related Articles

    • Import EDI File Setup

      Purpose Allow the setup of file paths for import and export of file relevant to distributors Access View | Distributor | account | Distributor Settings tab Dialog Details The following dialog will display: Details Specific Fields Field Explanation ...
    • Import EDI File Errors

      Purpose EDI Import allows the import of an externally created file of Bailment Assets, credit returns and price adjustments. Process Review the error, and correct Issue Solution File IO Exceptions or parsing errors If there is a problem reading the ...
    • Argos API/EDI Import Tool

      This document outlines how to use the Argos API Import tool to import new Bailment Accounts from an external file through the Argos API Server. Also how raise Credit Returns and Price Adjustments. Prerequisites API Server The API Import tool requires ...
    • Importing an EDI file

      Purpose To allow the import of asset details so that Bailment Accounts and Trust Receipts may be automatically created EDI File Import Rules All invoice amounts must be positive All Credit Return amounts must be negative and for the full amount of ...
    • Client Import Routine

      Concept Argos Vault provides functionality to import client records from an external source into a Vault Database. A tab delimited file can be generated which complies with a predefined format and used as the data source for the Client Import. This ...