DIH Item QC Cross reference

Administration > Data Integration Hub > Data integration hub > Import Definition > Definition Data Target > DIH Quality Control > DIH Item QC Cross reference

Top  Previous  Next

Description

See

Table

Quality control Item - Cross reference

Item Master > Quality control link

BEAS_QSVERWEIS

 
For detailed information on how to import see Data Integration Hub and Source-Target-Link.

 

Field

Name

M

Type

Description

NR

Number

X

int(4)


ItemCode

Item

X

nchar(50)


CardCode

Supplier


nchar(20)


TYP

Type


nchar(1)

 
Valid values: Alle=
Wareneingang=W
Fertigung=E
VK-Retoure=R
�berschreitung Haltbarkeitsdatum=C
Bestandsumlagerung=T
Manuell einbuchen=M
Eingangsrechnung=X
Einkaufretoure=Y
Eingangsgutschrift=Z
Ausgangsgutschrift=O
Lieferung=P
Ausgangsrechnung=Q
Storno=S
Manuell=U

DATE_FROM

Date From


datetime(8)

best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.

DATE_TO

Date To


datetime(8)

best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.

QUANTITY_FROM

Quantity From


numeric(4)


QUANTITY_TO

Quantity To


numeric(4)


QSAUFTRAG

QC Work Order

X

nvarchar(50)


INFO

Info


ntext(16000)


UDF1

Userfield 1


nvarchar(30)


UDF2

Userfield 2


nvarchar(30)


UDF3

Userfield 3


nvarchar(30)


UDF4

Userfield 4


nvarchar(30)


OnlyAllPoReceipt

only All Documents


int(4)


AllwaysAfterError

always by Error


int(4)


RuleId

Item Rule


nvarchar(50)


SCRIPT

Release Instruction


ntext(16000)


QcInfo

QC order Information


ntext(16000)


WhsCode

Warehouse


nvarchar(20)


Version

Version


nvarchar(20)


SORT_ID

Sorting


int(4)


BITMAP

Picture


nvarchar(50)


COLORID

Color


int(4)



Help URL: https://help.beascloud.com/beas202402/index.html?dih-item-qc-cross-reference.htm