Purchasing Targets Dataset Structure
The FILE_PURCH_TARGET_FS dataset contains the following columns.
| Column | Data Type | Description |
|---|---|---|
|
PERIOD_START_DT |
VARCHAR2(19) |
Start date of the reporting period. |
|
PRC_BU_ID |
VARCHAR2(80) |
Purchasing Business Unit identifier. |
|
KPI_NAME |
VARCHAR2(80) |
Name of the Procurement KPI. |
|
TARGET_VALUE |
NUMBER |
Target value configured for the KPI. |
|
DELETE_FLG |
VARCHAR2(1) |
Indicates whether the record is marked for deletion. |
|
CREATED_ON_DT |
VARCHAR2(19) |
Record creation timestamp. |
|
CHANGED_ON_DT |
VARCHAR2(19) |
Last modification timestamp. |
|
DATASOURCE_NUM_ID |
NUMBER |
Source system identifier. |
|
INTEGRATION_ID |
VARCHAR2(80) |
Unique integration identifier. |
|
TENANT_ID |
VARCHAR2(80) |
Tenant identifier for multi-tenant environments. |
|
X_CUSTOM |
VARCHAR2(10) |
Reserved custom attribute. |