VIEW: AR.AR_CMGT_TRADE_REF_DATA#

Source

View Text - Preformatted

select DATAPOINT_ID DATAPOINT_ID, CREDIT_REQUEST_ID CREDIT_REQUEST_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, COUNTRY COUNTRY, TAX_NUMBER TAX_NUMBER, REFERENCE_NAME REFERENCE_NAME, CONTACT_NAME CONTACT_NAME, ADDRESS ADDRESS, PHONE_NUMBER PHONE_NUMBER, CITY CITY, FAX_NUMBER FAX_NUMBER, STATE STATE, EMAIL EMAIL, POSTAL_CODE POSTAL_CODE, PROVINCE PROVINCE, URL URL, REPORT_DATE REPORT_DATE, LAST_TRANSACTION_DATE LAST_TRANSACTION_DATE, NUMBERS_OF_YEARS_IN_TRADE NUMBERS_OF_YEARS_IN_TRADE, PAYMENT_TERMS PAYMENT_TERMS, CREDIT_LIMIT CREDIT_LIMIT, CURRENCY CURRENCY, AMOUNT_OWED AMOUNT_OWED, CREDIT_BALANCE CREDIT_BALANCE, PAST_DUE_AMOUNT PAST_DUE_AMOUNT, INTERNAL_TRADE_RATING INTERNAL_TRADE_RATING, CASE_FOLDER_ID CASE_FOLDER_ID, NOTES NOTES from "AR"."AR_CMGT_TRADE_REF_DATA"

View Text - HTML Formatted

SELECT DATAPOINT_ID DATAPOINT_ID
, CREDIT_REQUEST_ID CREDIT_REQUEST_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, COUNTRY COUNTRY
, TAX_NUMBER TAX_NUMBER
, REFERENCE_NAME REFERENCE_NAME
, CONTACT_NAME CONTACT_NAME
, ADDRESS ADDRESS
, PHONE_NUMBER PHONE_NUMBER
, CITY CITY
, FAX_NUMBER FAX_NUMBER
, STATE STATE
, EMAIL EMAIL
, POSTAL_CODE POSTAL_CODE
, PROVINCE PROVINCE
, URL URL
, REPORT_DATE REPORT_DATE
, LAST_TRANSACTION_DATE LAST_TRANSACTION_DATE
, NUMBERS_OF_YEARS_IN_TRADE NUMBERS_OF_YEARS_IN_TRADE
, PAYMENT_TERMS PAYMENT_TERMS
, CREDIT_LIMIT CREDIT_LIMIT
, CURRENCY CURRENCY
, AMOUNT_OWED AMOUNT_OWED
, CREDIT_BALANCE CREDIT_BALANCE
, PAST_DUE_AMOUNT PAST_DUE_AMOUNT
, INTERNAL_TRADE_RATING INTERNAL_TRADE_RATING
, CASE_FOLDER_ID CASE_FOLDER_ID
, NOTES NOTES
FROM "AR"."AR_CMGT_TRADE_REF_DATA"