VIEW: POS.POS_SUPPLIER_REGISTRATIONS#

Source

View Text - Preformatted

select SUPPLIER_REG_ID SUPPLIER_REG_ID, USER_REG_ID USER_REG_ID, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_NUMBER SUPPLIER_NUMBER, TAXPAYER_ID TAXPAYER_ID, TAX_REGISTRATION_NUMBER TAX_REGISTRATION_NUMBER, DUNS_NUMBER DUNS_NUMBER, OU_ID OU_ID, ADDRESS_NICKNAME ADDRESS_NICKNAME, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, ADDRESS_LINE4 ADDRESS_LINE4, CITY CITY, COUNTY COUNTY, STATE STATE, PROVINCE PROVINCE, COUNTRY COUNTRY, POSTAL_CODE POSTAL_CODE, NOTE_FROM_SUPPLIER NOTE_FROM_SUPPLIER, NOTE_TO_SUPPLIER NOTE_TO_SUPPLIER, PO_VENDOR_ID PO_VENDOR_ID, VENDOR_PARTY_ID VENDOR_PARTY_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REGISTRATION_TYPE REGISTRATION_TYPE, REGISTRATION_STATUS REGISTRATION_STATUS, REG_KEY REG_KEY, TAX_REG_COUNTRY_CODE TAX_REG_COUNTRY_CODE, TAX_REG_TYPE TAX_REG_TYPE, SUPPLIER_NAME_ALT SUPPLIER_NAME_ALT, SUPPLIER_TYPE SUPPLIER_TYPE, STANDARD_INDUSTRY_CLASS STANDARD_INDUSTRY_CLASS, NI_NUMBER NI_NUMBER, SM_NOTE_TO_SUPPLIER SM_NOTE_TO_SUPPLIER, SM_NOTE_TO_BUYER SM_NOTE_TO_BUYER, SM_BUYER_INTERNAL_NOTES SM_BUYER_INTERNAL_NOTES, REGISTRATION_PURPOSE REGISTRATION_PURPOSE from "POS"."POS_SUPPLIER_REGISTRATIONS"

View Text - HTML Formatted

SELECT SUPPLIER_REG_ID SUPPLIER_REG_ID
, USER_REG_ID USER_REG_ID
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_NUMBER SUPPLIER_NUMBER
, TAXPAYER_ID TAXPAYER_ID
, TAX_REGISTRATION_NUMBER TAX_REGISTRATION_NUMBER
, DUNS_NUMBER DUNS_NUMBER
, OU_ID OU_ID
, ADDRESS_NICKNAME ADDRESS_NICKNAME
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, ADDRESS_LINE4 ADDRESS_LINE4
, CITY CITY
, COUNTY COUNTY
, STATE STATE
, PROVINCE PROVINCE
, COUNTRY COUNTRY
, POSTAL_CODE POSTAL_CODE
, NOTE_FROM_SUPPLIER NOTE_FROM_SUPPLIER
, NOTE_TO_SUPPLIER NOTE_TO_SUPPLIER
, PO_VENDOR_ID PO_VENDOR_ID
, VENDOR_PARTY_ID VENDOR_PARTY_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REGISTRATION_TYPE REGISTRATION_TYPE
, REGISTRATION_STATUS REGISTRATION_STATUS
, REG_KEY REG_KEY
, TAX_REG_COUNTRY_CODE TAX_REG_COUNTRY_CODE
, TAX_REG_TYPE TAX_REG_TYPE
, SUPPLIER_NAME_ALT SUPPLIER_NAME_ALT
, SUPPLIER_TYPE SUPPLIER_TYPE
, STANDARD_INDUSTRY_CLASS STANDARD_INDUSTRY_CLASS
, NI_NUMBER NI_NUMBER
, SM_NOTE_TO_SUPPLIER SM_NOTE_TO_SUPPLIER
, SM_NOTE_TO_BUYER SM_NOTE_TO_BUYER
, SM_BUYER_INTERNAL_NOTES SM_BUYER_INTERNAL_NOTES
, REGISTRATION_PURPOSE REGISTRATION_PURPOSE
FROM "POS"."POS_SUPPLIER_REGISTRATIONS"