Payments - IBY_TRXN_CORE | IBY_BEPKEYS stores information about the payment systems. |
---|---|
Column Name | Descritpion |
TAXAMOUNT | The amount, out of the total price, that consists of tax. |
SHIPFROMZIP | The ZIP code from which merchandise is to be sent. |
SHIPTOZIP | The ZIP code to which merchandise is to be sent. |
VOICEAUTHFLAG | Indicate whether voice authorization obtained. |
DATE_OF_VOICE_AUTHORIZATION | Date Of Voice Authorization |
CVV2RESULT | CVV2 validation result returned by the payment system/credit card network. |
PROC_TRACENUMBER | Processor trace/reference number column. Required by certain processors. |
POS_READER_CAPABILITY_CODE | Card reader capability at the point-of-sale from lookup type IBY_POS_CAPABILITY_TYPE |
POS_ENTRY_METHOD_CODE | Card entry method from lookup type IBY_POS_ENTRY_TYPE |
POS_ID_METHOD_CODE | Card holder identification method from lookup type IBY_POS_CARD_ID_TYPE |
POS_AUTH_SOURCE_CODE | Card authorization source from lookup type IBY_POS_AUTH_SRC_TYPE |
READER_DATA | Card reader data, encoded in a text format |
POS_TRXN_FLAG | Indicates whether the transaction occurred at a point-of-sale |
INSTR_EXPIRYDATE | Expiration date for the card |
CARD_SUBTYPE_CODE | Subtype, used for purchase cards from lookup type IBY_PURCHASECARD_SUBTYPE |
CARD_DATA_LEVEL | Purchase card data level from lookup type IBY_PCARD_DATA_LEVEL |
INSTR_OWNER_NAME | Card holder name, as a single string |
INSTR_OWNER_ADDRESS_LINE1 | Card holder billing address line 1 information. |
INSTR_OWNER_ADDRESS_LINE2 | Card holder billing address line 2 information. |
INSTR_OWNER_ADDRESS_LINE3 | Card holder billing address line 3 information. |
INSTR_OWNER_CITY | Card holder billing address city information |
INSTR_OWNER_STATE_PROVINCE | Card holder billing address state or province information |
INSTR_OWNER_COUNTRY | Card holder billing address country information |
INSTR_OWNER_POSTALCODE | Card holder billing address information |
INSTR_OWNER_PHONE | Card holder billing address phone information |
INSTR_OWNER_EMAIL | Card holder email information |
AUTHCODE | Authorization code received from Credit Card Processing System for authorization. |
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_DATE | Standard Who column - date when a user last updated this row. |
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. |
CREATION_DATE | Standard who column - date when this row was created. |
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. |
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. |
SECURITY_GROUP_ID | Used in hosted environments |
DEBIT_NETWORK_CODE | Debit card network code |
SURCHARGE_AMOUNT | Debit card surcharge amount |
ENCRYPTED | Indicates whether the card holder name and the expiry date details are encrypted or not. |
EXPIRY_SEC_SEGMENT_ID | Expiry date segment identifier - for security purposes |
CHNAME_SEC_SEGMENT_ID | Card holder name segment identifier - for security purposes |
REFERENCECODE | Reference code received from Back End Payment Systems or processing system which can be used for reference. |
OPERATIONCODE | Generic code for any operation such as auth, capture etc |
INSTRNAME | Ppayment instrument name such as Visa, MasterCard etc. |
TRXNMID | Primary key as well as foreign key associating the POS data with a single credit card transaction |
AUTHTYPE | Denotes whether authorization is authonly or authcapture. |
TERMINALID | Used for credit card processing. A merchant can get multiple terminal Ids and there is a batch open for each Terminal Id. The merchant could perform operations on those batches independently. |
AVSCODE | Address Verification Code from back end payment systems. |
TRACENUMBER | Unique Transaction id for payworks Back End Payment System follow-on transactions |
ACQUIRER | Merchant bank which may be optionally returned by back end payment system. |
AUXMSG | Auxillary message that may be returned by the payment system or processing system. |
PONUMBER | Buyer's Purchase Order Number |
Payments - IBY_TRXN_EXTENDED | IBY_TRXN_EXTENDED stores the details of a payment request that are specific for extended set functionality for credit cards. |
---|---|
Column Name | Descritpion |
TRXNMID | Transaction Identifier |
BATCHTRXNSTATUS | Indicates the status of the row if it is included in batch operation |
SETREQTYPE | Denotes whether pinit or preq SET request type |
PREVSPLITID | Used during subsequent authorization |
SUBSAUTHTYPE | Authorization type for subsequent authorization |
SPLITSHIPMENT | Y or N flag indicating if the shipment has been split |
AUTHCURRENCY | Authorized currency |
AUTHPRICE | Authorized price |
INSTALLTOTALTRXNS | Number of installments |
RECURRINGFREQ | Frequency in number of days of recurring authorization |
RECURRINGEXPDATE | Date for final installment |
SETTRXNID | Transaction Identifier from payment system |
CUSTREFNUM | Customer reference number |
DESTPOSTALCODE | Destination postal code |
LOCALTAXPRICE | Local tax price |
LOCALTAXCURRENCY | Local tax currency |
CREDITCOUNTER | Indicates the nth return for multiple returns |
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 |
LAST_UPDATE_DATE | 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 |
APPROVALCODE | SET approval code for an operation. For example, for authorization transaction, it contains the authorization code. |
COMPLETIONCODE | Additional SET status code for completion of transaction |
SPLITID | Counter that indicates the sequence in the split shipment |
TERMINALID | Used for credit card processing. A merchant can get multiple terminal identifiers and there is a batch open for each Terminal Identifier. The merchant can perform operations on those batches independantly. |
SUBAUTHIND | Subsequent authorization indicator |
CARDBIN | First five or six digits that identifies the card |
BATCHSEQNUM | Sequence of the transaction in a batch |
Payments - IBY_TRXN_FI | IBY_TRXN_FI contains the details of a payment request that are specific for systems that support both bank account transfers and credit cards such as Financial Institutions. |
---|---|
Column Name | Descritpion |
TRXNMID | Transaction Identifier |
SPLITID | counter that indicates the sequence in the split shipment |
PSREQID | system generated ID that will be sent to FI Back End Payment Systems during schedule of payments with them |
REFERENCECODE | referencecode from Back End Payment System |
AUXMSG | any auxillary message that may be returned by the payment system or processing system |
SRVID | ID returned by Back End Payment System when the payment is scheduled |
PROCESSFEE | The fee charged for processing a transaction |
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 - 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_TRXN_SUMMARIES_ALL | IBY_TRXN_SUMMARIES_ALL contains information about each payment request. This table is used for both online and offline payment transactions. The information contained in this table is generic in nature to cover the various payment inst |
---|---|
Column Name | Descritpion |
TRANSACTIONID | ID generated for each payment request (orapmtreq) and passed back toElectronic Commerce Application. |
PAYERID | userid |
PAYERINSTRID | Instrument id for the payer |
DETAILLOOKUP | lookup column for CORE, EXTENDED or FI transactions |
AMOUNT | Transaction Amount |
INSTRNUMBER | Instrument number could be Credit Card number(for 11i) in case of unregistered instruments. |
INSTRNUM_HASH | |
INSTRNUM_LENGTH | |
PAYMENT_CHANNEL_CODE | |
INSTRTYPE | Instrument type |
INSTRSUBTYPE | Holds the instrument subtype for the payment transaction. The subtype is like visa, master card, etc. for credit card. |
CC_ISSUER_RANGE_ID | |
CURRENCYNAMECODE | code for currency name such USD |
STATUS | Status of the transaction. It is a lookup code for lookup type IBY_TRANSACTION_STATUS |
TANGIBLEID | bill or order ID |
UPDATEDATE | the date scheduled payment is updated |
TRXNTYPEID | The TRXTYPE columns is a Lookup code for lookup type IBY_TRXNTYPES |
ERRORLOCATION | Identifies the location of error |
BEPCODE | Error code from Back End Payment System |
BEPMESSAGE | Error message from Back End Payment System |
BATCHID | Batch Id provided by Electronic Commerce Application |
SETTLEDATE | scheduled date for the bill or order used for offline payments only |
MBATCHID | Batch identifier |
ECBATCHID | Used for AR Bills Receivable integration. RA_BATCHES_ALL.BATCH_ID |
REQDATE | date when the batch operation request is received |
SALES_REP_PARTY_ID | The party Identifier for the sales rep who initiated the transaction. Foreign Key to HZ_PARTIES |
PROCESS_PROFILE_CODE | |
REQTYPE | type of request such as closebatch, purgebatch, openbatch etc... |
REQSEQ | Request Sequence |
DESTURL | used for storing the constructed Back End Payment System url during schedule of Payments |
NLSLANG | NLS Language |
NEEDSUPDT | flag to identify the rows that has changed status. Used by Schedular |
OVERALL_SCORE | Overall Risk Score |
SUB_KEY_ID | Oracle Internal use only - reserved for future use |
INSTRNUM_SEC_SEGMENT_ID | |
TRXNREF | Optional, secondary transaction identifier to be passed by calling application; useful in distinguishing transactions when the tangible/order id must be shared. |
BEPKEY | merchant account ID used with this transaction |
SECURITY_GROUP_ID | Used in hosted environments |
PROC_REFERENCE_CODE | |
PROC_REFERENCE_AMOUNT | |
SETTLEMENT_CUSTOMER_REFERENCE | |
BR_MATURITY_DATE | |
SETTLEMENT_DUE_DATE | |
CALL_APP_SERVICE_REQ_CODE | |
BANK_CHARGE_BEARER_CODE | |
DIRDEB_INSTRUCTION_CODE | |
DEBIT_ADVICE_DELIVERY_METHOD | |
PAYEEID | id of the payee passed by Electronic Commerce Application |
DEBIT_ADVICE_EMAIL | |
DEBIT_ADVICE_FAX | |
PAYER_PARTY_ID | |
BEPID | Back End Payment System Identifier |
MPAYEEID | Payee identifier |
ECAPPID | Electronic Commerce Application Identifier |
TRXNMID | system generated ID |
CUST_ACCOUNT_ID | Customer account for which the payment transaction is being processed. Foreign Key to HZ_CUST_ACCOUNTS |
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. |
FIRST_TRXN_FLAG | |
ACCT_SITE_ID | |
ACCT_SITE_USE_ID | |
ORG_ID | Organization identifier |
ORG_TYPE | |
LEGAL_ENTITY_ID | |
BILL_TO_ADDRESS_ID | |
FACTORED_FLAG | |
PAYMENTMETHODNAME | Payment Method Name |
MTANGIBLEID | master id that points to iby_tangible table for additional information about tangible(orders) |
PAYEEINSTRID | Instrument id for the payee |
Payments - IBY_TRXN_DOCUMENTS | Table used to store XML documents associated with a particular transaction. |
---|---|
Column Name | Descritpion |
TRXN_DOCUMENT_ID | System generated Primary Key |
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 | 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_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). |
TRXNMID | Column is a foreign key into table IBY_TRXN_SUMMARIES_ALL . Indicates which transaction |
PAYMENT_INSTRUCTION_ID | |
DOCTYPE | Column holds an application defined number indicating what type of document this is. |
DOCUMENT | Column holds the actual XML document. |
FROZEN_FLAG | Oracle Internal use only - reserved for future use |
TO_BE_PURGED_FLAG | Oracle Internal use only - reserved for future use |
DOCUMENT_PURGED_FLAG | Oracle Internal use only - reserved for future use |
DOCUMENT_PURGED_DATE | Oracle Internal use only - reserved for future use |
SECURITY_GROUP_ID | Used in hosted environments |
Payments - IBY_VISBLTY_CLASS_DTLS | Stores the combinations of EC app, payee and org id for a visibility class |
---|---|
Column Name | Descritpion |
VISIBILITY_CLASS_ID | Foreign key to parent visibility class |
LAST_UPDATE_LOGIN | Standard Who column |
SECURITY_GROUP_ID | Used in hosted environments |
VIS_PAYEEID | The payee for the visibility detial |
VIS_ECAPPID | The EC app for the visibility detial |
VIS_ORG_ID | The orgnization for the visibility detial |
VIS_ALL_PAYEE_FLAG | Indicating if this visibility class details is for all payees. Value are 'Y', 'N', or null. If 'Y', the VIS_PAYEEID is ignored |
VIS_ALL_ECAPP_FLAG | Indicating if this visibility class details is for all EC applications. Value are 'Y', 'N', or null. If 'Y', the VIS_ECAPPID is ignored |
VIS_ALL_ORG_FLAG | Indicating if this visibility class details is for all organizations. Value are 'Y', 'N', or null. If 'Y', the VIS_ORG_ID is ignored |
VISBLTY_CLASS_DTL_ID | System generated primary key |
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 |
Payments - IBY_VISIBILITY_CLASSES | Stores the user privilege settings for viewing sensitive data in iPayment operations UI |
---|---|
Column Name | Descritpion |
VISIBILITY_CLASS_ID | System generated primary key |
LAST_UPDATE_LOGIN | Standard Who column |
SECURITY_GROUP_ID | Used in hosted environments |
VISIBILITY_CLASS_NAME | Name of the visibility class |
INSTR_NUMBER_MASK | How to mask instrument numbers used for a transaction |
AMOUNT_MASK | How the transaction amount is masked. Set to masked values for Payroll originated data |
BENEFICIARY_MASK | How the beneficiary name is masked. Set to masked values for Payroll originated data |
START_DATE_ACTIVE | Date when the visibility class become active |
END_DATE_ACTIVE | Date after which the visibility class will no longer be active |
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 |
Payments - IBY_VALIDATION_VALUES | IBY_VALIDATION_VALUES stores the values for each validation parameter. For example, one validation controls the maximum amount that can be paid in a single payment instruction. The maximum amount parameter is stored in this table, and the a |
---|---|
Column Name | Descritpion |
VALIDATION_ASSIGNMENT_ID | Validation assignment Identifier |
VAL_PARAM_VARCHAR2_VALUE | Value of the validation parameter if it is of type VARCHAR2 |
VAL_PARAM_NUMBER_VALUE | Value of the validation parameter if it is of type NUMBER |
VAL_PARAM_DATE_VALUE | Value of the validation parameter if it is of type DATE |
VALIDATION_PARAMETER_CODE | Name or token of the parameter that uses this value |
VALIDATION_SET_CODE | Validation set code |
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_VALIDATION_PARAMS_TL | IBY_VALIDATION_PARAMS stores parameters for each validation. For example, one validation controls the maximum amount that can be paid in a single payment instruction. The maximum amount parameter is stored in this table, and the actual valu |
---|---|
Column Name | Descritpion |
VALIDATION_SET_CODE | Validation set code |
LAST_UPDATE_LOGIN | Standard Who column |
OBJECT_VERSION_NUMBER | Object version number |
VALIDATION_PARAMETER_CODE | User entered primary key. Name or token of the parameter that should use this value |
VALIDATION_PARAM_DISPLAY_NAME | Validation value 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 |
Payments - IBY_VALIDATION_PARAMS_B | IBY_VALIDATION_PARAMS stores parameters for each validation. For example, one validation controls the maximum amount that can be paid in a single payment instruction. The maximum amount parameter is stored in this table, and the actual valu |
---|---|
Column Name | Descritpion |
VALIDATION_SET_CODE | Validation set code |
OBJECT_VERSION_NUMBER | Object version number |
VALIDATION_PARAMETER_CODE | User entered primary key. Name or token of the parameter that should use this value |
VALIDATION_PARAMETER_TYPE | Data type of the parameter. Values from the lookup IBY_PARAMETER_TYPES include VARCHAR2, NUMBER, and DATE. |
VALIDATION_PARAM_DISPLAY_ORDER | Number used to order the parameters |
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_TRXN_TYPES_TL | IBY_TRXN_TYPES stores the payment processing transaction types required by the dependent products for submitting payment transactions to Oracle Payments. This is used for both funds disbursement and funds capture transactions. |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application Identifier of the calling product |
LAST_UPDATE_LOGIN | Standard Who column |
OBJECT_VERSION_NUMBER | Object version number |
PAY_PROC_TRXN_TYPE_CODE | System code for the transaction type. Must be unique per calling application |
LANGUAGE | Language code |
SOURCE_LANG | Language code of the record's current language |
NAME | User friendly name |
DESCRIPTION | Free text description of the payment processing transaction 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_TRXN_TYPES_B | IBY_TRXN_TYPES stores the payment processing transaction types required by the dependent products for submitting payment transactions to Oracle Payments. This is used for both funds disbursement and funds capture transactions. |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application Identifier of the calling product |
OBJECT_VERSION_NUMBER | Object version number |
PAY_PROC_TRXN_TYPE_CODE | System code for the transaction type. Must be unique per calling application |
SEEDED_FLAG | Y or N flag for whether the payment processing transaction type is seeded |
PAYMENT_FLOW | Category of this transaction type. Values are defined in the IBY_PAYMENT_FLOW lookup and include DISBURSEMENTS and FUND CAPTURE. |
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_TRXN_ERROR_TOKENS | IBY_TRXN_ERROR_TOKENS stores the values that are used to fill out the tokens in transaction error messages. For each error in IBY_TRANSACTION_ERRORS, this table contains one or more rows with one row for each token included in the correspon |
---|---|
Column Name | Descritpion |
TRANSACTION_ERROR_ID | Transaction error Identifier |
LAST_UPDATE_LOGIN | Standard Who column |
TOKEN_NAME | Name or code of the token |
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 |
TOKEN_VALUE | Value to be populated into the error message |
LOOKUP_TYPE_SOURCE | FND lookup type to which the token value belongs |
Payments - IBY_USED_PAYMENT_DOCS | IBY_USED_PAYMENT_DOCS tracks information about which payment documents have been used when printing payments. |
---|---|
Column Name | Descritpion |
PAYMENT_DOCUMENT_ID | Payment document Identifier |
OBJECT_VERSION_NUMBER | Object version number |
USED_DOCUMENT_NUMBER | Number of payment document used |
DATE_USED | Date that the payment document was used |
DOCUMENT_USE | This column can be populated with any of the values defined in the IBY_PAYMENT_DOCUMENT_USES lookup. |
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_TRXN_EXTENSIBILITY | |
---|---|
Column Name | Descritpion |
TRXNMID | |
EXTEND_NAME | |
EXTEND_VALUE | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
OBJECT_VERSION_NUMBER | |
TRXN_EXTEND_ID |
Payments - IBY_VALIDATION_SETS_TL | |
---|---|
Column Name | Descritpion |
LANGUAGE | |
SOURCE_LANG | |
VALIDATION_SET_DISPLAY_NAME | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
VALIDATION_SET_CODE | |
OBJECT_VERSION_NUMBER |
Payments - IBY_TRANSMIT_PROTOCOLS_B | |
---|---|
Column Name | Descritpion |
TRANSMIT_CODE_LANGUAGE | |
TRANSMIT_CODE_PACKAGE | |
TRANSMIT_CODE_ENTRY_POINT | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
OBJECT_VERSION_NUMBER | |
TRANSMIT_PROTOCOL_CODE |
Payments - IBY_TRANSMIT_VALUES | |
---|---|
Column Name | Descritpion |
TRANSMIT_CONFIGURATION_ID | |
TRANSMIT_PARAMETER_CODE | |
TRANSMIT_VARCHAR2_VALUE | |
TRANSMIT_NUMBER_VALUE | |
TRANSMIT_DATE_VALUE | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
TRANSMIT_VALUE_ID | |
OBJECT_VERSION_NUMBER |
Payments - IBY_TRANSMIT_PROTOCOLS_TL | |
---|---|
Column Name | Descritpion |
LANGUAGE | |
SOURCE_LANG | |
TRANSMIT_PROTOCOL_NAME | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
OBJECT_VERSION_NUMBER | |
TRANSMIT_PROTOCOL_CODE |
Payments - IBY_TRANSMIT_PARAMETERS_TL | |
---|---|
Column Name | Descritpion |
TRANSMIT_PROTOCOL_CODE | |
LANGUAGE | |
SOURCE_LANG | |
TRANSMIT_PARAMETER_NAME | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
OBJECT_VERSION_NUMBER | |
TRANSMIT_PARAMETER_CODE |
Payments - IBY_TRANSMIT_PARAMETERS_B | |
---|---|
Column Name | Descritpion |
TRANSMIT_PARAMETER_TYPE | |
DISPLAY_ORDER | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
TRANSMIT_PROTOCOL_CODE | |
OBJECT_VERSION_NUMBER | |
MANDATORY_FLAG | |
DYNAMIC_FLAG | |
DYN_CODE_LANGUAGE | |
DYN_CODE_PACKAGE | |
DYN_CODE_ENTRY_POINT | |
TRANSMIT_PARAMETER_CODE |
Payments - IBY_VAL_ASSIGNMENTS | |
---|---|
Column Name | Descritpion |
VALIDATION_SET_CODE | |
VAL_ASSIGNMENT_ENTITY_TYPE | |
ASSIGNMENT_ENTITY_ID | |
INACTIVE_DATE | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
OBJECT_VERSION_NUMBER | |
VALIDATION_ASSIGNMENT_ID |
Payments - IBY_VALIDATION_SETS_B | |
---|---|
Column Name | Descritpion |
VALIDATION_LEVEL_CODE | |
VALIDATION_CODE_PACKAGE | |
VALIDATION_CODE_ENTRY_POINT | |
VALIDATION_CODE_LANGUAGE | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
VALIDATION_SET_CODE | |
LAST_UPDATE_LOGIN | |
OBJECT_VERSION_NUMBER | |
PAYMENT_FLOW |
Payments - IBY_UPG_INSTRUMENTS | |
---|---|
Column Name | Descritpion |
INSTR_ASSIGNMENT_ID | |
ACCT_SITE_USE_ID | |
SUPPLIER_SITE_ID | |
BANK_ACCOUNT_ID | |
BANK_ACCOUNT_USES_ID | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
OBJECT_VERSION_NUMBER | |
EXT_PARTY_ID | |
INSTRUMENT_TYPE | |
INSTRUMENT_ID | |
PAYMENT_FUNCTION | |
ORG_TYPE | |
ORG_ID | |
PARTY_SITE_ID | |
CUST_ACCOUNT_ID |
Payments - IBY_UPG_PPP | |
---|---|
Column Name | Descritpion |
SYSTEM_PROFILE_CODE | |
SYSTEM_PROFILE_DESCRIPTION | |
PERIODIC_SEQUENCE_NAME_1 | |
PERIODIC_SEQUENCE_NAME_2 | |
PERIODIC_SEQUENCE_NAME_3 | |
PROCESSING_TYPE | |
MARK_COMPLETE_EVENT | |
MANUAL_MARK_COMPLETE_FLAG | |
POSITIVE_PAY_DELIVERY_FLAG | |
TRANSMIT_INSTR_IMMED_FLAG | |
AUTOMATIC_PI_REG_SUBMIT | |
BEP_SUFFIX | |
SYSTEM_PROFILE_NAME | |
DECLARATION_OPTION | |
DCL_ONLY_FOREIGN_CURR_PMT_FLAG | |
DECLARATION_REPORT_FORMAT_CODE | |
DECLARATION_CURR_FX_RATE_TYPE | |
DECLARATION_CURRENCY_CODE | |
SECURITY_PROTOCOL_CODE | |
DECLARATION_THRESHOLD_AMOUNT | |
BANK_INSTRUCTION1_CODE | |
BANK_INSTRUCTION2_CODE | |
BANK_INSTRUCTION_DETAILS | |
TRANSMIT_PROTOCOL_CODE | |
PAYMENT_TEXT_MESSAGE1 | |
PAYMENT_TEXT_MESSAGE2 | |
ACK_TRANSMIT_PROTOCOL_CODE | |
ACK_SECURITY_PROTOCOL_CODE | |
SEND_TO_FILE_FLAG | |
PI_REGISTER_FORMAT | |
BEP_ACCOUNT_ID | |
PAYMENT_PROFILE_NAME | |
APPLICABLE_PMT_METHOD | |
APPLICABLE_CURRENCY | |
APPLICABLE_PAYER_ORG | |
APPLICABLE_INT_BANK_ACCOUNT | |
PAYMENT_FORMAT_CODE | |
PMT_GROUP_BY_PAYMENT_DETAILS | |
PMT_GROUP_BY_BANK_CHARGE_BEAR | |
PMT_GROUP_BY_DELIVERY_CHANNEL | |
PMT_GROUP_BY_REMITTANCE_MES | |
PMT_GROUP_BY_MAX_DOCUMENTS | |
PMT_GROUP_BY_UNIQUE_REMIT_ID | |
PMT_GROUP_BY_SETTLE_PRIORITY | |
PMT_GROUP_BY_PAYMENT_REASON | |
PMT_GROUP_BY_DUE_DATE_FLAG | |
PMT_MAX_DOCUMENTS_PER_PAYMENT | |
POSITIVE_PAY_FORMAT_CODE | |
PMT_PAYMENT_DETAILS_LENGTH_LIM | |
PMT_PAYMENT_DETAILS_FORMULA | |
INST_GROUP_BY_PAYMENT_DATE | |
INST_GROUP_BY_PAYMENT_CURRENCY | |
INST_GROUP_BY_INT_BANK_ACCT | |
INST_GROUP_BY_MAX_PAYMENTS | |
INST_GROUP_BY_PAY_SERVICE_REQ | |
INST_GROUP_BY_LEGAL_ENTITY | |
INST_GROUP_BY_BILL_PAYABLE | |
INST_GROUP_BY_MAX_INSTRUCTION | |
INST_GROUP_BY_ORGANIZATION | |
PAY_FILE_LETTER_FORMAT_CODE | |
INST_GROUP_BY_PAYMENT_FUNCTION | |
INST_GROUP_BY_PAYMENT_REASON | |
INST_GROUP_BY_RFC | |
INST_MAX_PAYMENTS_PER_INSTR | |
INST_MAX_AMOUNT_PER_INSTR_VAL | |
INST_MAX_AMOUNT_PER_INSTR_CURR | |
INST_MAX_AMOUNT_FX_RATE_TYPE | |
INST_SORT_OPTION_1 | |
INST_SORT_ORDER_1 | |
INST_SORT_OPTION_2 | |
PRINT_INSTRUCTION_IMMED_FLAG | |
INST_SORT_ORDER_2 | |
INST_SORT_OPTION_3 | |
INST_SORT_ORDER_3 | |
REMIT_DOCUMENT_COUNT_LIMIT | |
REMIT_ALLOW_MULTIPLE_COPY_FLAG | |
REMIT_PMT_DETAILS_LENGTH_LIM | |
REMIT_REMITTANCE_ADVICE_FORMAT | |
REMIT_SRA_OVERRIDE_PAYEE_FLAG | |
REMIT_ADVICE_DELIVERY_METHOD | |
REMIT_AUTOMATIC_SRA_SUBMIT | Y or N flag indicating whether the remittance advice should be submitted automatically at payment completion point. |
No hay comentarios:
Publicar un comentario