CONDITION REPORT
----------------
FILE - REQLINE
Condition Type
--------------------------------------------------------------------------------
CLOSED FILEFLD
where (( Closed Fl = "Y" ))
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
--------------------------------------------------------------------------------
CREATE-PO FILEFLD
where ( Create Po Fl = "Y"
And Status >= 1 )
Is Used In No Indexes
Is Used In Rel - POLINESRC
Is Used In No SubType
Is Used In No States
Is Used In CndFld - DER-ORIGIN-CD
- DER-REQUESTER
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HAS-ACCOUNTS OTOFLDS
where ( Relation: Accounts 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-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: Rqlinedtl 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-ITEMSUB OTOFLDS
where ( Relation: Itemsub 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-MMUAVAL OTOFLDS
where ( Relation: Mmuaval 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-PH-DEMAND OTOFLDS
where ( Relation: Whdemand Phar 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-SOURCE OTOFLDS
where ( Relation: Polinesrc 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-WHSHIPLINE OTOFLDS
where ( Relation: Whshipline 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
--------------------------------------------------------------------------------
INTERCOMPANY FILEFLD
where ( Company != From Company )
Is Used In Index - RLNSET9
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
--------------------------------------------------------------------------------
INVENTORY FILEFLD
where ( Item Type = "I" )
Is Used In Index - RLNSET2
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 FILEFLD
where ( Item Type = "I"
Or Item Type = "N" )
Is Used In No Indexes
Is Used In Rel - ITEM
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-LOCATION FILEFLD
where ( Item Type = "I" )
Is Used In No Indexes
Is Used In Rel - ITEM-LOCATION
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
--------------------------------------------------------------------------------
OPEN FILEFLD
where (( Closed Fl != "Y" ))
Is Used In Index - RLNSET4
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
--------------------------------------------------------------------------------
PO-COMPANY FILEFLD
where ( Item Type != "I" )
Is Used In No Indexes
Is Used In Rel - PO-COMPANY
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
--------------------------------------------------------------------------------
POLINESRC FILEFLD
where ( Create Po Fl = "Y"
And Status = 9 )
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
--------------------------------------------------------------------------------
PROCREJ-STATUS FILEFLD
where (( Status = 9 )
And ( Closed Fl = "Y" ))
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - DER-CLOSE-STAT
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
REJECT-STATUS FILEFLD
where ( Status = 8 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - DER-CLOSE-STAT
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
RELEASE-STATUS FILEFLD
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 CndFld - DER-CLOSE-STAT
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
UNRELEASE-STAT FILEFLD
where ( Status = Zeroes )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - DER-CLOSE-STAT
Is Used In No AvfFlds
Is Used In No Rules
|
