In this release, Expedient has introduced a load function that enables users to create/update/delete TLF via the load process.
The function can be accessed via the path below. You can load the TLF file by csv, xls or xlsx format.
Customs Processing -> Tools -> Load TLF File
Features
- The process allows you to have a column heading. If you contain a column heading on the load file, the process will ignore line 1 (column heading line).
- The process is able to assign a new TLF code automatically when TLF record is created. In order to do that, you have to ensure the “Auto generate TLF code” option is clicked. The TLF will be created with the format “Tariff Head + 3 characters”. e.g. 3919AAB.
- You can create your own load template by
- clicking “Edit” and modify the template
- clicking “OK” to go to the main Load screen.
- clicking “Save” or “Save As” to save your template.
-
| The field in Load Screen | The field in TLF Masterfile | Mandatory/Optional | Mapping Rules |
| * TLF Code | TLF Code | Mandatory | Max 7 characters are allowed as TLF Code. No space or special characters are allowed on the field. |
| * Tariff Code | Tariff Code | Mandatory | The process validates Tariff Code. Only the valid Tariff Code (The value is in the customs reference file) is allowed to load into TLF Masterfile. |
| Concession Code | Concession Code | Mandatory | The process validates Concession Code. Only the valid Concession Code (The value is in the customs reference file) is allowed to load into TLF Masterfile. |
| * TLF Description | Description | Optional | This is a free text field. |
| Code (Permit Authority) | Code (Permit Authority) | Optional | The field allows you to enter Permit Authority Code. |
| Code (Other Information) | Code (Other Information) | Optional | The field allows you to enter Permit Other Information Code. |
| Code (Prohibited Goods) | Code (Prohibited Goods) | Optional | The field allows you to enter Prohibited Goods Code. |
| Code (Commodity) | Code (Commodity) | Optional | The field allows you to enter Commodity Code. |
| Code (Valuation) | Code (Valuation) | Optional | The field allows you to enter Valuation Code. |
| Code (Party) | Code (Party) | Optional | The field allows you to enter Party Code. |
| Delete TLF Indicator | Optional | When the value is (Y)es, the process will delete TLF Record. |