Vendor Name | Str 41 | Name of vendor company, MANDATORY |
AP Account | Str 159 | Accounts payable file, if not mapped will default to AP Account |
Txn Date | Date | Date of the bill |
Due Date | Date | Date the bill is due for payment |
Ref Number | Str20 | Reference number of the bill |
Terms | Str31 | Vendors payment terms |
Memo | Str4095 | Memo for the bill |
Is Tax Included | Bool | true or false - When tax is included in amounts (CA, UK and AU only) |
Exchange Rate | Float | Exchange rate to home currency |
Link To Purchase Order | Str 31 | The purchase order number to link the whole bill to more |
Account | Str159 | Expenses Account (from Chart of Account list), full name required |
Expense Amount | Amt | Amount for that line. |
Expense Memo | Str 4095 | Expense line memo |
Customer Name | Str 209 | CustomerJob name |
Class Name | Str 159 | Class name |
Expense Sales Tax Code | Str 3 | Sales Tax code for the Expense account line |
Billable Status | Enum | Whether the line is Billable, NotBillable or HasBeenBilled |
Sales Rep FullName | Str | Name of the Sales Rep as appears in the QuickBooks Sales Rep list |
Data Ext Name1 | Str | Name of the Custom field 1 read more |
Data Ext Value1 | Str | Value for the Custom field 1 |
Data Ext Name2 | Str | Name of the Custom field 2 |
Data Ext Value2 | Str | Value for the Custom field 2 |
Item Full Name | Str | Item purchased on the bill, full name required |
Txn ID | guid | Transaction ID |
Txn Line ID | guid | Transaction Line ID |
Description | Str4095 | Description for the Item purchased |
Quantity | Quan | Quantity of the item purchased |
Unit Of Measure | Str31 | Unit of measure for the item purchased |
Cost | Price | Cost of the item purchased |
Item Amount | Amt | Line total of the item |
Item Customer | Str209 | CusotmerJob |
Item Class | Str159 | Class of line item |
Item Sales Tax Code | Str3 | Item sales tax code, true or false - When tax is included in amounts (CA, UK and AU only) |
Item Billable Status | enum | Item billable status Billable, NotBillable or HasBeenBilled |
Item Sales Rep FullName | Str | Name of the Sales Rep as appears in the QuickBooks Sales Rep list |
Item Data Ext Name1 | Str | Name of the Custom field 1 read more |
Item Data Ext Value1 | Str | Value for the Custom field 1 |
Item Data Ext Name2 | Str | Name of the Custom field 2 |
Item Data Ext Value2 | Str | Value for the Custom field 2 |
Override Item Account | Str209 | |
Freight | Amt | The amount of freight charge on the bill see more on shopping cart fields |
Insurance | Amt | The amount of insurance charged on the bill see more on shopping cart fields |
Line Link To Purchase Order | Str 31 | Specify the reference number of the purchase order that you wish to line link to more |
Item Lot Number | Str 40 | The Lot Number for the item |
item Serial Number | Str 4095 | The Serial Number for the item (for multiple number on the same item separate by a comma) more here |
Item Expiration Date | Date | The Expiration date for the item (date in the format yyyy-mm-dd) |