Skip to main content

DSCSA Transaction Document fields

The fields of a DSCSA Transaction Document record (dscsa.document) that its screens show, by label.

Explained in the guide: Find, view, download and print DSCSA documents, Find the DSCSA documents issued in an owner's name or received for it.

FieldExplained inTechnical nameTypeHelpModule
3PL Ownerdscsa_3pl_report_owner_idLink to ContactThe owner (3PL client) this record belongs to. Empty: our own.3PL add-on
Archived Ondscsa_archived_onDate and timeRx Tracking
Chain Positionchain_indexWhole numberRx Tracking
Direct Purchasedirect_purchaseCheckboxThe seller bought the product directly from the manufacturer, its exclusive distributor, or a repackager that bought it directly from the manufacturer.Rx Tracking
DirectionFields and statuses the core module adds to Odoo screensdirectionSelection (see Statuses)Rx Tracking
Document DatedateDateRx Tracking
EPCIS Problemepcis_issueMulti-line textWhy no EPCIS file was generated when this outbound document was posted (missing GLN, address, ...). Empty when the file was generated or is not needed (lot-level document).Rx Tracking
Frozen Filesfile_idsList of AttachmentThe files frozen when the document was posted (T3 report, EPCIS). Served as stored.Rx Tracking
Hashdscsa_hashTextRx Tracking
Hold Placed Bylegal_hold_by_idLink to UserRx Tracking
Hold Placed Onlegal_hold_onDate and timeRx Tracking
Invoice Referenceinvoice_refTextRx Tracking
Issuing Mode3PL settings and the fields the add-on adds to existing screensdscsa_issue_modeSelection (see Statuses)3PL add-on
Keep At Least Untilretention_untilDateTransaction date plus the six-year DSCSA retention period. Documents are never deleted in Odoo; this is the legal minimum.Rx Tracking
Legal Holdlegal_holdCheckboxKept for litigation or an investigation: set and released by a DSCSA manager, with a reason.Rx Tracking
Legal Hold Reasonlegal_hold_reasonMulti-line textRx Tracking
Lot Levellot_levelCheckboxLot-level content without package serial numbers (exempt small dispenser).Rx Tracking
NumbernameTextRx Tracking
Order Referenceorder_refTextPurchase order number of the buyer.Rx Tracking
Owner3PL settings and the fields the add-on adds to existing screensdscsa_owner_idLink to ContactThe owner (3PL client) in whose name this document is issued. Empty: our own document.3PL add-on
Package Countpackage_countWhole numberRx Tracking
Posted Onposted_onDate and timeRx Tracking
Previous Hashprevious_hashTextRx Tracking
Productsline_idsList of DSCSA Document LineRx Tracking
S3 ArchiveFields and statuses the core module adds to Odoo screensdscsa_archive_stateSelection (see Statuses)Rx Tracking
S3 Archive Jobsdscsa_archive_job_idsList of DSCSA S3 Archive JobRx Tracking
S3 Manifest ETagdscsa_archive_etagTextRx Tracking
S3 Manifest Keydscsa_archive_keyTextRx Tracking
S3 Manifest Version IDdscsa_archive_version_idTextRx Tracking
Ship Dateship_dateDateRx Tracking
StateFields and statuses the core module adds to Odoo screensstateSelection (see Statuses)Rx Tracking
Trading Partnerpartner_idLink to ContactThe other party of the transaction (commercial partner): the buyer of an outbound document, the seller of an inbound one.Rx Tracking
Transaction Datetransaction_dateDateRx Tracking
Transaction Historyhistory_idsList of DSCSA Transaction History HopEvery change of ownership back to the manufacturer; position 1 is this document's own transaction.Rx Tracking
Transaction Statementts_textMulti-line textRx Tracking
Transferpicking_idLink to TransferRx Tracking
Transfer of Ownership in Place3PL settings and the fields the add-on adds to existing screensdscsa_in_placeCheckboxTitle transfer without a shipment: the units stayed in our warehouse.3PL add-on
TS Legal Noticets_legal_noticeTextRx Tracking
Visible to the Buyer3PL settings and the fields the add-on adds to existing screensdscsa_buyer_visibleCheckboxAn owner document the buyer may see in its portal: issued in mode B, or published later by a DSCSA manager with the owner's authorization ("Publish to Buyer"). Never unpublished. Own documents are always visible to their buyer.3PL add-on

Products (line_ids): each line is a DSCSA Document Line record; its fields are on dscsa.document.line.

S3 Archive Jobs (dscsa_archive_job_ids): each line is a DSCSA S3 Archive Job record; its fields are on dscsa.archive.job.

Transaction History (history_ids): each line is a DSCSA Transaction History Hop record; its fields are on dscsa.document.history.