{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["List Process","490000028","490000029"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"List Process","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[490000028,"Accounts Payable by Period"]
[490000029,"Accounts Payable Historical"]

{"sheet":"490000028","index":1,"n_rows":82,"n_cols":7,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["tableAlias","tableName","name","columnGroupHeading","columnHeading","calculation","Oncalculation"]
["UDM_AP_HIST","UDM_AP_HIST","COMPANYID","Company","ID"]
["UDM_DIMCOMPANY","UDM_DIMCOMPANY","COMPANYNAME","Company","Name"]
["UDM_DIMCOMPANY","UDM_DIMCOMPANY","LEDCUR","Ledger","Currency"]
["UDM_AP_HIST","UDM_AP_HIST","SITEID","Site","ID"]
["UDM_DIMSITES","UDM_DIMSITES","FCYNAM","Site","Name"]
["UDM_AP_HIST","UDM_AP_HIST","VENDID","Vendor","ID"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","VENDNAME","Vendor","Name"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","STATGROUP1","Vendor Stat Group","Code 1"]
["UDM_DESCRIPTION","UDM_DESCRIPTION","DESCRIPTION","Vendor Stat Group","Desc 1"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","STATGROUP2","Vendor Stat Group","Code 2"]
["UDM_DESCRIPTION_1","UDM_DESCRIPTION","DESCRIPTION","Vendor Stat Group","Desc 2"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","STATGROUP3","Vendor Stat Group","Code 3"]
["UDM_DESCRIPTION_2","UDM_DESCRIPTION","DESCRIPTION","Vendor Stat Group","Desc 3"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","STATGROUP4","Vendor Stat Group","Code 4"]
["UDM_DESCRIPTION_3","UDM_DESCRIPTION","DESCRIPTION","Vendor Stat Group","Desc 4"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","STATGROUP5","Vendor Stat Group","Code 5"]
["UDM_DESCRIPTION_4","UDM_DESCRIPTION","DESCRIPTION","Vendor Stat Group","Desc 5"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD01","Vendor UDF 01","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD01DESC","Vendor UDF 01","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD02","Vendor UDF 02","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD02DESC","Vendor UDF 02","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD03","Vendor UDF 03","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD03DESC","Vendor UDF 03","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD04","Vendor UDF 04","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD04DESC","Vendor UDF 04","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD05","Vendor UDF 05","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD05DESC","Vendor UDF 05","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD06","Vendor UDF 06","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD06DESC","Vendor UDF 06","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD07","Vendor UDF 07","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD07DESC","Vendor UDF 07","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD08","Vendor UDF 08","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD08DESC","Vendor UDF 08","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD09","Vendor UDF 09","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD09DESC","Vendor UDF 09","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD10","Vendor UDF 10","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD10DESC","Vendor UDF 10","Desc"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","COUNTRY",null,"Country"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","PROVINCESTATE",null,"State"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","CITY",null,"City"]
["UDM_AP_HIST","UDM_AP_HIST","FISYEAR","Fiscal","Year"]
["UDM_AP_HIST","UDM_AP_HIST","FISPER","Fiscal","Period"]
["UDM_AP_HIST","UDM_AP_HIST","PERID","Fiscal","Period ID"]
["*SERVER","*SERVER","FLD00000021","Calendar","Year","BI_YEAR(:UDM_DIM_FISCALPERIOD.ENDDATE:)"]
["*SERVER","*SERVER","FLD00000022","Calendar","Period","BI_MONTH(:UDM_DIM_FISCALPERIOD.ENDDATE:)"]
["*SERVER","*SERVER","FLD00000023","Calendar","Period ID","BI_YEAR(:UDM_DIM_FISCALPERIOD.ENDDATE:) * 100\n+ BI_MONTH(:UDM_DIM_FISCALPERIOD.ENDDATE:)"]
["UDM_AP_HIST","UDM_AP_HIST","ACCOUNTID","Account","ID"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCOUNTDESC","Account","Description"]
["UDM_AP_HIST","UDM_AP_HIST","DOCNUM","Document","Number"]
["UDM_AP_HIST","UDM_AP_HIST","DOCTYP","Document","Type"]
["UDM_AP_HIST","UDM_AP_HIST","DOCDATE","Document","Date"]
["UDM_AP_HIST","UDM_AP_HIST","DUEDATE","Document","Due Date"]
["*SERVER","*SERVER","FLD0000001",null,"Aging Category","CASE\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND (BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) <= 0\nOR UDM_AP_HIST.REMBALFLAG = 1)\nTHEN 'Current Amount'\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND (BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) <= 0\nOR UDM_AP_HIST.REMBALFLAG = 1)\nTHEN 'Current Amount'\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) BETWEEN @@UDM_APBUCKET01_MIN AND @@UDM_APBUCKET01_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET01_MIN-@@UDM_APBUCKET01_MAX Days'\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) BETWEEN @@UDM_APBUCKET01_MIN AND @@UDM_APBUCKET01_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET01_MIN-@@UDM_APBUCKET01_MAX Days'\n\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) BETWEEN @@UDM_APBUCKET02_MIN AND @@UDM_APBUCKET02_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET02_MIN-@@UDM_APBUCKET02_MAX Days'\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) BETWEEN @@UDM_APBUCKET02_MIN AND @@UDM_APBUCKET02_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET02_MIN-@@UDM_APBUCKET02_MAX Days'\n\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) BETWEEN @@UDM_APBUCKET03_MIN AND @@UDM_APBUCKET03_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET03_MIN-@@UDM_APBUCKET03_MAX Days'\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) BETWEEN @@UDM_APBUCKET03_MIN AND @@UDM_APBUCKET03_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET03_MIN-@@UDM_APBUCKET03_MAX Days'\n\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) >= @@UDM_APBUCKET04\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET04+ Days'\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) >= @@UDM_APBUCKET04\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET04+ Days'\n\n\nEND"]
["*SERVER","*SERVER","FLD0000002",null,"Current Amount","CASE\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND (BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) <= 0\nOR UDM_AP_HIST.REMBALFLAG = 1)\nTHEN [Amount Due]\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND (BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) <= 0\nOR UDM_AP_HIST.REMBALFLAG = 1)\nTHEN [Amount Due]\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD0000003","Overdue","@@UDM_APBUCKET01_MIN-@@UDM_APBUCKET01_MAX Days","CASE\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) BETWEEN @@UDM_APBUCKET01_MIN AND @@UDM_APBUCKET01_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN [Amount Due]\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) BETWEEN @@UDM_APBUCKET01_MIN AND @@UDM_APBUCKET01_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN [Amount Due]\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD0000004","Overdue","@@UDM_APBUCKET02_MIN-@@UDM_APBUCKET02_MAX Days","CASE\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) BETWEEN @@UDM_APBUCKET02_MIN AND @@UDM_APBUCKET02_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN [Amount Due]\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) BETWEEN @@UDM_APBUCKET02_MIN AND @@UDM_APBUCKET02_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN [Amount Due]\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD0000005","Overdue","@@UDM_APBUCKET03_MIN-@@UDM_APBUCKET03_MAX Days","CASE\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) BETWEEN @@UDM_APBUCKET03_MIN AND @@UDM_APBUCKET03_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN [Amount Due]\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) BETWEEN @@UDM_APBUCKET03_MIN AND @@UDM_APBUCKET03_MAX\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN [Amount Due]\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD0000006","Overdue","@@UDM_APBUCKET04+ Days","CASE\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) >= @@UDM_APBUCKET04\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN [Amount Due]\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) >= @@UDM_APBUCKET04\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN [Amount Due]\n\nELSE 0\nEND"]
["UDM_DIM_FISCALPERIOD","UDM_DIM_FISCALPERIOD","NUMBEROFDAYS",null,"Number of Days"]
["UDM_AP_HIST","UDM_AP_HIST","AMTDUEHC",null,"Amount Due"]
["*SERVER","*SERVER","FLD0000007",null,"Amount Overdue","CASE\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) > 0\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN [Amount Due]\n\nWHEN BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) > 0\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN [Amount Due]\n\nELSE 0\nEND"]
["UDM_AP_HIST","UDM_AP_HIST","SUPPUR",null,"Supplier Purchases"]
["*SERVER","*SERVER","FLD0000008",null,"Overdue Ratio",0,"if([Amount Due] !== 0)\nnecResult = [Amount Overdue] / [Amount Due];\nelse\nnecResult = 0;"]
["UDM_AP_HIST","UDM_AP_HIST","AMTDUEHCLM","Last Month","Amount Due"]
["UDM_AP_HIST","UDM_AP_HIST","AMTOVERDUELM","Last Month","Amount Overdue"]
["UDM_AP_HIST","UDM_AP_HIST","SUPPURLM","Last Month","Supplier Purchases"]
["*SERVER","*SERVER","FLD0000009","Last Month","Overdue Ratio",0,"if([Last Month Amount Due] !== 0)\n\nnecResult= ([Last Month Amount Overdue] / [Last Month Amount Due]);\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000010","M to M Growth","Amount Due",0,"if([Last Month Amount Due]!== 0)\n\nnecResult=([Amount Due] - [Last Month Amount Due]) / [Last Month Amount Due];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000011","M to M Growth","Amount Overdue",0,"if([Last Month Amount Overdue] !== 0)\n\nnecResult=([Amount Overdue] - [Last Month Amount Overdue])/[Last Month Amount Overdue];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000012","M to M Growth","Supplier Purchases",0,"if([Last Month Supplier Purchases] !== 0)\n\nnecResult=([Supplier Purchases] - [Last Month Supplier Purchases]) / [Last Month Supplier Purchases] ;\n\nelse\nnecResult = 0;"]
["UDM_AP_HIST","UDM_AP_HIST","AMTDUEHCLY","Last Year","Amount Due"]
["UDM_AP_HIST","UDM_AP_HIST","AMTOVERDUELY","Last Year","Amount Overdue"]
["UDM_AP_HIST","UDM_AP_HIST","SUPPURLY","Last Year","Supplier Purchases"]
["*SERVER","*SERVER","FLD00000013","Last Year","Overdue Ratio",0,"if([Last Year Amount Due] !== 0)\n\nnecResult= ([Last Year Amount Overdue] / [Last Year Amount Due]);\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000014","Y to Y Growth","Amount Due",0,"if([Last Year Amount Due]!== 0)\n\nnecResult=([Amount Due] - [Last Year Amount Due]) / [Last Year Amount Due];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000015","Y to Y Growth","Amount Overdue",0,"if([Last Year Amount Overdue] !== 0)\n\nnecResult=([Amount Overdue] - [Last Year Amount Overdue])/[Last Year Amount Overdue];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000016","Y to Y Growth","Supplier Purchases",0,"if([Last Year Supplier Purchases]!== 0)\n\nnecResult=([Supplier Purchases] - [Last Year Supplier Purchases]) / [Last Year Supplier Purchases];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000017",null,"Turn Over Ratio",0,"if (([Amount Due] + [Amount Due]LM) !== 0)\n\nnecResult= 2 * [Supplier Purchases] / ([Amount Due] + [Amount Due]LM);\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000018",null,"Payables Deferral Period",0,"if (([Supplier Purchases]) !== 0)\n\nnecResult= [Number of Days] * ([Amount Due] + [Amount Due]LM) / (2 * [Supplier Purchases]);\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000019",null,"Document Count","CASE\nWHEN [Amount Due] <> 0\nTHEN 1\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD00000020",null,"Average Overdue Days","CASE\nWHEN [Amount Due] <> 0\nAND BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) >= 0\nAND BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:) > 0\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN BI_DATEDIFF(:[Document Due Date]:,:UDM_AP_HIST.PERLASTDATE:)\n\nWHEN [Amount Due] <> 0\nAND BI_DATEDIFF(:UDM_AP_HIST.PERLASTDATE:,:BI_GETDATE():) < 0\nAND BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():) > 0\nAND UDM_AP_HIST.REMBALFLAG = 0\nTHEN BI_DATEDIFF(:[Document Due Date]:,:BI_GETDATE():)\n\nELSE NULL\nEND"]

{"sheet":"490000029","index":2,"n_rows":68,"n_cols":7,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["tableAlias","tableName","name","columnGroupHeading","columnHeading","calculation","Oncalculation"]
["UDM_STGAPHIST","UDM_STGAPHIST","COMPANYID","Société","ID"]
["UDM_DIMCOMPANY","UDM_DIMCOMPANY","COMPANYNAME","Société","Nom"]
["UDM_DIMCOMPANY","UDM_DIMCOMPANY","LEDCUR","Devise","Référenciel"]
["UDM_STGAPHIST","UDM_STGAPHIST","SITEID","Site","ID"]
["UDM_DIMSITES","UDM_DIMSITES","FCYNAM","Site","Nom"]
["UDM_STGAPHIST","UDM_STGAPHIST","VENDID","Fournisseur","ID"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","VENDNAME","Fournisseur","Nom"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","STATGROUP1","Fournisseur Famille stat","Code 1"]
["UDM_DESCRIPTION","UDM_DESCRIPTION","DESCRIPTION","Fournisseur Famille stat","Desc 1"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","STATGROUP2","Fournisseur Famille stat","Code 2"]
["UDM_DESCRIPTION_1","UDM_DESCRIPTION","DESCRIPTION","Fournisseur Famille stat","Desc 2"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","STATGROUP3","Fournisseur Famille stat","Code 3"]
["UDM_DESCRIPTION_2","UDM_DESCRIPTION","DESCRIPTION","Fournisseur Famille stat","Desc 3"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","STATGROUP4","Fournisseur Famille stat","Code 4"]
["UDM_DESCRIPTION_3","UDM_DESCRIPTION","DESCRIPTION","Fournisseur Famille stat","Desc 4"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","STATGROUP5","Fournisseur Famille stat","Code 5"]
["UDM_DESCRIPTION_4","UDM_DESCRIPTION","DESCRIPTION","Fournisseur Famille stat","Desc 5"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD01","Fournisseur CDU 01","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD01DESC","Fournisseur CDU 01","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD02","Fournisseur CDU 02","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD02DESC","Fournisseur CDU 02","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD03","Fournisseur CDU 03","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD03DESC","Fournisseur CDU 03","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD04","Fournisseur CDU 04","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD04DESC","Fournisseur CDU 04","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD05","Fournisseur CDU 05","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD05DESC","Fournisseur CDU 05","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD06","Fournisseur CDU 06","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD06DESC","Fournisseur CDU 06","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD07","Fournisseur CDU 07","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD07DESC","Fournisseur CDU 07","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD08","Fournisseur CDU 08","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD08DESC","Fournisseur CDU 08","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD09","Fournisseur CDU 09","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD09DESC","Fournisseur CDU 09","Desc"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD10","Fournisseur CDU 10","Code"]
["UDM_DIMVENDOR","UDM_DIMVENDOR","UDFIELD10DESC","Fournisseur CDU 10","Desc"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","COUNTRY",null,"Pays"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","PROVINCESTATE",null,"État"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","CITY",null,"Ville"]
["UDM_STGAPHIST","UDM_STGAPHIST","ACCOUNTID","Compte","ID"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCOUNTDESC","Compte","Description"]
["UDM_STGAPHIST","UDM_STGAPHIST","DOCNUM","Document","Numéro"]
["UDM_STGAPHIST","UDM_STGAPHIST","DOCTYP","Document","Type"]
["UDM_STGAPHIST","UDM_STGAPHIST","DOCDATE","Document","Date"]
["UDM_STGAPHIST","UDM_STGAPHIST","ORIDOCNUM","Document ajusté","Numéro"]
["UDM_STGAPHIST","UDM_STGAPHIST","ORIDOCTYP","Document ajusté","Type"]
["UDM_STGAPHIST","UDM_STGAPHIST","ORIDOCDATE","Document ajusté","Date"]
["UDM_STGAPHIST","UDM_STGAPHIST","DUEDATE","Document ajusté","Date d'échéance"]
["*SERVER","*SERVER","FLD00000010",null,"Date d'analyse","CASE\nWHEN [Société ID] = [Société ID]\nTHEN BI_TODATE(:'$$DATE','$$FORMAT':)\nEND"]
["*SERVER","*SERVER","FLD0000001",null,"Tranche d'âge","CASE\nWHEN (BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) <= 0\nOR UDM_STGAPHIST.REMBALFLAG = 1)\nTHEN 'Current Amount'\n\n\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) BETWEEN @@UDM_APBUCKET01_MIN AND @@UDM_APBUCKET01_MAX\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET01_MIN-@@UDM_APBUCKET01_MAX Days'\n\n\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) BETWEEN @@UDM_APBUCKET02_MIN AND @@UDM_APBUCKET02_MAX\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET02_MIN-@@UDM_APBUCKET02_MAX Days'\n\n\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) BETWEEN @@UDM_APBUCKET03_MIN AND @@UDM_APBUCKET03_MAX\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET03_MIN-@@UDM_APBUCKET03_MAX Days'\n\n\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= @@UDM_APBUCKET04\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN '@@UDM_APBUCKET04+ Days'\n\n\nEND"]
["*SERVER","*SERVER","FLD0000002","Ledger Curency","Montant non dû","CASE\nWHEN (BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) <= 0\nOR UDM_STGAPHIST.REMBALFLAG = 1)\nTHEN UDM_STGAPHIST.AMOUNTHC\n\n+\nCASE WHEN BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.EXCHRATEADJ ELSE 0 END\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTHC ELSE 0 END\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD0000003","En retard (Pièce)","@@UDM_APBUCKET01_MIN-@@UDM_APBUCKET01_MAX jours","CASE\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) BETWEEN @@UDM_APBUCKET01_MIN AND @@UDM_APBUCKET01_MAX\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN UDM_STGAPHIST.AMOUNTHC\n\n+\nCASE WHEN BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.EXCHRATEADJ ELSE 0 END\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTHC ELSE 0 END\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD0000004","En retard (Pièce)","@@UDM_APBUCKET02_MIN-@@UDM_APBUCKET02_MAX jours","CASE\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) BETWEEN @@UDM_APBUCKET02_MIN AND @@UDM_APBUCKET02_MAX\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN UDM_STGAPHIST.AMOUNTHC\n\n+\nCASE WHEN BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.EXCHRATEADJ ELSE 0 END\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTHC ELSE 0 END\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD0000005","En retard (Pièce)","@@UDM_APBUCKET03_MIN-@@UDM_APBUCKET03_MAX jours","CASE\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) BETWEEN @@UDM_APBUCKET03_MIN AND @@UDM_APBUCKET03_MAX\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN UDM_STGAPHIST.AMOUNTHC\n\n+\nCASE WHEN BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.EXCHRATEADJ ELSE 0 END\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTHC ELSE 0 END\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD0000006","En retard (Pièce)","@@UDM_APBUCKET04+ jours","CASE\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= @@UDM_APBUCKET04\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN UDM_STGAPHIST.AMOUNTHC\n\n+\nCASE WHEN BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.EXCHRATEADJ ELSE 0 END\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTHC ELSE 0 END\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD0000009","Ledger Curency","Montant dû","UDM_STGAPHIST.AMOUNTHC\n\n+\nCASE WHEN BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.EXCHRATEADJ ELSE 0 END\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTHC ELSE 0 END"]
["*SERVER","*SERVER","FLD0000007","Ledger Curency","Montant en retard","CASE\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) > 0\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN UDM_STGAPHIST.AMOUNTHC\n\n+\nCASE WHEN BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.EXCHRATEADJ ELSE 0 END\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTHC ELSE 0 END\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD0000008",null,"Ratio des retards",0,"if([Ledger Curency Montant dû] !== 0)\nnecResult = [Ledger Curency Montant en retard] / [Ledger Curency Montant dû] ;\nelse\nnecResult = 0;"]
["UDM_STGAPHIST","UDM_STGAPHIST","TRANCUR","Devise","Pièce"]
["*SERVER","*SERVER","FLD00000011","Devise de pièce","Montant non dû","CASE\nWHEN (BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) <= 0\nOR UDM_STGAPHIST.REMBALFLAG = 1)\nTHEN UDM_STGAPHIST.AMOUNTTC\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTTC ELSE 0 END\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD00000012","En retard (Pièce)","@@UDM_APBUCKET01_MIN-@@UDM_APBUCKET01_MAX jours","CASE\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) BETWEEN @@UDM_APBUCKET01_MIN AND @@UDM_APBUCKET01_MAX\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN UDM_STGAPHIST.AMOUNTTC\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTTC ELSE 0 END\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD00000013","En retard (Pièce)","@@UDM_APBUCKET02_MIN-@@UDM_APBUCKET02_MAX jours","CASE\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) BETWEEN @@UDM_APBUCKET02_MIN AND @@UDM_APBUCKET02_MAX\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN UDM_STGAPHIST.AMOUNTTC\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTTC ELSE 0 END\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD00000014","En retard (Pièce)","@@UDM_APBUCKET03_MIN-@@UDM_APBUCKET03_MAX jours","CASE\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) BETWEEN @@UDM_APBUCKET03_MIN AND @@UDM_APBUCKET03_MAX\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN UDM_STGAPHIST.AMOUNTTC\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTTC ELSE 0 END\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD00000015","En retard (Pièce)","@@UDM_APBUCKET04+ jours","CASE\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= @@UDM_APBUCKET04\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN UDM_STGAPHIST.AMOUNTTC\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTTC ELSE 0 END\n\nELSE 0\nEND"]
["*SERVER","*SERVER","FLD00000016","Devise de pièc","Montant en retard","UDM_STGAPHIST.AMOUNTTC\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTTC ELSE 0 END"]
["*SERVER","*SERVER","FLD00000017","Devise de pièce","Montant en retard","CASE\nWHEN BI_DATEDIFF(:[Document ajusté Date d'échéance]:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) > 0\nAND UDM_STGAPHIST.REMBALFLAG = 0\nTHEN UDM_STGAPHIST.AMOUNTTC\n\n+ \nCASE WHEN UDM_STGAPHIST.HISTOTYPE = 2 AND BI_DATEDIFF(:UDM_STGAPHIST.APPLDATE:,: BI_TODATE(:'$$DATE','$$FORMAT':) :) >= 0 THEN UDM_STGAPHIST.PAYAMTTC ELSE 0 END\n\nELSE 0\nEND"]