IBY_PAYMENTS_ALL
IBY_PAYMENTS_ALL stores information on payments. A payment is a single check or fund transfer transaction between first party payer and third party payee. A payment pays one or more documents payable, and there may be one or more payments in a payment instruction. Payments are built by grouping documents payable according to Oracle Payments' grouping rules. This table corresponds to the Payments tab of the Funds Disbursement Process Home.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_PAYMENTS_ALL_PK |
PAYMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_ID | NUMBER | 18 | Yes | System-generated primary key. | |
| INVOICING_LEGAL_ENTITY_ID | NUMBER | 18 | Invoicing legal entity unique identifier. | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Yes | Payment method identifier | |
| PAYMENT_SERVICE_REQUEST_ID | NUMBER | 18 | Yes | Payment process request identifier | |
| PROCESS_TYPE | VARCHAR2 | 30 | Yes | Specifies the process by which the payment is built into a payment instruction. Values, from the lookup IBY_PROCESS_TYPES, include STANDARD, IMMEDIATE, and MANUAL. | |
| PAYMENT_STATUS | VARCHAR2 | 30 | Yes | Payment status. Values, from the lookup IBY_PAYMENT_STATUSES, include CREATED, FORMATTED, TRANSMITTED. | |
| PAYMENTS_COMPLETE_FLAG | VARCHAR2 | 1 | Yes | Yes or No flag indicates if the payment is confirmed | |
| PAYMENT_FUNCTION | VARCHAR2 | 30 | Yes | Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others. | |
| PAYMENT_AMOUNT | NUMBER | Yes | Amount of the payment | ||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | 10 | Yes | Currency of the payment | |
| BILL_PAYABLE_FLAG | VARCHAR2 | 1 | Yes | Yes or No flag indicating whether a payment is a bill payable. | |
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | 1 | Yes | Yes or No flag indicating whether this payment contains a document payable for which the EXCLUSIVE_PAYMENT_FLAG was Yes. | |
| SEPARATE_REMIT_ADVICE_REQ_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether a separate remittance advice needs to be generated for a payment. By default, this flag is set to N. | |
| INTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | Yes | Internal bank account identifier | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| ORG_TYPE | VARCHAR2 | 30 | Yes | Organization type, such as business unit. Values taken from lookup: IBY_ORGANIZATION_TYPES | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Legal entity identifier | |
| DECLARE_PAYMENT_FLAG | VARCHAR2 | 1 | Yes | Yes or No flag that indicates whether this payment needs to be reported to the central bank. Applicable only when DECLARATION_OPTION for regulatory reporting is set to DECLARE_DIRECT_TO_CENTRAL_BANK. | |
| DELIVERY_CHANNEL_CODE | VARCHAR2 | 30 | Delivery channel code for the payment, updated only when the payment s are grouped by delivery channel. | ||
| EXT_PAYEE_ID | NUMBER | 18 | Yes | External payee identifier | |
| PAYMENT_INSTRUCTION_ID | NUMBER | 18 | Payment instruction identifier | ||
| PAYMENT_PROFILE_ID | NUMBER | 18 | Yes | Payment process profile identifier | |
| PREGROUPED_PAYMENT_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether this payment was grouped by the calling application. If the value is Y, all the documents of this payment will contain a non-null value for the payment grouping number attribute. | |
| STOP_CONFIRMED_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether a stop has been confirmed on this payment. | |
| STOP_RELEASED_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether a stop request has been released on this payment. | |
| STOP_REQUEST_PLACED_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether a stop request has been placed on this payment. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| PAYEE_PARTY_ID | NUMBER | 18 | TCA party identifier | ||
| PARTY_SITE_ID | NUMBER | 18 | Payee party site identifier | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Supplier site identifier | ||
| PAYMENT_REASON_CODE | VARCHAR2 | 30 | Payment reason code | ||
| PAYMENT_REASON_COMMENTS | VARCHAR2 | 240 | Free text field available for entering a reason for the payment | ||
| PAYMENT_DATE | DATE | Payment date | |||
| ANTICIPATED_VALUE_DATE | DATE | Anticipated value date | |||
| DECLARATION_AMOUNT | NUMBER | Sum of all reporting amounts from the documents that constitute this payment. This amount will be in the declaration or reporting currency. | |||
| DECLARATION_CURRENCY_CODE | VARCHAR2 | 10 | Currency of the declaration amount | ||
| DISCOUNT_AMOUNT_TAKEN | NUMBER | Discount amount in payment currency | |||
| PAYMENT_DETAILS | VARCHAR2 | 4000 | Concatenated string that represents the payment details | ||
| BANK_CHARGE_BEARER | VARCHAR2 | 30 | Party that is responsible for paying regular or express bank charges, such as Payee or Payer. Values taken from lookup: IBY_BANK_CHARGE_BEARER | ||
| BANK_CHARGE_AMOUNT | NUMBER | Bank charge amount in the payment currency | |||
| SETTLEMENT_PRIORITY | VARCHAR2 | 30 | Priority with which the financial institution or payment system settles payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY. | ||
| REMITTANCE_MESSAGE1 | VARCHAR2 | 150 | Remittance message for use in payment processing | ||
| REMITTANCE_MESSAGE2 | VARCHAR2 | 150 | Remittance message for use in payment processing | ||
| REMITTANCE_MESSAGE3 | VARCHAR2 | 150 | Remittance message for use in payment processing | ||
| PAYMENT_REFERENCE_NUMBER | NUMBER | 18 | User and bank facing number identifying the payment | ||
| PAPER_DOCUMENT_NUMBER | NUMBER | 18 | Payment document number if a printed payment | ||
| BANK_ASSIGNED_REF_CODE | VARCHAR2 | 30 | Payment system-provided reference code for this payment | ||
| EXTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | External bank account identifier | ||
| UNIQUE_REMITTANCE_IDENTIFIER | VARCHAR2 | 256 | Unique remittance Identifier provided by the payee | ||
| URI_CHECK_DIGIT | VARCHAR2 | 2 | Unique remittance identifier check digit | ||
| BANK_INSTRUCTION1_CODE | VARCHAR2 | 30 | Code of first bank instruction, from the payment process profile | ||
| BANK_INSTRUCTION2_CODE | VARCHAR2 | 30 | Code of second bank instruction, from the payment process profile | ||
| BANK_INSTRUCTION_DETAILS | VARCHAR2 | 255 | Additional bank instruction details from the payment process profile | ||
| PAYMENT_TEXT_MESSAGE1 | VARCHAR2 | 150 | Text message for use in payment processing | ||
| PAYMENT_TEXT_MESSAGE2 | VARCHAR2 | 150 | Text message for use in payment processing | ||
| PAYMENT_TEXT_MESSAGE3 | VARCHAR2 | 150 | Text message for use in payment processing | ||
| MATURITY_DATE | DATE | Calculated maturity date on a bill payable payment | |||
| PAYMENT_DUE_DATE | DATE | Date on which the payment is made | |||
| DOCUMENT_CATEGORY_CODE | VARCHAR2 | 30 | Document category for sequential numbering | ||
| DOCUMENT_SEQUENCE_ID | NUMBER | Document sequence identifier from sequential numbering | |||
| DOCUMENT_SEQUENCE_VALUE | NUMBER | Document sequence value from sequential numbering | |||
| BENEFICIARY_PARTY | NUMBER | 18 | Beneficiary party, if payment is made through a third party | ||
| STOP_CONFIRMED_BY | VARCHAR2 | 64 | The user who confirmed the stop. | ||
| STOP_CONFIRM_DATE | DATE | Date on which the stop was confirmed. | |||
| STOP_CONFIRM_REASON | VARCHAR2 | 240 | Reason for confirming the stop. | ||
| STOP_CONFIRM_REFERENCE | VARCHAR2 | 100 | Payment system reference code for the confirmed stop payment. | ||
| STOP_RELEASED_BY | VARCHAR2 | 64 | The user who released the stop request. | ||
| STOP_RELEASE_DATE | DATE | Date on which the stop request was released. | |||
| STOP_RELEASE_REASON | VARCHAR2 | 240 | Reason for releasing the stop request. | ||
| STOP_RELEASE_REFERENCE | VARCHAR2 | 100 | Payment system reference code for releasing or denying the stop request. | ||
| STOP_REQUEST_DATE | DATE | Date on which the stop request was placed. | |||
| STOP_REQUEST_PLACED_BY | VARCHAR2 | 64 | The user who placed the stop request. | ||
| STOP_REQUEST_REASON | VARCHAR2 | 240 | Reason for placing the stop request. | ||
| STOP_REQUEST_REFERENCE | VARCHAR2 | 100 | Payment system reference code for the stop request. | ||
| VOIDED_BY | VARCHAR2 | 64 | The user who voided the payment. | ||
| VOID_DATE | DATE | Date on which the payment was voided. | |||
| VOID_REASON | VARCHAR2 | 240 | Reason for voiding the payment. | ||
| REMIT_TO_LOCATION_ID | NUMBER | 18 | Remit-To address identifier | ||
| COMPLETED_PMTS_GROUP_ID | NUMBER | 18 | The identifier of a group of payments, including this one, which were confirmed. Value is from sequence IBY_COMPLETED_PMTS_GROUP_S. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| EXT_BRANCH_NUMBER | VARCHAR2 | 30 | Payee bank routing number (branch number), denormalized from CE bank branches view | ||
| EXT_BANK_NUMBER | VARCHAR2 | 30 | Payee bank number, denormalized from CE bank branches view | ||
| EXT_BANK_ACCOUNT_NAME | VARCHAR2 | 80 | Payee bank account name, denormalized from CE bank branches view | ||
| EXT_BANK_ACCOUNT_NUMBER | VARCHAR2 | 100 | Masked payee bank account number, denormalized from CE bank accounts view | ||
| EXT_BANK_ACCOUNT_TYPE | VARCHAR2 | 25 | Payee bank account type, denormalized from CE bank accounts view | ||
| EXT_BANK_ACCOUNT_IBAN_NUMBER | VARCHAR2 | 50 | Masked payee bank account IBAN, denormalized from CE bank accounts view | ||
| PAYEE_NAME | VARCHAR2 | 360 | Name of payee, if provided by administrator | ||
| PAYEE_ADDRESS1 | VARCHAR2 | 240 | First line for payee address, if provided by administrator | ||
| PAYEE_ADDRESS2 | VARCHAR2 | 240 | Second line for payee address, if provided by administrator | ||
| PAYEE_ADDRESS3 | VARCHAR2 | 240 | Third line for payee address, if provided by administrator | ||
| PAYEE_ADDRESS4 | VARCHAR2 | 240 | Fourth line for payee address, if provided by administrator | ||
| PAYEE_CITY | VARCHAR2 | 60 | Payee city, if provided by administrator | ||
| PAYEE_POSTAL_CODE | VARCHAR2 | 60 | Payee postal code, if provided by administrator | ||
| PAYEE_STATE | VARCHAR2 | 120 | Payee state, if provided by administrator | ||
| PAYEE_PROVINCE | VARCHAR2 | 120 | Payee province, if provided by administrator | ||
| PAYEE_COUNTY | VARCHAR2 | 120 | Payee county, if provided by administrator | ||
| PAYEE_COUNTRY | VARCHAR2 | 60 | Payee country code, if provided by administrator | ||
| REMIT_ADVICE_DELIVERY_METHOD | VARCHAR2 | 100 | How the remittance advice, if any, is delivered using values from lookup type IBY_DELIVERY_METHODS | ||
| REMIT_ADVICE_EMAIL | VARCHAR2 | 255 | E-mail address to which the remittance advice is delivered | ||
| REMIT_ADVICE_FAX | VARCHAR2 | 100 | Fax number to which the remittance advice is delivered | ||
| PAYMENT_PROFILE_SYS_NAME | VARCHAR2 | 100 | Denormalized from IBY_SYS_PMT_PROFILES and derived via PAYMENT_PROFILE_ ID | ||
| PAYMENT_PROFILE_ACCT_NAME | VARCHAR2 | 100 | Denormalized from IBY_ACCT_PMT_PROFILES and derived via PAYMENT_PROFILE_ ID | ||
| PAYMENT_PROCESS_REQUEST_NAME | VARCHAR2 | 255 | Denormalized from IBY_PAY_SERVICE_REQUESTS.CALL_APP_PAY_SERVICE_REQ_CODE and derived via PAYMENT_SERVICE_REQUEST_ID | ||
| SOURCE_PRODUCT | VARCHAR2 | 50 | Denormalized from product name for product determined by IBY_PAY_SERVICE_REQUESTS. CALLING_APP_ID; derive via PAYMENT_SERVICE_REQUEST_ID | ||
| PAYMENT_REASON_FORMAT_VALUE | VARCHAR2 | 80 | Payment reason value that is put into the extract for use by the format | ||
| DECLARATION_EXCH_RATE_TYPE | VARCHAR2 | 255 | Exchange rate type used for regulatory reporting. | ||
| DECLARATION_FORMAT | VARCHAR2 | 100 | Format used for regulatory reporting. | ||
| DELIVERY_CHANNEL_FORMAT_VALUE | VARCHAR2 | 80 | An alias for delivery channel code that is put into the extract for optional use by the format. | ||
| BANK_INSTRUCTION1_FORMAT_VALUE | VARCHAR2 | 80 | Bank instruction value that is put into the extract for use by the format | ||
| BANK_INSTRUCTION2_FORMAT_VALUE | VARCHAR2 | 80 | Bank instruction value that is put into the extract for use by the format | ||
| SRA_DELIVERY_METHOD | VARCHAR2 | 100 | Denormalized from IBY_REMIT_ADVICE_SETUP.REMIT_ADVICE_ DELIVERY_METHOD and derived via payment process profile. | ||
| INT_BANK_NAME | VARCHAR2 | 360 | Disbursement bank account name, denormalized from HZ_PARTIES.PARTY_NAME and derived via INTERNAL_BANK_ACCOUNT_ID | ||
| INT_BANK_NUMBER | VARCHAR2 | 30 | Denormalized from TCA; derived via INTERNAL_BANK_ACCOUNT_ID | ||
| INT_BIC | VARCHAR2 | 30 | Bank identification code for disbursement bank account | ||
| INT_BANK_BRANCH_NAME | VARCHAR2 | 360 | Denormalized from TCA; derived via INTERNAL_BANK_ACCOUNT_ID | ||
| INT_BANK_BRANCH_NUMBER | VARCHAR2 | 30 | Denormalized from TCA; derived via INTERNAL_BANK_ACCOUNT_ID | ||
| INT_BANK_ACCOUNT_NAME | VARCHAR2 | 360 | Denormalized from CE; derived via INTERNAL_BANK_ACCOUNT_ID | ||
| INT_BANK_ACCOUNT_NUMBER | VARCHAR2 | 30 | Denormalized from CE; derived via INTERNAL_BANK_ACCOUNT_ID | ||
| INT_BANK_ACCOUNT_IBAN | VARCHAR2 | 50 | Denormalized from CE; derived via INTERNAL_BANK_ACCOUNT_ID | ||
| EXT_BANK_NAME | VARCHAR2 | 360 | Payee bank name denormalized from IBY_EXT_BANK_ACCOUNTS_V. BANK_NAME and derived via EXTERNAL_BANK_ACCOUNT_ID | ||
| EXT_BIC | VARCHAR2 | 30 | Bank identification code for payee bank account | ||
| EXT_BANK_BRANCH_NAME | VARCHAR2 | 360 | Denormalized from IBY_EXT_BANK_ACCOUNTS_V. BANK_BRANCH_NAME; derived via EXTERNAL_BANK_ACCOUNT_ID | ||
| ORG_NAME | VARCHAR2 | 240 | Business unit name, denormalized from HR_ALL_ORGANIZATION_UNITS.NAME and derived via ORG_ID. | ||
| LEGAL_ENTITY_NAME | VARCHAR2 | 240 | Legal entity name. | ||
| PAYER_LE_REGISTRATION_NUM | VARCHAR2 | 240 | Legal registration number of the legal entity making the disbursement | ||
| PAYER_TAX_REGISTRATION_NUM | VARCHAR2 | 50 | Tax registration number of the legal entity making the disbursement | ||
| PAYEE_PARTY_NAME | VARCHAR2 | 360 | Denormalized from HZ_PARTIES.PARTY_NAME; derived via PAYEE_PARTY_ID | ||
| PAYEE_LE_REGISTRATION_NUM | VARCHAR2 | 50 | Legal registration number of the legal entity receiving the disbursement | ||
| PAYEE_TAX_REGISTRATION_NUM | VARCHAR2 | 50 | Tax registration number of the legal entity receiving the disbursement | ||
| PAYEE_TAX_REGISTRATION_TYPE | VARCHAR2 | 30 | Tax registration type of the legal entity receiving the disbursement | ||
| PARTY_SITE_NAME | VARCHAR2 | 240 | Party site name | ||
| PAYEE_ADDRESS_CONCAT | VARCHAR2 | 2000 | Concatenated denormalization from standard address fields HZ_LOCATIONS; derived via PARTY_SITE_ID. | ||
| BENEFICIARY_NAME | VARCHAR2 | 360 | Beneficiary name, denormalized from HZ_PARTIES.PARTY_NAME and derived via BENEFICIARY_PARTY_ID | ||
| BENEFICIARY_SITE_ID | NUMBER | 18 | Beneficiary party site identifier | ||
| BENEFICIARY_SITE_NAME | VARCHAR2 | 240 | Beneficiary party site name | ||
| BENEFICIARY_ADDRESS | VARCHAR2 | 2000 | Beneficiary party, if payment is made through a third party | ||
| INT_EFT_SWIFT_CODE | VARCHAR2 | 30 | SWIFT code of the payer's bank | ||
| EXT_EFT_SWIFT_CODE | VARCHAR2 | 30 | SWIFT code of the payee's bank | ||
| PAYER_LEGAL_ENTITY_NAME | VARCHAR2 | 240 | Name of the legal entity making the disbursement | ||
| PAYER_PARTY_SITE_NAME | VARCHAR2 | 240 | Payer party site name | ||
| PAYER_PARTY_NUMBER | VARCHAR2 | 30 | Payer party number | ||
| PAYEE_PARTY_NUMBER | VARCHAR2 | 30 | Payee party number | ||
| PAYEE_ALTERNATE_NAME | VARCHAR2 | 360 | Payee party alternate name | ||
| PAYEE_SITE_ALTERNATE_NAME | VARCHAR2 | 320 | Payee party site alternate name | ||
| PAYEE_SUPPLIER_NUMBER | VARCHAR2 | 30 | Supplier number | ||
| PAYEE_FIRST_PARTY_REFERENCE | VARCHAR2 | 30 | Payee first party reference | ||
| INT_BANK_BRANCH_RFC_IDENTIFIER | VARCHAR2 | 30 | Internal bank branch RFC identifier | ||
| INT_BANK_ACCT_AGENCY_LOC_CODE | VARCHAR2 | 30 | Auditing column for the corresponding value in CE_BANK_ACCOUNTS.AGENCY_LOCATION_CODE | ||
| PAYER_ABBREVIATED_AGENCY_CODE | VARCHAR2 | 30 | Agency Location Code used by federal agencies | ||
| PAYER_FEDERAL_US_EMPLOYER_ID | VARCHAR2 | 20 | Employer identifier used by federal agencies | ||
| EXT_BANK_ACCT_OWNER_PARTY_ID | VARCHAR2 | 360 | Identifier of the bank branch of the payee | ||
| EXT_BANK_ACCT_PMT_FACTOR_FLAG | VARCHAR2 | 1 | Identifier of the bank branch of the payee | ||
| ADDRESS_SOURCE | VARCHAR2 | 30 | Source of the address. Possible values from the lookup IBY_ADDRESS_SOURCE_TYPES include TCA and HR. | ||
| EMPLOYEE_ADDRESS_CODE | VARCHAR2 | 30 | Type of address. Possible values include HOME and OFFICE. | ||
| EMPLOYEE_PERSON_ID | NUMBER | 18 | Employee person Identifier | ||
| EMPLOYEE_PAYMENT_FLAG | VARCHAR2 | 1 | Y or N flag indicating whether the payment is of the employee payment type | ||
| EMPLOYEE_ADDRESS_ID | NUMBER | 18 | HR Identifier of the address | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| EXT_BANK_BRANCH_PARTY_ID | NUMBER | Identifier of the bank branch of the payee | |||
| EXT_BANK_ALT_NAME | VARCHAR2 | 320 | Alternate name of the bank of the payee | ||
| EXT_BANK_BRANCH_ALT_NAME | VARCHAR2 | 320 | Alternate name of the bank branch of the payee | ||
| EXT_BANK_ACCOUNT_ALT_NAME | VARCHAR2 | 320 | Alternate name of the bank account of the payee | ||
| EXT_BANK_ACCOUNT_NUM_ELEC | VARCHAR2 | 100 | Auditing column for the corresponding value in IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELEC | ||
| EXT_BANK_BRANCH_LOCATION_ID | NUMBER | Identifier of the address of the bank branch of the payee | |||
| EXT_BANK_ACCT_OWNER_PARTY_NAME | VARCHAR2 | 360 | Name of the account owner of the payee bank account | ||
| INT_BANK_BRANCH_PARTY_ID | NUMBER | Identifier of the bank branch of the payer | |||
| INT_BANK_ALT_NAME | VARCHAR2 | 360 | Alternate name of the bank of the payer | ||
| INT_BANK_BRANCH_ALT_NAME | VARCHAR2 | 360 | Alternate name of the bank branch of the payer | ||
| INT_BANK_ACCOUNT_ALT_NAME | VARCHAR2 | 320 | Alternate name of the bank account of the payer | ||
| INT_BANK_ACCOUNT_NUM_ELEC | VARCHAR2 | 100 | Auditing column for the corresponding value in CE_BANK_ACCOUNTS.EFT_USER_NUM | ||
| INT_BANK_BRANCH_LOCATION_ID | NUMBER | Identifier of the address of the bank branch of the payer | |||
| INT_BANK_BRANCH_EFT_USER_NUM | VARCHAR2 | 30 | Auditing column for the corresponding value in CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC | ||
| PAYER_PARTY_ID | NUMBER | Identifier of the supplier party | |||
| PAYER_LOCATION_ID | NUMBER | Identifier of the supplier party address | |||
| PAYER_PARTY_ATTR_CATEGORY | VARCHAR2 | 150 | Payer party attribute category | ||
| PAYER_LE_ATTR_CATEGORY | VARCHAR2 | 150 | Payer party legal entity attribute category | ||
| PAYEE_PARTY_ATTR_CATEGORY | VARCHAR2 | 150 | Payer party legal entity attribute category | ||
| PAYEE_SUPPLIER_ATTR_CATEGORY | VARCHAR2 | 150 | Payer party supplier attribute category | ||
| PAYEE_SPPLR_SITE_ATTR_CATEGORY | VARCHAR2 | 150 | Payer partysupplier site attribute category | ||
| PAYEE_SUPPLIER_SITE_NAME | VARCHAR2 | 240 | Supplier site name | ||
| PAYEE_SUPPLIER_SITE_ALT_NAME | VARCHAR2 | 320 | Supplier site alternate name | ||
| PAYEE_SUPPLIER_ID | NUMBER | Supplier alternate name | |||
| LOGICAL_GROUP_REFERENCE | VARCHAR2 | 30 | If not null, this column indicates that this payment is part of a logical group of payments. It is in the format of [PAYMENT_INSTRUCTION_ID]_COUNT. | ||
| INVOICING_ORG_ID | NUMBER | 18 | Invoicing Business Unit | ||
| INVOICING_ORG_TYPE | VARCHAR2 | 30 | Invoicing Organiztion Type | ||
| SRA_CREATED | VARCHAR2 | 1 | Y or N flag indicating if the separate remittance advice has been printed or delivered for this payment | ||
| SERVICE_LEVEL_CODE | VARCHAR2 | 30 | The service level with which a payment is processed. | ||
| POSITIVE_PAY_FILE_CREATED_FLAG | VARCHAR2 | 1 | Y or N flag indicates whether a positive pay file has been created for a payment. By default, this flag is set to N. | ||
| INV_EXT_PAYEE_ID | NUMBER | 18 | External payee associated with the invoice supplier | ||
| INV_PAYEE_PARTY_ID | NUMBER | 18 | Party identifier of the supplier that sends the invoice. | ||
| INV_PARTY_SITE_ID | NUMBER | 18 | Party site identifier associated with the supplier. | ||
| INV_SUPPLIER_SITE_ID | NUMBER | 18 | Supplier site identifier of the supplier that sends the invoice. | ||
| INV_PAYEE_PARTY_NUMBER | VARCHAR2 | 30 | Party number of the supplier that sends the invoice. | ||
| INV_PAYEE_SUPPLIER_ID | NUMBER | 18 | Supplier identifier of the supplier that sends the invoice. | ||
| INV_PAYEE_SUPPLIER_NUMBER | VARCHAR2 | 30 | Supplier number of the supplier that sends the invoice. | ||
| INV_PAYEE_PARTY_NAME | VARCHAR2 | 360 | Payee name of the supplier that sends the invoice. | ||
| INV_PAYEE_ALTERNATE_NAME | VARCHAR2 | 360 | Alternate name of the supplier that sends the invoice. | ||
| INV_PAYEE_SITE_ALT_NAME | VARCHAR2 | 360 | Alternate site name of the supplier that sends the invoice. | ||
| INV_PAYEE_SUPPLIER_SITE_NAME | VARCHAR2 | 240 | Site name of the supplier that sends the invoice. | ||
| INV_PAYEE_SPPLR_SITE_ALT_NAME | VARCHAR2 | 360 | Alternate site name of the supplier that sends the invoice. | ||
| INV_PAYEE_ADDRESS1 | VARCHAR2 | 240 | First address line of the supplier that sends the invoice. | ||
| INV_PAYEE_ADDRESS2 | VARCHAR2 | 240 | Second address line of the supplier that sends the invoice. | ||
| INV_PAYEE_ADDRESS3 | VARCHAR2 | 240 | Third address line of the supplier that sends the invoice. | ||
| INV_PAYEE_ADDRESS4 | VARCHAR2 | 240 | Fourth address line of the supplier that sends the invoice. | ||
| INV_PAYEE_CITY | VARCHAR2 | 60 | City name of the supplier address that sends the invoice. | ||
| INV_PAYEE_POSTAL_CODE | VARCHAR2 | 60 | Postal code of the supplier address that sends the invoice. | ||
| INV_PAYEE_STATE | VARCHAR2 | 120 | State name of the supplier address that sends the invoice. | ||
| INV_PAYEE_PROVINCE | VARCHAR2 | 120 | Province name of the supplier that sends the invoice. | ||
| INV_PAYEE_COUNTY | VARCHAR2 | 120 | County name of the supplier that sends the invoice. | ||
| INV_PAYEE_COUNTRY | VARCHAR2 | 60 | Country name of the supplier that sends the invoice. | ||
| INV_PAYEE_ADDRESS_CONCAT | VARCHAR2 | 1000 | Concatenated standard address fields of the supplier that sends the invoice. | ||
| INV_PAYEE_LE_REG_NUM | VARCHAR2 | 50 | Legal registration number of the supplier that sends the invoice. | ||
| INV_PAYEE_TAX_REG_NUM | VARCHAR2 | 50 | Tax registration number of the supplier that sends the invoice. | ||
| INV_PAYEE_TAX_REG_TYPE | VARCHAR2 | 30 | Tax registration type of the supplier that sends the invoice. | ||
| INV_PAYEE_FIRST_PARTY_REF | VARCHAR2 | 30 | Customer number with the supplier that sends the invoice. | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Ledger identifier for the invoice. | ||
| DATA_SET_ID | NUMBER | 18 | Unique sequence generated by Budgetary Control for every budget control call. | ||
| FUNDS_STATUS_CODE | VARCHAR2 | 30 | Funds status of the budget controlled payments. | ||
| INBOUND_FILE_ID | NUMBER | 18 | Identifier of the inbound payment file. | ||
| ACKNOWLEDGEMENT_DATE | DATE | Date when acknowledgment file was processed. | |||
| BEP_STATUS | VARCHAR2 | 30 | Status returned by the bank or payment system. | ||
| BEP_ERROR_CODE | VARCHAR2 | 30 | Error code from bank or payment system. | ||
| BEP_ERROR_MESSAGE_TEXT | VARCHAR2 | 255 | Error message from bank or payment system. | ||
| PAYMENT_MODE_CODE | VARCHAR2 | 30 | Invoice payment mode identifier. | ||
| PAYMENT_INSTRUMENT_ID | NUMBER | 18 | Funding instrument used for making payments. | ||
| BEP_TRXN_RESPONSE_ID | VARCHAR2 | 60 | Response identifier generated by payment system for a payment request. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_PAYMENTS_ALL | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| IBY_PAYMENTS_ALL | iby_acct_pmt_profiles_b | PAYMENT_PROFILE_ID |
| IBY_PAYMENTS_ALL | iby_pay_service_requests | PAYMENT_SERVICE_REQUEST_ID |
| IBY_PAYMENTS_ALL | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
| IBY_PAYMENTS_ALL | iby_external_payees_all | EXT_PAYEE_ID |
| IBY_PAYMENTS_ALL | ce_bank_accounts | EXTERNAL_BANK_ACCOUNT_ID |
| IBY_PAYMENTS_ALL | ce_bank_accounts | INTERNAL_BANK_ACCOUNT_ID |
| ap_checks_all | iby_payments_all | PAYMENT_ID |
| ap_checks_all | iby_payments_all | COMPLETED_PMTS_GROUP_ID |
| iby_status_overrides | iby_payments_all | PAYMENT_ID |
| jl_br_ap_bank_returns_all | iby_payments_all | PAYMENT_ID |
| iby_documents_payable_h | iby_payments_all | PAYMENT_ID |
| iby_docs_payable_all | iby_payments_all | FORMATTING_PAYMENT_ID |
| iby_docs_payable_all | iby_payments_all | PAYMENT_ID |
| ap_history_checks_all | iby_payments_all | PAYMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_PAYMENTS_ALL_N1 | Non Unique | Default | PAYMENT_PROFILE_ID |
| IBY_PAYMENTS_ALL_N10 | Non Unique | Default | COMPLETED_PMTS_GROUP_ID, ORG_ID, ORG_TYPE |
| IBY_PAYMENTS_ALL_N11 | Non Unique | Default | PAYMENT_INSTRUCTION_ID, PAPER_DOCUMENT_NUMBER |
| IBY_PAYMENTS_ALL_N12 | Non Unique | Default | PAYMENT_REFERENCE_NUMBER |
| IBY_PAYMENTS_ALL_N13 | Non Unique | Default | DOCUMENT_CATEGORY_CODE, DOCUMENT_SEQUENCE_ID, DOCUMENT_SEQUENCE_VALUE |
| IBY_PAYMENTS_ALL_N14 | Non Unique | Default | PAYEE_PARTY_ID |
| IBY_PAYMENTS_ALL_N2 | Non Unique | Default | PAYMENT_SERVICE_REQUEST_ID, PAYMENT_INSTRUCTION_ID |
| IBY_PAYMENTS_ALL_N3 | Non Unique | Default | PAYMENT_REASON_CODE |
| IBY_PAYMENTS_ALL_N4 | Non Unique | Default | DELIVERY_CHANNEL_CODE |
| IBY_PAYMENTS_ALL_N5 | Non Unique | Default | PAYMENT_DATE |
| IBY_PAYMENTS_ALL_N6 | Non Unique | Default | EXT_PAYEE_ID |
| IBY_PAYMENTS_ALL_N7 | Non Unique | Default | EXTERNAL_BANK_ACCOUNT_ID |
| IBY_PAYMENTS_ALL_N8 | Non Unique | Default | INTERNAL_BANK_ACCOUNT_ID |
| IBY_PAYMENTS_ALL_N9 | Non Unique | Default | PAYMENT_STATUS |
| IBY_PAYMENTS_ALL_U1 | Unique | Default | PAYMENT_ID |