[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_SUBR_STA |
|---|---|
| Object Type: | TABLE |
| Owner: | GMF |
| FND Design Data: |  GMF.GL_SUBR_STA
|
| Subobject Name: | |
| Status: | VALID |
Subsidiary ledger update state.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_SUBR_STA_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 REFERENCE_NO
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CLOSED_PER_IND | NUMBER | (2) | Yes | Indicates if the OPM transactions being posted are in a Closed GL Period. 1 - The OPM transactions are in a Closed GL Period. 0 = The OPM transactions are in a valid Open GL Period. |
| GL_DATE | DATE | When closed_per_ind = 1, gl_date is a valid date in an Open GL Period to be used for posting the transactions. Otherwise it is NULL. | ||
| GL_FISCAL_YEAR | NUMBER | (5) | The GL Fiscal Year of the transactions. When closed_per_ind = 0 it is the same as fiscal_year. When closed_per_ind = 1 it is the GL Fiscal Year of GL_DATE. | |
| REFERENCE_NO | NUMBER | (10) | Yes | Reference number of Subledger Update run. |
| GL_PERIOD | NUMBER | (5) | The GL Period of the transactions. When CLOSED_PER_IND = 0 it is the same as PERIOD; when CLOSED_PER_IND = 1 it is the GL Period of GL_DATE. | |
| CO_CODE | VARCHAR2 | (4) | Company of Subledger Update. | |
| CURRENT_STATE | NUMBER | (5) | Yes | Subledger Update is running or not. |
| START_TIME | DATE | Date and time process starts. | ||
| END_TIME | DATE | Date and time process completes. | ||
| COMPLETION_IND | NUMBER | (5) | Yes | Completion type. 0=Normal completion;1= process is aborted. |
| STARTED_BY | NUMBER | (15) | Yes | Operator code of last user who started update routine. |
| STOP_IND | NUMBER | (5) | Yes | Control parameter to stop program. 0=keep running; 1=stop or abort process. |
| FISCAL_YEAR | NUMBER | (5) | Yes | Fiscal year of run. |
| PERIOD | NUMBER | (5) | Yes | GL period of run. |
| PERIOD_START_DATE | DATE | Yes | SubLedger posting start date (defaults to GL period start date.) | |
| PERIOD_END_DATE | DATE | Yes | Subledger posting end date (defaults to GL period end date.) | |
| TEST_POSTING | NUMBER | (5) | Yes | Test Subledger or Live Subledger run. 0 - Live run; 1 - Test run |
| POST_IC | NUMBER | (5) | Request to post Inventory Transactions to Subledger. 1 - Post Inventory transactions; 0 - Do not post Inventory transactions. | |
| POST_OP | NUMBER | (5) | Request to Order Processing Transactions to Subledger. 1 - Post Order Processing transactions; 0 - Do not post Order Processing transactions. | |
| POST_PM | NUMBER | (5) | Request to post Production Management Transactions to Subledger. 1 - Post Production Management transactions; 0 - Do not post Production Management transactions. | |
| POST_PO | NUMBER | (5) | Request to post Purchasing Transactions to Subledger. 1 - Post Purchasing transactions; 0 - Do not post Purchasing transactions. | |
| POST_CM | NUMBER | (5) | Request to post Cost Revaluation Transactions to Subledger. 1 - Post Cost Revaluation transactions; 0 - Do not post Cost Revaluation transactions. | |
| SCHEDULED_ON | VARCHAR2 | (32) | Yes | Date and time process is scheduled to start |
| ABORTED_BY | NUMBER | (15) | Operator Code of user who aborted the run. | |
| UPDATE_STAGE | NUMBER | (5) | Used for diagnostic information when process ends abnormally | |
| ERRORS_FOUND | NUMBER | (10) | # of errors found. | |
| ERRORS_POSTED | NUMBER | (10) | # of unique errors. | |
| ERRORS_LIMIT | NUMBER | (10) | ** Not Used ** | |
| ROWS_POSTED | NUMBER | (10) | # of rows posted to the Subsidiary Ledger. | |
| ABORT_REASON | VARCHAR2 | (70) | Reason for abort. | |
| CREATION_DATE | DATE | Yes | Standard who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
| IN_USE | NUMBER | (5) | Not currently used | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent who column | |
| PROGRAM_ID | NUMBER | (15) | Concurrent who column | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent who column | ||
| REQUEST_ID | NUMBER | (15) | Concurrent who column | |
| POST_OM | NUMBER | (5) | Indicates the Subledger process if OM Shipments' inventory transactions in OPM need to be booked or not. | |
| INCL_NO_COST | NUMBER | (5) | Flag to include or exclued transactions without GL item costs established | |
| POST_PUR | NUMBER | (5) | Request to post Oracle Purchasing Transactions to Subledger. | |
| DEFAULT_LANGUAGE | VARCHAR2 | (4) | User Default Language | |
| CREV_CURR_CALENDAR | VARCHAR2 | (10) | Cost Revaluation Current Cost Calendar | |
| CREV_CURR_MTHD | VARCHAR2 | (10) | Cost Revaluation Current Cost Method | |
| CREV_CURR_PERIOD | VARCHAR2 | (10) | Cost Revaluation Current Cost Period | |
| CREV_GL_TRANS_DATE | DATE | Cost Revaluation GL Transaction Date | ||
| CREV_INV_PREV_CAL | VARCHAR2 | (10) | Cost Revaluation Previous Inventory Calendar | |
| CREV_INV_PREV_PER | NUMBER | (15) | Cost Revaluation Previous Inventory Period | |
| CREV_PREV_CALENDAR | VARCHAR2 | (10) | Cost Revaluation Previous Cost Calendar | |
| CREV_PREV_MTHD | VARCHAR2 | (10) | Cost Revaluation Previous Cost Method | |
| CREV_PREV_PERIOD | VARCHAR2 | (10) | Cost Revaluation Previous Cost Period | |
| BASE_CURRENCY | VARCHAR2 | (15) | Base Currency of the Legal Entity | |
| COST_BASIS | NUMBER | Basis for costs: 0 = current period costs; 1 = prior period costs | ||
| COST_MTHD_CODE | VARCHAR2 | (10) | Valuation Cost Type code | |
| COST_TYPE | NUMBER | Valuation Cost Type | ||
| COST_TYPE_ID | NUMBER | Valuation Cost Type identifier | ||
| CREV_CURR_COST_TYPE_ID | NUMBER | Inventory Revaluation Current Cost Type identifier | ||
| CREV_CURR_PERIOD_ID | NUMBER | Inventory Revaluation Current Cost Period identifier | ||
| CREV_PREV_COST_TYPE_ID | NUMBER | Inventory Revaluation Prior Cost Type identifier | ||
| CREV_PREV_PERIOD_ID | NUMBER | Inventory Revaluation Prior Cost Period identifier | ||
| DEFAULT_COST_MTHD_CODE | VARCHAR2 | (10) | Alternate cost type for lot cost valuation cost type | |
| DEFAULT_COST_TYPE_ID | NUMBER | Alternate cost type identifier for lot cost valuation cost type | ||
| EXTRACT_HDR_ROWS_POSTED | NUMBER | Number of rows created in SLA extract header table | ||
| EXTRACT_LINE_ROWS_POSTED | NUMBER | Number of rows created in SLA extract lines table | ||
| LEDGER_ID | NUMBER | Ledger identifier | ||
| LEGAL_ENTITY_ID | NUMBER | Legal Entity identifier | ||
| LEGAL_ENTITY_NAME | VARCHAR2 | (240) | Legal Entity Name | |
| PERIOD_ID | NUMBER | (15) | Cost Period identifier | |
| PROCESS_CATEGORY | VARCHAR2 | (100) | Accounting Process Category | |
| POST_CM_CADJ | NUMBER | (5) | Post Actual Cost Adjustments to Subledger: 1 = Yes; 0 = No | |
| POST_CM_RVAL | NUMBER | (5) | Post Cost Revaluations to Subledger: 1 = Yes; 0 = No | |
| POST_GL_ALOC | NUMBER | (5) | This is the post gl post allocation | |
| BATCH_ID_FROM | NUMBER | From Batch Id for production source | ||
| BATCH_ID_TO | NUMBER | Batch Id To for production source | ||
| NUM_OF_PROCESS | NUMBER | (5) | Number of process | |
| POST_TXN_CMPT_COST | NUMBER | (5) | Post Transaction at Component cost (1) or Item cost (0) |
Cut, paste (and edit) the following text to query this object:
SELECT CLOSED_PER_IND
, GL_DATE
, GL_FISCAL_YEAR
, REFERENCE_NO
, GL_PERIOD
, CO_CODE
, CURRENT_STATE
, START_TIME
, END_TIME
, COMPLETION_IND
, STARTED_BY
, STOP_IND
, FISCAL_YEAR
, PERIOD
, PERIOD_START_DATE
, PERIOD_END_DATE
, TEST_POSTING
, POST_IC
, POST_OP
, POST_PM
, POST_PO
, POST_CM
, SCHEDULED_ON
, ABORTED_BY
, UPDATE_STAGE
, ERRORS_FOUND
, ERRORS_POSTED
, ERRORS_LIMIT
, ROWS_POSTED
, ABORT_REASON
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DELETE_MARK
, IN_USE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, POST_OM
, INCL_NO_COST
, POST_PUR
, DEFAULT_LANGUAGE
, CREV_CURR_CALENDAR
, CREV_CURR_MTHD
, CREV_CURR_PERIOD
, CREV_GL_TRANS_DATE
, CREV_INV_PREV_CAL
, CREV_INV_PREV_PER
, CREV_PREV_CALENDAR
, CREV_PREV_MTHD
, CREV_PREV_PERIOD
, BASE_CURRENCY
, COST_BASIS
, COST_MTHD_CODE
, COST_TYPE
, COST_TYPE_ID
, CREV_CURR_COST_TYPE_ID
, CREV_CURR_PERIOD_ID
, CREV_PREV_COST_TYPE_ID
, CREV_PREV_PERIOD_ID
, DEFAULT_COST_MTHD_CODE
, DEFAULT_COST_TYPE_ID
, EXTRACT_HDR_ROWS_POSTED
, EXTRACT_LINE_ROWS_POSTED
, LEDGER_ID
, LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME
, PERIOD_ID
, PROCESS_CATEGORY
, POST_CM_CADJ
, POST_CM_RVAL
, POST_GL_ALOC
, BATCH_ID_FROM
, BATCH_ID_TO
, NUM_OF_PROCESS
, POST_TXN_CMPT_COST
FROM GMF.GL_SUBR_STA;
GMF.GL_SUBR_STA does not reference any database object
GMF.GL_SUBR_STA is referenced by following:
GMF
GL_SUBR_STA#
|
|
|
|