[Home] [Help] [Dependency Information]
Object Name: | PSA_BC_ALLOC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view stores the source distribution and allocation information. This information is used to link related transactions together
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
LEDGER_ID | NUMBER | (15) | Accounting books defining column | |
EVENT_ID | NUMBER | (15) | Business event identifier | |
ENTITY_ID | NUMBER | (15) | Entity identifier | |
AE_HEADER_ID | NUMBER | (15) | Yes | XLA journal entry header defining column |
AE_LINE_NUM | NUMBER | (15) | XLA journal entry line defining column | |
ENTITY_CODE | VARCHAR2 | (30) | Yes | Entity code |
SOURCE_ID_INT_1 | NUMBER | (15) | Source identifier (number) | |
SOURCE_ID_INT_2 | NUMBER | (15) | Source identifier (number) | |
SOURCE_ID_INT_3 | NUMBER | (15) | Source identifier (number) | |
SOURCE_ID_INT_4 | NUMBER | (15) | Source identifier (number) | |
SOURCE_ID_CHAR_1 | VARCHAR2 | (30) | Source identifier (char) | |
SOURCE_ID_CHAR_2 | VARCHAR2 | (30) | Source identifier (char) | |
SOURCE_ID_CHAR_3 | VARCHAR2 | (30) | Source identifier (char) | |
SOURCE_ID_CHAR_4 | VARCHAR2 | (30) | Source identifier (char) | |
APPLICATION_ID | NUMBER | (15) | Yes | Application identifier |
SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | Source distribution identifier (number) | ||
SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | Source distribution identifier (number) | ||
SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | Source distribution identifier (number) | ||
SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | Source distribution identifier (number) | ||
SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | Source distribution identifier (number) | ||
SOURCE_DISTRIBUTION_ID_CHAR_1 | VARCHAR2 | (240) | Source distribution identifier (char) | |
SOURCE_DISTRIBUTION_ID_CHAR_2 | VARCHAR2 | (240) | Source distribution identifier (char) | |
SOURCE_DISTRIBUTION_ID_CHAR_3 | VARCHAR2 | (240) | Source distribution identifier (char) | |
SOURCE_DISTRIBUTION_ID_CHAR_4 | VARCHAR2 | (240) | Source distribution identifier (char) | |
SOURCE_DISTRIBUTION_ID_CHAR_5 | VARCHAR2 | (240) | Source distribution identifier (char) | |
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Source distribution type | |
ALLOC_TO_ENTITY_CODE | VARCHAR2 | (30) | Allocation to entity code | |
ALLOC_TO_SOURCE_ID_NUM_1 | NUMBER | (15) | Allocation to source identifier (number) | |
ALLOC_TO_SOURCE_ID_NUM_2 | NUMBER | (15) | Allocation to source identifier (number) | |
ALLOC_TO_SOURCE_ID_NUM_3 | NUMBER | (15) | Allocation to source identifier (number) | |
ALLOC_TO_SOURCE_ID_NUM_4 | NUMBER | (15) | Allocation to source identifier (number) | |
ALLOC_TO_SOURCE_ID_CHAR_1 | VARCHAR2 | (30) | Allocation to source identifier (char) | |
ALLOC_TO_SOURCE_ID_CHAR_2 | VARCHAR2 | (30) | Allocation to source identifier (char) | |
ALLOC_TO_SOURCE_ID_CHAR_3 | VARCHAR2 | (30) | Allocation to source identifier (char) | |
ALLOC_TO_SOURCE_ID_CHAR_4 | VARCHAR2 | (30) | Allocation to source identifier (char) | |
ALLOC_TO_APPLICATION_ID | NUMBER | (15) | Allocation to application identifier | |
ALLOC_TO_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Allocation to distribution type | |
ALLOC_TO_DIST_ID_NUM_1 | NUMBER | (15) | Allocation to distribution identifier (number) | |
ALLOC_TO_DIST_ID_NUM_2 | NUMBER | (15) | Allocation to distribution identifier (number) | |
ALLOC_TO_DIST_ID_NUM_3 | NUMBER | (15) | Allocation to distribution identifier (number) | |
ALLOC_TO_DIST_ID_NUM_4 | NUMBER | (15) | Allocation to distribution identifier (number) | |
ALLOC_TO_DIST_ID_NUM_5 | NUMBER | (15) | Allocation to distribution identifier (number) | |
ALLOC_TO_DIST_ID_CHAR_1 | VARCHAR2 | (30) | Allocation to distribution identifier (char) | |
ALLOC_TO_DIST_ID_CHAR_2 | VARCHAR2 | (30) | Allocation to distribution identifier (char) | |
ALLOC_TO_DIST_ID_CHAR_3 | VARCHAR2 | (30) | Allocation to distribution identifier (char) | |
ALLOC_TO_DIST_ID_CHAR_4 | VARCHAR2 | (30) | Allocation to distribution identifier (char) | |
ALLOC_TO_DIST_ID_CHAR_5 | VARCHAR2 | (30) | Allocation to distribution identifier (char) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, LEDGER_ID
, EVENT_ID
, ENTITY_ID
, AE_HEADER_ID
, AE_LINE_NUM
, ENTITY_CODE
, SOURCE_ID_INT_1
, SOURCE_ID_INT_2
, SOURCE_ID_INT_3
, SOURCE_ID_INT_4
, SOURCE_ID_CHAR_1
, SOURCE_ID_CHAR_2
, SOURCE_ID_CHAR_3
, SOURCE_ID_CHAR_4
, APPLICATION_ID
, SOURCE_DISTRIBUTION_ID_NUM_1
, SOURCE_DISTRIBUTION_ID_NUM_2
, SOURCE_DISTRIBUTION_ID_NUM_3
, SOURCE_DISTRIBUTION_ID_NUM_4
, SOURCE_DISTRIBUTION_ID_NUM_5
, SOURCE_DISTRIBUTION_ID_CHAR_1
, SOURCE_DISTRIBUTION_ID_CHAR_2
, SOURCE_DISTRIBUTION_ID_CHAR_3
, SOURCE_DISTRIBUTION_ID_CHAR_4
, SOURCE_DISTRIBUTION_ID_CHAR_5
, SOURCE_DISTRIBUTION_TYPE
, ALLOC_TO_ENTITY_CODE
, ALLOC_TO_SOURCE_ID_NUM_1
, ALLOC_TO_SOURCE_ID_NUM_2
, ALLOC_TO_SOURCE_ID_NUM_3
, ALLOC_TO_SOURCE_ID_NUM_4
, ALLOC_TO_SOURCE_ID_CHAR_1
, ALLOC_TO_SOURCE_ID_CHAR_2
, ALLOC_TO_SOURCE_ID_CHAR_3
, ALLOC_TO_SOURCE_ID_CHAR_4
, ALLOC_TO_APPLICATION_ID
, ALLOC_TO_DISTRIBUTION_TYPE
, ALLOC_TO_DIST_ID_NUM_1
, ALLOC_TO_DIST_ID_NUM_2
, ALLOC_TO_DIST_ID_NUM_3
, ALLOC_TO_DIST_ID_NUM_4
, ALLOC_TO_DIST_ID_NUM_5
, ALLOC_TO_DIST_ID_CHAR_1
, ALLOC_TO_DIST_ID_CHAR_2
, ALLOC_TO_DIST_ID_CHAR_3
, ALLOC_TO_DIST_ID_CHAR_4
, ALLOC_TO_DIST_ID_CHAR_5
FROM APPS.PSA_BC_ALLOC_V;
|
|
|