01Relates to the patient
reference data (no patient link)
Single-patient export: included in full (reference data).
02References
RO_ID→MMT_REPLENISH_ORDERS.RO_IDPACKAGE_NDC→NDC_PACKAGES.PACKAGE_NDC
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | RO_ID PK | integer | int | no | |
| 2 | RO_LINE_NO PK | integer | int | no | |
| 3 | PACKAGE_NDC | string | varchar(15) | no | |
| 4 | CAT_NO | string | varchar(10) | yes | |
| 5 | QUANTITY_TO_PICK | decimal | decimal(10,2) | no | |
| 6 | QUANTITY_PICKED | decimal | decimal(10,2) | no | |
| 7 | QUANTITY_RECEIVED | decimal | decimal(10,2) | yes | |
| 8 | LOT_ID | string | varchar(50) | yes | |
| 9 | EXP_DATE | datetime | datetime | yes | |
| 10 | COMMENTS | string | varchar(1000) | yes |