CONDITION REPORT
----------------
FILE - EEEXPENSE
Condition Type
--------------------------------------------------------------------------------
ADVANCE-EXISTS OTOFLDS
where ( Relation: Eematching 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
--------------------------------------------------------------------------------
EEMATCHING OTOFLDS
where ( Relation: Eematching 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
--------------------------------------------------------------------------------
EXP-HISTORY OTOFLDS
where ( Relation: Apinvoice Exists
And Apinvoice->Tran Inv Amt = Apinvoice->Tran Paid Amt )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - AP-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
EXP-OPEN OTOFLDS
where ( Relation: Apinvoice Exists
And Apinvoice->Tran Inv Amt != Apinvoice->Tran Paid Amt )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - AP-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
EXP-UNRELEASED FILEFLD
where ( Rec 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 No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
EXPENSE-TYPE FILEFLD
where ( Expense Type = "E" )
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
--------------------------------------------------------------------------------
MANUAL-PAYMENT FILEFLD
where ( Trans Nbr != Spaces
And Rec 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 No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
OPEN FILEFLD
where (( Rec Status = Zeroes ))
Is Used In Index - EXPSET3
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
--------------------------------------------------------------------------------
OUT-OF-BALANCE FILEFLD
where ( Base Exp Amt != Base Dist Tot
Or Base Tax Amt != Base Tax Tot
Or Base Emp Paid != Base Emp Tot )
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
--------------------------------------------------------------------------------
PAYBACK-TYPE FILEFLD
where ( Expense Type = "P" )
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
--------------------------------------------------------------------------------
PAYMENT-EXISTS OTOFLDS
where ( Relation: Appayment 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
|