Ticket Form Fields - Revision history

Jquinn: /* Calculated Fields */

2025-02-27T20:23:39Z

Calculated Fields

← Older revision		Revision as of 20:23, 27 February 2025
Line 132:		Line 132:
	CALC_LISTTOTAL		CALC_LISTTOTAL
	CALC_SAVINGS		CALC_SAVINGS
	CALC_BATCHWEIGHTS (Allows Re-Print of Batch Weights) (LEFT XX FORMAT MEMO)		CALC_BATCHWEIGHTS (Allows Re-Print of Batch Weights) (COLUMN 15 LEFT 50 FORMAT MEMO FIELD CALC_BATCHWEIGHTS)
	</PRE>		</PRE>

Jquinn: /* Calculated Fields */

2025-02-25T21:33:20Z

Calculated Fields

← Older revision		Revision as of 21:33, 25 February 2025
Line 132:		Line 132:
	CALC_LISTTOTAL		CALC_LISTTOTAL
	CALC_SAVINGS		CALC_SAVINGS
	CALC_BATCHWEIGHTS (Allows Re-Print of Batch Weights)		CALC_BATCHWEIGHTS (Allows Re-Print of Batch Weights) (LEFT XX FORMAT MEMO)
	</PRE>		</PRE>

Jquinn: /* Calc Items with U/M */

2025-02-21T20:24:05Z

Calc Items with U/M

← Older revision		Revision as of 20:24, 21 February 2025
Line 137:		Line 137:
	===Calc Items with U/M===		===Calc Items with U/M===
	<PRE>		<PRE>
	CALC_NET_WEIGHT Unit Type:Weight		CALC_NET_WEIGHT Unit Type:Weight (CALC_NET_WEIGHT_TN)
	GROSS_WEIGHT Unit Type:Weight		GROSS_WEIGHT Unit Type:Weight (GROSS_WEIGHT_TN)
	TARE_WEIGHT Unit Type:Weight		TARE_WEIGHT Unit Type:Weight (TARE_WEIGHT_TN)
	CALC_DELVTODATE Unit Type:Quantity (Qty for an order)		CALC_DELVTODATE Unit Type:Quantity (Qty for an order)
	CALC_QTYTODAY Unit Type:Quantity (Qty by Job Name)		CALC_QTYTODAY Unit Type:Quantity (Qty by Job Name)

Jquinn: /* Calculated Fields */

2025-02-17T14:13:00Z

Calculated Fields

← Older revision		Revision as of 14:13, 17 February 2025
Line 132:		Line 132:
	CALC_LISTTOTAL		CALC_LISTTOTAL
	CALC_SAVINGS		CALC_SAVINGS
			CALC_BATCHWEIGHTS (Allows Re-Print of Batch Weights)
	</PRE>		</PRE>

Hhildreth: /* Calculated Fields */

2024-09-05T17:59:36Z

Calculated Fields

← Older revision		Revision as of 17:59, 5 September 2024
Line 128:		Line 128:
	COND_PRODTYPE_AGG		COND_PRODTYPE_AGG
	COND_PRODTYPE_DEL		COND_PRODTYPE_DEL
			CALC_LISTSUBTOTAL
			CALC_LISTTAXTOTAL
			CALC_LISTTOTAL
			CALC_SAVINGS
	</PRE>		</PRE>

Hhildreth: /* Ticket Fields */

2024-09-05T17:58:47Z

Ticket Fields

← Older revision		Revision as of 17:58, 5 September 2024
Line 54:		Line 54:
	PR.DESCRIPTION_2 PROD_DESCRIPTION_2,		PR.DESCRIPTION_2 PROD_DESCRIPTION_2,
	PR.BASE_PRODUCT,		PR.BASE_PRODUCT,
			PR.LIST_PRICE,
	CT.DESCRIPTION TERMS_CLASS_DESC,		CT.DESCRIPTION TERMS_CLASS_DESC,
	PC.SUBTOTAL PCL_SUBTOTAL,		PC.SUBTOTAL PCL_SUBTOTAL,

Jquinn: /* Copies, Multiple Copies, Samepage Copies & New Page */

2023-12-27T20:48:36Z

Copies, Multiple Copies, Samepage Copies & New Page

← Older revision		Revision as of 20:48, 27 December 2023
Line 154:		Line 154:
	Top of Form COPIES X, SAMEPAGE (Replace X with Number of 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)		Bottom of Form BEGINCOPY X (ADD DETAIL BELOW) (Replace X with the copy number) (eg. BEGINGCOPY 1)
	After Copy X ENDCOPY X (~~Replace X with the copy number) (qg~~. ENDCOPY 1)		After Copy X ENDCOPY (eg. ENDCOPY )

	NEWPAGE NEWPAGE (ADD DETAIL BELOW)		NEWPAGE NEWPAGE (ADD DETAIL BELOW)
	</PRE>		</PRE>

Hhildreth: /* Ticket Fields */

2023-08-09T20:22:43Z

Ticket Fields

← Older revision		Revision as of 20:22, 9 August 2023
Line 6:		Line 6:
	TH.SESSION_NO, TH.TRANS_NO,		TH.SESSION_NO, TH.TRANS_NO,
	TH.CUST_NO, TH.TICKET_NO, TH.TICKET_DATE,		TH.CUST_NO, TH.TICKET_NO, TH.TICKET_DATE,
	TH.SLUMP, TH.MILES, TH.TICKET_TIME,		TH.SLUMP, TH.MILES, TH.TICKET_TIME, TGT_ARRIVE_JOB_DT
	TH.SALESPERSON, TH.SYS_LOC, TH.PLANT_NO,		TH.SALESPERSON, TH.SYS_LOC, TH.PLANT_NO,
	TH.TAX_AUTHORITY, TH.JOB_PO_LOC, TH.JOB_LOT,		TH.TAX_AUTHORITY, TH.JOB_PO_LOC, TH.JOB_LOT,

WikiAdmin: 1 revision imported

2023-07-14T13:00:38Z

1 revision imported

← Older revision	Revision as of 13:00, 14 July 2023
(No difference)

Intra>Mbradley: /* Calculated Fields */

2023-06-27T17:00:33Z

Calculated Fields

New page

==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.

<PRE>
TH.SESSION_NO, TH.TRANS_NO,
TH.CUST_NO, TH.TICKET_NO, TH.TICKET_DATE,
TH.SLUMP, TH.MILES, TH.TICKET_TIME,
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,
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
</PRE>

==Calculated Fields==
<PRE>
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
</PRE>

===Calc Items with U/M===
<PRE>
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)
</PRE>

==Copies, Multiple Copies, Samepage Copies & New Page==
<PRE>
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 X (Replace X with the copy number) (qg. ENDCOPY 1)

NEWPAGE NEWPAGE (ADD DETAIL BELOW)
</PRE>