VIEW: PN.PN_VAR_TRX_HEADERS_ALL#

Source

View Text - Preformatted

select TRX_HEADER_ID TRX_HEADER_ID, VAR_RENT_ID VAR_RENT_ID, PERIOD_ID PERIOD_ID, LINE_ITEM_ID LINE_ITEM_ID, GRP_DATE_ID GRP_DATE_ID, CALC_PRD_START_DATE CALC_PRD_START_DATE, CALC_PRD_END_DATE CALC_PRD_END_DATE, VAR_RENT_SUMM_ID VAR_RENT_SUMM_ID, LINE_ITEM_GROUP_ID LINE_ITEM_GROUP_ID, RESET_GROUP_ID RESET_GROUP_ID, PRORATION_FACTOR PRORATION_FACTOR, REPORTING_GROUP_SALES REPORTING_GROUP_SALES, PRORATED_GROUP_SALES PRORATED_GROUP_SALES, YTD_SALES YTD_SALES, REPORTING_GROUP_SALES_FOR REPORTING_GROUP_SALES_FOR, PRORATED_GROUP_SALES_FOR PRORATED_GROUP_SALES_FOR, YTD_SALES_FOR YTD_SALES_FOR, FY_PRORATION_SALES FY_PRORATION_SALES, LY_PRORATION_SALES LY_PRORATION_SALES, CALCULATED_RENT CALCULATED_RENT, PERCENT_RENT_DUE PERCENT_RENT_DUE, YTD_PERCENT_RENT YTD_PERCENT_RENT, PRORATED_RENT_DUE PRORATED_RENT_DUE, TRUEUP_RENT_DUE TRUEUP_RENT_DUE, CALCULATED_RENT_FOR CALCULATED_RENT_FOR, PERCENT_RENT_DUE_FOR PERCENT_RENT_DUE_FOR, YTD_PERCENT_RENT_FOR YTD_PERCENT_RENT_FOR, REPORTING_GROUP_DEDUCTIONS REPORTING_GROUP_DEDUCTIONS, PRORATED_GROUP_DEDUCTIONS PRORATED_GROUP_DEDUCTIONS, YTD_DEDUCTIONS YTD_DEDUCTIONS, LY_PRORATION_DEDUCTIONS LY_PRORATION_DEDUCTIONS, FY_PRORATION_DEDUCTIONS FY_PRORATION_DEDUCTIONS, FIRST_YR_RENT FIRST_YR_RENT, INVOICE_FLAG INVOICE_FLAG, 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 "PN"."PN_VAR_TRX_HEADERS_ALL"

View Text - HTML Formatted

SELECT TRX_HEADER_ID TRX_HEADER_ID
, VAR_RENT_ID VAR_RENT_ID
, PERIOD_ID PERIOD_ID
, LINE_ITEM_ID LINE_ITEM_ID
, GRP_DATE_ID GRP_DATE_ID
, CALC_PRD_START_DATE CALC_PRD_START_DATE
, CALC_PRD_END_DATE CALC_PRD_END_DATE
, VAR_RENT_SUMM_ID VAR_RENT_SUMM_ID
, LINE_ITEM_GROUP_ID LINE_ITEM_GROUP_ID
, RESET_GROUP_ID RESET_GROUP_ID
, PRORATION_FACTOR PRORATION_FACTOR
, REPORTING_GROUP_SALES REPORTING_GROUP_SALES
, PRORATED_GROUP_SALES PRORATED_GROUP_SALES
, YTD_SALES YTD_SALES
, REPORTING_GROUP_SALES_FOR REPORTING_GROUP_SALES_FOR
, PRORATED_GROUP_SALES_FOR PRORATED_GROUP_SALES_FOR
, YTD_SALES_FOR YTD_SALES_FOR
, FY_PRORATION_SALES FY_PRORATION_SALES
, LY_PRORATION_SALES LY_PRORATION_SALES
, CALCULATED_RENT CALCULATED_RENT
, PERCENT_RENT_DUE PERCENT_RENT_DUE
, YTD_PERCENT_RENT YTD_PERCENT_RENT
, PRORATED_RENT_DUE PRORATED_RENT_DUE
, TRUEUP_RENT_DUE TRUEUP_RENT_DUE
, CALCULATED_RENT_FOR CALCULATED_RENT_FOR
, PERCENT_RENT_DUE_FOR PERCENT_RENT_DUE_FOR
, YTD_PERCENT_RENT_FOR YTD_PERCENT_RENT_FOR
, REPORTING_GROUP_DEDUCTIONS REPORTING_GROUP_DEDUCTIONS
, PRORATED_GROUP_DEDUCTIONS PRORATED_GROUP_DEDUCTIONS
, YTD_DEDUCTIONS YTD_DEDUCTIONS
, LY_PRORATION_DEDUCTIONS LY_PRORATION_DEDUCTIONS
, FY_PRORATION_DEDUCTIONS FY_PRORATION_DEDUCTIONS
, FIRST_YR_RENT FIRST_YR_RENT
, INVOICE_FLAG INVOICE_FLAG
, 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 "PN"."PN_VAR_TRX_HEADERS_ALL"