CONDITION REPORT
----------------
FILE - ICTRANS
Condition Type
--------------------------------------------------------------------------------
CREDITACCOUNT FILEFLD
where ( Off Acct Unit != Spaces
And Off Account != Zeroes
And Off Sub Acct != Zeroes )
Is Used In No Indexes
Is Used In No Rels
Is Used In SubType - CREDITACCOUNT
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
DETAIL-EXISTS OTOFLDS
where ( Relation: Ictransdtl 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
--------------------------------------------------------------------------------
HISTORY-REPORT FILEFLD
where (( Doc Type = "IS"
Or Doc Type = "RR" )
And Status = 2 )
Is Used In Index - ICTSET6
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
--------------------------------------------------------------------------------
ICTSET4 FILEFLD
where (( Status = 1
Or Status = 5 ))
Is Used In Index - ICTSET4
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
--------------------------------------------------------------------------------
ICTSET5 FILEFLD
where ( Status = Zeroes )
Is Used In Index - ICTSET5
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
--------------------------------------------------------------------------------
INSPECTION FILEFLD
where ( Doc Type = "RJ"
Or Doc Type = "AC" )
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
--------------------------------------------------------------------------------
INVENTORYACCT FILEFLD
where ( Inv Acct Unit != Spaces )
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
--------------------------------------------------------------------------------
MFG-INFO-EXIST FILEFLD
where ( Manuf Nbr != Spaces )
Is Used In Index - ICTSET8
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
--------------------------------------------------------------------------------
MMDIST-EXISTS OTOFLDS
where ( Relation: Mmdist 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
--------------------------------------------------------------------------------
PO-RECEIVING FILEFLD
where ( Doc Type = "PO" )
Is Used In No Indexes
Is Used In Rel - PORECLINE
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
--------------------------------------------------------------------------------
POSTED FILEFLD
where ( Status = 2 )
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
--------------------------------------------------------------------------------
REASONCODE FILEFLD
where ( Reason Code != Spaces )
Is Used In No Indexes
Is Used In Rel - REASONCODE
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
--------------------------------------------------------------------------------
REC-ADJUST FILEFLD
where ( Doc Type = "RA" )
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
--------------------------------------------------------------------------------
RELEASED FILEFLD
where ( Status != Zeroes )
Is Used In Index - ICTSET2
- ICTSET3
- ICTSET7
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
--------------------------------------------------------------------------------
REQ-RETURN FILEFLD
where ( Doc Type = "RR" )
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
--------------------------------------------------------------------------------
REQUISITIONS FILEFLD
where ( System Cd = "RQ" )
Is Used In No Indexes
Is Used In Rel - REQLINE
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
--------------------------------------------------------------------------------
RETURN-EXISTS OTOFLDS
where ( Relation: Poreturnln 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
--------------------------------------------------------------------------------
SHIPLN-EXISTS 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
--------------------------------------------------------------------------------
UNPOSTED FILEFLD
where ( Status = Zeroes
And Doc Type = "IS"
Or Doc Type = "RT"
Or ( Doc Type = "AJ"
And Quantity < 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
--------------------------------------------------------------------------------
VENDOR-RETURN FILEFLD
where ( Doc Type = "VR"
Or Doc Type = "VA" )
Is Used In No Indexes
Is Used In Rel - PORETURNLN
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
|
