|
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)
|
<
|