AP_SYSTEM_PARAMETERS_ALL_
AP_SYSTEM_PARAMETERS_ALL contains System Options setup data for a business unit. AP_SYSTEM_PARAMETERS_ALL_ is the audit table for AP_SYSTEM_PARAMETERS_ALL.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
AP_SYSTEM_PARAMETERS_ALL_PK_ |
LAST_UPDATE_DATE, ORG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| RELEASE_DUP_INVOICE_HOLD_FLAG | VARCHAR2 | 1 | Flag that indicates whether invoice validation process can evaluate duplicate invoice hold and automatically release it. (Y or N) | ||
| RECALC_PAY_SCHEDULE_FLAG | VARCHAR2 | 1 | Flag that indicates whether Recalculate Payment Installments (Y or N) | ||
| PREPAYMENT_AVAILABLE_MESG_FLAG | VARCHAR2 | 1 | Indicates whether available prepayments are shown during invoice entry. | ||
| SS_CHARGE_TYPES_MATCH_CODE | VARCHAR2 | 30 | Indicates the charge types that supplies are not allowed to enter while creating a matched invoice. Possible values are None, Freight only, Miscellaneous only and both. | ||
| SS_CHARGE_TYPES_UNMATCH_CODE | VARCHAR2 | 30 | Indicates the charge types that suppliers are not allowed to enter while creating an unmatched invoice. Possible values are None, Freight only, Miscellaneous only and Both. | ||
| SS_UPRICE_CHANGE_FOR_QTYMATCH | VARCHAR2 | 30 | Setting that indicates whether unit price change is allowed for purchase order matched self-service invoice. | ||
| SS_INVOICE_BACKDATING_FLAG | VARCHAR2 | 1 | Indicates whether a self-service invoice can have invoice date prior to system date. | ||
| SS_LIMIT_TO_SINGLE_PO_FLAG | VARCHAR2 | 1 | Indicates whether a self-service invoice can be matched to multiple purchase orders. | ||
| REQUIRE_INVOICE_GROUP_FLAG | VARCHAR2 | 1 | Setting that indicates whether invoice group is mandatory during invoice entry. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Ledger for which the parameters, control options, and defaults have been defined in order to operate your Payables application. | ||
| BASE_CURRENCY_CODE | VARCHAR2 | 15 | Functional currency code associated with the ledger. | ||
| AUTO_CALCULATE_INTEREST_FLAG | VARCHAR2 | 1 | Flag that indicates whether interest invoices are automatically created for past due invoice payments (Y or N) | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Default invoice currency code that defaults on the supplier sites associated with the business unit. | ||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | 15 | Default payment currency code (must be same as INVOICE_CURRENCY_CODE or must be an associated fixed-rate currency) | ||
| TERMS_ID | NUMBER | 18 | Default payment terms identifier that defaults on the supplier sites associated with the business unit. | ||
| ALWAYS_TAKE_DISC_FLAG | VARCHAR2 | 1 | Flag that indicates if available discount for supplier will be taken, regardless of when invoice is paid (Y or N) | ||
| PAY_DATE_BASIS_LOOKUP_CODE | VARCHAR2 | 25 | Basis used for selecting invoices for payment | ||
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for accounts payable liability account | ||
| DISC_TAKEN_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for discounts taken account | ||
| ADD_DAYS_SETTLEMENT_DATE | NUMBER | 18 | Number of days added to system date to calculate settlement date for a prepayment | ||
| DAYS_BETWEEN_CHECK_CYCLES | NUMBER | 18 | Number of days between normal payment printing cycles, used to determine Pay Through Date for automatic payment batch | ||
| FEDERAL_IDENTIFICATION_NUM | VARCHAR2 | 20 | Federal Tax Identification number of your company | ||
| LOCATION_ID | NUMBER | 18 | Location identifier for headquarters location of your company (prints on 1099 forms) | ||
| PREPAY_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for prepayment account | ||
| UPDATE_PAY_SITE_FLAG | VARCHAR2 | 1 | Flag that indicates if changes to supplier payment address on manual payments or Quick payments is allowed (Y or N) | ||
| GAIN_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for account to which realized exchange rate gains are posted | ||
| LOSS_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for account to which realized exchange rate losses are posted | ||
| MAKE_RATE_MANDATORY_FLAG | VARCHAR2 | 1 | Flag that indicates if exchange rates must be entered for multiple currency invoices and payments (Y or N) | ||
| GL_DATE_FROM_RECEIPT_FLAG | VARCHAR2 | 25 | Date used as accounting date during invoice entry | ||
| DISC_IS_INV_LESS_TAX_FLAG | VARCHAR2 | 1 | Flag that indicates if tax amount excluded from invoice amount when invoice amount applicable to discount calculated (Y or N) | ||
| ACCOUNTING_METHOD_OPTION | VARCHAR2 | 25 | Accounting method used with primary set of books | ||
| ONLINE_PRINT_FLAG | VARCHAR2 | 1 | Flag that indicates if immediate on-line printing for Quick Payments is allowed (Y or N) | ||
| EFT_USER_NUMBER | VARCHAR2 | 30 | Number which identifies your company as a user of electronic funds transfer services to bank or clearing organization | ||
| MAX_OUTLAY | NUMBER | Maximum amount of a payment batch | |||
| VENDOR_PAY_GROUP_LOOKUP_CODE | VARCHAR2 | 25 | Default pay group code for payment requests. Used to group a category of suppliers or invoices into a single pay run. For example: employees, merchandise, nonmerchandise, government, domestic, and international. | ||
| REQUIRE_TAX_ENTRY_FLAG | VARCHAR2 | 1 | Flag that indicates if tax entry is required during invoice entry (Y or N) | ||
| POST_DATED_PAYMENTS_FLAG | VARCHAR2 | 1 | Flag that indicates if payment date can be prior to system date (Y or N) | ||
| SECONDARY_ACCOUNTING_METHOD | VARCHAR2 | 25 | Accounting method used for secondary set of books | ||
| SECONDARY_SET_OF_BOOKS_ID | NUMBER | 18 | Secondary set of books identifier | ||
| INTEREST_TOLERANCE_AMOUNT | NUMBER | Minimum interest amount owed on past due invoice for interest invoice to be automatically created | |||
| INTEREST_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for interest expense account | ||
| TERMS_DATE_BASIS | VARCHAR2 | 25 | Date used together with payment terms and invoice amount to create invoice scheduled payment | ||
| LIABILITY_POST_LOOKUP_CODE | VARCHAR2 | 25 | Code for method used to build offsetting Accounting Flexfields for invoice and payment distributions (Automatic Offsets/Fund Accounting) | ||
| DISCOUNT_DISTRIBUTION_METHOD | VARCHAR2 | 25 | Method for distributing discount amounts taken on invoice payments | ||
| COMBINED_FILING_FLAG | VARCHAR2 | 1 | Flag that indicates whether your organization participates in the Combined Filing Program for income tax reporting | ||
| INCOME_TAX_REGION | VARCHAR2 | 10 | Default income tax region assigned to invoice lines for 1099 suppliers | ||
| INCOME_TAX_REGION_FLAG | VARCHAR2 | 1 | A value of Y indicates that you use supplier tax region as the default Income Tax Region for 1099 invoice lines | ||
| ALLOW_FINAL_MATCH_FLAG | VARCHAR2 | 1 | Flag that indicates whether you allow final matching to purchase orders | ||
| ALLOW_FLEX_OVERRIDE_FLAG | VARCHAR2 | 1 | Flag that indicates whether you can override the matching Accounting Flexfield for an invoice distribution matched to a purchase order distribution line | ||
| ALLOW_PAID_INVOICE_ADJUST | VARCHAR2 | 1 | Flag that indicates whether you allow adjustments to paid invoices | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | USSGL Transaction Code for automatically generated interest invoices | ||
| USSGL_TRX_CODE_CONTEXT | VARCHAR2 | 30 | USSGL Transaction Code Descriptive Flexfield context column | ||
| INV_DOC_CATEGORY_OVERRIDE | VARCHAR2 | 1 | Flag that indicates whether you can override the default document category (Sequential Numbering) for invoices | ||
| PAY_DOC_CATEGORY_OVERRIDE | VARCHAR2 | 1 | Flag that indicates whether you can override the default document category (Sequential Numbering) for payments | ||
| VENDOR_AUTO_INT_DEFAULT | VARCHAR2 | 1 | Default Automatic Interest Calculation value that defaults to suppliers (Y or N) | ||
| RATE_VAR_GAIN_CCID | NUMBER | 18 | Accounting Flexfield identifier for account used to record exchange rate gains for invoices matched to purchase orders | ||
| RATE_VAR_LOSS_CCID | NUMBER | 18 | Accounting Flexfield identifier for account used to record exchange rate losses for invoices matched to purchase order | ||
| TRANSFER_DESC_FLEX_FLAG | VARCHAR2 | 1 | A value of Y indicates the system will transfer descriptive flexfield information from a purchase order shipment to an invoice line and from the purchase order distribution to an invoice distribution during purchase order matching | ||
| ALLOW_AWT_FLAG | VARCHAR2 | 1 | Flag to indicate whether Automatic Withholding Tax is allowed (Y or N) | ||
| DEFAULT_AWT_GROUP_ID | NUMBER | 18 | Default Withholding Tax group for new suppliers | ||
| ALLOW_AWT_OVERRIDE | VARCHAR2 | 1 | Flag to indicate whether override of withholding tax amount is allowed (Y, N, null) | ||
| CREATE_AWT_DISTS_TYPE | VARCHAR2 | 25 | Indicates when the system should automatically create withholding tax invoices. Possible values are Never, Validation, or Payment | ||
| CREATE_AWT_INVOICES_TYPE | VARCHAR2 | 25 | Indicates when the system should automatically create withholding tax invoices (Never, Invoice Validation, Payment). | ||
| AWT_INCLUDE_DISCOUNT_AMT | VARCHAR2 | 1 | Flag to indicate whether the discount amount is included in withholding tax calculation | ||
| AWT_INCLUDE_TAX_AMT | VARCHAR2 | 1 | Flag to indicate whether the tax amount is included in the withholding tax calculation | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| AUTO_CREATE_FREIGHT_FLAG | VARCHAR2 | 1 | Flag that indicates whether a freight line can be automatically created from a user request | ||
| FREIGHT_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for accounts payable freight account | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| 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. | ||
| 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. | ||
| ALLOW_SUPPLIER_BANK_OVERRIDE | VARCHAR2 | 1 | Flag to indicate whether user can charge remit-to bank at payment creation time. | ||
| USE_BANK_CHARGE_FLAG | VARCHAR2 | 1 | Flag to indicate if Bank Charge feature is used | ||
| BANK_CHARGE_BEARER | VARCHAR2 | 1 | Indicates whether the deploying company or your supplier pays bank charges for electronic payments. | ||
| MRC_BASE_CURRENCY_CODE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id, functional currency pairs | ||
| MRC_SECONDARY_SET_OF_BOOKS_ID | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id | ||
| GAIN_LOSS_CALC_LEVEL | VARCHAR2 | 30 | Level at which Payables will calculate gain and loss, either Payment or Payment Line | ||
| WHEN_TO_ACCOUNT_PMT | VARCHAR2 | 30 | Defines when accounting entries for payments will be created. | ||
| FUTURE_DATED_PMT_LIAB_RELIEF | VARCHAR2 | 30 | Specifies when the liability for future dated payments is relieved | ||
| GL_TRANSFER_ALLOW_OVERRIDE | VARCHAR2 | 1 | Option that allows the user to change the default values for program parameters when the user submits the transfer to GL process | ||
| GL_TRANSFER_MODE | VARCHAR2 | 1 | GL Interface Transfer Summary Level. Detail (D), summarized by accounting date (A), summarized by accounting period (P) | ||
| GL_TRANSFER_SUBMIT_JOURNAL_IMP | VARCHAR2 | 1 | Option for submitting Journal Import to Oracle General Ledger at the same time as the transfer to GL process | ||
| INCLUDE_REPORTING_SOB | VARCHAR2 | 1 | If this option is set to 'Y' then all multi reporting currencies ledgers will automatically be selected for transfer with the same selection criteria as the main ledger. | ||
| PREPAYMENT_TERMS_ID | NUMBER | 18 | Default payment terms for prepayment. For example, a company may want to have immediate payment terms for all prepayment type invoices. | ||
| APPROVAL_WORKFLOW_FLAG | VARCHAR2 | 1 | Select this check box value to enable invoice approval. | ||
| ALLOW_FORCE_APPROVAL_FLAG | VARCHAR2 | 1 | Select this check box value if you use the Invoice Approval Workflow Program and want to allow accounts payable processors to override the workflow and manually approve invoices. | ||
| VALIDATE_BEFORE_APPROVAL_FLAG | VARCHAR2 | 1 | If you select this check box value, then Invoice Approval Workflow does not select any invoice for processing unless the invoice status is Validated. | ||
| XML_PAYMENTS_AUTO_CONFIRM_FLAG | VARCHAR2 | 1 | Flag that indicates if the XML Payment Automatic Confirmation feature is enabled. | ||
| BUILD_PREPAYMENT_ACCOUNTS_FLAG | VARCHAR2 | 1 | Flag indicating whether the prepayment account should be built or defaulted | ||
| ENABLE_1099_ON_AWT_FLAG | VARCHAR2 | 1 | Select this check box value is you want to include Withholding Distribution in Income Tax Reports | ||
| TOLERANCE_ID | NUMBER | 18 | A unique identifier for tolerance template that is used for goods tolerance. | ||
| PREPAY_TAX_DIFF_CCID | NUMBER | 18 | Account to which any prepayment tax difference amount will be charged. | ||
| CE_BANK_ACCT_USE_ID | NUMBER | 18 | Bank account number used for cash transactions. | ||
| APPROVAL_TIMING | VARCHAR2 | 30 | If you select this check box value, then Invoice Approval Workflow does not select any invoice for processing unless the invoice status is Accounted. | ||
| SERVICES_TOLERANCE_ID | NUMBER | 18 | Services tolerance template identifier | ||
| RECEIPT_ACCEPTANCE_DAYS | NUMBER | 18 | Number of days in receipt acceptance period | ||
| 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. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | 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. | ||
| PAYMENT_PRIORITY | NUMBER | A unique number between 1 (high) and 99 (low) that represents the priority of payment. | |||
| EXCLUDE_FREIGHT_FROM_DISCOUNT | VARCHAR2 | 1 | Exclude Freight From Discount Identifier | ||
| PRORATE_INT_INV_ACROSS_DISTS | VARCHAR2 | 1 | Used to display the 'Interest' Allocation method in 'Accounting Option' label. | ||
| EMPLOYEE_TERMS_ID | NUMBER | 18 | Default payment terms identifier for payment requests. | ||
| EMPLOYEE_PAY_GROUP_LOOKUP_CODE | VARCHAR2 | 25 | Default pay group code for payment requests. Used to group a category of invoices into a single pay run. For example: employees, merchandise, nonmerchandise, government, domestic, and international. | ||
| EMPLOYEE_PAYMENT_PRIORITY | NUMBER | 2 | A unique number between 1 (high) and 99 (low) that represents the priority of payment. | ||
| BUDGET_DATE_BASIS | VARCHAR2 | 25 | Budget Date Basis to default the budget date on invoice transactions | ||
| 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. | |||
| AUTOMATIC_MATCHING_FLAG | VARCHAR2 | 1 | Indicates if automatic matching is enabled for the invoicing business unit. If users enable this option, they must select a matching rule set. | ||
| MATCHING_RULE_SET_ID | NUMBER | 18 | Matching rule set used to perform automatic matching for an invoice when a matching rule set is not found at the invoice header and supplier site setup. | ||
| ROUTE_INTERFACE_REJECTION_FLAG | VARCHAR2 | 1 | Indicates whether rejected invoices in the interface table should be routed for correction. | ||
| OVERRIDE_MATCH_REJECTION_FLAG | VARCHAR2 | 1 | Indicates whether invoice import process allows override on rejections for scanned invoices. | ||
| ALLOW_INV_THIRD_PARTY_OVRD | VARCHAR2 | 1 | Allow override of remit-to supplier and address for third party payments | ||
| ALLOW_PYMT_THIRD_PARTY_OVRD | VARCHAR2 | 1 | Allow override of remit-to supplier and address for third party payments | ||
| BANK_CHARGE_DEDUCTION_TYPE | VARCHAR2 | 1 | Type of deduction for bank charges. Values are Standard, Negotiated, or None. | ||
| ROUTING_FLAG | VARCHAR2 | 1 | Indicates the Invoice Rounting option is enabled for the business unit. | ||
| ATTACHMENT_MANDATORY_SS_FLAG | VARCHAR2 | 1 | Makes attachments mandatory for invoices created through supplier portal. | ||
| DISALLOW_ATTACHMENT_DEL_FLAG | VARCHAR2 | 1 | Prevents the deletion of attachments for approved or validated invoices. | ||
| DEFAULT_CONV_RATE_DATE_BASIS | VARCHAR2 | 25 | Date used as default conversion rate date to convert an amount into another currency for an invoice | ||
| ACCOUNT_DEFAULT_BASIS_CODE | VARCHAR2 | 30 | Basis used for defaulting the accounts on the invoice transactions. | ||
| SS_QTYMATCH_OVERBILL_FLAG | VARCHAR2 | 1 | Flag that indicates whether a supplier can enter a quantity on the invoice that exceeds the purchase order for quantity based matches or not | ||
| SS_AMTMATCH_OVERBILL_FLAG | VARCHAR2 | 1 | Flag that indicates whether a supplier can enter a quantity on the invoice that exceeds the purchase order for quantity based matches or not | ||
| ESCHEATMENT_ELIGIBILITY_PERIOD | NUMBER | 18 | Number of days after which escheatment is allowed. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Actione Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1's and 0s for each row. 1 will be stored if the value has changed and 0 will be stored if the value hasn't. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_SYSTEM_PARAMETERS_ALL_U2_ | Unique | FUSION_TS_SEED | LAST_UPDATE_DATE, ORG_ID |
| AP_SYSTEM_PARAMETERS_A_N1_ | Non Unique | FUSION_TS_SEED | ORG_ID |
| AP_SYSTEM_PARAMETERS_U1_ | Unique | FUSION_TS_SEED | LAST_UPDATE_DATE, SET_OF_BOOKS_ID, ORG_ID |