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:

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_ByLong IntegerLI_1414
2PONUMBER SearchPO NumberStringSTR17_POP_Number17
3ASI_Document_Status SearchASI_Document_StatusIntegerINT0
4POSTATUS SearchPO StatusIntegerDDL_PO_Status0
5STATGRP SearchStatus GroupIntegerINT11
6POTYPE SearchPO TypeIntegerDDL_POP_PO_Type0
7USER2ENT SearchUser To EnterStringSTR15_User_ID15
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 WithStringSTR2020
9DOCDATE SearchDocument DateDateDT8
10LSTEDTDT SearchLast Edit DateDateDT_Date6
11LSTPRTDT SearchLast Printed DateDateDATE_L0
12PRMDATE SearchPromised DateDateDATE_L0
13PRMSHPDTE SearchPromised Ship DateDateDATE_L0
14REQDATE SearchRequired DateDateDATE_L0
15REQTNDT SearchRequisition DateDateDATE_L0
16SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
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 NumberStringSTR2525
18REMSUBTO SearchRemaining SubtotalCurrencyDLR17_RBS0_UTR$17
19SUBTOTAL SearchSubtotalCurrencyDLR17_RBS0_STR$17
20TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
21FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
22MSCCHAMT SearchMisc Charges AmountCurrencyDLR17_RBS0_UTR$17
23TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
24VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
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 NameStringSTR64_Vendor_Name64
26MINORDER SearchMinimum OrderCurrencyDLR17_$U217
27VADCDPAD SearchVendor Address Code - Purchase AddressStringSTR15_Address_Code15
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 IDIntegerINT54
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 CodeStringSTR15_LBAU15
30PRSTADCD SearchPrimary Shipto Address CodeStringSTR15_LBAU15
31CMPNYNAM SearchCompany NameStringSTR64_Company_Name64
32CONTACT SearchContactStringSTR6060
33ADDRESS1 SearchAddress 1StringSTR6060
34ADDRESS2 SearchAddress 2StringSTR6060
35ADDRESS3 SearchAddress 3StringSTR6060
36CITY SearchCityStringSTR3535
37STATE SearchStateStringSTR30_State29
38ZIPCODE SearchZip CodeStringSTR1010
39COUNTRY SearchCountryStringSTR6060
40PHONE1 SearchPhone 1StringPhone_Number14
41PHONE2 SearchPhone 2StringPhone_Number14
42FAX SearchFaxStringSTR14_FAX14
43PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
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 AmountCurrencyDLR11_RBS0_UTR$11
45DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
46DISAMTAV SearchDiscount Amount AvailableCurrencyDLR17_RBS0_UTR$17
47DISCDATE SearchDiscount DateDateDT8
48DUEDATE SearchDue DateDateDT8
49TRDISPCT SearchTrade Discount PercentIntegerINT4_%24
50CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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 PrintedIntegerINT4_U04
52CREATDDT SearchCreated DateDateDT8
53MODIFDT SearchModified DateDateDT8
54TRXSORCE SearchTRX SourceStringSTR1313
55PONOTIDS_1 SearchPO Note ID Array[1]CurrencyDLR1414
56PONOTIDS_2 SearchPO Note ID Array[2]CurrencyDLR1414
57PONOTIDS_3 SearchPO Note ID Array[3]CurrencyDLR1414
58PONOTIDS_4 SearchPO Note ID Array[4]CurrencyDLR1414
59PONOTIDS_5 SearchPO Note ID Array[5]CurrencyDLR1414
60PONOTIDS_6 SearchPO Note ID Array[6]CurrencyDLR1414
61PONOTIDS_7 SearchPO Note ID Array[7]CurrencyDLR1414
62PONOTIDS_8 SearchPO Note ID Array[8]CurrencyDLR1414
63PONOTIDS_9 SearchPO Note ID Array[9]CurrencyDLR1414
64PONOTIDS_10 SearchPO Note ID Array[10]CurrencyDLR1414
65PONOTIDS_11 SearchPO Note ID Array[11]CurrencyDLR1414
66PONOTIDS_12 SearchPO Note ID Array[12]CurrencyDLR1414
67PONOTIDS_13 SearchPO Note ID Array[13]CurrencyDLR1414
68PONOTIDS_14 SearchPO Note ID Array[14]CurrencyDLR1414
69PONOTIDS_15 SearchPO Note ID Array[15]CurrencyDLR1414
70COMMNTID SearchComment IDStringSTR15_Comment_ID15
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 SubtotalCurrencyDLR17_RBS0_STR$17
72TRDPCTPR SearchTrade Discount Percent (Precise)Currency (Variable)Trade Discount Percent (Precise)23
73ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
74CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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 IndexIntegerINT33
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 IDStringSTR15_Rate_Type_ID15
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 IDStringSTR15_Exchange_Table_ID15
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 DateDateDT_Date6
79TIME1 SearchTimeTimeTM66
80RATECALC SearchRate Calc MethodIntegerINT0
81DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
82MCTRXSTT SearchMC Transaction StateIntegerINT11
83OREMSUBT SearchOriginating Remaining SubtotalCurrencyDLR17_RBS0_UTR$17
84ORSUBTOT SearchOriginating SubtotalCurrencyDLR17_RBS0_STR$17
85Originating_Canceled_Sub SearchOriginating Canceled SubtotalCurrencyDLR17_RBS0_STR$17
86ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
87ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
88OMISCAMT SearchOriginating Misc Charges AmountCurrencyDLR17_RBS0_UTR$17
89ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
90ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
91ODISAMTAV SearchOriginating Discount Amount AvailableCurrencyDLR17_RBS0_UTR$17
92BUYERID SearchBuyer IDStringSTR15_User_ID15
93ONORDAMT SearchOn Order AmountCurrencyDLR19_RBS0_UTR$19
94ORORDAMT SearchOriginating On Order AmountCurrencyDLR19_RBS0_UTR$19
95HOLD SearchHoldBooleanCB_Hold0
96ONHOLDDATE SearchOn Hold DateDateDT8
97ONHOLDBY SearchOn Hold ByStringSTR15_User_ID15
98HOLDREMOVEDATE SearchHold Remove DateDateDT8
99HOLDREMOVEBY SearchHold Remove ByStringSTR15_User_ID15
100ALLOWSOCMTS SearchAllow SO CommitmentsBooleanCB_AllowSOCommitments0
101XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
102VNDCHKNM SearchVendor Check NameStringSTR64_Vendor_Name64
103VENDSHNM SearchVendor Short NameStringSTR1515
104VADDCDPR SearchVendor Address Code - PrimaryStringSTR15_Address_Code15
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 FromStringSTR15_Address_Code15
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 ToStringSTR15_Address_Code15
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 IDStringSTR10_Class_ID10
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 ContactStringSTR6060
109UPSZONE SearchUPS ZoneStringSTR33
110TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
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 VendorStringSTR2020
112TXIDNMBR SearchTax ID NumberStringTax_ID_Number11
113VENDSTTS SearchVendor StatusIntegerDDL_Vendor_Status0
114PARVENID SearchParent Vendor IDStringSTR_15_Vendor_ID15
115TRDDISCT SearchTrade DiscountIntegerINT4_%24
116TEN99TYPE Search1099 TypeInteger1099_Type0
117MINPYTYP SearchMinimum Payment TypeIntegerGB_Amt_Type0
118MINPYPCT SearchMinimum Payment PercentIntegerINT5_%25
119MINPYDLR SearchMinimum Payment DollarCurrencyDLR17_RBS0_UTR$17
120MXIAFVND SearchMaximum Invoice Amount For VendorsIntegerGB0
121MAXINDLR SearchMaximum Invoice DollarCurrencyDLR17_$U217
122COMMENT1 SearchComment1StringSTR3030
123COMMENT2 SearchComment2StringSTR3030
124USERDEF1 SearchUser Defined 1StringSTR2020
125USERDEF2 SearchUser Defined 2StringSTR2020
126CRLMTDLR SearchCredit Limit DollarCurrencyDLR17_$U217
127PYMNTPRI SearchPayment PriorityStringSTR33
128KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
129KGLDSTHS SearchKeep GL Dist HistoryBooleanCB_Keep_GL_Dist_History0
130KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
131KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
132PTCSHACF SearchPost To Cash Account FromIntegerGB0
133CREDTLMT SearchCredit LimitIntegerGB0
134WRITEOFF SearchWriteoffIntegerGB0
135MXWOFAMT SearchMaximum Write Off AmountCurrencyDLR17_$U217
136SBPPSDED SearchSubject To PPS DeductionsBooleanCB_Subject_To_PPS_Deductions0
137PPSTAXRT SearchPPS Tax RateIntegerINT5_%25
138DXVARNUM SearchDeduction Exemption/Variation NumberStringSTR2525
139CRTCOMDT SearchCertificate Commencing DateDateDT8
140CRTEXPDT SearchCertificate Expiration DateDateDT8
141RTOBUTKN SearchReporting Obligation UndertakenBooleanCB_Reporting_Obligation0
142XPDTOBLG SearchExpiration Date ObligationBooleanCB_Expiration_Date_Obligation0
143PRSPAYEE SearchPrescribed PayeeBooleanCB_Prescribed_Payee0
144PMAPINDX SearchPM AP IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IDStringSTR15_Checkbook_ID15
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 VendorBooleanCB Revalue Vendor0
160Post_Results_To SearchPost Results ToIntegerGB0
161FREEONBOARD SearchFree On BoardIntegerDDL_Free_On_Board0
162HIESTBAL SearchHighest BalanceCurrencyDLR17_RBS0_UTR$17
163CURRBLNC SearchCurrent BalanceCurrencyDLR19_RBS0_STR$19
164NOINVLIF SearchNumber of Invoices LIFELong IntegerLI_9U09
165NOINVLYR SearchNumber of Invoices LYRLong IntegerLI_9U09
166NOINVYTD SearchNumber of Invoices YTDLong IntegerLI_9U09
167NOPILIFE SearchNumber of Paid Invoices LIFELong IntegerLI_9U09
168NOPINYTD SearchNumber of Paid Invoices YTDLong IntegerLI_9U09
169AMBLDLIF SearchAmount Billed LIFECurrencyDLR19_RBS0_STR$19
170AMBLDLYR SearchAmount Billed LYRCurrencyDLR19_RBS0_STR$19
171AMBLDTYD SearchAmount Billed YTDCurrencyDLR19_RBS0_STR$19
172AMTPDLIF SearchAmount Paid LIFECurrencyDLR19_RBS0_STR$19
173AMTPDLYR SearchAmount Paid LYRCurrencyDLR19_RBS0_STR$19
174AMTPDYTD SearchAmount Paid YTDCurrencyDLR19_RBS0_STR$19
175TEN99ALIF Search1099 Amount LIFECurrencyDLR19_RBS0_STR$19
176TEN99ALYR Search1099 Amount LYRCurrencyDLR19_RBS0_STR$19
177TEN99AYTD Search1099 Amount YTDCurrencyDLR19_RBS0_STR$19
178DISAVYTD SearchDiscount Available YTDCurrencyDLR19_RBS0_STR$19
179DISAVLIF SearchDiscount Available LIFECurrencyDLR19_RBS0_STR$19
180DISAVLYR SearchDiscount Available LYRCurrencyDLR19_RBS0_STR$19
181DISTKNLF SearchDiscount Taken LIFECurrencyDLR19_RBS0_STR$19
182DISTKLYR SearchDiscount Taken LYRCurrencyDLR19_RBS0_STR$19
183DISTKYTD SearchDiscount Taken YTDCurrencyDLR19_RBS0_STR$19
184DISLSTLF SearchDiscount Lost LIFECurrencyDLR19_RBS0_STR$19
185DISLSLYR SearchDiscount Lost LYRCurrencyDLR19_RBS0_STR$19
186DISLSYTD SearchDiscount Lost YTDCurrencyDLR19_RBS0_STR$19
187FINCHLIF SearchFinance Charge LIFECurrencyDLR19_RBS0_STR$19
188FINCHLYR SearchFinance Charge LYRCurrencyDLR19_RBS0_STR$19
189FINCHYTD SearchFinance Charge YTDCurrencyDLR19_RBS0_STR$19
190WROFSLIF SearchWrite Offs LIFECurrencyDLR19_RBS0_STR$19
191WROFSLYR SearchWrite Offs LYRCurrencyDLR19_RBS0_STR$19
192WROFSYTD SearchWrite Offs YTDCurrencyDLR19_RBS0_STR$19
193RTRNSLIF SearchReturns LIFECurrencyDLR19_RBS0_STR$19
194RTRNSLYR SearchReturns LYRCurrencyDLR19_RBS0_STR$19
195RTRNSYTD SearchReturns YTDCurrencyDLR19_RBS0_STR$19
196TRDTKLIF SearchTrade Discounts Taken LIFECurrencyDLR19_RBSO_STR$19
197TRDTLYR SearchTrade Discounts Taken LYRCurrencyDLR19_RBSO_STR$19
198TRDTYTD SearchTrade Discounts Taken YTDCurrencyDLR19_RBSO_STR$19
199NFNCHLIF SearchNumber of Finance Charges LIFELong IntegerLI_9U09
200NFNCHLYR SearchNumber of Finance Charges LYRLong IntegerLI_9U09
201NFNCHYTD SearchNumber of Finance Charges YTDLong IntegerLI_9U09
202RTNGOWED SearchRetainage OwedCurrencyDLR17_RBS0_STR$17
203LSTCHNUM SearchLast Check NumberStringCheck_Number20
204LSTCHKDT SearchLast Check DateDateDT8
205LSTCHAMT SearchLast Check AmountCurrencyDLR17_RBS0_UTR$17
206LSTINNUM SearchLast Invoice NumberStringSTR2020
207LSTINVAM SearchLast Invoice AmountCurrencyDLR17_RBS0_UTR$17
208LSTPURDT SearchLast Purchase DateDateDT8
209FSTPURDT SearchFirst Purchase DateDateDT8
210CURUNPBN SearchCurrent Unapplied Payment BalanceCurrencyDLR17_RBS0_UTR$17
211UNPDFNCH SearchUnpaid Finance ChargesCurrencyDLR17_RBS0_UTR$17
212DYCHTCLR SearchDays Checks To ClearIntegerINT3_U03
213AVGDTPYR SearchAverage Days To Pay - YearIntegerINT3_U03
214AVDTPLIF SearchAverage Days To Pay - LifeIntegerINT3_U03
215ACCRDINV SearchAccured InventoryCurrencyDLR17_RBS0_STR$17
216CUSTNAME SearchCustomer NameStringSTR64_Customer_Name64
217CUSTCLAS SearchCustomer ClassStringSTR15_Customer_Class15
218CPRCSTNM SearchCorporate Customer NumberStringSTR15_RM_Customer_Number15
219CNTCPRSN SearchContact PersonStringSTR6060
220STMTNAME SearchStatement NameStringSTR6464
221SHRTNAME SearchShort NameStringSTR1515
222ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
223STADDRCD SearchStatement Address CodeStringSTR15_LBAU15
224SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
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 TypeIntegerGB_Amt_Type0
226CRLMTAMT SearchCredit Limit AmountCurrencyDLR17_RBS0_UTR$17
227CRLMTPER SearchCredit Limit PeriodIntegerDDL0
228CRLMTPAM SearchCredit Limit Period AmountCurrencyDLR17_RBS0_UTR$17
229CUSTDISC SearchCustomer DiscountIntegerINT5_%25
230PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
231FNCHATYP SearchFinance Charge Amt TypeIntegerGB_Amt_Type0
232FNCHPCNT SearchFinance Charge PercentIntegerINT5_%25
233FINCHDLR SearchFinance Charge DollarCurrencyDLR17_RBS0_UTR$17
234MXWOFTYP SearchMaximum Writeoff TypeIntegerGP_Max_Writeoff0
235MXWROFAM SearchMax Writeoff AmountCurrencyDLR17_RBS0_UTR$17
236TAXEXMT1 SearchTax Exempt 1StringSTR2525
237TAXEXMT2 SearchTax Exempt 2StringSTR2525
238BALNCTYP SearchBalance TypeIntegerGB_Bal_Type0
239STMTCYCL SearchStatement CycleIntegerDDL_Stmt_Cycle0
240BANKNAME SearchBank NameStringSTR3030
241BNKBRNCH SearchBank BranchStringSTR2020
242SALSTERR SearchSales TerritoryStringSTR15_Sales_Territory15
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 TypeIntegerGB0
244RMCSHACC SearchRM Cash Account IndexLong IntegerLI_1414
245RMARACC SearchRM AR Account IndexLong IntegerLI_1414
246RMSLSACC SearchRM Sales Account IndexLong IntegerLI_1414
247RMIVACC SearchRM IV Account IndexLong IntegerLI_1414
248RMCOSACC SearchRM Cost Of Sales Account IndexLong IntegerLI_1414
249RMTAKACC SearchRM Discounts Taken Account IndexLong IntegerLI_1414
250RMAVACC SearchRM Discounts Avail Account IndexLong IntegerLI_1414
251RMFCGACC SearchRM Finance Charge Account IndexLong IntegerLI_1414
252RMWRACC SearchRM Writeoff Account IndexLong IntegerLI_1414
253FRSTINDT SearchFirst Invoice DateDateDT_Date6
254INACTIVE SearchInactiveBooleanCB_Inactive0
255CRCARDID SearchCredit Card IDStringSTR1515
256CRCRDNUM SearchCredit Card NumberStringSTR2020
257CCRDXPDT SearchCredit Card Exp DateDateDT_Date6
258Revalue_Customer SearchRevalue CustomerBooleanCB Revalue Customer0
259FINCHID SearchFinance Charge IDStringSTR15_Charge_ID15
260GOVCRPID SearchGovernmental Corporate IDStringSTR30_Gov_Corp_ID30
261GOVINDID SearchGovernmental Individual IDStringSTR30_Gov_Indiv_ID30
262TNSFCLIF SearchTotal Amount Of NSF Checks LifeCurrencyDLR19_RBS0_STR$19
263NONSFLIF SearchNumber Of NSF Checks LifeLong IntegerLI6_U06
264CUSTBLNC SearchCustomer BalanceCurrencyDLR19_RBS0_STR$19
265AGPERAMT_1 SearchAging Period Amounts[1]CurrencyDLR17_RBSO_STR$17
266AGPERAMT_2 SearchAging Period Amounts[2]CurrencyDLR17_RBSO_STR$17
267AGPERAMT_3 SearchAging Period Amounts[3]CurrencyDLR17_RBSO_STR$17
268AGPERAMT_4 SearchAging Period Amounts[4]CurrencyDLR17_RBSO_STR$17
269AGPERAMT_5 SearchAging Period Amounts[5]CurrencyDLR17_RBSO_STR$17
270AGPERAMT_6 SearchAging Period Amounts[6]CurrencyDLR17_RBSO_STR$17
271AGPERAMT_7 SearchAging Period Amounts[7]CurrencyDLR17_RBSO_STR$17
272LASTAGED SearchLast AgedDateDATE6
273LSTNSFCD SearchLast NSF Check DateDateDT_Date6
274LPYMTAMT SearchLast Payment AmountCurrencyDLR17_RBS0_STR$17
275LASTPYDT SearchLast Payment DateDateDT_Date6
276LSTTRXDT SearchLast Transaction DateDateDT_Date6
277LSTTRXAM SearchLast Transaction AmountCurrencyDLR17_RBS0_STR$17
278LSTFCHAM SearchLast Finance Charge AmountCurrencyDLR19_RBS0_STR$19
279UPFCHYTD SearchUnpaid Finance Charges YTDCurrencyDLR17_RBS0_UTR$17
280NUMADTPL SearchNumber ADTP Documents - LifeLong IntegerLong_10U10
281NUMADTPY SearchNumber ADTP Documents - YearLong IntegerLong_10U10
282NUMADTPR SearchNumber ADTP Documents - LYRLong IntegerLong_10U10
283TDTKNLTD SearchTotal Discounts Taken LTDCurrencyDLR19_RBS0_STR$19
284TDTKNLYR SearchTotal Discounts Taken LYRCurrencyDLR19_RBS0_STR$19
285TDTKNYTD SearchTotal Discounts Taken YTDCurrencyDLR19_RBS0_STR$19
286TDISAYTD SearchTotal Discounts Available YTDCurrencyDLR19_RBS0_STR$19
287RETAINAG SearchRetainageCurrencyDLR19_RBS0_STR$19
288TNSFCYTD SearchTotal Amount Of NSF Checks YTDCurrencyDLR19_RBS0_STR$19
289NONSFYTD SearchNumber Of NSF Checks YTDLong IntegerLI6_U06
290UNPSTDSA SearchUnposted Sales AmountCurrencyDLR19_RBS0_UTR$19
291UNPSTDCA SearchUnposted Cash AmountCurrencyDLR19_RBS0_UTR$19
292UNPSTOSA SearchUnposted Other Sales AmountCurrencyDLR19_RBS0_UTR$19
293UNPSTOCA SearchUnposted Other Cash AmountCurrencyDLR19_RBS0_UTR$19
294NCSCHPMT SearchNon Current Scheduled PaymentsCurrencyDLR19_RBS0_STR$19
295TTLSLYTD SearchTotal Sales YTDCurrencyDLR19_RBS0_STR$19
296TTLSLLYR SearchTotal Sales LYRCurrencyDLR19_RBS0_STR$19
297TTLSLLTD SearchTotal Sales LTDCurrencyDLR19_RBS0_STR$19
298TCOSTLTD SearchTotal Costs LTDCurrencyDLR19_RBS0_STR$19
299TCOSTLYR SearchTotal Costs LYRCurrencyDLR19_RBS0_STR$19
300TCOSTYTD SearchTotal Costs YTDCurrencyDLR19_RBS0_STR$19
301TCSHRLTD SearchTotal Cash Received LTDCurrencyDLR19_RBS0_STR$19
302TCSHRLYR SearchTotal Cash Received LYRCurrencyDLR19_RBS0_STR$19
303TCSHRYTD SearchTotal Cash Received YTDCurrencyDLR19_RBS0_STR$19
304TFNCHYTD SearchTotal Finance Charges YTDCurrencyDLR19_RBS0_STR$19
305TFNCHLYR SearchTotal Finance Charges LYRCurrencyDLR19_RBS0_STR$19
306TFNCHLTD SearchTotal Finance Charges LTDCurrencyDLR19_RBS0_STR$19
307FNCHCYTD SearchFinance Charges CYTDCurrencyDLR19_RBS0_STR$19
308FNCHLYRC SearchFinance Charges LYR CalendarCurrencyDLR19_RBS0_STR$19
309TBDDTLYR SearchTotal Bad Deb LYRCurrencyDLR19_RBS0_STR$19
310TBDDTLTD SearchTotal Bad Debt LTDCurrencyDLR19_RBS0_STR$19
311TBDDTYTD SearchTotal Bad Debt YTDCurrencyDLR19_RBS0_STR$19
312TWVFCLTD SearchTotal Waived FC LTDCurrencyDLR19_RBS0_STR$19
313TWVFCLYR SearchTotal Waived FC LYRCurrencyDLR19_RBS0_STR$19
314TWVFCYTD SearchTotal Waived FC YTDCurrencyDLR19_RBS0_STR$19
315TWROFLTD SearchTotal Writeoffs LTDCurrencyDLR19_RBS0_STR$19
316TWROFLYR SearchTotal Writeoffs LYRCurrencyDLR19_RBS0_STR$19
317TWROFYTD SearchTotal Writeoffs YTDCurrencyDLR19_RBS0_STR$19
318TTLINLTD SearchTotal # Invoices LTDLong IntegerLI6_U06
319TTLINLYR SearchTotal # Invoices LYRLong IntegerLI6_U06
320TTLINYTD SearchTotal # Invoices YTDLong IntegerLI6_U06
321TTLFCLTD SearchTotal # FC LTDLong IntegerLI6_U06
322TTLFCLYR SearchTotal # FC LYRLong IntegerLI6_U06
323TTLFCYTD SearchTotal # FC YTDLong IntegerLI6_U06
324HIBALLYR SearchHigh Balance LYRCurrencyDLR19_RBSO_STR$19
325HIBALLTD SearchHigh Balance LTDCurrencyDLR19_RBSO_STR$19
326HIBALYTD SearchHigh Balance YTDCurrencyDLR19_RBSO_STR$19
327LASTSTDT SearchLast Statement DateDateDATE6
328LSTSTAMT SearchLast Statement AmountCurrencyDLR17_RBS0_STR$17
329DEPRECV SearchDeposits ReceivedCurrencyDLR19_RBS0_STR$19
330DISGRPER SearchDiscount Grace PeriodIntegerINT2_U02
331DOCFMTID SearchDocument Format IDStringSTR15_LBU15
332DUEGRPER SearchDue Date Grace PeriodIntegerINT2_U02
333PHONE3 SearchPhone 3StringPhone_Number314
334TaxInvRecvd SearchTax Invoice ReceivedBooleanCB_Tax_Invoice_Received0
335Withholding_LIFE SearchWithholding LIFECurrencyDLR19_RBS0_STR$19
336WITHLYR SearchWithholding LYRCurrencyDLR19_RBS0_STR$19
337WITHYTD SearchWithholding YTDCurrencyDLR19_RBS0_STR$19
338Change_Order_Flag SearchChange Order FlagIntegerINT0
339PO_Field_Changes SearchPO Field ChangesLong IntegerML_POP_PO_Field_Changes0
340PO_Status_Orig SearchPO Status OrigIntegerDDL_PO_Status0
341Revision_Number SearchRevision NumberIntegerINT44
342TTLRTLTD SearchTotal Returns LTDCurrencyDLR19_RBS0_STR$19
343TTLRTYTD SearchTotal Returns YTDCurrencyDLR19_RBS0_STR$19
344TTLRTLYR SearchTotal Returns LYRCurrencyDLR19_RBS0_STR$19
345UPSZONE1 SearchASI_UPS_ZoneStringSTR33
346SHIPMTHD1 SearchASI_Shipping_MethodStringSTR15_Shipping_Method15
347TAXSCHID1 SearchASI_Tax_Schedule_IDStringSTR15_Tax_Schedule_ID15
348ADDRESS11 SearchASI_Address_1StringSTR6060
349ADDRESS21 SearchASI_Address_2StringSTR6060
350ADDRESS31 SearchASI_Address_3StringSTR6060
351COUNTRY1 SearchASI_CountryStringSTR6060
352CITY1 SearchASI_CityStringSTR3535
353STATE1 SearchASI_StateStringSTR30_State29
354ZIP1 SearchASI_ZipStringSTR1010
355PHONE11 SearchASI_Phone_1StringPhone_Number14
356PHONE21 SearchASI_Phone_2StringPhone_Number14
357FAX1 SearchASI_FaxStringSTR14_FAX14
358PRBTADCD1 SearchASI_Primary_Billto_Address_CodeStringSTR15_LBAU15
359PRSTADCD1 SearchASI_Primary_Shipto_Address_CodeStringSTR15_LBAU15
360CHEKBKID1 SearchASI_Checkbook_IDStringSTR15_Checkbook_ID15
361PYMTRMID1 SearchASI_Payment_Terms_IDStringSTR20_Payment_Terms_ID20
362CURNCYID1 SearchASI_Currency_IDStringSTR15_Currency_ID15
363RATETPID1 SearchASI_Rate_Type_IDStringSTR15_Rate_Type_ID15
364ASI_Minimum_Payment_Type SearchASI_Minimum_Payment_TypeIntegerASI_Minimum_Payment_Type0
365MINPYDLR1 SearchASI_Minimum_Payment_DollarCurrencyDLR17_RBS0_UTR$17
366MINPYPCT1 SearchASI_Minimum_Payment_PercentIntegerINT5_%25
367COMMENT11 SearchASI_Comment1StringSTR3030
368COMMENT21 SearchASI_Comment2StringSTR3030
369USERDEF11 SearchASI_User_Defined_1StringSTR2020
370USERDEF21 SearchASI_User_Defined_2StringSTR2020
371TXRGNNUM1 SearchASI_Tax_Registration_NumberStringSTR2525
372HOLD1 SearchASI_HoldBooleanCB_Hold0
373KPDSTHST1 SearchASI_Keep_Distribution_HistoryBooleanCB_Keep_Dist_History0
374KPCALHST1 SearchASI_Keep_Calendar_HistoryBooleanCB_Keep_Calendar_History0
375KPERHIST1 SearchASI_Keep_Period_HistoryBooleanCB_Keep_Period_History0
376KPTRXHST1 SearchASI_Keep_Trx_HistoryBooleanCB_Keep_Trx_History0
377NOTEINDX1 SearchASI_Note_IndexCurrencyDLR1414
378CREATDDT1 SearchASI_Created_DateDateDT8
379MODIFDT1 SearchASI_Modified_DateDateDT8
380FRSTINDT1 SearchASI_First_Invoice_DateDateDT_Date6
381AVDTPLYR1 SearchASI_Average_Days_to_Pay_LYRIntegerINT3_U03
382AVDTPLIF1 SearchASI_Average_Days_To_Pay_LifeIntegerINT3_U03
383AVGDTPYR1 SearchASI_Average_Days_To_Pay_YearIntegerINT3_U03
384WROFSLIF1 SearchASI_Write_Offs_LIFECurrencyDLR19_RBS0_STR$19
385WROFSLYR1 SearchASI_Write_Offs_LYRCurrencyDLR19_RBS0_STR$19
386WROFSYTD1 SearchASI_Write_Offs_YTDCurrencyDLR19_RBS0_STR$19
387ONORDAMT1 SearchASI_On_Order_AmountCurrencyDLR19_RBS0_UTR$19
388ASI_Post_Results_To SearchASI_Post_Results_ToIntegerASI_Post_Results_To0
389DISGRPER1 SearchASI_Discount_Grace_PeriodIntegerINT2_U02
390DOCFMTID1 SearchASI_Document_Format_IDStringSTR15_LBU15
391DUEGRPER1 SearchASI_Due_Date_Grace_PeriodIntegerINT2_U02
392PHONE31 SearchASI_Phone_3StringPhone_Number14
393VENDNAME1 SearchASI_Vendor_NameStringSTR64_Vendor_Name64
394VADCDPAD1 SearchASI_Vendor_Address_Code_Purchase_AddressStringSTR15_Address_Code15
395ADDRESS111 SearchASI_Address_12StringSTR6060
396ADDRESS211 SearchASI_Address_22StringSTR6060
397ADDRESS311 SearchASI_Address_32StringSTR6060
398COUNTRY11 SearchASI_Country2StringSTR6060
399CITY11 SearchASI_City2StringSTR3535
400STATE11 SearchASI_State2StringSTR30_State29
401ZIPCODE1 SearchASI_Zip_CodeStringSTR1010
402PHNUMBR11 SearchASI_Phone_Number_1StringPhone_Number14
403PHNUMBR21 SearchASI_Phone_Number_2StringPhone_Number14
404FAXNUMBR1 SearchASI_Fax_NumberStringSTR14_FAX14
405SHIPMTHD11 SearchASI_Shipping_Method2StringSTR15_Shipping_Method15
406CURNCYID11 SearchASI_Currency_ID2StringSTR15_Currency_ID15
407TXRGNNUM11 SearchASI_Tax_Registration_Number2StringSTR2525
408MINORDER1 SearchASI_Minimum_OrderCurrencyDLR17_$U217
409PYMTRMID11 SearchASI_Payment_Terms_ID2StringSTR20_Payment_Terms_ID20
410HOLD11 SearchASI_Hold2BooleanCB_Hold0
411NOTEINDX11 SearchASI_Note_Index2CurrencyDLR1414
412CREATDDT11 SearchASI_Created_Date2DateDT8
413MODIFDT11 SearchASI_Modified_Date2DateDT8
414RATETPID11 SearchASI_Rate_Type_ID2StringSTR15_Rate_Type_ID15
415ONORDAMT11 SearchASI_On_Order_Amount2CurrencyDLR19_RBS0_UTR$19
416DISGRPER11 SearchASI_Discount_Grace_Period2IntegerINT2_U02
417DUEGRPER11 SearchASI_Due_Date_Grace_Period2IntegerINT2_U02
418GOVCRPID1 SearchASI_Governmental_Corporate_IDStringSTR30_Gov_Corp_ID30
419GOVINDID1 SearchASI_Governmental_Individual_IDStringSTR30_Gov_Indiv_ID30
420PHONE311 SearchASI_Phone_32StringPhone_Number14
421TAXSCHID2 SearchASI_Tax_Schedule_ID_2StringSTR15_Tax_Schedule_ID15
422BSIVCTTL SearchBased On Invoice TotalBooleanYN0
423Purchase_Freight_Taxable SearchPurchase Freight TaxableIntegerDDL_Purchase_Tax_Options0
424Purchase_Misc_Taxable SearchPurchase Misc TaxableIntegerDDL_Purchase_Tax_Options0
425FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
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 IDStringSTR15_LBAU15
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 AmountCurrencyDLR19_RBSO_UTR$19
428ORFRTTAX SearchOriginating Freight Tax AmountCurrencyDLR19_RBSO_UTR$19
429MSCTXAMT SearchMisc Tax AmountCurrencyDLR19_RBSO_UTR$19
430ORMSCTAX SearchOriginating Misc Tax AmountCurrencyDLR19_RBSO_UTR$19
431BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
432OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
433BackoutFreightTaxAmt SearchBackout Freight Tax AmountCurrencyDLR17_RBS0_UTR$17
434OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountCurrencyDLR17_RBS0_UTR$17
435BackoutMiscTaxAmt SearchBackout Misc Tax AmountCurrencyDLR17_RBS0_UTR$17
436OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountCurrencyDLR17_RBS0_UTR$17
437BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountCurrencyDLR17_RBS0_UTR$17
438OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountCurrencyDLR17_RBS0_UTR$17
439POPCONTNUM SearchPOP Contract NumberStringSTR2020
440CONTENDDTE SearchContract End DateDateDATE_L0
441CNTRLBLKTBY SearchControl Blanket ByIntegerINT0
442PURCHCMPNYNAM SearchPurchase Company NameStringSTR64_Company_Name64
443PURCHCONTACT SearchPurchase ContactStringSTR6060
444PURCHADDRESS1 SearchPurchase Address 1StringSTR6060
445PURCHADDRESS2 SearchPurchase Address 2StringSTR6060
446PURCHADDRESS3 SearchPurchase Address 3StringSTR6060
447PURCHCITY SearchPurchase CityStringSTR3535
448PURCHSTATE SearchPurchase StateStringSTR30_State29
449PURCHZIPCODE SearchPurchase Zip CodeStringSTR1010
450PURCHCOUNTRY SearchPurchase CountryStringSTR6060
451PURCHPHONE1 SearchPurchase Phone 1StringPhone_Number14
452PURCHPHONE2 SearchPurchase Phone 2StringPhone_Number14
453PURCHPHONE3 SearchPurchase Phone 3StringPhone_Number314
454PURCHFAX SearchPurchase FaxStringSTR14_FAX14
455TXSCHSRC SearchTax Schedule SourceIntegerINT11
azurecurveProductsSmartList (1493)PathnameSmartList Purchase Order (ASIEXP07)

Leave a Reply

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