GeMIS_WEB/GUI/b-vesrzahl.w

&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
&ANALYZE-RESUME
/* Connected Databases 
          anadat           PROGRESS
*/
&Scoped-define WINDOW-NAME CURRENT-WINDOW
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS bTableWin 
/*------------------------------------------------------------------------

  File: adm2\src\browser.w

  Description: SmartDataBrowser Object

  Input Parameters:
      <none>

  Output Parameters:
      <none>

------------------------------------------------------------------------*/
/*          This .W file was created with the Progress AppBuilder.      */
/*----------------------------------------------------------------------*/

/* Create an unnamed pool to store all the widgets created 
     by this procedure. This is a good default which assures
     that this procedure's triggers and internal procedures 
     will execute in this procedure's storage, and that proper
     cleanup will occur on deletion of the procedure. */

CREATE WIDGET-POOL.

/* ***************************  Definitions  ************************** */

/* Parameters Definitions ---                                           */

/* Local Variable Definitions ---                                       */

{ incl/tmpbrowser.i }

{src/adm2/widgetprto.i}

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK 

/* ********************  Preprocessor Definitions  ******************** */

&Scoped-define PROCEDURE-TYPE SmartDataBrowser
&Scoped-define DB-AWARE no

&Scoped-define ADM-SUPPORTED-LINKS TableIO-Target,Data-Target,Update-Source

/* Include file with RowObject temp-table definition */
&Scoped-define DATA-FIELD-DEFS "d-vesrzahl.i"

/* Name of designated FRAME-NAME and/or first browse and/or first query */
&Scoped-define FRAME-NAME F-Main
&Scoped-define BROWSE-NAME br_table

/* Internal Tables (found by Frame, Query & Browse Queries)             */
&Scoped-define INTERNAL-TABLES rowObject

/* Definitions for BROWSE br_table                                      */
&Scoped-define FIELDS-IN-QUERY-br_table Trnr Tr_Art Guts_Dat Kunde Faknr ~
Betrag Taxen_01 Referenz Tn_Nr Aufg_Dat Verb_Dat Aufg_Ref Taxen_02 Rj_Cd ~
Mi_Fi_Nr 
&Scoped-define ENABLED-FIELDS-IN-QUERY-br_table 
&Scoped-define QUERY-STRING-br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION
&Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
&Scoped-define TABLES-IN-QUERY-br_table rowObject
&Scoped-define FIRST-TABLE-IN-QUERY-br_table rowObject


/* Definitions for FRAME F-Main                                         */

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS RECT-1 br_table 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */

/* _UIB-PREPROCESSOR-BLOCK-END */
&ANALYZE-RESUME


/* ************************  Function Prototypes ********************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD setZeilenfarbe bTableWin 
FUNCTION setZeilenfarbe RETURNS LOGICAL
    ( ipFarbe AS INT )  FORWARD.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


/* ***********************  Control Definitions  ********************** */


/* Definitions of the field level widgets                               */
DEFINE RECTANGLE RECT-1
    EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL   
    SIZE 166 BY 10.48.

/* Query definitions                                                    */
&ANALYZE-SUSPEND
DEFINE TEMP-TABLE RowObject NO-UNDO
    {{&DATA-FIELD-DEFS}}
    {src/adm2/robjflds.i}.

DEFINE QUERY br_table FOR 
    rowObject SCROLLING.
&ANALYZE-RESUME

/* Browse definitions                                                   */
DEFINE BROWSE br_table
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
    QUERY br_table NO-LOCK DISPLAY
    Trnr FORMAT "9999":U
    Tr_Art COLUMN-LABEL "Art" FORMAT "999":U
    Guts_Dat COLUMN-LABEL "Valuta" FORMAT "99.99.9999":U
    Kunde FORMAT "x(60)":U WIDTH 60
    Faknr FORMAT "x(07)":U
    Betrag FORMAT "zzz,zzz,zz9.99-":U
    Taxen_01 COLUMN-LABEL "Tax 1" FORMAT "zz9.99-":U WIDTH 7
    Referenz FORMAT "x(27)":U
    Tn_Nr COLUMN-LABEL "Teilnehmer-Nr" FORMAT "999999999":U WIDTH 21
    Aufg_Dat COLUMN-LABEL "Aufg.Dat" FORMAT "99.99.9999":U
    Verb_Dat COLUMN-LABEL "Verarb.Dat" FORMAT "99.99.9999":U
    Aufg_Ref COLUMN-LABEL "Aufg.Ref" FORMAT "x(10)":U
    Taxen_02 COLUMN-LABEL "Tax 2" FORMAT "zz9.99-":U WIDTH 7
    Rj_Cd COLUMN-LABEL "FeCd" FORMAT "x(01)":U
    Mi_Fi_Nr COLUMN-LABEL "Fiche" FORMAT "x(10)":U
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
    WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 164 BY 10.


/* ************************  Frame Definitions  *********************** */

DEFINE FRAME F-Main
    br_table AT ROW 1.48 COL 3 WIDGET-ID 200
    RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 2
    WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY 
    SIDE-LABELS NO-UNDERLINE THREE-D 
    AT COL 1 ROW 1 SCROLLABLE  WIDGET-ID 100.


/* *********************** Procedure Settings ************************ */

&ANALYZE-SUSPEND _PROCEDURE-SETTINGS
/* Settings for THIS-PROCEDURE
   Type: SmartDataBrowser
   Data Source: "d-vesrzahl.w"
   Allow: Basic,Browse
   Frames: 1
   Add Fields to: Neither
   Other Settings: PERSISTENT-ONLY COMPILE
 */

/* This procedure should always be RUN PERSISTENT.  Report the error,  */
/* then cleanup and return.                                            */
IF NOT THIS-PROCEDURE:PERSISTENT THEN 
DO:
    MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
        VIEW-AS ALERT-BOX ERROR BUTTONS OK.
    RETURN.
END.

&ANALYZE-RESUME _END-PROCEDURE-SETTINGS

/* *************************  Create Window  ************************** */

&ANALYZE-SUSPEND _CREATE-WINDOW
/* DESIGN Window definition (used by the UIB) 
  CREATE WINDOW bTableWin ASSIGN
         HEIGHT             = 11
         WIDTH              = 168.
/* END WINDOW DEFINITION */
                                                                        */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin 
/* ************************* Included-Libraries *********************** */

{src/adm2/browser.i}

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME




/* ***********  Runtime Attributes and AppBuilder Settings  *********** */

&ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
/* SETTINGS FOR WINDOW bTableWin
  NOT-VISIBLE,,RUN-PERSISTENT                                           */
/* SETTINGS FOR FRAME F-Main
   NOT-VISIBLE FRAME-NAME Size-to-Fit                                   */
/* BROWSE-TAB br_table RECT-1 F-Main */
ASSIGN 
    FRAME F-Main:SCROLLABLE = FALSE
    FRAME F-Main:HIDDEN     = TRUE.

/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


/* Setting information for Queries and Browse Widgets fields            */

&ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
/* Query rebuild information for BROWSE br_table
     _TblList          = "rowObject"
     _Options          = "NO-LOCK INDEXED-REPOSITION"
     _FldNameList[1]   > _<SDO>.rowObject.Trnr
"Trnr" ? "9999" "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[2]   > _<SDO>.rowObject.Tr_Art
"Tr_Art" "Art" ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[3]   > _<SDO>.rowObject.Guts_Dat
"Guts_Dat" "Valuta" ? "date" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[4]   > _<SDO>.rowObject.Kunde
"Kunde" ? "x(60)" "character" ? ? ? ? ? ? no "?" no no "60" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[5]   > _<SDO>.rowObject.Faknr
"Faknr" ? ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[6]   > _<SDO>.rowObject.Betrag
"Betrag" ? ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[7]   > _<SDO>.rowObject.Taxen_01
"Taxen_01" "Tax 1" "zz9.99-" "decimal" ? ? ? ? ? ? no "?" no no "7" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[8]   > _<SDO>.rowObject.Referenz
"Referenz" ? ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[9]   > _<SDO>.rowObject.Tn_Nr
"Tn_Nr" "Teilnehmer-Nr" ? "integer" ? ? ? ? ? ? no "?" no no "21" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[10]   > _<SDO>.rowObject.Aufg_Dat
"Aufg_Dat" "Aufg.Dat" ? "date" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[11]   > _<SDO>.rowObject.Verb_Dat
"Verb_Dat" "Verarb.Dat" ? "date" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[12]   > _<SDO>.rowObject.Aufg_Ref
"Aufg_Ref" "Aufg.Ref" ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[13]   > _<SDO>.rowObject.Taxen_02
"Taxen_02" "Tax 2" "zz9.99-" "decimal" ? ? ? ? ? ? no "?" no no "7" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[14]   > _<SDO>.rowObject.Rj_Cd
"Rj_Cd" "FeCd" ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[15]   > _<SDO>.rowObject.Mi_Fi_Nr
"Mi_Fi_Nr" "Fiche" ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _Query            is NOT OPENED
*/  /* BROWSE br_table */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
/* Query rebuild information for FRAME F-Main
     _Options          = "NO-LOCK"
     _Query            is NOT OPENED
*/  /* FRAME F-Main */
&ANALYZE-RESUME

 



/* ************************  Control Triggers  ************************ */

&Scoped-define BROWSE-NAME br_table
&Scoped-define SELF-NAME br_table
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON CTRL-END OF br_table IN FRAME F-Main
    DO:
        APPLY "END":U TO BROWSE {&BROWSE-NAME}.
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON CTRL-HOME OF br_table IN FRAME F-Main
    DO:
        APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON DEFAULT-ACTION OF br_table IN FRAME F-Main
    DO:
    {src/adm2/brsdefault.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON END OF br_table IN FRAME F-Main
    DO:
    {src/adm2/brsend.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON HOME OF br_table IN FRAME F-Main
    DO:
    {src/adm2/brshome.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON LEFT-MOUSE-CLICK OF br_table IN FRAME F-Main
    DO:
        APPLY 'ENTRY' TO {&BROWSE-NAME}.
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON LEFT-MOUSE-DBLCLICK OF br_table IN FRAME F-Main
    DO:
        IF NOT VALID-HANDLE( hFenster ) THEN RETURN NO-APPLY.
        RUN TOOLBAR IN hFenster ( INPUT 'UPDATE' ).
        RETURN NO-APPLY.
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON OFF-END OF br_table IN FRAME F-Main
    DO:
    {src/adm2/brsoffnd.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON OFF-HOME OF br_table IN FRAME F-Main
    DO:
    {src/adm2/brsoffhm.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON ROW-DISPLAY OF br_table IN FRAME F-Main
    DO:
        DEFINE VARIABLE iKnr    AS INTEGER NO-UNDO.
        DEFINE VARIABLE iFaknr  AS INTEGER NO-UNDO.
        DEFINE VARIABLE nBetrag AS DECIMAL NO-UNDO.
        
        DEFINE BUFFER bDebop FOR Debop.
        
        DO WHILE TRUE:
            rowObject.Kunde:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15. 
            rowObject.Faknr:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15. 
            rowObject.Kunde:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15.

            iKnr    = (IF rowObject.Kunde BEGINS 'ERROR' THEN 0 ELSE INTEGER(SUBSTRING(rowObject.Kunde,01,06)) ) NO-ERROR.
            iFaknr  = INTEGER(rowObject.Faknr).
            nBetrag = DECIMAL(rowObject.Betrag).
            
            FIND bDebop NO-LOCK
                WHERE bDebop.Firma = Firma
                AND   bDebop.Knr   = iKnr
                AND   bDebop.Faknr = iFaknr NO-ERROR.
            IF NOT AVAILABLE bDebop THEN
            DO:
                rowObject.Kunde:BGCOLOR IN BROWSE {&BROWSE-NAME} = 14. 
                rowObject.Faknr:BGCOLOR IN BROWSE {&BROWSE-NAME} = 14. 
                LEAVE.
            END.
            IF nBetrag = bDebop.Saldo_Frw THEN LEAVE.
            IF nBetrag > bDebop.Saldo_Frw THEN
            DO:
                rowObject.Betrag:BGCOLOR IN BROWSE {&BROWSE-NAME} = 14. 
                LEAVE.
            END.
            FIND SteuNr NO-LOCK
                WHERE SteuNr.Firma = Firma.
            IF (bDebop.Saldo - nBetrag) > SteuNr.SK_Tol_Max THEN
            DO:
                rowObject.Betrag:BGCOLOR IN BROWSE {&BROWSE-NAME} = 14. 
                LEAVE.
            END.
            LEAVE.
        END.
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON ROW-ENTRY OF br_table IN FRAME F-Main
    DO:
    {src/adm2/brsentry.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON ROW-LEAVE OF br_table IN FRAME F-Main
    DO:
    {src/adm2/brsleave.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON SCROLL-NOTIFY OF br_table IN FRAME F-Main
    DO:
        {src/adm2/brsscrol.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON START-SEARCH OF br_table IN FRAME F-Main
    DO:
        { incl/brwstartsearch.i }
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON VALUE-CHANGED OF br_table IN FRAME F-Main
    DO:
    {src/adm2/brschnge.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&UNDEFINE SELF-NAME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin 


/* ***************************  Main Block  *************************** */

{ incl/brwmainblock.i }
{ incl/brwinternproc.i }

    &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN          
        RUN initializeObject.        
    &ENDIF

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


/* **********************  Internal Procedures  *********************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE destroyObject bTableWin 
PROCEDURE destroyObject :
    /*------------------------------------------------------------------------------
          Purpose:     Super Override
          Parameters:  
          Notes:       
        ------------------------------------------------------------------------------*/

    DEF VAR hBrowser AS HANDLE NO-UNDO.

    hBrowser = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
    DYNAMIC-FUNCTION('setBrowserDaten':U, INPUT hBrowser,
        INPUT Sektion ) NO-ERROR.

    RUN SUPER.

/* Code placed here will execute AFTER standard behavior.    */

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin  _DEFAULT-DISABLE
PROCEDURE disable_UI :
    /*------------------------------------------------------------------------------
      Purpose:     DISABLE the User Interface
      Parameters:  <none>
      Notes:       Here we clean-up the user-interface by deleting
                   dynamic widgets we have created and/or hide 
                   frames.  This procedure is usually called when
                   we are ready to "clean-up" after running.
    ------------------------------------------------------------------------------*/
    /* Hide all frames. */
    HIDE FRAME F-Main.
    IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_BROWSE bTableWin 
PROCEDURE ENTRY_BROWSE :
    /*------------------------------------------------------------------------------
          Purpose:     
          Parameters:  <none>
          Notes:       
        ------------------------------------------------------------------------------*/

    APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject bTableWin 
PROCEDURE initializeObject :
    /*------------------------------------------------------------------------------
      Purpose:     Super Override
      Parameters:  
      Notes:       
    ------------------------------------------------------------------------------*/

    { incl/brwinitialize.i }

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

/* ************************  Function Implementations ***************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION setZeilenfarbe bTableWin 
FUNCTION setZeilenfarbe RETURNS LOGICAL
    ( ipFarbe AS INT ) :
    /*------------------------------------------------------------------------------*/
    /*  Purpose:     Super Override                                                 */
    /*  Parameters:                                                                 */
    /*  Notes:                                                                      */
    /*------------------------------------------------------------------------------*/
    
    /*    DEFINE VARIABLE iKnr    AS INTEGER NO-UNDO.                                           */
    /*    DEFINE VARIABLE iFaknr  AS INTEGER NO-UNDO.                                           */
    /*    DEFINE VARIABLE iError  AS INTEGER NO-UNDO.                                           */
    /*    DEFINE VARIABLE nBetrag AS DECIMAL NO-UNDO.                                           */
    /*    DEFINE VARIABLE lFound  AS LOGICAL NO-UNDO.                                           */
    /*                                                                                          */
    /*    DEFINE BUFFER bDebop FOR Debop.                                                       */
    /*                                                                                          */
    /*    DO WITH FRAME {&FRAME-NAME}:                                                          */
    /*        iError = 0.                                                                       */
    /*        lFound = FALSE.                                                                   */
    /*        FOR EACH tBrowser WHERE VALID-HANDLE(tBrowser.hCol)                               */
    /*            AND   tBrowser.fVisible NO-LOCK:                                              */
    /*            tBrowser.hCol:BGCOLOR = ipFarbe.                                              */
    /*                                                                                          */
    /*            MESSAGE tBrowser.Feld tBrowser.cLabel                                         */
    /*                VIEW-AS ALERT-BOX.                                                        */
    /*            CASE tBrowser.hCol:NAME:                                                      */
    /*                WHEN 'Kunde'  THEN                                                        */
    /*                    iKnr    = INTEGER(ENTRY(1, tBrowser.hCol:SCREEN-VALUE, ' ')) NO-ERROR.*/
    /*                WHEN 'Faknr'  THEN                                                        */
    /*                    iFaknr  = INTEGER(tBrowser.hCol:SCREEN-VALUE).                        */
    /*                WHEN 'Betrag'  THEN                                                       */
    /*                    nBetrag = DECIMAL(tBrowser.hCol:SCREEN-VALUE).                        */
    /*            END CASE.                                                                     */
    /*            IF iKnr = ? THEN tBrowser.hCol:BGCOLOR = 12.                                  */
    /*            lFound = TRUE.                                                                */
    /*        END.                                                                              */
    /*                                                                                          */
    /*        IF NOT lFound THEN RETURN FALSE.                                                  */
    /*        DO WHILE iKnr <> ?:                                                               */
    /*            FIND bDebop NO-LOCK                                                           */
    /*                WHERE bDebop.Firma = Firma                                                */
    /*                AND   bDebop.Knr   = iKnr                                                 */
    /*                AND   bDebop.Faknr = iFaknr NO-ERROR.                                     */
    /*            IF NOT AVAILABLE bDebop THEN                                                  */
    /*            DO:                                                                           */
    /*                iError = 3.                                                               */
    /*                LEAVE.                                                                    */
    /*            END.                                                                          */
    /*            IF nBetrag = bDebop.Saldo_Frw THEN LEAVE.                                     */
    /*            IF nBetrag > bDebop.Saldo_Frw THEN                                            */
    /*            DO:                                                                           */
    /*                iError = 2.                                                               */
    /*                LEAVE.                                                                    */
    /*            END.                                                                          */
    /*            FIND SteuNr NO-LOCK                                                           */
    /*                WHERE SteuNr.Firma = Firma.                                               */
    /*            IF (bDebop.Saldo - nBetrag) > SteuNr.SK_Tol_Max THEN                          */
    /*            DO:                                                                           */
    /*                iError = 1.                                                               */
    /*                LEAVE.                                                                    */
    /*            END.                                                                          */
    /*            LEAVE.                                                                        */
    /*        END.                                                                              */
    /*                                                                                          */
    /*        CASE iError:                                                                      */
    /*            WHEN 0 THEN                                                                   */
    /*                LEAVE.                                                                    */
    /*            WHEN 3 THEN                                                                   */
    /*                DO:                                                                       */
    /*                    FIND FIRST tBrowser NO-LOCK                                           */
    /*                        WHERE tBrowser.Feld = 'Faknr' NO-ERROR.                           */
    /*                    IF NOT AVAILABLE tBrowser THEN MESSAGE 'Faknr nicht gefunden'         */
    /*                            VIEW-AS ALERT-BOX.                                            */
    /*                    ELSE tBrowser.hCol:BGCOLOR = 14.                                      */
    /*                    FIND FIRST tBrowser NO-LOCK                                           */
    /*                        WHERE tBrowser.Feld = 'Kunde' NO-ERROR.                           */
    /*                    tBrowser.hCol:BGCOLOR = 14.                                           */
    /*                END.                                                                      */
    /*            WHEN 1 OR                                                                     */
    /*            WHEN 2 THEN                                                                   */
    /*                DO:                                                                       */
    /*                    FIND FIRST tBrowser NO-LOCK                                           */
    /*                        WHERE tBrowser.Feld = 'Betrag'.                                   */
    /*                    tBrowser.hCol:BGCOLOR = 14.                                           */
    /*                END.                                                                      */
    /*                                                                                          */
    /*        END CASE.                                                                         */
    /*                                                                                          */
    /*    END.                                                                                  */

    RETURN TRUE.

END FUNCTION.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME