|
Field Name
|
Format
|
Description
|
|
Reference No
| The text should be of Max Length: 20 Characters | Reference number for the transaction. By default, this value is used only for internal processing by Dancing Numbers (Desktop), and QuickBooks auto-generates a new value. It can be changed in the import settings. |
|
Vendor*
| The text should be Max Length: of 41 Characters | Name of the Vendor / Customer / Employee for the transaction.
Reference can be checked by Full Name, First Name, Company Name, Account NO., Tax Id, Custom Field, Lookup (configured via Import Settings) |
|
Date
| Date | The date on which transactions happen. |
|
Due Date
| Date |
Due date of the payment.
|
|
Term
| |
Related to the terms for the transactions.
|
|
Address Line 1
| Max text length of 41 characters |
Address’s first line
|
|
Address Line 2
| Name of the Vendor / Customer / Employee for the transaction.
Reference can be checked by Full Name, First Name, Company Name, Account NO., Tax ID, Custom Field, Lookup (configured via Import Settings) |
Address’s Second.
|
|
City
| Need to be in Text and Max Length of 31 Characters |
City name.
|
|
Country
| It should be in text & the length is 21 Characters |
Country name.
|
|
State
| Text and Max Length is 21 Characters | The region in a country. |
|
Postal Code
| Text with Max Characters Length 13 |
Postal code
|
|
Credit Card Account*
| Reference Text (Max Length should be 159 Characters) |
Name of the Credit Card Account for the transaction.
|
|
Memo
| Need to be in text and Max Length is 4095 Characters |
Transaction’s note
|
|
Expense Account**
| Reference Text and Max Length of 159 Characters | Expense Account Name related to the billing. |
|
Expense Amount**
| Decimal | The expense is related to the amount. |
|
Expense Memo
| Text (Max Length: 4095 Characters) |
The Note of the expense.
|
|
Expense Customer
| Reference Text with Max Length of 41 Characters | Customer associated with the expense.
Customer reference can be checked by Full Name, First Name, Company Name, Account NO., Resale NO., Custom Field, Lookup(configured via Import Settings) |
|
Expense Billable
| Billable, HasBeenBilled, NotBillable, |
Billable status of the expense.
|
|
Expense Class
| Reference Text and Max Length of 159 Characters |
Class for the Expense.
|
|
Expense Sales Rep
| Reference Text (Max Length: 5 Characters) | Reference to the Sales rep related to expense |
|
Product/Service**
| Reference Text | Reference to the Item.
It can be checked by Full Name, Lookup, Custom Field, (it can be configured through Import Settings) |
|
Inventory Site
| Reference Text (Max Length: 31 Characters) |
Related to the Item Site
|
|
Inventory BIN
| Reference Text (Max Length: 31 Characters) |
Related to the Item BIN referenced to the Site. Should be specified in the Site: BIN format.
|
|
Unit of Measure
| Reference text |
Measuring unit of Product
|
|
Product/Service Quantity
| Decimal |
Quantity of the Item.
|
|
Product/Service Rate
| Decimal |
Unit Price of the Item.
|
|
Product/Service Amount**
| Decimal |
Total Amount of the Item. It is not required if Line Item Quantity & Line Item Rate is available.
|
|
Serial No
| Reference to text and numbers |
Serial number of product
|
|
Lot No
| Reference to text |
Identification number assigned to a particular quantity
|
|
Product/Service Description
| Text (Max Length should be: 4095 Characters) |
Description of the Item
|
|
Product/Service Customer
| Reference to the Sales rep related to the Product | Reference to the Customer related with the expense. |
|
Product/Service Billable
| Billable, HasBeenBilled, NotBillable, |
The billable status of the line item.
|
|
Product/Service Sales Rep
| Reference Text (Max Length: 5 Characters) | Currency Related to the product |
|
Product/Service Class
| Reference Text (Max Length: 159 Characters) |
Class name for the Item.
|
|
Exchange Rate
| Decimal |
Exchange rate of the product
|
| Currency | Text Currency Code |
Currency Related with the product
|
