[Home] [Help] [Dependency Information]
Object Name: | PN_LOC_ACC_MAP_ALL |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_LOC_ACC_MAP_ALL |
Subobject Name: | |
Status: | VALID |
The table stores the information for mapping of expense accounts to the location for the specified accounting period. This is used when you extract the expense amount from GL to the PN_REC_EXP_ITF table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_LOC_ACC_MAP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LOC_ACC_MAP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOC_ACC_MAP_ID | NUMBER | (15) | Yes | Unique location mapping identifier for the expense account mapping with location. |
LOC_ACC_MAP_HDR_ID | NUMBER | (15) | Yes | Mapping identifier of the parent mapping to which the detail line belongs to. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column. | |
CREATION_DATE | DATE | Yes | Standard Who column. | |
CREATED_BY | NUMBER | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column. | ||
PROPERTY_ID | NUMBER | (15) | Property identifier of the property for the account mapping. | |
LOCATION_ID | NUMBER | (15) | Location identifier of the location for the account mapping. | |
ACCOUNT_LOW | VARCHAR2 | (240) | The GL account from range for mapping the account. | |
ACCOUNT_HIGH | VARCHAR2 | (240) | The GL account to range for mapping the account. | |
EXPENSE_TYPE_CODE | VARCHAR2 | (30) | Yes | The expense type associated with the location and GL account range combination. |
EFFECTIVE_FROM_DATE | DATE | Yes | The date from which the accounting period is effective. | |
EFFECTIVE_TO_DATE | DATE | Yes | The Date to which the accounting period is effective. | |
RECOVERABLE_FLAG | VARCHAR2 | (1) | The flag to indicate whether the expenses are recoverable. | |
SEGMENT1_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT1_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT2_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT2_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT3_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT3_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT4_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT4_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT5_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT5_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT6_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT6_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT7_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT7_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT8_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT8_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT9_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT9_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT10_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT10_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT11_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT11_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT12_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT12_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT13_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT13_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT14_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT14_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT15_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT15_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT16_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT16_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT17_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT17_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT18_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT18_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT19_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT19_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT20_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT20_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT21_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT21_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT22_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT22_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT23_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT23_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT24_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT24_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT25_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT25_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT26_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT26_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT27_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT27_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT28_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT28_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT29_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT29_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT30_LOW | VARCHAR2 | (25) | Key flexfield segment. | |
SEGMENT30_HIGH | VARCHAR2 | (25) | Key flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield segment. | |
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 flexfields 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 LOC_ACC_MAP_ID
, LOC_ACC_MAP_HDR_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PROPERTY_ID
, LOCATION_ID
, ACCOUNT_LOW
, ACCOUNT_HIGH
, EXPENSE_TYPE_CODE
, EFFECTIVE_FROM_DATE
, EFFECTIVE_TO_DATE
, RECOVERABLE_FLAG
, SEGMENT1_LOW
, SEGMENT1_HIGH
, SEGMENT2_LOW
, SEGMENT2_HIGH
, SEGMENT3_LOW
, SEGMENT3_HIGH
, SEGMENT4_LOW
, SEGMENT4_HIGH
, SEGMENT5_LOW
, SEGMENT5_HIGH
, SEGMENT6_LOW
, SEGMENT6_HIGH
, SEGMENT7_LOW
, SEGMENT7_HIGH
, SEGMENT8_LOW
, SEGMENT8_HIGH
, SEGMENT9_LOW
, SEGMENT9_HIGH
, SEGMENT10_LOW
, SEGMENT10_HIGH
, SEGMENT11_LOW
, SEGMENT11_HIGH
, SEGMENT12_LOW
, SEGMENT12_HIGH
, SEGMENT13_LOW
, SEGMENT13_HIGH
, SEGMENT14_LOW
, SEGMENT14_HIGH
, SEGMENT15_LOW
, SEGMENT15_HIGH
, SEGMENT16_LOW
, SEGMENT16_HIGH
, SEGMENT17_LOW
, SEGMENT17_HIGH
, SEGMENT18_LOW
, SEGMENT18_HIGH
, SEGMENT19_LOW
, SEGMENT19_HIGH
, SEGMENT20_LOW
, SEGMENT20_HIGH
, SEGMENT21_LOW
, SEGMENT21_HIGH
, SEGMENT22_LOW
, SEGMENT22_HIGH
, SEGMENT23_LOW
, SEGMENT23_HIGH
, SEGMENT24_LOW
, SEGMENT24_HIGH
, SEGMENT25_LOW
, SEGMENT25_HIGH
, SEGMENT26_LOW
, SEGMENT26_HIGH
, SEGMENT27_LOW
, SEGMENT27_HIGH
, SEGMENT28_LOW
, SEGMENT28_HIGH
, SEGMENT29_LOW
, SEGMENT29_HIGH
, SEGMENT30_LOW
, SEGMENT30_HIGH
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
FROM PN.PN_LOC_ACC_MAP_ALL;
PN.PN_LOC_ACC_MAP_ALL does not reference any database object
PN.PN_LOC_ACC_MAP_ALL is referenced by following:
|
|
|