| |
AVAILABLE FIELDS |
TYPE |
|
| |
Area |
Numeric |
Id of the Linked Area |
| |
AreaText |
Text (50) |
Title of the linked Area |
| |
Id |
Numeric |
|
| |
InvoiceDescription |
Text (100) |
|
| |
KeyDate |
Date |
|
| |
KeyDateTimeZone |
Numeric |
|
| |
KeyDateTimeZoneText |
Text (50) |
|
| |
Notes |
Text (2000) |
|
| |
Order |
Numeric |
Id of the linked Order |
| |
OrderText |
Text (50) |
Reference of the linked Order |
| |
ParentOrderItem |
Numeric |
|
| |
ParentOrderItemText |
Text (50) |
|
| |
PriceType |
Numeric |
1=Retail,2=Wholesale |
| |
PriceTypeText |
Text (50) |
See above |
| |
Product |
Numeric |
Id of the linked Product |
| |
ProductText |
Text (50) |
Title of the linked Product |
| |
Quantity |
Numeric |
|
| |
Reference |
Text (50) |
|
| |
Store |
Numeric |
Id of the linked Store |
| |
StoreText |
Text (50) |
Title of the linked Store |
| |
TaxType |
Numeric |
Depends upon your country. For Australia, 1=GST Applies,2=GST Free - Export,3=GST Free - Other,4=GST Free - Input Taxed,5=GST Free - Exclude |
| |
TaxTypeText |
Text (50) |
See above |
| |
TotalCost |
Numeric |
|
| |
TotalTax |
Numeric |
|
| |
UnitCost |
Numeric |
|
| |
Variant |
Numeric |
Variant of the linked Product (if any) |
| |
VariantText |
Text (50) |
Title of the Variant of the linked Product (if any) |
| |
|
|
|
| |
Audit Fields |
|
Click here for more information |