View - dbo.arch_PurchaseOrderLines

Property	Value
Name	arch_PurchaseOrderLines
Schema	dbo
Quoted Identifier Status	True
Ansi Nulls Status	True
Returns View Metadata	False
Create Date	10/2/2015 3:57 PM
Description

Column Name	Data Type	Allow Nulls	Fulltext Indexed	Identity	Description / Computed Formula
Acct1_AccountNumber	varchar(25)	True	False	False
Acct1_Amount	numeric(17, 2)	True	False	False
Acct1_CustodialGlc	varchar(5)	True	False	False
Acct1_CustodialGlCode	varchar(9)	True	False	False
Acct1_CustodialLocation	varchar(2)	True	False	False
Acct1_CustodialOrgUnit	varchar(16)	True	False	False
Acct1_CustodialQual1	varchar(6)	True	False	False
Acct1_CustodialQual2	varchar(4)	True	False	False
Acct1_CustodialStateOrgUnit	varchar(8)	True	False	False
Acct1_ExtraCostInd	varchar(1)	True	False	False
Acct1_Glc	varchar(5)	True	False	False
Acct1_GlCode	varchar(9)	True	False	False
Acct1_Location	varchar(2)	True	False	False
Acct1_OrgUnit	varchar(16)	True	False	False
Acct1_Qual1	varchar(6)	True	False	False
Acct1_Qual2	varchar(4)	True	False	False
Acct1_SplitPercentage	numeric(17, 4)	True	False	False
Acct1_StateOrgUnit	varchar(8)	True	False	False
Acct10_AccountNumber	varchar(25)	True	False	False
Acct10_Amount	numeric(17, 2)	True	False	False
Acct10_CustodialGlc	varchar(5)	True	False	False
Acct10_CustodialGlCode	varchar(9)	True	False	False
Acct10_CustodialLocation	varchar(2)	True	False	False
Acct10_CustodialOrgUnit	varchar(16)	True	False	False
Acct10_CustodialQual1	varchar(6)	True	False	False
Acct10_CustodialQual2	varchar(4)	True	False	False
Acct10_CustodialStateOrgUnit	varchar(8)	True	False	False
Acct10_ExtraCostInd	varchar(1)	True	False	False
Acct10_Glc	varchar(5)	True	False	False
Acct10_GlCode	varchar(9)	True	False	False
Acct10_Location	varchar(2)	True	False	False
Acct10_OrgUnit	varchar(16)	True	False	False
Acct10_Qual1	varchar(6)	True	False	False
Acct10_Qual2	varchar(4)	True	False	False
Acct10_SplitPercentage	numeric(17, 4)	True	False	False
Acct10_StateOrgUnit	varchar(8)	True	False	False
Acct2_AccountNumber	varchar(25)	True	False	False
Acct2_Amount	numeric(17, 2)	True	False	False
Acct2_CustodialGlc	varchar(5)	True	False	False
Acct2_CustodialGlCode	varchar(9)	True	False	False
Acct2_CustodialLocation	varchar(2)	True	False	False
Acct2_CustodialOrgUnit	varchar(16)	True	False	False
Acct2_CustodialQual1	varchar(6)	True	False	False
Acct2_CustodialQual2	varchar(4)	True	False	False
Acct2_CustodialStateOrgUnit	varchar(8)	True	False	False
Acct2_ExtraCostInd	varchar(1)	True	False	False
Acct2_Glc	varchar(5)	True	False	False
Acct2_GlCode	varchar(9)	True	False	False
Acct2_Location	varchar(2)	True	False	False
Acct2_OrgUnit	varchar(16)	True	False	False
Acct2_Qual1	varchar(6)	True	False	False
Acct2_Qual2	varchar(4)	True	False	False
Acct2_SplitPercentage	numeric(17, 4)	True	False	False
Acct2_StateOrgUnit	varchar(8)	True	False	False
Acct3_AccountNumber	varchar(25)	True	False	False
Acct3_Amount	numeric(17, 2)	True	False	False
Acct3_CustodialGlc	varchar(5)	True	False	False
Acct3_CustodialGlCode	varchar(9)	True	False	False
Acct3_CustodialLocation	varchar(2)	True	False	False
Acct3_CustodialOrgUnit	varchar(16)	True	False	False
Acct3_CustodialQual1	varchar(6)	True	False	False
Acct3_CustodialQual2	varchar(4)	True	False	False
Acct3_CustodialStateOrgUnit	varchar(8)	True	False	False
Acct3_ExtraCostInd	varchar(1)	True	False	False
Acct3_Glc	varchar(5)	True	False	False
Acct3_GlCode	varchar(9)	True	False	False
Acct3_Location	varchar(2)	True	False	False
Acct3_OrgUnit	varchar(16)	True	False	False
Acct3_Qual1	varchar(6)	True	False	False
Acct3_Qual2	varchar(4)	True	False	False
Acct3_SplitPercentage	numeric(17, 4)	True	False	False
Acct3_StateOrgUnit	varchar(8)	True	False	False
Acct4_AccountNumber	varchar(25)	True	False	False
Acct4_Amount	numeric(17, 2)	True	False	False
Acct4_CustodialGlc	varchar(5)	True	False	False
Acct4_CustodialGlCode	varchar(9)	True	False	False
Acct4_CustodialLocation	varchar(2)	True	False	False
Acct4_CustodialOrgUnit	varchar(16)	True	False	False
Acct4_CustodialQual1	varchar(6)	True	False	False
Acct4_CustodialQual2	varchar(4)	True	False	False
Acct4_CustodialStateOrgUnit	varchar(8)	True	False	False
Acct4_ExtraCostInd	varchar(1)	True	False	False
Acct4_Glc	varchar(5)	True	False	False
Acct4_GlCode	varchar(9)	True	False	False
Acct4_Location	varchar(2)	True	False	False
Acct4_OrgUnit	varchar(16)	True	False	False
Acct4_Qual1	varchar(6)	True	False	False
Acct4_Qual2	varchar(4)	True	False	False
Acct4_SplitPercentage	numeric(17, 4)	True	False	False
Acct4_StateOrgUnit	varchar(8)	True	False	False
Acct5_AccountNumber	varchar(25)	True	False	False
Acct5_Amount	numeric(17, 2)	True	False	False
Acct5_CustodialGlc	varchar(5)	True	False	False
Acct5_CustodialGlCode	varchar(9)	True	False	False
Acct5_CustodialLocation	varchar(2)	True	False	False
Acct5_CustodialOrgUnit	varchar(16)	True	False	False
Acct5_CustodialQual1	varchar(6)	True	False	False
Acct5_CustodialQual2	varchar(4)	True	False	False
Acct5_CustodialStateOrgUnit	varchar(8)	True	False	False
Acct5_ExtraCostInd	varchar(1)	True	False	False
Acct5_Glc	varchar(5)	True	False	False
Acct5_GlCode	varchar(9)	True	False	False
Acct5_Location	varchar(2)	True	False	False
Acct5_OrgUnit	varchar(16)	True	False	False
Acct5_Qual1	varchar(6)	True	False	False
Acct5_Qual2	varchar(4)	True	False	False
Acct5_SplitPercentage	numeric(17, 4)	True	False	False
Acct5_StateOrgUnit	varchar(8)	True	False	False
Acct6_AccountNumber	varchar(25)	True	False	False
Acct6_Amount	numeric(17, 2)	True	False	False
Acct6_CustodialGlc	varchar(5)	True	False	False
Acct6_CustodialGlCode	varchar(9)	True	False	False
Acct6_CustodialLocation	varchar(2)	True	False	False
Acct6_CustodialOrgUnit	varchar(16)	True	False	False
Acct6_CustodialQual1	varchar(6)	True	False	False
Acct6_CustodialQual2	varchar(4)	True	False	False
Acct6_CustodialStateOrgUnit	varchar(8)	True	False	False
Acct6_ExtraCostInd	varchar(1)	True	False	False
Acct6_Glc	varchar(5)	True	False	False
Acct6_GlCode	varchar(9)	True	False	False
Acct6_Location	varchar(2)	True	False	False
Acct6_OrgUnit	varchar(16)	True	False	False
Acct6_Qual1	varchar(6)	True	False	False
Acct6_Qual2	varchar(4)	True	False	False
Acct6_SplitPercentage	numeric(17, 4)	True	False	False
Acct6_StateOrgUnit	varchar(8)	True	False	False
Acct7_AccountNumber	varchar(25)	True	False	False
Acct7_Amount	numeric(17, 2)	True	False	False
Acct7_CustodialGlc	varchar(5)	True	False	False
Acct7_CustodialGlCode	varchar(9)	True	False	False
Acct7_CustodialLocation	varchar(2)	True	False	False
Acct7_CustodialOrgUnit	varchar(16)	True	False	False
Acct7_CustodialQual1	varchar(6)	True	False	False
Acct7_CustodialQual2	varchar(4)	True	False	False
Acct7_CustodialStateOrgUnit	varchar(8)	True	False	False
Acct7_ExtraCostInd	varchar(1)	True	False	False
Acct7_Glc	varchar(5)	True	False	False
Acct7_GlCode	varchar(9)	True	False	False
Acct7_Location	varchar(2)	True	False	False
Acct7_OrgUnit	varchar(16)	True	False	False
Acct7_Qual1	varchar(6)	True	False	False
Acct7_Qual2	varchar(4)	True	False	False
Acct7_SplitPercentage	numeric(17, 4)	True	False	False
Acct7_StateOrgUnit	varchar(8)	True	False	False
Acct8_AccountNumber	varchar(25)	True	False	False
Acct8_Amount	numeric(17, 2)	True	False	False
Acct8_CustodialGlc	varchar(5)	True	False	False
Acct8_CustodialGlCode	varchar(9)	True	False	False
Acct8_CustodialLocation	varchar(2)	True	False	False
Acct8_CustodialOrgUnit	varchar(16)	True	False	False
Acct8_CustodialQual1	varchar(6)	True	False	False
Acct8_CustodialQual2	varchar(4)	True	False	False
Acct8_CustodialStateOrgUnit	varchar(8)	True	False	False
Acct8_ExtraCostInd	varchar(1)	True	False	False
Acct8_Glc	varchar(5)	True	False	False
Acct8_GlCode	varchar(9)	True	False	False
Acct8_Location	varchar(2)	True	False	False
Acct8_OrgUnit	varchar(16)	True	False	False
Acct8_Qual1	varchar(6)	True	False	False
Acct8_Qual2	varchar(4)	True	False	False
Acct8_SplitPercentage	numeric(17, 4)	True	False	False
Acct8_StateOrgUnit	varchar(8)	True	False	False
Acct9_AccountNumber	varchar(25)	True	False	False
Acct9_Amount	numeric(17, 2)	True	False	False
Acct9_CustodialGlc	varchar(5)	True	False	False
Acct9_CustodialGlCode	varchar(9)	True	False	False
Acct9_CustodialLocation	varchar(2)	True	False	False
Acct9_CustodialOrgUnit	varchar(16)	True	False	False
Acct9_CustodialQual1	varchar(6)	True	False	False
Acct9_CustodialQual2	varchar(4)	True	False	False
Acct9_CustodialStateOrgUnit	varchar(8)	True	False	False
Acct9_ExtraCostInd	varchar(1)	True	False	False
Acct9_Glc	varchar(5)	True	False	False
Acct9_GlCode	varchar(9)	True	False	False
Acct9_Location	varchar(2)	True	False	False
Acct9_OrgUnit	varchar(16)	True	False	False
Acct9_Qual1	varchar(6)	True	False	False
Acct9_Qual2	varchar(4)	True	False	False
Acct9_SplitPercentage	numeric(17, 4)	True	False	False
Acct9_StateOrgUnit	varchar(8)	True	False	False
AddProgram	varchar(8)	True	False	False
AddUserId	varchar(8)	True	False	False
BalanceAmountAccrued	numeric(17, 2)	False	False	False
BalanceQtyAccrued	numeric(17, 4)	False	False	False
BalanceTotalAmount	numeric(17, 2)	False	False	False
Buyer	varchar(25)	True	False	False
BuyerId	varchar(3)	True	False	False
CommodityCode	varchar(13)	True	False	False
CommodityDesc	varchar(50)	True	False	False
DetailCommitmentAmount	numeric(17, 2)	False	False	False
DetailDescription	varchar(6000)	True	False	False
DetailItemType	varchar(2)	True	False	False
DetailStatus	varchar(15)	True	False	False
DetailStatusCode	varchar(2)	True	False	False
Discount	numeric(17, 4)	False	False	False
DueDate	date(10, 0)	True	False	False
EncumberedAcct1_AccountNumber	varchar(25)	True	False	False
EncumberedAcct1_Amount	numeric(17, 2)	True	False	False
EncumberedAcct1_WorkAmount	numeric(17, 2)	True	False	False
EncumberedAcct10_AccountNumber	varchar(25)	True	False	False
EncumberedAcct10_Amount	numeric(17, 2)	True	False	False
EncumberedAcct10_WorkAmount	numeric(17, 2)	True	False	False
EncumberedAcct10Glc	varchar(5)	True	False	False
EncumberedAcct10GlCode	varchar(9)	True	False	False
EncumberedAcct10Location	varchar(2)	True	False	False
EncumberedAcct10OrgUnit	varchar(16)	True	False	False
EncumberedAcct10Qual1	varchar(6)	True	False	False
EncumberedAcct10Qual2	varchar(4)	True	False	False
EncumberedAcct10StateOrgUnit	varchar(8)	True	False	False
EncumberedAcct1Glc	varchar(5)	True	False	False
EncumberedAcct1GlCode	varchar(9)	True	False	False
EncumberedAcct1Location	varchar(2)	True	False	False
EncumberedAcct1OrgUnit	varchar(16)	True	False	False
EncumberedAcct1Qual1	varchar(6)	True	False	False
EncumberedAcct1Qual2	varchar(4)	True	False	False
EncumberedAcct1StateOrgUnit	varchar(8)	True	False	False
EncumberedAcct2_AccountNumber	varchar(25)	True	False	False
EncumberedAcct2_Amount	numeric(17, 2)	True	False	False
EncumberedAcct2_WorkAmount	numeric(17, 2)	True	False	False
EncumberedAcct2Glc	varchar(5)	True	False	False
EncumberedAcct2GlCode	varchar(9)	True	False	False
EncumberedAcct2Location	varchar(2)	True	False	False
EncumberedAcct2OrgUnit	varchar(16)	True	False	False
EncumberedAcct2Qual1	varchar(6)	True	False	False
EncumberedAcct2Qual2	varchar(4)	True	False	False
EncumberedAcct2StateOrgUnit	varchar(8)	True	False	False
EncumberedAcct3_AccountNumber	varchar(25)	True	False	False
EncumberedAcct3_Amount	numeric(17, 2)	True	False	False
EncumberedAcct3_WorkAmount	numeric(17, 2)	True	False	False
EncumberedAcct3Glc	varchar(5)	True	False	False
EncumberedAcct3GlCode	varchar(9)	True	False	False
EncumberedAcct3Location	varchar(2)	True	False	False
EncumberedAcct3OrgUnit	varchar(16)	True	False	False
EncumberedAcct3Qual1	varchar(6)	True	False	False
EncumberedAcct3Qual2	varchar(4)	True	False	False
EncumberedAcct3StateOrgUnit	varchar(8)	True	False	False
EncumberedAcct4_AccountNumber	varchar(25)	True	False	False
EncumberedAcct4_Amount	numeric(17, 2)	True	False	False
EncumberedAcct4_WorkAmount	numeric(17, 2)	True	False	False
EncumberedAcct4Glc	varchar(5)	True	False	False
EncumberedAcct4GlCode	varchar(9)	True	False	False
EncumberedAcct4Location	varchar(2)	True	False	False
EncumberedAcct4OrgUnit	varchar(16)	True	False	False
EncumberedAcct4Qual1	varchar(6)	True	False	False
EncumberedAcct4Qual2	varchar(4)	True	False	False
EncumberedAcct4StateOrgUnit	varchar(8)	True	False	False
EncumberedAcct5_AccountNumber	varchar(25)	True	False	False
EncumberedAcct5_Amount	numeric(17, 2)	True	False	False
EncumberedAcct5_WorkAmount	numeric(17, 2)	True	False	False
EncumberedAcct5Glc	varchar(5)	True	False	False
EncumberedAcct5GlCode	varchar(9)	True	False	False
EncumberedAcct5Location	varchar(2)	True	False	False
EncumberedAcct5OrgUnit	varchar(16)	True	False	False
EncumberedAcct5Qual1	varchar(6)	True	False	False
EncumberedAcct5Qual2	varchar(4)	True	False	False
EncumberedAcct5StateOrgUnit	varchar(8)	True	False	False
EncumberedAcct6_AccountNumber	varchar(25)	True	False	False
EncumberedAcct6_Amount	numeric(17, 2)	True	False	False
EncumberedAcct6_WorkAmount	numeric(17, 2)	True	False	False
EncumberedAcct6Glc	varchar(5)	True	False	False
EncumberedAcct6GlCode	varchar(9)	True	False	False
EncumberedAcct6Location	varchar(2)	True	False	False
EncumberedAcct6OrgUnit	varchar(16)	True	False	False
EncumberedAcct6Qual1	varchar(6)	True	False	False
EncumberedAcct6Qual2	varchar(4)	True	False	False
EncumberedAcct6StateOrgUnit	varchar(8)	True	False	False
EncumberedAcct7_AccountNumber	varchar(25)	True	False	False
EncumberedAcct7_Amount	numeric(17, 2)	True	False	False
EncumberedAcct7_WorkAmount	numeric(17, 2)	True	False	False
EncumberedAcct7Glc	varchar(5)	True	False	False
EncumberedAcct7GlCode	varchar(9)	True	False	False
EncumberedAcct7Location	varchar(2)	True	False	False
EncumberedAcct7OrgUnit	varchar(16)	True	False	False
EncumberedAcct7Qual1	varchar(6)	True	False	False
EncumberedAcct7Qual2	varchar(4)	True	False	False
EncumberedAcct7StateOrgUnit	varchar(8)	True	False	False
EncumberedAcct8_AccountNumber	varchar(25)	True	False	False
EncumberedAcct8_Amount	numeric(17, 2)	True	False	False
EncumberedAcct8_WorkAmount	numeric(17, 2)	True	False	False
EncumberedAcct8Glc	varchar(5)	True	False	False
EncumberedAcct8GlCode	varchar(9)	True	False	False
EncumberedAcct8Location	varchar(2)	True	False	False
EncumberedAcct8OrgUnit	varchar(16)	True	False	False
EncumberedAcct8Qual1	varchar(6)	True	False	False
EncumberedAcct8Qual2	varchar(4)	True	False	False
EncumberedAcct8StateOrgUnit	varchar(8)	True	False	False
EncumberedAcct9_AccountNumber	varchar(25)	True	False	False
EncumberedAcct9_Amount	numeric(17, 2)	True	False	False
EncumberedAcct9_WorkAmount	numeric(17, 2)	True	False	False
EncumberedAcct9Glc	varchar(5)	True	False	False
EncumberedAcct9GlCode	varchar(9)	True	False	False
EncumberedAcct9Location	varchar(2)	True	False	False
EncumberedAcct9OrgUnit	varchar(16)	True	False	False
EncumberedAcct9Qual1	varchar(6)	True	False	False
EncumberedAcct9Qual2	varchar(4)	True	False	False
EncumberedAcct9StateOrgUnit	varchar(8)	True	False	False
EncumbranceTotalAmount	numeric(17, 2)	False	False	False
FinancialStatus	varchar(15)	True	False	False
FinancialStatusCode	varchar(2)	True	False	False
FiscalYear	varchar(4)	True	False	False
FreightInd	varchar(1)	True	False	False
LineItemAmount	numeric(17, 2)	False	False	False
MaintDateTime	datetime(23, 3)	True	False	False
MaintProgram	varchar(8)	True	False	False
MaintUserId	varchar(8)	True	False	False
NotesInd	varchar(1)	True	False	False
PaidTotalAmount	numeric(17, 2)	False	False	False
PaymentStatus	varchar(15)	True	False	False
PaymentStatusCode	varchar(2)	True	False	False
PoLineCreateDate	datetime(23, 3)	True	False	False
PoLineNumber	int(10, 0)	True	False	False
PrevPoInfo	varchar(15)	True	False	False
PrqItemNumber	int(10, 0)	False	False	False
PrqSeqNumber	int(10, 0)	False	False	False
PrqYearReferenceNumber	varchar(12)	True	False	False
PurchaseOrderNumber	varchar(8)	True	False	False
QuantityOrdered	numeric(17, 4)	False	False	False
RecAmountAccrued	numeric(17, 2)	False	False	False
RecAmountPayables	numeric(17, 2)	False	False	False
ReceivingQuantity	numeric(17, 4)	False	False	False
ReceivingStatus	varchar(15)	True	False	False
ReceivingStatusCode	varchar(2)	True	False	False
ReceivingUser	varchar(42)	True	False	False
ReceivingUserId	varchar(8)	True	False	False
RecQtyAccured	numeric(17, 4)	False	False	False
RecQtyPayables	numeric(17, 4)	False	False	False
StandardItemNumber	varchar(15)	True	False	False
UnitCost	numeric(17, 4)	False	False	False
UnitOfMeasure	varchar(25)	True	False	False
UnitOfMeasureCode	varchar(6)	True	False	False
YearPurchaseOrderNumber	varchar(12)	True	False	False

Name

Insert

Update

Delete

Instead

Name

Clustered

Columns

Name	Type
FIP_COMMODITY	Table
FIP_PO_DET	Table
FIP_PO_DET_ACCOUNT_DET	Table
FIP_PO_DET_ACCT_ENC_DET	Table
FIP_TABLES	Table
SECURITY_USER_A2	Table

Name	Type
udf_arch_PoDetailDesc	USERDEFINEDFUNCTION
FIP_COMMODITY	TABLE
FIP_PO_DET	TABLE
FIP_PO_DET_ACCOUNT_DET	TABLE
FIP_PO_DET_ACCT_ENC_DET	TABLE
FIP_TABLES	TABLE
SECURITY_USER_A2	TABLE

Object

Property

Value

Object

Property

Value

/****** Object: View [dbo].[arch_PurchaseOrderLines] Script Date: 03/09/2017 16:47:09 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE VIEW [dbo].[arch_PurchaseOrderLines]
AS
SELECT
    PoDet.DET_YEAR_REF_NBR AS YearPurchaseOrderNumber
   ,SUBSTRING(PoDet.DET_YEAR_REF_NBR, 1, 4) AS FiscalYear
   ,SUBSTRING(PoDet.DET_YEAR_REF_NBR, 5, 8) AS PurchaseOrderNumber
   ,PoDet.DET_ITM_NBR AS PoLineNumber
   ,ISNULL(DET_LINE_ITM_AMT, 0) AS LineItemAmount
   ,ISNULL(QTY_ORD, 0) AS QuantityOrdered
   ,UNIT_MEAS AS UnitOfMeasureCode
   ,UOM.UNIT_MEAS_DESC AS UnitOfMeasure
   ,ISNULL(UNIT_COST, 0) AS UnitCost
   ,ISNULL(DISC, 0) AS Discount
   ,COMMODITY_CODE AS CommodityCode
   ,Comm.CC_DESCRIPTION AS CommodityDesc
   ,STD_ITM_NBR AS StandardItemNumber
   ,TXT_NOTES_IND AS NotesInd
   ,FREIGHT_IND AS FreightInd
   ,CONVERT(DATE, DUE_DATE) AS DueDate
   ,PoDet.DET_STATUS AS DetailStatusCode
   ,StatusDesc.STATUS_DESC AS DetailStatus
   ,REC_STATUS AS ReceivingStatusCode
   ,RecStatDesc.STATUS_DESC AS ReceivingStatus
   ,PAY_STATUS AS PaymentStatusCode
   ,PayStatDesc.STATUS_DESC AS PaymentStatus
   ,FIN_STATUS AS FinancialStatusCode
   ,FinStatusDesc.STATUS_DESC AS FinancialStatus
   ,RECEIVING_USER_ID AS ReceivingUserId
   ,CASE
      WHEN RecUser.LAST_NAME IS NULL AND RecUser.FIRST_NAME IS NULL THEN NULL
      WHEN RecUser.FIRST_NAME IS NULL THEN RecUser.LAST_NAME
      ELSE RecUser.LAST_NAME + ', ' + RecUser.FIRST_NAME
    END AS ReceivingUser
   ,ISNULL(REC_QTY_REC_TO_DATE, 0) AS ReceivingQuantity
   ,PoDet.BUYER_ID AS BuyerId
   ,BuyerName.BUYER_NAME AS Buyer
   ,PRQ_YR_REF_NBR AS PrqYearReferenceNumber
   ,ISNULL(PRQ_ITM_NBR, 0) AS PrqItemNumber
   ,ISNULL(PRQ_SEQ_NBR, 0) AS PrqSeqNumber
   ,ISNULL(DET_COMMITTED_AMT, 0) AS DetailCommitmentAmount
   ,ISNULL(REC_QTY_PAYABLES, 0) AS RecQtyPayables
   ,ISNULL(REC_AMT_PAYABLES, 0) AS RecAmountPayables
   ,ISNULL(REC_QTY_ACCRUED, 0) AS RecQtyAccured
   ,ISNULL(REC_AMT_ACCRUED, 0) AS RecAmountAccrued
   ,ISNULL(BAL_AMT_ACCRUED, 0) AS BalanceAmountAccrued
   ,ISNULL(BAL_QTY_ACCRUED, 0) AS BalanceQtyAccrued
   ,DET_ITM_TYPE AS DetailItemType
   ,PREV_PO_INFO AS PrevPoInfo
   ,ISNULL(ENC_TOT_AMT, 0) AS EncumbranceTotalAmount
   ,ISNULL(BALANCE_TOT_AMT, 0) AS BalanceTotalAmount
   ,ISNULL(PAID_TOT_AMT, 0) AS PaidTotalAmount
   ,CASE
      WHEN ISDATE(PoDet.ADD_DATE) = 0 THEN '1900-01-01 00:00:00.000'
      WHEN PoDet.ADD_TIME IS NULL THEN CONVERT(DATETIME, CONVERT(CHAR(8), PoDet.ADD_DATE) + ' '
              + '00:00:00.000')
      ELSE CONVERT(DATETIME, CONVERT(CHAR(8), PoDet.ADD_DATE) + ' '
            + STUFF(STUFF(STUFF(RIGHT('0000000' + cast(PoDet.ADD_TIME as varchar(7)),7),3,0,':'),6,0,':'),9,0,'.'))
    END AS PoLineCreateDate
  ,PoDet.ADD_USER_ID AS AddUserId
  ,PoDet.ADD_PGM AS AddProgram
  ,CASE
     WHEN ISDATE(PoDet.ADD_DATE) = 0 AND ISDATE(PoDet.MAINT_DATE) = 0 THEN '1900-01-01 00:00:00.000'
     WHEN ISDATE(PoDet.MAINT_DATE) = 0 AND PoDet.ADD_TIME IS NULL THEN CONVERT(DATETIME, CONVERT(CHAR(8), PoDet.ADD_DATE) + ' '
                + '00:00:00.000')
     WHEN ISDATE(PoDet.MAINT_DATE) = 0 AND PoDet.MAINT_TIME IS NULL THEN CONVERT(DATETIME, CONVERT(CHAR(8), PoDet.ADD_DATE) + ' '
              + STUFF(STUFF(STUFF(RIGHT('0000000' + cast(PoDet.ADD_TIME as varchar(7)),7),3,0,':'),6,0,':'),9,0,'.'))
     WHEN ISDATE(PoDet.MAINT_DATE) = 1 AND PoDet.MAINT_TIME IS NULL THEN CONVERT(DATETIME, CONVERT(CHAR(8), PoDet.MAINT_DATE) + ' '
               + '00:00:00.000')
     ELSE CONVERT(DATETIME, CONVERT(CHAR(8), PoDet.MAINT_DATE) + ' '
                + STUFF(STUFF(STUFF(RIGHT('0000000' + cast(PoDet.MAINT_TIME as varchar(7)),7),3,0,':'),6,0,':'),9,0,'.'))
   END AS         MaintDateTime
  ,PoDet.MAINT_USER_ID AS MaintUserId
  ,PoDet.MAINT_PGM AS MaintProgram
  ,dbo.udf_arch_PoDetailDesc(PoDet.ISN_FIP_PO_DET) AS DetailDescription
  ,Acct0.ACCT_NBR AS Acct1_AccountNumber
  ,LEFT(Acct0.ACCT_NBR,8) AS Acct1_StateOrgUnit
  ,LEFT(Acct0.ACCT_NBR,16) AS Acct1_OrgUnit
  ,SUBSTRING(Acct0.ACCT_NBR,9,6) AS Acct1_Qual1
  ,SUBSTRING(Acct0.ACCT_NBR,15,2) AS Acct1_Location
  ,SUBSTRING(Acct0.ACCT_NBR,17,9) AS Acct1_GlCode
  ,SUBSTRING(Acct0.ACCT_NBR,17,5) AS Acct1_Glc
  ,SUBSTRING(Acct0.ACCT_NBR,22,4) AS Acct1_Qual2
  ,LEFT(Acct0.ACCT_CUSTODIAL_ACCT,8) AS Acct1_CustodialStateOrgUnit
  ,LEFT(Acct0.ACCT_CUSTODIAL_ACCT,16) AS Acct1_CustodialOrgUnit
  ,SUBSTRING(Acct0.ACCT_CUSTODIAL_ACCT,9,6) AS Acct1_CustodialQual1
  ,SUBSTRING(Acct0.ACCT_CUSTODIAL_ACCT,15,2) AS Acct1_CustodialLocation
  ,SUBSTRING(Acct0.ACCT_CUSTODIAL_ACCT,17,9) AS Acct1_CustodialGlCode
  ,SUBSTRING(Acct0.ACCT_CUSTODIAL_ACCT,17,5) AS Acct1_CustodialGlc
  ,SUBSTRING(Acct0.ACCT_CUSTODIAL_ACCT,22,4) AS Acct1_CustodialQual2
  ,Acct0.SPLIT_PCT AS Acct1_SplitPercentage
  ,Acct0.AMT AS Acct1_Amount
  ,Acct0.EXTRA_COST_IND AS Acct1_ExtraCostInd
  ,Acct1.ACCT_NBR AS Acct2_AccountNumber
  ,LEFT(Acct1.ACCT_NBR,8) AS Acct2_StateOrgUnit
  ,LEFT(Acct1.ACCT_NBR,16) AS Acct2_OrgUnit
  ,SUBSTRING(Acct1.ACCT_NBR,9,6) AS Acct2_Qual1
  ,SUBSTRING(Acct1.ACCT_NBR,15,2) AS Acct2_Location
  ,SUBSTRING(Acct1.ACCT_NBR,17,9) AS Acct2_GlCode
  ,SUBSTRING(Acct1.ACCT_NBR,17,5) AS Acct2_Glc
  ,SUBSTRING(Acct1.ACCT_NBR,22,4) AS Acct2_Qual2
  ,LEFT(Acct1.ACCT_CUSTODIAL_ACCT,8) AS Acct2_CustodialStateOrgUnit
  ,LEFT(Acct1.ACCT_CUSTODIAL_ACCT,16) AS Acct2_CustodialOrgUnit
  ,SUBSTRING(Acct1.ACCT_CUSTODIAL_ACCT,9,6) AS Acct2_CustodialQual1
  ,SUBSTRING(Acct1.ACCT_CUSTODIAL_ACCT,15,2) AS Acct2_CustodialLocation
  ,SUBSTRING(Acct1.ACCT_CUSTODIAL_ACCT,17,9) AS Acct2_CustodialGlCode
  ,SUBSTRING(Acct1.ACCT_CUSTODIAL_ACCT,17,5) AS Acct2_CustodialGlc
  ,SUBSTRING(Acct1.ACCT_CUSTODIAL_ACCT,22,4) AS Acct2_CustodialQual2
  ,Acct1.SPLIT_PCT AS Acct2_SplitPercentage
  ,Acct1.AMT AS Acct2_Amount
  ,Acct1.EXTRA_COST_IND AS Acct2_ExtraCostInd
  ,Acct2.ACCT_NBR AS Acct3_AccountNumber
  ,LEFT(Acct2.ACCT_NBR,8) AS Acct3_StateOrgUnit
  ,LEFT(Acct2.ACCT_NBR,16) AS Acct3_OrgUnit
  ,SUBSTRING(Acct2.ACCT_NBR,9,6) AS Acct3_Qual1
  ,SUBSTRING(Acct2.ACCT_NBR,15,2) AS Acct3_Location
  ,SUBSTRING(Acct2.ACCT_NBR,17,9) AS Acct3_GlCode
  ,SUBSTRING(Acct2.ACCT_NBR,17,5) AS Acct3_Glc
  ,SUBSTRING(Acct2.ACCT_NBR,22,4) AS Acct3_Qual2
  ,LEFT(Acct2.ACCT_CUSTODIAL_ACCT,8) AS Acct3_CustodialStateOrgUnit
  ,LEFT(Acct2.ACCT_CUSTODIAL_ACCT,16) AS Acct3_CustodialOrgUnit
  ,SUBSTRING(Acct2.ACCT_CUSTODIAL_ACCT,9,6) AS Acct3_CustodialQual1
  ,SUBSTRING(Acct2.ACCT_CUSTODIAL_ACCT,15,2) AS Acct3_CustodialLocation
  ,SUBSTRING(Acct2.ACCT_CUSTODIAL_ACCT,17,9) AS Acct3_CustodialGlCode
  ,SUBSTRING(Acct2.ACCT_CUSTODIAL_ACCT,17,5) AS Acct3_CustodialGlc
  ,SUBSTRING(Acct2.ACCT_CUSTODIAL_ACCT,22,4) AS Acct3_CustodialQual2
  ,Acct2.SPLIT_PCT AS Acct3_SplitPercentage
  ,Acct2.AMT AS Acct3_Amount
  ,Acct2.EXTRA_COST_IND AS Acct3_ExtraCostInd

  ,Acct3.ACCT_NBR AS Acct4_AccountNumber
  ,LEFT(Acct3.ACCT_NBR,8) AS Acct4_StateOrgUnit
  ,LEFT(Acct3.ACCT_NBR,16) AS Acct4_OrgUnit
  ,SUBSTRING(Acct3.ACCT_NBR,9,6) AS Acct4_Qual1
  ,SUBSTRING(Acct3.ACCT_NBR,15,2) AS Acct4_Location
  ,SUBSTRING(Acct3.ACCT_NBR,17,9) AS Acct4_GlCode
  ,SUBSTRING(Acct3.ACCT_NBR,17,5) AS Acct4_Glc
  ,SUBSTRING(Acct3.ACCT_NBR,22,4) AS Acct4_Qual2
  ,LEFT(Acct3.ACCT_CUSTODIAL_ACCT,8) AS Acct4_CustodialStateOrgUnit
  ,LEFT(Acct3.ACCT_CUSTODIAL_ACCT,16) AS Acct4_CustodialOrgUnit
  ,SUBSTRING(Acct3.ACCT_CUSTODIAL_ACCT,9,6) AS Acct4_CustodialQual1
  ,SUBSTRING(Acct3.ACCT_CUSTODIAL_ACCT,15,2) AS Acct4_CustodialLocation
  ,SUBSTRING(Acct3.ACCT_CUSTODIAL_ACCT,17,9) AS Acct4_CustodialGlCode
  ,SUBSTRING(Acct3.ACCT_CUSTODIAL_ACCT,17,5) AS Acct4_CustodialGlc
  ,SUBSTRING(Acct3.ACCT_CUSTODIAL_ACCT,22,4) AS Acct4_CustodialQual2
  ,Acct3.SPLIT_PCT AS Acct4_SplitPercentage
  ,Acct3.AMT AS Acct4_Amount
  ,Acct3.EXTRA_COST_IND AS Acct4_ExtraCostInd

  ,Acct4.ACCT_NBR AS Acct5_AccountNumber
  ,LEFT(Acct4.ACCT_NBR,8) AS Acct5_StateOrgUnit
  ,LEFT(Acct4.ACCT_NBR,16) AS Acct5_OrgUnit
  ,SUBSTRING(Acct4.ACCT_NBR,9,6) AS Acct5_Qual1
  ,SUBSTRING(Acct4.ACCT_NBR,15,2) AS Acct5_Location
  ,SUBSTRING(Acct4.ACCT_NBR,17,9) AS Acct5_GlCode
  ,SUBSTRING(Acct4.ACCT_NBR,17,5) AS Acct5_Glc
  ,SUBSTRING(Acct4.ACCT_NBR,22,4) AS Acct5_Qual2
  ,LEFT(Acct4.ACCT_CUSTODIAL_ACCT,8) AS Acct5_CustodialStateOrgUnit
  ,LEFT(Acct4.ACCT_CUSTODIAL_ACCT,16) AS Acct5_CustodialOrgUnit
  ,SUBSTRING(Acct4.ACCT_CUSTODIAL_ACCT,9,6) AS Acct5_CustodialQual1
  ,SUBSTRING(Acct4.ACCT_CUSTODIAL_ACCT,15,2) AS Acct5_CustodialLocation
  ,SUBSTRING(Acct4.ACCT_CUSTODIAL_ACCT,17,9) AS Acct5_CustodialGlCode
  ,SUBSTRING(Acct4.ACCT_CUSTODIAL_ACCT,17,5) AS Acct5_CustodialGlc
  ,SUBSTRING(Acct4.ACCT_CUSTODIAL_ACCT,22,4) AS Acct5_CustodialQual2
  ,Acct4.SPLIT_PCT AS Acct5_SplitPercentage
  ,Acct4.AMT AS Acct5_Amount
  ,Acct4.EXTRA_COST_IND AS Acct5_ExtraCostInd

  ,Acct5.ACCT_NBR AS Acct6_AccountNumber
  ,LEFT(Acct5.ACCT_NBR,8) AS Acct6_StateOrgUnit
  ,LEFT(Acct5.ACCT_NBR,16) AS Acct6_OrgUnit
  ,SUBSTRING(Acct5.ACCT_NBR,9,6) AS Acct6_Qual1
  ,SUBSTRING(Acct5.ACCT_NBR,15,2) AS Acct6_Location
  ,SUBSTRING(Acct5.ACCT_NBR,17,9) AS Acct6_GlCode
  ,SUBSTRING(Acct5.ACCT_NBR,17,5) AS Acct6_Glc
  ,SUBSTRING(Acct5.ACCT_NBR,22,4) AS Acct6_Qual2
  ,LEFT(Acct5.ACCT_CUSTODIAL_ACCT,8) AS Acct6_CustodialStateOrgUnit
  ,LEFT(Acct5.ACCT_CUSTODIAL_ACCT,16) AS Acct6_CustodialOrgUnit
  ,SUBSTRING(Acct5.ACCT_CUSTODIAL_ACCT,9,6) AS Acct6_CustodialQual1
  ,SUBSTRING(Acct5.ACCT_CUSTODIAL_ACCT,15,2) AS Acct6_CustodialLocation
  ,SUBSTRING(Acct5.ACCT_CUSTODIAL_ACCT,17,9) AS Acct6_CustodialGlCode
  ,SUBSTRING(Acct5.ACCT_CUSTODIAL_ACCT,17,5) AS Acct6_CustodialGlc
  ,SUBSTRING(Acct5.ACCT_CUSTODIAL_ACCT,22,4) AS Acct6_CustodialQual2
  ,Acct5.SPLIT_PCT AS Acct6_SplitPercentage
  ,Acct5.AMT AS Acct6_Amount
  ,Acct5.EXTRA_COST_IND AS Acct6_ExtraCostInd

  ,Acct6.ACCT_NBR AS Acct7_AccountNumber
  ,LEFT(Acct6.ACCT_NBR,8) AS Acct7_StateOrgUnit
  ,LEFT(Acct6.ACCT_NBR,16) AS Acct7_OrgUnit
  ,SUBSTRING(Acct6.ACCT_NBR,9,6) AS Acct7_Qual1
  ,SUBSTRING(Acct6.ACCT_NBR,15,2) AS Acct7_Location
  ,SUBSTRING(Acct6.ACCT_NBR,17,9) AS Acct7_GlCode
  ,SUBSTRING(Acct6.ACCT_NBR,17,5) AS Acct7_Glc
  ,SUBSTRING(Acct6.ACCT_NBR,22,4) AS Acct7_Qual2
  ,LEFT(Acct6.ACCT_CUSTODIAL_ACCT,8) AS Acct7_CustodialStateOrgUnit
  ,LEFT(Acct6.ACCT_CUSTODIAL_ACCT,16) AS Acct7_CustodialOrgUnit
  ,SUBSTRING(Acct6.ACCT_CUSTODIAL_ACCT,9,6) AS Acct7_CustodialQual1
  ,SUBSTRING(Acct6.ACCT_CUSTODIAL_ACCT,15,2) AS Acct7_CustodialLocation
  ,SUBSTRING(Acct6.ACCT_CUSTODIAL_ACCT,17,9) AS Acct7_CustodialGlCode
  ,SUBSTRING(Acct6.ACCT_CUSTODIAL_ACCT,17,5) AS Acct7_CustodialGlc
  ,SUBSTRING(Acct6.ACCT_CUSTODIAL_ACCT,22,4) AS Acct7_CustodialQual2
  ,Acct6.SPLIT_PCT AS Acct7_SplitPercentage
  ,Acct6.AMT AS Acct7_Amount
  ,Acct6.EXTRA_COST_IND AS Acct7_ExtraCostInd

  ,Acct7.ACCT_NBR AS Acct8_AccountNumber
  ,LEFT(Acct7.ACCT_NBR,8) AS Acct8_StateOrgUnit
  ,LEFT(Acct7.ACCT_NBR,16) AS Acct8_OrgUnit
  ,SUBSTRING(Acct7.ACCT_NBR,9,6) AS Acct8_Qual1
  ,SUBSTRING(Acct7.ACCT_NBR,15,2) AS Acct8_Location
  ,SUBSTRING(Acct7.ACCT_NBR,17,9) AS Acct8_GlCode
  ,SUBSTRING(Acct7.ACCT_NBR,17,5) AS Acct8_Glc
  ,SUBSTRING(Acct7.ACCT_NBR,22,4) AS Acct8_Qual2
  ,LEFT(Acct7.ACCT_CUSTODIAL_ACCT,8) AS Acct8_CustodialStateOrgUnit
  ,LEFT(Acct7.ACCT_CUSTODIAL_ACCT,16) AS Acct8_CustodialOrgUnit
  ,SUBSTRING(Acct7.ACCT_CUSTODIAL_ACCT,9,6) AS Acct8_CustodialQual1
  ,SUBSTRING(Acct7.ACCT_CUSTODIAL_ACCT,15,2) AS Acct8_CustodialLocation
  ,SUBSTRING(Acct7.ACCT_CUSTODIAL_ACCT,17,9) AS Acct8_CustodialGlCode
  ,SUBSTRING(Acct7.ACCT_CUSTODIAL_ACCT,17,5) AS Acct8_CustodialGlc
  ,SUBSTRING(Acct7.ACCT_CUSTODIAL_ACCT,22,4) AS Acct8_CustodialQual2
  ,Acct7.SPLIT_PCT AS Acct8_SplitPercentage
  ,Acct7.AMT AS Acct8_Amount
  ,Acct7.EXTRA_COST_IND AS Acct8_ExtraCostInd
  ,Acct8.ACCT_NBR AS Acct9_AccountNumber
  ,LEFT(Acct8.ACCT_NBR,8) AS Acct9_StateOrgUnit
  ,LEFT(Acct8.ACCT_NBR,16) AS Acct9_OrgUnit
  ,SUBSTRING(Acct8.ACCT_NBR,9,6) AS Acct9_Qual1
  ,SUBSTRING(Acct8.ACCT_NBR,15,2) AS Acct9_Location
  ,SUBSTRING(Acct8.ACCT_NBR,17,9) AS Acct9_GlCode
  ,SUBSTRING(Acct8.ACCT_NBR,17,5) AS Acct9_Glc
  ,SUBSTRING(Acct8.ACCT_NBR,22,4) AS Acct9_Qual2
  ,LEFT(Acct8.ACCT_CUSTODIAL_ACCT,8) AS Acct9_CustodialStateOrgUnit
  ,LEFT(Acct8.ACCT_CUSTODIAL_ACCT,16) AS Acct9_CustodialOrgUnit
  ,SUBSTRING(Acct8.ACCT_CUSTODIAL_ACCT,9,6) AS Acct9_CustodialQual1
  ,SUBSTRING(Acct8.ACCT_CUSTODIAL_ACCT,15,2) AS Acct9_CustodialLocation
  ,SUBSTRING(Acct8.ACCT_CUSTODIAL_ACCT,17,9) AS Acct9_CustodialGlCode
  ,SUBSTRING(Acct8.ACCT_CUSTODIAL_ACCT,17,5) AS Acct9_CustodialGlc
  ,SUBSTRING(Acct8.ACCT_CUSTODIAL_ACCT,22,4) AS Acct9_CustodialQual2
  ,Acct8.SPLIT_PCT AS Acct9_SplitPercentage
  ,Acct8.AMT AS Acct9_Amount
  ,Acct8.EXTRA_COST_IND AS Acct9_ExtraCostInd
  ,Acct9.ACCT_NBR AS Acct10_AccountNumber
  ,LEFT(Acct9.ACCT_NBR,8) AS Acct10_StateOrgUnit
  ,LEFT(Acct9.ACCT_NBR,16) AS Acct10_OrgUnit
  ,SUBSTRING(Acct9.ACCT_NBR,9,6) AS Acct10_Qual1
  ,SUBSTRING(Acct9.ACCT_NBR,15,2) AS Acct10_Location
  ,SUBSTRING(Acct9.ACCT_NBR,17,9) AS Acct10_GlCode
  ,SUBSTRING(Acct9.ACCT_NBR,17,5) AS Acct10_Glc
  ,SUBSTRING(Acct9.ACCT_NBR,22,4) AS Acct10_Qual2
  ,LEFT(Acct9.ACCT_CUSTODIAL_ACCT,8) AS Acct10_CustodialStateOrgUnit
  ,LEFT(Acct9.ACCT_CUSTODIAL_ACCT,16) AS Acct10_CustodialOrgUnit
  ,SUBSTRING(Acct9.ACCT_CUSTODIAL_ACCT,9,6) AS Acct10_CustodialQual1
  ,SUBSTRING(Acct9.ACCT_CUSTODIAL_ACCT,15,2) AS Acct10_CustodialLocation
  ,SUBSTRING(Acct9.ACCT_CUSTODIAL_ACCT,17,9) AS Acct10_CustodialGlCode
  ,SUBSTRING(Acct9.ACCT_CUSTODIAL_ACCT,17,5) AS Acct10_CustodialGlc
  ,SUBSTRING(Acct9.ACCT_CUSTODIAL_ACCT,22,4) AS Acct10_CustodialQual2
  ,Acct9.SPLIT_PCT AS Acct10_SplitPercentage
  ,Acct9.AMT AS Acct10_Amount
  ,Acct9.EXTRA_COST_IND AS Acct10_ExtraCostInd
  ,EncAcct0.ACCT_ENCUMBERED_ACCT AS EncumberedAcct1_AccountNumber
  ,LEFT(EncAcct0.ACCT_ENCUMBERED_ACCT,8) AS EncumberedAcct1StateOrgUnit
  ,LEFT(EncAcct0.ACCT_ENCUMBERED_ACCT,16) AS EncumberedAcct1OrgUnit
  ,SUBSTRING(EncAcct0.ACCT_ENCUMBERED_ACCT,9,6) AS EncumberedAcct1Qual1
  ,SUBSTRING(EncAcct0.ACCT_ENCUMBERED_ACCT,15,2) AS EncumberedAcct1Location
  ,SUBSTRING(EncAcct0.ACCT_ENCUMBERED_ACCT,17,9) AS EncumberedAcct1GlCode
  ,SUBSTRING(EncAcct0.ACCT_ENCUMBERED_ACCT,17,5) AS EncumberedAcct1Glc
  ,SUBSTRING(EncAcct0.ACCT_ENCUMBERED_ACCT,22,4) AS EncumberedAcct1Qual2
  ,EncAcct0.ENCUMBERED_AMT AS EncumberedAcct1_Amount
  ,EncAcct0.ENCUMBERED_WORK_AMT AS EncumberedAcct1_WorkAmount

  ,EncAcct1.ACCT_ENCUMBERED_ACCT AS EncumberedAcct2_AccountNumber
  ,LEFT(EncAcct1.ACCT_ENCUMBERED_ACCT,8) AS EncumberedAcct2StateOrgUnit
  ,LEFT(EncAcct1.ACCT_ENCUMBERED_ACCT,16) AS EncumberedAcct2OrgUnit
  ,SUBSTRING(EncAcct1.ACCT_ENCUMBERED_ACCT,9,6) AS EncumberedAcct2Qual1
  ,SUBSTRING(EncAcct1.ACCT_ENCUMBERED_ACCT,15,2) AS EncumberedAcct2Location
  ,SUBSTRING(EncAcct1.ACCT_ENCUMBERED_ACCT,17,9) AS EncumberedAcct2GlCode
  ,SUBSTRING(EncAcct1.ACCT_ENCUMBERED_ACCT,17,5) AS EncumberedAcct2Glc
  ,SUBSTRING(EncAcct1.ACCT_ENCUMBERED_ACCT,22,4) AS EncumberedAcct2Qual2
  ,EncAcct1.ENCUMBERED_AMT AS EncumberedAcct2_Amount
  ,EncAcct1.ENCUMBERED_WORK_AMT AS EncumberedAcct2_WorkAmount

  ,EncAcct2.ACCT_ENCUMBERED_ACCT AS EncumberedAcct3_AccountNumber
  ,LEFT(EncAcct2.ACCT_ENCUMBERED_ACCT,8) AS EncumberedAcct3StateOrgUnit
  ,LEFT(EncAcct2.ACCT_ENCUMBERED_ACCT,16) AS EncumberedAcct3OrgUnit
  ,SUBSTRING(EncAcct2.ACCT_ENCUMBERED_ACCT,9,6) AS EncumberedAcct3Qual1
  ,SUBSTRING(EncAcct2.ACCT_ENCUMBERED_ACCT,15,2) AS EncumberedAcct3Location
  ,SUBSTRING(EncAcct2.ACCT_ENCUMBERED_ACCT,17,9) AS EncumberedAcct3GlCode
  ,SUBSTRING(EncAcct2.ACCT_ENCUMBERED_ACCT,17,5) AS EncumberedAcct3Glc
  ,SUBSTRING(EncAcct2.ACCT_ENCUMBERED_ACCT,22,4) AS EncumberedAcct3Qual2
  ,EncAcct2.ENCUMBERED_AMT AS EncumberedAcct3_Amount
  ,EncAcct2.ENCUMBERED_WORK_AMT AS EncumberedAcct3_WorkAmount

  ,EncAcct3.ACCT_ENCUMBERED_ACCT AS EncumberedAcct4_AccountNumber
  ,LEFT(EncAcct3.ACCT_ENCUMBERED_ACCT,8) AS EncumberedAcct4StateOrgUnit
  ,LEFT(EncAcct3.ACCT_ENCUMBERED_ACCT,16) AS EncumberedAcct4OrgUnit
  ,SUBSTRING(EncAcct3.ACCT_ENCUMBERED_ACCT,9,6) AS EncumberedAcct4Qual1
  ,SUBSTRING(EncAcct3.ACCT_ENCUMBERED_ACCT,15,2) AS EncumberedAcct4Location
  ,SUBSTRING(EncAcct3.ACCT_ENCUMBERED_ACCT,17,9) AS EncumberedAcct4GlCode
  ,SUBSTRING(EncAcct3.ACCT_ENCUMBERED_ACCT,17,5) AS EncumberedAcct4Glc
  ,SUBSTRING(EncAcct3.ACCT_ENCUMBERED_ACCT,22,4) AS EncumberedAcct4Qual2
  ,EncAcct3.ENCUMBERED_AMT AS EncumberedAcct4_Amount
  ,EncAcct3.ENCUMBERED_WORK_AMT AS EncumberedAcct4_WorkAmount

  ,EncAcct4.ACCT_ENCUMBERED_ACCT AS EncumberedAcct5_AccountNumber
  ,LEFT(EncAcct4.ACCT_ENCUMBERED_ACCT,8) AS EncumberedAcct5StateOrgUnit
  ,LEFT(EncAcct4.ACCT_ENCUMBERED_ACCT,16) AS EncumberedAcct5OrgUnit
  ,SUBSTRING(EncAcct4.ACCT_ENCUMBERED_ACCT,9,6) AS EncumberedAcct5Qual1
  ,SUBSTRING(EncAcct4.ACCT_ENCUMBERED_ACCT,15,2) AS EncumberedAcct5Location
  ,SUBSTRING(EncAcct4.ACCT_ENCUMBERED_ACCT,17,9) AS EncumberedAcct5GlCode
  ,SUBSTRING(EncAcct4.ACCT_ENCUMBERED_ACCT,17,5) AS EncumberedAcct5Glc
  ,SUBSTRING(EncAcct4.ACCT_ENCUMBERED_ACCT,22,4) AS EncumberedAcct5Qual2
  ,EncAcct4.ENCUMBERED_AMT AS EncumberedAcct5_Amount
  ,EncAcct4.ENCUMBERED_WORK_AMT AS EncumberedAcct5_WorkAmount

  ,EncAcct5.ACCT_ENCUMBERED_ACCT AS EncumberedAcct6_AccountNumber
  ,LEFT(EncAcct5.ACCT_ENCUMBERED_ACCT,8) AS EncumberedAcct6StateOrgUnit
  ,LEFT(EncAcct5.ACCT_ENCUMBERED_ACCT,16) AS EncumberedAcct6OrgUnit
  ,SUBSTRING(EncAcct5.ACCT_ENCUMBERED_ACCT,9,6) AS EncumberedAcct6Qual1
  ,SUBSTRING(EncAcct5.ACCT_ENCUMBERED_ACCT,15,2) AS EncumberedAcct6Location
  ,SUBSTRING(EncAcct5.ACCT_ENCUMBERED_ACCT,17,9) AS EncumberedAcct6GlCode
  ,SUBSTRING(EncAcct5.ACCT_ENCUMBERED_ACCT,17,5) AS EncumberedAcct6Glc
  ,SUBSTRING(EncAcct5.ACCT_ENCUMBERED_ACCT,22,4) AS EncumberedAcct6Qual2
  ,EncAcct5.ENCUMBERED_AMT AS EncumberedAcct6_Amount
  ,EncAcct5.ENCUMBERED_WORK_AMT AS EncumberedAcct6_WorkAmount

  ,EncAcct6.ACCT_ENCUMBERED_ACCT AS EncumberedAcct7_AccountNumber
  ,LEFT(EncAcct6.ACCT_ENCUMBERED_ACCT,8) AS EncumberedAcct7StateOrgUnit
  ,LEFT(EncAcct6.ACCT_ENCUMBERED_ACCT,16) AS EncumberedAcct7OrgUnit
  ,SUBSTRING(EncAcct6.ACCT_ENCUMBERED_ACCT,9,6) AS EncumberedAcct7Qual1
  ,SUBSTRING(EncAcct6.ACCT_ENCUMBERED_ACCT,15,2) AS EncumberedAcct7Location
  ,SUBSTRING(EncAcct6.ACCT_ENCUMBERED_ACCT,17,9) AS EncumberedAcct7GlCode
  ,SUBSTRING(EncAcct6.ACCT_ENCUMBERED_ACCT,17,5) AS EncumberedAcct7Glc
  ,SUBSTRING(EncAcct6.ACCT_ENCUMBERED_ACCT,22,4) AS EncumberedAcct7Qual2
  ,EncAcct6.ENCUMBERED_AMT AS EncumberedAcct7_Amount
  ,EncAcct6.ENCUMBERED_WORK_AMT AS EncumberedAcct7_WorkAmount

  ,EncAcct7.ACCT_ENCUMBERED_ACCT AS EncumberedAcct8_AccountNumber
  ,LEFT(EncAcct7.ACCT_ENCUMBERED_ACCT,8) AS EncumberedAcct8StateOrgUnit
  ,LEFT(EncAcct7.ACCT_ENCUMBERED_ACCT,16) AS EncumberedAcct8OrgUnit
  ,SUBSTRING(EncAcct7.ACCT_ENCUMBERED_ACCT,9,6) AS EncumberedAcct8Qual1
  ,SUBSTRING(EncAcct7.ACCT_ENCUMBERED_ACCT,15,2) AS EncumberedAcct8Location
  ,SUBSTRING(EncAcct7.ACCT_ENCUMBERED_ACCT,17,9) AS EncumberedAcct8GlCode
  ,SUBSTRING(EncAcct7.ACCT_ENCUMBERED_ACCT,17,5) AS EncumberedAcct8Glc
  ,SUBSTRING(EncAcct7.ACCT_ENCUMBERED_ACCT,22,4) AS EncumberedAcct8Qual2
  ,EncAcct7.ENCUMBERED_AMT AS EncumberedAcct8_Amount
  ,EncAcct7.ENCUMBERED_WORK_AMT AS EncumberedAcct8_WorkAmount

  ,EncAcct8.ACCT_ENCUMBERED_ACCT AS EncumberedAcct9_AccountNumber
  ,LEFT(EncAcct8.ACCT_ENCUMBERED_ACCT,8) AS EncumberedAcct9StateOrgUnit
  ,LEFT(EncAcct8.ACCT_ENCUMBERED_ACCT,16) AS EncumberedAcct9OrgUnit
  ,SUBSTRING(EncAcct8.ACCT_ENCUMBERED_ACCT,9,6) AS EncumberedAcct9Qual1
  ,SUBSTRING(EncAcct8.ACCT_ENCUMBERED_ACCT,15,2) AS EncumberedAcct9Location
  ,SUBSTRING(EncAcct8.ACCT_ENCUMBERED_ACCT,17,9) AS EncumberedAcct9GlCode
  ,SUBSTRING(EncAcct8.ACCT_ENCUMBERED_ACCT,17,5) AS EncumberedAcct9Glc
  ,SUBSTRING(EncAcct8.ACCT_ENCUMBERED_ACCT,22,4) AS EncumberedAcct9Qual2
  ,EncAcct8.ENCUMBERED_AMT AS EncumberedAcct9_Amount
  ,EncAcct8.ENCUMBERED_WORK_AMT AS EncumberedAcct9_WorkAmount

  ,EncAcct9.ACCT_ENCUMBERED_ACCT AS EncumberedAcct10_AccountNumber
  ,LEFT(EncAcct9.ACCT_ENCUMBERED_ACCT,8) AS EncumberedAcct10StateOrgUnit
  ,LEFT(EncAcct9.ACCT_ENCUMBERED_ACCT,16) AS EncumberedAcct10OrgUnit
  ,SUBSTRING(EncAcct9.ACCT_ENCUMBERED_ACCT,9,6) AS EncumberedAcct10Qual1
  ,SUBSTRING(EncAcct9.ACCT_ENCUMBERED_ACCT,15,2) AS EncumberedAcct10Location
  ,SUBSTRING(EncAcct9.ACCT_ENCUMBERED_ACCT,17,9) AS EncumberedAcct10GlCode
  ,SUBSTRING(EncAcct9.ACCT_ENCUMBERED_ACCT,17,5) AS EncumberedAcct10Glc
  ,SUBSTRING(EncAcct9.ACCT_ENCUMBERED_ACCT,22,4) AS EncumberedAcct10Qual2
  ,EncAcct9.ENCUMBERED_AMT AS EncumberedAcct10_Amount
  ,EncAcct9.ENCUMBERED_WORK_AMT AS EncumberedAcct10_WorkAmount


FROM dbo.FIP_PO_DET PoDet
LEFT OUTER JOIN FIP_TABLES StatusDesc
ON
(
   StatusDesc.STATUS_CODE = PoDet.DET_STATUS
)
LEFT OUTER JOIN FIP_TABLES FinStatusDesc
ON
(
    FinStatusDesc.STATUS_CODE = PoDet.FIN_STATUS
)

LEFT OUTER JOIN FIP_TABLES RecStatDesc
ON
(
   RecStatDesc.STATUS_CODE = PoDet.REC_STATUS
)

LEFT OUTER JOIN FIP_TABLES PayStatDesc
ON
(
    PayStatDesc.STATUS_CODE = PoDet.PAY_STATUS
)
LEFT OUTER JOIN FIP_TABLES BuyerName
ON
(
    BuyerName.BUYER_ID = PoDet.BUYER_ID
)
LEFT OUTER JOIN FIP_TABLES UOM
ON
(
   UOM.UNIT_MEAS_CODE = PoDet.UNIT_MEAS
)
LEFT OUTER JOIN FIP_COMMODITY Comm
ON
(
   Comm.CC_COMMODITY_CODE = PoDet.COMMODITY_CODE
)
LEFT OUTER JOIN SECURITY_USER_A2 RecUser
ON
(
   RecUser.USER_ID = PoDet.RECEIVING_USER_ID
)
LEFT OUTER JOIN FIP_PO_DET_ACCOUNT_DET Acct0
ON
(
    PoDet.ISN_FIP_PO_DET = Acct0.ISN_FIP_PO_DET
    AND Acct0.cnxarraycolumn = 0
)
LEFT OUTER JOIN FIP_PO_DET_ACCOUNT_DET Acct1
ON
(
    PoDet.ISN_FIP_PO_DET = Acct1.ISN_FIP_PO_DET
    AND Acct1.cnxarraycolumn = 1
)
LEFT OUTER JOIN FIP_PO_DET_ACCOUNT_DET Acct2
ON
(
    PoDet.ISN_FIP_PO_DET = Acct2.ISN_FIP_PO_DET
    AND Acct2.cnxarraycolumn = 2
)
LEFT OUTER JOIN FIP_PO_DET_ACCOUNT_DET Acct3
ON
(
    PoDet.ISN_FIP_PO_DET = Acct3.ISN_FIP_PO_DET
    AND Acct3.cnxarraycolumn = 3
)
LEFT OUTER JOIN FIP_PO_DET_ACCOUNT_DET Acct4
ON
(
    PoDet.ISN_FIP_PO_DET = Acct4.ISN_FIP_PO_DET
    AND Acct4.cnxarraycolumn = 4
)
LEFT OUTER JOIN FIP_PO_DET_ACCOUNT_DET Acct5
ON
(
    PoDet.ISN_FIP_PO_DET = Acct5.ISN_FIP_PO_DET
    AND Acct5.cnxarraycolumn = 5
)
LEFT OUTER JOIN FIP_PO_DET_ACCOUNT_DET Acct6
ON
(
    PoDet.ISN_FIP_PO_DET = Acct6.ISN_FIP_PO_DET
    AND Acct6.cnxarraycolumn = 6
)
LEFT OUTER JOIN FIP_PO_DET_ACCOUNT_DET Acct7
ON
(
    PoDet.ISN_FIP_PO_DET = Acct7.ISN_FIP_PO_DET
    AND Acct7.cnxarraycolumn = 7
)
LEFT OUTER JOIN FIP_PO_DET_ACCOUNT_DET Acct8
ON
(
    PoDet.ISN_FIP_PO_DET = Acct8.ISN_FIP_PO_DET
    AND Acct8.cnxarraycolumn = 8
)
LEFT OUTER JOIN FIP_PO_DET_ACCOUNT_DET Acct9
ON
(
    PoDet.ISN_FIP_PO_DET = Acct9.ISN_FIP_PO_DET
    AND Acct9.cnxarraycolumn = 9
)
LEFT OUTER JOIN FIP_PO_DET_ACCT_ENC_DET EncAcct0
ON
(
    PoDet.ISN_FIP_PO_DET = EncAcct0.ISN_FIP_PO_DET
    AND EncAcct0.cnxarraycolumn = 0
)
LEFT OUTER JOIN FIP_PO_DET_ACCT_ENC_DET EncAcct1
ON
(
    PoDet.ISN_FIP_PO_DET = EncAcct1.ISN_FIP_PO_DET
    AND EncAcct1.cnxarraycolumn = 1
)
LEFT OUTER JOIN FIP_PO_DET_ACCT_ENC_DET EncAcct2
ON
(
    PoDet.ISN_FIP_PO_DET = EncAcct2.ISN_FIP_PO_DET
    AND EncAcct2.cnxarraycolumn = 2
)
LEFT OUTER JOIN FIP_PO_DET_ACCT_ENC_DET EncAcct3
ON
(
    PoDet.ISN_FIP_PO_DET = EncAcct3.ISN_FIP_PO_DET
    AND EncAcct3.cnxarraycolumn = 3
)
LEFT OUTER JOIN FIP_PO_DET_ACCT_ENC_DET EncAcct4
ON
(
    PoDet.ISN_FIP_PO_DET = EncAcct4.ISN_FIP_PO_DET
    AND EncAcct4.cnxarraycolumn = 4
)
LEFT OUTER JOIN FIP_PO_DET_ACCT_ENC_DET EncAcct5
ON
(
    PoDet.ISN_FIP_PO_DET = EncAcct5.ISN_FIP_PO_DET
    AND EncAcct5.cnxarraycolumn = 5
)
LEFT OUTER JOIN FIP_PO_DET_ACCT_ENC_DET EncAcct6
ON
(
    PoDet.ISN_FIP_PO_DET = EncAcct6.ISN_FIP_PO_DET
    AND EncAcct6.cnxarraycolumn = 6
)
LEFT OUTER JOIN FIP_PO_DET_ACCT_ENC_DET EncAcct7
ON
(
    PoDet.ISN_FIP_PO_DET = EncAcct7.ISN_FIP_PO_DET
    AND EncAcct7.cnxarraycolumn = 7
)
LEFT OUTER JOIN FIP_PO_DET_ACCT_ENC_DET EncAcct8
ON
(
    PoDet.ISN_FIP_PO_DET = EncAcct8.ISN_FIP_PO_DET
    AND EncAcct8.cnxarraycolumn = 8
)
LEFT OUTER JOIN FIP_PO_DET_ACCT_ENC_DET EncAcct9
ON
(
    PoDet.ISN_FIP_PO_DET = EncAcct9.ISN_FIP_PO_DET
    AND EncAcct9.cnxarraycolumn = 9
)