Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

*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 NameStorage TypeKeyableStorage

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 = Confirmed
2 = In-Process
3 = Pending
4 = User Defined 2
5 = User Defined 3

1

1

5

E

*Change Order Type**

Drop-Down List
1 = Fixed Amount
2 = Cost Plus
3 = Cost Plus NTE

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

Anchorsignature_utilities_change_order_377signature_utilities_change_order_377**

Update to Change Order Rules

If you are using the RPO revenue recognition method, the updated change order rules were implemented in the Signature 2016 R3 release. The change orders that can be created are limited based on the job's contract type:

Job Type

Change Order Type

Fixed

Fixed, Cost Plus

Cost Plus

N/A - None

Cost Plus NTE

Cost Plus NTE*

...