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

VIEW: APPS.IBY_PURCHASECARD_V

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

View Type

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


View used to work with registered purchase cards.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTRID NUMBER (15) Yes ID that iPayment uses to identify a registered purchase card.
PCNUMBER VARCHAR2 (30) Yes Purchase card number.
EXPIRYDATE DATE

Date after which the purchase card expires.
FINAME VARCHAR2 (80)
The name of the financial institution (bank) that issued the card.
ACCTTYPE VARCHAR2 (30)
Type of purchase card account.
CHNAME VARCHAR2 (80)
Card holder name.
INSTRNAME VARCHAR2 (80)
Mnemonic for a registered purchase card.
SUBTYPE VARCHAR2 (80)
Subtype of purchase card (e.g. commercial card, business card, etc.).
OWNERTYPE VARCHAR2 (20) Yes The type of the account holder.
OWNERID VARCHAR2 (80) Yes ID that iPayment uses to identify purchase.
INSTRBUF VARCHAR2 (240)
Description of registered purchase card.
ENCRYPTED VARCHAR2 (1)
Indicates if the instrument is encrypted
Query Text

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


SELECT INSTRID
,      PCNUMBER
,      EXPIRYDATE
,      FINAME
,      ACCTTYPE
,      CHNAME
,      INSTRNAME
,      SUBTYPE
,      OWNERTYPE
,      OWNERID
,      INSTRBUF
,      ENCRYPTED
FROM APPS.IBY_PURCHASECARD_V;

Dependencies

[top of page]

APPS.IBY_PURCHASECARD_V references the following:

SchemaAPPS
SynonymIBY_ACCTTYPE
SynonymIBY_CREDITCARD
SynonymIBY_INSTRHOLDER
APPS.IBY_PURCHASECARD_V is referenced by following:

SchemaAPPS
Package BodyIBY_INSTRREG_PUB - show dependent code
Package BodyIBY_OFFLINEDB_PKG - show dependent code