Units Table Format (UN)

Follow Vision specifications for preparing a file containing Unit items.

Field Name Data Type Length Notes
AvailableForPlanning varchar 1 Flag indicating whether Available for Project Planning is selected for this unit table.
AvailableForTimesheet varchar 1 Flag indicating whether the Available for Timesheet option is selected for this unit row in the unit table. The setting is N if the unit is linked to an inventory item.
BillingCurrecyCode nvarchar 3 The billing currency for the billing rate.
BillingRate decimal 19,4 Billing rate per unit to use.
Company nvarchar 14 The company whose unit table this is.
ConsolBill varchar 1 Flag indicating whether to consolidate billing on the invoice.
ConsolCost varchar 1 Flag indicating whether to consolidate cost detail on the invoice.
CostRate decimal 19,4 Cost rate per unit.
CreditAccount nvarchar 13 Account to credit with the sum of costs to the unit.
CreditWBS1 nvarchar 30 Project to credit with the sum of costs to the unit.
CreditWBS2 nvarchar 7 The reference field for the project phase. This column is populated by Vision once the CreditWBS1 column in this table is filled in.
CreditWBS3 nvarchar 7 The reference field for the project task. This column is populated by Vision once the CreditWBS1 column in this table is filled in.
EmployeeSpecificRevenue varchar 1 Determines whether the unit will allow employee association for revenue.
FilterCode nvarchar 10 The Unit Table's code, from the CFGUnitTableCode table.
FilterOrg nvarchar 14 The code for the organization associated with the TableNo. This code works as a filter, enforcing record-level access for this table.
FilterPrincipal nvarchar 20 The Employee ID of the principal associated with the TableNo. This code works as a filter, enforcing record-level access for this table.
FilterProjMgr nvarchar 20 The Employee ID of the project manager associated with the TableNo. This code works as a filter, enforcing record-level access for this table.
FilterSupervisor nvarchar 20 The Employee ID of the supervisor associated with the TableNo. This code works as a filter, enforcing record-level access for this table.
Format varchar 1 Variable indicating the billing line format. Valid options are 1-Name only, 2-Name and detail, 3-Detail only.
Item nvarchar 30 Inventory item associated with the unit. Only applicable when using Vision Inventory.
Name nvarchar 40 Name for the unit.
OHAccount nvarchar 13 Default account to use when an overhead project is specified in data entry.
PluralLabel nvarchar 10 Label to use when more than one unit is specified.
PostAccount nvarchar 13 Posting account to use when generating the invoice.
ProjectCurrecyCode nvarchar 3 The project currency for the cost rate.
RegAccount nvarchar 13 Default account to use when a regular project is specified in data entry.
ShowDate varchar 1 Flag indicating whether to show the transaction date on the invoice.
SingleLabel nvarchar 10 Label to use when just one unit is specified.
ShowCalc varchar 1 Flag indicating whether to show calculations on the invoice.
Status varchar 1 The unit's Status, from the CFGUnitStatus Table.
Unit nvarchar 11 Unit number.
UnitTable nvarchar 30 Unit table.
UnitType nvarchar 10 Unit type.