Import Matrix: Purchase Items
Technical Documentation
Available Fields
Active
Always use Unit Rate for Gross Amount
Billing Item ID
Class ID
Department
Expense Account Number
Item ID
Item Name
Markup
Quantity On Hand
Sales Account Number
Standard Description
Tax 1 Applies
Tax 2 Applies
Unit Cost
Unit Description
Unit Rate
Matrix
Field Name |
Key Field |
Required |
Valid Values |
Table Validation |
Table |
Field Validation |
Comments |
Markup |
|
|
Numeric |
|
|
|
|
Always use Unit Rate for Gross Amount |
|
|
Yes No |
|
|
|
|
Billing Item ID |
|
|
|
Yes |
Billing Items |
Billing Item ID |
|
Class ID |
|
See Comments |
|
Yes |
GL Classes |
Class ID |
If Require Class in the GL Tracking Options is Yes then Class ID must be a valid Class |
Department |
|
See Comments |
|
Yes |
Departments |
Department ID |
If Require Department in the GL Tracking Options is Yes then Department must be a valid Department |
Expense Account Number |
|
|
|
Yes |
GL Accounts |
Account Number |
|
Item ID |
Yes |
Yes |
|
|
|
|
|
Item Name |
|
Yes |
|
|
|
|
|
Active |
|
|
Yes No |
|
|
|
|
Quantity On Hand |
|
|
Numeric |
|
|
|
|
Sales Account Number |
|
|
|
Yes |
GL Accounts |
Account Number |
|
Standard Description |
|
|
|
|
|
|
|
Tax 1 Applies |
|
|
Yes No |
|
|
|
|
Tax 2 Applies |
|
|
Yes No |
|
|
|
|
Unit Cost |
|
|
Numeric |
|
|
|
|
Unit Description |
|
|
|
|
|
|
|
Unit Rate |
|
|
Numeric |
Yes |
|
|
This field is only used it the “Always us Unit Rate for Gross Amount” is Yes |