VIEW: ONT.OE_LINE_ACKS#

Source

View Text - Preformatted

select HEADER_ID HEADER_ID, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF, CHANGE_DATE CHANGE_DATE, CHANGE_SEQUENCE CHANGE_SEQUENCE, ACCOUNTING_RULE ACCOUNTING_RULE, ORDER_NUMBER ORDER_NUMBER, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, ACKNOWLEDGMENT_FLAG ACKNOWLEDGMENT_FLAG, FIRST_ACK_CODE FIRST_ACK_CODE, LAST_ACK_CODE LAST_ACK_CODE, FIRST_ACK_DATE FIRST_ACK_DATE, LAST_ACK_DATE LAST_ACK_DATE, BUYER_SELLER_FLAG BUYER_SELLER_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, ACTUAL_ARRIVAL_DATE ACTUAL_ARRIVAL_DATE, ACTUAL_SHIPMENT_DATE ACTUAL_SHIPMENT_DATE, AGREEMENT AGREEMENT, AGREEMENT_ID AGREEMENT_ID, ARRIVAL_SET_ID ARRIVAL_SET_ID, ARRIVAL_SET_NAME ARRIVAL_SET_NAME, PRICE_LIST PRICE_LIST, PRICE_LIST_ID PRICE_LIST_ID, SHIP_FROM_ORG SHIP_FROM_ORG, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, SHIP_TO_ORG SHIP_TO_ORG, SHIP_TO_ORG_ID SHIP_TO_ORG_ID, SOLD_FROM_ORG SOLD_FROM_ORG, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID, SOLD_TO_ORG SOLD_TO_ORG, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, ATO_LINE_ID ATO_LINE_ID, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, AUTHORIZED_TO_SHIP_FLAG AUTHORIZED_TO_SHIP_FLAG, BOOKED_FLAG BOOKED_FLAG, CALCULATE_PRICE_FLAG CALCULATE_PRICE_FLAG, CANCELLED_FLAG CANCELLED_FLAG, CANCELLED_QUANTITY CANCELLED_QUANTITY, CLOSED_FLAG CLOSED_FLAG, COMMITMENT_ID COMMITMENT_ID, COMPONENT_CODE COMPONENT_CODE, COMPONENT_NUMBER COMPONENT_NUMBER, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, CONFIG_DISPLAY_SEQUENCE CONFIG_DISPLAY_SEQUENCE, CONFIGURATION_ID CONFIGURATION_ID, CONFIG_LINE_REF CONFIG_LINE_REF, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID, CONTEXT CONTEXT, CONTRACT_PO_NUMBER CONTRACT_PO_NUMBER, COST_TYPE COST_TYPE, COST_TYPE_ID COST_TYPE_ID, COSTING_DATE COSTING_DATE, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER, CUST_PO_NUMBER CUST_PO_NUMBER, CUST_PRODUCTION_SEQ_NUM CUST_PRODUCTION_SEQ_NUM, CUSTOMER_DOCK CUSTOMER_DOCK, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE, CUSTOMER_ITEM CUSTOMER_ITEM, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID, CUSTOMER_ITEM_REVISION CUSTOMER_ITEM_REVISION, CUSTOMER_JOB CUSTOMER_JOB, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, DELIVERY_ID DELIVERY_ID, DELIVER_TO_CONTACT DELIVER_TO_CONTACT, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID, DELIVER_TO_ORG DELIVER_TO_ORG, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME, DEMAND_BUCKET_TYPE DEMAND_BUCKET_TYPE, DEMAND_BUCKET_TYPE_CODE DEMAND_BUCKET_TYPE_CODE, DEMAND_CLASS DEMAND_CLASS, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, DEMAND_STREAM DEMAND_STREAM, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG, DPW_ASSIGNED_FLAG DPW_ASSIGNED_FLAG, EARLIEST_ACCEPTABLE_DATE EARLIEST_ACCEPTABLE_DATE, ERROR_FLAG ERROR_FLAG, EXPLOSION_DATE EXPLOSION_DATE, FOB_POINT FOB_POINT, FOB_POINT_CODE FOB_POINT_CODE, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE, FREIGHT_TERMS FREIGHT_TERMS, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FULFILLED_QUANTITY FULFILLED_QUANTITY, FULFILLMENT_SET_ID FULFILLMENT_SET_ID, FULFILLMENT_SET_NAME FULFILLMENT_SET_NAME, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, INDUSTRY_ATTRIBUTE1 INDUSTRY_ATTRIBUTE1, 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_ATTRIBUTE16 INDUSTRY_ATTRIBUTE16, INDUSTRY_ATTRIBUTE17 INDUSTRY_ATTRIBUTE17, INDUSTRY_ATTRIBUTE18 INDUSTRY_ATTRIBUTE18, INDUSTRY_ATTRIBUTE19 INDUSTRY_ATTRIBUTE19, INDUSTRY_ATTRIBUTE2 INDUSTRY_ATTRIBUTE2, INDUSTRY_ATTRIBUTE20 INDUSTRY_ATTRIBUTE20, INDUSTRY_ATTRIBUTE21 INDUSTRY_ATTRIBUTE21, INDUSTRY_ATTRIBUTE22 INDUSTRY_ATTRIBUTE22, INDUSTRY_ATTRIBUTE23 INDUSTRY_ATTRIBUTE23, INDUSTRY_ATTRIBUTE24 INDUSTRY_ATTRIBUTE24, INDUSTRY_ATTRIBUTE25 INDUSTRY_ATTRIBUTE25, INDUSTRY_ATTRIBUTE26 INDUSTRY_ATTRIBUTE26, INDUSTRY_ATTRIBUTE27 INDUSTRY_ATTRIBUTE27, INDUSTRY_ATTRIBUTE28 INDUSTRY_ATTRIBUTE28, INDUSTRY_ATTRIBUTE29 INDUSTRY_ATTRIBUTE29, INDUSTRY_ATTRIBUTE3 INDUSTRY_ATTRIBUTE3, INDUSTRY_ATTRIBUTE30 INDUSTRY_ATTRIBUTE30, 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_CONTEXT INDUSTRY_CONTEXT, INTMED_SHIP_TO_CONTACT_ID INTMED_SHIP_TO_CONTACT_ID, INTMED_SHIP_TO_ORG_ID INTMED_SHIP_TO_ORG_ID, INTERFACE_STATUS INTERFACE_STATUS, INVENTORY_ITEM INVENTORY_ITEM, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INVENTORY_ITEM_SEGMENT_1 INVENTORY_ITEM_SEGMENT_1, INVENTORY_ITEM_SEGMENT_10 INVENTORY_ITEM_SEGMENT_10, INVENTORY_ITEM_SEGMENT_11 INVENTORY_ITEM_SEGMENT_11, INVENTORY_ITEM_SEGMENT_12 INVENTORY_ITEM_SEGMENT_12, INVENTORY_ITEM_SEGMENT_13 INVENTORY_ITEM_SEGMENT_13, INVENTORY_ITEM_SEGMENT_14 INVENTORY_ITEM_SEGMENT_14, INVENTORY_ITEM_SEGMENT_15 INVENTORY_ITEM_SEGMENT_15, INVENTORY_ITEM_SEGMENT_16 INVENTORY_ITEM_SEGMENT_16, INVENTORY_ITEM_SEGMENT_17 INVENTORY_ITEM_SEGMENT_17, INVENTORY_ITEM_SEGMENT_18 INVENTORY_ITEM_SEGMENT_18, INVENTORY_ITEM_SEGMENT_19 INVENTORY_ITEM_SEGMENT_19, INVENTORY_ITEM_SEGMENT_2 INVENTORY_ITEM_SEGMENT_2, INVENTORY_ITEM_SEGMENT_20 INVENTORY_ITEM_SEGMENT_20, INVENTORY_ITEM_SEGMENT_3 INVENTORY_ITEM_SEGMENT_3, INVENTORY_ITEM_SEGMENT_4 INVENTORY_ITEM_SEGMENT_4, INVENTORY_ITEM_SEGMENT_5 INVENTORY_ITEM_SEGMENT_5, INVENTORY_ITEM_SEGMENT_6 INVENTORY_ITEM_SEGMENT_6, INVENTORY_ITEM_SEGMENT_7 INVENTORY_ITEM_SEGMENT_7, INVENTORY_ITEM_SEGMENT_8 INVENTORY_ITEM_SEGMENT_8, INVENTORY_ITEM_SEGMENT_9 INVENTORY_ITEM_SEGMENT_9, INVOICE_COMPLETE_FLAG INVOICE_COMPLETE_FLAG, INVOICE_SET_ID INVOICE_SET_ID, INVOICE_SET_NAME INVOICE_SET_NAME, INVOICE_NUMBER INVOICE_NUMBER, INVOICE_TO_CONTACT INVOICE_TO_CONTACT, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, INVOICE_TO_ORG INVOICE_TO_ORG, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, INVOICE_TOLERANCE_ABOVE INVOICE_TOLERANCE_ABOVE, INVOICE_TOLERANCE_BELOW INVOICE_TOLERANCE_BELOW, INVOICING_RULE INVOICING_RULE, INVOICING_RULE_ID INVOICING_RULE_ID, ITEM_INPUT ITEM_INPUT, ITEM_REVISION ITEM_REVISION, ITEM_TYPE_CODE ITEM_TYPE_CODE, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, LINE_CATEGORY_CODE LINE_CATEGORY_CODE, LINE_ID LINE_ID, LINE_NUMBER LINE_NUMBER, LINE_PO_CONTEXT LINE_PO_CONTEXT, LINE_TYPE LINE_TYPE, LINE_TYPE_ID LINE_TYPE_ID, LINK_TO_LINE_ID LINK_TO_LINE_ID, LINK_TO_LINE_REF LINK_TO_LINE_REF, LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER, LOT LOT, MATERIAL_COST MATERIAL_COST, MATERIAL_OVERHEAD_COST MATERIAL_OVERHEAD_COST, MODEL_GROUP_NUMBER MODEL_GROUP_NUMBER, OPEN_FLAG OPEN_FLAG, OPERATION_CODE OPERATION_CODE, OPTION_FLAG OPTION_FLAG, OPTION_NUMBER OPTION_NUMBER, ORDER_QUANTITY_UOM ORDER_QUANTITY_UOM, ORDER_SOURCE ORDER_SOURCE, ORDER_SOURCE_ID ORDER_SOURCE_ID, ORDERED_QUANTITY ORDERED_QUANTITY, ORG_ID ORG_ID, OUTSIDE_PROCESSING_COST OUTSIDE_PROCESSING_COST, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF, OVER_SHIP_REASON_CODE OVER_SHIP_REASON_CODE, OVER_SHIP_RESOLVED_FLAG OVER_SHIP_RESOLVED_FLAG, OVERHEAD_COST OVERHEAD_COST, PAYMENT_TERM PAYMENT_TERM, PAYMENT_TERM_ID PAYMENT_TERM_ID, PAYMENT_TRX PAYMENT_TRX, PAYMENT_TRX_ID PAYMENT_TRX_ID, PLANNING_PROD_SEQ_NUM PLANNING_PROD_SEQ_NUM, PRICING_ATTRIBUTE1 PRICING_ATTRIBUTE1, PRICING_ATTRIBUTE10 PRICING_ATTRIBUTE10, PRICING_ATTRIBUTE2 PRICING_ATTRIBUTE2, PRICING_ATTRIBUTE3 PRICING_ATTRIBUTE3, PRICING_ATTRIBUTE4 PRICING_ATTRIBUTE4, PRICING_ATTRIBUTE5 PRICING_ATTRIBUTE5, PRICING_ATTRIBUTE6 PRICING_ATTRIBUTE6, PRICING_ATTRIBUTE7 PRICING_ATTRIBUTE7, PRICING_ATTRIBUTE8 PRICING_ATTRIBUTE8, PRICING_ATTRIBUTE9 PRICING_ATTRIBUTE9, PRICING_CONTEXT PRICING_CONTEXT, PRICING_DATE PRICING_DATE, PRICING_QUANTITY PRICING_QUANTITY, PRICING_QUANTITY_UOM PRICING_QUANTITY_UOM, PROGRAM PROGRAM, PROGRAM_APPLICATION PROGRAM_APPLICATION, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT PROJECT, PROJECT_ID PROJECT_ID, PROMISE_DATE PROMISE_DATE, REFERENCE_HEADER REFERENCE_HEADER, REFERENCE_HEADER_ID REFERENCE_HEADER_ID, REFERENCE_LINE REFERENCE_LINE, REFERENCE_LINE_ID REFERENCE_LINE_ID, REFERENCE_TYPE REFERENCE_TYPE, RELATED_PO_NUMBER RELATED_PO_NUMBER, REQUEST_DATE REQUEST_DATE, REQUEST_ID REQUEST_ID, RESERVED_QUANTITY RESERVED_QUANTITY, RESOURCE_COST RESOURCE_COST, RETURN_ATTRIBUTE1 RETURN_ATTRIBUTE1, RETURN_ATTRIBUTE10 RETURN_ATTRIBUTE10, RETURN_ATTRIBUTE11 RETURN_ATTRIBUTE11, RETURN_ATTRIBUTE12 RETURN_ATTRIBUTE12, RETURN_ATTRIBUTE13 RETURN_ATTRIBUTE13, RETURN_ATTRIBUTE14 RETURN_ATTRIBUTE14, RETURN_ATTRIBUTE15 RETURN_ATTRIBUTE15, RETURN_ATTRIBUTE2 RETURN_ATTRIBUTE2, RETURN_ATTRIBUTE3 RETURN_ATTRIBUTE3, RETURN_ATTRIBUTE4 RETURN_ATTRIBUTE4, RETURN_ATTRIBUTE5 RETURN_ATTRIBUTE5, RETURN_ATTRIBUTE6 RETURN_ATTRIBUTE6, RETURN_ATTRIBUTE7 RETURN_ATTRIBUTE7, RETURN_ATTRIBUTE8 RETURN_ATTRIBUTE8, RETURN_ATTRIBUTE9 RETURN_ATTRIBUTE9, RETURN_CONTEXT RETURN_CONTEXT, RETURN_REASON_CODE RETURN_REASON_CODE, RLA_SCHEDULE_TYPE_CODE RLA_SCHEDULE_TYPE_CODE, SALESREP_ID SALESREP_ID, SALESREP SALESREP, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE, SCHEDULE_ITEM_DETAIL SCHEDULE_ITEM_DETAIL, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG, SHIP_SET_ID SHIP_SET_ID, SHIP_SET_NAME SHIP_SET_NAME, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4, SHIP_TO_CITY SHIP_TO_CITY, SHIP_TO_CONTACT SHIP_TO_CONTACT, SHIP_TO_CONTACT_AREA_CODE1 SHIP_TO_CONTACT_AREA_CODE1, SHIP_TO_CONTACT_AREA_CODE2 SHIP_TO_CONTACT_AREA_CODE2, SHIP_TO_CONTACT_AREA_CODE3 SHIP_TO_CONTACT_AREA_CODE3, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, SHIP_TO_CONTACT_JOB_TITLE SHIP_TO_CONTACT_JOB_TITLE, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME, SHIP_TO_COUNTRY SHIP_TO_COUNTRY, SHIP_TO_COUNTY SHIP_TO_COUNTY, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE, SHIP_TO_STATE SHIP_TO_STATE, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW, SHIPMENT_NUMBER SHIPMENT_NUMBER, SHIPMENT_PRIORITY SHIPMENT_PRIORITY, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIPPED_QUANTITY SHIPPED_QUANTITY, SHIPPING_METHOD SHIPPING_METHOD, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, SHIPPING_QUANTITY SHIPPING_QUANTITY, SHIPPING_QUANTITY_UOM SHIPPING_QUANTITY_UOM, SORT_ORDER SORT_ORDER, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID, SOURCE_DOCUMENT_LINE_ID SOURCE_DOCUMENT_LINE_ID, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID, SOURCE_TYPE_CODE SOURCE_TYPE_CODE, SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID, SUBINVENTORY SUBINVENTORY, SUBMISSION_DATETIME SUBMISSION_DATETIME, TASK TASK, TASK_ID TASK_ID, TAX TAX, TAX_CODE TAX_CODE, TAX_DATE TAX_DATE, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON TAX_EXEMPT_REASON, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, TAX_POINT TAX_POINT, TAX_POINT_CODE TAX_POINT_CODE, TAX_RATE TAX_RATE, TAX_VALUE TAX_VALUE, UNIT_LIST_PRICE UNIT_LIST_PRICE, UNIT_SELLING_PRICE UNIT_SELLING_PRICE, VEH_CUS_ITEM_CUM_KEY_ID VEH_CUS_ITEM_CUM_KEY_ID, VISIBLE_DEMAND_FLAG VISIBLE_DEMAND_FLAG, CUSTOMER_LINE_NUMBER CUSTOMER_LINE_NUMBER, CUSTOMER_SHIPMENT_NUMBER CUSTOMER_SHIPMENT_NUMBER, CUSTOMER_ITEM_NET_PRICE CUSTOMER_ITEM_NET_PRICE, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID, DROP_SHIP_FLAG DROP_SHIP_FLAG, SHIP_TO_EDI_LOCATION_CODE SHIP_TO_EDI_LOCATION_CODE, SPLIT_FROM_LINE_REF SPLIT_FROM_LINE_REF, SERVICE_TXN_REASON_CODE SERVICE_TXN_REASON_CODE, SERVICE_TXN_COMMENTS SERVICE_TXN_COMMENTS, SERVICE_DURATION SERVICE_DURATION, SERVICE_START_DATE SERVICE_START_DATE, SERVICE_END_DATE SERVICE_END_DATE, SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG, SERVICE_NUMBER SERVICE_NUMBER, SERVICE_PERIOD SERVICE_PERIOD, SERVICE_REFERENCE_TYPE_CODE SERVICE_REFERENCE_TYPE_CODE, SERVICE_REFERENCE_LINE_ID SERVICE_REFERENCE_LINE_ID, SERVICE_REFERENCE_SYSTEM_ID SERVICE_REFERENCE_SYSTEM_ID, CREDIT_INVOICE_LINE_ID CREDIT_INVOICE_LINE_ID, SHIP_TO_PROVINCE SHIP_TO_PROVINCE, INVOICE_PROVINCE INVOICE_PROVINCE, BILL_TO_EDI_LOCATION_CODE BILL_TO_EDI_LOCATION_CODE, INVOICE_CITY INVOICE_CITY, SHIP_FROM_ADDRESS_1 SHIP_FROM_ADDRESS_1, SHIP_FROM_ADDRESS_2 SHIP_FROM_ADDRESS_2, SHIP_FROM_ADDRESS_3 SHIP_FROM_ADDRESS_3, SHIP_FROM_CITY SHIP_FROM_CITY, SHIP_FROM_POSTAL_CODE SHIP_FROM_POSTAL_CODE, SHIP_FROM_COUNTRY SHIP_FROM_COUNTRY, SHIP_FROM_EDI_LOCATION_CODE SHIP_FROM_EDI_LOCATION_CODE, SHIP_FROM_REGION1 SHIP_FROM_REGION1, SHIP_FROM_REGION2 SHIP_FROM_REGION2, SHIP_FROM_REGION3 SHIP_FROM_REGION3, SHIP_FROM_ADDRESS_ID SHIP_FROM_ADDRESS_ID, SHIP_TO_ADDRESS_CODE SHIP_TO_ADDRESS_CODE, SHIP_TO_ADDRESS_NAME SHIP_TO_ADDRESS_NAME, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID, INVOICE_ADDRESS_CODE INVOICE_ADDRESS_CODE, INVOICE_ADDRESS_NAME INVOICE_ADDRESS_NAME, DELIVER_TO_CUSTOMER DELIVER_TO_CUSTOMER, SERVICED_LINE_ID SERVICED_LINE_ID, SERVICE_REFERENCE_ORDER SERVICE_REFERENCE_ORDER, SERVICE_REFERENCE_LINE SERVICE_REFERENCE_LINE, SERVICE_REFERENCE_SYSTEM SERVICE_REFERENCE_SYSTEM, TP_CONTEXT TP_CONTEXT, TP_ATTRIBUTE1 TP_ATTRIBUTE1, TP_ATTRIBUTE2 TP_ATTRIBUTE2, TP_ATTRIBUTE3 TP_ATTRIBUTE3, TP_ATTRIBUTE4 TP_ATTRIBUTE4, TP_ATTRIBUTE5 TP_ATTRIBUTE5, TP_ATTRIBUTE6 TP_ATTRIBUTE6, TP_ATTRIBUTE7 TP_ATTRIBUTE7, TP_ATTRIBUTE8 TP_ATTRIBUTE8, TP_ATTRIBUTE9 TP_ATTRIBUTE9, TP_ATTRIBUTE10 TP_ATTRIBUTE10, TP_ATTRIBUTE11 TP_ATTRIBUTE11, TP_ATTRIBUTE12 TP_ATTRIBUTE12, TP_ATTRIBUTE13 TP_ATTRIBUTE13, TP_ATTRIBUTE14 TP_ATTRIBUTE14, TP_ATTRIBUTE15 TP_ATTRIBUTE15, SPLIT_FROM_SHIPMENT_REF SPLIT_FROM_SHIPMENT_REF, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID, INVOICE_TO_CUSTOMER_ID INVOICE_TO_CUSTOMER_ID, DELIVER_TO_CUSTOMER_ID DELIVER_TO_CUSTOMER_ID, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME, SHIP_TO_CUSTOMER_NUMBER SHIP_TO_CUSTOMER_NUMBER, INVOICE_TO_CUSTOMER_NAME INVOICE_TO_CUSTOMER_NAME, INVOICE_TO_CUSTOMER_NUMBER INVOICE_TO_CUSTOMER_NUMBER, DELIVER_TO_CUSTOMER_NAME DELIVER_TO_CUSTOMER_NAME, DELIVER_TO_CUSTOMER_NUMBER DELIVER_TO_CUSTOMER_NUMBER, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ACKNOWLEDGMENT_TYPE ACKNOWLEDGMENT_TYPE, USER_ITEM_DESCRIPTION USER_ITEM_DESCRIPTION, BLANKET_NUMBER BLANKET_NUMBER, BLANKET_LINE_NUMBER BLANKET_LINE_NUMBER, ORIGINAL_INVENTORY_ITEM_ID ORIGINAL_INVENTORY_ITEM_ID, ORIGINAL_ORDERED_ITEM_ID ORIGINAL_ORDERED_ITEM_ID, ORIGINAL_ORDERED_ITEM ORIGINAL_ORDERED_ITEM, ORDERED_ITEM ORDERED_ITEM, INVOICE_INTERFACE_STATUS_CODE INVOICE_INTERFACE_STATUS_CODE, PREFERRED_GRADE PREFERRED_GRADE, ORDERED_QUANTITY2 ORDERED_QUANTITY2, ORDERED_QUANTITY_UOM2 ORDERED_QUANTITY_UOM2, SHIPPING_QUANTITY2 SHIPPING_QUANTITY2, CANCELLED_QUANTITY2 CANCELLED_QUANTITY2, SHIPPED_QUANTITY2 SHIPPED_QUANTITY2, SHIPPING_QUANTITY_UOM2 SHIPPING_QUANTITY_UOM2, FULFILLED_QUANTITY2 FULFILLED_QUANTITY2, REVENUE_AMOUNT REVENUE_AMOUNT, FULFILLMENT_DATE FULFILLMENT_DATE, ORIGINAL_ITEM_IDENTIFIER_TYPE ORIGINAL_ITEM_IDENTIFIER_TYPE, ITEM_SUBSTITUTION_TYPE_CODE ITEM_SUBSTITUTION_TYPE_CODE, AUTO_SELECTED_QUANTITY AUTO_SELECTED_QUANTITY, ORDERED_ITEM_ID ORDERED_ITEM_ID, ITEM_IDENTIFIER_TYPE ITEM_IDENTIFIER_TYPE, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, INVOICED_QUANTITY INVOICED_QUANTITY, REFERENCE_CUSTOMER_TRX_LINE_ID REFERENCE_CUSTOMER_TRX_LINE_ID, SPLIT_BY SPLIT_BY, LINE_SET_ID LINE_SET_ID, UNIT_LIST_PERCENT UNIT_LIST_PERCENT, UNIT_SELLING_PERCENT UNIT_SELLING_PERCENT, UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE, RE_SOURCE_FLAG RE_SOURCE_FLAG, FLOW_STATUS_CODE FLOW_STATUS_CODE, UNIT_LIST_PRICE_PER_PQTY UNIT_LIST_PRICE_PER_PQTY, UNIT_SELLING_PRICE_PQTY UNIT_SELLING_PRICE_PQTY, ITEM_RELATIONSHIP_TYPE ITEM_RELATIONSHIP_TYPE, UNIT_SELLING_PRICE_PER_PQTY UNIT_SELLING_PRICE_PER_PQTY, SHIP_TO_PARTY_NUMBER SHIP_TO_PARTY_NUMBER, INVOICE_TO_PARTY_NUMBER INVOICE_TO_PARTY_NUMBER, DELIVER_TO_PARTY_NUMBER DELIVER_TO_PARTY_NUMBER, END_CUSTOMER_NUMBER END_CUSTOMER_NUMBER, END_CUSTOMER_PARTY_NUMBER END_CUSTOMER_PARTY_NUMBER, END_CUSTOMER_ID END_CUSTOMER_ID, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ADDRESS1 END_CUSTOMER_ADDRESS1, END_CUSTOMER_ADDRESS2 END_CUSTOMER_ADDRESS2, END_CUSTOMER_ADDRESS3 END_CUSTOMER_ADDRESS3, END_CUSTOMER_ADDRESS4 END_CUSTOMER_ADDRESS4, END_CUSTOMER_CITY END_CUSTOMER_CITY, END_CUSTOMER_POSTAL_CODE END_CUSTOMER_POSTAL_CODE, END_CUSTOMER_COUNTRY END_CUSTOMER_COUNTRY, END_CUSTOMER_STATE END_CUSTOMER_STATE, END_CUSTOMER_COUNTY END_CUSTOMER_COUNTY, END_CUSTOMER_PROVINCE END_CUSTOMER_PROVINCE, END_CUSTOMER_CONTACT END_CUSTOMER_CONTACT, END_CUSTOMER_CONTACT_LAST_NAME END_CUSTOMER_CONTACT_LAST_NAME, END_CUSTOMER_CONTACT_FIRST_NAM END_CUSTOMER_CONTACT_FIRST_NAM, END_CUSTOMER_NAME END_CUSTOMER_NAME, IB_OWNER IB_OWNER, IB_CURRENT_LOCATION IB_CURRENT_LOCATION, IB_INSTALLED_AT_LOCATION IB_INSTALLED_AT_LOCATION, ORDER_FIRMED_DATE ORDER_FIRMED_DATE, ACTUAL_FULFILLMENT_DATE ACTUAL_FULFILLMENT_DATE, COMMITMENT COMMITMENT, CUSTOMER_PAYMENT_TERM CUSTOMER_PAYMENT_TERM, DELIVER_TO_ADDRESS1 DELIVER_TO_ADDRESS1, DELIVER_TO_ADDRESS2 DELIVER_TO_ADDRESS2, DELIVER_TO_ADDRESS3 DELIVER_TO_ADDRESS3, DELIVER_TO_ADDRESS4 DELIVER_TO_ADDRESS4, DELIVER_TO_CITY DELIVER_TO_CITY, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY, DELIVER_TO_COUNTY DELIVER_TO_COUNTY, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE, DELIVER_TO_PROVINCE DELIVER_TO_PROVINCE, DELIVER_TO_STATE DELIVER_TO_STATE, INVOICE_ADDRESS_1 INVOICE_ADDRESS_1, INVOICE_ADDRESS_2 INVOICE_ADDRESS_2, INVOICE_ADDRESS_3 INVOICE_ADDRESS_3, INVOICE_ADDRESS_4 INVOICE_ADDRESS_4, INVOICE_COUNTRY INVOICE_COUNTRY, INVOICE_COUNTY INVOICE_COUNTY, INVOICE_POSTAL_CODE INVOICE_POSTAL_CODE, INVOICE_STATE INVOICE_STATE, IB_OWNER_CODE IB_OWNER_CODE, IB_INSTALLED_AT_LOCATION_CODE IB_INSTALLED_AT_LOCATION_CODE, IB_CURRENT_LOCATION_CODE IB_CURRENT_LOCATION_CODE, CHARGE_PERIODICITY_CODE CHARGE_PERIODICITY_CODE, CONFIG_HEADER_ID CONFIG_HEADER_ID, CONFIG_REV_NBR CONFIG_REV_NBR, INST_ID INST_ID, SERVICE_BILL_PROFILE_ID SERVICE_BILL_PROFILE_ID, SERVICE_BILLING_PROFILE SERVICE_BILLING_PROFILE, SERVICE_COV_TEMPLATE_ID SERVICE_COV_TEMPLATE_ID, SERVICE_COVERAGE_TEMPLATE SERVICE_COVERAGE_TEMPLATE, SERVICE_SUBS_TEMPLATE_ID SERVICE_SUBS_TEMPLATE_ID, SERVICE_SUBSCRIPTION_TEMPLATE SERVICE_SUBSCRIPTION_TEMPLATE, SERVICE_BILL_OPTION_CODE SERVICE_BILL_OPTION_CODE, SERVICE_BILL_OPTION SERVICE_BILL_OPTION, SERVICE_FIRST_PERIOD_AMOUNT SERVICE_FIRST_PERIOD_AMOUNT, SERVICE_FIRST_PERIOD_ENDDATE SERVICE_FIRST_PERIOD_ENDDATE, SUBSCRIPTION_ENABLE_FLAG SUBSCRIPTION_ENABLE_FLAG from "ONT"."OE_LINE_ACKS"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
, CHANGE_DATE CHANGE_DATE
, CHANGE_SEQUENCE CHANGE_SEQUENCE
, ACCOUNTING_RULE ACCOUNTING_RULE
, ORDER_NUMBER ORDER_NUMBER
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, ACKNOWLEDGMENT_FLAG ACKNOWLEDGMENT_FLAG
, FIRST_ACK_CODE FIRST_ACK_CODE
, LAST_ACK_CODE LAST_ACK_CODE
, FIRST_ACK_DATE FIRST_ACK_DATE
, LAST_ACK_DATE LAST_ACK_DATE
, BUYER_SELLER_FLAG BUYER_SELLER_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, ACTUAL_ARRIVAL_DATE ACTUAL_ARRIVAL_DATE
, ACTUAL_SHIPMENT_DATE ACTUAL_SHIPMENT_DATE
, AGREEMENT AGREEMENT
, AGREEMENT_ID AGREEMENT_ID
, ARRIVAL_SET_ID ARRIVAL_SET_ID
, ARRIVAL_SET_NAME ARRIVAL_SET_NAME
, PRICE_LIST PRICE_LIST
, PRICE_LIST_ID PRICE_LIST_ID
, SHIP_FROM_ORG SHIP_FROM_ORG
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, SHIP_TO_ORG SHIP_TO_ORG
, SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, SOLD_FROM_ORG SOLD_FROM_ORG
, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID
, SOLD_TO_ORG SOLD_TO_ORG
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, ATO_LINE_ID ATO_LINE_ID
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, AUTHORIZED_TO_SHIP_FLAG AUTHORIZED_TO_SHIP_FLAG
, BOOKED_FLAG BOOKED_FLAG
, CALCULATE_PRICE_FLAG CALCULATE_PRICE_FLAG
, CANCELLED_FLAG CANCELLED_FLAG
, CANCELLED_QUANTITY CANCELLED_QUANTITY
, CLOSED_FLAG CLOSED_FLAG
, COMMITMENT_ID COMMITMENT_ID
, COMPONENT_CODE COMPONENT_CODE
, COMPONENT_NUMBER COMPONENT_NUMBER
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, CONFIG_DISPLAY_SEQUENCE CONFIG_DISPLAY_SEQUENCE
, CONFIGURATION_ID CONFIGURATION_ID
, CONFIG_LINE_REF CONFIG_LINE_REF
, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
, CONTEXT CONTEXT
, CONTRACT_PO_NUMBER CONTRACT_PO_NUMBER
, COST_TYPE COST_TYPE
, COST_TYPE_ID COST_TYPE_ID
, COSTING_DATE COSTING_DATE
, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER
, CUST_PO_NUMBER CUST_PO_NUMBER
, CUST_PRODUCTION_SEQ_NUM CUST_PRODUCTION_SEQ_NUM
, CUSTOMER_DOCK CUSTOMER_DOCK
, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE
, CUSTOMER_ITEM CUSTOMER_ITEM
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, CUSTOMER_ITEM_REVISION CUSTOMER_ITEM_REVISION
, CUSTOMER_JOB CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, DELIVERY_ID DELIVERY_ID
, DELIVER_TO_CONTACT DELIVER_TO_CONTACT
, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, DELIVER_TO_ORG DELIVER_TO_ORG
, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID
, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME
, DEMAND_BUCKET_TYPE DEMAND_BUCKET_TYPE
, DEMAND_BUCKET_TYPE_CODE DEMAND_BUCKET_TYPE_CODE
, DEMAND_CLASS DEMAND_CLASS
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, DEMAND_STREAM DEMAND_STREAM
, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG
, DPW_ASSIGNED_FLAG DPW_ASSIGNED_FLAG
, EARLIEST_ACCEPTABLE_DATE EARLIEST_ACCEPTABLE_DATE
, ERROR_FLAG ERROR_FLAG
, EXPLOSION_DATE EXPLOSION_DATE
, FOB_POINT FOB_POINT
, FOB_POINT_CODE FOB_POINT_CODE
, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, FREIGHT_TERMS FREIGHT_TERMS
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FULFILLED_QUANTITY FULFILLED_QUANTITY
, FULFILLMENT_SET_ID FULFILLMENT_SET_ID
, FULFILLMENT_SET_NAME FULFILLMENT_SET_NAME
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, INDUSTRY_ATTRIBUTE1 INDUSTRY_ATTRIBUTE1
, 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_ATTRIBUTE16 INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17 INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18 INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19 INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE2 INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE20 INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21 INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22 INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23 INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24 INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25 INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26 INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27 INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28 INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29 INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE3 INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE30 INDUSTRY_ATTRIBUTE30
, 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_CONTEXT INDUSTRY_CONTEXT
, INTMED_SHIP_TO_CONTACT_ID INTMED_SHIP_TO_CONTACT_ID
, INTMED_SHIP_TO_ORG_ID INTMED_SHIP_TO_ORG_ID
, INTERFACE_STATUS INTERFACE_STATUS
, INVENTORY_ITEM INVENTORY_ITEM
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INVENTORY_ITEM_SEGMENT_1 INVENTORY_ITEM_SEGMENT_1
, INVENTORY_ITEM_SEGMENT_10 INVENTORY_ITEM_SEGMENT_10
, INVENTORY_ITEM_SEGMENT_11 INVENTORY_ITEM_SEGMENT_11
, INVENTORY_ITEM_SEGMENT_12 INVENTORY_ITEM_SEGMENT_12
, INVENTORY_ITEM_SEGMENT_13 INVENTORY_ITEM_SEGMENT_13
, INVENTORY_ITEM_SEGMENT_14 INVENTORY_ITEM_SEGMENT_14
, INVENTORY_ITEM_SEGMENT_15 INVENTORY_ITEM_SEGMENT_15
, INVENTORY_ITEM_SEGMENT_16 INVENTORY_ITEM_SEGMENT_16
, INVENTORY_ITEM_SEGMENT_17 INVENTORY_ITEM_SEGMENT_17
, INVENTORY_ITEM_SEGMENT_18 INVENTORY_ITEM_SEGMENT_18
, INVENTORY_ITEM_SEGMENT_19 INVENTORY_ITEM_SEGMENT_19
, INVENTORY_ITEM_SEGMENT_2 INVENTORY_ITEM_SEGMENT_2
, INVENTORY_ITEM_SEGMENT_20 INVENTORY_ITEM_SEGMENT_20
, INVENTORY_ITEM_SEGMENT_3 INVENTORY_ITEM_SEGMENT_3
, INVENTORY_ITEM_SEGMENT_4 INVENTORY_ITEM_SEGMENT_4
, INVENTORY_ITEM_SEGMENT_5 INVENTORY_ITEM_SEGMENT_5
, INVENTORY_ITEM_SEGMENT_6 INVENTORY_ITEM_SEGMENT_6
, INVENTORY_ITEM_SEGMENT_7 INVENTORY_ITEM_SEGMENT_7
, INVENTORY_ITEM_SEGMENT_8 INVENTORY_ITEM_SEGMENT_8
, INVENTORY_ITEM_SEGMENT_9 INVENTORY_ITEM_SEGMENT_9
, INVOICE_COMPLETE_FLAG INVOICE_COMPLETE_FLAG
, INVOICE_SET_ID INVOICE_SET_ID
, INVOICE_SET_NAME INVOICE_SET_NAME
, INVOICE_NUMBER INVOICE_NUMBER
, INVOICE_TO_CONTACT INVOICE_TO_CONTACT
, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, INVOICE_TO_ORG INVOICE_TO_ORG
, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, INVOICE_TOLERANCE_ABOVE INVOICE_TOLERANCE_ABOVE
, INVOICE_TOLERANCE_BELOW INVOICE_TOLERANCE_BELOW
, INVOICING_RULE INVOICING_RULE
, INVOICING_RULE_ID INVOICING_RULE_ID
, ITEM_INPUT ITEM_INPUT
, ITEM_REVISION ITEM_REVISION
, ITEM_TYPE_CODE ITEM_TYPE_CODE
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, LINE_CATEGORY_CODE LINE_CATEGORY_CODE
, LINE_ID LINE_ID
, LINE_NUMBER LINE_NUMBER
, LINE_PO_CONTEXT LINE_PO_CONTEXT
, LINE_TYPE LINE_TYPE
, LINE_TYPE_ID LINE_TYPE_ID
, LINK_TO_LINE_ID LINK_TO_LINE_ID
, LINK_TO_LINE_REF LINK_TO_LINE_REF
, LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER
, LOT LOT
, MATERIAL_COST MATERIAL_COST
, MATERIAL_OVERHEAD_COST MATERIAL_OVERHEAD_COST
, MODEL_GROUP_NUMBER MODEL_GROUP_NUMBER
, OPEN_FLAG OPEN_FLAG
, OPERATION_CODE OPERATION_CODE
, OPTION_FLAG OPTION_FLAG
, OPTION_NUMBER OPTION_NUMBER
, ORDER_QUANTITY_UOM ORDER_QUANTITY_UOM
, ORDER_SOURCE ORDER_SOURCE
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, ORDERED_QUANTITY ORDERED_QUANTITY
, ORG_ID ORG_ID
, OUTSIDE_PROCESSING_COST OUTSIDE_PROCESSING_COST
, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF
, OVER_SHIP_REASON_CODE OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG OVER_SHIP_RESOLVED_FLAG
, OVERHEAD_COST OVERHEAD_COST
, PAYMENT_TERM PAYMENT_TERM
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, PAYMENT_TRX PAYMENT_TRX
, PAYMENT_TRX_ID PAYMENT_TRX_ID
, PLANNING_PROD_SEQ_NUM PLANNING_PROD_SEQ_NUM
, PRICING_ATTRIBUTE1 PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE10 PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE2 PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3 PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4 PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5 PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6 PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7 PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8 PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9 PRICING_ATTRIBUTE9
, PRICING_CONTEXT PRICING_CONTEXT
, PRICING_DATE PRICING_DATE
, PRICING_QUANTITY PRICING_QUANTITY
, PRICING_QUANTITY_UOM PRICING_QUANTITY_UOM
, PROGRAM PROGRAM
, PROGRAM_APPLICATION PROGRAM_APPLICATION
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT PROJECT
, PROJECT_ID PROJECT_ID
, PROMISE_DATE PROMISE_DATE
, REFERENCE_HEADER REFERENCE_HEADER
, REFERENCE_HEADER_ID REFERENCE_HEADER_ID
, REFERENCE_LINE REFERENCE_LINE
, REFERENCE_LINE_ID REFERENCE_LINE_ID
, REFERENCE_TYPE REFERENCE_TYPE
, RELATED_PO_NUMBER RELATED_PO_NUMBER
, REQUEST_DATE REQUEST_DATE
, REQUEST_ID REQUEST_ID
, RESERVED_QUANTITY RESERVED_QUANTITY
, RESOURCE_COST RESOURCE_COST
, RETURN_ATTRIBUTE1 RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE10 RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11 RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12 RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13 RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14 RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15 RETURN_ATTRIBUTE15
, RETURN_ATTRIBUTE2 RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3 RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4 RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5 RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6 RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7 RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8 RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9 RETURN_ATTRIBUTE9
, RETURN_CONTEXT RETURN_CONTEXT
, RETURN_REASON_CODE RETURN_REASON_CODE
, RLA_SCHEDULE_TYPE_CODE RLA_SCHEDULE_TYPE_CODE
, SALESREP_ID SALESREP_ID
, SALESREP SALESREP
, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE
, SCHEDULE_ITEM_DETAIL SCHEDULE_ITEM_DETAIL
, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE
, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, SHIP_SET_ID SHIP_SET_ID
, SHIP_SET_NAME SHIP_SET_NAME
, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4
, SHIP_TO_CITY SHIP_TO_CITY
, SHIP_TO_CONTACT SHIP_TO_CONTACT
, SHIP_TO_CONTACT_AREA_CODE1 SHIP_TO_CONTACT_AREA_CODE1
, SHIP_TO_CONTACT_AREA_CODE2 SHIP_TO_CONTACT_AREA_CODE2
, SHIP_TO_CONTACT_AREA_CODE3 SHIP_TO_CONTACT_AREA_CODE3
, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, SHIP_TO_CONTACT_JOB_TITLE SHIP_TO_CONTACT_JOB_TITLE
, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME
, SHIP_TO_COUNTRY SHIP_TO_COUNTRY
, SHIP_TO_COUNTY SHIP_TO_COUNTY
, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE
, SHIP_TO_STATE SHIP_TO_STATE
, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, SHIPMENT_PRIORITY SHIPMENT_PRIORITY
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, SHIPPING_METHOD SHIPPING_METHOD
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY SHIPPING_QUANTITY
, SHIPPING_QUANTITY_UOM SHIPPING_QUANTITY_UOM
, SORT_ORDER SORT_ORDER
, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_LINE_ID SOURCE_DOCUMENT_LINE_ID
, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID
, SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID
, SUBINVENTORY SUBINVENTORY
, SUBMISSION_DATETIME SUBMISSION_DATETIME
, TASK TASK
, TASK_ID TASK_ID
, TAX TAX
, TAX_CODE TAX_CODE
, TAX_DATE TAX_DATE
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON TAX_EXEMPT_REASON
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, TAX_POINT TAX_POINT
, TAX_POINT_CODE TAX_POINT_CODE
, TAX_RATE TAX_RATE
, TAX_VALUE TAX_VALUE
, UNIT_LIST_PRICE UNIT_LIST_PRICE
, UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, VEH_CUS_ITEM_CUM_KEY_ID VEH_CUS_ITEM_CUM_KEY_ID
, VISIBLE_DEMAND_FLAG VISIBLE_DEMAND_FLAG
, CUSTOMER_LINE_NUMBER CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER CUSTOMER_SHIPMENT_NUMBER
, CUSTOMER_ITEM_NET_PRICE CUSTOMER_ITEM_NET_PRICE
, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID
, DROP_SHIP_FLAG DROP_SHIP_FLAG
, SHIP_TO_EDI_LOCATION_CODE SHIP_TO_EDI_LOCATION_CODE
, SPLIT_FROM_LINE_REF SPLIT_FROM_LINE_REF
, SERVICE_TXN_REASON_CODE SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS SERVICE_TXN_COMMENTS
, SERVICE_DURATION SERVICE_DURATION
, SERVICE_START_DATE SERVICE_START_DATE
, SERVICE_END_DATE SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG
, SERVICE_NUMBER SERVICE_NUMBER
, SERVICE_PERIOD SERVICE_PERIOD
, SERVICE_REFERENCE_TYPE_CODE SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID SERVICE_REFERENCE_SYSTEM_ID
, CREDIT_INVOICE_LINE_ID CREDIT_INVOICE_LINE_ID
, SHIP_TO_PROVINCE SHIP_TO_PROVINCE
, INVOICE_PROVINCE INVOICE_PROVINCE
, BILL_TO_EDI_LOCATION_CODE BILL_TO_EDI_LOCATION_CODE
, INVOICE_CITY INVOICE_CITY
, SHIP_FROM_ADDRESS_1 SHIP_FROM_ADDRESS_1
, SHIP_FROM_ADDRESS_2 SHIP_FROM_ADDRESS_2
, SHIP_FROM_ADDRESS_3 SHIP_FROM_ADDRESS_3
, SHIP_FROM_CITY SHIP_FROM_CITY
, SHIP_FROM_POSTAL_CODE SHIP_FROM_POSTAL_CODE
, SHIP_FROM_COUNTRY SHIP_FROM_COUNTRY
, SHIP_FROM_EDI_LOCATION_CODE SHIP_FROM_EDI_LOCATION_CODE
, SHIP_FROM_REGION1 SHIP_FROM_REGION1
, SHIP_FROM_REGION2 SHIP_FROM_REGION2
, SHIP_FROM_REGION3 SHIP_FROM_REGION3
, SHIP_FROM_ADDRESS_ID SHIP_FROM_ADDRESS_ID
, SHIP_TO_ADDRESS_CODE SHIP_TO_ADDRESS_CODE
, SHIP_TO_ADDRESS_NAME SHIP_TO_ADDRESS_NAME
, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID
, INVOICE_ADDRESS_CODE INVOICE_ADDRESS_CODE
, INVOICE_ADDRESS_NAME INVOICE_ADDRESS_NAME
, DELIVER_TO_CUSTOMER DELIVER_TO_CUSTOMER
, SERVICED_LINE_ID SERVICED_LINE_ID
, SERVICE_REFERENCE_ORDER SERVICE_REFERENCE_ORDER
, SERVICE_REFERENCE_LINE SERVICE_REFERENCE_LINE
, SERVICE_REFERENCE_SYSTEM SERVICE_REFERENCE_SYSTEM
, TP_CONTEXT TP_CONTEXT
, TP_ATTRIBUTE1 TP_ATTRIBUTE1
, TP_ATTRIBUTE2 TP_ATTRIBUTE2
, TP_ATTRIBUTE3 TP_ATTRIBUTE3
, TP_ATTRIBUTE4 TP_ATTRIBUTE4
, TP_ATTRIBUTE5 TP_ATTRIBUTE5
, TP_ATTRIBUTE6 TP_ATTRIBUTE6
, TP_ATTRIBUTE7 TP_ATTRIBUTE7
, TP_ATTRIBUTE8 TP_ATTRIBUTE8
, TP_ATTRIBUTE9 TP_ATTRIBUTE9
, TP_ATTRIBUTE10 TP_ATTRIBUTE10
, TP_ATTRIBUTE11 TP_ATTRIBUTE11
, TP_ATTRIBUTE12 TP_ATTRIBUTE12
, TP_ATTRIBUTE13 TP_ATTRIBUTE13
, TP_ATTRIBUTE14 TP_ATTRIBUTE14
, TP_ATTRIBUTE15 TP_ATTRIBUTE15
, SPLIT_FROM_SHIPMENT_REF SPLIT_FROM_SHIPMENT_REF
, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, INVOICE_TO_CUSTOMER_ID INVOICE_TO_CUSTOMER_ID
, DELIVER_TO_CUSTOMER_ID DELIVER_TO_CUSTOMER_ID
, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME
, SHIP_TO_CUSTOMER_NUMBER SHIP_TO_CUSTOMER_NUMBER
, INVOICE_TO_CUSTOMER_NAME INVOICE_TO_CUSTOMER_NAME
, INVOICE_TO_CUSTOMER_NUMBER INVOICE_TO_CUSTOMER_NUMBER
, DELIVER_TO_CUSTOMER_NAME DELIVER_TO_CUSTOMER_NAME
, DELIVER_TO_CUSTOMER_NUMBER DELIVER_TO_CUSTOMER_NUMBER
, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ACKNOWLEDGMENT_TYPE ACKNOWLEDGMENT_TYPE
, USER_ITEM_DESCRIPTION USER_ITEM_DESCRIPTION
, BLANKET_NUMBER BLANKET_NUMBER
, BLANKET_LINE_NUMBER BLANKET_LINE_NUMBER
, ORIGINAL_INVENTORY_ITEM_ID ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ORDERED_ITEM_ID ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM ORIGINAL_ORDERED_ITEM
, ORDERED_ITEM ORDERED_ITEM
, INVOICE_INTERFACE_STATUS_CODE INVOICE_INTERFACE_STATUS_CODE
, PREFERRED_GRADE PREFERRED_GRADE
, ORDERED_QUANTITY2 ORDERED_QUANTITY2
, ORDERED_QUANTITY_UOM2 ORDERED_QUANTITY_UOM2
, SHIPPING_QUANTITY2 SHIPPING_QUANTITY2
, CANCELLED_QUANTITY2 CANCELLED_QUANTITY2
, SHIPPED_QUANTITY2 SHIPPED_QUANTITY2
, SHIPPING_QUANTITY_UOM2 SHIPPING_QUANTITY_UOM2
, FULFILLED_QUANTITY2 FULFILLED_QUANTITY2
, REVENUE_AMOUNT REVENUE_AMOUNT
, FULFILLMENT_DATE FULFILLMENT_DATE
, ORIGINAL_ITEM_IDENTIFIER_TYPE ORIGINAL_ITEM_IDENTIFIER_TYPE
, ITEM_SUBSTITUTION_TYPE_CODE ITEM_SUBSTITUTION_TYPE_CODE
, AUTO_SELECTED_QUANTITY AUTO_SELECTED_QUANTITY
, ORDERED_ITEM_ID ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE ITEM_IDENTIFIER_TYPE
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, INVOICED_QUANTITY INVOICED_QUANTITY
, REFERENCE_CUSTOMER_TRX_LINE_ID REFERENCE_CUSTOMER_TRX_LINE_ID
, SPLIT_BY SPLIT_BY
, LINE_SET_ID LINE_SET_ID
, UNIT_LIST_PERCENT UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE
, RE_SOURCE_FLAG RE_SOURCE_FLAG
, FLOW_STATUS_CODE FLOW_STATUS_CODE
, UNIT_LIST_PRICE_PER_PQTY UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE_PQTY UNIT_SELLING_PRICE_PQTY
, ITEM_RELATIONSHIP_TYPE ITEM_RELATIONSHIP_TYPE
, UNIT_SELLING_PRICE_PER_PQTY UNIT_SELLING_PRICE_PER_PQTY
, SHIP_TO_PARTY_NUMBER SHIP_TO_PARTY_NUMBER
, INVOICE_TO_PARTY_NUMBER INVOICE_TO_PARTY_NUMBER
, DELIVER_TO_PARTY_NUMBER DELIVER_TO_PARTY_NUMBER
, END_CUSTOMER_NUMBER END_CUSTOMER_NUMBER
, END_CUSTOMER_PARTY_NUMBER END_CUSTOMER_PARTY_NUMBER
, END_CUSTOMER_ID END_CUSTOMER_ID
, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID
, END_CUSTOMER_ADDRESS1 END_CUSTOMER_ADDRESS1
, END_CUSTOMER_ADDRESS2 END_CUSTOMER_ADDRESS2
, END_CUSTOMER_ADDRESS3 END_CUSTOMER_ADDRESS3
, END_CUSTOMER_ADDRESS4 END_CUSTOMER_ADDRESS4
, END_CUSTOMER_CITY END_CUSTOMER_CITY
, END_CUSTOMER_POSTAL_CODE END_CUSTOMER_POSTAL_CODE
, END_CUSTOMER_COUNTRY END_CUSTOMER_COUNTRY
, END_CUSTOMER_STATE END_CUSTOMER_STATE
, END_CUSTOMER_COUNTY END_CUSTOMER_COUNTY
, END_CUSTOMER_PROVINCE END_CUSTOMER_PROVINCE
, END_CUSTOMER_CONTACT END_CUSTOMER_CONTACT
, END_CUSTOMER_CONTACT_LAST_NAME END_CUSTOMER_CONTACT_LAST_NAME
, END_CUSTOMER_CONTACT_FIRST_NAM END_CUSTOMER_CONTACT_FIRST_NAM
, END_CUSTOMER_NAME END_CUSTOMER_NAME
, IB_OWNER IB_OWNER
, IB_CURRENT_LOCATION IB_CURRENT_LOCATION
, IB_INSTALLED_AT_LOCATION IB_INSTALLED_AT_LOCATION
, ORDER_FIRMED_DATE ORDER_FIRMED_DATE
, ACTUAL_FULFILLMENT_DATE ACTUAL_FULFILLMENT_DATE
, COMMITMENT COMMITMENT
, CUSTOMER_PAYMENT_TERM CUSTOMER_PAYMENT_TERM
, DELIVER_TO_ADDRESS1 DELIVER_TO_ADDRESS1
, DELIVER_TO_ADDRESS2 DELIVER_TO_ADDRESS2
, DELIVER_TO_ADDRESS3 DELIVER_TO_ADDRESS3
, DELIVER_TO_ADDRESS4 DELIVER_TO_ADDRESS4
, DELIVER_TO_CITY DELIVER_TO_CITY
, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY
, DELIVER_TO_COUNTY DELIVER_TO_COUNTY
, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE
, DELIVER_TO_PROVINCE DELIVER_TO_PROVINCE
, DELIVER_TO_STATE DELIVER_TO_STATE
, INVOICE_ADDRESS_1 INVOICE_ADDRESS_1
, INVOICE_ADDRESS_2 INVOICE_ADDRESS_2
, INVOICE_ADDRESS_3 INVOICE_ADDRESS_3
, INVOICE_ADDRESS_4 INVOICE_ADDRESS_4
, INVOICE_COUNTRY INVOICE_COUNTRY
, INVOICE_COUNTY INVOICE_COUNTY
, INVOICE_POSTAL_CODE INVOICE_POSTAL_CODE
, INVOICE_STATE INVOICE_STATE
, IB_OWNER_CODE IB_OWNER_CODE
, IB_INSTALLED_AT_LOCATION_CODE IB_INSTALLED_AT_LOCATION_CODE
, IB_CURRENT_LOCATION_CODE IB_CURRENT_LOCATION_CODE
, CHARGE_PERIODICITY_CODE CHARGE_PERIODICITY_CODE
, CONFIG_HEADER_ID CONFIG_HEADER_ID
, CONFIG_REV_NBR CONFIG_REV_NBR
, INST_ID INST_ID
, SERVICE_BILL_PROFILE_ID SERVICE_BILL_PROFILE_ID
, SERVICE_BILLING_PROFILE SERVICE_BILLING_PROFILE
, SERVICE_COV_TEMPLATE_ID SERVICE_COV_TEMPLATE_ID
, SERVICE_COVERAGE_TEMPLATE SERVICE_COVERAGE_TEMPLATE
, SERVICE_SUBS_TEMPLATE_ID SERVICE_SUBS_TEMPLATE_ID
, SERVICE_SUBSCRIPTION_TEMPLATE SERVICE_SUBSCRIPTION_TEMPLATE
, SERVICE_BILL_OPTION_CODE SERVICE_BILL_OPTION_CODE
, SERVICE_BILL_OPTION SERVICE_BILL_OPTION
, SERVICE_FIRST_PERIOD_AMOUNT SERVICE_FIRST_PERIOD_AMOUNT
, SERVICE_FIRST_PERIOD_ENDDATE SERVICE_FIRST_PERIOD_ENDDATE
, SUBSCRIPTION_ENABLE_FLAG SUBSCRIPTION_ENABLE_FLAG
FROM "ONT"."OE_LINE_ACKS"