|
|
CONDITION REPORT
----------------
FILE - APINVOICE
Condition Type
--------------------------------------------------------------------------------
ACCRUED-TAX OTOFLDS
where ( Relation: Taxcode Exists
And Taxcode->Accrual Fl = "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
--------------------------------------------------------------------------------
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: Maaocdtl 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
--------------------------------------------------------------------------------
APAUTHOR FILEFLD
where ( Auth Code > Spaces )
Is Used In No Indexes
Is Used In Rel - APAUTHOR
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
--------------------------------------------------------------------------------
APBATCH FILEFLD
where ( Batch Num != Zeroes )
Is Used In No Indexes
Is Used In Rel - APBATCH
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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
APISET11 FILEFLD
where (( Tran Tot Pmt != Tran Inv Amt )
Or ( Base Tot Pmt != Base Inv Amt ))
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
--------------------------------------------------------------------------------
APISET12 FILEFLD
where (( Approved Flag = "N" )
Or ( Approved Flag = "D" ))
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
--------------------------------------------------------------------------------
APISET2 FILEFLD
where ( Rec Status = Zeroes )
Is Used In Index - APISET2
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
--------------------------------------------------------------------------------
APISET3 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
--------------------------------------------------------------------------------
APISET7 FILEFLD
where ( Tran Tot Dist != Tran Inv Amt
Or Tran Tot Pmt != Tran Inv Amt
Or Base Tot Pmt != Base Inv Amt
Or Tran Tot Tax != Tran Tax Amt )
Is Used In Index - APISET7
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 Index - APISET14
- APISET8
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
--------------------------------------------------------------------------------
APUAVAL-EXISTS OTOFLDS
where ( Relation: Apuaval 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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
AVAIL-TO-MATCH FILEFLD
where ( Match Fl = "Y"
And Match Status = Zeroes
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
--------------------------------------------------------------------------------
BATCH-INVOICE FILEFLD
where ( Batch Num != 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
--------------------------------------------------------------------------------
BUYER-MESSAGES OTOFLDS
where ( Relation: Pomessage 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
--------------------------------------------------------------------------------
BYPASS-INV FILEFLD
where ( Bypass Match = "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
--------------------------------------------------------------------------------
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-APPLIED FILEFLD, OTOFLDS
where (( Invoice Type != "C"
Or Invoice Type != "Y"
Or Invoice Type != "M" )
And Relation: Apcrmemo 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
--------------------------------------------------------------------------------
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 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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
DISC-TOT FILEFLD
where (( Disc Point = 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
--------------------------------------------------------------------------------
DTLS-EXIST OTOFLDS
where ( Relation: Mainvdtl 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
--------------------------------------------------------------------------------
FROM-RETURN FILEFLD
where ( Return Number != 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
--------------------------------------------------------------------------------
INTRAST-EXIST FILEFLD
where (( Notc != Spaces )
Or ( Stat Proc != Spaces )
Or ( Ship Via != Spaces )
Or ( Unloading Port != Spaces )
Or ( Intrastat Nbr != Zeroes )
Or ( Dropship Fl != Spaces )
Or ( Fob 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
--------------------------------------------------------------------------------
INV-APPLIED FILEFLD, OTOFLDS
where (( Invoice Type = "C"
Or Invoice Type = "Y"
Or Invoice Type = "M" )
And Relation: Apcrmemo2 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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
INVOICED-TAX OTOFLDS
where ( Relation: Taxcode Exists
And Taxcode->Accrual Fl = "I" )
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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
LINK-NOT-MATCH FILEFLD
where ( Match 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
--------------------------------------------------------------------------------
MAINVMSG-EXIST OTOFLDS
where ( Relation: Mainvmsg 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
--------------------------------------------------------------------------------
MATCH-REF FILEFLD
where ( Match Ref Nbr != Spaces )
Is Used In Index - APISET11
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
--------------------------------------------------------------------------------
NON-MATCH-INV FILEFLD
where ( 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
--------------------------------------------------------------------------------
OPEN-CREDIT FILEFLD
where((( Invoice Type = "C" )
Or ( Invoice Type = "M" )
Or ( Invoice Type = "Y" ))
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
--------------------------------------------------------------------------------
OPEN-INVOICES FILEFLD
where ( Rec Status = Zeroes
Or Rec Status = 1 )
Is Used In No Indexes
Is Used In No Rels
Is Used In SubType - OPEN-INVOICES
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
OPEN-PREPAY FILEFLD
where ( Invoice Type = "Y"
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
--------------------------------------------------------------------------------
OUT-BAL-PO-INV FILEFLD
where((( Tran Inv Amt != Tran Tot Dist )
Or ( Tran Inv Amt != Tran Tot Pmt )
Or ( Tran Tax Amt != Tran Tot Tax ))
And ( Match Fl = "Y" )
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
--------------------------------------------------------------------------------
OUT-BAL-TXBL FILEFLD, OTOFLDS
where ( Relation: Txcompany Exists
And Txcompany->Taxable Cntr = "Y"
And Tran Txbl Amt != Tran Tot Txbl
And Match Fl = "N" )
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 != Tran 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 ( Dropship Fl != "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-EXISTS OTOFLDS
where ( Relation: Purchorder 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-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
--------------------------------------------------------------------------------
POD-AVAIL FILEFLD
where ( Match Status = Zeroes
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
--------------------------------------------------------------------------------
PONUM-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
--------------------------------------------------------------------------------
POOL-1 OTOFLDS
where ( Apvenmast->Pool Option = 1
Or ( Apvenmast->Pool Option = Zeroes
And Macompany->Pool Option = 1 ))
Is Used In No Indexes
Is Used In Rel - MAPOOL1
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
--------------------------------------------------------------------------------
POOL-2 OTOFLDS
where (( Apvenmast->Pool Option = 2 )
Or (( Apvenmast->Pool Option = Zeroes )
And ( Macompany->Pool Option = 2 )))
Is Used In No Indexes
Is Used In Rel - MAPOOL2
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
--------------------------------------------------------------------------------
POOL-3 OTOFLDS
where (( Apvenmast->Pool Option = 3 )
Or (( Apvenmast->Pool Option = Zeroes )
And ( Macompany->Pool Option = 3 )))
Is Used In No Indexes
Is Used In Rel - MAPOOL3
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
--------------------------------------------------------------------------------
PREPAY-CREDIT 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 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
Condition Type
--------------------------------------------------------------------------------
SERVICE-INV FILEFLD
where ( 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 No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TAXCNTRL FILEFLD, OTOFLDS
where ( Company = Txcompany->Company
And Txcompany->Taxable Cntr = "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
--------------------------------------------------------------------------------
USER-FIELD-ENT OTOFLDS
where ( Relation: Invusrfld 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
--------------------------------------------------------------------------------
VENAGRMT-EXIST OTOFLDS
where (( Relation: Povagrmthd Exists ))
Is Used In No Indexes
Is Used In Rel - POVAGRMTHD
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
--------------------------------------------------------------------------------
VOUCHER-INV FILEFLD
where ( Voucher 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 No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
|
