Invoice Form Fields

From KeystoneIntranet
Revision as of 20:22, 27 February 2025 by Jquinn (talk | contribs)
Jump to navigation Jump to search

Fields available for the invoice form.

NOTE: In most cases just the field name is used. In some cases an alias is used and both the actual field name and the alias will be presented - in this case use the alias name on the form.

Examples: 

IV.SESSION_NO INV_SESSION_NO,  
IV.TRANS_NO INV_TRANS_NO,  
SP.DESCRIPTION SALESPERSON_NAME,

Use: 

INV_SESSION_NO
INV_TRANS_NO
SALESPERSON_NAME

A ticket Image can be added as: 

Add ticket form to invoice....
! ---------- Ticket Document Image
DETAIL 5
     LINE 4 COLUMN 1 LEFT 80         IMAGEFIELD TICKET DOC_ID

To add a Barcode or Payment Link: 

For QR Code:
LINE +1 COLUMN 15	LEFT 40 FORMAT BARCODE_QR	FIELD CALC_LINK_PAYMENT_QR
 
For payment link:
FIELD CALC_LINK_PAYMENT WIDTH ?? FORMAT PDF_HYPERLINK

Invoice Form Fields

IV.SESSION_NO INV_SESSION_NO,  
IV.TRANS_NO INV_TRANS_NO,  
IV.CUST_NO,  
IV.INVOICE_NO,  
IV.INVOICE_DATE,  
SALES_TAX,  
SALES_TAX_1,  
SALES_TAX_2,  
SALES_TAX_3,  
IV.DEBIT_AMOUNT INVOICE_TOTAL,  
IV.DISC_OFFERED DISC_AVAILABLE,  
IV.DISC_VALID_DATE DISC_DATE,  
NON_TAXABLE_1,  
NON_TAXABLE_2,  
NON_TAXABLE_3,  
IV.PRIOR_AR_BALANCE,  
IV.TAX_AUTHORITY,  
IV.JOB_DESC,  
IV.AGING_1,  
IV.AGING_2,  
IV.AGING_3,  
IV.AGING_4,  
IV.AGING_5,  
IV.FINCHG_1,  
IV.FINCHG_2,  
IV.FINCHG_3,  
IV.FINCHG_4,  
IV.FINCHG_5,  
IV.INVOICEMESSAGE_1,  
IV.INVOICEMESSAGE_2,  
IV.INVOICEMESSAGE_3,  
IV.INVOICEMESSAGE_4,  
IV.RETURNADDR_1,  
IV.RETURNADDR_2,  
IV.RETURNADDR_3,  
IV.RETURNADDR_4,  
IV.UMS_1,  
IV.UMS_2,  
IV.UMS_3,  
IV.UMS_4,  
IV.UMS_5,  
IV.UMSTOTAL_1,  
IV.UMSTOTAL_2,  
IV.UMSTOTAL_3,  
IV.UMSTOTAL_4,  
IV.UMSTOTAL_5,  
IV.CUST_NAME,  
IV.CUST_ADDRESS_1,  
IV.CUST_ADDRESS_2,  
IV.CUST_CITY,  
IV.CUST_STATE,  
IV.CUST_ZIP,  
IV.CREDIT_TERMS,  
IV.DISCOUNT_MESSAGE,  
(0) SPLIT_RATE,   temporary
(0) SPLIT_LIMIT,  
IV.PLANT_NAME,  
IV.PLANT_SCREEN_ID,  
IV.PLANT_ADDRESS_1,  
IV.PLANT_ADDRESS_2,  
IV.PLANT_PHONE_NO,  
IV.SPACE_BETWEEN_TICKETS,  
IV.NONTAX_TOTAL,  
IV.TICKET_COMMENTS,  
IV.PRODUCT_TOTALS,  
IV.PRINT_CASH,  
IV.PRINT_PRICED,  
IV.PRINT_UNPRICED,  
IV.CUST_COD_FLAG,  
IV.CUST_USER_1,  
IV.CUST_USER_2,  
IV.DUE_DATE,  
IV.VOID_FLAG,  
IV.PLANT_NO INV_PLANT_NO,  
IV.DIVISION_NO,  
IV.CREDIT_AMOUNT,  

// customer fields
CU.TAX_ID CUST_TAX_ID,  

// sales header fields
SH.SESSION_NO TCK_SESSION_NO,  
SH.TRANS_NO TCK_TRANS_NO,  
SH.TICKET_NO,  
SH.TICKET_DATE,  
SH.SLUMP,  
SH.MILES,  
SH.TICKET_TIME,  
SH.SALESPERSON,  
SH.CUST_CLASS,  
SH.SYS_LOC,  
SH.PLANT_NO,  
SH.JOB_PO_LOC,  
SH.JOB_LOT,  
SH.TRUCK_NO,  
SH.TRAILER_1,  
SH.TRAILER_2,  
SH.SOURCE_FLAG,  
SH.VOID_FLAG,  
SH.PRICED_FLAG,  
SH.OFFICE_PRICE_FLAG,  
SH.ZONE,  
SH.COD_FLAG,  
SH.ELAPSED_TIME,  
SH.BATCH_START_DT,  
SH.BATCH_END_DT,  
SH.LEAVE_PLANT_DT,  
SH.ARRIVE_JOB_DT,  
SH.BEGIN_POUR_DT,  
SH.END_POUR_DT,  
SH.LEAVE_JOB_DT,  
SH.RETURN_PLANT_DT,  
SH.CUSTOMER_PO,  
SH.DRIVER,  
SH.JOB_CLASS,  
SH.PAYMENT_AMOUNT,  
SH.CHECK_DATE,  
SH.CHECK_NO,  
SH.BANK_NO,  
SH.SHIP_TO_1,  
SH.SHIP_TO_2,  
SH.SHIP_TO_3,  
SH.SHIP_TO_4,  
SH.DELV_INST_1,  
SH.DELV_INST_2,  
SH.DELV_INST_3,  
SH.DELV_INST_4,  
SH.ORDER_CODE, 
SH.JOB_BLOCK, 
SH.CUSTOM_1, 
SH.CUSTOM_2, 
SH.USAGE_TYPE, 
SH.DOC_LINK,  

// sales detail fields
SD.LINE_NO TCK_LINE_NO,  
SD.COMMENT_FLAG,  
SD.UNIT_PRICE,  
SD.LIST_PRICE,  
SD.UNIT_DISC,  
SD.STD_DISC,  
SD.QTY_SOLD,  
SD.PRODUCT_CODE,  
SD.UNIT_OF_MEASURE,  
SD.DESCRIPTION,  
SD.TAX_CODE,  
SD.TAX_CODE_2,  
SD.TAX_CODE_3,  
SD.PRICE_SOURCE,  
SD.GROSS_WEIGHT,  
SD.TARE_WEIGHT,  
SD.WEIGHT_UMS,  
SD.SCALE_WEIGHT_FLAG,  
SD.EXT_PRICE,  .99.27

      // salesperson fields
SP.DESCRIPTION SALESPERSON_NAME,  

      // product fields
PR.ROLLUP_FLAG,   
PR.PRODUCT_TYPE,  
PR.DESCRIPTION_1 PROD_DESCRIPTION_1,  
PR.DESCRIPTION_2 PROD_DESCRIPTION_2,
PR.BASE_PRODUCT  

// usage class fields
UC.DESCRIPTION USAGE_DESC,  .32

// plant fields
PT.PLANT_NAME TCK_PLANT_NAME, 
PT.PLANT_SCREEN_ID TCK_PLANT_SCREEN_ID,  

// division fields
//DV.DIVISION_NO,  
DV.DIVISION_NAME, 

// tax authority fields  
TA.DESCRIPTION TAX_AUTH_DESC

Calculated Fields

CALC_RETADDR1, CALC_RETADDR2, CALC_RETADDR3,
 CALC_RETADDR4, CALC_INVOICEDATE, CALC_CUSTADDR1,
 CALC_CUSTADDR2, CALC_CUSTADDR3, CALC_CUSTADDR4,
 CALC_INVMSG1, CALC_INVMSG2, CALC_INVMSG3,
 CALC_INVMSG4, CALC_CREDITTERMS, CALC_INVOICENO,
 CALC_SUBTOTAL, CALC_NONTAXTOTAL, CALC_SALESTAX,
 CALC_INVTOTAL, UNIT_PRICE, CALC_EXTPRICE,
 CALC_TAXIND, CALC_TAXAUTH, CALC_DISCOUNTLINE,
 CALC_DISCTOTAL, CALC_NFAGING1, CALC_NFAGING2,
 CALC_NFAGING3, CALC_NFAGING4, CALC_NFAGING5,
 CALC_NFAGING4&5, CALC_FINCHGBAL, CALC_AGING1,
 CALC_AGING2, CALC_AGING3, CALC_AGING4,
 CALC_AGING5, CALC_AGING4&5, CALC_DISCBALDUE,
 COND_NONTAXTOTAL, CALC_UMS, CALC_UMSTOTAL,
 COND_PRODUCTTOTALS, CALC_UMSTOTALLINE, JOB_PO_LOC,
 CALC_DISCDATE, CALC_TAXRATEPCT, CALC_TAXINDYN,
 CALC_MATLTOTAL, CALC_DELVTOTAL, QTY_SOLD,
 CALC_TKROLL_MATLTOTAL, CALC_TKROLL_DELVTOTAL, CALC_TKROLL_TAXTOTAL,
 CALC_TKROLL_TKTTOTAL, CALC_TAXABLETOTAL, ORDER_CODE,
 TAX_RATE, SPLIT_RATE, SPLIT_LIMIT,
 PLANT_NAME, PLANT_SCREEN_ID, PLANT_ADDRESS_1,
 PLANT_ADDRESS_2, PLANT_PHONE_NO, CUST_USER_1,
 CUST_USER_2, CALC_PAYMENTTOTAL, CALC_NETDUE,
 CALC_PRIORARBAL, CALC_NEWARBAL, TICKET_JOB,
 PS_DESCRIPTION, PS_QUANTITY, PS_U_OF_M,
 PS_PRODUCT_CODE, PS_UNIT_PRICE, PS_EXT_PRICE,
 CALC_VOIDFLAGMSG,
 PS_TAX_IND,  
 TS_PLANT_NO, TS_TICKET_NO,  
 COND_TICKET_LINE_1,  
 COND_PRICE_ROLLUP,  
 COND_COD_CUST, COND_CASH_CUST,  
 TAX_DESC_1, TAX_DESC_2, TAX_DESC_3,  
 DOC_ID,  
 CALC_INVBAL
Retrieved from "http://in.compucrete.com/index.php?title=Invoice_Form_Fields&oldid=1092"