VIEW: EC.ECE_MVSTO_LOCATIONS#

Source

View Text - Preformatted

select BILL_TO_CODE_INTERNAL BILL_TO_CODE_INTERNAL, BILL_TO_CODE_EXTERNAL BILL_TO_CODE_EXTERNAL, BILL_TO_NAME BILL_TO_NAME, BILL_TO_ADDRESS1 BILL_TO_ADDRESS1, BILL_TO_ADDRESS2 BILL_TO_ADDRESS2, BILL_TO_ADDRESS3 BILL_TO_ADDRESS3, BILL_TO_ADDRESS4 BILL_TO_ADDRESS4, BILL_TO_CITY BILL_TO_CITY, BILL_TO_POSTAL_CODE BILL_TO_POSTAL_CODE, BILL_TO_COUNTRY_INT BILL_TO_COUNTRY_INT, BILL_TO_COUNTRY_EXT BILL_TO_COUNTRY_EXT, BILL_TO_STATE_INT BILL_TO_STATE_INT, BILL_TO_STATE_EXT BILL_TO_STATE_EXT, BILL_TO_PROVINCE_INT BILL_TO_PROVINCE_INT, BILL_TO_PROVINCE_EXT BILL_TO_PROVINCE_EXT, BILL_TO_COUNTY_INT BILL_TO_COUNTY_INT, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID, SHIP_TO_CODE_INTERNAL SHIP_TO_CODE_INTERNAL, SHIP_TO_CODE_EXTERNAL SHIP_TO_CODE_EXTERNAL, SHIP_TO_NAME SHIP_TO_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_POSTAL_CODE SHIP_TO_POSTAL_CODE, SHIP_TO_COUNTRY_INT SHIP_TO_COUNTRY_INT, SHIP_TO_COUNTRY_EXT SHIP_TO_COUNTRY_EXT, SHIP_TO_STATE_INT SHIP_TO_STATE_INT, SHIP_TO_STATE_EXT SHIP_TO_STATE_EXT, SHIP_TO_PROVINCE_INT SHIP_TO_PROVINCE_INT, SHIP_TO_PROVINCE_EXT SHIP_TO_PROVINCE_EXT, SHIP_TO_COUNTY_INT SHIP_TO_COUNTY_INT, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID, VENDOR_CODE_INT VENDOR_CODE_INT, VENDOR_CODE_EXT VENDOR_CODE_EXT, VENDOR_CUSTOMER_NAME VENDOR_CUSTOMER_NAME, VENDOR_ADDRESS1 VENDOR_ADDRESS1, VENDOR_ADDRESS2 VENDOR_ADDRESS2, VENDOR_ADDRESS3 VENDOR_ADDRESS3, VENDOR_ADDRESS4 VENDOR_ADDRESS4, VENDOR_CITY VENDOR_CITY, VENDOR_POSTAL_CODE VENDOR_POSTAL_CODE, VENDOR_COUNTRY_INT VENDOR_COUNTRY_INT, VENDOR_COUNTRY_EXT1 VENDOR_COUNTRY_EXT1, VENDOR_STATE_INT VENDOR_STATE_INT, VENDOR_STATE_EXT1 VENDOR_STATE_EXT1, VENDOR_PROVINCE_INT VENDOR_PROVINCE_INT, VENDOR_PROVINCE_EXT1 VENDOR_PROVINCE_EXT1, VENDOR_COUNTY VENDOR_COUNTY, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, TRANSACTION_LINE_ID TRANSACTION_LINE_ID, RUN_ID RUN_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID from "EC"."ECE_MVSTO_LOCATIONS"

View Text - HTML Formatted

SELECT BILL_TO_CODE_INTERNAL BILL_TO_CODE_INTERNAL
, BILL_TO_CODE_EXTERNAL BILL_TO_CODE_EXTERNAL
, BILL_TO_NAME BILL_TO_NAME
, BILL_TO_ADDRESS1 BILL_TO_ADDRESS1
, BILL_TO_ADDRESS2 BILL_TO_ADDRESS2
, BILL_TO_ADDRESS3 BILL_TO_ADDRESS3
, BILL_TO_ADDRESS4 BILL_TO_ADDRESS4
, BILL_TO_CITY BILL_TO_CITY
, BILL_TO_POSTAL_CODE BILL_TO_POSTAL_CODE
, BILL_TO_COUNTRY_INT BILL_TO_COUNTRY_INT
, BILL_TO_COUNTRY_EXT BILL_TO_COUNTRY_EXT
, BILL_TO_STATE_INT BILL_TO_STATE_INT
, BILL_TO_STATE_EXT BILL_TO_STATE_EXT
, BILL_TO_PROVINCE_INT BILL_TO_PROVINCE_INT
, BILL_TO_PROVINCE_EXT BILL_TO_PROVINCE_EXT
, BILL_TO_COUNTY_INT BILL_TO_COUNTY_INT
, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID
, SHIP_TO_CODE_INTERNAL SHIP_TO_CODE_INTERNAL
, SHIP_TO_CODE_EXTERNAL SHIP_TO_CODE_EXTERNAL
, SHIP_TO_NAME SHIP_TO_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_POSTAL_CODE SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTRY_INT SHIP_TO_COUNTRY_INT
, SHIP_TO_COUNTRY_EXT SHIP_TO_COUNTRY_EXT
, SHIP_TO_STATE_INT SHIP_TO_STATE_INT
, SHIP_TO_STATE_EXT SHIP_TO_STATE_EXT
, SHIP_TO_PROVINCE_INT SHIP_TO_PROVINCE_INT
, SHIP_TO_PROVINCE_EXT SHIP_TO_PROVINCE_EXT
, SHIP_TO_COUNTY_INT SHIP_TO_COUNTY_INT
, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID
, VENDOR_CODE_INT VENDOR_CODE_INT
, VENDOR_CODE_EXT VENDOR_CODE_EXT
, VENDOR_CUSTOMER_NAME VENDOR_CUSTOMER_NAME
, VENDOR_ADDRESS1 VENDOR_ADDRESS1
, VENDOR_ADDRESS2 VENDOR_ADDRESS2
, VENDOR_ADDRESS3 VENDOR_ADDRESS3
, VENDOR_ADDRESS4 VENDOR_ADDRESS4
, VENDOR_CITY VENDOR_CITY
, VENDOR_POSTAL_CODE VENDOR_POSTAL_CODE
, VENDOR_COUNTRY_INT VENDOR_COUNTRY_INT
, VENDOR_COUNTRY_EXT1 VENDOR_COUNTRY_EXT1
, VENDOR_STATE_INT VENDOR_STATE_INT
, VENDOR_STATE_EXT1 VENDOR_STATE_EXT1
, VENDOR_PROVINCE_INT VENDOR_PROVINCE_INT
, VENDOR_PROVINCE_EXT1 VENDOR_PROVINCE_EXT1
, VENDOR_COUNTY VENDOR_COUNTY
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, TRANSACTION_LINE_ID TRANSACTION_LINE_ID
, RUN_ID RUN_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "EC"."ECE_MVSTO_LOCATIONS"