Name
|
Type
|
Description
|
RuleId
|
Edm.String(20)
|
The Group Id of the rule
Can be the ItemCode or ItemGroup Code
Mandatory field
Primary key
Database: "BEAS_OWHS_BINDEFLINE"."BinGroup"
|
|
RuleBy
|
Edm.String(1)
|
Type of Group (Item, ItemGroup)
Constraints:
I=By Item
G=By Item Group
Mandatory field
Primary key
Database: "BEAS_OWHS_BINDEFLINE"."BinType"
|
|
LineNumber
|
Edm.Int32
|
Mandatory field
Primary key
Database: "BEAS_OWHS_BINDEFLINE"."LINEID"
|
|
SortId
|
Edm.Int32
|
Mandatory field
Primary key
Database: "BEAS_OWHS_BINDEFLINE"."SortId"
|
|
Line
|
Edm.String(20)
|
Mandatory field
Primary key
Database: "BEAS_OWHS_BINDEFLINE"."RuleId"
|
|
Description
|
Edm.String(20)
|
Database: "BEAS_OWHS_BINDEFLINE"."DESCRIPTION"
|
|
Project
|
Edm.String(20)
|
Linked table: OPRJ
Database: "BEAS_OWHS_BINDEFLINE"."PrjCode"
|
|
WhsCode
|
Edm.String(20)
|
Database: "BEAS_OWHS_BINDEFLINE"."WhsCode"
|
|
DocumentType
|
Edm.String(20)
|
Rule for document type
Constraints:
Release Material (QC Transfer process)=QCGOOD
Lock Material (QC Transfer process)=QCBAD
Create new work order=WONEW
Database: "BEAS_OWHS_BINDEFLINE"."DocType"
|
|
CardCode
|
Edm.String(20)
|
Database: "BEAS_OWHS_BINDEFLINE"."CardCode"
|
|
FromWhsCode
|
Edm.String(20)
|
Database: "BEAS_OWHS_BINDEFLINE"."FromWhsCode"
|
|
ToWhsCode
|
Edm.String(20)
|
use this Warehouse Id
Linked table: OWHS
Linked column: WhsCode
Mandatory field
Database: "BEAS_OWHS_BINDEFLINE"."TOWHSCODE"
|
|
ToBinCode
|
Edm.String(20)
|
use this Bin Code
Database: "BEAS_OWHS_BINDEFLINE"."TOBINCODE"
|
|
ToProductionLine
|
Edm.String(50)
|
use this production Line
Database: "BEAS_OWHS_BINDEFLINE"."WMS_PRODLINE"
|
|
OnlyPostOut
|
Edm.Boolean
|
Linked table: OPRJ
Database: "BEAS_OWHS_BINDEFLINE"."PrjCode"
|
|
OnlyQC
|
Edm.Boolean
|
Use this rule only, if QC Order is existing for this transaction
Constraints:
Yes=1
No=0
Database: "BEAS_OWHS_BINDEFLINE"."OnlyQC"
|
|
Script
|
Edm.String(8000)
|
Database: "BEAS_OWHS_BINDEFLINE"."BinCodeScript"
|
|
Bitmap
|
Edm.String(20)
|
Database: "BEAS_OWHS_BINDEFLINE"."BITMAPNAME"
|
|
Color
|
Edm.Int32
|
Database: "BEAS_OWHS_BINDEFLINE"."COLORID"
|
|
