Considerations for Importing POS Detail Data

To import POS detail data from a spreadsheet, you must create a spreadsheet that contains columns for each of the data items. The columns must appear in the same order as the fields on the GUI/VAT Detail POS Interface Revisions form.

Fields are:

• Ln ID (line ID)

• Short Item No (short item number)

• 2nd Item Number

• 3rd Item Number

• Description

• UM (unit of measure)

• Quantity Ordered

• Taxable

• Tx Ex (tax explanation code)

• Tax Area

• Base Curr (base currency)

• Unit Price

• Taxable Amount

• Tax

• Gross Amount

• Cur Cod (currency code)

• Exchange Rate

• Foreign Unit Price

• Foreign Taxable Amount

• Foreign Tax

• Foreign Gross Amt (foreign gross amount)

• Doc Co (document company)

• Doc Ty (document type)

• Doc Number (document number)

• Pay Itm (pay item)

• Pay Ext (pay extension)

• Order Co (order company)

• Order Ty (order type)

• Order Number

• Order Suf (order suffix)

• Line Number

• TT (tax type)

• User Code

• User Date

• User Amount

• User Number

• User Reference

• User ID

• Program ID

• Work Stn ID (work station ID)

• Date Updated

• Time of Day