Load Quality issues (QIS)
Possible fields to be loaded into RamBase are listed in the Field-column in the following table. The other columns in this table provide additional information about each field.
Field | Required | Format | Length | Example | Description |
|---|---|---|---|---|---|
ST | Y | Status | 1 | 4 | Status of the Quality issue (QIS). It may be one of these values: 1 - Registering 2 - Analyzing 4 - Waiting for actions 8 - Reviewing 9 - Closed |
TITLE | Y | Text | Title of the Quality issue (QIS). | ||
DESCRIPTION | Y* | Text | *May be required by Company settings (CSV). Description of the Quality issue (QIS). | ||
TYPE | Y* | Number | 123456 | *May be required by Company settings (CSV). Type of quality issue (DOV). Identifier can be found in QHSES setup (QISADMIN) application next to specific type (columns might be hidden). | |
CATEGORY | Y* | Number | 123456 | *May be required by Company settings (CSV). Quality issue category (DOV). Identifier can be found in QHSES setup (QISADMIN) application next to specific type (columns might be hidden). | |
OCCUREDAT | Y* | Date time - YYYY.MM.DD HH:MM:SS | 2023.08.24 15:48:23 | *May be required by Company settings (CSV). Date and time when this issue occurred. | |
REGISTEREDAT | Recommended when ST >= 2. | Date time - YYYY.MM.DD HH:MM:SS | 2023.08.24 15:48:23 | Date and time when issue was registered. | |
DUEDATE | Date - YYYY.MM.DD | 2023.08.24 | Date for when issue has to be resolved. | ||
CLOSEDAT | Date time - YYYY.MM.DD HH:MM:SS | 2023.08.24 15:48:23 | Date and time issue was closed. | ||
CLOSECOMMENT | Text | Additional comment added when quality issue was closed. | |||
RESPONSIBLE | Y* | Number | 123 | *May be required by Company settings (CSV). PID of person who is responsible for the Quality issue (QIS). | |
ASSIGNEE | Number | 123 | PID of person the issue is assigned to. | ||
CREATEDBY | Number | 123 | PID of creator. | ||
TOTALCOST | Decimal number | 4999.95 | Total cost of the issue. Calculated based on data in sub-table, but editable. (Default 0 if no value is added) | ||
RISKSCORE | Number | 9 | Likelihood multiplied by severity of a quality issue. Used in risk assessment analysis. Calculated based on data in sub-table, but editable. | ||
DEPNO | Y* | Number | 123 | *May be required by Company settings (CSV). Department identifier. | |
LOCNO | Number | 123456 | Location identifier. | ||
REPORTARCHIVE | REPORTARCHIVE and REPORTNO are both required if load is to include reporter. | Text | 3 | CUS | Type of reporter. Possible values limited to CUS (Customer), SUP (Supplier) and PER (Personnel). |
REPORTNO | REPORTARCHIVE and REPORTNO are both required if load is to include reporter. | Number | 123456 | Reporter identifier. | |
EXTERNALREFERENCE | Text | External reference of the client’s or customer’s issue. | |||
EXTERNALTITLE | Text | Title of the Quality issue (QIS) used as title in external correspondence. | |||
REQUIREREVIEW | Recommended | True (=1) or false (=0) | 1 | 0 | True if this issue requires a review. False if not. (Default 0 if no value is added.) |
NOTIFYWHENCLOSED | Recommended | True (=1) or false (=0) | 1 | 0 | If this is set to true, an IMS will be sent to the creator of the issue. (Default 0 if no value is added.) |
ISMARKEDASNCR | Recommended | True (=1) or false (=0) | 1 | 0 | Whether this issue is marked as non conformance report (NCR) or not. (Default 0 if no value is added.) |
SOURCEARCH | SOURCEARCH and SOURCENO are both required if load is to include source. | Text | PWO | Type of source for Quality issue (QIS). | |
SOURCENO | SOURCEARCH and SOURCENO are both required if load is to include source. | Number | 123456 | Identifier of source for Quality issue (QIS). If using ART as source for this field, leave out "#", as this is a pure numerical field (no special characters). | |
SOURCEITM | Number | 1 | Item number of the source object. | ||
SOURCEIT | Text | #123456 | Identifier of the source product, preceded by # character. | ||
SOURCECUSACCOUNT | Number | 123456 | Identifier of the source customer account. Source related fields can be provided from file and will not be overwritten. Main source related fields will be automatically filled with corresponding data. | ||
SOURCESUPACCOUNT | Number | 123456 | Source supplier account identifier. | ||
SOURCEAFFECTEDQTY | Number | Number of affected product units. (Default 0 if no value is added.) Automatically calculated, but editable. | |||
SOURCETOTALQTY | Number | Total amount of units in the source of the issue. (Default 0 if no value is added.) Automatically calculated. | |||
SOURCECOANO | Number | 123456 | Source sales order identifier. | ||
SOURCECOAITM | Number | 1 | Source sales order item identifier. | ||
SOURCERESNO | Number | 123456 | Source production resource identifier. | ||
SOURCEMFRNO | Number | 1234 | Source manufacturer identifier. | ||
SOURCEOPRNODETECTED | Number | 123456 | Production operation identifier of the operation the issue was detected. | ||
SOURCEOPRNOOCCURRED | Number | 123456 | Production operation number of source where the issue occurred. | ||
SOURCEMATERIALIT | Text | #123456 | Source material identifier, preceded by # character. | ||
SOURCEMATERIALCODE | Text | Code of the source material. | |||
SOURCEPRJNO | Number | 234 | Finance project reference from source. | ||
SOURCEPWONO | Number | 123456 | Source production work order identifier. | ||
SOURCESPONO | Number | 123456 | Source purchase order identifier. | ||
SOURCESPOITM | Number | 1 | Source purchase order item identifier. | ||
EXTID | Text | ID-1234 | Identifier of the Quality issue (QIS) in source system which it was exported from. | ||
NOTE1 | Text | Note containing additional information added to the Quality issue (QIS). | |||
REPORTEDBYCUSEXTID | N | Text | ID-1234 | Identifier of customer from external system. If found in loaded customers it is set as a REPORTNO. | |
REPORTEDBYSUPEXTID | N | Text | ID-1234 | Identifier of supplier from external system. If found in loaded suppliers it is set as a REPORTNO. | |
REPORTEDBYPEREXTID | N | Text | ID-1234 | Identifier of employee from external system. If found in loaded employees it is set as a REPORTNO. | |
ARTEXTID | N | Text | ID-1234 | Identifier of the article/product loaded from external system. Articles loaded from external system have their own identifier and when found - this articles is set as a main source in loaded quality issue - will overwrite SOURCEARCH and SOURCENO, SOURCEITM will be empty. | |
CUSTOMTAG | Text | My custom tag text,second custom tag | Text added as custom tags to the imported quality issue. Might be more tags, they should be separated by comma. | ||
UDF | 123.123 - decimals with "." as a decimal separator 0/1 - zero or one as a boolean value yyyy.mm.dd - as date yyyy.mm.dd hh:MM:ss as datetime | UDF_NameOfCustomField | Custom field at main level of the quality issue. There might be many custom fields and each one of them should have separate column in .csv file with "UDF_" prefix. Specific formats are given in format column. |