|
|
CONDITION REPORT
----------------
FILE - OEINVCLINE
Condition Type
--------------------------------------------------------------------------------
AR-GL-UPDATED OTOFLDS
where ( Oeinvoice->Status = 9 )
Is Used In No Indexes
Is Used In Rel - OEDIST
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-EXISTS OTOFLDS
where ( Oeinvoice->Batch Nbr != Zeroes )
Is Used In No Indexes
Is Used In Rel - OEINVHDR
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In 3 Rules
Condition Type
--------------------------------------------------------------------------------
CATCH-WT-ITEM OTOFLDS
where ( Itemmast->Ctw Code != "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
--------------------------------------------------------------------------------
COMMITTED FILEFLD
where ( Atn Obj Id != Zeroes )
Is Used In Index - OILSET3
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
--------------------------------------------------------------------------------
COMMITTED-C FILEFLD
where ( Atn Obj Id C != Zeroes )
Is Used In Index - OILSET4
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
--------------------------------------------------------------------------------
CREATE-PO OTOFLDS
where ( Coline->Create Po = "Y" )
Is Used In No Indexes
Is Used In Rel - POLINESRC
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
--------------------------------------------------------------------------------
D1-ACCOUNT FILEFLD
where ( D1 Acct Unit != Spaces
Or D1 Account != Zeroes
Or D1 Sub Acct != 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
--------------------------------------------------------------------------------
D2-ACCOUNT FILEFLD
where ( D2 Acct Unit != Spaces
Or D2 Account != Zeroes
Or D2 Sub Acct != 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
--------------------------------------------------------------------------------
D3-ACCOUNT FILEFLD
where ( D3 Acct Unit != Spaces
Or D3 Account != Zeroes
Or D3 Sub Acct != 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
--------------------------------------------------------------------------------
DESC-CHANGED FILEFLD
where ( Old(Description) != Description )
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 1 Rule
Condition Type
--------------------------------------------------------------------------------
DISC-CODE-CHGD FILEFLD
where ( Old(Disc Code) != Disc Code )
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 1 Rule
Condition Type
--------------------------------------------------------------------------------
DISCOUNTABLE FILEFLD
where ( Ord Disc 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
--------------------------------------------------------------------------------
ICCOMPANY FILEFLD
where ( Line Type != "X" )
Is Used In No Indexes
Is Used In Rel - ICCOMPANY
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
--------------------------------------------------------------------------------
INVENTORY-ITEM FILEFLD
where ( Line Type = "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
--------------------------------------------------------------------------------
ITEM-CHANGED FILEFLD
where ( Old(Item) != Item )
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 1 Rule
Condition Type
--------------------------------------------------------------------------------
ITEMLOC FILEFLD
where ( Line Type = "I" )
Is Used In No Indexes
Is Used In Rel - ICCATEGORY
- ITEMLOC
Is Used In No SubType
Is Used In No States
Is Used In CndFld - C-ACCOUNT
- C-ACCT-UNIT
- C-SUB-ACCT
- I-ACCOUNT
- I-ACCT-UNIT
- I-SUB-ACCT
- S-ACCOUNT
- S-ACCT-UNIT
- S-SUB-ACCT
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ITEMMAST FILEFLD
where ( Line Type = "I"
Or Line Type = "N" )
Is Used In No Indexes
Is Used In Rel - ITEMMAST
- OESLSACCT
Is Used In No SubType
Is Used In No States
Is Used In CndFld - I-ACCOUNT
- I-ACCT-UNIT
- I-SUB-ACCT
Is Used In No AvfFlds
Is Used In 2 Rules
Condition Type
--------------------------------------------------------------------------------
LINE-TAX OTOFLDS
where ( Oecompany->Tax Print Cd = "D" )
Is Used In No Indexes
Is Used In Rel - LINE-TAX
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
--------------------------------------------------------------------------------
LINE-TYPE-CHGD FILEFLD
where ( Old(Line Type) != Line Type )
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 1 Rule
Condition Type
--------------------------------------------------------------------------------
MADE-TO-ORDER OTOFLDS
where ( Oeinvoice->Invc Source = "S"
And Coline->Kit Fl = "O" )
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-INVOICE OTOFLDS
where ( Oeinvoice->Invc Source = "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
--------------------------------------------------------------------------------
MULT-RATE OTOFLDS
where ( Oeinvoice->Curr Mudv = "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
--------------------------------------------------------------------------------
MULT-SPR-UOMS FILEFLD
where ( Mult Spr Fl = "Y" )
Is Used In No Indexes
Is Used In Rel - OEINVCUOM
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
--------------------------------------------------------------------------------
NO-CHARGE FILEFLD
where ( No Charge 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 1 Rule
Condition Type
--------------------------------------------------------------------------------
NON-CWT-ITEM FILEFLD, OTOFLDS
where (( Line Type != "X"
And Itemmast->Ctw Code = "N" )
Or ( Line Type = "X" ))
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
--------------------------------------------------------------------------------
NOT-IN-BASE OTOFLDS
where ( Oeinvoice->Currency Code != Oecompany->Currency Code )
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
--------------------------------------------------------------------------------
OILSET2 FILEFLD
where ( Price Status = "A" )
Is Used In Index - OILSET2
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
--------------------------------------------------------------------------------
OILSET3 FILEFLD
where ( Line Type = "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
--------------------------------------------------------------------------------
REASON-ENTERED FILEFLD
where ( Reason Code != Spaces )
Is Used In No Indexes
Is Used In Rel - OEREASON
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
--------------------------------------------------------------------------------
RECURRING-INVC OTOFLDS
where ( Oeinvoice->Recur Invoice != Spaces )
Is Used In No Indexes
Is Used In Rel - BLRICLINE
- BLRIMAST
- BLRIMLINE
- OECSLINE
- OEMASTSRVC
- OEMSLINE
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
--------------------------------------------------------------------------------
RETURN-INVC OTOFLDS
where ( Oeinvoice->Invc Source = "R" )
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
--------------------------------------------------------------------------------
RETURNS-EXIST OTOFLDS
where ( Relation: Returnline 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
--------------------------------------------------------------------------------
SALESMAN2 FILEFLD
where ( Salesman 2 != Zeroes )
Is Used In No Indexes
Is Used In Rel - SALESMAN2
- SALESREP2
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
--------------------------------------------------------------------------------
SPECIAL-ORDER FILEFLD
where ( Line Type = "X" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - C-ACCOUNT
- C-ACCT-UNIT
- C-SUB-ACCT
Is Used In No AvfFlds
Is Used In 1 Rule
Condition Type
--------------------------------------------------------------------------------
SYSTEM-INVOICE OTOFLDS
where ( Oeinvoice->Invc Source = "S" )
Is Used In No Indexes
Is Used In Rel - OESHIPMENT
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In 1 Rule
Condition Type
--------------------------------------------------------------------------------
TAXED FILEFLD
where ( Tax Code != Spaces
And Tax Exempt Cd = "T" )
Is Used In No Indexes
Is Used In Rel - TXTAXCODE
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
--------------------------------------------------------------------------------
UOM-REQUIRED OTOFLDS
where ( Oecompany->Uom Req 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 1 Rule
|
