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

TABLE: BOM.CST_AE_LINES

Object Details
Object Name: CST_AE_LINES
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.CST_AE_LINES
Subobject Name:
Status: VALID


This table stores the accounting distribution entries (debits and credits) for periodic distributions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CST_AE_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAE_LINE_ID
CST_AE_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAE_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
AE_LINE_ID NUMBER (15) Yes Unique Identifier
AE_HEADER_ID NUMBER (15) Yes Accounting Header Identifier
AE_LINE_NUMBER NUMBER
Yes Accounting Line Number
AE_LINE_TYPE_CODE VARCHAR2 (30)
Accounting Line Type Code
CODE_COMBINATION_ID NUMBER (15)
Account Identifier
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Exchange Rate
ENTERED_DR NUMBER

Accounting Debit Entry
ENTERED_CR NUMBER

Accounting Credit Entry
ACCOUNTED_DR NUMBER

Accounting Debit entry in functional currency
ACCOUNTED_CR NUMBER

Accounting Credit entry in functional currency
SOURCE_TABLE VARCHAR2 (30)
Accounting Entry source table
SOURCE_ID NUMBER (15)
Accounting Entry source Identifier
RATE_OR_AMOUNT NUMBER

Per Unit Rate
BASIS_TYPE NUMBER

Basis Type for WIP
RESOURCE_ID NUMBER

Resource Identifier for WIP
COST_ELEMENT_ID NUMBER

Cost Element Identifier
ACTIVITY_ID NUMBER

Activity Identifier for WIP
REPETITIVE_SCHEDULE_ID NUMBER

Repetitive Schedule Identifier for WIP
OVERHEAD_BASIS_FACTOR NUMBER

Overhead Basis Factor for WIP
BASIS_RESOURCE_ID NUMBER (15)
Basis Resource Identifier for WIP
GL_SL_LINK_ID NUMBER (15)
Link to General Ledger
DESCRIPTION VARCHAR2 (240)
Description of Accounting entry line
ACCOUNTING_ERROR_CODE VARCHAR2 (30)
Accounting Error Code
STAT_AMOUNT NUMBER

Stat Amount
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL Transaction Code
SUBLEDGER_DOC_SEQUENCE_ID NUMBER (15)
Subledger Document Sequence Identifier
SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER

Subledger Document Sequence Value
GL_TRANSFER_ERROR_CODE VARCHAR2 (240)
General Ledger Transfer Error Code
REFERENCE1 VARCHAR2 (240)
Reference column
REFERENCE2 VARCHAR2 (240)
Reference column
REFERENCE3 VARCHAR2 (240)
Reference column
REFERENCE4 VARCHAR2 (240)
Reference column
REFERENCE5 VARCHAR2 (240)
Reference column
REFERENCE6 VARCHAR2 (240)
Reference column
REFERENCE7 VARCHAR2 (240)
Reference column
REFERENCE8 VARCHAR2 (240)
Reference column
REFERENCE9 VARCHAR2 (240)
Reference column
REFERENCE10 VARCHAR2 (240)
Reference column
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) Yes Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column
PROGRAM_ID NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Standard Who column
PO_DISTRIBUTION_ID NUMBER

Purchase Order Distribution Identifier for Receiving Transactions
WIP_ENTITY_ID NUMBER

WIP Entity Identifier
Query Text

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


SELECT AE_LINE_ID
,      AE_HEADER_ID
,      AE_LINE_NUMBER
,      AE_LINE_TYPE_CODE
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      SOURCE_TABLE
,      SOURCE_ID
,      RATE_OR_AMOUNT
,      BASIS_TYPE
,      RESOURCE_ID
,      COST_ELEMENT_ID
,      ACTIVITY_ID
,      REPETITIVE_SCHEDULE_ID
,      OVERHEAD_BASIS_FACTOR
,      BASIS_RESOURCE_ID
,      GL_SL_LINK_ID
,      DESCRIPTION
,      ACCOUNTING_ERROR_CODE
,      STAT_AMOUNT
,      USSGL_TRANSACTION_CODE
,      SUBLEDGER_DOC_SEQUENCE_ID
,      SUBLEDGER_DOC_SEQUENCE_VALUE
,      GL_TRANSFER_ERROR_CODE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      PO_DISTRIBUTION_ID
,      WIP_ENTITY_ID
FROM BOM.CST_AE_LINES;

Dependencies

[top of page]

BOM.CST_AE_LINES does not reference any database object

BOM.CST_AE_LINES is referenced by following:

SchemaBOM
ViewCST_AE_LINES#