Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVA0568
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Maint_Billing_Note_Archive
Physical Name: SVA0568
Technical Name: SV_Maint_Billing_Note_ArchiveSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_Maint_Billing_Note_Archive'].CUSTNMBR AS 'SV_Maint_Billing_Note_Archive-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVA0568 AS ['SV_Maint_Billing_Note_Archive']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Maint_Billing_Note_Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 ADRSCODE Address Code STR15_Address_Code String 15 3 Contract_Number WS Contract Number STR10 String 10 4 WSCONTSQ WS Contract Number Sequence LI_Sequence_Number Long Integer 10 5 RMDNUMWK RM Document Number-WORK STR17_LBAU String 17 6 RMDTYPAL RM Document Type-All INT2 Integer 2 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 Payments7 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Maint_Billing_Note_Archive'].USERID AS 'SV_Maint_Billing_Note_Archive-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVA0568 AS ['SV_Maint_Billing_Note_Archive']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Maint_Billing_Note_Archive'].USERID = ['Users Master'].USERID8 Note_Author Note Author STR_20 String 20 9 DATE1 Date DT6 Date 6 10 TIME1 Time TM6 Time 6 11 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['SV_Maint_Billing_Note_Archive'].NOTEINDX AS 'SV_Maint_Billing_Note_Archive-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SVA0568 AS ['SV_Maint_Billing_Note_Archive']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SV_Maint_Billing_Note_Archive'].NOTEINDX = ['Record Notes Master'].NOTEINDX12 USERNAME User Name STR30 String 30 13 MODIFDT Modified Date DT Date 8 14 Modified_Time Modified Time TM6 Time 6 15 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Maint_Billing_Note_Archive'].MDFUSRID AS 'SV_Maint_Billing_Note_Archive-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVA0568 AS ['SV_Maint_Billing_Note_Archive']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Maint_Billing_Note_Archive'].MDFUSRID = ['Users Master'].USERID16 Time_Zone Time Zone STR3 String 3 17 SV_Language_ID SV Language ID INT2 Integer 2 18 WSReserved_CB1 WSReserved CB1 CB Boolean 0 19 WSReserved_CB2 WSReserved CB2 CB Boolean 0 20 WSReserved_CB3 WSReserved CB3 CB Boolean 0 21 WSReserved_CB4 WSReserved CB4 CB Boolean 0 22 WSReserved_CB5 WSReserved CB5 CB Boolean 0 23 WSReserved_STR1 WSReserved STR1 STR10 String 10 24 WSReserved_STR2 WSReserved STR2 STR10 String 10 25 Record_Notes Record Notes TX32000 Text 32000