Record Type Five (5) - Material Record

 

Column

Max. Size

Type

Sample Mask

Description

NOTES

1

1

Alpha Numeric

 

Record Type

Specifies the type of record (i.e. 1,2,3,4,5).

2

10

Alpha Numeric

 

Project Code

Estimate or project code imported from.

3

16

Alpha Numeric

 

Item

Item code to be imported as contract item.

4

30

Alpha Numeric

 

Phase code

May set up cross reference to Viewpoint codes.

5

30

Alpha Numeric

 

Cost type

Cost type

6

16

Numeric

##########.##

Quantity

No commas, rounded to Viewpoint precision.

7

30

Alpha Numeric

 

Unit of measure

May be cross referenced to Viewpoint codes.

8

16

Numeric

##########.##

Unit price

No commas, rounded to Viewpoint precision.

9

1

Alpha Numeric

 

Per E,C,M

(E,C,M) Default is E.

10

30

Alpha Numeric

 

Material code

May be cross referenced to Viewpoint codes.

11

30

Alpha Numeric

 

Vendor code

May be cross referenced to Viewpoint codes.

12

30

Alpha Numeric

 

Description

Material description

13

8000

String

 

Notes

Material detail notes