Overview
This database stores importer-specific product data — including descriptions, HTS codes, values, units of measure, country of origin, and more. Using accurate, client-provided SKUs/part numbers ensures consistency and compliance.
Best Practice: Use the SKU or Part Number from the client’s Commercial Invoice or Packing List. This eliminates discrepancies and supports audit traceability.
Where parts Are Used
- Entry Summary (7501)
- Cargo Release
- In-Bond (QP/WP)
- FTZ Admissions (e214)
- AES/EEI Filings
- Warehouse Receipts
- Proforma Entry
Primarily designed for perishable agricultural products (produce), this shared database contains standardized commodity descriptions, FDA codes, growing seasons, and packaging types. It can be used by any importer for consistency in proforma and regulatory reporting.
Description: Manual entry via dedicated maintenance screen (Parts Master).
Best For: One-off or low-volume additions; full control over all fields.
Description: Add standardized produce items from the shared Commodity library.
Best For: Fruits, vegetables, and FDA-regulated perishables.
Description: Bulk upload using pre-formatted Excel templates.
Best For: New importers, catalog updates, or seasonal refreshes.
Description: Ap on-the-fly during entry creation; system prompts to save new part.
Best For: Ad-hoc or first-time shipments with new SKUs.
Main Screen
The Part Number Entry – Main Screen stores the customer-specific Part Number (SKU), commercial description, default unit of measure and basic pricing information. These values are used whenever the part is entered when entering line information in various modules. Such as, 7501 Line Items, Cargo Release Line Item, FTZ, Warehouse, ISF or Inbonds.
From the Parts / SKU Master menu, enter or look up a Customer Name and Part Number to open or create a record. Use the (N)ext Screen prompt at the bottom to move to HTS Classification, or (P)ost to save the part once all screens are complete.
Fields
- Customer Name
- Customer account number and name that owns this part/SKU (e.g., 1474 ACME INTERNATIONAL INC.). Each customer–part combination is stored separately.
- Part Number
-
Customer’s internal part number or SKU (e.g.,
SKU12345) used when entering line information. - 1–n. Description Lines
- Free-form commercial description for the product, matching the wording used on invoices (e.g., PARTICLE BOARDS). Additional lines may be used as needed.
- 3. Unit of Measure
-
Default selling or reporting unit for the item (e.g.,
NOfor “number”,KGS,CTN). This should match the unit shown on the commercial invoice. Enter / to see the list. - 4. Uom Factor
- Optional conversion factor between the invoice unit and an internal or inventory unit. Site-specific usage; may be left blank if not used at your location. Only used for Landed Cost Reporting.
- 5. Measurements
- Optional dimensional or weight information (per unit) used by some sites for cubic / weight calculations or warehouse handling.
- 6. Selling Price
- Default selling price per unit. This may be used as a reference price or to pre-fill AR invoicing lines depending on your configuration. Only used for Landed Cost Reporting.
- 7. Include in LC?
- Y if this part should be included in Landed Cost calculations and reports; N if it should be excluded. Only used for Landed Cost Reporting.
Command prompts at the bottom of the screen. Use Line# to jump to a specific line, (Q)uit to exit without posting, (N)ext Screen to move to Classification, and (P)ost to save the part after all information is entered.
HTS Classification Screen
The Classification Screen stores default HTS, country of origin, value per unit and related regulatory data for the part. When this SKU is used on an entry, these values are pulled in automatically and can be adjusted if needed.
After completing the main screen, press (N)ext Screen to display the classification page. Use the prompts at the bottom to insert additional sub-lines, navigate pages, or open Declaration Information.
Fields
- Sub#
- Classification sub-line number (usually 1>). Additional sub-lines are used for complex items that require multiple HTS numbers.
- CO (Country of Origin)
-
Country of origin code (e.g.,
AUfor Australia). This origin will default to entry lines when the part is selected. - HTS Number
-
10-digit Harmonized Tariff Schedule number for the product (e.g.,
4410.11.0060). This is a key compliance field that drives duty and PGA rules. - Manufacturer
- Optional manufacturer code or name linked to this part. Use if you maintain manufacturer records or have manufacturer-specific rulings.
- Cls Rule No
- Optional classification ruling number or internal reference used to document how the HTS was determined.
- Item Value
-
Default value per unit for this HTS line (e.g.,
120.0000). This may be used for validation or as a starting point when invoice prices are consistent. - Eff Date
- Optional effective date for the classification, used when tracking historical changes in HTS or duty treatment.
- SPI
- Special Program Indicator (if applicable) for preference programs such as GSP or FTA codes.
- ADD Number
- Antidumping duty case number or reference when the HTS is subject to ADD.
- CVD Number
- Countervailing duty case number or reference when the HTS is subject to CVD.
- Bnd?
- Indicates whether a bond is required for this classification. Site-specific; may impact default bond selection.
- Bond Number / Surety
- Optional default bond number and surety to associate with entries for this part, if different from the customer’s standard bond.
- Ctn?
- Flag indicating whether carton-level data is required (used in some warehouse or PGA scenarios).
- Tax?
- Indicates whether local tax treatment (e.g., state tax) applies to this classification, depending on your configuration.
- Sub-Line# To modify an existing classification line
- Page to loop through pages if multiple pages exists.
- Ins, to insert a classification on the same sub-line.
- Addm to add a classification.
- Del, to delete a classification from the sub-line.
- PGA, to add PGA information if needed.
- DecClaration, to add Declaration information.
Declaration Information Screen
The Declaration Information screen stores Section 232 Aluminum and Steel Exclusion IDs or similar special declarations at the part level. When populated, these IDs are available whenever the part is used on an entry line.
From the Classification screen, select the desired sub-line and use De(C)laration to open this page. Enter the appropriate exclusion IDs or leave the fields blank if no exclusion applies, then press (B)ack to return to Classification.
Fields
- Aluminum Exclusion Id
- Exclusion ID number issued by the appropriate authority for aluminum products subject to Section 232 duties. Enter the exact ID as provided in the approval notice.
- Steel Exclusion Id
- Exclusion ID number for steel products subject to Section 232 duties. Leave blank if the product does not use a steel exclusion.
Use Line# to confirm the classification line being edited and (B)ack to return to the classification screen. Exclusion IDs are saved when the part is posted.
PGA Defaults. (Participatory Government Agencies)
The PGA screens store default information required by Participating Government Agencies (PGAs), based on the data collection rules tied to the Harmonized Tariff Schedule (HTS).
Each PGA has its own dedicated screen, and the level of complexity varies depending on the amount of information that agency requires. The purpose of assigning PGA data at this level is to capture only the details that remain consistent across entries, reducing repetitive input during processing.
- For Example:
- Entity information should be left blank, as the system will automatically populate it from shipment details when needed.
- Values and weights should not be entered here, since they are transferred directly from the 7501 Line Item.
If the particular HTS requires or may require PGA information enter G to add the information.
- Current Supported PGA's
- AMS U.S. Department of Agriculture, Agricultural Marketing Service. See AMS PGA Entry.
- APH U.S. Department of Agriculture, Animal and Plant Health Inspection Service. See APH PGA Entry.
- ATF U.S. Department of Justice, Bureau of Alcohol, Tobacco, Firearms and Explosives. See ATF PGA Entry.
- DEA U.S. Department of Justice, Drug Enforcement Administration. See DEA PGA Entry.
- DTC U.S. Department of State, Directorate of Defense Trade Controls. See DTC PGA Entry.
- EPA U.S. Environmental Protection Agency. See EPA PGA Entry.
- FDA U.S. Department of Health and Human Services, Food and Drug Administration. See FDA PGA Entry.
- FSI U.S. Department of Agriculture, Food Safety and Inspection Service. See FSI PGA Entry.
- FWS U.S. Fish & Wildlife Service. See FWS PGA Entry.
- NHT U.S. Department of Transportation, National Highway Traffic Safety Administration. See NHT PGA Entry.
- NMF U.S. Department of Commerce, National Oceanic and Atmospheric Administration, National Marine Fisheries. See NMF PGA Entry.
- TTB U.S. Department of the Treasury, Alcohol and Tobacco Tax and Trade Bureau. See TTB PGA Entry.