DW_NS_inventoryNumber_D
This table contains information about Lot/Serial Numbered items. i.e. Expiration Date, Serial/Lot Number and the item to which this Serial/Lot Number has been assigned to.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| expirationdate | TIMESTAMP | Expiration Date | |||||
| inventorynumber | VARCHAR2 | 128 | Serial/Lot Number | ||||
| item | NUMBER | 38 | 0 | Item | |||
| memo | VARCHAR2 | 999 | Memo | ||||
| lastmodifieddate | TIMESTAMP | Last Modified Date |