...
*Indicates validated fields, and must contain data.
** New rules for change order type
| Note |
|---|
'Posting Status' (6,F) must have a value of 2, or be empty. |
| Tab Position (.txt file) | Excel Column (.csv file) | Field Name | Storage Type | Keyable | Storage |
|---|---|---|---|---|---|
1 | A | *WS Job Number | String | 17 | 18 |
2 | B | Project Number | String | 17 | 18 |
3 | C | *Change Order # | String | 14 | 16 |
4 | D | *Change Order Status | Drop-Down List | 1 | 1 |
5 | E | *Change Order Type** | Drop-Down List | 1 | 1 |
6 | F | Posting Status | Integer | 1 | 1 |
7 | G | *Change Order Description | String | 30 | 32 |
8 | H | Change Order Estimated Cost | Currency | 14 | 14 |
9 | I | Confirmed Modified Date | Date | 8 | 8 |
10 | J | Confirmed Modified User ID | String | 15 | 16 |
11 | K | User Defined CO 1 | String | 15 | 16 |
12 | L | User Defined CO 2 | String | 15 | 16 |
13 | M | User Defined CO 3 | String | 15 | 16 |
14 | N | User Defined CO 4 | String | 15 | 16 |
15 | O | User Defined Date 1 | Date | 8 | 8 |
16 | P | User Defined Date 2 | Date | 8 | 8 |
17 | Q | User Defined Date 3 | Date | 8 | 8 |
18 | R | User Defined Date 4 | Date | 8 | 8 |
19 | S | Posting Date | Date | 8 | 8 |
20 | T | Change Order Maximum Amount | Currency | 14 | 14 |
Anchor
Update to Change Order Rules
...