RCV_SHIPMENT_LINES
RCV_SHIPMENT_LINES stores information about items that have been shipped and/or received from a specific receipt source. . RCV_SHIPMENT_LINES also stores information about the default destination for intransit shipments. .
Details
-
Schema: FUSION
-
Object owner: RCV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
RCV_SHIPMENT_LINES_PK |
SHIPMENT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| SHIPMENT_LINE_ID | NUMBER | 18 | Yes | This column stores the receiving shipment receiving receipt line unique identifier. This is the primary key for the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| SHIPMENT_HEADER_ID | NUMBER | 18 | Yes | This column stores the receiving shipment receiving receipt header unique identifier. | ||
| LINE_NUM | NUMBER | 18 | Yes | This column stores the number corresponding to the shipment line. | ||
| CATEGORY_ID | NUMBER | 18 | This column stores the Item category unique identifier. | |||
| QUANTITY_SHIPPED | NUMBER | This column stores the net quantity shipped for the receiving shipment receipt line. | ||||
| QUANTITY_RECEIVED | NUMBER | This column stores the net quantity received for the receiving shipment receipt line. | ||||
| QUANTITY_DELIVERED | NUMBER | This column stores the net quantity delivered for the receiving shipment receipt line. | ||||
| QUANTITY_RETURNED | NUMBER | This column stores the net quantity returned for the receiving shipment receipt line. | ||||
| QUANTITY_ACCEPTED | NUMBER | This column stores the net quantity accepted for the receiving shipment receipt line. | ||||
| QUANTITY_REJECTED | NUMBER | This column stores the net quantity rejected for the receiving shipment receipt line. | ||||
| UOM_CODE | VARCHAR2 | 3 | This column stores the unit of measure code for the receiving shipment receipt line. | |||
| 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_ID | NUMBER | 18 | This column stores the inventory item unique identifier of the document for which the receiving shipment receipt line is created. | |||
| ITEM_REVISION | VARCHAR2 | 18 | This column stores the revision number of the inventory item. | |||
| 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. | |||
| UOM_CONVERSION_RATE | NUMBER | This column is not currently used. | ||||
| SHIPMENT_LINE_STATUS_CODE | VARCHAR2 | 25 | This column stores the shipment line status code. Values: EXPECTED, PARTIALLY RECEIVED, FULLY RECEIVED, CANCELLED. | |||
| 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. | |||
| 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. | |||
| 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. | |||
| ROUTING_HEADER_ID | NUMBER | 18 | This column stores the receiving routing unique identifier. Values: 1 (Standard receipt), 2 (Inspection required) and 3 (Direct delivery). | |||
| PACKING_SLIP | VARCHAR2 | 25 | This column stores the Packing slip number. | |||
| FROM_ORGANIZATION_ID | NUMBER | 18 | From organization unique identifier for in-transit shipment lines. | |||
| DELIVER_TO_PERSON_ID | NUMBER | 18 | This column stores the deliver to person, or requester, unique identifier. | |||
| 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. | |||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | This column stores the destination type code for the shipment line. | |||
| TO_ORGANIZATION_ID | NUMBER | 18 | This column stores Receiving organization unique identifier where the receiving shipment receipt line is created. | |||
| TO_SUBINVENTORY | VARCHAR2 | 10 | This column stores the default destination subinventory in the receiving organization. | |||
| LOCATOR_ID | NUMBER | 18 | This column stores the default destination locator unique identifier in the receiving organization. | |||
| DELIVER_TO_LOCATION_ID | NUMBER | 18 | This column stores the deliver to location unique identifier. | |||
| SHIPMENT_UNIT_PRICE | NUMBER | This column stores the unit price for shipping the item. | ||||
| 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. | ||||
| COMMENTS | VARCHAR2 | 4000 | This column stores the note created by the receiver. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Line (RCV_SHIPMENT_LINES) | |||
| REASON_ID | NUMBER | 18 | This column stores the inventory transaction reason unique identifier. | |||
| GOVERNMENT_CONTEXT | VARCHAR2 | 30 | USSGL descriptive flexfield context column. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| DESTINATION_CONTEXT | VARCHAR2 | 30 | Destination descriptive flexfield context. | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | This column stores the primary unit of measure code of the item in the receiving organization. | |||
| EXCESS_TRANSPORT_REASON | VARCHAR2 | 25 | This column stores the excess transportation reason code. | |||
| EXCESS_TRANSPORT_RESPONSIBLE | VARCHAR2 | 25 | This column is not being used currently. | |||
| EXCESS_TRANSPORT_AUTH_NUM | VARCHAR2 | 30 | This column is not being used currently. | |||
| ASN_LINE_FLAG | VARCHAR2 | 1 | Indicates whether item is on an Advance Shipment Notice (ASN). Used by missing ASN Items Processor to determine whether shipped items were received. | |||
| ORIGINAL_ASN_PARENT_LINE_ID | VARCHAR2 | 1 | This column is not being used currently. | |||
| ORIGINAL_ASN_LINE_FLAG | VARCHAR2 | 1 | This column is not being used currently. | |||
| VENDOR_CUM_SHIPPED_QUANTITY | NUMBER | This column stores the supplier's quantity shipped specified on the ASN - populated for parent lines only. | ||||
| NOTICE_UNIT_PRICE | NUMBER | This column stores the EDI transaction 857 unit price for the item in 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. | ||||
| INVOICE_STATUS_CODE | VARCHAR2 | 25 | EDI transaction 857 status code to determine which line has been transferred to Oracle Payables. | |||
| CUM_COMPARISON_FLAG | VARCHAR2 | 1 | This column is not being used currently. | |||
| CONTAINER_NUM | VARCHAR2 | 35 | This column stores the container number for the receiving shipment receipt line. | |||
| TRUCK_NUM | VARCHAR2 | 35 | This column stores the truck number specified in the shipment line. | |||
| BAR_CODE_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. | ||||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | This column stores the Receiving location unique identifier. | |||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | This column stores the code for the country of manufacture. | |||
| CUSTOMER_ITEM_NUM | VARCHAR2 | 50 | This column stores customer's item number. | |||
| SECONDARY_QUANTITY_SHIPPED | NUMBER | This column stores the net quantity shipped for the receiving shipment receipt line in the item's secondary unit of measure. | ||||
| SECONDARY_QUANTITY_RECEIVED | NUMBER | This column stores the net quantity received for the receiving shipment receipt line 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 in the receiving organization. | |||
| QC_GRADE | VARCHAR2 | 150 | This column is not being used currently. | |||
| MMT_TRANSACTION_ID | NUMBER | 18 | This column stores the Inventory transaction unique identifier that created the in-transit shipment line. Maps to INV_MATERIAL_TXNS.TRANSACTION_ID. | |||
| ASN_LPN_ID | NUMBER | 18 | This column stores the packing unit unique identifier for the ASN line. | |||
| AMOUNT | NUMBER | Transaction Amount. Reserved for future use. | ||||
| AMOUNT_RECEIVED | NUMBER | Amount shipped for a fixed price service receipt line in purchase order currency. | ||||
| 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. | |||
| OSA_FLAG | VARCHAR2 | 1 | This column is not being used currently. | |||
| REQUESTED_AMOUNT | NUMBER | This column is not being used currently. | ||||
| MATERIAL_STORED_AMOUNT | NUMBER | This column is not being used currently. | ||||
| APPROVAL_STATUS | VARCHAR2 | 25 | This column is not being used currently. | |||
| AMOUNT_SHIPPED | NUMBER | Amount shipped for a fixed price service receipt line in purchase order currency. | ||||
| 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. | ||
| 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_LINE_NUMBER | VARCHAR2 | 80 | Source document line 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_DOC_SCHEDULE_NUMBER | VARCHAR2 | 80 | Source document schedule number for the 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_EXPECTED_RECEIPT_DATE | DATE | Expected arrival 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_OC_HEADER_NUMBER | VARCHAR2 | 80 | Original Sales order number reference corresponding to the RMA. | |||
| RA_ORIG_OC_LINE_NUMBER | VARCHAR2 | 80 | Original Sales order line number reference corresponding to the RMA. | |||
| RA_ORIG_DOO_FULFIL_LINE_NUM | VARCHAR2 | 80 | Original fulfillment line number reference in distributed order orchestration corresponding to the RMA. | |||
| CUSTOMER_ID | NUMBER | 18 | Customer unique identifier. Applicable for RMA transactions. | |||
| CUSTOMER_SITE_ID | NUMBER | 18 | Customer site unique identifier. Applicable for RMA transactions. | |||
| RA_QUANTITY_EXPECTED | NUMBER | Expected Quantity to be received for the receipt advice line. Applicable to RMA and flexible supply source documents. | ||||
| RA_SECONDARY_QUANTITY_EXPECTED | NUMBER | Expected Quantity to be received for the receipt advice line in Item's secondary UOM. Applicable to RMA and flexible supply source documents. | ||||
| RA_UNIT_PRICE | NUMBER | Unit Price of the inventory item of the receipt advice line. Applicable to flexible supply source documents. | ||||
| 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. | |||
| RA_LAST_ACTION_CODE | VARCHAR2 | 25 | This column stores the last action performed on the receipt advice line - CREATE, UPDATE, CANCEL. | |||
| RA_MESSAGE_NUMBER | NUMBER | This column stores the message number when the receipt advice was last processed. | ||||
| INTERFACE_TRANSACTION_ID | NUMBER | 18 | This column stores the receiving transaction interface unique identifier that created the current receiving shipment line. | |||
| 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. | |||
| CONSIGNED_FLAG | VARCHAR2 | 1 | This column if the receipt line is created for consigned material. | |||
| CONSUMED_QUANTITY | NUMBER | Supplier consigned Inventory consumed quantity. | ||||
| EXTERNAL_SYS_INTF_STATUS | VARCHAR2 | 25 | Indicates if the receipt advice for this shipment has been interfaced to the external system or has been confirmed as received. | |||
| FIRST_PTY_REG_ID | NUMBER | 18 | Tax Determinant: First party tax registration ID for the shipment line. | |||
| THIRD_PTY_REG_ID | NUMBER | 18 | Tax Determinant: Third party tax registration ID for the shipment line. | |||
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Tax Determinant: Default taxation country code for the shipment line. | |||
| 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 for the shipment line. | |||
| 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 shipment line. | |||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | Tax Determinant: User defined fiscal classification code for the shipment line. | |||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | 50 | Tax Determinant: Tax Classification Code for the shipment line. | |||
| INTENDED_USE | VARCHAR2 | 240 | Tax Determinant: Intended use code of the transaction line. 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 shipment line. | |||
| 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 shipment line. | |||
| 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. | |||
| PRODUCT_FISC_CLASS_ID | NUMBER | 18 | Tax Determinant: Product fiscal classification id for the inventory item. | |||
| ORIG_TO_INV_SHIP_TXN_ID | NUMBER | 18 | This column stores the reference to inventory transaction unique identifier of the original Transfer Order shipment for a return transfer order. | |||
| CUSTOMER_ITEM_ID | NUMBER | 18 | This column stores the customer item unique identifier. | |||
| BACK_TO_BACK_FLAG | VARCHAR2 | 1 | This column indicates if the receipt line is created for a back-to-back order. | |||
| 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. | |||
| 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. | |||
| EWAY_BILL_NUMBER | NUMBER | 18 | This column stores the e-Way Bill number provided by supplier for shipment of goods. | |||
| EWAY_BILL_DATE | DATE | This column stores the date on which the e-Way Bill was generated. | ||||
| EXT_SYS_GROUP_ID | NUMBER | 18 | This column stores the group identifier that marks all the inbound shipment lines set as Interfaced in the current request. A REST api will use this column value to fetch the receipt advice lines. | |||
| DS_LINE_INTERFACED_TO_OM | VARCHAR2 | 1 | This column indicates if the drop ship line has been interfaced to Order Management. If the value is N it means this line is pending interface to OM. If the value is Y, this line has been successfully interfaced to OM. If the value is NULL, this line is not eligible for interface to OM. | |||
| SECONDARY_QTY_DELIVERED | NUMBER | This column stores the net quantity delivered for the receiving shipment receipt line in the item's secondary unit of measure. | ||||
| SECONDARY_QTY_RETURNED | NUMBER | This column stores the net quantity returned for the receiving shipment receipt line in the item's secondary unit of measure. | ||||
| SECONDARY_QTY_ACCEPTED | NUMBER | This column stores the net quantity accepted for the receiving shipment receipt line in the item's secondary unit of measure. | ||||
| SECONDARY_QTY_REJECTED | NUMBER | This column stores the net quantity rejected for the receiving shipment receipt line in the item's secondary unit of measure. | ||||
| WORK_CONFIRMATION_ID | NUMBER | 18 | Value that uniquely identifies the work confirmation. This column is populated by procurement during automatic on approval of the work confirmation. | |||
| WORK_CONFIRMATION_LINE_ID | NUMBER | 18 | Value that uniquely identifies the work confirmation line. This column is populated by procurement during automatic on approval of the work confirmation. | |||
| ELASTIC_SEARCH_INGEST_STATUS | VARCHAR2 | 15 | This column is for internal use. It stores the elastic search index ingestion status code for inbound shipment lines. Valid values are NULL, PENDING and COMPLETED. | |||
| CST_TRANSFER_STATUS | VARCHAR2 | 1 | This column indicates whether the ASN line has been processed by Costing. Values values are Y, N 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_SHIPMENT_LINES | rcv_shipment_headers | SHIPMENT_HEADER_ID |
| RCV_SHIPMENT_LINES | egp_categories_b | CATEGORY_ID |
| RCV_SHIPMENT_LINES | inv_secondary_inventories | TO_SUBINVENTORY, TO_ORGANIZATION_ID |
| RCV_SHIPMENT_LINES | inv_transaction_reasons_b | REASON_ID |
| RCV_SHIPMENT_LINES | po_headers_all | PO_HEADER_ID |
| RCV_SHIPMENT_LINES | po_lines_all | PO_LINE_ID |
| RCV_SHIPMENT_LINES | po_line_locations_all | PO_LINE_LOCATION_ID |
| RCV_SHIPMENT_LINES | po_distributions_all | PO_DISTRIBUTION_ID |
| RCV_SHIPMENT_LINES | por_requisition_lines_all | REQUISITION_LINE_ID |
| RCV_SHIPMENT_LINES | por_req_distributions_all | REQ_DISTRIBUTION_ID |
| rcv_transactions | rcv_shipment_lines | SHIPMENT_LINE_ID |
| inv_supply | rcv_shipment_lines | SHIPMENT_LINE_ID |
| rcv_serials_supply | rcv_shipment_lines | SHIPMENT_LINE_ID |
| ap_invoice_lines_all | rcv_shipment_lines | RCV_SHIPMENT_LINE_ID |
| rcv_lots_supply | rcv_shipment_lines | SHIPMENT_LINE_ID |
| rcv_supply | rcv_shipment_lines | SHIPMENT_LINE_ID |
| rcv_transactions_interface | rcv_shipment_lines | SHIPMENT_LINE_ID |
| rcv_receipt_deliveries | rcv_shipment_lines | SHIPMENT_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| RCV_SHIPMENT_LINES_N1 | Non Unique | Default | ITEM_ID, TO_ORGANIZATION_ID, FROM_ORGANIZATION_ID | |
| RCV_SHIPMENT_LINES_N10 | Non Unique | Default | CST_TRANSFER_STATUS | |
| RCV_SHIPMENT_LINES_N11 | Non Unique | Default | ASN_LPN_ID | Obsolete |
| RCV_SHIPMENT_LINES_N12 | Non Unique | Default | TRANSFER_ORDER_HEADER_ID, TRANSFER_ORDER_LINE_ID | |
| RCV_SHIPMENT_LINES_N13 | Non Unique | Default | SHIPMENT_LINE_STATUS_CODE, SOURCE_DOCUMENT_CODE, ASN_LINE_FLAG | |
| RCV_SHIPMENT_LINES_N14 | Non Unique | Default | TO_ORGANIZATION_ID | |
| RCV_SHIPMENT_LINES_N15 | Non Unique | Default | EXT_SYS_GROUP_ID | |
| RCV_SHIPMENT_LINES_N16 | Non Unique | Default | DS_LINE_INTERFACED_TO_OM | |
| RCV_SHIPMENT_LINES_N17 | Non Unique | Default | WORK_CONFIRMATION_ID, WORK_CONFIRMATION_LINE_ID | |
| RCV_SHIPMENT_LINES_N18 | Non Unique | RCV_SHIPMENT_LINES_N18 | ASN_LINE_FLAG | |
| RCV_SHIPMENT_LINES_N19 | Non Unique | RCV_SHIPMENT_LINES_N19 | ELASTIC_SEARCH_INGEST_STATUS | |
| RCV_SHIPMENT_LINES_N2 | Non Unique | Default | PO_HEADER_ID | |
| RCV_SHIPMENT_LINES_N20 | Non Unique | Default | RA_MESSAGE_NUMBER | |
| RCV_SHIPMENT_LINES_N21 | Non Unique | Default | RECEIPT_ADVICE_HEADER_ID | |
| RCV_SHIPMENT_LINES_N3 | Non Unique | Default | PO_LINE_ID | |
| RCV_SHIPMENT_LINES_N4 | Non Unique | Default | PO_LINE_LOCATION_ID | |
| RCV_SHIPMENT_LINES_N5 | Non Unique | Default | EMPLOYEE_ID | |
| RCV_SHIPMENT_LINES_N6 | Non Unique | Default | DELIVER_TO_PERSON_ID | |
| RCV_SHIPMENT_LINES_N7 | Non Unique | Default | CONTAINER_NUM, TO_ORGANIZATION_ID, SHIPMENT_HEADER_ID | Obsolete |
| RCV_SHIPMENT_LINES_N8 | Non Unique | Default | REQUISITION_LINE_ID | Obsolete |
| RCV_SHIPMENT_LINES_N9 | Non Unique | Default | PACKING_SLIP | |
| RCV_SHIPMENT_LINES_U1 | Unique | Default | SHIPMENT_LINE_ID | |
| RCV_SHIPMENT_LINES_U2 | Unique | Default | SHIPMENT_HEADER_ID, LINE_NUM |