|
|
CONDITION REPORT
----------------
FILE - RETURNLINE
Condition Type
--------------------------------------------------------------------------------
BIN-TRACKED OTOFLDS
where ( Itemmast->Lot Track Fl = "N"
And Itemloc->Bin Track Fl = "Y" )
Is Used In No Indexes
Is Used In Rel - BINS
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
--------------------------------------------------------------------------------
CLOSED FILEFLD, STATE
where ( Status = 9 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In State - CLOSED
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
COGS-ACCOUNT FILEFLD
where ( Cgs Acct Unit != Spaces
Or Cgs Account != Zeroes
Or Cgs Sub Acct != Zeroes )
Is Used In No Indexes
Is Used In Rel - COGS-ACCOUNT
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
--------------------------------------------------------------------------------
COGS-OFFSET FILEFLD
where ( Off Acct Unit != Spaces
Or Off Account != Zeroes
Or Off Sub Acct != Zeroes )
Is Used In No Indexes
Is Used In Rel - COGS-OFFSET
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
--------------------------------------------------------------------------------
COMMITTED-C FILEFLD
where ( Atn Obj Id C != Zeroes )
Is Used In Index - RTLSET3
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
--------------------------------------------------------------------------------
ENTERED FILEFLD, STATE
where ( Status = Zeroes )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In State - ENTERED
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
FULLY-RECEIVED FILEFLD, STATE
where ( Status = 1 )
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
--------------------------------------------------------------------------------
ITEMLOC FILEFLD
where ( Line Type = "I" )
Is Used In No Indexes
Is Used In Rel - ITEMLOC
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
--------------------------------------------------------------------------------
ITEMMAST FILEFLD
where ( Line Type != "X" )
Is Used In No Indexes
Is Used In Rel - ITEMMAST
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
--------------------------------------------------------------------------------
LOT-TRACKED OTOFLDS
where ( Itemmast->Lot Track Fl = "Y" )
Is Used In No Indexes
Is Used In Rel - LOTS
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
--------------------------------------------------------------------------------
ORIG-INVOICE OTOFLDS
where ( Returnhdr->Orig Invc Pre != Spaces
Or Returnhdr->Orig Invc Nbr != Zeroes )
Is Used In No Indexes
Is Used In Rel - OEINVCLINE
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
--------------------------------------------------------------------------------
ORIG-ORDER-NBR FILEFLD
where ( Order Nbr != Zeroes )
Is Used In No Indexes
Is Used In Rel - COLINE
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
--------------------------------------------------------------------------------
REASON-ENTERED FILEFLD
where ( Reason Code != Spaces )
Is Used In No Indexes
Is Used In Rel - OEREASON
- REASON
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
--------------------------------------------------------------------------------
RELEASED FILEFLD
where ( Status = 1 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In State - RELEASED
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
RESTOCK FILEFLD
where ( Restk Chg Code != Spaces )
Is Used In No Indexes
Is Used In Rel - OEMISC
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
--------------------------------------------------------------------------------
SALES-ACCOUNT FILEFLD
where ( Sls Acct Unit != Spaces
Or Sls Account != Zeroes
Or Sls Sub Acct != Zeroes )
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
--------------------------------------------------------------------------------
SERIAL-TRACKED OTOFLDS
where ( Itemmast->Ser Track Fl = "R"
Or Itemmast->Ser Track Fl = "I" )
Is Used In No Indexes
Is Used In Rel - SERIALS
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
--------------------------------------------------------------------------------
SHIPD-TO-VEND FILEFLD, STATE
where ( Status = 3 )
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
--------------------------------------------------------------------------------
UOM-TRACKED OTOFLDS
where ( Mult Uoms > Spaces )
Is Used In No Indexes
Is Used In Rel - UOMS
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
|
