echo Begin of Upgrade 7.0.380
echo Title: FRSP_ORDLABELS
BRING << \EOF
17 14 FRSP_ORDLABELS22 חוקל תונמזה תקבדמ תקפה0 80 0 0 0 0 3 LOG0 0 
57 10 יטרפ חותיפ1 
58 1 14 FRSP_ORDLABELS80 
7 14 FRSP_ORDLABELS80 10 6 INPUTF66 
18 9 LABELSDEF0 
56 9 LABELSDEF12 תוקבדמ תרדגה0 
19 9 LABELSDEF1 9 LABELNAME4 CHAR10 10 8 הקבדמ םש
19 9 LABELSDEF2 8 LABELDES5 RCHAR32 32 10 הקבדמ רואת
19 9 LABELSDEF3 9 LABELPATH4 CHAR64 64 13 הקבדמ ץבוק םש
19 9 LABELSDEF4 8 LABELDEF3 INT13 4 15 (ID)הקבדמ תרדגה
33 9 LABELSDEF8 LABELDEF0 48 
20 9 LABELSDEF65 1 
21 9 LABELSDEF1 8 LABELDEF1 
20 9 LABELSDEF85 2 
21 9 LABELSDEF2 9 LABELNAME1 
9 14 FRSP_ORDLABELS80 10 3 LAB0 0 4 FILE0 0 73 9 LABELSDEF9 LABELNAME
18 6 ORDERS1 
56 6 ORDERS11 חוקל תונמזה0 
19 6 ORDERS1 3 ORD3 INT13 4 10 (ID) הנמזה
19 6 ORDERS2 4 CUST3 INT13 4 9 (ID) חוקל
19 6 ORDERS3 7 ORDNAME4 CHAR16 16 5 הנמזה
19 6 ORDERS4 7 CURDATE4 DATE8 4 5 ךיראת
19 6 ORDERS5 9 REFERENCE4 CHAR15 15 14 (חוקל) שכר .זה
19 6 ORDERS6 4 USER3 INT13 4 10 (ID) שמתשמ
19 6 ORDERS7 5 WARHS3 INT13 4 9 (ID) ןסחמ
19 6 ORDERS8 6 QPRICE4 REAL16 8 9 ללוכ ריחמ
33 6 ORDERS6 QPRICE2 50 
19 6 ORDERS9 3 VAT4 REAL16 8 4 מ"עמ
33 6 ORDERS3 VAT2 50 
19 6 ORDERS10 8 TOTPRICE4 REAL16 8 14 מ"עמ ללוכ ריחמ
33 6 ORDERS8 TOTPRICE2 50 
19 6 ORDERS11 8 CURRENCY3 INT13 4 9 (ID) עבטמ
19 6 ORDERS12 4 PROF3 INT13 4 14 (ID) ריחמ תעצה
19 6 ORDERS13 6 CLOSED4 CHAR1 1 7 C הרוגס
19 6 ORDERS14 4 PROJ3 INT13 4 11 (ID) טקיורפ
33 6 ORDERS4 PROJ0 48 
19 6 ORDERS15 5 UDATE4 DATE14 4 8 המיתח .ת
19 6 ORDERS16 7 PERCENT4 REAL8 8 14 (%) תיללכ החנה
33 6 ORDERS7 PERCENT2 50 
19 6 ORDERS17 8 DISPRICE4 REAL16 8 14 החנה ירחא ריחמ
33 6 ORDERS8 DISPRICE2 50 
19 6 ORDERS18 3 PAY3 INT13 4 10 (ID) םולשת
33 6 ORDERS3 PAY0 48 
19 6 ORDERS19 8 SHIPTYPE3 INT13 4 16 (ID) חולשמ סופיט
33 6 ORDERS8 SHIPTYPE0 48 
19 6 ORDERS20 5 AGENT3 INT13 4 9 (ID) ןכוס
33 6 ORDERS5 AGENT0 48 
19 6 ORDERS21 4 DEAL3 INT13 4 16 (ID) תרגסמ תנמזה
33 6 ORDERS4 DEAL0 48 
19 6 ORDERS22 8 DESTCODE3 INT13 4 8 (ID) רתא
33 6 ORDERS8 DESTCODE0 48 
19 6 ORDERS23 4 TYPE4 CHAR1 1 10 ?יאלמל םאה
19 6 ORDERS24 12 FORECASTFLAG4 CHAR1 1 16 יאלמ/תיזחת תנמזה
19 6 ORDERS25 9 LCURRENCY3 INT13 4 15 (ID) הדמצה עבטמ
33 6 ORDERS9 LCURRENCY0 48 
19 6 ORDERS26 9 LEXCHANGE4 REAL17 8 8 סיסב רעש
33 6 ORDERS9 LEXCHANGE9 57 
19 6 ORDERS27 6 ADVBAL4 REAL16 8 5 המדקמ
33 6 ORDERS6 ADVBAL2 50 
19 6 ORDERS28 10 ADVPERCENT4 REAL6 8 19 .שחהמ המדקמ זוזיק %
33 6 ORDERS10 ADVPERCENT2 50 
19 6 ORDERS29 7 PCLOSED4 CHAR1 1 11 תיקלח הרוגס
19 6 ORDERS30 7 BOOKNUM4 CHAR16 16 8 סקנפ .זה
19 6 ORDERS31 6 BRANCH3 INT13 4 9 (ID) ףינס
33 6 ORDERS6 BRANCH0 48 
19 6 ORDERS32 12 ADJPRICEFLAG4 CHAR1 1 11 ךורעש/הדמצה
19 6 ORDERS33 7 DETAILS5 RCHAR24 24 5 םיטרפ
19 6 ORDERS34 7 ORDTYPE3 INT13 4 14 (ID) הריכמ גוס
33 6 ORDERS7 ORDTYPE0 48 
19 6 ORDERS35 5 PHONE3 INT13 4 12 (ID) רשק שיא
33 6 ORDERS5 PHONE0 48 
19 6 ORDERS36 5 PLIST3 INT13 4 11 (ID) ןוריחמ
33 6 ORDERS5 PLIST0 48 
19 6 ORDERS37 7 QPROFIT4 REAL16 8 10 לעופב חוור
33 6 ORDERS7 QPROFIT2 50 
19 6 ORDERS38 4 CASH3 INT13 4 15 (ID) הדקפה זכרמ
33 6 ORDERS4 CASH0 48 
19 6 ORDERS39 4 DOER3 INT13 4 9 (ID) עצבמ
33 6 ORDERS4 DOER0 48 
19 6 ORDERS40 9 ORDSTATUS3 INT13 4 16 (ID) הנמזה סוטטס
33 6 ORDERS9 ORDSTATUS0 48 
19 6 ORDERS41 12 MGIC_SHIPPER3 INT13 8 19 (ID) פס/עת/הלבוה.ח.
33 6 ORDERS12 MGIC_SHIPPER0 48 
19 6 ORDERS42 12 MGIC_PAYDATE4 DATE8 8 18 רעושמ ןוערפ ךיראת.
19 6 ORDERS43 14 MGIC_CONTAINER3 INT13 8 11 (ID) הלוכמ.
33 6 ORDERS14 MGIC_CONTAINER0 48 
19 6 ORDERS44 12 EWIM_SHIPPER3 INT13 8 18 (ID)פס/עת/הלבוה.ח.
33 6 ORDERS12 EWIM_SHIPPER0 48 
19 6 ORDERS45 11 SIL_ENDCUST3 INT13 8 20 קיליס-(ID) יפוס חוקל
33 6 ORDERS11 SIL_ENDCUST0 48 
19 6 ORDERS46 9 CPCP_PORD3 INT13 8 19 (ID) CPC שכר תנמזה.
33 6 ORDERS9 CPCP_PORD0 48 
19 6 ORDERS47 10 EWIM_AGENT3 INT13 8 16 (ID) הנמזהב ןכוס
33 6 ORDERS10 EWIM_AGENT0 48 
19 6 ORDERS48 10 EWIM_IVDOC3 INT13 8 16 ID חולשמ/ןח רפסמ
33 6 ORDERS10 EWIM_IVDOC0 48 
19 6 ORDERS49 15 EXTR_WHITELABEL4 CHAR1 1 11 white label
19 6 ORDERS50 12 SILC_COLLNUM4 CHAR30 30 12 Collect Numn
19 6 ORDERS51 14 SILC_PAERTYCOL4 CHAR30 30 14 Paerty Collect
19 6 ORDERS52 12 SILI_IMPTERM3 INT13 8 15 (ID)  אובי יאנת
33 6 ORDERS12 SILI_IMPTERM0 48 
19 6 ORDERS53 13 FPEA_COMPILER3 INT13 8 10 (ID) טקלמ.
33 6 ORDERS13 FPEA_COMPILER0 48 
19 6 ORDERS54 12 FPEA_UNIFLAG4 CHAR1 1 13 ףיילינוי קשממ
19 6 ORDERS55 12 FPEA_PEAFLAG4 CHAR1 1 13 תימעפ דח קשממ
19 6 ORDERS56 14 FEWI_NUMOFCART3 INT2 8 13 םינוטרק רפסמ.
33 6 ORDERS14 FEWI_NUMOFCART0 48 
20 6 ORDERS65 1 
21 6 ORDERS1 3 ORD1 
20 6 ORDERS85 2 
21 6 ORDERS2 7 ORDNAME1 
20 6 ORDERS78 3 
21 6 ORDERS3 4 CUST1 
21 6 ORDERS3 6 CLOSED2 
20 6 ORDERS78 4 
21 6 ORDERS4 7 CURDATE1 
20 6 ORDERS78 5 
21 6 ORDERS5 5 AGENT1 
20 6 ORDERS78 6 
21 6 ORDERS6 4 CUST2 
21 6 ORDERS6 9 REFERENCE1 
20 6 ORDERS78 7 
21 6 ORDERS7 4 PROF1 
20 6 ORDERS78 8 
21 6 ORDERS8 7 BOOKNUM1 
20 6 ORDERS78 9 
21 6 ORDERS9 6 BRANCH1 
9 14 FRSP_ORDLABELS80 10 3 PAR0 0 4 FILE0 0 73 6 ORDERS7 ORDNAME
7 14 FRSP_ORDLABELS80 20 4 SQLI67 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/1 2 
28 14 FRSP_ORDLABELS80 20 42 GOSUB 1000;   /*   Delete From Labels   */2 3 
28 14 FRSP_ORDLABELS80 20 42 GOSUB 1001;   /* Insert Value To Labels */3 4 
28 14 FRSP_ORDLABELS80 20 42 GOSUB 1002;   /*      Print Labels      */4 5 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/5 6 
28 14 FRSP_ORDLABELS80 20 9 SUB 1000;6 7 
28 14 FRSP_ORDLABELS80 20 42 DELETE FROM LABELS WHERE  USER = SQL.USER;7 8 
28 14 FRSP_ORDLABELS80 20 7 RETURN;8 9 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/9 10 
28 14 FRSP_ORDLABELS80 20 9 SUB 1001;10 11 
28 14 FRSP_ORDLABELS80 20 15 :B_LABELDEF = 011 12 
28 14 FRSP_ORDLABELS80 20 1 ;12 13 
28 14 FRSP_ORDLABELS80 20 22 LINK ORDERS TO :$.PAR;13 14 
28 14 FRSP_ORDLABELS80 20 27 ERRMSG 1 WHERE :RETVAL <=0;14 15 
28 14 FRSP_ORDLABELS80 20 25 LINK LABELSDEF TO :$.LAB;15 16 
28 14 FRSP_ORDLABELS80 20 26 ERRMSG 1 WHERE :RETVAL <=016 17 
28 14 FRSP_ORDLABELS80 20 1 ;17 18 
28 14 FRSP_ORDLABELS80 20 9 :CNT = 0;18 19 
28 14 FRSP_ORDLABELS80 20 30 SELECT COUNT(*), MAX(LABELDEF)19 20 
28 14 FRSP_ORDLABELS80 20 22 INTO :CNT, :B_LABELDEF20 21 
28 14 FRSP_ORDLABELS80 20 15 FROM  LABELSDEF21 22 
28 14 FRSP_ORDLABELS80 20 19 WHERE LABELDEF <> 022 23 
28 14 FRSP_ORDLABELS80 20 1 ;23 24 
28 14 FRSP_ORDLABELS80 20 17 UNLINK LABELSDEF;24 25 
28 14 FRSP_ORDLABELS80 20 24 ERRMSG 2 WHERE :CNT <> 125 26 
28 14 FRSP_ORDLABELS80 20 1 ;26 27 
28 14 FRSP_ORDLABELS80 20 12 :T_LINE = 1;27 28 
28 14 FRSP_ORDLABELS80 20 20 DECLARE X CURSOR FOR28 29 
28 14 FRSP_ORDLABELS80 20 60 SELECT ORDERS.ORDNAME,(N.CUSTDES='' ? C.CUSTDES : N.CUSTDES)29 30 
28 14 FRSP_ORDLABELS80 20 35 FROM ORDERS, NSCUST N?, CUSTOMERS C30 31 
28 14 FRSP_ORDLABELS80 20 21 WHERE ORDERS.ORD <> 031 32 
28 14 FRSP_ORDLABELS80 20 24 AND ORDERS.CUST = C.CUST32 33 
28 14 FRSP_ORDLABELS80 20 21 AND ORDERS.ORD = N.IV33 34 
28 14 FRSP_ORDLABELS80 20 16 AND N.TYPE = 'O'34 35 
28 14 FRSP_ORDLABELS80 20 10 ORDER BY 135 36 
28 14 FRSP_ORDLABELS80 20 1 ;36 37 
28 14 FRSP_ORDLABELS80 20 7 OPEN X;37 38 
28 14 FRSP_ORDLABELS80 20 29 GOTO 801 WHERE :RETVAL <= 0 ;38 39 
28 14 FRSP_ORDLABELS80 20 10 LABEL 901;39 40 
28 14 FRSP_ORDLABELS80 20 36 FETCH X INTO :X_ORDNAME, :X_CUSTDES;40 41 
28 14 FRSP_ORDLABELS80 20 27 GOTO 701 WHERE :RETVAL <= 041 42 
28 14 FRSP_ORDLABELS80 20 1 ;42 43 
28 14 FRSP_ORDLABELS80 20 68 INSERT INTO LABELS(KLINE, SORT, USER, LABELQUANT,LABELDEF,PAR1,PAR2)43 44 
28 14 FRSP_ORDLABELS80 20 48 VALUES(:T_LINE, :T_LINE, SQL.USER,1,:B_LABELDEF,44 45 
28 14 FRSP_ORDLABELS80 20 12 :X_CUSTDES);45 47 
28 14 FRSP_ORDLABELS80 20 22 :T_LINE = :T_LINE + 1;46 48 
28 14 FRSP_ORDLABELS80 20 9 LOOP 901;47 49 
28 14 FRSP_ORDLABELS80 20 10 LABEL 701;48 50 
28 14 FRSP_ORDLABELS80 20 8 CLOSE X;49 51 
28 14 FRSP_ORDLABELS80 20 10 LABEL 801;50 52 
28 14 FRSP_ORDLABELS80 20 14 UNLINK ORDERS;51 53 
28 14 FRSP_ORDLABELS80 20 7 RETURN;52 54 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/53 55 
28 14 FRSP_ORDLABELS80 20 9 SUB 1002;54 56 
28 14 FRSP_ORDLABELS80 20 30 EXECUTE WINPROC '-P','LABELS';55 57 
28 14 FRSP_ORDLABELS80 20 7 RETURN;56 58 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/57 59 
28 14 FRSP_ORDLABELS80 20 29 #INCLUDE func/FSPS_getEnvVars58 1 
28 14 FRSP_ORDLABELS80 20 33 STRCAT(:O_ENVNUM,'O',:X_ORDNAME),59 46 
2 14 FRSP_ORDLABELS80 1 34 .תכרעמה להנמל הנפ אנ .תימינפ האיגש
2 14 FRSP_ORDLABELS80 2 20 תדדוב הקבדמ רוחבל אנ
1007 14 FRSP_ORDLABELS80 20 4 SQLI67 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/1 2 
28 14 FRSP_ORDLABELS80 20 42 GOSUB 1000;   /*   Delete From Labels   */2 3 
28 14 FRSP_ORDLABELS80 20 42 GOSUB 1001;   /* Insert Value To Labels */3 4 
28 14 FRSP_ORDLABELS80 20 42 GOSUB 1002;   /*      Print Labels      */4 5 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/5 6 
28 14 FRSP_ORDLABELS80 20 9 SUB 1000;6 7 
28 14 FRSP_ORDLABELS80 20 42 DELETE FROM LABELS WHERE  USER = SQL.USER;7 8 
28 14 FRSP_ORDLABELS80 20 7 RETURN;8 9 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/9 10 
28 14 FRSP_ORDLABELS80 20 9 SUB 1001;10 11 
28 14 FRSP_ORDLABELS80 20 15 :B_LABELDEF = 011 12 
28 14 FRSP_ORDLABELS80 20 1 ;12 13 
28 14 FRSP_ORDLABELS80 20 22 LINK ORDERS TO :$.PAR;13 14 
28 14 FRSP_ORDLABELS80 20 27 ERRMSG 1 WHERE :RETVAL <=0;14 15 
28 14 FRSP_ORDLABELS80 20 25 LINK LABELSDEF TO :$.LAB;15 16 
28 14 FRSP_ORDLABELS80 20 26 ERRMSG 1 WHERE :RETVAL <=016 17 
28 14 FRSP_ORDLABELS80 20 1 ;17 18 
28 14 FRSP_ORDLABELS80 20 9 :CNT = 0;18 19 
28 14 FRSP_ORDLABELS80 20 30 SELECT COUNT(*), MAX(LABELDEF)19 20 
28 14 FRSP_ORDLABELS80 20 22 INTO :CNT, :B_LABELDEF20 21 
28 14 FRSP_ORDLABELS80 20 15 FROM  LABELSDEF21 22 
28 14 FRSP_ORDLABELS80 20 19 WHERE LABELDEF <> 022 23 
28 14 FRSP_ORDLABELS80 20 1 ;23 24 
28 14 FRSP_ORDLABELS80 20 17 UNLINK LABELSDEF;24 25 
28 14 FRSP_ORDLABELS80 20 24 ERRMSG 2 WHERE :CNT <> 125 26 
28 14 FRSP_ORDLABELS80 20 1 ;26 27 
28 14 FRSP_ORDLABELS80 20 12 :T_LINE = 1;27 28 
28 14 FRSP_ORDLABELS80 20 20 DECLARE X CURSOR FOR28 29 
28 14 FRSP_ORDLABELS80 20 60 SELECT ORDERS.ORDNAME,(N.CUSTDES='' ? C.CUSTDES : N.CUSTDES)29 30 
28 14 FRSP_ORDLABELS80 20 35 FROM ORDERS, NSCUST N?, CUSTOMERS C30 31 
28 14 FRSP_ORDLABELS80 20 21 WHERE ORDERS.ORD <> 031 32 
28 14 FRSP_ORDLABELS80 20 24 AND ORDERS.CUST = C.CUST32 33 
28 14 FRSP_ORDLABELS80 20 21 AND ORDERS.ORD = N.IV33 34 
28 14 FRSP_ORDLABELS80 20 16 AND N.TYPE = 'O'34 35 
28 14 FRSP_ORDLABELS80 20 10 ORDER BY 135 36 
28 14 FRSP_ORDLABELS80 20 1 ;36 37 
28 14 FRSP_ORDLABELS80 20 7 OPEN X;37 38 
28 14 FRSP_ORDLABELS80 20 29 GOTO 801 WHERE :RETVAL <= 0 ;38 39 
28 14 FRSP_ORDLABELS80 20 10 LABEL 901;39 40 
28 14 FRSP_ORDLABELS80 20 36 FETCH X INTO :X_ORDNAME, :X_CUSTDES;40 41 
28 14 FRSP_ORDLABELS80 20 27 GOTO 701 WHERE :RETVAL <= 041 42 
28 14 FRSP_ORDLABELS80 20 1 ;42 43 
28 14 FRSP_ORDLABELS80 20 68 INSERT INTO LABELS(KLINE, SORT, USER, LABELQUANT,LABELDEF,PAR1,PAR2)43 44 
28 14 FRSP_ORDLABELS80 20 48 VALUES(:T_LINE, :T_LINE, SQL.USER,1,:B_LABELDEF,44 45 
28 14 FRSP_ORDLABELS80 20 12 :X_CUSTDES);45 47 
28 14 FRSP_ORDLABELS80 20 22 :T_LINE = :T_LINE + 1;46 48 
28 14 FRSP_ORDLABELS80 20 9 LOOP 901;47 49 
28 14 FRSP_ORDLABELS80 20 10 LABEL 701;48 50 
28 14 FRSP_ORDLABELS80 20 8 CLOSE X;49 51 
28 14 FRSP_ORDLABELS80 20 10 LABEL 801;50 52 
28 14 FRSP_ORDLABELS80 20 14 UNLINK ORDERS;51 53 
28 14 FRSP_ORDLABELS80 20 7 RETURN;52 54 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/53 55 
28 14 FRSP_ORDLABELS80 20 9 SUB 1002;54 56 
28 14 FRSP_ORDLABELS80 20 30 EXECUTE WINPROC '-P','LABELS';55 57 
28 14 FRSP_ORDLABELS80 20 7 RETURN;56 58 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/57 59 
28 14 FRSP_ORDLABELS80 20 29 #INCLUDE func/FSPS_getEnvVars58 1 
28 14 FRSP_ORDLABELS80 20 33 STRCAT(:O_ENVNUM,'O',:X_ORDNAME),59 46 
3 6 ORDERS70 710 14 FRSP_ORDLABELS80 
3 6 ORDERS70 710 14 FRSP_ORDLABELS80 
3 10 CUSTORDERS77 400 14 FRSP_ORDLABELS80 
EOF
echo End of Upgrade 7.0.380
BRING << \EOF
65 3 ORD6 ORDERS2 10 Order (ID)
65 4 CUST6 ORDERS2 13 Customer (ID)
65 7 ORDNAME6 ORDERS2 5 Order
65 7 CURDATE6 ORDERS2 4 Date
65 9 REFERENCE6 ORDERS2 20 Customer's Purch Ord
65 4 USER6 ORDERS2 9 User (ID)
65 5 WARHS6 ORDERS2 14 Warehouse (ID)
65 6 QPRICE6 ORDERS2 16 Price Bef. Disc.
65 3 VAT6 ORDERS2 9 Sales Tax
65 8 TOTPRICE6 ORDERS2 11 Final Price
65 8 CURRENCY6 ORDERS2 13 Currency (ID)
65 4 PROF6 ORDERS2 20 Price Quotation (ID)
65 6 CLOSED6 ORDERS2 10 Closed (C)
65 4 PROJ6 ORDERS2 12 Project (ID)
65 5 UDATE6 ORDERS2 10 Time Stamp
65 7 PERCENT6 ORDERS2 18 % Overall Discount
65 8 DISPRICE6 ORDERS2 20 Price After Discount
65 3 PAY6 ORDERS2 12 Payment (ID)
65 8 SHIPTYPE6 ORDERS2 18 Shipment Type (ID)
65 5 AGENT6 ORDERS2 14 Sales Rep (ID)
65 4 DEAL6 ORDERS2 18 Blanket Order (ID)
65 8 DESTCODE6 ORDERS2 17 Address Code (ID)
65 4 TYPE6 ORDERS2 12 Stock Order?
65 12 FORECASTFLAG6 ORDERS2 20 Forecast/Stock Order
65 9 LCURRENCY6 ORDERS2 16 Linked Curr (ID)
65 9 LEXCHANGE6 ORDERS2 9 Base Rate
65 6 ADVBAL6 ORDERS2 15 Advance Payment
65 10 ADVPERCENT6 ORDERS2 20 % Advance Pay Deduct
65 7 PCLOSED6 ORDERS2 16 Partially Closed
65 7 BOOKNUM6 ORDERS2 19 Sales Rep Order Num
65 6 BRANCH6 ORDERS2 11 Branch (ID)
65 12 ADJPRICEFLAG6 ORDERS2 13 Price Linkage
65 7 DETAILS6 ORDERS2 7 Details
65 7 ORDTYPE6 ORDERS2 17 Type of Sale (ID)
65 5 PHONE6 ORDERS2 12 Contact (ID)
65 9 LABELNAME9 LABELSDEF2 13 Type of Label
65 8 LABELDES9 LABELSDEF2 11 Description
65 9 LABELPATH9 LABELSDEF2 10 Label File
65 8 LABELDEF9 LABELSDEF2 18 Type of Label (ID)
65 5 PLIST6 ORDERS2 15 Price List (ID)
65 7 QPROFIT6 ORDERS2 6 Profit
65 4 CASH6 ORDERS2 20 Bank Account Code-ID
65 4 DOER6 ORDERS2 17 Assigned to: (ID)
65 9 ORDSTATUS6 ORDERS2 17 Order Status (ID)
65 15 EXTR_WHITELABEL6 ORDERS2 11 White Label
64 1 2 20 Internal Development
62 6 ORDERS2 12 Sales Orders
62 9 LABELSDEF2 17 Label Definitions
65 3 ORD6 ORDERS2 10 Order (ID)
65 3 ORD6 ORDERS3 10 Order (ID)
65 3 ORD6 ORDERS4 10 Order (ID)
65 3 ORD6 ORDERS5 10 Orden (ID)
65 3 ORD6 ORDERS6 10 Ordre (ID)
65 3 ORD6 ORDERS8 10 Order (ID)
65 3 ORD6 ORDERS18 10 Order (ID)
65 3 ORD6 ORDERS25 10 Order (ID)
65 3 ORD6 ORDERS31 10 Order (ID)
65 3 ORD6 ORDERS38 10 Order (ID)
65 3 ORD6 ORDERS39 10 Order (ID)
65 3 ORD6 ORDERS41 10 Order (ID)
65 3 ORD6 ORDERS43 10 Order (ID)
65 3 ORD6 ORDERS44 10 Order (ID)
65 4 CUST6 ORDERS2 13 Customer (ID)
65 4 CUST6 ORDERS3 13 Customer (ID)
65 4 CUST6 ORDERS4 13 Customer (ID)
65 4 CUST6 ORDERS5 12 Cliente (ID)
65 4 CUST6 ORDERS6 11 Client (ID)
65 4 CUST6 ORDERS8 13 Customer (ID)
65 4 CUST6 ORDERS18 13 Customer (ID)
65 4 CUST6 ORDERS25 13 Customer (ID)
65 4 CUST6 ORDERS31 13 Customer (ID)
65 4 CUST6 ORDERS38 13 Customer (ID)
65 4 CUST6 ORDERS39 13 Customer (ID)
65 4 CUST6 ORDERS41 13 Customer (ID)
65 4 CUST6 ORDERS43 13 Customer (ID)
65 4 CUST6 ORDERS44 13 Customer (ID)
65 7 ORDNAME6 ORDERS2 5 Order
65 7 ORDNAME6 ORDERS3 5 Order
65 7 ORDNAME6 ORDERS4 5 Order
65 7 ORDNAME6 ORDERS5 5 Orden
65 7 ORDNAME6 ORDERS6 8 Commande
65 7 ORDNAME6 ORDERS8 5 Order
65 7 ORDNAME6 ORDERS18 5 Order
65 7 ORDNAME6 ORDERS25 5 Order
65 7 ORDNAME6 ORDERS31 5 Order
65 7 ORDNAME6 ORDERS38 5 Order
65 7 ORDNAME6 ORDERS39 5 Order
65 7 ORDNAME6 ORDERS41 5 Order
65 7 ORDNAME6 ORDERS43 5 Order
65 7 ORDNAME6 ORDERS44 5 Order
65 7 CURDATE6 ORDERS2 4 Date
65 7 CURDATE6 ORDERS3 4 Date
65 7 CURDATE6 ORDERS4 4 Date
65 7 CURDATE6 ORDERS5 5 Fecha
65 7 CURDATE6 ORDERS6 4 Date
65 7 CURDATE6 ORDERS8 4 Date
65 7 CURDATE6 ORDERS18 4 Date
65 7 CURDATE6 ORDERS25 4 Date
65 7 CURDATE6 ORDERS31 4 Date
65 7 CURDATE6 ORDERS38 4 Date
65 7 CURDATE6 ORDERS39 4 Date
65 7 CURDATE6 ORDERS41 4 Date
65 7 CURDATE6 ORDERS43 4 Date
65 7 CURDATE6 ORDERS44 4 Date
65 9 REFERENCE6 ORDERS2 20 Customer's Purch Ord
65 9 REFERENCE6 ORDERS3 20 Customer's Purch Ord
65 9 REFERENCE6 ORDERS4 20 Customer's Purch Ord
65 9 REFERENCE6 ORDERS5 20 Orden Compra Cliente
65 9 REFERENCE6 ORDERS6 18 Commande Achat Clt
65 9 REFERENCE6 ORDERS8 20 Customer's Purch Ord
65 9 REFERENCE6 ORDERS18 20 Customer's Purch Ord
65 9 REFERENCE6 ORDERS25 20 Customer's Purch Ord
65 9 REFERENCE6 ORDERS31 20 Customer's Purch Ord
65 9 REFERENCE6 ORDERS38 20 Customer's Purch Ord
65 9 REFERENCE6 ORDERS39 20 Customer's Purch Ord
65 9 REFERENCE6 ORDERS41 20 Customer's Purch Ord
65 9 REFERENCE6 ORDERS43 20 Customer's Purch Ord
65 9 REFERENCE6 ORDERS44 20 Customer's Purch Ord
65 4 USER6 ORDERS2 9 User (ID)
65 4 USER6 ORDERS3 9 User (ID)
65 4 USER6 ORDERS4 9 User (ID)
65 4 USER6 ORDERS5 12 Usuario (ID)
65 4 USER6 ORDERS6 16 Utilisateur (ID)
65 4 USER6 ORDERS8 9 User (ID)
65 4 USER6 ORDERS18 9 User (ID)
65 4 USER6 ORDERS25 9 User (ID)
65 4 USER6 ORDERS31 9 User (ID)
65 4 USER6 ORDERS38 9 User (ID)
65 4 USER6 ORDERS39 9 User (ID)
65 4 USER6 ORDERS41 9 User (ID)
65 4 USER6 ORDERS43 9 User (ID)
65 4 USER6 ORDERS44 9 User (ID)
65 5 WARHS6 ORDERS2 14 Warehouse (ID)
65 5 WARHS6 ORDERS3 14 Warehouse (ID)
65 5 WARHS6 ORDERS4 14 Warehouse (ID)
65 5 WARHS6 ORDERS5 12 Almacיn (ID)
65 5 WARHS6 ORDERS6 13 Entrepפt (ID)
65 5 WARHS6 ORDERS8 14 Warehouse (ID)
65 5 WARHS6 ORDERS18 14 Warehouse (ID)
65 5 WARHS6 ORDERS25 14 Warehouse (ID)
65 5 WARHS6 ORDERS31 14 Warehouse (ID)
65 5 WARHS6 ORDERS38 14 Warehouse (ID)
65 5 WARHS6 ORDERS39 14 Warehouse (ID)
65 5 WARHS6 ORDERS41 14 Warehouse (ID)
65 5 WARHS6 ORDERS43 14 Warehouse (ID)
65 5 WARHS6 ORDERS44 14 Warehouse (ID)
65 6 QPRICE6 ORDERS2 16 Price Bef. Disc.
65 6 QPRICE6 ORDERS3 16 Price Bef. Disc.
65 6 QPRICE6 ORDERS4 16 Price Bef. Disc.
65 6 QPRICE6 ORDERS5 20 Precio antes Descuen
65 6 QPRICE6 ORDERS6 17 Prix Avant Remise
65 6 QPRICE6 ORDERS8 16 Price Bef. Disc.
65 6 QPRICE6 ORDERS18 16 Price Bef. Disc.
65 6 QPRICE6 ORDERS25 16 Price Bef. Disc.
65 6 QPRICE6 ORDERS31 16 Price Bef. Disc.
65 6 QPRICE6 ORDERS38 16 Price Bef. Disc.
65 6 QPRICE6 ORDERS39 16 Price Bef. Disc.
65 6 QPRICE6 ORDERS41 16 Price Bef. Disc.
65 6 QPRICE6 ORDERS43 16 Price Bef. Disc.
65 6 QPRICE6 ORDERS44 16 Price Bef. Disc.
65 3 VAT6 ORDERS2 3 VAT
65 3 VAT6 ORDERS3 9 Sales Tax
65 3 VAT6 ORDERS4 3 VAT
65 3 VAT6 ORDERS5 18 Impuesto de Ventas
65 3 VAT6 ORDERS6 3 TVA
65 3 VAT6 ORDERS8 3 VAT
65 3 VAT6 ORDERS18 3 VAT
65 3 VAT6 ORDERS25 3 VAT
65 3 VAT6 ORDERS31 3 VAT
65 3 VAT6 ORDERS38 3 VAT
65 3 VAT6 ORDERS39 3 VAT
65 3 VAT6 ORDERS41 3 VAT
65 3 VAT6 ORDERS43 3 VAT
65 3 VAT6 ORDERS44 3 VAT
65 8 TOTPRICE6 ORDERS2 11 Final Price
65 8 TOTPRICE6 ORDERS3 11 Final Price
65 8 TOTPRICE6 ORDERS4 11 Final Price
65 8 TOTPRICE6 ORDERS5 12 Precio Final
65 8 TOTPRICE6 ORDERS6 10 Prix Final
65 8 TOTPRICE6 ORDERS8 11 Final Price
65 8 TOTPRICE6 ORDERS18 11 Final Price
65 8 TOTPRICE6 ORDERS25 11 Final Price
65 8 TOTPRICE6 ORDERS31 11 Final Price
65 8 TOTPRICE6 ORDERS38 11 Final Price
65 8 TOTPRICE6 ORDERS39 11 Final Price
65 8 TOTPRICE6 ORDERS41 11 Final Price
65 8 TOTPRICE6 ORDERS43 11 Final Price
65 8 TOTPRICE6 ORDERS44 11 Final Price
65 8 CURRENCY6 ORDERS2 13 Currency (ID)
65 8 CURRENCY6 ORDERS3 13 Currency (ID)
65 8 CURRENCY6 ORDERS4 13 Currency (ID)
65 8 CURRENCY6 ORDERS5 11 Moneda (ID)
65 8 CURRENCY6 ORDERS6 11 Devise (ID)
65 8 CURRENCY6 ORDERS8 13 Currency (ID)
65 8 CURRENCY6 ORDERS18 13 Currency (ID)
65 8 CURRENCY6 ORDERS25 13 Currency (ID)
65 8 CURRENCY6 ORDERS31 13 Currency (ID)
65 8 CURRENCY6 ORDERS38 13 Currency (ID)
65 8 CURRENCY6 ORDERS39 13 Currency (ID)
65 8 CURRENCY6 ORDERS41 13 Currency (ID)
65 8 CURRENCY6 ORDERS43 13 Currency (ID)
65 8 CURRENCY6 ORDERS44 13 Currency (ID)
65 4 PROF6 ORDERS2 20 Price Quotation (ID)
65 4 PROF6 ORDERS3 20 Price Quotation (ID)
65 4 PROF6 ORDERS4 20 Price Quotation (ID)
65 4 PROF6 ORDERS5 15 Cotizaciףn (ID)
65 4 PROF6 ORDERS6 15 Devis Prix (ID)
65 4 PROF6 ORDERS8 20 Price Quotation (ID)
65 4 PROF6 ORDERS18 20 Price Quotation (ID)
65 4 PROF6 ORDERS25 20 Price Quotation (ID)
65 4 PROF6 ORDERS31 20 Price Quotation (ID)
65 4 PROF6 ORDERS38 20 Price Quotation (ID)
65 4 PROF6 ORDERS39 20 Price Quotation (ID)
65 4 PROF6 ORDERS41 20 Price Quotation (ID)
65 4 PROF6 ORDERS43 20 Price Quotation (ID)
65 4 PROF6 ORDERS44 20 Price Quotation (ID)
65 6 CLOSED6 ORDERS2 10 Closed (C)
65 6 CLOSED6 ORDERS3 10 Closed (C)
65 6 CLOSED6 ORDERS4 10 Closed (C)
65 6 CLOSED6 ORDERS5 11 Cerrado (C)
65 6 CLOSED6 ORDERS6 13 Cmd Close (C)
65 6 CLOSED6 ORDERS8 10 Closed (C)
65 6 CLOSED6 ORDERS18 10 Closed (C)
65 6 CLOSED6 ORDERS25 10 Closed (C)
65 6 CLOSED6 ORDERS31 10 Closed (C)
65 6 CLOSED6 ORDERS38 10 Closed (C)
65 6 CLOSED6 ORDERS39 10 Closed (C)
65 6 CLOSED6 ORDERS41 10 Closed (C)
65 6 CLOSED6 ORDERS43 10 Closed (C)
65 6 CLOSED6 ORDERS44 10 Closed (C)
65 4 PROJ6 ORDERS2 12 Project (ID)
65 4 PROJ6 ORDERS3 12 Project (ID)
65 4 PROJ6 ORDERS4 12 Project (ID)
65 4 PROJ6 ORDERS5 13 Proyecto (ID)
65 4 PROJ6 ORDERS6 11 Projet (ID)
65 4 PROJ6 ORDERS8 12 Project (ID)
65 4 PROJ6 ORDERS18 12 Project (ID)
65 4 PROJ6 ORDERS25 12 Project (ID)
65 4 PROJ6 ORDERS31 12 Project (ID)
65 4 PROJ6 ORDERS38 12 Project (ID)
65 4 PROJ6 ORDERS39 12 Project (ID)
65 4 PROJ6 ORDERS41 12 Project (ID)
65 4 PROJ6 ORDERS43 12 Project (ID)
65 4 PROJ6 ORDERS44 12 Project (ID)
65 5 UDATE6 ORDERS2 10 Time Stamp
65 5 UDATE6 ORDERS3 10 Time Stamp
65 5 UDATE6 ORDERS4 10 Time Stamp
65 5 UDATE6 ORDERS5 16 Lםmite de Tiempo
65 5 UDATE6 ORDERS6 11 Cachet Date
65 5 UDATE6 ORDERS8 10 Time Stamp
65 5 UDATE6 ORDERS18 10 Time Stamp
65 5 UDATE6 ORDERS25 10 Time Stamp
65 5 UDATE6 ORDERS31 10 Time Stamp
65 5 UDATE6 ORDERS38 10 Time Stamp
65 5 UDATE6 ORDERS39 10 Time Stamp
65 5 UDATE6 ORDERS41 10 Time Stamp
65 5 UDATE6 ORDERS43 10 Time Stamp
65 5 UDATE6 ORDERS44 10 Time Stamp
65 7 PERCENT6 ORDERS2 18 % Overall Discount
65 7 PERCENT6 ORDERS3 18 % Overall Discount
65 7 PERCENT6 ORDERS4 18 % Overall Discount
65 7 PERCENT6 ORDERS5 19 % Descuento General
65 7 PERCENT6 ORDERS6 14 Total Remise %
65 7 PERCENT6 ORDERS8 18 % Overall Discount
65 7 PERCENT6 ORDERS18 18 % Overall Discount
65 7 PERCENT6 ORDERS25 18 % Overall Discount
65 7 PERCENT6 ORDERS31 18 % Overall Discount
65 7 PERCENT6 ORDERS38 18 % Overall Discount
65 7 PERCENT6 ORDERS39 18 % Overall Discount
65 7 PERCENT6 ORDERS41 18 % Overall Discount
65 7 PERCENT6 ORDERS43 18 % Overall Discount
65 7 PERCENT6 ORDERS44 18 % Overall Discount
65 8 DISPRICE6 ORDERS2 20 Price After Discount
65 8 DISPRICE6 ORDERS3 20 Price After Discount
65 8 DISPRICE6 ORDERS4 20 Price After Discount
65 8 DISPRICE6 ORDERS5 20 Precio Post. Descto.
65 8 DISPRICE6 ORDERS6 17 Prix Aprטs Remise
65 8 DISPRICE6 ORDERS8 20 Price After Discount
65 8 DISPRICE6 ORDERS18 20 Price After Discount
65 8 DISPRICE6 ORDERS25 20 Price After Discount
65 8 DISPRICE6 ORDERS31 20 Price After Discount
65 8 DISPRICE6 ORDERS38 20 Price After Discount
65 8 DISPRICE6 ORDERS39 20 Price After Discount
65 8 DISPRICE6 ORDERS41 20 Price After Discount
65 8 DISPRICE6 ORDERS43 20 Price After Discount
65 8 DISPRICE6 ORDERS44 20 Price After Discount
65 3 PAY6 ORDERS2 12 Payment (ID)
65 3 PAY6 ORDERS3 12 Payment (ID)
65 3 PAY6 ORDERS4 12 Payment (ID)
65 3 PAY6 ORDERS5 9 Pago (ID)
65 3 PAY6 ORDERS6 13 Paiement (ID)
65 3 PAY6 ORDERS8 12 Payment (ID)
65 3 PAY6 ORDERS18 12 Payment (ID)
65 3 PAY6 ORDERS25 12 Payment (ID)
65 3 PAY6 ORDERS31 12 Payment (ID)
65 3 PAY6 ORDERS38 12 Payment (ID)
65 3 PAY6 ORDERS39 12 Payment (ID)
65 3 PAY6 ORDERS41 12 Payment (ID)
65 3 PAY6 ORDERS43 12 Payment (ID)
65 3 PAY6 ORDERS44 12 Payment (ID)
65 8 SHIPTYPE6 ORDERS2 18 Shipment Type (ID)
65 8 SHIPTYPE6 ORDERS3 18 Shipment Type (ID)
65 8 SHIPTYPE6 ORDERS4 18 Shipment Type (ID)
65 8 SHIPTYPE6 ORDERS5 20 Tipo de Embarque(ID)
65 8 SHIPTYPE6 ORDERS6 17 Type Expיdi° (ID)
65 8 SHIPTYPE6 ORDERS8 18 Shipment Type (ID)
65 8 SHIPTYPE6 ORDERS18 18 Shipment Type (ID)
65 8 SHIPTYPE6 ORDERS25 18 Shipment Type (ID)
65 8 SHIPTYPE6 ORDERS31 18 Shipment Type (ID)
65 8 SHIPTYPE6 ORDERS38 18 Shipment Type (ID)
65 8 SHIPTYPE6 ORDERS39 18 Shipment Type (ID)
65 8 SHIPTYPE6 ORDERS41 18 Shipment Type (ID)
65 8 SHIPTYPE6 ORDERS43 18 Shipment Type (ID)
65 8 SHIPTYPE6 ORDERS44 18 Shipment Type (ID)
65 5 AGENT6 ORDERS2 14 Sales Rep (ID)
65 5 AGENT6 ORDERS3 14 Sales Rep (ID)
65 5 AGENT6 ORDERS4 14 Sales Rep (ID)
65 5 AGENT6 ORDERS5 20 Representante de Ven
65 5 AGENT6 ORDERS6 20 Rep. Commercial (ID)
65 5 AGENT6 ORDERS8 14 Sales Rep (ID)
65 5 AGENT6 ORDERS18 14 Sales Rep (ID)
65 5 AGENT6 ORDERS25 14 Sales Rep (ID)
65 5 AGENT6 ORDERS31 14 Sales Rep (ID)
65 5 AGENT6 ORDERS38 14 Sales Rep (ID)
65 5 AGENT6 ORDERS39 14 Sales Rep (ID)
65 5 AGENT6 ORDERS41 14 Sales Rep (ID)
65 5 AGENT6 ORDERS43 14 Sales Rep (ID)
65 5 AGENT6 ORDERS44 14 Sales Rep (ID)
65 4 DEAL6 ORDERS2 18 Blanket Order (ID)
65 4 DEAL6 ORDERS3 18 Blanket Order (ID)
65 4 DEAL6 ORDERS4 18 Blanket Order (ID)
65 4 DEAL6 ORDERS5 18 Orden General (ID)
65 4 DEAL6 ORDERS6 18 Blanket Order (ID)
65 4 DEAL6 ORDERS8 18 Blanket Order (ID)
65 4 DEAL6 ORDERS18 18 Blanket Order (ID)
65 4 DEAL6 ORDERS25 18 Blanket Order (ID)
65 4 DEAL6 ORDERS31 18 Blanket Order (ID)
65 4 DEAL6 ORDERS38 18 Blanket Order (ID)
65 4 DEAL6 ORDERS39 18 Blanket Order (ID)
65 4 DEAL6 ORDERS41 18 Blanket Order (ID)
65 4 DEAL6 ORDERS43 18 Blanket Order (ID)
65 4 DEAL6 ORDERS44 18 Blanket Order (ID)
65 8 DESTCODE6 ORDERS2 17 Address Code (ID)
65 8 DESTCODE6 ORDERS3 17 Address Code (ID)
65 8 DESTCODE6 ORDERS4 17 Address Code (ID)
65 8 DESTCODE6 ORDERS5 19 Cףdigo de Dir. (ID)
65 8 DESTCODE6 ORDERS6 17 Code Adresse (ID)
65 8 DESTCODE6 ORDERS8 17 Address Code (ID)
65 8 DESTCODE6 ORDERS18 17 Address Code (ID)
65 8 DESTCODE6 ORDERS25 17 Address Code (ID)
65 8 DESTCODE6 ORDERS31 17 Address Code (ID)
65 8 DESTCODE6 ORDERS38 17 Address Code (ID)
65 8 DESTCODE6 ORDERS39 17 Address Code (ID)
65 8 DESTCODE6 ORDERS41 17 Address Code (ID)
65 8 DESTCODE6 ORDERS43 17 Address Code (ID)
65 8 DESTCODE6 ORDERS44 17 Address Code (ID)
65 4 TYPE6 ORDERS2 12 Stock Order?
65 4 TYPE6 ORDERS3 12 Stock Order?
65 4 TYPE6 ORDERS4 12 Stock Order?
65 4 TYPE6 ORDERS5 17 Orden de Reserva?
65 4 TYPE6 ORDERS6 16 Commande Stock ?
65 4 TYPE6 ORDERS8 12 Stock Order?
65 4 TYPE6 ORDERS18 12 Stock Order?
65 4 TYPE6 ORDERS25 12 Stock Order?
65 4 TYPE6 ORDERS31 12 Stock Order?
65 4 TYPE6 ORDERS38 12 Stock Order?
65 4 TYPE6 ORDERS39 12 Stock Order?
65 4 TYPE6 ORDERS41 12 Stock Order?
65 4 TYPE6 ORDERS43 12 Stock Order?
65 4 TYPE6 ORDERS44 12 Stock Order?
65 12 FORECASTFLAG6 ORDERS2 20 Forecast/Stock Order
65 12 FORECASTFLAG6 ORDERS3 20 Forecast/Stock Order
65 12 FORECASTFLAG6 ORDERS4 20 Forecast/Stock Order
65 12 FORECASTFLAG6 ORDERS5 19 Orden Reserv/Proyec
65 12 FORECASTFLAG6 ORDERS6 20 Comd/Prיvision-Stock
65 12 FORECASTFLAG6 ORDERS8 20 Forecast/Stock Order
65 12 FORECASTFLAG6 ORDERS18 20 Forecast/Stock Order
65 12 FORECASTFLAG6 ORDERS25 20 Forecast/Stock Order
65 12 FORECASTFLAG6 ORDERS31 20 Forecast/Stock Order
65 12 FORECASTFLAG6 ORDERS38 20 Forecast/Stock Order
65 12 FORECASTFLAG6 ORDERS39 20 Forecast/Stock Order
65 12 FORECASTFLAG6 ORDERS41 20 Forecast/Stock Order
65 12 FORECASTFLAG6 ORDERS43 20 Forecast/Stock Order
65 12 FORECASTFLAG6 ORDERS44 20 Forecast/Stock Order
65 9 LCURRENCY6 ORDERS2 16 Linked Curr (ID)
65 9 LCURRENCY6 ORDERS3 16 Linked Curr (ID)
65 9 LCURRENCY6 ORDERS4 16 Linked Curr (ID)
65 9 LCURRENCY6 ORDERS5 18 Actual Relac. (ID)
65 9 LCURRENCY6 ORDERS6 16 Lien Devise (ID)
65 9 LCURRENCY6 ORDERS8 16 Linked Curr (ID)
65 9 LCURRENCY6 ORDERS18 16 Linked Curr (ID)
65 9 LCURRENCY6 ORDERS25 16 Linked Curr (ID)
65 9 LCURRENCY6 ORDERS31 16 Linked Curr (ID)
65 9 LCURRENCY6 ORDERS38 16 Linked Curr (ID)
65 9 LCURRENCY6 ORDERS39 16 Linked Curr (ID)
65 9 LCURRENCY6 ORDERS41 16 Linked Curr (ID)
65 9 LCURRENCY6 ORDERS43 16 Linked Curr (ID)
65 9 LCURRENCY6 ORDERS44 16 Linked Curr (ID)
65 9 LEXCHANGE6 ORDERS2 9 Base Rate
65 9 LEXCHANGE6 ORDERS3 9 Base Rate
65 9 LEXCHANGE6 ORDERS4 9 Base Rate
65 9 LEXCHANGE6 ORDERS5 9 Tipo Base
65 9 LEXCHANGE6 ORDERS6 12 Taux de Base
65 9 LEXCHANGE6 ORDERS8 9 Base Rate
65 9 LEXCHANGE6 ORDERS18 9 Base Rate
65 9 LEXCHANGE6 ORDERS25 9 Base Rate
65 9 LEXCHANGE6 ORDERS31 9 Base Rate
65 9 LEXCHANGE6 ORDERS38 9 Base Rate
65 9 LEXCHANGE6 ORDERS39 9 Base Rate
65 9 LEXCHANGE6 ORDERS41 9 Base Rate
65 9 LEXCHANGE6 ORDERS43 9 Base Rate
65 9 LEXCHANGE6 ORDERS44 9 Base Rate
65 6 ADVBAL6 ORDERS2 15 Advance Payment
65 6 ADVBAL6 ORDERS3 15 Advance Payment
65 6 ADVBAL6 ORDERS4 15 Advance Payment
65 6 ADVBAL6 ORDERS5 8 Pre-pago
65 6 ADVBAL6 ORDERS6 7 Acompte
65 6 ADVBAL6 ORDERS8 15 Advance Payment
65 6 ADVBAL6 ORDERS18 15 Advance Payment
65 6 ADVBAL6 ORDERS25 15 Advance Payment
65 6 ADVBAL6 ORDERS31 15 Advance Payment
65 6 ADVBAL6 ORDERS38 15 Advance Payment
65 6 ADVBAL6 ORDERS39 15 Advance Payment
65 6 ADVBAL6 ORDERS41 15 Advance Payment
65 6 ADVBAL6 ORDERS43 15 Advance Payment
65 6 ADVBAL6 ORDERS44 15 Advance Payment
65 10 ADVPERCENT6 ORDERS2 20 % Advance Pay Deduct
65 10 ADVPERCENT6 ORDERS3 20 % Advance Pay Deduct
65 10 ADVPERCENT6 ORDERS4 20 % Advance Pay Deduct
65 10 ADVPERCENT6 ORDERS5 20 % Pre-payment Deduct
65 10 ADVPERCENT6 ORDERS6 16 Dיduc° Acompte %
65 10 ADVPERCENT6 ORDERS8 20 % Advance Pay Deduct
65 10 ADVPERCENT6 ORDERS18 20 % Advance Pay Deduct
65 10 ADVPERCENT6 ORDERS25 20 % Advance Pay Deduct
65 10 ADVPERCENT6 ORDERS31 20 % Advance Pay Deduct
65 10 ADVPERCENT6 ORDERS38 20 % Advance Pay Deduct
65 10 ADVPERCENT6 ORDERS39 20 % Advance Pay Deduct
65 10 ADVPERCENT6 ORDERS41 20 % Advance Pay Deduct
65 10 ADVPERCENT6 ORDERS43 20 % Advance Pay Deduct
65 10 ADVPERCENT6 ORDERS44 20 % Advance Pay Deduct
65 7 PCLOSED6 ORDERS2 16 Partially Closed
65 7 PCLOSED6 ORDERS3 16 Partially Closed
65 7 PCLOSED6 ORDERS4 16 Partially Closed
65 7 PCLOSED6 ORDERS5 20 Parcialmente Cerrado
65 7 PCLOSED6 ORDERS6 17 En partie traitיe
65 7 PCLOSED6 ORDERS8 16 Partially Closed
65 7 PCLOSED6 ORDERS18 16 Partially Closed
65 7 PCLOSED6 ORDERS25 16 Partially Closed
65 7 PCLOSED6 ORDERS31 16 Partially Closed
65 7 PCLOSED6 ORDERS38 16 Partially Closed
65 7 PCLOSED6 ORDERS39 16 Partially Closed
65 7 PCLOSED6 ORDERS41 16 Partially Closed
65 7 PCLOSED6 ORDERS43 16 Partially Closed
65 7 PCLOSED6 ORDERS44 16 Partially Closed
65 7 BOOKNUM6 ORDERS2 19 Sales Rep Order Num
65 7 BOOKNUM6 ORDERS3 19 Sales Rep Order Num
65 7 BOOKNUM6 ORDERS4 19 Sales Rep Order Num
65 7 BOOKNUM6 ORDERS5 20 N÷ Ord.Repres.Ventas
65 7 BOOKNUM6 ORDERS6 20 No Cmd/RepCommercial
65 7 BOOKNUM6 ORDERS8 19 Sales Rep Order Num
65 7 BOOKNUM6 ORDERS18 19 Sales Rep Order Num
65 7 BOOKNUM6 ORDERS25 19 Sales Rep Order Num
65 7 BOOKNUM6 ORDERS31 19 Sales Rep Order Num
65 7 BOOKNUM6 ORDERS38 19 Sales Rep Order Num
65 7 BOOKNUM6 ORDERS39 19 Sales Rep Order Num
65 7 BOOKNUM6 ORDERS41 19 Sales Rep Order Num
65 7 BOOKNUM6 ORDERS43 19 Sales Rep Order Num
65 7 BOOKNUM6 ORDERS44 19 Sales Rep Order Num
65 6 BRANCH6 ORDERS2 11 Branch (ID)
65 6 BRANCH6 ORDERS3 11 Branch (ID)
65 6 BRANCH6 ORDERS4 11 Branch (ID)
65 6 BRANCH6 ORDERS5 17 INT 1 Uso Interno
65 6 BRANCH6 ORDERS6 11 Agence (ID)
65 6 BRANCH6 ORDERS8 11 Branch (ID)
65 6 BRANCH6 ORDERS18 11 Branch (ID)
65 6 BRANCH6 ORDERS25 11 Branch (ID)
65 6 BRANCH6 ORDERS31 11 Branch (ID)
65 6 BRANCH6 ORDERS38 11 Branch (ID)
65 6 BRANCH6 ORDERS39 11 Branch (ID)
65 6 BRANCH6 ORDERS41 11 Branch (ID)
65 6 BRANCH6 ORDERS43 11 Branch (ID)
65 6 BRANCH6 ORDERS44 11 Branch (ID)
65 12 ADJPRICEFLAG6 ORDERS2 13 Price Linkage
65 12 ADJPRICEFLAG6 ORDERS3 13 Price Linkage
65 12 ADJPRICEFLAG6 ORDERS4 13 Price Linkage
65 12 ADJPRICEFLAG6 ORDERS5 16 Precios de Uniףn
65 12 ADJPRICEFLAG6 ORDERS6 20 Prix liי (Cmd Cadre)
65 12 ADJPRICEFLAG6 ORDERS8 13 Price Linkage
65 12 ADJPRICEFLAG6 ORDERS18 13 Price Linkage
65 12 ADJPRICEFLAG6 ORDERS25 13 Price Linkage
65 12 ADJPRICEFLAG6 ORDERS31 13 Price Linkage
65 12 ADJPRICEFLAG6 ORDERS38 13 Price Linkage
65 12 ADJPRICEFLAG6 ORDERS39 13 Price Linkage
65 12 ADJPRICEFLAG6 ORDERS41 13 Price Linkage
65 12 ADJPRICEFLAG6 ORDERS43 13 Price Linkage
65 12 ADJPRICEFLAG6 ORDERS44 13 Price Linkage
65 7 DETAILS6 ORDERS2 7 Details
65 7 DETAILS6 ORDERS3 7 Details
65 7 DETAILS6 ORDERS4 7 Details
65 7 DETAILS6 ORDERS5 8 Detalles
65 7 DETAILS6 ORDERS6 7 Dיtails
65 7 DETAILS6 ORDERS8 7 Details
65 7 DETAILS6 ORDERS18 7 Details
65 7 DETAILS6 ORDERS25 7 Details
65 7 DETAILS6 ORDERS31 7 Details
65 7 DETAILS6 ORDERS38 7 Details
65 7 DETAILS6 ORDERS39 7 Details
65 7 DETAILS6 ORDERS41 7 Details
65 7 DETAILS6 ORDERS43 7 Details
65 7 DETAILS6 ORDERS44 7 Details
65 7 ORDTYPE6 ORDERS2 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS3 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS4 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS5 18 Tipo de Venta (ID)
65 7 ORDTYPE6 ORDERS6 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS8 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS18 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS25 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS31 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS38 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS39 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS41 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS43 17 Type of Sale (ID)
65 7 ORDTYPE6 ORDERS44 17 Type of Sale (ID)
65 5 PHONE6 ORDERS2 12 Contact (ID)
65 5 PHONE6 ORDERS3 12 Contact (ID)
65 5 PHONE6 ORDERS4 12 Contact (ID)
65 5 PHONE6 ORDERS5 13 Contacto (ID)
65 5 PHONE6 ORDERS6 12 Contact (ID)
65 5 PHONE6 ORDERS8 12 Contact (ID)
65 5 PHONE6 ORDERS18 12 Contact (ID)
65 5 PHONE6 ORDERS25 12 Contact (ID)
65 5 PHONE6 ORDERS31 12 Contact (ID)
65 5 PHONE6 ORDERS38 12 Contact (ID)
65 5 PHONE6 ORDERS39 12 Contact (ID)
65 5 PHONE6 ORDERS41 12 Contact (ID)
65 5 PHONE6 ORDERS43 12 Contact (ID)
65 5 PHONE6 ORDERS44 12 Contact (ID)
65 9 LABELNAME9 LABELSDEF2 13 Type of Label
65 9 LABELNAME9 LABELSDEF3 13 Type of Label
65 9 LABELNAME9 LABELSDEF44 13 Type of Label
65 8 LABELDES9 LABELSDEF2 11 Description
65 8 LABELDES9 LABELSDEF3 11 Description
65 8 LABELDES9 LABELSDEF44 11 Description
65 9 LABELPATH9 LABELSDEF2 10 Label File
65 9 LABELPATH9 LABELSDEF3 10 Label File
65 9 LABELPATH9 LABELSDEF44 10 Label File
65 8 LABELDEF9 LABELSDEF2 18 Type of Label (ID)
65 8 LABELDEF9 LABELSDEF3 18 Type of Label (ID)
65 8 LABELDEF9 LABELSDEF44 18 Type of Label (ID)
65 5 PLIST6 ORDERS2 15 Price List (ID)
65 5 PLIST6 ORDERS3 15 Price List (ID)
65 5 PLIST6 ORDERS4 15 Price List (ID)
65 5 PLIST6 ORDERS5 20 Lista de Precios(ID)
65 5 PLIST6 ORDERS6 15 Liste Prix (ID)
65 5 PLIST6 ORDERS8 15 Price List (ID)
65 5 PLIST6 ORDERS18 15 Price List (ID)
65 5 PLIST6 ORDERS25 15 Price List (ID)
65 5 PLIST6 ORDERS31 15 Price List (ID)
65 5 PLIST6 ORDERS38 15 Price List (ID)
65 5 PLIST6 ORDERS39 15 Price List (ID)
65 5 PLIST6 ORDERS41 15 Price List (ID)
65 5 PLIST6 ORDERS43 15 Price List (ID)
65 5 PLIST6 ORDERS44 15 Price List (ID)
65 7 QPROFIT6 ORDERS2 6 Profit
65 7 QPROFIT6 ORDERS3 6 Profit
65 7 QPROFIT6 ORDERS4 6 Profit
65 7 QPROFIT6 ORDERS5 8 Ganancia
65 7 QPROFIT6 ORDERS6 6 Profit
65 7 QPROFIT6 ORDERS8 6 Profit
65 7 QPROFIT6 ORDERS18 6 Profit
65 7 QPROFIT6 ORDERS25 6 Profit
65 7 QPROFIT6 ORDERS31 6 Profit
65 7 QPROFIT6 ORDERS38 6 Profit
65 7 QPROFIT6 ORDERS39 6 Profit
65 7 QPROFIT6 ORDERS41 6 Profit
65 7 QPROFIT6 ORDERS43 6 Profit
65 7 QPROFIT6 ORDERS44 6 Profit
65 4 CASH6 ORDERS2 20 Bank Account Code-ID
65 4 CASH6 ORDERS3 20 Bank Account Code-ID
65 4 CASH6 ORDERS4 20 Bank Account Code-ID
65 4 CASH6 ORDERS5 20 Cףd-ID Cuenta Bancar
65 4 CASH6 ORDERS6 19 Cpte Banque Code-ID
65 4 CASH6 ORDERS8 20 Bank Account Code-ID
65 4 CASH6 ORDERS18 20 Bank Account Code-ID
65 4 CASH6 ORDERS25 20 Bank Account Code-ID
65 4 CASH6 ORDERS31 20 Bank Account Code-ID
65 4 CASH6 ORDERS38 20 Bank Account Code-ID
65 4 CASH6 ORDERS39 20 Bank Account Code-ID
65 4 CASH6 ORDERS41 20 Bank Account Code-ID
65 4 CASH6 ORDERS43 20 Bank Account Code-ID
65 4 CASH6 ORDERS44 20 Bank Account Code-ID
65 4 DOER6 ORDERS2 17 Assigned to: (ID)
65 4 DOER6 ORDERS3 17 Assigned to: (ID)
65 4 DOER6 ORDERS4 17 Assigned to: (ID)
65 4 DOER6 ORDERS5 15 Asignado A (ID)
65 4 DOER6 ORDERS6 16 Affectי א : (ID)
65 4 DOER6 ORDERS8 17 Assigned to: (ID)
65 4 DOER6 ORDERS18 17 Assigned to: (ID)
65 4 DOER6 ORDERS25 17 Assigned to: (ID)
65 4 DOER6 ORDERS31 17 Assigned to: (ID)
65 4 DOER6 ORDERS38 17 Assigned to: (ID)
65 4 DOER6 ORDERS39 17 Assigned to: (ID)
65 4 DOER6 ORDERS41 17 Assigned to: (ID)
65 4 DOER6 ORDERS43 17 Assigned to: (ID)
65 4 DOER6 ORDERS44 17 Assigned to: (ID)
65 9 ORDSTATUS6 ORDERS2 17 Order Status (ID)
65 9 ORDSTATUS6 ORDERS3 17 Order Status (ID)
65 9 ORDSTATUS6 ORDERS4 17 Order Status (ID)
65 9 ORDSTATUS6 ORDERS5 11 Estado (ID)
65 9 ORDSTATUS6 ORDERS6 18 Etat Commande (ID)
65 9 ORDSTATUS6 ORDERS8 17 Order Status (ID)
65 9 ORDSTATUS6 ORDERS18 17 Order Status (ID)
65 9 ORDSTATUS6 ORDERS25 17 Order Status (ID)
65 9 ORDSTATUS6 ORDERS31 17 Order Status (ID)
65 9 ORDSTATUS6 ORDERS38 17 Order Status (ID)
65 9 ORDSTATUS6 ORDERS39 17 Order Status (ID)
65 9 ORDSTATUS6 ORDERS41 17 Order Status (ID)
65 9 ORDSTATUS6 ORDERS43 17 Order Status (ID)
65 9 ORDSTATUS6 ORDERS44 17 Order Status (ID)
65 15 EXTR_WHITELABEL6 ORDERS2 11 White Label
65 15 EXTR_WHITELABEL6 ORDERS3 11 White Label
64 1 2 20 Internal Development
64 1 3 20 Internal Development
64 1 4 20 Internal Development
64 1 5 20 Internal Development
64 1 6 20 Internal Development
64 1 8 20 Internal Development
64 1 11 20 Internal Development
64 1 18 20 Internal Development
64 1 25 20 Internal Development
64 1 30 20 Internal Development
64 1 31 20 Internal Development
64 1 35 20 Internal Development
64 1 38 20 Internal Development
64 1 39 20 Internal Development
64 1 41 20 Internal Development
64 1 43 20 Internal Development
64 1 44 20 Internal Development
62 6 ORDERS2 12 Sales Orders
62 6 ORDERS3 12 Sales Orders
62 6 ORDERS4 12 Sales Orders
62 6 ORDERS5 16 Ordenes de Venta
62 6 ORDERS6 12 Sales Orders
62 6 ORDERS8 12 Sales Orders
62 6 ORDERS18 12 Sales Orders
62 6 ORDERS25 12 Sales Orders
62 6 ORDERS31 12 Sales Orders
62 6 ORDERS38 12 Sales Orders
62 6 ORDERS39 12 Sales Orders
62 6 ORDERS41 12 Sales Orders
62 6 ORDERS43 12 Sales Orders
62 6 ORDERS44 12 Sales Orders
62 9 LABELSDEF2 17 Label Definitions
62 9 LABELSDEF3 17 Label Definitions
62 9 LABELSDEF44 17 Label Definitions
EOF
echo Begin of Upgrade 7.0.576
echo Title: SO14000458
DBI <<\EOF
CREATE TABLE FSPS_ENVCONT 'ךשמה - תורבח.' 0
DNAME(CHAR,8,'הרבח')
ENVNUM(INT,3,'SPS-הקירסל הרבח דוק')
TWOTYPE(CHAR,1,'SPS-לופכ סופיט')
FSPS_INCDES(CHAR,1,'קירס ינפל רואת תדלקה')
UNIQUE(DNAME)
;
EOF
BRING << \EOF
1013 11 ENVIRONMENT70 0 0 0 11 FSPS_ENVNUM0 19 SPS-הקירסל הרבח דוק3 0 100 0 0 0 0 0 0 0 0 
1015 11 ENVIRONMENT70 11 FSPS_ENVNUM0 70 20 FSPS_ENVCONT5.ENVNUM3 INT
1013 11 ENVIRONMENT70 0 0 0 12 FSPS_TWOTYPE0 14 SPS-לופכ סופיט1 0 102 10 0 0 0 0 0 0 0 
1015 11 ENVIRONMENT70 12 FSPS_TWOTYPE0 70 21 FSPS_ENVCONT5.TWOTYPE4 CHAR
1013 11 ENVIRONMENT70 0 0 0 11 FSPS_INCDES0 20 קירס ינפל רואת תדלקה1 0 104 10 0 0 0 0 0 0 0 
1015 11 ENVIRONMENT70 11 FSPS_INCDES0 70 25 FSPS_ENVCONT5.FSPS_INCDES4 CHAR
18 11 ENVIRONMENT2 
56 11 ENVIRONMENT5 תורבח0 
19 11 ENVIRONMENT1 5 DNAME4 CHAR8 8 4 הרבח
19 11 ENVIRONMENT2 7 CREATOR4 CHAR8 8 7 רצוי םש
19 11 ENVIRONMENT3 5 TITLE5 RCHAR32 32 11 אלמ הרבח םש
19 11 ENVIRONMENT4 3 POS3 INT8 4 5 םוקימ
19 11 ENVIRONMENT5 7 ENVFLAG4 CHAR1 1 9 ?יתרבח בר
19 11 ENVIRONMENT6 8 ENVRATES4 CHAR1 1 20 יתרבח בר םירעש ןוכדע
19 11 ENVIRONMENT7 4 LANG3 INT6 4 7 הפש דוק
33 11 ENVIRONMENT4 LANG0 48 
19 11 ENVIRONMENT8 6 HRFLAG4 CHAR1 1 11 ?שונא יבאשמ
20 11 ENVIRONMENT85 1 
21 11 ENVIRONMENT1 5 DNAME1 
18 12 FSPS_ENVCONT2 
56 12 FSPS_ENVCONT13 ךשמה - תורבח.0 
19 12 FSPS_ENVCONT1 5 DNAME4 CHAR8 8 4 הרבח
19 12 FSPS_ENVCONT2 6 ENVNUM3 INT3 8 19 SPS-הקירסל הרבח דוק
33 12 FSPS_ENVCONT6 ENVNUM0 48 
19 12 FSPS_ENVCONT3 7 TWOTYPE4 CHAR1 1 14 SPS-לופכ סופיט
19 12 FSPS_ENVCONT4 11 FSPS_INCDES4 CHAR1 1 20 קירס ינפל רואת תדלקה
20 12 FSPS_ENVCONT85 1 
21 12 FSPS_ENVCONT1 5 DNAME1 
1013 11 ENVIRONMENT70 11 ENVIRONMENT5 DNAME0 10 FSPS_DNAME0 0 8 0 99 0 72 0 0 12 FSPS_ENVCONT5 DNAME15 1 
24 9400 15 FSPS_getEnvVars70 
1011 4 func70 15 FSPS_getEnvVars70 
22 4 func70 15 FSPS_getEnvVars70 2 /*2 1 
22 4 func70 15 FSPS_getEnvVars70 16 get the env vars1 2 
22 4 func70 15 FSPS_getEnvVars70 38 output: :O_ENVNUM (char 3), :O_TWOTYPE3 3 
22 4 func70 15 FSPS_getEnvVars70 2 */4 4 
22 4 func70 15 FSPS_getEnvVars70 34 :O_ENVNUM = ''; :O_TWOTYPE = '\0';6 5 
22 4 func70 15 FSPS_getEnvVars70 29 SELECT ITOA(ENVNUM,3),TWOTYPE5 6 
22 4 func70 15 FSPS_getEnvVars70 26 INTO :O_ENVNUM, :O_TWOTYPE8 7 
22 4 func70 15 FSPS_getEnvVars70 55 FROM FSPS_ENVCONT WHERE DNAME = SQL.ENV AND ENVNUM > 0;7 8 
22 4 func70 15 FSPS_getEnvVars70 17 SELECT '',TWOTYPE9 9 
22 4 func70 15 FSPS_getEnvVars70 26 INTO :O_ENVNUM, :O_TWOTYPE10 10 
22 4 func70 15 FSPS_getEnvVars70 56 FROM FSPS_ENVCONT WHERE DNAME = SQL.ENV AND ENVNUM <= 0;11 11 
24 9399 9 FSPS_BUF170 
1011 11 ENVIRONMENT70 9 FSPS_BUF170 
22 11 ENVIRONMENT70 9 FSPS_BUF170 47 GOTO 999 WHERE :$.FSPS_ENVNUM = :$1.FSPS_ENVNUM1 1 
22 11 ENVIRONMENT70 9 FSPS_BUF170 38 AND :$.FSPS_TWOTYPE = :$1.FSPS_TWOTYPE2 2 
22 11 ENVIRONMENT70 9 FSPS_BUF170 37 AND :$.FSPS_INCDES = :$1.FSPS_INCDES;10 3 
22 11 ENVIRONMENT70 9 FSPS_BUF170 31 INSERT INTO FSPS_ENVCONT(DNAME)3 4 
22 11 ENVIRONMENT70 9 FSPS_BUF170 17 VALUES(:$.DNAME);4 5 
22 11 ENVIRONMENT70 9 FSPS_BUF170 19 UPDATE FSPS_ENVCONT5 6 
22 11 ENVIRONMENT70 9 FSPS_BUF170 28 SET ENVNUM = :$.FSPS_ENVNUM,6 7 
22 11 ENVIRONMENT70 9 FSPS_BUF170 26 TWOTYPE = :$.FSPS_TWOTYPE,7 8 
22 11 ENVIRONMENT70 9 FSPS_BUF170 28 FSPS_INCDES = :$.FSPS_INCDES11 9 
22 11 ENVIRONMENT70 9 FSPS_BUF170 23 WHERE DNAME = :$.DNAME;8 10 
22 11 ENVIRONMENT70 9 FSPS_BUF170 10 LABEL 999;9 11 
24 9398 16 FSPS_POST-UPDATE70 
1011 11 ENVIRONMENT70 16 FSPS_POST-UPDATE70 
22 11 ENVIRONMENT70 16 FSPS_POST-UPDATE70 30 #INCLUDE ENVIRONMENT/FSPS_BUF11 1 
EOF
echo End of Upgrade 7.0.576
BRING << \EOF
65 5 DNAME11 ENVIRONMENT2 7 Company
65 7 CREATOR11 ENVIRONMENT2 12 Creator Name
65 5 TITLE11 ENVIRONMENT2 17 Full Company Name
65 3 POS11 ENVIRONMENT2 3 Pos
65 7 ENVFLAG11 ENVIRONMENT2 14 Multi-company?
65 8 ENVRATES11 ENVIRONMENT2 19 MultiCo Exch Rates?
65 4 LANG11 ENVIRONMENT2 13 Language Code
65 6 HRFLAG11 ENVIRONMENT2 19 Personnel Managemt?
62 11 ENVIRONMENT2 9 Companies
65 5 DNAME11 ENVIRONMENT2 7 Company
65 5 DNAME11 ENVIRONMENT3 7 Company
65 5 DNAME11 ENVIRONMENT5 7 Empresa
65 5 DNAME11 ENVIRONMENT6 10 Entreprise
65 5 DNAME11 ENVIRONMENT44 7 Company
65 7 CREATOR11 ENVIRONMENT2 12 Creator Name
65 7 CREATOR11 ENVIRONMENT3 12 Creator Name
65 7 CREATOR11 ENVIRONMENT5 18 Nombre del creador
65 7 CREATOR11 ENVIRONMENT6 12 Nom Crיateur
65 7 CREATOR11 ENVIRONMENT44 12 Creator Name
65 5 TITLE11 ENVIRONMENT2 17 Full Company Name
65 5 TITLE11 ENVIRONMENT3 17 Full Company Name
65 5 TITLE11 ENVIRONMENT5 8 Compa?ia
65 5 TITLE11 ENVIRONMENT6 16 Nom Ent. Complet
65 5 TITLE11 ENVIRONMENT44 17 Full Company Name
65 3 POS11 ENVIRONMENT2 3 Pos
65 3 POS11 ENVIRONMENT3 3 Pos
65 3 POS11 ENVIRONMENT5 3 Pos
65 3 POS11 ENVIRONMENT6 3 Pos
65 3 POS11 ENVIRONMENT44 3 Pos
65 7 ENVFLAG11 ENVIRONMENT2 14 Multi-company?
65 7 ENVFLAG11 ENVIRONMENT3 14 Multi-company?
65 7 ENVFLAG11 ENVIRONMENT5 14 Multi-Empresa?
65 7 ENVFLAG11 ENVIRONMENT6 17 Multi-Entreprise?
65 7 ENVFLAG11 ENVIRONMENT44 14 Multi-company?
65 8 ENVRATES11 ENVIRONMENT2 19 MultiCo Exch Rates?
65 8 ENVRATES11 ENVIRONMENT3 19 MultiCo Exch Rates?
65 8 ENVRATES11 ENVIRONMENT5 19 MultiEmpTasadeCamb?
65 8 ENVRATES11 ENVIRONMENT6 20 Taux Chg Mult-Entre?
65 8 ENVRATES11 ENVIRONMENT44 19 MultiCo Exch Rates?
65 4 LANG11 ENVIRONMENT2 13 Language Code
65 4 LANG11 ENVIRONMENT3 13 Language Code
65 4 LANG11 ENVIRONMENT5 18 C?digo de Lenguaje
65 4 LANG11 ENVIRONMENT6 11 Code Langue
65 4 LANG11 ENVIRONMENT44 13 Language Code
65 6 HRFLAG11 ENVIRONMENT2 19 Personnel Managemt?
65 6 HRFLAG11 ENVIRONMENT3 19 Personnel Managemt?
65 6 HRFLAG11 ENVIRONMENT5 19 Manejo de Personal?
65 6 HRFLAG11 ENVIRONMENT6 17 Gestion Personnel
65 6 HRFLAG11 ENVIRONMENT44 19 Personnel Managemt?
62 11 ENVIRONMENT2 9 Companies
62 11 ENVIRONMENT3 9 Companies
62 11 ENVIRONMENT44 9 Companies
EOF
echo Begin of Upgrade 7.0.615
echo Title: FRSP_ORDLABELS
BRING << \EOF
1007 14 FRSP_ORDLABELS80 20 4 SQLI67 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/1 2 
28 14 FRSP_ORDLABELS80 20 42 GOSUB 1000;   /*   Delete From Labels   */2 3 
28 14 FRSP_ORDLABELS80 20 42 GOSUB 1001;   /* Insert Value To Labels */3 4 
28 14 FRSP_ORDLABELS80 20 43 /* GOSUB 1002;         Print Labels      */4 5 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/5 6 
28 14 FRSP_ORDLABELS80 20 9 SUB 1000;6 7 
28 14 FRSP_ORDLABELS80 20 42 DELETE FROM LABELS WHERE  USER = SQL.USER;7 8 
28 14 FRSP_ORDLABELS80 20 7 RETURN;8 9 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/9 10 
28 14 FRSP_ORDLABELS80 20 9 SUB 1001;10 11 
28 14 FRSP_ORDLABELS80 20 15 :B_LABELDEF = 011 12 
28 14 FRSP_ORDLABELS80 20 1 ;12 13 
28 14 FRSP_ORDLABELS80 20 22 LINK ORDERS TO :$.PAR;13 14 
28 14 FRSP_ORDLABELS80 20 27 ERRMSG 1 WHERE :RETVAL <=0;14 15 
28 14 FRSP_ORDLABELS80 20 25 LINK LABELSDEF TO :$.LAB;15 16 
28 14 FRSP_ORDLABELS80 20 26 ERRMSG 1 WHERE :RETVAL <=016 17 
28 14 FRSP_ORDLABELS80 20 1 ;17 18 
28 14 FRSP_ORDLABELS80 20 9 :CNT = 0;18 19 
28 14 FRSP_ORDLABELS80 20 30 SELECT COUNT(*), MAX(LABELDEF)19 20 
28 14 FRSP_ORDLABELS80 20 22 INTO :CNT, :B_LABELDEF20 21 
28 14 FRSP_ORDLABELS80 20 15 FROM  LABELSDEF21 22 
28 14 FRSP_ORDLABELS80 20 19 WHERE LABELDEF <> 022 23 
28 14 FRSP_ORDLABELS80 20 1 ;23 24 
28 14 FRSP_ORDLABELS80 20 17 UNLINK LABELSDEF;24 25 
28 14 FRSP_ORDLABELS80 20 24 ERRMSG 2 WHERE :CNT <> 125 26 
28 14 FRSP_ORDLABELS80 20 1 ;26 27 
28 14 FRSP_ORDLABELS80 20 12 :T_LINE = 1;27 28 
28 14 FRSP_ORDLABELS80 20 20 DECLARE X CURSOR FOR28 29 
28 14 FRSP_ORDLABELS80 20 60 SELECT ORDERS.ORDNAME,(N.CUSTDES='' ? C.CUSTDES : N.CUSTDES)29 30 
28 14 FRSP_ORDLABELS80 20 35 FROM ORDERS, NSCUST N?, CUSTOMERS C30 31 
28 14 FRSP_ORDLABELS80 20 21 WHERE ORDERS.ORD <> 031 32 
28 14 FRSP_ORDLABELS80 20 24 AND ORDERS.CUST = C.CUST32 33 
28 14 FRSP_ORDLABELS80 20 21 AND ORDERS.ORD = N.IV33 34 
28 14 FRSP_ORDLABELS80 20 16 AND N.TYPE = 'O'34 35 
28 14 FRSP_ORDLABELS80 20 10 ORDER BY 135 36 
28 14 FRSP_ORDLABELS80 20 1 ;36 37 
28 14 FRSP_ORDLABELS80 20 7 OPEN X;37 38 
28 14 FRSP_ORDLABELS80 20 29 GOTO 801 WHERE :RETVAL <= 0 ;38 39 
28 14 FRSP_ORDLABELS80 20 10 LABEL 901;39 40 
28 14 FRSP_ORDLABELS80 20 36 FETCH X INTO :X_ORDNAME, :X_CUSTDES;40 41 
28 14 FRSP_ORDLABELS80 20 27 GOTO 701 WHERE :RETVAL <= 041 42 
28 14 FRSP_ORDLABELS80 20 1 ;42 43 
28 14 FRSP_ORDLABELS80 20 68 INSERT INTO LABELS(KLINE, SORT, USER, LABELQUANT,LABELDEF,PAR1,PAR2)43 44 
28 14 FRSP_ORDLABELS80 20 48 VALUES(:T_LINE, :T_LINE, SQL.USER,1,:B_LABELDEF,44 45 
28 14 FRSP_ORDLABELS80 20 12 :X_CUSTDES);45 47 
28 14 FRSP_ORDLABELS80 20 22 :T_LINE = :T_LINE + 1;46 48 
28 14 FRSP_ORDLABELS80 20 9 LOOP 901;47 49 
28 14 FRSP_ORDLABELS80 20 10 LABEL 701;48 50 
28 14 FRSP_ORDLABELS80 20 8 CLOSE X;49 51 
28 14 FRSP_ORDLABELS80 20 10 LABEL 801;50 52 
28 14 FRSP_ORDLABELS80 20 14 UNLINK ORDERS;51 53 
28 14 FRSP_ORDLABELS80 20 7 RETURN;52 54 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/53 55 
28 14 FRSP_ORDLABELS80 20 9 SUB 1002;54 56 
28 14 FRSP_ORDLABELS80 20 7 RETURN;56 58 
28 14 FRSP_ORDLABELS80 20 68 /******************************************************************/57 59 
28 14 FRSP_ORDLABELS80 20 29 #INCLUDE func/FSPS_getEnvVars58 1 
28 14 FRSP_ORDLABELS80 20 33 STRCAT(:O_ENVNUM,'O',:X_ORDNAME),59 46 
28 14 FRSP_ORDLABELS80 20 30 EXECUTE WINPROC '-P','LABELS';60 57 
1007 14 FRSP_ORDLABELS80 30 6 LABELS67 
9 14 FRSP_ORDLABELS80 30 3 MSG0 0 5 ASCII0 0 0 0 0 
EOF
echo End of Upgrade 7.0.615
BRING << \EOF
EOF
