VIEW: AR.RA_CUSTOMERS#

Source

View Text - Preformatted

select CUSTOMER_ID CUSTOMER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_NUMBER CUSTOMER_NUMBER, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, STATUS STATUS, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CUSTOMER_TYPE CUSTOMER_TYPE, CUSTOMER_PROSPECT_CODE CUSTOMER_PROSPECT_CODE, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE, PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, SIC_CODE SIC_CODE, ORDER_TYPE_ID ORDER_TYPE_ID, PRICE_LIST_ID PRICE_LIST_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ANALYSIS_FY ANALYSIS_FY, CUSTOMER_CATEGORY_CODE CUSTOMER_CATEGORY_CODE, CUSTOMER_GROUP_CODE CUSTOMER_GROUP_CODE, CUSTOMER_KEY CUSTOMER_KEY, CUSTOMER_SUBGROUP_CODE CUSTOMER_SUBGROUP_CODE, FISCAL_YEAREND_MONTH FISCAL_YEAREND_MONTH, NET_WORTH NET_WORTH, NUM_OF_EMPLOYEES NUM_OF_EMPLOYEES, POTENTIAL_REVENUE_CURR_FY POTENTIAL_REVENUE_CURR_FY, POTENTIAL_REVENUE_NEXT_FY POTENTIAL_REVENUE_NEXT_FY, RANK RANK, REFERENCE_USE_FLAG REFERENCE_USE_FLAG, TAX_CODE TAX_CODE, TAX_REFERENCE TAX_REFERENCE, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, THIRD_PARTY_FLAG THIRD_PARTY_FLAG, ACCESS_TEMPLATE_ENTITY_CODE ACCESS_TEMPLATE_ENTITY_CODE, PRIMARY_SPECIALIST_ID PRIMARY_SPECIALIST_ID, SECONDARY_SPECIALIST_ID SECONDARY_SPECIALIST_ID, COMPETITOR_FLAG COMPETITOR_FLAG, DUNNING_SITE_USE_ID DUNNING_SITE_USE_ID, STATEMENT_SITE_USE_ID STATEMENT_SITE_USE_ID, ORIG_SYSTEM ORIG_SYSTEM, YEAR_ESTABLISHED YEAR_ESTABLISHED, COTERMINATE_DAY_MONTH COTERMINATE_DAY_MONTH, FOB_POINT FOB_POINT, FREIGHT_TERM FREIGHT_TERM, GSA_INDICATOR GSA_INDICATOR, SHIP_PARTIAL SHIP_PARTIAL, SHIP_VIA SHIP_VIA, WAREHOUSE_ID WAREHOUSE_ID, PAYMENT_TERM_ID PAYMENT_TERM_ID, TAX_EXEMPT TAX_EXEMPT, TAX_EXEMPT_NUM TAX_EXEMPT_NUM, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE, DO_NOT_MAIL_FLAG DO_NOT_MAIL_FLAG, MISSION_STATEMENT MISSION_STATEMENT, CUSTOMER_NAME_PHONETIC CUSTOMER_NAME_PHONETIC, TAX_HEADER_LEVEL_FLAG TAX_HEADER_LEVEL_FLAG, TAX_ROUNDING_RULE TAX_ROUNDING_RULE, WH_UPDATE_DATE WH_UPDATE_DATE, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, 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, 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_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, URL URL, PERSON_FLAG PERSON_FLAG, FIRST_NAME FIRST_NAME, LAST_NAME LAST_NAME, DATES_NEGATIVE_TOLERANCE DATES_NEGATIVE_TOLERANCE, DATES_POSITIVE_TOLERANCE DATES_POSITIVE_TOLERANCE, DATE_TYPE_PREFERENCE DATE_TYPE_PREFERENCE, OVER_SHIPMENT_TOLERANCE OVER_SHIPMENT_TOLERANCE, UNDER_SHIPMENT_TOLERANCE UNDER_SHIPMENT_TOLERANCE, ITEM_CROSS_REF_PREF ITEM_CROSS_REF_PREF, OVER_RETURN_TOLERANCE OVER_RETURN_TOLERANCE, UNDER_RETURN_TOLERANCE UNDER_RETURN_TOLERANCE, SHIP_SETS_INCLUDE_LINES_FLAG SHIP_SETS_INCLUDE_LINES_FLAG, ARRIVALSETS_INCLUDE_LINES_FLAG ARRIVALSETS_INCLUDE_LINES_FLAG, SCHED_DATE_PUSH_FLAG SCHED_DATE_PUSH_FLAG, INVOICE_QUANTITY_RULE INVOICE_QUANTITY_RULE, PRICING_EVENT PRICING_EVENT from "AR"."RA_CUSTOMERS"

View Text - HTML Formatted

SELECT CUSTOMER_ID CUSTOMER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, STATUS STATUS
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CUSTOMER_TYPE CUSTOMER_TYPE
, CUSTOMER_PROSPECT_CODE CUSTOMER_PROSPECT_CODE
, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE
, PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, SIC_CODE SIC_CODE
, ORDER_TYPE_ID ORDER_TYPE_ID
, PRICE_LIST_ID PRICE_LIST_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ANALYSIS_FY ANALYSIS_FY
, CUSTOMER_CATEGORY_CODE CUSTOMER_CATEGORY_CODE
, CUSTOMER_GROUP_CODE CUSTOMER_GROUP_CODE
, CUSTOMER_KEY CUSTOMER_KEY
, CUSTOMER_SUBGROUP_CODE CUSTOMER_SUBGROUP_CODE
, FISCAL_YEAREND_MONTH FISCAL_YEAREND_MONTH
, NET_WORTH NET_WORTH
, NUM_OF_EMPLOYEES NUM_OF_EMPLOYEES
, POTENTIAL_REVENUE_CURR_FY POTENTIAL_REVENUE_CURR_FY
, POTENTIAL_REVENUE_NEXT_FY POTENTIAL_REVENUE_NEXT_FY
, RANK RANK
, REFERENCE_USE_FLAG REFERENCE_USE_FLAG
, TAX_CODE TAX_CODE
, TAX_REFERENCE TAX_REFERENCE
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, THIRD_PARTY_FLAG THIRD_PARTY_FLAG
, ACCESS_TEMPLATE_ENTITY_CODE ACCESS_TEMPLATE_ENTITY_CODE
, PRIMARY_SPECIALIST_ID PRIMARY_SPECIALIST_ID
, SECONDARY_SPECIALIST_ID SECONDARY_SPECIALIST_ID
, COMPETITOR_FLAG COMPETITOR_FLAG
, DUNNING_SITE_USE_ID DUNNING_SITE_USE_ID
, STATEMENT_SITE_USE_ID STATEMENT_SITE_USE_ID
, ORIG_SYSTEM ORIG_SYSTEM
, YEAR_ESTABLISHED YEAR_ESTABLISHED
, COTERMINATE_DAY_MONTH COTERMINATE_DAY_MONTH
, FOB_POINT FOB_POINT
, FREIGHT_TERM FREIGHT_TERM
, GSA_INDICATOR GSA_INDICATOR
, SHIP_PARTIAL SHIP_PARTIAL
, SHIP_VIA SHIP_VIA
, WAREHOUSE_ID WAREHOUSE_ID
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, TAX_EXEMPT TAX_EXEMPT
, TAX_EXEMPT_NUM TAX_EXEMPT_NUM
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE
, DO_NOT_MAIL_FLAG DO_NOT_MAIL_FLAG
, MISSION_STATEMENT MISSION_STATEMENT
, CUSTOMER_NAME_PHONETIC CUSTOMER_NAME_PHONETIC
, TAX_HEADER_LEVEL_FLAG TAX_HEADER_LEVEL_FLAG
, TAX_ROUNDING_RULE TAX_ROUNDING_RULE
, WH_UPDATE_DATE WH_UPDATE_DATE
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, 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
, 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_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, URL URL
, PERSON_FLAG PERSON_FLAG
, FIRST_NAME FIRST_NAME
, LAST_NAME LAST_NAME
, DATES_NEGATIVE_TOLERANCE DATES_NEGATIVE_TOLERANCE
, DATES_POSITIVE_TOLERANCE DATES_POSITIVE_TOLERANCE
, DATE_TYPE_PREFERENCE DATE_TYPE_PREFERENCE
, OVER_SHIPMENT_TOLERANCE OVER_SHIPMENT_TOLERANCE
, UNDER_SHIPMENT_TOLERANCE UNDER_SHIPMENT_TOLERANCE
, ITEM_CROSS_REF_PREF ITEM_CROSS_REF_PREF
, OVER_RETURN_TOLERANCE OVER_RETURN_TOLERANCE
, UNDER_RETURN_TOLERANCE UNDER_RETURN_TOLERANCE
, SHIP_SETS_INCLUDE_LINES_FLAG SHIP_SETS_INCLUDE_LINES_FLAG
, ARRIVALSETS_INCLUDE_LINES_FLAG ARRIVALSETS_INCLUDE_LINES_FLAG
, SCHED_DATE_PUSH_FLAG SCHED_DATE_PUSH_FLAG
, INVOICE_QUANTITY_RULE INVOICE_QUANTITY_RULE
, PRICING_EVENT PRICING_EVENT
FROM "AR"."RA_CUSTOMERS"