Considerations for Importing Customer Constants for Taiwan

To import customer constants from a spreadsheet, you must create a spreadsheet that contains these columns in the order specified:

1. Customer Number

2. Company

3. GUI Customer Type

4. Customer Uniform Number

5. Sales Item Type

6. Special Tax Item Type

7. Category Code 4 - Customer

8. Category Code 5 - Customer

9. Category Code 6 - Customer

10. GUI Format Code 1

11. GUI Format Code 2

12. Zero Tax Rate Item Type

13. Deduction Usage

14. In Bond Flag

15. GUI Format Code 3

16. User Code

17. User Date

18. User Amount

19. User Number

20. User Reference

21. User ID

22. Program ID

23. Work Station ID

24. Date Updated

25. Time of Day

26. e-GUI Mode

For information about the valid values for each column, see the corresponding fields on the GUI/VAT Customer Constants Revisions form.

The columns that should be completed depend on the value in the CT (Customer Type) column:

• For a customer type of 1 (Domestic Customer), complete these columns only if the value in the In Bond Flag field is Y:

  • GUI Format Code 2

  • Zero Tax Rate Item Type

  • Usage Description About Deduction Copy

• For a customer type of 2 (Domestic Individual Person), leave these columns blank:

  • Customer Uniform Number

  • GUI Format Code 2

  • Zero Tax Rate Item Type

  • Usage Description About Deduction Copy

• For a customer type of 3 (Foreign Customer), leave these columns blank:

  • Customer Uniform Number

  • GUI Format Code 1

  • Deduction Usage

Note: Enter N in the In Bond Flag column for customer type 2 and customer type 3.