|
1.*
|
Transaction Number
|
OETLTRNUM
|
Numeric
|
5
|
R:1-99999
|
|
2.*
|
Detail Line Number
|
OETLDETAIL
|
Numeric
|
4
|
R:1-9999
|
|
3.*
|
Line Type
Invoice Sale Line Types: 0=Deleted, 1=Non-Inventory, 2=Special Order, 3=Inventory, 4=BOM Comment (Kit Element), 6=Job Cost, 9=Comment Line, 11=Return of Non-Inventory, 12=Return of Special Order, 13=Return of Inventory, 14=Serial Number description
|
OETLLTYPE
|
Numeric
|
2
|
|
|
4.~
|
Stock Item Number
|
OETLSTK
|
CharCaps
|
20
|
|
|
5.
|
Location
|
OETLSTKLOC
|
Character
|
20
|
|
|
6.
|
Description
|
OETLDES
|
Character
|
45
|
|
|
7.~
|
Sales Category (Dept) Code
|
OETLCOCD
|
CharCaps
|
2
|
|
|
8.~
|
Salesperson Code
|
OETLSPCD
|
CharCaps
|
3
|
|
|
9.
|
IN Default Vendor
|
OETLVND
|
CharCaps
|
20
|
|
|
10.
|
Discount Code (Right Half)
|
OETLDICD
|
CharCaps
|
2
|
|
|
11.
|
Inventory Code
|
OETLINCD
|
CharCaps
|
2
|
|
|
12.
|
Product Type
|
OETLINTY
|
CharCaps
|
15
|
|
|
13.~
|
Tax Code
|
OETLTXCD
|
CharCaps
|
6
|
|
|
14.~
|
CC Code
|
OETLCC
|
CharCaps
|
4
|
|
|
15.
|
Taxable Flag
0=No, 1=Yes
|
OETLTAX
|
Numeric
|
1
|
R:0-1
|
|
16.~
|
Promotional Code
|
OETLPROMO
|
CharCaps
|
10
|
|
|
17.
|
Posting Status
|
OETLPOST
|
Numeric
|
3
|
R:0-255
|
|
18.
|
Transaction Date
|
OETLDATE
|
Date
|
|
R:same as header
|
|
19.
|
Discount Percent
|
OETLDIPC
|
Numeric
|
8
|
(3.4) R:0-100
|
|
20.
|
Quantity Ordered
|
OETLOQTY
|
Numeric
|
14
|
(8.4) R:+/-
|
|
21.
|
Quantity Shipped
|
OETLSQTY
|
Numeric
|
14
|
(8.4) R:+/-
|
|
22.
|
Quantity Backordered
|
OETLBQTY
|
Numeric
|
14
|
(8.4) R:+/-
|
|
23.
|
Unit Price -before discount
|
OETLPRICE
|
Numeric
|
14
|
(9.4) R:0->
|
|
24.
|
Extended Unit Price -after discount
|
OETLEXT
|
Numeric
|
14
|
(9.4) R:0->
|
|
25.
|
Total Cost (Not Unit Cost)
|
OETLTCOST
|
Numeric
|
14
|
(9.4) R:0->
|
|
26.
|
Last Unit Cost
|
OETLLCOST
|
Numeric
|
14
|
(9.4) R:0->
|
|
27.
|
Standard Cost
|
OETLSTAN
|
Numeric
|
14
|
(9.4) R:0->
|
|
28.
|
Inventory Price #1
|
OETLPRI1
|
Numeric
|
14
|
(9.4) R:0->
|
|
29.
|
Promotional Price
|
OETLPRI2
|
Numeric
|
14
|
(9.4) R:0->
|
|
30.~
|
Serial Number
|
OETLSER
|
CharCaps
|
20
|
|
|
31.
|
Ending Serial Number (Unused)
|
OETLENDSER
|
CharCaps
|
20
|
|
|
32.
|
Special Order GL Acct (Unused)
|
OETLACCT
|
CharCaps
|
30
|
|
|
33.
|
Sales Tax Amount
|
OETLTAXAMT
|
Numeric
|
14
|
(9.4) R:0->
|
|
34.
|
User Defined Field 1
|
OETLDUDF1
|
Character
|
30
|
|
|
35.
|
User Defined Field 2
|
OETLDUDF2
|
Character
|
30
|
|
|
36.
|
User Defined Field 3
|
OETLDUDF3
|
Numeric
|
17
|
(11.4) R:+/-
|
|
37.
|
User Defined Field 4
|
OETLDUDF4
|
Numeric
|
17
|
(11.4) R:+/-
|
|
38.
|
User Defined Field 5
|
OETLDUDF5
|
Date
|
|
R:any date
|
|
39.
|
Unique Comment Identifier
|
OETLCOM
|
Numeric
|
3
|
R:0-999
|
|
40.*
|
Batch Number
|
OETLBNUM
|
CharCaps
|
3
|
|
|
41.
|
Qty to Take Off Back Order
|
OETLBOQTY
|
Numeric
|
14
|
(8.4) R:+/-
|
|
42.
|
Misc. Charge
|
OETLMSCCHG
|
Numeric
|
14
|
(8.4) R:+/-
|
|
43.
|
BOM Detail Qty.
|
OETLBOMQTY
|
Numeric
|
14
|
(8.4) R:+/-
|
|
44.
|
Analysis Amount (Unused)
|
OETLANLSYS
|
Numeric
|
6
|
(3.2) R:0-100
|
|
45.
|
Net Amount (Unused)
|
OETLNET
|
Numeric
|
11
|
R:0->
|
|
46.
|
Unit Package
|
OETLUNITPK
|
Character
|
10
|
|
|
47.
|
Discountable Flag (Unused)
|
OETLDSCNT
|
Numeric
|
1
|
R:0/1
|
|
48.
|
UPC Code (Unused)
|
OETLUPC
|
Character
|
20
|
|
|
49.
|
Freight Amount (Unused)
|
OETLFRAMT
|
Numeric
|
14
|
|
|
50.
|
STC Amount (Unused)
|
OETLSTCAMT
|
Numeric
|
14
|
|
|
51.
|
Base Price
|
OETLBASE
|
Numeric
|
14
|
(8.4) R:+/-
|
|
52.
|
Original Price
|
OETLORGPRC
|
Numeric
|
14
|
(8.4) R:+/-
|
|
53.
|
BOM Parent Flag
|
OETLBOMPAR
|
Numeric
|
2
|
|
|
54.
|
Sub BOM Flag
|
OETLSUBBOM
|
Numeric
|
2
|
|
|
55.
|
BOM Association Identifier
|
OETLBMASOC
|
Character
|
50
|
|
.jpg)
