VIEW: RLM.RLM_INTERFACE_LINES_ALL#

Source

View Text - Preformatted

select LINE_ID LINE_ID, HEADER_ID HEADER_ID, AGREEMENT_ID AGREEMENT_ID, ATO_DATA_TYPE ATO_DATA_TYPE, BILL_TO_ADDRESS_1_EXT BILL_TO_ADDRESS_1_EXT, BILL_TO_ADDRESS_2_EXT BILL_TO_ADDRESS_2_EXT, BILL_TO_ADDRESS_3_EXT BILL_TO_ADDRESS_3_EXT, BILL_TO_ADDRESS_4_EXT BILL_TO_ADDRESS_4_EXT, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, BILL_TO_CITY_EXT BILL_TO_CITY_EXT, BILL_TO_COUNTRY_EXT BILL_TO_COUNTRY_EXT, BILL_TO_COUNTY_EXT BILL_TO_COUNTY_EXT, BILL_TO_NAME_EXT BILL_TO_NAME_EXT, BILL_TO_POSTAL_CD_EXT BILL_TO_POSTAL_CD_EXT, BILL_TO_PROVINCE_EXT BILL_TO_PROVINCE_EXT, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, BILL_TO_STATE_EXT BILL_TO_STATE_EXT, CARRIER_ID_CODE_EXT CARRIER_ID_CODE_EXT, CARRIER_QUALIFIER_EXT CARRIER_QUALIFIER_EXT, COMMODITY_EXT COMMODITY_EXT, COUNTRY_OF_ORIGIN_EXT COUNTRY_OF_ORIGIN_EXT, CUST_ASSEMBLY_EXT CUST_ASSEMBLY_EXT, CUST_ASSIGNED_ID_EXT CUST_ASSIGNED_ID_EXT, CUST_BILL_TO_EXT CUST_BILL_TO_EXT, CUST_CONTRACT_NUM_EXT CUST_CONTRACT_NUM_EXT, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE, CUST_INTRMD_SHIP_TO_EXT CUST_INTRMD_SHIP_TO_EXT, CUST_ITEM_PRICE_EXT CUST_ITEM_PRICE_EXT, CUST_ITEM_PRICE_UOM_EXT CUST_ITEM_PRICE_UOM_EXT, CUSTOMER_ITEM_REVISION CUSTOMER_ITEM_REVISION, CUSTOMER_JOB CUSTOMER_JOB, CUST_MANUFACTURER_EXT CUST_MANUFACTURER_EXT, CUST_MODEL_NUMBER_EXT CUST_MODEL_NUMBER_EXT, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER, CUST_ORDER_NUM_EXT CUST_ORDER_NUM_EXT, CUST_PROCESS_NUM_EXT CUST_PROCESS_NUM_EXT, CUST_PRODUCTION_LINE CUST_PRODUCTION_LINE, CUST_PRODUCTION_SEQ_NUM CUST_PRODUCTION_SEQ_NUM, CUST_SET_NUM_EXT CUST_SET_NUM_EXT, CUST_SHIP_FROM_ORG_EXT CUST_SHIP_FROM_ORG_EXT, CUST_SHIP_TO_EXT CUST_SHIP_TO_EXT, CUST_UOM_EXT CUST_UOM_EXT, CUSTOMER_ITEM_EXT CUSTOMER_ITEM_EXT, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID, REQUEST_DATE REQUEST_DATE, SCHEDULE_DATE SCHEDULE_DATE, DATE_TYPE_CODE DATE_TYPE_CODE, DATE_TYPE_CODE_EXT DATE_TYPE_CODE_EXT, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME, END_DATE_TIME END_DATE_TIME, EQUIPMENT_CODE_EXT EQUIPMENT_CODE_EXT, EQUIPMENT_NUMBER_EXT EQUIPMENT_NUMBER_EXT, HANDLING_CODE_EXT HANDLING_CODE_EXT, HAZARD_CODE_EXT HAZARD_CODE_EXT, HAZARD_CODE_QUAL_EXT HAZARD_CODE_QUAL_EXT, HAZARD_DESCRIPTION_EXT HAZARD_DESCRIPTION_EXT, IMPORT_LICENSE_DATE_EXT IMPORT_LICENSE_DATE_EXT, IMPORT_LICENSE_EXT IMPORT_LICENSE_EXT, 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_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_CONTEXT INDUSTRY_CONTEXT, INTRMD_SHIP_TO_ID INTRMD_SHIP_TO_ID, SHIP_TO_ORG_ID SHIP_TO_ORG_ID, INTRMD_ST_ADDRESS_1_EXT INTRMD_ST_ADDRESS_1_EXT, INTRMD_ST_ADDRESS_2_EXT INTRMD_ST_ADDRESS_2_EXT, INTRMD_ST_ADDRESS_3_EXT INTRMD_ST_ADDRESS_3_EXT, INTRMD_ST_ADDRESS_4_EXT INTRMD_ST_ADDRESS_4_EXT, INTRMD_ST_CITY_EXT INTRMD_ST_CITY_EXT, INTRMD_ST_COUNTRY_EXT INTRMD_ST_COUNTRY_EXT, INTRMD_ST_COUNTY_EXT INTRMD_ST_COUNTY_EXT, INTRMD_ST_NAME_EXT INTRMD_ST_NAME_EXT, INTRMD_ST_POSTAL_CD_EXT INTRMD_ST_POSTAL_CD_EXT, INTRMD_ST_PROVINCE_EXT INTRMD_ST_PROVINCE_EXT, INTRMD_ST_STATE_EXT INTRMD_ST_STATE_EXT, INTRMD_ST_SITE_USE_ID INTRMD_ST_SITE_USE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INVENTORY_ITEM_SEGMENT1 INVENTORY_ITEM_SEGMENT1, INVENTORY_ITEM_SEGMENT10 INVENTORY_ITEM_SEGMENT10, INVENTORY_ITEM_SEGMENT11 INVENTORY_ITEM_SEGMENT11, INVENTORY_ITEM_SEGMENT12 INVENTORY_ITEM_SEGMENT12, INVENTORY_ITEM_SEGMENT13 INVENTORY_ITEM_SEGMENT13, INVENTORY_ITEM_SEGMENT14 INVENTORY_ITEM_SEGMENT14, INVENTORY_ITEM_SEGMENT15 INVENTORY_ITEM_SEGMENT15, INVENTORY_ITEM_SEGMENT16 INVENTORY_ITEM_SEGMENT16, INVENTORY_ITEM_SEGMENT17 INVENTORY_ITEM_SEGMENT17, INVENTORY_ITEM_SEGMENT18 INVENTORY_ITEM_SEGMENT18, INVENTORY_ITEM_SEGMENT19 INVENTORY_ITEM_SEGMENT19, INVENTORY_ITEM_SEGMENT2 INVENTORY_ITEM_SEGMENT2, INVENTORY_ITEM_SEGMENT20 INVENTORY_ITEM_SEGMENT20, INVENTORY_ITEM_SEGMENT3 INVENTORY_ITEM_SEGMENT3, INVENTORY_ITEM_SEGMENT4 INVENTORY_ITEM_SEGMENT4, INVENTORY_ITEM_SEGMENT5 INVENTORY_ITEM_SEGMENT5, INVENTORY_ITEM_SEGMENT6 INVENTORY_ITEM_SEGMENT6, INVENTORY_ITEM_SEGMENT7 INVENTORY_ITEM_SEGMENT7, INVENTORY_ITEM_SEGMENT8 INVENTORY_ITEM_SEGMENT8, INVENTORY_ITEM_SEGMENT9 INVENTORY_ITEM_SEGMENT9, ITEM_CONTACT_CODE_1 ITEM_CONTACT_CODE_1, ITEM_CONTACT_CODE_2 ITEM_CONTACT_CODE_2, ITEM_CONTACT_VALUE_1 ITEM_CONTACT_VALUE_1, ITEM_CONTACT_VALUE_2 ITEM_CONTACT_VALUE_2, ITEM_DESCRIPTION_EXT ITEM_DESCRIPTION_EXT, ITEM_DETAIL_QUANTITY ITEM_DETAIL_QUANTITY, ITEM_DETAIL_REF_CODE_1 ITEM_DETAIL_REF_CODE_1, ITEM_DETAIL_REF_CODE_2 ITEM_DETAIL_REF_CODE_2, ITEM_DETAIL_REF_CODE_3 ITEM_DETAIL_REF_CODE_3, ITEM_DETAIL_REF_VALUE_1 ITEM_DETAIL_REF_VALUE_1, ITEM_DETAIL_REF_VALUE_2 ITEM_DETAIL_REF_VALUE_2, ITEM_DETAIL_REF_VALUE_3 ITEM_DETAIL_REF_VALUE_3, ITEM_DETAIL_SUBTYPE ITEM_DETAIL_SUBTYPE, ITEM_DETAIL_SUBTYPE_EXT ITEM_DETAIL_SUBTYPE_EXT, ITEM_DETAIL_TYPE ITEM_DETAIL_TYPE, ITEM_DETAIL_TYPE_EXT ITEM_DETAIL_TYPE_EXT, ITEM_ENG_CNG_LVL_EXT ITEM_ENG_CNG_LVL_EXT, ITEM_MEASUREMENTS_EXT ITEM_MEASUREMENTS_EXT, ITEM_NOTE_TEXT ITEM_NOTE_TEXT, ITEM_REF_CODE_1 ITEM_REF_CODE_1, ITEM_REF_CODE_2 ITEM_REF_CODE_2, ITEM_REF_CODE_3 ITEM_REF_CODE_3, ITEM_REF_VALUE_1 ITEM_REF_VALUE_1, ITEM_REF_VALUE_2 ITEM_REF_VALUE_2, ITEM_REF_VALUE_3 ITEM_REF_VALUE_3, ITEM_RELEASE_STATUS_EXT ITEM_RELEASE_STATUS_EXT, LADING_QUANTITY_EXT LADING_QUANTITY_EXT, LETTER_CREDIT_EXPDT_EXT LETTER_CREDIT_EXPDT_EXT, LETTER_CREDIT_EXT LETTER_CREDIT_EXT, LINE_REFERENCE LINE_REFERENCE, LINK_TO_LINE_REF LINK_TO_LINE_REF, ORDER_HEADER_ID ORDER_HEADER_ID, ORG_ID ORG_ID, OTHER_NAME_CODE_1 OTHER_NAME_CODE_1, OTHER_NAME_CODE_2 OTHER_NAME_CODE_2, OTHER_NAME_VALUE_1 OTHER_NAME_VALUE_1, OTHER_NAME_VALUE_2 OTHER_NAME_VALUE_2, PACK_SIZE_EXT PACK_SIZE_EXT, PACK_UNITS_PER_PACK_EXT PACK_UNITS_PER_PACK_EXT, PACK_UOM_CODE_EXT PACK_UOM_CODE_EXT, PACKAGING_CODE_EXT PACKAGING_CODE_EXT, PARENT_LINK_LINE_REF PARENT_LINK_LINE_REF, PRICE_LIST_ID PRICE_LIST_ID, PRIMARY_QUANTITY PRIMARY_QUANTITY, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, PRIME_CONTRCTR_PART_EXT PRIME_CONTRCTR_PART_EXT, PROCESS_STATUS PROCESS_STATUS, CUST_PO_RELEASE_NUM CUST_PO_RELEASE_NUM, CUST_PO_DATE CUST_PO_DATE, CUST_PO_LINE_NUM CUST_PO_LINE_NUM, CUST_PO_NUMBER CUST_PO_NUMBER, QTY_TYPE_CODE QTY_TYPE_CODE, QTY_TYPE_CODE_EXT QTY_TYPE_CODE_EXT, RETURN_CONTAINER_EXT RETURN_CONTAINER_EXT, SCHEDULE_LINE_ID SCHEDULE_LINE_ID, ROUTING_DESC_EXT ROUTING_DESC_EXT, ROUTING_SEQ_CODE_EXT ROUTING_SEQ_CODE_EXT, SCHEDULE_ITEM_NUM SCHEDULE_ITEM_NUM, SHIP_DEL_PATTERN_EXT SHIP_DEL_PATTERN_EXT, SHIP_DEL_TIME_CODE_EXT SHIP_DEL_TIME_CODE_EXT, SHIP_DEL_RULE_NAME SHIP_DEL_RULE_NAME, SHIP_FROM_ADDRESS_1_EXT SHIP_FROM_ADDRESS_1_EXT, SHIP_FROM_ADDRESS_2_EXT SHIP_FROM_ADDRESS_2_EXT, SHIP_FROM_ADDRESS_3_EXT SHIP_FROM_ADDRESS_3_EXT, SHIP_FROM_ADDRESS_4_EXT SHIP_FROM_ADDRESS_4_EXT, SHIP_FROM_CITY_EXT SHIP_FROM_CITY_EXT, SHIP_FROM_COUNTRY_EXT SHIP_FROM_COUNTRY_EXT, SHIP_FROM_COUNTY_EXT SHIP_FROM_COUNTY_EXT, SHIP_FROM_NAME_EXT SHIP_FROM_NAME_EXT, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, SHIP_FROM_POSTAL_CD_EXT SHIP_FROM_POSTAL_CD_EXT, SHIP_FROM_PROVINCE_EXT SHIP_FROM_PROVINCE_EXT, SHIP_FROM_STATE_EXT SHIP_FROM_STATE_EXT, SHIP_LABEL_INFO_LINE_1 SHIP_LABEL_INFO_LINE_1, SHIP_LABEL_INFO_LINE_10 SHIP_LABEL_INFO_LINE_10, SHIP_LABEL_INFO_LINE_2 SHIP_LABEL_INFO_LINE_2, SHIP_LABEL_INFO_LINE_3 SHIP_LABEL_INFO_LINE_3, SHIP_LABEL_INFO_LINE_4 SHIP_LABEL_INFO_LINE_4, SHIP_LABEL_INFO_LINE_5 SHIP_LABEL_INFO_LINE_5, SHIP_LABEL_INFO_LINE_6 SHIP_LABEL_INFO_LINE_6, SHIP_LABEL_INFO_LINE_7 SHIP_LABEL_INFO_LINE_7, SHIP_LABEL_INFO_LINE_8 SHIP_LABEL_INFO_LINE_8, SHIP_LABEL_INFO_LINE_9 SHIP_LABEL_INFO_LINE_9, SHIP_TO_ADDRESS_1_EXT SHIP_TO_ADDRESS_1_EXT, SHIP_TO_ADDRESS_2_EXT SHIP_TO_ADDRESS_2_EXT, SHIP_TO_ADDRESS_3_EXT SHIP_TO_ADDRESS_3_EXT, SHIP_TO_ADDRESS_4_EXT SHIP_TO_ADDRESS_4_EXT, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID, SHIP_TO_CITY_EXT SHIP_TO_CITY_EXT, SHIP_TO_COUNTRY_EXT SHIP_TO_COUNTRY_EXT, SHIP_TO_COUNTY_EXT SHIP_TO_COUNTY_EXT, SHIP_TO_NAME_EXT SHIP_TO_NAME_EXT, SHIP_TO_POSTAL_CD_EXT SHIP_TO_POSTAL_CD_EXT, SHIP_TO_PROVINCE_EXT SHIP_TO_PROVINCE_EXT, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, SHIP_TO_STATE_EXT SHIP_TO_STATE_EXT, START_DATE_TIME START_DATE_TIME, SUBLINE_ASSIGNED_ID_EXT SUBLINE_ASSIGNED_ID_EXT, SUBLINE_CONFIG_CODE_EXT SUBLINE_CONFIG_CODE_EXT, SUBLINE_CUST_ITEM_EXT SUBLINE_CUST_ITEM_EXT, SUBLINE_CUST_ITEM_ID SUBLINE_CUST_ITEM_ID, SUBLINE_MODEL_NUM_EXT SUBLINE_MODEL_NUM_EXT, SUBLINE_QUANTITY SUBLINE_QUANTITY, SUBLINE_UOM_CODE SUBLINE_UOM_CODE, SUPPLIER_ITEM_EXT SUPPLIER_ITEM_EXT, TRANSIT_TIME_EXT TRANSIT_TIME_EXT, TRANSIT_TIME_QUAL_EXT TRANSIT_TIME_QUAL_EXT, TRANSPORT_LOC_QUAL_EXT TRANSPORT_LOC_QUAL_EXT, TRANSPORT_LOCATION_EXT TRANSPORT_LOCATION_EXT, TRANSPORT_METHOD_EXT TRANSPORT_METHOD_EXT, UOM_CODE UOM_CODE, WEIGHT_EXT WEIGHT_EXT, WEIGHT_QUALIFIER_EXT WEIGHT_QUALIFIER_EXT, WEIGHT_UOM_EXT WEIGHT_UOM_EXT, FBO_CONFIGURATION_KEY_1 FBO_CONFIGURATION_KEY_1, FBO_CONFIGURATION_KEY_2 FBO_CONFIGURATION_KEY_2, FBO_CONFIGURATION_KEY_3 FBO_CONFIGURATION_KEY_3, FBO_CONFIGURATION_KEY_4 FBO_CONFIGURATION_KEY_4, FBO_CONFIGURATION_KEY_5 FBO_CONFIGURATION_KEY_5, MATCH_KEY_ACROSS MATCH_KEY_ACROSS, MATCH_KEY_WITHIN MATCH_KEY_WITHIN, CRITICAL_KEY_ATTRIBUTES CRITICAL_KEY_ATTRIBUTES, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, 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, 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, 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, TP_ATTRIBUTE_CATEGORY TP_ATTRIBUTE_CATEGORY, LINE_NUMBER LINE_NUMBER, INTMED_SHIP_TO_ORG_ID INTMED_SHIP_TO_ORG_ID, LINE_SOURCE LINE_SOURCE, PREFERRED_GRADE PREFERRED_GRADE, CUST_PRODUCTION_SEQ_NUM_BEG CUST_PRODUCTION_SEQ_NUM_BEG, CUST_PRODUCTION_SEQ_NUM_END CUST_PRODUCTION_SEQ_NUM_END, ITEM_DETAIL_QUANTITY_MIN_EXT ITEM_DETAIL_QUANTITY_MIN_EXT, ITEM_DETAIL_QUANTITY_MAX_EXT ITEM_DETAIL_QUANTITY_MAX_EXT, ITEM_DETAIL_QUANTITY_PRIOR_EXT ITEM_DETAIL_QUANTITY_PRIOR_EXT, REQUIREMENT_PRIORITY_EXT REQUIREMENT_PRIORITY_EXT, PROJECT_NUMBER_EXT PROJECT_NUMBER_EXT, RESP_LINE_NUMBER RESP_LINE_NUMBER, TASK_NUMBER_EXT TASK_NUMBER_EXT, UPC_EXT UPC_EXT, ITEM_ENG_CNG_LVL_DATE_EXT ITEM_ENG_CNG_LVL_DATE_EXT, AUTHORIZATION_CODE_EXT AUTHORIZATION_CODE_EXT, PACKAGING_DESC_EXT PACKAGING_DESC_EXT, BILL_TO_ADDRESS_5_EXT BILL_TO_ADDRESS_5_EXT, BILL_TO_ADDRESS_6_EXT BILL_TO_ADDRESS_6_EXT, BILL_TO_ADDRESS_7_EXT BILL_TO_ADDRESS_7_EXT, BILL_TO_ADDRESS_8_EXT BILL_TO_ADDRESS_8_EXT, BILL_TO_ADDRESS_9_EXT BILL_TO_ADDRESS_9_EXT, ONE_TIME_BILL_TO_FLAG_EXT ONE_TIME_BILL_TO_FLAG_EXT, BILL_TO_DESCRIPTION_EXT BILL_TO_DESCRIPTION_EXT, BILL_TO_FAX_EXT BILL_TO_FAX_EXT, BILL_TO_REGION_EXT BILL_TO_REGION_EXT, BILL_TO_JURISDICTION_EXT BILL_TO_JURISDICTION_EXT, BILL_TO_TEL_EXT BILL_TO_TEL_EXT, INTRMD_ST_ADDRESS_5_EXT INTRMD_ST_ADDRESS_5_EXT, INTRMD_ST_ADDRESS_6_EXT INTRMD_ST_ADDRESS_6_EXT, INTRMD_ST_ADDRESS_7_EXT INTRMD_ST_ADDRESS_7_EXT, INTRMD_ST_ADDRESS_8_EXT INTRMD_ST_ADDRESS_8_EXT, INTRMD_ST_ADDRESS_9_EXT INTRMD_ST_ADDRESS_9_EXT, ONE_TIME_INTRMD_ST_FLAG_EXT ONE_TIME_INTRMD_ST_FLAG_EXT, INTRMD_ST_DESCRIPTION_EXT INTRMD_ST_DESCRIPTION_EXT, INTRMD_ST_FAX_EXT INTRMD_ST_FAX_EXT, INTRMD_ST_REGION_EXT INTRMD_ST_REGION_EXT, INTRMD_ST_JURISDICTION_EXT INTRMD_ST_JURISDICTION_EXT, INTRMD_ST_TEL_EXT INTRMD_ST_TEL_EXT, SHIP_TO_ADDRESS_5_EXT SHIP_TO_ADDRESS_5_EXT, SHIP_TO_ADDRESS_6_EXT SHIP_TO_ADDRESS_6_EXT, SHIP_TO_ADDRESS_7_EXT SHIP_TO_ADDRESS_7_EXT, SHIP_TO_ADDRESS_8_EXT SHIP_TO_ADDRESS_8_EXT, SHIP_TO_ADDRESS_9_EXT SHIP_TO_ADDRESS_9_EXT, ONE_TIME_SHIP_TO_FLAG_EXT ONE_TIME_SHIP_TO_FLAG_EXT, SHIP_TO_DESCRIPTION_EXT SHIP_TO_DESCRIPTION_EXT, SHIP_TO_FAX_EXT SHIP_TO_FAX_EXT, SHIP_TO_REGION_EXT SHIP_TO_REGION_EXT, SHIP_TO_JURISDICTION_EXT SHIP_TO_JURISDICTION_EXT, SHIP_TO_TEL_EXT SHIP_TO_TEL_EXT, SHIP_FROM_ADDRESS_5_EXT SHIP_FROM_ADDRESS_5_EXT, SHIP_FROM_ADDRESS_6_EXT SHIP_FROM_ADDRESS_6_EXT, SHIP_FROM_ADDRESS_7_EXT SHIP_FROM_ADDRESS_7_EXT, SHIP_FROM_ADDRESS_8_EXT SHIP_FROM_ADDRESS_8_EXT, SHIP_FROM_ADDRESS_9_EXT SHIP_FROM_ADDRESS_9_EXT, ONE_TIME_SHIP_FROM_FLAG_EXT ONE_TIME_SHIP_FROM_FLAG_EXT, SHIP_FROM_DESCRIPTION_EXT SHIP_FROM_DESCRIPTION_EXT, SHIP_FROM_FAX_EXT SHIP_FROM_FAX_EXT, SHIP_FROM_REGION_EXT SHIP_FROM_REGION_EXT, SHIP_FROM_JURISDICTION_EXT SHIP_FROM_JURISDICTION_EXT, SHIP_FROM_TEL_EXT SHIP_FROM_TEL_EXT, FLEX_BKT_CODE FLEX_BKT_CODE, FLEX_BKT_FLAG FLEX_BKT_FLAG, BLANKET_NUMBER BLANKET_NUMBER, DSP_CHILD_PROCESS_INDEX DSP_CHILD_PROCESS_INDEX, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID from "RLM"."RLM_INTERFACE_LINES_ALL"

View Text - HTML Formatted

SELECT LINE_ID LINE_ID
, HEADER_ID HEADER_ID
, AGREEMENT_ID AGREEMENT_ID
, ATO_DATA_TYPE ATO_DATA_TYPE
, BILL_TO_ADDRESS_1_EXT BILL_TO_ADDRESS_1_EXT
, BILL_TO_ADDRESS_2_EXT BILL_TO_ADDRESS_2_EXT
, BILL_TO_ADDRESS_3_EXT BILL_TO_ADDRESS_3_EXT
, BILL_TO_ADDRESS_4_EXT BILL_TO_ADDRESS_4_EXT
, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID
, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, BILL_TO_CITY_EXT BILL_TO_CITY_EXT
, BILL_TO_COUNTRY_EXT BILL_TO_COUNTRY_EXT
, BILL_TO_COUNTY_EXT BILL_TO_COUNTY_EXT
, BILL_TO_NAME_EXT BILL_TO_NAME_EXT
, BILL_TO_POSTAL_CD_EXT BILL_TO_POSTAL_CD_EXT
, BILL_TO_PROVINCE_EXT BILL_TO_PROVINCE_EXT
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, BILL_TO_STATE_EXT BILL_TO_STATE_EXT
, CARRIER_ID_CODE_EXT CARRIER_ID_CODE_EXT
, CARRIER_QUALIFIER_EXT CARRIER_QUALIFIER_EXT
, COMMODITY_EXT COMMODITY_EXT
, COUNTRY_OF_ORIGIN_EXT COUNTRY_OF_ORIGIN_EXT
, CUST_ASSEMBLY_EXT CUST_ASSEMBLY_EXT
, CUST_ASSIGNED_ID_EXT CUST_ASSIGNED_ID_EXT
, CUST_BILL_TO_EXT CUST_BILL_TO_EXT
, CUST_CONTRACT_NUM_EXT CUST_CONTRACT_NUM_EXT
, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE
, CUST_INTRMD_SHIP_TO_EXT CUST_INTRMD_SHIP_TO_EXT
, CUST_ITEM_PRICE_EXT CUST_ITEM_PRICE_EXT
, CUST_ITEM_PRICE_UOM_EXT CUST_ITEM_PRICE_UOM_EXT
, CUSTOMER_ITEM_REVISION CUSTOMER_ITEM_REVISION
, CUSTOMER_JOB CUSTOMER_JOB
, CUST_MANUFACTURER_EXT CUST_MANUFACTURER_EXT
, CUST_MODEL_NUMBER_EXT CUST_MODEL_NUMBER_EXT
, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER
, CUST_ORDER_NUM_EXT CUST_ORDER_NUM_EXT
, CUST_PROCESS_NUM_EXT CUST_PROCESS_NUM_EXT
, CUST_PRODUCTION_LINE CUST_PRODUCTION_LINE
, CUST_PRODUCTION_SEQ_NUM CUST_PRODUCTION_SEQ_NUM
, CUST_SET_NUM_EXT CUST_SET_NUM_EXT
, CUST_SHIP_FROM_ORG_EXT CUST_SHIP_FROM_ORG_EXT
, CUST_SHIP_TO_EXT CUST_SHIP_TO_EXT
, CUST_UOM_EXT CUST_UOM_EXT
, CUSTOMER_ITEM_EXT CUSTOMER_ITEM_EXT
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, REQUEST_DATE REQUEST_DATE
, SCHEDULE_DATE SCHEDULE_DATE
, DATE_TYPE_CODE DATE_TYPE_CODE
, DATE_TYPE_CODE_EXT DATE_TYPE_CODE_EXT
, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME
, END_DATE_TIME END_DATE_TIME
, EQUIPMENT_CODE_EXT EQUIPMENT_CODE_EXT
, EQUIPMENT_NUMBER_EXT EQUIPMENT_NUMBER_EXT
, HANDLING_CODE_EXT HANDLING_CODE_EXT
, HAZARD_CODE_EXT HAZARD_CODE_EXT
, HAZARD_CODE_QUAL_EXT HAZARD_CODE_QUAL_EXT
, HAZARD_DESCRIPTION_EXT HAZARD_DESCRIPTION_EXT
, IMPORT_LICENSE_DATE_EXT IMPORT_LICENSE_DATE_EXT
, IMPORT_LICENSE_EXT IMPORT_LICENSE_EXT
, 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_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_CONTEXT INDUSTRY_CONTEXT
, INTRMD_SHIP_TO_ID INTRMD_SHIP_TO_ID
, SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, INTRMD_ST_ADDRESS_1_EXT INTRMD_ST_ADDRESS_1_EXT
, INTRMD_ST_ADDRESS_2_EXT INTRMD_ST_ADDRESS_2_EXT
, INTRMD_ST_ADDRESS_3_EXT INTRMD_ST_ADDRESS_3_EXT
, INTRMD_ST_ADDRESS_4_EXT INTRMD_ST_ADDRESS_4_EXT
, INTRMD_ST_CITY_EXT INTRMD_ST_CITY_EXT
, INTRMD_ST_COUNTRY_EXT INTRMD_ST_COUNTRY_EXT
, INTRMD_ST_COUNTY_EXT INTRMD_ST_COUNTY_EXT
, INTRMD_ST_NAME_EXT INTRMD_ST_NAME_EXT
, INTRMD_ST_POSTAL_CD_EXT INTRMD_ST_POSTAL_CD_EXT
, INTRMD_ST_PROVINCE_EXT INTRMD_ST_PROVINCE_EXT
, INTRMD_ST_STATE_EXT INTRMD_ST_STATE_EXT
, INTRMD_ST_SITE_USE_ID INTRMD_ST_SITE_USE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INVENTORY_ITEM_SEGMENT1 INVENTORY_ITEM_SEGMENT1
, INVENTORY_ITEM_SEGMENT10 INVENTORY_ITEM_SEGMENT10
, INVENTORY_ITEM_SEGMENT11 INVENTORY_ITEM_SEGMENT11
, INVENTORY_ITEM_SEGMENT12 INVENTORY_ITEM_SEGMENT12
, INVENTORY_ITEM_SEGMENT13 INVENTORY_ITEM_SEGMENT13
, INVENTORY_ITEM_SEGMENT14 INVENTORY_ITEM_SEGMENT14
, INVENTORY_ITEM_SEGMENT15 INVENTORY_ITEM_SEGMENT15
, INVENTORY_ITEM_SEGMENT16 INVENTORY_ITEM_SEGMENT16
, INVENTORY_ITEM_SEGMENT17 INVENTORY_ITEM_SEGMENT17
, INVENTORY_ITEM_SEGMENT18 INVENTORY_ITEM_SEGMENT18
, INVENTORY_ITEM_SEGMENT19 INVENTORY_ITEM_SEGMENT19
, INVENTORY_ITEM_SEGMENT2 INVENTORY_ITEM_SEGMENT2
, INVENTORY_ITEM_SEGMENT20 INVENTORY_ITEM_SEGMENT20
, INVENTORY_ITEM_SEGMENT3 INVENTORY_ITEM_SEGMENT3
, INVENTORY_ITEM_SEGMENT4 INVENTORY_ITEM_SEGMENT4
, INVENTORY_ITEM_SEGMENT5 INVENTORY_ITEM_SEGMENT5
, INVENTORY_ITEM_SEGMENT6 INVENTORY_ITEM_SEGMENT6
, INVENTORY_ITEM_SEGMENT7 INVENTORY_ITEM_SEGMENT7
, INVENTORY_ITEM_SEGMENT8 INVENTORY_ITEM_SEGMENT8
, INVENTORY_ITEM_SEGMENT9 INVENTORY_ITEM_SEGMENT9
, ITEM_CONTACT_CODE_1 ITEM_CONTACT_CODE_1
, ITEM_CONTACT_CODE_2 ITEM_CONTACT_CODE_2
, ITEM_CONTACT_VALUE_1 ITEM_CONTACT_VALUE_1
, ITEM_CONTACT_VALUE_2 ITEM_CONTACT_VALUE_2
, ITEM_DESCRIPTION_EXT ITEM_DESCRIPTION_EXT
, ITEM_DETAIL_QUANTITY ITEM_DETAIL_QUANTITY
, ITEM_DETAIL_REF_CODE_1 ITEM_DETAIL_REF_CODE_1
, ITEM_DETAIL_REF_CODE_2 ITEM_DETAIL_REF_CODE_2
, ITEM_DETAIL_REF_CODE_3 ITEM_DETAIL_REF_CODE_3
, ITEM_DETAIL_REF_VALUE_1 ITEM_DETAIL_REF_VALUE_1
, ITEM_DETAIL_REF_VALUE_2 ITEM_DETAIL_REF_VALUE_2
, ITEM_DETAIL_REF_VALUE_3 ITEM_DETAIL_REF_VALUE_3
, ITEM_DETAIL_SUBTYPE ITEM_DETAIL_SUBTYPE
, ITEM_DETAIL_SUBTYPE_EXT ITEM_DETAIL_SUBTYPE_EXT
, ITEM_DETAIL_TYPE ITEM_DETAIL_TYPE
, ITEM_DETAIL_TYPE_EXT ITEM_DETAIL_TYPE_EXT
, ITEM_ENG_CNG_LVL_EXT ITEM_ENG_CNG_LVL_EXT
, ITEM_MEASUREMENTS_EXT ITEM_MEASUREMENTS_EXT
, ITEM_NOTE_TEXT ITEM_NOTE_TEXT
, ITEM_REF_CODE_1 ITEM_REF_CODE_1
, ITEM_REF_CODE_2 ITEM_REF_CODE_2
, ITEM_REF_CODE_3 ITEM_REF_CODE_3
, ITEM_REF_VALUE_1 ITEM_REF_VALUE_1
, ITEM_REF_VALUE_2 ITEM_REF_VALUE_2
, ITEM_REF_VALUE_3 ITEM_REF_VALUE_3
, ITEM_RELEASE_STATUS_EXT ITEM_RELEASE_STATUS_EXT
, LADING_QUANTITY_EXT LADING_QUANTITY_EXT
, LETTER_CREDIT_EXPDT_EXT LETTER_CREDIT_EXPDT_EXT
, LETTER_CREDIT_EXT LETTER_CREDIT_EXT
, LINE_REFERENCE LINE_REFERENCE
, LINK_TO_LINE_REF LINK_TO_LINE_REF
, ORDER_HEADER_ID ORDER_HEADER_ID
, ORG_ID ORG_ID
, OTHER_NAME_CODE_1 OTHER_NAME_CODE_1
, OTHER_NAME_CODE_2 OTHER_NAME_CODE_2
, OTHER_NAME_VALUE_1 OTHER_NAME_VALUE_1
, OTHER_NAME_VALUE_2 OTHER_NAME_VALUE_2
, PACK_SIZE_EXT PACK_SIZE_EXT
, PACK_UNITS_PER_PACK_EXT PACK_UNITS_PER_PACK_EXT
, PACK_UOM_CODE_EXT PACK_UOM_CODE_EXT
, PACKAGING_CODE_EXT PACKAGING_CODE_EXT
, PARENT_LINK_LINE_REF PARENT_LINK_LINE_REF
, PRICE_LIST_ID PRICE_LIST_ID
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, PRIME_CONTRCTR_PART_EXT PRIME_CONTRCTR_PART_EXT
, PROCESS_STATUS PROCESS_STATUS
, CUST_PO_RELEASE_NUM CUST_PO_RELEASE_NUM
, CUST_PO_DATE CUST_PO_DATE
, CUST_PO_LINE_NUM CUST_PO_LINE_NUM
, CUST_PO_NUMBER CUST_PO_NUMBER
, QTY_TYPE_CODE QTY_TYPE_CODE
, QTY_TYPE_CODE_EXT QTY_TYPE_CODE_EXT
, RETURN_CONTAINER_EXT RETURN_CONTAINER_EXT
, SCHEDULE_LINE_ID SCHEDULE_LINE_ID
, ROUTING_DESC_EXT ROUTING_DESC_EXT
, ROUTING_SEQ_CODE_EXT ROUTING_SEQ_CODE_EXT
, SCHEDULE_ITEM_NUM SCHEDULE_ITEM_NUM
, SHIP_DEL_PATTERN_EXT SHIP_DEL_PATTERN_EXT
, SHIP_DEL_TIME_CODE_EXT SHIP_DEL_TIME_CODE_EXT
, SHIP_DEL_RULE_NAME SHIP_DEL_RULE_NAME
, SHIP_FROM_ADDRESS_1_EXT SHIP_FROM_ADDRESS_1_EXT
, SHIP_FROM_ADDRESS_2_EXT SHIP_FROM_ADDRESS_2_EXT
, SHIP_FROM_ADDRESS_3_EXT SHIP_FROM_ADDRESS_3_EXT
, SHIP_FROM_ADDRESS_4_EXT SHIP_FROM_ADDRESS_4_EXT
, SHIP_FROM_CITY_EXT SHIP_FROM_CITY_EXT
, SHIP_FROM_COUNTRY_EXT SHIP_FROM_COUNTRY_EXT
, SHIP_FROM_COUNTY_EXT SHIP_FROM_COUNTY_EXT
, SHIP_FROM_NAME_EXT SHIP_FROM_NAME_EXT
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, SHIP_FROM_POSTAL_CD_EXT SHIP_FROM_POSTAL_CD_EXT
, SHIP_FROM_PROVINCE_EXT SHIP_FROM_PROVINCE_EXT
, SHIP_FROM_STATE_EXT SHIP_FROM_STATE_EXT
, SHIP_LABEL_INFO_LINE_1 SHIP_LABEL_INFO_LINE_1
, SHIP_LABEL_INFO_LINE_10 SHIP_LABEL_INFO_LINE_10
, SHIP_LABEL_INFO_LINE_2 SHIP_LABEL_INFO_LINE_2
, SHIP_LABEL_INFO_LINE_3 SHIP_LABEL_INFO_LINE_3
, SHIP_LABEL_INFO_LINE_4 SHIP_LABEL_INFO_LINE_4
, SHIP_LABEL_INFO_LINE_5 SHIP_LABEL_INFO_LINE_5
, SHIP_LABEL_INFO_LINE_6 SHIP_LABEL_INFO_LINE_6
, SHIP_LABEL_INFO_LINE_7 SHIP_LABEL_INFO_LINE_7
, SHIP_LABEL_INFO_LINE_8 SHIP_LABEL_INFO_LINE_8
, SHIP_LABEL_INFO_LINE_9 SHIP_LABEL_INFO_LINE_9
, SHIP_TO_ADDRESS_1_EXT SHIP_TO_ADDRESS_1_EXT
, SHIP_TO_ADDRESS_2_EXT SHIP_TO_ADDRESS_2_EXT
, SHIP_TO_ADDRESS_3_EXT SHIP_TO_ADDRESS_3_EXT
, SHIP_TO_ADDRESS_4_EXT SHIP_TO_ADDRESS_4_EXT
, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID
, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID
, SHIP_TO_CITY_EXT SHIP_TO_CITY_EXT
, SHIP_TO_COUNTRY_EXT SHIP_TO_COUNTRY_EXT
, SHIP_TO_COUNTY_EXT SHIP_TO_COUNTY_EXT
, SHIP_TO_NAME_EXT SHIP_TO_NAME_EXT
, SHIP_TO_POSTAL_CD_EXT SHIP_TO_POSTAL_CD_EXT
, SHIP_TO_PROVINCE_EXT SHIP_TO_PROVINCE_EXT
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, SHIP_TO_STATE_EXT SHIP_TO_STATE_EXT
, START_DATE_TIME START_DATE_TIME
, SUBLINE_ASSIGNED_ID_EXT SUBLINE_ASSIGNED_ID_EXT
, SUBLINE_CONFIG_CODE_EXT SUBLINE_CONFIG_CODE_EXT
, SUBLINE_CUST_ITEM_EXT SUBLINE_CUST_ITEM_EXT
, SUBLINE_CUST_ITEM_ID SUBLINE_CUST_ITEM_ID
, SUBLINE_MODEL_NUM_EXT SUBLINE_MODEL_NUM_EXT
, SUBLINE_QUANTITY SUBLINE_QUANTITY
, SUBLINE_UOM_CODE SUBLINE_UOM_CODE
, SUPPLIER_ITEM_EXT SUPPLIER_ITEM_EXT
, TRANSIT_TIME_EXT TRANSIT_TIME_EXT
, TRANSIT_TIME_QUAL_EXT TRANSIT_TIME_QUAL_EXT
, TRANSPORT_LOC_QUAL_EXT TRANSPORT_LOC_QUAL_EXT
, TRANSPORT_LOCATION_EXT TRANSPORT_LOCATION_EXT
, TRANSPORT_METHOD_EXT TRANSPORT_METHOD_EXT
, UOM_CODE UOM_CODE
, WEIGHT_EXT WEIGHT_EXT
, WEIGHT_QUALIFIER_EXT WEIGHT_QUALIFIER_EXT
, WEIGHT_UOM_EXT WEIGHT_UOM_EXT
, FBO_CONFIGURATION_KEY_1 FBO_CONFIGURATION_KEY_1
, FBO_CONFIGURATION_KEY_2 FBO_CONFIGURATION_KEY_2
, FBO_CONFIGURATION_KEY_3 FBO_CONFIGURATION_KEY_3
, FBO_CONFIGURATION_KEY_4 FBO_CONFIGURATION_KEY_4
, FBO_CONFIGURATION_KEY_5 FBO_CONFIGURATION_KEY_5
, MATCH_KEY_ACROSS MATCH_KEY_ACROSS
, MATCH_KEY_WITHIN MATCH_KEY_WITHIN
, CRITICAL_KEY_ATTRIBUTES CRITICAL_KEY_ATTRIBUTES
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, 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
, 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
, 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
, TP_ATTRIBUTE_CATEGORY TP_ATTRIBUTE_CATEGORY
, LINE_NUMBER LINE_NUMBER
, INTMED_SHIP_TO_ORG_ID INTMED_SHIP_TO_ORG_ID
, LINE_SOURCE LINE_SOURCE
, PREFERRED_GRADE PREFERRED_GRADE
, CUST_PRODUCTION_SEQ_NUM_BEG CUST_PRODUCTION_SEQ_NUM_BEG
, CUST_PRODUCTION_SEQ_NUM_END CUST_PRODUCTION_SEQ_NUM_END
, ITEM_DETAIL_QUANTITY_MIN_EXT ITEM_DETAIL_QUANTITY_MIN_EXT
, ITEM_DETAIL_QUANTITY_MAX_EXT ITEM_DETAIL_QUANTITY_MAX_EXT
, ITEM_DETAIL_QUANTITY_PRIOR_EXT ITEM_DETAIL_QUANTITY_PRIOR_EXT
, REQUIREMENT_PRIORITY_EXT REQUIREMENT_PRIORITY_EXT
, PROJECT_NUMBER_EXT PROJECT_NUMBER_EXT
, RESP_LINE_NUMBER RESP_LINE_NUMBER
, TASK_NUMBER_EXT TASK_NUMBER_EXT
, UPC_EXT UPC_EXT
, ITEM_ENG_CNG_LVL_DATE_EXT ITEM_ENG_CNG_LVL_DATE_EXT
, AUTHORIZATION_CODE_EXT AUTHORIZATION_CODE_EXT
, PACKAGING_DESC_EXT PACKAGING_DESC_EXT
, BILL_TO_ADDRESS_5_EXT BILL_TO_ADDRESS_5_EXT
, BILL_TO_ADDRESS_6_EXT BILL_TO_ADDRESS_6_EXT
, BILL_TO_ADDRESS_7_EXT BILL_TO_ADDRESS_7_EXT
, BILL_TO_ADDRESS_8_EXT BILL_TO_ADDRESS_8_EXT
, BILL_TO_ADDRESS_9_EXT BILL_TO_ADDRESS_9_EXT
, ONE_TIME_BILL_TO_FLAG_EXT ONE_TIME_BILL_TO_FLAG_EXT
, BILL_TO_DESCRIPTION_EXT BILL_TO_DESCRIPTION_EXT
, BILL_TO_FAX_EXT BILL_TO_FAX_EXT
, BILL_TO_REGION_EXT BILL_TO_REGION_EXT
, BILL_TO_JURISDICTION_EXT BILL_TO_JURISDICTION_EXT
, BILL_TO_TEL_EXT BILL_TO_TEL_EXT
, INTRMD_ST_ADDRESS_5_EXT INTRMD_ST_ADDRESS_5_EXT
, INTRMD_ST_ADDRESS_6_EXT INTRMD_ST_ADDRESS_6_EXT
, INTRMD_ST_ADDRESS_7_EXT INTRMD_ST_ADDRESS_7_EXT
, INTRMD_ST_ADDRESS_8_EXT INTRMD_ST_ADDRESS_8_EXT
, INTRMD_ST_ADDRESS_9_EXT INTRMD_ST_ADDRESS_9_EXT
, ONE_TIME_INTRMD_ST_FLAG_EXT ONE_TIME_INTRMD_ST_FLAG_EXT
, INTRMD_ST_DESCRIPTION_EXT INTRMD_ST_DESCRIPTION_EXT
, INTRMD_ST_FAX_EXT INTRMD_ST_FAX_EXT
, INTRMD_ST_REGION_EXT INTRMD_ST_REGION_EXT
, INTRMD_ST_JURISDICTION_EXT INTRMD_ST_JURISDICTION_EXT
, INTRMD_ST_TEL_EXT INTRMD_ST_TEL_EXT
, SHIP_TO_ADDRESS_5_EXT SHIP_TO_ADDRESS_5_EXT
, SHIP_TO_ADDRESS_6_EXT SHIP_TO_ADDRESS_6_EXT
, SHIP_TO_ADDRESS_7_EXT SHIP_TO_ADDRESS_7_EXT
, SHIP_TO_ADDRESS_8_EXT SHIP_TO_ADDRESS_8_EXT
, SHIP_TO_ADDRESS_9_EXT SHIP_TO_ADDRESS_9_EXT
, ONE_TIME_SHIP_TO_FLAG_EXT ONE_TIME_SHIP_TO_FLAG_EXT
, SHIP_TO_DESCRIPTION_EXT SHIP_TO_DESCRIPTION_EXT
, SHIP_TO_FAX_EXT SHIP_TO_FAX_EXT
, SHIP_TO_REGION_EXT SHIP_TO_REGION_EXT
, SHIP_TO_JURISDICTION_EXT SHIP_TO_JURISDICTION_EXT
, SHIP_TO_TEL_EXT SHIP_TO_TEL_EXT
, SHIP_FROM_ADDRESS_5_EXT SHIP_FROM_ADDRESS_5_EXT
, SHIP_FROM_ADDRESS_6_EXT SHIP_FROM_ADDRESS_6_EXT
, SHIP_FROM_ADDRESS_7_EXT SHIP_FROM_ADDRESS_7_EXT
, SHIP_FROM_ADDRESS_8_EXT SHIP_FROM_ADDRESS_8_EXT
, SHIP_FROM_ADDRESS_9_EXT SHIP_FROM_ADDRESS_9_EXT
, ONE_TIME_SHIP_FROM_FLAG_EXT ONE_TIME_SHIP_FROM_FLAG_EXT
, SHIP_FROM_DESCRIPTION_EXT SHIP_FROM_DESCRIPTION_EXT
, SHIP_FROM_FAX_EXT SHIP_FROM_FAX_EXT
, SHIP_FROM_REGION_EXT SHIP_FROM_REGION_EXT
, SHIP_FROM_JURISDICTION_EXT SHIP_FROM_JURISDICTION_EXT
, SHIP_FROM_TEL_EXT SHIP_FROM_TEL_EXT
, FLEX_BKT_CODE FLEX_BKT_CODE
, FLEX_BKT_FLAG FLEX_BKT_FLAG
, BLANKET_NUMBER BLANKET_NUMBER
, DSP_CHILD_PROCESS_INDEX DSP_CHILD_PROCESS_INDEX
, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
FROM "RLM"."RLM_INTERFACE_LINES_ALL"