IBY_PAYEE_

IBY_PAYEE_ is the audit table for IBY_PAYEE. Table IBY_PAYEE contains a row for each payee, such as a biller, merchant, or store at this site.

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

IBY_PAYEE_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, MPAYEEID

Columns

Name Datatype Length Precision Not-null Comments
PAYEEID VARCHAR2 80 Payee Identifier passed by electronic commerce application
NAME VARCHAR2 80 Name of the internal payee for receiving funds.
ECAPPID NUMBER 18 Electronic commerce application Identifier
USERNAME VARCHAR2 80 User name to authenticate receipt of funds.
PASSWORD VARCHAR2 80 Pass word to authenticate receipt of funds.
ACTIVESTATUS VARCHAR2 1 Y or N flag to indicate whether the merchant is active
SUPPORTEDOP NUMBER Bit map to denote operations supported by the payee
LOGO VARCHAR2 255 Logo for the internal payee for receiving funds.
MPAYEEID NUMBER 18 Yes System generated Payee Identifier
THRESHOLD NUMBER 18 Threshold value to check against the overall risk score
RISK_ENABLED VARCHAR2 1 Y or N flag indicating whether risk management feature is enabled
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
SECURITY_GROUP_ID NUMBER Security group identifier used in hosted environments.
MCC_CODE NUMBER 10 Merchant category code, or MCC, for this payee, if applicable
MASTER_KEY VARCHAR2 24 Oracle internal use only, reserved for future use
SECURITY_ENABLED VARCHAR2 1 Oracle internal use only, reserved for future use
EMAIL_ADDRESS VARCHAR2 2000 Oracle internal use only, reserved for future use
FINANCING_PAYEE_FLAG VARCHAR2 1 Oracle internal use only, reserved for future use
DBA_NAME VARCHAR2 80 Payee doing business name of the payee for receiving funds.
DBA_CITY VARCHAR2 80 Payee doing-business-as address city
DBA_STATE_PROVINCE VARCHAR2 80 Payee doing-business-as address state or province
DBA_COUNTRY VARCHAR2 80 Payee doing-business-as address country
INACTIVE_DATE DATE User entered or system defaulted end date.
START_DATE DATE Date from which payee is available for use
END_DATE DATE Date until which payee is available for use
PAYER_NOTIF_SEND_FROM VARCHAR2 1024 Send from email address for payer notifications
PAYER_NOTIF_EMAIL_SUBJECT VARCHAR2 1024 Email subject line for payer notifications
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
IBY_PAYEE_MPAYEEID_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, MPAYEEID
IBY_PAYEE_N1_ Non Unique Default MPAYEEID