Import Matrix: Broadcast Items
Technical Documentation
Available Fields
Active
Billing Item ID
Class ID
Commission
Department
Expense Account Number
Item ID
Item Name
Sales Account Number
Standard Description
Tax 1 Applies
Tax 2 Applies
Matrix
|
Field Name |
Key Field |
Required |
Valid Values |
Table Validation |
Table |
Field Validation |
Comments |
|
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 |
|
Commission |
|
|
Numeric |
|
|
|
|
|
Department |
|
See Comments |
|
Yes |
Departments |
Department ID |
If Require Department GL Tracking Options is Yes then Department must be a valid Class |
|
Expense Account Number |
|
|
|
Yes |
GL Accounts |
Account Number |
|
|
Active |
|
|
Yes No |
|
|
|
|
|
Item ID |
Yes |
Yes |
|
|
|
|
|
|
Item Name |
|
Yes |
|
|
|
|
|
|
Sales Account Number |
|
|
|
Yes |
GL Accounts |
Account Number |
|
|
Standard Description |
|
|
|
|
|
|
|
|
Tax 1 Applies |
|
|
Yes No |
|
|
|
|
|
Tax 2 Applies |
|
|
Yes No |
|
|
|
|