Supplier EPCIS File fields
The fields of a Supplier EPCIS File record (dscsa.epcis.import) that its screens show, by label.
Explained in the guide: Review supplier EPCIS files and the inbound DSCSA document.
| Field | Explained in | Technical name | Type | Help | Module |
|---|---|---|---|---|---|
| Buyer GLN | buyer_gln | Text | Rx Tracking | ||
| Custody Only | Receive the owner's own goods as a custody receipt | dscsa_custody_only | Checkbox | The file names the owner as both seller and buyer: a move of the owner's own goods (e.g. from its contract manufacturer), not a transaction. No transaction statement is needed and no document posted. | 3PL add-on |
| Despatch Advice References | desadv_refs | Text | Rx Tracking | ||
| Direct Purchase | direct_purchase | Checkbox | The file states that the seller bought directly from the manufacturer (GS1 US directPurchase). | Rx Tracking | |
| Discrepancies | discrepancy_ids | List of DSCSA Receiving Discrepancy | Rx Tracking | ||
| Discrepancy Count | discrepancy_count | Whole number | Rx Tracking | ||
| Duplicate Serials | duplicate_count | Whole number | Rx Tracking | ||
| Duplicates | duplicate_summary | Multi-line text | Serials in the file that are already in our package ledger. They are not expected on the receipt and become 'duplicate' discrepancies when it is validated. | Rx Tracking | |
| EPCIS File | file | File | Rx Tracking | ||
| File Created On | file_created_on | Date and time | Rx Tracking | ||
| File Name | name | Text | Rx Tracking | ||
| File SHA-256 | file_sha256 | Text | Rx Tracking | ||
| Has Transaction Statement | ts_present | Checkbox | Rx Tracking | ||
| Imported On | Attach the supplier's EPCIS file to an owner's open receipt | dscsa_target | Selection (see Statuses) | Open receipt: imported before the goods were received. Late file: attached to the done receipt (the goods arrived before their data). Title transfer: the owner's transfer file. | 3PL add-on |
| Inbound Document | document_id | Link to DSCSA Transaction Document | The inbound DSCSA document created and posted from this file when the receipt was validated. | Rx Tracking | |
| Inferred from Cases | inferred_count | Whole number | Packages the shipping event lists only through their sealed case (SSCC): known from the aggregation data of the file. | Rx Tracking | |
| Invoice References | invoice_refs | Text | Rx Tracking | ||
| Legal Notice | legal_notice | Multi-line text | Rx Tracking | ||
| Owner | Attach the supplier's EPCIS file to an owner's open receipt | dscsa_owner_id | Link to Contact | The owner (3PL client) whose receipt this file was imported on: the file's buyer. | 3PL add-on |
| Packages | package_ids | List of DSCSA Package | Rx Tracking | ||
| Packages in File | announced_count | Whole number | Rx Tracking | ||
| PO References | po_refs | Text | Rx Tracking | ||
| Products in File | announced_product_ids | List of Product Variant | Rx Tracking | ||
| Purchase Order | purchase_id | Link to Purchase Order | Rx Tracking | ||
| Receipt | picking_id | Link to Transfer | Rx Tracking, 3PL add-on | ||
| Received | received_count | Whole number | Rx Tracking | ||
| Seller GLN | seller_gln | Text | Rx Tracking | ||
| Ship Date | ship_date | Date | Rx Tracking | ||
| Ship-from GLN | ship_from_gln | Text | Rx Tracking | ||
| Ship-to GLN | ship_to_gln | Text | Rx Tracking | ||
| Shipped At | shipped_at | Date and time | Rx Tracking | ||
| State | Fields and statuses the core module adds to Odoo screens | state | Selection (see Statuses) | Rx Tracking | |
| Statement Affirmed | ts_affirmed | Checkbox | Rx Tracking | ||
| Still Expected | expected_count | Whole number | Rx Tracking | ||
| Superseded By | superseded_by_id | Link to Supplier EPCIS File | Rx Tracking | ||
| Supplier | partner_id | Link to Contact | Rx Tracking | ||
| Supplier Document | supplier_document_ref | Text | First despatch advice number of the file, else its first invoice number. | Rx Tracking | |
| Supplier File ID | epcis_document_ref | Text | SBDH InstanceIdentifier of the file. | Rx Tracking | |
| Transaction Statement Recorded In | dscsa_ts_record_id | Link to DSCSA Receiving Discrepancy | Where the Transaction Statement this file lacks was recorded (for this file or a file it superseded). | Rx Tracking | |
| Warnings | warning_text | Multi-line text | Rx Tracking |
Discrepancies (discrepancy_ids): each line is a DSCSA Receiving Discrepancy record; its fields are on dscsa.discrepancy.
Packages (package_ids): each line is a DSCSA Package record; its fields are on dscsa.package.