| Payables - AP_TERMS_TL | Payment term definitions |
|---|---|
| Column Name | Descritpion |
| TERM_ID | Term identifier |
| DESCRIPTION | Description |
| TYPE | No longer used |
| START_DATE_ACTIVE | Date from which payment term is valid |
| END_DATE_ACTIVE | Date after which a payment term is invalid |
| RANK | Unique rank to rate invoice payment terms against purchase order payment terms in accordance with Prompt Payment Act |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure definition column. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| ATTRIBUTE15 | Descriptive flexfield segment |
| LANGUAGE | Language |
| CREATION_DATE | Standard who column - date when this row was created. |
| SOURCE_LANG | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| NAME | Name of payment term |
| ENABLED_FLAG | No longer used |
| DUE_CUTOFF_DAY | Used for proxima terms only, day of a month after which Oracle Payables schedules payment using a day after the current month |
| Payables - AP_TOLERANCES_ALL | Matching and invoice variance testing tolerance levels |
|---|---|
| Column Name | Descritpion |
| PRICE_TOLERANCE | Percentage based tolerance level for price variance |
| MAX_QTY_ORD_TOLERANCE | Tolerance level for maximum quantity ordered variance |
| MAX_QTY_REC_TOLERANCE | Tolerance level for maximum quantity received variance |
| SHIP_AMT_TOLERANCE | Tolerance level for purchase order shipment amount variance |
| RATE_AMT_TOLERANCE | Tolerance level for exchange rate amount variance |
| TOTAL_AMT_TOLERANCE | Tolerance level for total amount variance |
| TAX_TOL_AMT_RANGE | No longer used |
| ORG_ID | Organization identifier |
| QUANTITY_TOLERANCE | Percentage-based tolerance level for quantity variance |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| QTY_RECEIVED_TOLERANCE | Percentage-based tolerance level for quantity received tolerance |
| TAX_TOLERANCE | No longer used |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Payables - AP_VENDOR_KEY_IND_ALL | Compiled supplier information for the Key Indicators Report |
|---|---|
| Column Name | Descritpion |
| PERIOD_NAME | Period name |
| NUM_VENDORS_HELD | Number of new suppliers on hold |
| NUM_VENDORS_UPDATED | Number of existing suppliers for which supplier information updated |
| NUM_SITES_UPDATED | Number of existing supplier sites for which site information updated |
| VALUE1 | Custom statistical tracking |
| VALUE2 | Custom statistical tracking |
| VALUE3 | Custom statistical tracking |
| VALUE4 | Custom statistical tracking |
| VALUE5 | Custom statistical tracking |
| VALUE6 | Custom statistical tracking |
| VALUE7 | Custom statistical tracking |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| VALUE8 | Custom statistical tracking |
| VALUE9 | Custom statistical tracking |
| VALUE10 | Custom statistical tracking |
| ORG_ID | Organization identifier |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| NUM_VENDORS | Number of new suppliers |
| NUM_VENDOR_SITES | Number of sites for new suppliers |
| NUM_SITES | Number of additional sites for existing suppliers |
| NUM_INACTIVE_VENDORS | Number of new suppliers with inactive dates |
| NUM_ONE_TIME_VENDORS | Number of new suppliers designated as one-time suppliers |
| NUM_1099_VENDORS | Number of new suppliers of type 1099 |
| Payables - FINANCIALS_SYSTEM_PARAMS_ALL | Oracle Financials system parameters and defaults |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| FOB_LOOKUP_CODE | Type of free on board, default used during supplier entry |
| MISC_CHARGE_CCID | Accounting Flexfield identifier for the accounts payable miscellaneous account, which is used for iSupplier Portal Invoices |
| GLOBAL_ATTRIBUTE_CATEGORY | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE1 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE2 | Reserved for country-specific functionality |
| TERMS_ID | Payment terms identifier, default used during supplier entry |
| GLOBAL_ATTRIBUTE3 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE4 | Reserved for country-specific functionality |
| ALWAYS_TAKE_DISC_FLAG | Flag that indicates if available discount for a supplier will be taken, regardless of when the invoice is paid (Y or N), default used during supplier entry |
| GLOBAL_ATTRIBUTE5 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE6 | Reserved for country-specific functionality |
| PAY_DATE_BASIS_LOOKUP_CODE | Basis Oracle Payables applications use for selecting invoices for payment (DUE or DISCOUNT), default used during supplier entry |
| GLOBAL_ATTRIBUTE7 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE8 | Reserved for country-specific functionality |
| INVOICE_CURRENCY_CODE | Currency code for invoices, default used during supplier entry |
| GLOBAL_ATTRIBUTE9 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE10 | Reserved for country-specific functionality |
| PAYMENT_CURRENCY_CODE | Currency code for payments, default used during supplier entry |
| GLOBAL_ATTRIBUTE11 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE12 | Reserved for country-specific functionality |
| ACCTS_PAY_CODE_COMBINATION_ID | Accounting Flexfield identifier for the accounts payable liability account, default used during supplier entry |
| GLOBAL_ATTRIBUTE13 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE14 | Reserved for country-specific functionality |
| PREPAY_CODE_COMBINATION_ID | Accounting Flexfield identifier for the prepayment account, default used during supplier entry |
| GLOBAL_ATTRIBUTE15 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE16 | Reserved for country-specific functionality |
| DISC_TAKEN_CODE_COMBINATION_ID | Accounting Flexfield identifier for the discount taken account |
| GLOBAL_ATTRIBUTE17 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE18 | Reserved for country-specific functionality |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| FUTURE_PERIOD_LIMIT | Maximum number of future periods allowed |
| GLOBAL_ATTRIBUTE19 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE20 | Reserved for country-specific functionality |
| RESERVE_AT_COMPLETION_FLAG | Flag that indicates if Oracle Purchasing creates an encumbrance journal entry when a requisition is entered (Y) or when the requisition is approved (N) |
| RETAINAGE_CODE_COMBINATION_ID | Accounting Flexfield Identifier for the account associated with a retainage distribution. |
| RES_ENCUMB_CODE_COMBINATION_ID | Accounting Flexfield identifier for the reserve for encumbrance account |
| REQ_ENCUMBRANCE_FLAG | Flag that indicates if Oracle Purchasing will create an encumbrance journal entry when a purchase requisition is created (Y or N) |
| REQ_ENCUMBRANCE_TYPE_ID | Requisition encumbrance type identifier |
| PURCH_ENCUMBRANCE_FLAG | Flag that indicates if Oracle Purchasing will create an encumbrance journal entry when a purchase order is created |
| PURCH_ENCUMBRANCE_TYPE_ID | Purchase order encumbrance type identifier |
| INV_ENCUMBRANCE_TYPE_ID | Identifier for encumbrance type assigned to invoice encumbrances |
| MANUAL_VENDOR_NUM_TYPE | Type of supplier number Oracle Payables uses for either automatic or manual supplier number entry |
| INVENTORY_ORGANIZATION_ID | Inventory organization identifier |
| SET_OF_BOOKS_ID | Set of books identifier |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| FREIGHT_TERMS_LOOKUP_CODE | Freight terms |
| RFQ_ONLY_SITE_FLAG | Flag that indicates if supplier site is a RFQ only site |
| RECEIPT_ACCEPTANCE_DAYS | Number of days in receipt acceptance period |
| BUSINESS_GROUP_ID | Business group identifier associated with Oracle Purchasing |
| EXPENSE_CHECK_ADDRESS_FLAG | Employee address for expense checks (H for home or O for office), default used during employee entry |
| TERMS_DATE_BASIS | Date Oracle Payables uses together with payment terms and invoice amount to create an invoice scheduled payment, default used during supplier entry |
| USE_POSITIONS_FLAG | Flag that indicates whether you use approval hierarchies that are based on the positions you define for employees |
| PAYMENT_METHOD_LOOKUP_CODE | Payment method default used during supplier entry |
| RATE_VAR_CODE_COMBINATION_ID | Not used |
| HOLD_UNMATCHED_INVOICES_FLAG | Default Hold Unmatched Invoices value for supplier (Y or N) |
| EXCLUSIVE_PAYMENT_FLAG | Default Pay Alone value for suppliers; defaults from supplier to invoices for supplier |
| REVISION_SORT_ORDERING | Not used |
| VAT_REGISTRATION_NUM | Value-Added Tax registration number for your organization |
| VAT_COUNTRY_CODE | European Union (EU)) member state for your organization |
| RATE_VAR_GAIN_CCID | Accounting Flexfield identifier for account used to record exchange rate gains for invoices matched to purchase orders |
| RATE_VAR_LOSS_CCID | Accounting Flexfield identifier for account used to record exchange rate losses for invoices matched to purchase orders |
| USER_DEFINED_VENDOR_NUM_CODE | Method of entering supplier numbers |
| ORG_ID | Organization identifier |
| BANK_CHARGE_BEARER | Bank charge bearer |
| VAT_CODE | No longer used |
| MATCH_OPTION | Flag to indicate whether to match invoices to purchase orders (P) or receipts (R) |
| VENDOR_NUM_START_NUM | Next automatic supplier number (Oracle Payables applications update as you enter suppliers) |
| NON_RECOVERABLE_TAX_FLAG | No longer used |
| TAX_ROUNDING_RULE | No longer used |
| SHIP_TO_LOCATION_ID | Ship-to location identifier, default used during supplier entry |
| PRECISION | No longer used |
| MINIMUM_ACCOUNTABLE_UNIT | No longer used |
| BILL_TO_LOCATION_ID | Bill-to location identifier, default used during supplier entry |
| DEFAULT_RECOVERY_RATE | No longer used |
| CASH_BASIS_ENC_NR_TAX | Not currently used |
| SHIP_VIA_LOOKUP_CODE | Type of shipping method, default used during supplier entry |
| FUTURE_DATED_PAYMENT_CCID | Accounting Flexfield identifier for future dated payment account default for Suppliers and Bank accounts |
| EXPENSE_CLEARING_CCID | Credit card expense clearing account |
| Payables - AP_TERMS_LINES | Detail information about payment terms |
|---|---|
| Column Name | Descritpion |
| TERM_ID | Term identifier |
| DUE_DAYS | Number of days after terms date, used to calculate due date of invoice payment line |
| DUE_DAY_OF_MONTH | Day of month used to calculate due date of invoice payment line |
| DUE_MONTHS_FORWARD | Number of months ahead, used to calculate due date of invoice payment line |
| DISCOUNT_PERCENT | Percentage used to calculate discount available for invoice payment line |
| DISCOUNT_DAYS | Number of days after terms date, used to calculate discount date for invoice payment line |
| DISCOUNT_DAY_OF_MONTH | Day of month used to calculate discount date for invoice payment line |
| DISCOUNT_MONTHS_FORWARD | Number of months ahead used to calculate discount date for invoice payment line |
| DISCOUNT_PERCENT_2 | Percentage used to calculate second discount available for invoice payment line |
| DISCOUNT_DAYS_2 | Number of days after terms date, used to calculate second discount available for invoice payment line |
| DISCOUNT_DAY_OF_MONTH_2 | Day of month used to calculate second discount available for invoice payment line |
| SEQUENCE_NUM | Number of payment term line |
| DISCOUNT_MONTHS_FORWARD_2 | Number of months ahead, used to calculate discount available for invoice payment line |
| DISCOUNT_PERCENT_3 | Percentage used to calculate third discount available for invoice payment line |
| DISCOUNT_DAYS_3 | Number of days after terms date, used to calculate third discount for invoice payment line |
| DISCOUNT_DAY_OF_MONTH_3 | Day of month used to calculate third discount for invoice payment line |
| DISCOUNT_MONTHS_FORWARD_3 | Number of months ahead, used to calculate third discount for invoice payment line |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure definition column. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| ATTRIBUTE15 | Descriptive flexfield segment |
| FIXED_DATE | Fixed due date |
| CALENDAR | Name of special calendar associated with the term line |
| CREATION_DATE | Standard who column - date when this row was created. |
| DISCOUNT_AMOUNT | Contains the first discount amount in absolute amount |
| DISCOUNT_CRITERIA | When first discount is provided both in terms of percent and amount, this field decides which one to consider. This field holds one of the three values - H, L or NULL. If value is H system will consider Higher of the discounts arrived at by |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| DISCOUNT_AMOUNT_2 | Contains the second discount amount in absolute amount |
| DISCOUNT_CRITERIA_2 | When second discount is provided both in terms of percent and amount, this field decides which one to consider. This field holds one of the three values - H, L or NULL. If value is H system will consider Higher of the discounts arrived at b |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| DISCOUNT_AMOUNT_3 | Contains the third discount amount in absolute amount |
| DISCOUNT_CRITERIA_3 | When third discount is provided both in terms of percent and amount, this field decides which one to consider. This field holds one of the three values - H, L or NULL. If value is H system will consider Higher of the discounts arrived at by |
| DUE_PERCENT | Percentage of payment due by a certain date |
| DUE_AMOUNT | Maximum of payment amount due by a certain date |
| Payables - FINANCIALS_PURGES | Invoice purge selection criteria and purged invoice statistical data |
|---|---|
| Column Name | Descritpion |
| PURGE_NAME | Name of purge |
| ACTIVITY_DATE | Last date record updated (Records updated on or before this date will be selected as purge candidates) |
| AP_ENCUMBRANCE_LINES | Number of records purged from same name table |
| AP_PAYMENT_HISTORY | Number of records purged from same name table |
| AP_CHECKS | Number of rows purged from this table |
| AP_MATCHED_RECT_ADJ | Number of records purged from same name table |
| RCV_SUBLEDGER_DETAILS | Number of records purged from same name table |
| AP_INVOICES | Number of rows purged from this table |
| AP_MC_CHECKS | Number of rows purged from this table |
| AP_MC_INVOICE_DISTS | Number of rows purged from this table |
| PO_REQUISITION_HEADERS | Number of rows purged from this table |
| AP_MC_INVOICE_PAYMENTS | Number of rows purged from this table |
| AP_MC_INVOICES | Number of rows purged from this table |
| PO_HEADERS | Number of rows purged from this table |
| PO_MC_DISTRIBUTIONS | Number of rows purged from this table |
| PO_MC_HEADERS | Number of rows purged from this table |
| PO_VENDORS | Number of rows purged from this table |
| AP_INVOICE_PAYMENTS | Number of rows purged from this table |
| AP_INVOICE_PREPAYS | Number of rows purged from this table |
| AP_PAYMENT_SCHEDULES | Number of rows purged from this table |
| AP_RECURRING_PAYMENTS | Number of rows purged from this table |
| CREATION_DATE | Standard Who column |
| AP_TRIAL_BALANCE | Number of rows purged from this table |
| AP_INVOICE_DISTRIBUTIONS | Number of rows purged from this table |
| AP_HOLDS | Number of rows purged from this table |
| AP_BATCHES | Number of rows purged from this table |
| PO_REQUISITION_LINES | Number of rows purged from this table |
| PO_REQ_DISTRIBUTIONS | Number of rows purged from this table |
| PO_APPROVALS | Number of rows purged from this table |
| PO_LINES | Number of rows purged from this table |
| PO_LINE_LOCATIONS | Number of rows purged from this table |
| PO_DISTRIBUTIONS | Number of rows purged from this table |
| CREATED_BY | Standard Who column |
| PO_RELEASES | Number of rows purged from this table |
| PO_ITEM_HISTORY | Number of rows purged from this table |
| PO_ACCEPTANCES | Number of rows purged from this table |
| PO_NOTES | Number of rows purged from this table |
| PO_NOTE_REFERENCES | Number of rows purged from this table |
| PO_RECEIPTS | Number of rows purged from this table |
| PO_DELIVERIES | Number of rows purged from this table |
| PO_QUALITY_INSPECTIONS | Number of rows purged from this table |
| PO_VENDOR_SITES | Number of rows purged from this table |
| PO_VENDOR_CONTACTS | Number of rows purged from this table |
| LAST_UPDATE_DATE | Standard Who column |
| PO_HEADERS_ARCHIVE | Number of rows purged from this table |
| PO_LINES_ARCHIVE | Number of rows purged from this table |
| PO_LINE_LOCATIONS_ARCHIVE | Number of rows purged from this table |
| PO_VENDOR_LIST_HEADERS | Number of rows purged from this table |
| PO_VENDOR_LIST_ENTRIES | Number of rows purged from this table |
| PO_NOTIFICATIONS | Number of rows purged from this table |
| PO_ACCRUAL_RECONCILE_TEMP | Number of rows purged from this table |
| PO_BLANKET_ITEMS | Number of rows purged from this table |
| PO_RECEIPT_HEADERS | Number of rows purged from this table |
| LAST_UPDATED_BY | Standard Who column |
| ORGANIZATION_ID | Organization identifier |
| PO_APPROVED_SUPPLIER_LIST | Number of rows purged from this table |
| PO_ASL_ATTRIBUTES | Number of rows purged from this table |
| PO_ASL_DOCUMENTS | Number of rows purged from this table |
| CHV_AUTHORIZATIONS | Number of rows purged from this table |
| LAST_UPDATE_LOGIN | Standard Who column |
| CHV_CUM_ADJUSTMENTS | Number of rows purged from this table |
| CHV_CUM_PERIODS | Number of rows purged from this table |
| CHV_CUM_PERIOD_ITEMS | Number of rows purged from this table |
| CHV_HORIZONTAL_SCHEDULES | Number of rows purged from this table |
| CHV_ITEM_ORDERS | Number of rows purged from this table |
| CATEGORY | Type of purge process |
| CHV_SCHEDULE_HEADERS | Number of rows purged from this table |
| CHV_SCHEDULE_ITEMS | Number of rows purged from this table |
| MRP_SR_SOURCE_ORG | Number of rows purged from this table |
| MRP_ITEM_SOURCING | Number of rows purged from this table |
| STATUS | Status of completion of purge process |
| AP_ACCOUNTING_EVENTS | Number of records purged from same name table |
| AP_AE_HEADERS | Number of records purged from same name table |
| ACTION | Action you select for purge |
| AP_AE_LINES | Number of records purged from same name table |
| AP_CHRG_ALLOCATIONS | Number of records purged from same name table |
| Payables - AP_VENDOR_AUDIT_TMP | Temporary table for duplicate supplier candidates during Supplier Merge |
|---|---|
| Column Name | Descritpion |
| VENDOR_ID | Supplier identifier |
| VENDOR_NUMBER | Supplier number |
| VENDOR_NAME | Supplier name |
| Payables - AP_WEB_SIGNING_LIMITS_ALL | Tracks signing limit authority for Self-Service Expenses-entered expense reports |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| DOCUMENT_TYPE | Document type |
| ORG_ID | Organization identifier |
| EMPLOYEE_ID | Employee identifier |
| COST_CENTER | Cost center |
| SIGNING_LIMIT | Signing authority limit |
| Payables - AP_TEMP_APPROVAL_ALL | No longer used |
|---|---|
| Column Name | Descritpion |
| HOLD_LOOKUP_CODE | Name of hold code |
| NUMBER_HOLDS_PLACED | Number of holds placed by Invoice Validation. |
| NUMBER_HOLDS_RELEASED | Number of holds released by Invoice Validation. |
| ORG_ID | Organization identifier |
| Payables - AP_TRIAL_BAL | No longer used |
|---|---|
| Column Name | Descritpion |
| CODE_COMBINATION_ID | Accounting Flexfield identifier |
| REMAINING_AMOUNT | Amount remaining as an outstanding liability |
| VENDOR_ID | Supplier identifier |
| SET_OF_BOOKS_ID | Set of Books identifier |
| ORG_ID | Organization identifier |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| INVOICE_AMOUNT | Total invoice amount for this liability account |
| INVOICE_ID | Invoice identifier |
| Payables - AP_TRIAL_BALANCE | Denormalized information about posted invoices for your accrual set of books |
|---|---|
| Column Name | Descritpion |
| INVOICE_ID | Invoice identifier |
| ACCOUNTING_DATE | Accounting date of invoice |
| PAYMENT_AMOUNT | Amount of posted payment for invoice |
| DISTRIBUTION_AMOUNT | Amount of posted expense for the invoice |
| DISTRIBUTION_LINE_NUMBER | Line number for invoice distribution line |
| Payables - AP_WHT_ITF | Information for the submission of the AP Withholding Tax extract program |
|---|---|
| Column Name | Descritpion |
| ORGANIZATION_NAME | Name of the organization |
| TAXPAYER_ID | Tax Payer Id |
| SUPPLIER_NUMBER | Supplier's Number (Internal) |
| SUPPLIER_SITE_CODE | Supplier Site Code |
| VAT_REGISTRATION_NUMBER | Supplier's VAT Registration Number |
| SUPPLIER_ADDRESS_LINE1 | Supplier's address line 1 |
| SUPPLIER_ADDRESS_LINE2 | Supplier's address line 2 |
| SUPPLIER_ADDRESS_LINE3 | Supplier's address line 3 |
| SUPPLIER_CITY | Supplier's city |
| SUPPLIER_STATE | Supplier's state |
| SUPPLIER_ZIP | Supplier's zip |
| FUNCTIONAL_CURRENCY_CODE | Functional currency code |
| SUPPLIER_PROVINCE | Supplier's province |
| SUPPLIER_COUNTRY | Supplier's country |
| INVOICE_NUM | Invoice number |
| INVOICE_AMOUNT | Invoice amount |
| INVOICE_CURRENCY_CODE | Currency of the Invoice |
| INVOICE_DATE | Invoice Date |
| INV_GLOBAL_ATTRIBUTE1 | AP_INVOICES Global Attribute1 |
| INV_GLOBAL_ATTRIBUTE2 | AP_INVOICES Global Attribute2 |
| INV_GLOBAL_ATTRIBUTE3 | AP_INVOICES Global Attribute3 |
| INV_GLOBAL_ATTRIBUTE4 | AP_INVOICES Global Attribute4 |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| INV_GLOBAL_ATTRIBUTE5 | AP_INVOICES Global Attribute5 |
| INV_GLOBAL_ATTRIBUTE6 | AP_INVOICES Global Attribute6 |
| INV_GLOBAL_ATTRIBUTE7 | AP_INVOICES Global Attribute7 |
| INV_GLOBAL_ATTRIBUTE8 | AP_INVOICES Global Attribute8 |
| INV_GLOBAL_ATTRIBUTE9 | AP_INVOICES Global Attribute9 |
| INV_GLOBAL_ATTRIBUTE10 | AP_INVOICES Global Attribute10 |
| INV_GLOBAL_ATTRIBUTE11 | AP_INVOICES Global Attribute11 |
| INV_GLOBAL_ATTRIBUTE12 | AP_INVOICES Global Attribute12 |
| INV_GLOBAL_ATTRIBUTE13 | AP_INVOICES Global Attribute13 |
| INV_GLOBAL_ATTRIBUTE14 | AP_INVOICES Global Attribute14 |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| INV_GLOBAL_ATTRIBUTE15 | AP_INVOICES Global Attribute15 |
| INV_GLOBAL_ATTRIBUTE16 | AP_INVOICES Global Attribute16 |
| INV_GLOBAL_ATTRIBUTE17 | AP_INVOICES Global Attribute17 |
| INV_GLOBAL_ATTRIBUTE18 | AP_INVOICES Global Attribute18 |
| INV_GLOBAL_ATTRIBUTE19 | AP_INVOICES Global Attribute19 |
| INV_GLOBAL_ATTRIBUTE20 | AP_INVOICES Global Attribute20 |
| PV_GLOBAL_ATTRIBUTE1 | PO_VENDORS Global Attribute1 |
| PV_GLOBAL_ATTRIBUTE2 | PO_VENDORS Global Attribute2 |
| PV_GLOBAL_ATTRIBUTE3 | PO_VENDORS Global Attribute3 |
| PV_GLOBAL_ATTRIBUTE4 | PO_VENDORS Global Attribute4 |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PV_GLOBAL_ATTRIBUTE5 | PO_VENDORS Global Attribute5 |
| PV_GLOBAL_ATTRIBUTE6 | PO_VENDORS Global Attribute6 |
| PV_GLOBAL_ATTRIBUTE7 | PO_VENDORS Global Attribute7 |
| PV_GLOBAL_ATTRIBUTE8 | PO_VENDORS Global Attribute8 |
| PV_GLOBAL_ATTRIBUTE9 | PO_VENDORS Global Attribute9 |
| PV_GLOBAL_ATTRIBUTE10 | PO_VENDORS Global Attribute10 |
| PV_GLOBAL_ATTRIBUTE11 | PO_VENDORS Global Attribute11 |
| PV_GLOBAL_ATTRIBUTE12 | PO_VENDORS Global Attribute12 |
| PV_GLOBAL_ATTRIBUTE13 | PO_VENDORS Global Attribute13 |
| PV_GLOBAL_ATTRIBUTE14 | PO_VENDORS Global Attribute14 |
| CREATION_DATE | Standard who column - date when this row was created. |
| PV_GLOBAL_ATTRIBUTE15 | PO_VENDORS Global Attribute15 |
| PV_GLOBAL_ATTRIBUTE16 | PO_VENDORS Global Attribute16 |
| PV_GLOBAL_ATTRIBUTE17 | PO_VENDORS Global Attribute17 |
| PV_GLOBAL_ATTRIBUTE18 | PO_VENDORS Global Attribute18 |
| PV_GLOBAL_ATTRIBUTE19 | PO_VENDORS Global Attribute19 |
| PV_GLOBAL_ATTRIBUTE20 | PO_VENDORS Global Attribute20 |
| AWT_CODE | Withholding Tax Code |
| AWT_RATE | Withholding Tax Rate |
| AWT_AMOUNT | Amount withheld |
| AWT_BASE_AMOUNT | Base amount withheld |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| AWT_GROUP_NAME | Withholding tax group name |
| ADDRESS_LINE1 | Address line 1 |
| AWT_GL_DATE | GL date of withholding |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| ADDRESS_LINE2 | Address line 2 |
| AWT_GROSS_AMOUNT | Amount subject to withholding tax |
| ADDRESS_LINE3 | Address line 3 |
| CITY | City |
| ZIP | Zip |
| PROVINCE | Province |
| STATE | State |
| COUNTRY | Country |
| TAX_AUTHORITY | Tax Authority Name |
| SUPPLIER_TYPE | Supplier Type |
| SUPPLIER_NAME | Supplier Name |
| Payables - AP_WEB_PREFERENCES | Stores the user preferences for Oracle Internet Expenses. |
|---|---|
| Column Name | Descritpion |
| EMPLOYEE_ID | Name of employee |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| DEFAULT_FOREIGN_CURR_FLAG | Default Includes Foreign Currency Value |
| DEFAULT_SOURCE | Determines whether to derive preferences from prior reports or from the user's preferences settings. |
| DEFAULT_LOCATION_ID | The default location ID. |
| VEHICLE_CATEGORY | The default vehicle category. |
| VEHICLE_TYPE | The default vehicle type |
| FUEL_TYPE | The default fuel type |
| TIME_FORMAT | Determines which time format time to use. |
| DEFAULT_EXCHANGE_RATE_FLAG | Determines whether to default exchange rates |
| SHOW_AUDIT_HEADER_FLAG | Determines whether the expense report header is displayed to the auditor |
| EXPENSE_ALLOCATIONS_FLAG | Lets the user enable or disable line level accounting during expense report entry. |
| DEFAULT_APPROVER_ID | Default alternate approver ID |
| DEFAULT_EXPENSE_TEMPLATE_ID | Default expense template ID |
| DEFAULT_PURPOSE | Default expense report purpose |
| VALIDATE_DETAILS_FLAG | Flag to determine whether to validate details. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Payables - AP_TRANSMISSIONS_SETUP | No Longer Used |
|---|---|
| Column Name | Descritpion |
| TRANSMISSION_CODE | Unique name for transmission setup. |
| LOCAL_CONF_DIRECTORY | The local directory where the confirmation note from the bank will be placed. |
| LOCAL_STMT_DIRECTORY | The local directory where the statement note from the bank will be placed. |
| LOCAL_EXCEPTION_DIRECTORY | The local directory where the exception note from the bank will be placed. |
| BANK_PAY_DIRECTORY | The bank's directory where the payment file will be placed. |
| BANK_CONF_DIRECTORY | The bank's directory from which the confirmation note will be taken. |
| BANK_STMT_DIRECTORY | The bank's directory from which the statement note will be taken. |
| BANK_EXCEPTION_DIRECTORY | The bank's directory from which the exception note will be taken. |
| PAY_FILE_EXT | The extension of the payment file name |
| PAY_FILE_PREFIX | The prefix of the payment file name |
| PAY_FILE_SUFFIX | The suffix of the payment file. |
| BANK_BRANCH_ID | Bank branch identifier |
| CONF_FILE_EXT | The extension of the confirmation file name |
| CONF_FILE_PREFIX | The prefix of the confirmation file name |
| CONF_FILE_SUFFIX | The suffix of the confirmation file name |
| STMT_FILE_EXT | The extension of the statement file name |
| STMT_FILE_PREFIX | The prefix of the statement file name |
| STMT_FILE_SUFFIX | The suffix of the statement file name |
| EXCEPTION_FILE_EXT | The extension of the exception file name |
| EXCEPTION_FILE_PREFIX | The prefix of the exception file name |
| EXCEPTION_FILE_SUFFIX | The suffix of the exception file name |
| INTRA_STATEMENT_EMAIL | The workflow role to which Intra-Day statement messages are sent. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LOCAL_INTRA_DIRECTORY | The local directory where the Intra-day statement note from the bank will be placed. |
| BANK_INTRA_DIRECTORY | The banks's directory from which the Intra-Day statements note will be taken |
| INTRA_FILE_EXT | The extension of the Intra-Day statement file name |
| INTRA_FILE_PREFIX | The prefix of the Intra_Day statement file name |
| INTRA_FILE_SUFFIX | The suffix of the Intra-Day statement file name. |
| XTR_TRANSMISSION_EMAIL | The workflow role to which Oracle Treasury transmission messages are sent |
| XTR_CONFIRMATION_EMAIL | The workflow role to which Oracle Treasury confirmation messages are sent |
| XTR_LOCAL_PAY_DIR | The local directory where the modified Oracle Treasury payment file exists |
| XTR_LOCAL_CONF_DIR | The local directory where the Oracle Treasury confirmation note from the bank will be placed. |
| XTR_BANK_PAY_DIR | The bank's directory where the Oracle Treasury payment filw will be placed |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| XTR_BANK_CONF_DIR | The bank's directory from which the Oracle Treasury confirmation note will be taken |
| XTR_PAY_FILE_EXT | The extension of the Oracle Treasury payment file name |
| XTR_PAY_FILE_PREFIX | The prefix of the Oracle Treasury payment file name |
| XTR_PAY_FILE_SUFFIX | The suffix of the Oracle Treasury payment file name. |
| XTR_CONF_FILE_EXT | The extension of the Oracle Treasury confirmation file name |
| XTR_CONF_FILE_PREFIX | The prefix of the Oracle Treasury confirmation file name |
| XTR_CONF_FILE_SUFFIX | The suffix of the Oracle Treasury confirmation file name |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| TRANSMISSION_PROGRAM | The bank's custom transmission program. |
| TRANSMISSION_ID | Transmission Identifier |
| USERNAME | Assigned and used by the bank to identify the sender |
| PASSWORD | Assigned and used by the bank to identify the sender |
| PROTOCOL | The bank's required protocol by which the files are transferred |
| PROTOCOL_ADDRESS | The bank's host address to which the files are transmitted. |
| EXTERNAL_IDENTIFIER | The identifier by which the transmitter is known to the bank. |
| TRANSMISSION_EMAIL | The workflow role to which transmission messages are sent. |
| CONFIRMATION_EMAIL | The workflow role to which confirmation messages are sent. |
| STATEMENT_EMAIL | The workflow role to which statement messages are sent. |
| EXCEPTION_EMAIL | The workflow role to which exception messages are sent. |
| LOCAL_PAY_DIRECTORY | The local directory where the modified payment file exists. |
| Payables - AP_WEB_EMPLOYEE_INFO_ALL | This table is used to store employee information. |
|---|---|
| Column Name | Descritpion |
| VALUE_TYPE | Part of the unique identifier of the table. This value determines what kind of data this record stores. |
| VALUE | Value for the stored value_type. |
| PERIOD_ID | Part of the unique identifier of the table storing the id from ap_pol_schedule_periods. |
| ORG_ID | Organization identifier |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| EMPLOYEE_ID | Part of the unique identifier of the table. This value ties to the HR tables. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| NUMERIC_VALUE | Numeric Value for the stored value_type |
| Payables - AP_WEB_VAT_SETUP_ALL | This table is used to store VAT-related setup for a specific organization. The VAT-related setup data affects the display of merchant fields on the Expense Line Details page. |
|---|---|
| Column Name | Descritpion |
| ENABLE_MERCHANT_NAME_CODE | Determines the behavior of the Merchant Name field. |
| ENABLE_MERCHANT_RECEIPT_CODE | Determines the behavior of the Merchant Receipt field. |
| ENABLE_MERCHANT_TAX_REG_CODE | Determines the behavior of the Merchant Tax Registration field. |
| ENABLE_MERCHANT_REFERENCE_CODE | Determines the behavior of the Merchant Reference field. |
| ENABLED_CODE | Determines whether or not this setup line is enabled. |
| ORG_ID | Organization identifier |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| TERRITORY_CODE | Territory code |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| ENABLE_MERCHANT_TAXPAYER_CODE | Determines the behaviour of the Merchant Taxpayer ID field. |
| VAT_SETUP_ID | Vat Setup Identifier |
| Payables - AP_TB_BALANCES_TMP | AP_TB_BALANCES_TMP stores balance amounts for each liability account within a ledger as of the balance date. This table is used during trial balance upgrade to populate the account balances based on XLA_UPGRADE_DATES.start_date |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Ledger Identifier |
| CODE_COMBINATION_ID | Account Identifier |
| BALANCE_DATE | Balance Date for which Balance Amount is stored |
| BALANCE_AMOUNT | Balance Amount |
| Payables - AP_TRIAL_BALANCE_LEDGERS | |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | |
| WORKER_NO | |
| STATUS | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY |
| Payables - AP_WEB_AMEX_PARAMS | Download parameters for American Express |
|---|---|
| Column Name | Descritpion |
| CARD_PROGRAM_ID | Credit card program identifier |
| SECURE_DIRECTORY | Secure directory where the data files are downloaded |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| RECORD_LENGTH | Length of record in data file - constant value 0 |
| RECORD_TERMINATOR | Record terminator used in data file - constant value LF |
| WALLET_PATH | Path to the Oracle Wallet file |
| ENCRYPTED_WALLET_PASSWORD | Encrypted password for the Oracle Wallet |
| USERNAME | User name for the American Express profile |
| ENCRYPTED_PASSWORD | Encrypted password for the American Express profile |
| REMOTE_FILENAME | Remote filename |
| AMEX_SERVER | American Express server hostname |
| Payables - OIE_PDM_DESTINATIONS | This table holds per diem destination information. |
|---|---|
| Column Name | Descritpion |
| PDM_DESTINATION_ID | Sequence generated unique identifier. |
| CREATION_DATE | Standard WHO column |
| REPORT_LINE_ID | Report Line Identifier. |
| START_DATE | Start date for location detail line. |
| END_DATE | End date for location detail line. |
| LOCATION_ID | Location identifier. |
| LAST_UPDATE_DATE | Standard WHO column |
| LAST_UPDATED_BY | Standard WHO column |
| LAST_UPDATE_LOGIN | Standard WHO column |
| CREATED_BY | Standard WHO column |
| Payables - OIE_ATTENDEES_ALL | Holds the attendee and recipient data for the current expense type. |
|---|---|
| Column Name | Descritpion |
| ATTENDEE_LINE_ID | Primary Key from OIE_ATTENDEES_SELECT sequence |
| TAX_ID | Attendee's tax id |
| ORG_ID | The organization ID |
| LAST_UPDATE_DATE | Standard WHO column |
| LAST_UPDATED_BY | Standard WHO column |
| CREATION_DATE | Standard WHO column |
| CREATED_BY | Standard WHO column |
| LAST_UPDATE_LOGIN | Standard WHO column |
| REPORT_LINE_ID | Report Line Identifier FK to ap_expense_report_lines_all |
| EMPLOYEE_FLAG | To indicate if the attenddee is company employee |
| EMPLOYEE_ID | Employee ID |
| ATTENDEE_TYPE | Attendee Type from OIE_ATTENDEE_TYPE lookup |
| NAME | Attendee Name |
| TITLE | Attendee Title |
| EMPLOYER | Attendee's select Employer |
| EMPLOYER_ADDRESS | Attendee's select Employer Address |
| Payables - OIE_PDM_DAILY_BREAKUPS | This table holds per diem data for a rate period. |
|---|---|
| Column Name | Descritpion |
| PDM_DAILY_BREAKUP_ID | Sequence generated unique identifier. |
| DINNER_FLAG | Indicates if dinner is free. |
| ACCOMMODATION_AMOUNT | Amount incurred due to accommodation. |
| ACCOMMODATION_FLAG | Indicates if user received dinner during the rate period. |
| HOTEL_NAME | Stores hotel name. |
| NIGHT_RATE_TYPE | Stores night rate type. |
| NIGHT_RATE_AMOUNT | Night rate amount. |
| PDM_RATE | Daily per diem amount based on per diem detail dates. |
| PDM_DESTINATION_ID | Points to the location choosen for per diem calculation. |
| RATE_TYPE_CODE | Column indicates if rate is standard, first day rate, last day rate. |
| LAST_UPDATE_DATE | Standard WHO column |
| REPORT_LINE_ID | Report Line Identifier. |
| LAST_UPDATED_BY | Standard WHO column |
| LAST_UPDATE_LOGIN | Standard WHO column |
| CREATED_BY | Standard WHO column |
| CREATION_DATE | Standard WHO column |
| SCHEDULE_TYPE_CODE | Standard WHO column |
| CUST_MEALS_AMOUNT | Custom amount incurred due to meals. |
| CUST_ACCOMMODATION_AMOUNT | Custom amount incurred due to accommodation. |
| CUST_NIGHT_RATE_AMOUNT | Custom night rate amount. |
| CUST_PDM_RATE | Custom daily per diem amount based on per diem detail dates. |
| START_DATE | Start date for expense detail line. |
| END_DATE | End date for expense detail line |
| AMOUNT | Reimbursable amount. |
| NUMBER_OF_MEALS | Number of meals. |
| MEALS_AMOUNT | Amount incurred due to meals. |
| BREAKFAST_FLAG | Indicates if breakfast is free. |
| LUNCH_FLAG | Indicates if lunch is free. |
| Payables - OIE_ADDON_MILEAGE_RATES | This table stores additional information for a mileage expense type. |
|---|---|
| Column Name | Descritpion |
| REPORT_LINE_ID | Report Line Identifier |
| CREATION_DATE | Standard WHO column |
| ADDON_RATE_TYPE | Denotes additional rate type lookup code. |
| MILEAGE_RATE | Rate for the additional mileage type. |
| MILEAGE_AMOUNT | Amount for the additional mileage type. |
| MILEAGE_PAYROLL_TAX_CODE_ID | For use in future |
| LAST_UPDATE_DATE | Standard WHO column |
| LAST_UPDATED_BY | Standard WHO column |
| LAST_UPDATE_LOGIN | Standard WHO column |
| CREATED_BY | Standard WHO column |
| Payables - AP_TOLERANCE_TEMPLATES | Matching and invoice variance testing tolerance levels |
|---|---|
| Column Name | Descritpion |
| TOLERANCE_ID | Tolerance Template Identifier |
| LAST_UPDATE_LOGIN | Standard Who column - operating system login of user who last updated this row |
| CREATION_DATE | Standard Who column - date when this row was created |
| CREATED_BY | Standard Who column - user who created this row |
| MAX_QTY_ORD_TOLERANCE | Tolerance level for maximum quantity ordered variance |
| MAX_QTY_REC_TOLERANCE | Tolerance level for maximum quantity received variance |
| SHIP_AMT_TOLERANCE | Tolerance level for purchase order shipment amount variance |
| RATE_AMT_TOLERANCE | Tolerance level for exchange rate amount variance |
| TOTAL_AMT_TOLERANCE | Tolerance level for total amount variance |
| TAX_TOL_AMT_RANGE | Tolerance level for total tax amount variance |
| TOLERANCE_TYPE | Designates the type of tolerance template as either Goods or Services |
| TOLERANCE_NAME | Tolerance Template Name |
| DESCRIPTION | Tolerance Template Description |
| PRICE_TOLERANCE | Percentage based tolerance level for price variance |
| QUANTITY_TOLERANCE | Percentage based tolerance level for quantity variance |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row |
| LAST_UPDATED_BY | Standard Who column - user who last updated this row |
| QTY_RECEIVED_TOLERANCE | Percentage based tolerance level for quantity received tolerance |
| TAX_TOLERANCE | Percentage based tolerance level for tax variance |
| Payables - AP_WEB_PROXY_ASSIGNMENTS | Stores reporting access rights relationships. |
|---|---|
| Column Name | Descritpion |
| ASSIGNMENT_ID | Unique sequence number. |
| LAST_UPDATE_DATE | Standard WHO column |
| LAST_UPDATED_BY | Standard WHO column |
| LAST_UPDATE_LOGIN | Standard WHO column |
| CREATED_BY | Standard WHO column |
| CREATION_DATE | Standard WHO column |
| ASSIGNOR_ID | Application user identifier. |
| ASSIGNEE_ID | Application user identifier. |
| RESPONSIBILITY_ID | Responsibility assigned to the user. |
| RESPONSIBILITY_APP_ID | Unique sequence number. |
| SECURITY_GROUP_ID | Security group identifier. |
| EFFECTIVE_START_DATE | The date the responsibility assignment begins. |
| EFFECTIVE_END_DATE | The date the responsibility assignment expires. |
| ASSIGNMENT_TYPE | Identifies the record source. |
| Payables - FINANCIALS_PURGES_ALL | Invoice purge selection criteria and purged invoice statistical data |
|---|---|
| Column Name | Descritpion |
| PURGE_NAME | Name of purge |
| ACTIVITY_DATE | Last date record updated (Records updated on or before this date will be selected as purge candidates) |
| AP_ENCUMBRANCE_LINES | Number of records purged from same name table |
| AP_PAYMENT_HISTORY | Number of records purged from same name table |
| AP_CHECKS | Number of rows purged from this table |
| AP_MATCHED_RECT_ADJ | Number of records purged from same name table |
| RCV_SUBLEDGER_DETAILS | Number of records purged from same name table |
| AP_INVOICES | Number of rows purged from this table |
| AP_MC_CHECKS | Number of rows purged from this table |
| AP_MC_INVOICE_DISTS | Number of rows purged from this table |
| PO_REQUISITION_HEADERS | Number of rows purged from this table |
| AP_MC_INVOICE_PAYMENTS | Number of rows purged from this table |
| AP_MC_INVOICES | Number of rows purged from this table |
| PO_HEADERS | Number of rows purged from this table |
| PO_MC_DISTRIBUTIONS | Number of rows purged from this table |
| PO_MC_HEADERS | Number of rows purged from this table |
| PO_VENDORS | Number of rows purged from this table |
| ORG_ID | Organization identifier |
| AP_INVOICE_LINES | Number of rows purged from this table |
| AP_INVOICE_PAYMENTS | Number of rows purged from this table |
| AP_ALLOCATION_RULES | Number of rows purged from this table |
| AP_ALLOCATION_RULE_LINES | Number of rows purged from this table |
| AP_INVOICE_PREPAYS | Number of rows purged from this table |
| AP_INV_APRVL_HIST | Number of rows purged from this table |
| AP_LINE_APRVL_HIST | Number of rows purged from this table |
| AP_PAYMENT_SCHEDULES | Number of rows purged from this table |
| APPROX_ROWS | Approximate transactions to be purged. |
| PAY_ALONE | To Purge Pay Alone only if chosen on UI. |
| AP_RECURRING_PAYMENTS | Number of rows purged from this table |
| CREATION_DATE | Standard who column - date when this row was created. |
| AP_TRIAL_BALANCE | Number of rows purged from this table |
| AP_INVOICE_DISTRIBUTIONS | Number of rows purged from this table |
| AP_HOLDS | Number of rows purged from this table |
| AP_BATCHES | Number of rows purged from this table |
| PO_REQUISITION_LINES | Number of rows purged from this table |
| PO_REQ_DISTRIBUTIONS | Number of rows purged from this table |
| PO_APPROVALS | Number of rows purged from this table |
| PO_LINES | Number of rows purged from this table |
| PO_LINE_LOCATIONS | Number of rows purged from this table |
| PO_DISTRIBUTIONS | Number of rows purged from this table |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| PO_RELEASES | Number of rows purged from this table |
| PO_ITEM_HISTORY | Number of rows purged from this table |
| PO_ACCEPTANCES | Number of rows purged from this table |
| PO_NOTES | Number of rows purged from this table |
| PO_NOTE_REFERENCES | Number of rows purged from this table |
| PO_RECEIPTS | Number of rows purged from this table |
| PO_DELIVERIES | Number of rows purged from this table |
| PO_QUALITY_INSPECTIONS | Number of rows purged from this table |
| PO_VENDOR_SITES | Number of rows purged from this table |
| PO_VENDOR_CONTACTS | Number of rows purged from this table |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| PO_HEADERS_ARCHIVE | Number of rows purged from this table |
| PO_LINES_ARCHIVE | Number of rows purged from this table |
| PO_LINE_LOCATIONS_ARCHIVE | Number of rows purged from this table |
| PO_VENDOR_LIST_HEADERS | Number of rows purged from this table |
| PO_VENDOR_LIST_ENTRIES | Number of rows purged from this table |
| PO_NOTIFICATIONS | Number of rows purged from this table |
| PO_ACCRUAL_RECONCILE_TEMP | Number of rows purged from this table |
| PO_BLANKET_ITEMS | Number of rows purged from this table |
| PO_RECEIPT_HEADERS | Number of rows purged from this table |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| ORGANIZATION_ID | Organization identifier |
| PO_APPROVED_SUPPLIER_LIST | Number of rows purged from this table |
| PO_ASL_ATTRIBUTES | Number of rows purged from this table |
| PO_ASL_DOCUMENTS | Number of rows purged from this table |
| CHV_AUTHORIZATIONS | Number of rows purged from this table |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CHV_CUM_ADJUSTMENTS | Number of rows purged from this table |
| CHV_CUM_PERIODS | Number of rows purged from this table |
| CHV_CUM_PERIOD_ITEMS | Number of rows purged from this table |
| CHV_HORIZONTAL_SCHEDULES | Number of rows purged from this table |
| CHV_ITEM_ORDERS | Number of rows purged from this table |
| CATEGORY | Type of purge process |
| CHV_SCHEDULE_HEADERS | Number of rows purged from this table |
| CHV_SCHEDULE_ITEMS | Number of rows purged from this table |
| MRP_SR_SOURCE_ORG | Number of rows purged from this table |
| MRP_ITEM_SOURCING | Number of rows purged from this table |
| STATUS | Status of completion of purge process |
| AP_ACCOUNTING_EVENTS | Number of records purged from same name table |
| AP_AE_HEADERS | Number of records purged from same name table |
| ACTION | Action you select for purge |
| AP_AE_LINES | Number of records purged from same name table |
| AP_CHRG_ALLOCATIONS | Number of records purged from same name table |
| Payables - AP_USER_EXCHANGE_RATES | User type exchange rate when submitting the payment process request for multiple currencies and even multiple functional currencies. |
|---|---|
| Column Name | Descritpion |
| CHECKRUN_ID | Payment process request identifier |
| PAYMENT_CURRENCY_CODE | Payment Currency Code |
| LEDGER_CURRENCY_CODE | Ledger Currency Code |
| EXCHANGE_RATE | User Exchange Rate |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Payables - AP_UNSELECTED_INVOICES_ALL | This table holds invoices that could not be paid by a payment batch. |
|---|---|
| Column Name | Descritpion |
| INVOICE_ID | Invoice identifier |
| PAYMENT_NUM | Payment number |
| DONT_PAY_REASON_CODE | Reason that OK_TO_PAY_FLAG is N |
| ORG_ID | Organization identifier |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CHECKRUN_ID | Payment batch identifier |
| LAST_UPDATE_LOGIN | Standard Who column |
| Payables - OIE_CURRENT_PAGE_SETTING | This table stores the current setting of a region (hide-show, table..) on a page for each user. |
|---|---|
| Column Name | Descritpion |
| USER_ID | Fnd User Identifier |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| PAGE_NAME | Page Identifier |
| OBJECT_NAME | Object Identifier |
| OBJECT_TYPE_CODE | Lookup Code for Object Type |
| HIDE_FLAG | Lookup Code for Hide or Show |
| SELECTED_TAB | Selected Tabd Identifier |
| SORTED_COLUMN | Sorted Column Identifier |
| SORT_ORDER_CODE | Lookup Code for Sort Order |
| CREATION_DATE | Standard Who column |
| Payables - AP_WEB_ACCFLEX_SEGMENTS | Accounting flexfield setup. |
|---|---|
| Column Name | Descritpion |
| ID_FLEX_NUM | Chart of Accounts ID. |
| APPLICATION_COLUMN_NAME | Application Column Name. |
| SEGMENT_NUM | Segment Number. |
| SEGMENT_DISPLAY_CODE | Determines display behavior for segment. |
| LAST_UPDATE_DATE | Standard Who Column. |
| LAST_UPDATED_BY | Standard Who Column. |
| CREATION_DATE | Standard Who Column. |
| CREATED_BY | Standard Who Column. |
| LAST_UPDATE_LOGIN | Standard Who Column. |
| SET_OF_BOOKS_ID | Set Of Books Id |
| Payables - OIE_DATA_CAPTURE_FIELDS | Stores the field behavior for the data capture rules. |
|---|---|
| Column Name | Descritpion |
| EXPENSE_FIELD_ID | Entity Identifier |
| RULE_ID | References the data capture rule |
| FIELD_NAME | Stores the name of the field that needs to be displayed for data capture |
| FIELD_BEHAVIOR | Stores the behavior of the field (enabled/disabled/required) |
| LAST_UPDATE_DATE | Standard WHO column |
| LAST_UPDATED_BY | Standard WHO column |
| LAST_UPDATE_LOGIN | Standard WHO column |
| CREATED_BY | Standard WHO column |
| CREATION_DATE | Standard WHO column |
| Payables - OIE_DATA_CAPTURE_OPTIONS | Stores the attendee types enabled for the data capture rules. |
|---|---|
| Column Name | Descritpion |
| OPTION_ID | Entity Identifier |
| RULE_ID | References the data capture rule |
| OPTION_TYPE | Stores the option type for the rule (references lookup type) |
| OPTION_CODE | Stores the option code enabled for the rule (references lookup code) |
| LAST_UPDATE_DATE | standard WHO column |
| LAST_UPDATED_BY | Standard WHO column |
| LAST_UPDATE_LOGIN | Standard WHO column |
| CREATED_BY | Standard WHO column |
| CREATION_DATE | Standard WHO column |
| Payables - OIE_DATA_CAPTURE_RULES | Stores the expense type data capture rules. |
|---|---|
| Column Name | Descritpion |
| RULE_ID | Entity Identifier |
| CREATION_DATE | Standard WHO column |
| RULE_NAME | Name of person who is attendee/recepient |
| RULE_DESCRIPTION | Title of the attendee/recepient |
| DATA_CAPTURE_TYPE | Indicates option to capture data for employee only, non-employee only or both. |
| INCLUDE_FILER_FLAG | Indicates the type of defaulting of the filer as an attendee. |
| LAST_UPDATE_DATE | Standard WHO column |
| LAST_UPDATED_BY | Standard WHO column |
| LAST_UPDATE_LOGIN | Standard WHO column |
| CREATED_BY | Standard WHO column |
| Payables - OIE_SET_DISTRIBUTIONS | Set Distribution Table. |
|---|---|
| Column Name | Descritpion |
| DISTRIBUTION_SET_ID | Distribution Set ID |
| SEGMENT3 | Segment column |
| SEGMENT4 | Segment column |
| SEGMENT5 | Segment column |
| SEGMENT6 | Segment column |
| SEGMENT7 | Segment column |
| SEGMENT8 | Segment column |
| SEGMENT9 | Segment column |
| SEGMENT10 | Segment column |
| SEGMENT11 | Segment column |
| SEGMENT12 | Segment column |
| DISTRIBUTION_ID | Distribution Line Identifier |
| SEGMENT13 | Segment column |
| SEGMENT14 | Segment column |
| SEGMENT15 | Segment column |
| SEGMENT16 | Segment column |
| SEGMENT17 | Segment column |
| SEGMENT18 | Segment column |
| SEGMENT19 | Segment column |
| SEGMENT20 | Segment column |
| SEGMENT21 | Segment column |
| SEGMENT22 | Segment column |
| PERCENTAGE | Split Percentage |
| SEGMENT23 | Segment column |
| SEGMENT24 | Segment column |
| SEGMENT25 | Segment column |
| SEGMENT26 | Segment column |
| SEGMENT27 | Segment column |
| SEGMENT28 | Segment column |
| SEGMENT29 | Segment column |
| SEGMENT30 | Segment column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| PROJECT_ID | Project ID |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| TASK_ID | Task ID |
| AWARD_ID | Award ID |
| PROJECT_EXPENDITURE_ORG_ID | Project Expenditure Organization ID |
| SEGMENT1 | Segment column |
| SEGMENT2 | Segment column |
| Payables - OIE_ALLOCATION_PREFS | User Allocation Preferences |
|---|---|
| Column Name | Descritpion |
| ALLOCATION_PREF_ID | Primary Key |
| PERSON_ID | Foreign key to PER_PEOPLE_X |
| DISTRIBUTION_SET_ID | Foreign key to OIE_DISTRIBUTION_SETS |
| ALLOCATION_PREF_REASON | Distribution Set Reason |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Payables - OIE_DISTRIBUTION_SETS_ALL | Distribution Set Header Table |
|---|---|
| Column Name | Descritpion |
| DISTRIBUTION_SET_ID | Distribution Set Identifier |
| LAST_UPDATE_LOGIN | Standard Who column |
| DISTRIBUTION_SET_NAME | Distribution Set Name |
| DISTRIBUTION_METHOD | Distribution Method |
| DISTRIBUTION_SET_TYPE_CODE | Identifies, if the distribution is an Account distribution or a Project distribution. |
| ORG_ID | The organization Identifier |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| Payables - OIE_POL_RATES_INTERFACE | This table serves as an interface / staging table for uploaded CONUS and OCONUS rates which can be used to generate policy schedules. |
|---|---|
| Column Name | Descritpion |
| STATE_PROVINCE | Stores the location State or Province |
| OFF_BASE_INC_AMT | Stores the location Off Base Inc Amount |
| FOOTNOTE_AMT | Stores the location Footnote Amount |
| FOOTNOTE_RATE_AMT | Stores the location Footnote Rate Amount |
| MAX_PER_DIEM_AMT | Stores the location Max Per Diem Rate Amount |
| EFFECTIVE_DATE | Stores the location Effective Date |
| CREATED_BY | Standard WHO column |
| CREATION_DATE | Standard WHO column |
| LAST_UPDATED_BY | Standard WHO column |
| LAST_UPDATE_LOGIN | Standard WHO column |
| LAST_UPDATE_DATE | Standard WHO column |
| COUNTRY | Stores the location Country |
| CITY_LOCALITY | Stores the location City or Locality |
| COUNTY | Stores the location County |
| START_OF_SEASON | Stores the location Start of Season |
| END_OF_SEASON | Stores the location End of Season |
| MAX_LODGING_AMT | Stores the location Max Lodging Amount |
| NO_GOVT_MEALS_AMT | Stores the location Local Meals Amount |
| PROP_MEALS_AMT | Stores the location Proportional Meals Amount |
| Payables - AP_WEB_DISC_LINES_GT | |
|---|---|
| Column Name | Descritpion |
| START_DATE | |
| JUSTIFICATION | |
| RECEIPT_MISSING_FLAG | |
| PROJECT_NUMBER | |
| TASK_NUMBER | |
| AWARD_NUMBER | |
| VAT_CODE | |
| TAX_CODE_ID | |
| AMOUNT_INCLUDES_TAX_FLAG | |
| RECEIPT_ERRORS_FLAG | |
| ATTRIBUTE_CATEGORY | |
| END_DATE | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| DAILY_AMOUNT | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| RECEIPT_AMOUNT | |
| REIMBURSABLE_AMOUNT | |
| RATE | |
| PARAMETER_ID | |
| CURRENCY_CODE | |
| GROUP_VALUE |
| Payables - OIE_ADDON_MILEAGE_RATES_ARC | OIE Archive Table for Add On Mileage Rates |
|---|---|
| Column Name | Descritpion |
| ARC_REQ_ID | |
| LAST_UPDATE_LOGIN | |
| CREATED_BY | |
| CREATION_DATE | |
| ARCHIVE_DATE | |
| REPORT_LINE_ID | |
| ADDON_RATE_TYPE | |
| MILEAGE_RATE | |
| MILEAGE_AMOUNT | |
| MILEAGE_PAYROLL_TAX_CODE_ID | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY |
| Payables - OIE_ATTENDEES_ARC | OIE Archive Table for Attendee Information |
|---|---|
| Column Name | Descritpion |
| ARC_REQ_ID | |
| EMPLOYER | |
| EMPLOYER_ADDRESS | |
| TAX_ID | |
| ORG_ID | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_LOGIN | |
| ARCHIVE_DATE | |
| ATTENDEE_LINE_ID | |
| REPORT_LINE_ID | |
| EMPLOYEE_FLAG | |
| EMPLOYEE_ID | |
| ATTENDEE_TYPE | |
| NAME | |
| TITLE |
| Payables - OIE_PDM_DAILY_BREAKUPS_ARC | OIE Archive Table for Perdiem Daily Breakups |
|---|---|
| Column Name | Descritpion |
| ARC_REQ_ID | |
| BREAKFAST_FLAG | |
| LUNCH_FLAG | |
| DINNER_FLAG | |
| ACCOMMODATION_AMOUNT | |
| ACCOMMODATION_FLAG | |
| HOTEL_NAME | |
| NIGHT_RATE_TYPE | |
| NIGHT_RATE_AMOUNT | |
| PDM_RATE | |
| PDM_DESTINATION_ID | |
| ARCHIVE_DATE | |
| RATE_TYPE_CODE | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN | |
| CREATED_BY | |
| CREATION_DATE | |
| SCHEDULE_TYPE_CODE | |
| CUST_MEALS_AMOUNT | |
| CUST_ACCOMMODATION_AMOUNT | |
| CUST_NIGHT_RATE_AMOUNT | |
| PDM_DAILY_BREAKUP_ID | |
| CUST_PDM_RATE | |
| REPORT_LINE_ID | |
| START_DATE | |
| END_DATE | |
| AMOUNT | |
| NUMBER_OF_MEALS | |
| MEALS_AMOUNT |
| Payables - OIE_PDM_DESTINATIONS_ARC | OIE Archive Table for PerDiem Destinations |
|---|---|
| Column Name | Descritpion |
| ARC_REQ_ID | |
| LAST_UPDATE_LOGIN | |
| CREATED_BY | |
| CREATION_DATE | |
| ARCHIVE_DATE | |
| PDM_DESTINATION_ID | |
| REPORT_LINE_ID | |
| START_DATE | |
| END_DATE | |
| LOCATION_ID | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY |
| Payables - OIE_DUP_RULE_ASSIGNMENTS_ALL | This table contains the information related to the assignment of either duplicate detection rule or rule set to the operating units, along with Global rule assignment. |
|---|---|
| Column Name | Descritpion |
| RULE_ASSIGNMENT_ID | Duplicate Detection Rules Assignment identifier |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID) |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID) |
| ORG_ID | Organization identifier |
| RULE_ID | Holds the rule id of the duplicate detection rule that was assigned |
| RULE_SET_ID | Holds the rule set id of the duplicate detection rule set that was assigned |
| START_DATE | Holds the effective start date of the duplicate detection rules assignment |
| END_DATE | Holds the effective end date of the duplicate detection rules assignment |
| CREATION_DATE | Standard who column - date when this row was created |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID) |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row |
| Payables - OIE_DUP_DETECT_RS_SUMMARY | This table contains the general information related to duplicate detection rule sets. |
|---|---|
| Column Name | Descritpion |
| RULE_SET_ID | Duplicate Detection Rule Set identifier |
| RULE_SET_NAME | Holds the name of the duplicate detection rule set |
| DESCRIPTION | Holds the description of the duplicate detection rule set |
| CREATION_DATE | Standard who column - date when this row was created |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID) |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID) |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID) |
| Payables - OIE_DUP_DETECT_RS_DETAIL | This table contains the information related to the duplicate detection rules assigned to the expense categories, along with Generic type. |
|---|---|
| Column Name | Descritpion |
| RULE_SET_ID | Holds the duplicate detection rule set id |
| CATEGORY_CODE | Holds the expense category code for which the duplicate detection rule is assigned |
| RULE_ID | Holds the rule id of the duplicate detection rule that was assigned to the specific category |
| CREATION_DATE | Standard who column - date when this row was created |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID) |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID) |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID) |
| Payables - OIE_DUP_DETECT_RULES | This table contains all of the information related to duplicate detection rules. |
|---|---|
| Column Name | Descritpion |
| RULE_ID | Duplicate Detection Rule Identifier |
| DETECT_END_DATE_FLAG | This flag indicates whether End Date is considered for performing the duplicate detection. This is an expense category specific field for Accommodations |
| DETECT_MERCHANT_FLAG | This flag indicates whether Merchant is considered for performing the duplicate detection. This is an expense category specific field for Accommodations, Airfare and Car Rental |
| DETECT_CLASS_OF_TICKET_FLAG | This flag indicates whether Ticket Class is considered for performing the duplicate detection. This is an expense category specific field for Airfare |
| DETECT_TICKET_NUM_FLAG | This flag indicates whether Ticket Number is considered for performing the duplicate detection. This is an expense category specific field for Airfare |
| DETECT_FROM_LOCATION_FLAG | This flag indicates whether From Location is considered for performing the duplicate detection. This is an expense category specific field for Airfare |
| DETECT_TO_LOCATION_FLAG | This flag indicates whether To Location is considered for performing the duplicate detection. This is an expense category specific field for Airfare |
| DETECT_DISTANCE_UOM_FLAG | This flag indicates whether Distance UOM is considered for performing the duplicate detection. This is an expense category specific field for Mileage |
| DETECT_DAILY_TRIP_DIST_FLAG | This flag indicates whether Trip Distance is considered for performing the duplicate detection. This is an expense category specific field for Mileage |
| DETECT_LOCATION_FIELDS_FLAG | This flag indicates whether Location Fields is considered for performing the duplicate detection. This is an expense category specific field for Mileage |
| DETECT_VLP_NUM_FLAG | This flag indicates whether Vehicle License Plate Number is considered for performing the duplicate detection. This is an expense category specific field for Mileage |
| RULE_NAME | Holds the name of the duplicate detection rule |
| DETECT_ATTENDEE_FLAG | This flag indicates whether Attendee is considered for performing the duplicate detection. This is an additional rule |
| DUPLICATES_ALLOWED | Holds the number of duplicates allowed |
| DUPLICATE_DETECTION_ACTION | Holds the duplicate detection action that to be perfomed when duplicates were detected |
| CREATION_DATE | Standard who column - date when this row was created |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID) |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID) |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID) |
| RULE_TYPE | Holds the rule type, which can be either Accommodations or Airfare or Car Rental or Generic or Meals or Mileage or Miscellaneous or PerDiem |
| DESCRIPTION | Holds the description of the duplicate detection rule |
| DETECT_EMPLOYEE_FLAG | This flag indicates whether Employee is considered for performing the duplicate detection. This is an required attribute and this flag always be Y |
| DETECT_RECEIPT_DATE_FLAG | This flag indicates whether Receipt Date is considered for performing the duplicate detection. This is an required attribute and this flag always be Y |
| DETECT_EXP_CATEGORY_FLAG | This flag indicates whether Expense Category is considered for performing the duplicate detection. This is an required attribute and this flag always be Y |
| DETECT_EXPENSE_TYPE_FLAG | This flag indicates whether Expense Type is considered for performing the duplicate detection. This is an optional attribute |
| DETECT_RECEIPT_AMT_FLAG | This flag indicates whether Receipt Amount along with Receipt Currency is considered for performing the duplicate detection. This is an optional attribute |
No hay comentarios:
Publicar un comentario