1. Localizations for Taiwan Implementation Guide
  2. Considerations for Importing POS Header Data

Considerations for Importing POS Header Data

To import POS header 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 Header POS Interface Revisions form, and you must provide a column in the spreadsheet for every field, even if you do not include data for the field. You must provide the header data for each POS transaction, either by importing the data or by manually entering the information.

Fields are:

  • Dclr Co (declaration company)

  • Dclr Site (declaration site)

  • Dclr YM (declaration year and month)

  • Trans. No. From (transaction number from)

  • Seq. No. (sequence number)

  • Auth Code (authorization code)

  • Trs Typ (transaction type)

  • Doc Typ (document type)

  • Trans Date (transaction date)

  • G/L Date (general ledger date)

  • Hppn YM (year and month in which the transaction occurred)

  • Fm Cd (format code)

  • TT (tax type)

  • Tx Ex (tax explanation code)

  • Tax Area

  • Tax Rate

  • Base Curr (base currency)

  • Taxable Amount

  • Tax

  • Gross Amount

  • Cur Code (currency code)

  • Exchange Rate

  • Foreign Taxable Amt (foreign taxable amount)

  • Foreign Tax

  • Foreign Gross Amt (foreign gross amount)

  • UI PF (GUI prefix)

  • Register No. From (register number from)

  • Segment No. From (segment number from)

  • GUI/VAT No. From (GUI/VAT number from)

  • GUI/VAT No. To (leave this field blank)

  • Trans. No. To (leave this field blank)

  • SN (summary note)

  • Doc. Count (document count)

  • Sal Itm (sales item type)

  • Zr Tx (zero tax rate item type)

  • DU (deduction usage code)

  • Proof Doc Name (proof document name)

  • Proof Doc Number (proof document number)

  • EM (exportation method)

  • ED Ty (export declaration type)

  • Exportation Doc. No. (exportation document number)

  • Export Date

  • Rev Typ (revenue type)

  • Spc Tax (special tax type)

  • Sold To Number

  • Invoice To Number

  • Ship To Number

  • Alpha Name

  • Prtnr UN (uniform number of business partner)

  • MT (merged transactions)

  • Doc Co (document company)

  • Doc Ty (document type)

  • Doc Number (document number)

  • Batch Number

  • Order Co (order company)

  • Order Ty (order type)

  • Order Number

  • Order Suf (order suffix)

  • Item Description

  • Quantity Ordered

  • CC 1 (category code 1)

  • CC 2 (category code 2)

  • CC 3 (category code 3)

  • CC 4 (category code 4)

  • CC 5 (category code 5)

  • CC 6 (category code 6)

  • Prt Cnt (printer count)

  • Creator ID (leave this field blank)

  • Sales Person

  • Cash Register

  • Citizenship ID

  • Credit Card Number

  • Payment Type

  • PS (prepayment status)

  • Prepay Balance

  • Dat Gen (data generation) (leave this field blank)

  • Remarks

  • User Code

  • User Date

  • User Amount

  • User Reference

  • User ID

  • Program ID

  • Work Stn ID (work station ID)

  • Date Updated

  • Time of Day