JC Jobs (JCJM)

JC Jobs Sample Text File

JC Jobs - JCJM

Columns that are typically used for importing are in yellow

Column Name

Type

Importable

Default Available

Length & Scale

Required

Comments

JCCo

bCompany

Yes

Y

1-255

Yes

Job

bJob

Yes

N

10

Yes

Description

bDesc

Yes

N

30

No

Contract

bContract

Yes

Y

10

Yes

JobStatus

tinyint

Yes

Y

1-255

Yes

BidNumber

varchar

Yes

N

10

No

LockPhases

bYN

Yes

Y

1

Yes

ProjectMgr

int

Yes

N

integer

No

JobPhone

bPhone

Yes

N

20

No

JobFax

bPhone

Yes

N

20

No

MailAddress

varchar

Yes

N

60

No

MailCity

varchar

Yes

N

30

No

MailState

bState

Yes

N

2

No

MailZip

bZip

Yes

N

12

No

MailAddress2

varchar

Yes

N

60

No

ShipAddress

varchar

Yes

Y

60

No

ShipCity

varchar

Yes

Y

30

No

ShipState

bState

Yes

Y

2

No

ShipZip

bZip

Yes

Y

12

No

ShipAddress2

varchar

Yes

Y

60

No

LiabTemplate

smallint

Yes

N

smallint

No

TaxGroup

bGroup

Yes

Y

1-255

Yes

TaxCode

bTaxCode

Yes

N

10

No

InsTemplate

smallint

Yes

N

smallint

No

MarkUpDiscRate

bRate

Yes

Y

numeric

Yes

PRLocalCode

bLocalCode

Yes

N

10

No

PRStateCode

bState

Yes

Y

2

No

Certified

bYN

Yes

Y

1

Yes

OverTimeFlag

char

Yes

N

1

No

EEORegion

char

Yes

N

8

No

SMSACode

char

Yes

N

10

No

CraftTemplate

smallint

Yes

N

smallint

No

ProjMinPct

bPct

Yes

Y

numeric

Yes

Reviewer

varchar

Yes

N

3

No

Notes

bNotes

Yes

N

text

No

ComGroup

varchar

Yes

N

10

No

SLCompGroup

varchar

Yes

N

10

No

POCompGroup

varchar

Yes

N

10

No

VendorGroup

bGroup

Yes

N

1-255

No

ArchEngFirm

bFirm

Yes

N

integer

No

OTSched

tinyint

Yes

N

1-255

No

PriceTemplate

smallint

Yes

N

smallint

No

HaulTaxOpt

tinyint

Yes

Y

1-255

Yes

GeoCode

varchar

Yes

N

10

No

BaseTaxOn

varchar

Yes

Y

1

Yes

UpdatePlugs

bYN

Yes

Y

1

Yes

UniqueAttchID

uniqueidentifier

No

N

No

ContactCode

bEmployee

Yes

N

integer

No

ClosePurgeFlag

bYN

Yes

N

1

No

OurFirm

bFirm

Yes

N

integer

No

AutoAddItemYN

bYN

Yes

N

1

Yes

OverProjNotes

varchar

Yes

N

8000

No

WghtAvgOT

bYN

Yes

Y

1

Yes

HrsPerManDay

bUnits

Yes

Y

numeric

Yes

AutoGenSubNo

varchar

Yes

N

1

Yes

SecurityGroup

smallint

Yes

Y

smallint

No

Table Guidelines

The definition of each of the table’s columns is outlined below.

  • Column Name – The name of the column/field in the database table.

  • Type – The column’s SQL data type. Types starting with a “b” are Viewpoint defined data types.

  • Importable – The field is available for import.

  • Default Available – Indicated if a programmatic default value is available for this field. Defaults use the same logic as a posting program to determine a value.

  • Length and Scale – Indicates the format of the field.

  • Required – Indicates if the data is required.

    A hard coded default value can be specified in IM Template; when importing files this value overwrites the imported value.

    Note:

    Use the Template Detail tab in the IM Template form to add any additional fields for importing.