[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_SYSTEM_PARAMETERS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.AR_SYSTEM_PARAMETERS_ALL
|
| Subobject Name: | |
| Status: | VALID |
The AR_SYSTEM_PARAMETERS_ALL table stores information that you supply to customize Oracle 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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AR_SYSTEM_PARAMETERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 ACCOUNTING_METHOD
ORG_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | General Ledger Set of Books that is used, only one currently supported |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| 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) | Yes | Y or N indicates whether to allow unearned discount |
| PARTIAL_DISCOUNT_FLAG | VARCHAR2 | (1) | Yes | Y or N indicates if more than one currency is allowed |
| PRINT_REMIT_TO | VARCHAR2 | (1) | Yes | Y or N indicates whether to print the remit-to |
| DEFAULT_CB_DUE_DATE | VARCHAR2 | (30) | Yes | Default chargeback due date |
| AUTO_SITE_NUMBERING | VARCHAR2 | (1) | Yes | Y or N indicates whether to use payment rules |
| CASH_BASIS_SET_OF_BOOKS_ID | NUMBER | (15) | General Ledger Set of Books that is used for cash basis accounting method | |
| CODE_COMBINATION_ID_GAIN | NUMBER | (15) | Code combination ID for realized gains | |
| AUTOCASH_HIERARCHY_ID | NUMBER | (15) | Identifies the default payment rule to be used | |
| RUN_GL_JOURNAL_IMPORT_FLAG | VARCHAR2 | (1) | Yes | Y or N indicates whether to automatically run the General Ledger Journal Import when posting |
| CER_SPLIT_AMOUNT | NUMBER | (9) | Yes | Split amount that the Collection Effectiveness report uses |
| CER_DSO_DAYS | NUMBER | (5) | Yes | Number of day that sales are outstanding, used by the Collections Effectiveness report |
| POSTING_DAYS_PER_CYCLE | NUMBER | (5) | Yes | 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 | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CALC_DISCOUNT_ON_LINES_FLAG | VARCHAR2 | (1) | Yes | Indicates if discount amounts can be calculated using only the invoice line amounts |
| CHANGE_PRINTED_INVOICE_FLAG | VARCHAR2 | (1) | Yes | Indicates if changes can be made to transactions that were already printed |
| CODE_COMBINATION_ID_LOSS | NUMBER | (15) | Code combination ID for realized losses | |
| CREATE_RECIPROCAL_FLAG | VARCHAR2 | (1) | Yes | No Longer Used. |
| DEFAULT_COUNTRY | VARCHAR2 | (60) | Name of the country that is defaulted for addresses | |
| DEFAULT_TERRITORY | VARCHAR2 | (30) | Yes | 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) | Yes | Indicates if deletion of incomplete invoices is allowed |
| LOCATION_STRUCTURE_ID | NUMBER | (15) | Identifier of the Sales Tax Location Flexfield structure | |
| SITE_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | 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 | (15) | Controls the detail of message that is displayed in the AutoInvoice log file | |
| AI_MAX_MEMORY_IN_BYTES | NUMBER | (15) | 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 MTL_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 | (15) | Yes | Defines the default grouping rule for customers that are defined in Oracle Receivables |
| SALESREP_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Indicates if salespersons are required |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| AUTO_REC_INVOICES_PER_COMMIT | NUMBER | (8) | Yes | Number of invoices that the Automatic Receipt program processes before saving |
| AUTO_REC_RECEIPTS_PER_COMMIT | NUMBER | (8) | Yes | Number of receipts that the Automatic Receipt program processes before saving |
| PAY_UNRELATED_INVOICES_FLAG | VARCHAR2 | (1) | Yes | 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. |
| PRINT_HOME_COUNTRY_FLAG | VARCHAR2 | (1) | Yes | 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 | (15) | 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 | (15) | 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 | (15) | Organization identifier | |
| 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) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
| RULE_SET_ID | NUMBER | Yes | Application rule set ID | |
| 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 | (15) | Indicates tax code defaulting hierarchy for a customer site level tax code | |
| TAX_HIER_CUST_EXC_RATE | NUMBER | (15) | Indicates tax code defaulting hierarchy for a customer level tax code | |
| TAX_HIER_PROD_EXC_RATE | NUMBER | (15) | Indicates tax code defaulting hierarchy for an item level tax code | |
| TAX_HIER_ACCOUNT_EXC_RATE | NUMBER | (15) | Indicates tax code defaulting hierarchy for a revenue account tax code | |
| TAX_HIER_SYSTEM_EXC_RATE | NUMBER | (15) | 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) | Indicates the tax view set suffix. For example, A for Taxware, V for Vertex, O for Oracle tax views. | |
| INCLUSIVE_TAX_USED | VARCHAR2 | (1) | If Y, the running totals in the Transactions Workbench Lines window are disabled | |
| CODE_COMBINATION_ID_ROUND | NUMBER | (15) | Code combination ID for the rounding error | |
| TRX_HEADER_LEVEL_ROUNDING | VARCHAR2 | (1) | Yes | Indicates if Header Level Rounding is enabled |
| TRX_HEADER_ROUND_CCID | NUMBER | (15) | Code combination identifier of the header rounding account | |
| FINCHRG_RECEIVABLES_TRX_ID | NUMBER | (15) | Foreign key to the AR_RECEIVABLES_TRX table, indicates the default receivables activity for finance charges | |
| SALES_TAX_GEOCODE | VARCHAR2 | (30) | US state and local tax jurisdiction code. Use this field to provide either a Vertex GeoCode or Taxware Geocode value for the Point of Order origin. | |
| BILLS_RECEIVABLE_ENABLED_FLAG | VARCHAR2 | (1) | Bills Receivable enabled flag | |
| TA_INSTALLED_FLAG | VARCHAR2 | (1) | Trade Accounting activation flag | |
| REV_TRANSFER_CLEAR_CCID | NUMBER | (15) | 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 | (15) | Receipt method for iReceivables credit card payments | |
| SHOW_BILLING_NUMBER_FLAG | VARCHAR2 | (1) | Indicates whether to display the consolidated billing number in various Receivables reports and windows, such as the Transactions window. Replaces the AR: Show Billing Number profile option. | |
| CROSS_CURRENCY_RATE_TYPE | VARCHAR2 | (30) | Determines the exchange rate type that Receivables uses to derive the exchange rate for cross currency receipt applications for Lockbox and Receipt API. Replaces the AR: Cross Currency Rate Type profile option. | |
| DOCUMENT_SEQ_GEN_LEVEL | VARCHAR2 | (80) | Determines at what point Receivables generates a document number for a transaction: when it is saved, or when it is complete. Replaces the AR: Document Number Generation Level profile option. | |
| 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 | (15) | Receipt method for iReceivables bank account transfer payments | |
| 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) | CREDIT CLASSIFICATION | |
| CREDIT_CLASSIFICATION3 | VARCHAR2 | (30) | Credit Classification | |
| CREDIT_CLASSIFICATION2 | VARCHAR2 | (30) | Credit Classification | |
| UNMTCH_CLAIM_CREATION_FLAG | VARCHAR2 | (1) | Indicates if claims should be created for unmatched remittances that have a certain sign. Valid LOV choices are NULL (none), A (Any Sign), P (Positive), or N (Negative). | |
| 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 | (15) | The Receivables Activity type used for Convenience Charges | |
| ALLOW_LATE_CHARGES | VARCHAR2 | (30) | If late charges is allowed or not | |
| LATE_CHARGE_DM_TYPE_ID | NUMBER | (15) | Transaction type for the late charges Debit Memo | |
| LATE_CHARGE_INV_TYPE_ID | NUMBER | (15) | Transaction type for the late charges Invoice | |
| LATE_CHARGE_BATCH_SOURCE_ID | NUMBER | (15) | Transaction batch source for the late charges documents | |
| PENALTY_REC_TRX_ID | NUMBER | (15) | 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) | |
| AUTOMATCH_SET_ID | NUMBER | (15) | Reserved for future use | |
| CREATE_DETAILED_DIST_FLAG | VARCHAR2 | (1) | Reserved for future use | |
| AUTOMATCH_ENABLED_FLAG | VARCHAR2 | (1) | Automatch Cash Application control flag | |
| DEFAULT_RCT_MTHD_FOR_LC_INV | VARCHAR2 | (1) | Default Receipt Method for Late Charge Invoices |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ACCOUNTING_METHOD
, ACCRUE_INTEREST
, UNEARNED_DISCOUNT
, PARTIAL_DISCOUNT_FLAG
, PRINT_REMIT_TO
, DEFAULT_CB_DUE_DATE
, AUTO_SITE_NUMBERING
, CASH_BASIS_SET_OF_BOOKS_ID
, CODE_COMBINATION_ID_GAIN
, AUTOCASH_HIERARCHY_ID
, RUN_GL_JOURNAL_IMPORT_FLAG
, CER_SPLIT_AMOUNT
, CER_DSO_DAYS
, POSTING_DAYS_PER_CYCLE
, ADDRESS_VALIDATION
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE_CATEGORY
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CALC_DISCOUNT_ON_LINES_FLAG
, CHANGE_PRINTED_INVOICE_FLAG
, CODE_COMBINATION_ID_LOSS
, CREATE_RECIPROCAL_FLAG
, DEFAULT_COUNTRY
, DEFAULT_TERRITORY
, GENERATE_CUSTOMER_NUMBER
, INVOICE_DELETION_FLAG
, LOCATION_STRUCTURE_ID
, SITE_REQUIRED_FLAG
, TAX_ALLOW_COMPOUND_FLAG
, TAX_INVOICE_PRINT
, TAX_METHOD
, TAX_USE_CUSTOMER_EXEMPT_FLAG
, TAX_USE_CUST_EXC_RATE_FLAG
, TAX_USE_LOC_EXC_RATE_FLAG
, TAX_USE_PRODUCT_EXEMPT_FLAG
, TAX_USE_PROD_EXC_RATE_FLAG
, TAX_USE_SITE_EXC_RATE_FLAG
, AI_LOG_FILE_MESSAGE_LEVEL
, AI_MAX_MEMORY_IN_BYTES
, AI_ACCT_FLEX_KEY_LEFT_PROMPT
, AI_MTL_ITEMS_KEY_LEFT_PROMPT
, AI_TERRITORY_KEY_LEFT_PROMPT
, AI_PURGE_INTERFACE_TABLES_FLAG
, AI_ACTIVATE_SQL_TRACE_FLAG
, DEFAULT_GROUPING_RULE_ID
, SALESREP_REQUIRED_FLAG
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, AUTO_REC_INVOICES_PER_COMMIT
, AUTO_REC_RECEIPTS_PER_COMMIT
, PAY_UNRELATED_INVOICES_FLAG
, PRINT_HOME_COUNTRY_FLAG
, LOCATION_TAX_ACCOUNT
, FROM_POSTAL_CODE
, TO_POSTAL_CODE
, TAX_REGISTRATION_NUMBER
, POPULATE_GL_SEGMENTS_FLAG
, UNALLOCATED_REVENUE_CCID
, ORG_ID
, TAX_CURRENCY_CODE
, TAX_PRECISION
, TAX_MINIMUM_ACCOUNTABLE_UNIT
, TAX_HEADER_LEVEL_FLAG
, TAX_ROUNDING_RULE
, TAX_ROUNDING_ALLOW_OVERRIDE
, TAX_CODE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, RULE_SET_ID
, TAX_USE_ACCOUNT_EXC_RATE_FLAG
, TAX_USE_SYSTEM_EXC_RATE_FLAG
, TAX_HIER_SITE_EXC_RATE
, TAX_HIER_CUST_EXC_RATE
, TAX_HIER_PROD_EXC_RATE
, TAX_HIER_ACCOUNT_EXC_RATE
, TAX_HIER_SYSTEM_EXC_RATE
, TAX_ENFORCE_ACCOUNT_FLAG
, TAX_DATABASE_VIEW_SET
, INCLUSIVE_TAX_USED
, CODE_COMBINATION_ID_ROUND
, TRX_HEADER_LEVEL_ROUNDING
, TRX_HEADER_ROUND_CCID
, FINCHRG_RECEIVABLES_TRX_ID
, SALES_TAX_GEOCODE
, BILLS_RECEIVABLE_ENABLED_FLAG
, TA_INSTALLED_FLAG
, REV_TRANSFER_CLEAR_CCID
, SALES_CREDIT_PCT_LIMIT
, MAX_WRTOFF_AMOUNT
, IREC_CC_RECEIPT_METHOD_ID
, SHOW_BILLING_NUMBER_FLAG
, CROSS_CURRENCY_RATE_TYPE
, DOCUMENT_SEQ_GEN_LEVEL
, CALC_TAX_ON_CREDIT_MEMO_FLAG
, IREC_BA_RECEIPT_METHOD_ID
, PAYMENT_THRESHOLD
, STANDARD_REFUND
, CREDIT_CLASSIFICATION1
, CREDIT_CLASSIFICATION3
, CREDIT_CLASSIFICATION2
, UNMTCH_CLAIM_CREATION_FLAG
, MATCHED_CLAIM_CREATION_FLAG
, MATCHED_CLAIM_EXCL_CM_FLAG
, MIN_WRTOFF_AMOUNT
, MIN_REFUND_AMOUNT
, IREC_SERVICE_CHARGE_REC_TRX_ID
, ALLOW_LATE_CHARGES
, LATE_CHARGE_DM_TYPE_ID
, LATE_CHARGE_INV_TYPE_ID
, LATE_CHARGE_BATCH_SOURCE_ID
, PENALTY_REC_TRX_ID
, POST_BILLING_ITEM_INCLUSION
, LATE_CHARGE_BILLING_CALC_MODE
, AUTOMATCH_SET_ID
, CREATE_DETAILED_DIST_FLAG
, AUTOMATCH_ENABLED_FLAG
, DEFAULT_RCT_MTHD_FOR_LC_INV
FROM AR.AR_SYSTEM_PARAMETERS_ALL;
AR.AR_SYSTEM_PARAMETERS_ALL does not reference any database object
AR.AR_SYSTEM_PARAMETERS_ALL is referenced by following:
AR
AR_SYSTEM_PARAMETERS_ALL#
|
|
|
|