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

TABLE: JA.JA_CN_VOUCHER_NUMBER

Object Details
Object Name: JA_CN_VOUCHER_NUMBER
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JA_CN_VOUCHER_NUMBER
Subobject Name:
Status: VALID

The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JA_CN_VOUCHER_NUMBER_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEDGER_ID
ColumnLEGAL_ENTITY_ID
ColumnPERIOD_NAME
ColumnJE_HEADER_ID
ColumnJE_LINE_NUMBER
ColumnVOUCHER_NUMBER
Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER (15) Yes Identifier of Ledger
LEGAL_ENTITY_ID NUMBER (15) Yes Identifier of legal entity
PERIOD_NAME VARCHAR2 (15) Yes Accounting period
JE_HEADER_ID NUMBER (15) Yes Identifier of GL header
JE_LINE_NUMBER NUMBER (15) Yes Identifier of GL line
VOUCHER_NUMBER NUMBER (15) Yes Voucher number of GL line
REQUEST_ID NUMBER (15) Yes The concurrent request id that run the voucher number generation or migration
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
DATA_SOURCE_TAG VARCHAR2 (5)
Flag to identifies whether the record is generated or migrated
Query Text

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


SELECT LEDGER_ID
,      LEGAL_ENTITY_ID
,      PERIOD_NAME
,      JE_HEADER_ID
,      JE_LINE_NUMBER
,      VOUCHER_NUMBER
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DATA_SOURCE_TAG
FROM JA.JA_CN_VOUCHER_NUMBER;

Dependencies

[top of page]

JA.JA_CN_VOUCHER_NUMBER does not reference any database object

JA.JA_CN_VOUCHER_NUMBER is referenced by following:

SchemaJA
ViewJA_CN_VOUCHER_NUMBER#