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

TABLE: AP.JE_NL_EFT_BATCHES

Object Details
Object Name: JE_NL_EFT_BATCHES
Object Type: TABLE
Owner: AP
FND Design Data: TableJE.JE_NL_EFT_BATCHES
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JE_NL_EFT_BATCHES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
JE_NL_EFT_BATCHES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHECKRUN_NAME
JE_NL_EFT_BATCHES_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMEDIUM_ID
ColumnMEDIUM_SEQNO
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CHECKRUN_NAME VARCHAR2 (50) Yes
DATE_CREATED DATE
Yes
BATCH_FORMAT VARCHAR2 (30) Yes
MEDIUM_ID NUMBER (15)
MEDIUM_SEQNO NUMBER (4)
PAYER_BANK_ACCOUNT VARCHAR2 (30)
TOT_BANK_ACCOUNTS NUMBER (19)
TOT_PAYMENT_AMOUNT NUMBER

TOT_PAYMENTS NUMBER (6)
TOT_RECORDS NUMBER (6)
NO_OF_CANCELLATIONS NUMBER (6)
FIRST_PAYMENT_NUMBER NUMBER (15)
LAST_PAYMENT_NUMBER NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT BATCH_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CHECKRUN_NAME
,      DATE_CREATED
,      BATCH_FORMAT
,      MEDIUM_ID
,      MEDIUM_SEQNO
,      PAYER_BANK_ACCOUNT
,      TOT_BANK_ACCOUNTS
,      TOT_PAYMENT_AMOUNT
,      TOT_PAYMENTS
,      TOT_RECORDS
,      NO_OF_CANCELLATIONS
,      FIRST_PAYMENT_NUMBER
,      LAST_PAYMENT_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM AP.JE_NL_EFT_BATCHES;

Dependencies

[top of page]

AP.JE_NL_EFT_BATCHES does not reference any database object

AP.JE_NL_EFT_BATCHES is referenced by following:

SchemaAPPS
SynonymJE_NL_EFT_BATCHES