Payables Setup Business Objects
This topic describes the setup business objects for Payables that you can audit.
AP_SYSTEM_PARAMETERS_ALL
Object name on the Configure Business Object Attributes page: General Payables Options
The AP_SYSTEM_PARAMETERS_ALL table stores the parameters and defaults you define for operating your Payables application. This table contains information such as your set of books, functional currency and payment terms. Your Payables application also uses this information to identify default values that cascade down to supplier and invoice entry. This table corresponds to the Manage Invoice Options and Manage Payment Options tasks under Define General Payables Options task. AP_SYSTEM_PARAMETERS_ALL_ is the audit table for AP_SYSTEM_PARAMETERS_ALL. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Create interest invoices | AUTO_CALCULATE_INTEREST_FLAG | Option that indicates whether interest invoices are automatically created for past due invoice payments (Y or N). | Yes |
Invoice Currency | INVOICE_CURRENCY_CODE | Default invoice currency code that defaults on the supplier sites associated with the business unit. | Yes |
Always take discount | ALWAYS_TAKE_DISC_FLAG | Option that indicates if an available discount for a supplier will be taken, regardless of when the invoice is paid (Y or N). | Yes |
Accounting Date Basis | GL_DATE_FROM_RECEIPT_FLAG | Date used as the accounting date during invoice entry. | No |
Exclude tax from calculation | DISC_IS_INV_LESS_TAX_FLAG | Option that indicates if tax amount is excluded from invoice amount when invoice amount applicable to discount calculated (Y or N). | Yes |
Allow payment date before the system date | POST_DATED_PAYMENTS_FLAG | Option that indicates whether the payment date can be before system date (Y or N). | Yes |
Minimum interest amount | INTEREST_TOLERANCE_AMOUNT | Minimum interest amount owed on past due invoice for interest invoice to be automatically created. | Yes |
Interest Expense Distribution | INTEREST_CODE_COMBINATION_ID | Accounting Flexfield identifier for interest expense account. | Yes |
Discount Allocation Method | DISCOUNT_DISTRIBUTION_METHOD | Method for distributing discount amounts taken on invoice payments. | Yes |
Use combined filing program | COMBINED_FILING_FLAG | Option that indicates whether your organization participates in the Combined Filing Program for income tax reporting. | Yes |
Income Tax Region | INCOME_TAX_REGION | Default income tax region assigned to invoice lines for 1099 suppliers. | Yes |
Use supplier tax region | INCOME_TAX_REGION_FLAG | A value of Y indicates that you use supplier tax region as the default Income Tax Region for 1099. invoice lines. | Yes |
Allow Final Matching | ALLOW_FINAL_MATCH_FLAG | Option that indicates whether you allow final matching to purchase orders. | Yes |
Allow Matching distribution override | ALLOW_FLEX_OVERRIDE_FLAG | Option that indicates whether you can override the matching Accounting Flexfield for an invoice distribution matched to a purchase order distribution line. | Yes |
Allow adjustments to paid invoices | ALLOW_PAID_INVOICE_ADJUST | Option that indicates whether you allow adjustments to paid invoices. | Yes |
Allow document category override | INV_DOC_CATEGORY_OVERRIDE | Option that indicates whether you can override the default document category (Sequential Numbering) for invoices. | Yes |
Transfer PO distribution additional information | TRANSFER_DESC_FLEX_FLAG | A value of Y indicates the application 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. | Yes |
Use withholding tax | ALLOW_AWT_FLAG | Option to indicate whether Automatic Withholding Tax is allowed (Y or N). | Yes |
Withholding Tax Group | DEFAULT_AWT_GROUP_ID | Default Withholding Tax group for new suppliers. | Yes |
Allow manual withholding | ALLOW_AWT_OVERRIDE | Option to indicate whether override of withholding tax amount is allowed (Y, N, null). | Yes |
Apply withholding tax | CREATE_AWT_DISTS_TYPE | Indicates when the application should automatically create withholding tax invoices. Possible values are Never, Validation, or Payment. | Yes |
Create Withholding Invoice | CREATE_AWT_INVOICES_TYPE | Indicates when the application should automatically create withholding tax invoices (Never, Invoice Validation, Payment). | Yes |
Withholding Amount Basis to include discount amount | AWT_INCLUDE_DISCOUNT_AMT | Option to indicate whether the discount amount is included in withholding tax calculation. | Yes |
Withholding Amount Basis to include tax amount | AWT_INCLUDE_TAX_AMT | Option to indicate whether the tax amount is included in the withholding tax calculation. | Yes |
Allow override of supplier site bank account | ALLOW_SUPPLIER_BANK_OVERRIDE | Option to indicate whether user can charge remit-to bank at payment creation time. | Yes |
Account for Payment | WHEN_TO_ACCOUNT_PMT | Defines when accounting entries for payments will be created. | Yes |
Enable invoice approval | APPROVAL_WORKFLOW_FLAG | Select this check box value to enable invoice approval. | Yes |
Allow Force Approval | ALLOW_FORCE_APPROVAL_FLAG | 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. | Yes |
Include withholding distributions in income tax reports | ENABLE_1099_ON_AWT_FLAG | Select this check box value is you want to include Withholding Distribution in Income Tax Reports. | Yes |
Quantity Tolerances | TOLERANCE_ID | A unique identifier for tolerance template that's used for goods tolerance. | Yes |
Amount Tolerances | SERVICES_TOLERANCE_ID | Services tolerance template identifier. | Yes |
Receipt Acceptance Days | RECEIPT_ACCEPTANCE_DAYS | Number of days in receipt acceptance period. | Yes |
Exclude Freight from Discount | EXCLUDE_FREIGHT_FROM_DISCOUNT | Exclude Freight From Discount Identifier. | Yes |
Interest Allocation Method | PRORATE_INT_INV_ACROSS_DISTS | Used to display the 'Interest' Allocation method in Accounting Option label. | Yes |
Allow Unit Price change for Quantity-Based Matches | SS_UPRICE_CHANGE_FOR_QTYMATCH | Setting that indicates whether unit price change is allowed for purchase order matched self-service invoice. | Yes |
Allow invoice backdating | SS_INVOICE_BACKDATING_FLAG | Indicates whether a self-service invoice can have invoice date before system date. | Yes |
Self Service Invoices to limit invoices to a single purchase order | SS_LIMIT_TO_SINGLE_PO_FLAG | Indicates whether a self-service invoice can be matched to multiple purchase orders. | Yes |
Require Invoice Grouping | REQUIRE_INVOICE_GROUP_FLAG | Setting that indicates whether invoice group is required during invoice entry. | Yes |
Recalculate invoice installments | RECALC_PAY_SCHEDULE_FLAG | Option that indicates whether Recalculate Payment Installments (Y or N). | Yes |
Budget Date Basis | BUDGET_DATE_BASIS | Budget Date Basis to default the budget date on invoice transactions. | Yes |
FINANCIALS_SYSTEM_PARAMS_ALL
Object name on the Configure Business Object Attributes page: Common Options for Payables and Procurement
The FINANCIALS_SYSTEM_PARAMETERS_ALL table stores options and defaults you share between your Payables application, and your Purchasing and Assets applications. You can define these options and defaults according to the way you run your business. This table corresponds to the Manage Common Options for Payables and Procurement task. FINANCIALS_SYSTEM_PARAMS_ALL_ is the audit table for FINANCIALS_SYSTEM_PARAMS_ALL. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Bill-to Location | BILL_TO_LOCATION_ID | Bill-to location identifier, default used during supplier entry. | Yes |
Liability Distribution | ACCTS_PAY_CODE_COMBINATION_ID | Accounting Flexfield identifier for the accounts payable liability account and default used during supplier entry. | Yes |
Prepayment Distribution | PREPAY_CODE_COMBINATION_ID | Accounting Flexfield identifier for the prepayment account and default used during supplier entry. | Yes |
Discount Taken Distribution | DISC_TAKEN_CODE_COMBINATION_ID | Accounting Flexfield identifier for the discount taken account. | Yes |
VAT Registration Number | VAT_REGISTRATION_NUM | Value-Added Tax registration number for your organization. | Yes |
VAT Registration Member State | VAT_COUNTRY_CODE | European Union (EU) member state for your organization. | Yes |
Conversion Rate Variance Gain | RATE_VAR_GAIN_CCID | Accounting Flexfield identifier for account used to record exchange rate gains for invoices matched to purchase orders. | Yes |
Conversion Rate Variance Loss | RATE_VAR_LOSS_CCID | Accounting Flexfield identifier for account used to record exchange rate losses for invoices matched to purchase orders. | Yes |
Bill Payable Distribution | FUTURE_DATED_PAYMENT_CCID | Accounting Flexfield identifier for future dated payment account default for Suppliers and Bank accounts. | Yes |
Miscellaneous Distribution | MISC_CHARGE_CCID | Accounting flexfield identifier for the accounts payable miscellaneous account, which is used for supplier portal Invoices. | Yes |
Buying Company Identifier | BUYING_COMPANY_IDENTIFIER | A unique identifier that identifies the buying business unit. The identifier is included on the invoice number of invoices created by the pay on receipt process or debit memos from return on receipt transactions. | Yes |
Expense Accrual Distributions | EXPENSE_ACCRUAL_CCID | Expense Accrual Account Code Combination Identifier. | Yes |
Gapless Invoice Numbering | GAPLESS_INV_NUM_FLAG | Gapless Invoice Numbering Option. | Yes |
Accrue Expense Items | EXPENSE_ACCRUAL_CODE | Defines accrue expense items options. | Yes |
Conversion Rate type | DEFAULT_EXCHANGE_RATE_TYPE | Specifies the default conversion rate type when you enter invoices or create payments. | Yes |
Automatic Offsets | AUTOMATIC_OFFSETS_FLAG | An option that allows overriding of either the primary balancing segment or all segments, except the natural account segment when creating the liability account. | Yes |
Realized Gain Distribution | GAIN_CODE_COMBINATION_ID | Accounting Flexfield identifier for account to which realized exchange rate gains are posted. | Yes |
Realized Loss Distribution | LOSS_CODE_COMBINATION_ID | Accounting Flexfield identifier for account to which realized exchange rate losses are posted. | Yes |
Require conversion rate entry | MAKE_RATE_MANDATORY_FLAG | Option that indicates whether exchange rates must be entered for multiple currency invoices and payments (Y or N). | Yes |
Freight Distribution | FREIGHT_CODE_COMBINATION_ID | Accounting Flexfield identifier for accounts payable freight account. | Yes |
Prepayment Tax Difference | PREPAY_TAX_DIFF_CCID | Account to which any prepayment tax difference amount will be charged. | Yes |
Require Conversion Rate Entry | MAKE_RATE_MANDATORY_PMT_FLAG | Require Conversion Rate Information for Payments. | No |
Payment Conversion Rate Type | DEFAULT_PMT_EXCHANGE_RATE_TYPE | Payment Conversion Rate Type. | No |
AP_TOLERANCE_TEMPLATES
Object name on the Configure Business Object Attributes page: Invoice Tolerances
The AP_TOLERANCE_TEMPLATES table stores the tolerance levels you set for matching and invoice variance testing. Payables uses this information to decide during Invoice Validation whether to apply a hold to an invoice for exceeding tolerance. AP_TOLERANCE_TEMPLATES_ is the audit table for AP_TOLERANCE_TEMPLATES. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Name | TOLERANCE_NAME | Name of the tolerance template. | Yes |
Description | DESCRIPTION | Description of the tolerance template. | No |
Price Percentage | PRICE_TOLERANCE | Percentage based tolerance level for price variance. | Yes |
Ordered Percentage | QUANTITY_TOLERANCE | Percentage based tolerance level for quantity variance. | Yes |
Received Percentage | QTY_RECEIVED_TOLERANCE | Percentage based tolerance level for quantity received tolerance. | Yes |
Maximum Ordered | MAX_QTY_ORD_TOLERANCE | Tolerance level for maximum quantity ordered variance. | Yes |
Maximum Received | MAX_QTY_REC_TOLERANCE | Tolerance level for maximum quantity received variance. | Yes |
Schedule Amount | SHIP_AMT_TOLERANCE | Tolerance level for purchase order shipment amount variance | Yes |
Conversion Rate Amount | RATE_AMT_TOLERANCE | Tolerance level for exchange rate amount variance. | Yes |
Total Amount | TOTAL_AMT_TOLERANCE | Tolerance level for total amount variance. | Yes |
Type | TOLERANCE_TYPE | Chooses the type of tolerance template as either Goods or Services. | Yes |
Consumed Percentage | QTY_CONSUMED_TOLERANCE | Tolerance level for comparison of billed quantity with consumed quantity expressed as a percentage. | Yes |
Maximum Consumed | MAX_QTY_CON_TOLERANCE | Tolerance level for comparison of billed quantity with consumed quantity expressed as an absolute value. | Yes |
AP_REPORTING_ENTITIES_ALL
Object name on the Configure Business Object Attributes page: Reporting Entities
The AP_REPORTING_ENTITIES_ALL table stores the information about the reporting entities you define for 1099 reporting. This table corresponds to the Manage Reporting Entities task. AP_REPORTING_ENTITIES_ALL_ is the audit table for AP_REPORTING_ENTITIES_ALL. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Taxpayer ID | TAX_IDENTIFICATION_NUM | Tax identification number for reporting entity. | Yes |
Name | ENTITY_NAME | Name of the reporting entity for tax reporting. | Yes |
Location | LOCATION_ID | Location identifier for reporting entity. | Yes |
Business Unit | ORG_ID | Indicates the identifier of the business unit associated with the row. | Yes |
Global Attribute Category | GLOBAL_ATTRIBUTE_CATEGORY | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | No |
Global Attribute 1 | GLOBAL_ATTRIBUTE1 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 2 | GLOBAL_ATTRIBUTE2 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 3 | GLOBAL_ATTRIBUTE3 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 4 | GLOBAL_ATTRIBUTE4 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 5 | GLOBAL_ATTRIBUTE5 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 6 | GLOBAL_ATTRIBUTE6 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 7 | GLOBAL_ATTRIBUTE7 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 8 | GLOBAL_ATTRIBUTE8 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 9 | GLOBAL_ATTRIBUTE9 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 10 | GLOBAL_ATTRIBUTE10 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 11 | GLOBAL_ATTRIBUTE11 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 12 | GLOBAL_ATTRIBUTE12 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 13 | GLOBAL_ATTRIBUTE13 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 14 | GLOBAL_ATTRIBUTE14 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 15 | GLOBAL_ATTRIBUTE15 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 16 | GLOBAL_ATTRIBUTE16 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 17 | GLOBAL_ATTRIBUTE17 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 18 | GLOBAL_ATTRIBUTE18 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 19 | GLOBAL_ATTRIBUTE19 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
Global Attribute 20 | GLOBAL_ATTRIBUTE20 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | No |
AP_REPORTING_ENTITY_LINES_ALL
Object name on the Configure Business Object Attributes page: Balancing Segment Values
The AP_REPORTING_ENTITY_LINES_ALL table stores the line information for the tax reporting entities you define. This table corresponds to the Balancing Segment Values section of the Manage Reporting Entities task. AP_REPORTING_ENTITY_LINES_ALL_ is the audit table for AP_REPORTING_ENTITY_LINES_ALL. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Primary Balancing Segment Value | BALANCING_SEGMENT_VALUE | Balancing segment value for reporting entity Accounting Flexfield. | Yes |
Business Unit | ORG_ID | Indicates the identifier of the business unit associated with the row. | Yes |
AP_BANK_CHARGES
Object name on the Configure Business Object Attributes page: Bank Charges
The AP_BANK_CHARGES table stores header information that you enter on the bank charges page. This table corresponds to the Manage Bank Charges task. AP_BANK_CHARGES_ is the audit table for AP_BANK_CHARGES. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Transferring Bank Branch ID | TRANSFERRING_BANK_BRANCH_ID | Transferring bank branch identifier. | Yes |
Transferring Bank Name | TRANSFERRING_BANK_NAME | Bank of customer, which transfers payment to supplier bank. | Yes |
Transferring Bank Option | TRANSFERRING_BANK | Transferring bank. Valid values are ONE for specific bank and ALL when bank charge is applicable to all transferring banks. | Yes |
Transferring Branch Option | TRANSFERRING_BRANCH | Transferring branch. Valid values are ONE for specific branch and ALL when bank charge is applicable to all transferring branches of transferring bank specified. | Yes |
Receiving Bank Branch ID | RECEIVING_BANK_BRANCH_ID | Receiving bank branch identifier. | Yes |
Receiving Bank Name | RECEIVING_BANK_NAME | Bank of supplier, which receives payment from customer bank. | Yes |
Receiving Bank Option | RECEIVING_BANK | Receiving branch. Valid values are ONE for specific bank, ALL for when charge is applicable to all receiving banks, and OTHER for bank other than the transferring bank. | Yes |
Receiving Branch Option | RECEIVING_BRANCH | Receiving branch. Valid values are ONE for specific branch, ALL for when charge is applicable to all receiving branches, and OTHER for branch other than the transferring branch. | Yes |
Settlement Priority | SETTLEMENT_PRIORITY | Settlement priority. Valid values are EXPRESS and NORMAL. | Yes |
Currency | CURRENCY_CODE | Currency used to define bank charges. | Yes |
Attribute Category | ATTRIBUTE_CATEGORY | Descriptive Flexfield: structure definition of the user descriptive flexfield. | No |
Attribute 1 | ATTRIBUTE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 2 | ATTRIBUTE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 3 | ATTRIBUTE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 4 | ATTRIBUTE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 5 | ATTRIBUTE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 6 | ATTRIBUTE6 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 7 | ATTRIBUTE7 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 8 | ATTRIBUTE8 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 9 | ATTRIBUTE9 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 10 | ATTRIBUTE10 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 11 | ATTRIBUTE11 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 12 | ATTRIBUTE12 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 13 | ATTRIBUTE13 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 14 | ATTRIBUTE14 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 15 | ATTRIBUTE15 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Number 1 | ATTRIBUTE_NUMBER1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Number 2 | ATTRIBUTE_NUMBER2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Number 3 | ATTRIBUTE_NUMBER3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Number 4 | ATTRIBUTE_NUMBER4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Number 5 | ATTRIBUTE_NUMBER5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Date 1 | ATTRIBUTE_DATE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Date 2 | ATTRIBUTE_DATE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Date 3 | ATTRIBUTE_DATE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Date 4 | ATTRIBUTE_DATE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Date 5 | ATTRIBUTE_DATE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Legal Entity | LEGAL_ENTITY_ID | Legal entity identifier. | Yes |
AP_BANK_CHARGE_LINES
Object name on the Configure Business Object Attributes page: Bank Charges Details
The AP_BANK_CHARGE_LINES table stores ranges for bank charges. This table corresponds to the Bank Charge Details section of the Manage Bank Charges task. AP_BANK_CHARGE_LINES_ is the audit table for AP_BANK_CHARGE_LINES. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
From Payment Amount | TRANS_AMOUNT_FROM | The end payment amount (lower amount) for given amount range. | Yes |
To Payment Amount | TRANS_AMOUNT_TO | The start payment amount (higher amount) for given amount range. | Yes |
Standard Bank Charge Amount | BANK_CHARGE_STANDARD | The bank charge amount at standard rate. | Yes |
Negotiated Bank Charge Amount | BANK_CHARGE_NEGOTIATED | The bank charge amount at negotiated rate. | Yes |
From Date | START_DATE | The start date to apply the bank charge at the specified amount. | Yes |
To Date | END_DATE | The end date to apply the bank charge at the specified amount. | Yes |
Attribute Category | ATTRIBUTE_CATEGORY | Descriptive Flexfield: structure definition of the user descriptive flexfield. | No |
Attribute 1 | ATTRIBUTE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 2 | ATTRIBUTE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 3 | ATTRIBUTE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 4 | ATTRIBUTE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 5 | ATTRIBUTE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 6 | ATTRIBUTE6 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 7 | ATTRIBUTE7 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 8 | ATTRIBUTE8 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 9 | ATTRIBUTE9 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 10 | ATTRIBUTE10 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 11 | ATTRIBUTE11 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 12 | ATTRIBUTE12 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 13 | ATTRIBUTE13 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 14 | ATTRIBUTE14 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 15 | ATTRIBUTE15 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Number 1 | ATTRIBUTE_NUMBER1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Number 2 | ATTRIBUTE_NUMBER2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Number 3 | ATTRIBUTE_NUMBER3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Number 4 | ATTRIBUTE_NUMBER4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Number 5 | ATTRIBUTE_NUMBER5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Date 1 | ATTRIBUTE_DATE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Date 2 | ATTRIBUTE_DATE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Date 3 | ATTRIBUTE_DATE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Date 4 | ATTRIBUTE_DATE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute Date 5 | ATTRIBUTE_DATE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
AP_INTEREST_PERIODS
Object name on the Configure Business Object Attributes page: Interest Rates
The AP_INTEREST_PERIODS table stores information about interest rates and periods that Payables uses to create invoices to pay interest owed on overdue invoices. This interest is calculated in accordance with the U.S. Prompt Payment Act. This table corresponds to the Manage Interest Rates task. AP_INTEREST_PERIODS is the audit table for AP_INTEREST_PERIODS. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Rate | ANNUAL_INTEREST_RATE | Interest rate applicable for a given period. | Yes |
From Date | START_DATE | Start date of a given interest period. | Yes |
To Date | END_DATE | End date of a given interest period. | Yes |
AP_TERMS_B
Object name on the Configure Business Object Attributes page: Payment Terms
The AP_TERMS_B table stores header information about payment terms you define. You need one row for each type of terms you use to create scheduled payments for invoices. When you enter suppliers or invoices, you can select payment terms you've defined in this table. Each terms must have one or more terms lines. This table corresponds to the Manage Payment Terms task. AP_TERMS_B_ is the audit table for AP_TERMS_B. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Name | TERM_ID | A unique identifier for the payment term. | Yes |
From Date | START_DATE_ACTIVE | Date from which payment term is valid. | Yes |
To Date | END_DATE_ACTIVE | Date after which payment term is invalid. | Yes |
Cutoff Day | DUE_CUTOFF_DAY | Used for certain terms only, day of a month after which Payables schedules payment using a day after the current month. | Yes |
Rank | RANK | Unique rank to rate invoice payment terms against purchase order payment terms in accordance with Prompt Payment Act. | Yes |
Attribute Category | ATTRIBUTE_CATEGORY | Descriptive Flexfield: structure definition of the user descriptive flexfield. | No |
Attribute 1 | ATTRIBUTE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 2 | ATTRIBUTE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 3 | ATTRIBUTE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 4 | ATTRIBUTE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 5 | ATTRIBUTE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 6 | ATTRIBUTE6 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 7 | ATTRIBUTE7 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 8 | ATTRIBUTE8 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 9 | ATTRIBUTE9 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 10 | ATTRIBUTE10 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 11 | ATTRIBUTE11 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 12 | ATTRIBUTE12 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 13 | ATTRIBUTE13 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 14 | ATTRIBUTE14 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 15 | ATTRIBUTE15 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
AP_TERMS_LINES
Object name on the Configure Business Object Attributes page: Installments
The AP_TERMS_LINES table stores detail information about payment terms you define. This table corresponds to the Installments and Discount sections of the Manage Payment Terms task. AP_TERMS_LINES_ is the audit table for AP_TERMS_LINES. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Name | TERM_ID | A unique identifier for the payment term. | Yes |
Sequence Number | SEQUENCE_NUM | Number of the payment term line. | Yes |
Due Percentage | DUE_PERCENT | Percentage of payment due by a certain date. | Yes |
Amount Due | DUE_AMOUNT | Maximum of payment amount due by a certain date. | Yes |
Days | DUE_DAYS | Number of days after terms date, used to calculate due date of invoice payment line. | Yes |
Day of Month | DUE_DAY_OF_MONTH | Day of month used to calculate due date of invoice payment line. | Yes |
Months Ahead | DUE_MONTHS_FORWARD | Number of months ahead, used to calculate due date of invoice payment line. | Yes |
First Discount Percentage | DISCOUNT_PERCENT | Percentage used to calculate discount available for invoice payment line. | Yes |
First Discount Days | DISCOUNT_DAYS | Number of days after terms date, used to calculate discount date for invoice payment line. | Yes |
First Discount Day of Month | DISCOUNT_DAY_OF_MONTH | Day of month used to calculate discount date for invoice payment line. | Yes |
First Discount Months Ahead | DISCOUNT_MONTHS_FORWARD | Number of months ahead used to calculate discount date for invoice payment line. | Yes |
Second Discount Percentage | DISCOUNT_PERCENT_2 | Percentage used to calculate second discount available for invoice payment line. | Yes |
Second Discount Days | DISCOUNT_DAYS_2 | Number of days after terms date, used to calculate second discount available for invoice payment line | Yes |
Second Discount Day of Month | DISCOUNT_DAY_OF_MONTH_2 | Day of month used to calculate second discount available for invoice payment line. | Yes |
Second Discount Months Ahead | DISCOUNT_MONTHS_FORWARD_2 | Number of months ahead, used to calculate discount available for invoice payment line. | Yes |
Third Discount Percentage | DISCOUNT_PERCENT_3 | Percentage used to calculate third discount available for invoice payment line. | Yes |
Third Discount Days | DISCOUNT_DAYS_3 | Number of days after terms date, used to calculate third discount for invoice payment line. | Yes |
Third Discount Day of Month | DISCOUNT_DAY_OF_MONTH_3 | Day of month used to calculate third discount for invoice payment line. | Yes |
Third Discount Months Ahead | DISCOUNT_MONTHS_FORWARD_3 | Number of months ahead, used to calculate third discount for invoice payment line. | Yes |
Attribute Category | ATTRIBUTE_CATEGORY | Descriptive Flexfield: structure definition of the user descriptive flexfield. | No |
Attribute 1 | ATTRIBUTE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 2 | ATTRIBUTE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 3 | ATTRIBUTE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 4 | ATTRIBUTE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 5 | ATTRIBUTE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 6 | ATTRIBUTE6 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 7 | ATTRIBUTE7 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 8 | ATTRIBUTE8 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 9 | ATTRIBUTE9 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 10 | ATTRIBUTE10 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 11 | ATTRIBUTE11 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 12 | ATTRIBUTE12 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 13 | ATTRIBUTE13 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 14 | ATTRIBUTE14 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 15 | ATTRIBUTE15 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Fixed Date | FIXED_DATE | Payment term attribute that indicates the payment due date. | Yes |
Calendar | CALENDAR | Name of special calendar associated with the term line. | Yes |
AP_TERMS_ST
Object name on the Configure Business Object Attributes page: Set Assignments
The AP_TERMS_ST table stores Set ID information for the payment terms you define. This table corresponds to the Set Assignments section of the Manage Payment Terms task. AP_TERMS_ST_ is the audit table for AP_TERMS_ST. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Name | TERM_ID | Payment term unique identifier. | Yes |
Set Code | SET_ID | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they're used to filter reference data in transactional UIs. | Yes |
AP_HOLD_CODES
Object name on the Configure Business Object Attributes page: Invoice Holds and Releases
The AP_HOLD_CODES table stores information about hold codes and release codes that you or your Payables application can place on an invoice. This table corresponds to the Manage Invoice Holds and Releases task. AP_HOLD_CODES_ is the audit table for AP_HOLD_CODES. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Name | HOLD_LOOKUP_CODE | Name of the hold code created to be applied on an invoice. | Yes |
Type | HOLD_TYPE | Hold type that's to be applied on an invoice. | Yes |
Allow Manual Release | USER_RELEASEABLE_FLAG | Indicates if a hold can be released by a user (Y or N). | Yes |
Inactive Date | INACTIVE_DATE | Date when the hold will be inactive. | Yes |
Allow Accounting | POSTABLE_FLAG | Indicates whether this hold should prevent the invoice from being accounted. | Yes |
Hold Instruction | HOLD_INSTRUCTION | Instruction to resolve the hold. | Yes |
Days Before Notifying | WAIT_BEFORE_NOTIFY_DAYS | Specify the number of days to wait before sending the notification. | Yes |
Days Before Reminding | REMINDER_DAYS | Specify the number of days to wait before sending the reminder notification. | Yes |
Allow Holds Resolution Routing | INITIATE_WORKFLOW_FLAG | Enable this to initiate the Hold Negotiation Workflow for the hold. | Yes |
AP_DISTRIBUTION_SETS_ALL
Object name on the Configure Business Object Attributes page: Distribution Sets
The AP_DISTRIBUTION_SETS_ALL table stores information about Distribution Sets you define to distribute invoices automatically. AP_DISTRIBUTION_SETS_ALL_ is the audit table for AP_DISTRIBUTION_SETS_ALL. This table corresponds to the Manage Distribution Sets task. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Name | DISTRIBUTION_SET_NAME | Name of invoice distribution set created. | Yes |
Description | DESCRIPTION | Description of invoice distribution set created. | Yes |
Distribution Percentage | TOTAL_PERCENT_DISTRIBUTION | Sum of the distribution percents for each of the distribution set lines. | Yes |
Inactive Date | INACTIVE_DATE | Date by when the distribution set will become inactive. | Yes |
Attribute Category | ATTRIBUTE_CATEGORY | Descriptive Flexfield: structure definition of the user descriptive flexfield. | No |
Attribute 1 | ATTRIBUTE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 2 | ATTRIBUTE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 3 | ATTRIBUTE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 4 | ATTRIBUTE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 5 | ATTRIBUTE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 6 | ATTRIBUTE6 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 7 | ATTRIBUTE7 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 8 | ATTRIBUTE8 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 9 | ATTRIBUTE9 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 10 | ATTRIBUTE10 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 11 | ATTRIBUTE11 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 12 | ATTRIBUTE12 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 13 | ATTRIBUTE13 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 14 | ATTRIBUTE14 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 15 | ATTRIBUTE15 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Business Unit | ORG_ID | Indicates the identifier of the business unit associated with the row. | Yes |
AP_DISTRIBUTION_SET_LINES_ALL
Object name on the Configure Business Object Attributes page: Distribution Set Details
The AP_DISTRIBUTION_SET_LINES_ALL table stores detailed information about individual distribution lines you define for a Distribution Set. This table corresponds to the Distribution Set Details section of the Manage Distribution Sets task. AP_DISTRIBUTION_SET_LINES_ALL_ is the audit table for AP_DISTRIBUTION_SET_LINES_ALL. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Distribution Combination | DIST_CODE_COMBINATION_ID | Accounting Flexfield identifier for account associated with Distribution Set line. | Yes |
Distribution | PERCENT_DISTRIBUTION | Percent of invoice amount to allocate to Distribution Set line. | Yes |
Income Tax Type | TYPE_1099 | Type of 1099 tax associated with distribution line. | Yes |
Description | DESCRIPTION | Description of distribution set line. | No |
Line | DISTRIBUTION_SET_LINE_NUMBER | Invoice Distribution Set line identifier. | No |
Attribute Category | ATTRIBUTE_CATEGORY | Descriptive Flexfield: structure definition of the user descriptive flexfield. | No |
Attribute 1 | ATTRIBUTE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 2 | ATTRIBUTE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 3 | ATTRIBUTE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 4 | ATTRIBUTE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 5 | ATTRIBUTE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 6 | ATTRIBUTE6 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 7 | ATTRIBUTE7 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 8 | ATTRIBUTE8 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 9 | ATTRIBUTE9 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 10 | ATTRIBUTE10 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 11 | ATTRIBUTE11 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 12 | ATTRIBUTE12 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 13 | ATTRIBUTE13 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 14 | ATTRIBUTE14 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 15 | ATTRIBUTE15 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Project Accounting Context | PROJECT_ACCOUNTING_CONTEXT | Oracle Projects Descriptive Flexfield context column. | No |
Task Number | TASK_ID | Identifier for project task used to build Accounting Flexfield for Distribution Set line. | No |
Project Number | PROJECT_ID | Identifier for project used to build Accounting Flexfield for Distribution Set line. | No |
Expenditure Organization | EXPENDITURE_ORGANIZATION_ID | Identifier for project organization used to build Accounting Flexfield for Distribution Set line | No |
Expenditure Type | EXPENDITURE_TYPE | Project expenditure type used to build Accounting Flexfield for Distribution Set line. | No |
Business Unit | ORG_ID | Indicates the identifier of the business unit associated with the row. | Yes |
Award Number | AWARD_ID | If Grants Accounting is installed, the award ID is used with data in project columns to track grant information. | No |
AP_AGING_PERIODS
Object name on the Configure Business Object Attributes page: Aging Periods
The AP_AGING_PERIODS table stores aging periods that you define for use in the Invoice Aging Report. This table corresponds to the Manage Aging Periods task. AP_AGING_PERIODS_ is the audit table for AP_AGING_PERIODS. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Aging Period ID | AGING_PERIOD_ID | Unique identifier of aging period defined in application. | Yes |
Name | PERIOD_NAME | Name of aging period defined in system. | Yes |
Description | DESCRIPTION | Description of aging period defined. | No |
Active | STATUS | Status of aging period. | Yes |
Attribute Category | ATTRIBUTE_CATEGORY | Descriptive Flexfield: structure definition of the user descriptive flexfield. | No |
Attribute 1 | ATTRIBUTE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 2 | ATTRIBUTE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 3 | ATTRIBUTE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 4 | ATTRIBUTE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 5 | ATTRIBUTE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 6 | ATTRIBUTE6 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 7 | ATTRIBUTE7 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 8 | ATTRIBUTE8 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 9 | ATTRIBUTE9 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 10 | ATTRIBUTE10 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 11 | ATTRIBUTE11 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 12 | ATTRIBUTE12 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 13 | ATTRIBUTE13 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 14 | ATTRIBUTE14 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 15 | ATTRIBUTE15 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
AP_AGING_PERIOD_LINES
Object name on the Configure Business Object Attributes page: Aging Period Details
The AP_AGING_PERIOD_LINES table stores information on individual aging periods. This table corresponds to the Aging Period Details section of the Manage Aging Periods task. AP_AGING_PERIOD_LINES_ is the audit table for AP_AGING_PERIOD_LINES. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Aging Period Line ID | AGING_PERIOD_LINE_ID | Unique identifier of aging period line defined as part of aging period setup. | Yes |
Column Order | PERIOD_SEQUENCE_NUM | Order of this particular date range within the entire period. | Yes |
From | DAYS_START | Starting day number for aging period line. | Yes |
To | DAYS_TO | Ending day number for aging period line. | Yes |
First | REPORT_HEADING1 | First column heading for aging period line. | Yes |
Second | REPORT_HEADING2 | Second column heading for aging period line. | Yes |
Attribute Category | ATTRIBUTE_CATEGORY | Descriptive Flexfield: structure definition of the user descriptive flexfield. | No |
Attribute 1 | ATTRIBUTE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 2 | ATTRIBUTE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 3 | ATTRIBUTE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 4 | ATTRIBUTE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 5 | ATTRIBUTE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 6 | ATTRIBUTE6 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 7 | ATTRIBUTE7 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 8 | ATTRIBUTE8 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 9 | ATTRIBUTE9 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 10 | ATTRIBUTE10 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 11 | ATTRIBUTE11 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 12 | ATTRIBUTE12 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 13 | ATTRIBUTE13 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 14 | ATTRIBUTE14 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 15 | ATTRIBUTE15 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
AP_INCOME_TAX_REGIONS
Object name on the Configure Business Object Attributes page: Tax Regions
The AP_INCOME_TAX_REGIONS table stores information about the tax regions you use to record payment information for 1099 suppliers when your organization participates in the Combined Filing Program. This table corresponds to the Manage Tax Regions task. AP_INCOME_TAX_REGIONS_ is the audit table for AP_INCOME_TAX_REGIONS. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
State | REGION_SHORT_NAME | Abbreviated income tax region name (identifies income tax region for 1099 supplier sites). | Yes |
Description | REGION_LONG_NAME | Full name of income tax region applicable for 1099 taxes. | Yes |
Code | REGION_CODE | Region code for income tax regions participating in the Combined Filing Program. | Yes |
Amount | REPORTING_LIMIT | Minimum reporting amount for income tax region participating in the Combined Filing Program. | Yes |
From Date | ACTIVE_DATE | Date from when the income tax region is active. | Yes |
To Date | INACTIVE_DATE | Date income tax region inactive. | Yes |
Method | REPORTING_LIMIT_METHOD_CODE | Method for calculating reporting limit for region. | Yes |
AP_OTHER_PERIOD_TYPES
Object name on the Configure Business Object Attributes page: Payables Calendars
The AP_OTHER_PERIOD_TYPES table stores the period type you define and use to create recurring invoice, automatic withholding tax, key indicators and payment terms periods. This table corresponds to the Manage Payables Calendars task. AP_OTHER_PERIOD_TYPES_ is the audit table for AP_OTHER_PERIOD_TYPES. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Name | CALENDAR_NAME | Name given to a calendar that's used in Payables. | Yes |
To Date | EFFECTIVE_TO | Effective To date of the calendar. | Yes |
From Date | EFFECTIVE_FROM | Effective From date of the calendar. | Yes |
Calendar Type | CALENDAR_TYPE | Type of the calendar, either GENERAL or PAYMENT TERMS. | Yes |
Description | DESCRIPTION | Statement, picture in words, or account that describes; descriptive representation. | No |
Attribute Category | ATTRIBUTE_CATEGORY | Descriptive Flexfield: structure definition of the user descriptive flexfield. | No |
Attribute 1 | ATTRIBUTE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 2 | ATTRIBUTE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 3 | ATTRIBUTE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 4 | ATTRIBUTE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 5 | ATTRIBUTE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 6 | ATTRIBUTE6 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 7 | ATTRIBUTE7 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 8 | ATTRIBUTE8 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 9 | ATTRIBUTE9 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 10 | ATTRIBUTE10 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 11 | ATTRIBUTE11 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 12 | ATTRIBUTE12 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 13 | ATTRIBUTE13 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 14 | ATTRIBUTE14 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 15 | ATTRIBUTE15 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
AP_OTHER_PERIODS
Object name on the Configure Business Object Attributes page: Period Information
The AP_OTHER_PERIODS table stores information about the time periods you define for use in recurring invoices, withholding taxes, key indicators and payment terms. This table corresponds to the Period Information section of the Manage Payables Calendars task. AP_OTHER_PERIODS_ is the audit table for AP_OTHER_PERIODS. The following table shows the fields that you can enable for auditing.
Audit Attribute | Table Column | Description | Audit-Enabled by Default |
---|---|---|---|
Start Date | START_DATE | Date from when a record isn't available for transacting. Use date enabled entities when history isn't stored. | Yes |
End Date | END_DATE | Date from when a record isn't available for transacting. Use date enabled entities when history isn't stored. | Yes |
Sequence | PERIOD_NUM | Order of periods within a payables calendar. | Yes |
Attribute Category | ATTRIBUTE_CATEGORY | Descriptive Flexfield: structure definition of the user descriptive flexfield. | No |
Attribute 1 | ATTRIBUTE1 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 2 | ATTRIBUTE2 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 3 | ATTRIBUTE3 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 4 | ATTRIBUTE4 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 5 | ATTRIBUTE5 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 6 | ATTRIBUTE6 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 7 | ATTRIBUTE7 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 8 | ATTRIBUTE8 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 9 | ATTRIBUTE9 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 10 | ATTRIBUTE10 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 11 | ATTRIBUTE11 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 12 | ATTRIBUTE12 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 13 | ATTRIBUTE13 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 14 | ATTRIBUTE14 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Attribute 15 | ATTRIBUTE15 | Descriptive Flexfield: segment of the user descriptive flexfield. | No |
Due Date | DUE_DATE | Date associated with a payables calendar period that indicates when an invoice payment is due. This is only applicable to payables calendars with a type of payment terms. | Yes |
Calendar Name | PERIOD_ID | Identifier of the created period. | Yes |