[Home] [Help] [Dependency Information]
Object Name: | IBY_INTERNAL_PAYERS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | IBY |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INT_PAYER_ID | NUMBER | (15) | Yes | |
PAYMENT_METHOD_AT_PAYEE_FLAG | VARCHAR2 | (1) | Yes | |
DOCUMENT_REJECTION_LEVEL_CODE | VARCHAR2 | (30) | Yes | |
PAYMENT_REJECTION_LEVEL_CODE | VARCHAR2 | (30) | Yes | |
REQUIRE_PROP_PMTS_REVIEW_FLAG | VARCHAR2 | (1) | Yes | |
ALLOW_EXT_ACCT_OVERRIDE_FLAG | VARCHAR2 | (1) | Yes | |
EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | (1) | Yes | |
SAVE_PAYMENT_FILE_IN_DB | VARCHAR2 | (1) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
ORG_ID | NUMBER | (15) | ||
ORG_TYPE | VARCHAR2 | (30) | ||
BANK_CHARGE_BEARER | VARCHAR2 | (30) | ||
PPR_REPORT_FORMAT | VARCHAR2 | (60) | ||
AUTOMATIC_PPR_REPORT_SUBMIT | VARCHAR2 | (1) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT INT_PAYER_ID
, PAYMENT_METHOD_AT_PAYEE_FLAG
, DOCUMENT_REJECTION_LEVEL_CODE
, PAYMENT_REJECTION_LEVEL_CODE
, REQUIRE_PROP_PMTS_REVIEW_FLAG
, ALLOW_EXT_ACCT_OVERRIDE_FLAG
, EXCLUSIVE_PAYMENT_FLAG
, SAVE_PAYMENT_FILE_IN_DB
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ORG_ID
, ORG_TYPE
, BANK_CHARGE_BEARER
, PPR_REPORT_FORMAT
, AUTOMATIC_PPR_REPORT_SUBMIT
, ZD_EDITION_NAME
FROM IBY.IBY_INTERNAL_PAYERS_ALL#;
|
|
|