{runquery 1} {runquery 2} {runquery 3} {runquery 4} {runquery 5} {runquery 6} {runquery 7}{runquery 8}{runquery 9}{runquery 10}{runquery 11}{runquery 12} {runquery 13} {runquery 14}

{translatestatictext 'Support Check'.{const language}}

| {translatestatictext 'Description'.{const language}} | {translatestatictext 'Result'.{const language}}
001 | {translatestatictext 'Check for Lost Postings not linked to a reservation and to a financial Account'.{const language}} | {field 1.NumberOfLostPostings} {translatestatictext 'Lost postings'.{const language}} / {translatestatictext 'Amount = '.{const language}}{field 1.amount}
002 | {translatestatictext 'Check for Lost Postings coming from Interface'.{const language}} | {translatestatictext 'Amount = '.{const language}}{field 2.Amount}
003 | {translatestatictext 'Check for open Allowances which should be closed'.{const language}} | {field 3.NUMBEROFAllowances} {translatestatictext 'Incorrect Open Allowances'.{const language}}
004 | {translatestatictext 'Check for Postings from Invoices which are no longer found in the system'.{const language}} | {field 4.NumberOfLostPostings} {translatestatictext 'Lost postings'.{const language}}
005 | {translatestatictext 'Check for Tax Postings whithout corresponding Revenue Record'.{const language}} | {field 5.NUMBEROFLONELYTAXRECORDS} {translatestatictext 'Lost postings'.{const language}}
006 | {translatestatictext 'Check for Tax Postings whithout Main Internal Split Revenue Record'.{const language}} | {field 6.NUMBEROFLONELYTAXRECORDS} {translatestatictext 'Lost postings'.{const language}}
007 | {translatestatictext 'Check for closed Allowances with not enough postings attached'.{const language}} | {field 7.INCORRECTCLOSEALLOWANCE} {translatestatictext 'Incorrect Allowances'.{const language}}
008 | {translatestatictext 'Check for open Allowances with checked out Reservations'.{const language}} | {field 8.INCORRECTOPENALLOWANCE} {translatestatictext 'Incorrect Allowances'.{const language}}
009 | {translatestatictext 'Check for Postings on no Billing Window'.{const language}} | {field 9.PostingWhithoutWindow} {translatestatictext 'Postings on no Billing Window'.{const language}}
010 | {translatestatictext 'Check for Reservations which are not in Balance'.{const language}} | {field 10.reservationsoutofbalance} {translatestatictext 'Reservation(s) out of Balance'.{const language}}
011 | {translatestatictext 'Check for Financial Accounts which are not in Balance'.{const language}} | {field 11.zfacsoutofbalance} {translatestatictext 'Financial Accoount(s) out of Balance'.{const language}}
012 | {translatestatictext 'Check for Net Postings that have same ZPOS_TAXLINK_ID'.{const language}} | {field 12.zposnetduplicatetaxid} {translatestatictext 'Net Posting(s) with duplicate Taxlink ID'.{const language}}

{translatestatictext 'Oracle Health Check'.{const language}}

{translatestatictext 'Parameter'.{const language}} | {translatestatictext 'Recommended Value'.{const language}} | {translatestatictext 'Current Value'.{const language}} | {translatestatictext 'Status'.{const language}}
{forall 13}
{dif '{field 13.Headline}'='1'} {field 13.NameLeft}{/dif}{else} | {field 13.NameLeft} {/else} | {field 13.Recommended_Value} | {field 13.Current_Value} {dif '{field 13.Headline}'='1'} | {/dif}{else} | {dif '{field 13.status}'='red'} {translatestatictext 'BAD'.{const language}} {/dif}{else} {dif '{field 13.status}'='green'} {translatestatictext 'GOOD'.{const language}} {/dif}{else} {dif '{field 13.status}'='orange'} {translatestatictext 'BAD'.{const language}} {/dif}{else} {/else} {/else} {/else} {/else}
{/forall}

{translatestatictext 'Top SQL'.{const language}}

{translatestatictext 'SQL ID'.{const language}} | {translatestatictext 'Exec.Time'.{const language}} | {translatestatictext 'SQL statement'.{const language}}
{forall 14}
{field 14.sql_id} | {field 14.averageexectime} | {field 14.sqltext}
{/forall}