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. |