[Home] [Help] [Dependency Information]
Object Name: | PN_VAR_TRX_HEADERS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_VAR_TRX_HEADERS_ALL |
Subobject Name: | |
Status: | VALID |
PN_VAR_TRX_HEADERS_ALL stores details of variable rent calculations
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_VAR_TRX_HEADERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRX_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_HEADER_ID | NUMBER | (15) | Yes | Identifier of the calculation sub-period |
VAR_RENT_ID | NUMBER | (15) | Yes | Identifier of the variable rent agreement |
PERIOD_ID | NUMBER | (15) | Yes | Identifier of the annual period |
LINE_ITEM_ID | NUMBER | (15) | Yes | Identifier of the line item |
GRP_DATE_ID | NUMBER | (15) | Yes | Identifier of the calculation period |
CALC_PRD_START_DATE | DATE | Start date of the calculation sub-period | ||
CALC_PRD_END_DATE | DATE | End date of the calculation sub-period | ||
VAR_RENT_SUMM_ID | NUMBER | (15) | Identifier of the variable rent summary | |
LINE_ITEM_GROUP_ID | NUMBER | Identifier of the group for this line item in the Setup table | ||
RESET_GROUP_ID | NUMBER | Identifier of the line item group at the end of a cumulative cycle after a change in break rate | ||
PRORATION_FACTOR | NUMBER | Proration factor calculated as days in the calculation sub-period divided by the total number of days in calculation period | ||
REPORTING_GROUP_SALES | NUMBER | Total sales for the calculation period | ||
PRORATED_GROUP_SALES | NUMBER | Total sales for the calculation sub-period | ||
YTD_SALES | NUMBER | Year-to-date sales for the calculation sub-period | ||
REPORTING_GROUP_SALES_FOR | NUMBER | Total forecasted sales for the calculation period | ||
PRORATED_GROUP_SALES_FOR | NUMBER | Total forecasted sales for the calculation sub-period | ||
YTD_SALES_FOR | NUMBER | Year-to-date forecasted sales for the calculation sub-period | ||
FY_PRORATION_SALES | NUMBER | Prorated sales for the first year | ||
LY_PRORATION_SALES | NUMBER | Prorated sales for the last year | ||
CALCULATED_RENT | NUMBER | Cumulative rent amount | ||
PERCENT_RENT_DUE | NUMBER | Gross variable rent for the calculation sub-period | ||
YTD_PERCENT_RENT | NUMBER | Year-to-date gross variable rent | ||
PRORATED_RENT_DUE | NUMBER | Amount of prorated rent due using the partial year calculation methods of first year, last year, and first, last, and first year and last year | ||
TRUEUP_RENT_DUE | NUMBER | Amount of true-up rent due | ||
CALCULATED_RENT_FOR | NUMBER | Cumulative forecasted rent amount | ||
PERCENT_RENT_DUE_FOR | NUMBER | Forecasted variable rent for the calculation sub-period | ||
YTD_PERCENT_RENT_FOR | NUMBER | Year-to-date forecasted rent | ||
REPORTING_GROUP_DEDUCTIONS | NUMBER | Total deduction amount for the calculation period | ||
PRORATED_GROUP_DEDUCTIONS | NUMBER | Total deduction amount for the calculation sub-period | ||
YTD_DEDUCTIONS | NUMBER | Year-to-date deduction amount | ||
LY_PRORATION_DEDUCTIONS | NUMBER | Prorated deduction for the last year | ||
FY_PRORATION_DEDUCTIONS | NUMBER | Prorated deduction for the first year | ||
FIRST_YR_RENT | NUMBER | Amount of partial first year | ||
INVOICE_FLAG | VARCHAR2 | (1) | Flag indicating whether an invoice is to be created | |
ORG_ID | NUMBER | (15) | Identifier of the operating unit | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT TRX_HEADER_ID
, VAR_RENT_ID
, PERIOD_ID
, LINE_ITEM_ID
, GRP_DATE_ID
, CALC_PRD_START_DATE
, CALC_PRD_END_DATE
, VAR_RENT_SUMM_ID
, LINE_ITEM_GROUP_ID
, RESET_GROUP_ID
, PRORATION_FACTOR
, REPORTING_GROUP_SALES
, PRORATED_GROUP_SALES
, YTD_SALES
, REPORTING_GROUP_SALES_FOR
, PRORATED_GROUP_SALES_FOR
, YTD_SALES_FOR
, FY_PRORATION_SALES
, LY_PRORATION_SALES
, CALCULATED_RENT
, PERCENT_RENT_DUE
, YTD_PERCENT_RENT
, PRORATED_RENT_DUE
, TRUEUP_RENT_DUE
, CALCULATED_RENT_FOR
, PERCENT_RENT_DUE_FOR
, YTD_PERCENT_RENT_FOR
, REPORTING_GROUP_DEDUCTIONS
, PRORATED_GROUP_DEDUCTIONS
, YTD_DEDUCTIONS
, LY_PRORATION_DEDUCTIONS
, FY_PRORATION_DEDUCTIONS
, FIRST_YR_RENT
, INVOICE_FLAG
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM PN.PN_VAR_TRX_HEADERS_ALL;
PN.PN_VAR_TRX_HEADERS_ALL does not reference any database object
PN.PN_VAR_TRX_HEADERS_ALL is referenced by following:
|
|
|