[Home] [Help]
View: RCV_SOURCES_BOTH_VAL_V
View Text
SELECT VENDOR_ID
, VENDOR_NAME
, SEGMENT1
, 'VENDOR'
, HOLD_STATUS
, NUM_1099
, VAT_REGISTRATION_NUM
FROM RCV_SUPPLIERS_VAL_V UNION SELECT ORGANIZATION_ID
, ORGANIZATION_NAME
, ORGANIZATION_CODE
, 'ORGANIZATION'
, NULL
, NULL
, NULL
FROM ORG_ORGANIZATION_DEFINITIONS
Columns
Name |
SOURCE_ID |
SOURCE_NAME |
SOURCE_CODE |
SOURCE_TYPE |
ON_HOLD |
TAXPAYER_ID |
TAX_REGISTRATION_NUM |