Ticket Form Fields

Ticket Fields

Note: These is the list of fields direct from the select query. Aliases such as "TH." and "CU." are not part of the field name used for tickets. Therefore use "SLUMP" not "TH.SLUMP" etc.

TH.SESSION_NO, TH.TRANS_NO, 
TH.CUST_NO, TH.TICKET_NO, TH.TICKET_DATE, 
TH.SLUMP, TH.MILES, TH.TICKET_TIME, TGT_ARRIVE_JOB_DT
TH.SALESPERSON, TH.SYS_LOC, TH.PLANT_NO, 
TH.TAX_AUTHORITY, TH.JOB_PO_LOC, TH.JOB_LOT, 
TH.JOB_BLOCK, TH.ORDER_CODE, TH.ORDER_SESSION_NO, 
TH.ORDER_TRANS_NO, TH.ORDER_LOAD_NO, TH.TRUCK_NO, TH.TRAILER_1, 
TH.TRAILER_2, TH.SOURCE_FLAG, TH.VOID_FLAG, 
TH.PRICED_FLAG, TH.OFFICE_PRICE_FLAG, TH.ZONE, 
TH.COD_FLAG, 
TH.ELAPSED_TIME, 
TH.BATCH_START_DT, TH.BATCH_END_DT, 
TH.LEAVE_PLANT_DT, TH.ARRIVE_JOB_DT, 
TH.BEGIN_POUR_DT, TH.END_POUR_DT, 
TH.LEAVE_JOB_DT, TH.RETURN_PLANT_DT, 
TH.CUSTOMER_PO, TH.DRIVER, TH.PAYMENT_AMOUNT, 
TH.CHECK_DATE, TH.CHECK_NO, 
TH.BANK_NO, TH.SHIP_TO_1, TH.SHIP_TO_2, 
TH.SHIP_TO_3, TH.SHIP_TO_4, TH.DELV_INST_1, 
TH.DELV_INST_2, TH.DELV_INST_3, TH.DELV_INST_4, 
TH.WEATHER, 
TH.WEIGHMASTER, TH.CUSTOM_1, TH.CUSTOM_2, 
TH.USAGE_TYPE,  
TD.LINE_NO, TD.COMMENT_FLAG, TD.UNIT_PRICE, 
TD.QTY_SOLD, 
TD.PRODUCT_CODE, TD.UNIT_OF_MEASURE, 
TD.DESCRIPTION, 
TD.TAX_CODE, TD.TAX_CODE_2, TD.TAX_CODE_3,  
TD.PRICE_SOURCE, 
TD.GROSS_WEIGHT, TD.TARE_WEIGHT, TD.WEIGHT_UMS, 
TD.SCALE_WEIGHT_FLAG, 
TH.COMMENT_1, TH.COMMENT_2, TH.NOTES_1, TH.NOTES_2, TH.ORDER_BALANCE, 
TH.AMT_TEND, TH.INV_ADJUST_FLAG, TH.CLOSED_FLAG, TD.UNIT_PCT_DISC, TD.QTY_DELIVERED, 
TD.QTY_ORDERED, TD.ORDER_LINE_NO, 
CU.NAME, CU.ADDRESS_1, CU.ADDRESS_2, CU.CITY, 
CU.STATE, CU.ZIP, CU.TERMS_CLASS CUST_TERMS_CLASS, 
CU.USER_1 CUST_USER_1, 
CU.USER_2 CUST_USER_2, 
CU.NOTES_1 CUST_NOTES_1, 
CU.NOTES_2 CUST_NOTES_2, 
CU.NOTES_3 CUST_NOTES_3, 
CU.NOTES_4 CUST_NOTES_4, 
TA.DESCRIPTION TAX_AUTHORITY_NAME,
PL.PLANT_NAME PLANT_ADDR1, PL.ADDRESS_1 PLANT_ADDR2, PL.ADDRESS_2 PLANT_ADDR3, 
DR.DRIVER_NAME, 
PR.PRODUCT_TYPE, 
PR.ROLLUP_FLAG, 
PR.DESCRIPTION_1 PROD_DESCRIPTION_1, 
PR.DESCRIPTION_2 PROD_DESCRIPTION_2, 
PR.BASE_PRODUCT, 
PR.LIST_PRICE,
CT.DESCRIPTION TERMS_CLASS_DESC, 
PC.SUBTOTAL PCL_SUBTOTAL, 
UM.SUBTOTAL UMS_SUBTOTAL, 
UM.UMS_TYPE, UM.EXPANDED_UMS,  
TR.PLATE_NUMBER, TR.OWNER_CODE, 
TR.LEGAL_MAX_WEIGHT, 
TR.VIN_NUMBER, 
TR.TRUCK_MAKE, TR.TRUCK_MODEL, TR.TRUCK_YEAR, 
OW.OWNER_NAME, 
UC.DESCRIPTION USAGE_DESC,  
SP.DESCRIPTION SALESPERSON_NAME,  
WM.NAME WM_NAME, WM.LICENSE_NO WM_LICENSE_NO, 
WM.LICENSE_EXP_DATE WM_LICENSE_EXP_DATE, 
WM.USER_1 WM_USER_1, WM.USER_2 WM_USER_2, 
WM.SIGNATURE_IMAGE WM_SIGNATURE_IMAGE, 
WM.SIGNATURE_IMAGE_EXT WM_SIGNATURE_IMAGE_EXT 

Calculated Fields

CALC_CUSTADDR1 CALC_CUSTADDR2 CALC_CUSTADDR3 CALC_CUSTADDR4 
CALC_EXTAMOUNT
CALC_PRICEDTICKET 
CALC_SUBTOTAL 
CALC_SALESTAX
CALC_TICKETTOTAL 
CALC_BALDUE
UNIT_PRICE 
UNIT_PCT_DISC 
TAX_CODE
CALC_TICKETSTODAY
CALC_MATLTOTAL
CALC_DELVTOTAL
CALC_WEIGHMASTER
COND_PRICEDTICKET
COND_WEIGHTS
COND_COMMENT
COND_LINE_1
COND_COD
COND_MANUALWEIGHT
COND_WEIGHMASTER
CALC_NONTAXTOTAL
ORDER_NOTES_1 ORDER_NOTES_2
CALC_PREVORDERBAL
CALC_NEWORDERBAL
COND_CONCRETETICKET
CALC_TAXABLETOTAL
CALC_CHANGEDUE
CALC_DISCTOTAL
CALC_NETDUEAFTERDISC
CALC_TICKETSTODATE
ORDER_DELV_TIME
COND_ORDER_PLUS
TAXCOL1_AMOUNT
TAXCOL2_AMOUNT
TAXCOL3_AMOUNT
TAXCOL1_LABEL
TAXCOL2_LABEL
TAXCOL3_LABEL
ORDER_CEMENT
ORDER_PCT_CALCIUM
ORDER_PCT_AIR
CALC_ORDERTOTAL
ORDER_TAKEN_BY
ORDER_TAKEN_ON
ORDER_CONTACT
ORDER_PHONE_NO
ORDER_PREV_TRUCK
ORDER_PREV_DRIVER
COND_PRODTYPE_MIX
COND_PRODTYPE_ING
COND_PRODTYPE_AGG
COND_PRODTYPE_DEL

Calc Items with U/M

CALC_NET_WEIGHT        Unit Type:Weight
GROSS_WEIGHT           Unit Type:Weight
TARE_WEIGHT            Unit Type:Weight
CALC_DELVTODATE        Unit Type:Quantity  (Qty for an order)
CALC_QTYTODAY          Unit Type:Quantity  (Qty by Job Name)
CALC_ORDQTYDELV        Unit Type:Quantity
CALC_ORDQTYREMAIN      Unit Type:Quantity
MILES                  Unit Type:Miles
QTY_SOLD               Unit Type:Quantity
QTY_DELIVERED          Unit Type:Quantity
QTY_ORDERED            Unit Type:Quantity
CALC_ORDQTYAMT         Unit Type:Quantity
LEGAL_MAX_WEIGHT       Unit Type:Weight
CALC_L1_QTY_ORDERED    Unit Type:Quantity
CALC_L1_QTY_DELIVERED  Unit Type:Quantity
CALC_L1_QTY_REMAINING  Unit Type:Quantity)

Copies, Multiple Copies, Samepage Copies & New Page

SAME PAGE COPIES
Top of Form            COPIES X, SAMEPAGE (Replace X with Number of copies)
Bottom of Form         BEGINCOPY X (ADD DETAIL BELOW) (Replace X with the copy number) (eg. BEGINGCOPY 1)
After Copy X           ENDCOPY   (eg. ENDCOPY )

NEWPAGE                NEWPAGE (ADD DETAIL BELOW)