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

VIEW: IBY.IBY_PAYEE#

Object Details
Object Name: IBY_PAYEE#
Object Type: VIEW
Owner: IBY
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MPAYEEID NUMBER (15) Yes
PAYEEID VARCHAR2 (80) Yes
NAME VARCHAR2 (80) Yes
ECAPPID NUMBER (15) Yes
USERNAME VARCHAR2 (80)
PASSWORD VARCHAR2 (80)
ACTIVESTATUS VARCHAR2 (1) Yes
THRESHOLD NUMBER (15)
RISK_ENABLED VARCHAR2 (1)
SUPPORTEDOP NUMBER

LAST_UPDATE_DATE DATE
Yes
OBJECT_VERSION_NUMBER NUMBER
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

SECURITY_GROUP_ID NUMBER

MCC_CODE NUMBER (10)
EMAIL_ADDRESS VARCHAR2 (2000)
FINANCING_PAYEE_FLAG VARCHAR2 (1)
MASTER_KEY VARCHAR2 (24)
SECURITY_ENABLED VARCHAR2 (1)
DBA_NAME VARCHAR2 (80)
DBA_CITY VARCHAR2 (80)
DBA_STATE_PROVINCE VARCHAR2 (80)
DBA_COUNTRY VARCHAR2 (80)
INACTIVE_DATE DATE

Query Text

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


SELECT MPAYEEID
,      PAYEEID
,      NAME
,      ECAPPID
,      USERNAME
,      PASSWORD
,      ACTIVESTATUS
,      THRESHOLD
,      RISK_ENABLED
,      SUPPORTEDOP
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      MCC_CODE
,      EMAIL_ADDRESS
,      FINANCING_PAYEE_FLAG
,      MASTER_KEY
,      SECURITY_ENABLED
,      DBA_NAME
,      DBA_CITY
,      DBA_STATE_PROVINCE
,      DBA_COUNTRY
,      INACTIVE_DATE
FROM IBY.IBY_PAYEE#;

Dependencies

[top of page]

IBY.IBY_PAYEE# references the following:

SchemaIBY
TableIBY_PAYEE
IBY.IBY_PAYEE# is referenced by following:

SchemaAPPS
SynonymIBY_PAYEE