Freshmark replication server

freshmark-canonical

Program drill-down

AGN_SET_LIM

BUYER SET LIMITS. Type DSP, base table DEBTOR_MAST.

Field inventory

65

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 1 I 0 221, 529
  
1 0.0 Work 2 I 0 121, 529
  
1 0.0 Label 2 T 0 11, 565
  
1 0.0 Work 33 I 0 661, 181
  
1 0.0 Work 1 I 0 471, 493
$VALIDATE  C:UCASE    V:Y;N    I:I\SETLIMIT;=;  A:CONST;N;I\SETLIMIT    O:SETFOCUS;I\CONFIRM
1 0.0 CMD 2 C 0 11, 529
$SELECT  O:SETFOCUS;I\UPDATE  
1 0.0 Work 1 I 0 471, 205
  
1 0.0 Work 8 I 0 1, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME    'CONVERT ONLY THE FIRST CHARACTER OF THE MARKET LABEL  C:MCASE;;T\MARKET    '20230126 THEUNIS  '20221130 THEUNIS  'U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\LINE,I\TO_BUYER,T\TO_NAME_DESC,I\TO_ID_NO,I\LIMITD  U:ZZGRID
1 0.0 Work 9 I 0 81, 61
$DEFAULT    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    '$CALCULATE  'U:ZZGRID_SPLIT;INIT_GRID;G\GRIDM;I\LV_CODE,I\LV_DESC,I\LV_CALC_TYPE,I\LV_RATE,I\LV_MRATE,I\LV_VATCD,I\LV_BOARD  'U:ZZGRID_SPLIT;DB_TO_GRID;G\GRIDM;LEVY_MAST    O:SETFOCUS;I\DA_CODE    '$BEFORE_DELETE  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 5 T -1 291, 49
  
1 0.0 Label 3 T -1 621, 25
  
1 0.0 Label 4 T -1 671, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 H -1 0, 0
  
1 0.0 Label 1 T -1 21, 97
  
1 0.0 DEBTOR_MAST DM_DEBTOR I -1 161, 97
$SELECT  S:MAIN_BUYER;I\DT_DEBTOR    $VALIDATE    M:  C:UCASE    F:DEBTOR_MAST;;;I\OSBAL=DM_OSBAL,I\MAIN_DEBTOR=DM_MAIN_DEBTOR,I\MAIN_ALLOC=DM_UNALLOC_AMT,T\MAIN_NAME=DM_NAME,I\ID=DM_IDNO,I\DM_ACCTYPE=DM_ACCTYPE,I\DEBTOR_T=DM_DEBTOR,I\PASS=DM_SET_LIM_PASS,I\LIMITCOICE=DM_USE_TOT_AVAIL;DM_MARKET='$I\MARKET$' AND DM_DEBT
1 0.0 Work 11 I 0 281, 169
  
1 0.0 Work 10 I -1 161, 169
$CALCULATE    A:VAR;I\DT_REFNO;I\TO_REF    O:SETFOCUS;I\TO_BUYER
1 0.0 Label 3 T -1 561, 97
  
1 0.0 Label 9 T -1 21, 169
  
1 0.0 Work 4 I -1 691, 97
$CALCULATE    I:I\PASS;=;I\PASST  DO(OPEN)    O:SHOW;I\REFNT,I\DT_REFNO,L\TB,L\AFT,L\RETL,L\ASBT,L\TRFAMT,I\DT_TRVAL,I\UPDATE    O:SHOW;I\DT_TRVAL,I\DT_REFNO,L\BUYER_NAME_L,I\LINE,T\LINE,G\GRID    O:SHOW;I\TO_BUYER,T\TO_NAME_DESC,I\RETURNS,I\LIMITD,I\DM_OSBALD,L\INSTR,L\INSTR2    O:ENABLEINPUT;G\GRID      U:UPDATE_LIMI
1 0.0 Label 7 T 0 561, 133
  
1 0.0 Work 8 I 0 691, 133
  
1 0.0 Label 5 T 0 561, 133
  
1 0.0 Work 6 I 0 691, 157
  
1 0.0 Label 12 T -1 21, 205
  
1 0.0 Work 32 I 0 221, 529
  
1 0.0 Work 2 I 0 371, 205
  
1 0.0 Label 15 T -1 121, 241
  
1 0.0 Label 16 T 0 561, 157
  
1 0.0 Work 1 I -1 161, 133
  
1 0.0 Label 17 T -1 421, 241
  
1 0.0 Work 18 I -1 21, 265
$VALIDATE  M:  C:UCASE    I:I\TO_BUYER;<>;  DO(EXITS)    F:DEBTOR_MAST;;;I\MAIN_DEBTOR=DM_MAIN_DEBTOR,I\DTT_DEBTOR=DM_DEBTOR;DM_MARKET='$I\MARKET$' AND DM_DEBTOR ='$I\TO_BUYER$'      I:I\MAIN_DEBTOR;<>;I\DT_DEBTOR    DO(MDER)      D:ENTER A VALID BUYER NUMBER;ERRORM;I\TO_BUYER    DOEND(MDER)      I:I\MAIN_DEBTOR;=;I\DT
1 0.0 CMD 31 C -1 651, 548
$SELECT  A:VAR;16;I\DT_TRTYPE  A:VAR;16;I\DT_TYPE      I:I\TO_BUYER;=;  DO(CLOSE10)    U:UPDATE_LIMITS;CLEARGRID    A:CONST;;I\CFM,T\NAME,I\DM_VATNO,I\PERIOD,I\DM_OSBAL,D\DT_TRTYPE,T\TRTYPE,I\DT_PAYMTHD,T\PAYMETH,I\DT_TRVAL,I\DT_REFNO,I\ID,I\PIN,I\MAIN_DEBTOR,W\PASSWORD_REQUIRED,I\CONF_AMT,I\CORR_AMT,I\RECEIPT,I\DT_COR
1 0.0 Work 19 I -1 121, 265
  
1 0.0 Work 20 I 0 641, 157
  
1 0.0 Work 21 I -1 421, 265
  
1 0.0 Work 22 G -1 21, 289
$SELECT  I:I\TO_BUYER;=;  O:SETFOCUS;I\UPDATE    
1 0.0 Work 29 I 0 241, 529
  
1 0.0 Label 23 T -1 21, 457
  
1 0.0 Work 28 I 0 351, 529
$VALIDATE  I:I\SET_LIMIT;=;  A:CONST;N;I\SET_LIMIT    C:UCASE    V:Y;N    M:    '$CALCULATE    O:SETFOCUS;I\UPDATE      
1 0.0 Work 24 I -1 201, 457
$VALIDATE    I:I\RETURNS;=;  A:CONST;N;I\RETURNS    C:UCASE    V:Y;N    $CALCULATE  M:    I:I\RETURNS;=;N  DO(O1)    A:CONST;TRANSFER TO SUB BUYER;I\DT_REMARK    A:CONST;TRANSFER FROM MAIN BUYER;I\TO_REMARKS  DOEND(O1)    I:I\RETURNS;=;Y  DO(O2)    A:CONST;TRANSFER FROM SUB BUYER;I\DT_REMARK    A:CONST;TRANSFER TO MAIN
1 0.0 Label 27 T 0 371, 493
  
1 0.0 Label 25 T -1 21, 493
  
1 0.0 Work 30 I 0 231, 529
  
1 0.0 Work 26 I -1 201, 493
$VALIDATE  'MAKE THIS FIELD MANDATORY  M:    I:I\DT_TRVAL;=;0  D:THE LIMIT CHANGE CAN NOT BE 0;ERRORM;I\DT_TRVAL    'ROUND THE TOTAL TO THE NEAREST FIVE CENT  F:CLIENT_MAST;;;W\ROUND=CM_ROUND;CM_CODE='$I\MARKET$'  A:ROUND;I\DT_TRVAL,0.05,W\ROUND;W\ROUNDED;;#0.00    I:W\ROUNDED;=;0.00  A:VAR;I\DT_TRVAL;W\ROUNDED      A:
1 0.0 Label 1 T -1 301, 97
  
1 0.0 CMD 2 C -1 261, 97
$SELECT  S:MAIN_BUYER;I\DT_DEBTOR
1 0.0 Work 3 I 0 61, 289
  
1 0.0 Label 4 T 0 61, 289
  
1 0.0 Work 13 I -1 161, 205
  
1 0.0 Label 14 T -1 21, 241
  
1 0.0 Work 1 I 0 521, 265
  
1 0.0 Work 1 I 0 661, 181
  
1 0.0 Label 2 T 0 561, 181
  
1 0.0 Work 1 I 0 571, 469
  
1 0.0 Label 1 T -1 21, 133
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 1.0 ZX_UPDATE Z 0 0, 0