|
|
CONDITION REPORT
----------------
FILE - APPAYMENT
Condition Type
--------------------------------------------------------------------------------
ACCEPT-DRAFT OTOFLDS
where ( Relation: Apdrafts Exists
And Apdrafts->Rec 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 CndFld - BANK-STATUS
- PAID-DOC-DATE
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
APINCCODE FILEFLD
where ( Income 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 No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
APPSET12 FILEFLD
where (( Rec Status = 1 )
Or ( Rec Status = 2 ))
Is Used In Index - APPSET12
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
--------------------------------------------------------------------------------
APPSET3 FILEFLD
where (( Rec 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
--------------------------------------------------------------------------------
APPSET4 FILEFLD
where ( Rec Status = 1
Or Rec Status = 2 )
Is Used In Index - APPSET4
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
--------------------------------------------------------------------------------
APPSET5 FILEFLD
where ( Rec Status = 2
Or Rec 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
--------------------------------------------------------------------------------
APPSET6 FILEFLD
where ( Trans Ident != Zeroes )
Is Used In Index - APPSET6
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
--------------------------------------------------------------------------------
CANCEL-DRAFT OTOFLDS
where ( Relation: Apdrafts Exists
And Apdrafts->Rec Status = 5 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CASH-PAYMENT FILEFLD, OTOFLDS
where ( Trans Nbr != Spaces
And Relation: Cbcheck 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
--------------------------------------------------------------------------------
CASHED-DRAFT OTOFLDS
where ( Relation: Apdrafts Exists
And Apdrafts->Rec 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 CndFld - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CHK-PROCESSED OTOFLDS
where ( Relation: Cbcheck Exists
And Cbcheck->Rec 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 CndFld - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CSDSET2 FILEFLD, OTOFLDS
where (( Recon Stmt Nbr != Zeroes )
And ( Relation: Cbstmtdtl 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
--------------------------------------------------------------------------------
CURR-BAL-LOC FILEFLD, OTOFLDS
where ( Rec Status > Zeroes
And Rec Status < 8
And Rec Status != 5
And Remit To Code != Spaces
And Relation: Apinvoice Exists
And Apinvoice->Invoice Type != "P"
And Apinvoice->Invoice Type != "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
--------------------------------------------------------------------------------
CURRENT-BAL FILEFLD, OTOFLDS
where ( Rec Status > Zeroes
And Rec Status < 8
And Rec Status != 5
And Remit To Code = Spaces
And Relation: Apinvoice Exists
And Apinvoice->Invoice Type != "P"
And Apinvoice->Invoice Type != "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
--------------------------------------------------------------------------------
DETAIL-PMT OTOFLDS
where ( Cbcheck->Serial Num = Zeroes )
Is Used In No Indexes
Is Used In Rel - CBTRANS
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
--------------------------------------------------------------------------------
DISHONOR-DRAFT OTOFLDS
where ( Relation: Apdrafts Exists
And Apdrafts->Rec Status = 4 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
DRAFT-ACCRUAL FILEFLD
where ( Rec Status = 5 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - DRAFT-ACCRUED
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
DRAFT-ACCRUED FILEFLD
where ( Rec Status = 5 )
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
--------------------------------------------------------------------------------
DRAFT-CANCEL FILEFLD
where ( Rec 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 - PMT-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
DRAFT-PAYMENT FILEFLD, OTOFLDS
where ( Trans Nbr != Spaces
And Relation: Apdrafts 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
--------------------------------------------------------------------------------
EMP-ADVANCE OTOFLDS
where ( Relation: Apinvoice Exists
And Apinvoice->Invoice Type = "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
--------------------------------------------------------------------------------
EMP-CREDIT OTOFLDS
where ( Relation: Apinvoice Exists
And Apinvoice->Invoice Type = "M" )
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
--------------------------------------------------------------------------------
EMP-EXPENSE OTOFLDS
where ( Relation: Apinvoice Exists
And Apinvoice->Invoice 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
--------------------------------------------------------------------------------
INC-WH-PMT FILEFLD
where ( Tran Inc Wh != 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
--------------------------------------------------------------------------------
INV-PAID FILEFLD, OTOFLDS
where((( Rec Status > 2 )
And ( Cbbankinst->Bank Inst Type = "C" ))
Or (( Rec Status = 9 )
And ( Cbbankinst->Bank Inst Type = "D" )))
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - BASE-NET-PMT
- TRAN-NET-PMT
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ISSUED-CASH OTOFLDS
where ( Relation: Cbcheck Exists
And Relation: Cbtrans Exists
And Cbtrans->Rec 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 - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
NO-PAYMENT FILEFLD
where ( Trans Nbr = 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 - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
NO-REINSTATE OTOFLDS
where ( Relation: Cbcheck Exists
And Cbcheck->Rec 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 CndFld - NO-REINSTATE
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
NON-BASE-PMT FILEFLD, OTOFLDS
where ( Inv Currency != Apcompany->Base Currency )
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
--------------------------------------------------------------------------------
ON-HOLD FILEFLD
where (( Hold Flag = "Y" ))
Is Used In No Indexes
Is Used In Rel - APHLDINV
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-PMT FILEFLD, OTOFLDS
where ( Rec Status < 3
Or (( Cbbankinst->Bank Inst Type = "D" )
And ( Rec Status = 4 )))
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - PMT-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
PAID-PMT FILEFLD, OTOFLDS
where((( Cbbankinst->Bank Inst Type = "C" )
And ( Rec Status > 2 )
And ( Void Seq = Zeroes ))
Or (( Cbbankinst->Bank Inst Type = "D" )
And ( Rec Status = 5 ))
Or (( Cbbankinst->Bank Inst Type = "D" )
And ( Rec Status = 9 )
And ( Void Seq = 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 - PMT-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
RECONCILE-CASH OTOFLDS
where ( Relation: Cbcheck Exists
And Relation: Cbtrans Exists
And Cbtrans->Rec 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 CndFld - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
STOP-PMT-CASH OTOFLDS
where ( Relation: Cbcheck Exists
And Relation: Cbtrans Exists
And Cbtrans->Rec Status = 4 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TAPE-ISSUED OTOFLDS
where ( Relation: Cbtrans Tape Exists
And Cbtrans Tape->Rec 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 - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TAPE-PAYMENT OTOFLDS
where ( Relation: Cbcheck Exists
And Cbcheck->Rec Status = 2
And Cbcheck->Serial Num != Zeroes )
Is Used In No Indexes
Is Used In Rel - CBTRANS-TAPE
Is Used In No SubType
Is Used In No States
Is Used In CndFld - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TAPE-PMT-REJ OTOFLDS
where ( Cbcheck->Rec Status = 3
Or Cbcheck->Rec Status = 4 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TAPE-RECONCILE OTOFLDS
where ( Relation: Cbtrans Tape Exists
And Cbtrans Tape->Rec 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 CndFld - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TAPE-VOID OTOFLDS
where ( Relation: Cbtrans Tape Exists
And (( Cbtrans->Rec Status = 3 )
Or ( Cbtrans->Rec Status = 4 )))
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
UNACCEPT-DRAFT OTOFLDS
where ( Relation: Apdrafts Exists
And Apdrafts->Rec 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 CndFld - BANK-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
UNOPEN-CASH FILEFLD, OTOFLDS
where ( Cbbankinst->Bank Inst Type = "C"
And Rec 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
--------------------------------------------------------------------------------
VOID-CASH OTOFLDS
where ( Relation: Cbcheck Exists
And Relation: Cbtrans Exists
And Cbtrans->Rec 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 CndFld - BANK-STATUS
- PMT-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
VOID-PMT FILEFLD
where ( Rec Status = 9
And Void Seq > 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
|
