RCV_TRANSACTIONS
RCV_TRANSACTIONS stores historical information about receiving transactions that you have performed. When you enter a receiving transaction and the receiving transaction processor processes your transaction, the transaction is recorded in this table. . Once a row has been inserted into this table, it will never be updated. When you correct a transaction, the net transaction quantity is maintained in RCV_SUPPLY. The original transaction quantity does not get updated. You can only delete rows from this table using the Purge feature of Oracle Purchasing. .
Details
-
Schema: FUSION
-
Object owner: RCV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
RCV_TRANSACTIONS_PK |
TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | This column stores the unique identifier for the current receiving transaction row. | ||
| INTF_RETURNS_TO_SHIPPING | VARCHAR2 | 1 | Populated as Y for Returns transactions if the print shipping document API is called. | |||
| CONSUMED_QUANTITY | NUMBER | Supplier consigned Inventory consumed quantity. | ||||
| 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. | |||
| QUANTITY | NUMBER | This column stores the receiving transaction quantity stored in the receiving transaction UOM. | ||||
| UOM_CODE | VARCHAR2 | 3 | This column stores the unit of measure code for the receiving transaction. | |||
| SHIPMENT_HEADER_ID | NUMBER | 18 | Yes | This column stores the receiving shipment receiving receipt header unique identifier. | ||
| SHIPMENT_LINE_ID | NUMBER | 18 | Yes | This column stores the receiving shipment receiving receipt header unique identifier. | ||
| USER_ENTERED_FLAG | VARCHAR2 | 1 | Yes | This column indicates where the current receiving transaction row is user-entered or automatically generated. | ||
| INTERFACE_SOURCE_CODE | VARCHAR2 | 25 | 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. | |||
| 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. | |||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | This column stores the destination type code when the receiving transaction is created. | |||
| PRIMARY_QUANTITY | NUMBER | Receiving Transaction quantity in terms of the item's primary unit of measure. | ||||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | This column stores the primary unit of measure code of the item in the receiving organization. | |||
| 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. | |||
| 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_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_DISTRIBUTION_ID | NUMBER | 18 | This column stores the purchase order distribution unique identifier. | |||
| PO_REVISION_NUM | NUMBER | 18 | This column stores the Purchase order revision number. | |||
| REQUISITION_LINE_ID | NUMBER | 18 | This column stores the requisition line 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. | ||||
| 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. | |||
| DELIVER_TO_PERSON_ID | NUMBER | 18 | This column stores the deliver to person, or requester, unique identifier. | |||
| DELIVER_TO_LOCATION_ID | NUMBER | 18 | This column stores the deliver to location unique identifier. | |||
| 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 | This column stores Receiving organization unique identifier where the receiving transaction is created. | |||
| 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. | |||
| 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. | |||
| LOCATION_ID | NUMBER | 18 | This column stores the Receiving location or the deliver to location 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. | |||
| INSPECTION_STATUS_CODE | VARCHAR2 | 25 | This column stores the inspection status code. Valid Values are NOT INSPECTED, ACCEPTED, REJECTED. | |||
| 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. Values are PENDING, INTERFACED, ERROR. | |||
| 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. | |||
| 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) | |||
| REQ_DISTRIBUTION_ID | NUMBER | 18 | This column stores the requisition distribution unique identifier. | |||
| DEPARTMENT_CODE | VARCHAR2 | 10 | This column is not being used currently. | |||
| REASON_ID | NUMBER | 18 | This column stores the inventory transaction reason unique identifier. | |||
| DESTINATION_CONTEXT | VARCHAR2 | 30 | Destination descriptive flexfield context. | |||
| LOCATOR_ATTRIBUTE | VARCHAR2 | 150 | This column is not being used currently. | |||
| CHILD_INSPECTION_FLAG | VARCHAR2 | 1 | This column is not being used currently. | |||
| SOURCE_DOC_QUANTITY | NUMBER | Transaction quantity in terms of the source document's unit of measure. | ||||
| SOURCE_DOC_UOM_CODE | VARCHAR2 | 3 | This column stores the source document's unit of measure code. | |||
| INTERFACE_TRANSACTION_ID | NUMBER | 18 | This column stores the Original interface transaction unique identifier that created the current row. | |||
| INTERFACE_GROUP_ID | NUMBER | 18 | This column stores the Original interface transaction group unique identifier. | |||
| GROUP_ID | NUMBER | 18 | This column stores the Original interface group unique identifier. | |||
| MOVEMENT_ID | NUMBER | 18 | This column stores the movement identifier. | |||
| INVOICE_ID | NUMBER | 18 | Transaction 857 Invoice unique identifier. | |||
| INVOICE_STATUS_CODE | VARCHAR2 | 25 | Eligibility status for automated Oracle Payables invoice creation. | |||
| 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. | |||
| MVT_STAT_STATUS | VARCHAR2 | 30 | Indicator of whether the transaction has been processed by the Movement Statistics concurrent program. | |||
| QUANTITY_BILLED | NUMBER | This column stores the quantity invoiced by fusion payables for the current receiving transaction. | ||||
| MATCH_FLAG | VARCHAR2 | 1 | Indicator of whether the purchase order or receipt must be matched to an invoice. | |||
| AMOUNT_BILLED | NUMBER | This column stores the amount invoiced by fusion payables for the transaction in terms of the purchase order currency. | ||||
| BASE_AMOUNT_BILLED | NUMBER | This column is not being used currently. | ||||
| MATCH_OPTION | VARCHAR2 | 25 | Indicator of whether the invoice for this transaction should be matched to the purchase order or the receipt. | |||
| 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. | |||
| CUSTOMER_ID | NUMBER | 18 | Customer unique identifier. Applicable for RMA transactions. | |||
| CUSTOMER_SITE_ID | NUMBER | 18 | Customer site unique identifier. Applicable for RMA transactions. | |||
| 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. | |||
| SECONDARY_QUANTITY | NUMBER | This column stores the receiving transaction quantity in the item's secondary unit of measure. | ||||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | This column stores the secondary unit of measure code of the inventory item. | |||
| QC_GRADE | VARCHAR2 | 150 | This column is not being used currently. | |||
| PA_ADDITION_FLAG | VARCHAR2 | 1 | Flag that indicates if project related receipts have been transferred to Oracle Projects. | |||
| 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. | |||
| FROM_SUBINVENTORY | VARCHAR2 | 240 | This column stores the source subinventory name for the receiving transaction. | |||
| FROM_LOCATOR_ID | NUMBER | 18 | This column stores the source locator unique identifier for the receiving transaction. | |||
| AMOUNT | NUMBER | Transaction Amount in purchase order currency. Applicable for fixed price lines. | ||||
| DROPSHIP_TYPE_CODE | NUMBER | 18 | This column is not being used currently. | |||
| 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. | |||
| 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. | |||
| 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. | |||
| REQUESTED_AMOUNT | NUMBER | This column is not being used currently. | ||||
| MATERIAL_STORED_AMOUNT | NUMBER | This column is not being used currently. | ||||
| REPLENISH_ORDER_LINE_ID | NUMBER | 18 | Replenishment sales order line unique identifier for chargeable subcontracting component. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the 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. | ||
| 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. | |||
| RCPT_CONF_STATUS | VARCHAR2 | 25 | This column stores the status code that identifying receipt confirmation sent from fusion receiving to the source system. Values : PENDING, SENT. | |||
| RCPT_CONF_MESSAGE_NUMBER | NUMBER | 18 | This column stores the Message Number that groups the receiving transactions communicated through a receipt confirmation. | |||
| SP_QUANTITY | NUMBER | Transaction quantity represented in terms of standard pack UOM. | ||||
| SP_UOM_CODE | VARCHAR2 | 3 | This column stores 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 | Standard pack grouping identifier for the parent transaction. | |||
| TXN_FLOW_HEADER_ID | NUMBER | 18 | Inter Company Transaction Flow Header Identifier. Not used since REL9. | |||
| 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. | |||
| 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 for the receiving transaction. | |||
| 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. | |||
| 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. | |||
| CSE_INTERFACE_STATUS_CODE | VARCHAR2 | 25 | This column stores the code that indicates the interface status of the receiving transaction to Asset Lifecycle Management. | |||
| 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. | |||
| RETURN_TO_HEADER_ID | NUMBER | 18 | This column stores the unique identifier for the return transfer order header created on performing a return. | |||
| RETURN_TO_LINE_ID | NUMBER | 18 | This column stores the unique identifier for the return transfer order line created on performing a return. | |||
| BUSINESS_EVENT_PUBLISHED | VARCHAR2 | 1 | This column stores Y or N and indicates whether a business event published by fusion receiving this receiving transaction row. | |||
| INTF_FROM_EXT_SYSTEM_FLAG | VARCHAR2 | 1 | This column will hold value Y or N depending on whether this transaction was interfaced by an external system or not. | |||
| 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. | |||
| ERECORD_ID | NUMBER | 18 | This column stores the unique identifier of the electronic record. | |||
| EXTERNAL_SYSTEM_PACKING_UNIT | VARCHAR2 | 150 | This column stores the license plate number of the external Warehouse Management System (WMS). | |||
| AUTO_DEBIT_MEMO_CREATED | VARCHAR2 | 1 | This column indicates whether the automatic debit memo was successfully created for the return to supplier transaction. | |||
| 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. | |||
| 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. | |||
| PRICING_QUANTITY | NUMBER | This column stores the transaction quantity in terms of the pricing unit of measure of the receiving document. | ||||
| PRICING_UOM_CODE | VARCHAR2 | 3 | This column stores the pricing unit of measure code of the receiving document. | |||
| ALM_INTERFACE_STATUS | VARCHAR2 | 30 | Column to indicate the ALM interface (for Genealogy) status. A blank value indicates that the transaction is not applicable for ALM interfacing, a value of 'P' indicates that there was an error while interfacing the transaction with ALM and a value of 'I' indicates that the transaction has been interfaced to ALM successfully. The lookup type corresponding to this column is ORA_INV_ALM_INTERFACE_STATUS. | |||
| BILLING_UOM_CODE | VARCHAR2 | 3 | This column stores the billing unit of measure code. quantity_billed will reflect quantity in this unit of measure code. | |||
| SCH_INTERFACE_STATUS | VARCHAR2 | 1 | This column indicates if the transaction has been interfaced to Recall Management. If the value is N it means this line is pending interface. If the value is Y, this line has been successfully interfaced. If the value is NULL, this line is not eligible for interface. | |||
| ELASTIC_SEARCH_INGEST_STATUS | VARCHAR2 | 15 | This column is for internal use. It stores the elastic search index ingestion status code for receiving transactions. Valid values are NULL, PENDING and COMPLETED. | |||
| DEFAULT_LOTSER_FROM_SHIPMENT | VARCHAR2 | 1 | This column is for internal use. It stores the value of the default lot and serial numbers attribute passed when executing a receipt or putaway transaction. | |||
| DELIVERY_REQUIRED_FLAG | VARCHAR2 | 1 | This column indicates if a delivery is required for the current receipt or the put away transaction. Valid values are Y and NULL. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RCV_TRANSACTIONS | po_lines_all | PO_LINE_ID |
| RCV_TRANSACTIONS | po_line_locations_all | PO_LINE_LOCATION_ID |
| RCV_TRANSACTIONS | po_distributions_all | PO_DISTRIBUTION_ID |
| RCV_TRANSACTIONS | por_requisition_lines_all | REQUISITION_LINE_ID |
| RCV_TRANSACTIONS | por_req_distributions_all | REQ_DISTRIBUTION_ID |
| RCV_TRANSACTIONS | rcv_shipment_headers | SHIPMENT_HEADER_ID |
| RCV_TRANSACTIONS | inv_secondary_inventories | SUBINVENTORY, ORGANIZATION_ID |
| RCV_TRANSACTIONS | rcv_shipment_lines | SHIPMENT_LINE_ID |
| RCV_TRANSACTIONS | inv_item_locations | LOCATOR_ID |
| RCV_TRANSACTIONS | inv_transaction_reasons_b | REASON_ID |
| RCV_TRANSACTIONS | gl_daily_conversion_types | CURRENCY_CONVERSION_TYPE |
| RCV_TRANSACTIONS | inv_material_txns | INV_TRANSACTION_ID |
| RCV_TRANSACTIONS | po_headers_all | PO_HEADER_ID |
| inv_supply | rcv_transactions | RCV_TRANSACTION_ID |
| rcv_serials_supply | rcv_transactions | TRANSACTION_ID |
| ap_invoice_lines_all | rcv_transactions | RCV_TRANSACTION_ID |
| rcv_lots_supply | rcv_transactions | TRANSACTION_ID |
| ap_holds_all | rcv_transactions | RCV_TRANSACTION_ID |
| rcv_supply | rcv_transactions | RCV_TRANSACTION_ID |
| ap_invoice_lines_interface | rcv_transactions | RCV_TRANSACTION_ID |
| inv_material_txns_temp | rcv_transactions | RCV_TRANSACTION_ID |
| rcv_receipt_deliveries | rcv_transactions | PARENT_TRANSACTION_ID |
| ap_invoice_distributions_all | rcv_transactions | RCV_TRANSACTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| RCV_TRANSACTIONS_N1 | Non Unique | Default | PARENT_TRANSACTION_ID | |
| RCV_TRANSACTIONS_N10 | Non Unique | Default | TRANSACTION_DATE | |
| RCV_TRANSACTIONS_N11 | Non Unique | Default | INTERFACE_TRANSACTION_ID | |
| RCV_TRANSACTIONS_N12 | Non Unique | Default | RECEIPT_EXCEPTION_FLAG | |
| RCV_TRANSACTIONS_N13 | Non Unique | Default | ACCRUAL_STATUS_CODE | |
| RCV_TRANSACTIONS_N14 | Non Unique | Default | DELIVER_TO_PERSON_ID | Obsolete |
| RCV_TRANSACTIONS_N15 | Non Unique | Default | VENDOR_ID | |
| RCV_TRANSACTIONS_N16 | Non Unique | Default | INVOICE_STATUS_CODE, SOURCE_DOCUMENT_CODE, TRANSACTION_TYPE, ORGANIZATION_ID, RCPT_CONF_STATUS | |
| RCV_TRANSACTIONS_N17 | Non Unique | Default | GROUP_ID | |
| RCV_TRANSACTIONS_N18 | Non Unique | Default | TRANSFER_ORDER_HEADER_ID | |
| RCV_TRANSACTIONS_N19 | Non Unique | Default | EMPLOYEE_ID | |
| RCV_TRANSACTIONS_N2 | Non Unique | Default | SHIPMENT_HEADER_ID, SOURCE_DOCUMENT_CODE, ROUTING_HEADER_ID, INSPECTION_STATUS_CODE | |
| RCV_TRANSACTIONS_N20 | Non Unique | Default | PO_DISTRIBUTION_ID | |
| RCV_TRANSACTIONS_N21 | Non Unique | Default | ERECORD_ID | |
| RCV_TRANSACTIONS_N22 | Non Unique | Default | ORGANIZATION_ID, SOURCE_DOCUMENT_CODE, ROUTING_HEADER_ID, INSPECTION_STATUS_CODE | |
| RCV_TRANSACTIONS_N23 | Non Unique | Default | LAST_UPDATE_DATE | |
| RCV_TRANSACTIONS_N24 | Non Unique | Default | REQUEST_ID | |
| RCV_TRANSACTIONS_N25 | Non Unique | Default | SOURCE_TRANSACTION_NUM | |
| RCV_TRANSACTIONS_N26 | Non Unique | Default | CUSTOMER_ID | |
| RCV_TRANSACTIONS_N27 | Non Unique | Default | EXTERNAL_SYS_TXN_REFERENCE | |
| RCV_TRANSACTIONS_N28 | Non Unique | Default | CREATION_DATE | |
| RCV_TRANSACTIONS_N29 | Non Unique | Default | ALM_INTERFACE_STATUS | |
| RCV_TRANSACTIONS_N3 | Non Unique | Default | SHIPMENT_LINE_ID | |
| RCV_TRANSACTIONS_N30 | Non Unique | RCV_TRANSACTIONS_N30 | SCH_INTERFACE_STATUS | |
| RCV_TRANSACTIONS_N31 | Non Unique | RCV_TRANSACTIONS_N31 | ELASTIC_SEARCH_INGEST_STATUS | |
| RCV_TRANSACTIONS_N4 | Non Unique | Default | PO_HEADER_ID | |
| RCV_TRANSACTIONS_N5 | Non Unique | Default | PO_LINE_ID | |
| RCV_TRANSACTIONS_N6 | Non Unique | Default | PO_LINE_LOCATION_ID | |
| RCV_TRANSACTIONS_N7 | Non Unique | Default | REQUISITION_LINE_ID | Obsolete |
| RCV_TRANSACTIONS_N8 | Non Unique | Default | REQ_DISTRIBUTION_ID | Obsolete |
| RCV_TRANSACTIONS_N9 | Non Unique | Default | RECEIPT_ADVICE_HEADER_ID, RECEIPT_ADVICE_LINE_ID | |
| RCV_TRANSACTIONS_U1 | Unique | Default | TRANSACTION_ID |