ASI_RM_Customer_MSTR_ADDR_SmartList (ASIEXP15)

azurecurveProductsSmartList (1493)PathnameASI_RM_Customer_MSTR_ADDR_SmartList (ASIEXP15)

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

Product: SmartList (1493)
Series: Pathname

Display Name: ASI_RM_Customer_MSTR_ADDR_SmartList
Physical Name: ASIEXP15
Technical Name: ASI_RM_Customer_MSTR_ADDR_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
       ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CUSTNMBR AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
4CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
5SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SLPRSNID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
6UPSZONE SearchUPS ZoneSTR3String43
7CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString1615
8CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
9CNTCPRSN SearchContact PersonSTR60String6260
10SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SHIPMTHD AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
11TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['ASI_RM_Customer_MSTR_ADDR_SmartList'].TAXSCHID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['ASI_RM_Customer_MSTR_ADDR_SmartList'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
12ADDRESS1 SearchAddress 1STR60String6260
13ADDRESS2 SearchAddress 2STR60String6260
14ADDRESS3 SearchAddress 3STR60String6260
15COUNTRY SearchCountrySTR60String6260
16CITY SearchCitySTR35String3635
17STATE SearchStateSTR30_StateString3029
18ZIP SearchZipSTR10String1210
19PHONE1 SearchPhone 1Phone_NumberString2214
20PHONE2 SearchPhone 2Phone_NumberString2214
21FAX SearchFaxSTR14_FAXString2214
22MODIFDT SearchModified DateDTDate48
23CREATDDT SearchCreated DateDTDate48
24INET1 SearchINet1STR200String202200
25INET2 SearchINet2STR200String202200
26INET3 SearchINet3STR200String202200
27INET4 SearchINet4STR200String202200
28INET5 SearchINet5STR200String202200
29INET6 SearchINet6STR200String202200
30INET7 SearchINet7STR200String202200
31INET8 SearchINet8STR200String202200
32ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
33STMTNAME SearchStatement NameSTR64String6664
34SHRTNAME SearchShort NameSTR15String1615
35PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString1615
36PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
37STADDRCD SearchStatement Address CodeSTR15_LBAUString1615
38ASI_Main_Salesperson SearchASI_Main_SalespersonSTR15_Salesperson_IDString1615
39CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CHEKBKID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
40PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['ASI_RM_Customer_MSTR_ADDR_SmartList'].PYMTRMID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['ASI_RM_Customer_MSTR_ADDR_SmartList'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
41CRLMTTYP SearchCredit Limit TypeGB_Amt_TypeInteger20
42CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency1017
43CRLMTPER SearchCredit Limit PeriodDDLInteger20
44CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency1017
45CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CURNCYID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['ASI_RM_Customer_MSTR_ADDR_SmartList'].CURNCYID = ['Currency Setup'].CURNCYID
46RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['ASI_RM_Customer_MSTR_ADDR_SmartList'].RATETPID AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['ASI_RM_Customer_MSTR_ADDR_SmartList'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
47CUSTDISC SearchCustomer DiscountINT5_%2Integer25
48PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
49MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger20
50MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
51MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
52FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger20
53FNCHPCNT SearchFinance Charge PercentINT5_%2Integer25
54FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency1017
55MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger20
56MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency1017
57COMMENT1 SearchComment1STR30String3230
58COMMENT2 SearchComment2STR30String3230
59USERDEF1 SearchUser Defined 1STR20String2220
60USERDEF2 SearchUser Defined 2STR20String2220
61TAXEXMT1 SearchTax Exempt 1STR25String2625
62TAXEXMT2 SearchTax Exempt 2STR25String2625
63TXRGNNUM SearchTax Registration NumberSTR25String2625
64BALNCTYP SearchBalance TypeGB_Bal_TypeInteger20
65STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger20
66BANKNAME SearchBank NameSTR30String3230
67BNKBRNCH SearchBank BranchSTR20String2220
68SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SALSTERR AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['ASI_RM_Customer_MSTR_ADDR_SmartList'].SALSTERR = ['Sales Territory Master File'].SALSTERR
69DEFCACTY SearchDefault Cash Account TypeGBInteger20
70RMCSHACC SearchRM Cash Account IndexLI_14Long Integer414
71RMARACC SearchRM AR Account IndexLI_14Long Integer414
72RMSLSACC SearchRM Sales Account IndexLI_14Long Integer414
73RMIVACC SearchRM IV Account IndexLI_14Long Integer414
74RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer414
75RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer414
76RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer414
77RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer414
78RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer414
79FRSTINDT SearchFirst Invoice DateDT_DateDate46
80INACTIVE SearchInactiveCB_InactiveBoolean20
81HOLD SearchHoldCB_HoldBoolean20
82CRCARDID SearchCredit Card IDSTR15String1615
83CRCRDNUM SearchCredit Card NumberSTR20String2220
84CCRDXPDT SearchCredit Card Exp DateDT_DateDate46
85KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
86KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
87KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
88KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
89Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean20
90Post_Results_To SearchPost Results ToGBInteger20
91FINCHID SearchFinance Charge IDSTR15_Charge_IDString1615
92GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
93GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
94NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['ASI_RM_Customer_MSTR_ADDR_SmartList'].NOTEINDX AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['ASI_RM_Customer_MSTR_ADDR_SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX
95PHONE3 SearchPhone 3Phone_Number3String2214
96DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
97DOCFMTID SearchDocument Format IDSTR15_LBUString1615
98DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
99ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger20
100SALSTERR1 SearchASI_Sales_TerritorySTR15_Sales_TerritoryString1615
101LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['ASI_RM_Customer_MSTR_ADDR_SmartList'].LOCNCODE AS 'ASI_RM_Customer_MSTR_ADDR_SmartList-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ASIEXP15 AS ['ASI_RM_Customer_MSTR_ADDR_SmartList']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['ASI_RM_Customer_MSTR_ADDR_SmartList'].LOCNCODE = ['Site Setup'].LOCNCODE
102USERDEF11 SearchASI_User_Defined_1STR20String2220
103USERDEF21 SearchASI_User_Defined_2STR20String2220
104CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger20
azurecurveProductsSmartList (1493)PathnameASI_RM_Customer_MSTR_ADDR_SmartList (ASIEXP15)

Leave a Reply

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