SmartList Purchasing Line Items (ASIEXP21)

azurecurveProductsSmartList (1493)PathnameSmartList Purchasing Line Items (ASIEXP21)

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

Product: SmartList (1493)
Series:

Display Name: SmartList Purchasing Line Items
Physical Name: ASIEXP21
Technical Name: ASI_POP_LINE_Items_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
2PONUMBER SearchPO NumberStringSTR17_POP_Number17
3ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
4ORD SearchOrdLong IntegerLI_Sequence_Number10
5POLNESTA SearchPO Line StatusIntegerDDL_PO_Line_Status0
6POTYPE SearchPO TypeIntegerDDL_POP_PO_Type0
7ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].ITEMNMBR AS 'SmartList Purchasing Line Items-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SmartList Purchasing Line Items'].ITEMNMBR = ['Item Master'].ITEMNMBR
8ITEMDESC SearchItem DescriptionStringSTR100100
9VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].VENDORID AS 'SmartList Purchasing Line Items-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SmartList Purchasing Line Items'].VENDORID = ['PM Vendor Master File'].VENDORID
10VNDITNUM SearchVendor Item NumberStringItem_Number30
11VNDITDSC SearchVendor Item DescriptionStringSTR100100
12NONINVEN SearchNon IVIntegerINT11
13UOFM SearchU Of MStringU_Of_M8
14UMQTYINB SearchU Of M QTY In BaseCurrencyDLR17_QTY_RBS0_STR17
15QTYORDER SearchQTY OrderedCurrencyDLR17_QTY_RBS0_UTR17
16QTYCANCE SearchQTY CanceledCurrencyDLR17_QTY_RBS0_UTR17
17QTYCMTBASE SearchQTY Committed In BaseCurrencyDLR17_QTY_RBS0_STR17
18QTYUNCMTBASE SearchQTY Uncommitted In BaseCurrencyDLR17_QTY_RBS0_STR17
19UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
20EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
21INVINDX SearchInventory IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].INVINDX AS 'SmartList Purchasing Line Items-Inventory Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].INVINDX = ['Account Index Master'].ACTINDX
22REQDATE SearchRequired DateDateDATE_L0
23PRMDATE SearchPromised DateDateDATE_L0
24PRMSHPDTE SearchPromised Ship DateDateDATE_L0
25REQSTDBY SearchRequested ByStringSTR20_LB20
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].REQSTDBY AS 'SmartList Purchasing Line Items-Requested By'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Purchasing Line Items'].REQSTDBY = ['Users Master'].USERID
26COMMNTID SearchComment IDStringSTR15_Comment_ID15
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].COMMNTID AS 'SmartList Purchasing Line Items-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['SmartList Purchasing Line Items'].COMMNTID = ['Comment Master'].COMMNTID
27DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
28POLNEARY_1 SearchPO Line Note ID Array[1]CurrencyDLR1414
29POLNEARY_2 SearchPO Line Note ID Array[2]CurrencyDLR1414
30POLNEARY_3 SearchPO Line Note ID Array[3]CurrencyDLR1414
31POLNEARY_4 SearchPO Line Note ID Array[4]CurrencyDLR1414
32POLNEARY_5 SearchPO Line Note ID Array[5]CurrencyDLR1414
33POLNEARY_6 SearchPO Line Note ID Array[6]CurrencyDLR1414
34POLNEARY_7 SearchPO Line Note ID Array[7]CurrencyDLR1414
35POLNEARY_8 SearchPO Line Note ID Array[8]CurrencyDLR1414
36POLNEARY_9 SearchPO Line Note ID Array[9]CurrencyDLR1414
37DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
38DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
39ITMTRKOP SearchItem Tracking OptionIntegerDDL_Track0
40BRKFLD1 SearchBreak Field 1IntegerINT11
41PO_Line_Status_Orig SearchPO Line Status OrigIntegerDDL_PO_Line_Status0
42QTY_Canceled_Orig SearchQTY Canceled OrigCurrencyDLR17_QTY_RBS0_UTR17
43OPOSTSUB SearchOriginating Posted SubtotalCurrencyDLR17_RBS0_STR$17
44JOBNUMBR SearchJob NumberStringSTR17_LBAU17
45COSTCODE SearchCost CodeStringSTR2727
46COSTTYPE SearchCost Code TypeIntegerINT3_RB0_U3
47CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].CURNCYID AS 'SmartList Purchasing Line Items-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Purchasing Line Items'].CURNCYID = ['Currency Setup'].CURNCYID
48CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].CURRNIDX AS 'SmartList Purchasing Line Items-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Purchasing Line Items'].CURRNIDX = ['Currency Setup'].CURRNIDX
49XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
50RATECALC SearchRate Calc MethodIntegerINT0
51DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
52ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
53OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
54LINEORIGIN SearchLine OriginIntegerDDL_Line_Origin0
55FREEONBOARD SearchFree On BoardIntegerDDL_Free_On_Board0
56ODECPLCU SearchOriginating Decimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
57Capital_Item SearchCapital ItemBooleanCB_Capital_Item0
58Product_Indicator SearchProduct IndicatorIntegerDDL_Product_Indicator0
59Source_Document_Number SearchSource Document NumberStringSTR11_Document_Number11
60Source_Document_Line_Num SearchSource Document Line NumberIntegerINT44
61ASI_Document_Status SearchASI_Document_StatusIntegerINT0
62STATGRP SearchStatus GroupIntegerINT11
63USER2ENT SearchUser To EnterStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].USER2ENT AS 'SmartList Purchasing Line Items-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Purchasing Line Items'].USER2ENT = ['Users Master'].USERID
64CONFIRM1 SearchConfirm WithStringSTR2020
65DOCDATE SearchDocument DateDateDT8
66LSTEDTDT SearchLast Edit DateDateDT_Date6
67LSTPRTDT SearchLast Printed DateDateDATE_L0
68REQTNDT SearchRequisition DateDateDATE_L0
69SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].SHIPMTHD AS 'SmartList Purchasing Line Items-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SmartList Purchasing Line Items'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
70TXRGNNUM SearchTax Registration NumberStringSTR2525
71REMSUBTO SearchRemaining SubtotalCurrencyDLR17_RBS0_UTR$17
72SUBTOTAL SearchSubtotalCurrencyDLR17_RBS0_STR$17
73TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
74FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
75MSCCHAMT SearchMisc Charges AmountCurrencyDLR17_RBS0_UTR$17
76TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
77VENDNAME SearchVendor NameStringSTR64_Vendor_Name64
78MINORDER SearchMinimum OrderCurrencyDLR17_$U217
79VADCDPAD SearchVendor Address Code - Purchase AddressStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].VADCDPAD AS 'SmartList Purchasing Line Items-Vendor Address Code - Purchase Address'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Purchasing Line Items'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID
80CMPANYID SearchCompany IDIntegerINT54
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].CMPANYID AS 'SmartList Purchasing Line Items-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['SmartList Purchasing Line Items'].CMPANYID = ['Company Master'].CMPANYID
81PRBTADCD SearchPrimary Billto Address CodeStringSTR15_LBAU15
82PRSTADCD SearchPrimary Shipto Address CodeStringSTR15_LBAU15
83CMPNYNAM SearchCompany NameStringSTR64_Company_Name64
84CONTACT SearchContactStringSTR6060
85ADDRESS1 SearchAddress 1StringSTR6060
86ADDRESS2 SearchAddress 2StringSTR6060
87ADDRESS3 SearchAddress 3StringSTR6060
88CITY SearchCityStringSTR3535
89STATE SearchStateStringSTR30_State29
90ZIPCODE SearchZip CodeStringSTR1010
91COUNTRY SearchCountryStringSTR6060
92PHONE1 SearchPhone 1StringPhone_Number14
93PHONE2 SearchPhone 2StringPhone_Number14
94FAX SearchFaxStringSTR14_FAX14
95PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PYMTRMID AS 'SmartList Purchasing Line Items-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['SmartList Purchasing Line Items'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
96DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
97DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
98DISAMTAV SearchDiscount Amount AvailableCurrencyDLR17_RBS0_UTR$17
99DISCDATE SearchDiscount DateDateDT8
100DUEDATE SearchDue DateDateDT8
101TRDPCTPR SearchTrade Discount Percent (Precise)Currency (Variable)Trade Discount Percent (Precise)23
102CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].CUSTNMBR AS 'SmartList Purchasing Line Items-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SmartList Purchasing Line Items'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
103TIMESPRT SearchTimes PrintedIntegerINT4_U04
104CREATDDT SearchCreated DateDateDT8
105MODIFDT SearchModified DateDateDT8
106PONOTIDS_1 SearchPO Note ID Array[1]CurrencyDLR1414
107PONOTIDS_2 SearchPO Note ID Array[2]CurrencyDLR1414
108PONOTIDS_3 SearchPO Note ID Array[3]CurrencyDLR1414
109PONOTIDS_4 SearchPO Note ID Array[4]CurrencyDLR1414
110PONOTIDS_5 SearchPO Note ID Array[5]CurrencyDLR1414
111PONOTIDS_6 SearchPO Note ID Array[6]CurrencyDLR1414
112PONOTIDS_7 SearchPO Note ID Array[7]CurrencyDLR1414
113PONOTIDS_8 SearchPO Note ID Array[8]CurrencyDLR1414
114PONOTIDS_9 SearchPO Note ID Array[9]CurrencyDLR1414
115PONOTIDS_10 SearchPO Note ID Array[10]CurrencyDLR1414
116PONOTIDS_11 SearchPO Note ID Array[11]CurrencyDLR1414
117PONOTIDS_12 SearchPO Note ID Array[12]CurrencyDLR1414
118PONOTIDS_13 SearchPO Note ID Array[13]CurrencyDLR1414
119PONOTIDS_14 SearchPO Note ID Array[14]CurrencyDLR1414
120PONOTIDS_15 SearchPO Note ID Array[15]CurrencyDLR1414
121COMMENT_1 SearchComment[1]StringSTR5050
122COMMENT_2 SearchComment[2]StringSTR5050
123COMMENT_3 SearchComment[3]StringSTR5050
124COMMENT_4 SearchComment[4]StringSTR5050
125CANCSUB SearchCanceled SubtotalCurrencyDLR17_RBS0_STR$17
126RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].RATETPID AS 'SmartList Purchasing Line Items-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['SmartList Purchasing Line Items'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
127EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].EXGTBLID AS 'SmartList Purchasing Line Items-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['SmartList Purchasing Line Items'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
128EXCHDATE SearchExchange DateDateDT_Date6
129TIME1 SearchTimeTimeTM66
130MCTRXSTT SearchMC Transaction StateIntegerINT11
131OREMSUBT SearchOriginating Remaining SubtotalCurrencyDLR17_RBS0_UTR$17
132ORSUBTOT SearchOriginating SubtotalCurrencyDLR17_RBS0_STR$17
133Originating_Canceled_Sub SearchOriginating Canceled SubtotalCurrencyDLR17_RBS0_STR$17
134ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
135ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
136OMISCAMT SearchOriginating Misc Charges AmountCurrencyDLR17_RBS0_UTR$17
137ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
138ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
139ODISAMTAV SearchOriginating Discount Amount AvailableCurrencyDLR17_RBS0_UTR$17
140BUYERID SearchBuyer IDStringSTR15_User_ID15
141ONORDAMT SearchOn Order AmountCurrencyDLR19_RBS0_UTR$19
142ORORDAMT SearchOriginating On Order AmountCurrencyDLR19_RBS0_UTR$19
143HOLD SearchHoldBooleanCB_Hold0
144ONHOLDDATE SearchOn Hold DateDateDT8
145ONHOLDBY SearchOn Hold ByStringSTR15_User_ID15
146HOLDREMOVEDATE SearchHold Remove DateDateDT8
147HOLDREMOVEBY SearchHold Remove ByStringSTR15_User_ID15
148ALLOWSOCMTS SearchAllow SO CommitmentsBooleanCB_AllowSOCommitments0
149NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].NOTEINDX AS 'SmartList Purchasing Line Items-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList Purchasing Line Items'].NOTEINDX = ['Record Notes Master'].NOTEINDX
150ITMSHNAM SearchItem Short NameStringSTR1515
151ITEMTYPE SearchItem TypeIntegerDDL_Item_Type0
152ITMGEDSC SearchItem Generic DescriptionStringSTR1010
153STNDCOST SearchStandard CostCurrencyDLR17_RBS0_UTR$17
154CURRCOST SearchCurrent CostCurrencyDLR17_RBS0_UTR$17
155LISTPRCE SearchList PriceCurrencyDLR17_RBS0_STR$17
156ITEMSHWT SearchItem Shipping WeightLong IntegerLI6_RBS2_UT6
157ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].ITMTSHID AS 'SmartList Purchasing Line Items-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Purchasing Line Items'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
158TAXOPTNS SearchTax OptionsIntegerDDL_Tax_Options0
159COMMCODE SearchCommission CodeStringSTR15_LBAU15
160IVIVINDX SearchIV IV IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVIVINDX AS 'SmartList Purchasing Line Items-IV IV Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVIVINDX = ['Account Index Master'].ACTINDX
161IVIVOFIX SearchIV IV Offset IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVIVOFIX AS 'SmartList Purchasing Line Items-IV IV Offset Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVIVOFIX = ['Account Index Master'].ACTINDX
162IVCOGSIX SearchIV COGS IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVCOGSIX AS 'SmartList Purchasing Line Items-IV COGS Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVCOGSIX = ['Account Index Master'].ACTINDX
163IVSLSIDX SearchIV Sales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVSLSIDX AS 'SmartList Purchasing Line Items-IV Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVSLSIDX = ['Account Index Master'].ACTINDX
164IVSLDSIX SearchIV Sales Discounts IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVSLDSIX AS 'SmartList Purchasing Line Items-IV Sales Discounts Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVSLDSIX = ['Account Index Master'].ACTINDX
165IVSLRNIX SearchIV Sales Returns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVSLRNIX AS 'SmartList Purchasing Line Items-IV Sales Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVSLRNIX = ['Account Index Master'].ACTINDX
166IVINUSIX SearchIV In Use IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVINUSIX AS 'SmartList Purchasing Line Items-IV In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVINUSIX = ['Account Index Master'].ACTINDX
167IVINSVIX SearchIV In Service IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVINSVIX AS 'SmartList Purchasing Line Items-IV In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVINSVIX = ['Account Index Master'].ACTINDX
168IVDMGIDX SearchIV Damaged IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVDMGIDX AS 'SmartList Purchasing Line Items-IV Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVDMGIDX = ['Account Index Master'].ACTINDX
169IVVARIDX SearchIV Variances IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVVARIDX AS 'SmartList Purchasing Line Items-IV Variances Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVVARIDX = ['Account Index Master'].ACTINDX
170DPSHPIDX SearchDrop Ship IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].DPSHPIDX AS 'SmartList Purchasing Line Items-Drop Ship Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].DPSHPIDX = ['Account Index Master'].ACTINDX
171PURPVIDX SearchPurchase Price Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PURPVIDX AS 'SmartList Purchasing Line Items-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PURPVIDX = ['Account Index Master'].ACTINDX
172IVRETIDX SearchInventory Returns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVRETIDX AS 'SmartList Purchasing Line Items-Inventory Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVRETIDX = ['Account Index Master'].ACTINDX
173ASMVRIDX SearchAssembly Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].ASMVRIDX AS 'SmartList Purchasing Line Items-Assembly Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].ASMVRIDX = ['Account Index Master'].ACTINDX
174ITMCLSCD SearchItem Class CodeStringSTR10_Class_ID10
Key to the Item Class Setup (IV40400).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].ITMCLSCD AS 'SmartList Purchasing Line Items-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['SmartList Purchasing Line Items'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
175LOTTYPE SearchLot TypeStringSTR10_Lot_Type10
176KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
177KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
178KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
179KPDSTHST SearchKeep Distribution HistoryBooleanCB_Keep_Dist_History0
180ALWBKORD SearchAllow Back OrdersBooleanCB_Allow_Back_Orders0
181VCTNMTHD SearchValuation MethodIntegerDDL_Valuation_Method0
182UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].UOMSCHDL AS 'SmartList Purchasing Line Items-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['SmartList Purchasing Line Items'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
183ALTITEM1 SearchAlternate Item 1StringSTR30_Item_Number30
184ALTITEM2 SearchAlternate Item 2StringSTR30_Item_Number30
185USCATVLS_1 SearchUser Category Values[1]StringUser_Category_Value10
186USCATVLS_2 SearchUser Category Values[2]StringUser_Category_Value10
187USCATVLS_3 SearchUser Category Values[3]StringUser_Category_Value10
188USCATVLS_4 SearchUser Category Values[4]StringUser_Category_Value10
189USCATVLS_5 SearchUser Category Values[5]StringUser_Category_Value10
190USCATVLS_6 SearchUser Category Values[6]StringUser_Category_Value10
191MSTRCDTY SearchMaster Record TypeIntegerINT11
192WRNTYDYS SearchWarranty DaysIntegerINT44
193PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
194VNDCHKNM SearchVendor Check NameStringSTR64_Vendor_Name64
195VENDSHNM SearchVendor Short NameStringSTR1515
196VADDCDPR SearchVendor Address Code - PrimaryStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].VADDCDPR AS 'SmartList Purchasing Line Items-Vendor Address Code - Primary'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Purchasing Line Items'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID
197VADCDSFR SearchVendor Address Code - Ship FromStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].VADCDSFR AS 'SmartList Purchasing Line Items-Vendor Address Code - Ship From'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Purchasing Line Items'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID
198VADCDTRO SearchVendor Address Code - Remit ToStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].VADCDTRO AS 'SmartList Purchasing Line Items-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Purchasing Line Items'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID
199VNDCLSID SearchVendor Class IDStringSTR10_Class_ID10
Key to the PM Class Master File (PM00100).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].VNDCLSID AS 'SmartList Purchasing Line Items-Vendor Class ID'
       ,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       PM00100 AS ['PM Class Master File']
              ON
                     ['SmartList Purchasing Line Items'].VNDCLSID = ['PM Class Master File'].VNDCLSID
200VNDCNTCT SearchVendor ContactStringSTR6060
201UPSZONE SearchUPS ZoneStringSTR33
202TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].TAXSCHID AS 'SmartList Purchasing Line Items-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Purchasing Line Items'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
203ACNMVNDR SearchAccount Number With VendorStringSTR2020
204TXIDNMBR SearchTax ID NumberStringTax_ID_Number11
205VENDSTTS SearchVendor StatusIntegerDDL_Vendor_Status0
206PARVENID SearchParent Vendor IDStringSTR_15_Vendor_ID15
207TRDDISCT SearchTrade DiscountIntegerINT4_%24
208TEN99TYPE Search1099 TypeInteger1099_Type0
209MINPYTYP SearchMinimum Payment TypeIntegerGB_Amt_Type0
210MINPYPCT SearchMinimum Payment PercentIntegerINT5_%25
211MINPYDLR SearchMinimum Payment DollarCurrencyDLR17_RBS0_UTR$17
212MXIAFVND SearchMaximum Invoice Amount For VendorsIntegerGB0
213MAXINDLR SearchMaximum Invoice DollarCurrencyDLR17_$U217
214COMMENT1 SearchComment1StringSTR3030
215COMMENT2 SearchComment2StringSTR3030
216USERDEF1 SearchUser Defined 1StringSTR2020
217USERDEF2 SearchUser Defined 2StringSTR2020
218CRLMTDLR SearchCredit Limit DollarCurrencyDLR17_$U217
219PYMNTPRI SearchPayment PriorityStringSTR33
220KGLDSTHS SearchKeep GL Dist HistoryBooleanCB_Keep_GL_Dist_History0
221PTCSHACF SearchPost To Cash Account FromIntegerGB0
222CREDTLMT SearchCredit LimitIntegerGB0
223WRITEOFF SearchWriteoffIntegerGB0
224MXWOFAMT SearchMaximum Write Off AmountCurrencyDLR17_$U217
225SBPPSDED SearchSubject To PPS DeductionsBooleanCB_Subject_To_PPS_Deductions0
226PPSTAXRT SearchPPS Tax RateIntegerINT5_%25
227DXVARNUM SearchDeduction Exemption/Variation NumberStringSTR2525
228CRTCOMDT SearchCertificate Commencing DateDateDT8
229CRTEXPDT SearchCertificate Expiration DateDateDT8
230RTOBUTKN SearchReporting Obligation UndertakenBooleanCB_Reporting_Obligation0
231XPDTOBLG SearchExpiration Date ObligationBooleanCB_Expiration_Date_Obligation0
232PRSPAYEE SearchPrescribed PayeeBooleanCB_Prescribed_Payee0
233PMAPINDX SearchPM AP IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMAPINDX AS 'SmartList Purchasing Line Items-PM AP Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMAPINDX = ['Account Index Master'].ACTINDX
234PMCSHIDX SearchPM Cash IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMCSHIDX AS 'SmartList Purchasing Line Items-PM Cash Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMCSHIDX = ['Account Index Master'].ACTINDX
235PMDAVIDX SearchPM Discount Available IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMDAVIDX AS 'SmartList Purchasing Line Items-PM Discount Available Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMDAVIDX = ['Account Index Master'].ACTINDX
236PMDTKIDX SearchPM Discount Taken IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMDTKIDX AS 'SmartList Purchasing Line Items-PM Discount Taken Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMDTKIDX = ['Account Index Master'].ACTINDX
237PMFINIDX SearchPM Finance Charge IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMFINIDX AS 'SmartList Purchasing Line Items-PM Finance Charge Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMFINIDX = ['Account Index Master'].ACTINDX
238PMMSCHIX SearchPM Misc Charges IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMMSCHIX AS 'SmartList Purchasing Line Items-PM Misc Charges Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMMSCHIX = ['Account Index Master'].ACTINDX
239PMFRTIDX SearchPM Freight IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMFRTIDX AS 'SmartList Purchasing Line Items-PM Freight Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMFRTIDX = ['Account Index Master'].ACTINDX
240PMTAXIDX SearchPM Tax IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMTAXIDX AS 'SmartList Purchasing Line Items-PM Tax Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMTAXIDX = ['Account Index Master'].ACTINDX
241PMWRTIDX SearchPM Write Offs IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMWRTIDX AS 'SmartList Purchasing Line Items-PM Write Offs Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMWRTIDX = ['Account Index Master'].ACTINDX
242PMPRCHIX SearchPM Purchases IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMPRCHIX AS 'SmartList Purchasing Line Items-PM Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMPRCHIX = ['Account Index Master'].ACTINDX
243PMRTNGIX SearchPM Retainage IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMRTNGIX AS 'SmartList Purchasing Line Items-PM Retainage Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMRTNGIX = ['Account Index Master'].ACTINDX
244PMTDSCIX SearchPM Trade Discount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PMTDSCIX AS 'SmartList Purchasing Line Items-PM Trade Discount Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PMTDSCIX = ['Account Index Master'].ACTINDX
245ACPURIDX SearchAccrued Purchases IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].ACPURIDX AS 'SmartList Purchasing Line Items-Accrued Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].ACPURIDX = ['Account Index Master'].ACTINDX
246CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].CHEKBKID AS 'SmartList Purchasing Line Items-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['SmartList Purchasing Line Items'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
247Revalue_Vendor SearchRevalue VendorBooleanCB Revalue Vendor0
248Post_Results_To SearchPost Results ToIntegerGB0
249POSTATUS SearchPO StatusIntegerDDL_PO_Status0
250HIESTBAL SearchHighest BalanceCurrencyDLR17_RBS0_UTR$17
251CURRBLNC SearchCurrent BalanceCurrencyDLR19_RBS0_STR$19
252NOINVYTD SearchNumber of Invoices YTDLong IntegerLI_9U09
253NOINVLIF SearchNumber of Invoices LIFELong IntegerLI_9U09
254NOINVLYR SearchNumber of Invoices LYRLong IntegerLI_9U09
255NOPINYTD SearchNumber of Paid Invoices YTDLong IntegerLI_9U09
256NOPILIFE SearchNumber of Paid Invoices LIFELong IntegerLI_9U09
257AMBLDTYD SearchAmount Billed YTDCurrencyDLR19_RBS0_STR$19
258AMBLDLIF SearchAmount Billed LIFECurrencyDLR19_RBS0_STR$19
259AMBLDLYR SearchAmount Billed LYRCurrencyDLR19_RBS0_STR$19
260AMTPDYTD SearchAmount Paid YTDCurrencyDLR19_RBS0_STR$19
261AMTPDLIF SearchAmount Paid LIFECurrencyDLR19_RBS0_STR$19
262AMTPDLYR SearchAmount Paid LYRCurrencyDLR19_RBS0_STR$19
263TEN99AYTD Search1099 Amount YTDCurrencyDLR19_RBS0_STR$19
264TEN99ALIF Search1099 Amount LIFECurrencyDLR19_RBS0_STR$19
265TEN99ALYR Search1099 Amount LYRCurrencyDLR19_RBS0_STR$19
266DISAVYTD SearchDiscount Available YTDCurrencyDLR19_RBS0_STR$19
267DISAVLIF SearchDiscount Available LIFECurrencyDLR19_RBS0_STR$19
268DISAVLYR SearchDiscount Available LYRCurrencyDLR19_RBS0_STR$19
269DISTKYTD SearchDiscount Taken YTDCurrencyDLR19_RBS0_STR$19
270DISTKNLF SearchDiscount Taken LIFECurrencyDLR19_RBS0_STR$19
271DISTKLYR SearchDiscount Taken LYRCurrencyDLR19_RBS0_STR$19
272DISLSYTD SearchDiscount Lost YTDCurrencyDLR19_RBS0_STR$19
273DISLSTLF SearchDiscount Lost LIFECurrencyDLR19_RBS0_STR$19
274DISLSLYR SearchDiscount Lost LYRCurrencyDLR19_RBS0_STR$19
275FINCHLIF SearchFinance Charge LIFECurrencyDLR19_RBS0_STR$19
276FINCHLYR SearchFinance Charge LYRCurrencyDLR19_RBS0_STR$19
277FINCHYTD SearchFinance Charge YTDCurrencyDLR19_RBS0_STR$19
278WROFSYTD SearchWrite Offs YTDCurrencyDLR19_RBS0_STR$19
279WROFSLIF SearchWrite Offs LIFECurrencyDLR19_RBS0_STR$19
280WROFSLYR SearchWrite Offs LYRCurrencyDLR19_RBS0_STR$19
281RTRNSYTD SearchReturns YTDCurrencyDLR19_RBS0_STR$19
282RTRNSLIF SearchReturns LIFECurrencyDLR19_RBS0_STR$19
283RTRNSLYR SearchReturns LYRCurrencyDLR19_RBS0_STR$19
284TRDTKLIF SearchTrade Discounts Taken LIFECurrencyDLR19_RBSO_STR$19
285TRDTLYR SearchTrade Discounts Taken LYRCurrencyDLR19_RBSO_STR$19
286TRDTYTD SearchTrade Discounts Taken YTDCurrencyDLR19_RBSO_STR$19
287NFNCHLIF SearchNumber of Finance Charges LIFELong IntegerLI_9U09
288NFNCHLYR SearchNumber of Finance Charges LYRLong IntegerLI_9U09
289NFNCHYTD SearchNumber of Finance Charges YTDLong IntegerLI_9U09
290RTNGOWED SearchRetainage OwedCurrencyDLR17_RBS0_STR$17
291LSTCHNUM SearchLast Check NumberStringCheck_Number20
292LSTCHKDT SearchLast Check DateDateDT8
293LSTCHAMT SearchLast Check AmountCurrencyDLR17_RBS0_UTR$17
294LSTINNUM SearchLast Invoice NumberStringSTR2020
295LSTINVAM SearchLast Invoice AmountCurrencyDLR17_RBS0_UTR$17
296LSTPURDT SearchLast Purchase DateDateDT8
297FSTPURDT SearchFirst Purchase DateDateDT8
298CURUNPBN SearchCurrent Unapplied Payment BalanceCurrencyDLR17_RBS0_UTR$17
299UNPDFNCH SearchUnpaid Finance ChargesCurrencyDLR17_RBS0_UTR$17
300DYCHTCLR SearchDays Checks To ClearIntegerINT3_U03
301AVGDTPYR SearchAverage Days To Pay - YearIntegerINT3_U03
302AVDTPLIF SearchAverage Days To Pay - LifeIntegerINT3_U03
303CUSTNAME SearchCustomer NameStringSTR64_Customer_Name64
304CUSTCLAS SearchCustomer ClassStringSTR15_Customer_Class15
305CPRCSTNM SearchCorporate Customer NumberStringSTR15_RM_Customer_Number15
306CNTCPRSN SearchContact PersonStringSTR6060
307STMTNAME SearchStatement NameStringSTR6464
308SHRTNAME SearchShort NameStringSTR1515
309ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
310STADDRCD SearchStatement Address CodeStringSTR15_LBAU15
311SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].SLPRSNID AS 'SmartList Purchasing Line Items-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SmartList Purchasing Line Items'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
312CRLMTTYP SearchCredit Limit TypeIntegerGB_Amt_Type0
313CRLMTAMT SearchCredit Limit AmountCurrencyDLR17_RBS0_UTR$17
314CRLMTPER SearchCredit Limit PeriodIntegerDDL0
315CRLMTPAM SearchCredit Limit Period AmountCurrencyDLR17_RBS0_UTR$17
316CUSTDISC SearchCustomer DiscountIntegerINT5_%25
317FNCHATYP SearchFinance Charge Amt TypeIntegerGB_Amt_Type0
318FNCHPCNT SearchFinance Charge PercentIntegerINT5_%25
319FINCHDLR SearchFinance Charge DollarCurrencyDLR17_RBS0_UTR$17
320MXWOFTYP SearchMaximum Writeoff TypeIntegerGP_Max_Writeoff0
321MXWROFAM SearchMax Writeoff AmountCurrencyDLR17_RBS0_UTR$17
322TAXEXMT1 SearchTax Exempt 1StringSTR2525
323TAXEXMT2 SearchTax Exempt 2StringSTR2525
324BALNCTYP SearchBalance TypeIntegerGB_Bal_Type0
325STMTCYCL SearchStatement CycleIntegerDDL_Stmt_Cycle0
326BANKNAME SearchBank NameStringSTR3030
327BNKBRNCH SearchBank BranchStringSTR2020
328SALSTERR SearchSales TerritoryStringSTR15_Sales_Territory15
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].SALSTERR AS 'SmartList Purchasing Line Items-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['SmartList Purchasing Line Items'].SALSTERR = ['Sales Territory Master File'].SALSTERR
329DEFCACTY SearchDefault Cash Account TypeIntegerGB0
330RMCSHACC SearchRM Cash Account IndexLong IntegerLI_1414
331RMARACC SearchRM AR Account IndexLong IntegerLI_1414
332RMSLSACC SearchRM Sales Account IndexLong IntegerLI_1414
333RMIVACC SearchRM IV Account IndexLong IntegerLI_1414
334RMCOSACC SearchRM Cost Of Sales Account IndexLong IntegerLI_1414
335RMTAKACC SearchRM Discounts Taken Account IndexLong IntegerLI_1414
336RMAVACC SearchRM Discounts Avail Account IndexLong IntegerLI_1414
337RMFCGACC SearchRM Finance Charge Account IndexLong IntegerLI_1414
338RMWRACC SearchRM Writeoff Account IndexLong IntegerLI_1414
339FRSTINDT SearchFirst Invoice DateDateDT_Date6
340INACTIVE SearchInactiveBooleanCB_Inactive0
341CRCARDID SearchCredit Card IDStringSTR1515
342CRCRDNUM SearchCredit Card NumberStringSTR2020
343CCRDXPDT SearchCredit Card Exp DateDateDT_Date6
344Revalue_Customer SearchRevalue CustomerBooleanCB Revalue Customer0
345FINCHID SearchFinance Charge IDStringSTR15_Charge_ID15
346GOVCRPID SearchGovernmental Corporate IDStringSTR30_Gov_Corp_ID30
347GOVINDID SearchGovernmental Individual IDStringSTR30_Gov_Indiv_ID30
348TNSFCLIF SearchTotal Amount Of NSF Checks LifeCurrencyDLR19_RBS0_STR$19
349NONSFLIF SearchNumber Of NSF Checks LifeLong IntegerLI6_U06
350CUSTBLNC SearchCustomer BalanceCurrencyDLR19_RBS0_STR$19
351AGPERAMT_1 SearchAging Period Amounts[1]CurrencyDLR17_RBSO_STR$17
352AGPERAMT_2 SearchAging Period Amounts[2]CurrencyDLR17_RBSO_STR$17
353AGPERAMT_3 SearchAging Period Amounts[3]CurrencyDLR17_RBSO_STR$17
354AGPERAMT_4 SearchAging Period Amounts[4]CurrencyDLR17_RBSO_STR$17
355AGPERAMT_5 SearchAging Period Amounts[5]CurrencyDLR17_RBSO_STR$17
356AGPERAMT_6 SearchAging Period Amounts[6]CurrencyDLR17_RBSO_STR$17
357AGPERAMT_7 SearchAging Period Amounts[7]CurrencyDLR17_RBSO_STR$17
358LASTAGED SearchLast AgedDateDATE6
359LSTNSFCD SearchLast NSF Check DateDateDT_Date6
360LPYMTAMT SearchLast Payment AmountCurrencyDLR17_RBS0_STR$17
361LASTPYDT SearchLast Payment DateDateDT_Date6
362LSTTRXDT SearchLast Transaction DateDateDT_Date6
363LSTTRXAM SearchLast Transaction AmountCurrencyDLR17_RBS0_STR$17
364LSTFCHAM SearchLast Finance Charge AmountCurrencyDLR19_RBS0_STR$19
365UPFCHYTD SearchUnpaid Finance Charges YTDCurrencyDLR17_RBS0_UTR$17
366NUMADTPL SearchNumber ADTP Documents - LifeLong IntegerLong_10U10
367NUMADTPR SearchNumber ADTP Documents - LYRLong IntegerLong_10U10
368NUMADTPY SearchNumber ADTP Documents - YearLong IntegerLong_10U10
369TDTKNLTD SearchTotal Discounts Taken LTDCurrencyDLR19_RBS0_STR$19
370TDTKNLYR SearchTotal Discounts Taken LYRCurrencyDLR19_RBS0_STR$19
371TDTKNYTD SearchTotal Discounts Taken YTDCurrencyDLR19_RBS0_STR$19
372TDISAYTD SearchTotal Discounts Available YTDCurrencyDLR19_RBS0_STR$19
373RETAINAG SearchRetainageCurrencyDLR19_RBS0_STR$19
374TNSFCYTD SearchTotal Amount Of NSF Checks YTDCurrencyDLR19_RBS0_STR$19
375NONSFYTD SearchNumber Of NSF Checks YTDLong IntegerLI6_U06
376UNPSTDSA SearchUnposted Sales AmountCurrencyDLR19_RBS0_UTR$19
377UNPSTDCA SearchUnposted Cash AmountCurrencyDLR19_RBS0_UTR$19
378UNPSTOSA SearchUnposted Other Sales AmountCurrencyDLR19_RBS0_UTR$19
379UNPSTOCA SearchUnposted Other Cash AmountCurrencyDLR19_RBS0_UTR$19
380NCSCHPMT SearchNon Current Scheduled PaymentsCurrencyDLR19_RBS0_STR$19
381TTLSLLTD SearchTotal Sales LTDCurrencyDLR19_RBS0_STR$19
382TTLSLLYR SearchTotal Sales LYRCurrencyDLR19_RBS0_STR$19
383TTLSLYTD SearchTotal Sales YTDCurrencyDLR19_RBS0_STR$19
384TCOSTLTD SearchTotal Costs LTDCurrencyDLR19_RBS0_STR$19
385TCOSTLYR SearchTotal Costs LYRCurrencyDLR19_RBS0_STR$19
386TCOSTYTD SearchTotal Costs YTDCurrencyDLR19_RBS0_STR$19
387TCSHRLTD SearchTotal Cash Received LTDCurrencyDLR19_RBS0_STR$19
388TCSHRLYR SearchTotal Cash Received LYRCurrencyDLR19_RBS0_STR$19
389TCSHRYTD SearchTotal Cash Received YTDCurrencyDLR19_RBS0_STR$19
390TFNCHLTD SearchTotal Finance Charges LTDCurrencyDLR19_RBS0_STR$19
391TFNCHLYR SearchTotal Finance Charges LYRCurrencyDLR19_RBS0_STR$19
392TFNCHYTD SearchTotal Finance Charges YTDCurrencyDLR19_RBS0_STR$19
393FNCHCYTD SearchFinance Charges CYTDCurrencyDLR19_RBS0_STR$19
394FNCHLYRC SearchFinance Charges LYR CalendarCurrencyDLR19_RBS0_STR$19
395TBDDTLYR SearchTotal Bad Deb LYRCurrencyDLR19_RBS0_STR$19
396TBDDTLTD SearchTotal Bad Debt LTDCurrencyDLR19_RBS0_STR$19
397TBDDTYTD SearchTotal Bad Debt YTDCurrencyDLR19_RBS0_STR$19
398TWVFCLTD SearchTotal Waived FC LTDCurrencyDLR19_RBS0_STR$19
399TWVFCLYR SearchTotal Waived FC LYRCurrencyDLR19_RBS0_STR$19
400TWVFCYTD SearchTotal Waived FC YTDCurrencyDLR19_RBS0_STR$19
401TWROFLTD SearchTotal Writeoffs LTDCurrencyDLR19_RBS0_STR$19
402TWROFLYR SearchTotal Writeoffs LYRCurrencyDLR19_RBS0_STR$19
403TWROFYTD SearchTotal Writeoffs YTDCurrencyDLR19_RBS0_STR$19
404TTLINLTD SearchTotal # Invoices LTDLong IntegerLI6_U06
405TTLINLYR SearchTotal # Invoices LYRLong IntegerLI6_U06
406TTLINYTD SearchTotal # Invoices YTDLong IntegerLI6_U06
407TTLFCLTD SearchTotal # FC LTDLong IntegerLI6_U06
408TTLFCLYR SearchTotal # FC LYRLong IntegerLI6_U06
409TTLFCYTD SearchTotal # FC YTDLong IntegerLI6_U06
410HIBALLTD SearchHigh Balance LTDCurrencyDLR19_RBSO_STR$19
411HIBALLYR SearchHigh Balance LYRCurrencyDLR19_RBSO_STR$19
412HIBALYTD SearchHigh Balance YTDCurrencyDLR19_RBSO_STR$19
413LASTSTDT SearchLast Statement DateDateDATE6
414LSTSTAMT SearchLast Statement AmountCurrencyDLR17_RBS0_STR$17
415DEPRECV SearchDeposits ReceivedCurrencyDLR19_RBS0_STR$19
416ABCCODE SearchABC CodeIntegerDDL_ABC_Code0
417CGSINFLX SearchCOGS Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].CGSINFLX AS 'SmartList Purchasing Line Items-COGS Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].CGSINFLX = ['Account Index Master'].ACTINDX
418CGSMCIDX SearchCOGS Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].CGSMCIDX AS 'SmartList Purchasing Line Items-COGS Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].CGSMCIDX = ['Account Index Master'].ACTINDX
419IVINFIDX SearchInventory Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].IVINFIDX AS 'SmartList Purchasing Line Items-Inventory Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].IVINFIDX = ['Account Index Master'].ACTINDX
420INVMCIDX SearchInventory Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].INVMCIDX AS 'SmartList Purchasing Line Items-Inventory Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].INVMCIDX = ['Account Index Master'].ACTINDX
421ITEMCODE SearchItem CodeStringSTR1515
422KTACCTSR SearchKit COGS Account SourceIntegerGB0
423LASTGENSN SearchLast Generated Serial NumberStringSTR20_LBAU20
424PriceGroup SearchPrice GroupStringSTR10_LBAU10
425PRICMTHD SearchPrice MethodIntegerDDL_Price_Method0
426PINFLIDX SearchPurch Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PINFLIDX AS 'SmartList Purchasing Line Items-Purch Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PINFLIDX = ['Account Index Master'].ACTINDX
427PURMCIDX SearchPurch Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].PURMCIDX AS 'SmartList Purchasing Line Items-Purch Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].PURMCIDX = ['Account Index Master'].ACTINDX
428PRCHSUOM SearchPurchasing U Of MStringU_Of_M8
429SELNGUOM SearchSelling U Of MStringU_Of_M8
430TCC SearchTax Commodity CodeStringSTR30_VAT30
431UPPVIDX SearchUnrealized Purchase Price Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].UPPVIDX AS 'SmartList Purchasing Line Items-Unrealized Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Purchasing Line Items'].UPPVIDX = ['Account Index Master'].ACTINDX
432DISGRPER SearchDiscount Grace PeriodIntegerINT2_U02
433DOCFMTID SearchDocument Format IDStringSTR15_LBU15
434DUEGRPER SearchDue Date Grace PeriodIntegerINT2_U02
435PHONE3 SearchPhone 3StringPhone_Number314
436TaxInvRecvd SearchTax Invoice ReceivedBooleanCB_Tax_Invoice_Received0
437Withholding_LIFE SearchWithholding LIFECurrencyDLR19_RBS0_STR$19
438WITHLYR SearchWithholding LYRCurrencyDLR19_RBS0_STR$19
439WITHYTD SearchWithholding YTDCurrencyDLR19_RBS0_STR$19
440Change_Order_Flag SearchChange Order FlagIntegerINT0
441PO_Field_Changes SearchPO Field ChangesLong IntegerML_POP_PO_Field_Changes0
442PO_Status_Orig SearchPO Status OrigIntegerDDL_PO_Status0
443Revision_Number SearchRevision NumberIntegerINT44
444LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].LOCNCODE AS 'SmartList Purchasing Line Items-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SmartList Purchasing Line Items'].LOCNCODE = ['Site Setup'].LOCNCODE
445RELEASEBYDATE SearchRelease By DateDateDATE_L0
446Released_Date SearchReleased DateDateDATE_L0
447UPSZONE1 SearchASI_UPS_ZoneStringSTR33
448SHIPMTHD1 SearchASI_Shipping_MethodStringSTR15_Shipping_Method15
449TAXSCHID1 SearchASI_Tax_Schedule_IDStringSTR15_Tax_Schedule_ID15
450ADDRESS11 SearchASI_Address_1StringSTR6060
451ADDRESS21 SearchASI_Address_2StringSTR6060
452ADDRESS31 SearchASI_Address_3StringSTR6060
453CITY1 SearchASI_CityStringSTR3535
454STATE1 SearchASI_StateStringSTR30_State29
455COUNTRY1 SearchASI_CountryStringSTR6060
456ZIP1 SearchASI_ZipStringSTR1010
457PHONE11 SearchASI_Phone_1StringPhone_Number14
458PHONE21 SearchASI_Phone_2StringPhone_Number14
459FAX1 SearchASI_FaxStringSTR14_FAX14
460PRBTADCD1 SearchASI_Primary_Billto_Address_CodeStringSTR15_LBAU15
461PRSTADCD1 SearchASI_Primary_Shipto_Address_CodeStringSTR15_LBAU15
462CHEKBKID1 SearchASI_Checkbook_IDStringSTR15_Checkbook_ID15
463PYMTRMID1 SearchASI_Payment_Terms_IDStringSTR20_Payment_Terms_ID20
464CURNCYID1 SearchASI_Currency_IDStringSTR15_Currency_ID15
465RATETPID1 SearchASI_Rate_Type_IDStringSTR15_Rate_Type_ID15
466ASI_Minimum_Payment_Type SearchASI_Minimum_Payment_TypeIntegerASI_Minimum_Payment_Type0
467MINPYDLR1 SearchASI_Minimum_Payment_DollarCurrencyDLR17_RBS0_UTR$17
468MINPYPCT1 SearchASI_Minimum_Payment_PercentIntegerINT5_%25
469COMMENT11 SearchASI_Comment1StringSTR3030
470COMMENT21 SearchASI_Comment2StringSTR3030
471USERDEF11 SearchASI_User_Defined_1StringSTR2020
472USERDEF21 SearchASI_User_Defined_2StringSTR2020
473TXRGNNUM1 SearchASI_Tax_Registration_NumberStringSTR2525
474HOLD1 SearchASI_HoldBooleanCB_Hold0
475KPDSTHST1 SearchASI_Keep_Distribution_HistoryBooleanCB_Keep_Dist_History0
476KPCALHST1 SearchASI_Keep_Calendar_HistoryBooleanCB_Keep_Calendar_History0
477KPERHIST1 SearchASI_Keep_Period_HistoryBooleanCB_Keep_Period_History0
478KPTRXHST1 SearchASI_Keep_Trx_HistoryBooleanCB_Keep_Trx_History0
479NOTEINDX1 SearchASI_Note_IndexCurrencyDLR1414
480CREATDDT1 SearchASI_Created_DateDateDT8
481MODIFDT1 SearchASI_Modified_DateDateDT8
482FRSTINDT1 SearchASI_First_Invoice_DateDateDT_Date6
483AVDTPLIF1 SearchASI_Average_Days_To_Pay_LifeIntegerINT3_U03
484AVDTPLYR1 SearchASI_Average_Days_to_Pay_LYRIntegerINT3_U03
485AVGDTPYR1 SearchASI_Average_Days_To_Pay_YearIntegerINT3_U03
486WROFSLIF1 SearchASI_Write_Offs_LIFECurrencyDLR19_RBS0_STR$19
487WROFSLYR1 SearchASI_Write_Offs_LYRCurrencyDLR19_RBS0_STR$19
488WROFSYTD1 SearchASI_Write_Offs_YTDCurrencyDLR19_RBS0_STR$19
489ONORDAMT1 SearchASI_On_Order_AmountCurrencyDLR19_RBS0_UTR$19
490ASI_Post_Results_To SearchASI_Post_Results_ToIntegerASI_Post_Results_To0
491DISGRPER1 SearchASI_Discount_Grace_PeriodIntegerINT2_U02
492DOCFMTID1 SearchASI_Document_Format_IDStringSTR15_LBU15
493DUEGRPER1 SearchASI_Due_Date_Grace_PeriodIntegerINT2_U02
494PHONE31 SearchASI_Phone_3StringPhone_Number14
495ITEMDESC1 SearchASI_Item_DescriptionStringSTR5050
496NOTEINDX11 SearchASI_Note_Index2CurrencyDLR1414
497DECPLQTY1 SearchASI_Decimal_Places_QTYSIntegerDDL_Decimal_Places_QTYS0
498DECPLCUR1 SearchASI_Decimal_Places_CurrencyIntegerDDL_Decimal_Places_Dollars0
499ITMTRKOP1 SearchASI_Item_Tracking_OptionIntegerDDL_Track0
500VCTNMTHD1 SearchASI_Valuation_MethodIntegerDDL_Valuation_Method0
501MODIFDT11 SearchASI_Modified_Date2DateDT8
502CREATDDT11 SearchASI_Created_Date2DateDT8
503PRCLEVEL1 SearchASI_PriceLevelStringSTR10_LBAU10
504PRMDATE1 SearchASI_Promised_DateDateDATE_L0
505PRMSHPDTE1 SearchASI_Promised_Ship_DateDateDATE_L0
506LOCNCODE1 SearchASI_Location_CodeStringSTR10_Location_Code10
507COMMNTID1 SearchASI_Comment_IDStringSTR15_Comment_ID15
508CURNCYID11 SearchASI_Currency_ID2StringSTR15_Currency_ID15
509ASI_Currency_Index SearchASI_Currency_IndexIntegerINT33
510XCHGRATE1 SearchASI_Exchange_RateCurrency (Variable)DLR14_Exchange_Rate14
511RATECALC1 SearchASI_Rate_Calc_MethodIntegerINT0
512DENXRATE1 SearchASI_Denomination_Exchange_RateCurrency (Variable)DLR14_Exchange_Rate14
513Change_Order_Flag1 SearchASI_Change_Order_FlagBooleanBoolean0
514VENDNAME1 SearchASI_Vendor_NameStringSTR64_Vendor_Name64
515VADCDPAD1 SearchASI_Vendor_Address_Code_Purchase_AddressStringSTR15_Address_Code15
516ADDRESS111 SearchASI_Address_12StringSTR6060
517ADDRESS211 SearchASI_Address_22StringSTR6060
518ADDRESS311 SearchASI_Address_32StringSTR6060
519CITY11 SearchASI_City2StringSTR3535
520STATE11 SearchASI_State2StringSTR30_State29
521ZIPCODE1 SearchASI_Zip_CodeStringSTR1010
522COUNTRY11 SearchASI_Country2StringSTR6060
523PHNUMBR11 SearchASI_Phone_Number_1StringPhone_Number14
524PHNUMBR21 SearchASI_Phone_Number_2StringPhone_Number14
525FAXNUMBR1 SearchASI_Fax_NumberStringSTR14_FAX14
526SHIPMTHD11 SearchASI_Shipping_Method2StringSTR15_Shipping_Method15
527CURNCYID111 SearchASI_Currency_ID3StringSTR15_Currency_ID15
528TXRGNNUM11 SearchASI_Tax_Registration_Number2StringSTR2525
529MINORDER1 SearchASI_Minimum_OrderCurrencyDLR17_$U217
530PYMTRMID11 SearchASI_Payment_Terms_ID2StringSTR20_Payment_Terms_ID20
531COMMENT111 SearchASI_Comment12StringSTR3030
532COMMENT211 SearchASI_Comment22StringSTR3030
533KPCALHST11 SearchASI_Keep_Calendar_History2BooleanCB_Keep_Calendar_History0
534KPERHIST11 SearchASI_Keep_Period_History2BooleanCB_Keep_Period_History0
535KPTRXHST11 SearchASI_Keep_Trx_History2BooleanCB_Keep_Trx_History0
536HOLD11 SearchASI_Hold2BooleanCB_Hold0
537PURPVIDX1 SearchASI_Purchase_Price_Variance_IndexLong IntegerLI_1414
538NOTEINDX111 SearchASI_Note_Index3CurrencyDLR1414
539MODIFDT111 SearchASI_Modified_Date3DateDT8
540CREATDDT111 SearchASI_Created_Date3DateDT8
541RATETPID11 SearchASI_Rate_Type_ID2StringSTR15_Rate_Type_ID15
542FREEONBOARD1 SearchASI_Free_On_BoardIntegerDDL_Free_On_Board0
543DISGRPER11 SearchASI_Discount_Grace_Period2IntegerINT2_U02
544DUEGRPER11 SearchASI_Due_Date_Grace_Period2IntegerINT2_U02
545GOVCRPID1 SearchASI_Governmental_Corporate_IDStringSTR30_Gov_Corp_ID30
546GOVINDID1 SearchASI_Governmental_Individual_IDStringSTR30_Gov_Indiv_ID30
547PHONE311 SearchASI_Phone_32StringPhone_Number14
548ONORDAMT11 SearchASI_On_Order_Amount2CurrencyDLR19_RBS0_UTR$19
549ASI_Required_Date SearchASI_Required_DateDateDATE_L0
550LOCNCODE11 SearchASI_Location_Code2StringSTR10_Location_Code10
551TRXSORCE SearchTRX SourceStringSTR1313
552Purchase_IV_Item_Taxable SearchPurchase IV Item TaxableIntegerDDL_Purchase_Tax_Options0
553Purchase_Item_Tax_Schedu SearchPurchase Item Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].Purchase_Item_Tax_Schedu AS 'SmartList Purchasing Line Items-Purchase Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Purchasing Line Items'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
554Purchase_Site_Tax_Schedu SearchPurchase Site Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Purchasing Line Items'].Purchase_Site_Tax_Schedu AS 'SmartList Purchasing Line Items-Purchase Site Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Purchasing Line Items'].Purchase_Site_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
555BSIVCTTL SearchBased On Invoice TotalBooleanYN0
556TAXAMNT1 SearchASI_Tax_AmountCurrencyDLR17_RBS0_UTR$17
557ORTAXAMT1 SearchASI_Originating_Tax_AmountCurrencyDLR17_RBS0_UTR$17
558Landed_Cost_Group_ID SearchLanded Cost Group IDStringSTR15_LBAU15
559PLNNDSPPLID SearchPlanned Supply IDIntegerINT0
560ASISHIPMTHD3 SearchASI_Shipping_Method3StringSTR15_Shipping_Method15
561ORIGPRMDATE SearchOriginal Promised DateDateDT8
562FSTRCPTDT SearchFirst Receipt DateDateDT8
563LSTRCPTDT SearchLast Receipt DateDateDT8
564CNTRLEXTQTY SearchControl Line Ext QtyCurrencyDLR17_QTY_RBS0_UTR17
565CNTRLEXTCOST SearchControl Line Ext CostCurrencyDLR17_RBS0_UTR$17
566REMAINEXTQTY SearchRemaining Ext QtyCurrencyDLR17_QTY_RBS0_UTR17
567ASI_Address_Code SearchASI_Address_CodeStringSTR15_Address_Code15
568CMPNYNAM1 SearchASI_Company_NameStringSTR64_Company_Name64
569CONTACT1 SearchASI_ContactStringSTR6060
570ADDRESS1111 SearchASI_Address_13StringSTR6060
571ADDRESS2111 SearchASI_Address_23StringSTR6060
572ADDRESS3111 SearchASI_Address_33StringSTR6060
573CITY3 SearchASI_City3StringSTR3535
574STATE3 SearchASI_State3StringSTR30_State29
575ZIP3 SearchASI_Zip3StringSTR1010
576COUNTRY3 SearchASI_Country3StringSTR6060
577PHONE1111 SearchASI_Phone_13StringPhone_Number14
578PHONE2111 SearchASI_Phone_23StringPhone_Number14
579PHONE3111 SearchASI_Phone_33StringPhone_Number14
580FAX3 SearchASI_Fax3StringSTR14_FAX14
581ADDRSOURCE SearchAddress SourceIntegerINT11
582PURCHSITETXSCHSRC SearchPurchase Site Tax Schedule SourceIntegerINT11
583UMSCHDSC SearchU Of M Schedule DescriptionStringSTR3030
584QTYSHPPD SearchQTY ShippedCurrencyDLR17_QTY_RBS0_UTR17
585QTYINVCD SearchQTY InvoicedCurrencyDLR17_QTY_RBS0_UTR17
586QTYREJ SearchQTY RejectedCurrencyDLR17_QTY_RBS0_UTR17
587QTYMATCH SearchQTY MatchedCurrencyDLR17_QTY_RBS0_UTR17
588ProjNum SearchProject NumberStringSTR15_LBAU15
589CostCatID SearchCost Category IDStringSTR15_LBAU15
590Total_Landed_Cost_Amount SearchTotal Landed Cost AmountCurrencyDLR17_RBS0_UTR$17
591QTYINVRESERVE SearchQTY Invoice ReserveCurrencyDLR17_QTY_RBS0_UTR17
592QTYRESERVED SearchQTY ReservedCurrencyDLR17_QTY_RBS0_UTR17
azurecurveProductsSmartList (1493)PathnameSmartList Purchasing Line Items (ASIEXP21)

Leave a Reply

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