AP_IDR_OPTIONS_
AP_IDR_OPTIONS contains the parameters and defaults you define for operating your Intelligent Document Recognition system. AP_IDR_OPTIONS_ is the Audit table for it.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_IDR_OPTIONS_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, IDR_OPTIONS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| IDR_OPTIONS_ID | NUMBER | 18 | Yes | Indicates the unique identifier associated to the row . | |
| IDR_EMAIL | VARCHAR2 | 1000 | The Email address that you have to send the images for processing by Intelligent Document Recognition. | ||
| BU_DERIVATION_BASIS_CODE | VARCHAR2 | 30 | Indicates the basis for derivation of business unit for image invoices created by Intelligent Document Recognition. | ||
| BU_EMAIL_MAPPING | XMLTYPE | Mapping of business unit with Email to derive the BU that is stamped on the invoice based on the email from which the image is sent. | |||
| USE_TAX_AMOUNT_AS_CONTROL_FLAG | VARCHAR2 | 1 | Option that indicates if the recognized tax amount must be considered as tax control amount for the entire invoice (Y or N). It will ensure that the calculated tax is the same as on the physical document. | ||
| IMPORT_FREIGHT_AMOUNT_FLAG | VARCHAR2 | 1 | Option that indicates if the recognized freight amount must be imported to Fusion Payables (Y or N). | ||
| ENFORCE_INCOMPLETE_STATUS_FLAG | VARCHAR2 | 1 | Indicates whether all Image invoices must be imported to Fusion Payables in Incomplete validation status. | ||
| CALC_TAX_DURING_IMPORT_FLAG | VARCHAR2 | 1 | Indicates whether tax should be calculated for the image invoices during import (Y or N). | ||
| IMPORT_PAIRED_LINES_ONLY_FLAG | VARCHAR2 | 1 | Option that indicates if the unmatched lines recognized for matched invoices must be imported to Fusion Payables (Y or N). | ||
| IMPORT_LINES_MATCHED_FLAG | VARCHAR2 | 1 | A value of Y indicates that the lines recognized for matched invoices must be imported to Fusion Payables. | ||
| IMPORT_LINES_UNMATCHED_FLAG | VARCHAR2 | 1 | A value of Y indicates that the lines recognized for unmatched invoices must be imported to Fusion Payables. | ||
| SINGLE_LINE_AMOUNT_PO_FLAG | VARCHAR2 | 1 | A value of Y indicates that system will create single matched line for invoices matched to amount based purchase orders. | ||
| SINGLE_LINE_UTILITY_INV_FLAG | VARCHAR2 | 1 | A value of Y indicates that system will create single invoice line for invoices created on suppliers categorized as Utility vendors. | ||
| PROCESS_DOC_ATTACHMENT_FLAG | VARCHAR2 | 1 | Option that indicates if you allow processing of DOC type attachments by Intelligent Document Recognition (Y or N). | ||
| PROCESS_DOCX_ATTACHMENT_FLAG | VARCHAR2 | 1 | Option that indicates if you allow processing of DOCX type attachments by Intelligent Document Recognition (Y or N). | ||
| PROCESS_PDF_ATTACHMENT_FLAG | VARCHAR2 | 1 | Option that indicates if you allow processing of PDF type attachments by Intelligent Document Recognition (Y or N). | ||
| PROCESS_TIFF_ATTACHMENT_FLAG | VARCHAR2 | 1 | Option that indicates if you allow processing of TIFF type attachments by Intelligent Document Recognition (Y or N). | ||
| PROCESS_PNG_ATTACHMENT_FLAG | VARCHAR2 | 1 | Option that indicates if you allow processing of PNG type attachments by Intelligent Document Recognition (Y or N). | ||
| PROCESS_JPEG_ATTACHMENT_FLAG | VARCHAR2 | 1 | Option that indicates if you allow processing of JPEG type attachments by Intelligent Document Recognition (Y or N). | ||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| REFERENCE_KEY1 | VARCHAR2 | 150 | Captures reference information from other applications. Free text field. Not validated. | ||
| REFERENCE_KEY2 | VARCHAR2 | 150 | Captures reference information from other applications. Free text field. Not validated. | ||
| REFERENCE_KEY3 | VARCHAR2 | 150 | Captures reference information from other applications. Free text field. Not validated. | ||
| REFERENCE_KEY4 | VARCHAR2 | 150 | Captures reference information from other applications. Free text field. Not validated. | ||
| REFERENCE_KEY5 | VARCHAR2 | 150 | Captures reference information from other applications. Free text field. Not validated. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| REQUESTER_EMAIL_DOMAIN | CLOB | The domain name used to recognize and extract requester email from the invoice document. | |||
| VALIDATE_PO_LE_FLAG | VARCHAR2 | 1 | Option that indicates whether the legal entity recognized for matched invoices must be validated with the legal entity on the purchase order available in the Fusion Purchasing. Possible values are Y or N. | ||
| CONVERT_EMAIL_INTO_ATTACH_FLAG | VARCHAR2 | 1 | Indicates whether the email should be converted into an attachment to the invoice. Possible values are Y or N. | ||
| IDR_ACTIVATION_STATUS | VARCHAR2 | 30 | Activation status for Intelligent Document Recognition (IDR). Possible values are ACTIVE and INACTIVE | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_IDR_OPTIONS_N1_ | Non Unique | Default | IDR_OPTIONS_ID |
| AP_IDR_OPTIONS_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, IDR_OPTIONS_ID |