RM Email Statements Header Temporary File (RM50103)

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Email Statements Header Temporary File (RM50103)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Email Statements Header Temporary File
Physical Name: RM50103
Technical Name: rmEmailStmtsHDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DSCRIPTN SearchDescriptionStringSTR3030
2STMNTID SearchStatement IDStringSTR15_LBAU15
3CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['RM Email Statements Header Temporary File'].CUSTNMBR AS 'RM Email Statements Header Temporary File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['RM Email Statements Header Temporary File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4STMTNAME SearchStatement NameStringSTR6464
5CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['RM Email Statements Header Temporary File'].CURNCYID AS 'RM Email Statements Header Temporary File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['RM Email Statements Header Temporary File'].CURNCYID = ['Currency Setup'].CURNCYID
6CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['RM Email Statements Header Temporary File'].CURRNIDX AS 'RM Email Statements Header Temporary File-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['RM Email Statements Header Temporary File'].CURRNIDX = ['Currency Setup'].CURRNIDX
7CNTCPRSN SearchContact PersonStringSTR6060
8ADDRESS1 SearchAddress 1StringSTR6060
9ADDRESS2 SearchAddress 2StringSTR6060
10ADDRESS3 SearchAddress 3StringSTR6060
11PHONE1 SearchPhone 1StringPhone_Number14
12PHONE2 SearchPhone 2StringPhone_Number14
13PHONE3 SearchPhone 3StringPhone_Number314
14CITY SearchCityStringSTR3535
15STATE SearchStateStringSTR30_State29
16ZIP SearchZipStringSTR1010
17DATE1 SearchDateDateDT66
18MINPYDUE SearchMinimum Payment DueCurrencyDLR11_$S214
19CUSTMSGS_1 SearchCustomer Messages[1]StringSTR4040
20CUSTMSGS_2 SearchCustomer Messages[2]StringSTR4040
21CUSTMSGS_3 SearchCustomer Messages[3]StringSTR4040
22AMNTDUE SearchAmount DueCurrencyDLR11_$S214
23STMTMSGS_1 SearchStatement Messages[1]StringSTR5050
24STMTMSGS_2 SearchStatement Messages[2]StringSTR5050
25STMTMSGS_3 SearchStatement Messages[3]StringSTR5050
26STMTMSGS_4 SearchStatement Messages[4]StringSTR5050
27STMTMSGS_5 SearchStatement Messages[5]StringSTR5050
28STMTMSGS_6 SearchStatement Messages[6]StringSTR5050
29STMTMSGS_7 SearchStatement Messages[7]StringSTR5050
30STMTMSGS_8 SearchStatement Messages[8]StringSTR5050
31STMTMSGS_9 SearchStatement Messages[9]StringSTR5050
32STMTMSGS_10 SearchStatement Messages[10]StringSTR5050
33STMTMSGS_11 SearchStatement Messages[11]StringSTR5050
34STMTMSGS_12 SearchStatement Messages[12]StringSTR5050
35STMTMSGS_13 SearchStatement Messages[13]StringSTR5050
36STMTMSGS_14 SearchStatement Messages[14]StringSTR5050
37STMTMSGS_15 SearchStatement Messages[15]StringSTR5050
38DOCARABR_1 SearchDocument Array Abbreviation[1]StringSTR33
39DOCARABR_2 SearchDocument Array Abbreviation[2]StringSTR33
40DOCARABR_3 SearchDocument Array Abbreviation[3]StringSTR33
41DOCARABR_4 SearchDocument Array Abbreviation[4]StringSTR33
42DOCARABR_5 SearchDocument Array Abbreviation[5]StringSTR33
43DOCARABR_6 SearchDocument Array Abbreviation[6]StringSTR33
44DOCARABR_7 SearchDocument Array Abbreviation[7]StringSTR33
45DOCARABR_8 SearchDocument Array Abbreviation[8]StringSTR33
46DOCARABR_9 SearchDocument Array Abbreviation[9]StringSTR33
47DOCARDSC_1 SearchDocument Array Description[1]StringSTR2020
48DOCARDSC_2 SearchDocument Array Description[2]StringSTR2020
49DOCARDSC_3 SearchDocument Array Description[3]StringSTR2020
50DOCARDSC_4 SearchDocument Array Description[4]StringSTR2020
51DOCARDSC_5 SearchDocument Array Description[5]StringSTR2020
52DOCARDSC_6 SearchDocument Array Description[6]StringSTR2020
53DOCARDSC_7 SearchDocument Array Description[7]StringSTR2020
54DOCARDSC_8 SearchDocument Array Description[8]StringSTR2020
55DOCARDSC_9 SearchDocument Array Description[9]StringSTR2020
56AGPERAMT_1 SearchAging Period Amounts[1]CurrencyDLR17_RBSO_STR$17
57AGPERAMT_2 SearchAging Period Amounts[2]CurrencyDLR17_RBSO_STR$17
58AGPERAMT_3 SearchAging Period Amounts[3]CurrencyDLR17_RBSO_STR$17
59AGPERAMT_4 SearchAging Period Amounts[4]CurrencyDLR17_RBSO_STR$17
60AGPERAMT_5 SearchAging Period Amounts[5]CurrencyDLR17_RBSO_STR$17
61AGPERAMT_6 SearchAging Period Amounts[6]CurrencyDLR17_RBSO_STR$17
62AGPERAMT_7 SearchAging Period Amounts[7]CurrencyDLR17_RBSO_STR$17
63AGPERDSC_1 SearchAging Periods Descriptions[1]StringSTR1515
64AGPERDSC_2 SearchAging Periods Descriptions[2]StringSTR1515
65AGPERDSC_3 SearchAging Periods Descriptions[3]StringSTR1515
66AGPERDSC_4 SearchAging Periods Descriptions[4]StringSTR1515
67AGPERDSC_5 SearchAging Periods Descriptions[5]StringSTR1515
68AGPERDSC_6 SearchAging Periods Descriptions[6]StringSTR1515
69AGPERDSC_7 SearchAging Periods Descriptions[7]StringSTR1515
70CMPANYID SearchCompany IDIntegerINT54
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['RM Email Statements Header Temporary File'].CMPANYID AS 'RM Email Statements Header Temporary File-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['RM Email Statements Header Temporary File'].CMPANYID = ['Company Master'].CMPANYID
71LOCATNID SearchLocation IDStringSTR15_Location_ID15
72PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['RM Email Statements Header Temporary File'].PYMTRMID AS 'RM Email Statements Header Temporary File-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['RM Email Statements Header Temporary File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
73CUSTBLNC SearchCustomer BalanceCurrencyDLR19_RBS0_STR$19
74DEPRECV SearchDeposits ReceivedCurrencyDLR19_RBS0_STR$19
75RNNMBR SearchRun NumberLong IntegerLong Int8
76PRNTSTUS SearchPrinting StatusIntegerINT0
77USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['RM Email Statements Header Temporary File'].USERID AS 'RM Email Statements Header Temporary File-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       RM50103 AS ['RM Email Statements Header Temporary File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['RM Email Statements Header Temporary File'].USERID = ['Users Master'].USERID
78Process_Index SearchProcess IndexLong Integerlong8
azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Email Statements Header Temporary File (RM50103)

Leave a Reply

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