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 TypeLength
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
2CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_NameString64
4CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString15
5CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
6CNTCPRSN SearchContact PersonSTR60String60
7STMTNAME SearchStatement NameSTR64String64
8SHRTNAME SearchShort NameSTR15String15
9ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
10UPSZONE SearchUPS ZoneSTR3String3
11SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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_IDString15
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 1STR60String60
14ADDRESS2 SearchAddress 2STR60String60
15ADDRESS3 SearchAddress 3STR60String60
16COUNTRY SearchCountrySTR60String60
17CITY SearchCitySTR35String35
18STATE SearchStateSTR30_StateString29
19ZIP SearchZipSTR10String10
20PHONE1 SearchPhone 1Phone_NumberString14
21PHONE2 SearchPhone 2Phone_NumberString14
22FAX SearchFaxSTR14_FAXString14
23PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString15
24PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
25STADDRCD SearchStatement Address CodeSTR15_LBAUString15
26SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
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_IDString15
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_IDString20
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_TypeInteger0
30CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency17
31CRLMTPER SearchCredit Limit PeriodDDLInteger0
32CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency17
33CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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_IDString15
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_%2Integer5
36PRCLEVEL SearchPriceLevelSTR10_LBAUString10
37MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger0
38MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency17
39MINPYPCT SearchMinimum Payment PercentINT5_%2Integer5
40FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger0
41FNCHPCNT SearchFinance Charge PercentINT5_%2Integer5
42FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency17
43MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger0
44MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency17
45COMMENT1 SearchComment1STR30String30
46COMMENT2 SearchComment2STR30String30
47USERDEF1 SearchUser Defined 1STR20String20
48USERDEF2 SearchUser Defined 2STR20String20
49TAXEXMT1 SearchTax Exempt 1STR25String25
50TAXEXMT2 SearchTax Exempt 2STR25String25
51TXRGNNUM SearchTax Registration NumberSTR25String25
52BALNCTYP SearchBalance TypeGB_Bal_TypeInteger0
53STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger0
54BANKNAME SearchBank NameSTR30String30
55BNKBRNCH SearchBank BranchSTR20String20
56SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString15
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 TypeGBInteger0
58RMCSHACC SearchRM Cash Account IndexLI_14Long Integer14
59RMARACC SearchRM AR Account IndexLI_14Long Integer14
60RMSLSACC SearchRM Sales Account IndexLI_14Long Integer14
61RMIVACC SearchRM IV Account IndexLI_14Long Integer14
62RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer14
63RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer14
64RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer14
65RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer14
66RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer14
67FRSTINDT SearchFirst Invoice DateDT_DateDate6
68INACTIVE SearchInactiveCB_InactiveBoolean0
69HOLD SearchHoldCB_HoldBoolean0
70CRCARDID SearchCredit Card IDSTR15String15
71CRCRDNUM SearchCredit Card NumberSTR20String20
72CCRDXPDT SearchCredit Card Exp DateDT_DateDate6
73KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean0
74KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
75KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
76KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
77NOTEINDX SearchNote IndexDLR14Currency14
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 DateDTDate8
79MODIFDT SearchModified DateDTDate8
80ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
81TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency19
82NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer6
83CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency19
84AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency17
85AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency17
86AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency17
87AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency17
88AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency17
89AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency17
90AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency17
91LASTAGED SearchLast AgedDATEDate6
92LSTNSFCD SearchLast NSF Check DateDT_DateDate6
93LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency17
94LASTPYDT SearchLast Payment DateDT_DateDate6
95LSTTRXDT SearchLast Transaction DateDT_DateDate6
96LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency17
97LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency19
98UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency17
99AVDTPLYR SearchAverage Days to Pay - LYRINT3_U0Integer3
100AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer3
101AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer3
102NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer10
103NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer10
104NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer10
105TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency19
106TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency19
107TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency19
108TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency19
109RETAINAG SearchRetainageDLR19_RBS0_STR$Currency19
110TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency19
111NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer6
112UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency19
113UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency19
114UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency19
115UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency19
116NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency19
117TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency19
118TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency19
119TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency19
120TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency19
121TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency19
122TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency19
123TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency19
124TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency19
125TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency19
126TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency19
127TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency19
128TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency19
129FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency19
130FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency19
131TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency19
132TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency19
133TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency19
134TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency19
135TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency19
136TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency19
137TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency19
138TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency19
139TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency19
140TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer6
141TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer6
142TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer6
143TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer6
144TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer6
145TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer6
146WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency19
147WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency19
148WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency19
149HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency19
150HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency19
151HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency19
152LASTSTDT SearchLast Statement DateDATEDate6
153LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency17
154DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency19
155ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency19
156Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean0
157Post_Results_To SearchPost Results ToGBInteger0
158FINCHID SearchFinance Charge IDSTR15_Charge_IDString15
159GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
160GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString30
161DISGRPER SearchDiscount Grace PeriodINT2_U0Integer2
162DOCFMTID SearchDocument Format IDSTR15_LBUString15
163DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
164PHONE3 SearchPhone 3Phone_Number3String14
165TTLRTLTD SearchTotal Returns LTDDLR19_RBS0_STR$Currency19
166TTLRTLYR SearchTotal Returns LYRDLR19_RBS0_STR$Currency19
167TTLRTYTD SearchTotal Returns YTDDLR19_RBS0_STR$Currency19
168RMSORACC SearchRM Sales Order Returns Account IndexLI_14Long Integer14
169Send_Email_Statements SearchSend Email StatementsCBBoolean0
170ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger0
171CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger0
172SHIPCOMPLETE SearchShip Complete DocumentCB_ShipCompleteBoolean0
azurecurveProductsSmartList (1493)PathnameSmartList RM Customer MSTR (ASIEXP02)

Leave a Reply

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