RCV_RECEIPT_DELIVERIES
The table RCV_RECEIPT_DELIVERIES stores all the information about the deliveries in receiving. There are two categories of deliveries - ad hoc and receipt-based. Ad hoc deliveries are manually created, and are not usually associated to a document like a purchase order or a transfer order. Receipt-based deliveries are created automatically on creating a receiving receipt, and are assigned to an employee or a contingent worker by a warehouse manager. The assignee will deliver the package to the eventual recipient, who confirms delivery through a signature or some other method.
Details
-
Schema: FUSION
-
Object owner: RCV
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
RCV_RECEIPT_DELIVERIES_PK |
RECEIPT_DELIVERY_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
RECEIPT_DELIVERY_ID | NUMBER | 18 | Yes | This column stores the unique identifier for the current receipt delivery row. | |
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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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. | |
DELIVERY_NUMBER | VARCHAR2 | 80 | Yes | This column stores the unique number that is used to track the current delivery row. | |
DELIVERY_CART_ID | NUMBER | 18 | This column uniquely identies the cart used to perform the current delivery. | ||
DELIVERY_STATUS_CODE | VARCHAR2 | 25 | This column stores the code that represents the status of the current delivery row. Valid values are OPEN, PENDING and DELIVERED. | ||
ADHOC_DELIVERY_IND | VARCHAR2 | 1 | This column indicates whether the current delivery is ad hoc or receipt-based. The value of this column will be Y for an ad hoc delivery and N for a receipt-based delivery. | ||
TO_ORGANIZATION_ID | NUMBER | 18 | This column stores the unique identifier of the inventory organization for the current delivery row. | ||
ITEM_ID | NUMBER | 18 | This column stores the unique identifier of the inventory item that is being delivered. | ||
ITEM_DESCRIPTION | VARCHAR2 | 240 | This column stores the description of the inventory item or the one-time item that is being delivered. | ||
RECEIPT_NUM | VARCHAR2 | 30 | This column stores the receiving receipt number for the current delivery row. | ||
SHIPMENT_HEADER_ID | NUMBER | 18 | This column stores the unique identifier of the receiving receipt header for the current delivery row. | ||
SHIPMENT_LINE_ID | NUMBER | 18 | This column stores the unique identifier of the receiving eceipt line for the current delivery row. | ||
SOURCE_DOCUMENT_CODE | VARCHAR2 | 25 | This column stores the source document code for the receiving transactions. Maps to FND_LOOKUP_VALUES_B.LOOKUP_CODE where lookup_type is RCV_SOURCE_DOCUMENT_TYPE. Valid values are PO, TRANSFER ORDER and NULL. | ||
DOCUMENT_NUMBER | VARCHAR2 | 80 | This column stores the document number for the current delivery row. If source document code is PO, this column stores the purchase order number. If source document code is TRANSFER ORDER, this column stores the transfer order number. | ||
DOCUMENT_LINE_NUMBER | VARCHAR2 | 80 | This column stores the document line number for the current delivery row. If source document code is PO, this column stores the purchase order line number. If source document code is TRANSFER ORDER, this column stores the transfer order line number. | ||
DOCUMENT_SCHEDULE_NUMBER | VARCHAR2 | 80 | This column stores the document schedule number for the current delivery row. If source document code is PO, this column stores the purchase order schedule number. | ||
PO_DISTRIBUTION_ID | NUMBER | 18 | This column stores the unique identifier of the purchase order distribution for the current delivery. | ||
TRANSFER_ORDER_DIST_ID | NUMBER | 18 | This column stores the unique identifier of the transfer order distribution for the current delivery row. | ||
QUANTITY | NUMBER | This column stores the quantity of the received item to be delivered to the requester. | |||
UOM_CODE | VARCHAR2 | 3 | This column stores the abbreviation that identifies the unit of measure for the quantity being delivered to the requester. | ||
DESTINATION_TYPE_CODE | VARCHAR2 | 25 | This column stores the destination type code for the receiving document of the current delivery row. | ||
PARENT_TRANSACTION_ID | NUMBER | 18 | This column stores the unique identifier of the parent receiving transaction for the current delivery row. | ||
DELIVER_TO_LOCATION_ID | NUMBER | 18 | This column stores unique identifier of the deliver to location for the current delivery row. | ||
SUBINVENTORY | VARCHAR2 | 10 | This column stores the destination PAR subinventory where the item is delivered to. | ||
LOCATOR_ID | NUMBER | 18 | This column stores the unique identifier of the destination PAR locator where the item is delivered to. | ||
DELIVER_TO_PERSON_ID | NUMBER | 18 | This column stores the unique identifier of the requester. If the SOURCE_DOCUMENT_CODE is PO, this column stores the requester of the purchase order distribution. If the SOURCE_DICUMENT_CODE is TRANSFER ORDER, this column stores the requester of the transfer order distribution. | ||
RECEIVED_BY_PERSON_ID | NUMBER | 18 | This column stores the unique identifier of the person who received the current delivery. | ||
DELIVERED_BY_PERSON_ID | NUMBER | 18 | This column stores the unique identifier of the person who executed the current delivery task. | ||
DELIVERY_DATE | DATE | This column stores the date on which the delivery was confirmed. | |||
COMMENTS | VARCHAR2 | 400 | This column stores the notes and comments captured for the current delivery row. | ||
ADHOC_LOCATION_NAME | VARCHAR2 | 60 | This column stores the destination location of the current ad-hoc delivery. | ||
ADHOC_RECEIVER_NAME | VARCHAR2 | 2000 | This column stores the name of the person who received the current adphoc delivery. | ||
REQUISITION_NUMBER | VARCHAR2 | 64 | This column stores the requisition that created the receiving document of the current delivery. | ||
PARSUB_LOCATION_ID | NUMBER | 18 | This column stores the unique identifier of the location associated with the destination PAR subinventory. | ||
RECEIVED_BY_NAME | VARCHAR2 | 2000 | This column stores the name of the person who has received the package. | ||
RECEIVED_BY_SIGNATURE | BLOB | This column stores the image of the signature of the person who received the package. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
RCV_RECEIPT_DELIVERIES | rcv_shipment_headers | SHIPMENT_HEADER_ID |
RCV_RECEIPT_DELIVERIES | rcv_shipment_lines | SHIPMENT_LINE_ID |
RCV_RECEIPT_DELIVERIES | rcv_transactions | PARENT_TRANSACTION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
RCV_RECEIPT_DELIVERIES_N1 | Non Unique | Default | TO_ORGANIZATION_ID, SUBINVENTORY | Obsolete |
RCV_RECEIPT_DELIVERIES_N10 | Non Unique | Default | UPPER("ADHOC_LOCATION_NAME") | |
RCV_RECEIPT_DELIVERIES_N11 | Non Unique | Default | UPPER("ADHOC_RECEIVER_NAME") | |
RCV_RECEIPT_DELIVERIES_N2 | Non Unique | Default | DELIVERY_STATUS_CODE | |
RCV_RECEIPT_DELIVERIES_N3 | Non Unique | Default | DOCUMENT_NUMBER, SOURCE_DOCUMENT_CODE | Obsolete |
RCV_RECEIPT_DELIVERIES_N4 | Non Unique | Default | DELIVER_TO_LOCATION_ID | |
RCV_RECEIPT_DELIVERIES_N5 | Non Unique | Default | DELIVERY_CART_ID | |
RCV_RECEIPT_DELIVERIES_N6 | Non Unique | Default | PARSUB_LOCATION_ID | Obsolete |
RCV_RECEIPT_DELIVERIES_N7 | Non Unique | Default | DELIVER_TO_PERSON_ID | |
RCV_RECEIPT_DELIVERIES_N8 | Non Unique | Default | TO_ORGANIZATION_ID, UPPER("SUBINVENTORY") | |
RCV_RECEIPT_DELIVERIES_N9 | Non Unique | Default | UPPER("DOCUMENT_NUMBER"), SOURCE_DOCUMENT_CODE | |
RCV_RECEIPT_DELIVERIES_U1 | Unique | Default | RECEIPT_DELIVERY_ID | |
RCV_RECEIPT_DELIVERIES_U2 | Unique | Default | DELIVERY_NUMBER |