Freshmark replication server

freshmark-canonical

Program drill-down

SURETY_BUYER_PMTS

SURETY BUYER PMTS. Type DSP, base table DEBT_ADDR.

Field inventory

122

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Label 17 T -1 291, 121
  
1 0.0 CMD 76 C -1 651, 541
$SELECT  'DO ALL CHECKS AGAIN    'MAKE SURE THE BUYER EXISTS  F:DEBTOR_MAST;Y;;I\MAIN=DM_MAIN_DEBTOR,I\SURETY=DM_SURETY_BUYER,T\NAME=DM_NAME;DM_MARKET='$I\MARKET$' AND DM_DEBTOR='$I\BUYER$';I\BUYER    'CHECK IF SURETY BUYER  I:I\SURETY;<>;Y  D:ONLY SURETY BUYERS MAY BE ENTERED HERE;ERRORM;I\BUYER    'CHECK IF MAIN BUYE
1 0.0 Label 1 T -1 500, 565
  
1 0.0 Work 2 I -1 561, 565
$CALCULATE  'NEW CHANGE FOR CT - JD 20140811  'CHECK IF CASHIER IS ALLOWED TO CHANGE THE DATE ON A PAYMENT, SET FIELD PROPERTIES ACCORDINGLY  I:W\ALLOW_DATE_CHG;<>;Y  DO(LVA)    A:DATE;DD MMM YYYY;I\ICPDTE    O:DISABLEINPUT;I\ICPDTE    D:YOU MAY NOT CHANGE THIS DATE;ERRORM;I\NORECZ  DOEND(LVA)    I:I\ICPDTE;=;  A:DATE;
1 0.0 ALLOW_DATE_CHG I 0 461, 85
  
1 0.0 Label 1 T -1 561, 205
  
1 0.0 CMD 38 C -1 241, 121
$SELECT  S:STATEMENT_DATE;I\SDATE;I\BUYER;I\TRDATE
1 0.0 CMD 11 C -1 241, 85
$SELECT  S:SURETY_BUYER;I\BUYER;I\MARKET
1 0.0 CMD 39 C -1 241, 157
$SELECT  S:PAYMENT_METHOD;I\PAYMETH;I\MARKET
1 0.0 SMAF I 0 11, 373
  
1 0.0 REM I -1 401, 157
$CALCULATE  C:UCASE
1 0.0 AMT I -1 401, 121
$CALCULATE  M:  I:I\AMT;>;I\TOTDUE;VAL  D:MAY NOT PAY MORE THAN IS DUE;ERRORM;I\AMT    I:I\AMT;=;0;VAL  D:PLEASE ENTER AN AMOUNT TO PAY;ERRORM;I\AMT    'IF THE AMOUNT CANNOT COVER THE CHARGES, DISALLOW THE PAYMENT COMPLETELY  '''I:I\SFC;>;I\AMT;VAL - THIS IS THE OLD SELECTION  I:I\DFCO;>;I\AMT;VAL  DO(HHD)    O:DISABLE
1 0.0 PAYMETH I -1 141, 157
$SELECT  S:PAYMENT_METHOD;I\PAYMETH;I\MARKET    $CALCULATE  M:  C:UCASE    'VALIDATE PAYMENT METHOD AND LOAD THE DESCRIPTION FOR THIS TRANSACTION  F:CASH_PAYMTHD;Y;CPM_PAYMETH;;;I\PAYMETH    
1 0.0 TOTDUE I -1 591, 121
  
1 0.0 SDATE I -1 141, 121
$SELECT  S:STATEMENT_DATE;I\SDATE;I\BUYER;I\TRDATE    $CALCULATE  M:    'FORMAT THE DATE FOR SQL USAGE  A:VAR;I\SDATE;I\SDATE;;YYYY/MM/DD    'MAKE SURE THE DATE EXISTS  F:STATEMENT_RUN_DETS;Y;;I\STMT_PAID=SRD_AMT_PAID,I\STMT_DUE=SRD_AMT_DUE;SRD_DEBTOR='$I\BUYER$' AND SRD_STATEMENT_DATE='$I\SDATE$';I\SDATE    'CALCULATE
1 0.0 Label 23 T -1 291, 205
  
1 0.0 BUYER I -1 141, 85
$SELECT  S:SURETY_BUYER;I\BUYER;I\MARKET    $CALCULATE  M:  C:UCASE    'MAKE SURE THE BUYER EXISTS  F:DEBTOR_MAST;Y;;I\ACCTYPE=DM_ACCTYPE,I\MAIN=DM_MAIN_DEBTOR,I\SURETY=DM_SURETY_BUYER,T\NAME=DM_NAME;DM_MARKET='$I\MARKET$' AND DM_DEBTOR='$I\BUYER$';I\BUYER    'CHECK IF SURETY BUYER  I:I\SURETY;<>;Y  D:ONLY SURETY BUYER
1 0.0 H -1 0, 0
  
1 0.0 ACCTYPE I 0 441, 85
  
1 0.0 MARKET I 0 11, 49
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET  A:ORGS;;I\ORGS  A:USERID;;I\USERID  A:USERIP;;I\IP    '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 M
1 0.0 CMD 1 C -1 81, 205
$SELECT  A:CONST;0.00;I\DA,I\DF,I\DL,I\DU,I\DH,I\DS,I\DK,I\DD  U:SURETY_BUYER_PMTS;CALC_AVAIL    O:SETFOCUS;I\DA
1 0.0 Label 12 T -1 291, 85
  
1 0.0 Label 13 T -1 591, 85
  
1 0.0 Label 15 T -1 21, 121
  
1 0.0 Label 9 T -1 21, 85
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 3 T -1 291, 49
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 OK I 0 501, 121
  
1 0.0 CASHP I 0 251, 49
  
1 0.0 CASHIER I 0 231, 49
  
1 0.0 DDO I -1 691, 481
  
1 0.0 DKO I -1 691, 457
  
1 0.0 DSO I -1 691, 433
  
1 0.0 ALLOC I 0 691, 157
  
1 0.0 DHO I -1 691, 409
  
1 0.0 DUO I -1 691, 385
  
1 0.0 DLO I -1 691, 361
  
1 0.0 DFO I -1 691, 337
  
1 0.0 DAO I -1 691, 313
  
1 0.0 DSCO I -1 691, 289
  
1 0.0 STMT_DUE I 0 161, 49
  
1 0.0 RUN_TOT I -1 691, 121
  
1 0.0 TMP1 I 0 21, 541
  
1 0.0 DFCO I -1 691, 241
  
1 0.0 DMAFO I 0 11, 445
  
1 0.0 DMSFO I -1 691, 265
  
1 0.0 STMT_PAID I 0 141, 49
  
1 0.0 SURETY I 0 401, 85
  
1 0.0 IP I 0 71, 49
  
1 0.0 MAIN I 0 421, 85
  
1 0.0 TRDATE I 0 181, 49
  
1 0.0 DWO I -1 691, 505
  
1 0.0 ORGS I 0 31, 49
  
1 0.0 USERID I 0 51, 49
  
1 0.0 DW I -1 561, 505
$CALCULATE  I:I\DW;>;I\DWO;VAL  D:$T\W$ IS OWED R$I\DWO$;ERRORM;I\DW    U:SURETY_BUYER_PMTS;CALC_AVAIL    I:I\OK;=;N  D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DW    'CHECK IF ALL FUNDS HAVE BEEN ALLOCATED  I:I\ALLOC;<>;I\AMT  D:NOT ALL FUNDS HAVE BEEN ALLOCATED;ERRORM;I\DA    O:SETFOCUS;I\NORECZ    'ONLY ALLOW TH
1 0.0 Label 1 T -1 521, 541
  
1 0.0 Work 2 I -1 561, 541
$CALCULATE    I:I\NORECZ;=;  A:CONST;3;I\NORECZ    I:I\NORECZ;=;0  A:CONST;3;I\NORECZ    I:I\NORECZ;>;10  D:CANNOT PRINT MORE THAN 10 RECEIPTS;ERRORM;I\NORECZ    I:W\ALLOW_DATE_CHG;<>;Y  DO(FLA)  'ONLY ALLOW THE UPDATE BUTTON TO BE CREATED ONCE ALL VALIDATIONS ARE DONE, AND THE LAST SCREEN FIELD HAS BEEN PASSED    O:EN
1 0.0 SW I -1 291, 505
  
1 0.0 PW I -1 431, 505
  
1 0.0 DD I -1 561, 481
$CALCULATE  I:I\DD;>;I\DDO;VAL  D:$T\D$ IS OWED R$I\DDO$;ERRORM;I\DD    ''U:SURETY_BUYER_PMTS;CALC_AVAIL    'I:I\DD;>;I\RUN_TOT;VAL  'D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DD    U:SURETY_BUYER_PMTS;CALC_AVAIL    I:I\OK;=;N  D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DD    $SVAR_FOCUS  U:SURETY_BUYER_PMTS;C
1 0.0 DK I -1 561, 457
$CALCULATE  I:I\DK;>;I\DKO;VAL  D:$T\K$ IS OWED R$I\DKO$;ERRORM;I\DK    'I:I\DK;>;I\RUN_TOT;VAL  'D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DK    U:SURETY_BUYER_PMTS;CALC_AVAIL    I:I\OK;=;N  D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DK    'A:SUB;I\RUN_TOT;I\RUN_TOT;I\DK;;#0.00  'A:ADD;I\DK;I\ALLOC;I\ALLOC;;#
1 0.0 DMAF I 0 11, 421
  
1 0.0 DMSF I -1 561, 265
  
1 0.0 DSC I -1 561, 289
  
1 0.0 DA I -1 561, 313
$CALCULATE  I:I\DA;>;I\DAO;VAL  D:$T\A$ IS OWED R$I\DAO$;ERRORM;I\DA    'I:I\DA;>;I\RUN_TOT;VAL  'D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DA    U:SURETY_BUYER_PMTS;CALC_AVAIL    I:I\OK;=;N  D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DA    'A:SUB;I\RUN_TOT;I\RUN_TOT;I\DA;;#0.00  'A:ADD;I\DA;I\ALLOC;I\ALLOC;;#
1 0.0 DF I -1 561, 337
$CALCULATE  I:I\DF;>;I\DFO;VAL  D:$T\F$ IS OWED R$I\DFO$;ERRORM;I\DF    'I:I\DF;>;I\RUN_TOT;VAL  'D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DF    U:SURETY_BUYER_PMTS;CALC_AVAIL    I:I\OK;=;N  D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DF    'A:SUB;I\RUN_TOT;I\RUN_TOT;I\DF;;#0.00  'A:ADD;I\DF;I\ALLOC;I\ALLOC;;#
1 0.0 DL I -1 561, 361
$CALCULATE  I:I\DL;>;I\DLO;VAL  D:$T\L$ IS OWED R$I\DLO$;ERRORM;I\DL    'I:I\DL;>;I\RUN_TOT;VAL  'D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DL    U:SURETY_BUYER_PMTS;CALC_AVAIL    I:I\OK;=;N  D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DL    'A:SUB;I\RUN_TOT;I\RUN_TOT;I\DL;;#0.00  'A:ADD;I\DL;I\ALLOC;I\ALLOC;;#
1 0.0 DU I -1 561, 385
$CALCULATE  I:I\DU;>;I\DUO;VAL  D:$T\U$ IS OWED R$I\DUO$;ERRORM;I\DU    'I:I\DU;>;I\RUN_TOT;VAL  'D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DU    U:SURETY_BUYER_PMTS;CALC_AVAIL    I:I\OK;=;N  D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DU    'A:SUB;I\RUN_TOT;I\RUN_TOT;I\DU;;#0.00  'A:ADD;I\DU;I\ALLOC;I\ALLOC;;#
1 0.0 DH I -1 561, 409
$CALCULATE  I:I\DH;>;I\DHO;VAL  D:$T\H$ IS OWED R$I\DHO$;ERRORM;I\DH    'I:I\DH;>;I\RUN_TOT;VAL  'D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DH    U:SURETY_BUYER_PMTS;CALC_AVAIL    I:I\OK;=;N  D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DH    'A:SUB;I\RUN_TOT;I\RUN_TOT;I\DH;;#0.00  'A:ADD;I\DH;I\ALLOC;I\ALLOC;;#
1 0.0 DS I -1 561, 433
$CALCULATE  I:I\DS;>;I\DSO;VAL  D:$T\S$ IS OWED R$I\DSO$;ERRORM;I\DS    'I:I\DS;>;I\RUN_TOT;VAL  'D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DS    U:SURETY_BUYER_PMTS;CALC_AVAIL    I:I\OK;=;N  D:THERE IS ONLY $I\RUN_TOT$ AVAILABLE;ERRORM;I\DS    'A:SUB;I\RUN_TOT;I\RUN_TOT;I\DS;;#0.00  'A:ADD;I\DS;I\ALLOC;I\ALLOC;;#
1 0.0 DFC I -1 561, 241
  
1 0.0 PD I -1 431, 481
  
1 0.0 PK I -1 431, 457
  
1 0.0 PS I -1 431, 433
  
1 0.0 PH I -1 431, 409
  
1 0.0 PU I -1 431, 385
  
1 0.0 PL I -1 431, 361
  
1 0.0 PF I -1 431, 337
  
1 0.0 PA I -1 431, 313
  
1 0.0 PSC I -1 431, 289
  
1 0.0 PMSF I -1 431, 265
  
1 0.0 PMAF I 0 11, 397
  
1 0.0 PFC I -1 431, 241
  
1 0.0 SD I -1 291, 481
  
1 0.0 SK I -1 291, 457
  
1 0.0 SS I -1 291, 433
  
1 0.0 SH I -1 291, 409
  
1 0.0 SU I -1 291, 385
  
1 0.0 SL I -1 291, 361
  
1 0.0 SF I -1 291, 337
  
1 0.0 SFC I -1 291, 241
  
1 0.0 SA I -1 291, 313
  
1 0.0 SSC I -1 291, 289
  
1 0.0 Label 19 T -1 21, 157
  
1 0.0 Label 21 T -1 291, 157
  
1 0.0 SMSF I -1 291, 265
  
1 0.0 Label 24 T -1 431, 205
  
1 0.0 Label 25 T -1 721, 205
  
1 0.0 Label 26 T -1 81, 241
  
1 0.0 Label 27 T 0 11, 349
  
1 0.0 Label 28 T -1 81, 265
  
1 0.0 Label 29 T -1 81, 289
  
1 0.0 Label 30 T -1 121, 313
  
1 0.0 Label 31 T -1 121, 337
  
1 0.0 Label 32 T -1 121, 361
  
1 0.0 Label 33 T -1 121, 385
  
1 0.0 Label 34 T -1 121, 409
  
1 0.0 Label 35 T -1 121, 433
  
1 0.0 Label 36 T -1 121, 457
  
1 0.0 Label 37 T -1 121, 481
  
1 0.0 Label 1 T -1 121, 505
  
1 0.0 RUN_TOT T -1 691, 85
  
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