Common Fields Used in Taiwan

Many of the fields on the forms on which you enter GUI/VAT information are the same. This table lists many of the fields in which you enter information:

Dclr Co (declaration company)

Enter the company number of the company for which the transaction occurred.

Dclr Site (declaration site)

Enter a value that exists in the Declaration Site (75T/DS) UDC table to specify the declaration site for which you file the declaration.

Dclr YM (declaration year and month)

Enter the Taiwanese year and month for which you report the transaction.

Trans. No. From (transaction number from)

Enter the beginning number in the range of GUI/VAT transaction numbers.

Seq. No. (sequence number)

The system assigns a sequence number for returns and allowances.

Auth Code (authorization code)

Enter a value that exists in the Authorization Code (75T/AC) UDC table to limit the entry of transactions for the declaration site to users who are assigned the same code.

Doc Typ (document type)

Enter a value that exists in the GUI/VAT Document Type (75TDT) UDC table to specify the document type of the transaction. Values are:

ALW: Returns or allowances

GUI: GUI

IMP: Import document

INV: Commercial invoice

OTR: Other document with VAT

SCR: Sales receipt

VPD: VAT payment document

Trans Date (transaction date)

Enter the date that the transaction was entered into the system.

G/L Date (general ledger date)

Enter the date on which the transaction is posted.

Hppn YM (happen year and month)

Enter the Taiwanese calender year and month in which the transaction occurred.

Fm Cd (format code)

Enter a value that exists in the GUI/VAT Format Code (75T/FC) UDC table to specify the format code for the transaction.

Values are:

21: Triplicate GUI / Computer GUI

22: Other document with tax amount

23: Triplicate purchase return or allowance

24: Duplicate purchase return or allowance

25: Triplicate cash register GUI

26: Summary triplicate / Computer GUI with tax

27: Summary other document with tax

28: VAT payment document

31: Triplicate / Computer GUI

32: Duplicate / Duplicate cash register GUI

33: Triplicate sales return or allowance

34: Duplicate sales return or allowance

35: Triplicate cash register GUI

36: GUI exempt

37: Special tax: sales

38: Special tax: return or allowance

99: Sales receipt

TTor Trs Typ (transaction type)

Enter a value that exists in the GUI/VAT Transaction Type (75T/TT) UDC table to specify the type of transaction. Values are:

FSV: Purchase foreign services

IDG: Imported goods

PUR: Purchase

SAL: Sales

Tx Ex (tax explanation code)

Enter a value that exists in the Tax Explanation Codes (00/EX) UDC table to specify the tax explanation code for the transaction. The tax explanation code for VAT must be V.

Tax Area

Enter the code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code that you enter against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax and general ledger distribution amounts when you create an invoice or voucher.

Tax Rate 1

Enter a number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.

Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.

Base Cur (base currency)

Enter a value that exists in the Currency Exchange Rates table (F0015) to specify the currency code of the company that originates the transaction.

Taxable Amount

Enter the amount on which the tax is calculated.

Tax

Enter the amount of the tax.

Gross Amount

Enter the total of the taxable amount and the tax.

Exchange Rate

Enter the value by which the foreign currency amount is multiplied to convert foreign currency to the equivalent domestic currency.

Foreign Taxable Amt (foreign taxable amount)

Enter the taxable amount in the foreign currency if the transaction occurred in a foreign currency.

Foreign Tax

Enter the tax amount in the foreign currency if the transaction occurred in a foreign currency.

Foreign Gross Amount

Enter the total of the taxable amount and the tax in the foreign currency if the transaction occurred in a foreign currency.

Register No. From (register number from)

Enter the beginning number of a range of receipt register numbers.

Segment No. From (segment number from)

Enter the beginning number of a range of segment numbers.

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

Enter the beginning number in a range of GUI/VAT numbers.

GUI/VAT No. To (GUI/VAT number to)

The system provides a value for this field.

Trans No. To (transaction number to)

The system provides a value for this field.

SN (summary note)

Enter a value that exists in the GUI/VAT Summary Note (75T/SN) UDC table to specify whether a record is a summary record. Values are:

Blank: Not a summary record.

A: Summary record

Doc Count (document count)

Enter the number of documents for the transaction.

Sal Item (sales item type)

Enter a value that exists in the GUI/VAT Sales Item Type (75T/ST) UDC table to specify the type of item sold. Values are:

Blank: General sales item

1: Land

2: Other fixed asset

DU (deduction usage)

Enter a value that exists in the Deduction Usage (75T/DD) UDC table to specify the deduction usage code. Values are:

Blank: No deduction

1: Machine equipment

2: Raw materials

3: Part materials

4: Fuel

5: Semi-finished goods

Proof Doc Name (proof document name)

Enter a value that exists in the GUI/VAT Proof Document Name (75T/PD) UDC table to specify the name of the document that proves that an exported item did not go through customs. Examples are:

BOE: Exchange memo

DFE: Declaration for exportation

GUI: Deduction copy of GUI

Proof Doc Number (proof document number)

Enter the number of the document that proves that an exported item did not go through customs.

EM (exportation method)

Enter a value that exists in the Exportation Method (75T/EX) UDC table to specify the exportation method. Values are:

Blank: Not exported

1: Export method 1

2: Export method 2

3: Export method 3

4: Export method 4

5: Export method 5

6: Export method 6

7: Export method 7

ED Ty (export declaration type)

Enter a value that exists in the Ex. Declare Type (75T/EP) UDC table to specify the export declaration type. Values are:

Blank: No export declaration type

B1: Export declare type B1

B2: Export declare type B2

B8: Export declare type B8

B9: Export declare type B9

D1: Export declare type D1

D3: Export declare type D3

D4: Export declare type D4

D5: Export declare type D5

D9: Export declare type D9

Exportation Doc. No. (exportation document number)

Enter the document number of the declaration for exportation.

Export Date

Enter the date that the item was exported.

Rev Typ (revenue type)

Enter a value that exists in the GUI/VAT Revenue Type (75T/RT) to specify the type of revenue received. Examples are:

R01: Sales revenue

R02: Commission revenue

Spc Tax (special tax)

Enter a value that exists in the GUI/VAT Special Tax Type (75T/SP) UDC table to specify whether a special tax rate applies to the transaction. Values are:

Blank: No special tax

1: Special food and beverage service, hostesses provided

2: Special food and beverage service, providing show programs

3: Banking, authorized business

4: Reinsurance

5: Banking, non-authorized business

Sold To Number

Enter the customer number. For point-of-sale (POS) transactions, this number is often a generic customer number.

Invoice To Number

Enter the customer number associated with the location to which the invoice is sent. For POS transactions, use the same value as you entered in the Sold To Number field or leave this field blank.

Ship To Number

Enter the customer number associated with the location to which you ship the goods sold. For POS transactions, use the same value as you entered in the Sold To Number field or leave this field blank.

Alpha Name

The system completes this field with the name of the customer.

Prtnr UN (business partner uniform number)

Enter the uniform number of the business partner. For POS transactions, leave this field blank.

MT (merged transactions)

Specify whether the GUI/VAT transaction was created from multiple invoices or sales orders. Values are:

0: Not merged

1: Merged

Doc Co (document company)

Enter the document company of the transaction.

Doc Type (document type)

Enter a value that exists in the Document Type (00/DT) UDC table to specify the document type for which the general ledger entry exists.

Doc Number (document number)

Enter the document number of the original transaction, such as the journal entry created for the POS transactions.

Batch Number

Enter the batch number of the posted transaction.

Order Co (order company)

Enter the company number of the company that originated the transaction.

Order Ty (order type)

Enter the order type of the original transaction.

Order Number

Enter the number of the original voucher, invoice, journal entry or other document.

Order Suf (order suffix)

Enter the pay item number.

Item Description

Enter the item description.

Quantity Ordered

Enter the quantity.

CC 1 (category code 1)

Enter a value that exists in the GUI/VAT Cat. Code 1 - Segment (75T/C1) UDC table to associate additional information to the segment number.

CC 2 (category code 2)

Enter a value that exists in the GUI/VAT Cat. Code 2 - Segment (75T/C2) UDC table to associate additional information to the segment number.

CC 3 (category code 3)

Enter a value that exists in the GUI/VAT Cat. Code 3 - Segment (75T/C3) UDC table to associate additional information to the segment number.

CC 4 (category code 4)

Enter a value that exists in the GUI/VAT Cat. Code 4 - Customer (75T/C4) UDC table to associate additional information to the customer.

CC 5 (category code 5)

Enter a value that exists in the GUI/VAT Cat. Code 5 - Customer (75T/C5) UDC table to associate additional information to the customer.

CC 6 (category code 6)

Enter a value that exists in the GUI/VAT Cat. Code 6 - Customer (75T/C6) UDC table to associate additional information to the customer.

Prt Cnt (print count)

Enter the number of GUIs printed.

Sales Person

Enter the sales person ID number.

Cash Register

Enter the cash register ID number.

Citizenship ID

Enter the citizenship number of an individual.

Credit Card Number

Enter the credit card number used for the transaction.

Payment Type

Enter the type of payment, such as cash, check, or credit card.

PS (prepayment status)

Enter a value that exists in the GUI/VAT Prepayment Status (75T/PS) UDC table to specify if a transaction is a prepayment. Values are:

Blank or 0: Not a prepayment

1: Prepayment, not delivered

2: Prepayment, item delivered

Prepay Balance

Enter the remaining balance to be paid.

Ln ID (line ID)

Enter the transaction line ID or sequence line ID of the GUI/VAT transaction.

Short Item No (short item number)

The JD Edwards EnterpriseOne system enables you to create three different item numbers. Enter the short item number.

2nd Item Number

The JD Edwards EnterpriseOne system enables you to create three different item numbers. Enter the 2nd item number.

3rd Item Number

The JD Edwards EnterpriseOne system enables you to create three different item numbers. Enter the 3rd item number.

Description

Enter the description of the item.

UM (unit of measure)

Enter a value that exists in the Unit of Measure (00/UM) UDC table to specify the unit of measure for the item.

Quantity Ordered

Enter the quantity of the item.

Taxable

Enter a value that exists in the H00/TV UDC table to specify whether the item is taxable.

Base Curr (base currency)

Enter a value that exists in the Currency Codes table (F0013) to specify the currency of the transaction.

Unit Price

Enter the list or base price to be charged for one unit of this item.

Pay Item

Enter the sequence number of the line on the voucher.

Pay Ext (pay extension)

Enter the code to designate an adjusting entry to a pay item on a voucher or invoice.

Line Number

Enter the number assigned to the line in the transaction record.

TT (tax type)

Enter a value that exists in the GUI/VAT Tax Type (75T/TX) UDC table to specify whether the GUI number is assigned to a taxable transaction. Values are:

Blank: Transaction type is IGD or FSV

1: Taxable (General/Special)

2: Zero tax rate

3: Tax-exempt

D: Unused

F: Void

User Code