|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Custom
|
Custom
|
Cust
|
yes/no
|
|
|
|
CustomProg
|
Custom Program
|
|
x(10)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
IntRouteCode
|
Internal Routing
|
Internal!Routing
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_IRAssD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
PartType
|
Warehouse Item Type
|
Warehouse!Item Type
|
x(8)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TrType
|
Type
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
IRADIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
TrType
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
PartType
|
yes
|
no
|
|
|
|
|
Addr
|
yes
|
no
|
|
|
oid_IRAssD
|
yes
|
oid_IRAssD
|
yes
|
no
|
|
|
Part
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AllowLotSerRef
|
Allow Lot/Ser Ref Switch
|
|
yes/no
|
|
|
|
AllowQtyDec
|
Allow Quantity Decrease
|
Qty!Dec
|
yes/no
|
|
|
|
AllowQtyInc
|
Allow Quantity Increase
|
Qty Inc
|
yes/no
|
|
|
|
AltUMOpt
|
Alternative UM Option
|
AltUM
|
>9
|
|
|
|
CheckInsp
|
Check Inspection
|
Chk Insp
|
yes/no
|
|
|
|
ClearShort
|
Clear Shortages
|
Short
|
yes/no
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateShipper
|
Create Shipper
|
Create!Shipper
|
yes/no
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ExpDate
|
Expire Date (Days)
|
Expire Date!(Days)
|
>>>9
|
|
|
|
FromLocOpt
|
From Location Option
|
From!Loc
|
>9
|
|
|
|
FromLotOpt
|
From Lot/Serial Option
|
From!Lot
|
>9
|
|
|
|
FromPartOpt
|
From Item Option
|
From!Item
|
>9
|
|
|
|
FromRefOpt
|
From Reference Option
|
From!Ref
|
>9
|
|
|
|
IntRouteCode
|
Internal Routing
|
Internal!Routing
|
x(8)
|
|
|
|
IntRouteGroup
|
Internal Routing Group
|
Internal!Routing!Group
|
x(8)
|
|
|
|
IntRouteSeq
|
Sequence
|
Seq
|
>>9
|
|
|
|
KeepFromStatus
|
Keep From Status
|
Keep!From!Status
|
yes/no
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModeM
|
Mode
|
|
X(8)
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
NewUM
|
NewUM
|
New!UM
|
x(2)
|
|
|
|
oid_IRD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
PrintException
|
Print Exceptions
|
Print!Except
|
yes/no
|
|
|
|
PrintID
|
Print ID
|
Print!ID
|
yes/no
|
|
|
|
PrintModeCl
|
Print Mode (Confirmed Tasks)
|
Print!Mode Cl
|
X(8)
|
|
|
|
PrintModeCr
|
Print Mode (Created Tasks)
|
Print!Mode Cr
|
X(8)
|
|
|
|
PrintModeEx
|
Print Mode (Exceptions)
|
Print!Mode Ex
|
X(8)
|
|
|
|
PrintModeID
|
Print Mode (ID)
|
Print!Mode ID
|
X(8)
|
|
|
|
PrintTaskCl
|
Print Confirmed Tasks
|
Print!Cl Task
|
yes/no
|
|
|
|
PrintTaskCr
|
Print Created Tasks
|
Print!Cr Task
|
yes/no
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
QtyOpt
|
Quantity Change Option
|
Qty
|
>9
|
|
|
|
RepickType
|
Repick Tran Type
|
Repick!Tran Type
|
x(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
SystemCode
|
System Code
|
Sys
|
x(2)
|
|
|
|
Task
|
Task
|
|
x(8)
|
|
|
|
ToLocOpt
|
To Location Option
|
To!Loc
|
>9
|
|
|
|
ToLotOpt
|
To Lot/Serial Option
|
To!Lot
|
>9
|
|
|
|
ToPartOpt
|
To Item Option
|
To!Item
|
>9
|
|
|
|
ToRefOpt
|
To Reference Option
|
To!Ref
|
>9
|
|
|
|
TrPriInc
|
Increment
|
|
->,>>>,>>9
|
|
|
|
TrPriority
|
Priority
|
|
->,>>>,>>9
|
|
|
|
TwoPhase
|
Two Phase
|
2Ph
|
yes/no
|
|
|
|
UseFrom
|
Confirmed at Source
|
Conf!Src
|
yes/no
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
IRDIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
IntRouteCode
|
yes
|
no
|
|
|
|
|
IntRouteSeq
|
yes
|
no
|
|
|
oid_IRD
|
yes
|
oid_IRD
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AllowInReturn
|
Allow Incoming Returns
|
InRet
|
yes/no
|
|
|
|
AllowIssue
|
Allow Issues
|
Iss
|
yes/no
|
|
|
|
AllowOutReturn
|
Allow Outgoing Returns
|
OutRet
|
yes/no
|
|
|
|
AllowReceipt
|
Allow Receipts
|
Rec
|
yes/no
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(24)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
Functional
|
Functional
|
Func
|
yes/no
|
|
|
|
IntRouteGroup
|
Internal Routing Group
|
Internal!Routing!Group
|
x(8)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
oid_IRGroupM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
IRGIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
IntRouteGroup
|
yes
|
no
|
|
|
oid_IRGroupM
|
yes
|
oid_IRGroupM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(24)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
IntRouteCode
|
Internal Routing
|
Internal!Routing
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_IRM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
IRMIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
IntRouteCode
|
yes
|
no
|
|
|
oid_IRM
|
yes
|
oid_IRM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
iro__qadc01
|
|
|
x(8)
|
|
|
|
iro_bdn_ll
|
Burden LL
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_bdn_tl
|
Burden
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_cost_set
|
Cost Set
|
|
x(8)
|
|
|
|
iro_cost_tot
|
Cost Total
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_date
|
Updated
|
|
99/99/99
|
|
|
|
iro_domain
|
Domain
|
|
x(8)
|
|
|
|
iro_lbr_ll
|
Labor LL
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_lbr_tl
|
Labor
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_mtl_ll
|
Material LL
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_mtl_tl
|
Material
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_nrv
|
Net Realized Value
|
NR!Value
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
iro_op
|
Operation
|
Op
|
>>>>9
|
|
|
|
iro_ovh_ll
|
Overhead LL
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_ovh_tl
|
Overhead
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_part
|
Item Number
|
|
x(18)
|
|
|
|
iro_routing
|
Routing Code
|
|
x(18)
|
|
|
|
iro_site
|
Site
|
|
x(8)
|
|
|
|
iro_sub_ll
|
Subcontract LL
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_sub_tl
|
Subcontract
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_user1
|
Ufld1
|
|
x(8)
|
|
|
|
iro_user2
|
Ufld2
|
|
x(8)
|
|
|
|
iro_value01
|
Value 01
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_value02
|
Value 02
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_value03
|
Value 03
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_value04
|
Value 04
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
iro_value05
|
Value 05
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
oid_iro_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
iro_det
|
yes
|
iro_domain
|
yes
|
no
|
|
|
|
|
iro_part
|
yes
|
no
|
|
|
|
|
iro_site
|
yes
|
no
|
|
|
|
|
iro_cost_set
|
yes
|
no
|
|
|
|
|
iro_routing
|
yes
|
no
|
|
|
|
|
iro_op
|
yes
|
no
|
|
|
oid_iro_det
|
yes
|
oid_iro_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
isb__chr01
|
|
|
x(8)
|
|
|
|
isb__chr02
|
|
|
x(8)
|
|
|
|
isb__chr03
|
|
|
x(8)
|
|
|
|
isb__chr04
|
|
|
x(8)
|
|
|
|
isb__chr05
|
|
|
x(8)
|
|
|
|
isb__chr06
|
|
|
x(8)
|
|
|
|
isb__chr07
|
|
|
x(8)
|
|
|
|
isb__chr08
|
|
|
x(8)
|
|
|
|
isb__chr09
|
|
|
x(8)
|
|
|
|
isb__chr10
|
|
|
x(8)
|
|
|
|
isb__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
isb__dec02
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
isb__dec03
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
isb__dte01
|
|
|
99/99/99
|
|
|
|
isb__dte02
|
|
|
99/99/99
|
|
|
|
isb__dte03
|
|
|
99/99/99
|
|
|
|
isb__dte04
|
|
|
99/99/99
|
|
|
|
isb__log01
|
|
|
yes/no
|
|
|
|
isb__log02
|
|
|
yes/no
|
|
|
|
isb__log03
|
|
|
yes/no
|
|
|
|
isb__log04
|
|
|
yes/no
|
|
|
|
isb__log05
|
|
|
yes/no
|
|
|
|
isb__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
isb__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
isb__qadc03
|
QAD Character Field 3
|
|
X(8)
|
|
|
|
isb__qadc04
|
QAD Character Field 4
|
|
x(8)
|
0
|
|
|
isb__qade01
|
QAD Decimal Field 1
|
|
->>>,>>>,>>9.99
|
10
|
|
|
isb__qade02
|
QAD Decimal Field 2
|
|
->>>,>>>,>>9.99
|
10
|
|
|
isb__qade03
|
QAD Decimal Field 3
|
|
->>>,>>>,>>9.99
|
10
|
|
|
isb__qadi01
|
QAD Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
isb__qadi02
|
QAD Integer Field 2
|
|
->,>>>,>>9
|
|
|
|
isb__qadi03
|
QAD Field
|
|
>>>>>9
|
|
|
|
isb__qadi04
|
QAD Integer Field 4
|
|
>>>>9
|
|
|
|
isb__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
isb__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
isb__qadl03
|
QAD Logical Field 3
|
|
yes/no
|
|
|
|
isb__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
isb__qadt02
|
QAD Date Field 2
|
|
99/99/99
|
|
|
|
isb__qadt03
|
QAD Date Field 3
|
|
99/99/99
|
|
|
|
isb_article
|
Article Number
|
|
x(18)
|
|
|
|
isb_calib_date
|
Calibration Date
|
|
99/99/99
|
|
|
|
isb_calibration
|
Calibration
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
isb_classification
|
Classification
|
|
x(12)
|
|
|
|
isb_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
isb_comp
|
Component
|
Comp
|
yes/no
|
|
|
|
isb_customer_id
|
Customer Id
|
|
x(18)
|
|
|
|
isb_desc1
|
Description
|
|
x(24)
|
|
|
|
isb_desc2
|
Description
|
|
x(24)
|
|
|
|
isb_domain
|
Domain
|
|
x(8)
|
|
|
|
isb_eco
|
ECO
|
|
x(8)
|
|
|
|
isb_eng_code
|
Engineer
|
|
x(8)
|
|
|
|
isb_eu_nbr
|
End User
|
|
x(8)
|
|
|
|
isb_eud_trnbr
|
End User ID
|
|
>>>>>>>>>9
|
|
|
|
isb_ic_ref
|
Inventory Ref
|
|
x(18)
|
|
|
|
isb_ins_date
|
Install Date
|
Install
|
99/99/99
|
|
|
|
isb_inv_nbr
|
Invoice
|
|
x(22)
|
|
|
|
isb_last_pm
|
Last PM date
|
Last PM
|
99/99/99
|
|
|
|
isb_lb_warr_exp
|
Labor Warranty Exp
|
Lbr Exp
|
99/99/99
|
|
|
|
isb_location
|
Location
|
|
x(24)
|
|
|
|
isb_lst_upd
|
Last Updated
|
|
99/99/99
|
|
|
|
isb_meter_date
|
Meter Reading Date
|
|
99/99/99
|
|
|
|
isb_meter_interval
|
Meter Reading Interval
|
Interval
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
isb_meter_rdg
|
Latest Meter Reading
|
Meter
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
isb_meter_um
|
Meter Reading Units
|
|
X(2)
|
|
|
|
isb_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
isb_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
isb_model
|
Model
|
|
x(18)
|
|
|
|
isb_next_pm
|
Next PM Date
|
Next PM
|
99/99/99
|
|
|
|
isb_orig_ins
|
Original Install
|
|
99/99/99
|
|
|
|
isb_origin
|
Country of Origin
|
|
x(12)
|
|
|
|
isb_owner
|
Ownership
|
|
x(8)
|
|
|
|
isb_parent
|
Parent
|
|
yes/no
|
|
|
|
isb_part
|
Item Number
|
Item
|
x(18)
|
|
|
|
isb_plant_maint
|
Internal Plant Maint
|
|
yes/no
|
|
|
|
isb_pm_days
|
PM days
|
|
>>>>>9
|
|
|
|
isb_pm_um
|
UM
|
|
x(2)
|
|
|
|
isb_price_sold
|
Price Sold
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
isb_qty
|
Qty
|
|
>,>>>,>>>,>>9.9<<
|
10
|
|
|
isb_rebuild
|
Rebuild ISB
|
|
yes/no
|
|
|
|
isb_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
isb_rev
|
Rev Level
|
Rev
|
x(10)
|
|
|
|
isb_seq
|
Seq
|
|
>>>>>>>9
|
|
|
|
isb_serial
|
Serial
|
|
x(18)
|
|
|
|
isb_ship_date
|
Ship Date
|
|
99/99/99
|
|
|
|
isb_so_line
|
Sales Order Line
|
SO Line
|
>>>>9
|
|
|
|
isb_so_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
isb_sold_to
|
Sold to
|
|
x(8)
|
|
|
|
isb_status
|
Status
|
|
x(8)
|
|
|
|
isb_sys_type
|
Item Type
|
|
x(2)
|
|
|
|
isb_tarrif
|
Tariff
|
|
x(8)
|
|
|
|
isb_updates
|
Updates
|
|
x(8)
|
|
|
|
isb_user1
|
Ufld1
|
|
x(8)
|
|
|
|
isb_user2
|
Ufld2
|
|
x(8)
|
|
|
|
isb_warr_cd
|
Warranty Code
|
Warr Cd
|
x(8)
|
|
|
|
isb_warr_dur
|
Warranty Duration
|
War Dur
|
>>>>>9
|
|
|
|
isb_warr_exp
|
Warranty Expiration
|
Warr Exp
|
99/99/99
|
|
|
|
isb_warr_override
|
Warranty Override
|
|
yes/no
|
|
|
|
oid_isb_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
isb_classification
|
no
|
isb_domain
|
yes
|
no
|
|
|
|
|
isb_classification
|
yes
|
no
|
|
|
|
|
isb_part
|
yes
|
no
|
|
|
isb_eu_ser
|
no
|
isb_domain
|
yes
|
no
|
|
|
|
|
isb_eu_nbr
|
yes
|
no
|
|
|
|
|
isb_serial
|
yes
|
no
|
|
|
|
|
isb_part
|
yes
|
no
|
|
∗
|
isb_eupartsr
|
yes
|
isb_domain
|
yes
|
no
|
|
|
|
|
isb_eu_nbr
|
yes
|
no
|
|
|
|
|
isb_part
|
yes
|
no
|
|
|
|
|
isb_serial
|
yes
|
no
|
|
|
|
|
isb_ref
|
yes
|
no
|
|
|
isb_model
|
no
|
isb_domain
|
yes
|
no
|
|
|
|
|
isb_eu_nbr
|
yes
|
no
|
|
|
|
|
isb_model
|
yes
|
no
|
|
|
|
|
isb_serial
|
yes
|
no
|
|
|
|
|
isb_ref
|
yes
|
no
|
|
|
isb_part_ser
|
yes
|
isb_domain
|
yes
|
no
|
|
|
|
|
isb_part
|
yes
|
no
|
|
|
|
|
isb_serial
|
yes
|
no
|
|
|
|
|
isb_ref
|
yes
|
no
|
|
|
isb_serial
|
no
|
isb_domain
|
yes
|
no
|
|
|
|
|
isb_serial
|
yes
|
no
|
|
|
|
|
isb_ref
|
yes
|
no
|
|
|
isb_sys_bld
|
no
|
isb_domain
|
yes
|
no
|
|
|
|
|
isb_eu_nbr
|
yes
|
no
|
|
|
|
|
isb_rebuild
|
yes
|
no
|
|
|
|
|
isb_sys_type
|
yes
|
no
|
|
|
oid_isb_mstr
|
yes
|
oid_isb_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
isd__qadc01
|
|
|
x(8)
|
|
|
|
isd_bdl_allowed
|
CIM Allowed
|
CIM!Allowed
|
yes/no
|
|
|
|
isd_domain
|
Domain
|
|
x(8)
|
|
|
|
isd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
isd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
isd_status
|
Status
|
|
x(8)
|
|
|
|
isd_tr_type
|
Restricted Trans
|
|
x(8)
|
|
|
|
isd_type
|
Type
|
|
x(8)
|
|
|
|
isd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
isd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_isd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
isd_status
|
yes
|
isd_domain
|
yes
|
no
|
|
|
|
|
isd_status
|
yes
|
no
|
|
|
|
|
isd_tr_type
|
yes
|
no
|
|
|
|
|
isd_type
|
yes
|
no
|
|
|
oid_isd_det
|
yes
|
oid_isd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
iss__chr01
|
|
|
x(8)
|
|
|
|
iss__chr02
|
|
|
x(8)
|
|
|
|
iss__chr03
|
|
|
x(8)
|
|
|
|
iss__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
iss__dec02
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
iss__dte01
|
|
|
99/99/99
|
|
|
|
iss__dte02
|
|
|
99/99/99
|
|
|
|
iss__log01
|
|
|
yes/no
|
|
|
|
iss__log02
|
|
|
yes/no
|
|
|
|
iss_comp
|
Component Item
|
Comp Item
|
x(18)
|
|
|
|
iss_comp_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
iss_comp_ser
|
Component Serial
|
Comp Serial
|
x(18)
|
|
|
|
iss_domain
|
Domain
|
|
x(8)
|
|
|
|
iss_eu_nbr
|
End User No
|
End User
|
x(8)
|
|
|
|
iss_par
|
Parent Item
|
Parent
|
x(18)
|
|
|
|
iss_par_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
iss_par_ser
|
Parent Serial
|
Par Serial
|
x(18)
|
|
|
|
iss_user1
|
Ufld1
|
|
x(8)
|
|
|
|
iss_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_iss_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
iss_comp
|
no
|
iss_domain
|
yes
|
no
|
|
|
|
|
iss_comp
|
yes
|
no
|
|
|
iss_compref
|
yes
|
iss_domain
|
yes
|
no
|
|
|
|
|
iss_eu_nbr
|
yes
|
no
|
|
|
|
|
iss_comp
|
yes
|
no
|
|
|
|
|
iss_comp_ser
|
yes
|
no
|
|
|
|
|
iss_comp_ref
|
yes
|
no
|
|
|
iss_par
|
no
|
iss_domain
|
yes
|
no
|
|
|
|
|
iss_par
|
yes
|
no
|
|
∗
|
iss_par_comp
|
yes
|
iss_domain
|
yes
|
no
|
|
|
|
|
iss_eu_nbr
|
yes
|
no
|
|
|
|
|
iss_par
|
yes
|
no
|
|
|
|
|
iss_par_ser
|
yes
|
no
|
|
|
|
|
iss_par_ref
|
yes
|
no
|
|
|
|
|
iss_comp
|
yes
|
no
|
|
|
|
|
iss_comp_ser
|
yes
|
no
|
|
|
|
|
iss_comp_ref
|
yes
|
no
|
|
|
oid_iss_mstr
|
yes
|
oid_iss_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
isvc__qadc01
|
|
|
x(24)
|
|
|
|
isvc__qadc02
|
|
|
x(24)
|
|
|
|
isvc_ctry_dest
|
Country Of Destination
|
|
x(3)
|
|
|
|
isvc_ctry_orig
|
Country Of Origin
|
|
x(3)
|
|
|
|
isvc_domain
|
Domain
|
|
x(8)
|
|
|
|
isvc_flow
|
Flow Indicator
|
|
x(2)
|
|
|
|
isvc_min_value
|
Minimum Value
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
isvc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
isvc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
isvc_mode_transp
|
Mode Of Transport
|
|
x(1)
|
|
|
|
isvc_per_unit
|
Added Value Per Unit
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
isvc_per_weight
|
Added Value Per Weight
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
isvc_percentage
|
Percentage
|
|
->>9.9<%
|
10
|
|
|
isvc_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
isvc_terms_delivery
|
Terms Of Delivery
|
|
x(4)
|
|
|
|
isvc_um
|
UM
|
|
x(2)
|
|
|
|
isvc_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
isvc_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_isvc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
isvc_delivery
|
yes
|
isvc_domain
|
yes
|
no
|
|
|
|
|
isvc_terms_delivery
|
yes
|
no
|
|
|
|
|
isvc_mode_transp
|
yes
|
no
|
|
|
|
|
isvc_shipvia
|
yes
|
no
|
|
|
|
|
isvc_flow
|
yes
|
no
|
|
|
|
|
isvc_ctry_orig
|
yes
|
no
|
|
|
|
|
isvc_ctry_dest
|
yes
|
no
|
|
|
oid_isvc_mstr
|
yes
|
oid_isvc_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
is__qadc01
|
|
|
x(8)
|
|
|
|
is_avail
|
Available
|
Avail
|
yes/no
|
|
|
|
is_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
is_desc
|
Description
|
|
x(24)
|
|
|
|
is_domain
|
Domain
|
|
x(8)
|
|
|
|
is_fail_status
|
Fail Status
|
Fail
|
X(8)
|
|
|
|
is_frozen
|
Frozen
|
|
yes/no
|
|
|
|
is_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
is_nettable
|
Nettable
|
Net
|
yes/no
|
|
|
|
is_overissue
|
Overissue
|
OvrIs
|
yes/no
|
|
|
|
is_status
|
Status Code
|
Status
|
x(8)
|
|
|
|
is_user1
|
Ufld1
|
|
x(8)
|
|
|
|
is_user2
|
Ufld2
|
|
x(8)
|
|
|
|
is_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_is_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
is_avail
|
yes
|
is_domain
|
yes
|
no
|
|
|
|
|
is_status
|
yes
|
no
|
|
|
|
|
is_avail
|
yes
|
no
|
|
∗
|
is_status
|
yes
|
is_domain
|
yes
|
no
|
|
|
|
|
is_status
|
yes
|
no
|
|
|
|
|
is_nettable
|
yes
|
no
|
|
|
is_status_unique
|
yes
|
is_domain
|
yes
|
no
|
|
|
|
|
is_status
|
yes
|
no
|
|
|
oid_is_mstr
|
yes
|
oid_is_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
itmh__chr01
|
User Field #1
|
|
x(8)
|
|
|
|
itmh__chr02
|
User Field #2
|
|
x(8)
|
|
|
|
itmh__chr03
|
User Field #3
|
|
x(8)
|
|
|
|
itmh__chr04
|
User Field #4
|
|
x(8)
|
|
|
|
itmh__dec01
|
User Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itmh__dec02
|
User Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itmh__dec03
|
User Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itmh__dte01
|
User Date #1
|
|
99/99/99
|
|
|
|
itmh__dte02
|
User Date #2
|
|
99/99/99
|
|
|
|
itmh__dte03
|
User Date #3
|
|
99/99/99
|
|
|
|
itmh__log01
|
User Logical #1
|
|
yes/no
|
|
|
|
itmh__log02
|
User Logical #2
|
|
yes/no
|
|
|
|
itmh__log03
|
User Logical #3
|
|
yes/no
|
|
|
|
itmh__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
itmh__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
itmh__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
itmh__qadc04
|
Qad Field #4
|
|
x(8)
|
0
|
|
|
itmh__qadc05
|
|
|
x(8)
|
|
|
|
itmh__qadc06
|
|
|
x(8)
|
|
|
|
itmh__qadd01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itmh__qadd02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itmh__qadd03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itmh__qadl01
|
QAD Logical Field
|
|
yes/no
|
|
|
|
itmh__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
itmh__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
itmh__qadt01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
itmh__qadt02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
itmh__qadt03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
itmh_acct
|
Sales Acct
|
Sales
|
x(8)
|
|
|
|
itmh_bill_detail
|
Bill Detail
|
Det
|
yes/no
|
|
|
|
itmh_bom_code
|
BOM code
|
|
x(18)
|
|
|
|
itmh_bom_gen
|
|
|
yes/no
|
|
|
|
itmh_ca_int_type
|
Work Code
|
|
x(8)
|
|
|
|
itmh_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
itmh_cmtindx
|
Comment Index
|
Cmt Index
|
->,>>>,>>9
|
|
|
|
itmh_comp_date
|
Date Complete
|
|
99/99/99
|
|
|
|
itmh_desc
|
Description
|
|
x(24)
|
|
|
|
itmh_domain
|
Domain
|
|
x(8)
|
|
|
|
itmh_dsc_acct
|
Disc Acct
|
|
x(8)
|
|
|
|
itmh_dsc_cc
|
Disc CC
|
CC
|
x(4)
|
|
|
|
itmh_dsc_project
|
Disc Project
|
|
x(8)
|
|
|
|
itmh_dsc_sub
|
Disc Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
itmh_due_date
|
Due Date
|
|
99/99/99
|
|
|
|
itmh_endown_date
|
End Down
|
|
99/99/99
|
|
|
|
itmh_endown_time
|
Time
|
|
99:99
|
|
|
|
itmh_eng_code
|
Engineer
|
|
x(8)
|
|
|
|
itmh_est_time
|
Estimated Time
|
Est Time
|
999:99
|
|
|
|
itmh_eu_nbr
|
End User
|
|
X(8)
|
0
|
|
|
itmh_exp_rec
|
Date Expected
|
|
99/99/99
|
|
|
|
itmh_fix_pr
|
Fixed Price
|
Fix
|
yes/no
|
|
|
|
itmh_fixed_price
|
Fixed Price
|
|
->>>,>>>,>>9.99
|
10
|
|
|
itmh_invoiced
|
Invoiced
|
|
yes/no
|
|
|
|
itmh_itm_line
|
Sub Line Number
|
|
>>9
|
|
|
|
itmh_line
|
Line
|
|
>>9
|
|
|
|
itmh_loc
|
Location
|
|
X(8)
|
|
|
|
itmh_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
itmh_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
itmh_model
|
Model
|
|
x(18)
|
|
|
|
itmh_nbr
|
Call/SR
|
|
x(8)
|
|
|
|
itmh_nxt_act
|
Next Status
|
|
x(8)
|
|
|
|
itmh_nxt_date
|
Next Status Date
|
|
99/99/99
|
|
|
|
itmh_nxt_time
|
Next Status Time
|
|
99:99
|
|
|
|
itmh_opn_date
|
|
|
99/99/99
|
|
|
|
itmh_override_lmt
|
Override Limits
|
|
yes/no
|
|
|
|
itmh_part
|
Item
|
|
x(18)
|
|
|
|
itmh_pr_list
|
Price List
|
|
X(8)
|
|
|
|
itmh_prefix
|
Detail Type
|
Type
|
x(3)
|
|
|
|
itmh_prod_line
|
Product Line
|
|
X(4)
|
|
|
|
itmh_project
|
Project
|
|
x(8)
|
|
|
|
itmh_pst
|
PST Taxable
|
|
yes/no
|
|
|
|
itmh_qty_call
|
Qty
|
|
>,>>>9
|
10
|
|
|
itmh_qty_chg
|
To Receive
|
|
->>,>>9.99
|
10
|
|
|
itmh_qty_rc_rec
|
Qty Rec from Repair Center
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
itmh_qty_rc_ship
|
Qty Shipped to Repair Center
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
itmh_qty_rec
|
Qty Received
|
|
->,>>9
|
10
|
|
|
itmh_qty_ship
|
Shipped
|
|
->,>>>9
|
10
|
|
|
itmh_rec_date
|
Received Date
|
|
99/99/99
|
|
|
|
itmh_recorded
|
Has Been thru CAR
|
|
yes/no
|
|
|
|
itmh_ref
|
Ref
|
|
>>>>>>9
|
|
|
|
itmh_rev
|
Revision
|
|
x(10)
|
|
|
|
itmh_route
|
Repair Route
|
|
x(18)
|
|
|
|
itmh_route_gen
|
|
|
yes/no
|
|
|
|
itmh_rrc_nbr
|
Repair Steps
|
|
X(8)
|
|
|
|
itmh_rrc_seq
|
Sequence
|
Seq
|
>>9
|
|
|
|
itmh_sa_nbr
|
Contract
|
|
x(8)
|
|
|
|
itmh_sa_sv
|
Contract Svc Type
|
|
x(8)
|
|
|
|
itmh_sad_line
|
Contract Line
|
|
>>>>>>>9
|
|
|
|
itmh_sep_doc
|
Separate Document
|
|
yes/no
|
|
|
|
itmh_serial
|
Serial
|
|
x(18)
|
|
|
|
itmh_ship_date
|
Date Shipped
|
|
99/99/99
|
|
|
|
itmh_site
|
Site
|
|
X(8)
|
0
|
|
|
itmh_status
|
Status
|
|
x(8)
|
|
|
|
itmh_stdown_date
|
Start Down
|
|
99/99/99
|
|
|
|
itmh_stdown_time
|
Time
|
|
99:99
|
|
|
|
itmh_stjob_date
|
Job Start
|
|
99/99/99
|
|
|
|
itmh_stjob_time
|
Time
|
|
99:99
|
|
|
|
itmh_sub
|
Sales Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
itmh_sv_code
|
Contract Type
|
|
x(8)
|
|
|
|
itmh_svc_type
|
|
|
x(1)
|
|
|
|
itmh_tag
|
Tag
|
|
X(1)
|
|
|
|
itmh_tax_env
|
Tax Environment
|
|
X(16)
|
|
|
|
itmh_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
itmh_tax_usage
|
|
|
x(8)
|
|
|
|
itmh_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
itmh_taxc
|
|
|
x(3)
|
|
|
|
itmh_type
|
Type
|
|
x(8)
|
|
|
|
itmh_uninvoiced
|
Uninvoiced
|
|
yes/no
|
|
|
|
itmh_unprocessed
|
|
|
yes/no
|
|
|
|
itmh_upd_isb
|
Update ISB
|
ISB
|
yes/no
|
|
|
|
itmh_user1
|
Ufld1
|
|
x(8)
|
|
|
|
itmh_user2
|
Ufld2
|
|
x(8)
|
|
|
|
itmh_warr_sv
|
Warranty Svc Type
|
|
x(8)
|
|
|
|
oid_itmh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
itmh_nbr
|
yes
|
itmh_domain
|
yes
|
no
|
|
|
|
|
itmh_nbr
|
yes
|
no
|
|
|
|
|
itmh_prefix
|
yes
|
no
|
|
|
|
|
itmh_type
|
yes
|
no
|
|
|
|
|
itmh_itm_line
|
yes
|
no
|
|
|
|
|
itmh_line
|
yes
|
no
|
|
|
itmh_part
|
no
|
itmh_domain
|
yes
|
no
|
|
|
|
|
itmh_part
|
yes
|
no
|
|
|
|
|
itmh_prefix
|
yes
|
no
|
|
|
|
|
itmh_serial
|
yes
|
no
|
|
|
itmh_sa_nbr
|
no
|
itmh_domain
|
yes
|
no
|
|
|
|
|
itmh_sa_nbr
|
yes
|
no
|
|
|
|
|
itmh_sad_line
|
yes
|
no
|
|
|
|
|
itmh_nbr
|
yes
|
no
|
|
|
|
|
itmh_line
|
yes
|
no
|
|
|
itmh_serial
|
no
|
itmh_domain
|
yes
|
no
|
|
|
|
|
itmh_serial
|
yes
|
no
|
|
|
|
|
itmh_prefix
|
yes
|
no
|
|
|
|
|
itmh_opn_date
|
yes
|
no
|
|
|
oid_itmh_hist
|
yes
|
oid_itmh_hist
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
itm__chr01
|
User Field #1
|
|
x(8)
|
|
|
|
itm__chr02
|
User Field #2
|
|
x(8)
|
|
|
|
itm__chr03
|
User Field #3
|
|
x(8)
|
|
|
|
itm__chr04
|
User Field #4
|
|
x(8)
|
|
|
|
itm__dec01
|
User Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__dec02
|
User Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__dec03
|
User Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__dte01
|
User Date #1
|
|
99/99/99
|
|
|
|
itm__dte02
|
User Date #2
|
|
99/99/99
|
|
|
|
itm__dte03
|
User Date #3
|
|
99/99/99
|
|
|
|
itm__log01
|
User Logical #1
|
|
yes/no
|
|
|
|
itm__log02
|
User Logical #2
|
|
yes/no
|
|
|
|
itm__log03
|
User Logical #3
|
|
yes/no
|
|
|
|
itm__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
itm__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
itm__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
itm__qadc04
|
Qad Field #4
|
|
x(8)
|
|
|
|
itm__qadc05
|
|
|
x(8)
|
|
|
|
itm__qadc06
|
|
|
x(8)
|
|
|
|
itm__qadd01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
itm__qadd02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
itm__qadd03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
itm__qadde01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__qadde02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__qadde03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
itm__qadl01
|
QAD Logical Field
|
|
yes/no
|
|
|
|
itm__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
itm__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
itm_acct
|
Sales Acct
|
Sales
|
x(8)
|
|
|
|
itm_alternate
|
Alternate Item
|
|
x(18)
|
|
|
|
itm_bill_detail
|
Bill Detail
|
Det
|
yes/no
|
|
|
|
itm_bom_code
|
BOM Code
|
|
x(18)
|
|
|
|
itm_bom_gen
|
|
|
yes/no
|
|
|
|
itm_ca_int_type
|
Work Code
|
WK Code
|
x(8)
|
|
|
|
itm_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
itm_cmtindx
|
Comment Index
|
Cmt Index
|
->,>>>,>>9
|
|
|
|
itm_comp_date
|
Date Complete
|
|
99/99/99
|
|
|
|
itm_desc
|
Description
|
|
x(24)
|
|
|
|
itm_domain
|
Domain
|
|
x(8)
|
|
|
|
itm_dsc_acct
|
Disc Acct
|
|
x(8)
|
|
|
|
itm_dsc_cc
|
Disc CC
|
CC
|
x(4)
|
|
|
|
itm_dsc_project
|
Disc Project
|
|
x(8)
|
|
|
|
itm_dsc_sub
|
Disc Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
itm_due_date
|
Due Date
|
|
99/99/99
|
|
|
|
itm_endown_date
|
End Down
|
|
99/99/99
|
|
|
|
itm_endown_time
|
Time
|
|
99:99
|
|
|
|
itm_eng_code
|
Engineer
|
|
x(8)
|
|
|
|
itm_est_cost
|
Estimated Cost
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
itm_est_time
|
Estimated Time
|
Est Time
|
999:99
|
|
|
|
itm_eu_nbr
|
End User
|
|
X(8)
|
0
|
|
|
itm_exp_rec
|
Date Expected
|
|
99/99/99
|
|
|
|
itm_fix_pr
|
Fixed Price
|
Fix
|
yes/no
|
|
|
|
itm_fixed_price
|
Fixed Price
|
|
->>>,>>>,>>9.99
|
10
|
|
|
itm_invoiced
|
Invoiced
|
|
yes/no
|
|
|
|
itm_itm_line
|
|
|
>>9
|
|
|
|
itm_line
|
Line
|
|
>>9
|
|
|
|
itm_loc
|
Location
|
|
x(8)
|
|
|
|
itm_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
itm_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
itm_model
|
Model
|
|
x(18)
|
|
|
|
itm_nbr
|
Call/SR
|
|
x(8)
|
|
|
|
itm_nxt_act
|
Next Status
|
|
x(8)
|
|
|
|
itm_nxt_date
|
Next Status Date
|
|
99/99/99
|
|
|
|
itm_nxt_time
|
Next Status Time
|
|
99:99
|
|
|
|
itm_override_lmt
|
Override Limits
|
Lmt
|
yes/no
|
|
|
|
itm_part
|
Item
|
|
x(18)
|
|
|
|
itm_pr_list
|
Price List
|
|
X(8)
|
|
|
|
itm_prefix
|
Detail Type
|
Type
|
x(3)
|
|
|
|
itm_prod_line
|
WIP Product Line
|
Line
|
X(4)
|
0
|
|
|
itm_project
|
Project
|
|
x(8)
|
|
|
|
itm_pst
|
PST Taxable
|
|
yes/no
|
|
|
|
itm_qty_call
|
Quantity
|
Call Qty
|
->,>>>,>>9.99
|
10
|
|
|
itm_qty_chg
|
To Receive
|
To Recv
|
->>,>>9
|
10
|
|
|
itm_qty_rc_rec
|
Qty Rec from Repair Center
|
Recv
|
->>,>>9
|
10
|
|
|
itm_qty_rc_ship
|
Qty Shipped to Repair Center
|
Shipped
|
->>,>>9
|
10
|
|
|
itm_qty_rec
|
Qty Received
|
Recv
|
->>,>>9
|
10
|
|
|
itm_qty_ship
|
Shipped
|
|
->,>>>9
|
10
|
|
|
itm_rec_date
|
Received Date
|
|
99/99/99
|
|
|
|
itm_recorded
|
|
|
yes/no
|
|
|
|
itm_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
itm_repair_type
|
Item Repair Type
|
|
x(11)
|
|
|
|
itm_replace_line
|
Replace For Line
|
|
>>9
|
|
|
|
itm_rev
|
Revision
|
|
x(10)
|
|
|
|
itm_route
|
Routing
|
|
x(18)
|
|
|
|
itm_route_gen
|
|
|
yes/no
|
|
|
|
itm_rrc_nbr
|
Repair Sequence
|
|
x(8)
|
|
|
|
itm_rrc_seq
|
Sequence
|
Seq
|
>>9
|
|
|
|
itm_sa_nbr
|
Contract
|
|
x(8)
|
0
|
|
|
itm_sa_sv
|
Contract Svc Type
|
|
x(8)
|
|
|
|
itm_sad_line
|
Contract Line
|
|
>>>>>>>9
|
|
|
|
itm_sep_doc
|
Separate Document
|
|
yes/no
|
|
|
|
itm_serial
|
Serial
|
|
x(18)
|
|
|
|
itm_ship_date
|
Date Shipped
|
|
99/99/99
|
|
|
|
itm_site
|
Site
|
|
x(8)
|
|
|
|
itm_sod_line
|
Material Order Line
|
|
>>9
|
|
|
|
itm_sod_nbr
|
Material Order
|
|
x(8)
|
|
|
|
itm_status
|
Status
|
|
x(8)
|
|
|
|
itm_stdown_date
|
Start Down
|
|
99/99/99
|
|
|
|
itm_stdown_time
|
Time
|
|
99:99
|
|
|
|
itm_stjob_date
|
Job Start
|
|
99/99/99
|
|
|
|
itm_stjob_time
|
Time
|
|
99:99
|
|
|
|
itm_sub
|
Sales Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
itm_sv_code
|
Service Type Used
|
Servc Tp
|
x(8)
|
|
|
|
itm_svc_type
|
|
|
x(1)
|
|
|
|
itm_tag
|
|
|
x(1)
|
|
|
|
itm_tax_env
|
Tax Environment
|
Tax Env
|
X(16)
|
|
|
|
itm_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
itm_tax_usage
|
Tax Usage
|
|
x(8)
|
0
|
|
|
itm_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
itm_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
itm_type
|
Type
|
|
x(8)
|
0
|
|
|
itm_uninvoiced
|
Uninvoiced
|
|
yes/no
|
|
|
|
itm_unprocessed
|
|
|
yes/no
|
|
|
|
itm_upd_isb
|
Update Installed Base
|
|
yes/no
|
|
|
|
itm_user1
|
Ufld1
|
|
x(8)
|
|
|
|
itm_user2
|
Ufld2
|
|
x(8)
|
|
|
|
itm_warr_sv
|
Warranty Svc Type
|
|
x(8)
|
|
|
|
oid_itm_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
itm_eng_code
|
no
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_eng_code
|
yes
|
no
|
|
|
|
|
itm_nxt_date
|
yes
|
no
|
|
|
|
|
itm_nxt_time
|
yes
|
no
|
|
|
itm_eu_nbr
|
no
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_type
|
yes
|
no
|
|
|
|
|
itm_eu_nbr
|
yes
|
no
|
|
|
|
|
itm_serial
|
yes
|
no
|
|
∗
|
itm_nbr
|
yes
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_nbr
|
yes
|
no
|
|
|
|
|
itm_prefix
|
yes
|
no
|
|
|
|
|
itm_type
|
yes
|
no
|
|
|
|
|
itm_itm_line
|
yes
|
no
|
|
|
|
|
itm_line
|
yes
|
no
|
|
|
itm_part
|
no
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_part
|
yes
|
no
|
|
|
|
|
itm_prefix
|
yes
|
no
|
|
|
|
|
itm_type
|
yes
|
no
|
|
|
|
|
itm_nbr
|
yes
|
no
|
|
|
itm_sa_nbr
|
no
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_sa_nbr
|
yes
|
no
|
|
|
|
|
itm_sad_line
|
yes
|
no
|
|
|
|
|
itm_prefix
|
yes
|
no
|
|
|
|
|
itm_type
|
yes
|
no
|
|
|
|
|
itm_nbr
|
yes
|
no
|
|
|
|
|
itm_line
|
yes
|
no
|
|
|
itm_serial
|
no
|
itm_domain
|
yes
|
no
|
|
|
|
|
itm_prefix
|
yes
|
no
|
|
|
|
|
itm_type
|
yes
|
no
|
|
|
|
|
itm_serial
|
yes
|
no
|
|
|
|
|
itm_nbr
|
yes
|
no
|
|
|
|
|
itm_line
|
yes
|
no
|
|
|
oid_itm_det
|
yes
|
oid_itm_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
itsd__qadc01
|
|
|
x(8)
|
|
|
|
itsd_date
|
Effective
|
|
99/99/99
|
|
|
|
itsd_domain
|
Domain
|
|
x(8)
|
|
|
|
itsd_loaded
|
Loaded
|
|
yes/no
|
|
|
|
itsd_part
|
Item Number
|
|
x(18)
|
|
|
|
itsd_qty
|
Quantity
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
itsd_ref
|
Reference
|
|
x(18)
|
|
|
|
itsd_site
|
Site
|
|
x(8)
|
|
|
|
itsd_type
|
Data Type
|
Type
|
x(1)
|
|
|
|
itsd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
itsd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_itsd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
itsd_det
|
yes
|
itsd_domain
|
yes
|
no
|
|
|
|
|
itsd_part
|
yes
|
no
|
|
|
|
|
itsd_site
|
yes
|
no
|
|
|
|
|
itsd_date
|
yes
|
no
|
|
|
|
|
itsd_type
|
yes
|
no
|
|
|
oid_itsd_det
|
yes
|
oid_itsd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
its__dec01
|
|
|
->,>>>,>>>9.99<<<<
|
10
|
|
|
its__dec02
|
|
|
->,>>>,>>9.99<<<
|
10
|
|
|
its__dec03
|
|
|
->,>>>,>>9.99<<<
|
10
|
|
|
its_date
|
Created Date
|
|
99/99/99
|
|
|
|
its_domain
|
Domain
|
|
x(8)
|
|
|
|
its_part
|
Item Number
|
|
x(18)
|
|
|
|
its_qty_oh
|
Quantity On Hand
|
QOH
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
its_site
|
Site
|
|
x(8)
|
|
|
|
its_target
|
Weeks Cover
|
|
>>>>
|
|
|
|
its_user1
|
Ufld1
|
|
x(8)
|
|
|
|
its_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_its_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
its_mstr
|
yes
|
its_domain
|
yes
|
no
|
|
|
|
|
its_part
|
yes
|
no
|
|
|
|
|
its_site
|
yes
|
no
|
|
|
oid_its_mstr
|
yes
|
oid_its_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ivs__qadc01
|
|
|
x(24)
|
|
|
|
ivs__qadd01
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
ivs__qadi01
|
|
|
>>>>>>>9
|
|
|
|
ivs__qadl01
|
|
|
yes/no
|
|
|
|
ivs__qadt01
|
|
|
99/99/99
|
|
|
|
ivs_ar_acct
|
AR Account
|
|
x(8)
|
|
|
|
ivs_ar_cc
|
AR Cost Center
|
|
x(4)
|
|
|
|
ivs_ar_sub
|
AR Sub-Account
|
|
x(8)
|
|
|
|
ivs_cmmts
|
Schedule Comments
|
|
yes/no
|
|
|
|
ivs_domain
|
Domain
|
|
x(8)
|
|
|
|
ivs_index1
|
Index
|
|
>>>>>9
|
|
|
|
ivs_inv_type
|
Invoice Type
|
|
x(4)
|
|
|
|
ivs_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ivs_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
ivs_prep_acct
|
Prepayment Account
|
|
x(8)
|
|
|
|
ivs_prep_cc
|
Prepayment Cost Center
|
|
x(4)
|
|
|
|
ivs_prep_sub
|
Prepayment Sub-Account
|
|
x(8)
|
|
|
|
ivs_ptax_acct
|
Prepayment Tax Account
|
|
x(8)
|
|
|
|
ivs_ptax_cc
|
Prepayment Tax Cost Center
|
|
x(4)
|
|
|
|
ivs_ptax_sub
|
Prepayment Tax Sub-Account
|
|
x(8)
|
|
|
|
ivs_so_nbr
|
Next Pending Invoice
|
|
>>>>>>>9
|
|
|
|
ivs_so_pre
|
Pending Invoice Prefix
|
|
x(3)
|
|
|
|
ivs_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ivs_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_ivs_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ivs_index1
|
yes
|
ivs_domain
|
yes
|
no
|
|
|
oid_ivs_ctrl
|
yes
|
oid_ivs_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
Journal_ID
|
Record ID
|
|
-99999999999
|
|
|
|
JournalCode
|
Daybook Code
|
|
x(8)
|
|
|
|
JournalControl
|
Daybook Control
|
Daybook Ctrl
|
x(20)
|
|
|
|
JournalDescription
|
Description
|
Daybook Description
|
x(40)
|
|
|
|
JournalGroup_ID
|
Link to Journal Group
|
|
-99999999999
|
|
|
|
JournalIsActive
|
Active
|
|
yes/no
|
|
|
|
JournalIsProjectProvision
|
Project Provision
|
|
yes/no
|
|
|
|
JournalSecondDescription
|
Second Description
|
|
x(40)
|
|
|
|
JournalTypeCode
|
Daybook Type
|
|
x(30)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Layer_ID
|
Link to Layer
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Role_ID
|
Link to Role
|
|
-99999999999
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
InternalJournal
|
no
|
JournalTypeCode
|
yes
|
no
|
|
|
JournalControl
|
no
|
JournalControl
|
yes
|
no
|
|
|
JournalGroupIdx
|
no
|
JournalGroup_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
Layer
|
no
|
Layer_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Journal_ID
|
yes
|
no
|
|
|
RoleIdx
|
no
|
Role_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
SharedSetAndCode
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
JournalCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
JournalIsActive
|
yes
|
no
|
|
|
|
|
JournalCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
JournalGroup_ID
|
Record ID
|
|
-99999999999
|
|
|
|
JournalGroupCode
|
Daybook Group Code
|
|
x(20)
|
|
|
|
JournalGroupDescription
|
Description
|
Daybook Group Description
|
x(40)
|
|
|
|
JournalGroupIsActive
|
Active
|
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
IsActive
|
no
|
JournalGroupIsActive
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
JournalGroup_ID
|
yes
|
no
|
|
|
SharedSet_ID
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
JournalGroupCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
JournalGroupIsActive
|
yes
|
no
|
|
|
|
|
JournalGroupCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
Journal_ID
|
Link to Journal
|
|
-99999999999
|
|
|
|
JournalLay_ID
|
Record ID
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
TargetLayer_ID
|
Link to Layer (Target)
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
JournalIdx
|
no
|
Journal_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
LayerIdx
|
no
|
TargetLayer_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
JournalLay_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
Journal_ID
|
yes
|
no
|
|
|
|
|
TargetLayer_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
JournalLay_ID
|
Link to JournalLay
|
|
-99999999999
|
|
|
|
JournalLayJrnl_ID
|
Record ID
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
TargetJournal_ID
|
Link to Journal (Target)
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
JournalIdx
|
no
|
TargetJournal_ID
|
yes
|
no
|
|
|
JournalLayIdx
|
no
|
JournalLay_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
JournalLayJrnl_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
JournalLay_ID
|
yes
|
no
|
|
|
|
|
TargetJournal_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
JournalTypeCode
|
Daybook Type Code
|
|
x(30)
|
|
|
|
JournalTypeIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
JournalTypeIsAllowMgt
|
Allow Management Layer
|
Allow Mgt
|
yes/no
|
|
|
|
JournalTypeIsAllowOfficial
|
Allow Official Layer
|
Allow Official
|
yes/no
|
|
|
|
JournalTypeIsAllowTrans
|
Allow Transient Layer
|
Allow Transient
|
yes/no
|
|
|
|
JournalTypeIsCorrection
|
Correction Daybook
|
|
yes/no
|
|
|
|
JournalTypeIsMultiJournal
|
Multiple Daybooks Allowed
|
Multi Daybooks
|
yes/no
|
|
|
|
JournalTypeIsStock
|
Stock Daybook
|
Stock
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
JournalTypeCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
JournalTypeIsActive
|
yes
|
no
|
|
|
|
|
JournalTypeCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
kbc__qadc01
|
|
|
x(8)
|
|
|
|
kbc__qadc02
|
|
|
x(24)
|
|
|
|
kbc__qadc03
|
|
|
x(24)
|
|
|
|
kbc__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
kbc__qadi01
|
|
|
->>>>>>>9
|
|
|
|
kbc__qadi02
|
|
|
->>>>>>>9
|
|
|
|
kbc__qadl01
|
|
|
yes/no
|
|
|
|
kbc__qadt01
|
|
|
99/99/99
|
|
|
|
kbc_accumulator_pause
|
Accumulator Monitor Pause
|
Pause
|
>>9
|
|
|
|
kbc_barcode_format_ext
|
Barcode External
|
Barcode!External
|
x(8)
|
|
|
|
kbc_barcode_format_int
|
Barcode Internal
|
Barcode!Internal
|
x(8)
|
|
|
|
kbc_card_reconcile
|
Card Reconciliation
|
|
yes/no
|
|
|
|
kbc_card_reporting
|
Card Reporting
|
|
>9
|
|
|
|
kbc_controlled_entry
|
Controlled Entry
|
Controlled!Entry
|
x(1)
|
|
|
|
kbc_cost_set
|
Cost Set
|
|
x(8)
|
|
|
|
kbc_decrease_at_cons
|
Decrease at Consume
|
|
x(8)
|
|
|
|
kbc_dispatch_nrm_id
|
Dispatch ID
|
|
x(8)
|
|
|
|
kbc_display_pause
|
Display Pause
|
Pause
|
>>9
|
|
|
|
kbc_domain
|
Domain
|
|
x(8)
|
|
|
|
kbc_eff_date_entry
|
Enable Eff Date
|
Enable!Eff!Date
|
yes/no
|
|
|
|
kbc_export_directory
|
Export Directory
|
Export Dir
|
x(45)
|
|
|
|
kbc_fifo_entry
|
Allow Entry of FIFO Process
|
Enable!FIFO
|
yes/no
|
|
|
|
kbc_fractional_kanban
|
Fractional Kanban
|
Fract!Kanban
|
>>9.9<%
|
10
|
|
|
kbc_id_barcode
|
Print ID Barcode
|
ID Barcode
|
yes/no
|
|
|
|
kbc_import_directory
|
Import Directory
|
Import Dir
|
x(45)
|
|
|
|
kbc_item_barcode
|
Print Item Barcode
|
Item!Barcode
|
yes/no
|
|
|
|
kbc_lead_time_method
|
Lead Time Method
|
LT!Method
|
>9
|
|
|
|
kbc_load_limit
|
Load Limit
|
Load!Limit
|
>>9.9<%
|
10
|
|
|
kbc_lot_entry
|
Lot Entry
|
|
yes/no
|
|
|
|
kbc_max_cycle_time
|
Maximum Cycle Time
|
Maximum!Cycle Time
|
>>>>>>>>9
|
|
|
|
kbc_min_cycle_check
|
Minimum Cycle Check
|
Min!Cycle!Check
|
x(1)
|
|
|
|
kbc_min_cycle_time
|
Minimum Cycle Time
|
Minimum!Cycle Time
|
>>>>>>>>9
|
|
|
|
kbc_min_epe_interval
|
Min EPE Interval
|
Min EPEI
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
kbc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
kbc_mod_inv_data
|
Modify Inv Data
|
|
x(8)
|
|
|
|
kbc_mod_inv_pct
|
Modify Inv Threshold
|
|
>>9.99%
|
10
|
|
|
kbc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
kbc_move_card_sizing
|
Move Card Sizing
|
|
x(8)
|
|
|
|
kbc_move_seq_enforce
|
Move Sequence Enforcement
|
|
yes/no
|
|
|
|
kbc_pattern
|
Current Demand Pattern
|
Curr Demand!Pattern
|
x(8)
|
|
|
|
kbc_phase_in_method
|
Phase-In Method
|
|
x(8)
|
|
|
|
kbc_phase_out_method
|
Phase-Out Method
|
|
x(8)
|
|
|
|
kbc_po_data_entry
|
PO Receipt Data Entry
|
|
yes/no
|
|
|
|
kbc_print_consume_ref
|
Print Consuming Reference
|
Print Consume
|
yes/no
|
|
|
|
kbc_print_quantity
|
Print Quantity
|
|
yes/no
|
|
|
|
kbc_regen_enforce
|
Regeneration Enforcement
|
|
x(8)
|
|
|
|
kbc_repl_seq_enforce
|
Replenishment Sequence Enforcement
|
|
yes/no
|
|
|
|
kbc_ss_template
|
Safety Stock Template
|
SS!Template
|
x(8)
|
|
|
|
kbc_template
|
Demand Template
|
|
x(8)
|
|
|
|
kbc_time_adj[5]
|
Time Adjustment
|
Adjust
|
x(8)
|
|
|
|
kbc_time_fence
|
Time Fence
|
|
>>9
|
|
|
|
kbc_tolerance_pct
|
Tolerance Pct
|
Tol Pct
|
>>9.99%
|
10
|
|
|
kbc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
kbc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
kbc_userd01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
kbc_useri01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
kbc_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
kbc_usert01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
oid_kbc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
kbc_index1
|
yes
|
kbc_domain
|
yes
|
no
|
|
|
oid_kbc_ctrl
|
yes
|
oid_kbc_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
kbdt__qadc01
|
|
|
x(24)
|
|
|
|
kbdt__qadc02
|
|
|
x(24)
|
|
|
|
kbdt_desc
|
Description
|
|
x(24)
|
|
|
|
kbdt_domain
|
Domain
|
|
x(8)
|
|
|
|
kbdt_future_days
|
Future Days
|
|
>>9
|
|
|
|
kbdt_future_source
|
Future Source
|
|
x(8)
|
|
|
|
kbdt_history_days
|
Historical Days
|
|
>>9
|
|
|
|
kbdt_history_source
|
Historical Source
|
|
x(8)
|
|
|
|
kbdt_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
kbdt_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
kbdt_template
|
Template
|
|
x(8)
|
|
|
|
kbdt_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
kbdt_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_kbdt_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
kbdt_template
|
yes
|
kbdt_domain
|
yes
|
no
|
|
|
|
|
kbdt_template
|
yes
|
no
|
|
|
oid_kbdt_mstr
|
yes
|
oid_kbdt_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
kbmd__chr01
|
|
|
x(8)
|
|
|
|
kbmd__dec01
|
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
kbmd__dte01
|
|
|
99/99/99
|
|
|
|
kbmd__int01
|
|
|
->>>,>>>,>>9
|
|
|
|
kbmd__log01
|
|
|
yes/no
|
|
|
|
kbmd__qadc01
|
|
|
x(8)
|
|
|
|
kbmd__qadd01
|
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
kbmd__qadi01
|
|
|
->>>,>>>,>>9
|
|
|
|
kbmd__qadl01
|
|
|
yes/no
|
|
|
|
kbmd__qadt01
|
|
|
99/99/99
|
|
|
|
kbmd_cons_ref
|
Consuming Reference
|
Consuming!Reference
|
x(8)
|
|
|
|
kbmd_cons_source
|
Consuming Destination
|
Consuming!Destination
|
x(8)
|
|
|
|
kbmd_demand
|
Maximum Demand
|
|
>>>,>>>,>>9
|
|
|
|
kbmd_domain
|
Domain
|
|
x(8)
|
|
|
|
kbmd_line
|
Production Line
|
Production!Line
|
x(8)
|
|
|
|
kbmd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
kbmd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
kbmd_part
|
Item Number
|
|
x(18)
|
|
|
|
kbmd_pattern
|
Demand Pattern
|
Demand!Pattern
|
x(8)
|
|
|
|
kbmd_period
|
Planning Period
|
Planning!Period
|
x(8)
|
|
|
|
kbmd_supp_ref
|
Supplying Reference
|
Supplying!Reference
|
x(8)
|
|
|
|
kbmd_supp_source
|
Supplying Source
|
Supplying!Source
|
x(8)
|
|
|
|
kbmd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
kbmd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_kbmd_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
kbmd_cons_source
|
yes
|
kbmd_domain
|
yes
|
no
|
|
|
|
|
kbmd_cons_source
|
yes
|
no
|
|
|
|
|
kbmd_pattern
|
yes
|
no
|
|
|
|
|
kbmd_part
|
yes
|
no
|
|
|
|
|
kbmd_cons_ref
|
yes
|
no
|
|
|
|
|
kbmd_supp_source
|
yes
|
no
|
|
|
|
|
kbmd_supp_ref
|
yes
|
no
|
|
|
|
|
kbmd_line
|
yes
|
no
|
|
|
kbmd_cons_source2
|
no
|
kbmd_domain
|
yes
|
no
|
|
|
|
|
kbmd_cons_source
|
yes
|
no
|
|
|
|
|
kbmd_pattern
|
yes
|
no
|
|
|
|
|
kbmd_period
|
yes
|
no
|
|
|
|
|
kbmd_part
|
yes
|
no
|
|
|
kbmd_part
|
yes
|
kbmd_domain
|
yes
|
no
|
|
|
|
|
kbmd_part
|
yes
|
no
|
|
|
|
|
kbmd_supp_source
|
yes
|
no
|
|
|
|
|
kbmd_supp_ref
|
yes
|
no
|
|
|
|
|
kbmd_cons_source
|
yes
|
no
|
|
|
|
|
kbmd_cons_ref
|
yes
|
no
|
|
|
|
|
kbmd_line
|
yes
|
no
|
|
|
|
|
kbmd_pattern
|
yes
|
no
|
|
|
oid_kbmd_mstr
|
yes
|
oid_kbmd_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
kbpp__qadc01
|
|
|
x(8)
|
|
|
|
kbpp_calendar_days
|
Calendar Days
|
Cal!Days
|
>>9
|
|
|
|
kbpp_desc
|
Description
|
|
x(24)
|
|
|
|
kbpp_domain
|
Domain
|
|
x(8)
|
|
|
|
kbpp_hours
|
Hours per Period
|
Hours per!Period
|
>>,>>9.99
|
10
|
|
|
kbpp_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
kbpp_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
kbpp_period
|
Planning Period
|
Planning!Period
|
x(8)
|
|
|
|
kbpp_user1
|
Ufld1
|
|
x(8)
|
|
|
|
kbpp_user2
|
Ufld2
|
|
x(8)
|
|
|
|
kbpp_work_days
|
Work Days
|
Work!Days
|
>>9
|
|
|
|
oid_kbpp_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
kbpp_period
|
yes
|
kbpp_domain
|
yes
|
no
|
|
|
|
|
kbpp_period
|
yes
|
no
|
|
|
oid_kbpp_mstr
|
yes
|
oid_kbpp_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
kbtrd__qadc01
|
|
|
x(24)
|
|
|
|
kbtrd__qadc02
|
|
|
x(24)
|
|
|
|
kbtrd__qadi01
|
|
|
->>>>>>>9
|
|
|
|
kbtrd_dataset
|
Table Name
|
|
x(14)
|
|
|
|
kbtrd_domain
|
Domain
|
|
x(8)
|
|
|
|
kbtrd_kbtr_trans_nbr
|
Kanban Transaction Number
|
Kanban!Transaction
|
>>>>>>>>9
|
|
|
|
kbtrd_mod_date
|
Modified Date
|
Modified
|
99/99/99
|
|
|
|
kbtrd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
kbtrd_tr_trnbr
|
Inventory Transaction Number
|
Inventory!Transaction
|
>>>>>>>>>9
|
|
|
|
kbtrd_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
kbtrd_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
kbtrd_useri01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
oid_kbtrd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
kbtrd_dataset_kbtr
|
yes
|
kbtrd_domain
|
yes
|
no
|
|
|
|
|
kbtrd_dataset
|
yes
|
no
|
|
|
|
|
kbtrd_kbtr_trans_nbr
|
yes
|
no
|
|
|
|
|
kbtrd_tr_trnbr
|
yes
|
no
|
|
|
kbtrd_dataset_tr
|
yes
|
kbtrd_domain
|
yes
|
no
|
|
|
|
|
kbtrd_dataset
|
yes
|
no
|
|
|
|
|
kbtrd_tr_trnbr
|
yes
|
no
|
|
|
|
|
kbtrd_kbtr_trans_nbr
|
yes
|
no
|
|
|
oid_kbtrd_det
|
yes
|
oid_kbtrd_det
|
yes
|
no
|