[Home] [Help] [Dependency Information]
Object Name: | IBY_PAY_PAYMENTS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | IBY |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ECAPP_ID | NUMBER | (15) | ||
PAYER_ID | VARCHAR2 | (80) | Yes | |
BATCH_ID | NUMBER | (15) | Yes | |
PMT_TRXN_ID | NUMBER | (15) | Yes | |
PMT_PRIORITY | VARCHAR2 | (10) | ||
DEBIT_ACCT_NUMBER | VARCHAR2 | (30) | ||
FAX_MAIL_TO_NAME | VARCHAR2 | (240) | ||
MAIL_ADDRESS1 | VARCHAR2 | (240) | ||
MAIL_ADDRESS2 | VARCHAR2 | (240) | ||
MAIL_ADDRESS3 | VARCHAR2 | (240) | ||
MAIL_ADDR_CITY | VARCHAR2 | (25) | ||
MAIL_ADDR_STATE | VARCHAR2 | (150) | ||
MAIL_ADDR_ZIP | VARCHAR2 | (20) | ||
PMT_LOC_COUNTRY_CODE | VARCHAR2 | (25) | ||
VALUE_AMOUNT | NUMBER | Yes | ||
REF_AMOUNT | NUMBER | |||
VALUE_DATE | DATE | Yes | ||
CHARGE_DETAILS | VARCHAR2 | (6) | ||
VAT_AMOUNT | NUMBER | |||
WHT_AMOUNT | NUMBER | |||
PMT_DETAILS_1 | VARCHAR2 | (20) | ||
PMT_DETAILS_2 | VARCHAR2 | (20) | ||
PMT_DETAILS_3 | VARCHAR2 | (20) | ||
PMT_DETAILS_4 | VARCHAR2 | (20) | ||
TRXN_CODE_CLRID | VARCHAR2 | (30) | ||
BNF_NAME | VARCHAR2 | (240) | Yes | |
BNF_ID | VARCHAR2 | (30) | ||
BNF_ADDRESS_LINE1 | VARCHAR2 | (240) | ||
BNF_ADDRESS_LINE2 | VARCHAR2 | (240) | ||
BNF_ADDRESS_LINE3 | VARCHAR2 | (240) | ||
BNF_ADDR_CITY | VARCHAR2 | (25) | ||
BNF_ADDR_STATE | VARCHAR2 | (150) | ||
BNF_ADDR_ZIP | VARCHAR2 | (20) | ||
BNF_ADDR_COUNTRY | VARCHAR2 | (25) | ||
BNF_ADDR_PHONE | VARCHAR2 | (15) | ||
BNF_REMARKS | VARCHAR2 | (80) | ||
BNF_CHARGE_AMT | NUMBER | |||
BNF_ADJUSTMENT_AMT | VARCHAR2 | (30) | ||
BNF_BANK_NAME | VARCHAR2 | (60) | ||
BNF_BANK_NUM | VARCHAR2 | (30) | ||
BNF_BANK_ADDRESS | VARCHAR2 | (35) | ||
BNF_BANK_ADDR_CITY | VARCHAR2 | (25) | ||
BNF_BANK_ADDR_STATE | VARCHAR2 | (25) | ||
BNF_BANK_ADDR_ZIP | VARCHAR2 | (20) | ||
BNF_BANK_ADDR_COUNTRY | VARCHAR2 | (25) | ||
BNF_BANK_BRANCH_NAME | VARCHAR2 | (60) | ||
BNF_BANK_BRANCH_NUM | VARCHAR2 | (25) | ||
BNF_BANK_BRANCH_TYPE | VARCHAR2 | (25) | ||
BNF_BANK_SWIFT_CODE | VARCHAR2 | (12) | ||
BNF_BANK_ACCOUNT_NAME | VARCHAR2 | (80) | ||
BNF_BANK_ACCT_NUMBER | VARCHAR2 | (30) | ||
BNF_BANK_ACCT_CHECK_DIGITS | VARCHAR2 | (30) | ||
BNF_BANK_ACCT_IBAN_NUMBER | VARCHAR2 | (40) | ||
BNF_BANK_ACCT_TYPE | VARCHAR2 | (25) | ||
BNF_FAXNO_CABLEADDR | VARCHAR2 | (35) | ||
BNF_SITE_CODE | VARCHAR2 | (15) | ||
BNF_BANK_CLEARING_MTD | VARCHAR2 | (60) | ||
BNF_TAXPAYER_ID | VARCHAR2 | (30) | ||
FUTURE_PAY_DUE_DATE | DATE | |||
CUST_REF | NUMBER | |||
INTRM_BANK_CODE | VARCHAR2 | (30) | ||
INTRM_SWIFT_CODE | VARCHAR2 | (30) | ||
INTRM_BANK_NAME | VARCHAR2 | (60) | ||
INTRM_BANK_FAXNO_CBL | VARCHAR2 | (35) | ||
PMT_STATUS | NUMBER | |||
PMT_APPROVAL_STATUS | NUMBER | |||
UPDATE_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | 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) | ||
ORG_ID | NUMBER | (15) | ||
ERROR_LOCATION | NUMBER | |||
BEP_CODE | VARCHAR2 | (80) | ||
BEP_MESSAGE | VARCHAR2 | (1024) |
Cut, paste (and edit) the following text to query this object:
SELECT ECAPP_ID
, PAYER_ID
, BATCH_ID
, PMT_TRXN_ID
, PMT_PRIORITY
, DEBIT_ACCT_NUMBER
, FAX_MAIL_TO_NAME
, MAIL_ADDRESS1
, MAIL_ADDRESS2
, MAIL_ADDRESS3
, MAIL_ADDR_CITY
, MAIL_ADDR_STATE
, MAIL_ADDR_ZIP
, PMT_LOC_COUNTRY_CODE
, VALUE_AMOUNT
, REF_AMOUNT
, VALUE_DATE
, CHARGE_DETAILS
, VAT_AMOUNT
, WHT_AMOUNT
, PMT_DETAILS_1
, PMT_DETAILS_2
, PMT_DETAILS_3
, PMT_DETAILS_4
, TRXN_CODE_CLRID
, BNF_NAME
, BNF_ID
, BNF_ADDRESS_LINE1
, BNF_ADDRESS_LINE2
, BNF_ADDRESS_LINE3
, BNF_ADDR_CITY
, BNF_ADDR_STATE
, BNF_ADDR_ZIP
, BNF_ADDR_COUNTRY
, BNF_ADDR_PHONE
, BNF_REMARKS
, BNF_CHARGE_AMT
, BNF_ADJUSTMENT_AMT
, BNF_BANK_NAME
, BNF_BANK_NUM
, BNF_BANK_ADDRESS
, BNF_BANK_ADDR_CITY
, BNF_BANK_ADDR_STATE
, BNF_BANK_ADDR_ZIP
, BNF_BANK_ADDR_COUNTRY
, BNF_BANK_BRANCH_NAME
, BNF_BANK_BRANCH_NUM
, BNF_BANK_BRANCH_TYPE
, BNF_BANK_SWIFT_CODE
, BNF_BANK_ACCOUNT_NAME
, BNF_BANK_ACCT_NUMBER
, BNF_BANK_ACCT_CHECK_DIGITS
, BNF_BANK_ACCT_IBAN_NUMBER
, BNF_BANK_ACCT_TYPE
, BNF_FAXNO_CABLEADDR
, BNF_SITE_CODE
, BNF_BANK_CLEARING_MTD
, BNF_TAXPAYER_ID
, FUTURE_PAY_DUE_DATE
, CUST_REF
, INTRM_BANK_CODE
, INTRM_SWIFT_CODE
, INTRM_BANK_NAME
, INTRM_BANK_FAXNO_CBL
, PMT_STATUS
, PMT_APPROVAL_STATUS
, UPDATE_DATE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, ERROR_LOCATION
, BEP_CODE
, BEP_MESSAGE
FROM IBY.IBY_PAY_PAYMENTS_ALL#;
|
|
|