|
|
CONDITION REPORT
----------------
FILE - APAPPHIST
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
--------------------------------------------------------------------------------
AH3SET6 FILEFLD
where ( Trans Ident != Zeroes )
Is Used In Index - AH3SET6
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
--------------------------------------------------------------------------------
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-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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
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
|
