DSCSA Trace Request fields
The fields of a DSCSA Trace Request record (dscsa.trace.request) that its screens show, by label.
Explained in the guide: Log a trace request from the FDA, a state or a trading partner.
| Field | Explained in | Technical name | Type | Help | Module |
|---|---|---|---|---|---|
| Approval Date | Answer a trace request about an owner's records | dscsa_owner_approved_on | Date | The date the owner approved the response. | 3PL add-on |
| Approval Reference | Answer a trace request about an owner's records | dscsa_owner_approval_ref | Text | The owner's reference for the approval: its e-mail, letter, ticket or call note. | 3PL add-on |
| Approved By (Owner) | Answer a trace request about an owner's records | dscsa_owner_approved_by | Text | Who at the owner approved the response (name and role). | 3PL add-on |
| Document Count | document_count | Whole number | Rx Tracking | ||
| Documents | document_ids | List of DSCSA Transaction Document | Rx Tracking | ||
| Due On | due_on | Date and time | 24 hours after the request was received: DSCSA expects the transaction information within 24 hours. | Rx Tracking | |
| GTINs / NDCs | query_gtins | Text | GTINs or hyphenated NDCs, separated by spaces or commas. | Rx Tracking | |
| Lots | query_lots | Multi-line text | Lot numbers, one per line or separated by commas. | Rx Tracking | |
| Not Found | unmatched_text | Multi-line text | Serials and lots of the query that match no package and no document. | Rx Tracking | |
| Number | name | Text | Rx Tracking | ||
| Owner Concerned | Answer a trace request about an owner's records | dscsa_owner_id | Link to Contact | The owner (3PL client) whose records the request is about: the search, the results and the response hold that owner's records only, and the response is prepared on its behalf with its approval. Empty: our own records (never an owner's documents). Changing it throws the results away. | 3PL add-on |
| Package Count | package_count | Whole number | Rx Tracking | ||
| Packages | package_ids | List of DSCSA Package | Rx Tracking | ||
| Products | query_product_ids | List of Product Variant | Rx Tracking | ||
| Received On | received_on | Date and time | Rx Tracking | ||
| Request | description | Multi-line text | What was asked, in the requester's words. | Rx Tracking | |
| Requested By | Fields and statuses the core module adds to Odoo screens | requester_type | Selection (see Statuses) | Rx Tracking | |
| Requester | partner_id | Link to Contact | The agency, trading partner or person who asked. | Rx Tracking | |
| Responded By | responded_by_id | Link to User | Rx Tracking | ||
| Responded On | responded_on | Date and time | Rx Tracking | ||
| Response File Name | response_filename | Text | Rx Tracking | ||
| Response SHA-256 | response_sha256 | Text | Rx Tracking | ||
| Responsible | user_id | Link to User | Rx Tracking | ||
| Searched By | searched_by_id | Link to User | Rx Tracking | ||
| Searched On | searched_on | Date and time | Rx Tracking | ||
| Serials | query_serials | Multi-line text | One package per line: a scanned or pasted GS1 DataMatrix, (01)…(21)… text, an SGTIN or SSCC URN, '<GTIN> <serial>' or a serial alone (any product). | Rx Tracking | |
| State | Fields and statuses the core module adds to Odoo screens | state | Selection (see Statuses) | Rx Tracking | |
| Their Reference | requester_reference | Text | The requester's case, letter or notification number. | Rx Tracking | |
| Transactions From | date_from | Date | Rx Tracking | ||
| Transactions To | date_to | Date | Rx Tracking |