Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVA0509
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Contract_Revenue_Method2_MSTR_Archive
Physical Name: SVA0509
Technical Name: SV_Contract_Revenue_Method2_MSTR_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_Contract_Revenue_Method2_MSTR_Archive'].CUSTNMBR AS 'SV_Contract_Revenue_Method2_MSTR_Archive-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVA0509 AS ['SV_Contract_Revenue_Method2_MSTR_Archive']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Contract_Revenue_Method2_MSTR_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 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 6 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 7 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 8 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 9 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Contract_Revenue_Method2_MSTR_Archive'].USERID AS 'SV_Contract_Revenue_Method2_MSTR_Archive-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVA0509 AS ['SV_Contract_Revenue_Method2_MSTR_Archive']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Contract_Revenue_Method2_MSTR_Archive'].USERID = ['Users Master'].USERID10 Technician_ID Technician ID STR15_Employee_ID String 15 11 Technician_Team Technician Team STR15_LBAU String 15 12 YEAR1 Year Year Integer 4 13 PERIODID Period ID INT3 Integer 3 14 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 15 DATE1 Date DT6 Date 6 16 POSTDATE Post Date DT_Date Date 6 17 Closed Closed Boolean Boolean 0 18 MODIFDT Modified Date DT Date 8 19 Modified_Time Modified Time TM6 Time 6 20 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Contract_Revenue_Method2_MSTR_Archive'].MDFUSRID AS 'SV_Contract_Revenue_Method2_MSTR_Archive-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVA0509 AS ['SV_Contract_Revenue_Method2_MSTR_Archive']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Contract_Revenue_Method2_MSTR_Archive'].MDFUSRID = ['Users Master'].USERID21 Time_Zone Time Zone STR3 String 3 22 Base_Currency_ID Base Currency ID STR15_Currency_ID String 15 23 Base_Curr_Conv_Factor Base Curr Conversion Factor DLR14_Exchange_Rate Currency (Variable) 14 24 Billing_Currency_ID Billing Currency ID STR15_Currency_ID String 15 25 Billing_Curr_Conv_Factor Billing Curr Conversion Factor DLR14_Exchange_Rate Currency (Variable) 14 26 Local_Currency_ID Local Currency ID STR15_Currency_ID String 15 27 GLJournalEntry GL Journal Entry LI8_U0 Long Integer 8 28 PB_ACTINDX Progress Billing Account Index LI_14 Long Integer 14 29 CE_ACTINDX Contract Earning Account Index LI_14 Long Integer 14 30 PB_SEQNUMBR Progress Billing Sequence Number LI_Sequence_Number Long Integer 10 31 CE_SEQNUMBR Contract Earnings Sequence Number LI_Sequence_Number Long Integer 10 32 WSReserved_CB1 WSReserved CB1 CB Boolean 0 33 WSReserved_CB2 WSReserved CB2 CB Boolean 0 34 WSReserved_CB3 WSReserved CB3 CB Boolean 0 35 WSReserved_CB4 WSReserved CB4 CB Boolean 0 36 WSReserved_CB5 WSReserved CB5 CB Boolean 0 37 WSReserved_STR1 WSReserved STR1 STR10 String 10 38 WSReserved_STR2 WSReserved STR2 STR10 String 10 39 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 Payments40 ACTINDX_CR Account Index Credit LI_14 Long Integer 14 41 ACTINDX_DR Account Index Debit LI_14 Long Integer 14 42 Reference_TRX_Number Reference TRX Number STR17_LBAU String 17 43 JRNENTRY Journal Entry LI8_U0 Long Integer 8 44 LNSEQNBR Line SEQ Number Sequence_Number Currency 19 45 Contract_Sequence_Number Contract Sequence Number Long Int Long Integer 8