file link: PCF_InputFile_ef_supplier
Purpose of the file: xxxx
| gbu | Rawmaterial_code | Rawmaterial_name | Supplier_code | Supplier_name | Plant_code | Plant_name | PCF_supplier | BCC_supplier | TCC_supplier | RCC_supplier | CCU_CC_supplier | PCF_transport_supplier | PDS_supplier | DQR_supplier | Adj_coeff_supplier | Activity_Year | |
| Sample Data | CS | WP1_400/118919 | 2-ETHYL HEXYL ACRYLATE BULK | 106496 | BASF CORP | 1402 | CLAMECY | 2.31 | 3 | 2021 | |||||||
| Mandatory Field ? | Mandatory field; Must be filled. Validation if the GBU exists. | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 20 | Not mandatory field | Not mandatory field.If the field is filled, the values should be between 1 and 3 | Not mandatory field. | Mandatory field |
| Data Type | string | string | string | string | string | string | string | Float greater than 20 and lower than - 20 should be uploaded, | float between 0 and 1 | float between 0 and 1 | float between 0 and 1 | float between 0 and 1 | float between 0 and 20 | float between 0 and 1 | float between 1 and 3 | float | string |
| Field Description | xxxxx | ||||||||||||||||
| Comments | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | As we don't have master data tables, we cannot validate whether the values exist or not through comparison. | A warning message should be sent to the Data Owner (but the data should be uploaded) |
Data Owner - Hubert Sizaret (the data owner will receive the error file by email and will be responsible for making any necessary manual corrections.)