1. Tables and Views for Financials
  2. JL_BR_AR_SELECT_CONTROLS_ALL

JL_BR_AR_SELECT_CONTROLS_ALL

This table stores the selection criteria for invoices sent to bank transfer batches.

Details

  • Schema: FUSION

  • Object owner: JL

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JL_BR_AR_SELECT_CONTROL_ALL_PK

SELECTION_CONTROL_ID

Columns

Name Datatype Length Precision Not-null Comments Status
SELECTION_CONTROL_ID NUMBER 18 Yes Selection control identifier for a particular remittance selection. Active
SELECTION_STATUS VARCHAR2 30 Batch selection status. Values are from the lookup JLBR_AR_SELECTION_STATUS. Active
SELECTION_TYPE VARCHAR2 30 Yes Batch selection type. Values are from the lookup JLBR_AR SELECTION_TYPE. Active
NAME VARCHAR2 80 No longer used. Active
BORDERO_TYPE VARCHAR2 30 No longer used. Active
SELECTION_DATE DATE No longer used. Active
CANCELLATION_DATE DATE No longer used. Active
GENERATION_DATE DATE No longer used. Active
REMITTANCE_DATE DATE No longer used. Active
DUE_DATE_BREAK_FLAG VARCHAR2 1 Indicates whether several payment batches are to be created (one for each date of the selection) or just one payment batch with all lines. Active
INITIAL_DUE_DATE DATE Start date of the due date range of selection criteria. Active
FINAL_DUE_DATE DATE End date of the due date range of selection criteria. Active
INITIAL_TRX_DATE DATE Initial invoicing date of selection criteria. Active
FINAL_TRX_DATE DATE Final invoicing date of selection criteria. Active
INITIAL_TRX_NUMBER VARCHAR2 20 Initial invoice number of selection criteria. Active
FINAL_TRX_NUMBER VARCHAR2 20 Final invoice number of selection criteria. Active
INITIAL_CUSTOMER_NUMBER VARCHAR2 30 Initial customer number of selection criteria. Active
FINAL_CUSTOMER_NUMBER VARCHAR2 30 Final customer number of selection criteria. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
RECEIPT_METHOD_ID NUMBER 18 Payment method used to create remittance batches automatically. Active
INITIAL_TRX_AMOUNT NUMBER Initial transaction amount of selection criteria. Active
FINAL_TRX_AMOUNT NUMBER Final transaction amount of selection criteria. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. 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
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_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
CUST_TRX_TYPE_SEQ_ID NUMBER 18 Transaction type identifier of a document to be selected. 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
PARTY_ID NUMBER 18 Party identifier associated with the customer account. Active
BILLING_ORG_ID NUMBER 18 Internal billing organization unique identifier. Active
RECORD_TYPE_CODE VARCHAR2 30 Yes Identifier that distinguishes a template record from a transaction record. Active
ACTIVE_FLAG VARCHAR2 1 Flag that indicates whether the template record is enabled. Valid values are Y for yes and N for no. Active
TEMPLATE_DESCRIPTION VARCHAR2 240 Description for the template name on the template record. Active

Foreign Keys

Table Foreign Table Foreign Key Column
JL_BR_AR_SELECT_CONTROLS_ALL ra_cust_trx_types_all CUST_TRX_TYPE_SEQ_ID
JL_BR_AR_SELECT_CONTROLS_ALL hz_parties PARTY_ID
jl_br_ar_select_accounts_all jl_br_ar_select_controls_all SELECTION_CONTROL_ID
jl_br_ar_coll_batches_all jl_br_ar_select_controls_all SELECTION_CONTROL_ID
jl_br_ar_borderos_all jl_br_ar_select_controls_all SELECTION_CONTROL_ID

Indexes

Index Uniqueness Tablespace Columns Status
JL_BR_AR_SELECT_CONTROLS_N1 Non Unique Default ORG_ID, NAME, RECEIPT_METHOD_ID
JL_BR_AR_SELECT_CONTROLS_U1 Unique FUSION_TS_TX_IDX SELECTION_CONTROL_ID Active