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 |