QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
IRAssD
Warehousing Internal Routing Assignment Detail
 
 
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
IRD
Warehousing Internal Routing Detail
 
 
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
IRGroupM
Warehousing Internal Routing Group Master
 
 
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
IRM
Warehousing Internal Routing Master
 
 
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
iro_det
Item Routing Cost Detail
 
 
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
isb_mstr
Service/Support Installed Base Item Master
 
 
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
isd_det
Inventory Status Detail
 
 
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
iss_mstr
Service/Support Installed Base Structure
 
 
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
isvc_mstr
Statistical Value Calculation Master
 
 
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
is_mstr
Inventory Status Master
 
 
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
itmh_hist
Service/Support Call Item History
 
 
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
itm_det
Service/Support Call Item Detail
 
 
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
itsd_det
Item Site Load Detail
 
 
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
its_mstr
Item Site Load Master
 
 
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
ivs_ctrl
Invoice Schedule Control
 
 
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
Journal
Daybook
 
 
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
JournalGroup
Daybook Group
 
 
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
JournalLay
Layer
 
 
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
JournalLayJrnl
Layer
 
 
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
JournalType
Daybook Type
 
 
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
kbc_ctrl
Kanban Control
 
 
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
kbdt_mstr
Kanban Demand Template Master
 
 
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
kbmd_mstr
Kanban Maximum Demand Master
 
 
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
kbpp_mstr
Kanban Planning Period Master
 
 
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
kbtrd_det
Kanban Transaction History Detail
 
 
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