|
|
CONDITION REPORT
----------------
FILE - APAPIHIST
Condition Type
--------------------------------------------------------------------------------
ADVANCE-INV FILEFLD
where ( 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 CndFld - TYPE-SHORT-NME
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
AOC-DTLS-EXIST OTOFLDS
where ( Relation: Mamaahist 2 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
--------------------------------------------------------------------------------
APMATCHSTATUS FILEFLD
where((( Match Status = Zeroes )
Or ( Match Status = 1 ))
And ( Match Fl = "Y" )
And (( Rec Status = Zeroes )
Or ( 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
--------------------------------------------------------------------------------
APVENLOCPURCH FILEFLD
where ( Purch Fr Loc != Spaces )
Is Used In No Indexes
Is Used In Rel - APVENLOCPURCH
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
--------------------------------------------------------------------------------
APVENLOCREMIT FILEFLD
where ( Remit To Code != Spaces )
Is Used In No Indexes
Is Used In Rel - APVENLOCREMIT
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
--------------------------------------------------------------------------------
AVAIL-ADVANCE FILEFLD
where (( Suffix = 1 )
And ( Invoice Type = "M" )
And ( 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
--------------------------------------------------------------------------------
CANCEL-INVOICE FILEFLD
where ( Cancel 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
Condition Type
--------------------------------------------------------------------------------
CREDIT-INVOICE FILEFLD
where ( Invoice Type = "C"
Or Invoice Type = "Y"
Or 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 CndFld - TYPE-SHORT-NME
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CREDIT-MEMO FILEFLD
where ( Invoice Type = "C" )
Is Used In Index - AH1SET12
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
--------------------------------------------------------------------------------
DEBIT-INVOICE FILEFLD
where ( Invoice 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 - TYPE-SHORT-NME
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
DTLS-EXIST OTOFLDS
where ( Relation: Mamadhist 2 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 FILEFLD
where ( Invoice Type = "A" )
Is Used In No Indexes
Is Used In Rel - EEADVANCE-A
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 FILEFLD
where ( Invoice Type = "M" )
Is Used In No Indexes
Is Used In Rel - EEADVANCE-M
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 FILEFLD
where ( Invoice Type = "E" )
Is Used In No Indexes
Is Used In Rel - EEEXPENSE
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-INV FILEFLD
where ( 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 CndFld - TYPE-SHORT-NME
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
FACTOR-VENDOR FILEFLD
where ( Pay Vendor != Vendor )
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-HISTORY FILEFLD
where ( Rec Status = 9
And Cancel 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 - INV-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
INV-RELEASED 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 CndFld - INV-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
INV-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 CndFld - INV-STATUS
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
LAWSON-PO FILEFLD
where ( Match Fl = "A"
Or Match 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
--------------------------------------------------------------------------------
MATCH-REF FILEFLD
where ( Match Ref Nbr != Spaces )
Is Used In Index - AH1SET11
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
--------------------------------------------------------------------------------
MATCHED FILEFLD
where ( Match Obj Id != Zeroes
And ( Rec Status = 1
Or Rec 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
--------------------------------------------------------------------------------
NON-BASE-INV 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
--------------------------------------------------------------------------------
OUT-OF-BALANCE FILEFLD
where((( Tran Inv Amt != Base Tot Dist )
Or ( Tran Inv Amt != Tran Tot Pmt )
Or ( Tran Tax Amt != Tran Tot Tax ))
And (( Match Fl != "Y" )
And ( Match Fl != "A" )
And ( Bypass Match != "Y" )
And ( Service 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 - OUT-BAL-FLAG
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
PO-NUMBER-USED FILEFLD
where ( Po Number != 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
--------------------------------------------------------------------------------
PREPAYMENT FILEFLD
where ( Invoice 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 CndFld - TYPE-SHORT-NME
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
REGULAR-INVOIC FILEFLD
where ( Invoice Type = 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 - TYPE-SHORT-NME
Is Used In No AvfFlds
Is Used In No Rules
|
