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 payment can exist in this table. These snapshots are differentiated by the table's primary key and a snapshot date.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_PAYMENTS_H_PK |
PAYMENT_HISTORY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_HISTORY_ID | NUMBER | 18 | Yes | System-generated primary key. | |
| PAYMENT_HISTORY_DATE | DATE | Yes | Payment snapshot date | ||
| PAYMENT_INSTRUCTION_HISTORY_ID | NUMBER | 18 | Yes | Associated payment instruction snapshot Identifier | |
| PAYMENT_ID | NUMBER | 18 | Yes | Payment Identifier | |
| PROCESSING_TYPE | VARCHAR2 | 30 | Yes | Specifies the type of processing from the payment process profile. Values from the lookup IBY_PROCESSING_TYPES include ELECTRONIC and PRINTED. | |
| 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. | |
| PAYMENTS_COMPLETE_FLAG | VARCHAR2 | 1 | Yes | Y or N flag indicating whether the payment has been marked as complete. | |
| 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_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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| DECLARATION_OPTION | VARCHAR2 | 30 | Specifies the customer's chosen declaration option from the payment process profile | ||
| DCL_ONLY_FOREIGN_CURR_PMT_FLAG | VARCHAR2 | 1 | Used in upgrade. | ||
| DECLARATION_REPORT_FORMAT_CODE | VARCHAR2 | 30 | Format to be used for regulatory reporting. Applicable only if the DECLARATION_OPTION is set to DECLARE_DIRECT_TO_CENTRAL_BANK. | ||
| DECLARATION_CURR_FX_RATE_TYPE | VARCHAR2 | 255 | Indicates the type of exchange rate from the payment process profile | ||
| DECLARATION_CURRENCY_CODE | VARCHAR2 | 10 | Currency of the declaration amount | ||
| DECLARATION_THRESHOLD_AMOUNT | NUMBER | From the payment process profile, the threshold amount above which the payment needs to be reported to the central bank | |||
| PAYMENT_DETAILS_FORMULA | VARCHAR2 | 240 | From the payment process profile, SQL function used to concatenate the document attributes into the payment details information | ||
| BANK_INSTRUCTION1_CODE | VARCHAR2 | 30 | Yes | Code of first bank instruction, from the payment process profile | |
| BANK_INSTRUCTION2_CODE | VARCHAR2 | 30 | Yes | 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 | From the payment process profile, text message for use in payment processing. | ||
| PAYMENT_TEXT_MESSAGE2 | VARCHAR2 | 150 | From the payment process profile, text message for use in payment processing. | ||
| 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_INSTRUCTION_ID | NUMBER | 18 | Yes | Payment instruction Identifier | |
| PAYMENT_STATUS | VARCHAR2 | 30 | Yes | Payment status. Values from the lookup IBY_PAYMENT_STATUSES include CREATED, FORMATTED, and TRANSMITTED. | |
| 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_REASON_CODE | VARCHAR2 | 30 | Yes | Payment reason code | |
| PAYMENT_REASON_COMMENTS | VARCHAR2 | 240 | Yes | Free text field available for entering a reason for the payment | |
| PAYMENT_DATE | DATE | Payment date | |||
| ANTICIPATED_VALUE_DATE | DATE | Anticipated value date | |||
| PAYMENT_AMOUNT | NUMBER | Yes | Amount of the payment | ||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | 10 | Yes | Currency of the payment | |
| MATURITY_DATE | DATE | Calculated maturity date on a bill payable payment | |||
| PAYMENT_DUE_DATE | DATE | Date on which the payment is made | |||
| DECLARE_PAYMENT_FLAG | VARCHAR2 | 1 | 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. | ||
| DECLARATION_AMOUNT | NUMBER | Sum of all reporting amounts from the documents that constitute this payment. This amount is in the declaration or reporting currency | |||
| DISCOUNT_AMOUNT_TAKEN | NUMBER | Discount amount, in payment currency | |||
| PAYMENT_DETAILS | VARCHAR2 | 240 | 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 | |||
| DELIVERY_FORMAT_VALUE | VARCHAR2 | 80 | Yes | An alias for delivery channel code that is put into the extract for optional use by the format. | |
| 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 | ||
| 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 | ||
| INT_BANK_ACCOUNT_NUMBER | VARCHAR2 | 30 | Internal bank account number from CE bank accounts | ||
| INT_BANK_ACCOUNT_ROUTING_NUM | VARCHAR2 | 30 | Internal bank account routing number from CE bank accounts | ||
| INT_BANK_ACCOUNT_IBAN_NUMBER | VARCHAR2 | 50 | Internal bank account IBAN number from CE bank accounts | ||
| EXT_BANK_ACCOUNT_NUMBER | VARCHAR2 | 30 | External bank account number from IBY bank accounts | ||
| EXT_BANK_ACCOUNT_ROUTING_NUM | VARCHAR2 | 30 | External bank account routing number from CE bank accounts | ||
| EXT_BANK_ACCOUNT_BANK_NAME | VARCHAR2 | 360 | Internal bank account bank name from IBY bank accounts | ||
| EXT_BANK_ACCOUNT_BRANCH_NAME | VARCHAR2 | 360 | Internal bank account branch name from IBY bank accounts | ||
| EXT_BANK_ACCOUNT_BRANCH_NUMBER | VARCHAR2 | 30 | Internal bank account branch number from IBY bank accounts | ||
| EXT_BANK_ACCOUNT_IBAN_NUMBER | VARCHAR2 | 50 | Internal bank account IBAN number from IBY bank accounts | ||
| EXT_BANK_ACCOUNT_SWIFT_CODE | VARCHAR2 | 30 | Internal bank account SWIFT code from IBY bank accounts | ||
| EXT_PAYEE_ID | NUMBER | 18 | External payee Identifier | ||
| 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 | ||
| BENEFICIARY_PARTY | NUMBER | 18 | Beneficiary party if payment is made through a third party | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| ORG_TYPE | VARCHAR2 | 30 | Organization type, such as business unit. Values taken from lookup: IBY_ORGANIZATION_TYPES | ||
| ORG_NAME | VARCHAR2 | 240 | Yes | Business unit name, denormalized from HR_ALL_ORGANIZATION_UNITS.NAME and derived via ORG_ID. | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Legal entity Identifier | |
| PARTY_NAME | VARCHAR2 | 360 | Party name, denormalized from HZ_PARTIES_ALL.PARTY_NAME and derived via PARTY_ID. | ||
| COUNTRY | VARCHAR2 | 60 | Yes | Country code from the TERRITORY_CODE column in the FND_TERRITORY table from TCA location | |
| ADDRESS1 | VARCHAR2 | 240 | First line for address from TCA location | ||
| ADDRESS2 | VARCHAR2 | 240 | Second line for address from TCA location | ||
| ADDRESS3 | VARCHAR2 | 240 | Third line for address from TCA location | ||
| ADDRESS4 | VARCHAR2 | 240 | Fourth line for address from TCA location | ||
| CITY | VARCHAR2 | 60 | City from TCA location | ||
| POSTAL_CODE | VARCHAR2 | 60 | Postal code from TCA location | ||
| POSTAL_PLUS4_CODE | VARCHAR2 | 10 | Four digit extension to the United States Postal ZIP code from TCA location | ||
| STATE | VARCHAR2 | 60 | State from TCA location | ||
| PROVINCE | VARCHAR2 | 60 | Province from TCA location | ||
| COUNTY | VARCHAR2 | 60 | County from TCA location | ||
| UNIQUE_REMITTANCE_IDENTIFIER | VARCHAR2 | 256 | Unique remittance Identifier provided by the payee | ||
| URI_CHECK_DIGIT | VARCHAR2 | 2 | Unique remittance Identifier check digit | ||
| 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 | |||
| STOP_CONFIRMED_BY | NUMBER | 18 | User who confirmed the stop | ||
| STOP_CONFIRM_DATE | DATE | Date on which the stop was confirmed | |||
| STOP_CONFIRM_REASON | VARCHAR2 | 240 | Reason for confirming the stop | ||
| STOP_CONFIRM_REFERENCE | VARCHAR2 | 100 | Payment system reference code for the confirmed stop payment | ||
| STOP_RELEASED_BY | NUMBER | 18 | User who released the stop request | ||
| STOP_RELEASE_DATE | DATE | Date on which the stop request was released | |||
| STOP_RELEASE_REASON | VARCHAR2 | 240 | Reason for releasing the stop request | ||
| STOP_RELEASE_REFERENCE | VARCHAR2 | 100 | Payment system reference code for releasing or denying the stop request. | ||
| STOP_REQUEST_DATE | DATE | Date on which the stop request was placed | |||
| STOP_REQUEST_PLACED_BY | NUMBER | 18 | User who placed the stop request | ||
| STOP_REQUEST_REASON | VARCHAR2 | 240 | Reason for placing the stop request | ||
| STOP_REQUEST_REFERENCE | VARCHAR2 | 100 | Payment system reference code for the stop request | ||
| VOIDED_BY | NUMBER | 18 | User who voided the payment | ||
| VOID_DATE | DATE | Date on which the payment was voided | |||
| VOID_REASON | VARCHAR2 | 240 | Reason for voiding the payment | ||
| 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. | ||
| INVOICING_ORG_ID | NUMBER | 18 | Invoicing Business Unit | ||
| INVOICING_ORG_TYPE | VARCHAR2 | 30 | Invoicing Organization Type | ||
| 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 | Party 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 of the invoicing supplier. | ||
| INV_PAYEE_POSTAL_CODE | VARCHAR2 | 60 | Postal code of the invoicing supplier. | ||
| INV_PAYEE_STATE | VARCHAR2 | 60 | State of the invoicing supplier. | ||
| 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_FIRST_PARTY_REF | VARCHAR2 | 30 | Customer number with the supplier that sends the invoice. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_PAYMENTS_H | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
| IBY_PAYMENTS_H | iby_pay_service_requests | PAYMENT_SERVICE_REQUEST_ID |
| IBY_PAYMENTS_H | iby_pay_instructions_h | PAYMENT_INSTRUCTION_HISTORY_ID |
| iby_documents_payable_h | iby_payments_h | PAYMENT_HISTORY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_PAYMENTS_H_PK | Unique | Default | PAYMENT_HISTORY_ID |