Scrub Transactions
The
Scrub Transactions
screen is used for cleaning up the week’s imported transactions.This screen can be opened by choosing
Scrub Transactions
from the Processing
menu.The scrubbing process is a review of imported period transactions from the refinery. This review process assists in identifying data anomalies such as:
- The Provided API is outside the acceptable range set in the Product Master.
- The Provided Weight is outside the tolerance range set in the System Defaults when weight is recalculated using the transaction volume and API.
Each scrubbing type is listed and has a matching column associated with it, identifying the number of records that need to be adjusted based on the scrubbing error.

Scrub Types
Transactions using inactive products will be defined by the
Inactive Product Number
error. This error is resolved by changing the product status in the Product Master
Maintenance table.
Duplicates, Offsetting, and Weight errors can be deleted or modified by you as needed.

API Value errors must be addressed either by:
- Editing the transaction so the API is within the acceptable range
- Editing the API range for the product in theProduct MasterMaintenance table

Date errors are defined as
Transaction Date in Previous Week
for transactions where the date appears to be in the previous week, or Transaction Date in the Future Week
. Previous date errors can be edited. However, transactions with future date errors cannot be processed because they have not yet occurred.
214 errors include transactions appearing on the
214 Match – 214 within period with no matching Transaction Downloaded
error. There are two ways to resolve this error type, as listed below. This resolution process also applies to the 7512 Match – 7512 within period with no matching Transaction Downloaded
error.- Edit the transaction so it matches an entered 214 in weight, volume, and API.
- Edit the transaction to indicate the status should beDfor Domestic because the product normally produced in a foreign country was domestically sourced or entered as an immediate duty pay receipt.
The system will perform a validation check on the duty paid foreign crude. This is done to ensure that you do not accidentally miss or overlook a 214 FTZ Admission. On the Receipts without a 214, the receipt will appear. In this case, the system expects the crude to arrive in foreign status. If the crude was in fact duty paid, change the status to
D
by editing the line of the receipt.
Processing
After all transactions are verified, click
Process
to begin processing the transactions. This action completes the import of the transactions and performs an additional verification of the product master data for the transaction.
If an error message is received during the processing of the transactions, address the message by updating the indicated production information. Upon correcting the issue, return to the
Scrub Transaction
screen and click Process
again.When a 214 has multiple status designations, there should be only one receipt transaction in the interface file for the total volume of the 214. This one receipt transaction will be matched to the 214, and each status (with the appropriate volume) can be seen on the
Transaction Scrubbing
screen when the receipt transaction is matched to the 214.If multiple transactions are included in the interface file, the
Scrub Transactions
screen will show duplicates of the individual statuses and the corresponding volume of that status. Should this occur, do not attempt to delete one of the duplicate lines. Doing so will delete the entire interfaced receipt transaction.The weekly interface file is not considered interfaced until the file has been loaded AND scrubbed. The control file total will not match until the transactions have completed scrubbing by having you press the
Process
button.Document Stage
There are four stages in which a 214 may be given at any time. The stage indicated on the
CBP 214 Zone Admission
screen will print on the bottom of the system-generated 214 FTZ Admission form. The form stage can be changed in the 214 FTZ Admission
form in the Forms
menu by choosing a different stage button and clicking Save
or Generate
.Document stage | Description |
|---|---|
Preliminary | A 214 in this stage may or may not have been submitted to CBP but is not considered when matching receipt transactions to 214s. |
Final | A 214 in this stage is being presented to CBP and is ready to match with a receipt transaction. |
Amended Final | When updated values are determined and after final measuring of the receipt has occurred; the 214 fields can be updated, and the document should be updated to this stage. |
Cancel | If a receipt is no longer destined for the zone, the 214 can be cancelled. After the 214 has been matched with an interface record, the 214 cannot be canceled or returned to the preliminary stage. |
