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.

[Home] [Help]

VIEW: EC.ECE_AR_TRX_LINES#

Source

View Text - Preformatted


select COMMUNICATION_METHOD COMMUNICATION_METHOD, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_ID TRANSACTION_ID, LINE_NUMBER LINE_NUMBER, CREDITED_LINE_NUMBER CREDITED_LINE_NUMBER, LINE_ITEM_NUMBER LINE_ITEM_NUMBER, CUSTOMER_ITEM_NUMBER CUSTOMER_ITEM_NUMBER, CUSTOMER_ITEM_DESC CUSTOMER_ITEM_DESC, ORDERED_QUANTITY ORDERED_QUANTITY, QUANTITY QUANTITY, UOM_CODE UOM_CODE, UOM_CODE_EXT1 UOM_CODE_EXT1, CREDIT_MEMO_REASON CREDIT_MEMO_REASON, UNIT_STANDARD_PRICE UNIT_STANDARD_PRICE, UNIT_SELLING_PRICE UNIT_SELLING_PRICE, LINE_AMOUNT LINE_AMOUNT, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, SALES_ORDER_NUMBER SALES_ORDER_NUMBER, SALES_CHANNEL SALES_CHANNEL, ITEM_ID ITEM_ID, SALES_ORDER_REVISION_NUMBER SALES_ORDER_REVISION_NUMBER, SALES_ORDER_LINE_NUMBER SALES_ORDER_LINE_NUMBER, SALES_ORDER_DATE SALES_ORDER_DATE, SHIP_ORDER_STATUS_INT SHIP_ORDER_STATUS_INT, SHIP_ORDER_STATUS_EXT SHIP_ORDER_STATUS_EXT, TRANSACTION_REFERENCE_KEY TRANSACTION_REFERENCE_KEY, ITEM_DESCRIPTION ITEM_DESCRIPTION, LINE_ITEM_ATTRIB_CATEGORY LINE_ITEM_ATTRIB_CATEGORY, LINE_ITEM_ATTRIBUTE1 LINE_ITEM_ATTRIBUTE1, LINE_ITEM_ATTRIBUTE2 LINE_ITEM_ATTRIBUTE2, LINE_ITEM_ATTRIBUTE3 LINE_ITEM_ATTRIBUTE3, LINE_ITEM_ATTRIBUTE4 LINE_ITEM_ATTRIBUTE4, LINE_ITEM_ATTRIBUTE5 LINE_ITEM_ATTRIBUTE5, LINE_ITEM_ATTRIBUTE6 LINE_ITEM_ATTRIBUTE6, LINE_ITEM_ATTRIBUTE7 LINE_ITEM_ATTRIBUTE7, LINE_ITEM_ATTRIBUTE8 LINE_ITEM_ATTRIBUTE8, LINE_ITEM_ATTRIBUTE9 LINE_ITEM_ATTRIBUTE9, LINE_ITEM_ATTRIBUTE10 LINE_ITEM_ATTRIBUTE10, LINE_ITEM_ATTRIBUTE11 LINE_ITEM_ATTRIBUTE11, LINE_ITEM_ATTRIBUTE12 LINE_ITEM_ATTRIBUTE12, LINE_ITEM_ATTRIBUTE13 LINE_ITEM_ATTRIBUTE13, LINE_ITEM_ATTRIBUTE14 LINE_ITEM_ATTRIBUTE14, LINE_ITEM_ATTRIBUTE15 LINE_ITEM_ATTRIBUTE15, INTERFACE_LINE_CATEGORY INTERFACE_LINE_CATEGORY, INTERFACE_LINE_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2, INTERFACE_LINE_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE3, INTERFACE_LINE_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE4, INTERFACE_LINE_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE5, INTERFACE_LINE_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE6, INTERFACE_LINE_ATTRIBUTE7 INTERFACE_LINE_ATTRIBUTE7, INTERFACE_LINE_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE8, INTERFACE_LINE_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE9, INTERFACE_LINE_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE10, INTERFACE_LINE_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE11, INTERFACE_LINE_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE12, INTERFACE_LINE_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE13, INTERFACE_LINE_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE14, INTERFACE_LINE_ATTRIBUTE15 INTERFACE_LINE_ATTRIBUTE15, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15, UOM_CODE_EXT2 UOM_CODE_EXT2, UOM_CODE_EXT3 UOM_CODE_EXT3, UOM_CODE_EXT4 UOM_CODE_EXT4, UOM_CODE_EXT5 UOM_CODE_EXT5, RUN_ID RUN_ID, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, HEADER_TP_ATTRIBUTE1 HEADER_TP_ATTRIBUTE1, HEADER_TP_ATTRIBUTE2 HEADER_TP_ATTRIBUTE2, HEADER_TP_ATTRIBUTE3 HEADER_TP_ATTRIBUTE3, HEADER_TP_ATTRIBUTE4 HEADER_TP_ATTRIBUTE4, HEADER_TP_ATTRIBUTE5 HEADER_TP_ATTRIBUTE5, HEADER_TP_ATTRIBUTE6 HEADER_TP_ATTRIBUTE6, HEADER_TP_ATTRIBUTE7 HEADER_TP_ATTRIBUTE7, HEADER_TP_ATTRIBUTE8 HEADER_TP_ATTRIBUTE8, HEADER_TP_ATTRIBUTE9 HEADER_TP_ATTRIBUTE9, HEADER_TP_ATTRIBUTE10 HEADER_TP_ATTRIBUTE10, HEADER_TP_ATTRIBUTE11 HEADER_TP_ATTRIBUTE11, HEADER_TP_ATTRIBUTE12 HEADER_TP_ATTRIBUTE12, HEADER_TP_ATTRIBUTE13 HEADER_TP_ATTRIBUTE13, HEADER_TP_ATTRIBUTE14 HEADER_TP_ATTRIBUTE14, HEADER_TP_ATTRIBUTE15 HEADER_TP_ATTRIBUTE15, LINE_TP_ATTRIBUTE1 LINE_TP_ATTRIBUTE1, LINE_TP_ATTRIBUTE2 LINE_TP_ATTRIBUTE2, LINE_TP_ATTRIBUTE3 LINE_TP_ATTRIBUTE3, LINE_TP_ATTRIBUTE4 LINE_TP_ATTRIBUTE4, LINE_TP_ATTRIBUTE5 LINE_TP_ATTRIBUTE5, LINE_TP_ATTRIBUTE6 LINE_TP_ATTRIBUTE6, LINE_TP_ATTRIBUTE7 LINE_TP_ATTRIBUTE7, LINE_TP_ATTRIBUTE8 LINE_TP_ATTRIBUTE8, LINE_TP_ATTRIBUTE9 LINE_TP_ATTRIBUTE9, LINE_TP_ATTRIBUTE10 LINE_TP_ATTRIBUTE10, LINE_TP_ATTRIBUTE11 LINE_TP_ATTRIBUTE11, LINE_TP_ATTRIBUTE12 LINE_TP_ATTRIBUTE12, LINE_TP_ATTRIBUTE13 LINE_TP_ATTRIBUTE13, LINE_TP_ATTRIBUTE14 LINE_TP_ATTRIBUTE14, LINE_TP_ATTRIBUTE15 LINE_TP_ATTRIBUTE15, INDUSTRY_ATTRIBUTE1 INDUSTRY_ATTRIBUTE1, INDUSTRY_ATTRIBUTE2 INDUSTRY_ATTRIBUTE2, INDUSTRY_ATTRIBUTE3 INDUSTRY_ATTRIBUTE3, INDUSTRY_ATTRIBUTE4 INDUSTRY_ATTRIBUTE4, INDUSTRY_ATTRIBUTE5 INDUSTRY_ATTRIBUTE5, INDUSTRY_ATTRIBUTE6 INDUSTRY_ATTRIBUTE6, INDUSTRY_ATTRIBUTE7 INDUSTRY_ATTRIBUTE7, INDUSTRY_ATTRIBUTE8 INDUSTRY_ATTRIBUTE8, INDUSTRY_ATTRIBUTE9 INDUSTRY_ATTRIBUTE9, INDUSTRY_ATTRIBUTE10 INDUSTRY_ATTRIBUTE10, INDUSTRY_ATTRIBUTE11 INDUSTRY_ATTRIBUTE11, INDUSTRY_ATTRIBUTE12 INDUSTRY_ATTRIBUTE12, INDUSTRY_ATTRIBUTE13 INDUSTRY_ATTRIBUTE13, INDUSTRY_ATTRIBUTE14 INDUSTRY_ATTRIBUTE14, INDUSTRY_ATTRIBUTE15 INDUSTRY_ATTRIBUTE15, INDUSTRY_CONTEXT INDUSTRY_CONTEXT, SHIP_ORDER_STATUS_EXT1 SHIP_ORDER_STATUS_EXT1, SHIP_ORDER_STATUS_EXT2 SHIP_ORDER_STATUS_EXT2, SHIP_ORDER_STATUS_EXT3 SHIP_ORDER_STATUS_EXT3, SHIP_ORDER_STATUS_EXT4 SHIP_ORDER_STATUS_EXT4, SHIP_ORDER_STATUS_EXT5 SHIP_ORDER_STATUS_EXT5, INDUSTRY_UOM_CODE_EXT2 INDUSTRY_UOM_CODE_EXT2, INDUSTRY_UOM_CODE_EXT3 INDUSTRY_UOM_CODE_EXT3, INDUSTRY_UOM_CODE_EXT4 INDUSTRY_UOM_CODE_EXT4, INDUSTRY_UOM_CODE_EXT5 INDUSTRY_UOM_CODE_EXT5, ITEM_IDENTIFIER_TYPE ITEM_IDENTIFIER_TYPE, ITEM_IDENTIFIER_TYPE_EXT1 ITEM_IDENTIFIER_TYPE_EXT1, ITEM_IDENTIFIER_TYPE_EXT2 ITEM_IDENTIFIER_TYPE_EXT2, ITEM_IDENTIFIER_TYPE_EXT3 ITEM_IDENTIFIER_TYPE_EXT3, ITEM_IDENTIFIER_TYPE_EXT4 ITEM_IDENTIFIER_TYPE_EXT4, ITEM_IDENTIFIER_TYPE_EXT5 ITEM_IDENTIFIER_TYPE_EXT5, ORDERED_ITEM ORDERED_ITEM, PURCHASE_ORDER_LINE_NUMBER PURCHASE_ORDER_LINE_NUMBER, PURCHASE_ORDER_NUMBER PURCHASE_ORDER_NUMBER, PURCHASE_ORDER_RELEASE_NUMBER PURCHASE_ORDER_RELEASE_NUMBER, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER, SHIPPED_QUANTITY SHIPPED_QUANTITY, INVOICE_LINE_TYPE INVOICE_LINE_TYPE, INVOICE_LINE_REFERENCE INVOICE_LINE_REFERENCE, GROSS_WEIGHT GROSS_WEIGHT, NET_WEIGHT NET_WEIGHT, WEIGHT_UOM_CODE_INT WEIGHT_UOM_CODE_INT, WEIGHT_UOM_CODE_EXT1 WEIGHT_UOM_CODE_EXT1, WEIGHT_UOM_CODE_EXT2 WEIGHT_UOM_CODE_EXT2, WEIGHT_UOM_CODE_EXT3 WEIGHT_UOM_CODE_EXT3, WEIGHT_UOM_CODE_EXT4 WEIGHT_UOM_CODE_EXT4, WEIGHT_UOM_CODE_EXT5 WEIGHT_UOM_CODE_EXT5, VOLUME VOLUME, VOLUME_UOM_CODE_INT VOLUME_UOM_CODE_INT, VOLUME_UOM_CODE_EXT1 VOLUME_UOM_CODE_EXT1, VOLUME_UOM_CODE_EXT2 VOLUME_UOM_CODE_EXT2, VOLUME_UOM_CODE_EXT3 VOLUME_UOM_CODE_EXT3, VOLUME_UOM_CODE_EXT4 VOLUME_UOM_CODE_EXT4, VOLUME_UOM_CODE_EXT5 VOLUME_UOM_CODE_EXT5, PACKING_SLIP_NUMBER PACKING_SLIP_NUMBER, DELIVERY_ID DELIVERY_ID, BOOKING_NUMBER BOOKING_NUMBER, BILL_OF_LADING_NUMBER BILL_OF_LADING_NUMBER, SHIPMENT_NUMBER SHIPMENT_NUMBER, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FREIGHT_TERMS_CODE_INT FREIGHT_TERMS_CODE_INT, FREIGHT_TERMS_CODE_EXT1 FREIGHT_TERMS_CODE_EXT1, FREIGHT_TERMS_CODE_EXT2 FREIGHT_TERMS_CODE_EXT2, FREIGHT_TERMS_CODE_EXT3 FREIGHT_TERMS_CODE_EXT3, FREIGHT_TERMS_CODE_EXT4 FREIGHT_TERMS_CODE_EXT4, FREIGHT_TERMS_CODE_EXT5 FREIGHT_TERMS_CODE_EXT5, FOB_LOCATION_CODE FOB_LOCATION_CODE, FOB_LOCATION_CODE_EXT1 FOB_LOCATION_CODE_EXT1, FOB_LOCATION_CODE_EXT2 FOB_LOCATION_CODE_EXT2, FOB_LOCATION_CODE_EXT3 FOB_LOCATION_CODE_EXT3, FOB_LOCATION_CODE_EXT4 FOB_LOCATION_CODE_EXT4, FOB_LOCATION_CODE_EXT5 FOB_LOCATION_CODE_EXT5, SHIP_FROM_EDI_LOC_CODE SHIP_FROM_EDI_LOC_CODE, SHIP_FROM_EDI_LOC_CODE_INT SHIP_FROM_EDI_LOC_CODE_INT, SHIP_FROM_EDI_LOC_CODE_EXT1 SHIP_FROM_EDI_LOC_CODE_EXT1, SHIP_FROM_EDI_LOC_CODE_EXT2 SHIP_FROM_EDI_LOC_CODE_EXT2, SHIP_FROM_EDI_LOC_CODE_EXT3 SHIP_FROM_EDI_LOC_CODE_EXT3, SHIP_FROM_EDI_LOC_CODE_EXT4 SHIP_FROM_EDI_LOC_CODE_EXT4, SHIP_FROM_EDI_LOC_CODE_EXT5 SHIP_FROM_EDI_LOC_CODE_EXT5, WAREHOUSE_CODE WAREHOUSE_CODE, WAREHOUSE_NAME WAREHOUSE_NAME, WAREHOUSE_ADDRESS1 WAREHOUSE_ADDRESS1, WAREHOUSE_ADDRESS2 WAREHOUSE_ADDRESS2, WAREHOUSE_ADDRESS3 WAREHOUSE_ADDRESS3, WAREHOUSE_CITY WAREHOUSE_CITY, WAREHOUSE_POSTAL_CODE WAREHOUSE_POSTAL_CODE, WAREHOUSE_COUNTRY_INT WAREHOUSE_COUNTRY_INT, WAREHOUSE_COUNTRY_EXT1 WAREHOUSE_COUNTRY_EXT1, WAREHOUSE_COUNTRY_EXT2 WAREHOUSE_COUNTRY_EXT2, WAREHOUSE_COUNTRY_EXT3 WAREHOUSE_COUNTRY_EXT3, WAREHOUSE_COUNTRY_EXT4 WAREHOUSE_COUNTRY_EXT4, WAREHOUSE_COUNTRY_EXT5 WAREHOUSE_COUNTRY_EXT5, WAREHOUSE_REGION1_INT WAREHOUSE_REGION1_INT, WAREHOUSE_REGION1_EXT1 WAREHOUSE_REGION1_EXT1, WAREHOUSE_REGION1_EXT2 WAREHOUSE_REGION1_EXT2, WAREHOUSE_REGION1_EXT3 WAREHOUSE_REGION1_EXT3, WAREHOUSE_REGION1_EXT4 WAREHOUSE_REGION1_EXT4, WAREHOUSE_REGION1_EXT5 WAREHOUSE_REGION1_EXT5, WAREHOUSE_REGION2_INT WAREHOUSE_REGION2_INT, WAREHOUSE_REGION2_EXT1 WAREHOUSE_REGION2_EXT1, WAREHOUSE_REGION2_EXT2 WAREHOUSE_REGION2_EXT2, WAREHOUSE_REGION2_EXT3 WAREHOUSE_REGION2_EXT3, WAREHOUSE_REGION2_EXT4 WAREHOUSE_REGION2_EXT4, WAREHOUSE_REGION2_EXT5 WAREHOUSE_REGION2_EXT5, WAREHOUSE_REGION3_INT WAREHOUSE_REGION3_INT, WAREHOUSE_REGION3_EXT1 WAREHOUSE_REGION3_EXT1, WAREHOUSE_REGION3_EXT2 WAREHOUSE_REGION3_EXT2, WAREHOUSE_REGION3_EXT3 WAREHOUSE_REGION3_EXT3, WAREHOUSE_REGION3_EXT4 WAREHOUSE_REGION3_EXT4, WAREHOUSE_REGION3_EXT5 WAREHOUSE_REGION3_EXT5, SHIPPED_QUANTITY2 SHIPPED_QUANTITY2, SHIPPING_QUANTITY SHIPPING_QUANTITY, SHIPPING_QUANTITY2 SHIPPING_QUANTITY2, SHIPPING_QUANTITY_UOM_INT SHIPPING_QUANTITY_UOM_INT, SHIPPING_QUANTITY_UOM_EXT1 SHIPPING_QUANTITY_UOM_EXT1, SHIPPING_QUANTITY_UOM_EXT2 SHIPPING_QUANTITY_UOM_EXT2, SHIPPING_QUANTITY_UOM_EXT3 SHIPPING_QUANTITY_UOM_EXT3, SHIPPING_QUANTITY_UOM_EXT4 SHIPPING_QUANTITY_UOM_EXT4, SHIPPING_QUANTITY_UOM_EXT5 SHIPPING_QUANTITY_UOM_EXT5, ORDERED_QUANTITY_UOM2_INT ORDERED_QUANTITY_UOM2_INT, ORDERED_QUANTITY_UOM2_EXT1 ORDERED_QUANTITY_UOM2_EXT1, ORDERED_QUANTITY_UOM2_EXT2 ORDERED_QUANTITY_UOM2_EXT2, ORDERED_QUANTITY_UOM2_EXT3 ORDERED_QUANTITY_UOM2_EXT3, ORDERED_QUANTITY_UOM2_EXT4 ORDERED_QUANTITY_UOM2_EXT4, ORDERED_QUANTITY_UOM2_EXT5 ORDERED_QUANTITY_UOM2_EXT5 from "EC"."ECE_AR_TRX_LINES"

View Text - HTML Formatted

SELECT COMMUNICATION_METHOD COMMUNICATION_METHOD
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_ID TRANSACTION_ID
, LINE_NUMBER LINE_NUMBER
, CREDITED_LINE_NUMBER CREDITED_LINE_NUMBER
, LINE_ITEM_NUMBER LINE_ITEM_NUMBER
, CUSTOMER_ITEM_NUMBER CUSTOMER_ITEM_NUMBER
, CUSTOMER_ITEM_DESC CUSTOMER_ITEM_DESC
, ORDERED_QUANTITY ORDERED_QUANTITY
, QUANTITY QUANTITY
, UOM_CODE UOM_CODE
, UOM_CODE_EXT1 UOM_CODE_EXT1
, CREDIT_MEMO_REASON CREDIT_MEMO_REASON
, UNIT_STANDARD_PRICE UNIT_STANDARD_PRICE
, UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, LINE_AMOUNT LINE_AMOUNT
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, SALES_ORDER_NUMBER SALES_ORDER_NUMBER
, SALES_CHANNEL SALES_CHANNEL
, ITEM_ID ITEM_ID
, SALES_ORDER_REVISION_NUMBER SALES_ORDER_REVISION_NUMBER
, SALES_ORDER_LINE_NUMBER SALES_ORDER_LINE_NUMBER
, SALES_ORDER_DATE SALES_ORDER_DATE
, SHIP_ORDER_STATUS_INT SHIP_ORDER_STATUS_INT
, SHIP_ORDER_STATUS_EXT SHIP_ORDER_STATUS_EXT
, TRANSACTION_REFERENCE_KEY TRANSACTION_REFERENCE_KEY
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, LINE_ITEM_ATTRIB_CATEGORY LINE_ITEM_ATTRIB_CATEGORY
, LINE_ITEM_ATTRIBUTE1 LINE_ITEM_ATTRIBUTE1
, LINE_ITEM_ATTRIBUTE2 LINE_ITEM_ATTRIBUTE2
, LINE_ITEM_ATTRIBUTE3 LINE_ITEM_ATTRIBUTE3
, LINE_ITEM_ATTRIBUTE4 LINE_ITEM_ATTRIBUTE4
, LINE_ITEM_ATTRIBUTE5 LINE_ITEM_ATTRIBUTE5
, LINE_ITEM_ATTRIBUTE6 LINE_ITEM_ATTRIBUTE6
, LINE_ITEM_ATTRIBUTE7 LINE_ITEM_ATTRIBUTE7
, LINE_ITEM_ATTRIBUTE8 LINE_ITEM_ATTRIBUTE8
, LINE_ITEM_ATTRIBUTE9 LINE_ITEM_ATTRIBUTE9
, LINE_ITEM_ATTRIBUTE10 LINE_ITEM_ATTRIBUTE10
, LINE_ITEM_ATTRIBUTE11 LINE_ITEM_ATTRIBUTE11
, LINE_ITEM_ATTRIBUTE12 LINE_ITEM_ATTRIBUTE12
, LINE_ITEM_ATTRIBUTE13 LINE_ITEM_ATTRIBUTE13
, LINE_ITEM_ATTRIBUTE14 LINE_ITEM_ATTRIBUTE14
, LINE_ITEM_ATTRIBUTE15 LINE_ITEM_ATTRIBUTE15
, INTERFACE_LINE_CATEGORY INTERFACE_LINE_CATEGORY
, INTERFACE_LINE_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE1
, INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2
, INTERFACE_LINE_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE3
, INTERFACE_LINE_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE4
, INTERFACE_LINE_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE5
, INTERFACE_LINE_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE6
, INTERFACE_LINE_ATTRIBUTE7 INTERFACE_LINE_ATTRIBUTE7
, INTERFACE_LINE_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE8
, INTERFACE_LINE_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE9
, INTERFACE_LINE_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE10
, INTERFACE_LINE_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE11
, INTERFACE_LINE_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE12
, INTERFACE_LINE_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE13
, INTERFACE_LINE_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE14
, INTERFACE_LINE_ATTRIBUTE15 INTERFACE_LINE_ATTRIBUTE15
, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15
, UOM_CODE_EXT2 UOM_CODE_EXT2
, UOM_CODE_EXT3 UOM_CODE_EXT3
, UOM_CODE_EXT4 UOM_CODE_EXT4
, UOM_CODE_EXT5 UOM_CODE_EXT5
, RUN_ID RUN_ID
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, HEADER_TP_ATTRIBUTE1 HEADER_TP_ATTRIBUTE1
, HEADER_TP_ATTRIBUTE2 HEADER_TP_ATTRIBUTE2
, HEADER_TP_ATTRIBUTE3 HEADER_TP_ATTRIBUTE3
, HEADER_TP_ATTRIBUTE4 HEADER_TP_ATTRIBUTE4
, HEADER_TP_ATTRIBUTE5 HEADER_TP_ATTRIBUTE5
, HEADER_TP_ATTRIBUTE6 HEADER_TP_ATTRIBUTE6
, HEADER_TP_ATTRIBUTE7 HEADER_TP_ATTRIBUTE7
, HEADER_TP_ATTRIBUTE8 HEADER_TP_ATTRIBUTE8
, HEADER_TP_ATTRIBUTE9 HEADER_TP_ATTRIBUTE9
, HEADER_TP_ATTRIBUTE10 HEADER_TP_ATTRIBUTE10
, HEADER_TP_ATTRIBUTE11 HEADER_TP_ATTRIBUTE11
, HEADER_TP_ATTRIBUTE12 HEADER_TP_ATTRIBUTE12
, HEADER_TP_ATTRIBUTE13 HEADER_TP_ATTRIBUTE13
, HEADER_TP_ATTRIBUTE14 HEADER_TP_ATTRIBUTE14
, HEADER_TP_ATTRIBUTE15 HEADER_TP_ATTRIBUTE15
, LINE_TP_ATTRIBUTE1 LINE_TP_ATTRIBUTE1
, LINE_TP_ATTRIBUTE2 LINE_TP_ATTRIBUTE2
, LINE_TP_ATTRIBUTE3 LINE_TP_ATTRIBUTE3
, LINE_TP_ATTRIBUTE4 LINE_TP_ATTRIBUTE4
, LINE_TP_ATTRIBUTE5 LINE_TP_ATTRIBUTE5
, LINE_TP_ATTRIBUTE6 LINE_TP_ATTRIBUTE6
, LINE_TP_ATTRIBUTE7 LINE_TP_ATTRIBUTE7
, LINE_TP_ATTRIBUTE8 LINE_TP_ATTRIBUTE8
, LINE_TP_ATTRIBUTE9 LINE_TP_ATTRIBUTE9
, LINE_TP_ATTRIBUTE10 LINE_TP_ATTRIBUTE10
, LINE_TP_ATTRIBUTE11 LINE_TP_ATTRIBUTE11
, LINE_TP_ATTRIBUTE12 LINE_TP_ATTRIBUTE12
, LINE_TP_ATTRIBUTE13 LINE_TP_ATTRIBUTE13
, LINE_TP_ATTRIBUTE14 LINE_TP_ATTRIBUTE14
, LINE_TP_ATTRIBUTE15 LINE_TP_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE1 INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE2 INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3 INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4 INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5 INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6 INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7 INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8 INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9 INDUSTRY_ATTRIBUTE9
, INDUSTRY_ATTRIBUTE10 INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11 INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12 INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13 INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14 INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15 INDUSTRY_ATTRIBUTE15
, INDUSTRY_CONTEXT INDUSTRY_CONTEXT
, SHIP_ORDER_STATUS_EXT1 SHIP_ORDER_STATUS_EXT1
, SHIP_ORDER_STATUS_EXT2 SHIP_ORDER_STATUS_EXT2
, SHIP_ORDER_STATUS_EXT3 SHIP_ORDER_STATUS_EXT3
, SHIP_ORDER_STATUS_EXT4 SHIP_ORDER_STATUS_EXT4
, SHIP_ORDER_STATUS_EXT5 SHIP_ORDER_STATUS_EXT5
, INDUSTRY_UOM_CODE_EXT2 INDUSTRY_UOM_CODE_EXT2
, INDUSTRY_UOM_CODE_EXT3 INDUSTRY_UOM_CODE_EXT3
, INDUSTRY_UOM_CODE_EXT4 INDUSTRY_UOM_CODE_EXT4
, INDUSTRY_UOM_CODE_EXT5 INDUSTRY_UOM_CODE_EXT5
, ITEM_IDENTIFIER_TYPE ITEM_IDENTIFIER_TYPE
, ITEM_IDENTIFIER_TYPE_EXT1 ITEM_IDENTIFIER_TYPE_EXT1
, ITEM_IDENTIFIER_TYPE_EXT2 ITEM_IDENTIFIER_TYPE_EXT2
, ITEM_IDENTIFIER_TYPE_EXT3 ITEM_IDENTIFIER_TYPE_EXT3
, ITEM_IDENTIFIER_TYPE_EXT4 ITEM_IDENTIFIER_TYPE_EXT4
, ITEM_IDENTIFIER_TYPE_EXT5 ITEM_IDENTIFIER_TYPE_EXT5
, ORDERED_ITEM ORDERED_ITEM
, PURCHASE_ORDER_LINE_NUMBER PURCHASE_ORDER_LINE_NUMBER
, PURCHASE_ORDER_NUMBER PURCHASE_ORDER_NUMBER
, PURCHASE_ORDER_RELEASE_NUMBER PURCHASE_ORDER_RELEASE_NUMBER
, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, INVOICE_LINE_TYPE INVOICE_LINE_TYPE
, INVOICE_LINE_REFERENCE INVOICE_LINE_REFERENCE
, GROSS_WEIGHT GROSS_WEIGHT
, NET_WEIGHT NET_WEIGHT
, WEIGHT_UOM_CODE_INT WEIGHT_UOM_CODE_INT
, WEIGHT_UOM_CODE_EXT1 WEIGHT_UOM_CODE_EXT1
, WEIGHT_UOM_CODE_EXT2 WEIGHT_UOM_CODE_EXT2
, WEIGHT_UOM_CODE_EXT3 WEIGHT_UOM_CODE_EXT3
, WEIGHT_UOM_CODE_EXT4 WEIGHT_UOM_CODE_EXT4
, WEIGHT_UOM_CODE_EXT5 WEIGHT_UOM_CODE_EXT5
, VOLUME VOLUME
, VOLUME_UOM_CODE_INT VOLUME_UOM_CODE_INT
, VOLUME_UOM_CODE_EXT1 VOLUME_UOM_CODE_EXT1
, VOLUME_UOM_CODE_EXT2 VOLUME_UOM_CODE_EXT2
, VOLUME_UOM_CODE_EXT3 VOLUME_UOM_CODE_EXT3
, VOLUME_UOM_CODE_EXT4 VOLUME_UOM_CODE_EXT4
, VOLUME_UOM_CODE_EXT5 VOLUME_UOM_CODE_EXT5
, PACKING_SLIP_NUMBER PACKING_SLIP_NUMBER
, DELIVERY_ID DELIVERY_ID
, BOOKING_NUMBER BOOKING_NUMBER
, BILL_OF_LADING_NUMBER BILL_OF_LADING_NUMBER
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FREIGHT_TERMS_CODE_INT FREIGHT_TERMS_CODE_INT
, FREIGHT_TERMS_CODE_EXT1 FREIGHT_TERMS_CODE_EXT1
, FREIGHT_TERMS_CODE_EXT2 FREIGHT_TERMS_CODE_EXT2
, FREIGHT_TERMS_CODE_EXT3 FREIGHT_TERMS_CODE_EXT3
, FREIGHT_TERMS_CODE_EXT4 FREIGHT_TERMS_CODE_EXT4
, FREIGHT_TERMS_CODE_EXT5 FREIGHT_TERMS_CODE_EXT5
, FOB_LOCATION_CODE FOB_LOCATION_CODE
, FOB_LOCATION_CODE_EXT1 FOB_LOCATION_CODE_EXT1
, FOB_LOCATION_CODE_EXT2 FOB_LOCATION_CODE_EXT2
, FOB_LOCATION_CODE_EXT3 FOB_LOCATION_CODE_EXT3
, FOB_LOCATION_CODE_EXT4 FOB_LOCATION_CODE_EXT4
, FOB_LOCATION_CODE_EXT5 FOB_LOCATION_CODE_EXT5
, SHIP_FROM_EDI_LOC_CODE SHIP_FROM_EDI_LOC_CODE
, SHIP_FROM_EDI_LOC_CODE_INT SHIP_FROM_EDI_LOC_CODE_INT
, SHIP_FROM_EDI_LOC_CODE_EXT1 SHIP_FROM_EDI_LOC_CODE_EXT1
, SHIP_FROM_EDI_LOC_CODE_EXT2 SHIP_FROM_EDI_LOC_CODE_EXT2
, SHIP_FROM_EDI_LOC_CODE_EXT3 SHIP_FROM_EDI_LOC_CODE_EXT3
, SHIP_FROM_EDI_LOC_CODE_EXT4 SHIP_FROM_EDI_LOC_CODE_EXT4
, SHIP_FROM_EDI_LOC_CODE_EXT5 SHIP_FROM_EDI_LOC_CODE_EXT5
, WAREHOUSE_CODE WAREHOUSE_CODE
, WAREHOUSE_NAME WAREHOUSE_NAME
, WAREHOUSE_ADDRESS1 WAREHOUSE_ADDRESS1
, WAREHOUSE_ADDRESS2 WAREHOUSE_ADDRESS2
, WAREHOUSE_ADDRESS3 WAREHOUSE_ADDRESS3
, WAREHOUSE_CITY WAREHOUSE_CITY
, WAREHOUSE_POSTAL_CODE WAREHOUSE_POSTAL_CODE
, WAREHOUSE_COUNTRY_INT WAREHOUSE_COUNTRY_INT
, WAREHOUSE_COUNTRY_EXT1 WAREHOUSE_COUNTRY_EXT1
, WAREHOUSE_COUNTRY_EXT2 WAREHOUSE_COUNTRY_EXT2
, WAREHOUSE_COUNTRY_EXT3 WAREHOUSE_COUNTRY_EXT3
, WAREHOUSE_COUNTRY_EXT4 WAREHOUSE_COUNTRY_EXT4
, WAREHOUSE_COUNTRY_EXT5 WAREHOUSE_COUNTRY_EXT5
, WAREHOUSE_REGION1_INT WAREHOUSE_REGION1_INT
, WAREHOUSE_REGION1_EXT1 WAREHOUSE_REGION1_EXT1
, WAREHOUSE_REGION1_EXT2 WAREHOUSE_REGION1_EXT2
, WAREHOUSE_REGION1_EXT3 WAREHOUSE_REGION1_EXT3
, WAREHOUSE_REGION1_EXT4 WAREHOUSE_REGION1_EXT4
, WAREHOUSE_REGION1_EXT5 WAREHOUSE_REGION1_EXT5
, WAREHOUSE_REGION2_INT WAREHOUSE_REGION2_INT
, WAREHOUSE_REGION2_EXT1 WAREHOUSE_REGION2_EXT1
, WAREHOUSE_REGION2_EXT2 WAREHOUSE_REGION2_EXT2
, WAREHOUSE_REGION2_EXT3 WAREHOUSE_REGION2_EXT3
, WAREHOUSE_REGION2_EXT4 WAREHOUSE_REGION2_EXT4
, WAREHOUSE_REGION2_EXT5 WAREHOUSE_REGION2_EXT5
, WAREHOUSE_REGION3_INT WAREHOUSE_REGION3_INT
, WAREHOUSE_REGION3_EXT1 WAREHOUSE_REGION3_EXT1
, WAREHOUSE_REGION3_EXT2 WAREHOUSE_REGION3_EXT2
, WAREHOUSE_REGION3_EXT3 WAREHOUSE_REGION3_EXT3
, WAREHOUSE_REGION3_EXT4 WAREHOUSE_REGION3_EXT4
, WAREHOUSE_REGION3_EXT5 WAREHOUSE_REGION3_EXT5
, SHIPPED_QUANTITY2 SHIPPED_QUANTITY2
, SHIPPING_QUANTITY SHIPPING_QUANTITY
, SHIPPING_QUANTITY2 SHIPPING_QUANTITY2
, SHIPPING_QUANTITY_UOM_INT SHIPPING_QUANTITY_UOM_INT
, SHIPPING_QUANTITY_UOM_EXT1 SHIPPING_QUANTITY_UOM_EXT1
, SHIPPING_QUANTITY_UOM_EXT2 SHIPPING_QUANTITY_UOM_EXT2
, SHIPPING_QUANTITY_UOM_EXT3 SHIPPING_QUANTITY_UOM_EXT3
, SHIPPING_QUANTITY_UOM_EXT4 SHIPPING_QUANTITY_UOM_EXT4
, SHIPPING_QUANTITY_UOM_EXT5 SHIPPING_QUANTITY_UOM_EXT5
, ORDERED_QUANTITY_UOM2_INT ORDERED_QUANTITY_UOM2_INT
, ORDERED_QUANTITY_UOM2_EXT1 ORDERED_QUANTITY_UOM2_EXT1
, ORDERED_QUANTITY_UOM2_EXT2 ORDERED_QUANTITY_UOM2_EXT2
, ORDERED_QUANTITY_UOM2_EXT3 ORDERED_QUANTITY_UOM2_EXT3
, ORDERED_QUANTITY_UOM2_EXT4 ORDERED_QUANTITY_UOM2_EXT4
, ORDERED_QUANTITY_UOM2_EXT5 ORDERED_QUANTITY_UOM2_EXT5
FROM "EC"."ECE_AR_TRX_LINES"