JL_BR_AR_PAY_SCHED_AUX
This temporary table stores the bank transfer batches.
Details
-
Schema: FUSION
-
Object owner: JL
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
JL_BR_AR_PAY_SCHED_AUX_PK |
PAYMENT_SCHEDULE_ID, LEGAL_ENTITY_ID, REMIT_TO_ADDRESS_SEQ_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| PAYMENT_SCHEDULE_ID | NUMBER | 18 | Yes | Unique identifier for a payment schedule. | Active | |
| AMOUNT_DUE_REMAINING | NUMBER | Amount due remaining for a payment schedule. | Active | |||
| DUE_DATE | DATE | Date on which a payment schedule is due. | Active | |||
| SELECT_ACCOUNT_ID | NUMBER | 18 | Account selection control identifier. | Active | ||
| CUSTOMER_NUMBER | VARCHAR2 | 30 | Numeric identifier assigned to a customer. | Active | ||
| BANK_INSTRUCTION_CODE1 | NUMBER | Bank instruction code 1 on a payment schedule. | Active | |||
| BANK_INSTRUCTION_CODE2 | NUMBER | Bank instruction code 2 on a payment schedule. | Active | |||
| BANK_NUMBER | VARCHAR2 | 30 | Unique numeric identifier for a bank. | Active | ||
| BANK_ACCOUNT_ID | NUMBER | 18 | Identifier for the bank account used by the company. | Active | ||
| BRANCH_NUMBER | VARCHAR2 | 25 | Unique numeric identifier for a bank branch. | Active | ||
| PORTFOLIO_CODE | NUMBER | Portfolio code on a payment schedule. | Active | |||
| BATCH_SOURCE_ID | NUMBER | 18 | Batch source identifier for a payment schedule. | Active | ||
| RECEIPT_METHOD_ID | NUMBER | 18 | Receipt method identifier for a payment schedule. | Active | ||
| CUSTOMER_TRX_TYPE_ID | NUMBER | 18 | Customer transaction type identifier. | Active | ||
| BANK_ACCOUNT_NUM | VARCHAR2 | 30 | Number of the bank account used by the company. | Active | ||
| CUSTOMER_TRX_ID | NUMBER | 18 | Customer transaction identifier on a payment schedule. | Active | ||
| TERMS_SEQUENCE_NUMBER | NUMBER | Terms sequence number on a payment schedule. | Active | |||
| CUSTOMER_SITE_USE_ID | NUMBER | 18 | Identifier for a customer site use. | Active | ||
| BANK_CHARGE_AMOUNT | NUMBER | No longer used. | Active | |||
| BANK_PARTY_ID | NUMBER | 18 | Identifier for a bank party on a payment schedule. | Active | ||
| BRANCH_PARTY_ID | NUMBER | 18 | Party identifier for collecting bank branch. | Active | ||
| BANK_ACCT_USE_ID | NUMBER | 18 | Unique identifier for the bank account use. | 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. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| BILLING_ORG_ID | NUMBER | 18 | Yes | Internal billing organization unique identifier. | ||
| BILL_TO_SITE_ID | NUMBER | 18 | Yes | Bill-to site unique identifier in the selection criteria of a remittance batch. | ||
| PARTY_ID | NUMBER | 18 | Yes | Party identifier associated with the customer account. | ||
| INTEREST_TYPE | VARCHAR2 | 30 | Method used to calculate interest. | |||
| INTEREST_RATE_AMOUNT | NUMBER | Interest to be applied in terms of percentage rate or amount. | ||||
| INTEREST_PERIOD | NUMBER | Interest period number of days for calculating interest. | ||||
| INTEREST_FORMULA | VARCHAR2 | 30 | Type of formula used for calculating interest. | |||
| GRACE_DAYS | NUMBER | Number of days to be excluded while calculating interest. | ||||
| PENALTY_TYPE | VARCHAR2 | 30 | Type of method used for applying penalty. | |||
| PENALTY_RATE_AMOUNT | NUMBER | Penalty value to be applied in terms of percentage rate or amount. | ||||
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Legal Entity unique identifier in the Brazilian receivables invoice. | ||
| REMIT_TO_ADDRESS_SEQ_ID | NUMBER | 18 | Yes | Remit to address sequence unique identifier. | ||
| CONSOLIDATE_PAY_SCHED_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate whether to consolidate multiple payment schedules while creating collection document in Brazil. | ||
| CUST_TRX_TYPE_SEQ_ID | NUMBER | 18 | Yes | Transaction type sequence unique identifier. | ||
| PAYMENT_TERM_ID | NUMBER | 18 | Yes | Unique payment terms identifier. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| JL_BR_AR_PAY_SCHED_AUX | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| JL_BR_AR_PAY_SCHED_AUX | hz_parties | BRANCH_PARTY_ID |
| JL_BR_AR_PAY_SCHED_AUX | ce_bank_acct_uses_all | BANK_ACCT_USE_ID |
| JL_BR_AR_PAY_SCHED_AUX | hz_parties | PARTY_ID |
| JL_BR_AR_PAY_SCHED_AUX | ce_bank_accounts | BANK_ACCOUNT_ID |
| JL_BR_AR_PAY_SCHED_AUX | ar_batch_sources_all | BATCH_SOURCE_ID |
| JL_BR_AR_PAY_SCHED_AUX | ra_cust_trx_types_all | CUSTOMER_TRX_TYPE_ID |
| JL_BR_AR_PAY_SCHED_AUX | ra_customer_trx_all | CUSTOMER_TRX_ID |
| JL_BR_AR_PAY_SCHED_AUX | hz_cust_site_uses_all | CUSTOMER_SITE_USE_ID |
| JL_BR_AR_PAY_SCHED_AUX | jl_br_ar_select_accounts_all | SELECT_ACCOUNT_ID |
| JL_BR_AR_PAY_SCHED_AUX | hz_parties | BANK_PARTY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JL_BR_AR_PAY_SCHED_AUX_N1 | Non Unique | Default | BANK_ACCT_USE_ID, SELECT_ACCOUNT_ID |
| JL_BR_AR_PAY_SCHED_AUX_U1 | Unique | Default | PAYMENT_SCHEDULE_ID, LEGAL_ENTITY_ID, REMIT_TO_ADDRESS_SEQ_ID |