Skip to main content

DSCSA Package fields

The fields of a DSCSA Package record (dscsa.package) that its screens show, by label.

Explained in the guide: Import the supplier's EPCIS file on the receipt, Verify returned units for resale, or reject and destroy them, See which owners' units are on hold (Owner Holds report), List the serial numbers we hold for an owner (Owner Serials).

FieldExplained inTechnical nameTypeHelpModule
3PL Ownerdscsa_3pl_report_owner_idLink to ContactThe owner (3PL client) this record belongs to. Empty: our own.3PL add-on
Cases per Supplier Filedscsa_announced_ssccsTextSSCCs of the cases the package is in according to the supplier's file (outermost first). Scanning one of them on the receipt receives every package of that sealed case.Rx Tracking
Decided Byreturn_decision_by_idLink to UserRx Tracking
Decided Onreturn_decision_dateDate and timeRx Tracking
Delivery Linedelivery_move_line_idLink to Product Moves (Stock Move Line)Rx Tracking
Expected Receiptdscsa_expected_picking_idLink to TransferRx Tracking
Expiration Dateexpiry_dateDateExpiration date as printed on the package (GS1 AI 17).Rx Tracking
Expiry per Supplier Filedscsa_announced_expiryDateRx Tracking
GTINgtin14TextRx Tracking
Held for Owner3PL settings and the fields the add-on adds to existing screensdscsa_owner_idLink to ContactThe owner we hold this unit for (after shipping: the owner it was shipped for). Empty: our own unit.3PL add-on
Inferred from Casedscsa_inferredCheckboxThe shipping event lists only the package's case; the package itself is known from the file's aggregation data.Rx Tracking
Lotlot_idLink to Lot/SerialRx Tracking
Lot per Supplier Filedscsa_announced_lot_idLink to Lot/SerialRx Tracking
Movement Historymove_line_idsList of Product Moves (Stock Move Line)Rx Tracking
OriginFields and statuses the core module adds to Odoo screensoriginSelection (see Statuses)How the package entered the ledger: scanned on a receipt, registered as opening balance for stock that predates the ledger, or found in an inventory count.Rx Tracking
Pending Transferpending_picking_idLink to TransferRx Tracking
Productproduct_idLink to Product VariantRx Tracking
Receipt Linereceipt_move_line_idLink to Product Moves (Stock Move Line)Rx Tracking
Received Datereceived_dateDate and timeRx Tracking
Registered Atregistered_location_idLink to Inventory LocationsWhere the package was registered outside a receipt. Packages without movement history (opening balance) are located here.Rx Tracking
Registration Noteorigin_noteTextReference given when the package was registered outside a receipt (opening balance, inventory count).Rx Tracking
Return DecisionFields and statuses the core module adds to Odoo screensreturn_decisionSelection (see Statuses)What a DSCSA manager decided about the last return of this package.Rx Tracking
Return Transferreturn_picking_idLink to TransferThe stock operation where the packing has been madeRx Tracking
Returned Datereturned_dateDate and timeRx Tracking
Seller of Record3PL settings and the fields the add-on adds to existing screensdscsa_seller_idLink to ContactSet when the unit ships: the owner, or our company when we sold it.3PL add-on
Serial NumberserialTextRx Tracking
SGTINsgtinTextEPC URN of the package (GTIN + serial), as used in EPCIS files.Rx Tracking
Shipped Dateshipped_dateDate and timeRx Tracking
Shipped Topartner_idLink to ContactCommercial partner the package was last shipped to.Rx Tracking
SSCCssccTextSerial Shipping Container Code of the case the package came in.Rx Tracking
StateFields and statuses the core module adds to Odoo screensstateSelection (see Statuses)Rx Tracking
Supplier Filedscsa_import_idLink to Supplier EPCIS FileThe supplier EPCIS file that announced this package.Rx Tracking