eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKL.OKL_TRNS_ACC_DSTRS_ALL

Object Details

Object Name:	OKL_TRNS_ACC_DSTRS_ALL
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_TRNS_ACC_DSTRS_ALL
Subobject Name:
Status:	VALID

Any call to accounting results in the creation of records in this table. Accounting engine gets the account and percentage information from template line table and populates this table. This table holds both draft and final entries. Only final entries and those which have post_to_gl = 'Y' are accounted and go further to subledger accounting tables, other entries just remain in this table. One of the important flags in
this table is posted_yn which has got values of 'Y'

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TRNS_ACC_DSTRS_ALL_U1	NORMAL	UNIQUE	APPS_TS_NOLOGGING	ID
OKL_TRNS_ACC_DSTRS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AET_ID
OKL_TRNS_ACC_DSTRS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSTED_YN
OKL_TRNS_ACC_DSTRS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID
OKL_TRNS_ACC_DSTRS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
OKL_TRNS_ACC_DSTRS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_DATE
OKL_TRNS_ACC_DSTRS_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ID SOURCE_TABLE
OKL_TRNS_ACC_DSTRS_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_EVENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
AET_ID	NUMBER			Foreign key to table OKL_ACCOUNTING_EVENTS
SET_OF_BOOKS_ID	NUMBER		Yes	Accounting books defining column
CR_DR_FLAG	VARCHAR2	(30)		Debit Credit Flag. Values are 'C' or 'D'
CODE_COMBINATION_ID	NUMBER			Key flexfield combination defining column
ORG_ID	NUMBER			Operating unit identifier
CURRENCY_CODE	VARCHAR2	(3)	Yes	Currency code
AE_LINE_TYPE	VARCHAR2	(30)		Accounting event line type
TEMPLATE_ID	NUMBER			Template identifier. Foreign Key to OKL_AE_TEMPLATES
SOURCE_ID	NUMBER			Value of the primary key of the transaction record which caused this accounting
SOURCE_TABLE	VARCHAR2	(30)		Table which holds the transaction record which caused this accounting
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
AMOUNT	NUMBER			Amount
ACCOUNTED_AMOUNT	NUMBER			Distribution amount in functional currency
GL_DATE	DATE			General ledger date
PERCENTAGE	NUMBER	(5)		Distribution percentage. This value comes from template line
COMMENTS	VARCHAR2	(1995)		User entered comments
POST_REQUEST_ID	NUMBER			Surrogate key used for primary unique identifiers
POSTED_YN	VARCHAR2	(3)		Indicates whether this distribution has been posted to subledger tables. Possible values are 'Y' (yes) , 'N' (No) or 'S' (selected). When the accounting process runs, it updates the POSTED_YN flag of the selected distributions to 'S'.
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
CURRENCY_CONVERSION_RATE	NUMBER	(5)		currency conversion rate
AE_CREATION_ERROR	VARCHAR2	(240)		Not used
GL_REVERSAL_FLAG	VARCHAR2	(3)		Not used
POST_TO_GL	VARCHAR2	(30)		This flag indicates if the distribution should be posted to GL or not. Possible values are 'Y' or 'N'. Only those distributions which have this flag as 'Y' are transferred to subledger accounting tables
REVERSE_EVENT_FLAG	VARCHAR2	(3)	Yes	Not used
DRAFT_YN	VARCHAR2	(3)	Yes	Not used
DRAFT_VERSION	NUMBER			Not used
ORIGINAL_DIST_ID	NUMBER			Original Distribution identifier. This field contains the identifier of the original distribution for which this is a reversal distribution. This field is used by accounting reversal process.
ACCOUNTING_EVENT_ID	NUMBER			not used
REQUEST_ID	NUMBER			Concurrent Manager column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Manager column
PROGRAM_ID	NUMBER			Concurrent Manager column
PROGRAM_UPDATE_DATE	DATE			Concurrent Manager column
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
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
ACCOUNTING_TEMPLATE_NAME	VARCHAR2	(150)		Accounting Template Name
UPGRADE_STATUS_FLAG	VARCHAR2	(1)		This column is added as part of SLA uptake for making Ids sequence generatedThe various values are :NULL - Upgrade required by ID upgrade scriptY - Upgraded by scriptN - Created new and hence uses correct sequence

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      CURRENCY_CONVERSION_TYPE
,      AET_ID
,      SET_OF_BOOKS_ID
,      CR_DR_FLAG
,      CODE_COMBINATION_ID
,      ORG_ID
,      CURRENCY_CODE
,      AE_LINE_TYPE
,      TEMPLATE_ID
,      SOURCE_ID
,      SOURCE_TABLE
,      OBJECT_VERSION_NUMBER
,      AMOUNT
,      ACCOUNTED_AMOUNT
,      GL_DATE
,      PERCENTAGE
,      COMMENTS
,      POST_REQUEST_ID
,      POSTED_YN
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      AE_CREATION_ERROR
,      GL_REVERSAL_FLAG
,      POST_TO_GL
,      REVERSE_EVENT_FLAG
,      DRAFT_YN
,      DRAFT_VERSION
,      ORIGINAL_DIST_ID
,      ACCOUNTING_EVENT_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ACCOUNTING_TEMPLATE_NAME
,      UPGRADE_STATUS_FLAG
FROM OKL.OKL_TRNS_ACC_DSTRS_ALL;

Dependencies

[top of page]

OKL.OKL_TRNS_ACC_DSTRS_ALL does not reference any database object

OKL.OKL_TRNS_ACC_DSTRS_ALL is referenced by following:

APPS: OKL_TRNS_ACC_DSTRS; OKL_TRNS_ACC_DSTRS_ALL