1. Tables and Views for Financials
  2. JL_BR_AP_BANK_RETURNS_ALL

JL_BR_AP_BANK_RETURNS_ALL

Stores information associated with the payment request for the purchases made by a customer.

Details

  • Schema: FUSION

  • Object owner: JL

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JL_BR_AP_BANK_RETURNS_ALL_PK

BANK_RETURN_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PAYMENT_ID NUMBER 18 A unique identifier that identifies a payment. It is also a foreign key to the IBY_PAYMENTS_ALL table. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
BANK_OCCURRENCE_CODE VARCHAR2 30 Occurrence error details sent by the bank. It is also a foreign key to the JL_BR_AR_BANK_OCCURRENCES table. Active
OCCURRENCE_DATE DATE Occurrence error date sent by the bank. Active
PROCESSING_DATE DATE Date when the bank will process the transaction. For example, the process date is different from the occurrence date for a DOC transaction. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
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. Active
BANK_RETURN_ID NUMBER 18 Yes Value generated during the processing of a payment request. It is passed to bank in a payment request file. It is also used to uniquely refer individual payment requests. Active
PAYMENT_INSTRUCTION_ID NUMBER 18 A unique identifier that identifies a payment instruction. It is also a foreign key to the IBY_PAY_INSTRUCTIONS_ALL table. Active
DOCUMENT_PAYABLE_ID NUMBER 18 A unique identifier that identifies a payment document. It is also a foreign key to the IBY_DOCS_PAYABLE_ALL table. Active
BANK_PARTY_ID NUMBER 18 Identifier for a bank party on a bank payment. Active
PAYMENT_AMOUNT NUMBER Indicates the payment amount sent to bank. Active
RETURN_STATUS_CODE VARCHAR2 30 Status of the return received from the bank. Active
PAYMENT_TYPE_CODE VARCHAR2 30 Type of payment transaction, such as DOC, TED, and collection document. Active
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.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
TAX_AUTHORITY_DOC_NUMBER VARCHAR2 120 Indicates the unique identifier of the document provided by the tax authority.
CITY_TAX_AMOUNT NUMBER The installment tax amount for city-level taxes levied on goods and services.
STATE_TAX_AMOUNT NUMBER The installment tax amount for state-level taxes levied on goods and services.
COUNTRY_TAX_AMOUNT NUMBER The installment tax amount for country-level taxes levied on goods and services.
EXCISE_TAX_AMOUNT NUMBER The installment tax amount for excise taxes that are levied on specific goods and services.
BANK_AUTHORIZATION_REF_NUMBER VARCHAR2 150 Indicates the authorization reference number provided by the bank when the payment is processed by the bank.
ERROR_DETAIL_CODE VARCHAR2 30 Indicates the error detail code assigned by the bank to identify the cause of an error on the payment processing.

Foreign Keys

Table Foreign Table Foreign Key Column
JL_BR_AP_BANK_RETURNS_ALL iby_pay_instructions_all PAYMENT_INSTRUCTION_ID
JL_BR_AP_BANK_RETURNS_ALL iby_payments_all PAYMENT_ID
JL_BR_AP_BANK_RETURNS_ALL iby_docs_payable_all DOCUMENT_PAYABLE_ID

Indexes

Index Uniqueness Tablespace Columns Status
JL_BR_AP_BANK_RET_ALL_N1 Non Unique Default OCCURRENCE_DATE, BANK_PARTY_ID
JL_BR_AP_BANK_RET_ALL_U1 Unique FUSION_TS_TX_IDX BANK_RETURN_ID Active
JL_BR_AP_BANK_RET_ALL_U2 Unique FUSION_TS_TX_IDX PAYMENT_ID, DOCUMENT_PAYABLE_ID Active