eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: EC.ECE_MVSTO_DETAILS#

Source

View Text - Preformatted


select EDI_SENT_FLAG EDI_SENT_FLAG, PERIOD_NAME PERIOD_NAME, EDI_TRANSACTION_REFERENCE EDI_TRANSACTION_REFERENCE, EDI_TRANSACTION_DATE EDI_TRANSACTION_DATE, TRANSACTION_DATE TRANSACTION_DATE, SET_OF_BOOKS_PERIOD SET_OF_BOOKS_PERIOD, CREATION_METHOD CREATION_METHOD, CREATION_METHOD_EXT1 CREATION_METHOD_EXT1, CREATION_METHOD_EXT2 CREATION_METHOD_EXT2, CREATION_METHOD_EXT3 CREATION_METHOD_EXT3, CREATION_METHOD_EXT4 CREATION_METHOD_EXT4, CREATION_METHOD_EXT5 CREATION_METHOD_EXT5, FLOW_INDICATOR_CODE FLOW_INDICATOR_CODE, FLOW_INDICATOR_CODE_EXT1 FLOW_INDICATOR_CODE_EXT1, FLOW_INDICATOR_CODE_EXT2 FLOW_INDICATOR_CODE_EXT2, FLOW_INDICATOR_CODE_EXT3 FLOW_INDICATOR_CODE_EXT3, FLOW_INDICATOR_CODE_EXT4 FLOW_INDICATOR_CODE_EXT4, FLOW_INDICATOR_CODE_EXT5 FLOW_INDICATOR_CODE_EXT5, STAT_METHOD STAT_METHOD, STAT_METHOD_EXT1 STAT_METHOD_EXT1, STAT_METHOD_EXT2 STAT_METHOD_EXT2, STAT_METHOD_EXT3 STAT_METHOD_EXT3, STAT_METHOD_EXT4 STAT_METHOD_EXT4, STAT_METHOD_EXT5 STAT_METHOD_EXT5, STAT_TYPE STAT_TYPE, STAT_TYPE_EXT1 STAT_TYPE_EXT1, STAT_TYPE_EXT2 STAT_TYPE_EXT2, STAT_TYPE_EXT3 STAT_TYPE_EXT3, STAT_TYPE_EXT4 STAT_TYPE_EXT4, STAT_TYPE_EXT5 STAT_TYPE_EXT5, TRANSPORT_MODE TRANSPORT_MODE, TRANSPORT_MODE_EXT1 TRANSPORT_MODE_EXT1, TRANSPORT_MODE_EXT2 TRANSPORT_MODE_EXT2, TRANSPORT_MODE_EXT3 TRANSPORT_MODE_EXT3, TRANSPORT_MODE_EXT4 TRANSPORT_MODE_EXT4, TRANSPORT_MODE_EXT5 TRANSPORT_MODE_EXT5, TRANSACTION_NATURE TRANSACTION_NATURE, TRANSACTION_NATURE_EXT1 TRANSACTION_NATURE_EXT1, TRANSACTION_NATURE_EXT2 TRANSACTION_NATURE_EXT2, TRANSACTION_NATURE_EXT3 TRANSACTION_NATURE_EXT3, TRANSACTION_NATURE_EXT4 TRANSACTION_NATURE_EXT4, TRANSACTION_NATURE_EXT5 TRANSACTION_NATURE_EXT5, MOVEMENT_NATURE_CODE MOVEMENT_NATURE_CODE, MOVEMENT_NATURE_CODE_EXT1 MOVEMENT_NATURE_CODE_EXT1, MOVEMENT_NATURE_CODE_EXT2 MOVEMENT_NATURE_CODE_EXT2, MOVEMENT_NATURE_CODE_EXT3 MOVEMENT_NATURE_CODE_EXT3, MOVEMENT_NATURE_CODE_EXT4 MOVEMENT_NATURE_CODE_EXT4, MOVEMENT_NATURE_CODE_EXT5 MOVEMENT_NATURE_CODE_EXT5, ORIGIN_TERRITORY_EU_CODE ORIGIN_TERRITORY_EU_CODE, ORIGIN_TERRITORY_CODE ORIGIN_TERRITORY_CODE, ORIGIN_TERRITORY_CODE_EXT1 ORIGIN_TERRITORY_CODE_EXT1, ORIGIN_TERRITORY_CODE_EXT2 ORIGIN_TERRITORY_CODE_EXT2, ORIGIN_TERRITORY_CODE_EXT3 ORIGIN_TERRITORY_CODE_EXT3, ORIGIN_TERRITORY_CODE_EXT4 ORIGIN_TERRITORY_CODE_EXT4, ORIGIN_TERRITORY_CODE_EXT5 ORIGIN_TERRITORY_CODE_EXT5, DESTINATION_TERRITORY_EU_CODE DESTINATION_TERRITORY_EU_CODE, DESTINATION_TERRITORY_CODE DESTINATION_TERRITORY_CODE, DEST_TERRITORY_CODE_EXT1 DEST_TERRITORY_CODE_EXT1, DEST_TERRITORY_CODE_EXT2 DEST_TERRITORY_CODE_EXT2, DEST_TERRITORY_CODE_EXT3 DEST_TERRITORY_CODE_EXT3, DEST_TERRITORY_CODE_EXT4 DEST_TERRITORY_CODE_EXT4, DEST_TERRITORY_CODE_EXT5 DEST_TERRITORY_CODE_EXT5, DISPATCH_TERRITORY_EU_CODE DISPATCH_TERRITORY_EU_CODE, DISPATCH_TERRITORY_CODE DISPATCH_TERRITORY_CODE, DISPATCH_TERRITORY_CODE_EXT1 DISPATCH_TERRITORY_CODE_EXT1, DISPATCH_TERRITORY_CODE_EXT2 DISPATCH_TERRITORY_CODE_EXT2, DISPATCH_TERRITORY_CODE_EXT3 DISPATCH_TERRITORY_CODE_EXT3, DISPATCH_TERRITORY_CODE_EXT4 DISPATCH_TERRITORY_CODE_EXT4, DISPATCH_TERRITORY_CODE_EXT5 DISPATCH_TERRITORY_CODE_EXT5, TRIANGULATION_COUNTRY_EU_CODE TRIANGULATION_COUNTRY_EU_CODE, TRIANGULATION_COUNTRY_CODE TRIANGULATION_COUNTRY_CODE, TRIANG_COUNTRY_CODE_EXT1 TRIANG_COUNTRY_CODE_EXT1, TRIANG_COUNTRY_CODE_EXT2 TRIANG_COUNTRY_CODE_EXT2, TRIANG_COUNTRY_CODE_EXT3 TRIANG_COUNTRY_CODE_EXT3, TRIANG_COUNTRY_CODE_EXT4 TRIANG_COUNTRY_CODE_EXT4, TRIANG_COUNTRY_CODE_EXT5 TRIANG_COUNTRY_CODE_EXT5, PORT PORT, PORT_EXT1 PORT_EXT1, PORT_EXT2 PORT_EXT2, PORT_EXT3 PORT_EXT3, PORT_EXT4 PORT_EXT4, PORT_EXT5 PORT_EXT5, AREA AREA, AREA_EXT1 AREA_EXT1, AREA_EXT2 AREA_EXT2, AREA_EXT3 AREA_EXT3, AREA_EXT4 AREA_EXT4, AREA_EXT5 AREA_EXT5, MOVEMENT_ID MOVEMENT_ID, MOVEMENT_TYPE MOVEMENT_TYPE, MOVEMENT_TYPE_EXT1 MOVEMENT_TYPE_EXT1, MOVEMENT_TYPE_EXT2 MOVEMENT_TYPE_EXT2, MOVEMENT_TYPE_EXT3 MOVEMENT_TYPE_EXT3, MOVEMENT_TYPE_EXT4 MOVEMENT_TYPE_EXT4, MOVEMENT_TYPE_EXT5 MOVEMENT_TYPE_EXT5, ZONE_CODE ZONE_CODE, ECONOMIC_ZONE_EXT1 ECONOMIC_ZONE_EXT1, ECONOMIC_ZONE_EXT2 ECONOMIC_ZONE_EXT2, ECONOMIC_ZONE_EXT3 ECONOMIC_ZONE_EXT3, ECONOMIC_ZONE_EXT4 ECONOMIC_ZONE_EXT4, ECONOMIC_ZONE_EXT5 ECONOMIC_ZONE_EXT5, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CODE_EXT1 CURRENCY_CODE_EXT1, CURRENCY_CODE_EXT2 CURRENCY_CODE_EXT2, CURRENCY_CODE_EXT3 CURRENCY_CODE_EXT3, CURRENCY_CODE_EXT4 CURRENCY_CODE_EXT4, CURRENCY_CODE_EXT5 CURRENCY_CODE_EXT5, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_TYPE_EXT1 CURRENCY_CONVERSION_TYPE_EXT1, CURRENCY_CONVERSION_TYPE_EXT2 CURRENCY_CONVERSION_TYPE_EXT2, CURRENCY_CONVERSION_TYPE_EXT3 CURRENCY_CONVERSION_TYPE_EXT3, CURRENCY_CONVERSION_TYPE_EXT4 CURRENCY_CONVERSION_TYPE_EXT4, CURRENCY_CONVERSION_TYPE_EXT5 CURRENCY_CONVERSION_TYPE_EXT5, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, MOVEMENT_AMOUNT MOVEMENT_AMOUNT, ITEM_COST ITEM_COST, DOCUMENT_UNIT_PRICE DOCUMENT_UNIT_PRICE, DOCUMENT_LINE_EXT_VALUE DOCUMENT_LINE_EXT_VALUE, OUTSIDE_CODE OUTSIDE_CODE, OUTSIDE_CODE_EXT1 OUTSIDE_CODE_EXT1, OUTSIDE_CODE_EXT2 OUTSIDE_CODE_EXT2, OUTSIDE_CODE_EXT3 OUTSIDE_CODE_EXT3, OUTSIDE_CODE_EXT4 OUTSIDE_CODE_EXT4, OUTSIDE_CODE_EXT5 OUTSIDE_CODE_EXT5, OUTSIDE_EXT_VALUE OUTSIDE_EXT_VALUE, OUTSIDE_UNIT_PRICE OUTSIDE_UNIT_PRICE, STAT_ADJ_AMOUNT STAT_ADJ_AMOUNT, STAT_ADJ_PERCENT STAT_ADJ_PERCENT, STAT_EXT_VALUE STAT_EXT_VALUE, DELIVERY_TERMS DELIVERY_TERMS, DELIVERY_TERMS_EXT1 DELIVERY_TERMS_EXT1, DELIVERY_TERMS_EXT2 DELIVERY_TERMS_EXT2, DELIVERY_TERMS_EXT3 DELIVERY_TERMS_EXT3, DELIVERY_TERMS_EXT4 DELIVERY_TERMS_EXT4, DELIVERY_TERMS_EXT5 DELIVERY_TERMS_EXT5, PRIMARY_QUANTITY PRIMARY_QUANTITY, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE, TRANSACTION_UOM_CODE_EXT1 TRANSACTION_UOM_CODE_EXT1, TRANSACTION_UOM_CODE_EXT2 TRANSACTION_UOM_CODE_EXT2, TRANSACTION_UOM_CODE_EXT3 TRANSACTION_UOM_CODE_EXT3, TRANSACTION_UOM_CODE_EXT4 TRANSACTION_UOM_CODE_EXT4, TRANSACTION_UOM_CODE_EXT5 TRANSACTION_UOM_CODE_EXT5, WEIGHT_METHOD WEIGHT_METHOD, WEIGHT_METHOD_EXT1 WEIGHT_METHOD_EXT1, WEIGHT_METHOD_EXT2 WEIGHT_METHOD_EXT2, WEIGHT_METHOD_EXT3 WEIGHT_METHOD_EXT3, WEIGHT_METHOD_EXT4 WEIGHT_METHOD_EXT4, WEIGHT_METHOD_EXT5 WEIGHT_METHOD_EXT5, UNIT_WEIGHT UNIT_WEIGHT, TOTAL_WEIGHT TOTAL_WEIGHT, TOTAL_WEIGHT_UOM_CODE TOTAL_WEIGHT_UOM_CODE, TOTAL_WEIGHT_UOM_CODE_EXT1 TOTAL_WEIGHT_UOM_CODE_EXT1, TOTAL_WEIGHT_UOM_CODE_EXT2 TOTAL_WEIGHT_UOM_CODE_EXT2, TOTAL_WEIGHT_UOM_CODE_EXT3 TOTAL_WEIGHT_UOM_CODE_EXT3, TOTAL_WEIGHT_UOM_CODE_EXT4 TOTAL_WEIGHT_UOM_CODE_EXT4, TOTAL_WEIGHT_UOM_CODE_EXT5 TOTAL_WEIGHT_UOM_CODE_EXT5, ALTERNATE_QUANTITY ALTERNATE_QUANTITY, ALTERNATE_UOM_CODE ALTERNATE_UOM_CODE, ALTERNATE_UOM_CODE_EXT1 ALTERNATE_UOM_CODE_EXT1, ALTERNATE_UOM_CODE_EXT2 ALTERNATE_UOM_CODE_EXT2, ALTERNATE_UOM_CODE_EXT3 ALTERNATE_UOM_CODE_EXT3, ALTERNATE_UOM_CODE_EXT4 ALTERNATE_UOM_CODE_EXT4, ALTERNATE_UOM_CODE_EXT5 ALTERNATE_UOM_CODE_EXT5, COMMODITY_CODE COMMODITY_CODE, COMMODITY_DESCRIPTION COMMODITY_DESCRIPTION, COMMENTS COMMENTS, ITEM_DESCRIPTION ITEM_DESCRIPTION, DOCUMENT_SOURCE_TYPE DOCUMENT_SOURCE_TYPE, DOCUMENT_REFERENCE DOCUMENT_REFERENCE, DOCUMENT_LINE_REFERENCE DOCUMENT_LINE_REFERENCE, TRANSACTING_FROM_ORG TRANSACTING_FROM_ORG, TRANSACTING_TO_ORG TRANSACTING_TO_ORG, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, AFFILIATION_REFERENCE_CODE AFFILIATION_REFERENCE_CODE, AFFILIATION_REF_CODE_EXT1 AFFILIATION_REF_CODE_EXT1, AFFILIATION_REF_CODE_EXT2 AFFILIATION_REF_CODE_EXT2, AFFILIATION_REF_CODE_EXT3 AFFILIATION_REF_CODE_EXT3, AFFILIATION_REF_CODE_EXT4 AFFILIATION_REF_CODE_EXT4, AFFILIATION_REF_CODE_EXT5 AFFILIATION_REF_CODE_EXT5, CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE, CONTAINER_TYPE_CODE_EXT1 CONTAINER_TYPE_CODE_EXT1, CONTAINER_TYPE_CODE_EXT2 CONTAINER_TYPE_CODE_EXT2, CONTAINER_TYPE_CODE_EXT3 CONTAINER_TYPE_CODE_EXT3, CONTAINER_TYPE_CODE_EXT4 CONTAINER_TYPE_CODE_EXT4, CONTAINER_TYPE_CODE_EXT5 CONTAINER_TYPE_CODE_EXT5, CSA_CODE CSA_CODE, CSA_CODE_EXT1 CSA_CODE_EXT1, CSA_CODE_EXT2 CSA_CODE_EXT2, CSA_CODE_EXT3 CSA_CODE_EXT3, CSA_CODE_EXT4 CSA_CODE_EXT4, CSA_CODE_EXT5 CSA_CODE_EXT5, OIL_REFERENCE_CODE OIL_REFERENCE_CODE, OIL_REFERENCE_CODE_EXT1 OIL_REFERENCE_CODE_EXT1, OIL_REFERENCE_CODE_EXT2 OIL_REFERENCE_CODE_EXT2, OIL_REFERENCE_CODE_EXT3 OIL_REFERENCE_CODE_EXT3, OIL_REFERENCE_CODE_EXT4 OIL_REFERENCE_CODE_EXT4, OIL_REFERENCE_CODE_EXT5 OIL_REFERENCE_CODE_EXT5, PICK_SLIP_REFERENCE PICK_SLIP_REFERENCE, PREFERENCE_CODE PREFERENCE_CODE, PREFERENCE_CODE_EXT1 PREFERENCE_CODE_EXT1, PREFERENCE_CODE_EXT2 PREFERENCE_CODE_EXT2, PREFERENCE_CODE_EXT3 PREFERENCE_CODE_EXT3, PREFERENCE_CODE_EXT4 PREFERENCE_CODE_EXT4, PREFERENCE_CODE_EXT5 PREFERENCE_CODE_EXT5, RECEIPT_REFERENCE RECEIPT_REFERENCE, RECEIPT_REFERENCE_EXT1 RECEIPT_REFERENCE_EXT1, RECEIPT_REFERENCE_EXT2 RECEIPT_REFERENCE_EXT2, RECEIPT_REFERENCE_EXT3 RECEIPT_REFERENCE_EXT3, RECEIPT_REFERENCE_EXT4 RECEIPT_REFERENCE_EXT4, RECEIPT_REFERENCE_EXT5 RECEIPT_REFERENCE_EXT5, SHIPMENT_LINE_REFERENCE SHIPMENT_LINE_REFERENCE, SHIPMENT_LINE_REFERENCE_EXT1 SHIPMENT_LINE_REFERENCE_EXT1, SHIPMENT_LINE_REFERENCE_EXT2 SHIPMENT_LINE_REFERENCE_EXT2, SHIPMENT_LINE_REFERENCE_EXT3 SHIPMENT_LINE_REFERENCE_EXT3, SHIPMENT_LINE_REFERENCE_EXT4 SHIPMENT_LINE_REFERENCE_EXT4, SHIPMENT_LINE_REFERENCE_EXT5 SHIPMENT_LINE_REFERENCE_EXT5, SHIPMENT_REFERENCE SHIPMENT_REFERENCE, SHIPMENT_REFERENCE_EXT1 SHIPMENT_REFERENCE_EXT1, SHIPMENT_REFERENCE_EXT2 SHIPMENT_REFERENCE_EXT2, SHIPMENT_REFERENCE_EXT3 SHIPMENT_REFERENCE_EXT3, SHIPMENT_REFERENCE_EXT4 SHIPMENT_REFERENCE_EXT4, SHIPMENT_REFERENCE_EXT5 SHIPMENT_REFERENCE_EXT5, TARIC_CODE TARIC_CODE, TARIC_CODE_EXT1 TARIC_CODE_EXT1, TARIC_CODE_EXT2 TARIC_CODE_EXT2, TARIC_CODE_EXT3 TARIC_CODE_EXT3, TARIC_CODE_EXT4 TARIC_CODE_EXT4, TARIC_CODE_EXT5 TARIC_CODE_EXT5, INVOICE_BATCH_REFERENCE INVOICE_BATCH_REFERENCE, INVOICE_DATE_REFERENCE INVOICE_DATE_REFERENCE, INVOICE_LINE_EXT_VALUE INVOICE_LINE_EXT_VALUE, INVOICE_LINE_REFERENCE INVOICE_LINE_REFERENCE, INVOICE_QUANTITY INVOICE_QUANTITY, INVOICE_REFERENCE INVOICE_REFERENCE, INVOICE_UNIT_PRICE INVOICE_UNIT_PRICE, INVOICE_BATCH_ID INVOICE_BATCH_ID, INVOICE_ID INVOICE_ID, CUSTOMER_LOCATION CUSTOMER_LOCATION, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_NUMBER CUSTOMER_NUMBER, BILL_TO_NAME BILL_TO_NAME, BILL_TO_NUMBER BILL_TO_NUMBER, BILL_TO_SITE BILL_TO_SITE, SHIP_TO_NAME SHIP_TO_NAME, SHIP_TO_NUMBER SHIP_TO_NUMBER, SHIP_TO_SITE SHIP_TO_SITE, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, VENDOR_NAME VENDOR_NAME, VENDOR_NUMBER VENDOR_NUMBER, VENDOR_SITE VENDOR_SITE, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, CATEGORY_ID CATEGORY_ID, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, MTL_TRANSACTION_ID MTL_TRANSACTION_ID, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, ORDER_HEADER_ID ORDER_HEADER_ID, ORDER_LINE_ID ORDER_LINE_ID, ORGANIZATION_ID ORGANIZATION_ID, PARENT_MOVEMENT_ID PARENT_MOVEMENT_ID, PICKING_LINE_DETAIL_ID PICKING_LINE_DETAIL_ID, PICKING_LINE_ID PICKING_LINE_ID, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, REQUISITION_HEADER_ID REQUISITION_HEADER_ID, REQUISITION_LINE_ID REQUISITION_LINE_ID, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, ENTITY_ORG_ID ENTITY_ORG_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, RUN_ID RUN_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID from "EC"."ECE_MVSTO_DETAILS"

View Text - HTML Formatted

SELECT EDI_SENT_FLAG EDI_SENT_FLAG
, PERIOD_NAME PERIOD_NAME
, EDI_TRANSACTION_REFERENCE EDI_TRANSACTION_REFERENCE
, EDI_TRANSACTION_DATE EDI_TRANSACTION_DATE
, TRANSACTION_DATE TRANSACTION_DATE
, SET_OF_BOOKS_PERIOD SET_OF_BOOKS_PERIOD
, CREATION_METHOD CREATION_METHOD
, CREATION_METHOD_EXT1 CREATION_METHOD_EXT1
, CREATION_METHOD_EXT2 CREATION_METHOD_EXT2
, CREATION_METHOD_EXT3 CREATION_METHOD_EXT3
, CREATION_METHOD_EXT4 CREATION_METHOD_EXT4
, CREATION_METHOD_EXT5 CREATION_METHOD_EXT5
, FLOW_INDICATOR_CODE FLOW_INDICATOR_CODE
, FLOW_INDICATOR_CODE_EXT1 FLOW_INDICATOR_CODE_EXT1
, FLOW_INDICATOR_CODE_EXT2 FLOW_INDICATOR_CODE_EXT2
, FLOW_INDICATOR_CODE_EXT3 FLOW_INDICATOR_CODE_EXT3
, FLOW_INDICATOR_CODE_EXT4 FLOW_INDICATOR_CODE_EXT4
, FLOW_INDICATOR_CODE_EXT5 FLOW_INDICATOR_CODE_EXT5
, STAT_METHOD STAT_METHOD
, STAT_METHOD_EXT1 STAT_METHOD_EXT1
, STAT_METHOD_EXT2 STAT_METHOD_EXT2
, STAT_METHOD_EXT3 STAT_METHOD_EXT3
, STAT_METHOD_EXT4 STAT_METHOD_EXT4
, STAT_METHOD_EXT5 STAT_METHOD_EXT5
, STAT_TYPE STAT_TYPE
, STAT_TYPE_EXT1 STAT_TYPE_EXT1
, STAT_TYPE_EXT2 STAT_TYPE_EXT2
, STAT_TYPE_EXT3 STAT_TYPE_EXT3
, STAT_TYPE_EXT4 STAT_TYPE_EXT4
, STAT_TYPE_EXT5 STAT_TYPE_EXT5
, TRANSPORT_MODE TRANSPORT_MODE
, TRANSPORT_MODE_EXT1 TRANSPORT_MODE_EXT1
, TRANSPORT_MODE_EXT2 TRANSPORT_MODE_EXT2
, TRANSPORT_MODE_EXT3 TRANSPORT_MODE_EXT3
, TRANSPORT_MODE_EXT4 TRANSPORT_MODE_EXT4
, TRANSPORT_MODE_EXT5 TRANSPORT_MODE_EXT5
, TRANSACTION_NATURE TRANSACTION_NATURE
, TRANSACTION_NATURE_EXT1 TRANSACTION_NATURE_EXT1
, TRANSACTION_NATURE_EXT2 TRANSACTION_NATURE_EXT2
, TRANSACTION_NATURE_EXT3 TRANSACTION_NATURE_EXT3
, TRANSACTION_NATURE_EXT4 TRANSACTION_NATURE_EXT4
, TRANSACTION_NATURE_EXT5 TRANSACTION_NATURE_EXT5
, MOVEMENT_NATURE_CODE MOVEMENT_NATURE_CODE
, MOVEMENT_NATURE_CODE_EXT1 MOVEMENT_NATURE_CODE_EXT1
, MOVEMENT_NATURE_CODE_EXT2 MOVEMENT_NATURE_CODE_EXT2
, MOVEMENT_NATURE_CODE_EXT3 MOVEMENT_NATURE_CODE_EXT3
, MOVEMENT_NATURE_CODE_EXT4 MOVEMENT_NATURE_CODE_EXT4
, MOVEMENT_NATURE_CODE_EXT5 MOVEMENT_NATURE_CODE_EXT5
, ORIGIN_TERRITORY_EU_CODE ORIGIN_TERRITORY_EU_CODE
, ORIGIN_TERRITORY_CODE ORIGIN_TERRITORY_CODE
, ORIGIN_TERRITORY_CODE_EXT1 ORIGIN_TERRITORY_CODE_EXT1
, ORIGIN_TERRITORY_CODE_EXT2 ORIGIN_TERRITORY_CODE_EXT2
, ORIGIN_TERRITORY_CODE_EXT3 ORIGIN_TERRITORY_CODE_EXT3
, ORIGIN_TERRITORY_CODE_EXT4 ORIGIN_TERRITORY_CODE_EXT4
, ORIGIN_TERRITORY_CODE_EXT5 ORIGIN_TERRITORY_CODE_EXT5
, DESTINATION_TERRITORY_EU_CODE DESTINATION_TERRITORY_EU_CODE
, DESTINATION_TERRITORY_CODE DESTINATION_TERRITORY_CODE
, DEST_TERRITORY_CODE_EXT1 DEST_TERRITORY_CODE_EXT1
, DEST_TERRITORY_CODE_EXT2 DEST_TERRITORY_CODE_EXT2
, DEST_TERRITORY_CODE_EXT3 DEST_TERRITORY_CODE_EXT3
, DEST_TERRITORY_CODE_EXT4 DEST_TERRITORY_CODE_EXT4
, DEST_TERRITORY_CODE_EXT5 DEST_TERRITORY_CODE_EXT5
, DISPATCH_TERRITORY_EU_CODE DISPATCH_TERRITORY_EU_CODE
, DISPATCH_TERRITORY_CODE DISPATCH_TERRITORY_CODE
, DISPATCH_TERRITORY_CODE_EXT1 DISPATCH_TERRITORY_CODE_EXT1
, DISPATCH_TERRITORY_CODE_EXT2 DISPATCH_TERRITORY_CODE_EXT2
, DISPATCH_TERRITORY_CODE_EXT3 DISPATCH_TERRITORY_CODE_EXT3
, DISPATCH_TERRITORY_CODE_EXT4 DISPATCH_TERRITORY_CODE_EXT4
, DISPATCH_TERRITORY_CODE_EXT5 DISPATCH_TERRITORY_CODE_EXT5
, TRIANGULATION_COUNTRY_EU_CODE TRIANGULATION_COUNTRY_EU_CODE
, TRIANGULATION_COUNTRY_CODE TRIANGULATION_COUNTRY_CODE
, TRIANG_COUNTRY_CODE_EXT1 TRIANG_COUNTRY_CODE_EXT1
, TRIANG_COUNTRY_CODE_EXT2 TRIANG_COUNTRY_CODE_EXT2
, TRIANG_COUNTRY_CODE_EXT3 TRIANG_COUNTRY_CODE_EXT3
, TRIANG_COUNTRY_CODE_EXT4 TRIANG_COUNTRY_CODE_EXT4
, TRIANG_COUNTRY_CODE_EXT5 TRIANG_COUNTRY_CODE_EXT5
, PORT PORT
, PORT_EXT1 PORT_EXT1
, PORT_EXT2 PORT_EXT2
, PORT_EXT3 PORT_EXT3
, PORT_EXT4 PORT_EXT4
, PORT_EXT5 PORT_EXT5
, AREA AREA
, AREA_EXT1 AREA_EXT1
, AREA_EXT2 AREA_EXT2
, AREA_EXT3 AREA_EXT3
, AREA_EXT4 AREA_EXT4
, AREA_EXT5 AREA_EXT5
, MOVEMENT_ID MOVEMENT_ID
, MOVEMENT_TYPE MOVEMENT_TYPE
, MOVEMENT_TYPE_EXT1 MOVEMENT_TYPE_EXT1
, MOVEMENT_TYPE_EXT2 MOVEMENT_TYPE_EXT2
, MOVEMENT_TYPE_EXT3 MOVEMENT_TYPE_EXT3
, MOVEMENT_TYPE_EXT4 MOVEMENT_TYPE_EXT4
, MOVEMENT_TYPE_EXT5 MOVEMENT_TYPE_EXT5
, ZONE_CODE ZONE_CODE
, ECONOMIC_ZONE_EXT1 ECONOMIC_ZONE_EXT1
, ECONOMIC_ZONE_EXT2 ECONOMIC_ZONE_EXT2
, ECONOMIC_ZONE_EXT3 ECONOMIC_ZONE_EXT3
, ECONOMIC_ZONE_EXT4 ECONOMIC_ZONE_EXT4
, ECONOMIC_ZONE_EXT5 ECONOMIC_ZONE_EXT5
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CODE_EXT1 CURRENCY_CODE_EXT1
, CURRENCY_CODE_EXT2 CURRENCY_CODE_EXT2
, CURRENCY_CODE_EXT3 CURRENCY_CODE_EXT3
, CURRENCY_CODE_EXT4 CURRENCY_CODE_EXT4
, CURRENCY_CODE_EXT5 CURRENCY_CODE_EXT5
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_TYPE_EXT1 CURRENCY_CONVERSION_TYPE_EXT1
, CURRENCY_CONVERSION_TYPE_EXT2 CURRENCY_CONVERSION_TYPE_EXT2
, CURRENCY_CONVERSION_TYPE_EXT3 CURRENCY_CONVERSION_TYPE_EXT3
, CURRENCY_CONVERSION_TYPE_EXT4 CURRENCY_CONVERSION_TYPE_EXT4
, CURRENCY_CONVERSION_TYPE_EXT5 CURRENCY_CONVERSION_TYPE_EXT5
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, MOVEMENT_AMOUNT MOVEMENT_AMOUNT
, ITEM_COST ITEM_COST
, DOCUMENT_UNIT_PRICE DOCUMENT_UNIT_PRICE
, DOCUMENT_LINE_EXT_VALUE DOCUMENT_LINE_EXT_VALUE
, OUTSIDE_CODE OUTSIDE_CODE
, OUTSIDE_CODE_EXT1 OUTSIDE_CODE_EXT1
, OUTSIDE_CODE_EXT2 OUTSIDE_CODE_EXT2
, OUTSIDE_CODE_EXT3 OUTSIDE_CODE_EXT3
, OUTSIDE_CODE_EXT4 OUTSIDE_CODE_EXT4
, OUTSIDE_CODE_EXT5 OUTSIDE_CODE_EXT5
, OUTSIDE_EXT_VALUE OUTSIDE_EXT_VALUE
, OUTSIDE_UNIT_PRICE OUTSIDE_UNIT_PRICE
, STAT_ADJ_AMOUNT STAT_ADJ_AMOUNT
, STAT_ADJ_PERCENT STAT_ADJ_PERCENT
, STAT_EXT_VALUE STAT_EXT_VALUE
, DELIVERY_TERMS DELIVERY_TERMS
, DELIVERY_TERMS_EXT1 DELIVERY_TERMS_EXT1
, DELIVERY_TERMS_EXT2 DELIVERY_TERMS_EXT2
, DELIVERY_TERMS_EXT3 DELIVERY_TERMS_EXT3
, DELIVERY_TERMS_EXT4 DELIVERY_TERMS_EXT4
, DELIVERY_TERMS_EXT5 DELIVERY_TERMS_EXT5
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE
, TRANSACTION_UOM_CODE_EXT1 TRANSACTION_UOM_CODE_EXT1
, TRANSACTION_UOM_CODE_EXT2 TRANSACTION_UOM_CODE_EXT2
, TRANSACTION_UOM_CODE_EXT3 TRANSACTION_UOM_CODE_EXT3
, TRANSACTION_UOM_CODE_EXT4 TRANSACTION_UOM_CODE_EXT4
, TRANSACTION_UOM_CODE_EXT5 TRANSACTION_UOM_CODE_EXT5
, WEIGHT_METHOD WEIGHT_METHOD
, WEIGHT_METHOD_EXT1 WEIGHT_METHOD_EXT1
, WEIGHT_METHOD_EXT2 WEIGHT_METHOD_EXT2
, WEIGHT_METHOD_EXT3 WEIGHT_METHOD_EXT3
, WEIGHT_METHOD_EXT4 WEIGHT_METHOD_EXT4
, WEIGHT_METHOD_EXT5 WEIGHT_METHOD_EXT5
, UNIT_WEIGHT UNIT_WEIGHT
, TOTAL_WEIGHT TOTAL_WEIGHT
, TOTAL_WEIGHT_UOM_CODE TOTAL_WEIGHT_UOM_CODE
, TOTAL_WEIGHT_UOM_CODE_EXT1 TOTAL_WEIGHT_UOM_CODE_EXT1
, TOTAL_WEIGHT_UOM_CODE_EXT2 TOTAL_WEIGHT_UOM_CODE_EXT2
, TOTAL_WEIGHT_UOM_CODE_EXT3 TOTAL_WEIGHT_UOM_CODE_EXT3
, TOTAL_WEIGHT_UOM_CODE_EXT4 TOTAL_WEIGHT_UOM_CODE_EXT4
, TOTAL_WEIGHT_UOM_CODE_EXT5 TOTAL_WEIGHT_UOM_CODE_EXT5
, ALTERNATE_QUANTITY ALTERNATE_QUANTITY
, ALTERNATE_UOM_CODE ALTERNATE_UOM_CODE
, ALTERNATE_UOM_CODE_EXT1 ALTERNATE_UOM_CODE_EXT1
, ALTERNATE_UOM_CODE_EXT2 ALTERNATE_UOM_CODE_EXT2
, ALTERNATE_UOM_CODE_EXT3 ALTERNATE_UOM_CODE_EXT3
, ALTERNATE_UOM_CODE_EXT4 ALTERNATE_UOM_CODE_EXT4
, ALTERNATE_UOM_CODE_EXT5 ALTERNATE_UOM_CODE_EXT5
, COMMODITY_CODE COMMODITY_CODE
, COMMODITY_DESCRIPTION COMMODITY_DESCRIPTION
, COMMENTS COMMENTS
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, DOCUMENT_SOURCE_TYPE DOCUMENT_SOURCE_TYPE
, DOCUMENT_REFERENCE DOCUMENT_REFERENCE
, DOCUMENT_LINE_REFERENCE DOCUMENT_LINE_REFERENCE
, TRANSACTING_FROM_ORG TRANSACTING_FROM_ORG
, TRANSACTING_TO_ORG TRANSACTING_TO_ORG
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, AFFILIATION_REFERENCE_CODE AFFILIATION_REFERENCE_CODE
, AFFILIATION_REF_CODE_EXT1 AFFILIATION_REF_CODE_EXT1
, AFFILIATION_REF_CODE_EXT2 AFFILIATION_REF_CODE_EXT2
, AFFILIATION_REF_CODE_EXT3 AFFILIATION_REF_CODE_EXT3
, AFFILIATION_REF_CODE_EXT4 AFFILIATION_REF_CODE_EXT4
, AFFILIATION_REF_CODE_EXT5 AFFILIATION_REF_CODE_EXT5
, CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE
, CONTAINER_TYPE_CODE_EXT1 CONTAINER_TYPE_CODE_EXT1
, CONTAINER_TYPE_CODE_EXT2 CONTAINER_TYPE_CODE_EXT2
, CONTAINER_TYPE_CODE_EXT3 CONTAINER_TYPE_CODE_EXT3
, CONTAINER_TYPE_CODE_EXT4 CONTAINER_TYPE_CODE_EXT4
, CONTAINER_TYPE_CODE_EXT5 CONTAINER_TYPE_CODE_EXT5
, CSA_CODE CSA_CODE
, CSA_CODE_EXT1 CSA_CODE_EXT1
, CSA_CODE_EXT2 CSA_CODE_EXT2
, CSA_CODE_EXT3 CSA_CODE_EXT3
, CSA_CODE_EXT4 CSA_CODE_EXT4
, CSA_CODE_EXT5 CSA_CODE_EXT5
, OIL_REFERENCE_CODE OIL_REFERENCE_CODE
, OIL_REFERENCE_CODE_EXT1 OIL_REFERENCE_CODE_EXT1
, OIL_REFERENCE_CODE_EXT2 OIL_REFERENCE_CODE_EXT2
, OIL_REFERENCE_CODE_EXT3 OIL_REFERENCE_CODE_EXT3
, OIL_REFERENCE_CODE_EXT4 OIL_REFERENCE_CODE_EXT4
, OIL_REFERENCE_CODE_EXT5 OIL_REFERENCE_CODE_EXT5
, PICK_SLIP_REFERENCE PICK_SLIP_REFERENCE
, PREFERENCE_CODE PREFERENCE_CODE
, PREFERENCE_CODE_EXT1 PREFERENCE_CODE_EXT1
, PREFERENCE_CODE_EXT2 PREFERENCE_CODE_EXT2
, PREFERENCE_CODE_EXT3 PREFERENCE_CODE_EXT3
, PREFERENCE_CODE_EXT4 PREFERENCE_CODE_EXT4
, PREFERENCE_CODE_EXT5 PREFERENCE_CODE_EXT5
, RECEIPT_REFERENCE RECEIPT_REFERENCE
, RECEIPT_REFERENCE_EXT1 RECEIPT_REFERENCE_EXT1
, RECEIPT_REFERENCE_EXT2 RECEIPT_REFERENCE_EXT2
, RECEIPT_REFERENCE_EXT3 RECEIPT_REFERENCE_EXT3
, RECEIPT_REFERENCE_EXT4 RECEIPT_REFERENCE_EXT4
, RECEIPT_REFERENCE_EXT5 RECEIPT_REFERENCE_EXT5
, SHIPMENT_LINE_REFERENCE SHIPMENT_LINE_REFERENCE
, SHIPMENT_LINE_REFERENCE_EXT1 SHIPMENT_LINE_REFERENCE_EXT1
, SHIPMENT_LINE_REFERENCE_EXT2 SHIPMENT_LINE_REFERENCE_EXT2
, SHIPMENT_LINE_REFERENCE_EXT3 SHIPMENT_LINE_REFERENCE_EXT3
, SHIPMENT_LINE_REFERENCE_EXT4 SHIPMENT_LINE_REFERENCE_EXT4
, SHIPMENT_LINE_REFERENCE_EXT5 SHIPMENT_LINE_REFERENCE_EXT5
, SHIPMENT_REFERENCE SHIPMENT_REFERENCE
, SHIPMENT_REFERENCE_EXT1 SHIPMENT_REFERENCE_EXT1
, SHIPMENT_REFERENCE_EXT2 SHIPMENT_REFERENCE_EXT2
, SHIPMENT_REFERENCE_EXT3 SHIPMENT_REFERENCE_EXT3
, SHIPMENT_REFERENCE_EXT4 SHIPMENT_REFERENCE_EXT4
, SHIPMENT_REFERENCE_EXT5 SHIPMENT_REFERENCE_EXT5
, TARIC_CODE TARIC_CODE
, TARIC_CODE_EXT1 TARIC_CODE_EXT1
, TARIC_CODE_EXT2 TARIC_CODE_EXT2
, TARIC_CODE_EXT3 TARIC_CODE_EXT3
, TARIC_CODE_EXT4 TARIC_CODE_EXT4
, TARIC_CODE_EXT5 TARIC_CODE_EXT5
, INVOICE_BATCH_REFERENCE INVOICE_BATCH_REFERENCE
, INVOICE_DATE_REFERENCE INVOICE_DATE_REFERENCE
, INVOICE_LINE_EXT_VALUE INVOICE_LINE_EXT_VALUE
, INVOICE_LINE_REFERENCE INVOICE_LINE_REFERENCE
, INVOICE_QUANTITY INVOICE_QUANTITY
, INVOICE_REFERENCE INVOICE_REFERENCE
, INVOICE_UNIT_PRICE INVOICE_UNIT_PRICE
, INVOICE_BATCH_ID INVOICE_BATCH_ID
, INVOICE_ID INVOICE_ID
, CUSTOMER_LOCATION CUSTOMER_LOCATION
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, BILL_TO_NAME BILL_TO_NAME
, BILL_TO_NUMBER BILL_TO_NUMBER
, BILL_TO_SITE BILL_TO_SITE
, SHIP_TO_NAME SHIP_TO_NAME
, SHIP_TO_NUMBER SHIP_TO_NUMBER
, SHIP_TO_SITE SHIP_TO_SITE
, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, VENDOR_NAME VENDOR_NAME
, VENDOR_NUMBER VENDOR_NUMBER
, VENDOR_SITE VENDOR_SITE
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, CATEGORY_ID CATEGORY_ID
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MTL_TRANSACTION_ID MTL_TRANSACTION_ID
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, ORDER_HEADER_ID ORDER_HEADER_ID
, ORDER_LINE_ID ORDER_LINE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PARENT_MOVEMENT_ID PARENT_MOVEMENT_ID
, PICKING_LINE_DETAIL_ID PICKING_LINE_DETAIL_ID
, PICKING_LINE_ID PICKING_LINE_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, REQUISITION_HEADER_ID REQUISITION_HEADER_ID
, REQUISITION_LINE_ID REQUISITION_LINE_ID
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, ENTITY_ORG_ID ENTITY_ORG_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, RUN_ID RUN_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "EC"."ECE_MVSTO_DETAILS"