FTZ Management: Preparation - FIFO Staging Correction
Data successfully imported during the Load Integration Files step will move to the staging tables. The
FIFO Staging Correction
screen allows you to view and edit transactions before moving the transactions to production. This screen can be accessed by choosing FIFO Staging Correction
from the Preparation
menu.To filter staging transactions:
- Choose a filter option from theFilter bydrop-down, then specify the search criteria in theshowdrop-down.
- If the search results need to be filtered further, use the secondFilter byandshowdrop-down. The second filter line is optional.
Update a Staging Transaction
To update a transaction:
- Choose a transaction from the table and clickEditto open theEnter Staging Transactionsscreen.
- Make any necessary changes in the fields below, and then clickSaveat the top of the screen.
- You will be redirected to theEnter Staging Transactionsscreen. A validation message will appear above the table, confirming the change successfully saved.
Source Fields and Default Sources
Many of the fields in the FIFO transaction tables (txdFIFOProcessing/HTSValues) have source fields for the data elements that can be utilized to pull the data from various maintenance tables:
SOURCE FIELD | DATA SOURCE |
|---|---|
I | Item Master |
M | Manufacturer ID |
H | HS Codes |
C | Item Master Custom Rules |
P | Pre Receipts |
(Blank) | User Company’s ERP System |
You can edit data in
FIFO Processing
or Transaction Correction
to set ‘Default Sources’ for any of the following source fields. Default Source = I (tmdItemMaster/HTSValues) |
|---|
ProductTypeCodeSource |
ProductDescSource |
NaftaCertifiedSource |
TxnQtyUomSource |
WeightSource |
WeightUomSource |
StatusCodeSource |
CountryOfOriginSource |
ManufacturerIDSource |
HtsIndexSource |
HtsNum2Source |
ValueSource |
Value2Source |
CurrencyCodeSource |
AltValueSource |
AltValue2Source |
AltCurrencyCodeSource |
HtsUomConvFactorSource |
AddlHtsUomConvFactorSource |
ADDutyRateSource |
CVDutyRateSource |
RCO21Source |
RCO22Source |
RCO23Source |
ReceiptSupplementSource |
RPO11Source |
RPO12Source |
RPO13Source |
DEFAULT SOURCE = H (TMDHTS) |
|---|
HtsNumSource |
SpiCode1Source |
SpiCode2Source |
HtsDescSource |
AdValoremRateSource |
SpecificRateSource |
RptQtyUomSource |
AddlRptQtyUomSource |
AddlSpecificRateSource |
Default Source = M (tmfManufacturer) |
|---|
RelationshipFlagSource |
Note that for positive adjustments (i.e., transactions with TxnCode = ‘APPC’ or ‘APIM’), the system will utilize the Default Source (superseding the Source Field value) for data elements that are relevant to the CBP, such as:
- CountryOfOriginSource
- HtsNumSource
- ManufacturerIDSource
- ValueSource
The following fields are "open" fields that can hold additional FIFO transaction date elements. These allow you to work with the Thomson Reuters implementation team to decide which fields will be of greatest use to your business environment.
Open parent record fields (txdFIFOProcessing) | Open child record fields (txdFIFOProcessingHTSValues) |
|---|---|
RPO11 | RCO21 |
RPO12 | RCO22 |
RPO13 | RCO23 |
Related Content
-
FTZ Management: Preparation - Loading Integration Files and File Load Manager
Format:
Article,
3 min read
-
FTZ Management: e214 - Understading the Process
Format:
Article,
1 min read