Post Reply 1 post Page 1 of 1
What fields and bands can I add to a custom receipt?
  • User avatar
    RetailEdge Moderator
    Site Admin
    Site Admin
    Posts: 1298
    Joined: Mon Jan 23, 2006 4:02 pm
    Location: Rutland, VT
    Contact:

    What fields and bands can I add to a custom receipt?

    by RetailEdge Moderator » Thu Oct 20, 2016 12:54 pm

    The following field names, types, properties, fields and bands are available for custom receipts and a brief description.

    Field Types (<Field_Type>)
    Label (simple text)
    DBLabel (value of particular field in the database table)
    Value = DB Field Name
    Memo (value of a memo field)
    DBMemo (value of particular field in the database table but put into a memo field to allow the field to stretch and wrap)
    Value = DB Field Name
    Image (an image, jpg or png, used to specify logos, etc.)
    Line (creates an underline)
    Value = Top, Bottom, Right, Left
    Box (draws a box with the dimensions specified)
    SaleData (specialized data for a particular sale, e.g., ReceiptTitle will change depending on whether the sale was an invoice, refund, exchange, etc.)
    SaleDataMemo (same as SaleData but a memo field that can stretch and wrap)
    SaleDataBarCode (prints the value of the sale data as a barcode, e.g., ticket number)
    SaleDataCC (credit card data from a sale, RetailEdge does not store credit card data and so this would be things like card type, authorization codes, etc.)
    SaleDataMemoCC (same as SaleDataCC but a memo field that can stretch and wrap)

    Common Field Properties:

    <Field_Name> - Any name you want. Must be unique
    <Field_Left>
    <Field_Top>
    <Field_Height>
    <Field_Width>
    <Field_BottomOffset> - Offset on the bottom of a particular field. This can provide built in spacing between fields.
    <Field_ShiftRelativeTo> - This allows you to shift a field relative to another field. If you have a field that can grow in size (memo), then you might want the next field displayed to shifted relative to the field that grows. Receipt messages are an example of this.
    <Field_Report> - There are different reports that will be put on different receipt types. For instance a Layaway receipt will have a detailed report of payments on a particular layaway

    Main
    Reg
    Pmt
    Tax
    Payout
    Layaway

    <Field_Band> - The receipt has many different bands available. The reports and fields are placed on the bands. See the attached image below.

    Title
    Header
    Detail
    Footer
    Summary

    <Field_Align_Hor> - Allows justification of the information in the field

    Left
    Right
    Center

    <Field_Stretch> - Allows the field to stretch depending on the length of information in the field.

    True
    False

    <Field_CC_Only> - Fields shown on a credit card receipt only.

    True
    False

    Formatting: - Allows you to format the display font sizing, etc.

    <Font>
    <Font_Name>
    <Font_Size>
    <Font_Color>
    <Font_Style>
    <Font_Style_Bold>
    True
    False
    <Font_Style_Italic>
    True
    False
    <Font_Style_Underline>
    True
    False
    <Font_Style_Strikeout>
    True
    False


    Available Bands:

    HeaderBand
    TitleBand
    DetailBand
    FooterBand[*]
    SummaryBand

    SaleData Values:

    BillTo
    CC_Value_Name
    CC_Value_Number
    CC_Value_CardType
    CC_Value_CustomerCopy
    CC_Value_Auth
    CC_Value_Amount
    CC_Value_EMVData
    CC_Value_SigCap
    Change
    ClerkID
    CustID
    Cust_Short
    Date
    Date_Long
    Date_Time
    Date_Timestamp
    ItemCount
    Layaway_TotalPaid
    Layaway_Balance
    Letterhead
    Location
    Mess_1
    Mess_2
    Mess_3
    Mess_4
    Mess_CC_1
    Mess_CC_2
    Mess_CC_3
    Mess_CC_4
    PONumber
    Store_Name
    Store_S1
    Store_S2
    Store_City
    Store_State
    Store_PostalCode
    Store_Country
    Store_Phone
    ReceiptAddress
    ReceiptTitle
    ReceiptTitle_CC
    Report_Credit
    Report_Charge
    Report_GiftCard_Balance
    Report_GiftCard_Issued
    Reprint
    SaleNote
    SalesTax
    ShipTo
    SignLine
    SubTotal
    TaxID
    Terms
    Ticket
    Ticket_Reg
    Total
    TotalPaid
    TotalSaved

    Possible DB Field Name Values:

    Inventory:

    Inv_Sku
    Inv_ItemID
    Inv_Desc
    Inv_DepartID
    Inv_VendorID
    Inv_ClassID
    Inv_Part_Mfr
    Inv_Part_Vendor
    Inv_UPC1
    Inv_UPC2
    Inv_User1
    Inv_User2
    Inv_User3
    Inv_User4
    Inv_User5

    Customer:

    Cust_CustID
    Cust_B_LastName
    Cust_B_FirstName
    Cust_B_Company
    Cust_B_S1
    Cust_B_S2
    Cust_B_City
    Cust_B_State
    Cust_B_Country
    Cust_B_PostalCode
    Cust_B_Phone
    Cust_S_LastName
    Cust_S_FirstName
    Cust_S_Company
    Cust_S_S1
    Cust_S_S2
    Cust_S_City
    Cust_S_State
    Cust_S_Country
    Cust_S_PostalCode
    Cust_S_Phone
    Cust_Fax
    Cust_Email
    Cust_TaxExempt
    Cust_User1
    Cust_User2
    Cust_User3
    Cust_User4
    Cust_User5
    Cust_Combo_Comp (First Name Last Name Company)
    Cust_Combo_CityState (City State Postal)
    Cust_Combo_FirstLast (First Name Last Name)

    Items:

    Inv_Name
    Sal_Itm_Desc
    Sal_Itm_Mess
    Sal_Itm_Price_Ext
    Sal_Itm_Price_Unit
    Sal_Itm_Quan
    Sal_Ser_Serial
    Saved

    Payments:

    Pmt_Name
    Sal_Pmt_Amount

    Tax Jurisdictions:


    Sal_Tax_Sales_Taxable
    Sal_Tax_Tax
    Tax_Name

    Image
Post Reply 1 post Page 1 of 1

Who is online

Users browsing this forum: Bing [Bot] and 0 guests