|
|
CONDITION REPORT
----------------
FILE - CUSTORDER
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
--------------------------------------------------------------------------------
BILL-TO-ENTERD FILEFLD
where ( Bill To != Zeroes )
Is Used In No Indexes
Is Used In Rel - BILLTO
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ORDER-ZERO
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CARRIER 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
--------------------------------------------------------------------------------
COD-ORDER FILEFLD
where ( Cod 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
--------------------------------------------------------------------------------
COD-TERM OTOFLDS
where ( Terms->Proc Indic = "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 1 Rule
Condition Type
--------------------------------------------------------------------------------
COMMENTS-EXIST OTOFLDS
where ( Relation: Hdr Comments Exists
Or Relation: Trl Comments 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
--------------------------------------------------------------------------------
CORSET4 FILEFLD
where ( 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
--------------------------------------------------------------------------------
CORSET6 FILEFLD
where ( Hold Code != Spaces )
Is Used In Index - CORSET6
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
--------------------------------------------------------------------------------
CUST-PO FILEFLD
where ( Cust Po 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
Condition Type
--------------------------------------------------------------------------------
FREIGHT-CODE FILEFLD
where ( Freight Code != Spaces )
Is Used In No Indexes
Is Used In Rel - OEFRTCODE
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
--------------------------------------------------------------------------------
FUTURE-ORDER FILEFLD
where ( Future 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
--------------------------------------------------------------------------------
HDR-COMM-EXIST OTOFLDS
where ( Relation: Hdr Comments 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
--------------------------------------------------------------------------------
HDR-COMMENTS OTOFLDS
where ( Relation: Hdr Comments 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
--------------------------------------------------------------------------------
HOLDCODES 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 CndFld - HOLD-LIT
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ICLOCATION FILEFLD
where ( Inv Location != Spaces )
Is Used In No Indexes
Is Used In Rel - ICLOCATION
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
--------------------------------------------------------------------------------
INVOICES-EXIST OTOFLDS
where ( Relation: Oeinvoice 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
--------------------------------------------------------------------------------
METHOD FILEFLD
where ( Method != Spaces )
Is Used In No Indexes
Is Used In Rel - OEMETHOD
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 ( Curelat->Mult Div = "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 - ACTUAL-FR-CH-B
- DISC-BASE
- DISC-TKN-BASE
- DISCNTBL-BASE
- FRT-CHG-BASE
- MISC-TTL-BASE
- ORD-DISC-BASE
- PMNT-BASE
- TAX-TTL-BASE
- TXBL-TTL-BASE
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
MULTI-CURRENCY OTOFLDS
where ( Oecompany->Multi Curr 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
--------------------------------------------------------------------------------
NO-CURR-OVR OTOFLDS
where ( Operator->Curr Ovr 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
--------------------------------------------------------------------------------
NO-OVERRIDE OTOFLDS
where ( Custdesc->Ovr Addr 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
--------------------------------------------------------------------------------
NO-RATE-OVR OTOFLDS
where ( Operator->Rate Ovr 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
--------------------------------------------------------------------------------
NON-POD-ORDER FILEFLD
where ( Pod Req Fl = 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 1 Rule
Condition Type
--------------------------------------------------------------------------------
NOT-BASE-CURR FILEFLD, OTOFLDS
where ( Currency Code != Oecompany->Currency Code )
Is Used In No Indexes
Is Used In Rel - CUCODES
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 FILEFLD, OTOFLDS
where ( 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
--------------------------------------------------------------------------------
NOT-SA-UPDATED FILEFLD
where ( Sa Updated Fl != "Y"
And Status > 1 )
Is Used In Index - CORSET10
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
--------------------------------------------------------------------------------
OEREASON FILEFLD
where ( Cxl Reason != 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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
OPEN FILEFLD
where ( 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 No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ORD-TYPE-CHNGD FILEFLD
where ( Old(Order Type) != Order 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
--------------------------------------------------------------------------------
ORDER-DISCOUNT FILEFLD
where ( Ord Disc Code > Spaces )
Is Used In No Indexes
Is Used In Rel - OEORDDISC
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
--------------------------------------------------------------------------------
PACKING-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 1 Rule
Condition Type
--------------------------------------------------------------------------------
PK-LIST-PRNTED FILEFLD
where ( Pk Prt 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
--------------------------------------------------------------------------------
PKLIST-NT-PRTD FILEFLD
where ( Pk Prt 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
--------------------------------------------------------------------------------
POSRC-EXISTS OTOFLDS
where ( Relation: Polinesrc 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
--------------------------------------------------------------------------------
PROC-IND-SAME OTOFLDS
where ( Old(Terms->Proc Indic) = Terms->Proc Indic )
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
--------------------------------------------------------------------------------
QUOTE FILEFLD
where ( Sls Quote 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
--------------------------------------------------------------------------------
SALESMAN2 FILEFLD
where ( Salesman 2 != Zeroes )
Is Used In No Indexes
Is Used In Rel - SALESMAN2
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 FILEFLD
where ( 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
--------------------------------------------------------------------------------
SHIPTO-ENTERED FILEFLD
where ( Ship To != 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
--------------------------------------------------------------------------------
SHPMNT-CREATED 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 1 Rule
Condition Type
--------------------------------------------------------------------------------
SOURCE FILEFLD
where ( Order Source != Spaces )
Is Used In No Indexes
Is Used In Rel - OESOURCE
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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
TERITORY FILEFLD
where ( Territory != Spaces )
Is Used In No Indexes
Is Used In Rel - TERITORY
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
--------------------------------------------------------------------------------
TERMS-EXIST FILEFLD
where ( Terms Cd != 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 - TERM-2
- TERMS-1
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TRL-COMM-EXIST OTOFLDS
where ( Relation: Trl Comments 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
--------------------------------------------------------------------------------
UNRELEASED FILEFLD
where ( 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
|
