[Home] [Help] [Dependency Information]
Object Name: | RCV_TRANSACTIONS_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_TRANSACTION_ID | NUMBER | Yes | ||
GROUP_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
TRANSACTION_TYPE | VARCHAR2 | (25) | Yes | |
TRANSACTION_DATE | DATE | Yes | ||
PROCESSING_STATUS_CODE | VARCHAR2 | (25) | Yes | |
PROCESSING_MODE_CODE | VARCHAR2 | (25) | Yes | |
PROCESSING_REQUEST_ID | NUMBER | |||
TRANSACTION_STATUS_CODE | VARCHAR2 | (25) | Yes | |
CATEGORY_ID | NUMBER | |||
QUANTITY | NUMBER | |||
UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
INTERFACE_SOURCE_CODE | VARCHAR2 | (30) | ||
INTERFACE_SOURCE_LINE_ID | NUMBER | |||
INV_TRANSACTION_ID | NUMBER | |||
ITEM_ID | NUMBER | |||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ITEM_REVISION | VARCHAR2 | (3) | ||
UOM_CODE | VARCHAR2 | (3) | ||
EMPLOYEE_ID | NUMBER | (9) | ||
AUTO_TRANSACT_CODE | VARCHAR2 | (25) | ||
SHIPMENT_HEADER_ID | NUMBER | |||
SHIPMENT_LINE_ID | NUMBER | |||
SHIP_TO_LOCATION_ID | NUMBER | |||
PRIMARY_QUANTITY | NUMBER | |||
PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
RECEIPT_SOURCE_CODE | VARCHAR2 | (25) | ||
VENDOR_ID | NUMBER | |||
VENDOR_SITE_ID | NUMBER | |||
FROM_ORGANIZATION_ID | NUMBER | |||
FROM_SUBINVENTORY | VARCHAR2 | (10) | ||
TO_ORGANIZATION_ID | NUMBER | |||
INTRANSIT_OWNING_ORG_ID | NUMBER | |||
ROUTING_HEADER_ID | NUMBER | |||
ROUTING_STEP_ID | NUMBER | |||
SOURCE_DOCUMENT_CODE | VARCHAR2 | (25) | ||
PARENT_TRANSACTION_ID | NUMBER | |||
PO_HEADER_ID | NUMBER | |||
PO_REVISION_NUM | NUMBER | |||
PO_RELEASE_ID | NUMBER | |||
PO_LINE_ID | NUMBER | |||
PO_LINE_LOCATION_ID | NUMBER | |||
PO_UNIT_PRICE | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_DATE | DATE | |||
PO_DISTRIBUTION_ID | NUMBER | |||
REQUISITION_LINE_ID | NUMBER | |||
REQ_DISTRIBUTION_ID | NUMBER | |||
CHARGE_ACCOUNT_ID | NUMBER | |||
SUBSTITUTE_UNORDERED_CODE | VARCHAR2 | (25) | ||
RECEIPT_EXCEPTION_FLAG | VARCHAR2 | (1) | ||
ACCRUAL_STATUS_CODE | VARCHAR2 | (25) | ||
INSPECTION_STATUS_CODE | VARCHAR2 | (25) | ||
INSPECTION_QUALITY_CODE | VARCHAR2 | (25) | ||
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | ||
DELIVER_TO_PERSON_ID | NUMBER | |||
LOCATION_ID | NUMBER | |||
DELIVER_TO_LOCATION_ID | NUMBER | |||
SUBINVENTORY | VARCHAR2 | (10) | ||
LOCATOR_ID | NUMBER | |||
WIP_ENTITY_ID | NUMBER | |||
WIP_LINE_ID | NUMBER | |||
DEPARTMENT_CODE | VARCHAR2 | (10) | ||
WIP_REPETITIVE_SCHEDULE_ID | NUMBER | |||
WIP_OPERATION_SEQ_NUM | NUMBER | |||
WIP_RESOURCE_SEQ_NUM | NUMBER | |||
BOM_RESOURCE_ID | NUMBER | |||
SHIPMENT_NUM | VARCHAR2 | (30) | ||
FREIGHT_CARRIER_CODE | VARCHAR2 | (25) | ||
BILL_OF_LADING | VARCHAR2 | (25) | ||
PACKING_SLIP | VARCHAR2 | (25) | ||
SHIPPED_DATE | DATE | |||
EXPECTED_RECEIPT_DATE | DATE | |||
ACTUAL_COST | NUMBER | |||
TRANSFER_COST | NUMBER | |||
TRANSPORTATION_COST | NUMBER | |||
TRANSPORTATION_ACCOUNT_ID | NUMBER | |||
NUM_OF_CONTAINERS | NUMBER | |||
WAYBILL_AIRBILL_NUM | VARCHAR2 | (30) | ||
VENDOR_ITEM_NUM | VARCHAR2 | (25) | ||
VENDOR_LOT_NUM | VARCHAR2 | (30) | ||
RMA_REFERENCE | VARCHAR2 | (30) | ||
COMMENTS | VARCHAR2 | (240) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
SHIP_HEAD_ATTRIBUTE1 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE2 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE3 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE4 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE5 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE6 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE7 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE8 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE9 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE10 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE11 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE12 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE13 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE14 | VARCHAR2 | (150) | ||
SHIP_HEAD_ATTRIBUTE15 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
SHIP_LINE_ATTRIBUTE1 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE2 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE3 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE4 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE5 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE6 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE7 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE8 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE9 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE10 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE11 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE12 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE13 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE14 | VARCHAR2 | (150) | ||
SHIP_LINE_ATTRIBUTE15 | VARCHAR2 | (150) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | ||
REASON_ID | NUMBER | |||
DESTINATION_CONTEXT | VARCHAR2 | (30) | ||
SOURCE_DOC_QUANTITY | NUMBER | |||
SOURCE_DOC_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
MOVEMENT_ID | NUMBER | |||
HEADER_INTERFACE_ID | NUMBER | |||
VENDOR_CUM_SHIPPED_QTY | NUMBER | |||
ITEM_NUM | VARCHAR2 | (81) | ||
DOCUMENT_NUM | VARCHAR2 | (50) | ||
DOCUMENT_LINE_NUM | VARCHAR2 | (50) | ||
TRUCK_NUM | VARCHAR2 | (35) | ||
SHIP_TO_LOCATION_CODE | VARCHAR2 | (60) | ||
CONTAINER_NUM | VARCHAR2 | (35) | ||
SUBSTITUTE_ITEM_NUM | VARCHAR2 | (81) | ||
NOTICE_UNIT_PRICE | NUMBER | |||
ITEM_CATEGORY | VARCHAR2 | (81) | ||
LOCATION_CODE | VARCHAR2 | (60) | ||
VENDOR_NAME | VARCHAR2 | (240) | ||
VENDOR_NUM | VARCHAR2 | (30) | ||
VENDOR_SITE_CODE | VARCHAR2 | (15) | ||
FROM_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
TO_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
INTRANSIT_OWNING_ORG_CODE | VARCHAR2 | (3) | ||
ROUTING_CODE | VARCHAR2 | (30) | ||
ROUTING_STEP | VARCHAR2 | (30) | ||
RELEASE_NUM | NUMBER | |||
DOCUMENT_SHIPMENT_LINE_NUM | NUMBER | |||
DOCUMENT_DISTRIBUTION_NUM | NUMBER | |||
DELIVER_TO_PERSON_NAME | VARCHAR2 | (240) | ||
DELIVER_TO_LOCATION_CODE | VARCHAR2 | (60) | ||
USE_MTL_LOT | NUMBER | |||
USE_MTL_SERIAL | NUMBER | |||
LOCATOR | VARCHAR2 | (81) | ||
REASON_NAME | VARCHAR2 | (30) | ||
VALIDATION_FLAG | VARCHAR2 | (1) | ||
SUBSTITUTE_ITEM_ID | NUMBER | |||
QUANTITY_SHIPPED | NUMBER | |||
QUANTITY_INVOICED | NUMBER | |||
TAX_NAME | VARCHAR2 | (50) | ||
TAX_AMOUNT | NUMBER | |||
REQ_NUM | VARCHAR2 | (25) | ||
REQ_LINE_NUM | NUMBER | |||
REQ_DISTRIBUTION_NUM | NUMBER | |||
WIP_ENTITY_NAME | VARCHAR2 | (24) | ||
WIP_LINE_CODE | VARCHAR2 | (10) | ||
RESOURCE_CODE | VARCHAR2 | (30) | ||
SHIPMENT_LINE_STATUS_CODE | VARCHAR2 | (25) | ||
BARCODE_LABEL | VARCHAR2 | (35) | ||
TRANSFER_PERCENTAGE | NUMBER | |||
QA_COLLECTION_ID | NUMBER | |||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) | ||
OE_ORDER_HEADER_ID | NUMBER | |||
OE_ORDER_LINE_ID | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
CUSTOMER_SITE_ID | NUMBER | |||
CUSTOMER_ITEM_NUM | VARCHAR2 | (50) | ||
CREATE_DEBIT_MEMO_FLAG | VARCHAR2 | (1) | ||
PUT_AWAY_RULE_ID | NUMBER | |||
PUT_AWAY_STRATEGY_ID | NUMBER | |||
LPN_ID | NUMBER | |||
TRANSFER_LPN_ID | NUMBER | |||
COST_GROUP_ID | NUMBER | |||
MOBILE_TXN | VARCHAR2 | (2) | ||
MMTT_TEMP_ID | NUMBER | |||
TRANSFER_COST_GROUP_ID | NUMBER | |||
SECONDARY_QUANTITY | NUMBER | |||
SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
SECONDARY_UOM_CODE | VARCHAR2 | (3) | ||
QC_GRADE | VARCHAR2 | (150) | ||
FROM_LOCATOR | VARCHAR2 | (81) | ||
FROM_LOCATOR_ID | NUMBER | |||
PARENT_SOURCE_TRANSACTION_NUM | VARCHAR2 | (25) | ||
INTERFACE_AVAILABLE_QTY | NUMBER | |||
INTERFACE_TRANSACTION_QTY | NUMBER | |||
INTERFACE_AVAILABLE_AMT | NUMBER | |||
INTERFACE_TRANSACTION_AMT | NUMBER | |||
LICENSE_PLATE_NUMBER | VARCHAR2 | (30) | ||
SOURCE_TRANSACTION_NUM | VARCHAR2 | (25) | ||
TRANSFER_LICENSE_PLATE_NUMBER | VARCHAR2 | (30) | ||
LPN_GROUP_ID | NUMBER | |||
ORDER_TRANSACTION_ID | NUMBER | |||
CUSTOMER_ACCOUNT_NUMBER | NUMBER | |||
CUSTOMER_PARTY_NAME | VARCHAR2 | (360) | ||
OE_ORDER_LINE_NUM | NUMBER | |||
OE_ORDER_NUM | NUMBER | |||
PARENT_INTERFACE_TXN_ID | NUMBER | |||
CUSTOMER_ITEM_ID | NUMBER | |||
AMOUNT | NUMBER | |||
JOB_ID | NUMBER | |||
TIMECARD_ID | NUMBER | |||
TIMECARD_OVN | NUMBER | |||
ERECORD_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
ASN_ATTACH_ID | NUMBER | |||
ORG_ID | NUMBER | |||
OPERATING_UNIT | VARCHAR2 | (240) | ||
REQUESTED_AMOUNT | NUMBER | |||
MATERIAL_STORED_AMOUNT | NUMBER | |||
AMOUNT_SHIPPED | NUMBER | |||
MATCHING_BASIS | VARCHAR2 | (30) | ||
REPLENISH_ORDER_LINE_ID | NUMBER | |||
EXPRESS_TRANSACTION | VARCHAR2 | (1) | ||
LCM_SHIPMENT_LINE_ID | NUMBER | |||
UNIT_LANDED_COST | NUMBER | |||
LCM_ADJUSTMENT_NUM | NUMBER |
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#;
|
|
|