[Home] [Help] [Dependency Information]
Object Name: | PN_VAR_DEDUCTIONS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_VAR_DEDUCTIONS_ALL |
Subobject Name: | |
Status: | VALID |
Stores deductions to be applied to each line item for calculation of variable rent, deduction type, related start and end dates, deduction type and account information.This table is partitioned by org.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_VAR_DEDUCTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DEDUCTION_ID |
PN_VAR_DEDUCTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GRP_DATE_ID |
PN_VAR_DEDUCTIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PERIOD_ID |
PN_VAR_DEDUCTIONS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LINE_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEDUCTION_ID | NUMBER | Yes | Uniquely identifies the deductions row. | |
DEDUCTION_NUM | NUMBER | Yes | Unique number of a deductions row. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
LINE_ITEM_ID | NUMBER | Associates the deductions row with a lines row in PN_VAR_LINES_ALL. | ||
PERIOD_ID | NUMBER | Associates the deductions row with a period row in PN_VAR_PERIODS_ALL. | ||
START_DATE | DATE | Yes | Deduction start date from which deduction will be applicable to variable rent. | |
END_DATE | DATE | Yes | Deduction end date before which deduction will be applicable to variable rent. | |
GRP_DATE_ID | NUMBER | Associates the deductions row with a group date row in PN_VAR_GRP_DATES_ALL. | ||
GROUP_DATE | DATE | Yes | Group date selected from PN_VAR_GRP_DATES_ALL based on Deduction start date and Deduction end date. | |
INVOICING_DATE | DATE | Yes | Invoicing date selected from PN_VAR_GRP_DATES_ALL based on Deduction start date and Deduction end date. | |
GL_ACCOUNT_ID | NUMBER | Associates the account id in GL_CODE_COMBINATIONS table with the deductions row. | ||
DEDUCTION_TYPE_CODE | VARCHAR2 | (30) | Identifies the deduction type.The value is derived from lookup_code in FND_LOOKUPS where lookup_type = PN_DEDUCTION_TYPE. | |
DEDUCTION_AMOUNT | NUMBER | Yes | Deduction Amount. | |
EXPORTED_CODE | VARCHAR2 | (1) | Yes | Identifies if a variable rent amount has been exported using this deduction amount. |
COMMENTS | VARCHAR2 | (2000) | Comments related to the deductions row. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ORG_ID | NUMBER | (15) | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT DEDUCTION_ID
, DEDUCTION_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LINE_ITEM_ID
, PERIOD_ID
, START_DATE
, END_DATE
, GRP_DATE_ID
, GROUP_DATE
, INVOICING_DATE
, GL_ACCOUNT_ID
, DEDUCTION_TYPE_CODE
, DEDUCTION_AMOUNT
, EXPORTED_CODE
, COMMENTS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
FROM PN.PN_VAR_DEDUCTIONS_ALL;
PN.PN_VAR_DEDUCTIONS_ALL does not reference any database object
PN.PN_VAR_DEDUCTIONS_ALL is referenced by following:
|
|
|