ServiceJCHWarehouse (SVINTER7)

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

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

Display Name: ServiceJCHWarehouse
Physical Name: SVINTER7
Technical Name: ServiceJCHWarehouse

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Service_Call_ID SearchService Call IDSTR17_LBAUString17
2Call_Invoice_Number SearchCall Invoice NumberSTR17_LBAUString17
3Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
4Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
5Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
6USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['ServiceJCHWarehouse'].USERID AS 'ServiceJCHWarehouse-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVINTER7 AS ['ServiceJCHWarehouse']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['ServiceJCHWarehouse'].USERID = ['Users Master'].USERID
7Technician_ID SearchTechnician IDSTR15_Employee_IDString15
8Technician_Team SearchTechnician TeamSTR15_LBAUString15
9Reference_TRX_Number SearchReference TRX NumberSTR17_LBAUString17
10CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['ServiceJCHWarehouse'].CUSTNMBR AS 'ServiceJCHWarehouse-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVINTER7 AS ['ServiceJCHWarehouse']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['ServiceJCHWarehouse'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
11ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
12SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
13WS_Job_Name SearchWS Job NameSTR30String30
14Job_Type SearchJob TypeSTR7_LBAUString7
15WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer8
16Cost_Code_Description SearchCost Code DescriptionSTR30String30
17Task_Code SearchTask CodeSTR10String10
18DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
19DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
20DOCDATE SearchDocument DateDTDate8
21TRXDSCRN SearchTransaction DescriptionSTR30String30
22Billable_Check_Box SearchBillable Check BoxCB_BillableBoolean0
23TAXABLE SearchTaxableCB_TaxableBoolean0
24TRXSOURC SearchTransaction SourceSTR25String25
25Billing_Amount SearchBilling AmountDLR14_RBS0_STR$Currency14
26VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['ServiceJCHWarehouse'].VENDORID AS 'ServiceJCHWarehouse-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       SVINTER7 AS ['ServiceJCHWarehouse']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['ServiceJCHWarehouse'].VENDORID = ['PM Vendor Master File'].VENDORID
27VENDNAME SearchVendor NameSTR64_Vendor_NameString64
28Equipment_ID SearchEquipment IDSTR30String30
29Equipment_Type SearchEquipment TypeSTR30String30
30Dynamics_Status SearchDynamics StatusSTR4_LBAUString4
31Wennsoft_Status SearchWennsoft StatusSTR4_LBAUString4
32BACHNUMB SearchBatch NumberSTR15_LBAUString15
33BCHSOURC SearchBatch SourceSTR15String15
34TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer6
35EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
36EMPLNAME SearchEmployee NameSTR40String40
37VCHNUMWK SearchVoucher Number - WORKSTR17_LBAUString17
38OH_Amount SearchOH AmountDLR14_RBS0_STR$Currency14
39EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
40WS_Extended_Cost SearchWS Extended CostDLR14_RBS0_STR$Currency14
41TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency17
42UOFM SearchU Of MU_Of_MString8
43ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['ServiceJCHWarehouse'].ITEMNMBR AS 'ServiceJCHWarehouse-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVINTER7 AS ['ServiceJCHWarehouse']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['ServiceJCHWarehouse'].ITEMNMBR = ['Item Master'].ITEMNMBR
44ITEMDESC SearchItem DescriptionSTR100String100
45UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency17
46JOBTITLE SearchJob TitleSTR6_Payroll_CodeString6
47PAYRCORD SearchPay RecordSTR6_Payroll_CodeString6
48PAYRATE SearchPay RateDLR11_$S2Currency14
49Billing_Rate SearchBilling RateDLR14_RBS0_STR$Currency14
50Add_New_Equipment_Record SearchAdd New Equipment RecordCBBoolean0
51New_Equipment_ID SearchNew Equipment IDSTR10String10
52Wennsoft_Model_Number SearchWennsoft Model NumberSTR20String20
53Wennsoft_Serial_Number SearchWennsoft Serial NumberSTR40String40
54Manufacturer_ID SearchManufacturer IDSTR15_LBAUString15
55Note_Checkbox SearchNote CheckboxCBBoolean0
56Service_User_Define_1 SearchService User Define 1STR20String20
57Service_User_Define_2 SearchService User Define 2STR20String20
58Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer6
59Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer6
60Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer6
61Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer6
62Service_User_Define_9 SearchService User Define 9DTDate8
63Service_User_Define_10 SearchService User Define 10DTDate8
64Service_User_Define_11 SearchService User Define 11DTDate8
65Service_User_Define_12 SearchService User Define 12DTDate8
66Service_User_Define_18 SearchService User Define 18CBBoolean0
67Service_User_Define_19 SearchService User Define 19CBBoolean0
68Service_User_Define_20 SearchService User Define 20CBBoolean0
69Service_User_Define_21 SearchService User Define 21CBBoolean0
70Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency14
71Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency14
72Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency14
73Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency14
74MODIFDT SearchModified DateDTDate8
75Modified_Time SearchModified TimeTM6Time6
76MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['ServiceJCHWarehouse'].MDFUSRID AS 'ServiceJCHWarehouse-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVINTER7 AS ['ServiceJCHWarehouse']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['ServiceJCHWarehouse'].MDFUSRID = ['Users Master'].USERID
77Time_Zone SearchTime ZoneSTR3String3
78SV_Language_ID SearchSV Language IDINT2Integer2
79Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString15
80Base_Curr_Conv_Factor SearchBase Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)14
81Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString15
82Billing_Curr_Conv_Factor SearchBilling Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)14
83Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString15
84WSReserved_CB1 SearchWSReserved CB1CBBoolean0
85WSReserved_CB2 SearchWSReserved CB2CBBoolean0
86WSReserved_CB3 SearchWSReserved CB3CBBoolean0
87WSReserved_CB4 SearchWSReserved CB4CBBoolean0
88WSReserved_CB5 SearchWSReserved CB5CBBoolean0
89WSReserved_CB6 SearchWSReserved CB6CBBoolean0
90WSReserved_CB7 SearchWSReserved CB7CBBoolean0
91WSReserved_CB8 SearchWSReserved CB8CBBoolean0
92WSReserved_CB9 SearchWSReserved CB9CBBoolean0
93WSReserved_CB10 SearchWSReserved CB10CBBoolean0
94WSReserved_STR1 SearchWSReserved STR1STR10String10
95WSReserved_STR2 SearchWSReserved STR2STR10String10
96WS_Created_Date SearchWS Created DateDTDate8
97WS_Created_Time SearchWS Created TimeTM6Time6
98WS_Transaction_Note SearchWS Transaction NoteTX500Text500

Leave a Reply

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