SV_Invoices_To_Group_TEMP (SV00799)

azurecurveProductsWennSoft Products (131)3rd PartySV_Invoices_To_Group_TEMP (SV00799)

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

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

Display Name: SV_Invoices_To_Group_TEMP
Physical Name: SV00799
Technical Name: SV_Invoices_To_Group_TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Service_Call_ID SearchService Call IDSTR17_LBAUString1817
2Reference_TRX_Number SearchReference TRX NumberSTR17_LBAUString1817
3SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
4USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Invoices_To_Group_TEMP'].USERID AS 'SV_Invoices_To_Group_TEMP-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00799 AS ['SV_Invoices_To_Group_TEMP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Invoices_To_Group_TEMP'].USERID = ['Users Master'].USERID
5RMDNUMWK SearchRM Document Number-WORKSTR17_LBAUString1817
6RMDTYPAL SearchRM Document Type-AllINT2Integer22
Document Type records the type of document.

Click to show/hide the Document Types


0	Balance Carried Forward
1	Sales / Invoice
2	Scheduled Payments
3	Debit Memo
4	Finance Charge
5	Service Repairs
6	Warranties
7	Credit Memo
8	Returns
9	Payments
7BACHNUMB SearchBatch NumberSTR15_LBAUString1615
8Group_Invoice_Checkbox SearchGroup Invoice CheckboxCBBoolean20
9Bill_Checkbox SearchBill CheckboxCBBoolean20
10Completion_Date SearchSV Completion DateDTDate48
11Divisions SearchDivisionsSTR15_LBAUString1615
12WS_Job_Type SearchWS Job TypeSTR17_LBAUString1817
13WS_Job_Name SearchWS Job NameSTR30String3230
14Committed_Cost SearchCommitted CostDLR19_TSCurrency1019
15WS_Extended_Cost SearchWS Extended CostDLR14_RBS0_STR$Currency1014
16Billing_Amount SearchBilling AmountDLR14_RBS0_STR$Currency1014
17Call_Invoice_Number SearchCall Invoice NumberSTR17_LBAUString1817
18Bill_Customer_Number SearchBill Customer NumberSTR15_RM_Customer_NumberString1615
19CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
20Bill_Address_Code SearchBill Address CodeSTR15_Address_CodeString1615
21Bill_To_Location_Name SearchBill To Location NameSTR30String3230
22VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SV_Invoices_To_Group_TEMP'].VENDORID AS 'SV_Invoices_To_Group_TEMP-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       SV00799 AS ['SV_Invoices_To_Group_TEMP']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SV_Invoices_To_Group_TEMP'].VENDORID = ['PM Vendor Master File'].VENDORID
23WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer48
24Cost_Code_Description SearchCost Code DescriptionSTR30String3230
25WS_Other_Cost_Sub_Code SearchWS Other Cost Sub CodeLI8_U0Long Integer48
26WS_Sub_Code_Desc SearchWS Sub Code DescriptionSTR30_LBAUString3230
27ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SV_Invoices_To_Group_TEMP'].ITEMNMBR AS 'SV_Invoices_To_Group_TEMP-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SV00799 AS ['SV_Invoices_To_Group_TEMP']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SV_Invoices_To_Group_TEMP'].ITEMNMBR = ['Item Master'].ITEMNMBR
28ITEMDESC SearchItem DescriptionSTR100String102100
29Billable_All SearchBillable AllDLR14_RBS0_STR$Currency1014
30Cost_All SearchCost AllDLR14_RBS0_STR$Currency1014
31PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
azurecurveProductsWennSoft Products (131)3rd PartySV_Invoices_To_Group_TEMP (SV00799)

Leave a Reply

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