AP_VENDOR_KEY_IND_ALL
Compiled supplier information for the Key Indicators Report
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_SUMMARY
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Name of the key indicator calendar period for which the report was submitted. | |
| 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. | |
| NUM_VENDORS | NUMBER | Number of new suppliers entered. | |||
| NUM_VENDOR_SITES | NUMBER | Number of new sites entered for the new suppliers. | |||
| NUM_SITES | NUMBER | Number of new sites entered for the existing suppliers. | |||
| NUM_INACTIVE_VENDORS | NUMBER | Number of suppliers with a value in the Inactive On field that is on or before the current date. | |||
| NUM_ONE_TIME_VENDORS | NUMBER | Number of new suppliers designated as one-time suppliers. | |||
| NUM_1099_VENDORS | NUMBER | Number of new suppliers who are 1099 type suppliers. A 1099 supplier is one who is defined as Federal Reportable. | |||
| NUM_VENDORS_HELD | NUMBER | Number of new supplier sites that have supplier site holds.In the Supplier Sites window, you can hold all payments or hold unvalidated invoices for a supplier site. | |||
| NUM_VENDORS_UPDATED | NUMBER | Number of pre-existing suppliers with added or changed supplier information. | |||
| NUM_SITES_UPDATED | NUMBER | Number of pre-existing supplier sites with added or changed site information. | |||
| VALUE1 | NUMBER | Value for custom statistical tracking. | |||
| VALUE2 | NUMBER | Value for custom statistical tracking. | |||
| VALUE3 | NUMBER | Value for custom statistical tracking. | |||
| VALUE4 | NUMBER | Value for custom statistical tracking. | |||
| VALUE5 | NUMBER | Value for custom statistical tracking. | |||
| VALUE6 | NUMBER | Value for custom statistical tracking. | |||
| VALUE7 | NUMBER | Value for custom statistical tracking. | |||
| VALUE8 | NUMBER | Value for custom statistical tracking. | |||
| VALUE9 | NUMBER | Value for custom statistical tracking. | |||
| VALUE10 | NUMBER | Value for custom statistical tracking. | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| 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. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_VENDOR_KEY_IND_U1 | Unique | APPS_TS_SUMMARY | PERIOD_NAME, ORG_ID |