SELECT IPF1.DocEntry AS 'Landed Costs Internal ID', IPF1.LineNum AS 'Row Number', IPF1.BaseType AS 'Base Document Type', IPF1.BaseEntry AS 'Base Document Internal ID', IPF1.ItemCode AS 'Item No.', IPF1.Dscription AS 'Item Description', IPF1.Quantity AS 'Quantity', IPF1.PriceFOB AS 'Base Doc. Price', IPF1.Currency AS 'Price Currency', IPF1.Rate AS 'Currency Price', IPF1.Custom AS 'Projected Customs', IPF1.CustomFC AS 'Projected Customs (FC)', IPF1.Cost AS 'Expenditure', IPF1.CostFC AS 'Freight (FC)', IPF1.PriceAtWH AS 'Whse Price', IPF1.PricAtWHFC AS 'Whse Price (FC)', IPF1.LineTotal AS 'Row Total', IPF1.TotalFrgn AS 'Row Total (FC)', IPF1.Volume AS 'Volume', IPF1.UnitCode AS 'Volume UoM', IPF1.Weight1 AS 'Weight 1', IPF1.UnitCode1 AS 'Unit of Weight 1', IPF1.Weight2 AS 'Weight 2', IPF1.UnitCode2 AS 'Unit of Weight 2', IPF1.CardCode AS 'Vendor Code', IPF1.Reference AS 'Reference', IPF1.OrigLine AS 'Base Line Number', IPF1.FactNoCust AS 'Factor Without Customs', IPF1.FacWthCust AS 'Factor with Customs', IPF1.PriceList AS 'Price List No.', IPF1.CostOH AS 'Cost Surcharge', IPF1.StockEval AS 'Use for Inventory Valuation', IPF1.UseBaseUn AS 'Inventory UoM', IPF1.BlockNum AS 'Block No.', IPF1.ImportLog AS 'Import Log', IPF1.WhsCode AS 'Warehouse Code', IPF1.OrigRow AS 'Original Row', IPF1.Locked AS 'Locked', IPF1.OrigWhs AS 'Original Warehouse', IPF1.ReleaseNum AS 'Release Number', IPF1.VarCosts AS 'Variant Costs', IPF1.ConstCosts AS 'Fixed Costs', IPF1.VarCostsFR AS 'Variant Costs (FC)', IPF1.CnstCostFR AS 'Fixed Costs (FC)', IPF1.UserCustom AS 'User Expected Custom', IPF1.UsrCusomFC AS 'User Expected Foreign Custom', IPF1.FobValue AS 'Base Doc. Value Row Total (LC)', IPF1.FobValueFC AS 'Base Doc. Value Row Total (FC)', IPF1.TtlExpndLC AS 'Allocated Unit Costs Row Total', IPF1.TtlExpndFC AS 'Allocated Unit Costs Row Total', IPF1.TtlCustLC AS 'Allocated Unit Costs Row Total', IPF1.TtlCustFC AS 'Allocated Unit Costs Row Total', IPF1.TtlCostLC AS 'Row Ttl Cust + Alloc Costs LC', IPF1.TtlCostFC AS 'Row Ttl Cust + Alloc Costs FC', IPF1.TtlVolume AS 'Volume Row Total', IPF1.TtlWeight AS 'Weight Row Total', IPF1.BaseRowNum AS 'use IPF1_BASE_LINE_NUM instead', IPF1.TtlCustSC AS 'Ttl Row Projected Customs (SC)', IPF1.TtlExpndSC AS 'Allocated Costs Row Total (SC)', IPF1.OriBAbsEnt AS 'Original Base Doc. Internal ID', IPF1.OriBLinNum AS 'Original Base Doc. Row No.', IPF1.TargetDoc AS 'Target Document Internal No.', IPF1.FobValCurr AS 'Base Doc. Value Currency', IPF1.FobnLaC AS 'FOB and Included Costs (LC)', IPF1.FobnLaCFC AS 'FOB and Included Costs (FC)', IPF1.NumPerMsr AS 'UoM Value', IPF1.Project AS 'Project Code', IPF1.OcrCode AS 'Distribution Rule', IPF1.OcrCode2 AS 'Distribution Rule 2', IPF1.OcrCode3 AS 'Distribution Rule 3', IPF1.OcrCode4 AS 'Distribution Rule 4', IPF1.OcrCode5 AS 'Distribution Rule 5', IPF1.OriBDocTyp AS 'Original Base Document Type', IPF1.CustRate AS 'Custom Group Rate', IPF1.LFixCost AS 'Locked Fixed Cost', IPF1.LFixCostFC AS 'Locked Fixed Cost (FC)', IPF1.LVarCost AS 'Locked Variable Cost', IPF1.LVarCostFC AS 'Locked Variable Cost (FC)', IPF1.CstmsRate AS 'Customs Rate', IPF1.VatGroup AS 'VAT Code', IPF1.VatPrcnt AS 'VAT Rate per Row', IPF1.VatSum AS 'Total of VAT', IPF1.SnbType AS 'Batch or Serial Type', IPF1.SnbAbsEnt AS 'SnB Abs. Entry', IPF1.SysNumber AS 'System Number', IPF1.DistNumber AS 'Distinct Number', IPF1.ExciseSum AS 'Sum of Excise', IPF1.ExcisSumFC AS 'Sum of Excise - FC', IPF1.ExcInStk AS 'Is Excise in Stock', IPF1.CustomSum AS 'Sum of Customs Cost', IPF1.CustSumFC AS 'Sum of Customs Cost in FC', IPF1.CstmInStk AS 'Is Customs in Stock', IPF1.CstmVatSum AS 'Sum of Customs Cost VAT', IPF1.CstmVatFC AS 'Sum of Customs Cost VAT in FC', IPF1.CstmVatStk AS 'Is Customs VAT in Stock', IPF1.CCDEntry AS 'CCD Abs. Entry', IPF1.CCDNumber AS 'Number of CCD', IPF1.ExcisSumSC AS 'Sum of Excise - SC', IPF1.CustSumSC AS 'Sum of Customs Cost in SC', IPF1.CstmVatSC AS 'Sum of Customs Cost VAT in SC', IPF1.InvQty AS 'Inventory Quantity', IPF1.CCDLineNum AS 'CCD Row Number' FROM IPF1 AS IPF1