Skip to main content

Knowledge Center

Load Quality issues (QIS) - INP/78797

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.