CONDITION REPORT
----------------
FILE - ITEMLOC
Condition Type
--------------------------------------------------------------------------------
ACTIVE FILEFLD
where ( Active Status = "A" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-ALLOC-ADD OTOFLDS
where ( Company->Alc Alloc Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-ALLOC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-ALLOC-SUB OTOFLDS
where ( Company->Alc Alloc Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-ALLOC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-BKORD-ADD OTOFLDS
where ( Company->Alc Bckord Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-BACKORD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-BKORD-SUB OTOFLDS
where ( Company->Alc Bckord Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-BACKORD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-HOLD-ADD OTOFLDS
where ( Company->Alc Hold Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-HOLD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-HOLD-SUB OTOFLDS
where ( Company->Alc Hold Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-HOLD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-INPRC-ADD OTOFLDS
where ( Company->Alc Inproc Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-INPROC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-INPRC-SUB OTOFLDS
where ( Company->Alc Inproc Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-INPROC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-INTRN-ADD OTOFLDS
where ( Company->Alc Intrnc Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-INTRAN
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-INTRN-SUB OTOFLDS
where ( Company->Alc Intrnc Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-INTRAN
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-ONORD-ADD OTOFLDS
where ( Company->Alc Onord Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-ONORD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-ONORD-SUB OTOFLDS
where ( Company->Alc Onord Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-ONORD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-WIP-ADD OTOFLDS
where ( Company->Alc Wip Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-WIP
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ALC-WIP-SUB OTOFLDS
where ( Company->Alc Wip Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALC-WIP
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
AVAIL-CW-OPT-1 OTOFLDS
where ( Itemmast->Ctw Code = "N" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CWT-ITEM OTOFLDS
where ( Itemmast->Ctw Code != "N" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HAS-DEMAND OTOFLDS
where ( Relation: Whdemand Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HAS-DETAIL OTOFLDS
where ( Relation: Sohdetail Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HAS-PURCH-TAX FILEFLD
where ( Purch Tax Cd != Spaces )
Is Used In No Indexes
Is Used In Rel - TAX-CODE-PURCH
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HAS-SELL-TAX FILEFLD
where ( Sell Tax Cd != Spaces )
Is Used In No Indexes
Is Used In Rel - TAX-CODE-SELL
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HAS-SERIAL OTOFLDS
where ( Relation: Itserial Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
INACTIVE FILEFLD
where ( Active Status = "I" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ITEM-ENTERED FILEFLD
where ( Item != Spaces )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ITEM-CODE-USED
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
MANUF-CD-ENTRD FILEFLD
where ( Manuf Code != Spaces )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - MANUF-CODE-DER
- MANUF-DIV-DER
- MANUF-NBR-DER
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
NON-CWT-ITEM OTOFLDS
where ( Itemmast->Ctw Code = "N" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
PHARITEM-EXIST OTOFLDS
where ( Relation: Pharittoitmloc Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
PREFERRED-BIN FILEFLD
where ( Prefer Bin != Spaces
And Bin Track Fl = "Y" )
Is Used In No Indexes
Is Used In Rel - BINGRPDTL
- PREFERRED-BIN
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
REPL-MFG-ENTRD OTOFLDS
where ( Repl Itemloc->Manuf Code != Spaces )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - MANUF-CODE-DER
- MANUF-DIV-DER
- MANUF-NBR-DER
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
RRPL-MFG-ENTRD OTOFLDS
where ( Rrpl Itemloc->Manuf Code != Spaces )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - MANUF-CODE-DER
- MANUF-DIV-DER
- MANUF-NBR-DER
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-ALLOC-ADD OTOFLDS
where ( Company->Sell Alloc Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-ALLOC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-ALLOC-SUB OTOFLDS
where ( Company->Sell Alloc Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-ALLOC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-BKORD-ADD OTOFLDS
where ( Company->Sell Bckord Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-BACKORD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-BKORD-SUB OTOFLDS
where ( Company->Sell Bckord Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-BACKORD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-HOLD-ADD OTOFLDS
where ( Company->Sell Hold Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-HOLD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-HOLD-SUB OTOFLDS
where ( Company->Sell Hold Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-HOLD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-INPRC-ADD OTOFLDS
where ( Company->Sell Inproc Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-INPROC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-INPRC-SUB OTOFLDS
where ( Company->Sell Inproc Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-INPROC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-INTRN-ADD OTOFLDS
where ( Company->Sell Intrnc Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-INTRAN
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-INTRN-SUB OTOFLDS
where ( Company->Sell Intrnc Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-INTRAN
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-ONORD-ADD OTOFLDS
where ( Company->Sell Onord Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-ONORD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-ONORD-SUB OTOFLDS
where ( Company->Sell Onord Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-ONORD
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-WIP-ADD OTOFLDS
where ( Company->Sell Wip Fl = "+" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-WIP
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SELL-WIP-SUB OTOFLDS
where ( Company->Sell Wip Fl = "-" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SELL-WIP
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
STORAGE-CODE FILEFLD
where ( Storage Code != Spaces )
Is Used In No Indexes
Is Used In Rel - STORAGE-CODE
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
|
