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 TypeLength
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
2PONUMBER SearchPO NumberSTR17_POP_NumberString17
3ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
4ORD SearchOrdLI_Sequence_NumberLong Integer10
5POLNESTA SearchPO Line StatusDDL_PO_Line_StatusInteger0
6POTYPE SearchPO TypeDDL_POP_PO_TypeInteger0
7ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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 DescriptionSTR100String100
9VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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_NumberString30
11VNDITDSC SearchVendor Item DescriptionSTR100String100
12NONINVEN SearchNon IVINT1Integer1
13UOFM SearchU Of MU_Of_MString8
14UMQTYINB SearchU Of M QTY In BaseDLR17_QTY_RBS0_STRCurrency17
15QTYORDER SearchQTY OrderedDLR17_QTY_RBS0_UTRCurrency17
16QTYCANCE SearchQTY CanceledDLR17_QTY_RBS0_UTRCurrency17
17QTYCMTBASE SearchQTY Committed In BaseDLR17_QTY_RBS0_STRCurrency17
18QTYUNCMTBASE SearchQTY Uncommitted In BaseDLR17_QTY_RBS0_STRCurrency17
19UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
20EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
21INVINDX SearchInventory IndexLI_14Long Integer14
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_LDate0
23PRMDATE SearchPromised DateDATE_LDate0
24PRMSHPDTE SearchPromised Ship DateDATE_LDate0
25REQSTDBY SearchRequested BySTR20_LBString20
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_IDString15
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_TypeInteger0
28POLNEARY_1 SearchPO Line Note ID Array[1]DLR14Currency14
29POLNEARY_2 SearchPO Line Note ID Array[2]DLR14Currency14
30POLNEARY_3 SearchPO Line Note ID Array[3]DLR14Currency14
31POLNEARY_4 SearchPO Line Note ID Array[4]DLR14Currency14
32POLNEARY_5 SearchPO Line Note ID Array[5]DLR14Currency14
33POLNEARY_6 SearchPO Line Note ID Array[6]DLR14Currency14
34POLNEARY_7 SearchPO Line Note ID Array[7]DLR14Currency14
35POLNEARY_8 SearchPO Line Note ID Array[8]DLR14Currency14
36POLNEARY_9 SearchPO Line Note ID Array[9]DLR14Currency14
37DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
38DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
39ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger0
40BRKFLD1 SearchBreak Field 1INT1Integer1
41PO_Line_Status_Orig SearchPO Line Status OrigDDL_PO_Line_StatusInteger0
42QTY_Canceled_Orig SearchQTY Canceled OrigDLR17_QTY_RBS0_UTRCurrency17
43OPOSTSUB SearchOriginating Posted SubtotalDLR17_RBS0_STR$Currency17
44JOBNUMBR SearchJob NumberSTR17_LBAUString17
45COSTCODE SearchCost CodeSTR27String27
46COSTTYPE SearchCost Code TypeINT3_RB0_UInteger3
47CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 IndexINT3Integer3
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)14
50RATECALC SearchRate Calc MethodINTInteger0
51DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
52ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency17
53OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency17
54LINEORIGIN SearchLine OriginDDL_Line_OriginInteger0
55FREEONBOARD SearchFree On BoardDDL_Free_On_BoardInteger0
56ODECPLCU SearchOriginating Decimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
57Capital_Item SearchCapital ItemCB_Capital_ItemBoolean0
58Product_Indicator SearchProduct IndicatorDDL_Product_IndicatorInteger0
59Source_Document_Number SearchSource Document NumberSTR11_Document_NumberString11
60Source_Document_Line_Num SearchSource Document Line NumberINT4Integer4
61ASI_Document_Status SearchASI_Document_StatusINTInteger0
62STATGRP SearchStatus GroupINT1Integer1
63USER2ENT SearchUser To EnterSTR15_User_IDString15
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 WithSTR20String20
65DOCDATE SearchDocument DateDTDate8
66LSTEDTDT SearchLast Edit DateDT_DateDate6
67LSTPRTDT SearchLast Printed DateDATE_LDate0
68REQTNDT SearchRequisition DateDATE_LDate0
69SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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 NumberSTR25String25
71REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency17
72SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency17
73TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
74FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
75MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency17
76TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
77VENDNAME SearchVendor NameSTR64_Vendor_NameString64
78MINORDER SearchMinimum OrderDLR17_$U2Currency17
79VADCDPAD SearchVendor Address Code - Purchase AddressSTR15_Address_CodeString15
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 IDINT5Integer4
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_LBAUString15
82PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
83CMPNYNAM SearchCompany NameSTR64_Company_NameString64
84CONTACT SearchContactSTR60String60
85ADDRESS1 SearchAddress 1STR60String60
86ADDRESS2 SearchAddress 2STR60String60
87ADDRESS3 SearchAddress 3STR60String60
88CITY SearchCitySTR35String35
89STATE SearchStateSTR30_StateString29
90ZIPCODE SearchZip CodeSTR10String10
91COUNTRY SearchCountrySTR60String60
92PHONE1 SearchPhone 1Phone_NumberString14
93PHONE2 SearchPhone 2Phone_NumberString14
94FAX SearchFaxSTR14_FAXString14
95PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
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$Currency11
97DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer5
98DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency17
99DISCDATE SearchDiscount DateDTDate8
100DUEDATE SearchDue DateDTDate8
101TRDPCTPR SearchTrade Discount Percent (Precise)Trade Discount Percent (Precise)Currency (Variable)23
102CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_U0Integer4
104CREATDDT SearchCreated DateDTDate8
105MODIFDT SearchModified DateDTDate8
106PONOTIDS_1 SearchPO Note ID Array[1]DLR14Currency14
107PONOTIDS_2 SearchPO Note ID Array[2]DLR14Currency14
108PONOTIDS_3 SearchPO Note ID Array[3]DLR14Currency14
109PONOTIDS_4 SearchPO Note ID Array[4]DLR14Currency14
110PONOTIDS_5 SearchPO Note ID Array[5]DLR14Currency14
111PONOTIDS_6 SearchPO Note ID Array[6]DLR14Currency14
112PONOTIDS_7 SearchPO Note ID Array[7]DLR14Currency14
113PONOTIDS_8 SearchPO Note ID Array[8]DLR14Currency14
114PONOTIDS_9 SearchPO Note ID Array[9]DLR14Currency14
115PONOTIDS_10 SearchPO Note ID Array[10]DLR14Currency14
116PONOTIDS_11 SearchPO Note ID Array[11]DLR14Currency14
117PONOTIDS_12 SearchPO Note ID Array[12]DLR14Currency14
118PONOTIDS_13 SearchPO Note ID Array[13]DLR14Currency14
119PONOTIDS_14 SearchPO Note ID Array[14]DLR14Currency14
120PONOTIDS_15 SearchPO Note ID Array[15]DLR14Currency14
121COMMENT_1 SearchComment[1]STR50String50
122COMMENT_2 SearchComment[2]STR50String50
123COMMENT_3 SearchComment[3]STR50String50
124COMMENT_4 SearchComment[4]STR50String50
125CANCSUB SearchCanceled SubtotalDLR17_RBS0_STR$Currency17
126RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
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_IDString15
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_DateDate6
129TIME1 SearchTimeTM6Time6
130MCTRXSTT SearchMC Transaction StateINT1Integer1
131OREMSUBT SearchOriginating Remaining SubtotalDLR17_RBS0_UTR$Currency17
132ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency17
133Originating_Canceled_Sub SearchOriginating Canceled SubtotalDLR17_RBS0_STR$Currency17
134ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
135ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
136OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency17
137ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
138ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
139ODISAMTAV SearchOriginating Discount Amount AvailableDLR17_RBS0_UTR$Currency17
140BUYERID SearchBuyer IDSTR15_User_IDString15
141ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency19
142ORORDAMT SearchOriginating On Order AmountDLR19_RBS0_UTR$Currency19
143HOLD SearchHoldCB_HoldBoolean0
144ONHOLDDATE SearchOn Hold DateDTDate8
145ONHOLDBY SearchOn Hold BySTR15_User_IDString15
146HOLDREMOVEDATE SearchHold Remove DateDTDate8
147HOLDREMOVEBY SearchHold Remove BySTR15_User_IDString15
148ALLOWSOCMTS SearchAllow SO CommitmentsCB_AllowSOCommitmentsBoolean0
149NOTEINDX SearchNote IndexDLR14Currency14
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 NameSTR15String15
151ITEMTYPE SearchItem TypeDDL_Item_TypeInteger0
152ITMGEDSC SearchItem Generic DescriptionSTR10String10
153STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency17
154CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency17
155LISTPRCE SearchList PriceDLR17_RBS0_STR$Currency17
156ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer6
157ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString15
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_OptionsInteger0
159COMMCODE SearchCommission CodeSTR15_LBAUString15
160IVIVINDX SearchIV IV IndexLI_14Long Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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_IDString10
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_TypeString10
176KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
177KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
178KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
179KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean0
180ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean0
181VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger0
182UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
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_NumberString30
184ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString30
185USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString10
186USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString10
187USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString10
188USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString10
189USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString10
190USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString10
191MSTRCDTY SearchMaster Record TypeINT1Integer1
192WRNTYDYS SearchWarranty DaysINT4Integer4
193PRCLEVEL SearchPriceLevelSTR10_LBAUString10
194VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString64
195VENDSHNM SearchVendor Short NameSTR15String15
196VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString15
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_CodeString15
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_CodeString15
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_IDString10
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 ContactSTR60String60
201UPSZONE SearchUPS ZoneSTR3String3
202TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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 VendorSTR20String20
204TXIDNMBR SearchTax ID NumberTax_ID_NumberString11
205VENDSTTS SearchVendor StatusDDL_Vendor_StatusInteger0
206PARVENID SearchParent Vendor IDSTR_15_Vendor_IDString15
207TRDDISCT SearchTrade DiscountINT4_%2Integer4
208TEN99TYPE Search1099 Type1099_TypeInteger0
209MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger0
210MINPYPCT SearchMinimum Payment PercentINT5_%2Integer5
211MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency17
212MXIAFVND SearchMaximum Invoice Amount For VendorsGBInteger0
213MAXINDLR SearchMaximum Invoice DollarDLR17_$U2Currency17
214COMMENT1 SearchComment1STR30String30
215COMMENT2 SearchComment2STR30String30
216USERDEF1 SearchUser Defined 1STR20String20
217USERDEF2 SearchUser Defined 2STR20String20
218CRLMTDLR SearchCredit Limit DollarDLR17_$U2Currency17
219PYMNTPRI SearchPayment PrioritySTR3String3
220KGLDSTHS SearchKeep GL Dist HistoryCB_Keep_GL_Dist_HistoryBoolean0
221PTCSHACF SearchPost To Cash Account FromGBInteger0
222CREDTLMT SearchCredit LimitGBInteger0
223WRITEOFF SearchWriteoffGBInteger0
224MXWOFAMT SearchMaximum Write Off AmountDLR17_$U2Currency17
225SBPPSDED SearchSubject To PPS DeductionsCB_Subject_To_PPS_DeductionsBoolean0
226PPSTAXRT SearchPPS Tax RateINT5_%2Integer5
227DXVARNUM SearchDeduction Exemption/Variation NumberSTR25String25
228CRTCOMDT SearchCertificate Commencing DateDTDate8
229CRTEXPDT SearchCertificate Expiration DateDTDate8
230RTOBUTKN SearchReporting Obligation UndertakenCB_Reporting_ObligationBoolean0
231XPDTOBLG SearchExpiration Date ObligationCB_Expiration_Date_ObligationBoolean0
232PRSPAYEE SearchPrescribed PayeeCB_Prescribed_PayeeBoolean0
233PMAPINDX SearchPM AP IndexLI_14Long Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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_IDString15
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 VendorBoolean0
248Post_Results_To SearchPost Results ToGBInteger0
249POSTATUS SearchPO StatusDDL_PO_StatusInteger0
250HIESTBAL SearchHighest BalanceDLR17_RBS0_UTR$Currency17
251CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency19
252NOINVYTD SearchNumber of Invoices YTDLI_9U0Long Integer9
253NOINVLIF SearchNumber of Invoices LIFELI_9U0Long Integer9
254NOINVLYR SearchNumber of Invoices LYRLI_9U0Long Integer9
255NOPINYTD SearchNumber of Paid Invoices YTDLI_9U0Long Integer9
256NOPILIFE SearchNumber of Paid Invoices LIFELI_9U0Long Integer9
257AMBLDTYD SearchAmount Billed YTDDLR19_RBS0_STR$Currency19
258AMBLDLIF SearchAmount Billed LIFEDLR19_RBS0_STR$Currency19
259AMBLDLYR SearchAmount Billed LYRDLR19_RBS0_STR$Currency19
260AMTPDYTD SearchAmount Paid YTDDLR19_RBS0_STR$Currency19
261AMTPDLIF SearchAmount Paid LIFEDLR19_RBS0_STR$Currency19
262AMTPDLYR SearchAmount Paid LYRDLR19_RBS0_STR$Currency19
263TEN99AYTD Search1099 Amount YTDDLR19_RBS0_STR$Currency19
264TEN99ALIF Search1099 Amount LIFEDLR19_RBS0_STR$Currency19
265TEN99ALYR Search1099 Amount LYRDLR19_RBS0_STR$Currency19
266DISAVYTD SearchDiscount Available YTDDLR19_RBS0_STR$Currency19
267DISAVLIF SearchDiscount Available LIFEDLR19_RBS0_STR$Currency19
268DISAVLYR SearchDiscount Available LYRDLR19_RBS0_STR$Currency19
269DISTKYTD SearchDiscount Taken YTDDLR19_RBS0_STR$Currency19
270DISTKNLF SearchDiscount Taken LIFEDLR19_RBS0_STR$Currency19
271DISTKLYR SearchDiscount Taken LYRDLR19_RBS0_STR$Currency19
272DISLSYTD SearchDiscount Lost YTDDLR19_RBS0_STR$Currency19
273DISLSTLF SearchDiscount Lost LIFEDLR19_RBS0_STR$Currency19
274DISLSLYR SearchDiscount Lost LYRDLR19_RBS0_STR$Currency19
275FINCHLIF SearchFinance Charge LIFEDLR19_RBS0_STR$Currency19
276FINCHLYR SearchFinance Charge LYRDLR19_RBS0_STR$Currency19
277FINCHYTD SearchFinance Charge YTDDLR19_RBS0_STR$Currency19
278WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency19
279WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency19
280WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency19
281RTRNSYTD SearchReturns YTDDLR19_RBS0_STR$Currency19
282RTRNSLIF SearchReturns LIFEDLR19_RBS0_STR$Currency19
283RTRNSLYR SearchReturns LYRDLR19_RBS0_STR$Currency19
284TRDTKLIF SearchTrade Discounts Taken LIFEDLR19_RBSO_STR$Currency19
285TRDTLYR SearchTrade Discounts Taken LYRDLR19_RBSO_STR$Currency19
286TRDTYTD SearchTrade Discounts Taken YTDDLR19_RBSO_STR$Currency19
287NFNCHLIF SearchNumber of Finance Charges LIFELI_9U0Long Integer9
288NFNCHLYR SearchNumber of Finance Charges LYRLI_9U0Long Integer9
289NFNCHYTD SearchNumber of Finance Charges YTDLI_9U0Long Integer9
290RTNGOWED SearchRetainage OwedDLR17_RBS0_STR$Currency17
291LSTCHNUM SearchLast Check NumberCheck_NumberString20
292LSTCHKDT SearchLast Check DateDTDate8
293LSTCHAMT SearchLast Check AmountDLR17_RBS0_UTR$Currency17
294LSTINNUM SearchLast Invoice NumberSTR20String20
295LSTINVAM SearchLast Invoice AmountDLR17_RBS0_UTR$Currency17
296LSTPURDT SearchLast Purchase DateDTDate8
297FSTPURDT SearchFirst Purchase DateDTDate8
298CURUNPBN SearchCurrent Unapplied Payment BalanceDLR17_RBS0_UTR$Currency17
299UNPDFNCH SearchUnpaid Finance ChargesDLR17_RBS0_UTR$Currency17
300DYCHTCLR SearchDays Checks To ClearINT3_U0Integer3
301AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer3
302AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer3
303CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
304CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString15
305CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
306CNTCPRSN SearchContact PersonSTR60String60
307STMTNAME SearchStatement NameSTR64String64
308SHRTNAME SearchShort NameSTR15String15
309ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
310STADDRCD SearchStatement Address CodeSTR15_LBAUString15
311SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
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_TypeInteger0
313CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency17
314CRLMTPER SearchCredit Limit PeriodDDLInteger0
315CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency17
316CUSTDISC SearchCustomer DiscountINT5_%2Integer5
317FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger0
318FNCHPCNT SearchFinance Charge PercentINT5_%2Integer5
319FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency17
320MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger0
321MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency17
322TAXEXMT1 SearchTax Exempt 1STR25String25
323TAXEXMT2 SearchTax Exempt 2STR25String25
324BALNCTYP SearchBalance TypeGB_Bal_TypeInteger0
325STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger0
326BANKNAME SearchBank NameSTR30String30
327BNKBRNCH SearchBank BranchSTR20String20
328SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString15
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 TypeGBInteger0
330RMCSHACC SearchRM Cash Account IndexLI_14Long Integer14
331RMARACC SearchRM AR Account IndexLI_14Long Integer14
332RMSLSACC SearchRM Sales Account IndexLI_14Long Integer14
333RMIVACC SearchRM IV Account IndexLI_14Long Integer14
334RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer14
335RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer14
336RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer14
337RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer14
338RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer14
339FRSTINDT SearchFirst Invoice DateDT_DateDate6
340INACTIVE SearchInactiveCB_InactiveBoolean0
341CRCARDID SearchCredit Card IDSTR15String15
342CRCRDNUM SearchCredit Card NumberSTR20String20
343CCRDXPDT SearchCredit Card Exp DateDT_DateDate6
344Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean0
345FINCHID SearchFinance Charge IDSTR15_Charge_IDString15
346GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
347GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString30
348TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency19
349NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer6
350CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency19
351AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency17
352AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency17
353AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency17
354AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency17
355AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency17
356AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency17
357AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency17
358LASTAGED SearchLast AgedDATEDate6
359LSTNSFCD SearchLast NSF Check DateDT_DateDate6
360LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency17
361LASTPYDT SearchLast Payment DateDT_DateDate6
362LSTTRXDT SearchLast Transaction DateDT_DateDate6
363LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency17
364LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency19
365UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency17
366NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer10
367NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer10
368NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer10
369TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency19
370TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency19
371TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency19
372TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency19
373RETAINAG SearchRetainageDLR19_RBS0_STR$Currency19
374TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency19
375NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer6
376UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency19
377UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency19
378UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency19
379UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency19
380NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency19
381TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency19
382TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency19
383TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency19
384TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency19
385TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency19
386TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency19
387TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency19
388TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency19
389TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency19
390TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency19
391TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency19
392TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency19
393FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency19
394FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency19
395TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency19
396TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency19
397TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency19
398TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency19
399TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency19
400TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency19
401TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency19
402TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency19
403TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency19
404TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer6
405TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer6
406TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer6
407TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer6
408TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer6
409TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer6
410HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency19
411HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency19
412HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency19
413LASTSTDT SearchLast Statement DateDATEDate6
414LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency17
415DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency19
416ABCCODE SearchABC CodeDDL_ABC_CodeInteger0
417CGSINFLX SearchCOGS Inflation IndexLI_14Long Integer14
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 Integer14
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 Integer14
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 Integer14
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 CodeSTR15String15
422KTACCTSR SearchKit COGS Account SourceGBInteger0
423LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString20
424PriceGroup SearchPrice GroupSTR10_LBAUString10
425PRICMTHD SearchPrice MethodDDL_Price_MethodInteger0
426PINFLIDX SearchPurch Inflation IndexLI_14Long Integer14
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 Integer14
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_MString8
429SELNGUOM SearchSelling U Of MU_Of_MString8
430TCC SearchTax Commodity CodeSTR30_VATString30
431UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer14
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_U0Integer2
433DOCFMTID SearchDocument Format IDSTR15_LBUString15
434DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
435PHONE3 SearchPhone 3Phone_Number3String14
436TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean0
437Withholding_LIFE SearchWithholding LIFEDLR19_RBS0_STR$Currency19
438WITHLYR SearchWithholding LYRDLR19_RBS0_STR$Currency19
439WITHYTD SearchWithholding YTDDLR19_RBS0_STR$Currency19
440Change_Order_Flag SearchChange Order FlagINTInteger0
441PO_Field_Changes SearchPO Field ChangesML_POP_PO_Field_ChangesLong Integer0
442PO_Status_Orig SearchPO Status OrigDDL_PO_StatusInteger0
443Revision_Number SearchRevision NumberINT4Integer4
444LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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_LDate0
446Released_Date SearchReleased DateDATE_LDate0
447UPSZONE1 SearchASI_UPS_ZoneSTR3String3
448SHIPMTHD1 SearchASI_Shipping_MethodSTR15_Shipping_MethodString15
449TAXSCHID1 SearchASI_Tax_Schedule_IDSTR15_Tax_Schedule_IDString15
450ADDRESS11 SearchASI_Address_1STR60String60
451ADDRESS21 SearchASI_Address_2STR60String60
452ADDRESS31 SearchASI_Address_3STR60String60
453CITY1 SearchASI_CitySTR35String35
454STATE1 SearchASI_StateSTR30_StateString29
455COUNTRY1 SearchASI_CountrySTR60String60
456ZIP1 SearchASI_ZipSTR10String10
457PHONE11 SearchASI_Phone_1Phone_NumberString14
458PHONE21 SearchASI_Phone_2Phone_NumberString14
459FAX1 SearchASI_FaxSTR14_FAXString14
460PRBTADCD1 SearchASI_Primary_Billto_Address_CodeSTR15_LBAUString15
461PRSTADCD1 SearchASI_Primary_Shipto_Address_CodeSTR15_LBAUString15
462CHEKBKID1 SearchASI_Checkbook_IDSTR15_Checkbook_IDString15
463PYMTRMID1 SearchASI_Payment_Terms_IDSTR20_Payment_Terms_IDString20
464CURNCYID1 SearchASI_Currency_IDSTR15_Currency_IDString15
465RATETPID1 SearchASI_Rate_Type_IDSTR15_Rate_Type_IDString15
466ASI_Minimum_Payment_Type SearchASI_Minimum_Payment_TypeASI_Minimum_Payment_TypeInteger0
467MINPYDLR1 SearchASI_Minimum_Payment_DollarDLR17_RBS0_UTR$Currency17
468MINPYPCT1 SearchASI_Minimum_Payment_PercentINT5_%2Integer5
469COMMENT11 SearchASI_Comment1STR30String30
470COMMENT21 SearchASI_Comment2STR30String30
471USERDEF11 SearchASI_User_Defined_1STR20String20
472USERDEF21 SearchASI_User_Defined_2STR20String20
473TXRGNNUM1 SearchASI_Tax_Registration_NumberSTR25String25
474HOLD1 SearchASI_HoldCB_HoldBoolean0
475KPDSTHST1 SearchASI_Keep_Distribution_HistoryCB_Keep_Dist_HistoryBoolean0
476KPCALHST1 SearchASI_Keep_Calendar_HistoryCB_Keep_Calendar_HistoryBoolean0
477KPERHIST1 SearchASI_Keep_Period_HistoryCB_Keep_Period_HistoryBoolean0
478KPTRXHST1 SearchASI_Keep_Trx_HistoryCB_Keep_Trx_HistoryBoolean0
479NOTEINDX1 SearchASI_Note_IndexDLR14Currency14
480CREATDDT1 SearchASI_Created_DateDTDate8
481MODIFDT1 SearchASI_Modified_DateDTDate8
482FRSTINDT1 SearchASI_First_Invoice_DateDT_DateDate6
483AVDTPLIF1 SearchASI_Average_Days_To_Pay_LifeINT3_U0Integer3
484AVDTPLYR1 SearchASI_Average_Days_to_Pay_LYRINT3_U0Integer3
485AVGDTPYR1 SearchASI_Average_Days_To_Pay_YearINT3_U0Integer3
486WROFSLIF1 SearchASI_Write_Offs_LIFEDLR19_RBS0_STR$Currency19
487WROFSLYR1 SearchASI_Write_Offs_LYRDLR19_RBS0_STR$Currency19
488WROFSYTD1 SearchASI_Write_Offs_YTDDLR19_RBS0_STR$Currency19
489ONORDAMT1 SearchASI_On_Order_AmountDLR19_RBS0_UTR$Currency19
490ASI_Post_Results_To SearchASI_Post_Results_ToASI_Post_Results_ToInteger0
491DISGRPER1 SearchASI_Discount_Grace_PeriodINT2_U0Integer2
492DOCFMTID1 SearchASI_Document_Format_IDSTR15_LBUString15
493DUEGRPER1 SearchASI_Due_Date_Grace_PeriodINT2_U0Integer2
494PHONE31 SearchASI_Phone_3Phone_NumberString14
495ITEMDESC1 SearchASI_Item_DescriptionSTR50String50
496NOTEINDX11 SearchASI_Note_Index2DLR14Currency14
497DECPLQTY1 SearchASI_Decimal_Places_QTYSDDL_Decimal_Places_QTYSInteger0
498DECPLCUR1 SearchASI_Decimal_Places_CurrencyDDL_Decimal_Places_DollarsInteger0
499ITMTRKOP1 SearchASI_Item_Tracking_OptionDDL_TrackInteger0
500VCTNMTHD1 SearchASI_Valuation_MethodDDL_Valuation_MethodInteger0
501MODIFDT11 SearchASI_Modified_Date2DTDate8
502CREATDDT11 SearchASI_Created_Date2DTDate8
503PRCLEVEL1 SearchASI_PriceLevelSTR10_LBAUString10
504PRMDATE1 SearchASI_Promised_DateDATE_LDate0
505PRMSHPDTE1 SearchASI_Promised_Ship_DateDATE_LDate0
506LOCNCODE1 SearchASI_Location_CodeSTR10_Location_CodeString10
507COMMNTID1 SearchASI_Comment_IDSTR15_Comment_IDString15
508CURNCYID11 SearchASI_Currency_ID2STR15_Currency_IDString15
509ASI_Currency_Index SearchASI_Currency_IndexINT3Integer3
510XCHGRATE1 SearchASI_Exchange_RateDLR14_Exchange_RateCurrency (Variable)14
511RATECALC1 SearchASI_Rate_Calc_MethodINTInteger0
512DENXRATE1 SearchASI_Denomination_Exchange_RateDLR14_Exchange_RateCurrency (Variable)14
513Change_Order_Flag1 SearchASI_Change_Order_FlagBooleanBoolean0
514VENDNAME1 SearchASI_Vendor_NameSTR64_Vendor_NameString64
515VADCDPAD1 SearchASI_Vendor_Address_Code_Purchase_AddressSTR15_Address_CodeString15
516ADDRESS111 SearchASI_Address_12STR60String60
517ADDRESS211 SearchASI_Address_22STR60String60
518ADDRESS311 SearchASI_Address_32STR60String60
519CITY11 SearchASI_City2STR35String35
520STATE11 SearchASI_State2STR30_StateString29
521ZIPCODE1 SearchASI_Zip_CodeSTR10String10
522COUNTRY11 SearchASI_Country2STR60String60
523PHNUMBR11 SearchASI_Phone_Number_1Phone_NumberString14
524PHNUMBR21 SearchASI_Phone_Number_2Phone_NumberString14
525FAXNUMBR1 SearchASI_Fax_NumberSTR14_FAXString14
526SHIPMTHD11 SearchASI_Shipping_Method2STR15_Shipping_MethodString15
527CURNCYID111 SearchASI_Currency_ID3STR15_Currency_IDString15
528TXRGNNUM11 SearchASI_Tax_Registration_Number2STR25String25
529MINORDER1 SearchASI_Minimum_OrderDLR17_$U2Currency17
530PYMTRMID11 SearchASI_Payment_Terms_ID2STR20_Payment_Terms_IDString20
531COMMENT111 SearchASI_Comment12STR30String30
532COMMENT211 SearchASI_Comment22STR30String30
533KPCALHST11 SearchASI_Keep_Calendar_History2CB_Keep_Calendar_HistoryBoolean0
534KPERHIST11 SearchASI_Keep_Period_History2CB_Keep_Period_HistoryBoolean0
535KPTRXHST11 SearchASI_Keep_Trx_History2CB_Keep_Trx_HistoryBoolean0
536HOLD11 SearchASI_Hold2CB_HoldBoolean0
537PURPVIDX1 SearchASI_Purchase_Price_Variance_IndexLI_14Long Integer14
538NOTEINDX111 SearchASI_Note_Index3DLR14Currency14
539MODIFDT111 SearchASI_Modified_Date3DTDate8
540CREATDDT111 SearchASI_Created_Date3DTDate8
541RATETPID11 SearchASI_Rate_Type_ID2STR15_Rate_Type_IDString15
542FREEONBOARD1 SearchASI_Free_On_BoardDDL_Free_On_BoardInteger0
543DISGRPER11 SearchASI_Discount_Grace_Period2INT2_U0Integer2
544DUEGRPER11 SearchASI_Due_Date_Grace_Period2INT2_U0Integer2
545GOVCRPID1 SearchASI_Governmental_Corporate_IDSTR30_Gov_Corp_IDString30
546GOVINDID1 SearchASI_Governmental_Individual_IDSTR30_Gov_Indiv_IDString30
547PHONE311 SearchASI_Phone_32Phone_NumberString14
548ONORDAMT11 SearchASI_On_Order_Amount2DLR19_RBS0_UTR$Currency19
549ASI_Required_Date SearchASI_Required_DateDATE_LDate0
550LOCNCODE11 SearchASI_Location_Code2STR10_Location_CodeString10
551TRXSORCE SearchTRX SourceSTR13String13
552Purchase_IV_Item_Taxable SearchPurchase IV Item TaxableDDL_Purchase_Tax_OptionsInteger0
553Purchase_Item_Tax_Schedu SearchPurchase Item Tax Schedule IDSTR15_LBAUString15
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_LBAUString15
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 TotalYNBoolean0
556TAXAMNT1 SearchASI_Tax_AmountDLR17_RBS0_UTR$Currency17
557ORTAXAMT1 SearchASI_Originating_Tax_AmountDLR17_RBS0_UTR$Currency17
558Landed_Cost_Group_ID SearchLanded Cost Group IDSTR15_LBAUString15
559PLNNDSPPLID SearchPlanned Supply IDINTInteger0
560ASISHIPMTHD3 SearchASI_Shipping_Method3STR15_Shipping_MethodString15
561ORIGPRMDATE SearchOriginal Promised DateDTDate8
562FSTRCPTDT SearchFirst Receipt DateDTDate8
563LSTRCPTDT SearchLast Receipt DateDTDate8
564CNTRLEXTQTY SearchControl Line Ext QtyDLR17_QTY_RBS0_UTRCurrency17
565CNTRLEXTCOST SearchControl Line Ext CostDLR17_RBS0_UTR$Currency17
566REMAINEXTQTY SearchRemaining Ext QtyDLR17_QTY_RBS0_UTRCurrency17
567ASI_Address_Code SearchASI_Address_CodeSTR15_Address_CodeString15
568CMPNYNAM1 SearchASI_Company_NameSTR64_Company_NameString64
569CONTACT1 SearchASI_ContactSTR60String60
570ADDRESS1111 SearchASI_Address_13STR60String60
571ADDRESS2111 SearchASI_Address_23STR60String60
572ADDRESS3111 SearchASI_Address_33STR60String60
573CITY3 SearchASI_City3STR35String35
574STATE3 SearchASI_State3STR30_StateString29
575ZIP3 SearchASI_Zip3STR10String10
576COUNTRY3 SearchASI_Country3STR60String60
577PHONE1111 SearchASI_Phone_13Phone_NumberString14
578PHONE2111 SearchASI_Phone_23Phone_NumberString14
579PHONE3111 SearchASI_Phone_33Phone_NumberString14
580FAX3 SearchASI_Fax3STR14_FAXString14
581ADDRSOURCE SearchAddress SourceINT1Integer1
582PURCHSITETXSCHSRC SearchPurchase Site Tax Schedule SourceINT1Integer1
583UMSCHDSC SearchU Of M Schedule DescriptionSTR30String30
584QTYSHPPD SearchQTY ShippedDLR17_QTY_RBS0_UTRCurrency17
585QTYINVCD SearchQTY InvoicedDLR17_QTY_RBS0_UTRCurrency17
586QTYREJ SearchQTY RejectedDLR17_QTY_RBS0_UTRCurrency17
587QTYMATCH SearchQTY MatchedDLR17_QTY_RBS0_UTRCurrency17
588ProjNum SearchProject NumberSTR15_LBAUString15
589CostCatID SearchCost Category IDSTR15_LBAUString15
590Total_Landed_Cost_Amount SearchTotal Landed Cost AmountDLR17_RBS0_UTR$Currency17
591QTYINVRESERVE SearchQTY Invoice ReserveDLR17_QTY_RBS0_UTRCurrency17
592QTYRESERVED SearchQTY ReservedDLR17_QTY_RBS0_UTRCurrency17
azurecurveProductsSmartList (1493)PathnameSmartList Purchasing Line Items (ASIEXP21)

Leave a Reply

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