Product: | AX - Global Accounting Engine |
---|---|
Description: | Duplicate information from a subset of columns of table RCV_TRANSACTIONS |
Implementation/DBA Data: | Not implemented in this database |
SELECT TRANSACTION_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
, QUANTITY
, UNIT_OF_MEASURE
, SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, USER_ENTERED_FLAG
, INTERFACE_SOURCE_CODE
, INTERFACE_SOURCE_LINE_ID
, INV_TRANSACTION_ID
, SOURCE_DOCUMENT_CODE
, DESTINATION_TYPE_CODE
, PRIMARY_QUANTITY
, PRIMARY_UNIT_OF_MEASURE
, UOM_CODE
, EMPLOYEE_ID
, PARENT_TRANSACTION_ID
, PO_HEADER_ID
, PO_RELEASE_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID
, PO_REVISION_NUM
, REQUISITION_LINE_ID
, PO_UNIT_PRICE
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, ROUTING_HEADER_ID
, ROUTING_STEP_ID
, DELIVER_TO_PERSON_ID
, DELIVER_TO_LOCATION_ID
, VENDOR_ID
, VENDOR_SITE_ID
, ORGANIZATION_ID
, SUBINVENTORY
, LOCATOR_ID
, WIP_ENTITY_ID
, WIP_LINE_ID
, WIP_REPETITIVE_SCHEDULE_ID
, WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM
, BOM_RESOURCE_ID
, LOCATION_ID
, SUBSTITUTE_UNORDERED_CODE
, RECEIPT_EXCEPTION_FLAG
, INSPECTION_STATUS_CODE
, ACCRUAL_STATUS_CODE
, INSPECTION_QUALITY_CODE
, VENDOR_LOT_NUM
, RMA_REFERENCE
, COMMENTS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQ_DISTRIBUTION_ID
, DEPARTMENT_CODE
, REASON_ID
, DESTINATION_CONTEXT
, LOCATOR_ATTRIBUTE
, CHILD_INSPECTION_FLAG
, SOURCE_DOC_UNIT_OF_MEASURE
, SOURCE_DOC_QUANTITY
, INTERFACE_TRANSACTION_ID
, GROUP_ID
, MOVEMENT_ID
, INVOICE_STATUS_CODE
FROM RCV_TRANSACTIONS