|
Column
|
Format
|
|
|
CustomerRef
|
STRTYPE (209)
|
MANDATORY FIELD FOR ZA
Customer Name as appears in QuickBooks, if ZA cannot find a Customer then it will create a new customer record.
|
|
AccountRef
|
STRTYPE (159)
|
Refers to an accounts receivable account in the QuickBooks file
|
|
TemplateRef
|
STRTYPE (31)
|
templates specify how to print certain transactions
|
|
TxnDate
|
DATETYPE
|
The date of the invoice. If you leave TxnDate out of an InvoiceAdd message, QuickBooks will prefill it with the date of the invoice that was most recently saved.
|
|
InvoiceRefNumber
|
STRTYPE (11)
|
MANDATORY FIELD FOR ZA
Generally used as the Invoice Ref number When RefNumber is left blank the RefNumber will be left blank in QuickBooks, duplicate RefNumbers are accepted in QuickBooks.
|
|
BillAdd1
|
STRTYPE (41)
|
First Line of Billing Address
|
|
Bill Add2
|
STRTYPE (41)
|
Second Line of Billing Address
|
|
BillAdd3
|
STRTYPE (41)
|
Third Line of Billing Address
|
|
BillAdd4
|
STRTYPE (41)
|
Fourth Line of Billing Address
|
|
BillAdd5
|
STRTYPE (41)
|
Fifth Line of Billing Address
|
|
BillCity
|
STRTYPE (31)
|
City Name
|
|
BillState
|
STRTYPE (21)
|
State or Province name in address
|
|
BillPostalCode
|
STRTYPE (13)
|
Postal or Zip code in address
|
|
BillCountry
|
STRTYPE (31)
|
Country in the billing address
|
|
BillNote
|
STRTYPE (41)
|
Note field value is written at the bottom of the address
|
|
ShipAdd1
|
STRTYPE (41)
|
First Line of Ship to Address
|
|
ShipAdd2
|
STRTYPE (41)
|
Second Line of Ship to Address
|
|
ShipAdd3
|
STRTYPE (41)
|
Third Line of Ship to Address
|
|
ShipAdd4
|
STRTYPE (41)
|
Fourth Line of Ship to Address
|
|
ShipAdd5
|
STRTYPE (41)
|
Fifth Line of Ship to Address
|
|
ShipCity
|
STRTYPE (31)
|
City Name
|
|
ShipState
|
STRTYPE
(21)
|
State or Province name in address
|
|
ShipPostalCode
|
STRTYPE
(13)
|
Postal or Zip code in address
|
|
ShipCountry
|
STRTYPE
(31)
|
Country in the Ship to address
|
|
ShipNote
|
STRTYPE (41)
|
the Note field value is written at the bottom of the address
|
|
IsPending
|
BOOLTYPE
(true or false)
|
If IsPending is set to true, the invoice has not been completed.
|
|
IsFinanceCharge
|
BOOLTYPE
(true or false)
|
a finance-charge item has been added to the invoice.
|
|
PO Number
|
STRTYPE (25)
|
Purchase Order number in QuickBooks
|
|
TermsRef
|
STRTYPE (31)
|
Will default to QuickBooks customers if left blank
|
|
ClassRef
|
STRTYPE (159)
|
In QuickBooks, classes give you a way to classify your transactions.
|
|
ShipDate
|
DATETYPE
|
The date when the product was, or will be, shipped.
|
|
SalesRepRef
|
STRTYPE (5)
|
A sales representative initials must be on the Employee, Vendor, or Other Names list within QuickBooks.
|
|
FOB
|
STRTYPE (13)
|
QuickBooks uses the term FOB, freight on board, to indicate the place from which the product is shipped
|
|
Due Date
|
DATETYPE
|
If DueDate is not included in an InvoiceAdd request, QuickBooks might determine the due date according to the terms set for this customer
|
|
ShipMethodRef
|
STRTYPE (15)
|
A shipping method, for example, standard mail or overnight delivery.
|
|
CustomerMsg
|
STRTYPE (101)
|
A standard message
|
|
IsToBePrinted
|
BOOLTYP (true or false)
|
Boolean flag used in QuickBooks to prompt user to print the form
|
|
IsToBeEmailed
|
BOOLTYP (true or false)
|
Prompt user to email this invoice from QuickBooks, customer needs to have email address
|
|
IsTaxIncluded
|
BOOLTYPE
(true or false)
|
Flag to determine whether the amounts are inclusive or exclusive of tax. Only for CA, UK and AU editions of QuickBooks.
|
|
CustomerTaxCodeRef
|
STRTYPE (3)
|
Refers to the sales-tax code for sales related to this customer.
|
|
Memo
|
STRTYPE (4095)
|
Message that appears in reports, but not on the invoice
|
|
ExchangeRate
|
FLOAT
|
The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the "home" currency
|
|
ItemRef
|
STRTYPE
|
MANDATORY FIELD FOR ZA
ItemRef can refer to an item on any Item list (ItemDiscount, ItemInventory, and so on). ZA will look for Items in QuickBooks, if not recognised then it will create a new item according to the settings.
|
|
Description
|
STRTYPE (4095)
|
A descriptive text field for the Item
|
|
Rate
|
PRICETYPE (13)
|
This data type always assumes there is a decimal point. Decimal values include amounts, quantities, and percents. They can be positive or negative.
|
|
LineClass
|
STRTYPE (159)
|
Classes can be used to separate transactions into meaningful categories
|
|
Quantity
|
QUANTYPE
|
QUANTYPE is a decimal value that refers to how much of something exists.
|
|
UnitOfMeasure
|
STRTYPE (31)
|
The name of the unit of measure selected from within the item's available units
|
|
SalesTaxCodeRef
|
STRTYPE (3)
|
Each item on a sales form is assigned a sales-tax code that indicates whether the item is taxable or non-taxable, and why
|
|
Amount
|
8.5 format
|
decimal value that represents an amount
|
|
Service Date
|
DATETYPE
|
Indicates the date on which the QuickBooks user performs the service for the customer.
|
|
Other1
|
STRTYPE (29)
|
The Other1 custom field fields exist at the line item level
|
|
Other2
|
STRTYPE (29)
|
< |