[Home] [Help] [Dependency Information]
Object Name: | JAI_RGM_BALANCE_T |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_RGM_BALANCE_T |
Subobject Name: | |
Status: | VALID |
This table has the debit and credit balances for every organization and location for every tax type.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | The request Identifier generated for the every call of the balance calculation routine. | ||
REGIME_ID | NUMBER | The Regime for which the balances are being calculated. | ||
PARTY_TYPE | VARCHAR2 | (30) | The Party Type - "IO" - Inventory Organization , "OU" Operating Unit | |
PARTY_ID | NUMBER | The Internal Identifier of the Organization | ||
LOCATION_ID | NUMBER | The Internal Identifier of the Location. | ||
BALANCE_DATE | DATE | The date as on which the balances are calculated. | ||
TAX_TYPE | VARCHAR2 | (30) | The Tax Type for which the balance is calculated. | |
DEBIT_AMT | NUMBER | Debit Amount For the Organization | ||
CREDIT_AMT | NUMBER | Credit Amount for the Organization. | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object Version Number. | |
PROGRAM_ID | NUMBER | Identifies the concurrent program | ||
PROGRAM_LOGIN_ID | NUMBER | Identifies the Oracle Applications Concurrent Program Login ID | ||
PROGRAM_APPLICATION_ID | NUMBER | Identifies the Oracle Application that spawned the concurrent program | ||
PLA_BALANCE | NUMBER | Stores PLA Balance. | ||
JAI_RGM_BALANCE_T | VARCHAR2 | (30) | ||
SERVICE_TYPE_CODE | VARCHAR2 | (30) | Indicates the service type in the repository |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, REGIME_ID
, PARTY_TYPE
, PARTY_ID
, LOCATION_ID
, BALANCE_DATE
, TAX_TYPE
, DEBIT_AMT
, CREDIT_AMT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, PLA_BALANCE
, JAI_RGM_BALANCE_T
, SERVICE_TYPE_CODE
FROM JA.JAI_RGM_BALANCE_T;
JA.JAI_RGM_BALANCE_T does not reference any database object
JA.JAI_RGM_BALANCE_T is referenced by following:
|
|
|