[Home] [Help] [Dependency Information]
Object Name: | OKL_AE_TEMPLATES_ALL |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_AE_TEMPLATES_ALL |
Subobject Name: | |
Status: | VALID |
A template is a child of template set and contains a group of template lines. Accounting engine does a query on this table to find out if a template exists for the given parameters (transaction type, stream type, product). When template is found, it goes to accounting template lines table to get accounts information and then accounting is initiated. This table is stripped by operating unit.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_AE_TEMPLATES_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_AE_TEMPLATES_ALL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AES_ID
TRY_ID STY_ID FACTORING_SYND_FLAG FAC_CODE SYT_CODE INV_CODE MEMO_YN START_DATE |
OKL_AE_TEMPLATES_ALL_U3 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AES_ID
NAME VERSION |
OKL_AE_TEMPLATES_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ADVANCE_ARREARS |
OKL_AE_TEMPLATES_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FAC_CODE |
OKL_AE_TEMPLATES_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FMA_ID |
OKL_AE_TEMPLATES_ALL_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SET_OF_BOOKS_ID |
OKL_AE_TEMPLATES_ALL_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | POST_TO_GL |
OKL_AE_TEMPLATES_ALL_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STY_ID |
OKL_AE_TEMPLATES_ALL_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SYT_CODE |
OKL_AE_TEMPLATES_ALL_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
SET_OF_BOOKS_ID | NUMBER | Accounting books defining column | ||
STY_ID | NUMBER | Yes | Foreign key to table OKL_STRM_TYPE_B | |
TRY_ID | NUMBER | Yes | Foreign key to table OKL_TRX_TYPES_B | |
AES_ID | NUMBER | Yes | Foreign key to table OKL_AE_TMPT_SETS | |
FMA_ID | NUMBER | Foreign key to table OKL_FORMULAE_B | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
NAME | VARCHAR2 | (150) | Yes | User entered description |
SYT_CODE | VARCHAR2 | (30) | Syndication code. Points to FND lookup OKL_SYNDICATION_CODE | |
FAC_CODE | VARCHAR2 | (30) | Factoring code. Points to FND lookup OKL_FACTORING_CODE | |
ADVANCE_ARREARS | VARCHAR2 | (30) | Not used | |
POST_TO_GL | VARCHAR2 | (30) | Not used | |
VERSION | VARCHAR2 | (24) | Version | |
START_DATE | DATE | Yes | Start date | |
MEMO_YN | VARCHAR2 | (3) | Memo flag. Values are Y or N | |
PRIOR_YEAR_YN | VARCHAR2 | (3) | Not used | |
DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
FACTORING_SYND_FLAG | VARCHAR2 | (45) | Factoring or syndication flag. Possible values are 'Factoring' or 'Syndication'. Points to FND lookup OKL_FACTORING_SYNDICATION | |
END_DATE | DATE | End date | ||
ACCRUAL_YN | VARCHAR2 | (3) | No longer used | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
INV_CODE | VARCHAR2 | (30) | Investor Code |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, SET_OF_BOOKS_ID
, STY_ID
, TRY_ID
, AES_ID
, FMA_ID
, OBJECT_VERSION_NUMBER
, NAME
, SYT_CODE
, FAC_CODE
, ADVANCE_ARREARS
, POST_TO_GL
, VERSION
, START_DATE
, MEMO_YN
, PRIOR_YEAR_YN
, DESCRIPTION
, FACTORING_SYND_FLAG
, END_DATE
, ACCRUAL_YN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, INV_CODE
FROM OKL.OKL_AE_TEMPLATES_ALL;
OKL.OKL_AE_TEMPLATES_ALL does not reference any database object
OKL.OKL_AE_TEMPLATES_ALL is referenced by following:
|
|
|