Appendix > Appendix > Format Requirements for Importing Transactions > Order Entry File Format Requirements > External File Format Requirements for the OE Transaction Detail
External File Format Requirements for the OE Transaction Detail
The table below contains the external file format requirements for the OE Transaction Detail.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Field Length
Character Position (Fixed- Length Format)
Data Type
39
* Detail Identifier
1
1
Char-Caps Type = “D”
40
* Line Type
2
2
Numeric
41
* Stock/Code2
 
50
4
Char-Caps
42
Stock Location
50
54
Char-Caps
43
Description
50
104
Character
44
Sales Dept Code
6
154
Char-Caps
45
Salesperson Code
6
160
Char-Caps
46
Sales Tax Code
6
166
Char-Caps
47
Comment Code
6
172
Char-Caps
48
* Taxable
(1=Yes, 0=No)3
 
1
178
Numeric
49
Promotional Code
20
179
Char-Caps
50
Discount Code (IN)
6
199
Numeric
51
Discount %
8
205
Numeric
52
Quantity Ordered
14
213
Numeric
53
Quantity Shipped
14
227
Numeric
54
Quantity Back Ord
14
241
Numeric
55
Unit Price
14
255
Numeric
56
Promotional Price
14
269
Numeric
57
Serial Number
20
283
Char-Caps
58
User Defined 1
50
303
Character
59
User Defined 2
50
353
Character
60
User Defined 3
16
403
Numeric
61
User Defined 4
16
419
Numeric
62
User Defined 5
10
435
Date
63
Misc. Price
14
445
Numeric
64
For Lease
(1=Yes, 0=No)
1
459
Numeric
65
Term Start Date
10
460
Date
66
Term Expiration Date
10
470
Date
67
End of Record
 
480
 

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

2 For all Transaction Types, except type 2, 9, or 12, the Stock Code field requires a valid Stock Number or Non-Inventory Code.

3 The Taxable field defaults to “N” if left blank. If these transactions are to be taxed, the “Y” must be included and a valid Sales Tax Code must be imported.

 
 
Published date: 06/04/2021