Service Director Tables

tblSvActivityStatus -- SV Activity Status table

Column Name	Column Type	Length	Enumeration
ID	tinyint	1
Description	pDescription	255
ActivityDispatchStatus	tinyint	1	0 = Open, 1 = Completed, 2 = Billed, 3 = Posted, 4 = NA
Action	tinyint	1	0 = None, 1 = System, 2 = Hold, 3 = Release, 4 = Cancel, 5 = Reopen, 6 = Complete
Sequence	tinyint	1
CF	xml	-1
ts	timestamp	8

tblSvAttachmentLocal -- SV Local Attachment table

Column Name	Column Type	Length	Default Value
ID	bigint	8
DispatchID	bigint	8
WorkOrderID	bigint	8
AttachmentId	int	4
EntryDate	datetime	8
Keywords	nvarchar	255
Comment	nvarchar	max
DocumentName	nvarchar	255
Document	varbinary	max
TechID	bigint	8
HostID	nvarchar	20
SynchID	bigint	8
Synched	bit	1	0
CF	xml	-1
ts	timestamp	8

tblSvBillingType -- SV Billing Type table

Column Name	Column Type	Length	Default Value
BillingType	nvarchar	10
Description	pDescription	255
BillableYN	bit	1	-1
CF	xml	-1
ts	timestamp	8

tblSvEquipment -- SV Equipment table

Column Name	Column Type	Length	Default Value	Description	Enumeration
ID	bigint	8
GeneralEquipmentID	bigint	8
EquipmentNo	nvarchar	24
Description	pDescription	255
ItemID	pItemID	24
SerialNumber	pSerNum	35
TagNumber	nvarchar	255
SiteYN	bit	1	0
CustID	pCustID	10
SiteID	pLocID	10
Manufacturer	pDescription	255
Model	pDescription	255
CategoryID	nvarchar	12
Status	tinyint	1	0	Equipment Status	0 = Active, 1 = Inactive, 2 = Deleted
Usage	tinyint	1	0	Equipment Usage	0 = All, 1 = Customer, 2 = Company
ServiceContractCharge	pDecimal	13	0
Ownership	tinyint	1	0	Equipment Ownership	0 = None, 1 = Customer, 2 = Company
AssetID	pAssetID	15
GLAcctExpense	pGlAcct	255
AdditionalDescription	nvarchar	max
CF	xml	-1
ts	timestamp	8

tblSvEquipmentActivity -- SV Equipment Activity table

Column Name	Column Type	Length	Description	Enumeration
ID	int	4
EquipmentID	bigint	8
Type	tinyint	1	Equipment Activity Type	0 = Purchase, 1 = Sale, 2 = Transfer
Description	pDescription	255
ContactID	nvarchar	10
SiteID	pLocID	10
ContactName	nvarchar	30
Address1	nvarchar	30
Address2	nvarchar	60
City	nvarchar	30
Region	nvarchar	10
Country	pCountry	6
PostalCode	nvarchar	10
Phone	nvarchar	15
Fax	nvarchar	15
OrderDate	datetime	8
ShipDate	datetime	8
InvoiceDate	datetime	8
OrderNumber	nvarchar	25
InvoiceNumber	pInvoiceNum	15
Price	pDecimal	28,10
CF	xml	-1
ts	timestamp	8

tblSvEquipmentCategory -- SV Equipment Category table

Column Name	Column Type	Length
CategoryID	nvarchar	12
Description	pDescription	255
CF	xml	-1
ts	timestamp	8

tblSvEquipmentKnowledgebase -- SV Equipment Knowledgebase table

Column Name	Column Type	Length
ID	int	4
EquipmentID	bigint	8
Description	pDescription	255
AdditionalDescription	nvarchar	max
Resolution	nvarchar	max
EntryDate	datetime	8
EnteredBy	pUserID	20
WorkOrderNo	pTransID	8
CF	xml	-1
ts	timestamp	8

tblSvEquipmentParts -- SV Equipment Parts table

Column Name	Column Type	Length
ID	int	4
EquipmentID	bigint	8
PartNo	nvarchar	24
ItemID	pItemID	24
Description	pDescription	255
Qty	pDecimal	28,10
EstimatedCost	pDecimal	28,10
PreferredVendor	pDescription	255
LeadTime	pDecimal	28,10
CF	xml	-1
ts	timestamp	8

tblSvEquipmentService -- SV Equipment Service table

Column Name	Column Type	Length	Default Value	Description	Enumeration
ID	int	4
EquipmentID	bigint	8
WorkToDoID	nvarchar	10
ScheduleType	tinyint	1	0	Schedule Type	0 = Year, 1 = Month, 2 = Day
ScheduleInterval	tinyint	1	0
ScheduleAutoPrompt	tinyint	1	0
ScheduleStartDate	datetime	8
ScheduleEndDate	datetime	8
ScheduleNextDate	datetime	8
CF	xml	-1
ts	timestamp	8

tblSvEquipmentWarranty -- SV Equipment Warranty table

Column Name	Column Type	Length	Default Value	Description	Enumeration
ID	int	4
EquipmentID	bigint	8
CoverageType	tinyint	1	0	Coverage Type	0 = None, 1 = Labor / Parts, 2 = Labor, 3 = Parts
IntervalType	tinyint	1	0	Interval Type	0 = Year, 1 = Month, 2 = Day
Interval	tinyint	1	0
StartDate	datetime	8
EndDate	datetime	8
CF	xml	-1
ts	timestamp	8

tblSvHistoryWorkOrder -- SV Work Order History table

Column Name	Column Type	Length	Default Value	Enumeration
ID	bigint	8
PostRun	pPostRun	14
WorkOrderNo	pTransID	8
OrderDate	datetime	8
CustID	pCustID	10
SiteID	pLocID	10
Attention	nvarchar	30
Address1	nvarchar	30
Address2	nvarchar	60
City	nvarchar	30
Region	nvarchar	10
Country	pCountry	6
PostalCode	nvarchar	10
TerrId	nvarchar	10
Phone1	nvarchar	15
Phone2	nvarchar	15
Phone3	nvarchar	15
Email	nvarchar	255
Internet	nvarchar	255
Rep1Id	pSalesRep	3
Rep1Pct	pDecimal	13
Rep2Id	pSalesRep	3
Rep2Pct	pDecimal	13
Rep1CommRate	pDecimal	13
Rep2CommRate	pDecimal	13
BillingType	nvarchar	10
BillableYN	bit	1
CustomerPoNumber	nvarchar	25
PODate	datetime	8
OriginalWorkOrder	pTransID	8
BillByWorkOrder	bit	1
FixedPrice	bit	1
BillingFormat	nvarchar	255
ProjectID	nvarchar	10
PhaseID	nvarchar	10
TaskID	nvarchar	10
CF	xml	-1
BillVia	tinyint	3	0	0 = SD, 1 = PC

tblSvHistoryWorkOrderActivity -- SV Work Order Activity History table

Column Name	Column Type	Length	Description	Enumeration
ID	int	4
DispatchID	bigint	8
WorkOrderID	bigint	8
ActivityType	tinyint	1	Work Order Activity Type	0 = Request Received, 1 = Scheduled, 2 = Dispatched, 3 = Arrived / Started, 4 = Completed, 5 = Billed, 6 = Unbilled, 7 = Posted, 8 = Canceled, 9 = Reopened
ActivityDateTime	datetime	8
TechID	pEmpID	11
Duration	bigint	8
EntryDate	datetime	8
EnteredBy	pUserID	20
Notes	nvarchar	max
StatusDescription	pDescription	255
CF	xml	-1

tblSvHistoryWorkOrderDispatch -- SV Work Order Dispatch History table

Column Name	Column Type	Length	Description	Enumeration
ID	bigint	8
WorkOrderID	bigint	8
DispatchNo	int	4
Description	pDescription	255
EquipmentID	bigint	8
EquipmentDescription	pDescription	255
BillingType	nvarchar	10
BillableYN	bit	1
BillToID	pCustID	10
RequestedDate	datetime	8
RequestedAMPM	tinyint	1	Requested AM / PM	0 = None, 1 = AM, 2 = PM
RequestedTechID	pEmpID	11
CancelledYN	bit	1
EstTravel	bigint	8
SchedApproved	bit	1
EntryDate	datetime	8
Counter	int	4
LocID	pLocID	10
SourceId	uniqueidentifier	16
PostRun	pPostRun	14
StatusID	tinyint	1
StatusDescription	pDescription	255
CF	xml	-1

tblSvHistoryWorkOrderDispatchWorkToDo -- SV Work Order Dispatch Work To Do History table

Column Name	Column Type	Length
ID	int	4
DispatchID	bigint	8
WorkOrderID	bigint	8
WorkToDoID	nvarchar	10
GroupID	nvarchar	10
Description	pDescription	255
EstimatedTime	bigint	8
SkillLevel	tinyint	1
CF	xml	-1

tblSvHistoryWorkOrderReferral -- SV Work Order Referral History table

Column Name	Column Type	Length
ID	bigint	8
CustID	pCustID	10
CompanyName	nvarchar	30
ContactName	nvarchar	30
Address1	nvarchar	30
Address2	nvarchar	60
City	nvarchar	30
Region	nvarchar	10
Country	pCountry	6
PostalCode	nvarchar	10
Phone	nvarchar	15
Fax	nvarchar	15
Email	nvarchar	255
Internet	nvarchar	255
Notes	nvarchar	max
CF	xml	-1

tblSvHistoryWorkOrderTrans -- SV Work Order Transaction History table

Column Name	Column Type	Length	Description	Enumeration
ID	bigint	8
DispatchID	bigint	8
WorkOrderID	bigint	8
TransType	tinyint	1	Transaction Type	0 = Labor, 1 = Part, 2 = Freight, 3 = Misc
ResourceID	nvarchar	24
LaborCode	nvarchar	10
Description	pDescription	255
LocID	pLocID	10
EntryDate	datetime	8
TransDate	datetime	8
FiscalYear	smallint	2
FiscalPeriod	smallint	2
AdditionalDescription	nvarchar	max
QtyEstimated	pDecimal	13
QtyUsed	pDecimal	13
Unit	nvarchar	5
UnitCost	pDecimal	13
UnitPrice	pDecimal	13
CostExt	pDecimal	13
PriceExt	pDecimal	13
TaxClass	tinyint	1
GLAcctCredit	pGlAcct	40
GLAcctDebit	pGlAcct	40
GLAcctSales	pGlAcct	40
HistSeqNum	int	4
QtySeqNum_Cmtd	int	4
QtySeqNum	int	4
LinkSeqNum	int	4
EntryNum	int	4
CF	xml	-1

tblSvHistoryWorkOrderTransExt -- SV Extended Work Order Transaction History table

Column Name	Column Type	Length
ID	int	4
TransID	bigint	8
LotNum	pLotNum	16
ExtLocA	int	4
ExtLocB	int	4
QtyEstimated	pDecimal	13
QtyUsed	pDecimal	13
UnitCost	pDecimal	13
HistSeqNum	int	4
QtySeqNum_Cmtd	int	4
QtySeqNum_Ext	int	4
QtySeqNum	int	4
Cmnt	nvarchar	35

tblSvHistoryWorkOrderTransSer -- SV Work Order Serial Number Transaction History table

Column Name	Column Type	Length
ID	int	4
TransID	bigint	8
SerNum	pSerNum	35
LotNum	pLotNum	16
ExtLocA	int	4
ExtLocB	int	4
UnitCost	pDecimal	13
UnitCostACV	pDecimal	13
UnitPrice	pDecimal	13
HistSeqNum	int	4
Cmnt	nvarchar	35
CF	xml	-1

tblSvInvoiceDetail -- SV Invoice Detail table

Column Name	Column Type	Length	Default Value	Description	Enumeration
TransID	pTransID	8
EntryNum	int	4
LineSeq	int	4
ResourceID	nvarchar	24
LocID	pLocID	10
Description	pDescription	255
AdditionalDescription	nvarchar	max
TaxClass	tinyint	1
QtyEstimated	pDecimal	13	0
QtyUsed	pDecimal	13	0
Unit	nvarchar	5
UnitCostFgn	pDecimal	13	0
UnitPriceFgn	pDecimal	13	0
CostExtFgn	pDecimal	13	0
PriceExtFgn	pDecimal	13	0
UnitCommBasisFgn	pDecimal	13
UnitCost	pDecimal	13	0
UnitPrice	pDecimal	13	0
CostExt	pDecimal	13	0
PriceExt	pDecimal	13	0
UnitCommBasis	pDecimal	13
GLAcctCredit	pGlAcct	40
GLAcctDebit	pGlAcct	40
GLAcctSales	pGlAcct	40
Rep1Id	pSalesRep	3
Rep1Pct	pDecimal	13	0
Rep1CommRate	pDecimal	13	0
Rep2Id	pSalesRep	3
Rep2Pct	pDecimal	13	0
Rep2CommRate	pDecimal	13	0
WorkOrderTransID	bigint	8
WorkOrderTransType	tinyint	1		Work Order Transaction Type	0 = Labor, 1 = Part, 2 = Freight, 3 = Misc
DispatchID	bigint	8
CatID	nvarchar	2
CF	xml	-1
ts	timestamp	8

tblSvInvoiceDispatch -- SV Invoice Dispatch table

Column Name	Column Type	Length
TransID	pTransID	8
DispatchID	bigint	8
CF	xml	-1
ts	timestamp	8

tblSvInvoiceHeader -- SV Invoice Header table

Column Name	Column Type	Length	Default Value	Description	Enumeration
TransID	pTransID	8
TransType	smallint	2
VoidYN	bit	1	0
BatchID	pBatchID	10
CustID	pCustID	10
BillToID	pCustID	10
TermsCode	pTermsCode	6
DistCode	pDistCode	6
TaxableYN	bit	1	-1
InvoiceNumber	pInvoiceNum	15
InvoiceDate	datetime	8
CustomerPoNumber	nvarchar	25
PODate	datetime	8
WorkOrderNo	pTransID	8
OrderDate	datetime	8
CompletedDate	datetime	8
DiscDueDate	datetime	8
NetDueDate	datetime	8
FiscalYear	smallint	2
FiscalPeriod	smallint	2
Rep1Id	pSalesRep	3
Rep1Pct	pDecimal	13	0
Rep1CommRate	pDecimal	13	0
Rep2Id	pSalesRep	3
Rep2Pct	pDecimal	13	0
Rep2CommRate	pDecimal	13	0
TaxGrpID	pTaxLoc	10
TaxLocAdj	pTaxLoc	10
TaxClassAdj	tinyint	1
TaxSubtotalFgn	pDecimal	13	0
NonTaxSubtotalFgn	pDecimal	13	0
SalesTaxFgn	pDecimal	13	0
TotCostFgn	pDecimal	13	0
TotPmtAmtFgn	pDecimal	13	0
DiscAmtFgn	pDecimal	13	0
TaxAmtAdjFgn	pDecimal	13	0
TaxSubtotal	pDecimal	13	0
NonTaxSubtotal	pDecimal	13	0
SalesTax	pDecimal	13	0
TotCost	pDecimal	13	0
TotPmtAmt	pDecimal	13	0
DiscAmt	pDecimal	13	0
TaxAmtAdj	pDecimal	13	0
BillingFormat	nvarchar	255
CurrencyID	pCurrency	6
ExchRate	pDecimal	13	-1
HoldYN	bit	1	0
SourceId	uniqueidentifier	16
WorkOrderID	bigint	8
PrintStatus	tinyint	1	0	Print Status	0 = Unprinted, 1 = Online, 2 = Batch, 3 = Skip
CF	xml	-1
ts	timestamp	8
*TaxGrpId2	pTaxLoc

tblSvInvoiceTax -- SV Invoice Tax table

Column Name	Column Type	Length	Default Value	Enumeration
TransID	pTransID	8
TaxLocID	pTaxLoc	10
TaxClass	tinyint	1	0
Level	tinyint	1	-1
TaxAmt	pDecimal	13	0
TaxAmtFgn	pDecimal	13	0
Taxable	pDecimal	13	0
TaxableFgn	pDecimal	13	0
NonTaxable	pDecimal	13	0
NonTaxableFgn	pDecimal	13	0
LiabilityAcct	pGlAcct	40
CF	xml	-1
ts	timestamp	8
TaxGroupType	tinyint	1	0	0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2
ExpenseAccount	pGlAcct

tblSvLaborCode -- SV Labor Code table

Column Name	Column Type	Length	Default Value
LaborCode	nvarchar	10
Description	nvarchar	35
AdditionalDescription	nvarchar	max
Unit	nvarchar	5
BillingRate	pDecimal	13	0
UnitCost	pDecimal	13	0
GLAcctSales	pGlAcct	40
GLAcctCost	pGlAcct	40
GLAcctPayroll	pGlAcct	40
TaxClass	tinyint	1
CalendarColor	int	4
CF	xml	-1
ts	timestamp	8

tblSvPaymentLocal -- SV Local Payment table

Column Name	Column Type	Length	Default Value	Description
ID	bigint	8
DispatchID	bigint	8
WorkOrderID	bigint	8
PmtDate	datetime	8
PmtType	tinyint	1
PmtMethodID	nvarchar	10
CcNum	nvarchar	255
CcHolder	nvarchar	30
CcExpire	datetime	8
CcAuth	nvarchar	10
CcRef	nvarchar	255
CheckNum	nvarchar	10
BankName	nvarchar	30
BankRoutingCode	nvarchar	9
BankAcctNum	nvarchar	255
Amount	decimal	28,10
AmountBase	decimal	28,10
CurrencyID	nvarchar	6
VoidDate	datetime	8
TechID	bigint	8
HostID	nvarchar	20
EntryDate	datetime	8
Settled	bit	1
Response	nvarchar	max		information from payment provider
Notes	nvarchar	max
iCap	varbinary	max
InvoiceNumber	nvarchar	15
SynchID	bigint	8
Synched	bit	1	0
CF	xml	-1
ts	timestamp	8
ExtPmtActivityID	bigint	8

tblSvServiceContractDetail -- SV Service Contract Detail table

Column Name	Column Type	Length	Default Value	Description	Enumeration
ID	int	4
ContractID	bigint	8
EquipmentID	bigint	8
CoverageType	tinyint	1	0	Coverage Type	0 = None, 1 = Labor / Parts, 2 = Labor, 3 = Parts
ContractAmount	pDecimal	13	0
CF	xml	-1
ts	timestamp	8

tblSvServiceContractHeader -- SV Service Contract Header table

Column Name	Column Type	Length	Default Value	Description	Enumeration
ID	bigint	8
ContractNo	nvarchar	8
CustID	pCustID	10
Description	pDescription	255
StartDate	datetime	8
EndDate	datetime	8
OriginalContractDate	datetime	8
Notes	nvarchar	max
RecurID	nvarchar	8
BillingType	tinyint	1	2	Billing Type	0 = As Needed, 1 = Days, 2 = Monthly, 3 = Quarterly, 4 = Yearly
NextBillingDate	datetime	8
BillingAmount	pDecimal	13	0
BillingInterval	tinyint	1	0
LastBillingDate	datetime	8
CF	xml	-1
ts	timestamp	8

tblSvSkill -- SV Skill table

Column Name	Column Type	Length
SkillLevel	tinyint	1
Description	pDescription	255
CF	xml	-1
ts	timestamp	8

tblSvSynchTrans -- SV Synchronization Transaction table (local to tablet only)

Column Name	Column Type	Length	Enumeration
SynchID	bigint	8
TransType	smallint	2	0 = Dispatch, 1 = Transaction, 2 = Payment, 3 = DispatchWorkToDo, 4 = Attachment
TransID	bigint	8
ts	timestamp	8

tblSvTechnician -- SV Technician table

Column Name	Column Type	Length	Default Value
TechID	pEmpID	11
ScheduleID	nvarchar	10
LocID	pLocID	10
CrewYN	bit	1	0
Description	pDescription	255
CF	xml	-1
ts	timestamp	8
ID	bigint	8
Password	nvarchar	max

tblSvTechnicianLaborCode -- SV Technician Labor Code table

Column Name	Column Type	Length
ID	int	4
TechID	pEmpID	11
LaborCode	nvarchar	10
SkillLevel	tinyint	1
CF	xml	-1
ts	timestamp	8

tblSvTechnicianRelation -- SV Technician Relation table

Column Name	Column Type	Length
ID	int	4
TechID	pEmpID	11
RelationID	pEmpID	11
CF	xml	-1
ts	timestamp	8

tblSvTechnicianPermission -- SV Technician Permission table

Column Name	Column Type	Length
ID	bigint	8
TechID	bigint	8
FeatureID	bigint	8
CF	xml	-1
ts	timestamp	8

tblSvWorkOrder -- SV Work Order table

Column Name	Column Type	Length	Default Value	Enumeration
ID	bigint	8
WorkOrderNo	pTransID	8
OrderDate	datetime	8
CustID	pCustID	10
SiteID	pLocID	10
Attention	nvarchar	30
Address1	nvarchar	30
Address2	nvarchar	60
City	nvarchar	30
Region	nvarchar	10
Country	pCountry	6
PostalCode	nvarchar	10
TerrId	nvarchar	10
Phone1	nvarchar	15
Phone2	nvarchar	15
Phone3	nvarchar	15
Email	nvarchar	255
Internet	nvarchar	255
Rep1Id	pSalesRep	3
Rep1Pct	pDecimal	13	0
Rep2Id	pSalesRep	3
Rep2Pct	pDecimal	13	0
Rep1CommRate	pDecimal	13	0
Rep2CommRate	pDecimal	13	0
BillingType	nvarchar	10
CustomerPoNumber	nvarchar	25
PODate	datetime	8
OriginalWorkOrder	pTransID	8
BillByWorkOrder	bit	1	0
FixedPrice	bit	1	0
BillingFormat	nvarchar	255
ProjectDetailID	int	4
CF	xml	-1
ts	timestamp	8
BillVia	tinyint	1	0	0 = SD, 1 = PC

tblSvWorkOrderActivity -- SV Work Order Activity table

Column Name	Column Type	Length	Default Value	Description	Enumeration
ID	int	4
DispatchID	bigint	8
WorkOrderID	bigint	8
ActivityType	tinyint	1		Work Order Activity Type	0 = Request Received, 1 = Scheduled, 2 = Dispatched, 3 = Arrived / Started, 4 = Completed, 5 = Billed, 6 = Unbilled, 7 = Posted, 8 = Canceled, 9 = Reopened, 10 = Payment Received, 11 = Hold, 12 = Release
ActivityDateTime	datetime	8
TechID	pEmpID	11
Duration	bigint	8	0
EntryDate	datetime	8
EnteredBy	pUserID	20
Notes	nvarchar	max
CF	xml	-1
ts	timestamp	8

tblSvWorkOrderDispatch -- SV Work Order Dispatch table

Column Name	Column Type	Length	Default Value	Description	Enumeration
ID	bigint	8
WorkOrderID	bigint	8
DispatchNo	int	4
Description	pDescription	255
Status	tinyint	1		Dispatch Status	0 = Open, 1 = Completed, 2 = Billed, 3 = Posted
EquipmentID	bigint	8
EquipmentDescription	pDescription	255
BillingType	nvarchar	10
BillToID	pCustID	10
RequestedDate	datetime	8
RequestedAMPM	tinyint	1	0	Requested AM / PM	0 = None, 1 = AM, 2 = PM
RequestedTechID	pEmpID	11
CancelledYN	bit	1	0
HoldYN	bit	1	0
EstTravel	bigint	8	0
SchedApproved	bit	1	0
EntryDate	datetime	8
Counter	int	4
LocID	pLocID	10
SourceId	uniqueidentifier	16
PostRun	pPostRun	14
StatusID	tinyint	1
CF	xml	-1
ts	timestamp	8

tblSvWorkOrderDispatchLocal -- SV Local Work Order Dispatch table

Column Name	Column Type	Length
DispatchID	bigint	8
WorkOrderID	bigint	8
Started	datetime	8
Completed	datetime	8
Cancelled	datetime	8
Held	datetime	8
TechID	bigint	8
HostID	nvarchar	20
SynchID	bigint	8
CF	xml	-1
ts	timestamp	8

tblSvWorkOrderDispatchWorkToDo -- SV Work Order Dispatch Work To Do table

Column Name	Column Type	Length
ID	int	4
DispatchID	bigint	8
WorkOrderID	bigint	8
WorkToDoID	nvarchar	10
GroupID	nvarchar	10
Description	pDescription	255
EstimatedTime	bigint	8
SkillLevel	tinyint	1
CF	xml	-1
ts	timestamp	8

tblSvWorkOrderDispatchWorkToDoLocal -- SV Local Work Order Dispatch Work To Do table

Column Name	Column Type	Length	Default Value
ID	bigint	8
DispatchID	bigint	8
WorkOrderID	bigint	8
WorkToDoID	nvarchar	10
Description	nvarchar	255
EstimatedTime	bigint	8	0
SkillLevel	tinyint	1
TechID	bigint	8
HostID	nvarchar	20
SynchID	bigint	8
CF	xml	-1
ts	timestamp	8

tblSvWorkOrderReferral -- SV Work Order Referral table

Column Name	Column Type	Length
ID	bigint	8
CustID	pCustID	10
CompanyName	nvarchar	30
ContactName	nvarchar	30
Address1	nvarchar	30
Address2	nvarchar	60
City	nvarchar	30
Region	nvarchar	10
Country	pCountry	6
PostalCode	nvarchar	10
Phone	nvarchar	15
Fax	nvarchar	15
Email	nvarchar	255
Internet	nvarchar	255
Notes	nvarchar	max
CF	xml	-1
ts	timestamp	8

tblSvWorkOrderTrans -- SV Work Order Transaction table

Column Name	Column Type	Length	Default Value	Description	Enumeration
ID	bigint	8
DispatchID	bigint	8
WorkOrderID	bigint	8
TransType	tinyint	1		Transaction Type	0 = Labor, 1 = Part, 2 = Freight, 3 = Misc
ResourceID	nvarchar	24
LaborCode	nvarchar	10
Description	pDescription	255
LocID	pLocID	10
EntryDate	datetime	8
TransDate	datetime	8
FiscalYear	smallint	2
FiscalPeriod	smallint	2
AdditionalDescription	nvarchar	max
QtyEstimated	pDecimal	13	0
QtyUsed	pDecimal	13	0
Unit	nvarchar	5
UnitCost	pDecimal	13	0
UnitPrice	pDecimal	13	0
CostExt	pDecimal	13	0
PriceExt	pDecimal	13	0
TaxClass	tinyint	1
GLAcctCredit	pGlAcct	40
GLAcctDebit	pGlAcct	40
GLAcctSales	pGlAcct	40
HistSeqNum	int	4
QtySeqNum_Cmtd	int	4
QtySeqNum	int	4
LinkSeqNum	int	4
EntryNum	int	4
Status	tinyint	1	0	Status	0 = New, 1 = Posted
CF	xml	-1
ts	timestamp	8

tblSvWorkOrderTransExt -- SV Extended Work Order Transaction table

Column Name	Column Type	Length	Default Value
ID	int	4
TransID	bigint	8
LotNum	pLotNum	16
ExtLocA	int	4
ExtLocB	int	4
QtyEstimated	pDecimal	13	0
QtyUsed	pDecimal	13	0
UnitCost	pDecimal	13	0
HistSeqNum	int	4
QtySeqNum_Cmtd	int	4
QtySeqNum_Ext	int	4
QtySeqNum	int	4
Cmnt	nvarchar	35
CF	xml	-1
ts	timestamp	8

tblSvWorkOrderTransLocal -- SV Local Work Order Transaction table

Column Name	Column Type	Length	Default Value	Description	Enumeration
ID	bigint	8
DispatchID	bigint	8
WorkOrderID	bigint	8
TransType	tinyint	1		Transaction Type	0 = Labor, 1 = Part, 2 = Freight, 3 = Misc
ResourceID	nvarchar	24
LaborCode	nvarchar	6
Description	nvarchar	255
LocID	nvarchar	10
EntryDate	datetime	8
TransDate	datetime	8
AdditionalDescription	nvarchar	max
Qty	decimal	28,10	0
Unit	nvarchar	5
Price	decimal	28,10	0
LotNum	nvarchar	16
SerNum	nvarchar	35
TaxClass	tinyint	1
TaxAmount	decimal	28,10	0
SynchID	bigint	8
TechID	bigint	8
HostID	nvarchar	20
Synched	bit	1	0
CF	xml	-1
ts	timestamp	8

tblSvWorkOrderTransSer -- SV Work Order Serial Number Transaction table

Column Name	Column Type	Length	Default Value
ID	int	4
TransID	bigint	8
SerNum	pSerNum	35
LotNum	pLotNum	16
ExtLocA	int	4
ExtLocB	int	4
UnitCost	pDecimal	13	0
UnitCostACV	pDecimal	13	0
UnitPrice	pDecimal	13	0
HistSeqNum	int	4
Cmnt	nvarchar	35
CF	xml	-1
ts	timestamp	8

tblSvWorkToDo -- SV Work To Do table

Column Name	Column Type	Length
WorkToDoID	nvarchar	10
Description	pDescription	255
LaborCode	nvarchar	10
EstimatedTime	bigint	8
RequiredSkillLevel	tinyint	1
CF	xml	-1
ts	timestamp	8

tblSvWorkToDoRelation -- SV Work To Do Relationship table

Column Name	Column Type	Length
ID	int	4
WorkToDoID	nvarchar	10
RelationID	nvarchar	10
CF	xml	-1
ts	timestamp	8