RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_HEADERS stores common information about the source of your receipts or expected receipts. You group your receipts by the source type and the source of the receipt. Oracle Purchasing does not allow you to group receipts from different sources under one receipt header. . There are two receipt source types, Supplier and Internal Order, that you need to use when receiving against different source document types. You use a receipt source type of 'Supplier' when receiving items that you ordered from an external supplier using a purchase order. When you receive items that are part of an inter-organization transfer, or when receiving items that you request from your inventory using an internal requisition, the receipt type would be 'Internal Order'. The 'Internal Order' receipt source type populates the ORGANIZATION_ID column. . Oracle Purchasing creates a receipt header when you are entering your receipts or when you perform inter-organization transfers using Oracle Inventory. When Oracle Inventory creates a receipt header for an intransit shipment, the receipt number is not populated until you receive the shipment. .
Details
-
Schema: FUSION
-
Object owner: RCV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
RCV_SHIPMENT_HEADERS_PK |
SHIPMENT_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| SHIPMENT_HEADER_ID | NUMBER | 18 | Yes | This column stores the receiving shipment receiving receipt header unique identifier. This is the primary key for 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. | ||
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| RECEIPT_SOURCE_CODE | VARCHAR2 | 25 | Yes | Source type of the shipment or the receipt. Valid Values are VENDOR, INVENTORY, TRANSFER ORDER, CUSTOMER and OUTSOURCER. | ||
| VENDOR_ID | NUMBER | 18 | Supplier unique identifier. References POZ_SUPPLIERS.VENDOR_ID. | |||
| VENDOR_SITE_ID | NUMBER | 18 | Supplier site unique identifier. References POZ_SUPPLIER_SITES_ALL_M.VENDOR_SITE_ID. | |||
| ORGANIZATION_ID | NUMBER | 18 | From organization unique identifier for in-transit shipment. | |||
| SHIPMENT_NUM | VARCHAR2 | 30 | Shipment number assigned by the shipment's source. Corresponds to the ASN Number, In-transit Shipment number and Transfer order shipment number. | |||
| RECEIPT_NUM | VARCHAR2 | 30 | This column stores the receipt number for the receiving shipment receipt header row. | |||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | This column stores the Receiving location unique identifier. | |||
| BILL_OF_LADING | VARCHAR2 | 25 | This column stores the Bill of lading number. | |||
| PACKING_SLIP | VARCHAR2 | 25 | This column stores the Packing slip number. | |||
| SHIPPED_DATE | DATE | This column stores the date when the shipment was created. | ||||
| FREIGHT_CARRIER_ID | NUMBER | 18 | This column stores the Freight Carrier unique identifier. | |||
| EXPECTED_RECEIPT_DATE | DATE | This column stores the Expected arrival date of the shipment. | ||||
| EMPLOYEE_ID | NUMBER | 18 | This column stores the Unique identifier for the person who created the receiving transaction. References PER_PERSON_NAMES_F.PERSON_ID. | |||
| NUM_OF_CONTAINERS | NUMBER | 18 | This column stores the number of containers in the shipment. | |||
| WAYBILL_AIRBILL_NUM | VARCHAR2 | 20 | This column stores the waybill or air bill number. | |||
| COMMENTS | VARCHAR2 | 4000 | This column stores the note created by the receiver. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| ASN_TYPE | VARCHAR2 | 25 | ASN type of the shipment. Valid values are ASN, ASBN and STD. The valid values are ASN and ASBN for ASN/ASBN creation and STD for a receipt. | |||
| EDI_CONTROL_NUM | VARCHAR2 | 10 | EDI transaction control number if data is imported via EDI. | |||
| NOTICE_CREATION_DATE | DATE | EDI transaction create date/time at source if data is imported via EDI. | ||||
| GROSS_WEIGHT | NUMBER | Shipment gross weight specified while creating ASN. | ||||
| GROSS_WEIGHT_UOM_CODE | VARCHAR2 | 3 | Shipment gross weight unit of measure code specified while creating ASN. | |||
| NET_WEIGHT | NUMBER | Shipment net weight specified while creating ASN. | ||||
| NET_WEIGHT_UOM_CODE | VARCHAR2 | 3 | Shipment net weight unit of measure code specified while creating ASN. | |||
| TAR_WEIGHT | NUMBER | Shipment tar (container) weight specified while creating ASN. | ||||
| TAR_WEIGHT_UOM_CODE | VARCHAR2 | 3 | Shipment tar (container) weight unit of measure code specified while creating ASN. | |||
| PACKAGING_CODE | VARCHAR2 | 5 | This column stores the packaging code of the shipment. | |||
| CARRIER_METHOD | VARCHAR2 | 2 | Carrier transportation method code. | |||
| CARRIER_EQUIPMENT | VARCHAR2 | 10 | Carrier equipment description code. | |||
| SPECIAL_HANDLING_CODE | VARCHAR2 | 3 | This column stores the special handling code for the shipment. | |||
| HAZARD_CODE | VARCHAR2 | 1 | Hazardous material qualifier code of the shipment. | |||
| HAZARD_CLASS | VARCHAR2 | 4 | Hazardous material class of the shipment. | |||
| HAZARD_DESCRIPTION | VARCHAR2 | 80 | This column stores the hazardous material description. | |||
| FREIGHT_TERMS | VARCHAR2 | 25 | This column stores the Freight Payment Method (e.g. user defined, Prepaid, Collect). | |||
| FREIGHT_BILL_NUMBER | VARCHAR2 | 35 | This column stores the Freight bill (PRO invoice) number. | |||
| INVOICE_NUM | VARCHAR2 | 50 | Invoice number associated with the shipment/billing notice (ASN with billing information). | |||
| INVOICE_DATE | DATE | Invoice date associated with the shipment/billing notice (ASN with billing information). | ||||
| INVOICE_AMOUNT | NUMBER | Invoice amount associated with the shipment/billing notice (ASN with billing information). | ||||
| TAX_NAME | VARCHAR2 | 15 | Tax name associated with the shipment/billing notice (ASN with billing information). | |||
| TAX_AMOUNT | NUMBER | Tax amount associated with the shipment/billing notice name indicated at the header level. | ||||
| FREIGHT_AMOUNT | NUMBER | This column stores the Freight bill amount associated with the shipment/billing notice. | ||||
| INVOICE_STATUS_CODE | VARCHAR2 | 25 | For ASN with billing information (ASBN) only, indicates when line items were rejected. | |||
| ASN_STATUS | VARCHAR2 | 10 | This column is not being used currently. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | This column stores the invoice currency and maps to POZ_SUPPLIER_SITES_ALL_M.INVOICE_CURRENCY_CODE. Used for ASN with billing information (ASBN) only. | |||
| CONVERSION_RATE_TYPE | VARCHAR2 | 30 | This column stores the currency conversion rate type of the purchase order. Used for purchase order receipts only. | |||
| CONVERSION_RATE | NUMBER | This column stores the currency conversion rate for the receipt. Used for purchase order shipments only. | ||||
| CONVERSION_DATE | DATE | This column stores the currency conversion date for the receipt. Used for purchase order shipments only. | ||||
| PAYMENT_TERMS_ID | NUMBER | 18 | EDI transaction 857 payment terms unique identifier. | |||
| SHIP_TO_ORG_ID | NUMBER | 18 | This column stores the inventory organization unique identifier where the receipt and shipment are created. | |||
| CUSTOMER_ID | NUMBER | 18 | Customer unique identifier. Applicable for RMA transactions. | |||
| CUSTOMER_SITE_ID | NUMBER | 18 | Customer site unique identifier. Applicable for RMA transactions. | |||
| REMIT_TO_SITE_ID | NUMBER | 18 | Remit to Site unique identifier. | |||
| SHIP_FROM_LOCATION_ID | NUMBER | 18 | Ship From Location Unique Identifier of the supplier site. | |||
| APPROVAL_STATUS | VARCHAR2 | 25 | This column is not being used currently. | |||
| PERFORMANCE_PERIOD_FROM | DATE | This column is not being used currently. | ||||
| PERFORMANCE_PERIOD_TO | DATE | This column is not being used currently. | ||||
| REQUEST_DATE | DATE | This column is not being used currently. | ||||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or 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. | ||
| LSP_FLAG | VARCHAR2 | 1 | This column indicates if the shipment or the receipt is created for a logistics service provider organization. | |||
| RA_OUTSOURCER_PARTY_ID | NUMBER | 18 | This column stores the Logistics service provider customer party unique identifier. | |||
| RECEIPT_ADVICE_NUMBER | VARCHAR2 | 80 | This column stores the Receipt advice number. This must be unique to each receipt advice interfaced to fusion receiving from a given source system. Applicable to RMA and flexible supply source documents. | |||
| RA_DOCUMENT_CODE | VARCHAR2 | 25 | This column stores the source document code for the document created as part of the receipt advice. Applicable to RMA and flexible supply source documents. | |||
| RA_DOCUMENT_NUMBER | VARCHAR2 | 80 | Source document number for the receipt advice. Applicable to RMA and flexible supply source documents. | |||
| RA_DOC_REVISION_NUMBER | VARCHAR2 | 80 | Revision number of the source document for the receipt advice. Applicable to flexible supply source documents. | |||
| RA_DOC_REVISION_DATE | DATE | Source document revision date for Receipt advice. Applicable to RMA and flexible supply source documents. | ||||
| RA_DOC_CREATION_DATE | DATE | Source document creation date for Receipt advice. Applicable to RMA and flexible supply source documents. | ||||
| RA_DOC_LAST_UPDATE_DATE | DATE | Source document last update date for Receipt advice. Applicable to RMA and flexible supply source documents. | ||||
| RA_OUTSOURCER_CONTACT_ID | NUMBER | 18 | This column stores the logistic outsourcer contact party unique identifier. Applicable to flexible supply source documents. | |||
| RA_NOTE_TO_RECEIVER | VARCHAR2 | 480 | Note to receiver specified in the receipt advice. Applicable to RMA and flexible supply source documents. | |||
| RMA_BU_ID | NUMBER | 18 | This column stores the unique identifier of the business unit in which the RMA was created. | |||
| RA_DOO_SOURCE_SYSTEM_ID | NUMBER | 18 | Unique identifier of the Distributed Order Orchestration instance that has created the receipt advice. | |||
| HEADER_INTERFACE_ID | NUMBER | 18 | Unique identifier for the receipt header interface record that created this shipment or receipt. | |||
| RA_ORIG_SYSTEM_REF | VARCHAR2 | 30 | Reference code for the source system that created the receipt advice. | |||
| GL_DATE | DATE | This column stores the general ledger date. | ||||
| EXTERNAL_SYS_TXN_REFERENCE | VARCHAR2 | 300 | This column is used to store the link to the transaction references passed by external WMS or 3PL systems. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| rcv_transactions | rcv_shipment_headers | SHIPMENT_HEADER_ID |
| inv_supply | rcv_shipment_headers | SHIPMENT_HEADER_ID |
| rcv_supply | rcv_shipment_headers | SHIPMENT_HEADER_ID |
| rcv_transactions_interface | rcv_shipment_headers | SHIPMENT_HEADER_ID |
| rcv_shipment_lines | rcv_shipment_headers | SHIPMENT_HEADER_ID |
| rcv_receipt_deliveries | rcv_shipment_headers | SHIPMENT_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCV_SHIPMENT_HEADERS_N1 | Non Unique | Default | SHIP_TO_LOCATION_ID |
| RCV_SHIPMENT_HEADERS_N10 | Non Unique | Default | CREATION_DATE |
| RCV_SHIPMENT_HEADERS_N11 | Non Unique | Default | PACKING_SLIP |
| RCV_SHIPMENT_HEADERS_N12 | Non Unique | Default | UPPER("SHIPMENT_NUM") |
| RCV_SHIPMENT_HEADERS_N13 | Non Unique | Default | TRUNC("EXPECTED_RECEIPT_DATE") |
| RCV_SHIPMENT_HEADERS_N14 | Non Unique | Default | EXTERNAL_SYS_TXN_REFERENCE |
| RCV_SHIPMENT_HEADERS_N15 | Non Unique | Default | CUSTOMER_ID |
| RCV_SHIPMENT_HEADERS_N16 | Non Unique | Default | HEADER_INTERFACE_ID |
| RCV_SHIPMENT_HEADERS_N2 | Non Unique | Default | SHIPMENT_NUM |
| RCV_SHIPMENT_HEADERS_N3 | Non Unique | Default | VENDOR_ID |
| RCV_SHIPMENT_HEADERS_N4 | Non Unique | Default | VENDOR_SITE_ID |
| RCV_SHIPMENT_HEADERS_N5 | Non Unique | Default | RECEIPT_SOURCE_CODE, RA_DOCUMENT_NUMBER |
| RCV_SHIPMENT_HEADERS_N6 | Non Unique | Default | RECEIPT_NUM, SHIP_TO_ORG_ID |
| RCV_SHIPMENT_HEADERS_N7 | Non Unique | Default | EMPLOYEE_ID |
| RCV_SHIPMENT_HEADERS_N8 | Non Unique | Default | RA_DOCUMENT_CODE, UPPER("RA_DOCUMENT_NUMBER") |
| RCV_SHIPMENT_HEADERS_N9 | Non Unique | Default | UPPER("RECEIPT_NUM") |
| RCV_SHIPMENT_HEADERS_U1 | Unique | Default | SHIPMENT_HEADER_ID |
| RCV_SHIPMENT_HEADERS_U2 | Unique | Default | RECEIPT_ADVICE_NUMBER, RA_DOO_SOURCE_SYSTEM_ID |