SV_Job_Costs_HISTORY (SV000815)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV000815

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_Job_Costs_HISTORY
Physical Name: SV000815
Technical Name: SV_Job_Costs_HISTORY

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Service_Call_ID SearchService Call IDSTR17_LBAUString17
2Call_Invoice_Number SearchCall Invoice NumberSTR17_LBAUString17
3JRNENTRY SearchJournal EntryLI8_U0Long Integer8
4OH_ACTINDX_CR SearchOH Account Index CRLI_14Long Integer14
5OH_ACTINDX_DR SearchOH Account Index DRLI_14Long Integer14
6Divisions SearchDivisionsSTR15_LBAUString15
7UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
8Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
9Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
10Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
11USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Job_Costs_HISTORY'].USERID AS 'SV_Job_Costs_HISTORY-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV000815 AS ['SV_Job_Costs_HISTORY']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Job_Costs_HISTORY'].USERID = ['Users Master'].USERID
12Technician_ID SearchTechnician IDSTR15_Employee_IDString15
13Technician_Team SearchTechnician TeamSTR15_LBAUString15
14Reference_TRX_Number SearchReference TRX NumberSTR17_LBAUString17
15CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_Job_Costs_HISTORY'].CUSTNMBR AS 'SV_Job_Costs_HISTORY-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SV000815 AS ['SV_Job_Costs_HISTORY']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Job_Costs_HISTORY'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
16ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
17SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
18WS_Job_Name SearchWS Job NameSTR30String30
19Job_Type SearchJob TypeSTR7_LBAUString7
20Appointment SearchAppointmentSTR25String25
21Sub_Task_Code SearchSub Task CodeSTR10String10
22Added_Rate SearchAdded RateYNBoolean0
23Travel_Transaction SearchTravel TransactionBooleanBoolean0
24WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer8
25WS_Other_Cost_Sub_Code SearchWS Other Cost Sub CodeLI8_U0Long Integer8
26Cost_Code_Description SearchCost Code DescriptionSTR30String30
27Task_Code SearchTask CodeSTR10String10
28DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
29DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
30DOCDATE SearchDocument DateDTDate8
31TRXDSCRN SearchTransaction DescriptionSTR30String30
32Billable_Check_Box SearchBillable Check BoxCB_BillableBoolean0
33TAXABLE SearchTaxableCB_TaxableBoolean0
34TRXSOURC SearchTransaction SourceSTR25String25
35Billing_Amount SearchBilling AmountDLR14_RBS0_STR$Currency14
36VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SV_Job_Costs_HISTORY'].VENDORID AS 'SV_Job_Costs_HISTORY-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       SV000815 AS ['SV_Job_Costs_HISTORY']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SV_Job_Costs_HISTORY'].VENDORID = ['PM Vendor Master File'].VENDORID
37VENDNAME SearchVendor NameSTR64_Vendor_NameString64
38Equipment_ID SearchEquipment IDSTR30String30
39Equipment_Type SearchEquipment TypeSTR30String30
40Dynamics_Status SearchDynamics StatusSTR4_LBAUString4
41Wennsoft_Status SearchWennsoft StatusSTR4_LBAUString4
42BACHNUMB SearchBatch NumberSTR15_LBAUString15
43BCHSOURC SearchBatch SourceSTR15String15
44TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer6
45EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
46EMPLNAME SearchEmployee NameSTR40String40
47VCHNUMWK SearchVoucher Number - WORKSTR17_LBAUString17
48OH_Amount SearchOH AmountDLR14_RBS0_STR$Currency14
49EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
50WS_Extended_Cost SearchWS Extended CostDLR14_RBS0_STR$Currency14
51TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency17
52UOFM SearchU Of MU_Of_MString8
53ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SV_Job_Costs_HISTORY'].ITEMNMBR AS 'SV_Job_Costs_HISTORY-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SV000815 AS ['SV_Job_Costs_HISTORY']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SV_Job_Costs_HISTORY'].ITEMNMBR = ['Item Master'].ITEMNMBR
54ITEMDESC SearchItem DescriptionSTR100String100
55UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency17
56JOBTITLE SearchJob TitleSTR6_Payroll_CodeString6
57PAYRCORD SearchPay RecordSTR6_Payroll_CodeString6
58PAYRATE SearchPay RateDLR11_$S2Currency14
59Billing_Rate SearchBilling RateDLR14_RBS0_STR$Currency14
60Add_New_Equipment_Record SearchAdd New Equipment RecordCBBoolean0
61New_Equipment_ID SearchNew Equipment IDSTR10String10
62Wennsoft_Model_Number SearchWennsoft Model NumberSTR20String20
63Wennsoft_Serial_Number SearchWennsoft Serial NumberSTR40String40
64Manufacturer_ID SearchManufacturer IDSTR15_LBAUString15
65Note_Checkbox SearchNote CheckboxCBBoolean0
66TRXHRUNTBILL SearchTRX Hours/Units BillLI6_S2Long Integer6
67WS_Committed_Cost SearchWS Committed CostDLR14_RBS0_STR$Currency14
68TRXQTYBILL SearchTRX QTY BILLDLR17_QTY_RBS0_STRCurrency17
69WIP_ACTINDX_CR SearchWIP Account Index CreditLI_14Long Integer14
70OH_WIP_ACTINDX_CR SearchOH WIP Account Index CreditLI_14Long Integer14
71ACTINDX_CR SearchAccount Index CreditLI_14Long Integer14
72ACTINDX_DR SearchAccount Index DebitLI_14Long Integer14
73INV_ACTINDX_DR SearchInvoice Account Index DebitLI_14Long Integer14
74INV_ACTINDX_CR SearchInvoice Account Index CreditLI_14Long Integer14
75SHFTCODE SearchShift CodeSTR6_Payroll_CodeString6
76SHFTPREM SearchShift PremiumDLR11_$S2Currency14
77Labor_Group_Name SearchLabor Group NameSTR15_RM_Customer_NumberString15
78Pricing_Matrix_Name SearchPricing Matrix NameSTR15_RM_Customer_NumberString15
79Travel_Rate_Name SearchTravel Rate NameSTR15_RM_Customer_NumberString15
80Service_User_Define_1 SearchService User Define 1STR20String20
81Service_User_Define_2 SearchService User Define 2STR20String20
82Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer6
83Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer6
84Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer6
85Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer6
86Service_User_Define_9 SearchService User Define 9DTDate8
87Service_User_Define_10 SearchService User Define 10DTDate8
88Service_User_Define_11 SearchService User Define 11DTDate8
89Service_User_Define_12 SearchService User Define 12DTDate8
90Service_User_Define_18 SearchService User Define 18CBBoolean0
91Service_User_Define_19 SearchService User Define 19CBBoolean0
92Service_User_Define_20 SearchService User Define 20CBBoolean0
93Service_User_Define_21 SearchService User Define 21CBBoolean0
94Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency14
95Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency14
96Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency14
97Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency14
98MODIFDT SearchModified DateDTDate8
99Modified_Time SearchModified TimeTM6Time6
100MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Job_Costs_HISTORY'].MDFUSRID AS 'SV_Job_Costs_HISTORY-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV000815 AS ['SV_Job_Costs_HISTORY']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Job_Costs_HISTORY'].MDFUSRID = ['Users Master'].USERID
101Time_Zone SearchTime ZoneSTR3String3
102SV_Language_ID SearchSV Language IDINT2Integer2
103Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString15
104Base_Curr_Conv_Factor SearchBase Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)14
105Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString15
106Billing_Curr_Conv_Factor SearchBilling Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)14
107Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString15
108WSReserved_CB1 SearchWSReserved CB1CBBoolean0
109WSReserved_CB2 SearchWSReserved CB2CBBoolean0
110WSReserved_CB3 SearchWSReserved CB3CBBoolean0
111WSReserved_CB4 SearchWSReserved CB4CBBoolean0
112WSReserved_CB5 SearchWSReserved CB5CBBoolean0
113WSReserved_CB6 SearchWSReserved CB6CBBoolean0
114WSReserved_CB7 SearchWSReserved CB7CBBoolean0
115WSReserved_CB8 SearchWSReserved CB8CBBoolean0
116WSReserved_CB9 SearchWSReserved CB9CBBoolean0
117WSReserved_CB10 SearchWSReserved CB10CBBoolean0
118WSReserved_STR1 SearchWSReserved STR1STR10String10
119WSReserved_STR2 SearchWSReserved STR2STR10String10
120WS_Created_Date SearchWS Created DateDTDate8
121WS_Created_Time SearchWS Created TimeTM6Time6
122GLPOSTDT SearchGL Posting DateDTDate8
123BilledToJob SearchBilledToJobDLR14_RBS0_STR$Currency14
124WS_Grouped SearchWS GroupedBooleanBoolean0
125REVSETRX SearchReverse TRXCB_Reverse_TRXBoolean0
126PYADNMBR SearchPayment/Adjustment NumberLI8_U0Long Integer8
127VOIDPYADNMBR SearchVoid Payment/Adjustment NumberLI8_U0Long Integer8
128WS_Transaction_Note SearchWS Transaction NoteTX500Text500

Leave a Reply

Your email address will not be published. Required fields are marked *