Freshmark replication server

freshmark-canonical

Program drill-down

CS_AGENT_ISS2_MAN

AGENT COLD STORAGE ISSUES. Type DSP, base table STK_DETS.

Field inventory

132

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 BLOCKED I 0 381, 481
  
1 0.0 WW I 0 281, 97
  
1 0.0 SD_CONTMASS I 0 101, 541
  
1 0.0 Work 1 I 0 401, 481
  
1 0.0 TEMP I 0 491, 445
  
1 0.0 Work 1 I 0 711, 493
  
1 0.0 TMP_TARIFF I 0 651, 517
  
1 0.0 Work 1 I 0 141, 49
  
1 0.0 Label 10 T -1 331, 205
  
1 0.0 SM_DDATE I 0 71, 49
  
1 0.0 STK_DETS SD_DATE I 0 111, 505
  
1 0.0 Work 1 I 0 441, 445
  
1 0.0 Work 1 I 0 221, 541
  
1 0.0 PERIOD I 0 461, 181
  
1 0.0 SD_PROV I 0 121, 541
  
1 0.0 LOC_TRANS LT_PRQTY_AVAIL I -1 289, 229
  
1 0.0 MIN CHARGE I 0 461, 505
  
1 0.0 Work 1 I 0 301, 553
  
1 0.0 UPDATE_FLAG I 0 731, 253
  
1 0.0 Work 1 I 0 541, 505
  
1 0.0 DEPNO I -1 35, 229
  
1 0.0 TARIFF_OVRRD I 0 241, 481
  
1 0.0 LOC_TRANS LT_PRQTY I -1 331, 229
$CALCULATE  M:    'CLEAR WORK FIELD  'A:CONST;;W\RESULT,W\VATCODE      'MAKE SURE QTY IS NOT < 0  I:I\LT_PRQTY;<=;0;NUM  D:QUANTITY MUST BE GREATER THAN ZERO;ERRORM;I\LT_PRQTY      'CHECK QTY IS NOT GREATER THAN QTY AVAIL  I:I\LT_PRQTY;>;I\LT_PRQTY_AVAIL;NUM  D:THIS IS GREATER THAN THE QUANTITY AVAILABLE;ERRORM;I\LT_PR
1 0.0 MAX CHARGE I 0 481, 505
  
1 0.0 Work 1 I 0 441, 469
  
1 0.0 TEMP DATE 2 I 0 201, 541
  
1 0.0 Label 2 T -1 520, 181
  
1 0.0 Work 2 I 0 771, 253
  
1 0.0 DELNO T -1 21, 97
  
1 0.0 LOC_TRANS LT_CS_PRDTYPE I -1 522, 229
' THIS FIELD WAS "I/PERIODTYPE" AND IT IS NOW "I\LT_CS_PRDTYPE"    $CALCULATE  'MAKE THIS FIELD MANDATORY  M:      'VALIDATE THE PERIOD TYPE ENTERED  F:PERIOD_TYPE;Y;;;PT_TYPE='$I\LT_CS_PRDTYPE$';I\LT_CS_PRDTYPE    
1 0.0 Label 3 T -1 42, 203
  
1 0.0 Work 1 I 0 91, 49
$DEFAULT    'PUTS PIC ON THE UPDATE BUTTON  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE    A:DATE;DD MMM/YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    'GETS WHICH SCREEN IS BEING DISPLAYED I.E. AGENTS DEPOSIT (AD) OR AGENT ISSUE (AI)  A:PARM;1;I\SCREEN_TYPE    'CHANGES THE TITLE OF THE S
1 0.0 LOC_TRANS LT_LOCA I -1 170, 229
  
1 0.0 Work 1 I 0 441, 445
  
1 0.0 Label 17 T -1 327, 182
  
1 0.0 LOC_TRANS LT_TRTARIFF I -1 431, 229
'THE WHOLE VALIDATIONS/CHECKS CREATED BY LAZ   $VALIDATE  'CLEAR WORK FIELDS  A:CONST;0.00;I\LT_TRVALUE,I\LT_TRVAT,I\TOTAL_DUE  A:CONST;;I\LT_CHG_PRD,W\RESULT  'W\RESULT  'I:I\TARIFF_OVRRD;=;Y   'DO(OVERRIDE)    'I:I\LT_TRTARIFF;<>;0     'DO(01)      I:I\TARIFF_OVRRD;<>;Y          DO(DLO)           'I:I\TMP_TARIFF;=;0 
1 0.0 LOC_TRANS LT_TRVALUE I -1 558, 229
$DEFAULT  O:DISABLEINPUT;I\LT_TRVALUE      $CALCULATE      'CHECK MINUMUM  U:CS_AGENT_ISS_MAN;MINIMUM    I:W\FLAG2;=;N  D:RE-ENTER THE NET AMOUNT FOR THIS ISSUE;ERRORM;I\LT_TRVALUE        '===========================CALCULATE VAT============ BEGIN ================================    'CALCULATE THE VAT    F:VAT_MAST;;;W
1 0.0 Label 4 T -1 562, 205
  
1 0.0 Label 5 T -1 561, 181
  
1 0.0 Label 6 T -1 627, 203
  
1 0.0 Label 10 T -1 693, 203
  
1 0.0 TOTAL DUE I -1 691, 229
  
1 0.0 Label 8 T -1 691, 181
  
1 0.0 LOC_TRANS LT_TRVAT I -1 627, 229
  
1 0.0 Label 11 T -1 111, 445
  
1 0.0 STK_MAST SM_AGENT T -1 411, 97
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 4 T -1 621, 49
  
1 0.0 STK_DETS SD_AGENT I -1 511, 97
    
1 0.0 Label 1 T -1 1, 205
  
1 0.0 SD_DETS SD_CONSIGN I -1 121, 97
$SELECT  I:I\MARKET;<>;37  DO(CHK)  I:I\AGENT;<>;  DO(AGN)   '****************  USE OWN COLD OR SEE MARKETS TOO   I:I\OWN_CR;=;Y    S:CONSIGN_DEPOSITS;I\SD_CONSIGN;I\MARKET;I\AGENT   I:I\OWN_CR;=;N    S:CONSIGN_DEPOSITS2;I\SD_CONSIGN;I\MARKET;I\AGENT  DOEND(AGN)    I:I\AGENT;=;    S:CONSIGN_DEPOSITS_MKT;I\SD_CONSIGN;I\
1 0.0 Label 6 T -1 671, 49
  
1 0.0 SD_ITEM I 0 21, 541
  
1 0.0 SD_CLASS Work 3 I 0 41, 541
  
1 0.0 Work 1 I 0 21, 505
  
1 0.0 LOC_TRANS LT_SHELF I -1 249, 229
  
1 0.0 Label 10 T -1 251, 205
  
1 0.0 Label 12 T -1 432, 205
  
1 0.0 Label 3 T -1 519, 205
  
1 0.0 Label 1 T -1 483, 205
  
1 0.0 LOC_TRANS LT_DEP_DATE I -1 100, 229
  
1 0.0 Label 2 T -1 101, 205
  
1 0.0 Label 8 T -1 211, 205
  
1 0.0 LOC_TRANS LT_SECTION I -1 209, 229
  
1 0.0 Label 9 T 0 1, 169
  
1 0.0 COMMODITY I -1 121, 133
  
1 0.0 CHARGE TYPE I 0 221, 445
  
1 0.0 Label 12 T -1 411, 133
  
1 0.0 Work 13 I -1 511, 133
  
1 0.0 Work 1 G -1 1, 253
  
1 0.0 Label 5 T -1 169, 182
  
1 0.0 LOC_TRANS LT_DEPNO I 0 11, 265
  
1 0.0 H -1 1, 85
  
1 0.0 Label 6 T -1 170, 204
  
1 0.0 CMD 4 C -1 221, 97
$SELECT  I:I\MARKET;<>;37  DO(CHK)  I:I\AGENT;<>;  DO(AGN)   '****************  USE OWN COLD OR SEE MARKETS TOO   I:I\OWN_CR;=;Y    S:CONSIGN_DEPOSITS;I\SD_CONSIGN;I\MARKET;I\AGENT   I:I\OWN_CR;=;N    S:CONSIGN_DEPOSITS2;I\SD_CONSIGN;I\MARKET;I\AGENT  DOEND(AGN)    I:I\AGENT;=;    S:CONSIGN_DEPOSITS_MKT;I\SD_CONSIGN;I\
1 0.0 Label 3 T -1 621, 25
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Label 2 T -1 1, 25
  
1 0.0 CMD 1 C -1 651, 545
$SCMD_FOCUS  O:BACKCOLOR;C\CREATE;YELLOW    $SELECT    I:I\LT_TRANS;=;    DO(UPD)       'UPDATE GRID DATA       U:CS_AGENT_ISS_MAN;UPD_GRID_DATA;G\GRID         'INITIALIZE THE GRID TO CLEAR ITS CONTENTS       U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\LT_TRANS,I\LT_DEPNO:H,W\DEPNO,I\LT_DEP_DATE,I\LT_LOCA,I\LT_SECTION,I\LT_SHELF
1 0.0 Work 1 I 0 1, 541
  
1 0.0 VATRATE I 0 591, 445
  
1 0.0 Work 1 I 0 361, 481
  
1 0.0 Work 2 I 0 1, 505
  
1 0.0 LT_CHG_PRD I -1 482, 229
$CALCULATE  'MAKE THIS FIELD MANDATORY  M:    I:I\LT_CHG_PRD;<;O;NUM  D:ERROR - PERIOD CANNOT BE LESS THAN ZERO;ERRORM;I\LT_CHG_PRD
1 0.0 Work 3 I 0 161, 541
  
1 0.0 Work 4 I 0 421, 157
  
1 0.0 VATCODE I 0 591, 481
  
1 0.0 Work 2 I 0 241, 541
  
1 0.0 Label 8 T -1 1, 181
  
1 0.0 Work 1 I 0 141, 541
  
1 0.0 CM_DEL_LEN I 0 261, 97
  
1 0.0 LOC_TRANS LT_DEP_TIME I 0 731, 253
  
1 0.0 PALLET DATA I 0 751, 253
  
1 0.0 Label 1 T 0 41, 169
  
1 0.0 SD_SIZE I 0 61, 541
  
1 0.0 SD_CONT I 0 81, 541
  
1 0.0 Label 7 T 0 691, 169
  
1 0.0 Label 6 T 0 557, 169
  
1 0.0 Label 5 T 0 511, 169
  
1 0.0 TEMP DATE 1 I 0 181, 541
  
1 0.0 Label 2 T 0 168, 169
  
1 0.0 Label 3 T 0 275, 159
  
1 0.0 Label 4 T 0 314, 159
  
1 0.0 Work 1 I 0 411, 61
  
1 0.0 Label 2 T -1 601, 133
  
1 0.0 LOC_TRANS LT_TRANS I -1 1, 229
$SVAR_FOCUS  'A:CONST;+;I\LT_TRANS        $SELECT  S:G:G\GRID:R1,I\LT_TRANS  $SELECT6  S:G:G\GRID:F1,I\LT_TRANS    $CALCULATE  I:I\LT_TRANS;=;    DO(001)      'O:SETFOCUS;C\CREATE      '''O:DISABLEINPUT;I\CONSIGN,I\COMMODITY,I\SLDQTY,I\PRICE,I\VAT,I\VALUE,W\DEL          'DISABLE GRID FIELDS      O:DISABLEINPUT;I\LT_CHG
1 0.0 AGENT I 0 21, 49
$DEFAULT  A:ORGS;;I\AGENT      'GET USERNAME  A:USERNAME;;I\USER    'GET USER IP  A:USERIP;;I\IP      'LOAD AGENT NAME  F:AGENT_MAST;;AM_CODE;T\AGENT=AM_NAME          'INITIALIZE THE GRID  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\LT_TRANS,I\LT_DEPNO:H,W\DEPNO,I\LT_DEP_DATE,I\LT_LOCA,I\LT_SECTION,I\LT_SHELF,I\LT_PRQTY_AVAIL,I\
1 0.0 Label 20 T -1 770, 201
  
1 0.0 Work 2 I 0 1, 49
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;I\CHARGEDAILY=CM_GENERATE_CS_CHARGE,I\OWN_CR=CM_OWN_ROOMS,I\TMP_TARIFF=CM_CS_MAX_CHARGE,I\TARIFF_OVRRD=CM_CS_ALLOW_TO,T\MARKET=CM_NAME,W\CM_DEL_LEN=CM_DEL_LEN,W\VATCODE=CM_CSVATCD,W\CS_MIN=CM_CS_MIN_CHARGE,W\CS_MAX=CM_CS_MAX_CHAR
1 0.0 TOTAL PALL I -1 361, 445
  
1 0.0 Work 12 I -1 311, 445
  
1 0.0 LT_PALL_QTY I -1 381, 229
$CALCULATE  'CLEAR FIELD  A:CONST;;W\TEMP    C:UCASE    'DETERMINE THE OWNER  'F:LOCATION_MAST;;;W\TMP=LM_AGENT;LM_CODE='$I\LT_LOCA$'    'IF LM_AGENT IS NULL THE OWNER IS THE MARKET - SO U MUST GET CHARGE TYPE FROM "CLIENT_MAST"  'I:W\TEMP;=;  'F:CLIENT_MAST;;;W\CHARGE_TYPE=CM_CHG_TYPE;CM_CODE='$I\MARKET$'      'IF LM_
1 0.0 Work 21 I -1 771, 229
$CALCULATE      'A:VAR;W\LT_PALL_QTY;I\LT_PALL_QTY       O:DISABLEINPUT;I\LT_TRVALUE      'CHECK MINUMUM  U:CS_AGENT_ISS_MAN;MINIMUM    'I:W\FLAG2;=;Y  '  DO(FY)          'CONVERT TO UPPERCASE      C:UCASE          'ALLOW ONLY 'D' OR BLANK IN THIS FIELDS      V:D;          'LOAD SCREEN DATA INTO THE GRID      U:ZZGRID_
1 0.0 AGENT_NAME T -1 601, 97
  
1 0.0 DEL DATE T -1 21, 133
  
1 0.0 Label 8 T -1 271, 49
  
1 0.0 Work 3 I 0 311, 505
  
1 0.0 Work 1 I 0 231, 73
  
1 0.0 DEPOSITS I 0 301, 97
  
1 0.0 Work 1 I 0 171, 49
  
1 0.0 Label 16 T -1 286, 182
  
1 0.0 Work 14 I -1 691, 445
  
1 0.0 Label 2 T -1 39, 181
  
1 0.0 Label 12 T -1 381, 205
  
1 0.0 Label 8 T -1 291, 205
  
1 0.0 FLAG2 I 0 501, 505
  
1 0.0 I\TMP10 I 0 151, 481
  
10 0.0 ZX_PRINT Z 0 1, 85
  
10 0.0 ZX_SELECT Z 0 1, 85
  
10 0.0 ZX_DELETE Z 0 1, 85
  
10 0.0 ZX_UPDATE Z 0 1, 85
'$BEFORE_WRITE  'U:AGENT_SALES;BUYER_PIN_NO
10 0.0 ZX_EXIT Z 0 1, 85