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