W:\PropAcctg_FOE\OFFICIAL\2019\ACCRUALS\WIP Overlay\Feb'19\10X01 SQL.xls|||`'1192$'`
False
False
10X01 SQL.xls
Table=`'1192$'`
W:\PropAcctg_FOE\OFFICIAL\2019\ACCRUALS\WIP Overlay\Feb'19\10X01 SQL.xls|||`'3089$'`
False
False
10X01 SQL.xls
Table=`'3089$'`
W:\PropAcctg_FOE\OFFICIAL\2019\ACCRUALS\WIP Overlay\Feb'19\10X01 SQL.xls|||`'6533$'`
False
False
10X01 SQL.xls
Table=`'6533$'`
W:\PropAcctg_FOE\OFFICIAL\2019\ACCRUALS\WIP Overlay\Feb'19\10X01 SQL.xls|||`'6651$'`
False
False
10X01 SQL.xls
Table=`'6651$'`
W:\PropAcctg_FOE\OFFICIAL\2019\ACCRUALS\WIP Overlay\Feb'19\10X01 SQL.xls|||`'6663$'`
False
False
10X01 SQL.xls
Table=`'6663$'`
W:\PropAcctg_FOE\OFFICIAL\2019\ACCRUALS\WIP Overlay\Feb'19\10X01 SQL.xls|||`'6820$'`
False
False
10X01 SQL.xls
Table=`'6820$'`
Warning
Subset
ByName
#1
#2
#3
#4
#5
#6
#7
USD Amount = IF [CURRENCY_CD]="EUR" then [SUM(A#RESOURCE_AMOUNT)]*1.2010
Elseif ...
"BUSINESS_UNIT","BUSINESS_UNIT_PO","PROJ_JOB1_DT","LATE_FINISH_DT","PROJECT_ID","PROJ_DESCR","ACTIVITY_ID","ACT_DESCR","PO_ID","INVOICE","PO_DESCR","LINE_NBR","SCHED_NBR","ACCOUNTING_DT","JOURNAL_DT","TRANS_DT","DOCTAG_ISD","DOCTAG_CAP_MTHD","ACCOUNT","ACTIVITY_USER2","ASSET_CAP_MTHD","LIFE","ACCOUNT_1","PIN","DEPTID","CURRENCY_CD","SUM(A#RESOURCE_AMOUNT)"
True
True
True
False
True
False
False
False
False
upper
W:\PropAcctg_FOE\OFFICIAL\2019\ACCRUALS\WIP Overlay\Feb'19\10X01 SQL.xls|||`'6624$'`
False
False
10X01 SQL.xls
Table=`'6624$'`
W:\PropAcctg_FOE\OFFICIAL\2019\ACCRUALS\WIP Overlay\Feb'19\Reference file.xlsx|||`Sheet1$`
False
1
Reference file.xlsx
Table=`Sheet1$`
C:\Users\phemala1\Documents\Alteryx\BT Input\MANUAL_CAP.xls|||`sheet1$`
False
False
MANUAL_CAP.xls
Table=`sheet1$`
C:\Users\phemala1\Documents\Alteryx\BT Input\Dic code file.xlsx|||`Sheet1$`
False
0
Dic code file.xlsx
Table=`Sheet1$`
C:\Users\phemala1\Documents\Alteryx\BT Input\PENDING_CAP.xls|||`sheet1$`
False
False
PENDING_CAP.xls
Table=`sheet1$`
Warning
All
ByName
C:\Users\phemala1\Documents\Alteryx\BT Input\CAP_ERRORS.xls|||`sheet1$`
False
False
CAP_ERRORS.xls
Table=`sheet1$`
C:\Users\phemala1\Desktop\USD Amount.xlsx|||Sheet1
RemoveFile
USD Amount.xlsx
Table=Sheet1
Horizontal
BT requirement_latest