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

VIEW: APPS.IBY_BATCHES_ALL_V

Object Details
Object Name: IBY_BATCHES_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIBY.IBY_BATCHES_ALL_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


IBY_BATCHES_ALL view allows a merchant or business to view Batch details.


[View Source]

Columns
Name Datatype Length Mandatory Comments
MERCHBATCHID VARCHAR2 (80) Yes Batch identifer
BATCHSTATUS NUMBER

Status of the batch
PAYEENAME VARCHAR2 (80)
NAME is name of the Payee
BATCHCLOSEDATE DATE

close date of this batch.
BEPNAME VARCHAR2 (80)
Name of the Back end Payment system like Cybercash, Verifone etc
VPSBATCHID VARCHAR2 (80)
VPSBatchID is the batchid from BEP
NUMTRXNS NUMBER

NUMTRXNS is number of transactions in this batch
BATCHSTATE VARCHAR2 (80)
It denotes state of the batch. Various batch states are: batch-accepted 0 batch-sent 1,batch-queued 2,batch-rejected 3,batch-processed 4 (not used currently) batch-error-at-cc 5,batch-not-found 6,batch-unknown 7.
BATCHTOTAL NUMBER

BATCHTOTAL is the total net for this batch
BATCHSALES NUMBER

BATCHSALES is the total inflow
BATCHCREDIT NUMBER

BATCHCREDIT is the total outflow and includes return and credit transaction amounts.
PAYMENTMETHODNAME VARCHAR2 (80)
Payment Method Name
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT MERCHBATCHID
,      BATCHSTATUS
,      PAYEENAME
,      BATCHCLOSEDATE
,      BEPNAME
,      VPSBATCHID
,      NUMTRXNS
,      BATCHSTATE
,      BATCHTOTAL
,      BATCHSALES
,      BATCHCREDIT
,      PAYMENTMETHODNAME
,      ORG_ID
FROM APPS.IBY_BATCHES_ALL_V;

Dependencies

[top of page]

APPS.IBY_BATCHES_ALL_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
SynonymIBY_BATCHES_ALL
SynonymIBY_BEPINFO
SynonymIBY_PAYEE

APPS.IBY_BATCHES_ALL_V is not referenced by any database object