VIEW: FV.FV_1099C_ALL#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CREDITORS_TIN CREDITORS_TIN, CUSTOMER_ID CUSTOMER_ID, DATE_CANCELED DATE_CANCELED, CUSTOMER_NAME CUSTOMER_NAME, AMOUNT AMOUNT, TRX_NUMBER TRX_NUMBER, REPORTABLE_FLAG REPORTABLE_FLAG, COUNTRY COUNTRY, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, ADDRESS3 ADDRESS3, ADDRESS4 ADDRESS4, VOID_FLAG VOID_FLAG, CORRECTED_FLAG CORRECTED_FLAG, REPRINT_FLAG REPRINT_FLAG, TAX_ID TAX_ID, FINANCE_CHARGE_AMOUNT FINANCE_CHARGE_AMOUNT, DEBT_DESCRIPTION DEBT_DESCRIPTION, CITY CITY, STATE STATE, POSTAL_CODE POSTAL_CODE, PROVINCE PROVINCE, BANKRUPTCY_CODE BANKRUPTCY_CODE, PROPERTY_VALUE PROPERTY_VALUE, ACCOUNT_NUMBER ACCOUNT_NUMBER, ORG_ID ORG_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 from "FV"."FV_1099C_ALL"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CREDITORS_TIN CREDITORS_TIN
, CUSTOMER_ID CUSTOMER_ID
, DATE_CANCELED DATE_CANCELED
, CUSTOMER_NAME CUSTOMER_NAME
, AMOUNT AMOUNT
, TRX_NUMBER TRX_NUMBER
, REPORTABLE_FLAG REPORTABLE_FLAG
, COUNTRY COUNTRY
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, ADDRESS3 ADDRESS3
, ADDRESS4 ADDRESS4
, VOID_FLAG VOID_FLAG
, CORRECTED_FLAG CORRECTED_FLAG
, REPRINT_FLAG REPRINT_FLAG
, TAX_ID TAX_ID
, FINANCE_CHARGE_AMOUNT FINANCE_CHARGE_AMOUNT
, DEBT_DESCRIPTION DEBT_DESCRIPTION
, CITY CITY
, STATE STATE
, POSTAL_CODE POSTAL_CODE
, PROVINCE PROVINCE
, BANKRUPTCY_CODE BANKRUPTCY_CODE
, PROPERTY_VALUE PROPERTY_VALUE
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, ORG_ID ORG_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
FROM "FV"."FV_1099C_ALL"