My Payments Table Descriptions hand book (I have big hands) Part 1

Payments - IBY_ACCPPMTMTHD	IBY_ACCPPMTMTHD contains a list of all the payment instrument methods that are accepted by a iPayment.
Column Name	Descritpion
PAYEEID	ID of the payee passed by Ellectronic Commerce Application
ECAPPID	Electronic Commerce Application identifier
ACCTTYPEID	Account type identifier
MPAYEEID	Payee Identifier
STATUS	Status in 0-active, 1-inactive.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_ACCTTYPE	IBY_ACCTTYPE contains a list of various account types supported. For example for bank account, the account types could be Checking, Savings etc, for Credit Card, the account types could be Visa, MasterCard, Discover etc...
Column Name	Descritpion
ACCTTYPEID	AccountType identifier
ACCTTYPE	Indicates the type of Accounts e.g CHECKING, SAVING, VISA, AMEX etc. It is a lookup code for LOOKUP TYPE IBY_ACCT_TYPE.
INSTRTYPE	Indicates different instrument types e.g bank account, credit card etc. It is a lookup code for lookup type IBY_INSTRUMENT_TYPES.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_BATCHES_ALL	"This table contains records of the settlement batch information which is updated by system while processing 'Create settlement Batches' program.IBY_BATCHES_ALL stores information about batch operations for credit cards and bank account tra
Column Name	Descritpion
BATCHID	Batch Identifier provided by electronic commerce application
BATCHTOTAL	Total net amount for this batch
BATCHSALES	Total inflow
BATCHCREDIT	Total outflow including return and credit transaction amounts
CURRENCYNAMECODE	ISO currency code for this batch
VPSBATCHID	Batch Identifier from payment system
GWBATCHID	Batch Identifier from Gateway
LEGAL_ENTITY_ID	Legal entity identifier
ERRORLOCATION	Indicates the location of error
BEPCODE	Error code from payment system
BEPMESSAGE	Error messages from payment system
BATCHOPENDATE	Date batch was opened
PAYEEID	Identifier of the payee passed by electronic commerce application
REQTYPE	"Request type like oraPmtCloseBatch,oraPmtQueryBatch from lookup type IBY_TRXN_REQTYPES"
REQDATE	Date when the batch operation request is received
DESTURL	Payment system URL constructed during schedule of payments
TERMINALID	Terminal Identifier used for credit card processing. A merchant can get multiple terminal identifiers with a batch open for each one. The merchant can perform operations on those batches independently.
ACQUIRER	Merchant bank which may be optionally returned
NLSLANG	NLS Language
SENTCOUNTER	Count of the number of times the batch has been sent to the payment system
SENTCOUNTERDAILY	Count of the number of times that the batch has been sent to the payment system on the current day
NEEDSUPDT	Y or N flag indicating that the rows that have changed status
SECURITY_GROUP_ID	Used in hosted environments
BEPID	Back End Payment system Identifier.
ORG_ID	Unique internal identifier of the Operating Unit. Validated against HR_OPERATING_UNITS.ORGANIZATION_ID.
ORG_TYPE	Organization type from lookup type IBY_ORGANIZATION_TYPES
INSTRUMENT_TYPE	Instrument type for the batch from lookup type IBY_PAYMENT_INSTR_TYPES
BR_DISPUTED_FLAG	Bills receivable disputed flag
BEPKEY	Merchant account Identifier used with this transaction
MPAYEEID	Payee Identifier
CREATED_BY	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	Standard who column - date when this row was created.
LAST_UPDATED_BY	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_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	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	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.
PAYER_NOTIFICATION_REQUIRED	Y or N flag indicating whether payer notification needs to be created for settlements in this batch
ECAPPID	Electronic commerce application Identifier
PAYER_NOTIFICATION_CREATED	Y or N flag indicating whether payer notification has been created for settlements in this batch
PAYMENTMETHODNAME	Name of the payment method
PROCESS_PROFILE_CODE	The funds capture process profiles code used in the batch.
BATCHSTATUS	"Batch status like scuccess-0, failed-7, pending-11, submitted-18, Batch Partially Succeded-6from Lookup type : IBY_TRANSACTION_STATUS"
MBATCHID	Unique internal Identifier for this record. Generated using a database sequence.
BATCHCLOSEDATE	Close date of this batch
NUMTRXNS	Number of transactions in this batch
BATCHSTATEID	State of the batch. Batch states are 0 for batch accepted, 1 for batch sent, 2 for batch queued, 3 for batch rejected, 4 for batch processed, 5 for batch error, 6 for batch not found, and 7 for batch unknown.
PAYEEINSTRID	Internal bank account for all transactions in the batch
SETTLEDATE	Settlement date for all transactions in the batch

Payments - IBY_BEPINFO	IBY_BEPKEYS stores information about the payment systems.
Column Name	Descritpion
BEPID	Payment system identifier
ADMINURL	URL to the native Back End Payment System admin pages
LOGINURL	loginurl to the payment system
LOGOUTURL	logouturl to the payment system
SRVRIDIMMED	Y or N flag indicating that Server ID is immediately sent
ACTIVESTATUS	Indicates whether payment system is active or not
LEADTIME	Lead time that is needed to schedule the payment
HOLIDAYFILE	Denotes support for holiday file
FILESUPPORT	Y or N flag
SECURITYSCHEME	Denotes whether HTML Page or Wallet for invoice or pay operation
INSTRTYPE	Instrument type
BEP_TYPE	Indicates whether the BEP is a processor or gateway model payment system. Values for this column include: PROCESSOR and GATEWAY
NAME	Name of the payment system
MAX_BATCH_SIZE	No longer used
OUTBOUND_INVALID_CHARS	Invalid characters to be replaced by the corresponding replacement characters. Generally should have positional correspondence with the replacement ones. For Citi-Payables only.
OUTBOUND_REPLACE_CHARS	Replacement characters corresponding to the invalid characters. Generally should have positional correspondence with the invalid ones. For Citi-Payables only.
SECURITY_GROUP_ID	Used in hosted environment
BANK_ID	System generated primary key
NLS_LANGUAGE	NLS language character set for the payment system network communication.
INACTIVE_DATE	Inactive date
SEEDED_FLAG	Y or N flag indicating that the data is seeded record
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
BASEURL	URL to the payment system
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.
SUFFIX	Three-letter payment system suffix. This is unique per payment system
PARTY_ID	Oracle Internal use only - reserved for future use
BEPUSERNAME	Username for authenticating from iPayment to Back End Payment System.
BEPPASSWORD	password for BEPUSERNAME.
SUPPORTEDOP	Bitmap to denote operations supported by bank end payment system
PSUSERNAME	username for authenticating from Back End Payment System to iPayment
PSPASSWORD	Password for PSUSERNAME

Payments - IBY_BEPKEYS	IBY_BEPKEYS stores information about the payment systems accounts.
Column Name	Descritpion
BEP_ACCOUNT_ID	Identifier of the payment system account
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SECURITY_GROUP_ID	Unsed in hosted environment
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
OWNERID	Identifier of the payer or payee
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
BEPID	Payment system identifier
KEY	Payment system account name
DEFAULTS	Y or N flag to denote whether this key is the payee's default for the given payment system
OWNERTYPE	Payer or payee
LAST_UPDATE_DATE	Standard Who column
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard Who column

Payments - IBY_BEPLANGS	IBY_BEPLANGS contains list of all the languages supported by the Back End Payment System
Column Name	Descritpion
BEPID	Back End Payment System identifier
BEPLANG	language supported by the Back End Payment System
PREFERRED	denotes whether this is the preferred language of the Back End Payment System
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_DEFAULT_BEP	IBY_DEFAULT_BEP stores information that will allow a payment system account and funds capture process profile to be derived for a transaction should the routing rules fail to yield them.
Column Name	Descritpion
INSTRTYPE	Type of Instrument supported by Back End Payment System
BEPID	Back End Payment System identifier
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	Used in hosted environments
MPAYEEID	Payee identifier
PAYMENT_CHANNEL_CODE	Payment method of the transaction
FNDCPT_USER_PROFILE_CODE	Default funds capture process profile to be used for the payment method if routing rules fail to yield one
BEP_ACCOUNT_ID	Default payment system account that

Payments - IBY_ECAPP	IBY_ECAPP stores information about Electronic Commerce Applications registered with iPayment. Oracle Applications which integrate with iPayment directly - via iPayment Java and PL/SQL API's are treated as EC applications by iPayment. They w
Column Name	Descritpion
NAME	Electronic Commerce Application name
APPLICATION_SHORT_NAME	Application Short Name
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ECAPPID	Electronic Commerce Application identifier
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_PAYEE	IBY_PAYEE stores a row for each payee, such as a biller, merchant, or store at this site.
Column Name	Descritpion
PAYEEID	Payee Identifier passed by electronic commerce application
INACTIVE_DATE	Inactive date
LAST_UPDATE_DATE	Standard Who column
OBJECT_VERSION_NUMBER	Used for locking purposes that subsequently allows for checking if there is 'old data on the screen compared to what is in the database. The situation occurs when the HTML application is a stateless application.
NAME	Name of the payee
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SECURITY_GROUP_ID	Used in hosted environments
ECAPPID	Electronic commerce application Identifier
USERNAME	Username for authentication
MPAYEEID	System generated Payee Identifier
PASSWORD	Password for the username above
ACTIVESTATUS	Y or N flag to indicate whether the merchant is active
THRESHOLD	Threshold value to check against the overall risk score
RISK_ENABLED	Y or N flag indicating whether risk management feature is enabled
SUPPORTEDOP	Bit map to denote operations supported by the payee
MCC_CODE	Merchant category code, or MCC, for this payee, if applicable
MASTER_KEY	Oracle internal use only, reserved for future use
SECURITY_ENABLED	Oracle internal use only, reserved for future use
EMAIL_ADDRESS	Oracle internal use only, reserved for future use
FINANCING_PAYEE_FLAG	Oracle internal use only, reserved for future use
DBA_NAME	Payee doing-business-name
DBA_CITY	Payee doing-business-as address city
DBA_STATE_PROVINCE	Payee doing-business-as address state or province
DBA_COUNTRY	Payee doing-business-as address country

Payments - IBY_PMTMTHD_CONDITIONS	IBY_PMTMTHD_CONDITIONS stores the conditions for payment methods. Each condition is comprised of a parameter, operation, and value. The condition is evaluated at runtime to determine if the payment system account and funds capture process p
Column Name	Descritpion
PAYMENTMETHODID	Payment method Identifier
SECURITY_GROUP_ID	Used in hosted environments
CONDITION_NAME	Mnemonic created by the user for one of the conditions which constitutes a routing rule
PARAMETER_CODE	AMOUNT, INSTRTYPE, or other condition
OPERATION_CODE	EQUALS, NEQUALS, or other operation
VALUE	Value for the condition
IS_VALUE_STRING	Value type such as number or character
ENTRY_SEQUENCE	Number which denotes the order in which the admin user has entered the conditions. When queried, it needs to be displayed in the same order that the user entered it.
LAST_UPDATE_DATE	Standard Who column
OBJECT_VERSION_NUMBER	Used for locking purposes that subsequently allows for checking if there is old data on the screen compared to what is in the database. The situation occurs when the HTML application is a stateless application.
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_ROUTINGINFO	IBY_ROUTINGINFO stores information that maps payment method to the payment system and funds capture process profile via conditions.
Column Name	Descritpion
FNDCPT_USER_PROFILE_CODE	Funds capture process profile
PAYMENT_CHANNEL_CODE	Payment method
INSTR_TYPE	Instrument type for which this routing rule applies. One of CREDITCARD, PURCHASECARD, or BANKACCOUNT
BEP_ACCOUNT_ID	Payment system account
INSTR_SUB_TYPE	If INSTR_TYPE is BANKACCOUNT, subtype can be either ACH or BR
BEPID	Payment system Identifier
PAYMENTMETHODID	System-generated identifier of the payment method
PAYMENTMETHODNAME	Name of the payment method
BEPKEY	Merchant account Identifier associated with this routing rule
MPAYEEID	Payee Identifier
CONFIGURED	Indicates whether payment method is active or not. 1 is active and 0 is inactive.
PRIORITY	Order in which the payment methods are selected
HITCOUNTER	Count of the number of times the routing rule was chosen
LAST_UPDATE_DATE	Standard Who column
PAYEEID	Payee Identifier passed by electronic commerce application
INACTIVE_DATE	Inactive Date
OBJECT_VERSION_NUMBER	Used for locking purposes that subsequently allows for checking if there is old data on the screen compared to what is in the database. The situation occurs when the HTML application is a stateless application.
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_TANGIBLE	IBY_TANGIBLE stores information about the bills or orders.
Column Name	Descritpion
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
TANGIBLEID	bill or orderid
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
SECURITY_GROUP_ID	Used in hosted environments
AMOUNT	Amount
CURRENCYNAMECODE	code for currency name such USD
SOURCE_OBJECT_TYPE_CODE	Type of the originating EC App quote or order. Foreign Key to JTF_OBJECTS_B
SOURCE_OBJECT_ID	Primary Key of the source object
ACCTNO	customer account number with the biller or merchant
MTANGIBLEID	system generated ID, this id is exposed to Electronic application unlike others
REFINFO	any reference information passed by the Electronic Commerce Application
MEMO	memo for the payment
ISSUEDATE	Date the Bills Receivable or Receipt was issued. Added for AR-BR integration
ORDER_MEDIUM	Order medium/channel from lookup type IBY_ORDER_MEDIUM_TYPE
EFT_AUTH_METHOD	Method used in obtaining authorization for performing EFT debits against the payer's bank account

Payments - IBY_PMTSCHEMES	IBY_PMTSCHEMES stores a list of payment schemes that are supported by a payment system.
Column Name	Descritpion
PMTSCHEMENAME	Name of the Payment Scheme : SSL,SET,Bank Account or FI
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
CREATION_DATE	Standard Who column
BEPID	Payment system identifier
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.
PMTSCHEMEID	Obsolete: this ID is not used to retrieve which payment instrument processing is allowed for a payment system. The code only uses PMTSCHEMENAME
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_BANKACCT	IBY_BANKACCOUNTstores bank account related information of the customer(payer) or payee.
Column Name	Descritpion
BANKACCOUNTID	Bank Account number
ADDRESSID	Address identifier, FK to HZ_LOCATIONS table. Address for the bank branch.
FINAME	Financial Institution Name - bank name
ACCTTYPEID	Accttype identifier, FK to iby_accttype. CHECKING, SAVING, etc.
BRANCHNAME	Bank Branch Name. Used to store bank branch number
BRANCHID	Bank branch number. Added for AR-BR integration
ROUTINGNO	ABA Routing Number for US bank accounts; bank number for non-US banks issued by some Code Agency
DESCRIPTION	Description of the instruments
INSTRNAME	Name of the instrument
ACCOUNT_HOLDER_NAME	Account Holder Name
BANKSWIFTCODE	Bank SWIFT code. Added for AR-BR integration
INSTRID	System generated id. Primary key
CHECK_DIGITS	Check digits for bank accounts that identify them separately from the bank account numbers
ENCRYPTED	Indicates whether strong encryption was used on sensitive data
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
SECURITY_GROUP_ID	Used in hosted environments
CURRENCY_CODE	ISO three digits currency code

Payments - IBY_CREDITCARD	IBY_CREDITACRD stores Credit Card related information of the customer(payer) or payee.
Column Name	Descritpion
CCNUMBER	Credit Card number
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
EXPIRYDATE	Expiry Date
ACCTTYPEID	Accttype identifier,FK to iby_accttype table
SECURITY_GROUP_ID	Used in hosted environments
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
SEC_SUBKEY_ID
ADDRESSID	Address identifier, FK to HZ_LOCATIONS table
BILLING_ADDR_POSTAL_CODE
BILL_ADDR_TERRITORY_CODE
INSTRNAME	Name of the Instrument
DESCRIPTION	Description of the instrument
CHNAME	Card Holder Name
FINAME	Financial Institution Name
INSTRID	ID generated by the system
SUBTYPE	Stores the subtype of the purchasecard e.g "corporate card","busines card" etc
ENCRYPTED	Flag indicating if the instrument is encrypted
MASKED_CC_NUMBER
CARD_MASK_SETTING
CARD_UNMASK_LENGTH
CC_NUMBER_HASH1
CC_NUMBER_HASH2
CARD_OWNER_ID
INSTRUMENT_TYPE
PURCHASECARD_FLAG
PURCHASECARD_SUBTYPE
CARD_ISSUER_CODE
CC_ISSUER_RANGE_ID
CC_NUMBER_LENGTH
ACTIVE_FLAG
SINGLE_USE_FLAG
INFORMATION_ONLY_FLAG
CARD_PURPOSE
INACTIVE_DATE
CC_NUM_SEC_SEGMENT_ID

Payments - IBY_INSTRHOLDER	IBY_INSTRHOLDER stores the information about the holder of the instrment. A payment instrument can be held by different users or payees or payers.
Column Name	Descritpion
INSTRTYPE	Instrument type
OWNERID	referes to ID of the payee or payer of the instrument. For AR-BR integration, the ownerid for PAYER type is passed from AR as ARcustomer name.
OWNERTYPE	refers to either payee or payer. Used to be hard-coded as "USER", which is used equivalently as "PAYER". For AR-BR integration, it will be either "PAYER" or "PAYEE"
ACTIVESTATUS	referes to whether the instrument is active or not in the system
OWNERADDRESSID	Foreign key to HZ_LOCATIONS. Stores the BILL_TO address of the payee or payer. Added for AR-BR integration
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
INSTRID	Instrument identifier, FK to instrument tables (iby_creditcard, iby_bankacct).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_ACTIVITY	IBY_ACTIVITY stores scheduler related activities.
Column Name	Descritpion
APPLICATION_ID	Application Identifier
COLUMN15	the columns which stores the values of activities.
COLUMN16	the columns which stores the values of activities.
COLUMN17	the columns which stores the values of activities.
COLUMN18	the columns which stores the values of activities.
COLUMN19	the columns which stores the values of activities.
COLUMN20	the columns which stores the values of activities.
COLUMN21	the columns which stores the values of activities.
COLUMN22	the columns which stores the values of activities.
COLUMN23	the columns which stores the values of activities.
COLUMN24	the columns which stores the values of activities.
ACTIVITY_NAME_ID	Activity Name Identifier which logs this activity
COLUMN25	the columns which stores the values of activities.
COLUMN26	the columns which stores the values of activities.
COLUMN27	the columns which stores the values of activities.
COLUMN28	the columns which stores the values of activities.
COLUMN29	the columns which stores the values of activities.
COLUMN30	the columns which stores the values of activities.
COLUMN31	vthe columns which stores the values of activities.
COLUMN32	the columns which stores the values of activities.
COLUMN33	the columns which stores the values of activities.
COLUMN34	the columns which stores the values of activities.
JTF_ACT_ACTIVITY_LOGS_USER_ID	JTF Activity Log User Identifier
COLUMN35	the columns which stores the values of activities.
COLUMN36	the columns which stores the values of activities.
COLUMN37	the columns which stores the values of activities.
COLUMN38	the columns which stores the values of activities.
COLUMN39	the columns which stores the values of activities.
COLUMN40	the columns which stores the values of activities.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
COMPONENT	Subcomponent of the Loging activity
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
SECURITY_GROUP_ID	Used in hosted environments
COLUMN1	the columns which stores the values of activities.
COLUMN2	the columns which stores the values of activities.
COLUMN3	the columns which stores the values of activities.
COLUMN4	the columns which stores the values of activities.
JTF_ACT_ACTIVITY_LOGS_ID	JTF Activity Log Identifier
COLUMN5	the columns which stores the values of activities.
COLUMN6	the columns which stores the values of activities.
COLUMN7	the columns which stores the values of activities.
COLUMN8	the columns which stores the values of activities.
COLUMN9	the columns which stores the values of activities.
COLUMN10	the columns which stores the values of activities.
COLUMN11	the columns which stores the values of activities.
COLUMN12	the columns which stores the values of activities.
COLUMN13	the columns which stores the values of activities.
COLUMN14	the columns which stores the values of activities.

Payments - IBY_IRF_PMT_AMOUNT	This table stores information pertaining to the payment amount risk factor involved in the payment request. A payment request that has huge amount is possibly a fraudulent payment. But the value of the amount varies from business to busines
Column Name	Descritpion
SEQ	Sequence
UPPER_LIMIT	Upper limit of payment amount. Customer payment amount should be lessl to or greater then the upper limit and greater then the lower limit.
SCORE	LOV of possible risk scores : low risk, medium low risk, medium risk, medium high risk or high risk for a particular range of limits in terms of making payments for goods/services he orders.
PAYEEID	Id of the payee passed by electronic commerce application
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LOWER_LIMIT	Lower limit of payment amount. Customer payment amount should be equal to or greater then the lower limit.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_IRF_PMT_FREQUENCY	This table stores information pertaining to the payment frequency risk factor. It basically has information about the frequency of purchase in the given time frame(duration). This risk fatcor is associated with a risk score - low and high.
Column Name	Descritpion
DURATION_TYPE	LOV : Number of days or weeks
FREQUENCY	Number of purchases made during the spcified duration
PAYEEID	Id of the payee passed by electronic commerce application
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DURATION	Number of days, weeks, months or year
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_IRF_PMT_HISTORY	This table stores information pertaining to the payment history risk factor. The merchant can set up different time ranges which he considers risky.
Column Name	Descritpion
ID	Unique Id generated by the system
DURATION	Number of Month, Year
DURATION_TYPE	LOV: Month, Year
PAYEEID	Id of the payee passed by electronic commerce application
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_IRF_PMT_HIST_RANGE	This table stores the frequency ranges information pertaining to the payment history risk factor. The customer can setup multiple frequency ranges for a specific duration. During Risk Factor evaluation the merchant can setup risk scores (lo
Column Name	Descritpion
FREQUENCY_HIGH_RANGE	High Limit of purchase frequency
FREQUENCY_LOW_RANGE	Low Limit of purchase frequency
SEQ	Sequence
SCORE	LOV of possible risk scores : low risk, medium low risk, medium risk, medium high risk, high risk for a particular range of frequency limits
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PAYMENT_HIST_ID	ID associated with payment history
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_IRF_RISKY_INSTR	IBY_IRF_RISKY_INSTR stores information pertaining to the risk instrument risk factor. It has information about the merchant who sends the file of risky instruments, the type of instrument and other account information pertaining to the risk
Column Name	Descritpion
INSTRTYPE	Intrument Type. Bank Account, Credit Card etc
ROUTING_NO	Bank ID to which the account belongs
ACCOUNT_NO	Bank Account Number
CREDITCARD_NO	Credit Card Number
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PAYEEID	id of the payee passed by electronic commerce application
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_IRF_TIMEOF_PURCHASE	This table stores information pertaining to the time of purchase risk factor. The merchant can setup different time ranges - and associate a risk score of low risk, medium low risk, medium risk , medium high risk and high risk.
Column Name	Descritpion
SEQ	Sequence
DURATION_TO	Stores the end time HH:MM of the duration range
SCORE	LOV of possible risk scores : low risk, medium low risk, medium risk, medium high risk, high risk for a particular range of frequency limits
PAYEEID	Id of the payee passed by electronic commerce application
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
DURATION_FROM	Stores the beginning time HH:MM of the duration range
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_IRF_TRXN_AMT_LIMIT	IBY_IRF_TRXN_AMT_LIMITstores information pertaining to the transaction amount limit risk factor. It is a limit on the total amount of payments made using the same instrument in a particular duration.
Column Name	Descritpion
DURATION_TYPE	LOV : days, weeks, month, years
AMOUNT	Transaction Amount limit
PAYEEID	id of the payee passed by electronic commerce application
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DURATION	Number of days, weeks, months or year
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_MAPPINGS	IBY_MAPPINGS stores mapping of codes with risk scores. Each row includes a code and a value for that code.
Column Name	Descritpion
MAPPING_CODE	Mapping Code
VALUE	Value of a lookup code
DESCRIPTION	Description of the quick code
SEQ	sequence
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
PAYEEID	PayeeID is the id of the payee passed by ecapplication
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
MAPPING_TYPE	Mapping Code type e.g avs, riskcode, credit rating
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_RISK_FACTORS	IBY_RISK_FACTORS stores information about the Risk Factors. These are factors which a merchant deems fit to use to evaluate the risk of the customer who wants to purchase its goods and services. Risk Management feature will contain bundled
Column Name	Descritpion
RISK_FACTOR_ID	ID generated by the System to uniquely identify a particular Risk Factor
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
CREATION_DATE	Standard who column - date when this row was created.
RISK_FACTOR_CODE	Look up type to fnd_lookups
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
FACTOR_TYPE	Risk Factor Type
SECURITY_GROUP_ID	Used in hosted environments
INTERFACE_NAME	Class Name of the object , which will be loaded dynamically at runtime.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

Payments - IBY_RISK_FORMULAS	IBY_RISK_FORMULAS stores risk formula retaled information . Risk Formula is used by merchants to evaluate the risk of the customer. This formula could be different for different goods/services offered by the merchants. A Risk Formula may be
Column Name	Descritpion
RISK_FORMULA_ID	ID generated by the System to uniquely identify a particular Risk Formula
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
FORMULA_NAME	Risk Formula Name
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DESCRIPTION	Description of the Risk Formula
SECURITY_GROUP_ID	Used in hosted environments
PAYEEID	Payee associated with this risk formula
IMPLICIT_FLAG	Flag that indicates if the formula is implicit or not. Valid values are 0,1'.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.

Payments - IBY_RISK_FORMULA_ITEM	IBY_RISK_FORMULA_ITEM table is an intersection table between the IBY_RISK_FORMULA and IBY_RISK_FACTORS. It stores weight for different Risk Factors.
Column Name	Descritpion
WEIGHT	Weights would be in the range of 0 (no weight) to 100 (full weight)
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
CREATION_DATE	Standard who column - date when this row was created.
RISK_FORMULA_ID	Risk Formula defining column
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
RISK_FACTOR_ID	Risk Factor defining column
SECURITY_GROUP_ID	Used in hosted environments
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.

Payments - IBY_F_PC_RATES_ALL
Column Name	Descritpion
RATE_ID
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RATE
CUSTOMER_TYPE_CODE
PAYMENT_TERM
PAYMENT_TERM_UOM_CODE
DEAL_SIZE_MIN
DEAL_SIZE_MAX
DEAL_SIZE_CURRENCY_CODE
ORG_ID
REQUEST_ID	Request Identifier
SECURITY_GROUP_ID
PROGRAM_APPLICATION_ID	Application Identifier of last concurrent program to update record
PROGRAM_ID	Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE	Last date concurrent program updated record
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Payments - IBY_F_T_CA_GRNTRS_B
Column Name	Descritpion
CREDIT_APP_GRNTR_ID
START_DATE_ACTIVE
END_DATE_ACTIVE
EMAIL_ADDRESS
SECURITY_KEY
CREDIT_APP_GRNTR_SEQ
SECURITY_GROUP_ID
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREDIT_APP_ID
ACTIVE_FLAG

Payments - IBY_F_CRDT_APP_STATUS_B
Column Name	Descritpion
CREDIT_APP_STATUS_ID
END_DATE_ACTIVE
UPDATE_ALLOWED_FLAG
SEEDED_FLAG
STATUS_CATEGORY_CODE
STATUS_NUMBER
SECURITY_GROUP_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
STATUS_CODE
START_DATE_ACTIVE

Payments - IBY_F_T_CA_GRNTR_H
Column Name	Descritpion
CA_GRNTR_HISTORY_ID
GRNTR_EVENT_TIME
SECURITY_GROUP_ID
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREDIT_APP_GRNTR_ID
GRNTR_EVENT_CODE

Payments - IBY_G_T_MESSAGES
Column Name	Descritpion
MESSAGE_ID
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
TRXN_SUMMARY_ID
CREDIT_APP_ID
MESSAGE_XML_ID
MESSAGE_CAT_CODE
MESSAGE_TYPE_CODE
MESSAGE_TIME
SECURITY_GROUP_ID
REQUEST_ID	Request Identifier
PROGRAM_APPLICATION_ID	Application Identifier of last concurrent program to update record
PROGRAM_ID	Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE	Last date concurrent program updated record
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Payments - IBY_F_T_CRDT_APP_REVS
Column Name	Descritpion
REVISION_ID
CREDIT_APP_REV_NUM
REVISION_TYPE_CODE
USER_ID
USER_TYPE_CODE
SECURITY_GROUP_ID
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREDIT_APP_ID
REVISION_XML_DOC_ID

Payments - IBY_F_T_CA_GRNTRS_TL
Column Name	Descritpion
CREDIT_APP_GRNTR_ID
LANGUAGE
SOURCE_LANG
SECURITY_GROUP_ID
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FIRST_NAME
LAST_NAME

Payments - IBY_G_MSG_TEMPLATES_TL
Column Name	Descritpion
MSG_TEMPLATE_ID
DESCRIPTION
LANGUAGE
SOURCE_LANG
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
MESSAGE_TEMPLATE
NAME

Payments - IBY_F_T_EMAIL_NOTIF_LOG
Column Name	Descritpion
PROGRAM_APPLICATION_ID	Application Identifier of last concurrent program to update record
ROLE_NAME
EMAIL_ADDRS
EMAIL_ADDR_COUNT
EMAIL_STATUS_CODE
PROGRAM_ID	Identifier of last concurrent program to update record
SECURITY_GROUP_ID
PROGRAM_UPDATE_DATE	Last date concurrent program updated record
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
EMAIL_NOTIF_LOG_ID
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREDIT_APP_ID
REQUEST_ID	Request Identifier
MSG_TEMPLATE_ID
CREDIT_APP_GRNTR_ID
WF_ITEM_KEY
EMAIL_NOTIF_TIME

Payments - IBY_F_CRDT_APP_STATUS_TL
Column Name	Descritpion
CREDIT_APP_STATUS_ID
LANGUAGE
SOURCE_LANG
SECURITY_GROUP_ID
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
NAME
DESCRIPTION
CUST_FACING_NAME

Payments - IBY_F_T_CRDT_APPS_ALL_TL
Column Name	Descritpion
CREDIT_APP_ID
LANGUAGE
SOURCE_LANG
SECURITY_GROUP_ID
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
NAME
DESCRIPTION

Payments - IBY_G_MSG_TEMPLATES_B
Column Name	Descritpion
MSG_TEMPLATE_ID
MSG_TYPE_CODE
FROZEN_FLAG
SEEDED_FLAG
START_DATE_ACTIVE
END_DATE_ACTIVE
SECURITY_GROUP_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
MSG_TEMPLATE_NAME
MSG_TEMPLATE_NUMBER
MSG_TEMPLATE_VERSION

Payments - IBY_G_T_MSG_REQ_LOG
Column Name	Descritpion
MSG_REQ_LOG_ID
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
MESSAGE_ID
MSG_REQ_COUNT
MSG_REQ_TIME
EXT_SYSTEM_RESP_CODE
SECURITY_GROUP_ID
REQUEST_ID	Request Identifier
PROGRAM_APPLICATION_ID	Application Identifier of last concurrent program to update record
PROGRAM_ID	Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE	Last date concurrent program updated record
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Payments - IBY_G_ST_TRANSITIONS
Column Name	Descritpion
TRANSITION_ID
RULE_CATEGORY_CODE
ENABLED_FLAG
SECURITY_GROUP_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FROM_STATUS_ID
TO_STATUS_ID

Payments - IBY_F_T_CRDT_APP_ST_H
Column Name	Descritpion
STATUS_HISTORY_ID
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREDIT_APP_ID
OLD_STATUS_ID
NEW_STATUS_ID
USER_ID
USER_TYPE_CODE
CA_STATUS_EVENT_CODE
CA_STATUS_EVENT_TIME
CA_STATUS_EVENT_DESC
REQUEST_ID	Request Identifier
SECURITY_GROUP_ID
PROGRAM_APPLICATION_ID	Application Identifier of last concurrent program to update record
PROGRAM_ID	Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE	Last date concurrent program updated record
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Payments - IBY_F_T_CRDT_APPS_ALL_B
Column Name	Descritpion
CREDIT_APP_ID
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
TRXN_SUMMARY_ID
CREDIT_APP_STATUS_ID
CREDIT_APP_XML_ID
TERMS_N_CONDITIONS_XML_ID
FINANCING_TYPE_CODE
DURATION
DURATION_UOM_CODE
PAYMENT_STRUCTURE_CODE
REQUEST_ID	Request Identifier
INTEREST_RATE
DECISION_TIME_FRAME
DECISION_TIME_FRAME_UOM_CODE
FIRST_SAVED_DATE
EXPIRATION_DATE
EXP_EXTENDED_COUNT
EXPIRING_FLAG
DOC_RECEIVED_DATE
DOC_RECEIVED_FLAG
N_PG_REQUESTED
N_PG_SUBMITTED
BUYER_FORM_MARKUP_FLAG
ORG_ID
SECURITY_GROUP_ID
ATTRIBUTE_CATEGORY
PROGRAM_APPLICATION_ID	Application Identifier of last concurrent program to update record
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
PROGRAM_ID	Identifier of last concurrent program to update record
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
PROGRAM_UPDATE_DATE	Last date concurrent program updated record
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Payments - IBY_PAY_INVOICEPMTS	Stores a reference to the invoice in the calling payable programs
Column Name	Descritpion
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PMT_TRXN_ID	Foreign key to IBY_PAY_PAYMENTS_ALL. Reference to the owning payment transaction
INVOICE_NUMBER	Stores AP_SELECTED_INVOICES_ALL.INVOICE_NUM
ECAPP_ID	Electronic Commerce Application Identifier
INVOICE_DATE	Stores AP_SELECTED_INVOICES_ALL.INVOICE_DATE
INVOICE_AMOUNT	Stores AP_SELECTED_INVOICES_ALL.INVOICE_AMOUNT
PAYMENT_AMOUNT	Stores AP_SELECTED_INVOICES_ALL.PAYMENT_AMOUNT
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column

Payments - IBY_PAY_BATCHES_ALL	Stores batch level payment information as submitted by payable programs
Column Name	Descritpion
PMT_BATCH_REQUEST_ID	The parent concurrent request which initiated the payment request that submitted the batch to iPayment. For Oracle Payables, this is the Payment Process Manager request
CUST_ADDR3	Address line3 of the paying customer. For Oracle Payables, this is the default org location (HR_LOCATIONS_ALL) associated with the operating unit.
CUST_ADDR_CITY	City of the paying customer
CUST_ADDR_COUNTY	County (US, UK); Province (CA)
CUST_ADDR_STATE	State or Province of the paying customer
CUST_ADDR_ZIP	Zip code of the paying customer
CUST_ADDR_COUNTRY	Country code of the paying customer
CUST_ADDR_ADDN	Additional address segment
ORIG_BANK_NAME	Paying customer bank name. AP_BANK_BRANCHES.BANK_NAME
ORIG_BANK_NUMBER	AP_BANK_BRANCHES.BANK_NUMBER. Holds the number by some countries to identify bank.
ORIG_BANK_BRANCH_NAME	AP_BANK_BRANCHES.BANK_BRANCH_NAME.
ORIG_BANK_BRANCH_TYPE	AP_BANK_BRANCHES.BANK_BRANCH_TYPE. Indicates which list the bank routing number is on. Valid values are ABA, CHIPS, SWIFT and OTHER.
ORIG_BANK_BRANCH_NUM	AP_BANK_BRANCHES.BANK_NUM. Bank branch number.
ORIG_EFT_SWIFT_CODE	AP_BANK_BRANCHES.EFT_SWIFT_CODE
ORIG_BANK_ACCOUNT_NAME	Paying customer bank account name. AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NAME
PAYER_ID	Payer identifier. The payer you registered in iPayment
ORIG_BANK_ACCT_NUMBER	Paying customer bank account number. AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NUM
ORIG_BANK_ACCT_CHECK_DIGITS	AP_BANK_ACCOUNTS_ALL.CHECK_DIGITS
ORIG_BANK_ACCT_TYPE	Paying customer bank account type. AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_TYPE
ORIG_BANK_ADDR_LINE1	AP_BANK_BRANCHES.ADDRESS_LINE1
MPAYER_ID	Payer identifier. Primary key of IBY_PAYEE
ORIG_BANK_ADDR_CITY	AP_BANK_BRANCHES.CITY
ORIG_BANK_ADDR_STATE	AP_BANK_BRANCHES.STATE
ORIG_BANK_ADDR_ZIP	AP_BANK_BRANCHES.ZIP
ORIG_COUNTRY_CODE	AP_BANK_BRANCHES.COUNTRY
PMT_METHOD	AP_INV_SELECTION_CRITERIA_ALL.PAYMENT_METHOD_LOOKUP_CODE. Only CHECK, WIRE, and EFT are supported
CURRENCY_CODE	AP_INV_SELECTION_CRITERIA_ALL.CURRENCY_CODE
BATCH_ID	System generated primary key
REF_CURRENCY_CODE	not used
DOC_ORDER_LOOKUP_CODE	AP_INV_SELECTION_CRITERIA_ALL.DOCUMENT_ORDER_LOOKUP_CODE
NUM_OF_TRXNS	Number of transactions in this payment batch
BATCH_TOTAL	total payment amount of the batch
BATCH_STATUS	batch status
IBY_BATCH_ID	Merged parent batch in IBY_BATCHES_ALL
REQUEST_DATE	date and time when the batch is submitted to iPayment
PMT_BATCH_NAME	Batch name as given in Oracle Payables.
IBY_MBATCH_ID	Merged parent batch in IBY_BATCHES_ALL. Primary key of IBY_BATCHES_ALL
PMT_BATCH_SET_ID	AP_INV_SELECTION_CRITERIA_ALL.BATCH_SET_ID
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column
ECAPP_ID	EC application registration Identifier. For Oracle Applications such as Oracle Payables, this is the APPLICATION_ID in FND_APPLICATION for the corresponding app
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ERROR_LOCATION	Identifies the location of error
ORG_ID	AP_INV_SELECTION_CRITERIA_ALL.ORG_ID
BEP_CODE	Error code from Back End Payment System
BEP_MESSAGE	Error message from Back End Payment System
BEPID	Back-end Payment System Identifier. Foreign key to IBY_BEPINFO. This is the third party bank or payment processor that will process the payment request
BEPKEY	Payment System Merchant Identifier
CUST_ID	Customer identifier from the external calling payable program. For Oracle Payables, this is the ORG_ID of the payment request originating operating unit
CUST_NAME	Name of the paying customer. For Oracle Payables, this is the orgnization name (HR_ALL_ORGNIZATION_UNITS.NAME) for which the payable request is originated.
CUST_ADDR1	Address line1 of the paying customer. For Oracle Payables, this is the default org location (HR_LOCATIONS_ALL) associated with the operating unit.
CUST_ADDR2	Address line2 of the paying customer. For Oracle Payables, this is the default org location (HR_LOCATIONS_ALL) associated with the operating unit.

Payments - IBY_PAY_PAYMENTS_ALL	Stores transaction level payment information as submitted by payable programs
Column Name	Descritpion
PAYER_ID	Payer Identifier
MAIL_ADDRESS3	AP_SELECTED_INVOICE_CHECKS_ALL.ADDRESS_LINE3
MAIL_ADDR_CITY	AP_SELECTED_INVOICE_CHECKS_ALL.CITY
MAIL_ADDR_STATE	AP_SELECTED_INVOICE_CHECKS_ALL.STATE
MAIL_ADDR_ZIP	AP_SELECTED_INVOICE_CHECKS_ALL.ZIP
PMT_LOC_COUNTRY_CODE	Country code of the beneficiary address. AP_SELECTED_INVOICE_CHECKS_ALL.COUNTRY
VALUE_AMOUNT	AP_SELECTED_INVOICE_CHECKS_ALL.CHECK_AMOUNT
REF_AMOUNT	Amount in the reference currency
VALUE_DATE	AP_SELECTED_INVOICE_CHECKS_ALL.PAYMENT_DATE
CHARGE_DETAILS	PO_VENDOR_SITES_ALL.BANK_CHARGE_BEARER
VAT_AMOUNT	Oracle Internal use only - reserved for future use
WHT_AMOUNT	Oracle Internal use only - reserved for future use
BATCH_ID	Batch Identifier. Foreign key to IBY_PAY_BATCHES_ALL
PMT_DETAILS_1	Oracle Internal use only - reserved for future use
PMT_DETAILS_2	Oracle Internal use only - reserved for future use
PMT_DETAILS_3	Oracle Internal use only - reserved for future use
PMT_DETAILS_4	Oracle Internal use only - reserved for future use
TRXN_CODE_CLRID	Transaction code from PO_VENDOR_SITES_ALL flexfield
BNF_NAME	AP_SELECTED_INVOICE_CHECKS_ALL.VENDOR_NAME
BNF_ID	PO_VENDORS.SEGMENT1. Supplier number
BNF_ADDRESS_LINE1	PO_VENDOR_SITES_ALL.ADDRESS_LINE1
BNF_ADDRESS_LINE2	PO_VENDOR_SITES_ALL.ADDRESS_LINE2
BNF_ADDRESS_LINE3	PO_VENDOR_SITES_ALL.ADDRESS_LINE3
BNF_ADDR_CITY	PO_VENDOR_SITES_ALL.CITY
BNF_ADDR_STATE	PO_VENDOR_SITES_ALL.STATE
PMT_TRXN_ID	System generated primary key
BNF_ADDR_ZIP	PO_VENDOR_SITES_ALL.ZIP
BNF_ADDR_COUNTRY	Oracle Internal use only - reserved for future use
BNF_ADDR_PHONE	PO_VENDOR_SITES_ALL.PHONE
BNF_REMARKS	Oracle Internal use only - reserved for future use
BNF_CHARGE_AMT	Oracle Internal use only - reserved for future use
BNF_ADJUSTMENT_AMT	Oracle Internal use only - reserved for future use
BNF_BANK_NAME	AP_BANK_BRANCHES.BANK_NAME
BNF_BANK_NUM	AP_BANK_BRANCHES.BANK_NUMBER
BNF_BANK_ADDRESS	AP_BANK_BRANCHES.ADDRESS_LINE1
BNF_BANK_ADDR_CITY	AP_BANK_BRANCHES.CITY
BNF_BANK_ADDR_STATE	AP_BANK_BRANCHES.STATE
BNF_BANK_ADDR_ZIP	AP_BANK_BRANCHES.ZIP
BNF_BANK_ADDR_COUNTRY	AP_BANK_BRANCHES.COUNTRY
BNF_BANK_BRANCH_NAME	AP_BANK_BRANCHES.BANK_BRANCH_NAME
BNF_BANK_BRANCH_NUM	AP_BANK_BRANCHES.BANK_NUM
BNF_BANK_BRANCH_TYPE	AP_BANK_BRANCHES.BANK_BRANCH_TYPE
BNF_BANK_SWIFT_CODE	AP_BANK_BRANCHES.EFT_SWIFT_CODE
BNF_BANK_ACCOUNT_NAME	AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NAME
BNF_BANK_ACCT_NUMBER	AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NUM
BNF_BANK_ACCT_CHECK_DIGITS	AP_BANK_ACCOUNTS_ALL.CHECK_DIGITS
BNF_BANK_ACCT_IBAN_NUMBER	International Bank Account Number. Corresponds to IBAN_NUMBER in AP_BANK_ACCOUNTS_ALL
BNF_BANK_ACCT_TYPE	AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_TYPE
BNF_FAXNO_CABLEADDR	Store the concatenated fax number from PO_VENDER_SITES_ALL
BNF_SITE_CODE	PO_VENDER_SITES_ALL.VENDER_SITE_CODE
ECAPP_ID	Electronic Commerce Application Identifier
PMT_PRIORITY	PO_VENDOR_SITES.PAYMENT_PRIORITY
BNF_BANK_CLEARING_MTD	Oracle Internal use only - reserved for future use
BNF_TAXPAYER_ID	PO_VENDORS_ALL.NUM_1099
FUTURE_PAY_DUE_DATE	AP_SELECTED_INVOICE_CHECKS_ALL.FUTURE_PAY_DUE_DATE
CUST_REF	AP_SELECTED_INVOICE_CHECKS_ALL.CHECK_NUMBER
INTRM_BANK_CODE	Oracle Internal use only - reserved for future use
INTRM_SWIFT_CODE	Oracle Internal use only - reserved for future use
INTRM_BANK_NAME	Oracle Internal use only - reserved for future use
INTRM_BANK_FAXNO_CBL	Oracle Internal use only - reserved for future use
PMT_STATUS	status of this transaction
PMT_APPROVAL_STATUS	Oracle Internal use only - reserved for future use
DEBIT_ACCT_NUMBER	AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NUM. Same as IBY_PAY_BATCHES_ALL.ORIG_BANK_ACCT_NUMBER
UPDATE_DATE	Oracle Internal use only - reserved for future use
OBJECT_VERSION_NUMBER	Application level record locking for three tier stateless applications
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
FAX_MAIL_TO_NAME	AP_SELECTED_INVOICE_CHECKS_ALL.VENDOR_NAME. Same as BNF_NAME
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	AP_INV_SELECTION_CRITERIA_ALL.ORG_ID
ERROR_LOCATION	Identifies the location of error
BEP_CODE	Error code from Back End Payment System
BEP_MESSAGE	Error message from Back End Payment System
MAIL_ADDRESS1	Beneficiary address line1. AP_SELECTED_INVOICE_CHECKS_ALL.ADDRESS_LINE1
MAIL_ADDRESS2	AP_SELECTED_INVOICE_CHECKS_ALL.ADDRESS_LINE2

Payments - IBY_PAYEE_SUBKEYS
Column Name	Descritpion
MPAYEE_ID
SUBKEY_CIPHER_TEXT
USE_COUNT
OBJECT_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
SECURITY_GROUP_ID
PAYEE_SUBKEY_ID

Payments - IBY_PCARD_BIN_RANGE	Stores the BIN ranges for all valid purchase cards.
Column Name	Descritpion
UPPERLIMIT	The upper limit of the BIN range.
PCARD_SUBTYPE	Character value giving the sub-type of the purchase card. Multiple characters are used if the card belongs to more than a single subtype.
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LOWERLIMIT	The lower limit of the BIN range.
SECURITY_GROUP_ID	Used in hosted environments

Payments - IBY_HOOK_DOCS_IN_PMT_T
Column Name	Descritpion
PAYMENT_ID
DOCUMENT_CURRENCY_CODE
AMOUNT_WITHHELD
DONT_PAY_FLAG
DONT_PAY_REASON_CODE
DONT_PAY_DESCRIPTION
PAY_PROC_TRXN_TYPE_CODE
INTERNAL_BANK_ACCOUNT_ID
EXT_PAYEE_ID
PAYEE_PARTY_ID
PARTY_SITE_ID
DOCUMENT_PAYABLE_ID
SUPPLIER_SITE_ID
ORG_ID
ORG_TYPE
EXTERNAL_BANK_ACCOUNT_ID
PAYMENT_CURR_DISCOUNT_TAKEN
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CALLING_APP_ID
OBJECT_VERSION_NUMBER
CALLING_APP_DOC_UNIQUE_REF1
CALLING_APP_DOC_UNIQUE_REF2
CALLING_APP_DOC_UNIQUE_REF3
CALLING_APP_DOC_UNIQUE_REF4
CALLING_APP_DOC_UNIQUE_REF5
DOCUMENT_AMOUNT

Payments - IBY_DOCS_PAYABLE_GT
Column Name	Descritpion
DOCUMENT_PAYABLE_ID
PAYMENT_METHOD_CODE
PAYMENT_FORMAT_CODE
PAYMENT_AMOUNT
EXCLUSIVE_PAYMENT_FLAG
PAYMENT_PROFILE_ID
PAYMENT_FUNCTION
PROCESS_TYPE
DOCUMENT_DATE
DOCUMENT_TYPE
DOCUMENT_DESCRIPTION
CALLING_APP_ID
DOCUMENT_AMOUNT
DOCUMENT_CURRENCY_TAX_AMOUNT
DOCUMENT_CURR_CHARGE_AMOUNT
PAYMENT_CURR_DISCOUNT_TAKEN
PAYMENT_DUE_DATE
PAYMENT_GROUPING_NUMBER
INTERNAL_BANK_ACCOUNT_ID
EXTERNAL_BANK_ACCOUNT_ID
PAYEE_PARTY_ID
PAYEE_PARTY_SITE_ID
CALLING_APP_DOC_UNIQUE_REF1
SUPPLIER_SITE_ID
REMIT_TO_LOCATION_ID
LEGAL_ENTITY_ID
ORG_ID
ORG_TYPE
DOCUMENT_CURRENCY_CODE
PAYMENT_CURRENCY_CODE
BANK_CHARGE_BEARER
BANK_CHARGE_AMOUNT
PAYMENT_CURR_BANK_CHARGES
CALLING_APP_DOC_UNIQUE_REF2
PAYMENT_DATE
ANTICIPATED_VALUE_DATE
PAYMENT_REASON_CODE
PAYMENT_REASON_COMMENTS
SETTLEMENT_PRIORITY
REMITTANCE_MESSAGE1
REMITTANCE_MESSAGE2
REMITTANCE_MESSAGE3
UNIQUE_REMITTANCE_IDENTIFIER
URI_CHECK_DIGIT
CALLING_APP_DOC_UNIQUE_REF3
BANK_ASSIGNED_REF_CODE
DELIVERY_CHANNEL_CODE
INTEREST_RATE
PO_NUMBER
AMOUNT_WITHHELD
DISCOUNT_DATE
DOC_SEQUENCE_ID
DOC_SEQUENCE_VALUE
ALLOW_REMOVING_DOCUMENT_FLAG
DOC_CATEGORY_CODE
CALLING_APP_DOC_UNIQUE_REF4
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
CALLING_APP_DOC_UNIQUE_REF5
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
CALLING_APP_DOC_REF_NUMBER
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
PAY_PROC_TRXN_TYPE_CODE

Payments - IBY_HOOK_PAYMENTS_T
Column Name	Descritpion
CALLING_APP_ID
INTERNAL_BANK_ACCOUNT_ID
EXT_PAYEE_ID
PAYEE_PARTY_ID
PARTY_SITE_ID
SUPPLIER_SITE_ID
ORG_ID
ORG_TYPE
EXTERNAL_BANK_ACCOUNT_ID
DISCOUNT_AMOUNT_TAKEN
PAYMENT_DATE
CALL_APP_PAY_SERVICE_REQ_CODE
BANK_CHARGE_AMOUNT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
PAYMENT_SERVICE_REQUEST_ID
PAYMENT_ID
PAYMENT_AMOUNT
PAYMENT_CURRENCY_CODE
DONT_PAY_FLAG
DONT_PAY_REASON_CODE
DONT_PAY_DESCRIPTION

Payments - IBY_PAYMENT_METHODS_B	IBY_PAYMENT_METHODS stores the payment methods that Oracle Payments supports. A payment method is a payment attribute on a document payable that indicates how the first party payer is going to make the payment. Examples of payment methods i
Column Name	Descritpion
PAYMENT_METHOD_CODE	User entered primary key
PAYMENT_REASON_COMNT_APL_FLAG	Indicates whether the payment reason comment attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
REMITTANCE_MESSAGE1_APL_FLAG	Indicates whether the remittance message1 attribute is mandatory, optional, or non-applicable to this payment method. The default setting is optional.
REMITTANCE_MESSAGE2_APL_FLAG	Indicates whether the remittance message2 attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
REMITTANCE_MESSAGE3_APL_FLAG	Indicates whether the remittance message3 attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
UNIQUE_REMITTANCE_ID_APL_FLAG	Indicates whether the unique remittance identifier attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
URI_CHECK_DIGIT_APL_FLAG	Indicates whether the URI check digit attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
DELIVERY_CHANNEL_APL_FLAG	Indicates whether the delivery channel attribute is mandatory, optional, or non-applicable to this payment method. The default setting is optional.
PAYMENT_FORMAT_APL_FLAG	Indicates whether the payment format attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
SETTLEMENT_PRIORITY_APL_FLAG	Indicates whether the settlement priority attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
EXCLUSIVE_PMT_APL_FLAG	Indicates whether the pay alone attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
CREATED_BY	Standard Who column
EXTERNAL_BANK_ACCT_APL_FLAG	Indicates whether the external bank account attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.
SUPPORT_BILLS_PAYABLE_FLAG	Indicates whether this payment method can be used to issue bills payable, that is future dated payments
DOCUMENT_CATEGORY_CODE	Document category code that is linked to a payment method. Document category codes are used in providing document sequence numbers for payments.
MATURITY_DATE_OFFSET_DAYS	With this payment method, number of days to be added to the payment date on a payment, which determines its maturity date
INACTIVE_DATE	Inactive date
ANTICIPATED_FLOAT	Days added to the payment date for use in cash forecasting
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
CREATION_DATE	Standard Who column
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
FORMAT_VALUE	Value used in the formatted payment instruction
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
SEEDED_FLAG	Y or N flag controlling updatability of records. Y indicates record was seeded by Oracle and may have user updates limited.
BANK_CHARGE_BEARER_APL_FLAG	Indicates whether the bank charge bearer attribute is mandatory, optional or non-applicable to this payment method. The default setting is disabled.
PAYMENT_REASON_APL_FLAG	Indicates whether the payment reason attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled.

Payments - IBY_PAYMENT_METHODS_TL	IBY_PAYMENT_METHODS stores the payment methods that Oracle Payments supports. A payment method is a payment attribute on a document payable that indicates how the first party payer is going to make the payment. Examples of payment methods i
Column Name	Descritpion
PAYMENT_METHOD_CODE	User entered primary key
OBJECT_VERSION_NUMBER	Object version number
DESCRIPTION	Free text description of the payment method
LANGUAGE	Language code
SOURCE_LANG	Language code of the record's current language
PAYMENT_METHOD_NAME	Payment method name
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_EXT_PARTY_PMT_MTHDS	IBY_EXT_PARTY_PMT_MTHDS stores payment method applicability driven by the preferences of the external party. A payment method is applicable to a party and payment function combination and, optionally and additionally, to a party site and/or
Column Name	Descritpion
EXT_PARTY_PMT_MTHD_ID	System generated primary key
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
INACTIVE_DATE	Inactive date
PAYMENT_METHOD_CODE	Payment method Identifier
PAYMENT_FLOW	Determines the source table for the PAYMENT_METHOD_CODE foreign key. Values from the lookup IBY_PAYMENT_FLOW are DISBURSEMENTS and FUND_CAPTURE.
EXT_PMT_PARTY_ID	External party Identifier, either a payee or payer, depending on the payment flow
PAYMENT_FUNCTION	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
PRIMARY_FLAG	Indicates if payment method is primary. Y for Yes, N otherwise.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Payments - IBY_APPLICABLE_PMT_MTHDS	IBY_APPLICABLE_PMT_MTHDS stores the payment method applicability information for company policy-based factors. The factors include First Party Legal Entity, First Party Organization, Payment Processing Transaction Type, Transaction is Forei
Column Name	Descritpion
APPLICABLE_PMT_MTHD_ID	System generated primary key
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
EXCLUDE_FROM_APPLIC_FLAG	Y or N flag
INACTIVE_DATE	Inactive date
PAYMENT_METHOD_CODE	Payment method identifier
PAYMENT_FLOW	Determines the source table for the PAYMENT_METHOD_CODE foreign key. Lookup values of IBY_PAYMENT_FLOW lookup type. Values are DISBURSEMENTS and FUND_CAPTURE.
APPLICABLE_TYPE_CODE	Applicable type. Each type corresponds to one factor in determining the applicability of a payment method. Lookup values of IBY_PMT_MTHD_USAGE_RULE_TYPES lookup type
APPLICABLE_VALUE_FROM	From value of the applicability type. Used for the payment amount applicability only
APPLICABLE_VALUE_TO	To value of the applicability type
APPLICATION_ID	Application Identifier of the calling product
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Payments - IBY_DELIVERY_CHANNELS_B	IBY_DELIVERY_CHANNELS stores delivery channel information that is used as lookup values for external payee setup or documents payable. The table is similar to FND_LOOKUPS, but with a new column for territory identification. Products that us
Column Name	Descritpion
DELIVERY_CHANNEL_CODE	User entered primary key
INACTIVE_DATE	Inactive date
TERRITORY_CODE	Code of the country where the delivery channel code is assigned or used
FORMAT_VALUE	Value required by the payment format that uses this delivery channel
SEEDED_FLAG	Y or N flag controlling updatability of records. Y indicates record was seeded by Oracle and may have user updates limited.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number

Payments - IBY_DOCS_PAYABLE_ALL	"This table contains records of the documents payable which are updated by system while processing 'Build payments' program. IBY_DOCS_PAYABLE_ALL stores Oracle Payments' representation of source products' documents payable. A document pay
Column Name	Descritpion
PAY_PROC_TRXN_TYPE_CODE	Type of payment processing transaction or document
DOCUMENT_CURRENCY_CODE	Document currency code
GLOBAL_ATTRIBUTE20	Global Descriptive Flexfield segment.
DOCUMENT_AMOUNT	Total amount in document currency
PAYMENT_CURRENCY_CODE	Payment currency code
PAYMENT_AMOUNT	Amount to be paid in payment currency
PAYMENT_SERVICE_REQUEST_ID	Identifier of the payment process request in which this document was submitted
PAYMENT_METHOD_CODE	Payment method Identifier
EXCLUSIVE_PAYMENT_FLAG	Y or N flag indicating whether this document payable should not be grouped with any other documents payable.
STRAIGHT_THROUGH_FLAG	When processing type Printed and if automatically print after formatting check box is selected, the flag is set to Y, otherwise N. Similarly, when processing type is electronic and payment completion point is selected as when payment instru
EXT_PAYEE_ID	External payee Identifier
PAYEE_PARTY_ID	TCA party Identifier
CALLING_APP_ID	Calling product Identifier
LEGAL_ENTITY_ID	Legal entity Identifier
ORG_ID	Unique internal identifier of the Operating Unit. Validated against HR_OPERATING_UNITS.ORGANIZATION_ID.
ALLOW_REMOVING_DOCUMENT_FLAG	Y or N flag indicating whether this document can be removed from a payment or payment process request.AP is passing this value to Payments but no specific processing is happening based on this flag.
CREATED_BY	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	Standard who column - date when this row was created.
LAST_UPDATED_BY	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_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	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.
CALLING_APP_DOC_UNIQUE_REF1	Source product''s first unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF2	Source product''s second unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF3	Source product''s third unique document payable Identifier
CALLING_APP_DOC_REF_NUMBER	Reference number entered by user of the source product. Need not be unique
CALLING_APP_DOC_UNIQUE_REF4	Source product''s fourth unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF5	Source product''s fifth unique document payable Identifier
LAST_UPDATE_LOGIN	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.
PARTY_SITE_ID	Party Site identifier Party Site Unique identifier from TCA tables. Validated against HZ_PARTY_SITES.PARTY_SITE_ID.
SUPPLIER_SITE_ID	Supplier site identifier. Validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_ID.
BENEFICIARY_PARTY	Beneficiary party if payment is made through a third party
ORG_TYPE	Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity.
ANTICIPATED_VALUE_DATE	Anticipated value date
PO_NUMBER	Purchase order numbers to which this document is matched. If multiple purchase orders, value is comma delimited
DOCUMENT_DESCRIPTION	Document description
DOCUMENT_CURRENCY_TAX_AMOUNT	Tax amount in document currency
DOCUMENT_PAYABLE_ID	Oracle Payments' unique internal document payable Identifier
DOCUMENT_CURR_CHARGE_AMOUNT	Charge amount in document currency
AMOUNT_WITHHELD	Amount withheld in payment currency
PAYMENT_CURR_DISCOUNT_TAKEN	Discount taken in payment currency
DISCOUNT_DATE	Discount date
PAYMENT_DUE_DATE	Date on which the payment is due.
PAYMENT_PROFILE_ID	Payment process profile Identifier
PAYMENT_ID	Payment Identifier. This field is populated once this document has been grouped into a payment.
FORMATTING_PAYMENT_ID	Formatting payment Identifier. This field identifies the payment stub on which this document's details are printed. This field is populated when the document has been grouped into a payment.
PAYMENT_FUNCTION	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
INTERNAL_BANK_ACCOUNT_ID	Internal bank account Identifier
EXTERNAL_BANK_ACCOUNT_ID	External bank account Identifier
BANK_CHARGE_BEARER	Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
INTEREST_RATE	Interest rate on which this document payable was created if it is an interest invoice
PAYMENT_GROUPING_NUMBER	This attribute is used to link a set of documents payable. All documents payable that have the same payment grouping number are grouped into a single payment.
PAYMENT_REASON_CODE	Payment reason code
PAYMENT_REASON_COMMENTS	Free text field available for entering a reason for the payment
SETTLEMENT_PRIORITY	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	Remittance message for use in payment processing
REMITTANCE_MESSAGE2	Remittance message for use in payment processing
PAYMENT_DATE	Payment date
REMITTANCE_MESSAGE3	Remittance message for use in payment processing
UNIQUE_REMITTANCE_IDENTIFIER	Unique remittance Identifier provided by the payee
URI_CHECK_DIGIT	Unique remittance Identifier check digit
DELIVERY_CHANNEL_CODE	Delivery channel code
PAYMENT_FORMAT_CODE	Payment format code
DOCUMENT_SEQUENCE_ID	Sequential numbering document sequence Identifier
DOCUMENT_SEQUENCE_VALUE	Sequence number of document payable
DOCUMENT_CATEGORY_CODE	Sequential numbering document category
BANK_ASSIGNED_REF_CODE	Payment system-provided reference code for this document
REMIT_TO_LOCATION_ID	Remit-To address Identifier
COMPLETED_PMTS_GROUP_ID	Identifier of a group of payments, which include this document, that were marked complete. The value is from the sequence IBY_COMPLETED_PMTS_GROUP_S.
DOCUMENT_DATE	Date of document
REJECTED_DOCS_GROUP_ID	Identifier of a group of documents payable, including this one, which were rejected together. The value is from the sequence IBY_REJECTED_DOCS_S.
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
DOCUMENT_TYPE	Type of document payable. Values from the IBY_DOCUMENT_TYPES lookup include INVOICE.
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
ADDRESS_SOURCE	Source of the address. Possible values from the lookup IBY_ADDRESS_SOURCE_TYPES include TCA and HR.
EMPLOYEE_ADDRESS_CODE	Type of address. Possible values include HOME and OFFICE.
EMPLOYEE_PERSON_ID	Employee person Identifier
EMPLOYEE_PAYMENT_FLAG	Y or N flag indicating whether the payment is of the employee payment type
EMPLOYEE_ADDRESS_ID	HR Identifier of the address
EXT_INV_PAYEE_ID	This would be same as EXT_PAYEE_ID if there is no third payments agreement for the trading partner on the invoice. If there is a third party payment agreement with any payee for the trading partner, then this is same as the trading partner
INV_PAYEE_PARTY_ID	This would be same as PAYEE_PARTY_ID if there is no third payments agreement for the trading partner on the invoice. If there is a third party payment agreement with any payee for the trading partner, then this is the same as the trading p
INV_PARTY_SITE_ID	This would be same as PARTY_SITE_ID if there is no third payments agreement for the trading partner on the invoice. If there is a third party payment agreement with any payee for the trading partner, then this is the same as the trading pa
INV_SUPPLIER_SITE_ID	This would be same as SUPPLIER_SITE_ID if there is no third payments agreement for the trading partner on the invoice. If there is a third party payment agreement with any payee for the trading partner, then this is same as the trading par
INV_BENEFICIARY_PARTY	This field always displays the same value as BENEFICIARY_PARTY.
RELATIONSHIP_ID	Identifies the relation ship between payee and original trading partner. key from IBY_EXT_PAYEE_RELATIONSHIPS.
DOCUMENT_STATUS	Document status. Values from the lookup IBY_DOCS_PAYABLE_STATUSES include PAYMENT CREATED.
GLOBAL_ATTRIBUTE_CATEGORY	Global Descriptive Flexfield structure defining column.
GLOBAL_ATTRIBUTE1	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE2	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE3	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE4	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE5	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE6	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE7	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE8	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE9	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE10	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE11	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE12	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE13	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE14	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE15	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE16	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE17	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE18	Global Descriptive Flexfield segment.
GLOBAL_ATTRIBUTE19	Global Descriptive Flexfield segment.

Payments - IBY_DOCUMENT_LINES	IBY_DOCUMENT_LINES stores Oracle Payments' representation of individual line items for documents payable, such as invoice lines for an Oracle Payables invoice. This information is passed according to payment format, but is not used to affec
Column Name	Descritpion
DOCUMENT_PAYABLE_LINE_ID	System generated primary key
PO_NUMBER	Purhcase order numbers to which this document line is matched. If multiple purchase orders, value is comma delimited.
LINE_NUMBER	Line number
LINE_TYPE	Line type
LINE_NAME	Line name
LINE_AMOUNT	Line amount in document currency
DESCRIPTION	Line description
UNIT_PRICE	Unit price
QUANTITY	Quantity
UNIT_OF_MEASURE	Unit of measure
DOCUMENT_PAYABLE_ID	Oracle Payments' internal payment document Identifier
CALLING_APP_DOCUMENT_LINE_CODE	Source product''s document line Identifier. Since document line Identifiers may be alphanumeric, even numeric document Identifiers are stored as VARCHAR2.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_EXTERNAL_PAYEES_ALL	"This table contains payment details of an external payee automatically created by the source product. For example when supplier or supplier site is created manually system automatically inserts row in to the IBY_EXTERNAL_PAYEES_ALL table.
Column Name	Descritpion
EXT_PAYEE_ID	Unique internal Identifier for this record. Generated using a database sequence.
OBJECT_VERSION_NUMBER	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.
PARTY_SITE_ID	Party Site identifier Party Site Unique identifier from TCA tables. Validated against HZ_PARTY_SITES.PARTY_SITE_ID.
SUPPLIER_SITE_ID	The supplier site Id for which the payment details are being entered. If the payment details are entered at supplier level, the Party side id is NULL.
ORG_ID	When the payment details are defined for a site, address operating unit, etc., the organization details are updated along with the site id or address operating unit.
ORG_TYPE	Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity.
DEFAULT_PAYMENT_METHOD_CODE	The default payment method at the time defining the Payee. While creating a Payee, default payment method is updated in both iby_external_payees_all and iby_ext_party_pmt_mthds. Later, the changes are update only in IBY_EXT_PARTY_PMT_MTH
ECE_TP_LOCATION_CODE	Trading partner location code for e-Commerce Gateway
BANK_CHARGE_BEARER	This field indicates the bearer of the bank charges. The bank charge bearer values are defined in the lookup IBY_BANK_CHARGE_BEARER. The possible values are Payer, Payee, Shared, etc.
BANK_INSTRUCTION1_CODE	The instructions to the bank can be selected here. There is a separate setup for defining the bank instruction code.
BANK_INSTRUCTION2_CODE	The instructions to the bank can be selected here. There is a separate setup for defining the bank instruction code.
PAYEE_PARTY_ID	TCA party Identifier
BANK_INSTRUCTION_DETAILS	It is a free text field that can be included for additional bank instructions.
PAYMENT_REASON_CODE	There is a separate setup for defining the payment reasons. The values mentioned in the payment details of the supplier setup are defaulted on the invoice workbench.
PAYMENT_REASON_COMMENTS	The Payment reason comments is a free text field. The value mentioned in the payment details of the supplier setup are defaulted on the invoice workbench.
INACTIVE_DATE	Inactive date
PAYMENT_TEXT_MESSAGE1	It is a free text field that can be used payment processing.
PAYMENT_TEXT_MESSAGE2	It is a free text field that can be used payment processing.
PAYMENT_TEXT_MESSAGE3	It is a free text field that can be used payment processing.
DELIVERY_CHANNEL_CODE	There is a separate setup for defining the Delivery Channel codes. The values mentioned in the payment details of the supplier setup are defaulted on the invoice workbench.
PAYMENT_FORMAT_CODE	Payment format attached under the payment specification tab of the suppliers payments details screen.
SETTLEMENT_PRIORITY	Priority with which the financial institution or payment system settles payments for this payee. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY.
REMIT_ADVICE_DELIVERY_METHOD	Default delivery method for the Separate remittance advice report. The value can be set at Payee or payee site level also. If the override with Payee delivery option is checked in the Payment process profile, the setting at the payee and
PAYMENT_FUNCTION	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
REMIT_ADVICE_EMAIL	E-mail address at which the payee wishes to receive remittance advice
REMIT_ADVICE_FAX	Fax number at which the payee wishes to receive remittance advice
EXCLUSIVE_PAYMENT_FLAG	Y or N flag indicating whether each document should be paid alone without grouping with any other document payable.
CREATED_BY	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	Standard who column - date when this row was created.
LAST_UPDATED_BY	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_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	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.

Payments - IBY_GEN_DOCUMENT_LINES	IBY_GEN_DOCUMENT_LINES serves as a template for source product tables or views from which Oracle Payables can import documents payable.
Column Name	Descritpion
CALLING_APP_ID	Source product Identifier
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
LAST_UPDATE_LOGIN	Standard Who column
PO_NUMBER	Purchase order numbers to which this document line is matched. If multiple purchase orders, value is comma delimited.
LINE_NUMBER	Line number
LINE_TYPE	Line type
LINE_NAME	Line name
LINE_AMOUNT	Line amount, in document currency
DESCRIPTION	Line description
CALLING_APP_DOCUMENT_LINE_CODE	Source product''s document line Identifier. Since document line Identifiers may be alphanumeric, even numeric document Identifiers are stored as VARCHAR2.
UNIT_PRICE	Unit price
QUANTITY	Quantity
UNIT_OF_MEASURE	Unit of measure
CALLING_APP_DOC_UNIQUE_REF1	Source product''s first unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF2	Source product''s second unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF3	Source product''s third unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF4	Source product''s fourth unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF5	Source product''s fifth unique document payable Identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Payments - IBY_PAYMENT_RULES	IBY_PAYMENT_RULES stores the header-level information for a payment method defaulting rule. A defaulting rule enables the user to define the default payment method with respect to multiple factors of a transaction context. A defaulting rule
Column Name	Descritpion
PAYMENT_RULE_ID	System generated primary key
OBJECT_VERSION_NUMBER	Object version number
APPLICATION_ID	Application Identifier of the calling product. Although this field is nullable at database level, a value is always be entered.
PAYMENT_RULE_NAME	Rule name
PAYMENT_METHOD_CODE	Payment method Identifier. Although this field is nullable at database level, a value is always be entered.
PAYMENT_RULE_PRIORITY	Rule priority. Smaller number has higher priority.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_PAYMENT_REFERENCES	IBY_PAYMENT_REFERENCES stores the current payment reference number. Payment reference numbers are outward facing identifiers assigned to payments during payment instruction creation.
Column Name	Descritpion
LAST_USED_REF_NUMBER	Last used payment reference number
LAST_AVAILABLE_REF_NUMBER	Last available payment reference number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version Number

Payments - IBY_PAYMENT_REASONS_TL	IBY_PAYMENT_REASONS stores payment reasons that are used as lookup values for payee records or documents payable, that is, invoices. This table is similar to FND_LOOKUPS, but with a new column for territory identification. Products that use
Column Name	Descritpion
PAYMENT_REASON_CODE	User entered primary key
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
LANGUAGE	Language code
SOURCE_LANG	Language code of the record's current language
MEANING	Lookup meaning of payment reasons
DESCRIPTION	Lookup description of payment reason
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Payments - IBY_PAYMENT_REASONS_B	IBY_PAYMENT_REASONS stores payment reasons that are used as lookup values for payee records or documents payable, that is, invoices. This table is similar to FND_LOOKUPS, but with a new column for territory identification. Products that use
Column Name	Descritpion
PAYMENT_REASON_CODE	User entered primary key
INACTIVE_DATE	Inactive date
TERRITORY_CODE	Code of the country where the payment reason code is assigned or used
FORMAT_VALUE	Value required by the payment format that uses this payment reason
SEEDED_FLAG	Y or N flag controlling updatability of records. Y indicates record was seeded by Oracle and may have user updates limited.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number

Payments - IBY_PAYMENTS_H	IBY_PAYMENTS_H table stores historical snapshots of payments. This table contains denormalized versions of payments from specific points in time, including when the payment was submitted to a payment system. Different snapshots of the same
Column Name	Descritpion
PAYMENT_HISTORY_ID	System generated primary key
STOP_RELEASED_FLAG	Y or N flag indicating whether a stop request has been released on this payment
STOP_REQUEST_DATE	Date on which the stop request was placed
STOP_REQUEST_PLACED_BY	User who placed the stop request
STOP_REQUEST_REASON	Reason for placing the stop request
STOP_REQUEST_REFERENCE	Payment system reference code for the stop request
VOIDED_BY	User who voided the payment
VOID_DATE	Date on which the payment was voided
VOID_REASON	Reason for voiding the payment
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
STOP_REQUEST_PLACED_FLAG	Y or N flag indicating whether a stop request has been placed on this payment.
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
CREATED_BY	Standard Who column
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
LAST_UPDATE_LOGIN	Standard Who column
DECLARATION_OPTION	Specifies the customer's chosen declaration option from the payment process profile
DCL_ONLY_FOREIGN_CURR_PMT_FLAG	Yor N flag to specify whether only foreign currency payments or all payments are declared from the payment process profile
PAYMENT_HISTORY_DATE	Payment snapshot date
DECLARATION_REPORT_FORMAT_CODE	Only needed if the DECLARATION_OPTION is set to DECLARE_DIRECT_TO_CENTRAL_BANK from the payment process profile
DECLARATION_CURR_FX_RATE_TYPE	Indicates the type of exchange rate from the payment process profile
DECLARATION_CURRENCY_CODE	Currency of the declaration amount
DECLARATION_THRESHOLD_AMOUNT	From the payment process profile, the threshold amount above which the payment needs to be reported to the central bank
PAYMENT_DETAILS_FORMULA	From the payment process profile, SQL function used to concatenate the document attributes into the payment details information
BANK_INSTRUCTION1_CODE	Code of first bank instruction, from the payment process profile
BANK_INSTRUCTION2_CODE	Code of second bank instruction, from the payment process profile
BANK_INSTRUCTION_DETAILS	Additional bank instruction details from the payment process profile
PAYMENT_TEXT_MESSAGE1	From the payment process profile, text message for use in payment processing.
PAYMENT_TEXT_MESSAGE2	From the payment process profile, text message for use in payment processing.
PAYMENT_INSTRUCTION_HISTORY_ID	Associated payment instruction snapshot Identifier
PAYMENT_SERVICE_REQUEST_ID	Payment process request Identifier
PROCESS_TYPE	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_INSTRUCTION_ID	Payment instruction Identifier
PAYMENT_STATUS	Payment status. Values from the lookup IBY_PAYMENT_STATUSES include CREATED, FORMATTED, and TRANSMITTED.
PAYMENT_FUNCTION	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
PAYMENT_REASON_CODE	Payment reason code
PAYMENT_REASON_COMMENTS	Free text field available for entering a reason for the payment
PAYMENT_DATE	Payment date
ANTICIPATED_VALUE_DATE	Anticipated value date
PAYMENT_AMOUNT	Amount of the payment
PAYMENT_ID	Payment Identifier
PAYMENT_CURRENCY_CODE	Currency of the payment
MATURITY_DATE	Calculated maturity date on a bill payable payment, that is, future dated payment
PAYMENT_DUE_DATE	Date on which the payment is made
DECLARE_PAYMENT_FLAG	Y or N flag that indicates whether this payment needs to be reported to the central bank
DECLARATION_AMOUNT	Sum of all reporting amounts from the documents that constitute this payment. This amount is in the declaration or reporting currency
DISCOUNT_AMOUNT_TAKEN	Discount amount, in payment currency
PAYMENT_DETAILS	Concatenated string that represents the payment details
BANK_CHARGE_BEARER	Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
BANK_CHARGE_AMOUNT	Bank charge amount in the payment currency
DELIVERY_FORMAT_VALUE	Delivery value required by the payment format that uses this delivery channel
PROCESSING_TYPE	Specifies the type of processing from the payment process profile. Values from the lookup IBY_PROCESSING_TYPES include ELECTRONIC and PRINTED.
SETTLEMENT_PRIORITY	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	Remittance message for use in payment processing
REMITTANCE_MESSAGE2	Remittance message for use in payment processing
REMITTANCE_MESSAGE3	Remittance message for use in payment processing
PAPER_DOCUMENT_NUMBER	Payment document number, if a printed payment
BANK_ASSIGNED_REF_CODE	Bank-provided reference code for this payment
INT_BANK_ACCOUNT_NUMBER	Internal bank account number from CE bank accounts
INT_BANK_ACCOUNT_ROUTING_NUM	Internal bank account routing number from CE bank accounts
INT_BANK_ACCOUNT_IBAN_NUMBER	Internal bank account IBAN number from CE bank accounts
EXT_BANK_ACCOUNT_NUMBER	External bank account number from IBY bank accounts
BILL_PAYABLE_FLAG	Y or N flag indicating whether a payment is a bill payable
EXT_BANK_ACCOUNT_ROUTING_NUM	External bank account routing number from CE bank accounts
EXT_BANK_ACCOUNT_BANK_NAME	Internal bank account bank name from IBY bank accounts
EXT_BANK_ACCOUNT_BRANCH_NAME	Internal bank account branch name from IBY bank accounts
EXT_BANK_ACCOUNT_BRANCH_NUMBER	Internal bank account branch number from IBY bank accounts
EXT_BANK_ACCOUNT_IBAN_NUMBER	Internal bank account IBAN number from IBY bank accounts
EXT_BANK_ACCOUNT_SWIFT_CODE	Internal bank account SWIFT code from IBY bank accounts
EXT_PAYEE_ID	External payee Identifier
PAYEE_PARTY_ID	TCA party Identifier
PARTY_SITE_ID	Payee party site Identifier
SUPPLIER_SITE_ID	Supplier site Identifier
EXCLUSIVE_PAYMENT_FLAG	Y or N flag indicating whether this payment is made up of a single document payable that was meant to be paid alone.
BENEFICIARY_PARTY	Beneficiary party if payment is made through a third party
ORG_ID	Organization Identifier
ORG_TYPE	Organization type. Values from the lookup IBY_ORGANIZATION_TYPES nclude Operating Unit, Business Group, and Legal Entity.
ORG_NAME	Organization name from HR organizations
LEGAL_ENTITY_ID	Legal entity Identifier
PARTY_NAME	Name of party from TCA parties
COUNTRY	Country code from the TERRITORY_CODE column in the FND_TERRITORY table from TCA location
ADDRESS1	First line for address from TCA location
ADDRESS2	Second line for address from TCA location
ADDRESS3	Third line for address from TCA location
PAYMENTS_COMPLETE_FLAG	Y or N flag indicating whether the payment has been marked as complete.
ADDRESS4	Fourth line for address from TCA location
CITY	City from TCA location
POSTAL_CODE	Postal code from TCA location
POSTAL_PLUS4_CODE	Four digit extension to the United States Postal ZIP code from TCA location
STATE	State from TCA location
PROVINCE	Province from TCA location
COUNTY	County from TCA location
UNIQUE_REMITTANCE_IDENTIFIER	Unique remittance Identifier provided by the payee
URI_CHECK_DIGIT	Unique remittance Identifier check digit
DOCUMENT_CATEGORY_CODE	Document category code
STOP_CONFIRMED_FLAG	Y or N flag indicating whether a stop has been confirmed on this payment
DOCUMENT_SEQUENCE_ID	Document Sequence ID
DOCUMENT_SEQUENCE_VALUE	Document sequence value
STOP_CONFIRMED_BY	User who confirmed the stop
STOP_CONFIRM_DATE	Date on which the stop was confirmed
STOP_CONFIRM_REASON	Reason for confirming the stop
STOP_CONFIRM_REFERENCE	Payment system reference code for the confirmed stop payment
STOP_RELEASED_BY	User who released the stop request
STOP_RELEASE_DATE	Date on which the stop request was released
STOP_RELEASE_REASON	Reason for releasing the stop request
STOP_RELEASE_REFERENCE	Payment system reference code for releasing or denying the stop request.

Payments - IBY_PAYMENTS_ALL	"This table contains records of the payments which are created by system while processing 'Build payments' program. A payment can be a single check or an electronic fund transfer between first party payer and third party payee. A row in
Column Name	Descritpion
PAYMENT_ID	Unique internal Identifier for this record. Generated using a database sequence.
BILL_PAYABLE_FLAG	Y or N flag indicating whether a payment is a bill payable, that is, a future dated payment
LEGAL_ENTITY_NAME
EXT_BANK_ACCOUNT_NUMBER	Masked payee bank account number, denormalized from CE bank accounts view
EXT_BANK_ACCOUNT_TYPE	Payee bank account type, denormalized from CE bank accounts view
EXT_BANK_ACCOUNT_IBAN_NUMBER	Masked payee bank account IBAN, denormalized from CE bank accounts view
PAYEE_NAME	Name of payee, if provided by administrator
PAYEE_ADDRESS1	First line for payee address, if provided by administrator
PAYEE_ADDRESS2	Second line for payee address, if provided by administrator
PAYEE_ADDRESS3	Third line for payee address, if provided by administrator
PAYEE_ADDRESS4	Fourth line for payee address, if provided by administrator
PAYEE_CITY	Payee city, if provided by administrator
PAYEE_POSTAL_CODE	Payee postal code, if provided by administrator
EXCLUSIVE_PAYMENT_FLAG	Y or N flag indicating whether this payment is made up of a single document payable that was meant to be paid alone
PAYEE_STATE	Payee state, if provided by administrator
PAYEE_PROVINCE	Payee province, if provided by administrator
PAYEE_COUNTY	Payee county, if provided by administrator
PAYEE_COUNTRY	Payee country code, if provided by administrator
REMIT_ADVICE_DELIVERY_METHOD	How the remittance advice, if any, is delivered using values from lookup type IBY_DELIVERY_METHODS
REMIT_ADVICE_EMAIL	E-mail address to which the remittance advice is delivered
REMIT_ADVICE_FAX	Fax number to which the remittance advice is delivered
PAYMENT_PROFILE_SYS_NAME	Denormalized from IBY_SYS_PMT_PROFILES; derive via PAYMENT_PROFILE_ ID
PAYMENT_PROFILE_ACCT_NAME	Denormalized from IBY_ACCT_PMT_PROFILES; derive via PAYMENT_PROFILE_ ID
PAYMENT_PROCESS_REQUEST_NAME	Specifies the name of the Payment process request.
SOURCE_PRODUCT	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	Payment reason format value that is put into the extract for use by the format.
SEPARATE_REMIT_ADVICE_REQ_FLAG	Y or N flag indicating whether a separate remittance advice needs to be generated for a payment.
DECLARATION_EXCH_RATE_TYPE	Exchange rate type used for regulatory reporting.
DECLARATION_FORMAT	Format used for regulatory reporting.
DELIVERY_CHANNEL_FORMAT_VALUE	Delivery channel format value that is put into the extract for use by the format.
BANK_INSTRUCTION1_FORMAT_VALUE	Bank instruction format value that is put into the extract for use by the format.
BANK_INSTRUCTION2_FORMAT_VALUE	Bank instruction format value that is put into the extract for use by the format.
SRA_DELIVERY_METHOD	Separate Remittance Advice delivery method selected. The look up used is IBY_REMIT_ADVICE_SETUP.REMIT_ADVICE_ DELIVERY_METHOD. Possible values are Null, Printed, E-mail, etc.
INT_BANK_NAME	Denormalized from HZ_PARTIES.PARTY_NAME; derived via INTERNAL_BANK_ACCOUNT_ID
INT_BANK_NUMBER	Denormalized from TCA; derived via INTERNAL_BANK_ACCOUNT_ID
INT_EFT_SWIFT_CODE	SWIFT code of the payer's bank
INT_BANK_BRANCH_NAME	Denormalized from TCA; derived via INTERNAL_BANK_ACCOUNT_ID
INT_BANK_BRANCH_NUMBER	Denormalized from TCA; derived via INTERNAL_BANK_ACCOUNT_ID
INT_BANK_ACCOUNT_NAME	Denormalized from CE; derived via INTERNAL_BANK_ACCOUNT_ID
INT_BANK_ACCOUNT_NUMBER	Denormalized from CE; derived via INTERNAL_BANK_ACCOUNT_ID
INT_BANK_ACCOUNT_IBAN	Denormalized from CE; derived via INTERNAL_BANK_ACCOUNT_ID
EXT_BANK_NAME	Denormalized from IBY_EXT_BANK_ACCOUNTS_V. BANK_NAME; derived via EXTERNAL_BANK_ACCOUNT_ID
EXT_EFT_SWIFT_CODE	SWIFT code of the payee's bank
EXT_BANK_BRANCH_NAME	Denormalized from IBY_EXT_BANK_ACCOUNTS_V. BANK_BRANCH_NAME; derived via EXTERNAL_BANK_ACCOUNT_ID
ORG_NAME	Denormalized fromHR_ALL_ORGANIZATION_UNITS.NAME; derived via ORG_ID
PAYER_LEGAL_ENTITY_NAME	Name of the legal entity making the disbursement
INTERNAL_BANK_ACCOUNT_ID	Internal bank account id used for making the payment.
PAYER_LE_REGISTRATION_NUM	Legal registration number of the legal entity making the disbursement
PAYER_TAX_REGISTRATION_NUM	Tax registration number of the legal entity making the disbursement
PAYEE_PARTY_NAME	Denormalized from HZ_PARTIES.PARTY_NAME; derived via PAYEE_PARTY_ID
PAYEE_LE_REGISTRATION_NUM	Legal registration number of the legal entity receiving the disbursement
PARTY_SITE_NAME
PAYEE_TAX_REGISTRATION_NUM	Tax registration number of the legal entity receiving the disbursement
PAYER_PARTY_SITE_NAME	Payer party site name
PAYEE_ADDRESS_CONCAT	Concatenated denormalization from standard address fields HZ_LOCATIONS; derived via PARTY_SITE_ID.
BENEFICIARY_NAME	Denormalized from HZ_PARTIES.PARTY_NAME; derived via BENEFICIARY_PARTY_ID
BENEFICIARY_SITE_NAME
BENEFICIARY_ADDRESS
PAYER_PARTY_NUMBER	Payer party number
PAYEE_PARTY_NUMBER	Payee party number
PAYEE_ALTERNATE_NAME	Payee party alternate name
PAYEE_SITE_ALTERNATE_NAME	Payee party site alternate name
PAYEE_SUPPLIER_NUMBER	Supplier number
PAYEE_FIRST_PARTY_REFERENCE	Payee first party reference
INT_BANK_BRANCH_RFC_IDENTIFIER	Internal bank branch RFC identifier
INT_BANK_ACCT_AGENCY_LOC_CODE	Auditing column for the corresponding value in CE_BANK_ACCOUNTS.AGENCY_LOCATION_CODE
PAYER_ABBREVIATED_AGENCY_CODE	Agency Location Code used by federal agencies
ORG_ID	Unique internal identifier of the Operating Unit. Validated against HR_OPERATING_UNITS.ORGANIZATION_ID.
PAYER_FEDERAL_US_EMPLOYER_ID	Employer identifier used by federal agencies
EXT_BANK_ACCT_OWNER_PARTY_ID	Identifier of the bank branch of the payee
EXT_BANK_ACCT_PMT_FACTOR_FLAG	Identifier of the bank branch of the payee
ADDRESS_SOURCE	Source of the address. Possible values from the lookup IBY_ADDRESS_SOURCE_TYPES include TCA and HR.
EMPLOYEE_ADDRESS_CODE	Type of address. Possible values include HOME and OFFICE.
EMPLOYEE_PERSON_ID	Employee person Identifier
EMPLOYEE_PAYMENT_FLAG	Y or N flag indicating whether the payment is of the employee payment type
EMPLOYEE_ADDRESS_ID	HR Identifier of the address
REQUEST_ID	Concurrent request identifier associated with the current process, used to control updates to processes that are currently active
EXT_BANK_BRANCH_PARTY_ID	Identifier of the bank branch of the payee
EXT_BANK_ALT_NAME	Alternate name of the bank of the payee
EXT_BANK_BRANCH_ALT_NAME	Alternate name of the bank branch of the payee
EXT_BANK_ACCOUNT_ALT_NAME	Alternate name of the bank account of the payee
EXT_BANK_ACCOUNT_NUM_ELEC	Auditing column for the corresponding value in IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELEC
EXT_BANK_BRANCH_LOCATION_ID	Identifier of the address of the bank branch of the payee
EXT_BANK_ACCT_OWNER_PARTY_NAME	Name of the account owner of the payee bank account
ORG_TYPE	Organization type. Values, from the lookup IBY_ORGANIZATION_TYPES Include Operating Unit, Business Group, and Legal Entity
INT_BANK_BRANCH_PARTY_ID	Identifier of the bank branch of the payer
INT_BANK_ALT_NAME	Alternate name of the bank of the payer
INT_BANK_BRANCH_ALT_NAME	Alternate name of the bank branch of the payer
INT_BANK_ACCOUNT_ALT_NAME	Alternate name of the bank account of the payer
INT_BANK_ACCOUNT_NUM_ELEC	Auditing column for the corresponding value in CE_BANK_ACCOUNTS.EFT_USER_NUM
INT_BANK_BRANCH_LOCATION_ID	Identifier of the address of the bank branch of the payer
INT_BANK_BRANCH_EFT_USER_NUM	Auditing column for the corresponding value in CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC
PAYER_PARTY_ID	Payer identifier
PAYER_LOCATION_ID	Payer location Identifier
PAYER_PARTY_ATTR_CATEGORY	Payee party attribute category.
PAYER_LE_ATTR_CATEGORY	Payer party legal entity attribute category
PAYEE_PARTY_ATTR_CATEGORY	Payer party legal entity attribute category
PAYEE_SUPPLIER_ATTR_CATEGORY	Payer party supplier attribute category
PAYEE_SPPLR_SITE_ATTR_CATEGORY	Payee supplier attribute category
PAYEE_SUPPLIER_SITE_NAME	Payee supplier site name.
PAYEE_SUPPLIER_SITE_ALT_NAME	Payee supplier sites alternative name.
PAYEE_SUPPLIER_ID	Supplier identifier
EXT_INV_PAYEE_ID	Payee identifier.
INV_PAYEE_PARTY_ID	Party (trading partner) identifier.
INV_PARTY_SITE_ID	Party site identifier
LEGAL_ENTITY_ID	Legal entity identifier
INV_SUPPLIER_SITE_ID	Supplier site identifier.
INV_BENEFICIARY_PARTY	Beneficiary party
INV_PAYEE_NAME	Name of party (trading partner)
INV_PAYEE_ADDRESS1	First line of party (trading partner) address line 1
INV_PAYEE_ADDRESS2	Second line of party (trading partner) address line 2
INV_PAYEE_ADDRESS3	Third line of party (trading partner) address line 3
INV_PAYEE_ADDRESS4	Fourth line of party (trading partner) address line 4
INV_PAYEE_CITY	Party (trading partner) city.
INV_PAYEE_POSTAL_CODE	Party (trading partner) postal code.
INV_PAYEE_STATE	Party (trading partner) state
INV_PAYEE_PROVINCE	Party (trading partner) province
INV_PAYEE_COUNTY	Party (trading partner) county.
INV_PAYEE_COUNTRY	Party (trading partner) country.
INV_PAYEE_PARTY_NAME	Payee party name.
INV_PAYEE_LE_REG_NUM	Legal registration number of the Party (trading partner)
INV_PAYEE_TAX_REG_NUM	Tax registration number of the Party (trading partner)
INV_PAYEE_ADDRESS_CONCAT	Payee concatenated standard address fields
INV_BENEFICIARY_NAME	Payee party number
INV_PAYEE_PARTY_NUMBER	Party (trading party) number
INV_PAYEE_ALTERNATE_NAME	Party (trading partner) alternate name
DECLARE_PAYMENT_FLAG	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.
INV_PAYEE_SITE_ALT_NAME	Party (trading partner) alternate site name
INV_PAYEE_SUPPLIER_NUMBER	Supplier (Trading Partner) Number.
INV_PAYEE_FIRST_PARTY_REF	Party (trading partner) reference
EXT_BNK_ACCT_OWNR_INV_PRTY_ID	Party (trading partner) .
EXT_BNK_BRANCH_INV_PRTY_ID	Same as inv_payee_party_id
EXT_BNK_ACCT_OWNR_INV_PRTY_NME	Same as inv_payee_party_name
INV_PAYEE_PARTY_ATTR_CAT	Payee party category.
INV_PAYEE_SUPPLIER_ATTR_CAT	Supplier (Trading Partner) attribute category
INV_PAYEE_SPPLR_SITE_ATTR_CAT	Supplier (Trading Partner) site attribute category
INV_PAYEE_SUPPLIER_SITE_NAME	Supplier (Trading Partner) site name
INV_PAYEE_SPPLR_SITE_ALT_NAME	Supplier (Trading Partner) site alternative name
INV_PAYEE_SUPPLIER_ID	Supplier (Trading Partner) identifier
PAYEE_ADDRESSEE
DELIVERY_CHANNEL_CODE	The delivery channel code for the payment. This is updated only when the payment s are grouped by Delivery channel code
EXT_PAYEE_ID	Payee Identifier to which actual payment is made.
PAYMENT_METHOD_CODE	Payment method used for making the payments.
PAYMENT_INSTRUCTION_ID	Payment instruction identifier
BENEFICIARY_SITE_ID
PAYMENT_PROFILE_ID	Payment process profile identifier
PREGROUPED_PAYMENT_FLAG	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 contains a non-null value for the payment grouping number attribute.
STOP_CONFIRMED_FLAG	Y or N flag indicating whether a stop has been confirmed on this payment.
STOP_RELEASED_FLAG	Y or N flag indicating whether a stop request has been released on this payment.
STOP_REQUEST_PLACED_FLAG	Y or N flag indicating whether a stop request has been placed on this payment.
CREATED_BY	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	Standard who column - date when this row was created.
LAST_UPDATED_BY	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	Standard Who column - date when a user last updated this row.
PAYMENT_SERVICE_REQUEST_ID	Payment service request Id and it is the foreign key to the table iby_pay_service_requests.
LAST_UPDATE_DATE	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	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	TCA party identifier
PARTY_SITE_ID	Party Site identifier Party Site Unique identifier from TCA tables. Validated against HZ_PARTY_SITES.PARTY_SITE_ID
SUPPLIER_SITE_ID	Supplier site identifier. Validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_ID.
PAYMENT_REASON_CODE	The payment reason code for the payment. This is updated only when the payment s are grouped by Payment reason code
PAYMENT_REASON_COMMENTS	Free text field available for entering a reason for the payment
PAYMENT_DATE	Payment date
ANTICIPATED_VALUE_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	Sum of all reporting amounts from the documents that constitute this payment. This amount is in the declaration or reporting currency.
PROCESS_TYPE	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.
DECLARATION_CURRENCY_CODE	Currency of the declaration amount
EXT_BIC
DISCOUNT_AMOUNT_TAKEN	Discount amount in payment currency
PAYMENT_DETAILS	Concatenated string as per the Payment details formula provided in the Payment process profile.
BANK_CHARGE_BEARER	Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
BANK_CHARGE_AMOUNT	Bank charge amount in the payment currency
SETTLEMENT_PRIORITY	Settlement Priority would be defined at invoice level. If payments are grouped based on settlement priority, then it would be populated at payment level. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY
REMITTANCE_MESSAGE1	Remittance message for use in payment processing
REMITTANCE_MESSAGE2	Remittance message for use in payment processing
REMITTANCE_MESSAGE3	Remittance message for use in payment processing
PAYMENT_REFERENCE_NUMBER	User and bank facing number identifying the payment
LOGICAL_GROUP_REFERENCE	Indicates the grouping mode - None, Single, Mixed or Grouped.
PAYMENT_STATUS	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.
PAPER_DOCUMENT_NUMBER	Paper document number when it is a printed payment.
BANK_ASSIGNED_REF_CODE	Payment system-provided reference code for this payment
EXTERNAL_BANK_ACCOUNT_ID	External bank account identifier
UNIQUE_REMITTANCE_IDENTIFIER	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	Unique remittance identifier check digit
BANK_INSTRUCTION1_CODE	Code of first bank instruction
BANK_INSTRUCTION2_CODE	Code of second bank instruction
BANK_INSTRUCTION_DETAILS	Additional bank instruction details
PAYMENT_TEXT_MESSAGE1	Text message for use in payment processing
PAYMENT_TEXT_MESSAGE2	Text message for use in payment processing
PAYMENTS_COMPLETE_FLAG	Y or N flag that indicates if the payment is complete
PAYMENT_TEXT_MESSAGE3	Text message for use in payment processing
MATURITY_DATE	Calculated maturity date on a bill payable payment, that is, a future dated payment
PAYMENT_DUE_DATE	Date on which the payment is made. This is populated if grouped by payment due date.
DOCUMENT_CATEGORY_CODE	Sequential Numbering document category
DOCUMENT_SEQUENCE_ID	Sequential Numbering document sequence identifier
DOCUMENT_SEQUENCE_VALUE	Sequence number of document payable
BENEFICIARY_PARTY	Beneficiary party, if payment is made through a third party
STOP_CONFIRMED_BY	The user who confirmed the stop.
STOP_CONFIRM_DATE	Date on which the stop was confirmed.
STOP_CONFIRM_REASON	Reason for confirming the stop.
STOP_CONFIRM_REFERENCE	Payment system reference code for the confirmed stop payment.
PAYMENT_FUNCTION	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
STOP_RELEASED_BY	The user who released the stop request.
STOP_RELEASE_DATE	Date on which the stop request was released.
STOP_RELEASE_REASON	Reason for releasing the stop request.
STOP_RELEASE_REFERENCE	Payment system reference code for releasing or denying the stop request.
STOP_REQUEST_DATE	Date on which the stop request was placed.
STOP_REQUEST_PLACED_BY	The user who placed the stop request.
STOP_REQUEST_REASON	Reason for placing the stop request.
STOP_REQUEST_REFERENCE	Payment system reference code for the stop request.
VOIDED_BY	The user who voided the payment.
VOID_DATE	Date on which the payment was voided.
PAYMENT_AMOUNT	Amount of the payment
VOID_REASON	Reason for voiding the payment.
INT_BIC
REMIT_TO_LOCATION_ID	Remit-To address identifier
COMPLETED_PMTS_GROUP_ID	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.
POSITIVE_PAY_FILE_CREATED_FLAG	Indicates whether the transaction has been included in any of the Positive pay file or not.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
PAYMENT_CURRENCY_CODE	Currency of the payment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
EXT_BRANCH_NUMBER	Payee bank routing number (branch number) of the banks branch.
EXT_BANK_NUMBER	Payee bank number, denormalized from CE bank branches view
EXT_BANK_ACCOUNT_NAME	Payee bank account name, denormalized from CE bank branches view

Payments - IBY_INTERNAL_PAYERS_ALL	IBY_INTERNAL_PAYERS_ALL stores payment-related attributes for the funds disbursement payment process for all first party payers. These attributes control the flow of payments.
Column Name	Descritpion
INT_PAYER_ID	System generated primary key
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
ORG_ID	Organization Identifier
ORG_TYPE	Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity.
BANK_CHARGE_BEARER	Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
PAYMENT_METHOD_AT_PAYEE_FLAG	Stores the Allow Payee Override system option. This is a Y or N flag indicating whether defaults for the payment method attribute can be set at the payee or payee site levels. The defaults at payee or payee site levels override the ones set
PPR_REPORT_FORMAT	Format to be used for the Payment Process Request Status Report. Set in the Disbursement System Options user interface page
AUTOMATIC_PPR_REPORT_SUBMIT	Y or N flag represented by the Automatically Submit at Payment Process Request Completion checkbox on the Disbursement System Options user interface page
DOCUMENT_REJECTION_LEVEL_CODE	Specifies what is rejected if a document payable fails validation. Values from the IBY_DOCUMENT_REJECTION_LEVELS lookup include REQUEST, PAYEE, and DOCUMENT.
PAYMENT_REJECTION_LEVEL_CODE	Specifies how much of a payment process request is rejected if a payment fails validation. Values from the IBY_PAYMENT_REJECTION_LEVELS lookup include REQUEST, PAYMENT, and NONE.
REQUIRE_PROP_PMTS_REVIEW_FLAG	Flag indicating whether Payments should stop the payment creation flow to allow an administrator to review and modify proposed payments before grouping them into payment instructions. Values from the lookup IBY_PROPOSED_PMTS_REVIEW_CODES in
ALLOW_EXT_ACCT_OVERRIDE_FLAG	Y or N flag indicating whether the external bank account can be overridden
EXCLUSIVE_PAYMENT_FLAG	Y or N flag indicating whether each document payable corresponds to one payment. The value in this column is a default for new payees.
SAVE_PAYMENT_FILE_IN_DB	Y or N flag indicating whether Oracle Payments saves a copy of the formatted payment instruction file in the database

Payments - IBY_INSTR_CREATION_RULES	IBY_INSTR_CREATION_RULES specifies how payments are grouped into payment instructions. Payment instructions are always grouped by internal bank account and payment process profile but additional items stored in this table can be added for f
Column Name	Descritpion
SYSTEM_PROFILE_CODE	Unique primary key
GROUP_BY_PAYMENT_CURRENCY	Y or N flag specifying whether payments are grouped into payment instructions by payment currency. If the processing type on the payment process profile is Printed, this flag is automatically set to Y and cannot be overridden.
GROUP_BY_PAYMENT_METHOD	Y or N specifying whether payments are grouped into payment instructions based on payment method
GROUP_BY_INTERNAL_BANK_ACCOUNT	Y or N flag specifying whether payments are grouped into payment instructions by internal bank account. If the processing type on the payment process profile is Printed, this flag is automatically set to Y and cannot be overridden.
GROUP_BY_MAX_PAYMENTS_FLAG	Y or N flag that indicates whether the system limits the number of payments in a payment instruction
GROUP_BY_PAY_SERVICE_REQUEST	Y or N flag specifying whether payments are grouped into payment instructions by payment process request
GROUP_BY_LEGAL_ENTITY	Y or N flag specifying whether payments are grouped into payment instructions by the first party legal entity
GROUP_BY_BILL_PAYABLE	Y or N flag specifying whether payments are grouped into payment instructions based on bill payable flag setting on the payments
GROUP_BY_ORGANIZATION	Y or N flag specifying whether payments are grouped into payment instructions by the first party organization
GROUP_BY_MAX_INSTRUCTION_FLAG	Y or N flag specifying whether there is a limit on the total payment amount when payment instructions are created. This value is set to Y when a value is specified in the MAX_AMOUNT_PER_INSTR_VALUE column.
GROUP_BY_PAYMENT_FUNCTION	Y or N flag specifying whether payments are grouped by the payment function
GROUP_BY_PAYMENT_REASON	Y or N flag specifying whether payments are grouped by the payment reason
GROUP_BY_RFC	Y or N flag specifying whether payments are grouped by the RFC, that is, regional finance center Identifier
MAX_PAYMENTS_PER_INSTRUCTION	Maximum number of payments that can be included in a payment instruction. When a value exists in this column, the Create Payment Instructions program uses it as one of its rules for building payment instructions.
MAX_AMOUNT_PER_INSTR_VALUE	Maximum total amount for which a payment instruction can be created. When a value exists in this column, the Create Payment Instructions program uses it as one of its rules for building payment instructions.
MAX_AMOUNT_PER_INSTR_CURR_CODE	Currency in which the maximum total amount per payment instruction is calculated
MAX_AMOUNT_FX_RATE_TYPE	Exchange rate type used to compare the payment instruction total amount to the maximum total amount allowed. Types are defined in the General Ledger currency exchange rate type lookups table. These include CORPORATE, SPOT, and DAILY.
SORT_OPTION_1	Primary column by which payments in a payment instruction are sorted. Values from the lookup IBY_PAYMENT_SORT_OPTIONS include PAYEE_NAME, PAYEE_NUMBER, and others.
SORT_ORDER_1	Order in which the primary sorting occurs. Values from the lookup IBY_PAYMENT_SORT_ORDERS include ASCENDING and DESCENDING.
SORT_OPTION_2	Second column by which payments in a payment instruction are sorted. Values from the lookup IBY_PAYMENT_SORT_OPTIONS include PAYEE_NAME, PAYEE_NUMBER, and others.
SORT_ORDER_2	Order in which the secondary sorting occurs. Values from the lookup IBY_PAYMENT_SORT_ORDERS include ASCENDING and DESCENDING.
SORT_OPTION_3	Third column by which payments in a payment instruction are sorted. Values from the lookup IBY_PAYMENT_SORT_OPTIONS include PAYEE_NAME, PAYEE_NUMBER, and others.
CREATED_BY	Standard Who column
SORT_ORDER_3	Order in which the tertiary sorting occurs. Values from the lookup IBY_PAYMENT_SORT_ORDERS include ASCENDING and DESCENDING.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
GROUP_BY_PAYMENT_DATE	Y or N flag specifying whether payments are grouped into payment instructions by payment date

Payments - IBY_INSTRUCT_SOURCE_APPS	IBY_INSTRUCT_SOURCE_APPS stores a list of source products that submitted documents to be paid in each payment instruction.
Column Name	Descritpion
PAYMENT_INSTRUCTION_ID	System generated primary key
CALLING_APP_ID	Source product identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_EXTRACT_ACTIVATIONS	IBY_EXTRACT_ACTIVATIONS defines which computed fields within an extract are unnecessary for a particular format, with each row corresponding to a single field for that extract. When the extract engine is called for a particular format, ever
Column Name	Descritpion
ACTIVATION_ID	System generated primary key
OBJECT_VERSION_NUMBER	Object version number
FORMAT_CODE	Indicates which format is associated with the extract
FIELD_NAME	Name of the field
ACTIVE_FLAG	Y or N to indicate whether the field is active within the format
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_SYS_PMT_PROFILES_TL	IBY_SYS_PMT_PROFILES stores seeded information that specifies the bulk of payment processing behavior. The rest of the behavior is specified in a user-defined account payment process profile stored in IBY_ACCT_PMT_PROFILES. A combination of
Column Name	Descritpion
SYSTEM_PROFILE_CODE	User entered primary key
OBJECT_VERSION_NUMBER	Object version number
SYSTEM_PROFILE_DESCRIPTION	Description of system payment process profile
SYSTEM_PROFILE_NAME	System payment process profile name
LANGUAGE	Language code
SOURCE_LANG	Language code of the record's current language
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_SYS_PMT_PROFILES_B	"This table stores Payment Process Profile setup for Funds Disbursement transactions. This table also stores information of the seeded Payment process profiles. IBY_SYS_PMT_PROFILES_B stores information that specifies the bulk of payment
Column Name	Descritpion
SYSTEM_PROFILE_CODE	The unique Payment Process profile code entered while defining the payment process profile.
DEFAULT_PAYMENT_DOCUMENT_ID	Payment document to be used by default for printing payments.
PERIODIC_SEQUENCE_NAME_1	Name of the sequence. The name is referenced in the payment format templates.
PERIODIC_SEQUENCE_NAME_2	Name of the sequence. The name is referenced in the payment format templates.
PERIODIC_SEQUENCE_NAME_3	Name of the sequence. The name is referenced in the payment format templates.
PROCESSING_TYPE	Specifies the processing type of the payment process profile. Values from IBY_PROCESSING_TYPES lookup are displayed. The values are 'Electronic', 'Printed' and 'Payment Card'.
LOGICAL_GROUPING_MODE	Indicates the grouping mode introduced for the SEPA payments. Values include - None, Single, Mixed or Grouped.
BATCH_BOOKING_FLAG	Indicates the batch booking option introduced for the SEPA payment. The option is Y or N.
MARK_COMPLETE_EVENT	"Event at which payments in a payment instruction are automatically marked complete for processing type 'Electronic'. Values are from the lookup IBY_MARK_COMPLETE_EVENTS. If the processing type is 'Printed', the field 'Payment completion po
MANUAL_MARK_COMPLETE_FLAG	Y or N flag indicating whether the user should manually mark the payment as complete after the instruction is formatted. This is applicable only when the Payment process profiles processing type is 'Electronic'.
POSITIVE_PAY_DELIVERY_FLAG	Y or N flag indicating whether Positive Pay is automatically delivered using the same transmission configuration as the payment instruction.
TRANSMIT_INSTR_IMMED_FLAG	Y or N flag indicating whether an electronic payment instruction should be transmitted immediately after the payment instruction is created. The default value of this flag is N. The value of this flag defaults to the Print Directly After Fo
SEEDED_FLAG	Y or N flag controlling updatability of records. Y indicates record was seeded by Oracle and may have user updates limited.
AUTOMATIC_PI_REG_SUBMIT	Y or N flag indicating whether the concurrent request for generating the payment instruction register is submitted automatically at the payment completion point
CREATED_BY	Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
BEPID	Payment system Id attached to the Payment process profile.
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	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_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	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	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.
DECLARATION_OPTION	Specifies the customer's option for the 'Regulatory reporting'. The declaration options are defined in IBY_CENTRAL_BANK_REPORT_OPTION lookup. They include 'No reporting', 'Report directly to Central bank' and Reporting made by bank'
DCL_ONLY_FOREIGN_CURR_PMT_FLAG	Y or N flag to specify whether only foreign currency payments or all payments are declared. Applicable only when Regulatory reporting (DECLARATION_OPTION) option is set to 'Report Directly to Central bank' or 'Reporting Made by Bank'
DECLARATION_REPORT_FORMAT_CODE	Format of the Regulatory Report. Only needed if the DECLARATION_OPTION is set to DECLARE_DIRECT_TO_CENTRAL_BANK
DECLARATION_CURR_FX_RATE_TYPE	Indicates the type of exchange rate to be used for converting the thresh hold amount to the payment amount currency. Types are defined in the General Ledger currency exchange rate type lookups table. These include SPOT, CORPORATE, and DAILY
DECLARATION_CURRENCY_CODE	The currency of the threshold amount in the process of regulatory reporting.
SECURITY_PROTOCOL_CODE	Security protocol Identifier
DECLARATION_THRESHOLD_AMOUNT	Threshold amount, above which the payment needs to be reported to the central bank
BANK_INSTRUCTION1_CODE	The instructions to the bank can be selected here. There is a separate setup for defining the bank instruction code.
BANK_INSTRUCTION2_CODE	The instructions to the bank can be selected here. There is a separate setup for defining the bank instruction code.
BANK_INSTRUCTION_DETAILS	It is a free text field that can be included for additional bank instructions.
TRANSMIT_PROTOCOL_CODE	Transmission protocol Identifier
PAYMENT_TEXT_MESSAGE1	It is a free text field that can be used payment processing.
PAYMENT_TEXT_MESSAGE2	It is a free text field that can be used payment processing.
INACTIVE_DATE	The date on which the PPP was made inactive.
ACK_TRANSMIT_PROTOCOL_CODE	Transmission protocol Identifier for acknowledgement file
ACK_SECURITY_PROTOCOL_CODE	Security protocol Identifier for acknowledgement file
SEND_TO_FILE_FLAG	Y or N flag indicating whether the payment format output should be 'Send to file' or 'Send to Printer'. Value 'Y' indicates that the formatted output is sent to a file and the payments may be printed outside of Oracle Payments. Value 'N'
PI_REGISTER_FORMAT	The Format attached to the Payment process profile for generating the Payment Instruction Register.
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
PAYMENT_FORMAT_CODE	The Format attached to the Payment process profile for generating the payment instruction.
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
POSITIVE_PAY_FORMAT_CODE	The Format attached to the Payment process profile for generating the Positive pay file.
ATTRIBUTE15	Descriptive Flexfield segment
OUTBOUND_PMT_FILE_DIRECTORY	File directory where output of outbound payment file is stored
OUTBOUND_PMT_FILE_EXTENSION	File extension of outbound payment files
OUTBOUND_PMT_FILE_PREFIX	File name prefix of outbound payment files
POSITIVE_PAY_FILE_DIRECTORY	File directory where output of positive pay file is stored
POSITIVE_PAY_FILE_EXTENSION	File extension of positive pay files
POSITIVE_PAY_FILE_PREFIX	File name prefix of positive pay files
ELECTRONIC_PROCESSING_CHANNEL	Indicates whether payment instruction formatting needs to be from Payments or from e-Commerce Gateway. The values flow from lookup IBY_FD_PPP_PROCESS_CHANNEL. The possible values are 'Oracle payments' and 'Oracle e-Commerce Gateway'
DISALLOW_SAVE_PRINT_FLAG	Indicates whether to allow the payment instruction to be saved and reprinted.
PAY_FILE_LETTER_FORMAT_CODE	The Format attached to the Payment process profile for generating the Payment file accompanying letter.
PRINT_INSTRUCTION_IMMED_FLAG	Y or N flag indicating whether a printed payment instruction should be printed immediately after the payment instruction is created. The value of this flag defaults to the Print Directly After Formatting parameter of the Create Payment In
DEFAULT_PRINTER	Printer to be used by default for printing payments. This is applicable only when the Payment process profiles processing type is 'Printed' and when the option 'Automatically print after formatting' is selected.

Payments - IBY_ACCT_PMT_PROFILES_TL	IBY_ACCT_PMT_PROFILES stores account-related information that completes the specification of the handling of payment instructions. Entries in this table are based on entries in the IBY_SYS_PMT_PROFILES table. A combination of the two tables
Column Name	Descritpion
PAYMENT_PROFILE_ID	System generated primary key
OBJECT_VERSION_NUMBER	Object version number
PAYMENT_PROFILE_NAME	Payment process profile name
LANGUAGE	Language code
SOURCE_LANG	Language code of the record's current language
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_SETUP_TASKS_TL	IBY_SETUP_TASKS stores the status of all Oracle Payments' setup tasks.
Column Name	Descritpion
TASK_CODE	Primary key for setup tasks per language
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.
DESCRIPTION	Description of the task
TASK_NAME	Name of the task
LANGUAGE	Language code
SOURCE_LANG	Language code of the record's current language
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_SETUP_TASKS_B	IBY_SETUP_TASKS stores the status of all Oracle Payments' setup tasks.
Column Name	Descritpion
TASK_CODE	Primary key for setup tasks
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.
STATUS	Lookup Type: IBY_TASK_STATUS
LEAF_NODE_FLAG	Leaf node flag
PARENT_TASK_CODE	Parent task code
DEST_FUNCTION_NAME	FND form function of the task setup page
SETUP_FLOW_CODE	Disbursements / Funds capture
DISPLAY_ORDER	Display order
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Payments - IBY_PAY_INSTRUCTIONS_H	IBY_PAY_INSTRUCTIONS_H stores historical snapshots of payment instructions. This table contains denormalized versions of payment instructions from specific points in time, including when the payment instruction was submitted to a payment sy
Column Name	Descritpion
PAYMENT_INSTRUCTION_HISTORY_ID	Payment instruction identifier
LAST_UPDATE_DATE	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
BEPID	Payment system identifier
PRINT_INSTRUCTION_IMMED_FLAG	Y or N that indicates if the instruction is printed immediately after formatting
TRANSMIT_INSTR_IMMED_FLAG	Y or N flag indicating whether the payment instruction is transmitted immediately after the payment instruction is created.
LAST_UPDATE_LOGIN	Standard Who column
TRANSMIT_CONFIGURATION_ID	Transmission configuration identifier
SECURITY_CONFIGURATION_ID	Security configuration Identifier from the payment process profile
POSITIVE_PAY_FORMAT_CODE	Positive pay format code from the payment process profile
PROCESS_TYPE	Specifies the process by which payments are built into payment instructions. Values from the lookup IBY_PROCESS_TYPES include STANDARD, IMMEDIATE, and MANUAL.
PAYMENT_INSTRUCTION_STATUS	Payment instruction status. Values from the lookup IBY_PAY_INSTRUCTION_STATUSES include CREATED, FORMATTED, and TRANSMITTED.
PAYMENTS_COMPLETE_FLAG	Y or N flag that indicates if the payments are complete
PMT_INSTRUCTION_HISTORY_DATE	Payment instruction date
INT_BANK_ACCOUNT_ROUTING_NUM	Internal bank account routing number from CE bank accounts
INT_BANK_ACCOUNT_NUMBER	Internal bank account number from CE bank accounts
INT_BANK_ACCOUNT_IBAN_NUMBER	Internal bank account IBAN number from CE bank accounts
SEQUENCE_NUMBER	Sequence number assigned to the payment instruction
PAY_ADMIN_ASSIGNED_REF_CODE	Administrator-assigned reference code
PAYMENT_COUNT	Number of payments comprising this instruction
TRANSMISSION_DATE	Date that the payment instruction is sent to the payment system
ACKNOWLEDGEMENT_DATE	Date on which the acknowledgement is received
COMMENTS	User entered notes
REMITTANCE_ADVICE_CREATED_FLAG	Y or N flag indicating whether any separate remittance advice documents were created for a payment instruction. By default this flag is set to N.
PAYMENT_INSTRUCTION_ID	Payment instruction identifier
BANK_ASSIGNED_REF_CODE	Payment system-provided reference code for this payment instruction
LEGAL_ENTITY_ID	Legal entity Identifier
PAYMENT_FUNCTION	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
PRINTER_NAME	Printer name
PAYMENT_REASON_CODE	Payment reason code. This column is populated when Payment Reason is specified as a grouping rule for payment instruction creation.
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
PAYMENT_INSTRUCTION_NAME	Payment instruction name
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
PAYMENT_FORMAT_CODE	Format used for the payment instruction
BILL_PAYABLE_FLAG	Y or N flag indicating whether a payment instruction consists of bills payable
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Payments - IBY_PROCESS_ORGS	Populated by build program - list of all orgs within any given PPR
Column Name	Descritpion
OBJECT_TYPE	Object type
ORG_TYPE	Organization type
ORG_ID	Organization Identifier
OBJECT_ID	Object identifier

Payments - IBY_PROCESS_FUNCTIONS	Populated by build program - list of all functions within any given PPR
Column Name	Descritpion
OBJECT_TYPE	Object type
PAYMENT_FUNCTION	Payment function
OBJECT_ID	Object identifier

Payments - IBY_ACCT_PMT_PROFILES_B	IBY_ACCT_PMT_PROFILES stores account-related information that completes the specification of the handling of payment instructions. Entries in this table are based on entries in the IBY_SYS_PMT_PROFILES table. A combination of the two tables
Column Name	Descritpion
PAYMENT_PROFILE_ID	System generated primary key
SECURITY_CONFIGURATION_ID	Security configuration Identifier
TRANSMIT_CONFIGURATION_ID	Transmission configuration Identifier
RESET_VALUE_1	Value to which the first sequence is reset
LAST_USED_NUMBER_1	Last number that was used by the first sequence
RESET_REQUEST_1	Identifier of the concurrent request used to reset the first sequence
RESET_VALUE_2	Value to which the second sequence is reset
LAST_USED_NUMBER_2	Last number that was used by the second sequence
RESET_REQUEST_2	Identifier of the concurrent request used to reset the second sequence
RESET_VALUE_3	Value to which the third sequence is reset
LAST_USED_NUMBER_3	Last number that was used by the third sequence
SYSTEM_PROFILE_CODE	System payment process profile Identifier
RESET_REQUEST_3	Identifier of the concurrent request used to reset the third sequence
INACTIVE_DATE	Inactive date
ACK_SEC_CONFIG_ID	Security configuration Identifier for acknowledgement file
ACK_TRANSMIT_CONFIG_ID	Transmission configuration Identifier for acknowledgement file
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
BEP_ACCOUNT_ID	Payment system account Identifier

Payments - IBY_TRANSACTION_ERRORS	IBY_TRANSACTION_ERRORS stores any errors encountered during payment processing validations.
Column Name	Descritpion
TRANSACTION_ERROR_ID	System generated primary key
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
LAST_UPDATE_LOGIN	Standard Who column
CALLING_APP_ID	Source product Identifier
PAY_PROC_TRXN_TYPE_CODE	Payment processing transaction type striped by application
CALLING_APP_DOC_UNIQUE_REF2	Source product''s second unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF3	Source product''s third unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF4	Source product''s fourth unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF5	Source product''s fifth unique document payable Identifier
TRANSACTION_TYPE	Transaction type. Values from the lookup IBY_TRANSACTION_TYPES include DOCUMENT_PAYABLE, PAYMENT, and PAYMENT_INSTRUCTION.
ERROR_TYPE	Type of error. Values from the lookup IBY_TRANSACTION_ERROR_TYPES include VALIDATION and BANK.
ERROR_MESSAGE	Error message for failed transaction. If ERROR_TYPE is BANK, this is a bank-specific error code.
VALIDATION_SET_CODE	Identifier of the validation set that was violated if ERROR_TYPE is VALIDATION.
PASS_DATE	Date on which the validation set that gave rise to this error was passed. This column is not be populated if the DO_NOT_APPLY_ERROR_FLAG is Y.
OVERRIDE_JUSTIFICATION	Justification for overriding validation error. This column is only populated if the DO_NOT_APPLY_ERROR_FLAG is Y.
OVERRIDE_DATE	Date on which the error was overridden. This column is only populated if the DO_NOT_APPLY_ERROR_FLAG is Y.
TRANSACTION_ID	Transaction Identifier
ERROR_CODE	Error code for failed transaction. If ERROR_TYPE is BANK, this is a bank-specific error code.
ERROR_DATE	Date on which the error occurred
ERROR_STATUS	Whether the error is still active, that is, the error still applies, passed, or overridden. Values from the lookup IBY_TRANSACTION_ERROR_STATUSES include ACTIVE, PASSED, and OVERRIDDEN. The last two values only apply to validation errors.
CALLING_APP_DOC_UNIQUE_REF1	Source product''s first unique document payable Identifier
OVERRIDE_ALLOWED_ON_ERROR_FLAG	Y or N flag specifying whether this validation error can be overridden by the payment administrator. Some validation errors are fatal and the condition causing the error must be corrected so the payment instruction can be validated successf
DO_NOT_APPLY_ERROR_FLAG	Y or N flag which only applies to errors on payment instructions. The value is N by default and only changes to Y if an administrator overrides the error. When a payment instruction is resubmitted to the Create Payment Instructions program

Payments - IBY_RULE_CONDITIONS	IBY_RULE_CONDITIONS stores the detail-level information for a payment method defaulting rule. Each row in the IBY_PAYMENT_RULES table has one or more rows in this table. Conditions of different types are combined with the AND logical operat
Column Name	Descritpion
RULE_CONDITION_ID	System generated primary key
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
PAYMENT_RULE_ID	Rule header Identifier
RULE_CONDITION_TYPE_CODE	Rule condition type. Each type corresponds to one driver parameter for payment method defaulting. Lookup values of IBY_PMT_MTHD_DEFAULTING_CONDITION lookup type
OPERATOR_CODE	Rule condition operator. Lookup codes, such as EQ, GT, LE, and others, which are defined by the IBY_PMT_MTHD_DEFAULTING_OPS lookup type. Applicable operators vary depending on the condition type.
RULE_CONDITION_VALUE	Rule condition value
STRING_VALUE_FLAG	Y if the value is a string. Otherwise it is treated as a number.
RULE_CONDITION_ENTRY_SEQUENCE	Number that denotes the order in which the user has entered the conditions. When queried, it needs to be displayed in the same order that the user has entered the rule condition.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Payments - IBY_REMIT_ADVICE_SETUP	IBY_REMIT_ADVICE_SETUP stores information on creating and delivering remittance information, or remittance advice, for a payee separately from the payment itself. Remittance advice setup is organized by payment process profile. Each payment
Column Name	Descritpion
SYSTEM_PROFILE_CODE	Unique primary key
OBJECT_VERSION_NUMBER	Object version number
REMITTANCE_ADVICE_FORMAT_CODE	Remittance format code
SRA_OVERRIDE_PAYEE_FLAG	Y or N flag indicating whether the delivery method preference in the payment process profile overrides the setting at the payee level. Y to override, N otherwise.
REMIT_ADVICE_DELIVERY_METHOD	Remittance advice delivery method. Values from the lookup IBY_DELIVERY_METHODS include EMAIL, FAX, and PRINTED.
AUTOMATIC_SRA_SUBMIT_FLAG	Y or N flag indicating whether the remittance advice should be submitted automatically at payment completion point.
DOCUMENT_COUNT_LIMIT	This number acts as a rule for inclusion of a payment in a remittance advice. If the number of documents within a payment exceeds this number, then the payment is included in a remittance advice.
ALLOW_MULTIPLE_COPY_FLAG	Y or N flag indicating whether multiple copies of the remittance advice can be created for a payment instruction
SEEDED_FLAG	Y or N flag controlling updatability of records. Y indicates record was seeded by Oracle and may have user updates limited.
PAYMENT_DETAILS_LENGTH_LIMIT	Maximum length of the payment detail record. Typically this is a type of description record in a payment format that allows concatenated details of the payment to be included, for example, invoices paid. If the length is exceeded, then the
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_PMT_CREATION_RULES	IBY_PMT_CREATION_RULES specifies how documents payable are grouped into payments. Creation rules are determined by payment process profiles. This table corresponds to the Payment Creation tab of the Update Payment Process Profile page.
Column Name	Descritpion
SYSTEM_PROFILE_CODE	Unique primary key
GROUP_BY_DELIVERY_CHANNEL	Y or N flag specifying whether documents payable are grouped by delivery channel
GROUP_BY_REMITTANCE_MESSAGE	Y or N flag specifying whether documents payable are grouped by remittance message
GROUP_BY_MAX_DOCUMENTS_FLAG	Y or N flag specifying whether there is a limit on how many documents can be grouped into a payment
GROUP_BY_UNIQUE_REMIT_ID_FLAG	Y or N flag specifying whether documents with unique remittance Identifiers are paid alone
GROUP_BY_SETTLE_PRIORITY_FLAG	Y or N flag specifying whether documents payable are grouped by the settlement priority value
GROUP_BY_PAYMENT_REASON	Y or N flag specifying whether documents payable are grouped by the payment reason
GROUP_BY_DUE_DATE_FLAG	Y or N flag specifying whether documents payable are grouped into payments by due date
MAX_DOCUMENTS_PER_PAYMENT	Maximum number of documents that can be grouped into a single payment. This value will only be used if GROUP_BY_MAX_DOCUMENTS_FLAG is set to Y.
PAYMENT_DETAILS_LENGTH_LIMIT	Maximum length of the payment detail record. Typically, this is a type of description record in a payment format that allows concatenated details of the payment to be included, for example, invoice numbers. If this length is exceeded, then
CREATED_BY	Standard Who column
PAYMENT_DETAILS_FORMULA	SQL function to be used to concatenate the document attributes into the payment details information
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
GROUP_BY_PAYMENT_DETAILS_FLAG	Y or N flag specifying whether documents payable are grouped by the length of the payment detail record
GROUP_BY_BANK_CHARGE_BEARER	Y or N flag specifying whether documents payable are grouped by the bank charge bearer

Payments - IBY_PAY_SERVICE_REQUESTS	"This table contains records of the payment process requests which are created by system while processing 'Build payments' program.IBY_PAY_SERVICE_REQUESTS stores payment process requests from source products. A payment process request is
Column Name	Descritpion
PAYMENT_SERVICE_REQUEST_ID	System generated primary key
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	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.
LAST_UPDATE_LOGIN	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.
INTERNAL_BANK_ACCOUNT_ID	Internal bank account identifier
PAYMENT_PROFILE_ID	Payment process profile Identifier. This is mandatory if COMPLETE_INSTRUCTION_FLAG is Y.
MAXIMUM_PAYMENT_AMOUNT	Maximum payment amount used to override default maximum payment amount
MINIMUM_PAYMENT_AMOUNT	Minimum payment amount used to override default minimum payment amount
DOCUMENT_REJECTION_LEVEL_CODE	Specifies what is rejected if a document payable fails validation. Values from the IBY_DOCUMENT_REJECTION_LEVELS lookup include REQUEST, PAYEE, and DOCUMENT.
PAYMENT_REJECTION_LEVEL_CODE	Specifies how much of a payment process request is rejected if a payment fails validation. Values from the IBY_PAYMENT_REJECTION_LEVELS lookup include REQUEST, PAYMENT, and NONE.
REQUIRE_PROP_PMTS_REVIEW_FLAG	Flag indicating whether Oracle Payments should stop the payment creation flow to allow an administrator to review and modify proposed payments before grouping them into payment instructions. Values from the lookup IBY_PROPOSED_PMTS_REVIEW_C
CALLING_APP_ID	Source product Identifier
ORG_TYPE	Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity.
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
CALL_APP_PAY_SERVICE_REQ_CODE	Source product's payment process request Identifier. Since the source product''s Identifiers may be alphanumeric, even numeric document Identifiers are stored as VARCHAR2.
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
CREATE_PMT_INSTRUCTIONS_FLAG	Flag indicating whether the Build Payments program automatically kicks off the Create Payment Instructions program after payment build completes.
PAYMENT_DOCUMENT_ID	Stores the payment document Identifier on which the payment instructions created from the payments of this request are printed. This parameter is only applicable where the Build Payments program kicks off the Create Payment Instructions pr
REQUEST_ID	Concurrent request identifier associated with the current process, used to control updates to processes that are currently active
PAYMENT_SERVICE_REQUEST_STATUS	Payment process request status. Values from the lookup IBY_REQUEST_STATUSES include PAYMENTS_CREATED.
PROCESS_TYPE	Specifies the process by which documents payable are built into payments and payments into payment instructions. Values from the lookup IBY_PROCESS_TYPES include STANDARD, IMMEDIATE, and MANUAL.
ALLOW_ZERO_PAYMENTS_FLAG	Y or N flag that indicates whether zero payments are allowed for this payment request. If set to N, any zero value payments created for this payment request is failed.
CREATED_BY	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	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.

Payments - IBY_PAY_INSTRUCTIONS_ALL	"This table contains records of the payment instructions. Instructions are created based on the Payment Process Request options. Data is inserted in to the table IBY_PAY_INSTRUCTIONS_AL after payment instruction creation, based on the opt
Column Name	Descritpion
PAYMENT_INSTRUCTION_ID	Unique internal Identifier for this record. Generated using a database sequence.
LEGAL_ENTITY_ID	Legal entity Identifier of the payment instruction. This column is populated only when first party legal entity is specified as a grouping rule for payment instruction creation.
PAYMENT_COUNT	Number of payments comprising this instruction
POSITIVE_PAY_FILE_CREATED_FLAG	Indicates whether a positive pay file has been created for a payment instruction
PRINT_INSTRUCTION_IMMED_FLAG	Y or N flag indicating whether the payment instruction is printed immediately after the payment instruction is created. Applicable when the processing type is 'Printed'.
TRANSMIT_INSTR_IMMED_FLAG	Y or N flag indicating whether the payment instruction is transmitted immediately after the payment instruction is created. Applicable when the processing type is 'Electronic'.
CREATED_BY	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	Standard who column - date when this row was created.
LAST_UPDATED_BY	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_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	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	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.
INTERNAL_BANK_ACCOUNT_ID	Internal bank account Identifier of the payment instruction. This column is populated only when internal bank account is specified as a grouping rule for payment instruction creation. This column is always populated for printed payment inst
PAY_ADMIN_ASSIGNED_REF_CODE	Administrator assigned reference code
PAYMENT_PROFILE_ID	Payment process profile Identifier
TRANSMISSION_DATE	Date that the payment instruction is sent to the bank
ACKNOWLEDGEMENT_DATE	Date on which the acknowledgement is received
COMMENTS	Comments entered while submitting following concurrent requests: -> ""Create Electronic Payment Instructions"" -> ""Create Printed Payment Instructions"""
BANK_ASSIGNED_REF_CODE	Payment system-provided reference code for this payment instruction
ORG_ID	Organization Identifier of the payment instruction. This column is populated only when first party organization is specified as a grouping rule for payment instruction creation.
ORG_TYPE	Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity.
PAYMENT_DATE	Payment date of the payment instruction. This column is populated only when payment date is specified as a grouping rule for payment instruction creation.
PAYMENT_CURRENCY_CODE	Currency of the payment instruction. This column is populated only when payment currency is specified as a grouping rule for payment instruction creation. This column is always populated for printed payment instructions, as they are require
PAYMENT_METHOD_CODE	Indicates the payment method code when the instruction is grouped by payment method.
PAYMENT_SERVICE_REQUEST_ID	Identifier of the payment process request which had its payments grouped into the payment instruction. This column is populated when payment process request is specified as a grouping rule for payment instruction creation.
PAYMENT_FUNCTION	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
PROCESS_TYPE	Specifies the process by which payments are built into payment instructions. Values from the lookup IBY_PROCESS_TYPES include STANDARD, IMMEDIATE, and MANUAL.
PAYMENT_REASON_CODE	Payment reason code. This column is populated when Payment Reason is specified as a grouping rule for payment instruction creation.
RFC_IDENTIFIER	Identifier of the regional finance center at the bank branch level pertaining to the payments in the instruction. This column is populated when RFC is specified as a grouping rule for payment instruction creation.
PAYMENT_REASON_COMMENTS	Free text describing a reason for the payments in the instruction. This column is populated when Payment Reason is specified as a grouping rule for payment instruction creation.
PAYMENT_DOCUMENT_ID	Payment document that was passed to the payment instruction creation program, if it is different from the default in the payment process profile
PRINTER_NAME	Automatically print after formatting' is selected, it is mandatory to provide the default printer.
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
PAYMENT_INSTRUCTION_STATUS	Payment instruction status. Values from the lookup IBY_PAY_INSTRUCTION_STATUSES include CREATED, FORMATTED, and TRANSMITTED.
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
REFERENCE_FORMAT_CODE	Reference format code
REQUEST_ID	Concurrent request identifier associated with the current process, used to control updates to processes that are currently active
PAYMENTS_COMPLETE_CODE	Code indicating whether payments in the payment instruction have been marked as complete. Values from the lookup IBY_PAYMENTS_COMPLETE include YES, NO, and PARTIAL.
GENERATE_SEP_REMIT_ADVICE_FLAG	Y or N flag indicating whether a separate remittance advice needs to be created for a payment instruction. If the flag is set to Y, then at least one payment within the payment instruction requires a separate remittance advice.
REMITTANCE_ADVICE_CREATED_FLAG	Indicates whether any separate remittance advice documents were created for a payment instruction. By default this flag is set to N.
REGULATORY_REPORT_CREATED_FLAG	Indicates whether a regulatory report, for example, for central bank reporting, has been created for a payment instruction
BILL_PAYABLE_FLAG	Y or N flag indicating whether a payment instruction consists of bills payable

Payments - IBY_GEN_DOCS_PAYABLE	IBY_GEN_DOCS_PAYABLE serves as a template for source product tables or views from which Oracle Payables can import documents payable.
Column Name	Descritpion
PAY_PROC_TRXN_TYPE_CODE	Type of payment processing transaction or document
PAYMENT_FUNCTION	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
PAYMENT_DATE	Payment date
DOCUMENT_DATE	Date of document
DOCUMENT_TYPE	Type of document payable. Values from the IBY_DOCUMENT_TYPES lookup include INVOICE.
DOCUMENT_CURRENCY_CODE	Document currency code
DOCUMENT_AMOUNT	Total amount in document currency
PAYMENT_CURRENCY_CODE	Payment currency code
PAYMENT_AMOUNT	Amount to be paid in payment currency
PAYMENT_METHOD_CODE	Payment method Identifier
CALLING_APP_ID	Source product Identifier
EXCLUSIVE_PAYMENT_FLAG	Y or N flag indicating whether this document payable corresponds to one payment.
PAYEE_PARTY_ID	TCA party Identifier
PARTY_SITE_ID	Payee party site Identifier
SUPPLIER_SITE_ID	Supplier site Identifier
BENEFICIARY_PARTY	Beneficiary party, if payment is made through a third party
LEGAL_ENTITY_ID	Legal entity Identifier
ORG_ID	Organization Identifier
ORG_TYPE	Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity.
ALLOW_REMOVING_DOCUMENT_FLAG	Y or N flag indicating whether this document can be removed from a payment or payment process request
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CALLING_APP_DOC_UNIQUE_REF1	Source product's first unique document payable Identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
ANTICIPATED_VALUE_DATE	Anticipated value date
PO_NUMBER	Purchase order numbers to which this document is matched. If multiple purchase orders, value is comma delimited.
DOCUMENT_DESCRIPTION	Document description
DOCUMENT_CURRENCY_TAX_AMOUNT	Tax amount in document currency
DOCUMENT_CURR_CHARGE_AMOUNT	Charge amount in document currency
AMOUNT_WITHHELD	Amount withheld in payment currency
PAYMENT_CURR_DISCOUNT_TAKEN	Discount taken in payment currency
CALLING_APP_DOC_UNIQUE_REF2	Source product's second unique document payable Identifier
DISCOUNT_DATE	Discount date
PAYMENT_DUE_DATE	Date on which the payment is made
PAYMENT_PROFILE_ID	Payment process profile Identifier
INTERNAL_BANK_ACCOUNT_ID	Internal bank account Identifier
EXTERNAL_BANK_ACCOUNT_ID	External bank account Identifier
BANK_CHARGE_BEARER	Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
INTEREST_RATE	Interest rate based on which this document payable was created if it is an interest invoice
PAYMENT_GROUPING_NUMBER	This attribute is used to link a set of documents payable. All documents payable that have the same payment grouping number are grouped into a single payment.
PAYMENT_REASON_CODE	Payment reason code
PAYMENT_REASON_COMMENTS	Free text field available for entering a reason for the payment
CALLING_APP_DOC_UNIQUE_REF3	Source product's third unique document payable Identifier
SETTLEMENT_PRIORITY	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	Remittance message for use in payment processing
REMITTANCE_MESSAGE2	Remittance message for use in payment processing
REMITTANCE_MESSAGE3	Remittance message for use in payment processing
UNIQUE_REMITTANCE_IDENTIFIER	Unique remittance Identifier provided by the payee
URI_CHECK_DIGIT	Unique remittance Identifier check digit
DELIVERY_CHANNEL_CODE	Delivery channel code
PAYMENT_FORMAT_CODE	Payment format code
DOCUMENT_SEQUENCE_ID	Sequential numbering document sequence Identifier
DOCUMENT_SEQUENCE_VALUE	Sequence number of document payable
CALLING_APP_DOC_UNIQUE_REF4	Source product's fourth unique document payable Identifier
DOCUMENT_CATEGORY_CODE	Sequential numbering document category
BANK_ASSIGNED_REF_CODE	Payment system-provided reference code for this document
REMIT_TO_LOCATION_ID	Remit-To address Identifier
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
CALLING_APP_DOC_UNIQUE_REF5	Calling application's fifth unique document payable identifier
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
ADDRESS_SOURCE	Source of the address. Possible values from the lookup IBY_ADDRESS_SOURCE_TYPES include TCA and HR.
EMPLOYEE_ADDRESS_CODE	Type of address. Possible values include HOME and OFFICE.
CALLING_APP_DOC_REF_NUMBER	Reference number entered by user of the source product. Need not be unique
EMPLOYEE_PERSON_ID	Employee person Identifier
EMPLOYEE_PAYMENT_FLAG	Y or N flag indicating whether the payment is of the employee payment type.
EMPLOYEE_ADDRESS_ID	HR Identifier of the address
CALL_APP_PAY_SERVICE_REQ_CODE	Source product''s payment process request identifier. Since the source product''s Identifiers may be alphanumeric, even numeric document Identifiers are stored as VARCHAR2.

Payments - IBY_DOCUMENT_LINES_H	IBY_DOCUMENT_LINES_H stores historical snapshots of document line items. This table contains denormalized versions of document lines from specific points in time, including when the payment for the associated document was submitted to a pay
Column Name	Descritpion
DOCUMENT_LINE_HISTORY_ID	System generated primary key
LAST_UPDATE_DATE	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
LAST_UPDATE_LOGIN	Standard Who column
PO_NUMBER	Purchase order numbers to which this document line is matched. If multiple purchase orders, value is comma delimited.
LINE_NUMBER	Line number
LINE_TYPE	Line type
LINE_NAME	Line name
LINE_AMOUNT	Line amount, in document currency
DESCRIPTION	Line description
UNIT_PRICE	Unit price
DOCUMENT_LINE_HISTORY_DATE	Document line snapshot date
QUANTITY	Quantity
UNIT_OF_MEASURE	Unit of measure
DOCUMENT_PAYABLE_HISTORY_ID	Document payable snapshot with which this line is associated
DOCUMENT_PAYABLE_LINE_ID	Oracle Payments' internal payment document line Identifier
DOCUMENT_PAYABLE_ID	Oracle Payments' internal payment document Identifier
CALLING_APP_DOCUMENT_LINE_CODE	Source product''s document line Identifier. Since document line Identifiers may be alphanumeric, even numeric document Identifiers are stored as VARCHAR2.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Payments - IBY_DOCUMENTS_PAYABLE_H	IBY_DOCUMENTS_PAYABLE_H stores historical snapshots of documents payable. This table contains denormalized versions of documents payable from specific points in time, such as when the payment for this document was submitted to a payment sys
Column Name	Descritpion
DOCUMENT_PAYABLE_HISTORY_ID	System generated primary key
CALLING_APP_DOC_UNIQUE_REF5	Source product''s fifth unique document payable Identifier
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
CALLING_APP_DOC_REF_NUMBER	Reference number entered by user of the source product. Need not be unique
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
LAST_UPDATE_LOGIN	Standard Who column
STRAIGHT_THROUGH_FLAG	Y or N flag indicating whether the document payable has been processed without unexpected manual intervention
PO_NUMBER	Purchase order numbers to which this document is matched. If multiple purchase orders, value is comma delimited.
DOCUMENT_PAYABLE_ID	Oracle Payments' unique internal document payable Identifier
DOCUMENT_PAYABLE_HISTORY_DATE	Document payable snapshot date
PAYMENT_FUNCTION	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
DOCUMENT_DATE	Date of document
DOCUMENT_TYPE	Type of document payable. Values from the IBY_DOCUMENT_TYPES lookup include INVOICE.
DOCUMENT_DESCRIPTION	Document description
DOCUMENT_STATUS	Document status. Values from the lookup IBY_DOCS_PAYABLE_STATUSES include PAYMENT CREATED.
DOCUMENT_AMOUNT	Total document amount
DOCUMENT_CURRENCY_CODE	Document currency code
DOC_CURRENCY_PAYMENT_AMOUNT	Amount to be paid in document currency
DOCUMENT_CURRENCY_TAX_AMOUNT	Tax amount in document currency
DOCUMENT_CURR_CHARGE_AMOUNT	Charge amount in document currency
PAYMENT_HISTORY_ID	Associated payment snapshot Identifier
PAYMENT_AMOUNT	Amount to be paid, in payment currency
PAYMENT_CURRENCY_CODE	Payment currency code
PAYMENT_DUE_DATE	Date on which the payment is made
PAYMENT_CURR_DISCOUNT_TAKEN	Discount taken, in payment currency
DISCOUNT_DATE	Discount date
AMOUNT_WITHHELD	Amount withheld
PAYMENT_SERVICE_REQUEST_ID	Identifier of the payment process request in which this document was submitted.
PAYMENT_METHOD_CODE	Payment method Identifier.
PAYMENT_PROFILE_ID	Payment process profile Identifier
PAYMENT_ID	Identifier of the payment in which this document was paid
PAY_PROC_TRXN_TYPE_CODE	Type of payment processing transaction or document
FORMATTING_PAYMENT_ID	Formatting payment identifier. This field identifies the payment stub on which this document's details are printed. This field is populated when the document has been grouped into a payment.
EXCLUSIVE_PAYMENT_FLAG	Y or N flag indicating whether this document payable corresponds to one payment.
INT_BANK_ACCOUNT_ROUTING_NUM	Internal bank account routing number from CE bank accounts
INT_BANK_ACCOUNT_NUMBER	Internal bank account number from CE bank accounts
INT_BANK_ACCOUNT_IBAN_NUMBER	Internal bank account IBAN number from CE bank accounts
EXT_BANK_ACCOUNT_ROUTING_NUM	External bank account routing number from IBY bank accounts
EXT_BANK_ACCOUNT_NUMBER	External bank account number from IBY bank accounts
EXT_BANK_ACCOUNT_BANK_NAME	Internal bank account bank name from IBY bank accounts
EXT_BANK_ACCOUNT_BRANCH_NAME	Internal bank account branch name from IBY bank accounts
EXT_BANK_ACCOUNT_BRANCH_NUMBER	Internal bank account branch number from IBY bank accounts
CALLING_APP_ID	Source product Identifier
EXT_BANK_ACCOUNT_IBAN_NUMBER	Internal bank account IBAN number from IBY bank accounts
EXT_BANK_ACCOUNT_SWIFT_CODE	Internal bank account SWIFT code from IBY bank accounts
EXT_PAYEE_ID	External payee Identifier
PARTY_SITE_ID	Payee party site Identifier
PAYEE_PARTY_ID	TCA party Identifier
SUPPLIER_SITE_ID	Supplier site Identifier
PARTY_NAME	Name of party from TCA parties
COUNTRY	Country code from the TERRITORY_CODE column in the FND_TERRITORY table from TCA location
ADDRESS1	First line for address from TCA location
ADDRESS2	Second line for address from TCA location
CALLING_APP_DOC_UNIQUE_REF1	Source product''s first unique document payable Identifier
ADDRESS3	Third line for address from TCA location
ADDRESS4	Fourth line for address from TCA location
CITY	City from TCA location
POSTAL_CODE	Postal code from TCA location
POSTAL_PLUS4_CODE	Four digit extension to the United States Postal ZIP code from TCA location
STATE	State from TCA location
PROVINCE	Province from TCA location
COUNTY	County from TCA location
BENEFICIARY_PARTY	Beneficiary party, if payment is made through a third party
ORG_ID	Organization Identifier
CALLING_APP_DOC_UNIQUE_REF2	Source product''s second unique document payable Identifier
ORG_TYPE	Organization type. Values from the lookup IBY_ORGANIZATION_TYPES include Operating Unit, Business Group, and Legal Entity.
LEGAL_ENTITY_ID	Legal entity Identifier
BANK_CHARGE_BEARER	Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.
INTEREST_RATE	Interest rate on which this document payable was created if it is an interest invoice
PAYMENT_GROUPING_NUMBER	Payment grouping number. All documents with the same grouping number are automatically grouped into a single payment. No document in the payment group can be removed from the payment unless the whole payment is removed.
PAYMENT_REASON_FORMAT_VALUE	Payment reason value required by the payment format that uses this payment reason
PAYMENT_REASON_COMMENTS	Free text field available for entering a reason for the payment
SETTLEMENT_PRIORITY	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	Remittance message for use in payment processing
REMITTANCE_MESSAGE2	Remittance message for use in payment processing
CALLING_APP_DOC_UNIQUE_REF3	Source product''s third unique document payable Identifier
REMITTANCE_MESSAGE3	Remittance message for use in payment processing
UNIQUE_REMITTANCE_IDENTIFIER	Unique remittance Identifier provided by the payee
URI_CHECK_DIGIT	Unique remittance Identifier check digit
DELIVERY_FORMAT_VALUE	Delivery value required by the payment format that uses this delivery channel
FORMAT_TEMPLATE_CODE	Payment format code, as defined in the XML Publisher registry
EXTRACT_CODE	Code for the extract version
DOCUMENT_CATEGORY_CODE	Sequential numbering document category
DOCUMENT_SEQUENCE_ID	Sequential numbering document sequence Identifier
DOCUMENT_SEQUENCE_VALUE	Sequence number of document payable
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
CALLING_APP_DOC_UNIQUE_REF4	Source product''s fourth unique document payable Identifier
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment

Payments - IBY_DELIVERY_CHANNELS_TL	IBY_DELIVERY_CHANNELS stores delivery channel information that is used as lookup values for external payee setup or documents payable. The table is similar to FND_LOOKUPS, but with a new column for territory identification. Products that us
Column Name	Descritpion
DELIVERY_CHANNEL_CODE	User entered primary key
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
LANGUAGE	Language code
SOURCE_LANG	Language code of the record's current language
MEANING	Lookup meaning of delivery channel
DESCRIPTION	Lookup description of delivery channel
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Payments - IBY_BANK_INSTRUCTIONS_TL	IBY_BANK_INSTRUCTIONS stores bank instructions that are used as lookup values for payment process profiles and external payee setup. This table corresponds to the Bank Instruction Codes page.
Column Name	Descritpion
BANK_INSTRUCTION_CODE	User entered primary key
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
LANGUAGE	Language code
SOURCE_LANG	Language code of the record's current language
MEANING	Lookup meaning of bank instruction
DESCRIPTION	Lookup description of bank instruction
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Payments - IBY_BANK_INSTRUCTIONS_B	IBY_BANK_INSTRUCTIONS stores bank instructions that are used as lookup values for payment process profiles and external payee setup. This table corresponds to the Bank Instruction Codes page.
Column Name	Descritpion
BANK_INSTRUCTION_CODE	User entered primary key
INACTIVE_DATE	Inactive date
TERRITORY_CODE	Code of the country where the bank instruction code is assigned or used
FORMAT_VALUE	Value required by the payment format that uses this bank instruction
SEEDED_FLAG	Y or N flag controlling updatability of records. Y indicates record was seeded by Oracle and may have user updates limited.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number

Payments - IBY_APPLICABLE_PMT_PROFS	IBY_APPLICABLE_PMT_PROFS maps payment methods to payment process profiles. Since administrators can define both payment methods and payment process profiles, they must also choose which payment process profiles are associated with each paym
Column Name	Descritpion
APPLICABLE_PMT_PROF_ID	System generated primary key
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
SYSTEM_PROFILE_CODE	Unique primary key
APPLICABLE_TYPE_CODE	Applicable type. Each type corresponds to one factor in determining the applicability of a payment process profile. Lookup values of IBY_PMT_PROF_USAGE_RULE_TYPES lookup type
SEEDED_FLAG	Y or N flag controlling updatability of records. Y indicates record was seeded by Oracle and may have user updates limited.
APPLICABLE_VALUE_FROM	From value of the applicability type. Used for the payment amount applicability only
APPLICABLE_VALUE_TO	To value of the applicability type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Payments - IBY_ACCOUNT_OWNERS	This table contains records of the account owners of the external bank accounts entered manually. This table corresponds to the Banking details page of supplier or customer. When an external bank account is created a row will be stored in
Column Name	Descritpion
ACCOUNT_OWNER_ID	Unique internal Identifier for this record. Generated using a database sequence.
LAST_UPDATE_LOGIN	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	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.
EXT_BANK_ACCOUNT_ID	This is the foreign key to the IBY_EXT_BANK_ACCOUNTS table.
ACCOUNT_OWNER_PARTY_ID	This column represents the party id of the account owner or the joint owner of the external bank account.
END_DATE	The date on which the bank account is end dated
PRIMARY_FLAG	Y or N flag indicating whether the party is the primary owner of the bank account
CREATED_BY	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	Standard who column - date when this row was created.
LAST_UPDATED_BY	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_DATE	Standard Who column - date when a user last updated this row.

Payments - IBY_EXT_BANK_ACCOUNTS	"This table contains records of the external bank accounts entered manually. This table corresponds to the Banking details page of supplier or customer. This table contains bank, branch, masking, encryption details of the external bank acc
Column Name	Descritpion
EXT_BANK_ACCOUNT_ID	Unique internal Identifier for this record. Generated using a database sequence.
ACCOUNT_SUFFIX	Account suffix
AGENCY_LOCATION_CODE	Agency location code as entered under the details heading of the bank account setup.
PAYMENT_FACTOR_FLAG	Indicates whether this is a payment factor bank account
FOREIGN_PAYMENT_USE_FLAG	Y or N flag indicating that this bank account can be used for foreign payments
EXCHANGE_RATE_AGREEMENT_NUM	Exchange rate agreement number
EXCHANGE_RATE_AGREEMENT_TYPE	Exchange rate agreement type
EXCHANGE_RATE	Exchange rate
HEDGING_CONTRACT_REFERENCE	Hedging contract reference
SECONDARY_ACCOUNT_REFERENCE	Secondary Account Reference as entered under the details heading of the bank account setup.
BA_NUM_SEC_SEGMENT_ID	Bank Account Number Security Segment ID, used for encryption.
ENCRYPTED	Y or N indicating whether bank account number is encrypted.
IBAN_SEC_SEGMENT_ID	Used for the encryption of the International Bank Account Number.
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
COUNTRY_CODE	Country code of the bank for which the bank accounts is created.
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
BRANCH_ID	Identifier of the bank branch that this bank account belongs to
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
REQUEST_ID	Enhanced Who column. Concurrent Program who column - concurrent request id of the program that last updated this row. Foreign key to the REQUEST_ID column of the FND_CONCURRENT_REQUESTS table..
PROGRAM_APPLICATION_ID	Enhanced Who column. Concurrent Program who column - application id of the program that last updated this row. Foreign key to the APPLICATION_ID column of the FND_APPLICATION table.
PROGRAM_ID	Enhanced Who column. Concurrent Program who column - program id of the program that last updated this row. Foreign key to the CONCURRENT_PROGRAM_ID column of the FND_CONCURRENT_PROGRAM table.
PROGRAM_UPDATE_DATE	Enhanced Who column. Concurrent Program who column - date when a program last updated this row.
START_DATE	Start date
END_DATE	End date
BANK_ID	Identifier of the bank that the bank branch belong to
CREATED_BY	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	Standard who column - date when this row was created.
LAST_UPDATED_BY	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_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	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	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. The situation occurs when the HTML application is an 'stateless' application.
BANK_ACCOUNT_NAME	The name of the bank account.
BANK_ACCOUNT_NAME_ALT	The alternate name of the bank account.
SHORT_ACCT_NAME	The short name of the bank account.
DESCRIPTION	The description regarding the bank account.
BANK_ACCOUNT_NUM	Account number
BANK_ACCOUNT_NUM_ELECTRONIC	The bank account number used in electronic files, if different from the written form
BA_NUM_ELEC_SEC_SEGMENT_ID	Electronically-formatted bank number security segment identifier
BANK_ACCOUNT_NUM_HASH1	Hash1 of the bank account number. Used for the encryption of the bank account number.
BANK_ACCOUNT_NUM_HASH2	Hash2 of the bank account number. Used for the encryption of the bank account number.
MASKED_BANK_ACCOUNT_NUM	The bank account number masked as per the setup. This is used for displaying the bank account number on the UI.
BA_MASK_SETTING	Setup value for the masking of the bank account number. The possible values are - Display Last Digits, Display First Digits and Display None. Value are taken from lookup IBY_PMT_INSTR_MASKING.
BA_UNMASK_LENGTH	The number of digits that can be exposed while displaying the bank account number on the UI or reports.
CURRENCY_CODE	Currency code of the bank account with which the bank account is defined.
IBAN	International Bank Account Number
IBAN_HASH1	IBAN hash1 value. Used for the encryption of the International Bank Account Number.
IBAN_HASH2	IBAN hash2 value. Used for the encryption of the International Bank Account Number.
SALT_VERSION	Denotes the versions of the encryption algorithm used for the Bank account number encryption.
MASKED_IBAN	Masked IBAN value; to be used for display purposes
CHECK_DIGITS	Bank account check digit value as entered.
BANK_ACCOUNT_TYPE	Bank account type (e.g. SAVINGS, CHECKING)
ACCOUNT_CLASSIFICATION	Account classification

Payments - IBY_PMT_MTHD_ATTRIB_APPL	IBY_PMT_MTHD_ATTRIB_APPL stores payment channel or method attribute applicability settings.
Column Name	Descritpion
PAYMENT_FLOW	Determines the source table for the PAYMENT_METHOD_CODE foreign key. Lookup values of IBY_PAYMENT_FLOW lookup type. Values are DISBURSEMENTS, and FUNDS_CAPTURE. If value is DISBURSEMENTS, the PAYMENT_METHOD_CODE comes from IBY_PAYMENT_ME
ATTRIBUTE_CODE	Code for the attribute
ATTRIBUTE_APPLICABILITY	Attribute applicability; value taken from IBY_PMT_ATTRIB_APL_TYPES
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object Version Number
PAYMENT_METHOD_CODE	Payment method identifier

Payments - IBY_CC_ISSUER_RANGES	Table contains card ranges for various credit card issuers. Used to remove structure from a credit card number before it is encrypted.
Column Name	Descritpion
CARD_ISSUER_CODE	The card issuer owning this card range
CARD_NUMBER_PREFIX	Common prefix for all card numbers under this issuer
CARD_NUMBER_LENGTH	Number of digits in the card number
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
OBJECT_VERSION_NUMBER	Object Version Number
CC_ISSUER_RANGE_ID	Primary key for the

Payments - IBY_PMT_INSTR_USES_ALL	"This table contains records of the relationship between payment instruments and Payer/Payee. Data can be entered manually. IBY_PMT_INSTR_USES_ALL table assigns payment instruments to external party payers and payees. This table is shared
Column Name	Descritpion
INSTRUMENT_PAYMENT_USE_ID	Unique internal Identifier for this record. Generated using a database sequence. Sequence used is IBY_PMT_INSTR_USES_ALL_S.nextval
LAST_UPDATED_BY	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_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	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	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.
START_DATE	Date when relationship of payment instrument with payer is started.
END_DATE	Date when relationship of payment instrument with payer is ended.
DEBIT_AUTH_FLAG	Whether authorization was obtained from the account holder for debits against the instrument. Only applicable for bank account instruments
DEBIT_AUTH_METHOD	Method used to obtain debit authorization, with values taken from lookup IBY_EFT_IN_AUTH_METHOD. Only applicable for bank account instruments
DEBIT_AUTH_REFERENCE	Reference code or number given at the time of debit authorization approval. Only applicable for bank account instruments
DEBIT_AUTH_BEGIN	Beginning of debit authorization. Only applicable for bank account instruments
PAYMENT_FLOW	Values from lookup IBY_PAYMENT_FLOW. Possible values can be FUNDS_CAPTURE or DISBURSEMENTS.
DEBIT_AUTH_END	End of debit authorization. Only applicable for bank account instruments
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
EXT_PMT_PARTY_ID	Foreign key to IBY_EXTERNAL_PAYERS_ALL.EXT_PAYER_ID
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
INSTRUMENT_TYPE	CREDITCARD or BANKACCOUNT.
INSTRUMENT_ID	Instrument ID
PAYMENT_FUNCTION	Payment Function. Possible values can be CUSTOMER_PAYMENT or PAYABLES_DISB.
ORDER_OF_PREFERENCE	The priority of the bank account or the credit card as per the setup.
CREATED_BY	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	Standard who column - date when this row was created.

Payments - IBY_FNDCPT_PAYEE_APPL	IBY_FNDCPT_PAYEE_APPL is a mapping table between internal payees and operating units. One payee may be associated with many operating units. An operating unit may be associated with at most one payee.
Column Name	Descritpion
MPAYEEID	Payee primary key
ORG_TYPE	Organization type from lookup type IBY_ORGANIZATION_TYPES
ORG_ID	Organization Identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Used for locking purposes that subsequently allows for checking if there is old data on the screen compared to what is in the database. The situation occurs when the HTML application is a stateless application.

Payments - IBY_RESULT_CODES	Result codes
Column Name	Descritpion
RESULT_CODE	API result code
OBJECT_VERSION_NUMBER	Object version number
REQUEST_INTERFACE_CODE	Code that the public interface result code belongs to
RESULT_CATEGORY	General category of the API result
MESSAGE_NAME	FND message code for the API result
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_INTERMEDIARY_ACCTS	IBY_INTERMEDIARY_ACCTS defines intermediary bank account information.
Column Name	Descritpion
INTERMEDIARY_ACCT_ID	Intermediary Bank Account Identifier
CHECK_DIGITS	Check digits
IBAN	International Bank Account Number
COMMENTS	Comments
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.
BANK_ACCT_ID	Foreign key to IBY_EXT_BANK_ACCOUNTS.EXT_BANK_ACCOUNT_ID. The external bank account that uses the intermediary bank account
INTERNAL_BANK_ACCOUNT_ID	Internal Bank Account Identifier
COUNTRY_CODE	Country code
BANK_NAME	Bank name
CITY	City
BANK_CODE	Bank code
BRANCH_NUMBER	Branch Number
BIC	Bank Identification Code (Swift Code)
ACCOUNT_NUMBER	Bank account number

Payments - IBY_FNDCPT_TX_XE_COPIES	IBY_FNDCPT_TX_XE_COPIES stores the copy relationship between transaction extension entities. This relationship is many-to-many, since during copy transaction extension, entities may be merged or split.
Column Name	Descritpion
SOURCE_TRXN_EXTENSION_ID	Source of the transaction extension
COPY_TRXN_EXTENSION_ID	Copy transaction extension
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.

Payments - IBY_FNDCPT_TX_OPERATIONS	IBY_FNDCPT_TX_OPERATIONS stores associations between transaction extension entities and authorization or settlement transactions.
Column Name	Descritpion
TRXN_EXTENSION_ID	Transaction extension primary key
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.
TRANSACTIONID	Transaction identifier for the series of Payments transaction operations performed

Payments - IBY_CREDITCARD_ISSUERS_TL	Holds the list of accepted card brands
Column Name	Descritpion
CARD_ISSUER_CODE	Card Issuer Code if know. Otherwise UNKNOWN.
LANGUAGE	Language code
SOURCE_LANG	Language code of the record's current language
CARD_ISSUER_NAME	Credit card brand name
DESCRIPTION	Description of the credit card brand
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.

Payments - IBY_EXTERNAL_PAYERS_ALL	"This table contains payment details of an external payer automatically created by the source product. For example when customer or customer site is created manually, system automatically insert row in to the IBY_EXTERNAL_PAYERS_ALL table.
Column Name	Descritpion
EXT_PAYER_ID	Unique internal Identifier for this record. Generated using a database sequence. The sequence used is IBY_EXTERNAL_PAYERS_ALL_S.nextval
CREATED_BY	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	Standard who column - date when this row was created.
LAST_UPDATED_BY	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_DATE	Standard Who Column
LAST_UPDATE_LOGIN	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	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.
DEBIT_ADVICE_DELIVERY_METHOD	Debit notification delivery method option selected. The possible values are Blank, E-mail, Fax and Printed.
DEBIT_ADVICE_EMAIL	When the user selects the Debit notification delivery method as 'E-mail', the email details can be entered in this field.
DEBIT_ADVICE_FAX	When the user selects the Debit notification delivery method as 'Fax', the fax details can be entered in this field.
PAYMENT_FUNCTION	Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include CUSTOMER_PAYMENT and others.
PARTY_ID	TCA party ID
ORG_TYPE	When the payment details are updated for a site, the organization type is also saved along with the site.
ORG_ID	When the payment details are updated for a site, the organization id is also saved along with the site.
CUST_ACCOUNT_ID	Customer account ID
ACCT_SITE_USE_ID	Customer account site use ID
BANK_CHARGE_BEARER_CODE	Bank charge bearer field indicates the bearer of the bank charges. The dropdown box has values Payer, Payee and Shared.
DIRDEB_INSTRUCTION_CODE	Direct debit instruction code

Payments - IBY_FNDCPT_PMT_CHNNLS_B	IBY_FNDCPT_PMT_CHNNLS defines all payment methods for the funds capture flow. Payment methods are categorized by instrument types. The instrument types are BANKACCOUNT, CREDITCARD, and DEBITCARD. Each payment method includes the attribute-
Column Name	Descritpion
PAYMENT_CHANNEL_CODE	User entered primary key
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
INSTRUMENT_TYPE	Instrument type. Values, from the IBY_INSTRUMENT_TYPES lookup, include BANKACCOUNT, CREDITCARD, and DEBITCARD
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.
SEEDED_FLAG	Y or N flag indicating that the data is seeded record
FORMAT_VALUE	Value used in the formatted settlement batch
INACTIVE_DATE	Inactive date
ATTRIBUTE_CATEGORY	Descriptive flexfield category code
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment

Payments - IBY_FNDCPT_TX_EXTENSIONS	"The data in this table will be created by the source products through the public API IBY_FNDCPT_TRXN_PUB, Create_Transaction_Extension and Copy_Transaction_Extension to register a Funds capture transaction. IBY_FNDCPT_TX_EXTENSIONS table
Column Name	Descritpion
TRXN_EXTENSION_ID	Unique internal Identifier for this record. Generated using a database sequence. Sequence used is IBY_FNDCPT_TX_EXTENSIONS_S.nextval
TRXN_REF_NUMBER1	Transaction reference number 1; optional transaction identifier used within the calling application
TRXN_REF_NUMBER2	Transaction reference number 2; optional transaction identifier used within the calling application
ADDITIONAL_INFO	Free-text field for additional information
INSTR_CODE_SEC_SEGMENT_ID	Foreign key to IBY_SECURITY_SEGMENTS.SEC_SEGMENT_ID
ENCRYPTED	Whether the extension is encrypted
PO_LINE_NUMBER	Purchase order line number
ORIGIN_APPLICATION_ID	Originating application id
TANGIBLEID	The tangibleid generated by IBY for the transaction. This column is used by Oracle Payments to link the upgraded transaction extensions with their associated IBY operations.
PAYMENT_CHANNEL_CODE	Payment channel code. Possible values can be CREDIT_CARD, BANK_ACCT_XFER and BILLS_RECEIVABLE.
CREATED_BY	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	Standard who column - date when this row was created.
EXT_PAYER_ID	Foreign key to IBY_EXTERNAL_PAYERS_ALL.EXT_PAYER_ID
LAST_UPDATED_BY	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_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	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	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.
PAYMENT_SYSTEM_ORDER_NUMBER	Payment System Order Number for the transaction.
INSTR_ASSIGNMENT_ID	This column is a foreign key to IBY_PMT_INSTR_USES_ALL.INSTRUMENT_PAYMENT_USE_ID
INSTRUMENT_SECURITY_CODE	Instrument security code. For credit cards this is the 3 or 4-digit security code printed on the card's reverse. Also known as CVVC for MasterCard, CVV2 for Visa, and CID for American Express. This column is encrypted.
INSTR_SEC_CODE_LENGTH	Instrument security code length; used to help in data compression
VOICE_AUTHORIZATION_FLAG	Y or N flag indicating this transaction has a voice authorization
VOICE_AUTHORIZATION_DATE	Voice authorization date
VOICE_AUTHORIZATION_CODE	Voice authorization code
ORDER_ID	Transaction order identifier
PO_NUMBER	Purchase order number

Payments - IBY_FNDCPT_PMT_CHNNLS_TL	IBY_FNDCPT_PMT_CHNNLS defines all payment methods for the funds capture flow. Payment methods are categorized by instrument types. The instrument types are BANKACCOUNT, CREDITCARD, and DEBITCARD. Each payment method includes the attribute-
Column Name	Descritpion
PAYMENT_CHANNEL_CODE	User entered primary key
LANGUAGE	Language code
SOURCE_LANG	Language code of the record's current language
PAYMENT_CHANNEL_NAME	Payment method name
DESCRIPTION	Payment method description
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.

Payments - IBY_CREDITCARD_ISSUERS_B	Holds the list of accepted card brands
Column Name	Descritpion
CARD_ISSUER_CODE	Card Issuer Code if know. Otherwise UNKNOWN.
CARD_ISSUER_ACCEPTED_FLAG	Y or N flag indicating whether the credit card brand is accepted for fund capture.
AUTHORIZATION_VALIDITY_PERIOD	Authorization validity period
DIGIT_CHECK_FLAG	Whether a MOD-10 digit check applies to this issuer's card numbers
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	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. The situation occurs when the HTML application is an 'stateless' application.

Payments - IBY_CREDITCARD_H	Holds historical data for credit cards
Column Name	Descritpion
CARD_HISTORY_CHANGE_ID	Credit card history change identifier
MASKED_CC_NUMBER	Masked credit card number; to be used for display purposes
CARD_OWNER_ID	Owner TCA Party ID
INSTRUMENT_TYPE	CREDITCARD
PURCHASECARD_FLAG	N
PURCHASECARD_SUBTYPE	IBY_PURCHASECARD_SUBTYPE include B (Business Card), C (Corporate Card), P (Purchase Card) and U (Unknown).
CARD_ISSUER_CODE	Card Issuer Code if know. Otherwise UNKNOWN.
SINGLE_USE_FLAG	Y
INFORMATION_ONLY_FLAG	Y or N flag indicating whether the credit card is registered for information use only
CARD_PURPOSE	Purpose of the credit card from lookup type IBY_CARD_PURPOSE
ACTIVE_FLAG	Y
INSTRID	Sequence: IBY_INSTR_S.nextval
INACTIVE_DATE	Inactive date
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
EXPIRYDATE	Expiration date of the card
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
ATTRIBUTE16	Descriptive Flexfield segment
ATTRIBUTE17	Descriptive Flexfield segment
ATTRIBUTE18	Descriptive Flexfield segment
ADDRESSID	Will become a foreign key to HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID instead of HZ_LOCATIONS.LOCATION_ID ; changes to existing customer data will be implemented in an upgrade script
ATTRIBUTE19	Descriptive Flexfield segment
ATTRIBUTE20	Descriptive Flexfield segment
ATTRIBUTE21	Descriptive Flexfield segment
ATTRIBUTE22	Descriptive Flexfield segment
ATTRIBUTE23	Descriptive Flexfield segment
ATTRIBUTE24	Descriptive Flexfield segment
ATTRIBUTE25	Descriptive Flexfield segment
ATTRIBUTE26	Descriptive Flexfield segment
ATTRIBUTE27	Descriptive Flexfield segment
ATTRIBUTE28	Descriptive Flexfield segment
DESCRIPTION	Description of payment instrument
ATTRIBUTE29	Descriptive Flexfield segment
ATTRIBUTE30	Descriptive Flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
CHNAME	Card holder name
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Object version number
EFFECTIVE_START_DATE	Active date
EFFECTIVE_END_DATE	Inactive date
EXPIRY_SEC_SEGMENT_ID	Stores the segment_ID of the encrypted expiry date.
CHNAME_SEC_SEGMENT_ID	Stores the segment_ID of the encrypted cardholder name
FINAME	Financial institution name
SECURITY_GROUP_ID	Used in hosted environments
ENCRYPTED	Flag indicating if the instrument is encrypted

Payments - IBY_BEP_ACCT_OPT_NAME_B
Column Name	Descritpion
ACCOUNT_OPTION_CODE
ACCOUNT_OPTION_DATATYPE
DISPLAY_ORDER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
BEPID

Payments - IBY_BEP_ACCT_OPT_NAME_TL
Column Name	Descritpion
ACCOUNT_OPTION_CODE
LANGUAGE
SOURCE_LANG
ACCOUNT_OPTION_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
BEPID

Payments - IBY_BEP_ACCT_OPT_VALS
Column Name	Descritpion
ACCOUNT_OPTION_CODE
ACCOUNT_OPTION_VALUE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
BEP_ACCOUNT_ID
BEPID

Payments - IBY_EXTRACTS_B	Defines data extracts for payment file creation
Column Name	Descritpion
EXTRACT_CODE
EXTRACT_VERSION
GEN_CODE_LANGUAGE
GEN_CODE_PACKAGE
GEN_CODE_ENTRY_POINT
DATASOURCE_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
EXTRACT_ID

Payments - IBY_FORMATS_TL
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
FORMAT_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
FORMAT_CODE

Payments - IBY_FORMATS_B	Stores payment processing format types
Column Name	Descritpion
FORMAT_TYPE_CODE
ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
FORMAT_TEMPLATE_CODE
OBJECT_VERSION_NUMBER
SEEDED_FLAG
EXTRACT_ID
REFERENCE_FORMAT_CODE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
FORMAT_CODE
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14

Payments - IBY_EXTRACTS_TL
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
EXTRACT_DESC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
EXTRACT_ID

Payments - IBY_PMT_SYS_FORMATS
Column Name	Descritpion
PAYMENT_FORMAT_CODE
INACTIVE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
PAYMENT_SYSTEM_ID

Payments - IBY_FNDCPT_USER_DC_PF_B
Column Name	Descritpion
SYS_DC_PROFILE_CODE
INACTIVE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
BEP_ACCOUNT_ID
ONLINE_DEB_TRANS_CONFIG_ID
SETTLEMENT_TRANS_CONFIG_ID
QUERY_TRANS_CONFIG_ID
USER_DC_PROFILE_CODE

Payments - IBY_FNDCPT_SYS_DC_PF_TL
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
SYS_DC_PROFILE_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
SYS_DC_PROFILE_CODE
DESCRIPTION	Description

Payments - IBY_FNDCPT_SYS_DC_PF_B
Column Name	Descritpion
PAYMENT_SYSTEM_ID
INACTIVE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
SETTLEMENT_COMPLETE_POINT	A point when the settlement is considered complete.
ONLINE_DEB_FORMAT_CODE
OVERRIDE_PAYER_DELIVERY_FLAG	Y or N Flag indicating whether the payer notification delivery method should be overridden by the payer delivery method preference.
PAYER_NOTIFICATION_FORMAT	Payer notification format
PAYER_NOTIFICATION_DEL_METHOD	Payer notification delivery method
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ONLINE_DEB_TRANS_PRTCL_CODE
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ONLINE_DEB_ACK_RDR_CODE
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
SETTLEMENT_REQ_FLAG
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
AUTOMATIC_PN_SUBMIT_FLAG
SETTLEMENT_FORMAT_CODE
SETTLEMENT_TRANS_PRTCL_CODE
SETTLEMENT_ACK_RDR_CODE
QUERY_FORMAT_CODE
QUERY_TRANS_PRTCL_CODE
SYS_DC_PROFILE_CODE
QUERY_ACK_RDR_CODE
GROUP_BY_ORG
GROUP_BY_LEGAL_ENTITY
GROUP_BY_INT_BANK_ACCOUNT
GROUP_BY_SETTLEMENT_CURR
GROUP_BY_SETTLEMENT_DATE
LIMIT_BY_AMT_CURR
LIMIT_BY_EXCH_RATE_TYPE
LIMIT_BY_TOTAL_AMT
LIMIT_BY_SETTLEMENT_NUM

Payments - IBY_FNDCPT_USER_EFT_PF_TL
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
USER_EFT_PROFILE_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
USER_EFT_PROFILE_CODE

Payments - IBY_FNDCPT_USER_EFT_PF_B
Column Name	Descritpion
SYS_EFT_PROFILE_CODE
INACTIVE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
BEP_ACCOUNT_ID
VERIFY_TRANS_CONFIG_ID
FUNDS_XFER_TRANS_CONFIG_ID
QUERY_TRANS_CONFIG_ID
USER_EFT_PROFILE_CODE

Payments - IBY_FNDCPT_USER_CC_PF_TL
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
USER_CC_PROFILE_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
USER_CC_PROFILE_CODE

Payments - IBY_FNDCPT_USER_CC_PF_B
Column Name	Descritpion
SYS_CC_PROFILE_CODE
INACTIVE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
BEP_ACCOUNT_ID
ONLINE_AUTH_TRANS_CONFIG_ID
SETTLEMENT_TRANS_CONFIG_ID
QUERY_TRANS_CONFIG_ID
USER_CC_PROFILE_CODE

Payments - IBY_FNDCPT_SYS_EFT_PF_TL
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
SYS_EFT_PROFILE_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
SYS_EFT_PROFILE_CODE
DESCRIPTION	Description

Payments - IBY_FNDCPT_SYS_EFT_PF_B
Column Name	Descritpion
PAYMENT_SYSTEM_ID
LIMIT_BY_SETTLEMENT_NUM
INACTIVE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
SETTLEMENT_COMPLETE_POINT	A point when the settlement is considered complete.
VERIFY_FORMAT_CODE
OVERRIDE_PAYER_DELIVERY_FLAG	Y or N Flag indicating whether the payer notification delivery method should be overridden by the payer delivery method preference.
PAYER_NOTIFICATION_FORMAT	Payer notification format
PAYER_NOTIFICATION_DEL_METHOD	Payer notification delivery method
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
VERIFY_TRANS_PRTCL_CODE
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
VERIFY_ACK_RDR_CODE
ATTRIBUTE8
ATTRIBUTE9
SETTLE_REQUIRE_VRFY_FLAG
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
FUNDS_XFER_FORMAT_CODE
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ACCOMPANY_LETTER_FORMAT
AUTOMATIC_PN_SUBMIT_FLAG
FUNDS_XFER_TRANS_PRTCL_CODE
FUNDS_XFER_ACK_RDR_CODE
QUERY_FORMAT_CODE
QUERY_TRANS_PRTCL_CODE
QUERY_ACK_RDR_CODE
SYS_EFT_PROFILE_CODE
GROUP_BY_ORG
GROUP_BY_LEGAL_ENTITY
GROUP_BY_INT_BANK_ACCOUNT
GROUP_BY_SETTLEMENT_CURR
GROUP_BY_SETTLEMENT_DATE
LIMIT_BY_AMT_CURR
LIMIT_BY_EXCH_RATE_TYPE
LIMIT_BY_TOTAL_AMT

Payments - IBY_PMT_SYS_TRANSMISSIONS
Column Name	Descritpion
BEPID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
TRANSMIT_PROTOCOL_CODE

Payments - IBY_ACK_READERS
Column Name	Descritpion
READER_CODE_LANGUAGE
READER_CODE_PACKAGE
READER_CODE_ENTRY_POINT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
ACK_READER_CODE

Payments - IBY_FNDCPT_USER_DC_PF_TL
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
USER_DC_PROFILE_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
USER_DC_PROFILE_CODE

Payments - IBY_FNDCPT_SYS_CC_PF_TL
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
SYS_CC_PROFILE_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
SYS_CC_PROFILE_CODE
OBJECT_VERSION_NUMBER
DESCRIPTION	Description

Payments - IBY_FNDCPT_SYS_CC_PF_B
Column Name	Descritpion
INACTIVE_DATE
LIMIT_BY_SETTLEMENT_NUM
CREATED_BY
PAYMENT_SYSTEM_ID
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
SETTLEMENT_COMPLETE_POINT	A point when the settlement is considered complete.
OVERRIDE_PAYER_DELIVERY_FLAG	Y or N Flag indicating whether the payer notification delivery method should be overridden by the payer delivery method preference.
PAYER_NOTIFICATION_FORMAT	Payer notification format
ONLINE_AUTH_FORMAT_CODE
PAYER_NOTIFICATION_DEL_METHOD	Payer notification delivery method
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ONLINE_AUTH_TRANS_PRTCL_CODE
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ONLINE_AUTH_ACK_RDR_CODE
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
SETTLEMENT_FORMAT_CODE
ATTRIBUTE14
ATTRIBUTE15
AUTOMATIC_PN_SUBMIT_FLAG
SETTLEMENT_TRANS_PRTCL_CODE
SETTLEMENT_ACK_RDR_CODE
QUERY_FORMAT_CODE
QUERY_TRANS_PRTCL_CODE
QUERY_ACK_RDR_CODE
SYS_CC_PROFILE_CODE
GROUP_BY_ORG
GROUP_BY_LEGAL_ENTITY
GROUP_BY_INT_BANK_ACCOUNT
GROUP_BY_SETTLEMENT_CURR
GROUP_BY_SETTLEMENT_DATE
LIMIT_BY_AMT_CURR
LIMIT_BY_EXCH_RATE_TYPE
LIMIT_BY_TOTAL_AMT

Payments - IBY_TRANSMIT_CONFIGS_TL
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
TRANSMIT_CONFIGURATION_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
TRANSMIT_CONFIGURATION_ID

Payments - IBY_TRANSMIT_CONFIGS_B
Column Name	Descritpion
TRANSMIT_PROTOCOL_CODE
INACTIVE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
TUNNELING_TRANS_CONFIG_ID
TRANSMIT_CONFIGURATION_ID

Payments - IBY_SYS_SECURITY_SUBKEYS
Column Name	Descritpion
SUBKEY_CIPHER_TEXT
USE_COUNT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
SEC_SUBKEY_ID

Payments - IBY_SECURITY_SEGMENTS
Column Name	Descritpion
SEGMENT_CIPHER_TEXT
CC_NUMBER_HASH1
CC_NUMBER_HASH2
CC_ISSUER_RANGE_ID
CC_NUMBER_LENGTH
CC_UNMASK_DIGITS
SEC_SUBKEY_ID
ENCODING_SCHEME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
SEC_SEGMENT_ID

Payments - IBY_SYS_SECURITY_OPTIONS
Column Name	Descritpion
SYS_KEY_HASH
CC_ENCRYPTION_MODE
EXT_BA_ENCRYPTION_MODE
INSTR_SEC_CODE_ENCRYPTION_MODE
CREDIT_CARD_MASK_SETTING
CREDIT_CARD_UNMASK_LEN
EXT_BA_MASK_SETTING
EXT_BA_UNMASK_LEN
SUBKEY_USE_MAXIMUM
CREATED_BY
CREATION_DATE
SYS_KEY_FILE_LOCATION
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER

Payments - IBY_TEMP_EXT_BANK_ACCTS
Column Name	Descritpion
TEMP_EXT_BANK_ACCT_ID
BANK_ADDRESS_ID
BRANCH_NUMBER
BRANCH_TYPE
BRANCH_NAME
BRANCH_NAME_ALT
BIC
RFC_IDENTIFIER
BANK_CODE
BRANCH_ADDRESS_ID
ACCOUNT_OWNER_PARTY_ID
EXT_BANK_ACCOUNT_ID
OWNER_PRIMARY_FLAG
BANK_ACCOUNT_NAME
BANK_ACCOUNT_NUM
CURRENCY_CODE
IBAN
CHECK_DIGITS
BANK_ACCOUNT_NAME_ALT
BANK_ACCOUNT_TYPE
ACCOUNT_SUFFIX
DESCRIPTION
COUNTRY_CODE
AGENCY_LOCATION_CODE
PAYMENT_FACTOR_FLAG
FOREIGN_PAYMENT_USE_FLAG
EXCHANGE_RATE_AGREEMENT_NUM
EXCHANGE_RATE_AGREEMENT_TYPE
EXCHANGE_RATE
START_DATE
END_DATE
ATTRIBUTE_CATEGORY
NOTE
BRANCH_ID
NOTE_ALT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
BANK_ID
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
STATUS
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
BANK_NAME
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
OBJECT_VERSION_NUMBER
CALLING_APP_UNIQUE_REF1
CALLING_APP_UNIQUE_REF2
EXT_PAYEE_ID
BANK_NUMBER
BANK_NAME_ALT
BANK_INSTITUTION_TYPE

Payments - IBY_TEMP_EXT_PAYEES
Column Name	Descritpion
TEMP_EXT_PAYEE_ID
ECE_TP_LOCATION_CODE
BANK_INSTRUCTION1_CODE
BANK_INSTRUCTION2_CODE
BANK_INSTRUCTION_DETAILS
PAYMENT_REASON_CODE
PAYMENT_REASON_COMMENTS
PAYMENT_TEXT_MESSAGE1
PAYMENT_TEXT_MESSAGE2
PAYMENT_TEXT_MESSAGE3
DELIVERY_CHANNEL_CODE
PAYMENT_FUNCTION
PAYMENT_FORMAT_CODE
EXCLUSIVE_PAYMENT_FLAG
INACTIVE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
PARTY_ID
ORG_TYPE
ORG_ID
BANK_CHARGE_BEARER
PARTY_SITE_ID
SUPPLIER_SITE_ID
DEFAULT_PAYMENT_METHOD_CODE

Payments - IBY_TEMP_PMT_INSTR_USES
Column Name	Descritpion
TEMP_EXT_PARTY_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
EXT_PARTY_ID
INSTRUMENT_TYPE
TEMP_INSTRUMENT_ID
PAYMENT_FUNCTION
ORDER_OF_PREFERENCE
STATUS
START_DATE
END_DATE

Payments - IBY_PYO_INVOICE_GT
Column Name	Descritpion
PAYMENT_ID
INVOICE_AMOUNT
DISCOUNT_AMOUNT
PRINT_SELECTED_CHECK_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
PAYMENT_INSTRUCTION_ID
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
INV_GLOBAL_ATTRIBUTE_CATEGORY
PAY_SELECTED_CHECK_ID
INV_GLOBAL_ATTRIBUTE1
INV_GLOBAL_ATTRIBUTE2
INV_GLOBAL_ATTRIBUTE3
INV_GLOBAL_ATTRIBUTE4
INV_GLOBAL_ATTRIBUTE5
INV_GLOBAL_ATTRIBUTE6
INV_GLOBAL_ATTRIBUTE7
INV_GLOBAL_ATTRIBUTE8
INV_GLOBAL_ATTRIBUTE9
INV_GLOBAL_ATTRIBUTE10
VENDOR_NUM
INV_GLOBAL_ATTRIBUTE11
INV_GLOBAL_ATTRIBUTE12
INV_GLOBAL_ATTRIBUTE13
INV_GLOBAL_ATTRIBUTE14
INV_GLOBAL_ATTRIBUTE15
INV_GLOBAL_ATTRIBUTE16
INV_GLOBAL_ATTRIBUTE17
INV_GLOBAL_ATTRIBUTE18
INV_GLOBAL_ATTRIBUTE19
INV_GLOBAL_ATTRIBUTE20
CUSTOMER_NUM
BANK_CHARGE_BEARER
PAYMENT_REASON_CODE
PAYMENT_REASON_COMMENTS
REMITTANCE_MESSAGE1
REMITTANCE_MESSAGE2
REMITTANCE_MESSAGE3
UNIQUE_REMITTANCE_IDENTIFIER
URI_CHECK_DIGIT
DELIVERY_CHANNEL_CODE
SETTLEMENT_PRIORITY
INVOICE_NUM
EXTERNAL_BANK_ACCOUNT_ID
PAYMENT_METHOD_CODE
VENDOR_ID
VENDOR_SITE_ID
PAYMENT_MEAN
PAYMENT_CHANNEL
COUNTRY
INVOICE_DATE
INVOICE_DESCRIPTION
PROPOSED_PAYMENT_AMOUNT

Payments - IBY_PYO_PAYMENT_GT
Column Name	Descritpion
COMMUNICATION_METHOD
TRANSACTION_DATE
ABA_GLOBAL_ATTRIBUTE10
ABA_GLOBAL_ATTRIBUTE11
ABA_GLOBAL_ATTRIBUTE12
ABA_GLOBAL_ATTRIBUTE13
ABA_GLOBAL_ATTRIBUTE14
ABA_GLOBAL_ATTRIBUTE15
ABA_GLOBAL_ATTRIBUTE16
ABA_GLOBAL_ATTRIBUTE17
ABA_GLOBAL_ATTRIBUTE18
ABA_GLOBAL_ATTRIBUTE19
TPH_ATTRIBUTE_CATEGORY
ABA_GLOBAL_ATTRIBUTE20
ABAS_GLOBAL_ATTRIBUTE_CATEGORY
ABAS_GLOBAL_ATTRIBUTE1
ABAS_GLOBAL_ATTRIBUTE2
ABAS_GLOBAL_ATTRIBUTE3
ABAS_GLOBAL_ATTRIBUTE4
ABAS_GLOBAL_ATTRIBUTE5
ABAS_GLOBAL_ATTRIBUTE6
ABAS_GLOBAL_ATTRIBUTE7
ABAS_GLOBAL_ATTRIBUTE8
TPH_ATTRIBUTE1
ABAS_GLOBAL_ATTRIBUTE9
ABAS_GLOBAL_ATTRIBUTE10
ABAS_GLOBAL_ATTRIBUTE11
ABAS_GLOBAL_ATTRIBUTE12
ABAS_GLOBAL_ATTRIBUTE13
ABAS_GLOBAL_ATTRIBUTE14
ABAS_GLOBAL_ATTRIBUTE15
ABAS_GLOBAL_ATTRIBUTE16
ABAS_GLOBAL_ATTRIBUTE17
ABAS_GLOBAL_ATTRIBUTE18
TPH_ATTRIBUTE2
ABAS_GLOBAL_ATTRIBUTE19
ABAS_GLOBAL_ATTRIBUTE20
PVS_GLOBAL_ATTRIBUTE_CATEGORY
PVS_GLOBAL_ATTRIBUTE1
PVS_GLOBAL_ATTRIBUTE2
PVS_GLOBAL_ATTRIBUTE3
PVS_GLOBAL_ATTRIBUTE4
PVS_GLOBAL_ATTRIBUTE5
PVS_GLOBAL_ATTRIBUTE6
PVS_GLOBAL_ATTRIBUTE7
TPH_ATTRIBUTE3
PVS_GLOBAL_ATTRIBUTE8
PVS_GLOBAL_ATTRIBUTE9
PVS_GLOBAL_ATTRIBUTE10
PVS_GLOBAL_ATTRIBUTE11
PVS_GLOBAL_ATTRIBUTE12
PVS_GLOBAL_ATTRIBUTE13
PVS_GLOBAL_ATTRIBUTE14
PVS_GLOBAL_ATTRIBUTE15
PVS_GLOBAL_ATTRIBUTE16
PVS_GLOBAL_ATTRIBUTE17
TPH_ATTRIBUTE4
PVS_GLOBAL_ATTRIBUTE18
PVS_GLOBAL_ATTRIBUTE19
PVS_GLOBAL_ATTRIBUTE20
BK_EFT_SWIFT_CODE
SBK_BANK_BRANCH_NUMBER
SBK_BANK_BRANCH_NAME
SBK_ADDRESS_LINE1
SBK_ADDRESS_LINE2
SBK_ADDRESS_LINE3
SBK_CITY
TPH_ATTRIBUTE5
SBK_STATE
SBK_ZIP
SBK_PROVINCE
SBK_COUNTRY
SBK_EFT_SWIFT_CODE
BILL_TO_INT_LOCATION_NAME
BILL_TO_INT_ADDRESS1
BILL_TO_INT_ADDRESS2
BILL_TO_INT_ADDRESS3
BILL_TO_INT_CITY
TPH_ATTRIBUTE6
BILL_TO_INT_POSTAL_CODE
BILL_TO_INT_COUNTRY
FI_VAT_REGISTRATION_NUM
BILL_TO_INT_LOCATION_ID
ECE_TP_LOCATION_CODE
BILL_TO_INT_REGION1
BILL_TO_INT_REGION2
BILL_TO_INT_REGION3
MAP_ID
FUTURE_PAY_DUE_DATE
TPH_ATTRIBUTE7
VENDOR_ALTERNATE_NAME
VENDOR_ALTERNATE_SITE_CODE
SUPPLIER_CHECK_DIGITS
SBK_BANK_NAME
IBAN_NUMBER
VENDOR_IBAN_NUMBER
PAYMENT_MEAN
PAYMENT_CHANNEL
VENDOR_ID
VENDOR_SITE_ID
TPH_ATTRIBUTE8
PAYMENT_REFERENCE_NUMBER
SBK_BANK_CODE
TEST_FLAG
TPH_ATTRIBUTE9
TPH_ATTRIBUTE10
TPH_ATTRIBUTE11
TPH_ATTRIBUTE12
TPH_ATTRIBUTE13
TPH_ATTRIBUTE14
TPH_ATTRIBUTE15
TPD_ATTRIBUTE_CATEGORY
TPD_ATTRIBUTE1
TPD_ATTRIBUTE2
DOCUMENT_ID
TPD_ATTRIBUTE3
TPD_ATTRIBUTE4
TPD_ATTRIBUTE5
DOCUMENT_STANDARD
TRANSACTION_HANDLING_CODE
CHECK_AMOUNT
CURRENCY_CODE
EDI_PAYMENT_METHOD
EDI_PAYMENT_FORMAT
BANK_BRANCH_TYPE
DOCUMENT_CODE
BANK_ACCOUNT_TYPE
BANK_ACCOUNT_NUM
BANK_EDI_ID_NUMBER
VENDOR_BANK_BRANCH_TYPE
VENDOR_BANK_ACCOUNT_TYPE
VENDOR_BANK_ACCOUNT_NUM
PAYMENT_DATE
BANK_NUM
VENDOR_BANK_NUM
EDI_REMITTANCE_METHOD
BK_TP_TRANSLATOR_CODE
EDI_REMITTANCE_INSTRUCTION
PAYMENT_INSTRUCTION_ID
CHECK_VOUCHER_NUM
SELECTED_CHECK_ID
CHECK_NUMBER
CUSTOMER_NUM
SEGMENT1
VENDOR_EDI_ID_NUMBER
SEGMENT2
SEGMENT3
BK_TP_LOCATION_CODE_EXT
SEGMENT4
SEGMENT5
BANK_BRANCH_ID
BK_BANK_BRANCH_NAME
BK_ADDRESS_LINE1
BK_ADDRESS_LINE2
BK_ADDRESS_LINE3
BK_CITY
BK_ZIP
BK_COUNTRY
BK_TP_DESCRIPTION
BK_STATE
BK_PROVINCE
BK_CONTACT_FIRST_NAME
BK_CONTACT_MIDDLE_NAME
BK_CONTACT_LAST_NAME
BK_CONTACT_TITLE
BK_CONTACT_PREFIX
BK_CONTACT_AREA_CODE
BK_CONTACT_PHONE
VENDOR_SITE_CODE
BK_TP_REFERENCE_EXT1
VENDOR_NAME
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
ADDRESS_LINE4
CITY
ZIP
COUNTRY
STATE
PROVINCE
BK_TP_REFERENCE_EXT2
ABA_GLOBAL_ATTRIBUTE_CATEGORY
ABA_GLOBAL_ATTRIBUTE1
ABA_GLOBAL_ATTRIBUTE2
ABA_GLOBAL_ATTRIBUTE3
ABA_GLOBAL_ATTRIBUTE4
ABA_GLOBAL_ATTRIBUTE5
ABA_GLOBAL_ATTRIBUTE6
ABA_GLOBAL_ATTRIBUTE7
ABA_GLOBAL_ATTRIBUTE8
ABA_GLOBAL_ATTRIBUTE9

Payments - IBY_EXT_PAYEE_RELATIONSHIPS	"This table stores information about third party payment related relationships and related attributes. IBY_EXT_PAYEE_RELATIONSHIPS contain third payment relationships entered manually using the Relationship region in the supplier page. Eac
Column Name	Descritpion
PARTY_ID	Party identifier for whom the third party payment relationship is created.
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
SUPPLIER_SITE_ID	Supplier site identifier for whom the third party payment relationship is created.
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
REMIT_PARTY_ID	The remit to party identifier on whom the payments will be made.
REMIT_SUPPLIER_SITE_ID	The remit to supplier site identifier on whom the payments will be made.
FROM_DATE	The date from which the relationship to make the third party payments is valid for processing.
TO_DATE	The date up to which the relationship to make the third party payments is valid for processing.
PRIMARY_FLAG	Indicates whether this is the primary relationship for a date range.
ADDITIONAL_INFORMATION	Additional information for the third party payment relationship.
RELATIONSHIP_ID	Unique internal Identifier for this record. Generated using a database sequence.
ACTIVE	Indicates whether the relationship is active or not.
CREATED_BY	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	Standard who column - date when this row was created.
LAST_UPDATED_BY	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_DATE	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.
LAST_UPDATE_LOGIN	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	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.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment

Payments - IBY_PROCESS_CONC_REQUESTS	Concurrent requests
Column Name	Descritpion
OBJECT_ID	Object identifier
OBJECT_VERSION_NUMBER	Object version number
OBJECT_TYPE	Object type
REQUEST_ID	Concurrent request identifier
COMPLETED_FLAG	Y or N flag that indicates if the payments are complete
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Payments - IBY_PMT_LOGICAL_GRP_RULES	IBY_PMT_LOGICAL_GRP_RULES specifies the attributes for grouping the payments in a payment instruction.
Column Name	Descritpion
GROUP_BY_PAYMENT_CURRENCY	Y or N specifying whether payments are grouped by payment currency
GROUP_BY_INTERNAL_BANK_ACCOUNT	Y or N specifying if the payments will be grouped by internal bank account
GROUP_BY_LEGAL_ENTITY	Y or N specifying if payments are grouped by legal entity
GROUP_BY_PAYMENT_METHOD	Y or N specifying if payments are grouped by payment method
GROUP_BY_PAYMENT_REASON	Y or N specifying if payments are grouped by payment reason
GROUP_BY_OPERATING_UNIT	Y or N specifying if the payments are grouped by operating unit
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
SYSTEM_PROFILE_CODE	Unique primary key
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard When Column
OBJECT_VERSION_NUMBER	Object Version Number
GROUP_BY_PAYMENT_DATE	Y or N specifying whether payments are grouped by payment date
LAST_UPDATE_LOGIN	Standard Who Column

Payments - IBY_PAYMENTCARD	"This table stores information about card number for the card programs associated with card type 'Payment Card'.IBY_PAYMENTCARD contain payment card numbers entered manually through the Payables, Credit card setup. The card number can be nu
Column Name	Descritpion
CARD_NUMBER	The Payment card number. It can be alphanumeric
CARD_PURPOSE	Not used
INACTIVE_DATE	Inactive date
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
EXPIRYDATE	Expiration date of the card
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
ADDRESSID	Will become a foreign key to HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID instead of HZ_LOCATIONS.LOCATION_ID ; changes to existing customer data will be implemented in an upgrade script
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
SECURITY_GROUP_ID	Used in hosted environments
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	This column is 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. The situation occurs when the HTML application is an 'stateless' application.
BILLING_ADDR_POSTAL_CODE	Billing address postal code
BILL_ADDR_TERRITORY_CODE	Billing address territory code
DESCRIPTION	Description of the instrument
CHNAME	Card Holder Name
FINAME	Financial Institution Name
INSTRID	Sequence: IBY_PAYMENTCARD_S.nextval
MASKED_CARD_NUMBER	Masked Payment card number; to be used for display purposes
CARD_MASK_SETTING	For masking feature
CARD_UNMASK_LENGTH	For masking feature
CARD_OWNER_ID	Owner TCA Party ID
INSTRUMENT_TYPE	PAYMENTCARD
CARD_ISSUER_CODE	COMCHECK
CARD_NUMBER_LENGTH	For masking/security features
ACTIVE_FLAG	Y or N denoting the card is active or not
SINGLE_USE_FLAG	Not Used
INFORMATION_ONLY_FLAG	Not used

Payments - IBY_AR_DOC_LINES_GT
Column Name	Descritpion
LINE_NUMBER
INVENTORY_ITEM_ID
DISCOUNT_AMOUNT
SALES_TAX_AMOUNT
TAX_RATE
VAT_TAX_AMOUNT
DOC_UNIQUE_REF
PO_NUMBER
LINE_TYPE
DESCRIPTION
EXTENDED_AMOUNT
INVOICE_CURRENCY_CODE
UNIT_PRICE
QUANTITY
UNIT_OF_MEASURE

Payments - IBY_PAY_DASHBOARD_GT
Column Name	Descritpion
PAYMENT_SERVICE_REQUEST_ID
CHECKRUN_ID
CHECKRUN_NAME
STATE

Payments - IBY_AR_DOC_HEADER_GT
Column Name	Descritpion
CALLING_APP_DOC_REF_NUMBER
FREIGHT_AMOUNT
DOCUMENT_DISCOUNT_EARNED
LOCAL_TAX_AMOUNT
NATIONAL_TAX_AMOUNT
VAT_TAX_AMOUNT
ADDRESS1
ADDRESS2
ADDRESS3
CITY
COUNTY
DOCUMENT_DATE
STATE
COUNTRY
POSTAL_CODE
TO_ADDRESS1
TO_ADDRESS2
TO_ADDRESS3
TO_CITY
TO_COUNTY
TO_STATE
TO_COUNTRY
CREATION_DATE
TO_POSTAL_CODE
ORDER_TANGIBLE_ID
TRANSACTIONID
INITIATOR_EXTENSION_ID
DOC_UNIQUE_REF
BR_DRAWEE_ISSUED_FLAG
BR_SIGNED_FLAG
DOCUMENT_TYPE
DOCUMENT_DESCRIPTION
DOCUMENT_AMOUNT
DOCUMENT_CURRENCY_CODE
SETTLEMENT_AMOUNT
DISCOUNT_AMOUNT

Payments - IBY_DOCS_IN_PMT_GT
Column Name	Descritpion
PAYMENT_ID
DOCUMENT_AMOUNT
DOCUMENT_CURRENCY_CODE
PAYMENT_GROUPING_NUMBER
DOCUMENT_STATUS
AMOUNT_WITHHELD
PAYMENT_DUE_DATE
DISCOUNT_DATE
INTERNAL_BANK_ACCOUNT_ID
EXT_PAYEE_ID
PAYEE_PARTY_ID
DOCUMENT_PAYABLE_ID
PARTY_SITE_ID
SUPPLIER_SITE_ID
ORG_ID
ORG_TYPE
EXTERNAL_BANK_ACCOUNT_ID
PAYMENT_CURR_DISCOUNT_TAKEN
DELIVERY_CHANNEL_CODE
UNIQUE_REMITTANCE_IDENTIFIER
URI_CHECK_DIGIT
CREATED_BY
CALLING_APP_ID
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
DONT_PAY_FLAG
DONT_PAY_REASON_CODE
DONT_PAY_DESCRIPTION
CALLING_APP_DOC_UNIQUE_REF1
CALLING_APP_DOC_UNIQUE_REF2
CALLING_APP_DOC_UNIQUE_REF3
CALLING_APP_DOC_UNIQUE_REF4
CALLING_APP_DOC_UNIQUE_REF5
PAY_PROC_TRXN_TYPE_CODE