eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IBY.IBY_PAYMENTS_ALL

Object Details

Object Name:	IBY_PAYMENTS_ALL
Object Type:	TABLE
Owner:	IBY
FND Design Data:	IBY.IBY_PAYMENTS_ALL
Subobject Name:
Status:	VALID

IBY_PAYMENTS_ALL stores information on payments. A payment is a single check or fund transfer transaction between first party payer and third party payee. A payment pays one or more documents payable, and there may be one or more payments in a payment instruction. Payments are built by grouping documents payable according to Oracle Payments' grouping rules. This table corresponds to the Payments tab of the Funds Disbursement Process Home.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_PAYMENTS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_ID
IBY_PAYMENTS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_PROFILE_ID
IBY_PAYMENTS_ALL_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPLETED_PMTS_GROUP_ID ORG_ID ORG_TYPE
IBY_PAYMENTS_ALL_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_INSTRUCTION_ID PAPER_DOCUMENT_NUMBER ORG_ID
IBY_PAYMENTS_ALL_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_REFERENCE_NUMBER
IBY_PAYMENTS_ALL_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_CATEGORY_CODE DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_VALUE
IBY_PAYMENTS_ALL_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYEE_PARTY_ID
IBY_PAYMENTS_ALL_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SERVICE_REQUEST_ID PAYMENT_STATUS PAYMENTS_COMPLETE_FLAG
IBY_PAYMENTS_ALL_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_STATUS STOP_REQUEST_PLACED_FLAG STOP_CONFIRMED_FLAG
IBY_PAYMENTS_ALL_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_INSTRUCTION_ID PAYMENT_SERVICE_REQUEST_ID
IBY_PAYMENTS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SERVICE_REQUEST_ID
IBY_PAYMENTS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_REASON_CODE
IBY_PAYMENTS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_CHANNEL_CODE
IBY_PAYMENTS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_DATE
IBY_PAYMENTS_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXT_PAYEE_ID
IBY_PAYMENTS_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXTERNAL_BANK_ACCOUNT_ID
IBY_PAYMENTS_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERNAL_BANK_ACCOUNT_ID
IBY_PAYMENTS_ALL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_ID	NUMBER	(15)	Yes	Unique internal Identifier for this record. Generated using a database sequence.
PAYMENT_METHOD_CODE	VARCHAR2	(30)	Yes	Payment method used for making the payments.
PAYMENT_SERVICE_REQUEST_ID	NUMBER	(15)	Yes	Payment service request Id and it is the foreign key to the table iby_pay_service_requests.
PROCESS_TYPE	VARCHAR2	(30)	Yes	Specifies the process by which the payment is built into a payment instruction. Values, from the lookup IBY_PROCESS_TYPES, include STANDARD, IMMEDIATE, and MANUAL.
PAYMENT_STATUS	VARCHAR2	(30)	Yes	The status of the Payment. Values are derived from the lookup IBY_PAYMENT_STATUSES. The possible values are CREATED, FORMATTED, TRANSMITTED, VOID_BY_OVERFLOW, REJECTED, FORMATTED, VOID, etc.
PAYMENTS_COMPLETE_FLAG	VARCHAR2	(1)	Yes	Y or N flag that indicates if the payment is complete
PAYMENT_FUNCTION	VARCHAR2	(30)	Yes	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
PAYMENT_AMOUNT	NUMBER		Yes	Amount of the payment
PAYMENT_CURRENCY_CODE	VARCHAR2	(10)	Yes	Currency of the payment
BILL_PAYABLE_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether a payment is a bill payable, that is, a future dated payment
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether this payment is made up of a single document payable that was meant to be paid alone
SEPARATE_REMIT_ADVICE_REQ_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether a separate remittance advice needs to be generated for a payment.
INTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Internal bank account id used for making the payment.
ORG_ID	NUMBER	(15)	Yes	Unique internal identifier of the Operating Unit. Validated against HR_OPERATING_UNITS.ORGANIZATION_ID.
ORG_TYPE	VARCHAR2	(30)	Yes	Organization type. Values, from the lookup IBY_ORGANIZATION_TYPES Include Operating Unit, Business Group, and Legal Entity
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Legal entity identifier
DECLARE_PAYMENT_FLAG	VARCHAR2	(1)	Yes	Y or N flag that indicates whether this payment needs to be reported to the central bank of the country in which the payment is being made.
DELIVERY_CHANNEL_CODE	VARCHAR2	(30)		The delivery channel code for the payment. This is updated only when the payment s are grouped by Delivery channel code
EXT_PAYEE_ID	NUMBER	(15)	Yes	Payee Identifier to which actual payment is made.
PAYMENT_INSTRUCTION_ID	NUMBER	(15)		Payment instruction identifier
PAYMENT_PROFILE_ID	NUMBER	(15)	Yes	Payment process profile identifier
PREGROUPED_PAYMENT_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether this payment was grouped by the calling application. If the value is Y, all the documents of this payment will contain a non-null value for the payment grouping number attribute.
STOP_CONFIRMED_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether a stop has been confirmed on this payment.
STOP_RELEASED_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether a stop request has been released on this payment.
STOP_REQUEST_PLACED_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating whether a stop request has been placed on this payment.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column - date when a user last updated this row.
LAST_UPDATE_DATE	DATE		Yes	Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. This number is incremented for every update to the row through the application.
PAYEE_PARTY_ID	NUMBER	(15)		TCA party identifier
PARTY_SITE_ID	NUMBER	(15)		Party Site identifier Party Site Unique identifier from TCA tables. Validated against HZ_PARTY_SITES.PARTY_SITE_ID
SUPPLIER_SITE_ID	NUMBER	(15)		Supplier site identifier. Validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_ID.
PAYMENT_REASON_CODE	VARCHAR2	(30)		The payment reason code for the payment. This is updated only when the payment s are grouped by Payment reason code
PAYMENT_REASON_COMMENTS	VARCHAR2	(240)		Free text field available for entering a reason for the payment
PAYMENT_DATE	DATE			Payment date
ANTICIPATED_VALUE_DATE	DATE			With the current flow this would be null for all the payments. The field exists at the document level. This is not getting to payment level as payments can not be grouped by anticipated_value_date.
DECLARATION_AMOUNT	NUMBER			Sum of all reporting amounts from the documents that constitute this payment. This amount will be in the declaration or reporting currency.
DECLARATION_CURRENCY_CODE	VARCHAR2	(10)		Currency of the declaration amount
DISCOUNT_AMOUNT_TAKEN	NUMBER			Discount amount in payment currency
PAYMENT_DETAILS	VARCHAR2	(4000)		Concatenated string as per the Payment details formula provided in the Payment process profile.
BANK_CHARGE_BEARER	VARCHAR2	(30)		Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
BANK_CHARGE_AMOUNT	NUMBER			Bank charge amount in the payment currency
SETTLEMENT_PRIORITY	VARCHAR2	(30)		Priority with which the financial institution or payment system settles payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY.
REMITTANCE_MESSAGE1	VARCHAR2	(150)		Remittance message for use in payment processing
REMITTANCE_MESSAGE2	VARCHAR2	(150)		Remittance message for use in payment processing
REMITTANCE_MESSAGE3	VARCHAR2	(150)		Remittance message for use in payment processing
PAYMENT_REFERENCE_NUMBER	NUMBER	(15)		User and bank facing number identifying the payment
PAPER_DOCUMENT_NUMBER	NUMBER	(15)		Payment document number if a printed payment
BANK_ASSIGNED_REF_CODE	VARCHAR2	(30)		Payment system-provided reference code for this payment
EXTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)		External bank account identifier
UNIQUE_REMITTANCE_IDENTIFIER	VARCHAR2	(30)		Unique remittance Identifier would be defined at invoice level. If payments are grouped based on Unique remittance Identifier, then it would be populated to payment level.
URI_CHECK_DIGIT	VARCHAR2	(2)		Unique remittance identifier check digit
BANK_INSTRUCTION1_CODE	VARCHAR2	(30)		Code of first bank instruction
BANK_INSTRUCTION2_CODE	VARCHAR2	(30)		Code of second bank instruction
BANK_INSTRUCTION_DETAILS	VARCHAR2	(255)		Additional bank instruction details
PAYMENT_TEXT_MESSAGE1	VARCHAR2	(150)		Text message for use in payment processing
PAYMENT_TEXT_MESSAGE2	VARCHAR2	(150)		Text message for use in payment processing
PAYMENT_TEXT_MESSAGE3	VARCHAR2	(150)		Text message for use in payment processing
MATURITY_DATE	DATE			Calculated maturity date on a bill payable payment, that is, a future dated payment
PAYMENT_DUE_DATE	DATE			Date on which the payment is made. This is populated if grouped by payment due date.
DOCUMENT_CATEGORY_CODE	VARCHAR2	(30)		Sequential Numbering document category
DOCUMENT_SEQUENCE_ID	NUMBER			Sequential Numbering document sequence identifier
DOCUMENT_SEQUENCE_VALUE	NUMBER			Sequence number of document payable
BENEFICIARY_PARTY	NUMBER	(15)		Beneficiary party, if payment is made through a third party
STOP_CONFIRMED_BY	NUMBER	(15)		The user who confirmed the stop.
STOP_CONFIRM_DATE	DATE			Date on which the stop was confirmed.
STOP_CONFIRM_REASON	VARCHAR2	(240)		Reason for confirming the stop.
STOP_CONFIRM_REFERENCE	VARCHAR2	(100)		Payment system reference code for the confirmed stop payment.
STOP_RELEASED_BY	NUMBER	(15)		The user who released the stop request.
STOP_RELEASE_DATE	DATE			Date on which the stop request was released.
STOP_RELEASE_REASON	VARCHAR2	(240)		Reason for releasing the stop request.
STOP_RELEASE_REFERENCE	VARCHAR2	(100)		Payment system reference code for releasing or denying the stop request.
STOP_REQUEST_DATE	DATE			Date on which the stop request was placed.
STOP_REQUEST_PLACED_BY	NUMBER	(15)		The user who placed the stop request.
STOP_REQUEST_REASON	VARCHAR2	(240)		Reason for placing the stop request.
STOP_REQUEST_REFERENCE	VARCHAR2	(100)		Payment system reference code for the stop request.
VOIDED_BY	NUMBER	(15)		The user who voided the payment.
VOID_DATE	DATE			Date on which the payment was voided.
VOID_REASON	VARCHAR2	(240)		Reason for voiding the payment.
REMIT_TO_LOCATION_ID	NUMBER	(15)		Remit-To address identifier
COMPLETED_PMTS_GROUP_ID	NUMBER	(15)		The identifier of a group of payments, including this one, which were marked complete. The value is from the sequence IBY_COMPLETED_PMTS_GROUP_S.
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
EXT_BRANCH_NUMBER	VARCHAR2	(30)		Payee bank routing number (branch number), denormalized from CE bank branches view
EXT_BANK_NUMBER	VARCHAR2	(30)		Payee bank number, denormalized from CE bank branches view
EXT_BANK_ACCOUNT_NAME	VARCHAR2	(80)		Payee bank account name, denormalized from CE bank branches view
EXT_BANK_ACCOUNT_NUMBER	VARCHAR2	(100)		Masked payee bank account number, denormalized from CE bank accounts view
EXT_BANK_ACCOUNT_TYPE	VARCHAR2	(25)		Payee bank account type, denormalized from CE bank accounts view
EXT_BANK_ACCOUNT_IBAN_NUMBER	VARCHAR2	(50)		Masked payee bank account IBAN, denormalized from CE bank accounts view
PAYEE_NAME	VARCHAR2	(360)		Name of payee, if provided by administrator
PAYEE_ADDRESS1	VARCHAR2	(240)		First line for payee address, if provided by administrator
PAYEE_ADDRESS2	VARCHAR2	(240)		Second line for payee address, if provided by administrator
PAYEE_ADDRESS3	VARCHAR2	(240)		Third line for payee address, if provided by administrator
PAYEE_ADDRESS4	VARCHAR2	(240)		Fourth line for payee address, if provided by administrator
PAYEE_CITY	VARCHAR2	(60)		Payee city, if provided by administrator
PAYEE_POSTAL_CODE	VARCHAR2	(60)		Payee postal code, if provided by administrator
PAYEE_STATE	VARCHAR2	(120)		Payee state, if provided by administrator
PAYEE_PROVINCE	VARCHAR2	(120)		Payee province, if provided by administrator
PAYEE_COUNTY	VARCHAR2	(120)		Payee county, if provided by administrator
PAYEE_COUNTRY	VARCHAR2	(60)		Payee country code, if provided by administrator
REMIT_ADVICE_DELIVERY_METHOD	VARCHAR2	(30)		How the remittance advice, if any, is delivered using values from lookup type IBY_DELIVERY_METHODS
REMIT_ADVICE_EMAIL	VARCHAR2	(255)		E-mail address to which the remittance advice is delivered
REMIT_ADVICE_FAX	VARCHAR2	(100)		Fax number to which the remittance advice is delivered
PAYMENT_PROFILE_SYS_NAME	VARCHAR2	(100)		Denormalized from IBY_SYS_PMT_PROFILES; derive via PAYMENT_PROFILE_ ID
PAYMENT_PROFILE_ACCT_NAME	VARCHAR2	(100)		Denormalized from IBY_ACCT_PMT_PROFILES; derive via PAYMENT_PROFILE_ ID
PAYMENT_PROCESS_REQUEST_NAME	VARCHAR2	(255)		Denormalized from IBY_PAY_SERVICE_REQUESTS.CALL_APP_PAY_SERVICE_REQ_CODE; derive via PAYMENT_SERVICE_REQUEST_ID
SOURCE_PRODUCT	VARCHAR2	(50)		Denormalized from product name for product determined by IBY_PAY_SERVICE_REQUESTS. CALLING_APP_ID; derive via PAYMENT_SERVICE_REQUEST_ID
PAYMENT_REASON_FORMAT_VALUE	VARCHAR2	(80)		Payment reason value that is put into the extract for use by the format
DECLARATION_EXCH_RATE_TYPE	VARCHAR2	(255)		Exchange rate type used for reporting
DECLARATION_FORMAT	VARCHAR2	(100)		Format for reporting
DELIVERY_CHANNEL_FORMAT_VALUE	VARCHAR2	(80)		Delivery channel value that is put into the extract for use by the format
BANK_INSTRUCTION1_FORMAT_VALUE	VARCHAR2	(80)		Bank instruction value that is put into the extract for use by the format
BANK_INSTRUCTION2_FORMAT_VALUE	VARCHAR2	(80)		Bank instruction value that is put into the extract for use by the format
SRA_DELIVERY_METHOD	VARCHAR2	(100)		Denormalized from IBY_REMIT_ADVICE_SETUP.REMIT_ADVICE_ DELIVERY_METHOD derived via PPP
INT_BANK_NAME	VARCHAR2	(360)		Denormalized from HZ_PARTIES.PARTY_NAME; derived via INTERNAL_BANK_ACCOUNT_ID
INT_BANK_NUMBER	VARCHAR2	(30)		Denormalized from TCA; derived via INTERNAL_BANK_ACCOUNT_ID
INT_EFT_SWIFT_CODE	VARCHAR2	(30)		SWIFT code of the payer's bank
INT_BANK_BRANCH_NAME	VARCHAR2	(360)		Denormalized from TCA; derived via INTERNAL_BANK_ACCOUNT_ID
INT_BANK_BRANCH_NUMBER	VARCHAR2	(30)		Denormalized from TCA; derived via INTERNAL_BANK_ACCOUNT_ID
INT_BANK_ACCOUNT_NAME	VARCHAR2	(100)		Denormalized from CE; derived via INTERNAL_BANK_ACCOUNT_ID
INT_BANK_ACCOUNT_NUMBER	VARCHAR2	(30)		Denormalized from CE; derived via INTERNAL_BANK_ACCOUNT_ID
INT_BANK_ACCOUNT_IBAN	VARCHAR2	(50)		Denormalized from CE; derived via INTERNAL_BANK_ACCOUNT_ID
EXT_BANK_NAME	VARCHAR2	(360)		Denormalized from IBY_EXT_BANK_ACCOUNTS_V. BANK_NAME; derived via EXTERNAL_BANK_ACCOUNT_ID
EXT_EFT_SWIFT_CODE	VARCHAR2	(30)		SWIFT code of the payee's bank
EXT_BANK_BRANCH_NAME	VARCHAR2	(360)		Denormalized from IBY_EXT_BANK_ACCOUNTS_V. BANK_BRANCH_NAME; derived via EXTERNAL_BANK_ACCOUNT_ID
ORG_NAME	VARCHAR2	(240)		Denormalized fromHR_ALL_ORGANIZATION_UNITS.NAME; derived via ORG_ID
PAYER_LEGAL_ENTITY_NAME	VARCHAR2	(240)		Name of the legal entity making the disbursement
PAYER_LE_REGISTRATION_NUM	VARCHAR2	(240)		Legal registration number of the legal entity making the disbursement
PAYER_TAX_REGISTRATION_NUM	VARCHAR2	(50)		Tax registration number of the legal entity making the disbursement
PAYEE_PARTY_NAME	VARCHAR2	(360)		Denormalized from HZ_PARTIES.PARTY_NAME; derived via PAYEE_PARTY_ID
PAYEE_LE_REGISTRATION_NUM	VARCHAR2	(50)		Legal registration number of the legal entity receiving the disbursement
PAYEE_TAX_REGISTRATION_NUM	VARCHAR2	(50)		Tax registration number of the legal entity receiving the disbursement
PAYER_PARTY_SITE_NAME	VARCHAR2	(240)		Payer party site name
PAYEE_ADDRESS_CONCAT	VARCHAR2	(2000)		Concatenated denormalization from standard address fields HZ_LOCATIONS; derived via PARTY_SITE_ID.
BENEFICIARY_NAME	VARCHAR2	(360)		Denormalized from HZ_PARTIES.PARTY_NAME; derived via BENEFICIARY_PARTY_ID
PAYER_PARTY_NUMBER	VARCHAR2	(30)		Payer party number
PAYEE_PARTY_NUMBER	VARCHAR2	(30)		Payee party number
PAYEE_ALTERNATE_NAME	VARCHAR2	(320)		Payee party alternate name
PAYEE_SITE_ALTERNATE_NAME	VARCHAR2	(320)		Payee party site alternate name
PAYEE_SUPPLIER_NUMBER	VARCHAR2	(30)		Supplier number
PAYEE_FIRST_PARTY_REFERENCE	VARCHAR2	(30)		Payee first party reference
INT_BANK_BRANCH_RFC_IDENTIFIER	VARCHAR2	(30)		Internal bank branch RFC identifier
INT_BANK_ACCT_AGENCY_LOC_CODE	VARCHAR2	(30)		Auditing column for the corresponding value in CE_BANK_ACCOUNTS.AGENCY_LOCATION_CODE
PAYER_ABBREVIATED_AGENCY_CODE	VARCHAR2	(30)		Agency Location Code used by federal agencies
PAYER_FEDERAL_US_EMPLOYER_ID	VARCHAR2	(20)		Employer identifier used by federal agencies
EXT_BANK_ACCT_OWNER_PARTY_ID	VARCHAR2	(360)		Identifier of the bank branch of the payee
EXT_BANK_ACCT_PMT_FACTOR_FLAG	VARCHAR2	(1)		Identifier of the bank branch of the payee
ADDRESS_SOURCE	VARCHAR2	(30)		Source of the address. Possible values from the lookup IBY_ADDRESS_SOURCE_TYPES include TCA and HR.
EMPLOYEE_ADDRESS_CODE	VARCHAR2	(30)		Type of address. Possible values include HOME and OFFICE.
EMPLOYEE_PERSON_ID	NUMBER	(15)		Employee person Identifier
EMPLOYEE_PAYMENT_FLAG	VARCHAR2	(1)		Y or N flag indicating whether the payment is of the employee payment type
EMPLOYEE_ADDRESS_ID	NUMBER	(15)		HR Identifier of the address
REQUEST_ID	NUMBER	(15)		Concurrent request identifier associated with the current process, used to control updates to processes that are currently active
EXT_BANK_BRANCH_PARTY_ID	NUMBER			Identifier of the bank branch of the payee
EXT_BANK_ALT_NAME	VARCHAR2	(320)		Alternate name of the bank of the payee
EXT_BANK_BRANCH_ALT_NAME	VARCHAR2	(320)		Alternate name of the bank branch of the payee
EXT_BANK_ACCOUNT_ALT_NAME	VARCHAR2	(320)		Alternate name of the bank account of the payee
EXT_BANK_ACCOUNT_NUM_ELEC	VARCHAR2	(100)		Auditing column for the corresponding value in IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELEC
EXT_BANK_BRANCH_LOCATION_ID	NUMBER			Identifier of the address of the bank branch of the payee
EXT_BANK_ACCT_OWNER_PARTY_NAME	VARCHAR2	(360)		Name of the account owner of the payee bank account
INT_BANK_BRANCH_PARTY_ID	NUMBER			Identifier of the bank branch of the payer
INT_BANK_ALT_NAME	VARCHAR2	(320)		Alternate name of the bank of the payer
INT_BANK_BRANCH_ALT_NAME	VARCHAR2	(320)		Alternate name of the bank branch of the payer
INT_BANK_ACCOUNT_ALT_NAME	VARCHAR2	(320)		Alternate name of the bank account of the payer
INT_BANK_ACCOUNT_NUM_ELEC	VARCHAR2	(100)		Auditing column for the corresponding value in CE_BANK_ACCOUNTS.EFT_USER_NUM
INT_BANK_BRANCH_LOCATION_ID	NUMBER			Identifier of the address of the bank branch of the payer
INT_BANK_BRANCH_EFT_USER_NUM	VARCHAR2	(30)		Auditing column for the corresponding value in CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC
PAYER_PARTY_ID	NUMBER			Identifier of the supplier party
PAYER_LOCATION_ID	NUMBER			Identifier of the supplier party address
PAYER_PARTY_ATTR_CATEGORY	VARCHAR2	(150)		Payer party attribute category
PAYER_LE_ATTR_CATEGORY	VARCHAR2	(150)		Payer party legal entity attribute category
PAYEE_PARTY_ATTR_CATEGORY	VARCHAR2	(150)		Payer party legal entity attribute category
PAYEE_SUPPLIER_ATTR_CATEGORY	VARCHAR2	(150)		Payer party supplier attribute category
PAYEE_SPPLR_SITE_ATTR_CATEGORY	VARCHAR2	(150)		Payer partysupplier site attribute category
PAYEE_SUPPLIER_SITE_NAME	VARCHAR2	(240)		Supplier site name
PAYEE_SUPPLIER_SITE_ALT_NAME	VARCHAR2	(320)		Supplier site alternate name
PAYEE_SUPPLIER_ID	NUMBER			Supplier alternate name
LOGICAL_GROUP_REFERENCE	VARCHAR2	(200)		Indicates the grouping mode - None, Single, Mixed or Grouped.
POSITIVE_PAY_FILE_CREATED_FLAG	VARCHAR2	(1)		Indicates whether a Positive Pay file is created for a Payment
EXT_INV_PAYEE_ID	NUMBER	(22)		Payee identifier.
INV_PAYEE_PARTY_ID	NUMBER	(22)		Party (trading partner) identifier.
INV_PARTY_SITE_ID	NUMBER	(22)		Party site identifier
INV_SUPPLIER_SITE_ID	NUMBER	(22)		Supplier site identifier.
INV_BENEFICIARY_PARTY	NUMBER	(22)		Beneficiary party
INV_PAYEE_NAME	VARCHAR2	(360)		Name of party (trading partner)
INV_PAYEE_ADDRESS1	VARCHAR2	(240)		Fourth line of party (trading partner) address line 1
INV_PAYEE_ADDRESS2	VARCHAR2	(240)		Fourth line of party (trading partner) address line 2
INV_PAYEE_ADDRESS3	VARCHAR2	(240)		Fourth line of party (trading partner) address line 3
INV_PAYEE_ADDRESS4	VARCHAR2	(240)		Fourth line of party (trading partner) address line 4
INV_PAYEE_CITY	VARCHAR2	(120)		Party (trading partner) city.
INV_PAYEE_POSTAL_CODE	VARCHAR2	(240)		Party (trading partner) postal code.
INV_PAYEE_STATE	VARCHAR2	(120)		Party (trading partner) state
INV_PAYEE_PROVINCE	VARCHAR2	(120)		Party (trading partner) province
INV_PAYEE_COUNTY	VARCHAR2	(120)		Party (trading partner) county.
INV_PAYEE_COUNTRY	VARCHAR2	(120)		Party (trading partner) country.
INV_PAYEE_PARTY_NAME	VARCHAR2	(360)		Payee party name.
INV_PAYEE_LE_REG_NUM	VARCHAR2	(50)		Legal registration number of the Party (trading partner)
INV_PAYEE_TAX_REG_NUM	VARCHAR2	(50)		Tax registration number of the Party (trading partner)
INV_PAYEE_ADDRESS_CONCAT	VARCHAR2	(2000)		Payee concatenated standard address fields
INV_BENEFICIARY_NAME	VARCHAR2	(360)		Payee party number
INV_PAYEE_PARTY_NUMBER	VARCHAR2	(30)		Party (trading party) number
INV_PAYEE_ALTERNATE_NAME	VARCHAR2	(320)		Party (trading partner) alternate name
INV_PAYEE_SITE_ALT_NAME	VARCHAR2	(320)		Party (trading partner) alternate site name
INV_PAYEE_SUPPLIER_NUMBER	VARCHAR2	(30)		Supplier (Trading Partner) Number.
INV_PAYEE_FIRST_PARTY_REF	VARCHAR2	(30)		Party (trading partner) reference
EXT_BNK_ACCT_OWNR_INV_PRTY_ID	VARCHAR2	(360)		Party (trading partner) .
EXT_BNK_BRANCH_INV_PRTY_ID	NUMBER	(15)		Same as inv_payee_party_id
EXT_BNK_ACCT_OWNR_INV_PRTY_NME	VARCHAR2	(360)		Same as inv_payee_party_name
INV_PAYEE_PARTY_ATTR_CAT	VARCHAR2	(150)		Payee party category.
INV_PAYEE_SUPPLIER_ATTR_CAT	VARCHAR2	(150)		Supplier (Trading Partner) attribute category
INV_PAYEE_SPPLR_SITE_ATTR_CAT	VARCHAR2	(150)		Supplier (Trading Partner) site attribute category
INV_PAYEE_SUPPLIER_SITE_NAME	VARCHAR2	(150)		Supplier (Trading Partner) site name
INV_PAYEE_SPPLR_SITE_ALT_NAME	VARCHAR2	(320)		Supplier (Trading Partner) site alternative name
INV_PAYEE_SUPPLIER_ID	NUMBER	(22)		Supplier (Trading Partner) identifier
PAYEE_ADDRESSEE	VARCHAR2	(360)		Payee Addressee
PAYEE_PARTY_SITE_NAME	VARCHAR2	(360)		Payee Party site name
INV_PAYEE_PARTY_SITE_NAME	VARCHAR2	(360)		Invoice Payee party site name
ACKNOWLEDGED_FLAG	VARCHAR2	(1)		Acknowledged flag
AFFECTS_REJECTION_LEVEL	VARCHAR2	(1)

Query Text

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


SELECT PAYMENT_ID
,      PAYMENT_METHOD_CODE
,      PAYMENT_SERVICE_REQUEST_ID
,      PROCESS_TYPE
,      PAYMENT_STATUS
,      PAYMENTS_COMPLETE_FLAG
,      PAYMENT_FUNCTION
,      PAYMENT_AMOUNT
,      PAYMENT_CURRENCY_CODE
,      BILL_PAYABLE_FLAG
,      EXCLUSIVE_PAYMENT_FLAG
,      SEPARATE_REMIT_ADVICE_REQ_FLAG
,      INTERNAL_BANK_ACCOUNT_ID
,      ORG_ID
,      ORG_TYPE
,      LEGAL_ENTITY_ID
,      DECLARE_PAYMENT_FLAG
,      DELIVERY_CHANNEL_CODE
,      EXT_PAYEE_ID
,      PAYMENT_INSTRUCTION_ID
,      PAYMENT_PROFILE_ID
,      PREGROUPED_PAYMENT_FLAG
,      STOP_CONFIRMED_FLAG
,      STOP_RELEASED_FLAG
,      STOP_REQUEST_PLACED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      PAYEE_PARTY_ID
,      PARTY_SITE_ID
,      SUPPLIER_SITE_ID
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      PAYMENT_DATE
,      ANTICIPATED_VALUE_DATE
,      DECLARATION_AMOUNT
,      DECLARATION_CURRENCY_CODE
,      DISCOUNT_AMOUNT_TAKEN
,      PAYMENT_DETAILS
,      BANK_CHARGE_BEARER
,      BANK_CHARGE_AMOUNT
,      SETTLEMENT_PRIORITY
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      PAYMENT_REFERENCE_NUMBER
,      PAPER_DOCUMENT_NUMBER
,      BANK_ASSIGNED_REF_CODE
,      EXTERNAL_BANK_ACCOUNT_ID
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      BANK_INSTRUCTION1_CODE
,      BANK_INSTRUCTION2_CODE
,      BANK_INSTRUCTION_DETAILS
,      PAYMENT_TEXT_MESSAGE1
,      PAYMENT_TEXT_MESSAGE2
,      PAYMENT_TEXT_MESSAGE3
,      MATURITY_DATE
,      PAYMENT_DUE_DATE
,      DOCUMENT_CATEGORY_CODE
,      DOCUMENT_SEQUENCE_ID
,      DOCUMENT_SEQUENCE_VALUE
,      BENEFICIARY_PARTY
,      STOP_CONFIRMED_BY
,      STOP_CONFIRM_DATE
,      STOP_CONFIRM_REASON
,      STOP_CONFIRM_REFERENCE
,      STOP_RELEASED_BY
,      STOP_RELEASE_DATE
,      STOP_RELEASE_REASON
,      STOP_RELEASE_REFERENCE
,      STOP_REQUEST_DATE
,      STOP_REQUEST_PLACED_BY
,      STOP_REQUEST_REASON
,      STOP_REQUEST_REFERENCE
,      VOIDED_BY
,      VOID_DATE
,      VOID_REASON
,      REMIT_TO_LOCATION_ID
,      COMPLETED_PMTS_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EXT_BRANCH_NUMBER
,      EXT_BANK_NUMBER
,      EXT_BANK_ACCOUNT_NAME
,      EXT_BANK_ACCOUNT_NUMBER
,      EXT_BANK_ACCOUNT_TYPE
,      EXT_BANK_ACCOUNT_IBAN_NUMBER
,      PAYEE_NAME
,      PAYEE_ADDRESS1
,      PAYEE_ADDRESS2
,      PAYEE_ADDRESS3
,      PAYEE_ADDRESS4
,      PAYEE_CITY
,      PAYEE_POSTAL_CODE
,      PAYEE_STATE
,      PAYEE_PROVINCE
,      PAYEE_COUNTY
,      PAYEE_COUNTRY
,      REMIT_ADVICE_DELIVERY_METHOD
,      REMIT_ADVICE_EMAIL
,      REMIT_ADVICE_FAX
,      PAYMENT_PROFILE_SYS_NAME
,      PAYMENT_PROFILE_ACCT_NAME
,      PAYMENT_PROCESS_REQUEST_NAME
,      SOURCE_PRODUCT
,      PAYMENT_REASON_FORMAT_VALUE
,      DECLARATION_EXCH_RATE_TYPE
,      DECLARATION_FORMAT
,      DELIVERY_CHANNEL_FORMAT_VALUE
,      BANK_INSTRUCTION1_FORMAT_VALUE
,      BANK_INSTRUCTION2_FORMAT_VALUE
,      SRA_DELIVERY_METHOD
,      INT_BANK_NAME
,      INT_BANK_NUMBER
,      INT_EFT_SWIFT_CODE
,      INT_BANK_BRANCH_NAME
,      INT_BANK_BRANCH_NUMBER
,      INT_BANK_ACCOUNT_NAME
,      INT_BANK_ACCOUNT_NUMBER
,      INT_BANK_ACCOUNT_IBAN
,      EXT_BANK_NAME
,      EXT_EFT_SWIFT_CODE
,      EXT_BANK_BRANCH_NAME
,      ORG_NAME
,      PAYER_LEGAL_ENTITY_NAME
,      PAYER_LE_REGISTRATION_NUM
,      PAYER_TAX_REGISTRATION_NUM
,      PAYEE_PARTY_NAME
,      PAYEE_LE_REGISTRATION_NUM
,      PAYEE_TAX_REGISTRATION_NUM
,      PAYER_PARTY_SITE_NAME
,      PAYEE_ADDRESS_CONCAT
,      BENEFICIARY_NAME
,      PAYER_PARTY_NUMBER
,      PAYEE_PARTY_NUMBER
,      PAYEE_ALTERNATE_NAME
,      PAYEE_SITE_ALTERNATE_NAME
,      PAYEE_SUPPLIER_NUMBER
,      PAYEE_FIRST_PARTY_REFERENCE
,      INT_BANK_BRANCH_RFC_IDENTIFIER
,      INT_BANK_ACCT_AGENCY_LOC_CODE
,      PAYER_ABBREVIATED_AGENCY_CODE
,      PAYER_FEDERAL_US_EMPLOYER_ID
,      EXT_BANK_ACCT_OWNER_PARTY_ID
,      EXT_BANK_ACCT_PMT_FACTOR_FLAG
,      ADDRESS_SOURCE
,      EMPLOYEE_ADDRESS_CODE
,      EMPLOYEE_PERSON_ID
,      EMPLOYEE_PAYMENT_FLAG
,      EMPLOYEE_ADDRESS_ID
,      REQUEST_ID
,      EXT_BANK_BRANCH_PARTY_ID
,      EXT_BANK_ALT_NAME
,      EXT_BANK_BRANCH_ALT_NAME
,      EXT_BANK_ACCOUNT_ALT_NAME
,      EXT_BANK_ACCOUNT_NUM_ELEC
,      EXT_BANK_BRANCH_LOCATION_ID
,      EXT_BANK_ACCT_OWNER_PARTY_NAME
,      INT_BANK_BRANCH_PARTY_ID
,      INT_BANK_ALT_NAME
,      INT_BANK_BRANCH_ALT_NAME
,      INT_BANK_ACCOUNT_ALT_NAME
,      INT_BANK_ACCOUNT_NUM_ELEC
,      INT_BANK_BRANCH_LOCATION_ID
,      INT_BANK_BRANCH_EFT_USER_NUM
,      PAYER_PARTY_ID
,      PAYER_LOCATION_ID
,      PAYER_PARTY_ATTR_CATEGORY
,      PAYER_LE_ATTR_CATEGORY
,      PAYEE_PARTY_ATTR_CATEGORY
,      PAYEE_SUPPLIER_ATTR_CATEGORY
,      PAYEE_SPPLR_SITE_ATTR_CATEGORY
,      PAYEE_SUPPLIER_SITE_NAME
,      PAYEE_SUPPLIER_SITE_ALT_NAME
,      PAYEE_SUPPLIER_ID
,      LOGICAL_GROUP_REFERENCE
,      POSITIVE_PAY_FILE_CREATED_FLAG
,      EXT_INV_PAYEE_ID
,      INV_PAYEE_PARTY_ID
,      INV_PARTY_SITE_ID
,      INV_SUPPLIER_SITE_ID
,      INV_BENEFICIARY_PARTY
,      INV_PAYEE_NAME
,      INV_PAYEE_ADDRESS1
,      INV_PAYEE_ADDRESS2
,      INV_PAYEE_ADDRESS3
,      INV_PAYEE_ADDRESS4
,      INV_PAYEE_CITY
,      INV_PAYEE_POSTAL_CODE
,      INV_PAYEE_STATE
,      INV_PAYEE_PROVINCE
,      INV_PAYEE_COUNTY
,      INV_PAYEE_COUNTRY
,      INV_PAYEE_PARTY_NAME
,      INV_PAYEE_LE_REG_NUM
,      INV_PAYEE_TAX_REG_NUM
,      INV_PAYEE_ADDRESS_CONCAT
,      INV_BENEFICIARY_NAME
,      INV_PAYEE_PARTY_NUMBER
,      INV_PAYEE_ALTERNATE_NAME
,      INV_PAYEE_SITE_ALT_NAME
,      INV_PAYEE_SUPPLIER_NUMBER
,      INV_PAYEE_FIRST_PARTY_REF
,      EXT_BNK_ACCT_OWNR_INV_PRTY_ID
,      EXT_BNK_BRANCH_INV_PRTY_ID
,      EXT_BNK_ACCT_OWNR_INV_PRTY_NME
,      INV_PAYEE_PARTY_ATTR_CAT
,      INV_PAYEE_SUPPLIER_ATTR_CAT
,      INV_PAYEE_SPPLR_SITE_ATTR_CAT
,      INV_PAYEE_SUPPLIER_SITE_NAME
,      INV_PAYEE_SPPLR_SITE_ALT_NAME
,      INV_PAYEE_SUPPLIER_ID
,      PAYEE_ADDRESSEE
,      PAYEE_PARTY_SITE_NAME
,      INV_PAYEE_PARTY_SITE_NAME
,      ACKNOWLEDGED_FLAG
,      AFFECTS_REJECTION_LEVEL
FROM IBY.IBY_PAYMENTS_ALL;

Dependencies

[top of page]

IBY.IBY_PAYMENTS_ALL does not reference any database object

IBY.IBY_PAYMENTS_ALL is referenced by following:

IBY: IBY_PAYMENTS_ALL#