Program drill-down
TRANSFER_RESERVATION
TRANSFER RESERVATION PER DOCKET. Type MAN, base table DEBTOR_MAST.
Field inventory
160
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Label 2 | T | -1 | 251, 181 | ||
| 1 | 0.0 | Work 1 | I | 0 | 341, 217 | ||
| 1 | 0.0 | Label 2 | T | -1 | 1, 181 | ||
| 1 | 0.0 | Work 4 | I | -1 | 732, 277 | $VALIDATE C:UCASE V:Y;N; I:I\TRANSFER;=; A:CONST;N;I\TRANSFER U:TRANSFER_RESERVATIONS_PER_DOCKET;CONFIRM_PALLETS;G\GRID U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\LINE O:SETFOCUS;I\LINE A:CONST;;I\LINE,I\ST_DOCNO,I\CON,I\COMM,I\AQTY,I\QTY,I\VAT,I\VALUE,I\TRANSFER |
|
| 1 | 0.0 | CMD 3 | C | -1 | 211, 181 | $SELECT S:DEBTOR;I\TO_BUYER |
|
| 1 | 0.0 | Work 3 | I | 0 | 381, 217 | ||
| 1 | 0.0 | Work 3 | I | 0 | 251, 205 | ||
| 1 | 0.0 | Work 4 | I | 0 | 281, 205 | ||
| 1 | 0.0 | Work 5 | I | 0 | 311, 205 | ||
| 1 | 0.0 | Work 1 | I | 0 | 431, 457 | ||
| 1 | 0.0 | Work 2 | I | 0 | 481, 457 | ||
| 1 | 0.0 | Work 3 | I | 0 | 531, 457 | ||
| 1 | 0.0 | CMD 1 | C | 0 | 651, 548 | '$SELECT 'I:I\AGENT;=; 'D:AGENT CODE IS A MANDATORY FIELD;ERRORM;I\AGENT 'F:AGENT_MAST;Y;;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT 'I:I\FROM_BUYER;=; 'D:FROM BUYER IS A MANDATORY FIELD;ERRORM;I\FROM_BUYER 'F:DEBTOR_MAST;Y;;I\BLOCKED=DM_BLOCKED,T\FROM_BUYER1=DM_NAME;DM_DEBTOR='$I\FROM_BUYER$';I\FRO |
|
| 1 | 0.0 | Work 1 | I | -1 | 111, 181 | $SELECT S:DEBTOR;I\TO_BUYER $CALCULATE A:CONST;;I\BLOCKED1,I\DEBTOR_TYPE A:CONST;;T\NAME_TO_BUYER,I\FIND_CHEP_SALES,I\TO_BUYER_CHEP_ACC,I\DM_ACTIVE2 M: F:DEBTOR_MAST;Y;;I\DM_EXPORT_IND=DM_EXPORT_IND,I\BLOCKED1=DM_BLOCKED,T\NAME_TO_BUYER=DM_NAME,I\DEBTOR_TYPE=DM_ACCTYPE,I\DM_SC_UNSEC=DM_SC_UNSEC,I\DM_ACTIVE2=DM_ |
|
| 1 | 0.0 | Work 12 | I | 0 | 551, 217 | ||
| 1 | 0.0 | Work 11 | I | 0 | 441, 217 | ||
| 1 | 0.0 | Label 2 | T | -1 | 1, 253 | ||
| 1 | 0.0 | Work 1 | I | -1 | 1, 277 | $CALCULATE I:I\LINE;=; DO(001) O:SETFOCUS;C\CREATE O:BACKCOLOR;C\CREATE;YELLOW O:DISABLEINPUT;I\TRANSFER A:CONST;;I\QTY,I\PRICE,I\VALUE DOEND(001) I:I\LINE;<>; DO(002) U:ZZGRID_SPLIT;GRID_TO_SCREEN;G\GRID;I\LINE I:I\ST_DOCNO;<>; DO(003) O:ENABLEINPUT;I\LINE,I\TRANSFER O:SETFOCUS;I\TR |
|
| 1 | 0.0 | Work 2 | I | 0 | 321, 85 | ||
| 1 | 0.0 | Work 1 | I | 0 | 281, 85 | ||
| 1 | 0.0 | Work 4 | I | 0 | 291, 457 | ||
| 1 | 0.0 | Work 3 | I | 0 | 271, 457 | ||
| 1 | 0.0 | Work 1 | I | 0 | 451, 181 | ||
| 1 | 0.0 | Work 10 | I | 0 | 411, 457 | ||
| 1 | 0.0 | Work 9 | I | 0 | 391, 457 | ||
| 1 | 0.0 | Work 8 | I | 0 | 371, 457 | ||
| 1 | 0.0 | Work 7 | I | 0 | 351, 457 | ||
| 1 | 0.0 | Work 6 | I | 0 | 331, 457 | ||
| 1 | 0.0 | Work 5 | I | 0 | 311, 457 | ||
| 1 | 0.0 | Work 10 | I | 0 | 181, 229 | ||
| 1 | 0.0 | Work 17 | I | 0 | 401, 181 | ||
| 1 | 0.0 | Work 6 | I | 0 | 31, 229 | ||
| 1 | 0.0 | Work 5 | I | 0 | 1, 229 | ||
| 1 | 0.0 | Work 1 | I | 0 | 441, 85 | ||
| 1 | 0.0 | Work 1 | I | 0 | 431, 181 | ||
| 1 | 0.0 | Work 16 | I | 0 | 371, 181 | ||
| 1 | 0.0 | Label 2 | T | -1 | 1, 157 | ||
| 1 | 0.0 | CMD 3 | C | -1 | 211, 157 | $SELECT S:SLS_ACCESS_PORT;I\SECTION;I\AGENT;I\PORT |
|
| 1 | 0.0 | Label 4 | T | -1 | 251, 157 | ||
| 1 | 0.0 | Work 13 | I | 0 | 281, 181 | ||
| 1 | 0.0 | Work 7 | I | 0 | 61, 229 | ||
| 1 | 0.0 | Work 8 | I | 0 | 121, 229 | ||
| 1 | 0.0 | Work 15 | I | 0 | 341, 181 | ||
| 1 | 0.0 | Work 9 | I | 0 | 91, 229 | ||
| 1 | 0.0 | Work 11 | I | 0 | 151, 229 | ||
| 1 | 0.0 | Work 12 | I | 0 | 261, 181 | ||
| 1 | 0.0 | Work 14 | I | 0 | 311, 181 | ||
| 1 | 0.0 | Work 1 | I | -1 | 111, 157 | $SELECT S:SLS_ACCESS_PORT;I\SECTION;I\AGENT;I\PORT $CALCULATE A:CONST;;G\GRID,I\TOTAL,I\CRED,W\PORT U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\LINE,I\ST_DOCNO,I\CON,I\COMM,I\QTY,I\PRICE,I\ST_ORIG_QTY:H,I\ST_ORIG_PRICE:H,I\ORIG_VAT:H,I\DELDATE:H,I\PALLET_CON:H,I\PALLET_DELDATE:H,I\DOC_MSG:H,I\ST_RECNO:H,I\ST_SMAN:H |
|
| 1 | 0.0 | Work 1 | I | 0 | 651, 133 | ||
| 1 | 0.0 | SMAN | I | 0 | 731, 157 | ||
| 1 | 0.0 | Work 6 | I | 0 | 561, 325 | ||
| 1 | 0.0 | Work 4 | I | 0 | 371, 325 | ||
| 1 | 0.0 | Work 5 | I | 0 | 411, 325 | ||
| 1 | 0.0 | ORIG_TOTAL | I | 0 | 321, 553 | ||
| 1 | 0.0 | Work 1 | I | 0 | 721, 145 | ||
| 1 | 0.0 | Work 2 | I | 0 | 531, 109 | ||
| 1 | 0.0 | Work 5 | I | 0 | 511, 325 | ||
| 1 | 0.0 | Work 3 | I | 0 | 321, 325 | ||
| 1 | 0.0 | Work 2 | I | 0 | 541, 157 | ||
| 1 | 0.0 | Work 1 | I | 0 | 591, 157 | ||
| 1 | 0.0 | Work 4 | I | 0 | 641, 97 | ||
| 1 | 0.0 | Work 3 | I | 0 | 721, 121 | ||
| 1 | 0.0 | Work 2 | I | 0 | 701, 157 | ||
| 1 | 0.0 | FLAG | I | 0 | 541, 517 | ||
| 1 | 0.0 | ACCTYPE | I | 0 | 521, 517 | ||
| 1 | 0.0 | CONTINUE | I | 0 | 581, 517 | ||
| 1 | 0.0 | FLAG2 | I | 0 | 561, 517 | ||
| 1 | 0.0 | Work 2 | I | 0 | 691, 97 | ||
| 1 | 0.0 | TEMP6 | I | 0 | 501, 157 | ||
| 1 | 0.0 | Work 1 | I | 0 | 611, 97 | ||
| 1 | 0.0 | DEBTOR_MAST | DM_MARKET | I | 0 | 231, 61 | $DEFAULT A:ORG |
| 1 | 0.0 | PALL_TYPE | PTP_TYPE | I | 0 | 311, 481 | |
| 1 | 0.0 | PALL_TYPE | PTP_DESC | I | 0 | 341, 481 | |
| 1 | 0.0 | Work 2 | I | 0 | 481, 109 | ||
| 1 | 0.0 | Work 1 | I | 0 | 441, 109 | ||
| 1 | 0.0 | Work 4 | I | 0 | 651, 109 | ||
| 1 | 0.0 | Work 3 | I | 0 | 591, 109 | ||
| 1 | 0.0 | Work 1 | I | 0 | 351, 109 | ||
| 1 | 0.0 | Work 7 | I | 0 | 661, 517 | ||
| 1 | 0.0 | Work 6 | I | 0 | 661, 493 | ||
| 1 | 0.0 | Work 2 | I | 0 | 681, 157 | ||
| 1 | 0.0 | Work 1 | I | 0 | 681, 193 | ||
| 1 | 0.0 | Work 3 | I | 0 | 731, 97 | ||
| 1 | 0.0 | Work 2 | I | 0 | 691, 121 | ||
| 1 | 0.0 | Work 1 | I | 0 | 691, 145 | ||
| 1 | 0.0 | STK_DETS | SD_CSQTY | I | 0 | 311, 521 | |
| 1 | 0.0 | STK_DETS | SD_RRQTY | I | 0 | 371, 521 | |
| 1 | 0.0 | Work 4 | I | 0 | 411, 109 | ||
| 1 | 0.0 | DEBTOR_MAST | DM_DEBTOR | I | -1 | 111, 133 | $SELECT S:DEBTOR;I\FROM_BUYER 'CHANGE TEXT CASE TO UPPER CASE AND SET THIS FIELD MANDATORY $CALCULATE A:CONST;;T\PROGRESS,I\DM_ACTIVE A:CONST;;I\DM_VATNO,I\MESSAGE,I\TOTAL,I\CRED,I\DM_GROUP,T\DM_GROUP1,T\DM_NAME,I\MESSAGE A:CONST;;I\DM_VATNO,I\MESSAGE,G\GRID,I\TOTAL,I\CRED,I\DM_GROUP,T\DM_GROUP1,T\DM_NAME,W |
| 1 | 0.0 | STK_DETS | SD_ADJQTY | I | 0 | 341, 521 | |
| 1 | 0.0 | STK_DETS | SD_RETQTY | I | 0 | 411, 529 | |
| 1 | 0.0 | Work 2 | I | 0 | 601, 217 | ||
| 1 | 0.0 | Work 1 | I | 0 | 141, 61 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'LOAD MARKET NAME 'F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CHK_CREDIT=CM_RESV_CRLCHK,I\CM_ROUND=CM_ROUND,I\CM_VATNO=CM_VATNO,I\CM_DKT_COMMENT=CM_DKT_COMMENT F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_RESV_DEBTOR_UPD=CM_RESV_DEBTOR_UPD,I\CHK_CREDIT=CM_RESV_DEBTOR_ |
|
| 1 | 0.0 | Label 3 | T | -1 | 731, 253 | ||
| 1 | 0.0 | Work 4 | I | -1 | 111, 109 | 'RETRIVING AGENT NAME $DEFAULT A:ORGS;I\AGENT F:AGENT_MAST;;AM_CODE;T\AGENT1=AM_NAME,I\NOREM_PRINT=AM_NOREM_PRN,I\NOINV_PRINT=AM_NOINV_PRN,I\AM_VATREG=AM_VATREG;AM_CODE='$I\AGENT$' A:USERIP;;I\IP F:IP_MAST;;;I\PORT=IM_PORT;IM_IP='$I\IP$' A:VAR;I\AGENT;I\ORGS I:I\AGENT;=; DO(AGN) O:ENABLEINPUT;I\A |
|
| 1 | 0.0 | STK_DETS | SD_COUNT | I | 0 | 111, 521 | |
| 1 | 0.0 | Label 3 | T | -1 | 211, 109 | ||
| 1 | 0.0 | STK_DETS | SD_PROV | I | 0 | 11, 517 | |
| 1 | 0.0 | STK_DETS | SD_CONTMASS | I | 0 | 181, 521 | |
| 1 | 0.0 | DEBTOR_MAST | DM_DEBTOR | T | -1 | 1, 133 | |
| 1 | 0.0 | Work 8 | I | -1 | 31, 277 | ||
| 1 | 0.0 | TEMP1 | I | 0 | 331, 133 | ||
| 1 | 0.0 | STK_DETS | SD_CONT | I | 0 | 41, 521 | |
| 1 | 0.0 | Work 1 | I | 0 | 581, 97 | ||
| 1 | 0.0 | STK_DETS | SD_SIZE | I | 0 | 71, 521 | |
| 1 | 0.0 | STK_DETS | SD_CONSIGN | I | 0 | 211, 517 | |
| 1 | 0.0 | STK_DETS | SD_ITEM | I | 0 | 151, 521 | |
| 1 | 0.0 | STK_DETS | SD_CLASS | I | 0 | 91, 521 | |
| 1 | 0.0 | STK_DETS | SD_RECQTY | I | 0 | 491, 517 | |
| 1 | 0.0 | STK_DETS | SD_SLDQTY | I | 0 | 461, 517 | |
| 1 | 0.0 | STK_DETS | SD_DISQTY | I | 0 | 431, 517 | |
| 1 | 0.0 | Work 53 | G | -1 | 1, 301 | '$GRID_VALIDATE COMMENTED ON JANET'S REQUEST ON 14082009 '$GRID_VALIDATE 'U:RESERVATION_GRID_PRETORIA;VALIDATE_PRICE;G\GRID,I\DM_DEBTOR,I\MARKET,I\AGENT 'U:ZZGRID_SPLIT;GRID_SUM;G\GRID;I\VALUE,I\TOTAL 'U:ZZGRID_SPLIT;GRID_SUM;G\GRID;I\VAT,I\TOTALVALUEVAT 'U:BUYER_RESERVATION_GRID_PRETORIA;TOTAL_VALUES |
|
| 1 | 0.0 | Work 1 | I | 0 | 571, 217 | ||
| 1 | 0.0 | Work 1 | I | 0 | 651, 157 | ||
| 1 | 0.0 | Work 2 | I | 0 | 651, 193 | ||
| 1 | 0.0 | TMP1 | I | 0 | 221, 553 | ||
| 1 | 0.0 | Work 52 | I | -1 | 0, 472 | ||
| 1 | 0.0 | Work 51 | I | -1 | 621, 277 | ||
| 1 | 0.0 | Work 50 | I | -1 | 561, 277 | ||
| 1 | 0.0 | Work 20 | I | -1 | 471, 277 | '$CALCULATE 'U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\LINE 'O:SETFOCUS;I\LINE 'A:CONST;;I\LINE,I\ST_DOCNO,I\CON,I\COMM,I\AQTY,I\QTY,I\PRICE,I\VAT,I\VALUE '$ESC 'O:SETFOCUS;I\QTY '$CALCULATE 'A:CONST;;I\ACPT_PRICE 'GET SUPPLIER CODE 'F:AGENT_MAST;;;I\TMP=AM_DEL_LEN;AM_CODE='$I\AGENT$' 'A:LEFT;I\C |
|
| 1 | 0.0 | Work 11 | I | -1 | 391, 277 | ''$VALIDATE ''O:SETFOCUS;I\PRICE ''I:I\ST_DOCNO;=; ''DO(002) ''I:I\ST_ORIG_PRICE;<>;I\PRICE ''D:YOU NOT ALLOWED TO CHANGE PALLET PRICE;I\PRICE ''DOEND(002) ''I:I\ST_DOCNO;=; ''DO(002) ''U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\LINE ''O:DISABLEINPUT;I\PRICE ''O:SETFOCUS;I\LINE ''A:CONST;;I\LINE,I\ST_ |
|
| 1 | 0.0 | Work 10 | I | -1 | 131, 277 | ||
| 1 | 0.0 | Label 46 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 14 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 16 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 9 | T | -1 | 231, 49 | ||
| 1 | 0.0 | H | -1 | 1, 121 | |||
| 1 | 0.0 | Label 17 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 1 | T | -1 | 1, 109 | ||
| 1 | 0.0 | CMD 47 | C | -1 | 211, 133 | 'SELECTING BUYER NUMBER FROM DEBTOR_MAST TABLE FOR F5 FUNCTION $SELECT S:BUYER_NUMBER;I\DM_DEBTOR |
|
| 1 | 0.0 | Label 6 | T | 0 | 421, 493 | ||
| 1 | 0.0 | Label 5 | T | -1 | 511, 469 | ||
| 1 | 0.0 | Label 4 | T | -1 | 1, 448 | ||
| 1 | 0.0 | Work 54 | I | -1 | 641, 469 | ||
| 1 | 0.0 | Label 2 | T | -1 | 251, 133 | ||
| 1 | 0.0 | Work 55 | I | 0 | 551, 495 | ||
| 1 | 0.0 | Label 8 | T | -1 | 131, 253 | ||
| 1 | 0.0 | Label 9 | T | -1 | 221, 253 | ||
| 1 | 0.0 | Label 12 | T | -1 | 391, 253 | ||
| 1 | 0.0 | Label 13 | T | -1 | 471, 253 | ||
| 1 | 0.0 | Label 14 | T | -1 | 561, 253 | ||
| 1 | 0.0 | Label 15 | T | -1 | 621, 253 | ||
| 1 | 0.0 | Work 25 | I | -1 | 221, 277 | ||
| 1 | 0.0 | Work 2 | I | 0 | 191, 61 | $DEFAULT A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME 'A:TIMER_ON;1000 'U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\ST_DOCNO,I\CON,I\COMM,I\AQTY,I\QTY,I\PRICE,I\ST_ORIG_QTY:H,I\ST_ORIG_PRICE:H,I\DELDATE:H,I\VAT,I\VALUE U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\LINE,I\ST_DOCNO,I\CON,I\COMM,I\QTY,I\PRICE,I\ST_ORIG_QTY:H,I\ST_ |
|
| 1 | 0.0 | Label 3 | T | -1 | 31, 253 | ||
| 1 | 0.0 | Work 1 | I | 0 | 621, 517 | ||
| 1 | 0.0 | Work 2 | I | 0 | 761, 301 | ||
| 1 | 0.0 | Work 1 | I | 0 | 771, 301 | ||
| 1 | 0.0 | Label 15 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 8 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Work 1 | I | 0 | 691, 109 | ||
| 1 | 0.0 | Work 2 | I | 0 | 691, 229 | ||
| 1 | 0.0 | Work 1 | I | 0 | 711, 229 | ||
| 1 | 0.0 | Label 2 | T | -1 | 381, 493 | ||
| 1 | 0.0 | Work 1 | I | 0 | 331, 241 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 1, 121 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 121 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 1, 121 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 1, 121 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 1, 121 | $UPDATE A:CONST;;I\FROM_BUYER_CHEP_ACC,I\TO_BUYER_CHEP_ACC,I\FIND_CHEP_SALES,I\MESSAGE I:I\AGENT;=; D:AGENT CODE IS A MANDATORY FIELD;ERRORM;I\AGENT F:AGENT_MAST;Y;;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT I:I\FROM_BUYER;=; D:FROM BUYER IS A MANDATORY FIELD;ERRORM;I\FROM_BUYER F:DEBTOR_MAST;Y;;I\BLOC |