Freshmark replication server

freshmark-canonical

Program drill-down

DEBTOR_DR_CR_BAL

DEBTOR BALANCES (NEW). Type DSP, base table DEBTOR_MAST.

Field inventory

29

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 H -1 0, 0
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 231, 49
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 MARKET I 0 1, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1
1 0.0 Label 12 T -1 331, 361
  
1 0.0 CMD 10 C -1 331, 337
$SELECT  A:CONST;IN PROGRESS...;T\PROG    I:I\DETSUM;=;D  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_DEBTOR_ACCTYPE_BALANCES;$I\MARKET$,$I\TYPE$,$I\BAL_TYPE$,$I\TRANS_DATE$,$I\DUMP$,S    I:I\DETSUM;=;S  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_DEBTOR_ACCTYPE_BALANCES_SUMMARY;$I\MARKET$,$I\
1 0.0 Label 1 T -1 191, 277
  
1 0.0 Work 2 I -1 331, 277
$VALIDATE    I:I\DUMP;=;  A:CONST;N;I\DUMP  V:Y;N  O:SETFOCUS;C\GO  O:BACKCOLOR;C\GO;YELLOW
1 0.0 Label 1 T -1 191, 241
  
1 0.0 Work 2 I -1 331, 241
$CALCULATE    'DEFAULT DATE TO CURRENT  I:I\TRANS_DATE;=;  A:DATE;DD MMM YYYY;I\TRANS_DATE    'I:I\MARKET;=;18  'DO(D9I)    'I:I\DETSUM;=;S   ' O:DISABLEINPUT;I\DUMP      'I:I\DETSUM;=;D    ''O:ENABLEINPUT;I\DUMP  'DOEND(D9I)    'O:SETFOCUS;C\GO  'O:BACKCOLOR;C\GO;YELLOW
1 0.0 Label 1 T -1 191, 133
  
1 0.0 Work 2 I -1 331, 133
$CALCULATE  C:UCASE  V:D;S;  'O:ENABLEINPUT;I\DUMP  I:I\DETSUM;=;  A:CONST;D;I\DETSUM    I:I\DETSUM;=;D  A:CONST;DETAIL;T\DS    I:I\DETSUM;=;S    A:CONST;SUMMARY;T\DS       
1 0.0 Label 1 T -1 191, 169
  
1 0.0 Label 2 T -1 421, 169
  
1 0.0 Label 3 T -1 191, 205
  
1 0.0 Work 6 I -1 331, 169
$SELECT  S:ACCOUNT;I\TYPE    $CALCULATE  C:UCASE  I:I\TYPE;<>;    F:ACCOUNT_TYPE;Y;;T\DESC=AT_DESC;AT_CODE='$I\TYPE$';I\TYPE    I:I\TYPE;=;    A:CONST;;I\TYPE,I\BAL_TYPE,T\DESC
1 0.0 CMD 8 C -1 381, 169
$SELECT  S:ACCOUNT;I\TYPE
1 0.0 Work 3 I -1 331, 205
$CALCULATE    I:I\DETSUM;=;D  DO(D61)    C:UCASE    V:CR;DR;  DOEND(D61)    I:I\DETSUM;=;S  DO(D62)    I:I\BAL_TYPE;<>;    D:SUMMARY REQUIRES THIS TO BE BLANK;ERRORM;I\BAL_TYPE  DOEND(D62)    'I:I\MARKET;<>;18  'DO(18)  '  O:SETFOCUS;C\GO  '  O:BACKCOLOR;C\GO;YELLOW  'DOEND(18)
1 0.0 Label 3 T -1 421, 133
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0