Considerations for Importing Supplier Constants for Taiwan

To import suppliers' constants from a spreadsheet, you must create a spreadsheet that contains the required columns in this order:

1. Supplier Number

2. Supplier Uniform Number

3. GUI Format Code

4. In Bond Flag

5. Deduction Code

6. Purchase Item Type

7. Import Item Type

   Note: Complete the Import Item Type column only if you left the GUI Format Code column blank to specify import goods or foreign service.

8. Purchase Usage

9. Category Code 7 - Supplier

10. Category Code 8 - Supplier

11. Category Code 9 - Supplier

12. User Code

13. User Date

14. User Amount

15. User Number

16. User Reference

17. User ID

18. Program ID

19. Work Station ID

20. Date Updated

21. Time of Day

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