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: Pathname

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2PONUMBER SearchPO NumberSTR17_POP_NumberString1817
3ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
4ORD SearchOrdLI_Sequence_NumberLong Integer410
5POLNESTA SearchPO Line StatusDDL_PO_Line_StatusInteger20
6POTYPE SearchPO TypeDDL_POP_PO_TypeInteger20
7ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
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 DescriptionSTR100String102100
9VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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 NumberItem_NumberString3230
11VNDITDSC SearchVendor Item DescriptionSTR100String102100
12NONINVEN SearchNon IVINT1Integer21
13UOFM SearchU Of MU_Of_MString108
14UMQTYINB SearchU Of M QTY In BaseDLR17_QTY_RBS0_STRCurrency1017
15QTYORDER SearchQTY OrderedDLR17_QTY_RBS0_UTRCurrency1017
16QTYCANCE SearchQTY CanceledDLR17_QTY_RBS0_UTRCurrency1017
17QTYCMTBASE SearchQTY Committed In BaseDLR17_QTY_RBS0_STRCurrency1017
18QTYUNCMTBASE SearchQTY Uncommitted In BaseDLR17_QTY_RBS0_STRCurrency1017
19UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
20EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
21INVINDX SearchInventory IndexLI_14Long Integer414
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 DateDATE_LDate40
23PRMDATE SearchPromised DateDATE_LDate40
24PRMSHPDTE SearchPromised Ship DateDATE_LDate40
25REQSTDBY SearchRequested BySTR20_LBString2220
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 IDSTR15_Comment_IDString1615
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 TypeDDL_Document_TypeInteger20
28POLNEARY_1 SearchPO Line Note ID Array[1]DLR14Currency1014
29POLNEARY_2 SearchPO Line Note ID Array[2]DLR14Currency1014
30POLNEARY_3 SearchPO Line Note ID Array[3]DLR14Currency1014
31POLNEARY_4 SearchPO Line Note ID Array[4]DLR14Currency1014
32POLNEARY_5 SearchPO Line Note ID Array[5]DLR14Currency1014
33POLNEARY_6 SearchPO Line Note ID Array[6]DLR14Currency1014
34POLNEARY_7 SearchPO Line Note ID Array[7]DLR14Currency1014
35POLNEARY_8 SearchPO Line Note ID Array[8]DLR14Currency1014
36POLNEARY_9 SearchPO Line Note ID Array[9]DLR14Currency1014
37DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
38DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
39ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger20
40BRKFLD1 SearchBreak Field 1INT1Integer21
41PO_Line_Status_Orig SearchPO Line Status OrigDDL_PO_Line_StatusInteger20
42QTY_Canceled_Orig SearchQTY Canceled OrigDLR17_QTY_RBS0_UTRCurrency1017
43OPOSTSUB SearchOriginating Posted SubtotalDLR17_RBS0_STR$Currency1017
44JOBNUMBR SearchJob NumberSTR17_LBAUString1817
45COSTCODE SearchCost CodeSTR27String2827
46COSTTYPE SearchCost Code TypeINT3_RB0_UInteger23
47CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 IndexINT3Integer23
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 RateDLR14_Exchange_RateCurrency (Variable)1014
50RATECALC SearchRate Calc MethodINTInteger20
51DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
52ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency1017
53OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency1017
54LINEORIGIN SearchLine OriginDDL_Line_OriginInteger20
55FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger20
56ODECPLCU SearchOriginating Decimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
57Capital_Item SearchCapital ItemCB_Capital_ItemBoolean20
58Product_Indicator SearchProduct IndicatorDDL_Product_IndicatorInteger20
59Source_Document_Number SearchSource Document NumberSTR11_Document_NumberString1211
60Source_Document_Line_Num SearchSource Document Line NumberINT4Integer24
61ASI_Document_Status SearchASI_Document_StatusINTInteger20
62STATGRP SearchStatus GroupINT1Integer21
63USER2ENT SearchUser To EnterSTR15_User_IDString1615
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 WithSTR20String2220
65DOCDATE SearchDocument DateDTDate48
66LSTEDTDT SearchLast Edit DateDT_DateDate46
67LSTPRTDT SearchLast Printed DateDATE_LDate40
68REQTNDT SearchRequisition DateDATE_LDate40
69SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
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 NumberSTR25String2625
71REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency1017
72SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency1017
73TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
74FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
75MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency1017
76TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
77VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
78MINORDER SearchMinimum OrderDLR17_$U2Currency1017
79VADCDPAD SearchVendor Address Code - Purchase AddressSTR15_Address_CodeString1615
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 IDINT5Integer24
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 CodeSTR15_LBAUString1615
82PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
83CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
84CONTACT SearchContactSTR60String6260
85ADDRESS1 SearchAddress 1STR60String6260
86ADDRESS2 SearchAddress 2STR60String6260
87ADDRESS3 SearchAddress 3STR60String6260
88CITY SearchCitySTR35String3635
89STATE SearchStateSTR30_StateString3029
90ZIPCODE SearchZip CodeSTR10String1210
91COUNTRY SearchCountrySTR60String6260
92PHONE1 SearchPhone 1Phone_NumberString2214
93PHONE2 SearchPhone 2Phone_NumberString2214
94FAX SearchFaxSTR14_FAXString2214
95PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
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 AmountDLR11_RBS0_UTR$Currency1011
97DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer25
98DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency1017
99DISCDATE SearchDiscount DateDTDate48
100DUEDATE SearchDue DateDTDate48
101TRDPCTPR SearchTrade Discount Percent (Precise)Trade Discount Percent (Precise)Currency (Variable)1223
102CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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 PrintedINT4_U0Integer24
104CREATDDT SearchCreated DateDTDate48
105MODIFDT SearchModified DateDTDate48
106PONOTIDS_1 SearchPO Note ID Array[1]DLR14Currency1014
107PONOTIDS_2 SearchPO Note ID Array[2]DLR14Currency1014
108PONOTIDS_3 SearchPO Note ID Array[3]DLR14Currency1014
109PONOTIDS_4 SearchPO Note ID Array[4]DLR14Currency1014
110PONOTIDS_5 SearchPO Note ID Array[5]DLR14Currency1014
111PONOTIDS_6 SearchPO Note ID Array[6]DLR14Currency1014
112PONOTIDS_7 SearchPO Note ID Array[7]DLR14Currency1014
113PONOTIDS_8 SearchPO Note ID Array[8]DLR14Currency1014
114PONOTIDS_9 SearchPO Note ID Array[9]DLR14Currency1014
115PONOTIDS_10 SearchPO Note ID Array[10]DLR14Currency1014
116PONOTIDS_11 SearchPO Note ID Array[11]DLR14Currency1014
117PONOTIDS_12 SearchPO Note ID Array[12]DLR14Currency1014
118PONOTIDS_13 SearchPO Note ID Array[13]DLR14Currency1014
119PONOTIDS_14 SearchPO Note ID Array[14]DLR14Currency1014
120PONOTIDS_15 SearchPO Note ID Array[15]DLR14Currency1014
121COMMENT_1 SearchComment[1]STR50String5250
122COMMENT_2 SearchComment[2]STR50String5250
123COMMENT_3 SearchComment[3]STR50String5250
124COMMENT_4 SearchComment[4]STR50String5250
125CANCSUB SearchCanceled SubtotalDLR17_RBS0_STR$Currency1017
126RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
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 IDSTR15_Exchange_Table_IDString1615
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 DateDT_DateDate46
129TIME1 SearchTimeTM6Time46
130MCTRXSTT SearchMC Transaction StateINT1Integer21
131OREMSUBT SearchOriginating Remaining SubtotalDLR17_RBS0_UTR$Currency1017
132ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency1017
133Originating_Canceled_Sub SearchOriginating Canceled SubtotalDLR17_RBS0_STR$Currency1017
134ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
135ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
136OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency1017
137ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
138ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency1011
139ODISAMTAV SearchOriginating Discount Amount AvailableDLR17_RBS0_UTR$Currency1017
140BUYERID SearchBuyer IDSTR15_User_IDString1615
141ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
142ORORDAMT SearchOriginating On Order AmountDLR19_RBS0_UTR$Currency1019
143HOLD SearchHoldCB_HoldBoolean20
144ONHOLDDATE SearchOn Hold DateDTDate48
145ONHOLDBY SearchOn Hold BySTR15_User_IDString1615
146HOLDREMOVEDATE SearchHold Remove DateDTDate48
147HOLDREMOVEBY SearchHold Remove BySTR15_User_IDString1615
148ALLOWSOCMTS SearchAllow SO CommitmentsCB_AllowSOCommitmentsBoolean20
149NOTEINDX SearchNote IndexDLR14Currency1014
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 NameSTR15String1615
151ITEMTYPE SearchItem TypeDDL_Item_TypeInteger20
152ITMGEDSC SearchItem Generic DescriptionSTR10String1210
153STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency1017
154CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency1017
155LISTPRCE SearchList PriceDLR17_RBS0_STR$Currency1017
156ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer46
157ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
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 OptionsDDL_Tax_OptionsInteger20
159COMMCODE SearchCommission CodeSTR15_LBAUString1615
160IVIVINDX SearchIV IV IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 CodeSTR10_Class_IDString1210
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 TypeSTR10_Lot_TypeString1210
176KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
177KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
178KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
179KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
180ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean20
181VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger20
182UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
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 1STR30_Item_NumberString3230
184ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString3230
185USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString1210
186USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString1210
187USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString1210
188USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString1210
189USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString1210
190USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString1210
191MSTRCDTY SearchMaster Record TypeINT1Integer21
192WRNTYDYS SearchWarranty DaysINT4Integer24
193PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
194VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString6664
195VENDSHNM SearchVendor Short NameSTR15String1615
196VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString1615
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 FromSTR15_Address_CodeString1615
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 ToSTR15_Address_CodeString1615
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 IDSTR10_Class_IDString1210
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 ContactSTR60String6260
201UPSZONE SearchUPS ZoneSTR3String43
202TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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 VendorSTR20String2220
204TXIDNMBR SearchTax ID NumberTax_ID_NumberString1211
205VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger20
206PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString1615
207TRDDISCT SearchTrade DiscountINT4_%2Integer24
208TEN99TYPE Search1099 Type1099_TypeInteger20
209MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger20
210MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
211MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
212MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger20
213MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency1017
214COMMENT1 SearchComment1STR30String3230
215COMMENT2 SearchComment2STR30String3230
216USERDEF1 SearchUser Defined 1STR20String2220
217USERDEF2 SearchUser Defined 2STR20String2220
218CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency1017
219PYMNTPRI SearchPayment PrioritySTR3String43
220KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean20
221PTCSHACF SearchPost To Cash Account FromGBInteger20
222CREDTLMT SearchCredit LimitGBInteger20
223WRITEOFF SearchWriteoffGBInteger20
224MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency1017
225SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean20
226PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
227DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String2625
228CRTCOMDT SearchCertificate Commencing DateDTDate48
229CRTEXPDT SearchCertificate Expiration DateDTDate48
230RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean20
231XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean20
232PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean20
233PMAPINDX SearchPM AP IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IDSTR15_Checkbook_IDString1615
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 VendorCB Revalue VendorBoolean20
248Post_Results_To SearchPost Results ToGBInteger20
249POSTATUS SearchPO StatusDDL_PO_StatusInteger20
250HIESTBAL SearchHighest BalanceDLR17_RBS0_UTR$Currency1017
251CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency1019
252NOINVYTD SearchNumber of Invoices YTDLI_9U0Long Integer49
253NOINVLIF SearchNumber of Invoices LIFELI_9U0Long Integer49
254NOINVLYR SearchNumber of Invoices LYRLI_9U0Long Integer49
255NOPINYTD SearchNumber of Paid Invoices YTDLI_9U0Long Integer49
256NOPILIFE SearchNumber of Paid Invoices LIFELI_9U0Long Integer49
257AMBLDTYD SearchAmount Billed YTDDLR19_RBS0_STR$Currency1019
258AMBLDLIF SearchAmount Billed LIFEDLR19_RBS0_STR$Currency1019
259AMBLDLYR SearchAmount Billed LYRDLR19_RBS0_STR$Currency1019
260AMTPDYTD SearchAmount Paid YTDDLR19_RBS0_STR$Currency1019
261AMTPDLIF SearchAmount Paid LIFEDLR19_RBS0_STR$Currency1019
262AMTPDLYR SearchAmount Paid LYRDLR19_RBS0_STR$Currency1019
263TEN99AYTD Search1099 Amount YTDDLR19_RBS0_STR$Currency1019
264TEN99ALIF Search1099 Amount LIFEDLR19_RBS0_STR$Currency1019
265TEN99ALYR Search1099 Amount LYRDLR19_RBS0_STR$Currency1019
266DISAVYTD SearchDiscount Available YTDDLR19_RBS0_STR$Currency1019
267DISAVLIF SearchDiscount Available LIFEDLR19_RBS0_STR$Currency1019
268DISAVLYR SearchDiscount Available LYRDLR19_RBS0_STR$Currency1019
269DISTKYTD SearchDiscount Taken YTDDLR19_RBS0_STR$Currency1019
270DISTKNLF SearchDiscount Taken LIFEDLR19_RBS0_STR$Currency1019
271DISTKLYR SearchDiscount Taken LYRDLR19_RBS0_STR$Currency1019
272DISLSYTD SearchDiscount Lost YTDDLR19_RBS0_STR$Currency1019
273DISLSTLF SearchDiscount Lost LIFEDLR19_RBS0_STR$Currency1019
274DISLSLYR SearchDiscount Lost LYRDLR19_RBS0_STR$Currency1019
275FINCHLIF SearchFinance Charge LIFEDLR19_RBS0_STR$Currency1019
276FINCHLYR SearchFinance Charge LYRDLR19_RBS0_STR$Currency1019
277FINCHYTD SearchFinance Charge YTDDLR19_RBS0_STR$Currency1019
278WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency1019
279WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency1019
280WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency1019
281RTRNSYTD SearchReturns YTDDLR19_RBS0_STR$Currency1019
282RTRNSLIF SearchReturns LIFEDLR19_RBS0_STR$Currency1019
283RTRNSLYR SearchReturns LYRDLR19_RBS0_STR$Currency1019
284TRDTKLIF SearchTrade Discounts Taken LIFEDLR19_RBSO_STR$Currency1019
285TRDTLYR SearchTrade Discounts Taken LYRDLR19_RBSO_STR$Currency1019
286TRDTYTD SearchTrade Discounts Taken YTDDLR19_RBSO_STR$Currency1019
287NFNCHLIF SearchNumber of Finance Charges LIFELI_9U0Long Integer49
288NFNCHLYR SearchNumber of Finance Charges LYRLI_9U0Long Integer49
289NFNCHYTD SearchNumber of Finance Charges YTDLI_9U0Long Integer49
290RTNGOWED SearchRetainage OwedDLR17_RBS0_STR$Currency1017
291LSTCHNUM SearchLast Check NumberCheck_NumberString2220
292LSTCHKDT SearchLast Check DateDTDate48
293LSTCHAMT SearchLast Check AmountDLR17_RBS0_UTR$Currency1017
294LSTINNUM SearchLast Invoice NumberSTR20String2220
295LSTINVAM SearchLast Invoice AmountDLR17_RBS0_UTR$Currency1017
296LSTPURDT SearchLast Purchase DateDTDate48
297FSTPURDT SearchFirst Purchase DateDTDate48
298CURUNPBN SearchCurrent Unapplied Payment BalanceDLR17_RBS0_UTR$Currency1017
299UNPDFNCH SearchUnpaid Finance ChargesDLR17_RBS0_UTR$Currency1017
300DYCHTCLR SearchDays Checks To ClearINT3_U0Integer23
301AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer23
302AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer23
303CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
304CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString1615
305CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
306CNTCPRSN SearchContact PersonSTR60String6260
307STMTNAME SearchStatement NameSTR64String6664
308SHRTNAME SearchShort NameSTR15String1615
309ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
310STADDRCD SearchStatement Address CodeSTR15_LBAUString1615
311SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
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 TypeGB_Amt_TypeInteger20
313CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency1017
314CRLMTPER SearchCredit Limit PeriodDDLInteger20
315CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency1017
316CUSTDISC SearchCustomer DiscountINT5_%2Integer25
317FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger20
318FNCHPCNT SearchFinance Charge PercentINT5_%2Integer25
319FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency1017
320MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger20
321MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency1017
322TAXEXMT1 SearchTax Exempt 1STR25String2625
323TAXEXMT2 SearchTax Exempt 2STR25String2625
324BALNCTYP SearchBalance TypeGB_Bal_TypeInteger20
325STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger20
326BANKNAME SearchBank NameSTR30String3230
327BNKBRNCH SearchBank BranchSTR20String2220
328SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
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 TypeGBInteger20
330RMCSHACC SearchRM Cash Account IndexLI_14Long Integer414
331RMARACC SearchRM AR Account IndexLI_14Long Integer414
332RMSLSACC SearchRM Sales Account IndexLI_14Long Integer414
333RMIVACC SearchRM IV Account IndexLI_14Long Integer414
334RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer414
335RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer414
336RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer414
337RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer414
338RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer414
339FRSTINDT SearchFirst Invoice DateDT_DateDate46
340INACTIVE SearchInactiveCB_InactiveBoolean20
341CRCARDID SearchCredit Card IDSTR15String1615
342CRCRDNUM SearchCredit Card NumberSTR20String2220
343CCRDXPDT SearchCredit Card Exp DateDT_DateDate46
344Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean20
345FINCHID SearchFinance Charge IDSTR15_Charge_IDString1615
346GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
347GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
348TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency1019
349NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer46
350CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency1019
351AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency1017
352AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency1017
353AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency1017
354AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency1017
355AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency1017
356AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency1017
357AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency1017
358LASTAGED SearchLast AgedDATEDate46
359LSTNSFCD SearchLast NSF Check DateDT_DateDate46
360LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency1017
361LASTPYDT SearchLast Payment DateDT_DateDate46
362LSTTRXDT SearchLast Transaction DateDT_DateDate46
363LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency1017
364LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency1019
365UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency1017
366NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer410
367NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer410
368NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer410
369TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency1019
370TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency1019
371TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency1019
372TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency1019
373RETAINAG SearchRetainageDLR19_RBS0_STR$Currency1019
374TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency1019
375NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer46
376UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency1019
377UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency1019
378UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency1019
379UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency1019
380NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency1019
381TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency1019
382TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency1019
383TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency1019
384TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency1019
385TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency1019
386TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency1019
387TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency1019
388TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency1019
389TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency1019
390TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency1019
391TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency1019
392TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency1019
393FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency1019
394FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency1019
395TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency1019
396TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency1019
397TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency1019
398TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency1019
399TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency1019
400TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency1019
401TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency1019
402TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency1019
403TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency1019
404TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer46
405TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer46
406TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer46
407TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer46
408TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer46
409TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer46
410HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency1019
411HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency1019
412HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency1019
413LASTSTDT SearchLast Statement DateDATEDate46
414LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency1017
415DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency1019
416ABCCODE SearchABC CodeDDL_ABC_CodeInteger20
417CGSINFLX SearchCOGS Inflation IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 CodeSTR15String1615
422KTACCTSR SearchKit COGS Account SourceGBInteger20
423LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString2220
424PriceGroup SearchPrice GroupSTR10_LBAUString1210
425PRICMTHD SearchPrice MethodDDL_Price_MethodInteger20
426PINFLIDX SearchPurch Inflation IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 MU_Of_MString108
429SELNGUOM SearchSelling U Of MU_Of_MString108
430TCC SearchTax Commodity CodeSTR30_VATString3230
431UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer414
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 PeriodINT2_U0Integer22
433DOCFMTID SearchDocument Format IDSTR15_LBUString1615
434DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
435PHONE3 SearchPhone 3Phone_Number3String2214
436TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
437Withholding_LIFE SearchWithholding LIFEDLR19_RBS0_STR$Currency1019
438WITHLYR SearchWithholding LYRDLR19_RBS0_STR$Currency1019
439WITHYTD SearchWithholding YTDDLR19_RBS0_STR$Currency1019
440Change_Order_Flag SearchChange Order FlagINTInteger20
441PO_Field_Changes SearchPO Field ChangesML_POP_PO_Field_ChangesLong Integer40
442PO_Status_Orig SearchPO Status OrigDDL_PO_StatusInteger20
443Revision_Number SearchRevision NumberINT4Integer24
444LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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 DateDATE_LDate40
446Released_Date SearchReleased DateDATE_LDate40
447UPSZONE1 SearchASI_UPS_ZoneSTR3String43
448SHIPMTHD1 SearchASI_Shipping_MethodSTR15_Shipping_MethodString1615
449TAXSCHID1 SearchASI_Tax_Schedule_IDSTR15_Tax_Schedule_IDString1615
450ADDRESS11 SearchASI_Address_1STR60String6260
451ADDRESS21 SearchASI_Address_2STR60String6260
452ADDRESS31 SearchASI_Address_3STR60String6260
453CITY1 SearchASI_CitySTR35String3635
454STATE1 SearchASI_StateSTR30_StateString3029
455COUNTRY1 SearchASI_CountrySTR60String6260
456ZIP1 SearchASI_ZipSTR10String1210
457PHONE11 SearchASI_Phone_1Phone_NumberString2214
458PHONE21 SearchASI_Phone_2Phone_NumberString2214
459FAX1 SearchASI_FaxSTR14_FAXString2214
460PRBTADCD1 SearchASI_Primary_Billto_Address_CodeSTR15_LBAUString1615
461PRSTADCD1 SearchASI_Primary_Shipto_Address_CodeSTR15_LBAUString1615
462CHEKBKID1 SearchASI_Checkbook_IDSTR15_Checkbook_IDString1615
463PYMTRMID1 SearchASI_Payment_Terms_IDSTR20_Payment_Terms_IDString2220
464CURNCYID1 SearchASI_Currency_IDSTR15_Currency_IDString1615
465RATETPID1 SearchASI_Rate_Type_IDSTR15_Rate_Type_IDString1615
466ASI_Minimum_Payment_Type SearchASI_Minimum_Payment_TypeASI_Minimum_Payment_TypeInteger20
467MINPYDLR1 SearchASI_Minimum_Payment_DollarDLR17_RBS0_UTR$Currency1017
468MINPYPCT1 SearchASI_Minimum_Payment_PercentINT5_%2Integer25
469COMMENT11 SearchASI_Comment1STR30String3230
470COMMENT21 SearchASI_Comment2STR30String3230
471USERDEF11 SearchASI_User_Defined_1STR20String2220
472USERDEF21 SearchASI_User_Defined_2STR20String2220
473TXRGNNUM1 SearchASI_Tax_Registration_NumberSTR25String2625
474HOLD1 SearchASI_HoldCB_HoldBoolean20
475KPDSTHST1 SearchASI_Keep_Distribution_HistoryCB_Keep_Dist_HistoryBoolean20
476KPCALHST1 SearchASI_Keep_Calendar_HistoryCB_Keep_Calendar_HistoryBoolean20
477KPERHIST1 SearchASI_Keep_Period_HistoryCB_Keep_Period_HistoryBoolean20
478KPTRXHST1 SearchASI_Keep_Trx_HistoryCB_Keep_Trx_HistoryBoolean20
479NOTEINDX1 SearchASI_Note_IndexDLR14Currency1014
480CREATDDT1 SearchASI_Created_DateDTDate48
481MODIFDT1 SearchASI_Modified_DateDTDate48
482FRSTINDT1 SearchASI_First_Invoice_DateDT_DateDate46
483AVDTPLIF1 SearchASI_Average_Days_To_Pay_LifeINT3_U0Integer23
484AVDTPLYR1 SearchASI_Average_Days_to_Pay_LYRINT3_U0Integer23
485AVGDTPYR1 SearchASI_Average_Days_To_Pay_YearINT3_U0Integer23
486WROFSLIF1 SearchASI_Write_Offs_LIFEDLR19_RBS0_STR$Currency1019
487WROFSLYR1 SearchASI_Write_Offs_LYRDLR19_RBS0_STR$Currency1019
488WROFSYTD1 SearchASI_Write_Offs_YTDDLR19_RBS0_STR$Currency1019
489ONORDAMT1 SearchASI_On_Order_AmountDLR19_RBS0_UTR$Currency1019
490ASI_Post_Results_To SearchASI_Post_Results_ToASI_Post_Results_ToInteger20
491DISGRPER1 SearchASI_Discount_Grace_PeriodINT2_U0Integer22
492DOCFMTID1 SearchASI_Document_Format_IDSTR15_LBUString1615
493DUEGRPER1 SearchASI_Due_Date_Grace_PeriodINT2_U0Integer22
494PHONE31 SearchASI_Phone_3Phone_NumberString2214
495ITEMDESC1 SearchASI_Item_DescriptionSTR50String5250
496NOTEINDX11 SearchASI_Note_Index2DLR14Currency1014
497DECPLQTY1 SearchASI_Decimal_Places_QTYSDDL_Decimal_Places_QTYSInteger20
498DECPLCUR1 SearchASI_Decimal_Places_CurrencyDDL_Decimal_Places_DollarsInteger20
499ITMTRKOP1 SearchASI_Item_Tracking_OptionDDL_TrackInteger20
500VCTNMTHD1 SearchASI_Valuation_MethodDDL_Valuation_MethodInteger20
501MODIFDT11 SearchASI_Modified_Date2DTDate48
502CREATDDT11 SearchASI_Created_Date2DTDate48
503PRCLEVEL1 SearchASI_PriceLevelSTR10_LBAUString1210
504PRMDATE1 SearchASI_Promised_DateDATE_LDate40
505PRMSHPDTE1 SearchASI_Promised_Ship_DateDATE_LDate40
506LOCNCODE1 SearchASI_Location_CodeSTR10_Location_CodeString1210
507COMMNTID1 SearchASI_Comment_IDSTR15_Comment_IDString1615
508CURNCYID11 SearchASI_Currency_ID2STR15_Currency_IDString1615
509ASI_Currency_Index SearchASI_Currency_IndexINT3Integer23
510XCHGRATE1 SearchASI_Exchange_RateDLR14_Exchange_RateCurrency (Variable)1014
511RATECALC1 SearchASI_Rate_Calc_MethodINTInteger20
512DENXRATE1 SearchASI_Denomination_Exchange_RateDLR14_Exchange_RateCurrency (Variable)1014
513Change_Order_Flag1 SearchASI_Change_Order_FlagBooleanBoolean20
514VENDNAME1 SearchASI_Vendor_NameSTR64_Vendor_NameString6664
515VADCDPAD1 SearchASI_Vendor_Address_Code_Purchase_AddressSTR15_Address_CodeString1615
516ADDRESS111 SearchASI_Address_12STR60String6260
517ADDRESS211 SearchASI_Address_22STR60String6260
518ADDRESS311 SearchASI_Address_32STR60String6260
519CITY11 SearchASI_City2STR35String3635
520STATE11 SearchASI_State2STR30_StateString3029
521ZIPCODE1 SearchASI_Zip_CodeSTR10String1210
522COUNTRY11 SearchASI_Country2STR60String6260
523PHNUMBR11 SearchASI_Phone_Number_1Phone_NumberString2214
524PHNUMBR21 SearchASI_Phone_Number_2Phone_NumberString2214
525FAXNUMBR1 SearchASI_Fax_NumberSTR14_FAXString2214
526SHIPMTHD11 SearchASI_Shipping_Method2STR15_Shipping_MethodString1615
527CURNCYID111 SearchASI_Currency_ID3STR15_Currency_IDString1615
528TXRGNNUM11 SearchASI_Tax_Registration_Number2STR25String2625
529MINORDER1 SearchASI_Minimum_OrderDLR17_$U2Currency1017
530PYMTRMID11 SearchASI_Payment_Terms_ID2STR20_Payment_Terms_IDString2220
531COMMENT111 SearchASI_Comment12STR30String3230
532COMMENT211 SearchASI_Comment22STR30String3230
533KPCALHST11 SearchASI_Keep_Calendar_History2CB_Keep_Calendar_HistoryBoolean20
534KPERHIST11 SearchASI_Keep_Period_History2CB_Keep_Period_HistoryBoolean20
535KPTRXHST11 SearchASI_Keep_Trx_History2CB_Keep_Trx_HistoryBoolean20
536HOLD11 SearchASI_Hold2CB_HoldBoolean20
537PURPVIDX1 SearchASI_Purchase_Price_Variance_IndexLI_14Long Integer414
538NOTEINDX111 SearchASI_Note_Index3DLR14Currency1014
539MODIFDT111 SearchASI_Modified_Date3DTDate48
540CREATDDT111 SearchASI_Created_Date3DTDate48
541RATETPID11 SearchASI_Rate_Type_ID2STR15_Rate_Type_IDString1615
542FREEONBOARD1 SearchASI_Free_On_BoardDDL_Free_On_BoardInteger20
543DISGRPER11 SearchASI_Discount_Grace_Period2INT2_U0Integer22
544DUEGRPER11 SearchASI_Due_Date_Grace_Period2INT2_U0Integer22
545GOVCRPID1 SearchASI_Governmental_Corporate_IDSTR30_Gov_Corp_IDString3230
546GOVINDID1 SearchASI_Governmental_Individual_IDSTR30_Gov_Indiv_IDString3230
547PHONE311 SearchASI_Phone_32Phone_NumberString2214
548ONORDAMT11 SearchASI_On_Order_Amount2DLR19_RBS0_UTR$Currency1019
549ASI_Required_Date SearchASI_Required_DateDATE_LDate40
550LOCNCODE11 SearchASI_Location_Code2STR10_Location_CodeString1210
551TRXSORCE SearchTRX SourceSTR13String1413
552Purchase_IV_Item_Taxable SearchPurchase IV Item TaxableDDL_Purchase_Tax_OptionsInteger20
553Purchase_Item_Tax_Schedu SearchPurchase Item Tax Schedule IDSTR15_LBAUString1615
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 IDSTR15_LBAUString1615
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 TotalYNBoolean20
556TAXAMNT1 SearchASI_Tax_AmountDLR17_RBS0_UTR$Currency1017
557ORTAXAMT1 SearchASI_Originating_Tax_AmountDLR17_RBS0_UTR$Currency1017
558Landed_Cost_Group_ID SearchLanded Cost Group IDSTR15_LBAUString1615
559PLNNDSPPLID SearchPlanned Supply IDINTInteger20
560ASISHIPMTHD3 SearchASI_Shipping_Method3STR15_Shipping_MethodString1615
561ORIGPRMDATE SearchOriginal Promised DateDTDate48
562FSTRCPTDT SearchFirst Receipt DateDTDate48
563LSTRCPTDT SearchLast Receipt DateDTDate48
564CNTRLEXTQTY SearchControl Line Ext QtyDLR17_QTY_RBS0_UTRCurrency1017
565CNTRLEXTCOST SearchControl Line Ext CostDLR17_RBS0_UTR$Currency1017
566REMAINEXTQTY SearchRemaining Ext QtyDLR17_QTY_RBS0_UTRCurrency1017
567ASI_Address_Code SearchASI_Address_CodeSTR15_Address_CodeString1615
568CMPNYNAM1 SearchASI_Company_NameSTR64_Company_NameString6664
569CONTACT1 SearchASI_ContactSTR60String6260
570ADDRESS1111 SearchASI_Address_13STR60String6260
571ADDRESS2111 SearchASI_Address_23STR60String6260
572ADDRESS3111 SearchASI_Address_33STR60String6260
573CITY3 SearchASI_City3STR35String3635
574STATE3 SearchASI_State3STR30_StateString3029
575ZIP3 SearchASI_Zip3STR10String1210
576COUNTRY3 SearchASI_Country3STR60String6260
577PHONE1111 SearchASI_Phone_13Phone_NumberString2214
578PHONE2111 SearchASI_Phone_23Phone_NumberString2214
579PHONE3111 SearchASI_Phone_33Phone_NumberString2214
580FAX3 SearchASI_Fax3STR14_FAXString2214
581ADDRSOURCE SearchAddress SourceINT1Integer21
582PURCHSITETXSCHSRC SearchPurchase Site Tax Schedule SourceINT1Integer21
583UMSCHDSC SearchU Of M Schedule DescriptionSTR30String3230
584QTYSHPPD SearchQTY ShippedDLR17_QTY_RBS0_UTRCurrency1017
585QTYINVCD SearchQTY InvoicedDLR17_QTY_RBS0_UTRCurrency1017
586QTYREJ SearchQTY RejectedDLR17_QTY_RBS0_UTRCurrency1017
587QTYMATCH SearchQTY MatchedDLR17_QTY_RBS0_UTRCurrency1017
588ProjNum SearchProject NumberSTR15_LBAUString1615
589CostCatID SearchCost Category IDSTR15_LBAUString1615
590Total_Landed_Cost_Amount SearchTotal Landed Cost AmountDLR17_RBS0_UTR$Currency1017
591QTYINVRESERVE SearchQTY Invoice ReserveDLR17_QTY_RBS0_UTRCurrency1017
592QTYRESERVED SearchQTY ReservedDLR17_QTY_RBS0_UTRCurrency1017
azurecurveProductsSmartList (1493)PathnameSmartList Purchasing Line Items (ASIEXP21)

Leave a Reply

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