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 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
       ['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_CodeString15
4CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
5SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
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 ZoneSTR3String3
7CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString15
8CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
9CNTCPRSN SearchContact PersonSTR60String60
10SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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_IDString15
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 1STR60String60
13ADDRESS2 SearchAddress 2STR60String60
14ADDRESS3 SearchAddress 3STR60String60
15COUNTRY SearchCountrySTR60String60
16CITY SearchCitySTR35String35
17STATE SearchStateSTR30_StateString29
18ZIP SearchZipSTR10String10
19PHONE1 SearchPhone 1Phone_NumberString14
20PHONE2 SearchPhone 2Phone_NumberString14
21FAX SearchFaxSTR14_FAXString14
22MODIFDT SearchModified DateDTDate8
23CREATDDT SearchCreated DateDTDate8
24INET1 SearchINet1STR200String200
25INET2 SearchINet2STR200String200
26INET3 SearchINet3STR200String200
27INET4 SearchINet4STR200String200
28INET5 SearchINet5STR200String200
29INET6 SearchINet6STR200String200
30INET7 SearchINet7STR200String200
31INET8 SearchINet8STR200String200
32ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
33STMTNAME SearchStatement NameSTR64String64
34SHRTNAME SearchShort NameSTR15String15
35PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString15
36PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
37STADDRCD SearchStatement Address CodeSTR15_LBAUString15
38ASI_Main_Salesperson SearchASI_Main_SalespersonSTR15_Salesperson_IDString15
39CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
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_IDString20
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_TypeInteger0
42CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency17
43CRLMTPER SearchCredit Limit PeriodDDLInteger0
44CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency17
45CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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_IDString15
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_%2Integer5
48PRCLEVEL SearchPriceLevelSTR10_LBAUString10
49MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger0
50MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency17
51MINPYPCT SearchMinimum Payment PercentINT5_%2Integer5
52FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger0
53FNCHPCNT SearchFinance Charge PercentINT5_%2Integer5
54FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency17
55MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger0
56MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency17
57COMMENT1 SearchComment1STR30String30
58COMMENT2 SearchComment2STR30String30
59USERDEF1 SearchUser Defined 1STR20String20
60USERDEF2 SearchUser Defined 2STR20String20
61TAXEXMT1 SearchTax Exempt 1STR25String25
62TAXEXMT2 SearchTax Exempt 2STR25String25
63TXRGNNUM SearchTax Registration NumberSTR25String25
64BALNCTYP SearchBalance TypeGB_Bal_TypeInteger0
65STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger0
66BANKNAME SearchBank NameSTR30String30
67BNKBRNCH SearchBank BranchSTR20String20
68SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString15
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 TypeGBInteger0
70RMCSHACC SearchRM Cash Account IndexLI_14Long Integer14
71RMARACC SearchRM AR Account IndexLI_14Long Integer14
72RMSLSACC SearchRM Sales Account IndexLI_14Long Integer14
73RMIVACC SearchRM IV Account IndexLI_14Long Integer14
74RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer14
75RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer14
76RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer14
77RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer14
78RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer14
79FRSTINDT SearchFirst Invoice DateDT_DateDate6
80INACTIVE SearchInactiveCB_InactiveBoolean0
81HOLD SearchHoldCB_HoldBoolean0
82CRCARDID SearchCredit Card IDSTR15String15
83CRCRDNUM SearchCredit Card NumberSTR20String20
84CCRDXPDT SearchCredit Card Exp DateDT_DateDate6
85KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean0
86KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
87KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
88KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
89Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean0
90Post_Results_To SearchPost Results ToGBInteger0
91FINCHID SearchFinance Charge IDSTR15_Charge_IDString15
92GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
93GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString30
94NOTEINDX SearchNote IndexDLR14Currency14
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_Number3String14
96DISGRPER SearchDiscount Grace PeriodINT2_U0Integer2
97DOCFMTID SearchDocument Format IDSTR15_LBUString15
98DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
99ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger0
100SALSTERR1 SearchASI_Sales_TerritorySTR15_Sales_TerritoryString15
101LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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_1STR20String20
103USERDEF21 SearchASI_User_Defined_2STR20String20
104CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger0
azurecurveProductsSmartList (1493)PathnameASI_RM_Customer_MSTR_ADDR_SmartList (ASIEXP15)

Leave a Reply

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