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 TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2PONUMBER SearchPO NumberSTR17_POP_NumberString1817
3ASI_Document_Status SearchASI_Document_StatusINTInteger20
4POSTATUS SearchPO StatusDDL_PO_StatusInteger20
5STATGRP SearchStatus GroupINT1Integer21
6POTYPE SearchPO TypeDDL_POP_PO_TypeInteger20
7USER2ENT SearchUser To EnterSTR15_User_IDString1615
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 WithSTR20String2220
9DOCDATE SearchDocument DateDTDate48
10LSTEDTDT SearchLast Edit DateDT_DateDate46
11LSTPRTDT SearchLast Printed DateDATE_LDate40
12PRMDATE SearchPromised DateDATE_LDate40
13PRMSHPDTE SearchPromised Ship DateDATE_LDate40
14REQDATE SearchRequired DateDATE_LDate40
15REQTNDT SearchRequisition DateDATE_LDate40
16SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
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 NumberSTR25String2625
18REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency1017
19SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency1017
20TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
21FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
22MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency1017
23TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
24VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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_NameString6664
26MINORDER SearchMinimum OrderDLR17_$U2Currency1017
27VADCDPAD SearchVendor Address Code - Purchase AddressSTR15_Address_CodeString1615
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 IDINT5Integer24
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_LBAUString1615
30PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
31CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
32CONTACT SearchContactSTR60String6260
33ADDRESS1 SearchAddress 1STR60String6260
34ADDRESS2 SearchAddress 2STR60String6260
35ADDRESS3 SearchAddress 3STR60String6260
36CITY SearchCitySTR35String3635
37STATE SearchStateSTR30_StateString3029
38ZIPCODE SearchZip CodeSTR10String1210
39COUNTRY SearchCountrySTR60String6260
40PHONE1 SearchPhone 1Phone_NumberString2214
41PHONE2 SearchPhone 2Phone_NumberString2214
42FAX SearchFaxSTR14_FAXString2214
43PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
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$Currency1011
45DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer25
46DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency1017
47DISCDATE SearchDiscount DateDTDate48
48DUEDATE SearchDue DateDTDate48
49TRDISPCT SearchTrade Discount PercentINT4_%2Integer24
50CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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_U0Integer24
52CREATDDT SearchCreated DateDTDate48
53MODIFDT SearchModified DateDTDate48
54TRXSORCE SearchTRX SourceSTR13String1413
55PONOTIDS_1 SearchPO Note ID Array[1]DLR14Currency1014
56PONOTIDS_2 SearchPO Note ID Array[2]DLR14Currency1014
57PONOTIDS_3 SearchPO Note ID Array[3]DLR14Currency1014
58PONOTIDS_4 SearchPO Note ID Array[4]DLR14Currency1014
59PONOTIDS_5 SearchPO Note ID Array[5]DLR14Currency1014
60PONOTIDS_6 SearchPO Note ID Array[6]DLR14Currency1014
61PONOTIDS_7 SearchPO Note ID Array[7]DLR14Currency1014
62PONOTIDS_8 SearchPO Note ID Array[8]DLR14Currency1014
63PONOTIDS_9 SearchPO Note ID Array[9]DLR14Currency1014
64PONOTIDS_10 SearchPO Note ID Array[10]DLR14Currency1014
65PONOTIDS_11 SearchPO Note ID Array[11]DLR14Currency1014
66PONOTIDS_12 SearchPO Note ID Array[12]DLR14Currency1014
67PONOTIDS_13 SearchPO Note ID Array[13]DLR14Currency1014
68PONOTIDS_14 SearchPO Note ID Array[14]DLR14Currency1014
69PONOTIDS_15 SearchPO Note ID Array[15]DLR14Currency1014
70COMMNTID SearchComment IDSTR15_Comment_IDString1615
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$Currency1017
72TRDPCTPR SearchTrade Discount Percent (Precise)Trade Discount Percent (Precise)Currency (Variable)1223
73ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
74CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 IndexINT3Integer23
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_IDString1615
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_IDString1615
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_DateDate46
79TIME1 SearchTimeTM6Time46
80RATECALC SearchRate Calc MethodINTInteger20
81DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
82MCTRXSTT SearchMC Transaction StateINT1Integer21
83OREMSUBT SearchOriginating Remaining SubtotalDLR17_RBS0_UTR$Currency1017
84ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency1017
85Originating_Canceled_Sub SearchOriginating Canceled SubtotalDLR17_RBS0_STR$Currency1017
86ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
87ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
88OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency1017
89ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
90ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency1011
91ODISAMTAV SearchOriginating Discount Amount AvailableDLR17_RBS0_UTR$Currency1017
92BUYERID SearchBuyer IDSTR15_User_IDString1615
93ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
94ORORDAMT SearchOriginating On Order AmountDLR19_RBS0_UTR$Currency1019
95HOLD SearchHoldCB_HoldBoolean20
96ONHOLDDATE SearchOn Hold DateDTDate48
97ONHOLDBY SearchOn Hold BySTR15_User_IDString1615
98HOLDREMOVEDATE SearchHold Remove DateDTDate48
99HOLDREMOVEBY SearchHold Remove BySTR15_User_IDString1615
100ALLOWSOCMTS SearchAllow SO CommitmentsCB_AllowSOCommitmentsBoolean20
101XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
102VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString6664
103VENDSHNM SearchVendor Short NameSTR15String1615
104VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString1615
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_CodeString1615
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_CodeString1615
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_IDString1210
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 ContactSTR60String6260
109UPSZONE SearchUPS ZoneSTR3String43
110TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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 VendorSTR20String2220
112TXIDNMBR SearchTax ID NumberTax_ID_NumberString1211
113VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger20
114PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString1615
115TRDDISCT SearchTrade DiscountINT4_%2Integer24
116TEN99TYPE Search1099 Type1099_TypeInteger20
117MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger20
118MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
119MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
120MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger20
121MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency1017
122COMMENT1 SearchComment1STR30String3230
123COMMENT2 SearchComment2STR30String3230
124USERDEF1 SearchUser Defined 1STR20String2220
125USERDEF2 SearchUser Defined 2STR20String2220
126CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency1017
127PYMNTPRI SearchPayment PrioritySTR3String43
128KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
129KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean20
130KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
131KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
132PTCSHACF SearchPost To Cash Account FromGBInteger20
133CREDTLMT SearchCredit LimitGBInteger20
134WRITEOFF SearchWriteoffGBInteger20
135MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency1017
136SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean20
137PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
138DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String2625
139CRTCOMDT SearchCertificate Commencing DateDTDate48
140CRTEXPDT SearchCertificate Expiration DateDTDate48
141RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean20
142XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean20
143PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean20
144PMAPINDX SearchPM AP IndexLI_14Long Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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_IDString1615
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 VendorBoolean20
160Post_Results_To SearchPost Results ToGBInteger20
161FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger20
162HIESTBAL SearchHighest BalanceDLR17_RBS0_UTR$Currency1017
163CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency1019
164NOINVLIF SearchNumber of Invoices LIFELI_9U0Long Integer49
165NOINVLYR SearchNumber of Invoices LYRLI_9U0Long Integer49
166NOINVYTD SearchNumber of Invoices YTDLI_9U0Long Integer49
167NOPILIFE SearchNumber of Paid Invoices LIFELI_9U0Long Integer49
168NOPINYTD SearchNumber of Paid Invoices YTDLI_9U0Long Integer49
169AMBLDLIF SearchAmount Billed LIFEDLR19_RBS0_STR$Currency1019
170AMBLDLYR SearchAmount Billed LYRDLR19_RBS0_STR$Currency1019
171AMBLDTYD SearchAmount Billed YTDDLR19_RBS0_STR$Currency1019
172AMTPDLIF SearchAmount Paid LIFEDLR19_RBS0_STR$Currency1019
173AMTPDLYR SearchAmount Paid LYRDLR19_RBS0_STR$Currency1019
174AMTPDYTD SearchAmount Paid YTDDLR19_RBS0_STR$Currency1019
175TEN99ALIF Search1099 Amount LIFEDLR19_RBS0_STR$Currency1019
176TEN99ALYR Search1099 Amount LYRDLR19_RBS0_STR$Currency1019
177TEN99AYTD Search1099 Amount YTDDLR19_RBS0_STR$Currency1019
178DISAVYTD SearchDiscount Available YTDDLR19_RBS0_STR$Currency1019
179DISAVLIF SearchDiscount Available LIFEDLR19_RBS0_STR$Currency1019
180DISAVLYR SearchDiscount Available LYRDLR19_RBS0_STR$Currency1019
181DISTKNLF SearchDiscount Taken LIFEDLR19_RBS0_STR$Currency1019
182DISTKLYR SearchDiscount Taken LYRDLR19_RBS0_STR$Currency1019
183DISTKYTD SearchDiscount Taken YTDDLR19_RBS0_STR$Currency1019
184DISLSTLF SearchDiscount Lost LIFEDLR19_RBS0_STR$Currency1019
185DISLSLYR SearchDiscount Lost LYRDLR19_RBS0_STR$Currency1019
186DISLSYTD SearchDiscount Lost YTDDLR19_RBS0_STR$Currency1019
187FINCHLIF SearchFinance Charge LIFEDLR19_RBS0_STR$Currency1019
188FINCHLYR SearchFinance Charge LYRDLR19_RBS0_STR$Currency1019
189FINCHYTD SearchFinance Charge YTDDLR19_RBS0_STR$Currency1019
190WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency1019
191WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency1019
192WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency1019
193RTRNSLIF SearchReturns LIFEDLR19_RBS0_STR$Currency1019
194RTRNSLYR SearchReturns LYRDLR19_RBS0_STR$Currency1019
195RTRNSYTD SearchReturns YTDDLR19_RBS0_STR$Currency1019
196TRDTKLIF SearchTrade Discounts Taken LIFEDLR19_RBSO_STR$Currency1019
197TRDTLYR SearchTrade Discounts Taken LYRDLR19_RBSO_STR$Currency1019
198TRDTYTD SearchTrade Discounts Taken YTDDLR19_RBSO_STR$Currency1019
199NFNCHLIF SearchNumber of Finance Charges LIFELI_9U0Long Integer49
200NFNCHLYR SearchNumber of Finance Charges LYRLI_9U0Long Integer49
201NFNCHYTD SearchNumber of Finance Charges YTDLI_9U0Long Integer49
202RTNGOWED SearchRetainage OwedDLR17_RBS0_STR$Currency1017
203LSTCHNUM SearchLast Check NumberCheck_NumberString2220
204LSTCHKDT SearchLast Check DateDTDate48
205LSTCHAMT SearchLast Check AmountDLR17_RBS0_UTR$Currency1017
206LSTINNUM SearchLast Invoice NumberSTR20String2220
207LSTINVAM SearchLast Invoice AmountDLR17_RBS0_UTR$Currency1017
208LSTPURDT SearchLast Purchase DateDTDate48
209FSTPURDT SearchFirst Purchase DateDTDate48
210CURUNPBN SearchCurrent Unapplied Payment BalanceDLR17_RBS0_UTR$Currency1017
211UNPDFNCH SearchUnpaid Finance ChargesDLR17_RBS0_UTR$Currency1017
212DYCHTCLR SearchDays Checks To ClearINT3_U0Integer23
213AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer23
214AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer23
215ACCRDINV SearchAccured InventoryDLR17_RBS0_STR$Currency1017
216CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
217CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString1615
218CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
219CNTCPRSN SearchContact PersonSTR60String6260
220STMTNAME SearchStatement NameSTR64String6664
221SHRTNAME SearchShort NameSTR15String1615
222ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
223STADDRCD SearchStatement Address CodeSTR15_LBAUString1615
224SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
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_TypeInteger20
226CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency1017
227CRLMTPER SearchCredit Limit PeriodDDLInteger20
228CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency1017
229CUSTDISC SearchCustomer DiscountINT5_%2Integer25
230PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
231FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger20
232FNCHPCNT SearchFinance Charge PercentINT5_%2Integer25
233FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency1017
234MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger20
235MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency1017
236TAXEXMT1 SearchTax Exempt 1STR25String2625
237TAXEXMT2 SearchTax Exempt 2STR25String2625
238BALNCTYP SearchBalance TypeGB_Bal_TypeInteger20
239STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger20
240BANKNAME SearchBank NameSTR30String3230
241BNKBRNCH SearchBank BranchSTR20String2220
242SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
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 TypeGBInteger20
244RMCSHACC SearchRM Cash Account IndexLI_14Long Integer414
245RMARACC SearchRM AR Account IndexLI_14Long Integer414
246RMSLSACC SearchRM Sales Account IndexLI_14Long Integer414
247RMIVACC SearchRM IV Account IndexLI_14Long Integer414
248RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer414
249RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer414
250RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer414
251RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer414
252RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer414
253FRSTINDT SearchFirst Invoice DateDT_DateDate46
254INACTIVE SearchInactiveCB_InactiveBoolean20
255CRCARDID SearchCredit Card IDSTR15String1615
256CRCRDNUM SearchCredit Card NumberSTR20String2220
257CCRDXPDT SearchCredit Card Exp DateDT_DateDate46
258Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean20
259FINCHID SearchFinance Charge IDSTR15_Charge_IDString1615
260GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
261GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
262TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency1019
263NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer46
264CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency1019
265AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency1017
266AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency1017
267AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency1017
268AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency1017
269AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency1017
270AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency1017
271AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency1017
272LASTAGED SearchLast AgedDATEDate46
273LSTNSFCD SearchLast NSF Check DateDT_DateDate46
274LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency1017
275LASTPYDT SearchLast Payment DateDT_DateDate46
276LSTTRXDT SearchLast Transaction DateDT_DateDate46
277LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency1017
278LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency1019
279UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency1017
280NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer410
281NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer410
282NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer410
283TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency1019
284TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency1019
285TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency1019
286TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency1019
287RETAINAG SearchRetainageDLR19_RBS0_STR$Currency1019
288TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency1019
289NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer46
290UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency1019
291UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency1019
292UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency1019
293UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency1019
294NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency1019
295TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency1019
296TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency1019
297TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency1019
298TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency1019
299TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency1019
300TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency1019
301TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency1019
302TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency1019
303TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency1019
304TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency1019
305TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency1019
306TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency1019
307FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency1019
308FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency1019
309TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency1019
310TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency1019
311TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency1019
312TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency1019
313TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency1019
314TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency1019
315TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency1019
316TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency1019
317TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency1019
318TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer46
319TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer46
320TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer46
321TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer46
322TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer46
323TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer46
324HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency1019
325HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency1019
326HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency1019
327LASTSTDT SearchLast Statement DateDATEDate46
328LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency1017
329DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency1019
330DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
331DOCFMTID SearchDocument Format IDSTR15_LBUString1615
332DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
333PHONE3 SearchPhone 3Phone_Number3String2214
334TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
335Withholding_LIFE SearchWithholding LIFEDLR19_RBS0_STR$Currency1019
336WITHLYR SearchWithholding LYRDLR19_RBS0_STR$Currency1019
337WITHYTD SearchWithholding YTDDLR19_RBS0_STR$Currency1019
338Change_Order_Flag SearchChange Order FlagINTInteger20
339PO_Field_Changes SearchPO Field ChangesML_POP_PO_Field_ChangesLong Integer40
340PO_Status_Orig SearchPO Status OrigDDL_PO_StatusInteger20
341Revision_Number SearchRevision NumberINT4Integer24
342TTLRTLTD SearchTotal Returns LTDDLR19_RBS0_STR$Currency1019
343TTLRTYTD SearchTotal Returns YTDDLR19_RBS0_STR$Currency1019
344TTLRTLYR SearchTotal Returns LYRDLR19_RBS0_STR$Currency1019
345UPSZONE1 SearchASI_UPS_ZoneSTR3String43
346SHIPMTHD1 SearchASI_Shipping_MethodSTR15_Shipping_MethodString1615
347TAXSCHID1 SearchASI_Tax_Schedule_IDSTR15_Tax_Schedule_IDString1615
348ADDRESS11 SearchASI_Address_1STR60String6260
349ADDRESS21 SearchASI_Address_2STR60String6260
350ADDRESS31 SearchASI_Address_3STR60String6260
351COUNTRY1 SearchASI_CountrySTR60String6260
352CITY1 SearchASI_CitySTR35String3635
353STATE1 SearchASI_StateSTR30_StateString3029
354ZIP1 SearchASI_ZipSTR10String1210
355PHONE11 SearchASI_Phone_1Phone_NumberString2214
356PHONE21 SearchASI_Phone_2Phone_NumberString2214
357FAX1 SearchASI_FaxSTR14_FAXString2214
358PRBTADCD1 SearchASI_Primary_Billto_Address_CodeSTR15_LBAUString1615
359PRSTADCD1 SearchASI_Primary_Shipto_Address_CodeSTR15_LBAUString1615
360CHEKBKID1 SearchASI_Checkbook_IDSTR15_Checkbook_IDString1615
361PYMTRMID1 SearchASI_Payment_Terms_IDSTR20_Payment_Terms_IDString2220
362CURNCYID1 SearchASI_Currency_IDSTR15_Currency_IDString1615
363RATETPID1 SearchASI_Rate_Type_IDSTR15_Rate_Type_IDString1615
364ASI_Minimum_Payment_Type SearchASI_Minimum_Payment_TypeASI_Minimum_Payment_TypeInteger20
365MINPYDLR1 SearchASI_Minimum_Payment_DollarDLR17_RBS0_UTR$Currency1017
366MINPYPCT1 SearchASI_Minimum_Payment_PercentINT5_%2Integer25
367COMMENT11 SearchASI_Comment1STR30String3230
368COMMENT21 SearchASI_Comment2STR30String3230
369USERDEF11 SearchASI_User_Defined_1STR20String2220
370USERDEF21 SearchASI_User_Defined_2STR20String2220
371TXRGNNUM1 SearchASI_Tax_Registration_NumberSTR25String2625
372HOLD1 SearchASI_HoldCB_HoldBoolean20
373KPDSTHST1 SearchASI_Keep_Distribution_HistoryCB_Keep_Dist_HistoryBoolean20
374KPCALHST1 SearchASI_Keep_Calendar_HistoryCB_Keep_Calendar_HistoryBoolean20
375KPERHIST1 SearchASI_Keep_Period_HistoryCB_Keep_Period_HistoryBoolean20
376KPTRXHST1 SearchASI_Keep_Trx_HistoryCB_Keep_Trx_HistoryBoolean20
377NOTEINDX1 SearchASI_Note_IndexDLR14Currency1014
378CREATDDT1 SearchASI_Created_DateDTDate48
379MODIFDT1 SearchASI_Modified_DateDTDate48
380FRSTINDT1 SearchASI_First_Invoice_DateDT_DateDate46
381AVDTPLYR1 SearchASI_Average_Days_to_Pay_LYRINT3_U0Integer23
382AVDTPLIF1 SearchASI_Average_Days_To_Pay_LifeINT3_U0Integer23
383AVGDTPYR1 SearchASI_Average_Days_To_Pay_YearINT3_U0Integer23
384WROFSLIF1 SearchASI_Write_Offs_LIFEDLR19_RBS0_STR$Currency1019
385WROFSLYR1 SearchASI_Write_Offs_LYRDLR19_RBS0_STR$Currency1019
386WROFSYTD1 SearchASI_Write_Offs_YTDDLR19_RBS0_STR$Currency1019
387ONORDAMT1 SearchASI_On_Order_AmountDLR19_RBS0_UTR$Currency1019
388ASI_Post_Results_To SearchASI_Post_Results_ToASI_Post_Results_ToInteger20
389DISGRPER1 SearchASI_Discount_Grace_PeriodINT2_U0Integer22
390DOCFMTID1 SearchASI_Document_Format_IDSTR15_LBUString1615
391DUEGRPER1 SearchASI_Due_Date_Grace_PeriodINT2_U0Integer22
392PHONE31 SearchASI_Phone_3Phone_NumberString2214
393VENDNAME1 SearchASI_Vendor_NameSTR64_Vendor_NameString6664
394VADCDPAD1 SearchASI_Vendor_Address_Code_Purchase_AddressSTR15_Address_CodeString1615
395ADDRESS111 SearchASI_Address_12STR60String6260
396ADDRESS211 SearchASI_Address_22STR60String6260
397ADDRESS311 SearchASI_Address_32STR60String6260
398COUNTRY11 SearchASI_Country2STR60String6260
399CITY11 SearchASI_City2STR35String3635
400STATE11 SearchASI_State2STR30_StateString3029
401ZIPCODE1 SearchASI_Zip_CodeSTR10String1210
402PHNUMBR11 SearchASI_Phone_Number_1Phone_NumberString2214
403PHNUMBR21 SearchASI_Phone_Number_2Phone_NumberString2214
404FAXNUMBR1 SearchASI_Fax_NumberSTR14_FAXString2214
405SHIPMTHD11 SearchASI_Shipping_Method2STR15_Shipping_MethodString1615
406CURNCYID11 SearchASI_Currency_ID2STR15_Currency_IDString1615
407TXRGNNUM11 SearchASI_Tax_Registration_Number2STR25String2625
408MINORDER1 SearchASI_Minimum_OrderDLR17_$U2Currency1017
409PYMTRMID11 SearchASI_Payment_Terms_ID2STR20_Payment_Terms_IDString2220
410HOLD11 SearchASI_Hold2CB_HoldBoolean20
411NOTEINDX11 SearchASI_Note_Index2DLR14Currency1014
412CREATDDT11 SearchASI_Created_Date2DTDate48
413MODIFDT11 SearchASI_Modified_Date2DTDate48
414RATETPID11 SearchASI_Rate_Type_ID2STR15_Rate_Type_IDString1615
415ONORDAMT11 SearchASI_On_Order_Amount2DLR19_RBS0_UTR$Currency1019
416DISGRPER11 SearchASI_Discount_Grace_Period2INT2_U0Integer22
417DUEGRPER11 SearchASI_Due_Date_Grace_Period2INT2_U0Integer22
418GOVCRPID1 SearchASI_Governmental_Corporate_IDSTR30_Gov_Corp_IDString3230
419GOVINDID1 SearchASI_Governmental_Individual_IDSTR30_Gov_Indiv_IDString3230
420PHONE311 SearchASI_Phone_32Phone_NumberString2214
421TAXSCHID2 SearchASI_Tax_Schedule_ID_2STR15_Tax_Schedule_IDString1615
422BSIVCTTL SearchBased On Invoice TotalYNBoolean20
423Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger20
424Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger20
425FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
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_LBAUString1615
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$Currency1019
428ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency1019
429MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency1019
430ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency1019
431BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency1017
432OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency1017
433BackoutFreightTaxAmt SearchBackout Freight Tax AmountDLR17_RBS0_UTR$Currency1017
434OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountDLR17_RBS0_UTR$Currency1017
435BackoutMiscTaxAmt SearchBackout Misc Tax AmountDLR17_RBS0_UTR$Currency1017
436OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountDLR17_RBS0_UTR$Currency1017
437BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency1017
438OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency1017
439POPCONTNUM SearchPOP Contract NumberSTR20String2220
440CONTENDDTE SearchContract End DateDATE_LDate40
441CNTRLBLKTBY SearchControl Blanket ByINTInteger20
442PURCHCMPNYNAM SearchPurchase Company NameSTR64_Company_NameString6664
443PURCHCONTACT SearchPurchase ContactSTR60String6260
444PURCHADDRESS1 SearchPurchase Address 1STR60String6260
445PURCHADDRESS2 SearchPurchase Address 2STR60String6260
446PURCHADDRESS3 SearchPurchase Address 3STR60String6260
447PURCHCITY SearchPurchase CitySTR35String3635
448PURCHSTATE SearchPurchase StateSTR30_StateString3029
449PURCHZIPCODE SearchPurchase Zip CodeSTR10String1210
450PURCHCOUNTRY SearchPurchase CountrySTR60String6260
451PURCHPHONE1 SearchPurchase Phone 1Phone_NumberString2214
452PURCHPHONE2 SearchPurchase Phone 2Phone_NumberString2214
453PURCHPHONE3 SearchPurchase Phone 3Phone_Number3String2214
454PURCHFAX SearchPurchase FaxSTR14_FAXString2214
455TXSCHSRC SearchTax Schedule SourceINT1Integer21
azurecurveProductsSmartList (1493)PathnameSmartList Purchase Order (ASIEXP07)

Leave a Reply

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