[Home] [Help] [Dependency Information]
Object Name: | PSA_BC_REPORT_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 is used by the Budgetary Control Results report and works as a source of budgetary control data for the report. This view is later joined to other transaction tables to form the report output.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
APPLICATION_ID | NUMBER | (15) | Application identifier | |
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Yes | Application short name |
APPLICATION_NAME | VARCHAR2 | (240) | Yes | Application name |
LEDGER_ID | NUMBER | (15) | Accounting books defining column | |
EVENT_ID | NUMBER | (15) | Event identifier | |
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Source distribution type | |
SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | (38) | Source distribution identifier (number) | |
SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | (38) | Source distribution identifier (number) | |
SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | (38) | Source distribution identifier (number) | |
SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | (38) | Source distribution identifier (number) | |
SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | (38) | 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) | |
PACKET_ID | NUMBER | (15) | Budgetary control packet defining column | |
JE_SOURCE_NAME | VARCHAR2 | (25) | Journal entry source name | |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Journal entry category name | |
CODE_COMBINATION_ID | NUMBER | (15) | Code combination identifier | |
ACTUAL_FLAG | VARCHAR2 | (1) | Actual flag | |
PERIOD_NAME | VARCHAR2 | (15) | Period name | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
STATUS_CODE | VARCHAR2 | (1) | Status code | |
BUDGET_TYPE | VARCHAR2 | (15) | Budget type | |
BUDGET_VERSION_ID | NUMBER | (15) | Budget version identifier | |
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | Encumbrance type identifier | |
TEMPLATE_ID | NUMBER | (15) | Template identifier | |
ENTERED_DR | NUMBER | Journal entry line debit amount in entered currency | ||
ENTERED_CR | NUMBER | Journal entry line credit amount in entered currency | ||
ACCOUNTED_DR | VARCHAR2 | (40) | Journal entry line debit amount in base currency | |
ACCOUNTED_CR | VARCHAR2 | (40) | Journal entry line credit amount in base currency | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | Government USSGL Transaction code | |
ACCOUNT_SEGMENT_VALUE | VARCHAR2 | (25) | Account segment value | |
AUTOMATIC_ENCUMBRANCE_FLAG | VARCHAR2 | (1) | Automatic encumbrance flag | |
FUNDING_BUDGET_VERSION_ID | NUMBER | (15) | Funding budget version identifier | |
FUNDS_CHECK_LEVEL_CODE | VARCHAR2 | (1) | Funds check level code | |
AMOUNT_TYPE | VARCHAR2 | (4) | Amount type | |
BOUNDARY_CODE | VARCHAR2 | (1) | Boundary code | |
TOLERANCE_PERCENTAGE | NUMBER | Percentage of funding budget that can be exceeded | ||
TOLERANCE_AMOUNT | NUMBER | Amount of funding budget that can be exceeded | ||
OVERRIDE_AMOUNT | NUMBER | Maximum transaction amount that can be used to override a funds check failure | ||
DR_CR_CODE | VARCHAR2 | (1) | Debit or credit transaction | |
ACCOUNT_TYPE | VARCHAR2 | (1) | Key flexfield combination type (Asset, liability, ..., Budgetary Dr/Cr) | |
ACCOUNT_CATEGORY_CODE | VARCHAR2 | (1) | Key flexfield category (Proprietary or budgetary) | |
EFFECT_ON_FUNDS_CODE | VARCHAR2 | (1) | Effect of transaction on funds available, increasing or decreasing | |
RESULT_CODE | VARCHAR2 | (3) | Result of funds check/reservation | |
BUDGET_POSTED_BALANCE | VARCHAR2 | (40) | Posted balance used in funds available calculation | |
ACTUAL_POSTED_BALANCE | VARCHAR2 | (40) | Posted balance used in funds available calculation | |
COMM_ENC_POSTED_BAL | VARCHAR2 | (40) | Posted balance used in funds available calculation | |
OBLI_ENC_POSTED_BAL | VARCHAR2 | (40) | Posted balance used in funds available calculation | |
ENC_POSTED_BALANCE | VARCHAR2 | (40) | Posted balance used in funds available calculation | |
BUDGET_APPROVED_BALANCE | VARCHAR2 | (40) | Balance approved, but not posted | |
ACTUAL_APPROVED_BALANCE | VARCHAR2 | (40) | Balance approved, but not posted | |
COMM_ENC_APPROVED_BAL | VARCHAR2 | (40) | Balance approved, but not posted | |
OBLI_ENC_APPROVED_BAL | VARCHAR2 | (40) | Balance approved, but not posted | |
ENC_APPROVED_BALANCE | VARCHAR2 | (40) | Balance approved, but not posted | |
BUDGET_PENDING_BALANCE | VARCHAR2 | (40) | Balance pending funds check | |
ACTUAL_PENDING_BALANCE | VARCHAR2 | (40) | Balance pending funds check | |
COMM_ENC_PENDING_BAL | VARCHAR2 | (40) | Balance pending funds check | |
OBLI_ENC_PENDING_BAL | VARCHAR2 | (40) | Balance pending funds check | |
ENC_PENDING_BALANCE | VARCHAR2 | (40) | Balance pending funds check | |
BUDGET_TOTAL_BALANCE | VARCHAR2 | (40) | Balance pending funds check | |
COMM_ENC_TOTAL_BAL | VARCHAR2 | (40) | Commitment encumbrance total balance | |
OBLI_ENC_TOTAL_BAL | VARCHAR2 | (40) | Obligation encumbrance total balance | |
ENC_TOTAL_BALANCE | VARCHAR2 | (40) | Encumbrance total balance | |
ACTUAL_TOTAL_BALANCE | VARCHAR2 | (40) | Actual total balance | |
AVAIL_POSTED_BALANCE | VARCHAR2 | (40) | Available posted balance | |
AVAIL_APPROVED_BALANCE | VARCHAR2 | (40) | Available approved balance | |
AVAIL_PENDING_BALANCE | VARCHAR2 | (40) | Available pending balance | |
AVAIL_TOTAL_BALANCE | VARCHAR2 | (40) | Available total balance | |
REFERENCE1 | VARCHAR2 | (100) | Journal entry line reference | |
REFERENCE2 | VARCHAR2 | (100) | Journal entry line reference | |
REFERENCE3 | VARCHAR2 | (100) | Journal entry line reference | |
REFERENCE4 | VARCHAR2 | (100) | Journal entry line reference | |
REFERENCE5 | VARCHAR2 | (100) | Journal entry line reference | |
REFERENCE13 | VARCHAR2 | (100) | Journal entry line reference | |
REFERENCE14 | VARCHAR2 | (100) | Journal entry line reference | |
REFERENCE15 | VARCHAR2 | (100) | Journal entry line reference | |
JE_BATCH_NAME | VARCHAR2 | (100) | Journal entry batch name | |
JE_BATCH_ID | NUMBER | (15) | Journal entry batch identifier | |
JE_HEADER_ID | NUMBER | (15) | Journal entry header identifier | |
JE_LINE_NUM | NUMBER | (15) | Journal entry line number | |
JE_LINE_DESCRIPTION | VARCHAR2 | (240) | Journal entry line description | |
USER_JE_CATEGORY_NAME | VARCHAR2 | (25) | Yes | Journal entry category name |
USER_JE_SOURCE_NAME | VARCHAR2 | (25) | Yes | Journal entry source name |
TRANSACTION_AMOUNT | NUMBER | Transaction amount | ||
CURRENT_FUNDS_AVAILABLE | VARCHAR2 | (40) | Current Funds Available | |
ACTUAL_FLAG_MEANING | VARCHAR2 | (0) | Meaning of actual flag | |
ENCUMBRANCE_TYPE | VARCHAR2 | (30) | Encumbrance type | |
STATUS_CODE_MEANING | VARCHAR2 | (0) | Meaning of status code | |
RESULT_CODE_MEANING | VARCHAR2 | (0) | Meaning of result code | |
FUNDING_BUDGET_NAME | VARCHAR2 | (15) | Funding budget name | |
AMOUNT_TYPE_MEANING | VARCHAR2 | (0) | Amount type meaning | |
BOUNDARY_MEANING | VARCHAR2 | (0) | Boundary meaning | |
TEMPLATE | VARCHAR2 | (240) | Sumarry template | |
LEVEL_MEANING | VARCHAR2 | (0) | Budget level meaning | |
ACCOUNT_TYPE_MEANING | VARCHAR2 | (0) | Account type meaning | |
EFFECT_ON_FUNDS_MEANING | VARCHAR2 | (0) | Effect on funds (Decreasing or Increasing) | |
BATCH_NAME | VARCHAR2 | (100) | Batch name | |
HEADER_NAME | VARCHAR2 | (100) | Header name | |
AE_HEADER_ID | NUMBER | (15) | XLA journal entry header defining column | |
AE_LINE_NUM | NUMBER | (15) | XLA journal entry line defining column | |
PERIOD_NUM | NUMBER | (15) | Period number | |
PERIOD_YEAR | NUMBER | (15) | Period year | |
QUARTER_NUM | NUMBER | (15) | Period number | |
EFFECTIVE_STATUS | VARCHAR2 | (1) | Effective status |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, APPLICATION_ID
, APPLICATION_SHORT_NAME
, APPLICATION_NAME
, LEDGER_ID
, EVENT_ID
, SOURCE_DISTRIBUTION_TYPE
, 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
, PACKET_ID
, JE_SOURCE_NAME
, JE_CATEGORY_NAME
, CODE_COMBINATION_ID
, ACTUAL_FLAG
, PERIOD_NAME
, CURRENCY_CODE
, STATUS_CODE
, BUDGET_TYPE
, BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID
, TEMPLATE_ID
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, USSGL_TRANSACTION_CODE
, ACCOUNT_SEGMENT_VALUE
, AUTOMATIC_ENCUMBRANCE_FLAG
, FUNDING_BUDGET_VERSION_ID
, FUNDS_CHECK_LEVEL_CODE
, AMOUNT_TYPE
, BOUNDARY_CODE
, TOLERANCE_PERCENTAGE
, TOLERANCE_AMOUNT
, OVERRIDE_AMOUNT
, DR_CR_CODE
, ACCOUNT_TYPE
, ACCOUNT_CATEGORY_CODE
, EFFECT_ON_FUNDS_CODE
, RESULT_CODE
, BUDGET_POSTED_BALANCE
, ACTUAL_POSTED_BALANCE
, COMM_ENC_POSTED_BAL
, OBLI_ENC_POSTED_BAL
, ENC_POSTED_BALANCE
, BUDGET_APPROVED_BALANCE
, ACTUAL_APPROVED_BALANCE
, COMM_ENC_APPROVED_BAL
, OBLI_ENC_APPROVED_BAL
, ENC_APPROVED_BALANCE
, BUDGET_PENDING_BALANCE
, ACTUAL_PENDING_BALANCE
, COMM_ENC_PENDING_BAL
, OBLI_ENC_PENDING_BAL
, ENC_PENDING_BALANCE
, BUDGET_TOTAL_BALANCE
, COMM_ENC_TOTAL_BAL
, OBLI_ENC_TOTAL_BAL
, ENC_TOTAL_BALANCE
, ACTUAL_TOTAL_BALANCE
, AVAIL_POSTED_BALANCE
, AVAIL_APPROVED_BALANCE
, AVAIL_PENDING_BALANCE
, AVAIL_TOTAL_BALANCE
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, REFERENCE13
, REFERENCE14
, REFERENCE15
, JE_BATCH_NAME
, JE_BATCH_ID
, JE_HEADER_ID
, JE_LINE_NUM
, JE_LINE_DESCRIPTION
, USER_JE_CATEGORY_NAME
, USER_JE_SOURCE_NAME
, TRANSACTION_AMOUNT
, CURRENT_FUNDS_AVAILABLE
, ACTUAL_FLAG_MEANING
, ENCUMBRANCE_TYPE
, STATUS_CODE_MEANING
, RESULT_CODE_MEANING
, FUNDING_BUDGET_NAME
, AMOUNT_TYPE_MEANING
, BOUNDARY_MEANING
, TEMPLATE
, LEVEL_MEANING
, ACCOUNT_TYPE_MEANING
, EFFECT_ON_FUNDS_MEANING
, BATCH_NAME
, HEADER_NAME
, AE_HEADER_ID
, AE_LINE_NUM
, PERIOD_NUM
, PERIOD_YEAR
, QUARTER_NUM
, EFFECTIVE_STATUS
FROM APPS.PSA_BC_REPORT_V;
|
|
|