In this release, Expedient has introduced a load function that enables users to create/update/delete import 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 Import 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.
- The process allows you to load TLF file with Tariff & Stat as combined value. e.g. 8431100027, if you select “Tariff & Stat Code as combined” option.
- 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 process will validate the following fields and automatically add “leading 0” if it’s not included on the file.
-
- Tariff and Stat
- Instrument No
- RNO
| The field in Load Screen | The field in TLF Masterfile | Mandatory/Optional | Mapping Rules |
| *TLF Code | TLF | Mandatory | Max 7 characters are allowed as TLF Code. No space or special characters are allowed on the field. |
| *TLF Description | Description | Mandatory | This is a free text field. |
| *Tariff / Stat | Tariff / Stat | Mandatory | The process validates tariff & Stat. Only the valid Tariff Stat ( The value is in the customs reference file) is allowed to load into TLF Masterfile. The field will ignore any space or special characters, and also the process will add “leading 0” if it’s not included on the load file. |
| TRT (Treatment Code) | TRT | Optional | The process validates the TRT. |
| Instrument Type | Instr. Type | Optional | The process validates the Instrument Type. |
| Instrument No | Instrument | Optional | The process validates the Instrument Number based on the customs reference file. If the “leading 0” is not included on the load file, the process will add 0 automatically based on the reference file. e.g. if the instrument number entered is 71, the process will convert it to 0000071. |
| RNO | RNO | Optional | The process validates RNO based on the customs reference file. If the “leading 0” is not included on the load file, the process will add 0 automatically based on the reference file. e.g. if the RNO entered is 44, the process will convert it 044. Note: if RNO is 001, it will not be loaded, as it’s an ICS default rate. |
| Export TLF | Export TLF | Optional | The process validates the Export TLF. |
| Approved By | Approved | Optional | You can enter approved user on the field. |
| Approved Date | Date | Optional | You can enter the approved date on the field. The following date format is accepted. DD/MM/YYYY (With or without leading 0 on Day or Month) DD/MM/YY (With or without leading 0 on Day or Month) DD-MM-YYYY (With or without leading 0 on Day or Month) DD-MM-YY (With or without leading 0 on Day or Month) |
| Delete TLF Indicator | Optional | When the value is (Y)es, the process will delete TLF Record. |