Skip to main content

[en] Knowledge Center

[en] Load Quality issues (QIS) - INP/78797

[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.