Skip to main content

DSCSA Receiving Discrepancy fields

The fields of a DSCSA Receiving Discrepancy record (dscsa.discrepancy) that its screens show, by label.

Explained in the guide: Work a receiving discrepancy to resolution, Work the Supplier Data Pending list, Review the receiving discrepancies of owners' receipts.

FieldExplained inTechnical nameTypeHelpModule
3PL Ownerdscsa_3pl_report_owner_idLink to ContactThe owner (3PL client) this record belongs to. Empty: our own.3PL add-on
Confirmed By (Owner)Release a data-pending hold with the owner's confirmationdscsa_owner_confirmed_by_idLink to ContactWho at the owner confirmed that the owner holds the supplier's transaction information and statement.3PL add-on
DescriptiondescriptionMulti-line textRx Tracking
Detected Ondetected_onDate and timeRx Tracking
Foundfound_valueTextRx Tracking
GTINgtin14TextRx Tracking
Inbound Documentdocument_idLink to DSCSA Transaction DocumentRx Tracking
Lotlot_idLink to Lot/SerialThe lot concerned: the physical one for a scanned package, else the file's.Rx Tracking
Lots Put on Holdquarantined_lot_idsList of Lot/SerialRx Tracking
OwnerWork the Supplier Data Pending listdscsa_owner_idLink to ContactThe owner (3PL client) whose receipt this discrepancy is about. Empty: our own receipt.3PL add-on
Owner Confirmation EvidenceRelease a data-pending hold with the owner's confirmationdscsa_owner_confirmation_attachment_idsList of AttachmentThe owner's confirmation (email, letter). Kept for good as a DSCSA record.3PL add-on
Owner Confirmation Recorded ByRelease a data-pending hold with the owner's confirmationdscsa_owner_confirmation_recorded_by_idLink to User3PL add-on
Owner Confirmation Recorded OnRelease a data-pending hold with the owner's confirmationdscsa_owner_confirmation_recorded_onDate and time3PL add-on
Owner Confirmation ReferenceRelease a data-pending hold with the owner's confirmationdscsa_owner_confirmation_refTextWhere the owner's confirmation can be found again: email subject, ticket or letter reference.3PL add-on
Owner Confirmed OnRelease a data-pending hold with the owner's confirmationdscsa_owner_confirmed_onDate3PL add-on
Packagepackage_idLink to DSCSA PackageThe scanned package, or for a duplicate the package already in the ledger.Rx Tracking
Productproduct_idLink to Product VariantRx Tracking
Purchase Orderpurchase_idLink to Purchase OrderRx Tracking
Receiptpicking_idLink to TransferRx Tracking
ReferencenameTextRx Tracking
Resolution Noteresolution_noteMulti-line textHow the discrepancy was resolved (e.g. corrected file received, product returned, suspect-product investigation opened).Rx Tracking
Resolve Bydate_dueDate10 business days after detection (weekends skipped; public holidays are not, which can only make the deadline earlier).Rx Tracking
Resolved Byresolved_by_idLink to UserRx Tracking
Resolved Onresolved_onDate and timeRx Tracking
Responsibleuser_idLink to UserRx Tracking
Serial NumberserialTextRx Tracking
SSCCssccTextRx Tracking
StateFields and statuses the core module adds to Odoo screensstateSelection (see Statuses)Rx Tracking
Supplierpartner_idLink to ContactRx Tracking
Supplier Affirms the Transaction Statementts_affirmedCheckboxThe person recording it confirmed that the supplier's statement affirms the §581(27) Transaction Statement.Rx Tracking
Supplier EPCIS Fileimport_idLink to Supplier EPCIS FileRx Tracking
Supplier File Saysexpected_valueTextRx Tracking
Transaction Statement Evidencets_evidence_idsList of AttachmentFiles showing the supplier's Transaction Statement. They are DSCSA records and can't be deleted.Rx Tracking
Transaction Statement Obtained Onts_obtained_onDateRx Tracking
Transaction Statement Recorded Byts_recorded_by_idLink to UserRx Tracking
Transaction Statement Recorded Onts_recorded_onDate and timeRx Tracking
Transaction Statement Referencets_referenceTextWhere the Transaction Statement can be found again: document number, portal URL, email subject, EDI message ID.Rx Tracking
Transaction Statement SourceFields and statuses the core module adds to Odoo screensts_sourceSelection (see Statuses)Rx Tracking
TypeFields and statuses the core module adds to Odoo screensdiscrepancy_typeSelection (see Statuses)Rx Tracking, 3PL add-on