[Home] [Help] [Dependency Information]
Object Name: | IBY_PAY_PAYMENTS# |
---|---|
Object Type: | VIEW |
Owner: | IBY |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PMT_BATCH_REQUEST_ID | NUMBER | Yes | ||
BATCH_ID | NUMBER | Yes | ||
PMT_TRXN_ID | NUMBER | Yes | ||
PMT_LOC_COUNTRY_CODE | VARCHAR2 | (10) | Yes | |
PMT_PRIORITY | VARCHAR2 | (10) | ||
DEBIT_ACCTNO | VARCHAR2 | (30) | ||
FAX_MAIL_TO_NAME | VARCHAR2 | (240) | ||
MAIL_ADDRESS1 | VARCHAR2 | (240) | ||
MAIL_ADDRESS2 | VARCHAR2 | (240) | ||
MAIL_ADDRESS3 | VARCHAR2 | (240) | ||
MAIL_ADDR_CITY | VARCHAR2 | (35) | ||
MAIL_ADDR_STATE | VARCHAR2 | (35) | ||
MAIL_ADDR_ZIP | VARCHAR2 | (35) | ||
VALUE_AMOUNT | NUMBER | Yes | ||
REF_AMOUNT | NUMBER | Yes | ||
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 | (6) | ||
BNF_NAME | VARCHAR2 | (240) | ||
BNF_ID | VARCHAR2 | (30) | ||
BNF_ADDRESS_LINE1 | VARCHAR2 | (240) | ||
BNF_ADDR_CITY | VARCHAR2 | (35) | ||
BNF_ADDR_STATE | VARCHAR2 | (35) | ||
BNF_ADDR_ZIP | VARCHAR2 | (35) | ||
BNF_ADDR_PHONE | VARCHAR2 | (20) | ||
BNF_REMARKS | VARCHAR2 | (80) | ||
BNF_CHARGE_AMT | NUMBER | |||
BNF_ADJUSTMENT_AMT | VARCHAR2 | (30) | ||
BNF_BANK_NAME | VARCHAR2 | (60) | ||
BNF_BANK_ADDRESS | VARCHAR2 | (60) | ||
BNF_BANK_ADDR_STATE | VARCHAR2 | (35) | ||
BNF_BANK_ADDR_CITY | VARCHAR2 | (35) | ||
BNF_BANK_ADDR_ZIP | VARCHAR2 | (20) | ||
BNF_BANK_BRANCH_NO | VARCHAR2 | (50) | ||
BNF_BANK_BRANCH_NAME | VARCHAR2 | (60) | ||
BNF_BANK_BRANCH_TYPE | VARCHAR2 | (25) | ||
BNF_ACCTNO | VARCHAR2 | (30) | ||
BNF_BANK_ACCOUNT_NAME | VARCHAR2 | (80) | ||
BNF_BANK_ACCT_TYPE | VARCHAR2 | (25) | ||
BNF_ACCT_TYPE | VARCHAR2 | (25) | ||
BNF_FAXNO_CABLEADDR | VARCHAR2 | (35) | ||
BNF_SITE_CODE | VARCHAR2 | (15) | ||
BNF_SWIFT_CODE | VARCHAR2 | (30) | ||
BNF_BANK_CLEARING_MTD | VARCHAR2 | (60) | ||
BNF_TAXPAYER_ID | VARCHAR2 | (30) | ||
FUTURE_PAY_DUE_DATE | DATE | |||
CUST_REF | NUMBER | |||
INTRM_BANKCODE | VARCHAR2 | (30) | ||
INTRM_SWIFTCODE | VARCHAR2 | (30) | ||
INTRM_BANKNAME | VARCHAR2 | (60) | ||
INTRM_BANK_FAXNO_CBL | VARCHAR2 | (35) | ||
PMT_STATUS | NUMBER | |||
PMT_APPROVAL_STATUS | NUMBER | |||
UPDATE_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | (5) | 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) | ||
ERROR_LOCATION | NUMBER | |||
BEP_CODE | VARCHAR2 | (80) | ||
BEP_MESSAGE | VARCHAR2 | (80) |
Cut, paste (and edit) the following text to query this object:
SELECT PMT_BATCH_REQUEST_ID
, BATCH_ID
, PMT_TRXN_ID
, PMT_LOC_COUNTRY_CODE
, PMT_PRIORITY
, DEBIT_ACCTNO
, FAX_MAIL_TO_NAME
, MAIL_ADDRESS1
, MAIL_ADDRESS2
, MAIL_ADDRESS3
, MAIL_ADDR_CITY
, MAIL_ADDR_STATE
, MAIL_ADDR_ZIP
, 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_ADDR_CITY
, BNF_ADDR_STATE
, BNF_ADDR_ZIP
, BNF_ADDR_PHONE
, BNF_REMARKS
, BNF_CHARGE_AMT
, BNF_ADJUSTMENT_AMT
, BNF_BANK_NAME
, BNF_BANK_ADDRESS
, BNF_BANK_ADDR_STATE
, BNF_BANK_ADDR_CITY
, BNF_BANK_ADDR_ZIP
, BNF_BANK_BRANCH_NO
, BNF_BANK_BRANCH_NAME
, BNF_BANK_BRANCH_TYPE
, BNF_ACCTNO
, BNF_BANK_ACCOUNT_NAME
, BNF_BANK_ACCT_TYPE
, BNF_ACCT_TYPE
, BNF_FAXNO_CABLEADDR
, BNF_SITE_CODE
, BNF_SWIFT_CODE
, BNF_BANK_CLEARING_MTD
, BNF_TAXPAYER_ID
, FUTURE_PAY_DUE_DATE
, CUST_REF
, INTRM_BANKCODE
, INTRM_SWIFTCODE
, INTRM_BANKNAME
, 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
, ERROR_LOCATION
, BEP_CODE
, BEP_MESSAGE
FROM IBY.IBY_PAY_PAYMENTS#;
|
|
|