Sale

Field Code

Description

TaskID

Unique Sale task ID

Company

Company name

Line1

Company Address Line1

Line2

Company Address Line2

Line3

Company Address Line3

ShipToDifferentCompany

Shipping Company if user choose Different Company

ShipToDifferentContact

Shipping Contact if user choose Different Company

ShippingAddressLine1

Full Shipping Address Part 1 (ShippingLine1 + Shipping Line2)

ShippingAddressLine2

Shipping Address Part 2 (City, State, Post code)

ShippingLine1

Shipping Address Line 1

ShippingLine2

Shipping Address Line 2

ShippingCitySuburb

Shipping Address City/Suburb

ShippingStateProvince

Shipping Address State/Province

ShippingZipPostCode

Shipping Address Zip/Postcode

ShippingCountry

Shipping Address Country

BillingLine1

Billing Address Line 1

BillingLine2

Billing Address Line 2

BillingCitySuburb

Billing Address City/Suburb

BillingStateProvince

Billing Address State/Province

BillingZipPostCode

Billing Address Zip/Postcode

BillingCountry

Billing Address Country

MyName

Company Contact Name

MyPhone

Company Phone

MyFax

Company Fax

MyEmail

Company Email

MyWebsite

Company Website

CustomerName

Customer Name

CustomerFax

Customer Fax

CustomerEmail

Customer Email

CustomerWebsite

Customer Website

BillingContact

Customer’s Billing Contact

CustomerContact

Customer Contact (Shipping contact if ship to different option is used otherwise Billing Contact)

CustomerPhone

Customer Phone

CustomerJobTitle

Customer contact’s job title

CustomerMobilePhone

Customer contact’s mobile phone number

Terms

Payment terms

BillingAddressLine1

Customer Billing Address Line1

BillingAddressLine2

Customer Billing Address Line2

CustomerReference

Customer Reference (e.g. Purchase Order Number)

TaxNumber

Customer Tax Number

InvoiceNumber

Invoice Number

InvoiceDate

Invoice Date

InvoiceDueDate

Invoice Due Date

RequiredBy

Shipment Required By

Currency

Customer Currency

Tax

TaxRule Name for document

SONumber

Sale Order Number

Fulfilmentnumber

Fulfilment number associated/Linked with Invoice

Date

Date of the document

Location

Warehouse Location

QuoteMemo

Quote Memo. Additional information you would like to print on the quote

InvoiceMemo

Invoice Memo. Additional information you would like to print on the invoice

CreditNoteMemo

Credit Note Memo. Additional information you would like to print on the credit note

OrderMemo

Sale Order Memo. Additional information you would like to print on the sale order

Note

Internal note from the task header

CreditNoteNumber

Credit Note Number

Rate

Currency conversion rate at the time when goods were received.

SalesRepresentative

Name of Sales Representative

SalesRepresentativePhone

Phone number of Sales Representative

SalesRepresentativeFax

Fax number of Sales Representative

SalesRepresentativeEmail

Email address of Sales Representative

PriceTier

Name price tier used for the document

CreditNoteDate

Credit Note Date

QuoteLinesBeforeTax

Quote Lines Before Tax

QuoteLinesTax

Quote Lines Tax

QuoteLinesTotal

Quote Lines Total

QuoteAdditionalChargesBeforeTax

Quote Additional Charges Before Tax

QuoteAdditionalChargesTax

Quote Additional Charges Tax

QuoteAdditionalChargesTotal

Quote Additional Charges Total

QuoteBeforeTax

Quote Before Tax

QuoteTax

Quote Tax

QuoteTotal

Quote Total

PrepaymentsTotal

Total of prepayments

QuoteDue

Quote Total - Total of prepayments

SOBeforeTax

Sale Order Amount Before tax

SOTax

Sale Order Tax (if applicable)

SOTotal

Total Sale order amount

OrderAdditionalChargesLinesBeforeTax

Order Additional Charges Before Tax

OrderAdditionalChargesTax

Order Additional Charges Tax

OrderAdditionalChargesTotal

Order Additional Charges Total

OrderBeforeTax

Order Before Tax

OrderTax

Order Tax

OrderTotal

Order Total

InvoiceLinesBeforeTax

Invoice Lines Before Tax

InvoiceLinesTax

Invoice Lines Tax

InvoiceLinesTotal

Invoice Lines Total

InvoiceAdditionalCostLinesBeforeTax

Invoice Additional Cost Lines Before Tax

InvoiceAdditionalCostLinesTax

Invoice Additional Cost Lines Tax

InvoiceAdditionalCostLinesTotal

Invoice Additional Cost Lines Total

InvoiceBalance

Invoice Balance

CreditNoteLinesBeforeTax

Credit Note Lines Before Tax

CreditNoteLinesTax

Credit Note Lines Tax

CreditNoteLinesTotal

Credit Note Lines Total

CreditNoteAdditionalCostLinesBeforeTax

Credit Note Additional Cost Lines Before Tax

CreditNoteAdditionalCostLinesTax

Credit Note Additional Cost Lines Tax

CreditNoteAdditionalCostLinesTotal

Credit Note Additional Cost Lines Total

CreditNoteBalance

Credit Note Balance

TotalCostOfGoods

Total Cost Of Goods for the document

TotalPayments

Total Payments for invoices

InvoiceTax

Invoice Tax

InvoiceBeforeTax

Invoice Before Tax

InvoiceTotal

Invoice Total

CreditNoteTax

Credit Note Tax

CreditNoteBeforeTax

Credit Note Before Tax

CreditNoteTotal

Credit Note Total

TotalRefunds

Total Refunds

QuoteTotalDiscount

Total Discount amount applied to Quote

SOTotalDiscount

Total Discount amount applied to Order

InvoiceTotalDiscount

Total Discount amount applied to Invoice

CreditNoteTotalDiscount

Total Discount amount applied to Credit Note

DatePrinted

Date Printed

DueOrCredit

Due Or Credit

LinesInQuoteLines

Total Lines In Quote Lines  Table

LinesInQuoteAdditionalCharges

Total Lines In Quote Additional Charges table

LinesInInvoice

Total Lines In Invoice table

LinesInInvoiceAdditionalCharges

Total Lines In Invoice Additional Charges table

LinesInBackorderedInvoice

Total Lines In Backordered Invoice table

LinesInPrepayment

Total Lines In Prepayment

LinesInPayment

Total Lines In Payment

LinesInCreditNote

Total Lines In Credit Note

LinesInCreditNoteAdditionalCharges

Total Lines In Credit Note Additional Charges table

LinesInRefund

Total Lines In Refund table

LinesInPickList

Total Lines In Pick List table

LinesInSaleOrder

Total Lines In Sale Order table

LinesInPackingList

Total Lines In Packing List table

LinesInShip

Total Lines In Ship table

LinesInReceipt

Total Lines In Receipt table

LinesInBoxContent

Total Lines In Box Content table

IsServiceOnly

Flag indicating that sale Is Service Only sale no inventory involved

QuoteTotalQuantity

TotalQuoteQuantity

OrderTotalQuantity

Total Order Quantity

PickTotalQuantity

Total Pick Quantity

ExpandedPickTotalQuantity

TotalQuantity in ExpandedPick table

RestockTotalQuantity

Total Restock Quantity

InvoiceTotalQuantity

Total Invoice Quantity

CreditNoteTotalQuantity

Total Credit Note Quantity

Status

Sale Task status

CustomerAttribute1

Custom Attribute 1 value assigned to a customer

CustomerAttribute2

Custom Attribute 2 value assigned to a customer

CustomerAttribute3

Custom Attribute 3 value assigned to a customer

CustomerAttribute4

Custom Attribute 4 value assigned to a customer

CustomerAttribute5

Custom Attribute 5 value assigned to a customer

CustomerAttribute6

Custom Attribute 6 value assigned to a customer

CustomerAttribute7

Custom Attribute 7 value assigned to a customer

CustomerAttribute8

Custom Attribute 8 value assigned to a customer

CustomerAttribute9

Custom Attribute 9 value assigned to a customer

CustomerAttribute10

Custom Attribute 10 value assigned to a customer

TaxMode

Totals are tax "Inclusive" or "Exclusive".

Carrier

Carrier Service Name from Carrier/Service on Sale Order screen (Default Carrier setup in Customer Record)

StripePay

This mail merge field will be replaced by Pay By Stripe hyperlink image enabling clients to pay the invoice by Stripe. Stripe integration should be enabled and configured.

PayPalPay

This mail merge field will be replaced by Pay By PayPal hyperlink image enabling clients to pay the invoice by PayPal. PayPal integration should be enabled and configured.

SaleAttribute1

Sale Additional Attribute 1

SaleAttribute2

Sale Additional Attribute 2

SaleAttribute3

Sale Additional Attribute 3

SaleAttribute4

Sale Additional Attribute 4

SaleAttribute5

Sale Additional Attribute 5

SaleAttribute6

Sale Additional Attribute 6

SaleAttribute7

Sale Additional Attribute 7

SaleAttribute8

Sale Additional Attribute 8

SaleAttribute9

Sale Additional Attribute 9

SaleAttribute10

Sale Additional Attribute 10


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.