/****** Object:  Table [dbo].[$ndo$dbconfig]    Script Date: 11/13/2007 14:07:43 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[$ndo$dbconfig]') AND type in (N'U'))
DROP TABLE [dbo].[$ndo$dbconfig]
GO
CREATE TABLE [$ndo$dbconfig]
( config varchar(512) Not Null )
GO
Grant SELECT ON [$ndo$dbconfig] TO public
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="Document No.","Posting Date";Search Method="";Index=5' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="Item No.","Applied Entry to Adjust";Search Method="";Index=7' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="Item No.","Entry Type","Variant Code","Drop Shipment","Global Dimension 1 Code","Global Dimension 2 Code","Location Code","Posting Date";Search Method="";Index=14' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="Item No.","Entry Type","Variant Code","Drop Shipment","Location Code","Posting Date";Search Method="";Index=14' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="Item No.","Location Code","Open","Variant Code","Unit of Measure Code","Lot No.","Serial No.";Search Method="";Index=3' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="Item No.","Open","Variant Code","Positive","Location Code","Posting Date","Expiration Date","Lot No.","Serial No.";Search Method="";Index=3' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="Item No.","Positive","Location Code","Variant Code";Search Method="";Index=14' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="Item No.","Posting Date","Variant Code","Location Code","Entry Type";Search Method="";Index=11' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="Item No.","Variant Code","Open","Positive","Location Code","Posting Date";Search Method="";Index=3' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="Location Code","Item No.","Variant Code","Entry Type","Posting Date","RetLife Cycle Phase","Positive";Search Method="";Index=17' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="RetRetail Customer No.","Posting Date";Search Method="";Index=16' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Ledger Entry";Key="Source Type","Source No.","Item No.","Variant Code","Posting Date";Search Method="";Index=15' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="Item Application Entry";Key="Inbound Item Entry No.","Item Ledger Entry No.","Outbound Item Entry No.","Cost Application";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Application Entry";Key="Inbound Item Entry No.","Outbound Item Entry No.","Cost Application";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Application Entry";Key="Item Ledger Entry No.","Output Completely Invd. Date";Search Method="";Index=5' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Application Entry";Key="Outbound Item Entry No.","Item Ledger Entry No.","Cost Application","Transferred-from Entry No.";Search Method="";Index=2' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Item Application Entry";Key="Transferred-from Entry No.","Cost Application";Search Method="";Index=3' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Document No.","Posting Date";Search Method="";Index=4' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Item Charge No.","Inventory Posting Group","Item No.";Search Method="";Index=17' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Item Ledger Entry No.","Document No.";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Item Ledger Entry No.","Entry Type";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Item Ledger Entry No.,Expected Cost";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Item Ledger Entry Type","Posting Date","Location Code","RetMerchandise Code";Search Method="";Index=17' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Item No.","Posting Date","Item Ledger Entry Type","Entry Type","Item Charge No.","Location Code","Variant Code";Search Method="";Index=17' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Item No.","Valuation Date","Location Code","Variant Code";Search Method="";Index=16' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Item No.","Variant Code","Item Ledger Entry Type","Cost Amount (Actual)","Expected Cost","Source No.","PfsOrder Type Code","Salespers./Purch. Code","PfsSeason","PfsBrand","PfsProduct Group Code";Search Method="";Index=17' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Item No.","Variant Code","Location Code","Posting Date","Item Ledger Entry Type","RetLife Cycle Phase";Search Method="";Index=16' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="RetRetail Customer No.","Posting Date";Search Method="";Index=15' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Source Type","Source No.","Item Ledger Entry Type","Item No.","Variant Code","Posting Date";Search Method="";Index=17' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Value Entry";Key="Source Type","Source No.","Item No.","Variant Code","Posting Date","Entry Type";Search Method="";Index=16' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetSeries Location Analysis";Key="Item No.","Vertical Component Code","Sorting";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSeries Location Analysis";Key="SortDecimal","SortCode","SortNumber";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSeries Location Analysis";Key="Sorting";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSeries Location Analysis";Key="Transfer-Level Code","Transfer-from Location","Location Code";Search Method="";Index=2' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSeries Location Analysis";Key="Transfer-Level Code","Transfer-from Location";Search Method="";Index=2' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSeries Location Analysis";Key="Transfer-Level Code";Search Method="";Index=2' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetDistr. Worksheet Location";Key="Worksheet Template Name","Name","Distribution Location Code","Line No.","Sorting";Search Method="";Index=0' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetDistr. Worksheet DistrLine";Key="Worksheet Template Name","Name","Distribution Location Code","Matrix Line No.";Search Method="";Index=1' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetPre Alloc. Variant";Key="Distribution Location Code","Horz Component Group","Horizontal Component Code","Product Group Code","Brand","Model Code","Item No.";Search Method="";Index=3' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetPre Alloc. Variant";Key="Distribution Location Code","Vertical Component Code","Product Group Code","Brand","Model Code";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetPre Alloc. Variant";Key="Item No.","Distribution Location Code","Vertical Component Code","Unit of Measure Code","Sorting";Search Method="";Index=0' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetPre Alloc. Variant Loc.";Key="Distribution Location Code","Horz Component Group","Horizontal Component Code","To Location Code","Product Group Code","Brand","Model Code","Item No.","Vertical Component Code";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetPre Alloc. Variant Loc.";Key="Item No.","Distribution Location Code","To Location Code","Vertical Component Code","Horizontal Component Code";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetPre Alloc. Variant Loc.";Key="Item No.","Distribution Location Code","Vertical Component Code","Horizontal Component Code","To Location Code";Search Method="";Index=2' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetPre Alloc. Variant Loc.";Key="Item No.","Distribution Location Code","Vertical Component Code","To Location Code","Horizontal Component Code";Search Method="";Index=2' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetPre Alloc. Location";Key="Item No.","Distribution Location Code","Vertical Component Code","To Location Code";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetPre Alloc. Location";Key="Item No.","Distribution Location Code","Vertical Component Code","Sorting";Search Method="";Index=0' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetRPL - Setup Header";Key="Item No.","Starting Date","Vertical Component Code","Item Life Cycle Phase";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetRPL - Setup Header";Key="Item No.","Starting Date","Sorting","Item Life Cycle Phase";Search Method="";Index=0' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetRPL - Setup Line";Key="Item No.","Starting Date","Vertical Component Code","Item Life Cycle Phase","Grouping","Location Group Code","Horizontal Component Code";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetRPL - Setup Line";Key="Location Group Code","Sorting";Search Method="";Index=0' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetSTS - Line";Key="Document No.","Line No.";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSTS - Line";Key="Document No.","Transfer Order No. to Post","Store Shipment No.","Item No.","Variant Code","Unit of Measure Code";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSTS - Line";Key="Document No.","Transfer Order No.","Store Shipment No.","Item No.","Sorting";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSTS - Line";Key="Document No.","Transfer Order No.","Store Shipment No.","Item No.","Variant Code","Unit of Measure Code","Scanned Barcode";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSTS - Line";Key="Transfer Order No.";Search Method="";Index=4' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetPOS Session Header";Key="Document Type","No.";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetPOS Session Header";Key="Intercompany Reference No.";Search Method="";Index=3' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetPOS Session Header";Key="Location Code","POS Code","Reference Code","Posting Date";Search Method="";Index=2' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetPOS Session Header";Key="Location Code","Reference Code";Search Method="";Index=2' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetPOS Session Line";Key="Document Type","Document No.","Line No.";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetPOS Session Line";Key="Payment Method Code","Currency Code";Search Method="";Index=1' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetRetail Customer Card";Key="Retail Customer No.","Owner Contact No.";Search Method="";Index=1' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="RetSTR - Line";Key="Document No.","Line No.";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSTR - Line";Key="Document No.","Store Request No.","Item No.","Sorting";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSTR - Line";Key="Document No.","Store Request No.","Item No.","Variant Code","Unit of Measure Code","Scanned Barcode";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="RetSTR - Line";Key="Document No.","Store Request No.","Item No.","Variant Code","Unit of Measure Code";Search Method="";Index=1' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="Sales Price";Key="Item No.","RetGrouping","RetClassification Code","RetLocationgroup Code","Starting Date","Variant Code","Minimum Quantity","Unit of Measure Code","Currency Code";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Sales Price";Key="Item No.","RetVertical Component";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Sales Price";Key="Item No.","Sales Type","Sales Code","Starting Date","Currency Code","RetMatrix Variant Code","Variant Code","Unit of Measure Code","Minimum Quantity";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Sales Price";Key="Item No.","Sales Type","Sales Code","Starting Date","Currency Code","Unit of Measure Code","Minimum Quantity","PfsSorting";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Sales Price";Key="Item No.","Sales Type","Sales Code","Starting Date","Currency Code","Variant Code","Unit of Measure Code","Minimum Quantity";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Sales Price";Key="RetPrice Scope","RetPrice Type","Item No.","Starting Date","Ending Date","Currency Code","Unit of Measure Code","Sales Code","Minimum Quantity","Variant Code";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Sales Price";Key="RetPrice Scope","Sales Type","RetPrice Type";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Sales Price";Key="RetPrice Type","RetPrice Change No.";Search Method="";Index=4' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Sales Price";Key="RetUpdate Status","RetIdentifier";Search Method="";Index=5' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Sales Price";Key="Sales Type","Item No.","Variant Code","Sales Code","Starting Date","Currency Code","Unit of Measure Code","Minimum Quantity";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Sales Price";Key="Sales Type","Sales Code","Item No.","Starting Date","Currency Code","Variant Code","Unit of Measure Code","Minimum Quantity";Search Method="";Index=1' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Activity Type","No.","Destination Type","Destination No.","Action Type","Bin Code";Search Method="";Index=8' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Activity Type","No.","Line No.";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Activity Type","No.","Location Code","Destination Type","Destination No.","Action Type","Zone Code","Bin Code","Item No.","PfsVertical Component","PfsSorting";Search Method="";Index=4' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Activity Type","No.","Location Code","Destination Type","Destination No.","Item No.","PfsVertical Component","Bin Code","PfsSorting";Search Method="";Index=4' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Activity Type","No.","Location Code","Destination Type","Destination No.","PfsBrand","PfsModel Code","Item No.","PfsVertical Component","Bin Code","PfsSorting";Search Method="";Index=4' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Activity Type","No.","Location Code","Destination Type","Destination No.","RetProduct Group Code","Item No.","PfsVertical Component","Bin Code","PfsSorting";Search Method="";Index=4' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Activity Type","No.","Location Code","Item No.","PfsVertical Component","Bin Code","Destination Type","Destination No.","PfsSorting";Search Method="";Index=4' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Activity Type","No.","Location Code","PfsBrand","PfsModel Code","Item No.","PfsVertical Component","Bin Code","Destination Type","Destination No.","PfsSorting";Search Method="";Index=4' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Activity Type","No.","Location Code","RetProduct Group Code","Item No.","PfsVertical Component","Bin Code","Destination Type","Destination No.","PfsSorting";Search Method="";Index=4' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Activity Type","No.","Location Code","Source Document","Source No.","Action Type","Zone Code";Search Method="";Index=4' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Item No.","Bin Code","Location Code","Action Type","Variant Code","Unit of Measure Code","Breakbulk No.","Activity Type","Lot No.","Serial No.";Search Method="";Index=14' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Item No.","Location Code","Activity Type","Bin Type Code","Unit of Measure Code","Variant Code","Breakbulk No.","Action Type","Lot No.","Serial No.";Search Method="";Index=14' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Source No.","Source Line No.","Source Subline No.","Serial No.","Lot No.";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Source Type","Source Subtype","Source No.","Source Line No.","Source Subline No.","Unit of Measure Code","Action Type","Breakbulk No.","Original Breakbulk";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Activity Line";Key="Whse. Document No.","Whse. Document Type","Activity Type","Whse. Document Line No.","Action Type","Unit of Measure Code","Original Breakbulk","Breakbulk No.","Lot No.","Serial No.";Search Method="";Index=12' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Line";Key="Derived From Line No.","Item No.","Variant Code","Shipment Date";Search Method="";Index=6' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Line";Key="Document No.","Derived From Line No.","PfsMatrix Line No.","PfsSorting";Search Method="";Index=9' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Line";Key="Document No.","Line No.";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Line";Key="Document No.","PfsMatrix Line No.","Derived From Line No.","PfsSorting";Search Method="";Index=9' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Line";Key="Item No.","Variant Code";Search Method="";Index=6' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Line";Key="Item No.";Search Method="";Index=6' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Line";Key="PfsTraffic Code","Item No.";Search Method="";Index=5' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Line";Key="RetDistribution Location Code","Derived From Line No.","Item No.","Variant Code","Transfer-to Code","Shipment Date";Search Method="";Index=6' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Line";Key="RetUpdate Status","RetIdentifier";Search Method="";Index=13' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Line";Key="Transfer-to Code","Derived From Line No.","Item No.","PfsVertical Component","Variant Code","Receipt Date";Search Method="";Index=1' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Line";Key="Transfer-to Code","Transfer-from Code","Derived From Line No.","Item No.","PfsVertical Component","PfsHorizontal Component","Unit of Measure Code";Search Method="";Index=11' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Entry";Key="Entry No.";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Entry";Key="Item No.","Bin Code","Location Code","Variant Code","Unit of Measure Code","Lot No.","Serial No.","Entry Type","Registering Date";Search Method="";Index=3' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Entry";Key="Item No.","Bin Code","Location Code","Variant Code","Unit of Measure Code","Lot No.","Serial No.","Entry Type";Search Method="";Index=3' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Warehouse Entry";Key="Item No.","Location Code","Variant Code","Bin Type Code","Unit of Measure Code","Lot No.","Serial No.";Search Method="";Index=3' as config
GO
INSERT INTO [$ndo$dbconfig]
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Shipment Line";Key="Document No.","Line No.";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Shipment Line";Key="RetStore Shipment No.";Search Method="";Index=0' as config
UNION
      SELECT 'IndexHint=Yes;Company=;Table="Transfer Shipment Line";Key="Transfer-to Code","Shipment Date","Transfer-from Code","Item No.","PfsSorting","Variant Code";Search Method="";Index=6' as config
GO
Select * From [$ndo$dbconfig]
GO