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

TABLE: IBY.IBY_BEPINFO

Object Details
Object Name: IBY_BEPINFO
Object Type: TABLE
Owner: IBY
FND Design Data: TableIBY.IBY_BEPINFO
Subobject Name:
Status: VALID


IBY_BEPKEYS stores information about the payment systems.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IBY_BEPINFO_BEPID_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBEPID
ColumnZD_EDITION_NAME
IBY_BEPINFO_NAME_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnZD_EDITION_NAME
IBY_BEPINFO_SUFFIX_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUFFIX
ColumnZD_EDITION_NAME
IBY_BEPINFO_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
Columns
Name Datatype Length Mandatory Comments
BEPID NUMBER (15) Yes Payment system identifier
NAME VARCHAR2 (80) Yes Name of the payment system
BASEURL VARCHAR2 (1024)
URL to the payment system
SUFFIX VARCHAR2 (10) Yes Three-letter payment system suffix. This is unique per payment system
BEPUSERNAME VARCHAR2 (80)
Username for authenticating from iPayment to Back End Payment System.
BEPPASSWORD VARCHAR2 (80)
password for BEPUSERNAME.
SUPPORTEDOP NUMBER

Bitmap to denote operations supported by bank end payment system
PSUSERNAME VARCHAR2 (80)
username for authenticating from Back End Payment System to iPayment
PSPASSWORD VARCHAR2 (80)
Password for PSUSERNAME
ADMINURL VARCHAR2 (1024)
URL to the native Back End Payment System admin pages
LOGINURL VARCHAR2 (1024)
loginurl to the payment system
LOGOUTURL VARCHAR2 (1024)
logouturl to the payment system
SRVRIDIMMED VARCHAR2 (1)
Y or N flag indicating that Server ID is immediately sent
ACTIVESTATUS VARCHAR2 (1)
Indicates whether payment system is active or not
LEADTIME NUMBER

Lead time that is needed to schedule the payment
HOLIDAYFILE VARCHAR2 (1)
Denotes support for holiday file
FILESUPPORT VARCHAR2 (1)
Y or N flag
SECURITYSCHEME NUMBER

Denotes whether HTML Page or Wallet for invoice or pay operation
INSTRTYPE VARCHAR2 (30)
Instrument type
LAST_UPDATE_DATE DATE
Yes Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Yes Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SECURITY_GROUP_ID NUMBER

Used in hosted environment
PARTY_ID NUMBER (15)
Oracle Internal use only - reserved for future use
BEP_TYPE VARCHAR2 (10)
Indicates whether the BEP is a processor or gateway model payment system. Values for this column include: PROCESSOR and GATEWAY
MAX_BATCH_SIZE NUMBER

No longer used
OUTBOUND_INVALID_CHARS VARCHAR2 (3000)
Invalid characters to be replaced by the corresponding replacement characters. Generally should have positional correspondence with the replacement ones. For Citi-Payables only.
OUTBOUND_REPLACE_CHARS VARCHAR2 (3000)
Replacement characters corresponding to the invalid characters. Generally should have positional correspondence with the invalid ones. For Citi-Payables only.
BANK_ID NUMBER (15)
System generated primary key
NLS_LANGUAGE VARCHAR2 (50)
NLS language character set for the payment system network communication.
INACTIVE_DATE DATE

Inactive date
SEEDED_FLAG VARCHAR2 (1)
Y or N flag indicating that the data is seeded record
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
AUTH_REVERSAL_FLAG VARCHAR2 (1)
Indicates if authorization reversal is supported by the Payment System. U-UNSUPPORTED, F-FULL_ONLY, M-FULL_AND_PARTIAL
ALLOW_CAPTURE_EX_AUTH_FLAG VARCHAR2 (1)
Y/N flag indicating if the payment system allows capture amount greater than authorization amount
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT BEPID
,      NAME
,      BASEURL
,      SUFFIX
,      BEPUSERNAME
,      BEPPASSWORD
,      SUPPORTEDOP
,      PSUSERNAME
,      PSPASSWORD
,      ADMINURL
,      LOGINURL
,      LOGOUTURL
,      SRVRIDIMMED
,      ACTIVESTATUS
,      LEADTIME
,      HOLIDAYFILE
,      FILESUPPORT
,      SECURITYSCHEME
,      INSTRTYPE
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      PARTY_ID
,      BEP_TYPE
,      MAX_BATCH_SIZE
,      OUTBOUND_INVALID_CHARS
,      OUTBOUND_REPLACE_CHARS
,      BANK_ID
,      NLS_LANGUAGE
,      INACTIVE_DATE
,      SEEDED_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      AUTH_REVERSAL_FLAG
,      ALLOW_CAPTURE_EX_AUTH_FLAG
,      ZD_EDITION_NAME
FROM IBY.IBY_BEPINFO;

Dependencies

[top of page]

IBY.IBY_BEPINFO does not reference any database object

IBY.IBY_BEPINFO is referenced by following:

SchemaIBY
ViewIBY_BEPINFO#