Freshmark replication server

freshmark-canonical

Program drill-down

BUYERS_SURETY

BUYERS SURETY MAINTENANCE. Type MAN, base table AGENT_SURETY.

Field inventory

38

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 Work 3 I -1 221, 313
  
1 0.0 AGENT_SURETY AS_AGENT I -1 151, 313
'SELECTING AGENT CODE FROM AGENT_MAST TABLE   $SELECT  S:AGENT_MAST;I\AS_AGENT        'CHANGE TEXT CASE TO UPPER CASE AND SET THIS FIELD MANDATIRY   $VALIDATE  M:  C:UCASE    F:AGENT_MAST;Y;AM_CODE;I\AS_NAME=AM_NAME;AM_BLOCK<>'Y';I\AS_AGENT    U:GRID_DESC_LOAD;LOAD;G\GRID,I\AS_AGENT,AM_NAME,AGENT_MAST,AM_CODE,I\AS_NAME
1 0.0 AGENT_SURETY AS_AGENT T -1 151, 289
  
1 0.0 AGENT_SURETY AS_BLOCK I -1 521, 313
'CHANGE TEXT CASE TO UPPER CASE AND SET THIS FIELD MANDATORY  $VALIDATE  C:UCASE  ONLY ALLOW THIS INPUT  V:Y;N;    I:I\AS_BLOCK;=;  A:CONST;N;I\AS_BLOCK
1 0.0 Label 1 T -1 581, 289
  
1 0.0 AGENT_SURETY AS_BLOCK T -1 521, 289
  
1 0.0 DEBTOR_MAST DM_DEBTOR T -1 251, 121
  
1 0.0 DEBTOR_MAST DM_DEBTOR I -1 411, 121
'SELECTING BUYER NUMBER FROM DEBTOR_MAST TABLE FOR F5 FUNCTION  $SELECT  S:BUYER NUMBER;I\DM_DEBTOR    'CHANGE TEXT CASE TO UPPER CASE AND SET THIS FIELD MANDATORY  $VALIDATE  M:  C:UCASE  'LOOK UP FOR THE EXISTING DEBTOR NUMBER, IF DOES NOT EXISTS DISPLAY ERROR MESSAGE  F:DEBTOR_MAST;Y;DM_DEBTOR;I\DM_DEBTOR=DM_DEBTOR,
1 0.0 AGENT_SURETY AS_SURETY I -1 371, 313
$VALIDATE  I:I\AS_SURETY;=;.00  D:AMOUNT CANNOT BE ZERO - PLEASE RE-ENTER;ERRORM;I\AS_SURETY
1 0.0 AGENT_SURETY AS_AGREE_NO I -1 581, 313
  
1 0.0 AGENT_SURETY AS_SURETY T -1 371, 289
  
1 0.0 DEBTOR_MAST DM_NAME I -1 411, 145
  
1 0.0 DEBTOR_MAST DM_NAME T -1 251, 145
  
1 0.0 DEBTOR_MAST DM_OSBAL I -1 411, 193
  
1 0.0 DEBTOR_MAST DM_OSBAL T -1 251, 193
  
1 0.0 DEBTOR_MAST DM_CRLIMIT I -1 411, 169
  
1 0.0 DEBTOR_MAST DM_CRLIMIT T -1 251, 169
  
1 0.0 Work 15 G -1 151, 337
  
1 0.0 CMD 16 C -1 191, 313
'SELECTING AGENT CODE FROM AGENT_MAST TABLE   $SELECT  S:AGENT_MAST;I\AS_AGENT
1 0.0 Label 17 T -1 221, 289
  
1 0.0 CMD 18 C -1 531, 121
'SELECTING BUYER NUMBER FROM DEBTOR_MAST TABLE FOR F5 FUNCTION  $SELECT  S:BUYER NUMBER;I\DM_DEBTOR
1 0.0 Label 19 T -1 291, 25
  
1 0.0 Label 20 T -1 215, 49
  
1 0.0 Label 21 T -1 671, 25
  
1 0.0 Label 22 T -1 621, 25
  
1 0.0 Label 23 T -1 671, 49
  
1 0.0 Label 24 T -1 621, 49
  
1 0.0 Work 25 I 0 61, 109
$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\GRID;I\AS_AGENT,I\AS_NAME,I\AS_MARKET:H,I\AS_BUYER:H,I\AS_SURETY,I\AS_BLOCK,I\AS_AGREE_NO  
1 0.0 AGENT_SURETY AS_MARKET I 0 211, 253
  
1 0.0 Label 27 T -1 1, 25
  
1 0.0 AGENT_SURETY AS_BUYER I 0 281, 253
  
1 0.0 Work 2 I 0 131, 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
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