RCV_RECEIPT_CONF_INT
The table RCV_RECEIPT_CONF_INT will be used to store the interface records corresponding to the receipt-confirmations sent by an external system such as contract manufacturer, for the transactions done at their end. The data from this intermediate table is transformed to receiving open interface tables, i.e. RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE.
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
RCV_RECEIPT_CONF_INT_PK |
RCPT_CONF_INTF_TXN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RCPT_CONF_INTF_TXN_ID | NUMBER | 18 | Yes | Receipt confirmation interface record unique identifier. | |
| GROUP_ID | NUMBER | 18 | Interface group for set processing. All the interface records for a given value of group_id will be processed together. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ORGANIZATION_CODE | VARCHAR2 | 18 | Yes | This column stores the organization where the receiving transactions are created. | |
| TRANSACTION_DATE | DATE | Yes | This column stores the transaction date for the receiving transactions. | ||
| 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. | ||
| DOCUMENT_NUMBER | VARCHAR2 | 80 | This column stores the document number for the receipt confirmation. | ||
| DOCUMENT_LINE_NUMBER | VARCHAR2 | 80 | This column stores the document line number for the receipt confirmation. | ||
| DOCUMENT_SCHEDULE_NUMBER | VARCHAR2 | 80 | This column stores the document schedule number for the receipt confirmation. | ||
| RECEIPT_NUMBER | VARCHAR2 | 30 | This column stores the receipt number to be used when creating a receipt in fusion receiving. | ||
| RECEIPT_LINE_NUMBER | NUMBER | 18 | This column stores the receipt line number to be used when creating a receipt. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | This column stores the inventory item number for which receiving transactions are created. | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | This column stores the item description for which receiving transactions are created. | ||
| 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. | ||
| QUANTITY_RECEIVED | NUMBER | This column stores the net quantity received in transaction unit of measure. | |||
| QUANTITY_ACCEPTED | NUMBER | This column stores the net quantity accepted in transaction unit of measure. | |||
| QUANTITY_REJECTED | NUMBER | This column stores the net quantity rejected transaction unit of measure. | |||
| QUANTITY_DELIVERED | NUMBER | This column stores the net quantity delivered in transaction unit of measure. | |||
| QUANTITY_RETURNED | NUMBER | This column stores the net quantity returned in transaction unit of measure. | |||
| QUANTITY_CORRECTED | NUMBER | This column stores the net quantity corrected in transaction unit of measure. | |||
| SECONDARY_QUANTITY | NUMBER | This column stores the 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_QUANTITY_RECEIVED | NUMBER | This column stores the net quantity received in item's secondary unit of measure. | |||
| SECONDARY_QUANTITY_ACCEPTED | NUMBER | This column stores the net quantity accepted in item's secondary unit of measure. | |||
| SECONDARY_QUANTITY_REJECTED | NUMBER | This column stores the net quantity rejected in item's secondary unit of measure. | |||
| SECONDARY_QUANTITY_DELIVERED | NUMBER | This column stores the net quantity delivered in item's secondary unit of measure. | |||
| SECONDARY_QUANTITY_RETURNED | NUMBER | This column stores the net quantity returned in item's secondary unit of measure. | |||
| SECONDARY_QUANTITY_CORRECTED | NUMBER | This column stores the net quantity corrected in item's secondary unit of measure. | |||
| SUBINVENTORY | VARCHAR2 | 10 | This column stores the destination subinventory where the item is to be put away. | ||
| LOCATION | VARCHAR2 | 81 | This column stores the concatenated segments of the inventory locator where the item is to be put away. | ||
| SOLDTO_LEGAL_ENTITY | VARCHAR2 | 240 | Sold-to Legal Entity name. Used to derive purchase order header information. | ||
| INSPECTION_QUALITY | VARCHAR2 | 80 | This column stores the inspection quality code. References FND_LOOKUP_VALUES_B.LOOKUP_CODE where lookup_type is RCV_QUALITY_CODE. | ||
| REASON_NAME | VARCHAR2 | 30 | This column stores the inventory transaction reason name. Used to derive REASON_ID. | ||
| PROCESSING_STATUS_CODE | VARCHAR2 | 25 | Processing status code of the receipt confirmation row. | ||
| ERROR_TYPE | VARCHAR2 | 25 | This column stores the type of the error for the receipt confirmation row. Values - ERROR or WARNING. | ||
| ERROR_MESSAGE | VARCHAR2 | 240 | Error message text for the receipt confirmation row. This value is translated in the language corresponding to the session in which the receiving transaction manager is invoked. | ||
| ERROR_MESSAGE_NAME | VARCHAR2 | 240 | Error message name for the receipt confirmation row. This value corresponds to the message name stored in message data dictionary. | ||
| SUBSTITUTE_ITEM_NUMBER | VARCHAR2 | 300 | This column stores the substitute item number for the receipt. | ||
| RMA_LINE_ID | NUMBER | 18 | This column stores the unique Identifier for the RMA line that was provided as part of the Send Receipt Advice web service. | ||
| ITEM_REVISION | VARCHAR2 | 18 | This column stores the revision number of the inventory item. | ||
| FROM_ORGANIZATION_CODE | VARCHAR2 | 18 | This column stores the from organization code for inter-organization transfers. | ||
| TRANSFER_LICENSE_PLATE_NUMBER | VARCHAR2 | 150 | This column stores the license plate number of the external Warehouse Management System (WMS). | ||
| 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. | ||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | This column stores the Code for the country of manufacture. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| rcv_receipt_conf_ls_int | rcv_receipt_conf_int | RCPT_CONF_INTF_TXN_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCV_RECEIPT_CONF_INT_N1 | Non Unique | Default | GROUP_ID, ORGANIZATION_CODE, DOCUMENT_NUMBER |
| RCV_RECEIPT_CONF_INT_U1 | Unique | Default | RCPT_CONF_INTF_TXN_ID |