|
|
CONDITION REPORT
----------------
FILE - WHDEMAND
Condition Type
--------------------------------------------------------------------------------
BIN-TRACKED OTOFLDS
where ( Itemmast->Lot Track Fl = "N"
And Itemloc->Bin Track Fl = "Y"
And Itemmast->Ser Track Fl != "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
--------------------------------------------------------------------------------
CASE-CART FILEFLD
where ( System Cd = "CX" )
Is Used In No Indexes
Is Used In Rel - CASEHEADER
- CASELINE
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ORIGIN
- SRC-ITEM-DESC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CTW OTOFLDS
where ( Itemmast->Ctw Code = "A"
Or Itemmast->Ctw Code = "R" )
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
- DISP-QUANTITY
- DISP-SHIPPED
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CUSTOMER-ORDER FILEFLD
where ( System Cd = "OE" )
Is Used In No Indexes
Is Used In Rel - COLINE
- CUSTORDER
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ORIGIN
- SRC-ITEM-DESC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
DEMAND FILEFLD
where (( Record Type = "D" ))
Is Used In Index - WDMSET1
- WDMSET9
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
--------------------------------------------------------------------------------
DETAIL-REQ FILEFLD
where (( Record Type = "D" )
And ( Line Type = "I" )
And ( Detail Req = "Y" ))
Is Used In Index - WDMSET4
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
--------------------------------------------------------------------------------
FG-TO-ALLOC FILEFLD
where (( Record Type = "D"
And Allocable Fl = "Y"
And Backord Qty > Zeroes
And Kit Fl = "S"
And Status = 1
And Obj Id Dmnd = Zeroes ))
Is Used In Index - WDMSET6
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
--------------------------------------------------------------------------------
GATHEREDMND FILEFLD
where (( Obj Id Dmnd > Zeroes
And Obj Id Dmnd < 999999999999 ))
Is Used In Index - WDMSET8
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-PO-CODE FILEFLD, OTOFLDS
where ( System Cd = "PO"
And Record Type = "S"
And Poline->Po 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 CndFld - DISP-DOC-NBR
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 - ICLOCATION
- ITEMLOC
- ITEMLOCS
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
--------------------------------------------------------------------------------
IS-RELEASE FILEFLD, OTOFLDS
where ( System Cd = "PO"
And Record Type = "S"
And Poline->Po Release != 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 - DISP-DOC-NBR
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
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SRC-ITEM-DESC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
LOT-TRACKED OTOFLDS
where ( Itemmast->Lot Track 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 FILEFLD
where ( Record Type = "S"
And System Cd = "PO" )
Is Used In No Indexes
Is Used In Rel - APCOMPANY
- APVENMAST
- POLINE
Is Used In No SubType
Is Used In No States
Is Used In CndFld - DISP-DOC-NBR
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
READ-TO-ALLOC FILEFLD
where (( Record Type = "D" )
And ( Allocable Fl = "Y" )
And ( Component Seq = Zeroes )
And ( Quantity > Printed Qty ))
Is Used In Index - WDMSET2
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
--------------------------------------------------------------------------------
REQUISITION FILEFLD
where ( System Cd = "RQ" )
Is Used In No Indexes
Is Used In Rel - REQHEADER
- REQLINE
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ORIGIN
- SRC-ITEM-DESC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
RETURN FILEFLD
where ( System Cd = "RT" )
Is Used In No Indexes
Is Used In Rel - RETURNHDR
- RETURNLINE
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
--------------------------------------------------------------------------------
SERIAL-TRACKED OTOFLDS
where ( Itemmast->Ser Track Fl = "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
--------------------------------------------------------------------------------
SHIP-CREATE FILEFLD
where (( Record Type = "D" )
And ( Status = 1 )
And ( Component Seq = Zeroes )
And ( Alloc Qty > Printed Qty )
And ( System Cd != "WO" ))
Is Used In Index - WDMSET3
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
--------------------------------------------------------------------------------
SUPPLY FILEFLD
where ( Record Type = "S" )
Is Used In Index - WDMSET7
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
--------------------------------------------------------------------------------
UOM-TRACKED FILEFLD, OTOFLDS
where ( Itemmast->Lot Track Fl = "N"
And Itemmast->Ser Track Fl != "R"
And Itemloc->Bin Track Fl = "N"
And Detail Req = "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
|
