AR_SYSTEM_PARAMETERS_ALL
AR_SYSTEM_PARAMETERS_ALL contains customizations to Oracle Fusion Receivables. This table stores installation-wide options. At least one row must always exist in this table. There is no primary key for this table.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_SYSTEM_PARAMETERS_ALL_PK |
ORG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | General Ledger Set of Books that is used, only one currently supported | ||
| BR_DEFAULT_BATCHSOURCE_SEQ_ID | NUMBER | 18 | Identifier of the default transaction source for bills receivable. | |||
| BR_REMIT_WITHOUT_RECOURSE_FLAG | VARCHAR2 | 1 | Indicates that bills receivable can be factored without recourse. | |||
| PAYMENT_APPLICATION_RULE | VARCHAR2 | 1 | Payment Application will be done either at Header level (H) or Line Level (L). | |||
| 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. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ACCOUNTING_METHOD | VARCHAR2 | 30 | Yes | Lookup code for the accounting method | ||
| ACCRUE_INTEREST | VARCHAR2 | 1 | Yes | Y or N indicates whether to accrue interest | ||
| UNEARNED_DISCOUNT | VARCHAR2 | 1 | Y or N indicates whether to allow unearned discount | |||
| PARTIAL_DISCOUNT_FLAG | VARCHAR2 | 1 | Y or N indicates if more than one currency is allowed | |||
| PRINT_REMIT_TO | VARCHAR2 | 1 | Y or N indicates whether to print the remit-to | |||
| DEFAULT_CB_DUE_DATE | VARCHAR2 | 30 | Due date that defaults when chargeback is created . | |||
| AUTO_SITE_NUMBERING | VARCHAR2 | 1 | Yes | Y or N indicates whether to use payment rules | ||
| CASH_BASIS_SET_OF_BOOKS_ID | NUMBER | 18 | General Ledger Set of Books that is used for cash basis accounting method | |||
| CODE_COMBINATION_ID_GAIN | NUMBER | 18 | Code combination ID for realized gains | |||
| AUTOCASH_HIERARCHY_ID | NUMBER | 18 | Identifies the default payment rule to be used | |||
| RUN_GL_JOURNAL_IMPORT_FLAG | VARCHAR2 | 1 | Y or N indicates whether to automatically run the General Ledger Journal Import when posting | |||
| CER_SPLIT_AMOUNT | NUMBER | Split amount that the Collection Effectiveness report uses | ||||
| ITEM_VALIDATION_ORG_ID | NUMBER | Item validation organization identifier. | ||||
| CER_DSO_DAYS | NUMBER | 5 | Number of day that sales are outstanding, used by the Collections Effectiveness report | |||
| POSTING_DAYS_PER_CYCLE | NUMBER | 5 | Number of posting days per commit cycle in the posting program | |||
| ADDRESS_VALIDATION | VARCHAR2 | 30 | Type of validation that is used for addresses that are defined in the home country | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| CALC_DISCOUNT_ON_LINES_FLAG | VARCHAR2 | 1 | Indicates if discount amounts can be calculated using only the invoice line amounts | |||
| CHANGE_PRINTED_INVOICE_FLAG | VARCHAR2 | 1 | Indicates if changes can be made to transactions that were already printed | |||
| CODE_COMBINATION_ID_LOSS | NUMBER | 18 | Code combination ID for realized losses | |||
| CREATE_RECIPROCAL_FLAG | VARCHAR2 | 1 | Not currently used. | |||
| DEFAULT_COUNTRY | VARCHAR2 | 60 | Name of the country that is defaulted for addresses | |||
| DEFAULT_TERRITORY | VARCHAR2 | 30 | Indicates the Territory Flexfield that is defaulted into the Transaction windows | |||
| GENERATE_CUSTOMER_NUMBER | VARCHAR2 | 1 | Yes | Indicates if customer numbers are automatically generated | ||
| INVOICE_DELETION_FLAG | VARCHAR2 | 1 | Indicates if deletion of incomplete invoices is allowed | |||
| LOCATION_STRUCTURE_ID | NUMBER | 18 | Identifier of the Sales Tax Location Flexfield structure | |||
| SITE_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates if the bill-to site is required for receipts | |||
| TAX_ALLOW_COMPOUND_FLAG | VARCHAR2 | 1 | Indicates if compound taxes (taxes that are based on other taxes) are calculated | |||
| TAX_INVOICE_PRINT | VARCHAR2 | 30 | Indicates the method that is used for printing tax amounts on invoices | |||
| TAX_METHOD | VARCHAR2 | 30 | Type of tax method used, Sales Tax or Value Added Tax | |||
| TAX_USE_CUSTOMER_EXEMPT_FLAG | VARCHAR2 | 1 | Indicates if customer exemptions are included when calculating tax for transactions | |||
| TAX_USE_CUST_EXC_RATE_FLAG | VARCHAR2 | 1 | Indicates if the tax rate that was defined for the customer is used | |||
| TAX_USE_LOC_EXC_RATE_FLAG | VARCHAR2 | 1 | Indicates if the tax rate that was defined for specific products based on the customer's ship-to address is used | |||
| TAX_USE_PRODUCT_EXEMPT_FLAG | VARCHAR2 | 1 | Indicates if item exemptions are included when calculating tax for transactions | |||
| TAX_USE_PROD_EXC_RATE_FLAG | VARCHAR2 | 1 | Indicates if the tax rate that is defined for specific products is used | |||
| TAX_USE_SITE_EXC_RATE_FLAG | VARCHAR2 | 1 | Indicates if the tax rate that is defined for the customer's business purpose is used | |||
| AI_LOG_FILE_MESSAGE_LEVEL | NUMBER | 18 | Controls the detail of message that is displayed in the AutoInvoice log file | |||
| AI_MAX_MEMORY_IN_BYTES | NUMBER | 18 | Controls the amount of scratch memory that is used in AutoInvoice | |||
| AI_ACCT_FLEX_KEY_LEFT_PROMPT | VARCHAR2 | 80 | Stores the segment name (not the left prompt) of one of the Accounting Flexfield segments that AutoInvoice uses to join to the GL_CODE_COMBINATIONS table | |||
| AI_MTL_ITEMS_KEY_LEFT_PROMPT | VARCHAR2 | 80 | Stores the segment name (not the left prompt) of one of the System Items Flexfield segments that AutoInvoice uses to join to the EGP_SYSTEM_ITEMS table | |||
| AI_TERRITORY_KEY_LEFT_PROMPT | VARCHAR2 | 80 | Stores the segment name (not the left prompt) of one of the Sales Territory Flexfield segments that AutoInvoice uses to join to the RA_TERRITORIES table | |||
| AI_PURGE_INTERFACE_TABLES_FLAG | VARCHAR2 | 1 | Y or N indicates if AutoInvoice automatically purges successfully processed transactions from the AutoInvoice interface tables | |||
| AI_ACTIVATE_SQL_TRACE_FLAG | VARCHAR2 | 1 | Y or N indicates if SQL trace is activated in AutoInvoice | |||
| DEFAULT_GROUPING_RULE_ID | NUMBER | 18 | Defines the default grouping rule for customers that are defined in Oracle Receivables | |||
| SALESREP_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates if sales persons are required. | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | System Parameters (AR_SYSTEM_PARAMETERS) | ||
| AUTO_REC_INVOICES_PER_COMMIT | NUMBER | 8 | Number of invoices that the Automatic Receipt program processes before saving | |||
| AUTO_REC_RECEIPTS_PER_COMMIT | NUMBER | 8 | Number of receipts that the Automatic Receipt program processes before saving | |||
| PAY_UNRELATED_INVOICES_FLAG | VARCHAR2 | 1 | Y indicates that the cash windows (Receipts, Applications) allow the application of cash from one customer's invoice to another customer's invoice, even if the two customers are not related. | |||
| TAX_CACHE | NUMBER | 18 | Not currently used. | |||
| PRINT_HOME_COUNTRY_FLAG | VARCHAR2 | 1 | Y indicates that document programs will print all country codes in addresses, N indicates that document programs will print all country codes except the home country. | |||
| LOCATION_TAX_ACCOUNT | NUMBER | 18 | Tax account that is the default value in the Tax Codes and Rates window | |||
| FROM_POSTAL_CODE | VARCHAR2 | 60 | Starting code of the postal code range that defaults when sales tax rate assignments are entered in the Tax Locations and Rates window | |||
| TO_POSTAL_CODE | VARCHAR2 | 60 | Ending code of the postal code range that defaults when sales tax rate assignments are entered in the Tax Locations and Rates window | |||
| TAX_REGISTRATION_NUMBER | VARCHAR2 | 60 | Registration number that is printed on customer invoices if customers are charged tax | |||
| POPULATE_GL_SEGMENTS_FLAG | VARCHAR2 | 1 | Yes | If Y, then the General Ledger Transfer Program populates segments in the GL_INTERFACE table. | ||
| UNALLOCATED_REVENUE_CCID | NUMBER | 18 | Revenue account that is used when a cash receipt with a balance other than zero is applied to an invoice with a zero balance, used only for the cash basis accounting method | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| TAX_CURRENCY_CODE | VARCHAR2 | 15 | Tax reporting currency. When specified, tax amounts are rounded using the tax precision and minimum accountable unit. | |||
| TAX_PRECISION | NUMBER | 1 | Tax currency precision | |||
| TAX_MINIMUM_ACCOUNTABLE_UNIT | NUMBER | Tax currency minimum accountable unit | ||||
| TAX_HEADER_LEVEL_FLAG | VARCHAR2 | 1 | Tax rounding level flag. When set, tax is rounded per document per rate. | |||
| TAX_ROUNDING_RULE | VARCHAR2 | 30 | Tax rounding rule, defined in the System Options window. Tax can be rounded up, down, or nearest, and can be overridden at the customer and site levels | |||
| TAX_ROUNDING_ALLOW_OVERRIDE | VARCHAR2 | 1 | Indicates if rounding rules can be overridden | |||
| TAX_CODE | VARCHAR2 | 50 | Tax code | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| CONFIRM_THRESHOLD_AMT | NUMBER | Threshold amount in functional currency above which an auto receipt is created in Approved status. Below this amount, the receipt is automatically Confirmed. | ||||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| RULE_SET_ID | NUMBER | Application rule set identifier. | ||||
| TAX_USE_ACCOUNT_EXC_RATE_FLAG | VARCHAR2 | 1 | Y or N indicates if the tax code that is defined for a revenue account should be used | |||
| TAX_USE_SYSTEM_EXC_RATE_FLAG | VARCHAR2 | 1 | Y or N indicates if the tax code that is assigned at the System Options level should be used | |||
| TAX_HIER_SITE_EXC_RATE | NUMBER | 18 | Indicates tax code defaulting hierarchy for a customer site level tax code | |||
| TAX_HIER_CUST_EXC_RATE | NUMBER | 18 | Indicates tax code defaulting hierarchy for a customer level tax code | |||
| TAX_HIER_PROD_EXC_RATE | NUMBER | 18 | Indicates tax code defaulting hierarchy for an item level tax code | |||
| TAX_HIER_ACCOUNT_EXC_RATE | NUMBER | 18 | Indicates tax code defaulting hierarchy for a revenue account tax code | |||
| TAX_HIER_SYSTEM_EXC_RATE | NUMBER | 18 | Indicates tax code defaulting hierarchy for the System Option tax code | |||
| TAX_ENFORCE_ACCOUNT_FLAG | VARCHAR2 | 1 | Indicates if the tax code that is associated with a revenue account must be used at the invoice line | |||
| TAX_DATABASE_VIEW_SET | VARCHAR2 | 30 | Oracle internal use only. | |||
| INCLUSIVE_TAX_USED | VARCHAR2 | 1 | If Y, the running totals in the Transactions Workbench Lines window are disabled | |||
| CODE_COMBINATION_ID_ROUND | NUMBER | 18 | Code combination ID for the rounding error | |||
| TRX_HEADER_LEVEL_ROUNDING | VARCHAR2 | 1 | Indicates if Header Level Rounding is enabled | |||
| TRX_HEADER_ROUND_CCID | NUMBER | 18 | Code combination identifier of the header rounding account | |||
| FINCHRG_RECEIVABLES_TRX_ID | NUMBER | 18 | Foreign key to the AR_RECEIVABLES_TRX table, indicates the default receivables activity for finance charges | |||
| SALES_TAX_GEOCODE | VARCHAR2 | 30 | A unique code identifying the tax jurisdiction for the United States state, county and city. | |||
| BILLS_RECEIVABLE_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether the Receivables Balances Workarea Bills Receivable task pane links and Bills Receivable Portfolio section will be displayed to the user. | |||
| TA_INSTALLED_FLAG | VARCHAR2 | 1 | Trade Accounting activation flag | |||
| REV_TRANSFER_CLEAR_CCID | NUMBER | 18 | Code combination ID of clearing account for revenue transfers | |||
| SALES_CREDIT_PCT_LIMIT | NUMBER | Revenue adjustment percentage limit of combined revenue and non-revenue sales credits per salesperson per transaction line | ||||
| MAX_WRTOFF_AMOUNT | NUMBER | Maximum write-off amount | ||||
| IREC_CC_RECEIPT_METHOD_ID | NUMBER | 18 | Default receipt method to use for credit card receipts created from Oracle Fusion Advanced Collections. | |||
| SHOW_BILLING_NUMBER_FLAG | VARCHAR2 | 1 | Not currently used. | |||
| CROSS_CURRENCY_RATE_TYPE | VARCHAR2 | 30 | Determines the conversion rate type that is used to derive the conversion rate for cross currency receipt applications for Lockbox and Receipt API. | |||
| DOCUMENT_SEQ_GEN_LEVEL | VARCHAR2 | 80 | Determines when to generate a document number for a transaction: when it is saved, or when it is complete. | |||
| CALC_TAX_ON_CREDIT_MEMO_FLAG | VARCHAR2 | 1 | 'Y' for calculating tax during Autoinvoice on credit memo using the tax calculation engine. N for using Receivables during Autoinvoice to prorate tax already calculated on related invoice. | |||
| IREC_BA_RECEIPT_METHOD_ID | NUMBER | 18 | Default receipt method to use for bank account transfer receipts created from Oracle Fusion Advance Collections. | |||
| PAYMENT_THRESHOLD | NUMBER | Maximum number of days allowed for full payment | ||||
| STANDARD_REFUND | NUMBER | Stores the maximum number of days allowed for refund . | ||||
| CREDIT_CLASSIFICATION1 | VARCHAR2 | 30 | Revenue policy value that defers revenue on transactions of customers that match the classification. | |||
| CREDIT_CLASSIFICATION3 | VARCHAR2 | 30 | Revenue policy value that defers revenue on transactions of customers that match the classification. | |||
| CREDIT_CLASSIFICATION2 | VARCHAR2 | 30 | Revenue policy value that defers revenue on transactions of customers that match the classification. | |||
| UNMTCH_CLAIM_CREATION_FLAG | VARCHAR2 | 1 | Not currently used. | |||
| MATCHED_CLAIM_CREATION_FLAG | VARCHAR2 | 1 | Indicates if claims should be created for matched reference numbers | |||
| MATCHED_CLAIM_EXCL_CM_FLAG | VARCHAR2 | 1 | Indicates if credit memos should be excluded from claim creation | |||
| MIN_WRTOFF_AMOUNT | NUMBER | Minimum write-off amount. This value must be negative | ||||
| MIN_REFUND_AMOUNT | NUMBER | Minimum amount in functional currency for which refund can be issued | ||||
| IREC_SERVICE_CHARGE_REC_TRX_ID | NUMBER | 18 | The Receivables Activity type used for Convenience Charges | |||
| ALLOW_LATE_CHARGES | VARCHAR2 | 30 | If late charges is allowed or not | |||
| PENALTY_REC_TRX_ID | NUMBER | 18 | Receivables activity for penalty | |||
| POST_BILLING_ITEM_INCLUSION | VARCHAR2 | 30 | Indicates whether the post billing debit items should be considered for Average Daily Balance Calculation | |||
| LATE_CHARGE_BILLING_CALC_MODE | VARCHAR2 | 30 | Indicates the Calculation Mode of the Late Charge in Case of average daily balance (either Run Date to Run Date or Bill Date to Run Date) | |||
| 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. | ||
| LATE_CHARGE_DM_TYPE_SEQ_ID | NUMBER | 18 | Late charge debit memo sequence identifier. | |||
| LATE_CHARGE_INV_TYPE_SEQ_ID | NUMBER | 18 | Late charge invoice sequence identifier. | |||
| LATE_CHARGE_BAT_SOURCE_SEQ_ID | NUMBER | 18 | Late charge batch source sequence identifier. | |||
| AUTOMATCH_RULE_ID | NUMBER | 18 | AutoMatch Setup Identifier | |||
| LOCKBOX_MATCHING_OPTION1 | VARCHAR2 | 30 | First Match Receipt By Option | |||
| LOCKBOX_MATCHING_OPTION2 | VARCHAR2 | 30 | Second Match Receipt By Option | |||
| LOCKBOX_MATCHING_OPTION3 | VARCHAR2 | 30 | Third Match Receipt By Option | |||
| LOCKBOX_MATCHING_OPTION4 | VARCHAR2 | 30 | Fourth Match Receipt By Option | |||
| AUTOAPPLY_FLAG | VARCHAR2 | 1 | Indicates whether the Business Unit uses Auto Apply Feature | |||
| EXCEPTION_RULE_ID | NUMBER | 18 | Rule to say what action to be performed on the Remaining Receipt or Transaction Amount | |||
| AUTOMATCH_RERUN_DAYS | NUMBER | The number of days automatch will rerun for a receipt in the business unit | ||||
| EXCEPTION_WRTOFF_REC_TRX_ID | NUMBER | 18 | Write off activity identifier for exception rule | |||
| EXCEPTION_ADJ_REC_TRX_ID | NUMBER | 18 | Adjustment activity for exception rule | |||
| EXCEPTION_ADJ_REASON_CODE | VARCHAR2 | 30 | Adjustment reason code for exception rule | |||
| EXCEPTION_PMT_METHOD_CODE | VARCHAR2 | 30 | Refund payment method code for exception rule | |||
| SERVICED_BY_ANY_BU_FLAG | VARCHAR2 | 1 | Option that allows any cash processing business unit in the same ledger to process receipts for the given billing business unit. | |||
| BA_REMIT_BANK_ACCT_USE_ID | NUMBER | 18 | Default remittance bank account to use for bank account transfer receipts created from Oracle Fusion Advanced Collections. | |||
| CC_REMIT_BANK_ACCT_USE_ID | NUMBER | 18 | Default remittance bank account to use for credit card receipts created from Oracle Fusion Advanced Collections. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| ALLOW_PAYMENT_DELETION_FLAG | VARCHAR2 | 1 | A system option to allow or not allow user to delete a payment including reciepts and bills recievable. | |||
| ACCT_DATES_OUT_OF_ORDER | VARCHAR2 | 20 | A system option to indicate the action on the transaction that failed co-relation check. | |||
| REPLY_TO_EMAIL_ADDRESS | VARCHAR2 | 320 | Reply-to e-mail address for printed transactions delivered using e-mail. | |||
| FROM_EMAIL_ADDRESS | VARCHAR2 | 320 | From e-mail address for printed transactions delivered using e-mail. | |||
| FROM_EMAIL_NAME | VARCHAR2 | 150 | Name of the from e-mail address for printed transactions delivered using e-mail. | |||
| EMAIL_SUBJECT | VARCHAR2 | 150 | Contains e-mail subject line for printed transactions delivered using e-mail. | |||
| EMAIL_BODY | VARCHAR2 | 4000 | Contains body of the e-mail for printed transactions delivered using e-mail. | |||
| INCLUDE_BU_SUBJECT_CODE | VARCHAR2 | 30 | Lookup code that specifies option to include Business Unit name in e-mail subject line for printed transactions delivered using e-mail. | |||
| INCLUDE_TRXNUM_SUBJECT_CODE | VARCHAR2 | 30 | Lookup code that specifies option to include Transaction Number in e-mail subject line for printed transactions delivered using e-mail. | |||
| CREATE_DETAILED_DIST | VARCHAR2 | 30 | Indicates the business purpose for creation of detailed distributions. | |||
| GLOBAL_ATTRIBUTE_NUMBER6 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER7 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER8 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER9 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER10 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| ENABLE_RECURRING_BILLING_FLAG | VARCHAR2 | 1 | Enable recurring billing feature in receivables. | |||
| STMT_REPLY_TO_EMAIL_ADDRESS | VARCHAR2 | 320 | Reply-to e-mail address for printed statements delivered using e-mail. | |||
| STMT_FROM_EMAIL_ADDRESS | VARCHAR2 | 320 | From e-mail address for printed statements delivered using e-mail. | |||
| STMT_FROM_EMAIL_NAME | VARCHAR2 | 150 | Name of the from e-mail address for printed statements delivered using e-mail. | |||
| STMT_EMAIL_SUBJECT | VARCHAR2 | 150 | Contains e-mail subject line for printed statements delivered using e-mail. | |||
| STMT_EMAIL_BODY | VARCHAR2 | 4000 | Contains body of the e-mail for printed statements delivered using e-mail. | |||
| INCLUDE_STMT_BU_SUB_CODE | VARCHAR2 | 30 | Lookup code that specifies option to include business unit name in e-mail subject line for printed statements delivered using e-mail. | |||
| INCLUDE_STMT_DATE_SUB_CODE | VARCHAR2 | 30 | Lookup code that specifies option to include statement date in e-mail subject line for printed statements delivered using e-mail. | |||
| DEFAULT_CASH_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the Cash Account. | |||
| DEFAULT_UNAPPLIED_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the Unapplied Receipts Account.. | |||
| DEFAULT_UNIDENTIFIED_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the Unidentified Receipts Account. | |||
| DEFAULT_ON_ACCOUNT_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the On-Account Receipts Account. | |||
| DEFAULT_UNEARNED_DISCOUNT_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the Unearned Discounts Account. | |||
| DEFAULT_EARNED_DISCOUNT_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the Earned Discounts Account. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_SYSTEM_PARAMETERS_ALL | ra_cust_trx_types_all | LATE_CHARGE_INV_TYPE_SEQ_ID |
| AR_SYSTEM_PARAMETERS_ALL | ra_batch_sources_all | LATE_CHARGE_BAT_SOURCE_SEQ_ID |
| AR_SYSTEM_PARAMETERS_ALL | ar_receivables_trx_all | PENALTY_REC_TRX_ID, ORG_ID |
| AR_SYSTEM_PARAMETERS_ALL | ar_automatch_rules | AUTOMATCH_RULE_ID |
| AR_SYSTEM_PARAMETERS_ALL | ar_app_exception_rules | EXCEPTION_RULE_ID |
| AR_SYSTEM_PARAMETERS_ALL | ar_receivables_trx_all | EXCEPTION_WRTOFF_REC_TRX_ID, ORG_ID |
| AR_SYSTEM_PARAMETERS_ALL | ar_receivables_trx_all | EXCEPTION_ADJ_REC_TRX_ID, ORG_ID |
| AR_SYSTEM_PARAMETERS_ALL | gl_code_combinations | CODE_COMBINATION_ID_GAIN |
| AR_SYSTEM_PARAMETERS_ALL | ar_autocash_hierarchies | AUTOCASH_HIERARCHY_ID |
| AR_SYSTEM_PARAMETERS_ALL | ar_receivables_trx_all | FINCHRG_RECEIVABLES_TRX_ID, ORG_ID |
| AR_SYSTEM_PARAMETERS_ALL | gl_code_combinations | REV_TRANSFER_CLEAR_CCID |
| AR_SYSTEM_PARAMETERS_ALL | ar_receivables_trx_all | IREC_SERVICE_CHARGE_REC_TRX_ID, ORG_ID |
| AR_SYSTEM_PARAMETERS_ALL | ra_cust_trx_types_all | LATE_CHARGE_DM_TYPE_SEQ_ID |
| ar_trx_dist_line_balances_all | ar_system_parameters_all | RECEIPT_BU_ID |
| hes_org_defaults_all_b | ar_system_parameters_all | ORG_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_SYSTEM_PARAMETERS_ALL_U1 | Unique | Default | ORG_ID |
| AR_SYSTEM_PARAMETERS_N1 | Non Unique | Default | ACCOUNTING_METHOD, ORG_ID |