Freshmark replication server

freshmark-canonical

Program drill-down

EXPORT_BUYERS_INV

EXPORT BUYERS INVOICE SETUP. Type MDL, base table EXPORT_INVOICE.

Field inventory

27

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 Label 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 291, 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 MARKET I 0 1, 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    'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1
1 0.0 Label 9 T -1 261, 145
  
1 0.0 CMD 10 C -1 491, 145
$SELECT  S:EXPORT_DEBTOR;I\BUYER
1 0.0 EXPORT_INVOICE EI_DEBTOR I -1 391, 145
$SELECT  S:EXPORT_DEBTOR;I\EI_DEBTOR    $CALCULATE  M:  F:DEBTOR_MAST;Y;;T\NAME=DM_NAME;DM_MARKET='$I\MARKET$' AND DM_DEBTOR='$I\EI_DEBTOR$' AND DM_EXPORT_IND='Y';I\EI_DEBTOR  U:ZZGRID_SPLIT;DB_TO_GRID;G\GRID;EXPORT_INVOICE,EI_DEBTOR='$I\EI_DEBTOR$' ORDER BY EI_PRODUCT    'U:EXPORT_BUYERS;CHECK_TRANS  'I:I\TMP1;=;N  'D
1 0.0 Label 12 T -1 531, 145
  
1 0.0 Label 14 T -1 271, 505
  
1 0.0 Work 15 I 0 391, 109
  
1 0.0 EXPORT_INVOICE EI_PROD I -1 391, 181
$VALIDATE  I:I\EI_PROD;<>;  F:PRODUCT_MAST;Y;;;PR_PRODUCT='$I\EI_PROD$';I\EI_PROD  U:ZZGRID_SPLIT;DB_TO_GRID;G\GRID;EXPORT_INVOICE,EI_DEBTOR='$I\EI_DEBTOR$' AND EI_PROD='$I\EI_PROD$' ORDER BY EI_VARIETY
1 0.0 EXPORT_INVOICE EI_VARIETY I -1 391, 217
$SELECT  S:VARIETY;I\EI_VARIETY;I\EI_PROD    $VALIDATE  M:  C:UCASE  I:I\EI_PROD;=;  DO(1)  I:I\EI_VARIETY;<>;  D:ENTER PRODUCT;ERRORM;I\EI_PROD  DOEND(1)    I:I\EI_VARIETY;<>;  DO(2)  I:I\EI_PROD;<>;  F:VAR_MAST;Y;;;VA_PRODUCT='$I\EI_PROD$' AND VA_VARIETY ='$I\EI_VARIETY$';I\VARIETY  'I:W\VARIETY;=;  'D:VARIETY '$I\VA
1 0.0 Label 3 T -1 261, 181
  
1 0.0 Label 4 T -1 261, 217
  
1 0.0 CMD 5 C -1 491, 181
$SELECT  S:PRODUCT;I\PR_PRODUCT
1 0.0 Work 1 G -1 261, 253
  
1 0.0 CMD 6 C -1 491, 217
$SELECT  S:VARIETY;I\VA_VARIETY;I\VA_PRODUCT
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