Name
|
Type
|
Description
|
ToolId
|
Edm.String(20)
|
Database: rtrim("BEAS_WKZ"."WKZ_ID")
|
|
ToolDescription
|
Edm.String(100)
|
Integration hub: Importable
Mandatory field
Database: "BEAS_WKZ"."BEZ"
|
|
DrawingNumber
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_WKZ"."ZNR"
|
|
Vendor
|
Edm.String(20)
|
Linked table: OCRD
Linked column: CardCode
Integration hub: Importable
Database: "BEAS_WKZ"."LIEF_ID"
|
|
Customer
|
Edm.String(20)
|
Linked table: OCRD
Linked column: CardCode
Integration hub: Importable
Database: "BEAS_WKZ"."CardCode"
|
|
PurchasePrice
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_WKZ"."KST"
|
|
Project
|
Edm.String(20)
|
Linked table: OPRJ
Linked column: PrjCode
Integration hub: Importable
Database: "BEAS_WKZ"."Project"
|
|
Status
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_WKZ"."ZUSTAND"
|
|
ToolType
|
Edm.String(1)
|
Default Value: W
Constraints:
Tool=W
Help Tool=H
Integration hub: Importable
Database: "BEAS_WKZ"."WKZTYP_ID"
|
|
WhsCode
|
Edm.String(20)
|
Linked table: OWHS
Linked column: WhsCode
Integration hub: Importable
Database: "BEAS_WKZ"."LAGO_ID"
|
|
BinCode
|
Edm.String(20)
|
Linked table: BEAS_WHSBIN
Linked column: bincode
Integration hub: Importable
Database: "BEAS_WKZ"."LPLATZ_ID"
|
|
ItemCode
|
Edm.String(20)
|
Linked table: OITM
Linked column: ItemCode
Integration hub: Importable
Database: "BEAS_WKZ"."ItemCode"
|
|
Quantity
|
Edm.DateTimeOffset
|
Integration hub: Importable
Database: "BEAS_WKZ"."MENGE"
|
|
UseFactor
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_WKZ"."NUTZEN"
|
|
Active
|
Edm.Boolean
|
Default Value: 1
Constraints:
Yes=1
No=0
Integration hub: Importable
Database: coalesce("BEAS_WKZ"."AKTIV",1)
|
|
Chooseable
|
Edm.Boolean
|
Constraints:
yes=1
no=0
Integration hub: Importable
Database: coalesce("BEAS_WKZ"."CHOOSEABLE",1)
|
|
Picture1
|
Edm.String(255)
|
Integration hub: Importable
Database: "BEAS_WKZ"."BILD1"
|
|
Picture2
|
Edm.String(255)
|
Integration hub: Importable
Database: "BEAS_WKZ"."BILD2"
|
|
Picture3
|
Edm.String(255)
|
Integration hub: Importable
Database: "BEAS_WKZ"."BILD3"
|
|
UDF1
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_WKZ"."UDF1"
|
|
UDF2
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_WKZ"."UDF2"
|
|
UDF3
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_WKZ"."UDF3"
|
|
UDF4
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_WKZ"."UDF4"
|
|