Program drill-down
CSV_COLLECTIONS
CSV COLLECTIONS. Type DSP, base table DEBTOR_MAST.
Field inventory
45
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 1 | I | 0 | 461, 361 | ||
| 1 | 0.0 | Work 1 | I | 0 | 331, 361 | ||
| 1 | 0.0 | USER ID | I | 0 | 81, 73 | $DEFAULT A:USERID;;I\USERID |
|
| 1 | 0.0 | IP | I | 0 | 61, 73 | $DEFAULT A:USERIP;;I\IP |
|
| 1 | 0.0 | ORGS | I | 0 | 41, 73 | $DEFAULT A:ORGS;;I\ORGS |
|
| 1 | 0.0 | MARKET | I | 0 | 21, 73 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE C:MCASE;;T\MARKET I:I\CM_SLAVE;<>;Y O:DISABLEINPUT;C\HOT_BACKUP |
|
| 1 | 0.0 | Work 3 | I | 0 | 71, 337 | ||
| 1 | 0.0 | DEBTOR_CHECK | I | 0 | 400, 487 | ||
| 1 | 0.0 | DEFAULT | I | 0 | 1, 73 | $DEFAULT A:DATE;DD MMM YYYY;T\DATE A:DATE;DD MMM YYYY;I\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;;T\MARKET=CM_NAME,I\CM_SLAVE=CM_SLAVE,I\CM_CLEAR_GRNS=CM_CLEAR_GRNS;CM_CODE='$I\MARKET$'; U:CSV_RUN;READ I:I\RUN;=;N DO(DLA) O:DISABLEINPUT;C\CLR,C\ALL |
|
| 1 | 0.0 | STK_CHECK | I | 0 | 491, 361 | ||
| 1 | 0.0 | Label 2 | T | -1 | 250, 337 | ||
| 1 | 0.0 | Label 3 | T | -1 | 291, 337 | ||
| 1 | 0.0 | Label 1 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 2 | T | -1 | 301, 25 | ||
| 1 | 0.0 | Label 3 | T | -1 | 331, 49 | ||
| 1 | 0.0 | Label 4 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 5 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 6 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 7 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 4 | T | -1 | 251, 337 | ||
| 1 | 0.0 | Label 1 | T | -1 | 331, 337 | ||
| 1 | 0.0 | Label 2 | T | -1 | 251, 361 | ||
| 1 | 0.0 | Work 5 | I | 0 | 121, 97 | ||
| 1 | 0.0 | Work 4 | I | 0 | 121, 73 | ||
| 1 | 0.0 | Work 4 | I | 0 | 71, 373 | ||
| 1 | 0.0 | Work 1 | I | 0 | 411, 361 | ||
| 1 | 0.0 | TMP1 | I | 0 | 551, 517 | ||
| 1 | 0.0 | APAC | I | 0 | 1, 97 | ||
| 1 | 0.0 | Work 1 | I | 0 | 371, 361 | ||
| 1 | 0.0 | CMD 1 | C | -1 | 291, 301 | $SELECT '''CHECK IN THE ZV_USER_DEFAULTS FOR REPLICATION ERROR LP 20130115 ON JANET'S REQUEST TOGETHER WITH CHRISTO F:ZV_USER_DEFAULTS;;;I\TMP1=ZV_TEXT;ZV_CODE = 'HOT_BACKUP_ERROR' I:I\TMP1;=;Y D:YOU CANNOT CARRY ON - PROBLEM ON REPLICATION;ERRORM;C\ALL I:I\TMP1;<>;Y DO(RUN) '******* 'BACKUP* '******* |
|
| 1 | 0.0 | Work 1 | I | 0 | 31, 409 | ||
| 1 | 0.0 | Work 1 | I | 0 | 21, 97 | ||
| 1 | 0.0 | CMD 8 | C | 0 | 71, 265 | $SELECT A:CONST;Y;I\CLICKED 'THIS WILL PREVENT THE CSV FROM BEING RUN TWICE O:DISABLEINPUT;C\GO U:CSV_RUN;CHK_CASHIER_BALS I:I\UPD_SLS;=;Y D:CASHIER BALANCING MUST BE RUN FIRST;ERRORM;C\GO A:CONST;;I\UPD_SLS U:CSV_RUN;CHK_UNPAID I:I\UPD_SLS;=;Y D:UNPAID SALES HAVE NOT BEEN CLEARED;ERRORM;C\GO I:I\CLI |
|
| 1 | 0.0 | CMD 1 | C | -1 | 291, 157 | $SELECT 'CALL LAZ'S PROGRAM E:$GBLROOT$LEGEND\PROJ_FMS\BIN\MAINMENU.EXE P CLEAR_UNPAID_SALES $I\MARKET$ I:I\CM_SLAVE;=;Y DO(01) O:ENABLEINPUT;C\HOT_BACKUP O:SETFOCUS;C\HOT_BACKUP O:BACKCOLOR;C\HOT_BACKUP;YELLOW DOEND(01) I:I\CM_SLAVE;<>;Y DO(02) O:DISABLEINPUT;C\HOT_BACKUP O:ENABLEINPUT;C\BACKU |
|
| 1 | 0.0 | CMD 1 | C | 0 | 71, 301 | $SELECT O:HIDE;T\CSVC,T\CSVS A:CONST;FTP STARTED...;T\FTPS U:FTP_UPLOAD;UPLOAD O:HIDE;T\FTPS A:CONST;FTP COMPLETE;T\FTPC |
|
| 1 | 0.0 | CMD 2 | C | -1 | 291, 265 | $SELECT ''U:DATABASE_OPTIMIZATION;OPTIMIZE O:ENABLEINPUT;C\ALL O:SETFOCUS;C\ALL O:BACKCOLOR;C\ALL;YELLOW |
|
| 1 | 0.0 | CMD 2 | C | -1 | 291, 193 | $SELECT I:I\CM_SLAVE;=;Y E:$GBLROOT$LEGEND\PROJ_FMS\BIN\MAINMENU.EXE P HOT_BACKUP_DB $I\MARKET$ O:SETFOCUS;C\BACKUP O:BACKCOLOR;C\BACKUP;YELLOW |
|
| 1 | 0.0 | CMD 1 | C | -1 | 291, 229 | $SELECT '''CHECK IN THE ZV_USER_DEFAULTS FOR REPLICATION ERROR LP 20130115 ON JANET'S REQUEST TOGETHER WITH CHRISTO F:ZV_USER_DEFAULTS;;;I\TMP1=ZV_TEXT;ZV_CODE = 'HOT_BACKUP_ERROR' I:I\TMP1;=;Y D:YOU CANNOT CARRY ON - PROBLEM ON REPLICATION;ERRORM;C\BACKUP I:I\TMP1;<>;Y DO(RUN) A:CONST;MYSQL BACKUPS STA |
|
| 1 | 0.0 | Work 1 | I | 0 | 231, 73 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 0, 0 |