Appendix > Appendix > Format Requirements for Importing Transactions > Order Entry File Format Requirements > External File Format Requirements for the OE Transaction Header
External File Format Requirements for the OE Transaction Header
The table below contains the external file format requirements for the OE Transaction Header.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Field Length
Character Position (Fixed-Length Format)
Data Type
1
* Header Identifier
1
1
Char-Caps Type = “H”
2
* Shipping Customer
50
2
Char-Caps
3
Shipping Address Contact
35
52
Character
4
Shipping Address Line 1
35
87
Character
5
Shipping Address Line 2
35
122
Character
6
Shipping Address City
35
157
Character
7
Shipping Address State/Province
35
192
Character
8
Shipping Address Postal Code
35
227
Character
9
Shipping Address Country2
 
35
262
Character
10
* Cash/Check/CC/Chg
(0-Cash; 1-Check; 2-CCard;3-AR Charge)3
 
1
297
Numeric
11
* Transaction Type
(0-Normal; 1-Hold; 2-Quote; 3-Work Order)
1
298
Numeric
12
* Invoice Number
20
299
Char-Caps
13
PO Number
20
319
Char-Caps
14
Ship Via Code
6
339
Char-Caps
15
* Department Code
6
345
Char-Caps
16
Salesperson Code
6
351
Char-Caps
17
Sales Tax Code
6
357
Char-Caps
18
Terms Code
6
363
Char-Caps
19
Discount Code (AR)
6
369
Char-Caps
20
Check Number
15
375
Char-Caps
21
Check Authorization
20
390
Character
22
Check Account Number
20
410
Char-Caps
23
Check Routing Number
15
430
Char-Caps
24
Check Driver’s Lic No
15
445
Char-Caps
25
Credit Card Code
6
460
Char-Caps
26
Credit Card Authorization
20
466
Character
27
* Invoice Date
10
486
Date
28
Order Date
10
496
Date
29
Shipping Date
10
506
Date
30
User Defined Field 1
50
516
Character
31
User Defined Field 2
50
566
Character
32
User Defined Field 3
16
616
Numeric
33
User Defined Field 4
16
632
Numeric
34
User Defined Field 5
10
648
Date
35
Printed Flag
(1=Yes, 0=No)4
 
1
658
Numeric
36
Shipping Phone
50
659
Character
37
Shipping Fax
50
709
Character
38
Payer
50
759
Character
39
End of Record
 
809
 

1 This number is for reference purposes only and will not appear in the actual text file.

2 If you enter a country code that is not in the preset list in Denali, the address formatting will default to the USA standards.

3 If you did not allow certain payment types to be accepted, you will still be able to import any payment type. The Allowable Payment Type function only operates in the Sales Order Entry window.

4 A blank entry will be treated the same as “0” or No

Published date: 06/04/2021