SmartList Purchase Order (ASIEXP07)

azurecurveProductsSmartList (1493)PathnameSmartList Purchase Order (ASIEXP07)

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

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Purchase Order
Physical Name: ASIEXP07
Technical Name: ASI_POP_PO_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
2PONUMBER SearchPO NumberSTR17_POP_NumberString17
3ASI_Document_Status SearchASI_Document_StatusINTInteger0
4POSTATUS SearchPO StatusDDL_PO_StatusInteger0
5STATGRP SearchStatus GroupINT1Integer1
6POTYPE SearchPO TypeDDL_POP_PO_TypeInteger0
7USER2ENT SearchUser To EnterSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].USER2ENT AS 'SmartList Purchase Order-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Purchase Order'].USER2ENT = ['Users Master'].USERID
8CONFIRM1 SearchConfirm WithSTR20String20
9DOCDATE SearchDocument DateDTDate8
10LSTEDTDT SearchLast Edit DateDT_DateDate6
11LSTPRTDT SearchLast Printed DateDATE_LDate0
12PRMDATE SearchPromised DateDATE_LDate0
13PRMSHPDTE SearchPromised Ship DateDATE_LDate0
14REQDATE SearchRequired DateDATE_LDate0
15REQTNDT SearchRequisition DateDATE_LDate0
16SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].SHIPMTHD AS 'SmartList Purchase Order-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SmartList Purchase Order'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
17TXRGNNUM SearchTax Registration NumberSTR25String25
18REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency17
19SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency17
20TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
21FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
22MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency17
23TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
24VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].VENDORID AS 'SmartList Purchase Order-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SmartList Purchase Order'].VENDORID = ['PM Vendor Master File'].VENDORID
25VENDNAME SearchVendor NameSTR64_Vendor_NameString64
26MINORDER SearchMinimum OrderDLR17_$U2Currency17
27VADCDPAD SearchVendor Address Code - Purchase AddressSTR15_Address_CodeString15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].VADCDPAD AS 'SmartList Purchase Order-Vendor Address Code - Purchase Address'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Purchase Order'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Purchase Order'].VENDORID = ['PM Address MSTR'].VENDORID
28CMPANYID SearchCompany IDINT5Integer4
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].CMPANYID AS 'SmartList Purchase Order-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['SmartList Purchase Order'].CMPANYID = ['Company Master'].CMPANYID
29PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString15
30PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
31CMPNYNAM SearchCompany NameSTR64_Company_NameString64
32CONTACT SearchContactSTR60String60
33ADDRESS1 SearchAddress 1STR60String60
34ADDRESS2 SearchAddress 2STR60String60
35ADDRESS3 SearchAddress 3STR60String60
36CITY SearchCitySTR35String35
37STATE SearchStateSTR30_StateString29
38ZIPCODE SearchZip CodeSTR10String10
39COUNTRY SearchCountrySTR60String60
40PHONE1 SearchPhone 1Phone_NumberString14
41PHONE2 SearchPhone 2Phone_NumberString14
42FAX SearchFaxSTR14_FAXString14
43PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PYMTRMID AS 'SmartList Purchase Order-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['SmartList Purchase Order'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
44DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency11
45DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer5
46DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency17
47DISCDATE SearchDiscount DateDTDate8
48DUEDATE SearchDue DateDTDate8
49TRDISPCT SearchTrade Discount PercentINT4_%2Integer4
50CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].CUSTNMBR AS 'SmartList Purchase Order-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SmartList Purchase Order'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
51TIMESPRT SearchTimes PrintedINT4_U0Integer4
52CREATDDT SearchCreated DateDTDate8
53MODIFDT SearchModified DateDTDate8
54TRXSORCE SearchTRX SourceSTR13String13
55PONOTIDS_1 SearchPO Note ID Array[1]DLR14Currency14
56PONOTIDS_2 SearchPO Note ID Array[2]DLR14Currency14
57PONOTIDS_3 SearchPO Note ID Array[3]DLR14Currency14
58PONOTIDS_4 SearchPO Note ID Array[4]DLR14Currency14
59PONOTIDS_5 SearchPO Note ID Array[5]DLR14Currency14
60PONOTIDS_6 SearchPO Note ID Array[6]DLR14Currency14
61PONOTIDS_7 SearchPO Note ID Array[7]DLR14Currency14
62PONOTIDS_8 SearchPO Note ID Array[8]DLR14Currency14
63PONOTIDS_9 SearchPO Note ID Array[9]DLR14Currency14
64PONOTIDS_10 SearchPO Note ID Array[10]DLR14Currency14
65PONOTIDS_11 SearchPO Note ID Array[11]DLR14Currency14
66PONOTIDS_12 SearchPO Note ID Array[12]DLR14Currency14
67PONOTIDS_13 SearchPO Note ID Array[13]DLR14Currency14
68PONOTIDS_14 SearchPO Note ID Array[14]DLR14Currency14
69PONOTIDS_15 SearchPO Note ID Array[15]DLR14Currency14
70COMMNTID SearchComment IDSTR15_Comment_IDString15
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].COMMNTID AS 'SmartList Purchase Order-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['SmartList Purchase Order'].COMMNTID = ['Comment Master'].COMMNTID
71CANCSUB SearchCanceled SubtotalDLR17_RBS0_STR$Currency17
72TRDPCTPR SearchTrade Discount Percent (Precise)Trade Discount Percent (Precise)Currency (Variable)23
73ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
74CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].CURNCYID AS 'SmartList Purchase Order-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Purchase Order'].CURNCYID = ['Currency Setup'].CURNCYID
75CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].CURRNIDX AS 'SmartList Purchase Order-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Purchase Order'].CURRNIDX = ['Currency Setup'].CURRNIDX
76RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].RATETPID AS 'SmartList Purchase Order-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['SmartList Purchase Order'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
77EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].EXGTBLID AS 'SmartList Purchase Order-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['SmartList Purchase Order'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
78EXCHDATE SearchExchange DateDT_DateDate6
79TIME1 SearchTimeTM6Time6
80RATECALC SearchRate Calc MethodINTInteger0
81DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
82MCTRXSTT SearchMC Transaction StateINT1Integer1
83OREMSUBT SearchOriginating Remaining SubtotalDLR17_RBS0_UTR$Currency17
84ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency17
85Originating_Canceled_Sub SearchOriginating Canceled SubtotalDLR17_RBS0_STR$Currency17
86ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
87ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
88OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency17
89ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
90ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
91ODISAMTAV SearchOriginating Discount Amount AvailableDLR17_RBS0_UTR$Currency17
92BUYERID SearchBuyer IDSTR15_User_IDString15
93ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency19
94ORORDAMT SearchOriginating On Order AmountDLR19_RBS0_UTR$Currency19
95HOLD SearchHoldCB_HoldBoolean0
96ONHOLDDATE SearchOn Hold DateDTDate8
97ONHOLDBY SearchOn Hold BySTR15_User_IDString15
98HOLDREMOVEDATE SearchHold Remove DateDTDate8
99HOLDREMOVEBY SearchHold Remove BySTR15_User_IDString15
100ALLOWSOCMTS SearchAllow SO CommitmentsCB_AllowSOCommitmentsBoolean0
101XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
102VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString64
103VENDSHNM SearchVendor Short NameSTR15String15
104VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].VADDCDPR AS 'SmartList Purchase Order-Vendor Address Code - Primary'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Purchase Order'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Purchase Order'].VENDORID = ['PM Address MSTR'].VENDORID
105VADCDSFR SearchVendor Address Code - Ship FromSTR15_Address_CodeString15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].VADCDSFR AS 'SmartList Purchase Order-Vendor Address Code - Ship From'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Purchase Order'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Purchase Order'].VENDORID = ['PM Address MSTR'].VENDORID
106VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].VADCDTRO AS 'SmartList Purchase Order-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Purchase Order'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Purchase Order'].VENDORID = ['PM Address MSTR'].VENDORID
107VNDCLSID SearchVendor Class IDSTR10_Class_IDString10
Key to the PM Class Master File (PM00100).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].VNDCLSID AS 'SmartList Purchase Order-Vendor Class ID'
       ,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       PM00100 AS ['PM Class Master File']
              ON
                     ['SmartList Purchase Order'].VNDCLSID = ['PM Class Master File'].VNDCLSID
108VNDCNTCT SearchVendor ContactSTR60String60
109UPSZONE SearchUPS ZoneSTR3String3
110TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].TAXSCHID AS 'SmartList Purchase Order-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Purchase Order'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
111ACNMVNDR SearchAccount Number With VendorSTR20String20
112TXIDNMBR SearchTax ID NumberTax_ID_NumberString11
113VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger0
114PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString15
115TRDDISCT SearchTrade DiscountINT4_%2Integer4
116TEN99TYPE Search1099 Type1099_TypeInteger0
117MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger0
118MINPYPCT SearchMinimum Payment PercentINT5_%2Integer5
119MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency17
120MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger0
121MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency17
122COMMENT1 SearchComment1STR30String30
123COMMENT2 SearchComment2STR30String30
124USERDEF1 SearchUser Defined 1STR20String20
125USERDEF2 SearchUser Defined 2STR20String20
126CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency17
127PYMNTPRI SearchPayment PrioritySTR3String3
128KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
129KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean0
130KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
131KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
132PTCSHACF SearchPost To Cash Account FromGBInteger0
133CREDTLMT SearchCredit LimitGBInteger0
134WRITEOFF SearchWriteoffGBInteger0
135MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency17
136SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean0
137PPSTAXRT SearchPPS Tax RateINT5_%2Integer5
138DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String25
139CRTCOMDT SearchCertificate Commencing DateDTDate8
140CRTEXPDT SearchCertificate Expiration DateDTDate8
141RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean0
142XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean0
143PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean0
144PMAPINDX SearchPM AP IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMAPINDX AS 'SmartList Purchase Order-PM AP Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMAPINDX = ['Account Index Master'].ACTINDX
145PMCSHIDX SearchPM Cash IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMCSHIDX AS 'SmartList Purchase Order-PM Cash Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMCSHIDX = ['Account Index Master'].ACTINDX
146PMDAVIDX SearchPM Discount Available IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMDAVIDX AS 'SmartList Purchase Order-PM Discount Available Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMDAVIDX = ['Account Index Master'].ACTINDX
147PMDTKIDX SearchPM Discount Taken IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMDTKIDX AS 'SmartList Purchase Order-PM Discount Taken Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMDTKIDX = ['Account Index Master'].ACTINDX
148PMFINIDX SearchPM Finance Charge IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMFINIDX AS 'SmartList Purchase Order-PM Finance Charge Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMFINIDX = ['Account Index Master'].ACTINDX
149PMMSCHIX SearchPM Misc Charges IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMMSCHIX AS 'SmartList Purchase Order-PM Misc Charges Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMMSCHIX = ['Account Index Master'].ACTINDX
150PMFRTIDX SearchPM Freight IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMFRTIDX AS 'SmartList Purchase Order-PM Freight Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMFRTIDX = ['Account Index Master'].ACTINDX
151PMTAXIDX SearchPM Tax IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMTAXIDX AS 'SmartList Purchase Order-PM Tax Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMTAXIDX = ['Account Index Master'].ACTINDX
152PMWRTIDX SearchPM Write Offs IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMWRTIDX AS 'SmartList Purchase Order-PM Write Offs Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMWRTIDX = ['Account Index Master'].ACTINDX
153PMPRCHIX SearchPM Purchases IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMPRCHIX AS 'SmartList Purchase Order-PM Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMPRCHIX = ['Account Index Master'].ACTINDX
154PMRTNGIX SearchPM Retainage IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMRTNGIX AS 'SmartList Purchase Order-PM Retainage Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMRTNGIX = ['Account Index Master'].ACTINDX
155PMTDSCIX SearchPM Trade Discount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PMTDSCIX AS 'SmartList Purchase Order-PM Trade Discount Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PMTDSCIX = ['Account Index Master'].ACTINDX
156ACPURIDX SearchAccrued Purchases IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].ACPURIDX AS 'SmartList Purchase Order-Accrued Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].ACPURIDX = ['Account Index Master'].ACTINDX
157PURPVIDX SearchPurchase Price Variance IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].PURPVIDX AS 'SmartList Purchase Order-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchase Order'].PURPVIDX = ['Account Index Master'].ACTINDX
158CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].CHEKBKID AS 'SmartList Purchase Order-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['SmartList Purchase Order'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
159Revalue_Vendor SearchRevalue VendorCB Revalue VendorBoolean0
160Post_Results_To SearchPost Results ToGBInteger0
161FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger0
162HIESTBAL SearchHighest BalanceDLR17_RBS0_UTR$Currency17
163CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency19
164NOINVLIF SearchNumber of Invoices LIFELI_9U0Long Integer9
165NOINVLYR SearchNumber of Invoices LYRLI_9U0Long Integer9
166NOINVYTD SearchNumber of Invoices YTDLI_9U0Long Integer9
167NOPILIFE SearchNumber of Paid Invoices LIFELI_9U0Long Integer9
168NOPINYTD SearchNumber of Paid Invoices YTDLI_9U0Long Integer9
169AMBLDLIF SearchAmount Billed LIFEDLR19_RBS0_STR$Currency19
170AMBLDLYR SearchAmount Billed LYRDLR19_RBS0_STR$Currency19
171AMBLDTYD SearchAmount Billed YTDDLR19_RBS0_STR$Currency19
172AMTPDLIF SearchAmount Paid LIFEDLR19_RBS0_STR$Currency19
173AMTPDLYR SearchAmount Paid LYRDLR19_RBS0_STR$Currency19
174AMTPDYTD SearchAmount Paid YTDDLR19_RBS0_STR$Currency19
175TEN99ALIF Search1099 Amount LIFEDLR19_RBS0_STR$Currency19
176TEN99ALYR Search1099 Amount LYRDLR19_RBS0_STR$Currency19
177TEN99AYTD Search1099 Amount YTDDLR19_RBS0_STR$Currency19
178DISAVYTD SearchDiscount Available YTDDLR19_RBS0_STR$Currency19
179DISAVLIF SearchDiscount Available LIFEDLR19_RBS0_STR$Currency19
180DISAVLYR SearchDiscount Available LYRDLR19_RBS0_STR$Currency19
181DISTKNLF SearchDiscount Taken LIFEDLR19_RBS0_STR$Currency19
182DISTKLYR SearchDiscount Taken LYRDLR19_RBS0_STR$Currency19
183DISTKYTD SearchDiscount Taken YTDDLR19_RBS0_STR$Currency19
184DISLSTLF SearchDiscount Lost LIFEDLR19_RBS0_STR$Currency19
185DISLSLYR SearchDiscount Lost LYRDLR19_RBS0_STR$Currency19
186DISLSYTD SearchDiscount Lost YTDDLR19_RBS0_STR$Currency19
187FINCHLIF SearchFinance Charge LIFEDLR19_RBS0_STR$Currency19
188FINCHLYR SearchFinance Charge LYRDLR19_RBS0_STR$Currency19
189FINCHYTD SearchFinance Charge YTDDLR19_RBS0_STR$Currency19
190WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency19
191WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency19
192WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency19
193RTRNSLIF SearchReturns LIFEDLR19_RBS0_STR$Currency19
194RTRNSLYR SearchReturns LYRDLR19_RBS0_STR$Currency19
195RTRNSYTD SearchReturns YTDDLR19_RBS0_STR$Currency19
196TRDTKLIF SearchTrade Discounts Taken LIFEDLR19_RBSO_STR$Currency19
197TRDTLYR SearchTrade Discounts Taken LYRDLR19_RBSO_STR$Currency19
198TRDTYTD SearchTrade Discounts Taken YTDDLR19_RBSO_STR$Currency19
199NFNCHLIF SearchNumber of Finance Charges LIFELI_9U0Long Integer9
200NFNCHLYR SearchNumber of Finance Charges LYRLI_9U0Long Integer9
201NFNCHYTD SearchNumber of Finance Charges YTDLI_9U0Long Integer9
202RTNGOWED SearchRetainage OwedDLR17_RBS0_STR$Currency17
203LSTCHNUM SearchLast Check NumberCheck_NumberString20
204LSTCHKDT SearchLast Check DateDTDate8
205LSTCHAMT SearchLast Check AmountDLR17_RBS0_UTR$Currency17
206LSTINNUM SearchLast Invoice NumberSTR20String20
207LSTINVAM SearchLast Invoice AmountDLR17_RBS0_UTR$Currency17
208LSTPURDT SearchLast Purchase DateDTDate8
209FSTPURDT SearchFirst Purchase DateDTDate8
210CURUNPBN SearchCurrent Unapplied Payment BalanceDLR17_RBS0_UTR$Currency17
211UNPDFNCH SearchUnpaid Finance ChargesDLR17_RBS0_UTR$Currency17
212DYCHTCLR SearchDays Checks To ClearINT3_U0Integer3
213AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer3
214AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer3
215ACCRDINV SearchAccured InventoryDLR17_RBS0_STR$Currency17
216CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
217CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString15
218CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
219CNTCPRSN SearchContact PersonSTR60String60
220STMTNAME SearchStatement NameSTR64String64
221SHRTNAME SearchShort NameSTR15String15
222ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
223STADDRCD SearchStatement Address CodeSTR15_LBAUString15
224SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].SLPRSNID AS 'SmartList Purchase Order-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SmartList Purchase Order'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
225CRLMTTYP SearchCredit Limit TypeGB_Amt_TypeInteger0
226CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency17
227CRLMTPER SearchCredit Limit PeriodDDLInteger0
228CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency17
229CUSTDISC SearchCustomer DiscountINT5_%2Integer5
230PRCLEVEL SearchPriceLevelSTR10_LBAUString10
231FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger0
232FNCHPCNT SearchFinance Charge PercentINT5_%2Integer5
233FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency17
234MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger0
235MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency17
236TAXEXMT1 SearchTax Exempt 1STR25String25
237TAXEXMT2 SearchTax Exempt 2STR25String25
238BALNCTYP SearchBalance TypeGB_Bal_TypeInteger0
239STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger0
240BANKNAME SearchBank NameSTR30String30
241BNKBRNCH SearchBank BranchSTR20String20
242SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString15
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].SALSTERR AS 'SmartList Purchase Order-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['SmartList Purchase Order'].SALSTERR = ['Sales Territory Master File'].SALSTERR
243DEFCACTY SearchDefault Cash Account TypeGBInteger0
244RMCSHACC SearchRM Cash Account IndexLI_14Long Integer14
245RMARACC SearchRM AR Account IndexLI_14Long Integer14
246RMSLSACC SearchRM Sales Account IndexLI_14Long Integer14
247RMIVACC SearchRM IV Account IndexLI_14Long Integer14
248RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer14
249RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer14
250RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer14
251RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer14
252RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer14
253FRSTINDT SearchFirst Invoice DateDT_DateDate6
254INACTIVE SearchInactiveCB_InactiveBoolean0
255CRCARDID SearchCredit Card IDSTR15String15
256CRCRDNUM SearchCredit Card NumberSTR20String20
257CCRDXPDT SearchCredit Card Exp DateDT_DateDate6
258Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean0
259FINCHID SearchFinance Charge IDSTR15_Charge_IDString15
260GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
261GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString30
262TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency19
263NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer6
264CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency19
265AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency17
266AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency17
267AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency17
268AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency17
269AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency17
270AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency17
271AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency17
272LASTAGED SearchLast AgedDATEDate6
273LSTNSFCD SearchLast NSF Check DateDT_DateDate6
274LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency17
275LASTPYDT SearchLast Payment DateDT_DateDate6
276LSTTRXDT SearchLast Transaction DateDT_DateDate6
277LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency17
278LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency19
279UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency17
280NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer10
281NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer10
282NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer10
283TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency19
284TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency19
285TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency19
286TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency19
287RETAINAG SearchRetainageDLR19_RBS0_STR$Currency19
288TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency19
289NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer6
290UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency19
291UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency19
292UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency19
293UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency19
294NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency19
295TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency19
296TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency19
297TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency19
298TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency19
299TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency19
300TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency19
301TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency19
302TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency19
303TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency19
304TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency19
305TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency19
306TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency19
307FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency19
308FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency19
309TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency19
310TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency19
311TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency19
312TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency19
313TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency19
314TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency19
315TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency19
316TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency19
317TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency19
318TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer6
319TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer6
320TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer6
321TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer6
322TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer6
323TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer6
324HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency19
325HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency19
326HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency19
327LASTSTDT SearchLast Statement DateDATEDate6
328LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency17
329DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency19
330DISGRPER SearchDiscount Grace PeriodINT2_U0Integer2
331DOCFMTID SearchDocument Format IDSTR15_LBUString15
332DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
333PHONE3 SearchPhone 3Phone_Number3String14
334TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean0
335Withholding_LIFE SearchWithholding LIFEDLR19_RBS0_STR$Currency19
336WITHLYR SearchWithholding LYRDLR19_RBS0_STR$Currency19
337WITHYTD SearchWithholding YTDDLR19_RBS0_STR$Currency19
338Change_Order_Flag SearchChange Order FlagINTInteger0
339PO_Field_Changes SearchPO Field ChangesML_POP_PO_Field_ChangesLong Integer0
340PO_Status_Orig SearchPO Status OrigDDL_PO_StatusInteger0
341Revision_Number SearchRevision NumberINT4Integer4
342TTLRTLTD SearchTotal Returns LTDDLR19_RBS0_STR$Currency19
343TTLRTYTD SearchTotal Returns YTDDLR19_RBS0_STR$Currency19
344TTLRTLYR SearchTotal Returns LYRDLR19_RBS0_STR$Currency19
345UPSZONE1 SearchASI_UPS_ZoneSTR3String3
346SHIPMTHD1 SearchASI_Shipping_MethodSTR15_Shipping_MethodString15
347TAXSCHID1 SearchASI_Tax_Schedule_IDSTR15_Tax_Schedule_IDString15
348ADDRESS11 SearchASI_Address_1STR60String60
349ADDRESS21 SearchASI_Address_2STR60String60
350ADDRESS31 SearchASI_Address_3STR60String60
351COUNTRY1 SearchASI_CountrySTR60String60
352CITY1 SearchASI_CitySTR35String35
353STATE1 SearchASI_StateSTR30_StateString29
354ZIP1 SearchASI_ZipSTR10String10
355PHONE11 SearchASI_Phone_1Phone_NumberString14
356PHONE21 SearchASI_Phone_2Phone_NumberString14
357FAX1 SearchASI_FaxSTR14_FAXString14
358PRBTADCD1 SearchASI_Primary_Billto_Address_CodeSTR15_LBAUString15
359PRSTADCD1 SearchASI_Primary_Shipto_Address_CodeSTR15_LBAUString15
360CHEKBKID1 SearchASI_Checkbook_IDSTR15_Checkbook_IDString15
361PYMTRMID1 SearchASI_Payment_Terms_IDSTR20_Payment_Terms_IDString20
362CURNCYID1 SearchASI_Currency_IDSTR15_Currency_IDString15
363RATETPID1 SearchASI_Rate_Type_IDSTR15_Rate_Type_IDString15
364ASI_Minimum_Payment_Type SearchASI_Minimum_Payment_TypeASI_Minimum_Payment_TypeInteger0
365MINPYDLR1 SearchASI_Minimum_Payment_DollarDLR17_RBS0_UTR$Currency17
366MINPYPCT1 SearchASI_Minimum_Payment_PercentINT5_%2Integer5
367COMMENT11 SearchASI_Comment1STR30String30
368COMMENT21 SearchASI_Comment2STR30String30
369USERDEF11 SearchASI_User_Defined_1STR20String20
370USERDEF21 SearchASI_User_Defined_2STR20String20
371TXRGNNUM1 SearchASI_Tax_Registration_NumberSTR25String25
372HOLD1 SearchASI_HoldCB_HoldBoolean0
373KPDSTHST1 SearchASI_Keep_Distribution_HistoryCB_Keep_Dist_HistoryBoolean0
374KPCALHST1 SearchASI_Keep_Calendar_HistoryCB_Keep_Calendar_HistoryBoolean0
375KPERHIST1 SearchASI_Keep_Period_HistoryCB_Keep_Period_HistoryBoolean0
376KPTRXHST1 SearchASI_Keep_Trx_HistoryCB_Keep_Trx_HistoryBoolean0
377NOTEINDX1 SearchASI_Note_IndexDLR14Currency14
378CREATDDT1 SearchASI_Created_DateDTDate8
379MODIFDT1 SearchASI_Modified_DateDTDate8
380FRSTINDT1 SearchASI_First_Invoice_DateDT_DateDate6
381AVDTPLYR1 SearchASI_Average_Days_to_Pay_LYRINT3_U0Integer3
382AVDTPLIF1 SearchASI_Average_Days_To_Pay_LifeINT3_U0Integer3
383AVGDTPYR1 SearchASI_Average_Days_To_Pay_YearINT3_U0Integer3
384WROFSLIF1 SearchASI_Write_Offs_LIFEDLR19_RBS0_STR$Currency19
385WROFSLYR1 SearchASI_Write_Offs_LYRDLR19_RBS0_STR$Currency19
386WROFSYTD1 SearchASI_Write_Offs_YTDDLR19_RBS0_STR$Currency19
387ONORDAMT1 SearchASI_On_Order_AmountDLR19_RBS0_UTR$Currency19
388ASI_Post_Results_To SearchASI_Post_Results_ToASI_Post_Results_ToInteger0
389DISGRPER1 SearchASI_Discount_Grace_PeriodINT2_U0Integer2
390DOCFMTID1 SearchASI_Document_Format_IDSTR15_LBUString15
391DUEGRPER1 SearchASI_Due_Date_Grace_PeriodINT2_U0Integer2
392PHONE31 SearchASI_Phone_3Phone_NumberString14
393VENDNAME1 SearchASI_Vendor_NameSTR64_Vendor_NameString64
394VADCDPAD1 SearchASI_Vendor_Address_Code_Purchase_AddressSTR15_Address_CodeString15
395ADDRESS111 SearchASI_Address_12STR60String60
396ADDRESS211 SearchASI_Address_22STR60String60
397ADDRESS311 SearchASI_Address_32STR60String60
398COUNTRY11 SearchASI_Country2STR60String60
399CITY11 SearchASI_City2STR35String35
400STATE11 SearchASI_State2STR30_StateString29
401ZIPCODE1 SearchASI_Zip_CodeSTR10String10
402PHNUMBR11 SearchASI_Phone_Number_1Phone_NumberString14
403PHNUMBR21 SearchASI_Phone_Number_2Phone_NumberString14
404FAXNUMBR1 SearchASI_Fax_NumberSTR14_FAXString14
405SHIPMTHD11 SearchASI_Shipping_Method2STR15_Shipping_MethodString15
406CURNCYID11 SearchASI_Currency_ID2STR15_Currency_IDString15
407TXRGNNUM11 SearchASI_Tax_Registration_Number2STR25String25
408MINORDER1 SearchASI_Minimum_OrderDLR17_$U2Currency17
409PYMTRMID11 SearchASI_Payment_Terms_ID2STR20_Payment_Terms_IDString20
410HOLD11 SearchASI_Hold2CB_HoldBoolean0
411NOTEINDX11 SearchASI_Note_Index2DLR14Currency14
412CREATDDT11 SearchASI_Created_Date2DTDate8
413MODIFDT11 SearchASI_Modified_Date2DTDate8
414RATETPID11 SearchASI_Rate_Type_ID2STR15_Rate_Type_IDString15
415ONORDAMT11 SearchASI_On_Order_Amount2DLR19_RBS0_UTR$Currency19
416DISGRPER11 SearchASI_Discount_Grace_Period2INT2_U0Integer2
417DUEGRPER11 SearchASI_Due_Date_Grace_Period2INT2_U0Integer2
418GOVCRPID1 SearchASI_Governmental_Corporate_IDSTR30_Gov_Corp_IDString30
419GOVINDID1 SearchASI_Governmental_Individual_IDSTR30_Gov_Indiv_IDString30
420PHONE311 SearchASI_Phone_32Phone_NumberString14
421TAXSCHID2 SearchASI_Tax_Schedule_ID_2STR15_Tax_Schedule_IDString15
422BSIVCTTL SearchBased On Invoice TotalYNBoolean0
423Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger0
424Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger0
425FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].FRTSCHID AS 'SmartList Purchase Order-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Purchase Order'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
426MSCSCHID SearchMisc Schedule IDSTR15_LBAUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Purchase Order'].MSCSCHID AS 'SmartList Purchase Order-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP07 AS ['SmartList Purchase Order']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Purchase Order'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
427FRTTXAMT SearchFreight Tax AmountDLR19_RBSO_UTR$Currency19
428ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency19
429MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency19
430ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency19
431BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency17
432OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency17
433BackoutFreightTaxAmt SearchBackout Freight Tax AmountDLR17_RBS0_UTR$Currency17
434OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountDLR17_RBS0_UTR$Currency17
435BackoutMiscTaxAmt SearchBackout Misc Tax AmountDLR17_RBS0_UTR$Currency17
436OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountDLR17_RBS0_UTR$Currency17
437BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency17
438OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency17
439POPCONTNUM SearchPOP Contract NumberSTR20String20
440CONTENDDTE SearchContract End DateDATE_LDate0
441CNTRLBLKTBY SearchControl Blanket ByINTInteger0
442PURCHCMPNYNAM SearchPurchase Company NameSTR64_Company_NameString64
443PURCHCONTACT SearchPurchase ContactSTR60String60
444PURCHADDRESS1 SearchPurchase Address 1STR60String60
445PURCHADDRESS2 SearchPurchase Address 2STR60String60
446PURCHADDRESS3 SearchPurchase Address 3STR60String60
447PURCHCITY SearchPurchase CitySTR35String35
448PURCHSTATE SearchPurchase StateSTR30_StateString29
449PURCHZIPCODE SearchPurchase Zip CodeSTR10String10
450PURCHCOUNTRY SearchPurchase CountrySTR60String60
451PURCHPHONE1 SearchPurchase Phone 1Phone_NumberString14
452PURCHPHONE2 SearchPurchase Phone 2Phone_NumberString14
453PURCHPHONE3 SearchPurchase Phone 3Phone_Number3String14
454PURCHFAX SearchPurchase FaxSTR14_FAXString14
455TXSCHSRC SearchTax Schedule SourceINT1Integer1
azurecurveProductsSmartList (1493)PathnameSmartList Purchase Order (ASIEXP07)

Leave a Reply

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