SmartList RM Customer MSTR (ASIEXP02)

azurecurveProductsSmartList (1493)PathnameSmartList RM Customer MSTR (ASIEXP02)

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

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList RM Customer MSTR
Physical Name: ASIEXP02
Technical Name: ASI_RM_Customer_MSTR_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SmartList RM Customer MSTR'].CUSTNMBR AS 'SmartList RM Customer MSTR-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       ASIEXP02 AS ['SmartList RM Customer MSTR']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SmartList RM Customer MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
4CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString1615
5CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
6CNTCPRSN SearchContact PersonSTR60String6260
7STMTNAME SearchStatement NameSTR64String6664
8SHRTNAME SearchShort NameSTR15String1615
9ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
10UPSZONE SearchUPS ZoneSTR3String43
11SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SmartList RM Customer MSTR'].SHIPMTHD AS 'SmartList RM Customer MSTR-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP02 AS ['SmartList RM Customer MSTR']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SmartList RM Customer MSTR'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
12TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList RM Customer MSTR'].TAXSCHID AS 'SmartList RM Customer MSTR-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP02 AS ['SmartList RM Customer MSTR']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList RM Customer MSTR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
13ADDRESS1 SearchAddress 1STR60String6260
14ADDRESS2 SearchAddress 2STR60String6260
15ADDRESS3 SearchAddress 3STR60String6260
16COUNTRY SearchCountrySTR60String6260
17CITY SearchCitySTR35String3635
18STATE SearchStateSTR30_StateString3029
19ZIP SearchZipSTR10String1210
20PHONE1 SearchPhone 1Phone_NumberString2214
21PHONE2 SearchPhone 2Phone_NumberString2214
22FAX SearchFaxSTR14_FAXString2214
23PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString1615
24PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
25STADDRCD SearchStatement Address CodeSTR15_LBAUString1615
26SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SmartList RM Customer MSTR'].SLPRSNID AS 'SmartList RM Customer MSTR-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       ASIEXP02 AS ['SmartList RM Customer MSTR']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SmartList RM Customer MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
27CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['SmartList RM Customer MSTR'].CHEKBKID AS 'SmartList RM Customer MSTR-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP02 AS ['SmartList RM Customer MSTR']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['SmartList RM Customer MSTR'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
28PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['SmartList RM Customer MSTR'].PYMTRMID AS 'SmartList RM Customer MSTR-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP02 AS ['SmartList RM Customer MSTR']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['SmartList RM Customer MSTR'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
29CRLMTTYP SearchCredit Limit TypeGB_Amt_TypeInteger20
30CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency1017
31CRLMTPER SearchCredit Limit PeriodDDLInteger20
32CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency1017
33CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList RM Customer MSTR'].CURNCYID AS 'SmartList RM Customer MSTR-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP02 AS ['SmartList RM Customer MSTR']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList RM Customer MSTR'].CURNCYID = ['Currency Setup'].CURNCYID
34RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['SmartList RM Customer MSTR'].RATETPID AS 'SmartList RM Customer MSTR-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP02 AS ['SmartList RM Customer MSTR']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['SmartList RM Customer MSTR'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
35CUSTDISC SearchCustomer DiscountINT5_%2Integer25
36PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
37MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger20
38MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
39MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
40FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger20
41FNCHPCNT SearchFinance Charge PercentINT5_%2Integer25
42FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency1017
43MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger20
44MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency1017
45COMMENT1 SearchComment1STR30String3230
46COMMENT2 SearchComment2STR30String3230
47USERDEF1 SearchUser Defined 1STR20String2220
48USERDEF2 SearchUser Defined 2STR20String2220
49TAXEXMT1 SearchTax Exempt 1STR25String2625
50TAXEXMT2 SearchTax Exempt 2STR25String2625
51TXRGNNUM SearchTax Registration NumberSTR25String2625
52BALNCTYP SearchBalance TypeGB_Bal_TypeInteger20
53STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger20
54BANKNAME SearchBank NameSTR30String3230
55BNKBRNCH SearchBank BranchSTR20String2220
56SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['SmartList RM Customer MSTR'].SALSTERR AS 'SmartList RM Customer MSTR-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       ASIEXP02 AS ['SmartList RM Customer MSTR']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['SmartList RM Customer MSTR'].SALSTERR = ['Sales Territory Master File'].SALSTERR
57DEFCACTY SearchDefault Cash Account TypeGBInteger20
58RMCSHACC SearchRM Cash Account IndexLI_14Long Integer414
59RMARACC SearchRM AR Account IndexLI_14Long Integer414
60RMSLSACC SearchRM Sales Account IndexLI_14Long Integer414
61RMIVACC SearchRM IV Account IndexLI_14Long Integer414
62RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer414
63RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer414
64RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer414
65RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer414
66RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer414
67FRSTINDT SearchFirst Invoice DateDT_DateDate46
68INACTIVE SearchInactiveCB_InactiveBoolean20
69HOLD SearchHoldCB_HoldBoolean20
70CRCARDID SearchCredit Card IDSTR15String1615
71CRCRDNUM SearchCredit Card NumberSTR20String2220
72CCRDXPDT SearchCredit Card Exp DateDT_DateDate46
73KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
74KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
75KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
76KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
77NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList RM Customer MSTR'].NOTEINDX AS 'SmartList RM Customer MSTR-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP02 AS ['SmartList RM Customer MSTR']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList RM Customer MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX
78CREATDDT SearchCreated DateDTDate48
79MODIFDT SearchModified DateDTDate48
80ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
81TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency1019
82NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer46
83CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency1019
84AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency1017
85AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency1017
86AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency1017
87AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency1017
88AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency1017
89AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency1017
90AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency1017
91LASTAGED SearchLast AgedDATEDate46
92LSTNSFCD SearchLast NSF Check DateDT_DateDate46
93LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency1017
94LASTPYDT SearchLast Payment DateDT_DateDate46
95LSTTRXDT SearchLast Transaction DateDT_DateDate46
96LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency1017
97LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency1019
98UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency1017
99AVDTPLYR SearchAverage Days to Pay - LYRINT3_U0Integer23
100AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer23
101AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer23
102NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer410
103NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer410
104NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer410
105TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency1019
106TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency1019
107TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency1019
108TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency1019
109RETAINAG SearchRetainageDLR19_RBS0_STR$Currency1019
110TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency1019
111NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer46
112UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency1019
113UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency1019
114UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency1019
115UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency1019
116NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency1019
117TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency1019
118TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency1019
119TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency1019
120TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency1019
121TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency1019
122TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency1019
123TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency1019
124TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency1019
125TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency1019
126TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency1019
127TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency1019
128TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency1019
129FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency1019
130FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency1019
131TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency1019
132TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency1019
133TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency1019
134TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency1019
135TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency1019
136TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency1019
137TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency1019
138TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency1019
139TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency1019
140TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer46
141TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer46
142TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer46
143TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer46
144TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer46
145TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer46
146WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency1019
147WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency1019
148WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency1019
149HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency1019
150HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency1019
151HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency1019
152LASTSTDT SearchLast Statement DateDATEDate46
153LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency1017
154DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency1019
155ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
156Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean20
157Post_Results_To SearchPost Results ToGBInteger20
158FINCHID SearchFinance Charge IDSTR15_Charge_IDString1615
159GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
160GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
161DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
162DOCFMTID SearchDocument Format IDSTR15_LBUString1615
163DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
164PHONE3 SearchPhone 3Phone_Number3String2214
165TTLRTLTD SearchTotal Returns LTDDLR19_RBS0_STR$Currency1019
166TTLRTLYR SearchTotal Returns LYRDLR19_RBS0_STR$Currency1019
167TTLRTYTD SearchTotal Returns YTDDLR19_RBS0_STR$Currency1019
168RMSORACC SearchRM Sales Order Returns Account IndexLI_14Long Integer414
169Send_Email_Statements SearchSend Email StatementsCBBoolean20
170ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger20
171CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger20
172SHIPCOMPLETE SearchShip Complete DocumentCB_ShipCompleteBoolean20
azurecurveProductsSmartList (1493)PathnameSmartList RM Customer MSTR (ASIEXP02)

Leave a Reply

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