VIEW: RLM.RLM_INTERFACE_HEADERS_ALL#

Source

View Text - Preformatted

select HEADER_ID HEADER_ID, CUST_ADDRESS_1_EXT CUST_ADDRESS_1_EXT, CUST_ADDRESS_2_EXT CUST_ADDRESS_2_EXT, CUST_ADDRESS_3_EXT CUST_ADDRESS_3_EXT, CUST_ADDRESS_4_EXT CUST_ADDRESS_4_EXT, CUST_CITY_EXT CUST_CITY_EXT, CUST_COUNTRY_EXT CUST_COUNTRY_EXT, CUST_COUNTY_EXT CUST_COUNTY_EXT, CUSTOMER_EXT CUSTOMER_EXT, CUST_NAME_EXT CUST_NAME_EXT, CUST_POSTAL_CD_EXT CUST_POSTAL_CD_EXT, CUST_PROVINCE_EXT CUST_PROVINCE_EXT, CUST_STATE_EXT CUST_STATE_EXT, CUSTOMER_ID CUSTOMER_ID, ECE_PRIMARY_ADDRESS_ID ECE_PRIMARY_ADDRESS_ID, ECE_TP_LOCATION_CODE_EXT ECE_TP_LOCATION_CODE_EXT, ECE_TP_TRANSLATOR_CODE ECE_TP_TRANSLATOR_CODE, EDI_CONTROL_NUM_1 EDI_CONTROL_NUM_1, EDI_CONTROL_NUM_2 EDI_CONTROL_NUM_2, EDI_CONTROL_NUM_3 EDI_CONTROL_NUM_3, EDI_TEST_INDICATOR EDI_TEST_INDICATOR, HEADER_CONTACT_CODE_1 HEADER_CONTACT_CODE_1, HEADER_CONTACT_CODE_2 HEADER_CONTACT_CODE_2, HEADER_CONTACT_VALUE_1 HEADER_CONTACT_VALUE_1, HEADER_CONTACT_VALUE_2 HEADER_CONTACT_VALUE_2, HEADER_NOTE_TEXT HEADER_NOTE_TEXT, HEADER_REF_CODE_1 HEADER_REF_CODE_1, HEADER_REF_CODE_2 HEADER_REF_CODE_2, HEADER_REF_CODE_3 HEADER_REF_CODE_3, HEADER_REF_VALUE_1 HEADER_REF_VALUE_1, HEADER_REF_VALUE_2 HEADER_REF_VALUE_2, HEADER_REF_VALUE_3 HEADER_REF_VALUE_3, ORG_ID ORG_ID, PROCESS_STATUS PROCESS_STATUS, SCHEDULE_HEADER_ID SCHEDULE_HEADER_ID, SCHEDULE_TYPE SCHEDULE_TYPE, SCHEDULE_TYPE_EXT SCHEDULE_TYPE_EXT, SCHED_GENERATION_DATE SCHED_GENERATION_DATE, SCHED_HORIZON_END_DATE SCHED_HORIZON_END_DATE, SCHED_HORIZON_START_DATE SCHED_HORIZON_START_DATE, SCHEDULE_PURPOSE SCHEDULE_PURPOSE, SCHEDULE_PURPOSE_EXT SCHEDULE_PURPOSE_EXT, SCHEDULE_REFERENCE_NUM SCHEDULE_REFERENCE_NUM, SCHEDULE_SOURCE SCHEDULE_SOURCE, 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, CUST_ADDRESS_5_EXT CUST_ADDRESS_5_EXT, CUST_ADDRESS_6_EXT CUST_ADDRESS_6_EXT, CUST_ADDRESS_7_EXT CUST_ADDRESS_7_EXT, CUST_ADDRESS_8_EXT CUST_ADDRESS_8_EXT, CUST_ADDRESS_9_EXT CUST_ADDRESS_9_EXT, ONE_TIME_CUST_FLAG_EXT ONE_TIME_CUST_FLAG_EXT, CURRENCY_EXT CURRENCY_EXT, TAX_EXEMPT_FLAG_EXT TAX_EXEMPT_FLAG_EXT, TAX_ID_EXT TAX_ID_EXT, HEADER_CONTACT_EMAIL_1_EXT HEADER_CONTACT_EMAIL_1_EXT, HEADER_CONTACT_EMAIL_2_EXT HEADER_CONTACT_EMAIL_2_EXT, HEADER_CONTACT_FAX_1_EXT HEADER_CONTACT_FAX_1_EXT, HEADER_CONTACT_FAX_2_EXT HEADER_CONTACT_FAX_2_EXT, HEADER_CONTACT_TEL_1_EXT HEADER_CONTACT_TEL_1_EXT, HEADER_CONTACT_TEL_2_EXT HEADER_CONTACT_TEL_2_EXT, CUST_FAX_EXT CUST_FAX_EXT, CUST_REGION_EXT CUST_REGION_EXT, CUST_TAX_JURISDICTION_EXT CUST_TAX_JURISDICTION_EXT, CUST_TEL_EXT CUST_TEL_EXT, CUST_URL_EXT CUST_URL_EXT, ORIGINAL_DOCUMENT_DATE ORIGINAL_DOCUMENT_DATE, RESP_DOCUMENT_DATE RESP_DOCUMENT_DATE, DOCUMENT_DESCRIPTION DOCUMENT_DESCRIPTION, DOCUMENT_REV_NUM DOCUMENT_REV_NUM, RESP_SCHEDULE_ID RESP_SCHEDULE_ID, RESP_DOCUMENT_REV_NUM RESP_DOCUMENT_REV_NUM, BUCKET_END_DATE BUCKET_END_DATE, BUCKET_START_DATE BUCKET_START_DATE, FLEX_BUCKET_CODE FLEX_BUCKET_CODE, SUPPLIER_NAME_EXT SUPPLIER_NAME_EXT, ONE_TIME_SUPPLIER_FLAG_EXT ONE_TIME_SUPPLIER_FLAG_EXT, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_CURRENCY_EXT SUPPLIER_CURRENCY_EXT, SUPPLIER_DESCRIPTION_EXT SUPPLIER_DESCRIPTION_EXT, CUST_DESCRIPTION_EXT CUST_DESCRIPTION_EXT, SUPPLIER_TAX_EXEMPT_FLAG_EXT SUPPLIER_TAX_EXEMPT_FLAG_EXT, SUPPLIER_TAX_ID_EXT SUPPLIER_TAX_ID_EXT, SUPPLIER_ADDRESS_1_EXT SUPPLIER_ADDRESS_1_EXT, SUPPLIER_ADDRESS_2_EXT SUPPLIER_ADDRESS_2_EXT, SUPPLIER_ADDRESS_3_EXT SUPPLIER_ADDRESS_3_EXT, SUPPLIER_ADDRESS_4_EXT SUPPLIER_ADDRESS_4_EXT, SUPPLIER_ADDRESS_5_EXT SUPPLIER_ADDRESS_5_EXT, SUPPLIER_ADDRESS_6_EXT SUPPLIER_ADDRESS_6_EXT, SUPPLIER_ADDRESS_7_EXT SUPPLIER_ADDRESS_7_EXT, SUPPLIER_ADDRESS_8_EXT SUPPLIER_ADDRESS_8_EXT, SUPPLIER_ADDRESS_9_EXT SUPPLIER_ADDRESS_9_EXT, SUPPLIER_CITY_EXT SUPPLIER_CITY_EXT, SUPPLIER_COUNTY_EXT SUPPLIER_COUNTY_EXT, SUPPLIER_FAX_EXT SUPPLIER_FAX_EXT, SUPPLIER_POSTAL_CD_EXT SUPPLIER_POSTAL_CD_EXT, SUPPLIER_REGION_EXT SUPPLIER_REGION_EXT, SUPPLIER_STATE_EXT SUPPLIER_STATE_EXT, SUPPLIER_PROVINCE_EXT SUPPLIER_PROVINCE_EXT, SUPPLIER_TAX_JURISDICTION_EXT SUPPLIER_TAX_JURISDICTION_EXT, SUPPLIER_TEL_EXT SUPPLIER_TEL_EXT, SUPPLIER_URL_EXT SUPPLIER_URL_EXT, SUP_HEADER_CONTACT_CODE_1 SUP_HEADER_CONTACT_CODE_1, SUP_HEADER_CONTACT_CODE_2 SUP_HEADER_CONTACT_CODE_2, SUP_HEADER_CONTACT_VALUE_1 SUP_HEADER_CONTACT_VALUE_1, SUP_HEADER_CONTACT_VALUE_2 SUP_HEADER_CONTACT_VALUE_2, SUP_HEADER_CONTACT_EMAIL_1_EXT SUP_HEADER_CONTACT_EMAIL_1_EXT, SUP_HEADER_CONTACT_EMAIL_2_EXT SUP_HEADER_CONTACT_EMAIL_2_EXT, SUP_HEADER_CONTACT_FAX_1_EXT SUP_HEADER_CONTACT_FAX_1_EXT, SUP_HEADER_CONTACT_FAX_2_EXT SUP_HEADER_CONTACT_FAX_2_EXT, SUP_HEADER_CONTACT_TEL_1_EXT SUP_HEADER_CONTACT_TEL_1_EXT, SUP_HEADER_CONTACT_TEL_2_EXT SUP_HEADER_CONTACT_TEL_2_EXT, SUPPLIER_COUNTRY_EXT SUPPLIER_COUNTRY_EXT from "RLM"."RLM_INTERFACE_HEADERS_ALL"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, CUST_ADDRESS_1_EXT CUST_ADDRESS_1_EXT
, CUST_ADDRESS_2_EXT CUST_ADDRESS_2_EXT
, CUST_ADDRESS_3_EXT CUST_ADDRESS_3_EXT
, CUST_ADDRESS_4_EXT CUST_ADDRESS_4_EXT
, CUST_CITY_EXT CUST_CITY_EXT
, CUST_COUNTRY_EXT CUST_COUNTRY_EXT
, CUST_COUNTY_EXT CUST_COUNTY_EXT
, CUSTOMER_EXT CUSTOMER_EXT
, CUST_NAME_EXT CUST_NAME_EXT
, CUST_POSTAL_CD_EXT CUST_POSTAL_CD_EXT
, CUST_PROVINCE_EXT CUST_PROVINCE_EXT
, CUST_STATE_EXT CUST_STATE_EXT
, CUSTOMER_ID CUSTOMER_ID
, ECE_PRIMARY_ADDRESS_ID ECE_PRIMARY_ADDRESS_ID
, ECE_TP_LOCATION_CODE_EXT ECE_TP_LOCATION_CODE_EXT
, ECE_TP_TRANSLATOR_CODE ECE_TP_TRANSLATOR_CODE
, EDI_CONTROL_NUM_1 EDI_CONTROL_NUM_1
, EDI_CONTROL_NUM_2 EDI_CONTROL_NUM_2
, EDI_CONTROL_NUM_3 EDI_CONTROL_NUM_3
, EDI_TEST_INDICATOR EDI_TEST_INDICATOR
, HEADER_CONTACT_CODE_1 HEADER_CONTACT_CODE_1
, HEADER_CONTACT_CODE_2 HEADER_CONTACT_CODE_2
, HEADER_CONTACT_VALUE_1 HEADER_CONTACT_VALUE_1
, HEADER_CONTACT_VALUE_2 HEADER_CONTACT_VALUE_2
, HEADER_NOTE_TEXT HEADER_NOTE_TEXT
, HEADER_REF_CODE_1 HEADER_REF_CODE_1
, HEADER_REF_CODE_2 HEADER_REF_CODE_2
, HEADER_REF_CODE_3 HEADER_REF_CODE_3
, HEADER_REF_VALUE_1 HEADER_REF_VALUE_1
, HEADER_REF_VALUE_2 HEADER_REF_VALUE_2
, HEADER_REF_VALUE_3 HEADER_REF_VALUE_3
, ORG_ID ORG_ID
, PROCESS_STATUS PROCESS_STATUS
, SCHEDULE_HEADER_ID SCHEDULE_HEADER_ID
, SCHEDULE_TYPE SCHEDULE_TYPE
, SCHEDULE_TYPE_EXT SCHEDULE_TYPE_EXT
, SCHED_GENERATION_DATE SCHED_GENERATION_DATE
, SCHED_HORIZON_END_DATE SCHED_HORIZON_END_DATE
, SCHED_HORIZON_START_DATE SCHED_HORIZON_START_DATE
, SCHEDULE_PURPOSE SCHEDULE_PURPOSE
, SCHEDULE_PURPOSE_EXT SCHEDULE_PURPOSE_EXT
, SCHEDULE_REFERENCE_NUM SCHEDULE_REFERENCE_NUM
, SCHEDULE_SOURCE SCHEDULE_SOURCE
, 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
, CUST_ADDRESS_5_EXT CUST_ADDRESS_5_EXT
, CUST_ADDRESS_6_EXT CUST_ADDRESS_6_EXT
, CUST_ADDRESS_7_EXT CUST_ADDRESS_7_EXT
, CUST_ADDRESS_8_EXT CUST_ADDRESS_8_EXT
, CUST_ADDRESS_9_EXT CUST_ADDRESS_9_EXT
, ONE_TIME_CUST_FLAG_EXT ONE_TIME_CUST_FLAG_EXT
, CURRENCY_EXT CURRENCY_EXT
, TAX_EXEMPT_FLAG_EXT TAX_EXEMPT_FLAG_EXT
, TAX_ID_EXT TAX_ID_EXT
, HEADER_CONTACT_EMAIL_1_EXT HEADER_CONTACT_EMAIL_1_EXT
, HEADER_CONTACT_EMAIL_2_EXT HEADER_CONTACT_EMAIL_2_EXT
, HEADER_CONTACT_FAX_1_EXT HEADER_CONTACT_FAX_1_EXT
, HEADER_CONTACT_FAX_2_EXT HEADER_CONTACT_FAX_2_EXT
, HEADER_CONTACT_TEL_1_EXT HEADER_CONTACT_TEL_1_EXT
, HEADER_CONTACT_TEL_2_EXT HEADER_CONTACT_TEL_2_EXT
, CUST_FAX_EXT CUST_FAX_EXT
, CUST_REGION_EXT CUST_REGION_EXT
, CUST_TAX_JURISDICTION_EXT CUST_TAX_JURISDICTION_EXT
, CUST_TEL_EXT CUST_TEL_EXT
, CUST_URL_EXT CUST_URL_EXT
, ORIGINAL_DOCUMENT_DATE ORIGINAL_DOCUMENT_DATE
, RESP_DOCUMENT_DATE RESP_DOCUMENT_DATE
, DOCUMENT_DESCRIPTION DOCUMENT_DESCRIPTION
, DOCUMENT_REV_NUM DOCUMENT_REV_NUM
, RESP_SCHEDULE_ID RESP_SCHEDULE_ID
, RESP_DOCUMENT_REV_NUM RESP_DOCUMENT_REV_NUM
, BUCKET_END_DATE BUCKET_END_DATE
, BUCKET_START_DATE BUCKET_START_DATE
, FLEX_BUCKET_CODE FLEX_BUCKET_CODE
, SUPPLIER_NAME_EXT SUPPLIER_NAME_EXT
, ONE_TIME_SUPPLIER_FLAG_EXT ONE_TIME_SUPPLIER_FLAG_EXT
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_CURRENCY_EXT SUPPLIER_CURRENCY_EXT
, SUPPLIER_DESCRIPTION_EXT SUPPLIER_DESCRIPTION_EXT
, CUST_DESCRIPTION_EXT CUST_DESCRIPTION_EXT
, SUPPLIER_TAX_EXEMPT_FLAG_EXT SUPPLIER_TAX_EXEMPT_FLAG_EXT
, SUPPLIER_TAX_ID_EXT SUPPLIER_TAX_ID_EXT
, SUPPLIER_ADDRESS_1_EXT SUPPLIER_ADDRESS_1_EXT
, SUPPLIER_ADDRESS_2_EXT SUPPLIER_ADDRESS_2_EXT
, SUPPLIER_ADDRESS_3_EXT SUPPLIER_ADDRESS_3_EXT
, SUPPLIER_ADDRESS_4_EXT SUPPLIER_ADDRESS_4_EXT
, SUPPLIER_ADDRESS_5_EXT SUPPLIER_ADDRESS_5_EXT
, SUPPLIER_ADDRESS_6_EXT SUPPLIER_ADDRESS_6_EXT
, SUPPLIER_ADDRESS_7_EXT SUPPLIER_ADDRESS_7_EXT
, SUPPLIER_ADDRESS_8_EXT SUPPLIER_ADDRESS_8_EXT
, SUPPLIER_ADDRESS_9_EXT SUPPLIER_ADDRESS_9_EXT
, SUPPLIER_CITY_EXT SUPPLIER_CITY_EXT
, SUPPLIER_COUNTY_EXT SUPPLIER_COUNTY_EXT
, SUPPLIER_FAX_EXT SUPPLIER_FAX_EXT
, SUPPLIER_POSTAL_CD_EXT SUPPLIER_POSTAL_CD_EXT
, SUPPLIER_REGION_EXT SUPPLIER_REGION_EXT
, SUPPLIER_STATE_EXT SUPPLIER_STATE_EXT
, SUPPLIER_PROVINCE_EXT SUPPLIER_PROVINCE_EXT
, SUPPLIER_TAX_JURISDICTION_EXT SUPPLIER_TAX_JURISDICTION_EXT
, SUPPLIER_TEL_EXT SUPPLIER_TEL_EXT
, SUPPLIER_URL_EXT SUPPLIER_URL_EXT
, SUP_HEADER_CONTACT_CODE_1 SUP_HEADER_CONTACT_CODE_1
, SUP_HEADER_CONTACT_CODE_2 SUP_HEADER_CONTACT_CODE_2
, SUP_HEADER_CONTACT_VALUE_1 SUP_HEADER_CONTACT_VALUE_1
, SUP_HEADER_CONTACT_VALUE_2 SUP_HEADER_CONTACT_VALUE_2
, SUP_HEADER_CONTACT_EMAIL_1_EXT SUP_HEADER_CONTACT_EMAIL_1_EXT
, SUP_HEADER_CONTACT_EMAIL_2_EXT SUP_HEADER_CONTACT_EMAIL_2_EXT
, SUP_HEADER_CONTACT_FAX_1_EXT SUP_HEADER_CONTACT_FAX_1_EXT
, SUP_HEADER_CONTACT_FAX_2_EXT SUP_HEADER_CONTACT_FAX_2_EXT
, SUP_HEADER_CONTACT_TEL_1_EXT SUP_HEADER_CONTACT_TEL_1_EXT
, SUP_HEADER_CONTACT_TEL_2_EXT SUP_HEADER_CONTACT_TEL_2_EXT
, SUPPLIER_COUNTRY_EXT SUPPLIER_COUNTRY_EXT
FROM "RLM"."RLM_INTERFACE_HEADERS_ALL"