RCV_TRANSACTIONS_INTERFACE
RCV_TRANSACTIONS_INTERFACE stores information about receiving transactions that are waiting to be processed by the receiving transaction processor or were rejected due to an error when the transaction processor attempted to process the transaction. When the receiving transaction processor successfully processes a transaction, it deletes the transaction from this table. Scope: public Lifecycle: active Display Name: RCV Transactions Interface Product: PO Category: BUSINESS_ENTITY PO_GOODS_RECEIPT Category: BUSINESS_ENTITY PO_EXPENSE_RECEIPT Category: BUSINESS_ENTITY PO_SERVICES_RECEIPTS Category: BUSINESS_ENTITY PO_GOODS_RETURN Category: BUSINESS_ENTITY PO_RECEIPT_CORRECTION
Details
-
Schema: FUSION
-
Object owner: RCV
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
RCV_TXN_INTERFACE_PK |
INTERFACE_TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| INTERFACE_TRANSACTION_ID | NUMBER | 18 | Yes | This column stores the Unique identifier for the receiving transaction interface row. | ||
| CONSUMED_QUANTITY | NUMBER | Supplier consigned Inventory consumed quantity. | ||||
| GROUP_ID | NUMBER | 18 | Interface group for set processing. All the interface records for a given value of group_id will be processed together. | |||
| 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. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| TRANSACTION_TYPE | VARCHAR2 | 25 | Yes | Receiving transaction type. References FND_LOOKUP_VALUES_B.LOOKUP_CODE, where lookup_type is RCV_TRANSACTION_TYPE. | ||
| TRANSACTION_DATE | DATE | Yes | This column stores the transaction date for the receiving transactions. | |||
| PROCESSING_STATUS_CODE | VARCHAR2 | 25 | Yes | Processing status of the interface row. Default value is PENDING. Other values are RUNNING, COMPLETED, ERROR. | ||
| PROCESSING_MODE_CODE | VARCHAR2 | 25 | Yes | Processing mode to be used when the interface row is processed. Defaulted to the value PENDING. Other values IMMEDIATE, BATCH. Maps to FND_LOOKUP_VALUES_B.LOOKUP_CODE where lookup_type = RCV_PROCESSING_MODE. | ||
| PROCESSING_REQUEST_ID | NUMBER | 18 | Identifier of the concurrent request that is processing the interface row. Set by the Receiving Transaction Processor | |||
| TRANSACTION_STATUS_CODE | VARCHAR2 | 25 | Yes | Transaction status of the interface row. Default value is PENDING. Other values are RUNNING, COMPLETED, ERROR. | ||
| CATEGORY_ID | NUMBER | 18 | This column stores the Item category unique identifier. | |||
| QUANTITY | NUMBER | This column stores the receiving transaction quantity stored in the receiving transaction UOM. | ||||
| UNIT_OF_MEASURE | VARCHAR2 | 25 | This column stores the unit of measure for the receiving transaction. | |||
| UOM_CODE | VARCHAR2 | 3 | This column stores the unit of measure code for the receiving transaction. | |||
| INTERFACE_SOURCE_CODE | VARCHAR2 | 30 | This column stores the source code for the interface row. | |||
| INTERFACE_SOURCE_LINE_ID | NUMBER | 18 | This column stores the source line unique identifier of the interface row. | |||
| INV_TRANSACTION_ID | NUMBER | 18 | This column stores the Inventory transaction unique identifier that created the in-transit shipment interface transaction row. Maps to INV_MATERIAL_TXNS.TRANSACTION_ID. | |||
| ITEM_ID | NUMBER | 18 | This column stores the inventory item unique identifier. | |||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | This column stores the purchase order line item description for PO receipts. For other documents, it stores the inventory item description. | |||
| ITEM_REVISION | VARCHAR2 | 18 | This column stores the revision number of the inventory item. | |||
| EMPLOYEE_ID | NUMBER | 18 | This column stores the Unique identifier for the person creating the receiving transaction. References PER_PERSON_NAMES_F.PERSON_ID. | |||
| AUTO_TRANSACT_CODE | VARCHAR2 | 25 | Automatic transaction creation code. Applicable values are SHIP, RECEIVE and DELIVER. This column is to be used when TRANSACTION_TYPE column of the interface row is RECEIVE or SHIP. | |||
| SHIPMENT_HEADER_ID | NUMBER | 18 | This column stores the receiving shipment receiving receipt header unique identifier. | |||
| SHIPMENT_LINE_ID | NUMBER | 18 | This column stores the receiving shipment receiving receipt header unique identifier. | |||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | This column stores the Receiving location unique identifier. | |||
| PRIMARY_QUANTITY | NUMBER | Receiving Transaction quantity in terms of the item's primary unit of measure. | ||||
| PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | 25 | This column stores the primary unit of measure of the item in the receiving organization. | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | This column stores the primary unit of measure code of the item in the receiving organization. | |||
| RECEIPT_SOURCE_CODE | VARCHAR2 | 25 | 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. | |||
| FROM_ORGANIZATION_ID | NUMBER | 18 | Source organization unique identifier for in-transit shipment. | |||
| TO_ORGANIZATION_ID | NUMBER | 18 | This column stores Receiving organization unique identifier where the receiving transaction is created. | |||
| ROUTING_HEADER_ID | NUMBER | 18 | This column stores the receiving routing unique identifier. Values: 1 (Standard receipt), 2 (Inspection required) and 3 (Direct delivery). | |||
| ROUTING_STEP_ID | NUMBER | 18 | This column stores the receiving routing step unique identifier. | |||
| 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. | |||
| PARENT_TRANSACTION_ID | NUMBER | 18 | This column stores the unique identifier of the parent receiving transaction. | |||
| PO_HEADER_ID | NUMBER | 18 | This column stores the purchase order header unique identifier. | |||
| PO_REVISION_NUM | NUMBER | 18 | This column stores the Purchase order revision number. | |||
| PO_LINE_ID | NUMBER | 18 | This column stores the purchase order line unique identifier. | |||
| PO_LINE_LOCATION_ID | NUMBER | 18 | This column stores the purchase order schedule unique identifier. | |||
| PO_UNIT_PRICE | NUMBER | This column stores the unit price from the purchase order line. | ||||
| CURRENCY_CODE | VARCHAR2 | 15 | This column stores the currency code for the receiving transaction. | |||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | This column stores the currency conversion rate type of the purchase order. Used for purchase order receipts only. | |||
| CURRENCY_CONVERSION_RATE | NUMBER | This column stores the currency conversion rate for the receipt. Used for purchase order receipts only. | ||||
| CURRENCY_CONVERSION_DATE | DATE | This column stores the currency conversion date for the receipt. Used for purchase order receipts only. | ||||
| PO_DISTRIBUTION_ID | NUMBER | 18 | This column stores the purchase order distribution unique identifier. | |||
| REQUISITION_LINE_ID | NUMBER | 18 | This column stores the requisition line unique identifier. | |||
| REQ_DISTRIBUTION_ID | NUMBER | 18 | This column stores the requisition distribution unique identifier. | |||
| SUBSTITUTE_UNORDERED_CODE | VARCHAR2 | 25 | Substitute or unordered receipt indicator. Has the value SUBSTITUTE when a substitute item is received. | |||
| RECEIPT_EXCEPTION_FLAG | VARCHAR2 | 1 | This column can be used to indicate that an exception was found when creating the receiving transaction. To create an exception, populate this column with 'Y'. | |||
| ACCRUAL_STATUS_CODE | VARCHAR2 | 25 | This column indicates the interface status of the receiving transaction from receiving to costing and is calculated by the system. | |||
| INSPECTION_STATUS_CODE | VARCHAR2 | 25 | This column stores the inspection status code. Valid Values are NOT INSPECTED, ACCEPTED, REJECTED. | |||
| INSPECTION_QUALITY_CODE | VARCHAR2 | 25 | This column stores the inspection quality code. References FND_LOOKUP_VALUES_B.LOOKUP_CODE where lookup_type is RCV_QUALITY_CODE. | |||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | This column stores the destination type code after the receiving transaction is created. | |||
| DELIVER_TO_PERSON_ID | NUMBER | 18 | This column stores the deliver to person, or requester, unique identifier. | |||
| LOCATION_ID | NUMBER | 18 | This column stores the Receiving location unique identifier. | |||
| DELIVER_TO_LOCATION_ID | NUMBER | 18 | This column stores the deliver to location unique identifier. | |||
| SUBINVENTORY | VARCHAR2 | 10 | This column stores the destination subinventory name for the receiving transaction. | |||
| LOCATOR_ID | NUMBER | 18 | This column stores the destination locator unique identifier for the receiving transaction. | |||
| WIP_ENTITY_ID | NUMBER | 18 | This column is not being used currently. | |||
| WIP_LINE_ID | NUMBER | 18 | This column is not being used currently. | |||
| DEPARTMENT_CODE | VARCHAR2 | 10 | This column is not being used currently. | |||
| WIP_REPETITIVE_SCHEDULE_ID | NUMBER | 18 | This column is not being used currently. | |||
| WIP_OPERATION_SEQ_NUM | NUMBER | 18 | This column is not being used currently. | |||
| WIP_RESOURCE_SEQ_NUM | NUMBER | 18 | This column is not being used currently. | |||
| BOM_RESOURCE_ID | NUMBER | 18 | This column is not being used currently. | |||
| 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. | |||
| FREIGHT_CARRIER_ID | NUMBER | 18 | This column stores the Freight Carrier unique identifier. | |||
| FREIGHT_CARRIER_NAME | VARCHAR2 | 360 | This column stores the Freight Carrier name. | |||
| 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. | ||||
| EXPECTED_RECEIPT_DATE | DATE | This column stores the Expected arrival date of the shipment. | ||||
| ACTUAL_COST | NUMBER | This column stores the actual cost for the in-transit shipment line. | ||||
| TRANSFER_COST | NUMBER | This column stores the cost of transferring items between organizations for an in-transit shipment. | ||||
| TRANSPORTATION_COST | NUMBER | This column stores the cost of transporting the items through an in-transit shipment. | ||||
| 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. | |||
| VENDOR_ITEM_NUM | VARCHAR2 | 300 | This column stores the supplier's item number. Maps to PO_LINES_ALL.VENDOR_PRODUCT_NUM. | |||
| VENDOR_LOT_NUM | VARCHAR2 | 30 | Lot number given by the supplier for PO receipts. | |||
| RMA_REFERENCE | VARCHAR2 | 30 | This column stores the supplier's RMA reference number when returning goods to supplier. | |||
| COMMENTS | VARCHAR2 | 240 | This column stores the note created by the receiver. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Transaction (RCV_TRANSACTIONS) | |||
| GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column. | |||
| REASON_ID | NUMBER | 18 | This column stores the inventory transaction reason unique identifier. | |||
| DESTINATION_CONTEXT | VARCHAR2 | 30 | Destination descriptive flexfield context. | |||
| SOURCE_DOC_QUANTITY | NUMBER | Transaction quantity in terms of the source document's unit of measure. | ||||
| SOURCE_DOC_UNIT_OF_MEASURE | VARCHAR2 | 25 | This column stores the source document's unit of measure. Used to derive SOURCE_DOC_UOM_CODE. | |||
| SOURCE_DOC_UOM_CODE | VARCHAR2 | 3 | This column stores the source document's unit of measure code. | |||
| FROM_SUBINVENTORY | VARCHAR2 | 10 | This column stores the source subinventory name for the receiving transaction. | |||
| INTRANSIT_OWNING_ORG_ID | NUMBER | 18 | Owner organization unique identifier for in-transit shipments. | |||
| MOVEMENT_ID | NUMBER | 18 | This column stores the movement identifier. | |||
| USE_MTL_LOT | NUMBER | 18 | This column corresponds to the lot control code of the item in the receiving organization. | |||
| USE_MTL_SERIAL | NUMBER | 18 | This column corresponds to the serial number control code of the item in the receiving organization. | |||
| HEADER_INTERFACE_ID | NUMBER | 18 | Unique identifier for the receipt header interface record for which this transaction interface record is created. Maps to RCV_HEADERS_INTERFACE.HEADER_INTERFACE_ID. | |||
| VENDOR_CUM_SHIPPED_QTY | NUMBER | Supplier's CUM quantity shipped specified on the Advance Shipment Notice (ASN). | ||||
| ITEM_NUM | VARCHAR2 | 300 | This column stores the item number for the receiving transaction. Used to derive ITEM_ID. | |||
| DOCUMENT_NUM | VARCHAR2 | 30 | This column stores the document number for the receiving transaction. Used to derive the document Id (PO_HEADER_ID, SHIPMENT_HEADER_ID, RECEIPT_ADVICE_HEADER_ID). | |||
| DOCUMENT_LINE_NUM | NUMBER | 18 | This column stores the document line number for the receiving transaction. Used to derive the document line Id (PO_LINE_ID, SHIPMENT_LINE_ID, RECEIPT_ADVICE_LINE_ID). | |||
| TRUCK_NUM | VARCHAR2 | 35 | This column stores the truck number specified in the shipment line. | |||
| SHIP_TO_LOCATION_CODE | VARCHAR2 | 60 | This column stores the receiving location code. Used to derive SHIP_TO_LOCATION_ID. | |||
| CONTAINER_NUM | VARCHAR2 | 35 | This column stores the container number for the receiving shipment receipt line. | |||
| SUBSTITUTE_ITEM_NUM | VARCHAR2 | 300 | This column stores the substitute item number for a receipt line. Used to derive SUBSTITUTE_ITEM_ID. | |||
| NOTICE_UNIT_PRICE | NUMBER | This column stores the EDI transaction 857 unit price for the item in the shipment line. | ||||
| ITEM_CATEGORY | VARCHAR2 | 81 | This column stores the item category. Used to derive CATEGORY_ID. | |||
| LOCATION_CODE | VARCHAR2 | 60 | This column stores the receiving location code. Used to derive LOCATION_ID. | |||
| VENDOR_NAME | VARCHAR2 | 240 | This column stores the supplier name and is used to derive VENDOR_ID. | |||
| VENDOR_NUM | VARCHAR2 | 30 | This column stores the supplier number and is used to derive VENDOR_ID. | |||
| VENDOR_SITE_CODE | VARCHAR2 | 240 | This column stores the supplier site code and is used in conjunction with BU_ID to derive VENDOR_SITE_ID. | |||
| FROM_ORGANIZATION_CODE | VARCHAR2 | 18 | This column stores the from organization code for inter-organization transfers and is used to derive FROM_ORGANIZATION_ID. | |||
| TO_ORGANIZATION_CODE | VARCHAR2 | 18 | This column stores Receiving organization code where the receiving transaction is created. Used to derive TO_ORGANIZATION_ID. | |||
| INTRANSIT_OWNING_ORG_CODE | VARCHAR2 | 18 | In-transit owning organization code for inter-organization transfers. Used to derive INTRANSIT_OWNING_ORG_ID. | |||
| ROUTING_CODE | VARCHAR2 | 30 | This column stores the receiving routing code. Maps to FND_LOOKUP_VALUES_B.LOOKUP_CODE where lookup_type = 'RCV_ROUTING_HEADERS' | |||
| ROUTING_STEP | VARCHAR2 | 30 | This column stores the upgrade step unique identifier. | |||
| DOCUMENT_SHIPMENT_LINE_NUM | NUMBER | 18 | This column stores the document number for the receiving transaction. Used to derive PO_LINE_LOCATION_ID. | |||
| DOCUMENT_DISTRIBUTION_NUM | NUMBER | 18 | This column stores the document number for the receiving transaction. Used to derive document distribution Id (PO_DISTRIBUTION_ID, TRANSFER_ORDER_DIST_ID). | |||
| DELIVER_TO_PERSON_NAME | VARCHAR2 | 240 | This column stores the deliver-to person, or requester name. This maps to PER_PERSON_NAMES_F.FULL_NAME and is used to derive DELIVER_TO_PERSON_ID. | |||
| DELIVER_TO_LOCATION_CODE | VARCHAR2 | 60 | This column stores the deliver-to location code. Used to derive DELIVER_TO_LOCATION_ID. | |||
| LOCATOR | VARCHAR2 | 81 | This column stores the concatenated segments of the destination locator. Used to derive LOCATOR_ID. | |||
| REASON_NAME | VARCHAR2 | 30 | This column stores the inventory transaction reason name. Used to derive REASON_ID. | |||
| VALIDATION_FLAG | VARCHAR2 | 1 | Flag to indicate if row needs to be validated before being processed. When creating rows from receiving open interface, the value of this column must be 'Y'. | |||
| SUBSTITUTE_ITEM_ID | NUMBER | 18 | This column stores the Buyer's substitute item unique identifier. | |||
| QUANTITY_SHIPPED | NUMBER | This column stores the quantity shipped for a shipment line. | ||||
| QUANTITY_INVOICED | NUMBER | This column stores the total quantity that has been invoiced for the shipment line. | ||||
| TAX_NAME | VARCHAR2 | 15 | EDI transaction 857 tax name indicated at the detail level. | |||
| TAX_AMOUNT | NUMBER | EDI transaction 857 tax amount indicated at the detail level. | ||||
| REQ_NUM | VARCHAR2 | 25 | This column maps to the requisition number and is used to derive REQ_LINE_ID. | |||
| REQ_LINE_NUM | NUMBER | 18 | This column maps to the requisition line number and is used to derive REQUISITION_LINE_ID. | |||
| REQ_DISTRIBUTION_NUM | NUMBER | 18 | This column maps to the requisition distribution number and is used to derive REQ_DISTRIBUTION_ID. | |||
| WIP_ENTITY_NAME | VARCHAR2 | 24 | This column is not being used currently. | |||
| WIP_LINE_CODE | VARCHAR2 | 10 | This column is not being used currently. | |||
| RESOURCE_CODE | VARCHAR2 | 30 | This column is not being used currently. | |||
| SHIPMENT_LINE_STATUS_CODE | VARCHAR2 | 25 | This column stores the shipment line status code. Values: EXPECTED, PARTIALLY RECEIVED, FULLY RECEIVED, CANCELLED. | |||
| BARCODE_LABEL | VARCHAR2 | 35 | Bar-coded detail label serial number if indicated on ASN for inner packaging of this item; to be matched for barcode-scanned receipts updating. | |||
| TRANSFER_PERCENTAGE | NUMBER | This column stores the transfer percentage for costing. | ||||
| QA_COLLECTION_ID | NUMBER | 18 | This column is not being used currently. | |||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | This column stores the code for the country of manufacture. | |||
| CUSTOMER_ID | NUMBER | 18 | Customer unique identifier. Applicable for RMA transactions. | |||
| CUSTOMER_SITE_ID | NUMBER | 18 | Customer site unique identifier. Applicable for RMA transactions. | |||
| CUSTOMER_ITEM_NUM | VARCHAR2 | 50 | This column stores customer's item number. Used to derive CUSTOMER_ITEM_ID. | |||
| CREATE_DEBIT_MEMO_FLAG | VARCHAR2 | 1 | Flag which determines if a debit memo has to be created or not. | |||
| PUT_AWAY_RULE_ID | NUMBER | 18 | This column is not being used currently. | |||
| PUT_AWAY_STRATEGY_ID | NUMBER | 18 | This column is not being used currently. | |||
| LPN_ID | NUMBER | 18 | This column stores the source packing unit unique identifier of the receiving transaction. | |||
| TRANSFER_LPN_ID | NUMBER | 18 | This column stores the transfer packing unit unique identifier of the receiving transaction. | |||
| MOBILE_TXN | VARCHAR2 | 2 | This column is not being used currently. | |||
| MMTT_TEMP_ID | NUMBER | 18 | This column is not being used currently. | |||
| SECONDARY_QUANTITY | NUMBER | This column stores the receiving transaction quantity in the item's secondary unit of measure. | ||||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | 25 | This column stores the secondary unit of measure of the inventory item in the receiving organization. | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | This column stores the secondary unit of measure code of the inventory item in the receiving organization. | |||
| QC_GRADE | VARCHAR2 | 150 | This column is not being used currently. | |||
| FROM_LOCATOR | VARCHAR2 | 81 | This column stores the concatenated segments of the source locator. Used to derive FROM_LOCATOR_ID. | |||
| FROM_LOCATOR_ID | NUMBER | 18 | This column stores the source locator unique identifier for the receiving transaction. | |||
| PARENT_SOURCE_TRANSACTION_NUM | VARCHAR2 | 25 | This column stores the parent source transaction number. Maps to SOURCE_TRANSACTION_NUM of the parent transaction and is used to derive parent_transaction_id/parent_interface_txn_id. | |||
| INTERFACE_AVAILABLE_QTY | NUMBER | This column stores the available quantity for the rcv_transactions_interface rows which are tagged as children of the current rcv_transactions_interface row. | ||||
| INTERFACE_TRANSACTION_QTY | NUMBER | This column stores the available transaction quantity when transacting against the interface line. | ||||
| INTERFACE_AVAILABLE_AMT | NUMBER | This column stores the available amount for the rcv_transactions_interface rows which are tagged as children of the current rcv_transactions_interface row. | ||||
| INTERFACE_TRANSACTION_AMT | NUMBER | This column stores the available transaction amount when transacting against the interface line. | ||||
| LICENSE_PLATE_NUMBER | VARCHAR2 | 30 | This column stores the source packing unit number and is used to derive LPN_ID. | |||
| SOURCE_TRANSACTION_NUM | VARCHAR2 | 25 | This column stores the source transaction number and can be used to store the unique transaction identifier in the source system. This value must be unique across all records in rcv_transactions and rcv_transactions_interface. | |||
| TRANSFER_LICENSE_PLATE_NUMBER | VARCHAR2 | 30 | This column stores the transfer packing unit number and is used to derive TRANSFER_LPN_ID. | |||
| LPN_GROUP_ID | NUMBER | 18 | This column stores the unique identifier for the group where the transactions associated to a given LPN are processed atomically. | |||
| ORDER_TRANSACTION_ID | NUMBER | 18 | This column stores the order transaction unique identifier. | |||
| CUSTOMER_ACCOUNT_NUMBER | NUMBER | 18 | Customer account number. Used to derive customer_id. | |||
| CUSTOMER_PARTY_NAME | VARCHAR2 | 360 | Customer Party Name. Used to derive customer_id. Maps to HZ_PARTIES.PARTY_NAME. | |||
| PARENT_INTERFACE_TXN_ID | NUMBER | 18 | This column stores the INTERFACE_TRANSACTION_ID of the RCV_TRANSACTIONS_INTERFACE row that is the parent of the current row. Maps to rcv_transactions_interface.interface_transaction_id. | |||
| CUSTOMER_ITEM_ID | NUMBER | 18 | This column stores the customer item unique identifier. | |||
| AMOUNT | NUMBER | Transaction Amount in purchase order currency. Applicable for fixed price lines. | ||||
| JOB_ID | NUMBER | 18 | This column is not being used currently. | |||
| TIMECARD_ID | NUMBER | 18 | This column is not being used currently. | |||
| TIMECARD_OVN | NUMBER | 18 | This column is not being used currently. | |||
| ERECORD_ID | NUMBER | 18 | This column stores the unique identifier of the electronic record. | |||
| PROJECT_ID | NUMBER | 18 | Identifier of the project corresponding to the source document and is propagated to the inventory transactions. | |||
| TASK_ID | NUMBER | 18 | Identifier of the task corresponding to the source document and is propagated to the inventory transactions. | |||
| ASN_ATTACH_ID | NUMBER | 18 | This column is not being used currently. | |||
| BU_ID | NUMBER | 18 | Business Unit Unique Identifier. For Purchase Order receipts, this column refers to Procurement BU identifier of the supplier site. For RMA receipts, this column refers to the RMA business unit identifier. | |||
| BUSINESS_UNIT | VARCHAR2 | 240 | Business Unit Name used to derive BU_ID. For Purchase Order receipts, this column refers to Procurement Business Unit of the supplier site. For RMA receipts, this column refers to the RMA business unit. | |||
| REQUESTED_AMOUNT | NUMBER | This column is not being used currently. | ||||
| MATERIAL_STORED_AMOUNT | NUMBER | This column is not being used currently. | ||||
| AMOUNT_SHIPPED | NUMBER | Amount shipped for a fixed price service receipt line in purchase order currency. | ||||
| MATCHING_BASIS | VARCHAR2 | 30 | This column refers to the matching basis of the purchase order schedule. | |||
| REPLENISH_ORDER_LINE_ID | NUMBER | 18 | Replenishment sales order line unique identifier for chargeable subcontracting component. | |||
| 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. | ||
| RA_OUTSOURCER_PARTY_ID | NUMBER | 18 | This column stores the Logistics service provider customer party unique identifier. | |||
| RA_OUTSOURCER_PARTY_NAME | VARCHAR2 | 240 | This column stores the Logistics service provider customer party name. Used to derive RA_OUTSOURCER_PARTY_ID. | |||
| 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. | |||
| RECEIPT_ADVICE_LINE_NUMBER | VARCHAR2 | 80 | This column stores the Receipt advice line 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_NUMBER | VARCHAR2 | 80 | Source document number for the receipt advice. Applicable to RMA and flexible supply source documents. | |||
| RA_DOCUMENT_LINE_NUMBER | VARCHAR2 | 80 | Source document line number for the receipt advice line. Applicable to RMA and flexible supply source documents. | |||
| RA_DOC_SCHEDULE_NUMBER | VARCHAR2 | 80 | Source document schedule number for the receipt advice line. Applicable to RMA and flexible supply source documents. | |||
| RA_DOO_HEADER_NUMBER | VARCHAR2 | 80 | Header number reference in Distributed Order Orchestration corresponding to the RMA. | |||
| RA_DOO_LINE_NUMBER | VARCHAR2 | 80 | Line number reference in Distributed Order Orchestration corresponding to the RMA. | |||
| RA_DOO_FULFILLMENT_LINE_NUMBER | VARCHAR2 | 80 | Fulfillment line number reference in Distributed Order Orchestration corresponding to the RMA. | |||
| RA_EXPECTED_RECEIPT_DATE | DATE | Expected arrival date for Receipt advice line. Applicable to RMA and flexible supply source documents. | ||||
| RA_DOC_LINE_CREATION_DATE | DATE | Source document line creation date for Receipt advice line. Applicable to RMA and flexible supply source documents. | ||||
| RA_DOC_LINE_LAST_UPDATE_DATE | DATE | Source document line last update date for Receipt advice line. Applicable to RMA and flexible supply source documents. | ||||
| RA_DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | Number of days allowed for an early receipt against receipt advice line. Applicable to RMA and flexible supply source documents. | ||||
| RA_DAYS_LATE_RECEIPT_ALLOWED | NUMBER | Number of days allowed for a late receipt against receipt advice line. Applicable to RMA and flexible supply source documents. | ||||
| RA_RECEIPT_DAYS_EXCEPTION_CODE | VARCHAR2 | 25 | Receipt days exception level for receipt advice line. Applicable to RMA and flexible supply source documents. | |||
| RA_ENFORCE_SHIP_TO_LOC_CODE | VARCHAR2 | 25 | Ship-to location control exception control for receipt advice line. Applicable to flexible supply source documents. | |||
| RA_ALLOW_SUBSTITUTE_RECEIPT | VARCHAR2 | 1 | Allow receipt of substitute items control for receipt advice line. Applicable to flexible supply source documents. | |||
| RA_QTY_RCV_TOLERANCE | NUMBER | Over receipt quantity tolerance for Receipt advice line. Applicable to RMA and flexible supply source documents. | ||||
| RA_QTY_RCV_EXCEPTION_CODE | VARCHAR2 | 25 | Over receipt quantity tolerance exception level for Receipt advice line. Applicable to RMA and flexible supply source documents. | |||
| RA_NOTE_TO_RECEIVER | VARCHAR2 | 480 | Note to receiver specified in the receipt advice line. Applicable to RMA and flexible supply source documents. | |||
| RECEIPT_ADVICE_HEADER_ID | NUMBER | 18 | This column stores the Receipt advice header unique identifier for receiving transactions against RMA and flexible supply source documents. | |||
| RECEIPT_ADVICE_LINE_ID | NUMBER | 18 | This column stores the Receipt advice line unique identifier for receiving transactions against RMA and flexible supply source documents. | |||
| RA_ORIG_DOO_HEADER_NUMBER | VARCHAR2 | 80 | Original order number reference in Distributed Order Orchestration corresponding to the RMA. | |||
| RA_ORIG_DOO_LINE_NUMBER | VARCHAR2 | 80 | Original order line number reference in Distributed Order Orchestration corresponding to the RMA. | |||
| RA_ORIG_DOO_FULFIL_LINE_NUM | VARCHAR2 | 80 | Original Sales order number reference corresponding to the RMA. | |||
| RA_ORIG_OC_HEADER_NUMBER | VARCHAR2 | 80 | Original Sales order line number reference corresponding to the RMA. | |||
| RA_ORIG_OC_LINE_NUMBER | VARCHAR2 | 80 | Original fulfillment line number reference in distributed order orchestration corresponding to the RMA. | |||
| RA_VENDOR_SITE_NAME | VARCHAR2 | 240 | Supplier site party name for Receipt advice. Used to derive VENDOR_ID for flexible supply source documents. References HZ_PARTY_SITES.PARTY_SITE_NAME. | |||
| SP_QUANTITY | NUMBER | Transaction quantity represented in terms of standard pack UOM. | ||||
| SP_UOM_CODE | VARCHAR2 | 3 | This column stores the Standard pack unit of measure code. | |||
| SP_GROUP_ID | NUMBER | 18 | This column stores Unique identifier used for grouping standard pack receipts. | |||
| PARENT_SP_GROUP_ID | NUMBER | 18 | This column stores the Standard pack grouping identifier for the parent transaction. | |||
| TRANSFER_ORDER_HEADER_ID | NUMBER | 18 | This column stores the Transfer order header unique identifier. References INV_TRANSFER_ORDER_HEADERS.HEADER_ID. | |||
| TRANSFER_ORDER_LINE_ID | NUMBER | 18 | This column stores the Transfer order line unique identifier. References INV_TRANSFER_ORDER_LINES.LINE_ID. | |||
| TRANSFER_ORDER_DIST_ID | NUMBER | 18 | This column stores the Transfer order line unique identifier. References INV_TRANSFER_ORDER_DISTRIBS.DISTRIBUTION_ID. | |||
| PHYSICAL_RETURN_REQD | VARCHAR2 | 1 | Indicates if physical return of material is required for returns against a transfer order. | |||
| CONSIGNED_FLAG | VARCHAR2 | 1 | This column if the receiving transaction is created for consigned material. | |||
| BACK_TO_BACK_FLAG | VARCHAR2 | 1 | This column indicates if the receiving transaction is created for a back-to-back order. | |||
| SOLDTO_LE_ID | NUMBER | 18 | Sold-to Legal Entity Unique Identifier. This column is used to derive PO_HEADER_ID in conjunction with DOCUMENT_NUM. | |||
| SOLDTO_LEGAL_ENTITY | VARCHAR2 | 240 | This column stores the Sold-to Legal Entity name and is used to derive SOLDTO_LE_ID. | |||
| FIRST_PTY_REG_ID | NUMBER | 18 | Tax Determinant: First party tax registration ID for the receiving transaction. | |||
| THIRD_PTY_REG_ID | NUMBER | 18 | Tax Determinant: Third party tax registration ID for the receiving transaction. | |||
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Tax Determinant: Default taxation country code for the receiving transaction. | |||
| DOCUMENT_FISCAL_CLASSIFICATION | VARCHAR2 | 240 | Tax Determinant: Document Fiscal Classification. Also known as Tax Document Subtype. | |||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Tax Determinant: Transaction business category code. | |||
| TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Tax Determinant: The number of the Fiscal Document. | |||
| TAX_INVOICE_DATE | DATE | Tax Determinant: Date of the Fiscal Document. | ||||
| SHIP_FROM_LOCATION_ID | NUMBER | 18 | Tax Determinant: Ship from location unique identifier for the receiving transaction. | |||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | Tax Determinant: User defined fiscal classification code. | |||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | 50 | Tax Determinant: Tax Classification Code for the receiving transaction. | |||
| PRODUCT_FISC_CLASS_ID | NUMBER | 18 | Tax Determinant: Product fiscal classification id for the inventory item. | |||
| INTENDED_USE | VARCHAR2 | 240 | Tax Determinant: Intended use code of the receiving transaction. This identifies the purpose for which the product is used. | |||
| INTENDED_USE_CLASSIF_ID | NUMBER | 18 | Tax Determinant: Intended use classification unique identifier for the receiving transaction. | |||
| PRODUCT_TYPE | VARCHAR2 | 240 | Tax Determinant: Product type code of the inventory item. Possible values are GOODS and SERVICES. | |||
| PRODUCT_CATEGORY | VARCHAR2 | 240 | Tax Determinant: Product category code of the receiving transaction. | |||
| ASSESSABLE_VALUE | NUMBER | Tax Determinant: This is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes. | ||||
| FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | Tax Determinant: The final discharge location identifier. | |||
| LOAD_REQUEST_ID | NUMBER | 18 | Used by Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | |||
| DS_RECEIPT_EVENT_TYPE | VARCHAR2 | 100 | Identifies the source that triggers the creation of the Drop Ship Receipt. | |||
| DS_RECEIPT_SOURCE_LINE_ID | NUMBER | 18 | Source document line that created the Drop Ship Receipt. | |||
| HEADER_INTERFACE_NUM | VARCHAR2 | 30 | Alternate Key for HEADER_INTERFACE_ID for a load_request_id. Used by SAAS processing. | |||
| INTERFACE_LINE_NUM | VARCHAR2 | 30 | Alternate Key for INTERFACE_TRANSACTION_ID for a load_request_id. Used by SAAS processing. | |||
| LPN_GROUP_NUM | VARCHAR2 | 30 | Alternate Key for LPN_GROUP_ID for a load_request_id. Used by SAAS processing. | |||
| PARENT_INTF_LINE_NUM | VARCHAR2 | 30 | Alternate Key for PARENT_INTERFACE_TXN_ID for a load_request_id. Used by SAAS processing. | |||
| ASN_LINE_NUM | NUMBER | 18 | Used to derive Shipment_line_id column when creating receipts against ASN through the Receiving Open Interface. | |||
| EMPLOYEE_NAME | VARCHAR2 | 240 | This column stores the name of the person creating the receiving transaction and is used to derive EMPLOYEE_ID. References PER_PERSON_NAMES_F.FULL_NAME. | |||
| FISCAL_DOC_HEADER_ID | NUMBER | 18 | This column stores the unique identifier for the fiscal document header. | |||
| FISCAL_DOC_ACCESS_KNUM | VARCHAR2 | 64 | This column stores the access key number corresponding to the fiscal document. | |||
| FISCAL_DOC_LINE_ID | NUMBER | 18 | This column stores the unique identifier for the fiscal document line. | |||
| REF_FISCAL_DOC_HEADER_ID | NUMBER | 18 | This column stores the unique identifier for the reference fiscal document header. | |||
| REF_FISCAL_DOC_LINE_ID | NUMBER | 18 | This column stores the unique identifier for the reference fiscal document line. | |||
| REF_FISCAL_DOC_ACCESS_KNUM | VARCHAR2 | 64 | This column stores the access key number corresponding to the reference fiscal document. | |||
| FIRST_PTY_NUMBER | VARCHAR2 | 30 | Tax Determinant: First party tax registration number for the receiving transaction. Used to derive FIRST_PTY_REG_ID. | |||
| THIRD_PTY_NUMBER | VARCHAR2 | 30 | Tax Determinant: Third party tax registration number for the receiving transaction. Used to derive THIRD_PTY_REG_ID. | |||
| PRODUCT_FISC_CLASS_NAME | VARCHAR2 | 250 | Tax Determinant: Product Fiscal Classification Name required for alternate key for Product Fiscal Classification ID. | |||
| FINAL_DISCHARGE_LOC_CODE | VARCHAR2 | 60 | Tax Determinant: Final Discharge Location Code. Used to derive FINAL_DISCHARGE_LOCATION_ID. | |||
| INTF_FROM_EXT_SYSTEM_FLAG | VARCHAR2 | 1 | This column holds value Y or N depending on whether this record is interfaced by an external system or not. | |||
| RCPT_CONF_INTF_TXN_ID | NUMBER | 18 | This column stores the unique identifier of receipt confirmation interface row. References RCV_RECEIPT_CONF_INT.RCPT_CONF_INTF_TXN_ID. | |||
| FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | This column stores the unique identifier for the fiscal document schedule. | |||
| REF_FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | This column stores the unique identifier for the reference fiscal document schedule. | |||
| QA_IP_EVENT_ID | NUMBER | 18 | Unique identifier for the QA Inspection event corresponding to the receiving ACCEPT or REJECT transaction. References QA_IP_EVENTS.IP_EVENT_ID. | |||
| QA_SKIP_INSPECTION | VARCHAR2 | 1 | This column indicates whether quality results is skipped for this receiving inspection transaction row. | |||
| CUSTOMER_PARTY_NUMBER | VARCHAR2 | 30 | Unique identifier for customer party number. Used to derive CUSTOMER_ID in conjunction with CUSTOMER_PARTY_NUMBER. Maps to HZ_PARTIES.PARTY_NUMBER. | |||
| EXTERNAL_SYSTEM_PACKING_UNIT | VARCHAR2 | 150 | This column stores the license plate number of the external Warehouse Management System (WMS). | |||
| RSL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Shipment line descriptive flexfield: structure definition of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE1 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE2 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE3 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE4 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE5 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE6 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE7 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE8 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE9 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE10 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE11 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE12 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE13 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE14 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE15 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE16 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE17 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE18 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE19 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE20 | VARCHAR2 | 150 | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | |||
| RSL_ATTRIBUTE_NUMBER1 | NUMBER | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_NUMBER2 | NUMBER | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_NUMBER3 | NUMBER | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_NUMBER4 | NUMBER | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_NUMBER5 | NUMBER | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_NUMBER6 | NUMBER | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_NUMBER7 | NUMBER | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_NUMBER8 | NUMBER | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_NUMBER9 | NUMBER | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_NUMBER10 | NUMBER | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_DATE1 | DATE | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_DATE2 | DATE | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_DATE3 | DATE | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_DATE4 | DATE | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_DATE5 | DATE | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| RSL_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Shipment line descriptive flexfield: segment of the shipment line user descriptive flexfield. | ||||
| EWAY_BILL_NUMBER | NUMBER | 18 | This column stores the e-Way Bill number provided by supplier for receipt of goods. | |||
| EWAY_BILL_DATE | DATE | This column stores the date on which the e-Way Bill was generated. | ||||
| INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes. | |||
| INV_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality. | |||
| INV_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality. | |||
| INV_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | |||
| RECALL_HEADER_ID | NUMBER | 18 | This column stores the Recall Notice Header Unique identifier. | |||
| RECALL_LINE_ID | NUMBER | 18 | This column stores the Recall Notice Line unique identifier. | |||
| RECALL_NOTICE_NUMBER | VARCHAR2 | 60 | Recall Notice number used for internal tracking within the enterprise which gets generated based on document sequencing setup. | |||
| RECALL_LINE_NUMBER | NUMBER | 18 | Recall Notice Line Number entered by the user. | |||
| EXTERNAL_SYS_TXN_REFERENCE | VARCHAR2 | 300 | This column is used to store the link to the document references passed by external WMS or 3PL systems. | |||
| DEFAULT_LOTSER_FROM_ASN | VARCHAR2 | 1 | Check box option whether to default lot and serial numbers from an ASN or ASBN when executing a receipt or putaway transaction, without having to go to the record lot and serial numbers page. | |||
| WORK_CONFIRMATION_ID | NUMBER | 18 | Value that uniquely identifies the work confirmation. This column is internally populated by procurement during automatic receipts on approval of the work confirmation. | |||
| WORK_CONFIRMATION_LINE_ID | NUMBER | 18 | Value that uniquely identifies the work confirmation line. This column is internally populated by procurement during automatic receipts on approval of the work confirmation. | |||
| DEFAULT_LOTSER_FROM_TO | VARCHAR2 | 1 | Check box option whether to default lot and serial numbers from a transfer order shipment when executing a receipt or putaway transaction, without having to go to the record lot and serial numbers page. | |||
| DIRECT_TRANSFER_ORDER_FLAG | VARCHAR2 | 1 | This column indicates if the current transaction belongs to a transfer order that has been shipped directly from source to destination locations. Valid values are Y and NULL. | |||
| FOB_LOOKUP_CODE | VARCHAR2 | 30 | Type of free-on-board terms for the ASN. References FND_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE is FOB. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RCV_TRANSACTIONS_INTERFACE | po_headers_all | PO_HEADER_ID |
| RCV_TRANSACTIONS_INTERFACE | po_lines_all | PO_LINE_ID |
| RCV_TRANSACTIONS_INTERFACE | po_line_locations_all | PO_LINE_LOCATION_ID |
| RCV_TRANSACTIONS_INTERFACE | inv_material_txns | INV_TRANSACTION_ID |
| RCV_TRANSACTIONS_INTERFACE | po_distributions_all | PO_DISTRIBUTION_ID |
| RCV_TRANSACTIONS_INTERFACE | por_requisition_lines_all | REQUISITION_LINE_ID |
| RCV_TRANSACTIONS_INTERFACE | por_req_distributions_all | REQ_DISTRIBUTION_ID |
| RCV_TRANSACTIONS_INTERFACE | inv_secondary_inventories | SUBINVENTORY, TO_ORGANIZATION_ID |
| RCV_TRANSACTIONS_INTERFACE | inv_item_locations | LOCATOR_ID |
| RCV_TRANSACTIONS_INTERFACE | gl_daily_conversion_types | CURRENCY_CONVERSION_TYPE |
| RCV_TRANSACTIONS_INTERFACE | inv_transaction_reasons_b | REASON_ID |
| RCV_TRANSACTIONS_INTERFACE | rcv_shipment_headers | SHIPMENT_HEADER_ID |
| RCV_TRANSACTIONS_INTERFACE | rcv_shipment_lines | SHIPMENT_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| RCV_TXN_INTERFACE_N1 | Non Unique | Default | GROUP_ID | |
| RCV_TXN_INTERFACE_N10 | Non Unique | Default | SHIPMENT_LINE_ID | |
| RCV_TXN_INTERFACE_N11 | Non Unique | Default | TRANSFER_LPN_ID, LPN_ID, TO_ORGANIZATION_ID | |
| RCV_TXN_INTERFACE_N12 | Non Unique | Default | LPN_GROUP_ID | |
| RCV_TXN_INTERFACE_N13 | Non Unique | Default | PO_HEADER_ID | |
| RCV_TXN_INTERFACE_N14 | Non Unique | Default | DOCUMENT_NUM | |
| RCV_TXN_INTERFACE_N15 | Non Unique | Default | PROCESSING_REQUEST_ID | |
| RCV_TXN_INTERFACE_N16 | Non Unique | Default | SHIPMENT_HEADER_ID | |
| RCV_TXN_INTERFACE_N17 | Non Unique | Default | LOAD_REQUEST_ID, PROCESSING_STATUS_CODE, HEADER_INTERFACE_NUM | |
| RCV_TXN_INTERFACE_N18 | Non Unique | Default | INTERFACE_LINE_NUM | Obsolete |
| RCV_TXN_INTERFACE_N19 | Non Unique | Default | EXTERNAL_SYS_TXN_REFERENCE | |
| RCV_TXN_INTERFACE_N2 | Non Unique | Default | PARENT_TRANSACTION_ID | |
| RCV_TXN_INTERFACE_N20 | Non Unique | Default | INTERFACE_LINE_NUM, LOAD_REQUEST_ID | |
| RCV_TXN_INTERFACE_N3 | Non Unique | Default | EMPLOYEE_ID | |
| RCV_TXN_INTERFACE_N4 | Non Unique | Default | DELIVER_TO_PERSON_ID | |
| RCV_TXN_INTERFACE_N5 | Non Unique | Default | PO_LINE_LOCATION_ID | |
| RCV_TXN_INTERFACE_N6 | Non Unique | Default | HEADER_INTERFACE_ID | |
| RCV_TXN_INTERFACE_N7 | Non Unique | Default | RECEIPT_ADVICE_LINE_ID | |
| RCV_TXN_INTERFACE_N8 | Non Unique | Default | TRANSACTION_STATUS_CODE, PO_DISTRIBUTION_ID | |
| RCV_TXN_INTERFACE_N9 | Non Unique | Default | PROCESSING_STATUS_CODE, HEADER_INTERFACE_ID | |
| RCV_TXN_INTERFACE_U1 | Unique | Default | INTERFACE_TRANSACTION_ID |