AP_TOLERANCE_TEMPLATES
AP_TOLERANCE_TEMPLATES contains the tolerance levels you set for matching and invoice variance testing. Oracle Payables uses this information to determine during Invoice Validation to hold an invoice for exceeding tolerance.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_TOLERANCE_TEMPLATES_PK |
TOLERANCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TOLERANCE_ID | NUMBER | 18 | Yes | A unique identifier for the tolerance template. | |
| TOLERANCE_NAME | VARCHAR2 | 255 | Yes | Name of the tolerance template. | |
| DESCRIPTION | VARCHAR2 | 255 | Description of the tolerance template. | ||
| PRICE_TOLERANCE | NUMBER | Percentage based tolerance level for price variance | |||
| QUANTITY_TOLERANCE | NUMBER | Percentage based tolerance level for quantity variance | |||
| 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. | |
| QTY_RECEIVED_TOLERANCE | NUMBER | Percentage based tolerance level for quantity received tolerance | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| MAX_QTY_ORD_TOLERANCE | NUMBER | Tolerance level for maximum quantity ordered variance | |||
| MAX_QTY_REC_TOLERANCE | NUMBER | Tolerance level for maximum quantity received variance | |||
| SHIP_AMT_TOLERANCE | NUMBER | Tolerance level for purchase order shipment amount variance | |||
| RATE_AMT_TOLERANCE | NUMBER | Tolerance level for exchange rate amount variance | |||
| TOTAL_AMT_TOLERANCE | NUMBER | Tolerance level for total amount variance | |||
| TOLERANCE_TYPE | VARCHAR2 | 30 | Designates the type of tolerance template as either Goods or Services | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | 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. | |
| QTY_CONSUMED_TOLERANCE | NUMBER | Tolerance level for comparison of billed quantity with consumed quantity expressed as a percentage. | |||
| MAX_QTY_CON_TOLERANCE | NUMBER | Tolerance level for comparison of billed quantity with consumed quantity expressed as an absolute value. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| poz_supplier_sites_all_m | ap_tolerance_templates | SERVICES_TOLERANCE_ID |
| poz_supplier_sites_all_m | ap_tolerance_templates | TOLERANCE_ID |
| ap_system_parameters_all | ap_tolerance_templates | TOLERANCE_ID |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AP_TOLERANCE_TEMPLATES_U1 | Unique | TOLERANCE_ID |