Unit Data Entry Table Formats (DEUnit)
Follow DPS specifications for preparing a file containing Unit Data Entry items.
Field Name | Data Type | Notes |
---|---|---|
Unit | varchar | |
TransDate | datetime | |
WBS1 | varchar | |
WBS2 | varchar | |
WBS3 | varchar | |
UnitTable | varchar | |
Account | varchar | |
DetailDescription | varchar | |
Quantity | decimal | When importing a unit quantity that has more than three decimal places, DPS will round it to the third decimal. |
Employee | varchar | |
Employee Company | varchar | If you have multiple companies, you can specify the company to which the employee record is mapped. |