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_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, ORG_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | 18 | 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 | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | 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 | Lookup code for the accounting method | ||
ACCRUE_INTEREST | VARCHAR2 | 1 | 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 | 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. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition 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. | ||
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 | 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. | ||
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. | ||
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 | 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 | 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. | |||
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. | ||
AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
AR_SYSTEM_PARAMETERS_ALL_N__ | Non Unique | Default | ORG_ID |
AR_SYSTEM_PARAMETERS_ALL_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, ORG_ID |