Quote Form Fields

Quote form Fields (Oct. 10, 2019 ver. 3.6)

Part of Keystone Forms

Selected Fields

CAST(' + IntToStr(i) + ' AS INTEGER) LOCPRODCLASS, 
QH.PROSPECT_NO, QH.JOB_PO_LOC, QH.SALESPERSON, QC.D_AND_B_RATING, 
QH.FOLLOW_UP_DATE, QH.WON_LOST_FLAG, QH.REASON_CODE, 
QH.QUOTE_DATE, QH.LAST_REVISED_DATE,
QH.EXPIRATION_DATE, QH.SESSION_NO, QH.TRANS_NO, QD.LINE_NO, 
QH.*, QD.*, 
QC.NAME, 
QC.ADDRESS_1, 
QC.ADDRESS_2, 
QC.CITY, 
QC.STATE, 
QC.ZIP, 
QC.CLASS, 
QC.D_AND_B_RATING, 
QC.PHONE_NO CUST_PHONE_NO, 
QC.FAX_NO CUST_FAX_NO, 
(0) TAX_RATE, 
SL.DESCRIPTION SLSPN_NAME, 
SL.JOB_TITLE SLSPN_JOB_TITLE, 
SL.PHONE_NO SLSPN_PHONE_NO, 
SL.CELL_NO SLSPN_CELL_NO, 
SL.FAX_NO SLSPN_FAX_NO, 
SL.EMAIL SLSPN_EMAIL, 
SL.USER_1 SLSPN_USER_1, 
SL.USER_2 SLSPN_USER_2, 
SL.SIGNATURE_IMAGE SL_SIGNATURE_IMAGE, 
SL.SIGNATURE_IMAGE_EXT SL_SIGNATURE_IMAGE_EXT, 
CT.DESCRIPTION TERMS_DESC, 
PL.PLANT_NAME, PL.PLANT_SCREEN_ID, 
PL.ADDRESS_1 PLANT_ADDRESS_1, PL.ADDRESS_2 PLANT_ADDRESS_2, 
PL.PHONE_NO PLANT_PHONE_NO, 
PR.PRODUCT_TYPE, PR.PLANT_NO PROD_PLANT_NO, 
PL2.PLANT_NAME PROD_PLANT_NAME, PL2.PLANT_SCREEN_ID PROD_PLANT_SCREEN_ID, 
UC.DESCRIPTION USAGE_DESC 
FROM ' + VIEW_QTPROSP_CUST_LIST + ' QC 
INNER JOIN ' + TBL_QTJOBHD + ' QH ON (QH.PROSPECT_NO = QC.PROSPECT_NO) 
INNER JOIN ' + TBL_QTJOBDT + ' QD ON (QH.SESSION_NO = QD.SESSION_NO) AND (QH.TRANS_NO = QD.TRANS_NO) 
LEFT OUTER JOIN ' + TBL_ARSLSPER + ' SL ON (QH.SALESPERSON = SL.CLASS_NO) 
LEFT OUTER JOIN ' + TBL_ARCTMCLS + ' CT ON (QH.TERMS_CLASS = CT.CLASS_NO) 
LEFT OUTER JOIN ' + TBL_ARPROD + ' PR ON (PR.PRODUCT_CODE = QD.PRODUCT_CODE) 
LEFT OUTER JOIN ' + TBL_ARPLANT + ' PL ON (PL.PLANT_NO = QH.PLANT_NO) 
LEFT OUTER JOIN ' + TBL_ARPLANT + ' PL2 ON (PL2.PLANT_NO = PR.PLANT_NO) 
LEFT OUTER JOIN ' + TBL_DIUSECLS + ' UC ON (UC.CLASS_NO = QH.USAGE_TYPE)
PROD_DESCRIPTION_1 (4.7.4)
PROD_DESCRIPTION_2 (4.7.4)

*To Remove Price or QTY - Example Below*
  IFNOT COND_COMMENT
                COLUMN 52       FORMAT #####.00         FIELD QTY_ORDERED
                COLUMN 61       FORMAT ####.000         FIELD UNIT_PRICE

Calculated Fields

CALC_CUSTADDR1
CALC_CUSTADDR2
CALC_CUSTADDR3
CALC_CUSTADDR4
CALC_RETADDR1
CALC_RETADDR2
CALC_RETADDR3
CALC_RETADDR4
CALC_SYSDATE
CALC_ORDTAXABLE
CALC_ORDNONTAX
CALC_ORDSUBTOTAL
CALC_ORDTAXTOTAL
CALC_ORDTOTAL
CALC_LISTSUBTOTAL
CALC_LISTTAXTOTAL
CALC_LISTTOTAL
CALC_SAVINGS
CALC_DISCOUNT
CALC_COSTTOTAL
CALC_PROFIT
COND_PRTRETADDR
COND_INTERNAL
COND_PRTLISTS
CALC_USERID
CALC_EXTPRICE
CALC_DISC_UNITPRICE
CALC_DISC_EXTPRICE
COND_COMMENT
CALC_DISCTOTAL
CALC_DISC_ORDSUBTOTAL
CALC_DISC_ORDTOTAL
CALC_UNIT_DISC
CALC_UNIT_TAX
CALC_UNIT_NET
CONDITION_1
CONDITION_2
CONDITION_3
CONDITION_4
CONDITION_5
CONDITION_6
CONDITION_7
CONDITION_8
CONDITIONS (LEFT 80 - FORMAT MEMO)
CALC_DISCTAXTOTAL
CALC_DISCTAX_ORDTOTAL
CALC_DISCSAVINGS
COND_PRODTYPE_MIX
COND_PRODTYPE_ING
COND_PRODTYPE_AGG
COND_PRODTYPE_DEL
CALC_UMS
CALC_UMSTOTAL
COND_PRODUCTTOTALS
CALC_UMSTOTALLINE (AFTER DETAIL)
CONTACT_EMAIL

Salesperson Signature Image

To print the salesperson's signature image on the quote form, use this line in the form file:

COLUMN 1	LEFT 20	IMAGEFIELD SL_SIGNATURE SALESPERSON
                                                ^^^^^^^^^^^ -- the field in the quote table representing the Salesperson Id
                                   ^^^^^^^^^^^^ -- this specifies the salesperson signature image
                     ^^ -- controls the horizontal width of the signature image