RCV_DOCK_LOGS
The table RCV_DOCK_LOGS stores details associated with receipt of carrier packages such as carrier tracking number, freight carrier name, and comments. Tracking numbers associated with carrier package arrivals are scanned and logged at the time of receipt. This information is used to confirm that the count of packages delivered by the freight carrier matches what has been recorded when performing the dock logging process.
Details
-
Schema: FUSION
-
Object owner: RCV
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
rcv_dock_logs_PK |
DOCK_LOG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCK_LOG_ID | NUMBER | 18 | Yes | Unique identifier for the dock log. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | Unique identifier for the inventory organization. | |
| TRACKING_NUMBER | VARCHAR2 | 30 | Yes | Stores the logged tracking number. | |
| FREIGHT_CARRIER_ID | NUMBER | 18 | Unique identifier for the freight carrier. | ||
| ADHOC_FREIGHT_CARRIER_NAME | VARCHAR2 | 360 | Stores the adhoc freight carrier name. | ||
| STATUS_CODE | VARCHAR2 | 30 | Yes | Stores the status code of the dock log. References FND_LOOKUP_VALUES.LOOKUP_CODE where lookup_code is ORA_RCV_DOCK_LOG_STATUS. | |
| COMMENTS | VARCHAR2 | 4000 | Stores the notes captured at the time of dock logging. | ||
| DAMAGED_FLAG | VARCHAR2 | 1 | Indicates whether the package is damaged. | ||
| LOGGED_BY_PERSON_ID | NUMBER | 18 | Yes | Unique identifier for the person performing the dock log. | |
| LOGGED_DATE | DATE | Yes | Date when the dock log was performed. | ||
| SHIPMENT_HEADER_ID | NUMBER | 18 | Unique identifier for the receiving receipt header. | ||
| ADHOC_RECEIPT_DELIVERY_ID | NUMBER | 18 | Unique identifier for the adhoc receiving delivery. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCV_DOCK_LOGS_U1 | Unique | Default | DOCK_LOG_ID |
| RCV_DOCK_LOGS_U2 | Unique | Default | TRACKING_NUMBER |