job

Type: table

Columns

Column	Type	Attributes	Description
accountrowid	int
actualenddate	datetime
actualstartdate	datetime
addressrowid	int
approvalrequired	smallint
approverrelationshiprowid	int
balance	decimal
billerelationshiprowid	int
billwithjobrowid	int
budgetamount	decimal
businessmanagerrelationshiprowid	int
cogsmethod	varchar
companyrowid	int
contactrowid	int
contractnbr	varchar
currencyratetypelistitemrowid	int
currencyrowid	int
description	varchar
expenseclassrowid	int
expensemarkuppercent	decimal
holdpayment	smallint
invoicedocumentformatrowid	int
isactive	tinyint
jobid	varchar
jobstatuslistitemrowid	int
jobtypelistitemrowid	int
lastbilldate	datetime
lastpercentcompletedate	datetime
noterowid	int
percentcomplete	decimal
ponbr	varchar
pricelevelrowid	int
projectedenddate	datetime
projectedstartdate	datetime
projectmanagerrelationshiprowid	int
relationshiprowid	int
retentionmethodid	varchar
retentionpercent	decimal
revenuerecognitionaccounttypes	varchar
revenuerecognitionbasis	varchar
revenuerecognitionlevel	varchar
revenuerecognitiontypeid	varchar
rowid	int	auto_increment
salesclassrowid	int
taskrowid	int
transactionrowid	int
updatetimestamp	timestamp	on update CURRENT_TIMESTAMP
userrowid	int

v.ismain -- Wed, Feb 28, 2018 2:58 PM