|
|
CONDITION REPORT
----------------
FILE - COLINE
Condition Type
--------------------------------------------------------------------------------
AUDIT-EXISTS OTOFLDS
where ( Relation: Oeaudit 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
--------------------------------------------------------------------------------
BACKORDERED OTOFLDS
where ( Whdemand->Backord Qty != 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 - BO-FL
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CLOSED FILEFLD
where ( 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
--------------------------------------------------------------------------------
COLSET2 FILEFLD
where ( Status = 2 )
Is Used In Index - COLSET2
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
--------------------------------------------------------------------------------
COLSET4 FILEFLD
where ( Price Status = "A" )
Is Used In Index - COLSET4
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
--------------------------------------------------------------------------------
COLSET6 FILEFLD
where ( Hold Code != Spaces )
Is Used In Index - COLSET6
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
--------------------------------------------------------------------------------
COLSET7 FILEFLD
where ( Status < 3 )
Is Used In Index - COLSET7
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
--------------------------------------------------------------------------------
COMMENTS-EXIST OTOFLDS
where ( Relation: Oeordcmnt Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - COMM-LIT
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
COMMITTED FILEFLD
where ( Atn Obj Id != Zeroes )
Is Used In Index - COLSET5
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-COST FILEFLD
where ( Atn Obj Id C != Zeroes )
Is Used In Index - COLSET8
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
--------------------------------------------------------------------------------
CONTRACT FILEFLD
where ( Contract Nbr != Spaces )
Is Used In No Indexes
Is Used In Rel - CONTRACT
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 FILEFLD
where ( Status = 2
And Create Po = "Y"
And Order Qty > Shipped Qty )
Is Used In Index - COLSET12
- COLSET9
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-YES FILEFLD
where ( 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
--------------------------------------------------------------------------------
CWT-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 CndFld - DISP-ALLOCATED
- DISP-BACKORD
- DISP-IN-PROC
- DISP-PRINTED
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CXL-OPR-ENTERD FILEFLD
where ( Cxl Opr != Spaces )
Is Used In No Indexes
Is Used In Rel - CXL-OPERATOR
- 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
--------------------------------------------------------------------------------
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 1 Rule
Condition Type
--------------------------------------------------------------------------------
EDIT FILEFLD, STATE
where ( Status = Zeroes )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In State - EDIT
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HAS-COMPANION OTOFLDS
where ( Relation: Itemcompanion 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
--------------------------------------------------------------------------------
HAS-ITEMSUB OTOFLDS
where ( Relation: Itemsub 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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
INVENTORIED 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 - PROJ-COST
Is Used In No AvfFlds
Is Used In 1 Rule
Condition Type
--------------------------------------------------------------------------------
ITEMLOCATION FILEFLD
where ( Inv Loc != Spaces
And Line Type = "I" )
Is Used In No Indexes
Is Used In Rel - ITEMLOCATION
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
--------------------------------------------------------------------------------
ITEMMAST FILEFLD
where ( Line Type != "X" )
Is Used In No Indexes
Is Used In Rel - ITEMMAST
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
--------------------------------------------------------------------------------
KITITEM OTOFLDS
where ( Kititem 2->Make Cd = "S" )
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
--------------------------------------------------------------------------------
LINE-ON-HOLD FILEFLD
where ( Hold Code != Spaces )
Is Used In No Indexes
Is Used In Rel - HOLDCODES
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-SHIPPED FILEFLD
where ( Last Ship Nbr > 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
--------------------------------------------------------------------------------
LOC-PRICING OTOFLDS
where ( Oecompany->Price Loc 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 - PRICE-LOC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
MADE-TO-ORDER FILEFLD
where ( Kit Fl = "O" )
Is Used In No Indexes
Is Used In Rel - COMPONENT
- KITITEM
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
--------------------------------------------------------------------------------
MADE-TO-STOCK FILEFLD
where ( Kit Fl != "O" )
Is Used In No Indexes
Is Used In Rel - KITITEM-2
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
--------------------------------------------------------------------------------
MK-TO-ORD-KIT FILEFLD
where ( 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
--------------------------------------------------------------------------------
MSDS-REQUIRED FILEFLD
where ( Msds Req Fl = "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
--------------------------------------------------------------------------------
MULT-SPR-UOM FILEFLD
where ( Mult Spr Fl = "Y" )
Is Used In No Indexes
Is Used In Rel - COLINEUOM
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
--------------------------------------------------------------------------------
MULTI-CURRENCY OTOFLDS
where ( Oecompany->Multi Curr Fl = "Y"
And Custorder->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
--------------------------------------------------------------------------------
MULTIPLY OTOFLDS
where ( Custorder->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 CndFld - ADD-DISC-BASE
- DISC-AMT-BASE
- DISC-TKN-BASE
- TAXABLE-BASE
- TAXABLE-BASE
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
NON-CWT-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
--------------------------------------------------------------------------------
NORMAL-LINE FILEFLD, OTOFLDS
where ( Create Po = "N"
And Oecompany->Route Stop 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
--------------------------------------------------------------------------------
NOT-IN-BASE OTOFLDS
where ( Custorder->Currency Code != Oecompany->Currency Code )
Is Used In No Indexes
Is Used In Rel - CURELAT
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-SPEC-ORDER FILEFLD
where ( Line Type != "X" )
Is Used In No Indexes
Is Used In Rel - MAJORCL
- MINORCL
- OESLSACCT
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
--------------------------------------------------------------------------------
ONE-CURRENCY OTOFLDS
where ( Oecompany->Multi Curr 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 1 Rule
Condition Type
--------------------------------------------------------------------------------
ONE-SPR-UOM FILEFLD
where ( Mult Spr 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
--------------------------------------------------------------------------------
OPEN FILEFLD
where ( Status > 1
And 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 No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
OVERRIDE-TXBL FILEFLD
where ( Ovr Taxable != 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 - TAXABLE-BASE
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
PACK-FB-REQD OTOFLDS
where ( Ordertype->Pack 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
--------------------------------------------------------------------------------
PICK-FB-REQD OTOFLDS
where ( Ordertype->Pick 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
--------------------------------------------------------------------------------
PO-DROPSHIP FILEFLD
where ( Create Po = "Y"
And Dropship Fl = "Y"
And Status = 2
And Order Qty > Invoice Qty )
Is Used In Index - COLSET11
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-VEND-ENTRD FILEFLD
where ( Vendor != Spaces )
Is Used In No Indexes
Is Used In Rel - PO-VENDOR
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
--------------------------------------------------------------------------------
PRICE-DT-ENTRD OTOFLDS
where ( Custorder->Price Date != 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 1 Rule
Condition Type
--------------------------------------------------------------------------------
PROMOTION FILEFLD
where ( Promotion > Spaces )
Is Used In No Indexes
Is Used In Rel - PROMOTION
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
--------------------------------------------------------------------------------
READY-FOR-PO FILEFLD, OTOFLDS
where ( Status = 2
And Hold Code = Spaces
And Custorder->Hold Code = Spaces
And Create Po = "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 - DER-ORIGIN-CD
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
--------------------------------------------------------------------------------
ROUTE-ASSIGNED FILEFLD
where ( Route > 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 1 Rule
Condition Type
--------------------------------------------------------------------------------
ROUTE-CREATED FILEFLD
where ( Rte Create 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
--------------------------------------------------------------------------------
ROUTE-ENTERED FILEFLD
where ( Route != 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
--------------------------------------------------------------------------------
ROUTE-PROCESS FILEFLD, OTOFLDS
where ( Oecompany->Route Stop Fl = "Y"
And Create Po = "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
--------------------------------------------------------------------------------
SALESREP2 FILEFLD
where ( Salesman 2 != Zeroes )
Is Used In No Indexes
Is Used In Rel - 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
--------------------------------------------------------------------------------
SHIP-ONLY OTOFLDS
where ( Ordertype->Pick Fl = "N"
And Ordertype->Pack 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
--------------------------------------------------------------------------------
SHIPMENT-EXIST OTOFLDS
where ( Relation: Whshipment 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
--------------------------------------------------------------------------------
SHIPTO-ENTERED FILEFLD
where ( Cust Ship To != Zeroes )
Is Used In No Indexes
Is Used In Rel - SHIPTO
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
--------------------------------------------------------------------------------
SPEC-NON-STOCK FILEFLD
where ( Line Type = "N"
Or Line Type = "X" )
Is Used In No Indexes
Is Used In Rel - COGS-OFFSET
- SALES-ACCT
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 No CndFlds
Is Used In No AvfFlds
Is Used In 1 Rule
Condition Type
--------------------------------------------------------------------------------
STD-COST-COMP OTOFLDS
where ( Iccompany->Cost Method = "STD" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - PROJ-COST
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TAX-CODE FILEFLD
where ( Tax Code > Spaces )
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
--------------------------------------------------------------------------------
TAXABLE FILEFLD
where ( Tax Exempt Cd = "T" )
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
--------------------------------------------------------------------------------
VENDOR-ENTERED FILEFLD
where ( Carrier != Spaces )
Is Used In No Indexes
Is Used In Rel - APCOMPANY
- APVENMAST
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
--------------------------------------------------------------------------------
WHDEMAND OTOFLDS
where ( Relation: Whdemand Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - DISP-ALLOCATED
- DISP-BACKORD
- DISP-IN-PROC
- DISP-PRINTED
Is Used In No AvfFlds
Is Used In No Rules
|
