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