Project Accounting View

By Ryan McBee   IF EXISTS (SELECT type,name FROM sysobjects WHERE name = ‘PACosts’ AND type = ‘V’) DROP VIEW PACosts GO ——————————————————————– CREATE VIEW PACosts AS   SELECT  ‘Timesheet’ AS DocumentType, ‘ ‘ as VendorInvoice, dbo.PA10001.PAPROJNUMBER AS ProjectNumber, LTRIM(RTRIM(dbo.PA10000.PATSNO)) + ‘-‘ + CONVERT(VARCHAR(10), dbo.PA10001.LNITMSEQ) AS DocumentNumber, dbo.PA10001.PACOSTCATID AS CostCategory, ‘LABOR’ AS Item, ‘Labor’ as […]