[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | RCV_TRANSACTIONS_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.RCV_TRANSACTIONS_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
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
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| RCV_TRANSACTIONS_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 INTERFACE_TRANSACTION_ID
|
| RCV_TRANSACTIONS_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
GROUP_ID
|
| RCV_TRANSACTIONS_INTERFACE_N10 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SHIPMENT_LINE_ID
|
| RCV_TRANSACTIONS_INTERFACE_N11 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSFER_LPN_ID
LPN_ID
TO_ORGANIZATION_ID
|
| RCV_TRANSACTIONS_INTERFACE_N12 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
LPN_GROUP_ID
|
| RCV_TRANSACTIONS_INTERFACE_N13 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PO_HEADER_ID
|
| RCV_TRANSACTIONS_INTERFACE_N14 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
DOCUMENT_NUM
|
| RCV_TRANSACTIONS_INTERFACE_N15 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PROCESSING_REQUEST_ID
|
| RCV_TRANSACTIONS_INTERFACE_N16 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SHIPMENT_HEADER_ID
|
| RCV_TRANSACTIONS_INTERFACE_N17 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
REPLENISH_ORDER_LINE_ID
|
| RCV_TRANSACTIONS_INTERFACE_N18 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
LCM_SHIPMENT_LINE_ID
|
| RCV_TRANSACTIONS_INTERFACE_N19 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INTERFACE_SOURCE_LINE_ID
|
| RCV_TRANSACTIONS_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PARENT_TRANSACTION_ID
|
| RCV_TRANSACTIONS_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
EMPLOYEE_ID
|
| RCV_TRANSACTIONS_INTERFACE_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
DELIVER_TO_PERSON_ID
|
| RCV_TRANSACTIONS_INTERFACE_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PO_LINE_LOCATION_ID
|
| RCV_TRANSACTIONS_INTERFACE_N6 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
HEADER_INTERFACE_ID
|
| RCV_TRANSACTIONS_INTERFACE_N7 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
WIP_ENTITY_ID
|
| RCV_TRANSACTIONS_INTERFACE_N8 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSACTION_STATUS_CODE
PO_DISTRIBUTION_ID
|
| RCV_TRANSACTIONS_INTERFACE_N9 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PROCESSING_STATUS_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERFACE_TRANSACTION_ID | NUMBER | Yes | Interface transaction unique identifier | |
| GROUP_ID | NUMBER | Interface processing group identifier | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| TRANSACTION_TYPE | VARCHAR2 | (25) | Yes | Receiving transaction type |
| TRANSACTION_DATE | DATE | Yes | Transaction date | |
| PROCESSING_STATUS_CODE | VARCHAR2 | (25) | Yes | Processing status of the interface row |
| PROCESSING_MODE_CODE | VARCHAR2 | (25) | Yes | Processing mode to be used when the interface row is processed |
| PROCESSING_REQUEST_ID | NUMBER | 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 |
| CATEGORY_ID | NUMBER | Item category unique identifier | ||
| QUANTITY | NUMBER | Transaction quantity | ||
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Transaction unit of measure | |
| INTERFACE_SOURCE_CODE | VARCHAR2 | (30) | Source of the interface row | |
| INTERFACE_SOURCE_LINE_ID | NUMBER | Source line identifier of the interface row | ||
| INV_TRANSACTION_ID | NUMBER | Inventory transaction unique identifier | ||
| ITEM_ID | NUMBER | Item unique identifier | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
| ITEM_REVISION | VARCHAR2 | (3) | Item revision number | |
| UOM_CODE | VARCHAR2 | (3) | Transaction unit of measure code | |
| EMPLOYEE_ID | NUMBER | (9) | Receiver unique identifier | |
| AUTO_TRANSACT_CODE | VARCHAR2 | (25) | Automatic transaction creation code | |
| SHIPMENT_HEADER_ID | NUMBER | Receipt shipment header unique identifier | ||
| SHIPMENT_LINE_ID | NUMBER | Receipt shipment line unique identifier | ||
| SHIP_TO_LOCATION_ID | NUMBER | Ship-to location unique identifier | ||
| PRIMARY_QUANTITY | NUMBER | Transaction quantity in terms of the item's primary unit of measure | ||
| PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Primary unit of measure of the item | |
| RECEIPT_SOURCE_CODE | VARCHAR2 | (25) | Source of the receipt | |
| VENDOR_ID | NUMBER | Supplier unique identifier | ||
| VENDOR_SITE_ID | NUMBER | Supplier site unique identifier | ||
| FROM_ORGANIZATION_ID | NUMBER | Source organization unique identifier | ||
| FROM_SUBINVENTORY | VARCHAR2 | (10) | Source subinventory name | |
| TO_ORGANIZATION_ID | NUMBER | Destination organization unique identifier | ||
| INTRANSIT_OWNING_ORG_ID | NUMBER | Organization that owns the items while they are in transit | ||
| ROUTING_HEADER_ID | NUMBER | Receiving routing unique identifier | ||
| ROUTING_STEP_ID | NUMBER | Not currently used | ||
| SOURCE_DOCUMENT_CODE | VARCHAR2 | (25) | Source document type | |
| PARENT_TRANSACTION_ID | NUMBER | Parent receiving transaction unique identifier | ||
| PO_HEADER_ID | NUMBER | Purchase order header unique identifier | ||
| PO_REVISION_NUM | NUMBER | Purchase order revision number | ||
| PO_RELEASE_ID | NUMBER | Purchase order Release unique identifier | ||
| PO_LINE_ID | NUMBER | Purchase order line unique identifier | ||
| PO_LINE_LOCATION_ID | NUMBER | Purchase order shipment unique identifier | ||
| PO_UNIT_PRICE | NUMBER | Unit price at time of receipt | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Source document currency code | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date | ||
| PO_DISTRIBUTION_ID | NUMBER | Purchase order distribution unique identifier | ||
| REQUISITION_LINE_ID | NUMBER | Requisition line unique identifier | ||
| REQ_DISTRIBUTION_ID | NUMBER | Requisition distribution unique identifier | ||
| CHARGE_ACCOUNT_ID | NUMBER | Charge account identifier | ||
| SUBSTITUTE_UNORDERED_CODE | VARCHAR2 | (25) | Substitute or unordered receipt indicator | |
| RECEIPT_EXCEPTION_FLAG | VARCHAR2 | (1) | Receipt exception indicator | |
| ACCRUAL_STATUS_CODE | VARCHAR2 | (25) | Accrual status of the items | |
| INSPECTION_STATUS_CODE | VARCHAR2 | (25) | Quality inspection status | |
| INSPECTION_QUALITY_CODE | VARCHAR2 | (25) | Quality inspection result code | |
| DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Destination type | |
| DELIVER_TO_PERSON_ID | NUMBER | Requester unique identifier | ||
| LOCATION_ID | NUMBER | Receiving location unique identifier | ||
| DELIVER_TO_LOCATION_ID | NUMBER | Deliver-to location unique identifier | ||
| SUBINVENTORY | VARCHAR2 | (10) | Destination subinventory name | |
| LOCATOR_ID | NUMBER | Destination locator unique identifier | ||
| WIP_ENTITY_ID | NUMBER | WIP job or repetitive assembly identifier | ||
| WIP_LINE_ID | NUMBER | WIP line identifier | ||
| DEPARTMENT_CODE | VARCHAR2 | (10) | WIP department name | |
| WIP_REPETITIVE_SCHEDULE_ID | NUMBER | WIP repetitive schedule identifier | ||
| WIP_OPERATION_SEQ_NUM | NUMBER | WIP operation sequence number within a routing | ||
| WIP_RESOURCE_SEQ_NUM | NUMBER | WIP resource sequence number | ||
| BOM_RESOURCE_ID | NUMBER | BOM resource unique identifier | ||
| SHIPMENT_NUM | VARCHAR2 | (30) | Supplier or source organization shipment number | |
| FREIGHT_CARRIER_CODE | VARCHAR2 | (25) | Freight carrier used to ship items | |
| BILL_OF_LADING | VARCHAR2 | (25) | Bill of lading number | |
| PACKING_SLIP | VARCHAR2 | (25) | Packing slip number | |
| SHIPPED_DATE | DATE | Date of shipping | ||
| EXPECTED_RECEIPT_DATE | DATE | Expected arrival date | ||
| ACTUAL_COST | NUMBER | Actual cost | ||
| TRANSFER_COST | NUMBER | Cost of transferring items between organizations | ||
| TRANSPORTATION_COST | NUMBER | Cost of shipping items between organizations | ||
| TRANSPORTATION_ACCOUNT_ID | NUMBER | Account to be charged for transportation costs | ||
| NUM_OF_CONTAINERS | NUMBER | Number of containers in the shipment | ||
| WAYBILL_AIRBILL_NUM | VARCHAR2 | (30) | Waybill or airbill number | |
| VENDOR_ITEM_NUM | VARCHAR2 | (25) | Supplier's item number | |
| VENDOR_LOT_NUM | VARCHAR2 | (30) | Supplier's lot number | |
| RMA_REFERENCE | VARCHAR2 | (30) | RMA reference number for return-to-supplier items | |
| COMMENTS | VARCHAR2 | (240) | Receiver comments | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| SHIP_HEAD_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE1 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE2 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE3 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE4 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE5 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE6 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE7 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE8 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE9 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE10 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE11 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE12 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE13 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE14 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_HEAD_ATTRIBUTE15 | VARCHAR2 | (150) | Shipment header descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE1 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE2 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE3 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE4 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE5 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE6 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE7 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE8 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE9 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE10 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE11 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE12 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE13 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE14 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| SHIP_LINE_ATTRIBUTE15 | VARCHAR2 | (150) | Shipment line descriptive flexfield segment column | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States standard general ledger transaction code | |
| GOVERNMENT_CONTEXT | VARCHAR2 | (30) | USSGL descriptive flexfield context column | |
| REASON_ID | NUMBER | 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) | Source document's unit of measure | |
| MOVEMENT_ID | NUMBER | Movement identifier | ||
| HEADER_INTERFACE_ID | NUMBER | Interface header unique identifier if it exists | ||
| VENDOR_CUM_SHIPPED_QTY | NUMBER | Supplier's CUM quantity shipped specified on the Advance Shipment Notice (ASN) | ||
| ITEM_NUM | VARCHAR2 | (81) | Buyer's item number specified on the ASN | |
| DOCUMENT_NUM | VARCHAR2 | (50) | Purchase order number specified on the ASN | |
| DOCUMENT_LINE_NUM | VARCHAR2 | (50) | Purchase order line number specified on the ASN | |
| TRUCK_NUM | VARCHAR2 | (35) | Truck number | |
| SHIP_TO_LOCATION_CODE | VARCHAR2 | (60) | Ship-to location specified at the item level on the ASN | |
| CONTAINER_NUM | VARCHAR2 | (35) | Container number | |
| SUBSTITUTE_ITEM_NUM | VARCHAR2 | (81) | Buyer's substitute item number specified on ASN | |
| NOTICE_UNIT_PRICE | NUMBER | EDI transaction 857 unit price | ||
| ITEM_CATEGORY | VARCHAR2 | (81) | Item category code - key flexfield all segments | |
| LOCATION_CODE | VARCHAR2 | (60) | Ship-to/receiving location | |
| VENDOR_NAME | VARCHAR2 | (240) | Supplier name | |
| VENDOR_NUM | VARCHAR2 | (30) | Supplier number | |
| VENDOR_SITE_CODE | VARCHAR2 | (15) | Supplier site code | |
| FROM_ORGANIZATION_CODE | VARCHAR2 | (3) | From organization code for inter-organization transfers | |
| TO_ORGANIZATION_CODE | VARCHAR2 | (3) | Ship-to organization code | |
| INTRANSIT_OWNING_ORG_CODE | VARCHAR2 | (3) | In-transit owning organization code for inter-organization transfers | |
| ROUTING_CODE | VARCHAR2 | (30) | Receiving routing name | |
| ROUTING_STEP | VARCHAR2 | (30) | Upgrade step unique identifier | |
| RELEASE_NUM | NUMBER | Release number | ||
| DOCUMENT_SHIPMENT_LINE_NUM | NUMBER | Document shipment line number | ||
| DOCUMENT_DISTRIBUTION_NUM | NUMBER | Document distribution number | ||
| DELIVER_TO_PERSON_NAME | VARCHAR2 | (240) | Employee full name | |
| DELIVER_TO_LOCATION_CODE | VARCHAR2 | (60) | Deliver-to location code | |
| USE_MTL_LOT | NUMBER | Flag used in lot processing | ||
| USE_MTL_SERIAL | NUMBER | Flag used in serial processing | ||
| LOCATOR | VARCHAR2 | (81) | Stock locator description | |
| REASON_NAME | VARCHAR2 | (30) | Transaction reason name | |
| VALIDATION_FLAG | VARCHAR2 | (1) | Marked after open interface validation | |
| SUBSTITUTE_ITEM_ID | NUMBER | Buyer's substitute item unique identifier | ||
| QUANTITY_SHIPPED | NUMBER | Shipped Quantity | ||
| QUANTITY_INVOICED | NUMBER | Invoiced quantity | ||
| TAX_NAME | VARCHAR2 | (50) | EDI transaction 857 tax name | |
| TAX_AMOUNT | NUMBER | EDI transaction 857 tax amount | ||
| REQ_NUM | VARCHAR2 | (25) | Requisition number | |
| REQ_LINE_NUM | NUMBER | For the REQ_LINE_ID on ASNs | ||
| REQ_DISTRIBUTION_NUM | NUMBER | For the REQ_DISTRIBUTION_ID on ASNs | ||
| WIP_ENTITY_NAME | VARCHAR2 | (24) | For the WIP_ENTITY_ID on ASNs | |
| WIP_LINE_CODE | VARCHAR2 | (10) | For the WIP_LINE_ID on ASNs | |
| RESOURCE_CODE | VARCHAR2 | (30) | For the REASON_ID on ASNs | |
| SHIPMENT_LINE_STATUS_CODE | VARCHAR2 | (25) | Status code for shipment line | |
| BARCODE_LABEL | VARCHAR2 | (35) | Barcoded 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 | Transfer percentage for costing | ||
| QA_COLLECTION_ID | NUMBER | Primary key for Oracle Quality results | ||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) | Code for the country of manufacture | |
| OE_ORDER_HEADER_ID | NUMBER | Sales order unique identifier | ||
| OE_ORDER_LINE_ID | NUMBER | Sales order line unique identifier | ||
| CUSTOMER_ID | NUMBER | Customer unique identifier | ||
| CUSTOMER_SITE_ID | NUMBER | Customer unique identifier | ||
| CUSTOMER_ITEM_NUM | VARCHAR2 | (50) | Customer's item number | |
| CREATE_DEBIT_MEMO_FLAG | VARCHAR2 | (1) | Flag which determines if a debit memo has to be created or not. | |
| PUT_AWAY_RULE_ID | NUMBER | Inserted for WMS functionality | ||
| PUT_AWAY_STRATEGY_ID | NUMBER | Part of WMS enhancement | ||
| LPN_ID | NUMBER | License plate number Identifier (for WMS use) | ||
| TRANSFER_LPN_ID | NUMBER | Transfer license plate number Identifier | ||
| COST_GROUP_ID | NUMBER | Cost Group Identifier for WMS | ||
| MOBILE_TXN | VARCHAR2 | (2) | Y/N for a row created through Mobile form (WMS) | |
| MMTT_TEMP_ID | NUMBER | Reference to original inventory transaction for WMS | ||
| TRANSFER_COST_GROUP_ID | NUMBER | Transfer Cost Group Identifier for Oracle WMS | ||
| SECONDARY_QUANTITY | NUMBER | Transaction quantity in secondary unit of measure | ||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Transaction secondary unit of measure | |
| SECONDARY_UOM_CODE | VARCHAR2 | (3) | Abbreviated secondary unit of measure | |
| QC_GRADE | VARCHAR2 | (150) | Quality grade of the item received | |
| FROM_LOCATOR | VARCHAR2 | (81) | Parent locator | |
| FROM_LOCATOR_ID | NUMBER | Parent locator id | ||
| PARENT_SOURCE_TRANSACTION_NUM | VARCHAR2 | (25) | Parent source transaction num | |
| INTERFACE_AVAILABLE_QTY | NUMBER | Available qty for the children rti rows | ||
| INTERFACE_TRANSACTION_QTY | NUMBER | Available transaction quantity. | ||
| INTERFACE_AVAILABLE_AMT | NUMBER | Available amount for the children rti rows | ||
| INTERFACE_TRANSACTION_AMT | NUMBER | Available transaction quantity. | ||
| LICENSE_PLATE_NUMBER | VARCHAR2 | (30) | Licence plate number | |
| SOURCE_TRANSACTION_NUM | VARCHAR2 | (25) | Source Transaction Number | |
| TRANSFER_LICENSE_PLATE_NUMBER | VARCHAR2 | (30) | Parent Licence plate number | |
| LPN_GROUP_ID | NUMBER | Lpn group identifier | ||
| ORDER_TRANSACTION_ID | NUMBER | Order Transaction Identifier | ||
| CUSTOMER_ACCOUNT_NUMBER | NUMBER | Customer Account Number | ||
| CUSTOMER_PARTY_NAME | VARCHAR2 | (360) | Customer Party Name | |
| OE_ORDER_LINE_NUM | NUMBER | Order Line Number | ||
| OE_ORDER_NUM | NUMBER | Order Number | ||
| PARENT_INTERFACE_TXN_ID | NUMBER | Parent rti id for the current rti row | ||
| CUSTOMER_ITEM_ID | NUMBER | Customer Item Identifier | ||
| AMOUNT | NUMBER | Amount | ||
| JOB_ID | NUMBER | Job Identifier for services | ||
| TIMECARD_ID | NUMBER | Timecard Identifier | ||
| TIMECARD_OVN | NUMBER | Timecard revision | ||
| ERECORD_ID | NUMBER | eRecord Identifier | ||
| PROJECT_ID | NUMBER | Project identifier for timecard | ||
| TASK_ID | NUMBER | Task identifier for timecard | ||
| ASN_ATTACH_ID | NUMBER | Asn Attach Id | ||
| ORG_ID | NUMBER | Organization identifier | ||
| OPERATING_UNIT | VARCHAR2 | (240) | Operation Unit Name used to derive ORG_ID | |
| REQUESTED_AMOUNT | NUMBER | requested_amount for a work confirmation line | ||
| MATERIAL_STORED_AMOUNT | NUMBER | material stored amont for a work confirmation line | ||
| AMOUNT_SHIPPED | NUMBER | Amount shipped for a work confirmation line | ||
| MATCHING_BASIS | VARCHAR2 | (30) | PO shipment Matching basis | |
| REPLENISH_ORDER_LINE_ID | NUMBER | Replenishment sales order line unique identifier for chargeable subcontracting component | ||
| EXPRESS_TRANSACTION | VARCHAR2 | (1) | Flag of Mobile Express Transaction | |
| LCM_SHIPMENT_LINE_ID | NUMBER | LCM shipment Line id | ||
| UNIT_LANDED_COST | NUMBER | Unit Landed Cost | ||
| LCM_ADJUSTMENT_NUM | NUMBER | LCM Adjustment Num |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_TRANSACTION_ID
, GROUP_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TRANSACTION_TYPE
, TRANSACTION_DATE
, PROCESSING_STATUS_CODE
, PROCESSING_MODE_CODE
, PROCESSING_REQUEST_ID
, TRANSACTION_STATUS_CODE
, CATEGORY_ID
, QUANTITY
, UNIT_OF_MEASURE
, INTERFACE_SOURCE_CODE
, INTERFACE_SOURCE_LINE_ID
, INV_TRANSACTION_ID
, ITEM_ID
, ITEM_DESCRIPTION
, ITEM_REVISION
, UOM_CODE
, EMPLOYEE_ID
, AUTO_TRANSACT_CODE
, SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, SHIP_TO_LOCATION_ID
, PRIMARY_QUANTITY
, PRIMARY_UNIT_OF_MEASURE
, RECEIPT_SOURCE_CODE
, VENDOR_ID
, VENDOR_SITE_ID
, FROM_ORGANIZATION_ID
, FROM_SUBINVENTORY
, TO_ORGANIZATION_ID
, INTRANSIT_OWNING_ORG_ID
, ROUTING_HEADER_ID
, ROUTING_STEP_ID
, SOURCE_DOCUMENT_CODE
, PARENT_TRANSACTION_ID
, PO_HEADER_ID
, PO_REVISION_NUM
, PO_RELEASE_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, PO_UNIT_PRICE
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, PO_DISTRIBUTION_ID
, REQUISITION_LINE_ID
, REQ_DISTRIBUTION_ID
, CHARGE_ACCOUNT_ID
, SUBSTITUTE_UNORDERED_CODE
, RECEIPT_EXCEPTION_FLAG
, ACCRUAL_STATUS_CODE
, INSPECTION_STATUS_CODE
, INSPECTION_QUALITY_CODE
, DESTINATION_TYPE_CODE
, DELIVER_TO_PERSON_ID
, LOCATION_ID
, DELIVER_TO_LOCATION_ID
, SUBINVENTORY
, LOCATOR_ID
, WIP_ENTITY_ID
, WIP_LINE_ID
, DEPARTMENT_CODE
, WIP_REPETITIVE_SCHEDULE_ID
, WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM
, BOM_RESOURCE_ID
, SHIPMENT_NUM
, FREIGHT_CARRIER_CODE
, BILL_OF_LADING
, PACKING_SLIP
, SHIPPED_DATE
, EXPECTED_RECEIPT_DATE
, ACTUAL_COST
, TRANSFER_COST
, TRANSPORTATION_COST
, TRANSPORTATION_ACCOUNT_ID
, NUM_OF_CONTAINERS
, WAYBILL_AIRBILL_NUM
, VENDOR_ITEM_NUM
, VENDOR_LOT_NUM
, RMA_REFERENCE
, COMMENTS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SHIP_HEAD_ATTRIBUTE_CATEGORY
, SHIP_HEAD_ATTRIBUTE1
, SHIP_HEAD_ATTRIBUTE2
, SHIP_HEAD_ATTRIBUTE3
, SHIP_HEAD_ATTRIBUTE4
, SHIP_HEAD_ATTRIBUTE5
, SHIP_HEAD_ATTRIBUTE6
, SHIP_HEAD_ATTRIBUTE7
, SHIP_HEAD_ATTRIBUTE8
, SHIP_HEAD_ATTRIBUTE9
, SHIP_HEAD_ATTRIBUTE10
, SHIP_HEAD_ATTRIBUTE11
, SHIP_HEAD_ATTRIBUTE12
, SHIP_HEAD_ATTRIBUTE13
, SHIP_HEAD_ATTRIBUTE14
, SHIP_HEAD_ATTRIBUTE15
, SHIP_LINE_ATTRIBUTE_CATEGORY
, SHIP_LINE_ATTRIBUTE1
, SHIP_LINE_ATTRIBUTE2
, SHIP_LINE_ATTRIBUTE3
, SHIP_LINE_ATTRIBUTE4
, SHIP_LINE_ATTRIBUTE5
, SHIP_LINE_ATTRIBUTE6
, SHIP_LINE_ATTRIBUTE7
, SHIP_LINE_ATTRIBUTE8
, SHIP_LINE_ATTRIBUTE9
, SHIP_LINE_ATTRIBUTE10
, SHIP_LINE_ATTRIBUTE11
, SHIP_LINE_ATTRIBUTE12
, SHIP_LINE_ATTRIBUTE13
, SHIP_LINE_ATTRIBUTE14
, SHIP_LINE_ATTRIBUTE15
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REASON_ID
, DESTINATION_CONTEXT
, SOURCE_DOC_QUANTITY
, SOURCE_DOC_UNIT_OF_MEASURE
, MOVEMENT_ID
, HEADER_INTERFACE_ID
, VENDOR_CUM_SHIPPED_QTY
, ITEM_NUM
, DOCUMENT_NUM
, DOCUMENT_LINE_NUM
, TRUCK_NUM
, SHIP_TO_LOCATION_CODE
, CONTAINER_NUM
, SUBSTITUTE_ITEM_NUM
, NOTICE_UNIT_PRICE
, ITEM_CATEGORY
, LOCATION_CODE
, VENDOR_NAME
, VENDOR_NUM
, VENDOR_SITE_CODE
, FROM_ORGANIZATION_CODE
, TO_ORGANIZATION_CODE
, INTRANSIT_OWNING_ORG_CODE
, ROUTING_CODE
, ROUTING_STEP
, RELEASE_NUM
, DOCUMENT_SHIPMENT_LINE_NUM
, DOCUMENT_DISTRIBUTION_NUM
, DELIVER_TO_PERSON_NAME
, DELIVER_TO_LOCATION_CODE
, USE_MTL_LOT
, USE_MTL_SERIAL
, LOCATOR
, REASON_NAME
, VALIDATION_FLAG
, SUBSTITUTE_ITEM_ID
, QUANTITY_SHIPPED
, QUANTITY_INVOICED
, TAX_NAME
, TAX_AMOUNT
, REQ_NUM
, REQ_LINE_NUM
, REQ_DISTRIBUTION_NUM
, WIP_ENTITY_NAME
, WIP_LINE_CODE
, RESOURCE_CODE
, SHIPMENT_LINE_STATUS_CODE
, BARCODE_LABEL
, TRANSFER_PERCENTAGE
, QA_COLLECTION_ID
, COUNTRY_OF_ORIGIN_CODE
, OE_ORDER_HEADER_ID
, OE_ORDER_LINE_ID
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, CUSTOMER_ITEM_NUM
, CREATE_DEBIT_MEMO_FLAG
, PUT_AWAY_RULE_ID
, PUT_AWAY_STRATEGY_ID
, LPN_ID
, TRANSFER_LPN_ID
, COST_GROUP_ID
, MOBILE_TXN
, MMTT_TEMP_ID
, TRANSFER_COST_GROUP_ID
, SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_UOM_CODE
, QC_GRADE
, FROM_LOCATOR
, FROM_LOCATOR_ID
, PARENT_SOURCE_TRANSACTION_NUM
, INTERFACE_AVAILABLE_QTY
, INTERFACE_TRANSACTION_QTY
, INTERFACE_AVAILABLE_AMT
, INTERFACE_TRANSACTION_AMT
, LICENSE_PLATE_NUMBER
, SOURCE_TRANSACTION_NUM
, TRANSFER_LICENSE_PLATE_NUMBER
, LPN_GROUP_ID
, ORDER_TRANSACTION_ID
, CUSTOMER_ACCOUNT_NUMBER
, CUSTOMER_PARTY_NAME
, OE_ORDER_LINE_NUM
, OE_ORDER_NUM
, PARENT_INTERFACE_TXN_ID
, CUSTOMER_ITEM_ID
, AMOUNT
, JOB_ID
, TIMECARD_ID
, TIMECARD_OVN
, ERECORD_ID
, PROJECT_ID
, TASK_ID
, ASN_ATTACH_ID
, ORG_ID
, OPERATING_UNIT
, REQUESTED_AMOUNT
, MATERIAL_STORED_AMOUNT
, AMOUNT_SHIPPED
, MATCHING_BASIS
, REPLENISH_ORDER_LINE_ID
, EXPRESS_TRANSACTION
, LCM_SHIPMENT_LINE_ID
, UNIT_LANDED_COST
, LCM_ADJUSTMENT_NUM
FROM PO.RCV_TRANSACTIONS_INTERFACE;
PO.RCV_TRANSACTIONS_INTERFACE does not reference any database object
PO.RCV_TRANSACTIONS_INTERFACE is referenced by following:
PO
RCV_TRANSACTIONS_INTERFACE#
|
|
|
|