Service Repair Tables
tblSmEmployee -- SM Employee table -- Add custom fields for SR
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| DfltScheduleId | Lookup | Lookup existing ID from tblSrSchedule | |||
| EmpRate | number |
tblSrCatalogDetail -- SR Catalog Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| CatalogId | nvarchar | 10 | |||
| ItemId | nvarchar | 255 | |||
| Descr | nvarchar | 255 | |||
| AddlDescr | nvarchar | 255 | |||
| UOM | nvarchar | 255 | |||
| UnitCost | pDecimal | 0 | |||
| UnitPrice | pDecimal | 0 | |||
| Weight | pDecimal | 0 | |||
| VendorName1 | nvarchar | 30 | |||
| VendorName2 | nvarchar | 30 | |||
| PriceId | nvarchar | 10 | |||
| ProductLine | nvarchar | 12 | |||
| SalesCat | nvarchar | 2 | |||
| WarningText | nvarchar | max | |||
| CF | XML | ||||
| ts | timestamp |
tblSrCatalogHeader -- SR Catalog Header table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| CatalogId | nvarchar | 10 | |||
| CatalogName | pDescription | 255 | |||
| CatalogDate | Datetime | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrCustContact -- SR Customer Contact table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| CustId | pCustId | ||||
| JobType | nvarchar | 6 | |||
| DocumentType | smallint | 0 = Estimate, 1 = Quote, 2 = QuickDeliveryTicket, 3 = InfoAlert, 4 = Other | |||
| ContactName | nvarchar | 30 | |||
| ContactType | smallint | 0 = Phone, 1 = Fax, 2 = Email, 3 = Web | |||
| ContactDescr | nvarchar | 255 | |||
| Value | nvarchar | 255 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrCustomerInstr -- SR Customer Instructions table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| CustId | pCustId | ||||
| WorkType | nvarchar | 6 | |||
| JobType | nvarchar | 6 | |||
| Instructions | text | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrDepartments -- SR Departments table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| DeptCode | pDeptID | 10 | |||
| Descr | pDescription | 255 | |||
| PrintLaborPrice | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| PrintMatlPrice | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| PrintOtherPrice | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| PrintTextPrice | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| PrintEstLaborPrice | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| PrintEstMatlPrice | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| PrintEstOtherPrice | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| PrintEstTextPrice | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| PrintEstSubTotals | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| PrintEstTotals | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| PrintSubTotals | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| PrintTotals | tinyint | 0=Detail; 1=Summary; 2=Total; 3=None | |||
| InvcFrom | tinyint | 0=Estimate; 1=Detail; 2=Both | |||
| PrintSpecInstr | bit | True | |||
| PrintCustomerInstr | bit | True | |||
| PrintNameplate | bit | True | |||
| MatlMultiplier | pDecimal | 1 | |||
| LaborMultiplier | pDecimal | 1 | |||
| StdLaborCostRate | pDecimal | 0 | |||
| BillingRateReg | pDecimal | 0 | |||
| BillingRateOT | pDecimal | 0 | |||
| BillingRateDT | pDecimal | 0 | |||
| LaborCostFlag | tinyint | 1 | 0=Actual; 1=Standard | ||
| LaborBurdenType | tinyint | 0 | 0=Percent; 1=Amount | ||
| LaborBurdenAmount | pDecimal | 0 | |||
| MatlBurdenPct | pDecimal | 0 | |||
| DistCode | pDistCode | 6 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrDistCode -- SR Distribution Code table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| DistCode | pDistCode | 6 | |||
| Descr | nvarchar | 25 | |||
| MaterialWIP | pGlAcct | ||||
| MaterialBurden | pGlAcct | ||||
| MaterialBurdenWIP | pGlAcct | ||||
| PayrollClearingLabor | pGlAcct | ||||
| LaborWIP | pGlAcct | ||||
| PayrollClearingLaborBurden | pGlAcct | ||||
| LaborBurdenWIP | pGlAcct | ||||
| MaterialSales | pGlAcct | ||||
| LaborSales | pGlAcct | ||||
| MaterialCOGS | pGlAcct | ||||
| MaterialBurdenCOGS | pGlAcct | ||||
| LaborCOGS | pGlAcct | ||||
| LaborBurdenCOGS | pGlAcct | ||||
| JobAccrual | pGlAcct | ||||
| AccruedIncome | pGlAcct | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrEquipmentTestTypes -- SR Equipment Test Types table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| TestTypeID | nvarchar | 2 | |||
| Descr | pDescription |
tblSrFailureCodes -- SR Failure Codes table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| FailureCode | nvarchar | 6 | |||
| Descr | nvarchar | 30 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrFieldSecurity -- SR Field Security table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| MenuId | int | ||||
| FieldName | nvarchar | 30 | |||
| AssemblyId | nvarchar | 100 | |||
| EntityNameFS | nvarchar | 100 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrHistContact -- SR Contact History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| Id | bigint | ||||
| TransId | pTransId | ||||
| JobType | nvarchar | 6 | |||
| DocumentType | smallint | 0 = Estimate, 1 = Quote, 2 = QuickDeliveryTicket, 3 = InfoAlert, 4 = Other | |||
| ContactName | nvarchar | 30 | |||
| ContactType | smallint | 0 = Phone, 1 = Fax, 2 = Email, 3 = Web | |||
| ContactDescr | nvarchar | 255 | |||
| Value | nvarchar | 255 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrHistDetail -- SR Job History Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| PostRun | pPostRun | ||||
| TransId | pTransId | 8 | |||
| LineSeq | int | ||||
| LineType | smallint | -1=Matl Credit; 0=Labor; 1=Mat’l;2=Text; 3=Other | |||
| LineStatus | int | 0=New;1=TrxPost; 2=Billed;3=Posted | |||
| LaborCode | nvarchar | 6 | |||
| EmployeeId | pEmpId | ||||
| RateType | tinyint | 1 = REG; 2 = OT; 3 = DT | |||
| LocId | pLocId | ||||
| Descr | pDescription | ||||
| AddlDescr | nvarchar | max | |||
| EarningCode | pCode | ||||
| ItemId | pItemID | ||||
| Unit | pUOM | ||||
| Qty | pDecimal | ||||
| UnitCost | pDecimal | ||||
| UnitCostFgn | pDecimal | ||||
| BurdenCost | pDecimal | ||||
| BurdenCostFgn | pDecimal | ||||
| CombinedUnitCost | pDecimal | ||||
| CombinedUnitCostFgn | pDecimal | ||||
| ExtCost | pDecimal | ||||
| ExtCostFgn | pDecimal | ||||
| UnitPrice | pDecimal | (Billing Rate in Labor lines) | |||
| UnitPriceFgn | pDecimal | (Billing Rate in Labor lines) | |||
| ExtPrice | pDecimal | ||||
| ExtPriceFgn | pDecimal | ||||
| Rep1Id | pSalesRep | ||||
| Rep1Pct | pDecimal | ||||
| Rep1CommRate | pDecimal | ||||
| Rep2Id | pSalesRep | ||||
| Rep2Pct | pDecimal | ||||
| Rep2CommRate | pDecimal | ||||
| UnitCommBasis | pDecimal | ||||
| UnitCommBasisFgn | pDecimal | ||||
| Reference | nvarchar | 35 | |||
| VendorId | pVendorId | ||||
| PriceId | nvarchar | 10 | |||
| TransDate | datetime | ||||
| PaYear | smallint | ||||
| FiscalYear | smallint | ||||
| FiscalPeriod | smallint | ||||
| AcctCode | nvarchar | 2 | |||
| GlAcctSales | pGLAcct | ||||
| GlAcctCOGS | pGLAcct | ||||
| GlAcctBurdenCOGS | pGLAcct | ||||
| GlAcctInv | pGLAcct | ||||
| GlAcctMatlWIP | pGLAcct | ||||
| GlAcctMatlBurden | pGLAcct | ||||
| GlAcctMatlBurdenWIP | pGLAcct | ||||
| GlAcctPayrollClearingLabor | pGLAcct | ||||
| GlAcctLaborWIP | pGLAcct | ||||
| GlAcctPayrollClearingLaborBurden | pGLAcct | ||||
| GlAcctLaborBurdenWIP | pGLAcct | ||||
| HistSeqNum | int | ||||
| QtySeqNum_Cmtd | int | ||||
| QtySeqNum | int | ||||
| LinkSeqNum | int | ||||
| TransPostRun | pPostRun | ||||
| BillingTransId | pTransId | TransId from Invoice detail table | |||
| BillingEntryNum | int | EntryNum from Invoice detail table | |||
| BillingPostRun | pPostRun | PostRun from Invoice table | |||
| EntryDate | datetime | ||||
| UserId | pUserID | ||||
| CreditId | bigint | ||||
| AddlPoInvCostYn | bit | ||||
| POInvoiceId | uniqueidentifier | ||||
| POReceivingDate | datetime | ||||
| PORcptID | uniqueidentifier | ||||
| PORcptNum | pInvoiceNum | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrHistDetailExt -- SR Extended Detail History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| Id | int | ||||
| TransId | pTransId | ||||
| LineDetailId | bigint | ||||
| LotNum | pLotNum | ||||
| Quantity | pDecimal | ||||
| UnitCost | pDecimal | ||||
| UnitCostFgn | pDecimal | ||||
| HistSeqNum | int | ||||
| QtySeqNum | int | ||||
| QtySeqNum_Cmtd | int | ||||
| QtySeqNum_Ext | int | ||||
| ExtLocA | int | ||||
| ExtLocB | int | ||||
| CreditId | bigint | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrHistDetailSer -- SR Serialized Detail History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| Id | int | ||||
| TransId | pTransId | ||||
| LineDetailId | bigint | ||||
| SerNum | pSerNum | ||||
| LotNum | pLotNum | ||||
| UnitCost | pDecimal | 0 | |||
| UnitCostACV | pDecimal | 0 | |||
| UnitPrice | pDecimal | 0 | |||
| UnitCostFgn | pDecimal | 0 | |||
| UnitPriceFgn | pDecimal | 0 | |||
| HistSeqNum | int | ||||
| ExtLocA | int | ||||
| ExtLocB | int | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrHistEstimate -- SR Job Estimate History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| PostRun | pPostRun | ||||
| TransId | pTransId | ||||
| LineSeq | int | ||||
| LineType | tinyint | 0=Labor; 1=Material; 2=Text; 3=Other | |||
| LaborCode | nvarchar | 6 | |||
| ItemId | pItemId | 24 | |||
| SchedWorkType | nvarchar | 6 | |||
| LocId | pLocId | ||||
| Descr | pDescription | ||||
| AddlDescr | pDescription | ||||
| Qty | pDecimal | ||||
| Unit | pUOM | ||||
| UnitCost | pDecimal | ||||
| UnitCostFgn | pDecimal | ||||
| BurdenCost | pDecimal | ||||
| BurdenCostFgn | pDecimal | ||||
| CombinedUnitCost | pDecimal | ||||
| CombinedUnitCost Fgn | pDecimal | ||||
| ExtCost | pDecimal | ||||
| ExtCostFgn | pDecimal | ||||
| UnitPrice | pDecimal | ||||
| UnitPriceFgn | pDecimal | ||||
| ExtPrice | pDecimal | ||||
| ExtPriceFgn | pDecimal | ||||
| Rep1Id | pSalesRep | ||||
| Rep1Pct | pDecimal | ||||
| Rep1CommRate | pDecimal | ||||
| Rep2Id | pSalesRep | ||||
| Rep2Pct | pDecimal | ||||
| Rep2CommRate | pDecimal | ||||
| UnitCostBasis | pDecimal | ||||
| UnitCostBasisFgn | pDecimal | ||||
| VendorId | pVendorId | ||||
| LinkSeqNum | int | ||||
| FromPoYn | bit | ||||
| IncludeYn | bit | ||||
| TaxClass | bit | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrHistEquipTestDetail-- SR Equipment Test History Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| PostRun | pPostRun | ||||
| EquipTestHdrId | bigint | ||||
| TestElementId | nvarchar | 2 | |||
| TestElementValue | pDecimal | ||||
| TestDate | datetime | 8 |
tblSrHistEquipTestHeader-- SR Equipment Test History Header table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| PostRun | pPostRun | ||||
| TestTypeId | nvarchar | 2 | |||
| TransId | pTransId | ||||
| TechnicianName | nvarchar | 40 | |||
| Notes | pDescription | ||||
| MachineOrigins | pDescription |
tblSrHistHeader -- SR Job History Header table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| TransId | pTransId | ||||
| VoidYn | bit | ||||
| TransType | smallint | 1= Quote; 2=Estimate Job; 3=Approved Job | |||
| TransStatus | tinyint | 0 | 0=Open; 1=Closed;2=On Hold | ||
| InvcNum | pInvoiceNum | ||||
| LastInvcDate | datetime | ||||
| InvcAmount | pDecimal | 0 | |||
| InvcAmountFgn | pDecimal | 0 | |||
| BatchId | pBatchId | ###### | |||
| DeptCode | pDeptID | ||||
| PrintLaborPrice | tinyint | ||||
| PrintMatlPrice | tinyint | ||||
| PrintOtherPrice | tinyint | ||||
| PrintTextPrice | tinyint | ||||
| PrintEstLaborPrice | tinyint | ||||
| PrintEstMatlPrice | tinyint | ||||
| PrintEstOtherPrice | tinyint | ||||
| PrintEstTextPrice | tinyint | ||||
| PrintEstSubTotals | tinyint | ||||
| PrintEstTotals | tinyint | ||||
| PrintSubTotals | tinyint | ||||
| PrintTotals | tinyint | ||||
| InvcFrom | tinyint | ||||
| JobTypeId | nvarchar | 6 | |||
| DistCode | pDistCode | 6 | |||
| CustId | pCustId | 10 | |||
| BillToId | pCustId | 10 | |||
| Contact | nvarchar | 25 | |||
| ShipToId | pCustId | ||||
| ShipToAttn | nvarchar | 30 | |||
| ShipToName | nvarchar | 30 | |||
| ShipToAddr1 | nvarchar | 30 | |||
| ShipToAddr2 | nvarchar | 60 | |||
| ShipToCity | nvarchar | 30 | |||
| ShipToRegion | nvarchar | 10 | |||
| ShipToCountry | pCountry | ||||
| ShipToPostalCode | nvarchar | 10 | |||
| ShipMethod | nvarchar | 6 | |||
| ShipVia | nvarchar | 20 | |||
| NameplateDescr | nvarchar | 40 | |||
| JobDescr | nvarchar | 80 | |||
| EnteredBy | pUserId | ||||
| QuoteId | pTransId | ||||
| Priority | nvarchar | 2 | |||
| FailCode1 | nvarchar | 6 | |||
| FailCode2 | nvarchar | 6 | |||
| DetailPrice | tinyint | 1 | N | N=Totals Only; 1=Detail; 2=Labor Ext Price and Material Detail; 3=Ext Price Only | |
| FinalBillYn | bit | ||||
| QuoteValidDays | int | ||||
| WarrantyYn | bit | 0 | |||
| OHJobYn | bit | 0 | |||
| PriceFirstYn | bit | 0 | |||
| OTFlag | bit | 0 | |||
| Rep1Id | pSalesRep | ||||
| Rep1Pct | pDecimal | ||||
| Rep1CommRate | pDecimal | ||||
| Rep2Id | pSalesRep | ||||
| Rep2Pct | pDecimal | ||||
| Rep2CommRate | pDecimal | ||||
| SalesRepNotes | text | ||||
| SpecialInstr | text | ||||
| ShopLocation | nvarchar | 80 | |||
| LocId | pLocID | ||||
| ReplItem | pItemId | ||||
| ReplItemDescr | nvarchar | 60 | |||
| ReplItemPrice | pDecimal | ||||
| ShipNum | nvarchar | 18 | |||
| CustLevel | nvarchar | 10 | |||
| CustPONum | nvarchar | 25 | |||
| POReleaseNum | nvarchar | 25 | |||
| MiscNum | nvarchar | 25 | |||
| CurrencyId | pCurrencyId | ||||
| ExchRate | pDecimal | 1 | |||
| QuoteAmt | pDecimal | ||||
| QuoteAmtFgn | pDecimal | ||||
| BudgetAmt | pDecimal | ||||
| BudgetAmtFgn | pDecimal | ||||
| TotEstAmt | pDecimal | ||||
| TotEstAmtFgn | pDecimal | ||||
| FreightBilled | pDecimal | ||||
| FreightBilledFgn | pDecimal | ||||
| FreightToBill | pDecimal | ||||
| FreightToBillFgn | pDecimal | ||||
| TotEstCost | pDecimal | ||||
| TotEstCstFgn | pDecimal | ||||
| DateConfirmedYn | bit | ||||
| PromiseDate | datetime | ||||
| EstimateDate | datetime | 15 | |||
| ShipDate | datetime | ||||
| EstCompleteDate | datetime | ||||
| EstApprovedDate | datetime | ||||
| StartDate | datetime | ||||
| FirstLaborDate | datetime | ||||
| LastLaborDate | datetime | ||||
| MatlPickDate | datetime | ||||
| JobCloseDate | datetime | ||||
| TransDate | datetime | Also referred to as Received Date | |||
| LostReasonCode | nvarchar | ||||
| FiscalYear | smallint | ||||
| FiscalPeriod | smallint | ||||
| SourceId | uniqueidentifier | ||||
| TotNoTaxEstAmt | pDecimal | ||||
| TotNoTaxEstAmtFgn | pDecimal | ||||
| TotEst | pDecimal | ||||
| TotEstFgn | pDecimal | ||||
| TotEstTax | pDecimal | ||||
| TotEstTaxFgn | pDecimal | ||||
| CustDistCode | pDistCode | ||||
| TaxLocAdj | pTaxLoc | ||||
| TaxableYn | bit | ||||
| TaxClassAdj | tinyint | ||||
| TaxAmtAdj | pDecimal | ||||
| TaxAmtAdjFgn | pDecimal | ||||
| SalesTax | pDecimal | ||||
| SalesTaxFgn | pDecimal | ||||
| TaxGrpId | pTaxLoc | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrHistInspection -- SR Inspection History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| InspectionId | bigint | ||||
| TransId | pTransId | ||||
| DefaultId | bigint | ||||
| InspectionDate | datetime | ||||
| ConfigId | bigint | ||||
| ClosedDate | datetime | ||||
| InspectionNo | int |
tblSrHistInspectionGroup -- SR Inspection Group History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| InspectionId | bigint | ||||
| GroupId | bigint | ||||
| AssignedTo | pEmpID | ||||
| AssignedDate | datetime | ||||
| DownloadDate | datetime | ||||
| DownloadBy | pEmpID | ||||
| CheckInDate | datetime | ||||
| Status | smallint | 0 = New; 1 = Active; 2 = Hold; 3 = Completed; 4 = FinalRpt | |||
| DefaultOrder | int | ||||
| AssignToType | smallint | -1 = None; 0 = Employee; 1 = Queue | |||
| Priority | int | ||||
| LaborCode | nvarchar | 6 | |||
| WorkType | nvarchar | 6 | |||
| EstimatedHours | pDecimal | ||||
| Exclusive | bit | ||||
| ConfigGroupId | bigint |
tblSrHistInspectionGroupStatus -- SR Inspection Group Status History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| PostRun | pPostRun | ||||
| GroupId | bigint | ||||
| UserId | pUserID | ||||
| HostId | pWrkStnID | ||||
| Status | smallint | -1 = None; 0 =GroupCreated; 1 = EmployeeAssigned; 2 = EmployeeRemoved; 3 = QueueAssigned; 4 = QueueRemoved; 5 = Priority; 6 = NeedsAttention; 7 = NeedAttended; 8 = GroupStateChanged | |||
| StatusDescr | nvarchar | 50 | |||
| StatusDateTime | datetime |
tblSrHistInvoiceDetail -- SR Invoice Detail History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| TransId | pTransId | ||||
| EntryNum | int | ||||
| OrgEntryNum | int | ||||
| RelNum | int | ||||
| TotRelNum | int | ||||
| LineSeq | int | ||||
| BillingSource | tinyint | 2 | 1=Estimate; 2=Actual; 3=Manual Entry | ||
| LineType | smallint | -1=Material Credit; 0=Labor; 1=Material; 2=Text; 3=Other | |||
| RecType | smallint | 0 = Detail; 1 = Total | |||
| LocId | pLocId | ||||
| LaborCode | nvarchar | 6 | |||
| EmployeeId | pEmpID | ||||
| RateType | tinyint | 1=REG; 2=OT; 3=DT | |||
| EarningCode | pCode | ||||
| ItemId | pItemId | ||||
| Descr | pDescription | ||||
| AddlDescr | pDescription | ||||
| TaxClass | tinyint | ||||
| UnitSell | pUOM | 5 | |||
| UnitBase | pUOM | 5 | |||
| QtyShipBase | pDecimal | 0 | |||
| QtyShipSell | pDecimal | 0 | |||
| Rep1Id | pSalesRep | ||||
| Rep1Pct | pDecimal | ||||
| Rep1CommRate | pDecimal | ||||
| Rep2Id | pSalesRep | ||||
| Rep2Pct | pDecimal | ||||
| Rep2CommRate | pDecimal | ||||
| UnitCommBasis | pDecimal | ||||
| UnitCommBasisFgn | pDecimal | ||||
| UnitCost | pDecimal | ||||
| UnitCostFgn | pDecimal | ||||
| BurdenCost | pDecimal | ||||
| BurdenCostFgn | pDecimal | ||||
| CombinedUnitCost | pDecimal | ||||
| CombinedUnitCostFgn | pDecimal | ||||
| ExtCost | pDecimal | ||||
| ExtCostFgn | pDecimal | ||||
| UnitPrice | pDecimal | (Billing Rate in Labor lines) | |||
| UnitPriceFgn | pDecimal | ||||
| ExtPrice | pDecimal | ||||
| ExtPriceFgn |
pDecimal |
||||
| PriceId | nvarchar | 10 | |||
| AcctCode | pGLAcctCode | ||||
| GlAcctSales | pGLAcct | ||||
| GlAcctCOGS | pGLAcct | ||||
| GlAcctBurdenCOGS | pGLAcct | ||||
| GlAcctInv | pGLAcct | ||||
| GlAcctMatlWIP | pGLAcct | ||||
| GlAcctMatlBurden | pGLAcct | ||||
| GlAcctMatlBurdenWIP | pGLAcct | ||||
| GlAcctPayrollClearingLabor | pGLAcct | ||||
| GlAcctLaborWIP | pGLAcct | ||||
| GlAcctPayrollClearingLaborBurden | pGLAcct | ||||
| GlAcctLaborBurdenWIP | pGLAcct | ||||
| HistSeqNum | int | ||||
| LinkedJobId | pTransId | ||||
| VoidYn | bit | ||||
| AddlPoInvCostYn | bit | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrHistInvoiceHeader -- SR Invoice Header History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| TransId | pTransId | ||||
| OrgTransId | pTransId | ||||
| OrgInvcId | int | ||||
| JobId | pTransId | ||||
| TransType | smallint | 0 = Estimate; 1 = Detail; 2 = Both | |||
| VoidYn | bit | 0 | |||
| HoldYn | bit | 0 | |||
| BatchId | pBatchId | ###### | |||
| CustId | pCustId | ||||
| CustLevel | nvarchar | 10 | |||
| BillToId | pCustId | ||||
| TermsCode | pTermsCode | ||||
| DistCode | pDistCode | ||||
| TaxableYn | bit | 0 | |||
| InvcNum | pInvoiceNum | ||||
| OrgInvcNum | pInvoiceNum | ||||
| InvcDate | datetime | ||||
| DiscDueDate | datetime | ||||
| ShipDate | datetime | ||||
| FiscalYear | smallint | ||||
| FiscalPeriod | smallint | ||||
| TaxGrpID | pTaxLoc | 10 | |||
| TaxLocAdj | pTaxLoc | 10 | |||
| TaxClassAdj | tinyint | ||||
| TaxSubtotal | pDecimal | 0 | |||
| TaxSubtotalFgn | pDecimal | 0 | |||
| NonTaxSubtotal | pDecimal | 0 | |||
| NonTaxSubtotalFgn | pDecimal | 0 | |||
| SalesTax | pDecimal | 0 | |||
| SalesTaxFgn | pDecimal | 0 | |||
| Freight | pDecimal | 0 | |||
| FreightFgn | pDecimal | 0 | |||
| Misc | pDecimal | 0 | |||
| MiscFgn | pDecimal | 0 | |||
| TotCost | pDecimal | 0 | |||
| TotCostFgn | pDecimal | 0 | |||
| TotPmtAmt | pDecimal | 0 | |||
| TotPmtAmtFgn | pDecimal | 0 | |||
| DiscAmt | pDecimal | 0 | |||
| DiscAmtFgn | pDecimal | 0 | |||
| TaxAmtAdj | pDecimal | 0 | |||
| TaxAmtAdjFgn | pDecimal | 0 | |||
| BillingFormat | nvarchar | ||||
| CurrencyId | pCurrency | ||||
| ExchRate | pDecimal | 1 | |||
| PrintDelTktStatus | tinyint | 0=unprinted;1=online;2=batch | |||
| PrintInvcStatus | tinyint | 0=unprinted;1=online;2=batch | |||
| DeptCode | pDeptID | ||||
| InvcFrom | tinyint | ||||
| PrintLaborPrice | tinyint | ||||
| PrintMatlPrice | tinyint | ||||
| PrintOtherPrice | tinyint | ||||
| PrintTextPrice | tinyint | ||||
| PrintSubTotals | tinyint | ||||
| PrintTotals | tinyint | ||||
| NameplateDescr | nvarchar | 40 | |||
| NameplateData | text | ||||
| SpecialInstr | text | ||||
| JobTypeId | nvarchar | 6 | |||
| EnteredBy | pUserID | ||||
| Contact | nvarchar | 25 | |||
| ShipToId | pCustId | ||||
| ShipToAttn | nvarchar | 30 | |||
| ShipToName | nvarchar | 30 | |||
| ShipToAddr1 | nvarchar | 30 | |||
| ShipToAddr2 | nvarchar | 60 | |||
| ShipToCity | nvarchar | 30 | |||
| ShipToRegion | nvarchar | 10 | |||
| ShipToCountry | nvarchar | 6 | |||
| ShipToPostalCode | nvarchar | 10 | |||
| ShipToMethod | nvarchar | 6 | |||
| ShipVia | nvarchar | 20 | |||
| ShipNum | nvarchar | 18 | |||
| ReceiveDate | datetime | ||||
| DetailPrice | tinyint | 1 | N | N=Totals Only; 1=Detail; 2=Labor Ext Price and Material Detail; 3=Ext Price Only | |
| LocId | pLocID | ||||
| Rep1Id | pSalesRep | ||||
| Rep1Pct | pDecimal | ||||
| Rep1CommRate | pDecimal | ||||
| Rep2Id | pSalesRep | ||||
| Rep2Pct | pDecimal | ||||
| Rep2CommRate | pDecimal | ||||
| TaxClassFreight | tinyint | ||||
| TaxClassMisc | tinyint | ||||
| CustPONum | nvarchar | ||||
| POReleaseNum | nvarchar | 25 | |||
| MiscNum | nvarchar | 25 | |||
| SourceID | uniqueidentifier | ||||
| CustDistCode | pDistCode | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrHistInvoiceTrans -- SR Invoice Transactions History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| TransId | pTransId | ||||
| JobId | pTransId | ||||
| InvcFrom | tinyint | ||||
| PrintLaborPrice | tinyint | ||||
| PrintMatlPrice | tinyint | ||||
| PrintOtherPrice | tinyint | ||||
| PrintTextPrice | tinyint | ||||
| Freight | pDecimal | ||||
| FreightFgn | pDecimal | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrHistLink -- SR Link History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| ParentTransId | pTransId | ||||
| LinkedTransId | pTransId |
tblSrHistNameplate -- SR Job History Nameplate table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| Id | int | ||||
| TransId | pTransId | ||||
| Priority | int | ||||
| NameplateFieldID | int | ||||
| NameplateFieldValue | nvarchar | 30 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrHistPicture -- SR Picture History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| PostRun | pPostRun | ||||
| TransId | pTransId | 8 | |||
| TypeSeq | int | 2 | |||
| Sequence | int | ||||
| PictureGroup | nvarchar | 10 | |||
| Description | pDescription | ||||
| Notes | text | ||||
| PictureID | nvarchar | 25 | |||
| SubFolder | nvarchar | 30 | |||
| JobType | nvarchar | 10 | |||
| PicturePath | nvarchar | 200 | |||
| PictureIDActual | nvarchar | 55 | |||
| CheckMarkPath | nvarchar | 200 |
tblSrHistPmt -- SR Payment History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| PmtNum | int | ||||
| PmtDate | datetime | ||||
| TransId | pTransId | ||||
| DepositId | pBatchId | ||||
| LinkId | int | ||||
| InvoiceLink | pTransId | ||||
| PmtMethodId | nvarchar | 10 | |||
| CcNum | nvarchar | 255 | |||
| CcHolder | nvarchar | 30 | |||
| CcExpire | datetime | ||||
| CcAuth | nvarchar | 10 | |||
| CheckNum | pCheckNum | ||||
| Note | nvarchar | 25 | |||
| PmtAmt | pDecimal | ||||
| PmtAmtFgn | pDecimal | ||||
| CurrencyId | pCurrency | ||||
| ExchRate | pDecimal | ||||
| PostedYn | bit | ||||
| PreparedYn | bit | ||||
| CcSecCode | varchar | 6 | |||
| BankName | nvarchar | 30 | |||
| BankRoutingCode | nvarchar | 9 | |||
| BankAcctNum | nvarchar | 255 | |||
| GlPeriod | smallint | ||||
| FiscalYear | smallint | ||||
| GlAcctReceivables | pGlAcct | ||||
| ExtPmtActivityID | bigint | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrHistSchedule -- SR Job Schedule History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| Id | int | ||||
| TransId | pTransId | ||||
| Priority | int | ||||
| WorkType | nvarchar | 6 | |||
| ScheduleYn | bit | ||||
| EstimateHours | pDecimal | ||||
| SchedDate | datetime | ||||
| FirstLaborDate | datetime | ||||
| CompleteDate | datetime | ||||
| SchDuringEstYn | bit | ||||
| UseEstHoursYn | bit | ||||
| HoldUnit | datetime | ||||
| Comments | varchar | max | |||
| CF | XML | ||||
| ts | timestamp | ||||
| Sequence | int | 1 |
tblSrHistStatus -- SR Job Status History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| PostRun | pPostRun | ||||
| TransId | pTransId | ||||
| UserId | pUserID | ||||
| HostId | pWrkStnID | ||||
| Status | nvarchar | 50 | |||
| StatusDate | datetime | ||||
| StatusTime | datetime | ||||
| DashboardStatus | smallint | 0 = None; 1 = New; 2 = Active; 3 = ReadyToEstimate; 4 = WaitingForApproval; 5 = InProcess; 6 = WaitingParts; 7 = Complete; 8 = InvoiceClosed | |||
| CF | XML | ||||
| ts | timestamp |
tblSrHistTax -- SR Tax History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| TransId | pTransId | ||||
| TaxLocId | pTaxLoc | ||||
| TaxClass | tinyint | ||||
| Level | tinyint | ||||
| TaxAmt | pDecimal | ||||
| TaxAmtFgn | pDecimal | ||||
| Taxable | pDecimal | ||||
| TaxableFgn | pDecimal | ||||
| NonTaxable | pDecimal | ||||
| NonTaxableFgn | pDecimal | ||||
| LiabilityAcct | pGlAcct |
tblSrHistTimeClockTrans -- SR Time Clock Transaction History table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PostRun | pPostRun | ||||
| TransId | int | ||||
| EmployeeId | pEmpId | ||||
| ScheduleId | nvarchar | 10 | |||
| EntryNum | int | ||||
| RelNum | int | ||||
| TransDate | datetime | ||||
| EntryType | tinyint | 0 = StartJob; 1 = ConcurrentJob | |||
| JobId | pTransID | ||||
| LaborCode | nvarchar | 6 | |||
| StartTime | datetime | ||||
| EndTime | datetime | ||||
| ReportedTime | pDecimal | 1=REG; 2=OT; 3=DT | |||
| InclBreak | bit | ||||
| EditYn | bit | ||||
| OHTime | bit |
tblSrInspection -- SR Inspection table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| InspectionId | bigint | ||||
| TransId | pTransId | ||||
| DefaultId | bigint | ||||
| ConfigId | bigint | ||||
| InspectionDate | datetime | ||||
| ClosedDate | datetime | ||||
| InspectionNo | int |
tblSrInspectionDefault -- SR Default Inspection table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| DefaultId | bigint | ||||
| JobType | nvarchar | 6 | |||
| CustId | pCustID | ||||
| ConfigId | bigint |
tblSrInspectionDefaultGroup -- SR Default Inspection Group table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| DefaultId | bigint | ||||
| GroupId | bigint | ||||
| AssignTo | pEmpID | ||||
| DefaultOrder | int | ||||
| AssignToType | smallint | -1 = None, 0 = Employee, 1 = Queue |
tblSrInspectionGroup -- SR Inspection Group table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| InspectionId | bigint | ||||
| GroupId | bigint | ||||
| AssignedTo | pEmpID | ||||
| AssignedDate | datetime | ||||
| DownloadDate | datetime | ||||
| DownloadBy | pEmpID | ||||
| CheckInDate | datetime | ||||
| Status | smallint | 0 = New; 1 = Active; 2 = Hold; 3 = Completed; 4 = FinalRpt | |||
| DefaultOrder | int | ||||
| Priority | int | ||||
| ConfigGroupId | bigint | ||||
| AssignToType | smallint | -1 = None; 0 = Employee; 1 = Queue | |||
| Exclusive | bit | ||||
| LaborCode | nvarchar | 6 | |||
| WorkType | nvarchar | 6 | |||
| EstimatedHours | pDecimal | ||||
| Sequence | int |
tblSrInspectionGroupStatus -- SR Inspection Group Status table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| GroupId | bigint | ||||
| UserId | pUserID | ||||
| HostIId | pWrkstnID | ||||
| Status | smallint | -1 = None; 0 = GroupCreated; 1 = EmployeeAssigned; 2 = EmployeeRemoved; 3 = QueueAssigned; 4 = QueueRemoved; 5 = Priority; 6 = NeedsAttention; 7 = NeedAttended; 8 = GroupStateChanged | |||
| StatusDescr | nvarchar | 50 | |||
| StatusDateTime | datetime |
tblSrInspectionReporting -- SR Inspection Reporting table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| ConfigId | bigint | ||||
| InspectionId | bigint | ||||
| LayoutName | nvarchar | 255 | |||
| AttachmentsQty | int |
tblSrInvoiceDetail -- SR Invoice Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| TransId | pTransId | ||||
| EntryNum | int | ||||
| OrgEntryNum | int | ||||
| RelNum | int | ||||
| TotRelNum | int | ||||
| LineSeq | int | ||||
| BillingSource | tinyint | 2 | 1=Estimate; 2=Actual; 3=Manual Entry | ||
| LineType | smallint | -1=Material Credit; 0=Labor; 1=Material; 2=Text; 3=Other | |||
| RecType | smallint | 0 = Detail; 1 = Total | |||
| LocId | pLocId | ||||
| LaborCode | nvarchar | 6 | |||
| EmployeeId | pEmpID | ||||
| RateType | tinyint | 1=REG; 2=OT; 3=DT | |||
| EarningCode | pCode | ||||
| ItemId | pItemId | ||||
| Descr | pDescription | ||||
| AddlDescr | nvarchar | max | |||
| TaxClass | tinyint | ||||
| UnitSell | pUOM | ||||
| UnitBase | pUOM | ||||
| QtyShipBase | pDecimal | 0 | |||
| QtyShipSell | pDecimal | 0 | |||
| Rep1Id | pSalesRep | ||||
| Rep1Pct | pDecimal | ||||
| Rep1CommRate | pDecimal | ||||
| Rep2Id | pSalesRep | ||||
| Rep2Pct | pDecimal | ||||
| Rep2CommRate | pDecimal | ||||
| UnitCommBasis | pDecimal | ||||
| UnitCommBasisFgn | pDecimal | ||||
| UnitCost | pDecimal | ||||
| UnitCostFgn | pDecimal | ||||
| BurdenCost | pDecimal | ||||
| BurdenCostFgn | pDecimal | ||||
| CombinedUnitCost | pDecimal | ||||
| CombinedUnitCostFgn | pDecimal | ||||
| ExtCost | pDecimal | ||||
| ExtCostFgn | pDecimal | ||||
| UnitPrice | pDecimal | (Billing Rate in Labor lines) | |||
| UnitPriceFgn | pDecimal | ||||
| ExtPrice | pDecimal | ||||
| ExtPriceFgn |
pDecimal |
||||
| PriceId | nvarchar | 10 | |||
| AcctCode | pGLAcctCode | ||||
| GlAcctSales | pGLAcct | ||||
| GlAcctCOGS | pGLAcct | ||||
| GlAcctBurdenCOGS | pGLAcct | ||||
| GlAcctInv | pGLAcct | ||||
| GlAcctMatl | pGLAcct | ||||
| GlAcctMatlWIP | pGLAcct | ||||
| GlAcctMatlBurdenWIP | pGLAcct | ||||
| GlAcctPayrollClearingLabor | pGLAcct | ||||
| GlAcctLabor | pGLAcct | ||||
| GlAcctPayrollClearingLaborBurden | pGLAcct | ||||
| GlAcctLaborBurdenWIP | pGLAcct | ||||
| HistSeqNum | int | ||||
| LinkedJobId | pTransId | ||||
| AddlPoInvCostYn | bit | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrInvoiceHeader -- SR Invoice Header table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| TransId | pTransId | ||||
| OrgTransId | pTransId | ||||
| OrgInvcId | int | ||||
| JobId | pTransId | ||||
| TransType | smallint | 0 = Estimate; 1 = Detail; 2 = Both | |||
| VoidYn | bit | 0 | |||
| HoldYn | bit | 0 | |||
| BatchId | pBatchId | ###### | |||
| CustId | pCustId | ||||
| CustLevel | nvarchar | 10 | |||
| BillToId | pCustId | ||||
| TermsCode | pTermsCode | ||||
| DistCode | pDistCode | ||||
| TaxableYn | bit | ||||
| InvcNum | pInvoiceNum | ||||
| OrgInvcNum | pInvoiceNum | ||||
| InvcDate | datetime | ||||
| DiscDueDate | datetime | ||||
| NetDueDate | datetime | ||||
| ShipDate | datetime | ||||
| FiscalYear | smallint | ||||
| FiscalPeriod | smallint | ||||
| TaxGrpID | pTaxLoc | ||||
| TaxLocAdj | pTaxLoc | ||||
| TaxClassAdj | tinyint | ||||
| TaxSubtotal | pDecimal | 0 | |||
| TaxSubtotalFgn | pDecimal | 0 | |||
| NonTaxSubtotal | pDecimal | 0 | |||
| NonTaxSubtotalFgn | pDecimal | 0 | |||
| SalesTax | pDecimal | 0 | |||
| SalesTaxFgn | pDecimal | 0 | |||
| Freight | pDecimal | 0 | |||
| FreightFgn | pDecimal | 0 | |||
| Misc | pDecimal | 0 | |||
| MiscFgn | pDecimal | 0 | |||
| TotCost | pDecimal | 0 | |||
| TotCostFgn | pDecimal | 0 | |||
| TotPmtAmt | pDecimal | 0 | |||
| TotPmtAmtFgn | pDecimal | 0 | |||
| DiscAmt | pDecimal | 0 | |||
| DiscAmtFgn | pDecimal | 0 | |||
| TaxAmtAdj | pDecimal | 0 | |||
| TaxAmtAdjFgn | pDecimal | 0 | |||
| BillingFormat | nvarchar | 255 | |||
| CurrencyId | pCurrency | ||||
| ExchRate | pDec | 1 | |||
| PrintDelTktStatus | tinyint | 0 = unprinted; 1 = online; 2 = batch | |||
| PrintInvcStatus | tinyint | 0 = unprinted; 1 = online; 2 = batch | |||
| DeptCode | pDeptID | ||||
| InvcFrom | tinyint | 0 = Estimate; 1 = Details; 2 = Both | |||
| PrintLaborPrice | tinyint | ||||
| PrintMatlPrice | tinyint | ||||
| PrintOtherPrice | tinyint | ||||
| PrintTextPrice | tinyint | ||||
| PrintSubTotals | tinyint | ||||
| PrintTotals | tinyint | ||||
| NameplateDescr | nvarchar | 40 | |||
| JobTypeId | nvarchar | 6 | |||
| EnteredBy | pUserID | ||||
| Contact | nvarchar | 25 | |||
| ShipToId | pCustId | ||||
| ShipToAttn | nvarchar | 30 | |||
| ShipToName | nvarchar | 30 | |||
| ShipToAddr1 | nvarchar | 30 | |||
| ShipToAddr2 | nvarchar | 60 | |||
| ShipToCity | nvarchar | 30 | |||
| ShipToRegion | nvarchar | 10 | |||
| ShipToCountry | nvarchar | 6 | |||
| ShipToPostalCode | nvarchar | 10 | |||
| ShipMethod | nvarchar | 6 | |||
| ShipVia | nvarchar | ||||
| ShipNum | nvarchar | ||||
| ReceiveDate | datetime | ||||
| DetailPrice | tinyint | 1 | N | 0 =Totals Only; 1=Detail; 2=Labor Ext Price and Material Detail; 3=Ext Price Only | |
| LocId | pLocID | ||||
| Rep1Id | pSalesRep | 3 | |||
| Rep1Pct | pDecimal | ||||
| Rep2Id | pSalesRep | 3 | |||
| Rep2Pct | pDecimal | ||||
| Rep1CommRate | pDecimal | ||||
| Rep2CommRate | pDecimal | ||||
| TaxClassFreight | tinyint | ||||
| TaxClassMisc | tinyint | ||||
| CustPONum | nvarchar | 25 | |||
| POReleaseNum | nvarchar | 25 | |||
| MiscNum | nvarchar | 25 | |||
| SourceId | uniqueidentifier | ||||
| CustDistCode | pDistCode | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrInvoiceTax -- SR Invoice Tax table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| TransId | pTransID | ||||
| TaxLocId | pTaxLoc | ||||
| TaxClass | tinyint | ||||
| Level | tinyint | ||||
| TaxAmt | pDecimal | 0 | |||
| TaxAmtFgn | pDecimal | 0 | |||
| Taxable | pDecimal | 0 | |||
| TaxableFgn | pDecimal | 0 | |||
| NonTaxable | pDecimal | 0 | |||
| NonTaxableFgn | pDecimal | 0 | |||
| LiabilityAcct | pGlAcct | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrInvoiceTrans -- SR Invoice Transactions table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| TransId | pTransId | 8 | |||
| JobId | pTransId | 8 | |||
| InvcFrom | tinyint | 0 = Estimate; 1 = Details; 2 = Both | |||
| PrintLaborPrice | tinyint | ||||
| PrintMatlPrice | tinyint | ||||
| PrintOtherPrice | tinyint | ||||
| PrintTextPrice | tinyint | ||||
| Freight | pDecimal | ||||
| FreightFgn | pDecimal | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrJobCardQA -- SR Job Card QA table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| JobType | nvarchar | 6 | |||
| WorkType | nvarchar | 6 | |||
| SeqNum | int | ||||
| Descr | pDescription | ||||
| PrintYN | bit | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrJobCardQAValues -- SR Job Card QA Values table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| WorkType | nvarchar | 6 | |||
| JobCardQAId | int | ||||
| SourceId | pTransId | ||||
| Descr | pDescription | ||||
| Value | nvarchar | 30 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrJobDocument -- SR Job Document table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| ID | bigint | ||||
| TransId | pTransID | ||||
| PostRun | pPostRun | ||||
| Filename | nvarchar | 3000 | |||
| DataLength | pDecimal | ||||
| Hash | binary | 4 | |||
| UploadedBy | pUserID | ||||
| UploadDate | datetime | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrJobDocumentContent -- SR Job Document content table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| ID | bigint | ||||
| Data | varbinary | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrJobPictureTypes -- SR Job Picture Types table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| AutoNumber | bigint | ||||
| JobType | nvarchar | 10 | |||
| CustId | pCustID | ||||
| PictureGroup | nvarchar | 10 | |||
| Sequence | int | ||||
| Description | nvarchar | 30 | |||
| Notes | text | ||||
| PictureId | nvarchar | 25 | |||
| SubFolder | nvarchar | 30 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrJobPictureTypesDetail -- SR Job Picture Types Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| AutoNumber | bigint | ||||
| DataType | smallint | ||||
| DataValue | nvarchar | 10 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrJobPriorityCodes -- SR Job Priority Codes table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PriorityCode | nvarchar | 2 | |||
| Descr | nvarchar | 30 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrJobSchedule -- SR Job Schedule table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| SchedId | bigint | ||||
| SchedCode | nvarchar | ||||
| Descr | pDescription | ||||
| TransId | pTransID | ||||
| Priority | int | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrJobScheduleDetail -- SR Job Schedule Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| DetailId | bigint | ||||
| SchedId | bigint | ||||
| WorkType | nvarchar | 6 | |||
| LocId | pLocID | ||||
| LineNum | tinyint | ||||
| ScheduledStart | datetime | ||||
| ScheduledCompleted | datetime | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrJobScheduleEmployee -- SR Job Schedule Employee table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| DetailId | bigint | ||||
| EmployeeId | pEmpID | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrJobType -- SR Job Type table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| JobType | nvarchar | 6 | |||
| Descr | pDescription | ||||
| PromiseDays | int | ||||
| AutoScheduleYn | bit | ||||
| SchDaysWorkType1 | int | ||||
| SchDaysWorkType2 | int | ||||
| SchDaysWorkType3 | int | ||||
| AutoESTWorkType | nvarchar | 6 | |||
| AutoPOWorkType | nvarchar | 6 | |||
| EstimateDays | int | ||||
| UseDuringEstimateYn | bit | ||||
| POGraceDays | int | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrJobTypeNameplate -- SR Job Type Nameplate table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| JobType | nvarchar | 6 | |||
| NameplateId | int | ||||
| JobDescriptionYN | bit | ||||
| Priority | int | ||||
| LimitToListYN | bit | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrJobTypeSchedule -- SR Job Type Schedule table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| JobType | nvarchar | 6 | |||
| WorkType | nvarchar | 6 | |||
| Priority | int | ||||
| Hours | pDecimal | ||||
| ScheDuringEstYn | bit | ||||
| UseEstHoursYn | bit | ||||
| CF | XML | ||||
| ts | timestamp | ||||
| Sequence | int | 1 |
tblSrJobTypeSchedulePrereq -- SR Job Type Schedule Prerequisites table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| JobTypeScheduleId | int | ||||
| WorkType | nvarchar | 6 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrLaborCodes -- SR Labor Codes table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| LaborCode | nvarchar | 6 | PK | ||
| Descr | nvarchar | 35 | |||
| AddnlDescr | nvarchar | 255 | |||
| HeadingCode | nvarchar | 6 | FK -tblSrLaborCodes | ||
| WorkType | nvarchar | 6 | |||
| TaxClass | tinyint | ||||
| StdLaborCostRate | pDecimal | ||||
| Note | text | ||||
| BillingRateReg | pDecimal | 0 | |||
| BillingRateOT | pDecimal | 0 | |||
| BillingRateDT | pDecimal | 0 | |||
| LaborCodeAdder | pDecimal |
tblSrLostReasonCodes -- SR Lost Reason Codes table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| LostReasonCode | nvarchar | 6 | PK | ||
| Descr | pDescription | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrMaterialCharge -- SR Material Charge table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| TransId | pTransId | ||||
| TransDate | datetime | ||||
| LineType | smallint | 1=Material Charge; -1=MaterialCredit | |||
| FiscalYear | smallint | ||||
| FiscalPeriod | smallint | ||||
| ItemId | pItemId | ||||
| Descr | pDescription | ||||
| AddlDescr | nvarchar | max | |||
| LocId | pLocId | ||||
| Unit | pUOM | ||||
| Qty | pDecimal | 0 | |||
| UnitCost | pDecimal | 0 | |||
| BurdenCost | pDecimal | 0 | |||
| CombinedUnitCost | pDecimal | 0 | |||
| ExtCost | pDecimal | 0 | |||
| UnitPrice | pDecimal | 0 | |||
| ExtPrice | pDecimal | 0 | |||
| Reference | nvarchar | 35 | |||
| GLAcctInv | pGlAcct | ||||
| GLAcctSales | pGlAcct | ||||
| GLAcctCOGS | pGlAcct | ||||
| GLAcctBurdenCOGS | pGlAcct | ||||
| GLAcctMatlWIP | pGlAcct | ||||
| GLAcctMatlBurden | pGlAcct | ||||
| GLAcctMatlBurdenWIP | pGlAcct | ||||
| EntryDate | datetime | ||||
| UserID | pUserId | ||||
| CreditId | bigint | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrMaterialChargeExt -- SR Extended Material Charge table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| MatlChargeId | bigint | ||||
| LotNum | pLotNum | ||||
| ExtLocA | int | ||||
| ExtLocB | int | ||||
| Qty | pDecimal | ||||
| UnitCost | pDecimal | 0 | |||
| CreditId | bigint | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrMaterialChargeSer -- SR Serialized Material Charge table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| MatlChargeId | bigint | ||||
| SerNum | pSerNum | ||||
| LotNum | pLotNum | ||||
| ExtLocA | int | ||||
| ExtLocB | int | ||||
| UnitCost | pDecimal | 0 | |||
| UnitPrice | pDecimal | 0 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrMinMaxValue -- SR Minimum/Maximum Values table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| TableId | nvarchar | 25 | |||
| Code | nvarchar | 25 | |||
| MinValue | pDecimal | ||||
| MaxValue | pDecimal | ||||
| Unit | pUom | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrNameplateDef -- SR Nameplate Definition table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| FieldName | nvarchar | 30 | |||
| LookupCode | nvarchar | 20 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrNameplateLookup -- SR Nameplate Lookup table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| LookupCode | nvarchar | 20 | |||
| LookupDescr | nvarchar | 35 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrNameplateLookupValue -- SR Nameplate Lookup Value table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| LookupCode | nvarchar | 20 | |||
| LookupValue | nvarchar | 35 | |||
| Order | int | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrQAWorksheet -- SR QA Worksheet table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| QASheetID | int | ||||
| QASheetName | nvarchar | 100 |
tblSrQAWorksheetDetail -- SR QAWorksheet Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| ID | int | ||||
| JobType | nvarchar | 6 | |||
| CustId | pCustId | ||||
| QASheetId | int |
tblSrQueue -- SR Queue table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| QueueID | nvarchar | 6 | |||
| Descr | pDescription | ||||
| Exclusive | tinyint | ||||
| Priority | int |
tblSrQueueEmployee -- SR Queue Employee table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| QueueID | nvarchar | 6 | |||
| Employee | pEmpID |
tblSrSchedule -- SR Schedule table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | nvarchar | 10 | |||
| Descr | pDescription | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrScheduleBreak -- SR Schedule Break table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| ScheduleId | nvarchar | 10 | |||
| BreakAutoCalc | bit | ||||
| BreakOHJob | pTransId | ||||
| BreakLaborCode | nvarchar | 6 | |||
| LunchAutoCalc | bit | ||||
| LunchStartTime | int | ||||
| LunchEndTime | int | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrScheduleBreakDetail -- SR Schedule Break Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| BreakId | int | ||||
| SeqNum | nvarchar | 3 | |||
| BreakStartTime | int | ||||
| BreakStopTime | int | ||||
| CF | XML | ||||
| Ts | timestamp |
tblSrScheduleCapacityAdj -- SR Schedule Capacity Adjustment table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| WorkType | nvarchar | 6 | |||
| LocId | pLocId | ||||
| LineNumber | tinyint | ||||
| AdjustType | tinyint | 1 = Increase, -1 = Decrease | |||
| AdjustAmt | pDecimal | ||||
| StartDate | datetime | ||||
| EndDate | datetime | ||||
| Comments | nvarchar | 255 | |||
| WhatIf | bit | 0 | |||
| CreateDate | datetime | ||||
| CreatedBy | pUserId | current user | |||
| CF | XML | ||||
| ts | timestamp | ||||
| Sequence | int |
tblSrScheduleDate -- SR Schedule Date table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| ScheduleId | nvarchar | 10 | |||
| Descr | pDescription | ||||
| ScheduleYn | bit | ||||
| BeginDate | datetime | ||||
| EndDate | datetime | ||||
| DayValue | tinyint | ||||
| AutoOT | bit | 0 | Auto calculate overtime for this day | ||
| AutoDT | bit | 0 | Auto calculate double time for this day | ||
| CF | XML | ||||
| ts | timestamp |
tblSrScheduleTime -- SR Schedule Time table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| ScheduleDateId | int | ||||
| BeginTime | int | ||||
| EndTime | int | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrStaticSchedule -- SR Static Schedule table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| ScheduleId | nvarchar | 10 | |||
| Descr | pDescription | ||||
| ActiveYn | bit | ||||
| PreReqWorkTypeCompleted | bit | ||||
| ScheduleStaticDate | datetime | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrStaticScheduleDetail -- SR Static Schedule Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| DetailId | bigint | ||||
| ScheduleId | nvarchar | 10 | |||
| TransId | pTransId | ||||
| DueDate | datetime | ||||
| WorkType | nvarchar | 6 | |||
| LocId | pLocId | ||||
| LineNum | tinyint | ||||
| Hours | pDecimal | ||||
| ScheduledStart | datetime | ||||
| ScheduledComplete | datetime | ||||
| PreReqWorkType | nvarchar | max | |||
| PreReqDate | datetime | ||||
| PoNum | pTransId | ||||
| PoDate | datetime | ||||
| LineSeq | int | ||||
| Comments | nvarchar | 255 | |||
| ShowStaticScheduleDetailYn | bit | -1 = None; 0 = GroupCreated; 1 = EmployeeAssigned; 2 = EmployeeRemoved; 3 = QueueAssigned; 4 = QueueRemoved; 5 = Priority; 6 = NeedsAttention; 7 = NeedAttended; 8 = GroupStateChanged | |||
| CF | XML | ||||
| ts | timestamp | ||||
| Sequence | int |
tblSrStaticScheduleEmployee -- SR Static Schedule Employee table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| DetailId | bigint | ||||
| EmployeeId | pEmpID | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrTimeCardTrans -- SR Time Card Transaction table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| TransId | pTransId | 8 | |||
| ExchRate | pDecimal | ||||
| LineStatus | int | 0=New;1=TrxPost; 2=Billed;3=Posted | |||
| LaborCode | nvarchar | 6 | |||
| EmployeeId | pEmpId | ||||
| RateType | tinyint | 1=REG; 2=OT; 3=DT | |||
| EarningCode | pCode | ||||
| Descr | pDescription | ||||
| AddlDescr | nvarchar | max | |||
| Qty | pDecimal | ||||
| UnitCost | pDecimal | ||||
| UnitCostFgn | pDecimal | ||||
| BurdenCost | pDecimal | ||||
| BurdenCostFgn | pDecimal | ||||
| CombinedUnitCost | pDecimal | ||||
| CombinedUnitCostFgn | pDecimal | ||||
| ExtCost | pDecimal | ||||
| ExtCostFgn | pDecimal | ||||
| UnitPrice | pDecimal | (Billing Rate in Labor lines) | |||
| UnitPriceFgn | pDecimal | (Billing Rate in Labor lines) | |||
| ExtPrice | pDecimal | ||||
| ExtPriceFgn | pDecimal | ||||
| Reference | nvarchar | 35 | |||
| TransDate | datetime | ||||
| PaYear | smallint | ||||
| FiscalYear | smallint | ||||
| FiscalPeriod | smallint | ||||
| GlAcctSales | pGLAcct | ||||
| GlAcctCOGS | pGLAcct | ||||
| GlAcctBurdenCOGS | pGLAcct | ||||
| GlAcctPayrollClearingLabor | pGLAcct | ||||
| GlAcctLaborWIP | pGLAcct | ||||
| GlAcctPayrollClearingLaborBurden | pGLAcct | ||||
| GlAcctLaborBurdenWIP | pGLAcct | ||||
| BillingTransId | pTransId | TransId from Invoice detail table | |||
| BillingEntryNum | int | EntryNum from Invoice detail table | |||
| BillingPostRun | pPostRun | PostRun from Invoice table | |||
| EntryDate | datetime | ||||
| UserID | pUserID | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrTimeClockTrans -- SR Timeclock Transaction table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| TransId | int | ||||
| EmployeeId | pEmpId | ||||
| ScheduleId | nvarchar | 10 | |||
| EntryNum | int | ||||
| RelNum | int | ||||
| TransDate | datetime | ||||
| EntryType | tinyint | 0=Start Job;1=Concurrent Job | |||
| JobId | pTransId | ||||
| LaborCode | nvarchar | 6 | |||
| StartTime | datetime | ||||
| EndTime | datetime | ||||
| ReportedTime | pDecimal | ||||
| InclBreak | bit | ||||
| EditYn | bit | ||||
| OHTime | bit | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrTransContact -- SR Transaction Contact table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| TransId | pTransId | ||||
| JobType | nvarchar | 6 | |||
| DocumentType | smallint | 0 = Estimate, 1 = Quote, 2 = QuickDeliveryTicket, 3 = InfoAlert, 4 = Other | |||
| ContactName | nvarchar | 30 | |||
| ContactType | smallint | 0 = Phone, 1 = Fax, 2 = Email, 3 = Web | |||
| ContactDescr | nvarchar | 255 | |||
| Value | nvarchar | 255 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrTransDetail -- SR Job Transaction Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| TransId | pTransId | ||||
| LineSeq | int | ||||
| LineType | tinyint | 0=Labor; 1=Material;2=Text; 3=Other;-1=Material Credit | |||
| LineStatus | int | 0=New;1=TrxPost; 2=Billed;3=Posted | |||
| LaborCode | nvarchar | 6 | |||
| EmployeeId | pEmpId | ||||
| RateType | tinyint | 1 = REG; 2 = OT; 3 = DT | |||
| EarningCode | pCode | ||||
| ItemId | pItemId | ||||
| LocId | pLocId | ||||
| Descr | pDescription | ||||
| AddlDescr | nvarchar | max | |||
| Unit | pUOM | ||||
| Qty | pDecimal | ||||
| UnitCost | pDecimal | ||||
| UnitCostFgn | pDecimal | ||||
| BurdenCost | pDecimal | ||||
| BurdenCostFgn | pDecimal | ||||
| CombinedUnitCost | pDecimal | ||||
| CombinedUnitCostFgn | pDecimal | ||||
| ExtCost | pDecimal | ||||
| ExtCostFgn | pDecimal | ||||
| UnitPrice | pDecimal | (Billing Rate in Labor lines) | |||
| UnitPriceFgn | pDecimal | (Billing Rate in Labor lines) | |||
| ExtPrice | pDecimal | ||||
| ExtPriceFgn | pDecimal | ||||
| Rep1Id | pSalesRep | ||||
| Rep1Pct | pDecimal | ||||
| Rep1CommRate | pDecimal | ||||
| Rep2Id | pSalesRep | ||||
| Rep2Pct | pDecimal | ||||
| Rep2CommRate | pDecimal | ||||
| UnitCommBasis | pDecimal | ||||
| UnitCommBasisFgn | pDecimal | ||||
| Reference | nvarchar | 35 | |||
| VendorId | pVendorId | ||||
| PriceId | nvarchar | 10 | |||
| TransDate | datetime | ||||
| PaYear | smallint | ||||
| FiscalYear | smallint | ||||
| FiscalPeriod | smallint | ||||
| AcctCode | nvarchar | 2 | |||
| GlAcctSales | pGLAcct | ||||
| GlAcctCOGS | pGLAcct | ||||
| GlAcctBurdenCOGS | pGLAcct | ||||
| GlAcctInv | pGLAcct | ||||
| GlAcctMatlWIP | pGLAcct | ||||
| GlAcctMatlBurden | pGLAcct | ||||
| GlAcctMatlBurdenWIP | pGLAcct | ||||
| GlAcctPayrollClearingLabor | pGLAcct | ||||
| GlAcctLaborWIP | pGLAcct | ||||
| GlAcctPayrollClearingLaborBurden | pGLAcct | ||||
| GlAcctLaborBurdenWIP | pGLAcct | ||||
| HistSeqNum | int | ||||
| QtySeqNum_Cmtd | int | ||||
| QtySeqNum | int | ||||
| LinkSeqNum | int | ||||
| TransPostRun | pPostRun | ||||
| BillingTransId | pTransId | TransId from Invoice detail table | |||
| BillingEntryNum | int | EntryNum from Invoice detail table | |||
| BillingPostRun | pPostRun | PostRun from Invoice table | |||
| EntryDate | datetime | ||||
| UserId | pUserID | ||||
| CreditId | bigint | ||||
| AddlPoInvCostYn | bit | ||||
| POInvoiceID | uniqueidentifier | ||||
| POReceivingDate | datetime | ||||
| PORcptNum | pInvoiceNum | ||||
| PORcptID | uniqueidentifier | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrTransDetailExt -- SR Job Transaction Extended Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| TransId | pTransId | ||||
| LineDetailId | bigint | ||||
| LotNum | pLotNum | ||||
| Quantity | pDecimal | ||||
| UnitCost | pDecimal | ||||
| UnitCostFgn | pDecimal | ||||
| HistSeqNum | int | ||||
| QtySeqNum | int | ||||
| QtySeqNum_Cmtd | int | ||||
| QtySeqNum_Ext | int | ||||
| ExtLocA | int | ||||
| ExtLocB | int | ||||
| CreditId | bigint | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrTransDetailSer -- SR Job Transaction Serialized Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| TransId | pTransId | ||||
| LineDetailId | bigint | ||||
| SerNum | pSerNum | ||||
| LotNum | pLotNum | ||||
| UnitCost | pDecimal | 0 | |||
| UnitCostACV | pDecimal | 0 | |||
| UnitPrice | pDecimal | 0 | |||
| UnitCostFgn | pDecimal | 0 | |||
| UnitPriceFgn | pDecimal | 0 | |||
| HistSeqNum | int | ||||
| ExtLocA | int | ||||
| ExtLocB | int | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrTransEstimate -- SR Job Transaction Estimate table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| TransId | pTransId | ||||
| LineSeq | int | ||||
| LineType | smallint | 0=Labor; 1=Material; 2=Text; 3=Other | |||
| LaborCode | nvarchar | 6 | |||
| ItemId | pItemId | ||||
| SchedWorkType | nvarchar | 6 | |||
| LocId | pLocId | ||||
| Descr | pDescription | ||||
| AddlDescr | nvarchar | max | |||
| Qty | pDecimal | ||||
| Unit | pUOM | ||||
| UnitCost | pDecimal | ||||
| UnitCostFgn | pDecimal | ||||
| BurdenCost | pDecimal | ||||
| BurdenCostFgn | pDecimal | ||||
| CombinedUnitCost | pDecimal | ||||
| CombinedUnitCost Fgn | pDecimal | ||||
| ExtCost | pDecimal | ||||
| ExtCostFgn | pDecimal | ||||
| UnitPrice | pDecimal | ||||
| UnitPriceFgn | pDecimal | ||||
| ExtPrice | pDecimal | ||||
| ExtPriceFgn | pDecimal | ||||
| Rep1Id | pSalesRep | ||||
| Rep1Pct | pDecimal | ||||
| Rep1CommRate | pDecimal | ||||
| Rep2Id | pSalesRep | ||||
| Rep2Pct | pDecimal | ||||
| Rep2CommRate | pDecimal | ||||
| UnitCommBasis | pDecimal | ||||
| UnitCommBasisFgn | pDecimal | ||||
| VendorId | pVendorId | ||||
| LinkSeqNum | int | ||||
| FromPoYn | bit | ||||
| IncludeYn | bit | ||||
| TaxClass | tinyint | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrTransEquipTestDetail -- SR Job Transaction Equipment Test Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| EquipTestHdrID | bigint | ||||
| TestElementID | nvarchar | 2 | |||
| TestElementValue | pDecimal | ||||
| TestDate | datetime | 8 |
tblSrTransEquipTestHeader -- SR Job Transaction Equipment Test Header table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | bigint | ||||
| TestTypeID | nvarchar | 2 | |||
| TransId | pTransId | ||||
| TechnicianName | nvarchar | 40 | |||
| Notes | pDescription | ||||
| MachineOrigins | pDescription |
tblSrTransHeader -- SR Job Transaction Header table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| TransId | pTransId | ||||
| TransType | smallint | 1 = Quote; 2 = Estimate Job; 3 = Approved Job | |||
| TransStatus | tinyint | 0 = Open; 1 = Closed; 2 = On Hold; | |||
| InvcNum | pInvoiceNum | ||||
| LastInvcDate | datetime | ||||
| InvcAmount | pDec | 0 | |||
| InvcAmountFgn | pDec | 0 | |||
| BatchId | pBatchId | ###### | |||
| DeptCode | pDeptID | ||||
| PrintLaborPrice | tinyint | ||||
| PrintMatlPrice | tinyint | ||||
| PrintOtherPrice | tinyint | ||||
| PrintTextPrice | tinyint | ||||
| PrintEstLaborPrice | tinyint | ||||
| PrintEstMatlPrice | tinyint | ||||
| PrintEstOtherPrice | tinyint | ||||
| PrintEstTextPrice | tinyint | ||||
| PrintEstSubTotals | tinyint | ||||
| PrintSubTotals | tinyint | ||||
| PrintEstTotals | tinyint | ||||
| PrintTotals | tinyint | ||||
| InvcFrom | tinyint | ||||
| JobTypeId | nvarchar | 6 | |||
| DistCode | pDistCode | ||||
| CustId | pCustId | ||||
| BillToId | pCustId | ||||
| Contact | nvarchar | 25 | |||
| ShipToId | pCustId | ||||
| ShipToAttn | nvarchar | 30 | |||
| ShipToName | nvarchar | 30 | |||
| ShipToAddr1 | nvarchar | 30 | |||
| ShipToAddr2 | nvarchar | 60 | |||
| ShipToCity | nvarchar | 30 | |||
| ShipToRegion | nvarchar | 10 | |||
| ShipToCountry | pCountry | ||||
| ShipToPostalCode | nvarchar | 10 | |||
| ShipToMethod | nvarchar | 6 | |||
| ShipVia | nvarchar | 20 | |||
| NameplateDescr | nvarchar | 40 | |||
| JobDescr | nvarchar | 80 | |||
| EnteredBy | pUserId | ||||
| QuoteId | pTransId | ||||
| Priority | nvarchar | ||||
| FailCode1 | nvarchar | 6 | |||
| FailCode2 | nvarchar | 6 | |||
| DetailPrice | nvarchar | tinyint | N | N=Totals Only; 1=Detail; 2=Labor Ext Price and Material Detail; 3=Ext Price Only | |
| FinalBillYn | bit | 0 | |||
| QuoteValidDays | int | 30 | |||
| WarrantyYn | bit | 0 | |||
| OHJobYn | bit | 0 | |||
| PriceFirstYn | bit | 0 | |||
| OTFlag | bit | 0 | |||
| Rep1Id | pSalesRep | ||||
| Rep1Pct | pDecimal | ||||
| Rep1CommRate | pDecimal | ||||
| Rep2Id | pSalesRep | ||||
| Rep2Pct | pDecimal | ||||
| Rep2CommRate | pDecimal | ||||
| SalesRepNotes | text | ||||
| SpecialInstr | text | ||||
| ShopLocation | nvarchar | 80 | |||
| LocID | pLocId | ||||
| ReplItem | pItemId | ||||
| ReplItemDescr | nvarchar | 60 | |||
| ReplItemPrice | pDecimal | ||||
| ShipNum | nvarchar | 18 | |||
| CustLevel | nvarchar | 10 | |||
| CustPONum | nvarchar | 25 | |||
| POReleaseNum | nvarchar | 25 | |||
| MiscNum | nvarchar | 25 | |||
| CurrencyId | pCurrency | ||||
| ExchRate | pDecimal | ||||
| QuoteAmt | pDecimal | ||||
| QuoteAmtFgn | pDecimal | ||||
| BudgetAmt | pDecimal | ||||
| BudgetAmtFgn | pDecimal | ||||
| TotEstAmt | pDecimal | ||||
| TotEstAmtFgn | pDecimal | ||||
| FreightBilled | pDecimal | ||||
| FreightBilledFgn | pDecimal | ||||
| FreightToBill | pDecimal | ||||
| FreightToBillFgn | pDecimal | ||||
| TotEstCost | pDecimal | ||||
| TotEstCostFgn | pDecimal | ||||
| DateConfirmedYn | bit | ||||
| PromiseDate | datetime | ||||
| EstimateDate | datetime | ||||
| ShipDate | datetime | ||||
| EstCompleteDate | datetime | ||||
| EstApprovedDate | datetime | ||||
| StartDate | datetime | ||||
| FirstLaborDate | datetime | ||||
| LastLaborDate | datetime | ||||
| MatlPickDate | datetime | ||||
| JobCloseDate | datetime | ||||
| TransDate | datetime | Also referred to as Received Date | |||
| LostReasonCode | nvarchar | 6 | |||
| FiscalYear | smallint | ||||
| FiscalPeriod | smallint | ||||
| SourceId | uniqueidentifier | ||||
| TaxLocAdj | pTaxLoc | ||||
| TaxClassAdj | tinyint | ||||
| TaxAmtAdj | tinyint | ||||
| TaxAmtAdjFgn | tinyint | ||||
| SalesTax | pDecimal | 0 | |||
| SalesTaxFgn | pDec | 0 | |||
| TaxGrpID | pTaxLoc | ||||
| TotNoTaxEstAmt | pDecimal | 0 | |||
| TotNoTaxEstAmtFgn | pDecimal | 0 | |||
| TotEst | pDecimal | ||||
| TotEstFgn | pDecimal | ||||
| TotEstTax | pDecimal | ||||
| TotEstTaxFgn | pDecimal | 0 | |||
| CustDistCode | pDistCode | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrTransLink -- SR Job Transaction Link table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| ParentTransId | pTransId | ||||
| LinkedTransId | pTransId |
tblSrTransNameplate -- SR Job Transaction Nameplate table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| TransId | pTransId | 8 | |||
| Priority | int | ||||
| NameplateFieldID | int | ||||
| NameplateFieldValue | nvarchar | 35 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrTransPicture -- SR Job Transaction Picture table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| TransId | pTransId | 8 | |||
| TypeSeq | int | 2 | |||
| Sequence | int | ||||
| PictureGroup | nvarchar | 10 | |||
| Description | pDescription | ||||
| Notes | text | ||||
| PictureID | nvarchar | 25 | |||
| SubFolder | nvarchar | 30 | |||
| JobType | nvarchar | 10 | |||
| PicturePath | nvarchar | 200 | |||
| PictureIDActual | nvarchar | 55 | |||
| CheckMarkPath | nvarchar | 200 |
tblSrTransPmt -- SR Transaction Prepayment table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| PmtNum | int | ||||
| PmtDate | datetime | ||||
| TransId | pTransId | ||||
| DepositId | pBatchId | ||||
| LinkId | int | ||||
| InvoiceLink | pTransID | ||||
| PmtMethodId | varchar | 10 | |||
| CcNum | nvarchar | 255 | |||
| CcHolder | varchar | 30 | |||
| CcExpire | datetime | ||||
| CcAuth | varchar | 10 | |||
| CheckNum | pCheckNum | ||||
| Note | varchar | 25 | |||
| PmtAmt | pDecimal | 0 | |||
| PmtAmtFgn | pDecimal | 0 | |||
| CurrencyID | pCurrency | ||||
| ExchRate | pDecimal | 1 | |||
| PostedYn | bit | 0 | |||
| PreparedYn | bit | 0 | |||
| CcSecCode | varchar | 6 | |||
| BankName | varchar | 30 | |||
| BankRoutingCode | varchar | 19 | |||
| BankAcctNum | nvarchar | 255 | |||
| GlPeriod | smallint | ||||
| FiscalYear | smallint | ||||
| GlAcctReceivables | pGlAcct | ||||
| ExtPmtActivityID | bigint | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrTransSchedule -- SR Job Transaction Schedule table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| TransId | pTransId | ||||
| Priority | int | ||||
| WorkType | nvarchar | 6 | |||
| ScheduleYn | bit | ||||
| EstimateHours | pDecimal | ||||
| SchedDate | datetime | ||||
| FirstLaborDate | datetime | ||||
| CompleteDate | datetime | ||||
| SchDuringEstYn | bit | ||||
| UseEstHoursYn | bit | ||||
| HoldUntil | datetime | ||||
| Comments | varchar | max | |||
| CF | XML | ||||
| ts | timestamp | ||||
| Sequence | int | 1 |
tblSrTransStatus -- SR Job Transaction Status table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| TransId | pTransId | ||||
| UserId | pUserID | ||||
| HostId | pWrkStnID | ||||
| Status | nvarchar | 50 | |||
| StatusDate | datetime | ||||
| StatusTime | datetime | ||||
| DashboardStatus | smallint | 0 = None; 1 = New; 2 = Active; 3 = ReadyToEstimate; 4 = WaitingForApproval; 5 = InProcess; 6 = WaitingParts; 7 = Complete; 8 = InvoiceClosed | |||
| CF | XML | ||||
| ts | timestamp |
tblSrTransTax -- SR Transaction Tax table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| TransId | pTransID | ||||
| TaxLocId | pTaxLoc | ||||
| TaxClass | tinyint | ||||
| Level | tinyint | ||||
| TaxAmt | pDecimal | 0 | |||
| TaxAmtFgn | pDecimal | 0 | |||
| Taxable | pDecimal | 0 | |||
| TaxableFgn | pDecimal | 0 | |||
| NonTaxable | pDecimal | 0 | |||
| NonTaxableFgn | pDecimal | 0 | |||
| LiabilityAcct | pGlAcct | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrWorkPlanDetail -- SR Work Plan Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| WorkPlanId | pTransId | ||||
| LineSeq | int | ||||
| LineType | smallint | 1 = Labor; 1 = Material; 2 = Text; 3 = Other | |||
| LaborCode | nvarchar | 6 | |||
| ItemId | pItemId | ||||
| LocId | pLocId | ||||
| Descr | pDescription | ||||
| AddlDescr | nvarchar | max | |||
| Qty | pDecimal | ||||
| Unit | pUOM | ||||
| UnitCost | pDecimal | 0 | |||
| BurdenCost | pDecimal | 0 | |||
| CombinedUnitCost | pDecimal | 0 | |||
| ExtCost | pDecimal | ||||
| UnitPrice | pDecimal | ||||
| ExtPrice | pDecimal | ||||
| VendorId | pVendorId | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrWorkPlanHeader -- SR Work Plan Header table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| WorkPlanId | pTransId | ||||
| Descr | pDescription | ||||
| CustId | pCustId | ||||
| LocId | pLocId | ||||
| JobTypeId | nvarchar | 6 | |||
| DeptCode | pDeptID | ||||
| CF | XML | ||||
| ts | timestamp |
tblSrWorkPlanNameplate -- SR Work Plan Nameplate table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| WorkPlanId | pTransId | ||||
| NameplateFieldID | int | ||||
| Priority | int | ||||
| NameplateFieldValue | nvarchar | 35 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrWorkTypes -- SR Work Types table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| WorkType | nvarchar | 6 | |||
| Descr | pDescription | ||||
| StdLaborCostRate | pDecimal | 0 | |||
| PrintJobCards | bit | ||||
| ScheduleID | nvarchar | 10 | |||
| CF | XML | ||||
| ts | timestamp |
tblSrWorkTypesDetail -- SR Work Types Detail table
| Column Name | Column Type | Length | Default Value | Description | Enumeration |
|---|---|---|---|---|---|
| Id | int | ||||
| WorkType | nvarchar | 6 | |||
| LocId | pLocId | ||||
| LineNum | tinyint | ||||
| Descr | pDescription | ||||
| ScheduleID | nvarchar | 10 | |||
| AdjustType | smallint | ||||
| AdjustScale | smallint | ||||
| AdjustAmt | pDecimal | 0 | |||
| CF | XML | ||||
| ts | timestamp |