Freshmark replication server

freshmark-canonical

Program drill-down

AGENT_SALES

AGENT SALES. Type DSP, base table DEBTOR_MAST.

Field inventory

248

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CONSIGN I -1 61, 229
$SELECT7  'DISPLAY A SELECTION WINDOW  F:CLIENT_MAST;;;I\CM_DELSECT=CM_DELSECT,I\CM_SUPPL_PROFORMA=CM_SUPPL_PROFORMA;CM_CODE='$I\MARKET$'  I:I\SCREEN_TYPE;<>;PS  DO(AS)    I:I\CM_DELSECT;=;1    DO(SECT)    U:DELIVERY_MAN;GET_IP;G\GRID    S:CONS_AGENT_SECT_SUPP;I\CONSIGN;I\AGENT;I\TMP3    DOEND(SECT)      I:I\CM_DELSECT
1 0.0 Work 1 I 0 681, 109
  
1 0.0 H -1 1, 85
  
1 0.0 Work 3 G -1 21, 253
  
1 0.0 CMD 4 C -1 231, 109
$SELECT  'DISPLAY A SELECTION WINDOW  S:DEBTOR;I\ST_DEBTOR  
1 0.0 CMD 15 C -1 641, 157
$SELECT  'DISPLAY A SELECTION WINDOW  S:BUYER_GROUP;I\GROUP
1 0.0 CMD 6 C -1 771, 229
$SELECT  'DISPLAY PERIOD SELECTION WINDOW  S:PERIOD_CODE;W\DEL
1 0.0 Label 1 T -1 21, 205
  
1 0.0 Label 20 T -1 21, 469
  
1 0.0 Label 17 T -1 571, 517
  
1 0.0 Label 16 T -1 571, 469
  
1 0.0 Label 1 T -1 21, 73
  
1 0.0 RESERVATION T -1 301, 73
  
1 0.0 Label 1 T 0 421, 193
  
1 0.0 Label 4 T 0 121, 589
  
1 0.0 Label 12 T -1 511, 157
  
1 0.0 Label 2 T -1 1, 49
  
1 0.0 Label 3 T -1 241, 457
  
1 0.0 Label 1 T -1 571, 493
  
1 0.0 Label 18 T -1 641, 205
  
1 0.0 Label 8 T -1 371, 205
  
1 0.0 Label 12 T -1 471, 205
  
1 0.0 Label 10 T -1 421, 205
  
1 0.0 Label 5 T -1 741, 205
  
1 0.0 Label 1 T -1 741, 181
  
1 0.0 Label 10 T -1 621, 109
  
1 0.0 INVDATE I -1 511, 85
$AFTER_READ  'DEFAULT CURRENT DATE  I:I\INVDATE;=;  A:DATE;DD MMM YYYY;I\INVDATE
1 0.0 Label 2 T -1 421, 85
  
1 0.0 Work 1 I 0 201, 73
  
1 0.0 Label 3 T -1 61, 205
  
1 0.0 Label 4 T -1 621, 49
  
1 0.0 Work 19 I -1 641, 229
  
1 0.0 Work 1 I 0 711, 121
  
1 0.0 Work 2 I 0 111, 37
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET  A:ORGS;;I\ORGS  A:USERID;;I\USERID    F:ZU_USER;;;I\ZU_PRN_NAME=ZU_PRN_NAME;ZU_USERID = '$I\USERID$';  F:ZV_USER_DEFAULTS;;;I\PRN_LOG=ZV_TEXT;ZV_CODE='PRN_LOG';  F:ZV_USER_DEFAULTS;;;I\RE_PRN_NAME=ZV_TEXT;ZV_CODE='RELOAD_PRN_NAME';    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_C
1 0.0 Work 3 I 0 471, 109
  
1 0.0 Work 3 I -1 51, 517
  
1 0.0 Work 1 I 0 381, 493
  
1 0.0 Work 1 I 0 401, 493
  
1 0.0 Work 1 I 0 431, 517
  
1 0.0 Work 1 I 0 701, 109
  
1 0.0 Work 2 I 0 451, 109
$VALIDATE  C:UCASE    'MAKE THIS FIELD MANDATORY  M:    O:ENABLEINPUT;I\ST_SMAN,C\SMAN  O:SETFOCUS;I\ST_SMAN  
1 0.0 Work 1 I 0 391, 493
  
1 0.0 Label 20 T -1 741, 205
  
1 0.0 Label 16 T -1 371, 181
  
1 0.0 Label 6 T -1 191, 205
  
1 0.0 Label 2 T -1 261, 109
  
1 0.0 STK_TRANS ST_DEBTOR T -1 21, 109
  
1 0.0 Label 14 T -1 561, 205
  
1 0.0 Label 17 T -1 421, 181
  
1 0.0 STK_TRANS ST_SMAN T -1 21, 145
  
1 0.0 Label 6 T -1 261, 145
  
1 0.0 Label 10 T -1 21, 181
  
1 0.0 Label 8 T -1 331, 49
  
1 0.0 Label 2 T -1 1, 25
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Label 3 T -1 621, 25
  
1 0.0 Label 6 T -1 671, 49
  
1 0.0 Label 2 T -1 671, 157
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Work 1 I -1 671, 517
  
1 0.0 SEQ I -1 21, 229
$SELECT  S:G:G\GRID:R1,I\SEQ  $SELECT6  S:G:G\GRID:F1,I\SEQ    $CALCULATE  I:I\MARKET;<>;60  DO(NOT60)  I:I\SEQ;=;  DO(001)   O:SETFOCUS;C\CREATE   O:BACKCOLOR;C\CREATE;YELLOW   O:DISABLEINPUT;I\CONSIGN,I\COMMOD,I\QTYAVAIL,I\SLDQTY,I\PRICE,I\VAT,I\VALUE,W\DEL   DOEND(001)  DOEND(NOT60)    I:I\MARKET;=;60  DO(NOT60)  I:
1 0.0 Work 2 I 0 331, 85
  
1 0.0 Work 2 I 0 541, 469
  
1 0.0 Work 1 I 0 461, 469
  
1 0.0 Work 1 I 0 401, 469
  
1 0.0 Work 1 I 0 361, 469
  
1 0.0 Work 2 I 0 421, 517
  
1 0.0 Work 1 I 0 441, 553
  
1 0.0 Work 3 I 0 21, 577
  
1 0.0 Work 6 I 0 141, 529
  
1 0.0 Work 4 I 0 411, 85
  
1 0.0 Work 1 I 0 471, 85
  
1 0.0 Work 2 I 0 61, 577
  
1 0.0 Work 1 I 0 431, 85
  
1 0.0 Work 1 I 0 451, 85
  
1 0.0 Work 8 I 0 141, 577
  
1 0.0 Work 7 I 0 141, 553
  
1 0.0 Work 4 I 0 91, 529
  
1 0.0 Work 5 I 0 91, 553
  
1 0.0 Work 1 I 0 381, 577
  
1 0.0 Work 11 I -1 421, 229
$CALCULATE  M:    'GET SUPPLIER CODE  F:AGENT_MAST;;;I\TMP=AM_DEL_LEN;AM_CODE='$I\AGENT$'  A:LEFT;I\CONSIGN,I\TMP;I\TMP1  F:STK_MAST;;;I\TMP1=SM_SUPP;SM_DELNO='$I\TMP1$' AND SM_MARKET='$I\MARKET$' AND SM_AGENT='$I\AGENT$' AND SM_DDATE='$I\DELDATE$';  F:SUPPLIER_MAST;;;I\PALL_SUPPL=SUM_PALL_SUPPL;SUM_SUPPL='$I\TMP1$'   
1 0.0 PRICE I -1 471, 229
$CALCULATE  'I:I\SCREEN_TYPE;=;PS  '  U:AGENT_SALES;BUYER_AGENT_SURETY_LIMIT    A:CONST;N;I\AGN_OVERRIDE  A:CONST;N;I\MKT_OVERRIDE    'GET SUPPLIER CODE  F:AGENT_MAST;;;I\TMP=AM_DEL_LEN;AM_CODE='$I\AGENT$'  A:LEFT;I\CONSIGN,I\TMP;I\TMP1  F:STK_MAST;;;I\TMP7=SM_SUPP;SM_DELNO='$I\TMP1$' AND SM_MARKET='$I\MARKET$' AND SM_
1 0.0 DEBTOR_MAST DM_AGENT I -1 141, 73
'$DEFAULT  'A:ORGS;;I\AGENT  'A:ORGS;;I\ORGS      ''COMMENTED BY JUSTIN ON 04/09/08===========================================================================================  ''LOAD AGENT NAME  ''F:AGENT_MAST;;AM_CODE;T\AGENT_NAME=AM_NAME,I\AM_DEL_LEN=AM_DEL_LEN,I\AM_TARGET_OVR=AM_TARGET_OVR,I\AM_TARGET_USE=AM_TARGET_
1 0.0 Label 2 T -1 181, 517
  
1 0.0 Work 1 I 0 461, 445
  
1 0.0 Work 1 I 0 191, 133
  
1 0.0 Work 1 I 0 101, 517
  
1 0.0 FULL_DUMP I 0 431, 61
  
1 0.0 Work 1 I 0 211, 565
  
1 0.0 Work 2 I 0 521, 61
  
1 0.0 Work 1 I 0 91, 73
  
1 0.0 Work 1 I 0 361, 109
$VALIDATE  C:UCASE    'O:ENABLEINPUT;I\ST_SMAN,C\SMAN  F:AGENT_MAST;;;I\TMP1=AM_SLSM_ENTRY;AM_CODE='$I\AGENT$'      I:I\MARKET;=;15  DO(MKT15)  O:ENABLEINPUT;I\ST_SMAN,C\SMAN  O:SETFOCUS;I\ST_SMAN  DOEND(MKT15)    I:I\MARKET;<>;15  DO(MKT15)  '$SVAR_FOCUS_LOST  O:SETFOCUS;I\SEQ  DOEND(MKT15)    I:I\MARKET;IN;32,39  DO(
1 0.0 PALLS_SOLD I 0 521, 529
  
1 0.0 Work 2 I 0 201, 73
  
1 0.0 Work 1 I 0 541, 181
  
1 0.0 DRMAST I 0 301, 529
  
1 0.0 Work 1 I 0 21, 145
  
1 0.0 Work 4 I 0 641, 85
  
1 0.0 Work 5 I 0 661, 85
  
1 0.0 Work 1 I 0 581, 85
  
1 0.0 Work 2 I 0 411, 121
  
1 0.0 Work 2 I 0 201, 49
  
1 0.0 Work 1 I 0 171, 529
  
1 0.0 Work 1 I 0 191, 529
  
1 0.0 Work 1 I 0 371, 121
  
1 0.0 Work 1 I 0 551, 61
  
1 0.0 AM_TARGET_USE I 0 281, 529
  
1 0.0 AM_TARGET_OVR I 0 361, 517
  
1 0.0 AM_DEL_LEN I 0 251, 529
  
1 0.0 Work 1 I 0 181, 553
  
1 0.0 Work 1 I 0 251, 49
  
1 0.0 Work 1 I 0 491, 61
  
1 0.0 Work 19 I -1 671, 469
  
1 0.0 Work 21 I -1 21, 493
  
1 0.0 Work 1 I 0 211, 73
  
1 0.0 Work 2 I 0 361, 433
  
1 0.0 Work 9 I -1 371, 229
  
1 0.0 Work 7 I -1 191, 229
  
1 0.0 TARGET I 0 21, 529
  
1 0.0 Work 2 I 0 251, 565
  
1 0.0 Work 1 I 0 231, 565
  
1 0.0 Work 2 I 0 371, 85
  
1 0.0 Work 3 I 0 391, 85
  
1 0.0 Work 1 I 0 311, 85
  
1 0.0 Work 1 I 0 351, 85
  
1 0.0 Work 2 I 0 411, 469
  
1 0.0 Work 1 I 0 531, 85
  
1 0.0 Work 1 I 0 511, 85
  
1 0.0 Work 1 I 0 571, 517
  
1 0.0 Work 1 I 0 461, 517
  
1 0.0 Work 1 I 0 381, 517
  
1 0.0 Work 3 I 0 401, 517
  
1 0.0 DELDATE I 0 221, 529
  
1 0.0 Work 1 I 0 231, 169
  
1 0.0 Work 2 I -1 671, 493
  
1 0.0 Work 1 I 0 121, 469
  
1 0.0 CM_DELSECT I 0 421, 469
  
1 0.0 Work 1 I 0 151, 49
  
1 0.0 Work 2 I 0 371, 145
  
1 0.0 Work 3 I 0 191, 457
  
1 0.0 Work 1 I 0 121, 469
  
1 0.0 Work 2 I 0 211, 457
  
1 0.0 Work 1 I 0 171, 469
  
1 0.0 Work 1 I 0 41, 529
  
1 0.0 Work 2 I 0 601, 85
  
1 0.0 Work 3 I 0 621, 85
  
1 0.0 Work 1 I 0 481, 121
  
1 0.0 Work 1 I 0 331, 169
  
1 0.0 Work 1 I 0 451, 157
  
1 0.0 Work 1 I 0 581, 517
  
1 0.0 Work 2 I 0 471, 517
  
1 0.0 EXIT I -1 401, 397
$SVAR_FOCUS  U:EXIT_SCREEN
1 0.0 Work 1 I 0 91, 145
  
1 0.0 Work 1 I 0 21, 553
  
1 0.0 Work 1 I 0 321, 517
  
1 0.0 Work 3 I 0 311, 565
  
1 0.0 Work 1 I 0 101, 37
  
1 0.0 Work 3 I 0 361, 493
  
1 0.0 Work 1 I 0 251, 73
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 2 I 0 471, 109
$VALIDATE  C:UCASE  'MAKE THIS FIELD MANDATORY  M:    F:DEBTOR_MAST;;DM_DEBTOR;W\EXIST1=DM_DEBTOR,T\ACT_BUYER_NAME=DM_NAME,I\TMP=DM_BLOCKED,I\TMP3=DM_SALE_BLOCK;DM_MARKET='$I\MARKET$';I\ACTUALBUYER  @I:W\EXIST1;=;  DO(EMSG)    O:ENABLEINPUT;I\ACTUALBUYER    D:BUYER $I\ACTUALBUYER$ DOES NOT EXIST;ERRORM;I\ACTUALBUYER  D
1 0.0 Work 1 I 0 521, 169
  
1 0.0 Work 13 I -1 601, 157
$SELECT  'DISPLAY A SELECTION WINDOW  S:BUYER_GROUP;I\GROUP    $VALIDATE  'MAKE THIS FIELD MANDATORY  M:  C:UCASE  'MAKE SURE THE GROUP IS A VALID GROUP AND DISPLAY THE GROUP DESC  F:BUYER_GROUP;Y;BG_CODE;T\GROUP_DESC=BG_DESC;;I\GROUP  
1 0.0 Work 11 I -1 141, 181
  
1 0.0 Work 1 I 0 361, 577
  
1 0.0 Work 1 I 0 281, 565
  
1 0.0 Pic 1 P -1 491, 73
  
1 0.0 Work 1 I 0 401, 493
  
1 0.0 Work 2 I -1 451, 517
  $CALCULATE    I:I\MARKET;=;60  DO(NOT60)  DO(001)   O:SETFOCUS;C\CREATE   O:BACKCOLOR;C\CREATE;YELLOW   O:DISABLEINPUT;I\CONSIGN,I\COMMOD,I\QTYAVAIL,I\SLDQTY,I\PRICE,I\VAT,I\VALUE,W\DEL   DOEND(001)  DOEND(NOT60)    M:  C:UCASE
1 0.0 Label 1 T -1 331, 517
  
1 0.0 Work 15 I -1 561, 229
  
1 0.0 Work 1 I 0 461, 61
  
1 0.0 Work 1 I 0 91, 73
$DEFAULT    A:DATE;DD MMM/YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  'A:TIMER_ON;1000  A:USERIP;;I\IP  A:ORGS;;I\AGENT  A:ORGS;;I\ORGS    'LOAD PORT  F:IP_MAST;;;I\PORT=IM_PORT;IM_IP='$I\IP$'    'JD CHANGE ON CHRISTO'S REQUEST 2011-06-07  I:I\MARKET;=;11  O:HIDE;I\TOTAL_RES_SALES_VALUE,T\CRAVA,I\CRLIMIT,T\CRLIM    I:I\MARKET
1 0.0 Work 1 I 0 251, 169
  
1 0.0 Work 1 I 0 271, 169
  
1 0.0 Work 2 I 0 291, 169
  
1 0.0 Work 3 I 0 311, 169
  
1 0.0 Work 1 I 0 261, 145
  
1 0.0 Work 3 I 0 741, 73
  
1 0.0 I -1 141, 109
'$DEFAULT  ''INITIALIZES THE GRID   'U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\CONSIGN,I\COMMOD,I\QTYAVAIL,I\SLDQTY,I\PRICE,I\VAT,I\VALUE,I\DELDATE:H,I\PALLS_SOLD:H,I\DOC_MSG:H,I\ITEM:H,I\DISCVAL:H,I\VAROR:H,W\DEL    ''PUTS PIC ON THE UPDATE BUTTON  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE    $SE
1 0.0 Work 1 I 0 641, 181
  
1 0.0 Work 3 I 0 501, 49
  
1 0.0 CMD 5 C -1 161, 229
$SELECT  'DISPLAY A SELECTION WINDOW  F:CLIENT_MAST;;;I\CM_DELSECT=CM_DELSECT;CM_CODE='$I\SM_MARKET$'  I:I\SCREEN_TYPE;<>;PS  DO(AS)    I:I\CM_DELSECT;=;1    DO(SECT)    U:DELIVERY_MAN;GET_IP;G\GRID    S:CONS_AGENT_SECT;I\CONSIGN;I\AGENT;I\TMP3    DOEND(SECT)      I:I\CM_DELSECT;=;0    S:CONS_AGENT;I\CONSIGN;I\AGENT;  
1 0.0 CMD 5 C -1 201, 145
$SELECT  S:SALESMAN_AGENT;I\ST_SMAN;I\AGENT
1 0.0 Work 2 I 0 251, 145
  
1 0.0 Work 1 I 0 511, 493
  
1 0.0 Work 3 I 0 421, 145
  
1 0.0 Work 21 I -1 741, 229
$SELECT    'ALLOW FOR PERIOD SELECTION IF SCREEN TYPE IS PROVISIONAL SALES (PS)  I:I\SCREEN_TYPE;=;PS  DO(PS)    'DISPLAY PERIOD SELECTION WINDOW    S:PERIOD_CODE;W\DEL  DOEND(PS)    A:CONST;Y;I\CHK    $CALCULATE    '''==================================================================  '''MOMZ TESTING PRICE FOR DURBAN 
1 0.0 Work 1 I 0 61, 145
  
1 0.0 I -1 141, 145
$SELECT  'DISPLAY A SELECTION WINDOW  S:SALESMAN_AGENT;I\ST_SMAN;I\AGENT    $CALCULATE    M:  I:I\MARKET;<>;17  A:VAR;I\ST_SMAN;I\ST_SMAN;;000    I:I\AGENT;EX;MS,AAM  DO(NOTMS)  A:VAR;I\ST_SMAN;I\ST_SMAN;;000  DOEND(NOTMS)      I:I\MARKET;=;17  DO(17)  I:I\AGENT;IN;MS,AAM  F:SALESMAN_MAST;;;I\ST_SMAN=SLS_CODE;SLS_HIDDE
1 0.0 CMD 1 C -1 651, 541
$SELECT    I:I\ST_DEBTOR;=;  D:BUYER NUMBER IS BLANK - PLEASE RECAPTURE SALE;ERRORM;I\SEQ    I:I\MARKET;<>;69;  DO(6I9)    I:I\ST_DEBTOR;=;3    D:BUYER NUMBER IS INCORRECT - PLEASE RECAPTURE SALE;ERRORM;I\SEQ  DOEND(6I9)    I:I\DM_UNALLOC_ACTIVE;=;Y  DO(11)    I:I\TOTAL;>;I\DM_UNALLOC_AMT    D:PURCHASE LIMIT EXCEEDED;E
1 0.0 Work 1 I 0 201, 73
  
1 0.0 Work 1 I 0 651, 169
  
1 0.0 Work 1 I 0 711, 145
  
1 0.0 Work 1 I 0 451, 517
  
1 0.0 Work 1 I 0 321, 517
  
1 0.0 Work 1 I 0 681, 169
  
1 0.0 Work 2 I 0 561, 445
  
1 0.0 Work 1 I 0 151, 49
  
1 0.0 Work 2 I 0 701, 133
  
1 0.0 Work 1 I 0 731, 109
  
1 0.0 Work 2 I 0 711, 133
  
1 0.0 Work 1 I 0 91, 397
  
1 0.0 Work 2 I 0 131, 397
  
1 0.0 Work 2 I 0 491, 85
  
1 0.0 Work 1 I 0 611, 133
  
1 0.0 I 0 771, 145
  
1 0.0 Work 1 I 0 341, 553
  
1 0.0 Work 1 I 0 411, 469
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 2 I 0 400, 499
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 2 I 0 400, 499
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 1 I -1 520, 145
$VALIDATE    C:UCASE
1 0.0 Label 2 T -1 421, 145
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Check 1 K -1 331, 493
  
1 0.0 Label 4 T -1 481, 493
  
1 0.0 Check 1 K -1 451, 493
  $CALCULATE  
1 0.0 I\FLOORWHS I -1 550, 100
$VALIDATE  C:UCASE  M:    V:W;F;    I:I\FLOORWHS;=;  A:CONST;W;I\FLOORWHS
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 2 I 0 400, 499
  
1 0.0 Work 3 I 0 400, 499
  
1 0.0 Work 2 I 0 400, 499
  
1 0.0 Work 1 I 0 550, 73
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 T\FLOORWHS T -1 401, 97
  
1 0.0 Work 2 I 0 400, 499
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 2 I 0 400, 499
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 1 I 0 491, 73
  
1 0.0 Work 2 I 0 510, 73
  
1 0.0 Work 1 I 0 480, 499
  
1 0.0 Work 2 I 0 530, 541
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 1 I 0 481, 493
  
1 0.0 Work 1 I 0 400, 499
  
1 0.0 Work 2 I 0 400, 499
  
1 0.0 Work 2 I 0 400, 499
  
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    '$SELECT  $UPDATE  U:ZZGRID_VALIDATE;INIT_GRID;G\GRID    F:AGENT_MAST;;;I\TMP=AM_PIN_SALES;AM_CODE='$I\AGENT$'  F:AGENT_SURETY;;;I\AS_SURETY=AS_SURETY;AS_MARKET='$I\MARKET$' AND AS_AGENT='$I\AGENT$' AND AS_BUYER='$I\ST_DEBTOR$' AND AS_BLOCK = 'N'  I:I\SCREEN_TYPE;=;PS  DO(
10 0.0 ZX_EXIT Z 0 1, 85
$EXIT  'RESET ACTIVE FLAG ON EXIT  'U:AGENT_SALES;RESET_ACTIVE  'ADDED BY LP20120417 ON JANET REQUEST (SET THE BUYER TO NON-ACTIVE)  U:AGENT_SALES_BUYER_LOCK;UNACTIVE_BUYER