ASI SOP Line Item SmartList (ASIEXP20)

azurecurveProductsSmartList (1493)PathnameASI SOP Line Item SmartList (ASIEXP20)

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

Product: SmartList (1493)
Series:

Display Name: ASI SOP Line Item SmartList
Physical Name: ASIEXP20
Technical Name: ASI_SOP_LINE_Items_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
2ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
3SOPTYPE SearchSOP TypeIntegerDDL_SOP_Type0
4SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17
5LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
6CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
7ASI_Document_Status SearchASI_Document_StatusIntegerINT0
8ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].ITEMNMBR AS 'ASI SOP Line Item SmartList-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['ASI SOP Line Item SmartList'].ITEMNMBR = ['Item Master'].ITEMNMBR
9ITEMDESC SearchItem DescriptionStringSTR100100
10NONINVEN SearchNon IVIntegerINT11
11DROPSHIP SearchDrop ShipIntegerINT22
12UOFM SearchU Of MStringU_Of_M8
13LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].LOCNCODE AS 'ASI SOP Line Item SmartList-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['ASI SOP Line Item SmartList'].LOCNCODE = ['Site Setup'].LOCNCODE
14UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
15ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
16UNITPRCE SearchUnit PriceCurrencyDLR17_RBS0_STR$17
17ORUNTPRC SearchOriginating Unit PriceCurrencyDLR17_RBS0_STR$17
18XTNDPRCE SearchExtended PriceCurrencyDLR17_RBS0_STR$17
19OXTNDPRC SearchOriginating Extended PriceCurrencyDLR17_RBS0_STR$17
20REMPRICE SearchRemaining PriceCurrencyDLR17_RBS0_UTR$17
21OREPRICE SearchOriginating Remaining PriceCurrencyDLR17_RBS0_UTR$17
22EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
23OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
24MRKDNAMT SearchMarkdown AmountCurrencyDLR17_RBS0_UTR$17
25ORMRKDAM SearchOriginating Markdown AmountCurrencyDLR17_RBS0_UTR$17
26MRKDNPCT SearchMarkdown PercentIntegerINT5_%25
27MRKDNTYP SearchMarkdown TypeIntegerGB0
28INVINDX SearchInventory IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].INVINDX AS 'ASI SOP Line Item SmartList-Inventory Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].INVINDX = ['Account Index Master'].ACTINDX
29CSLSINDX SearchCost Of Sales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].CSLSINDX AS 'ASI SOP Line Item SmartList-Cost Of Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].CSLSINDX = ['Account Index Master'].ACTINDX
30SLSINDX SearchSales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].SLSINDX AS 'ASI SOP Line Item SmartList-Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].SLSINDX = ['Account Index Master'].ACTINDX
31MKDNINDX SearchMarkdown IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].MKDNINDX AS 'ASI SOP Line Item SmartList-Markdown Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].MKDNINDX = ['Account Index Master'].ACTINDX
32RTNSINDX SearchReturns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].RTNSINDX AS 'ASI SOP Line Item SmartList-Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].RTNSINDX = ['Account Index Master'].ACTINDX
33INUSINDX SearchIn Use IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].INUSINDX AS 'ASI SOP Line Item SmartList-In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].INUSINDX = ['Account Index Master'].ACTINDX
34INSRINDX SearchIn Service IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].INSRINDX AS 'ASI SOP Line Item SmartList-In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].INSRINDX = ['Account Index Master'].ACTINDX
35DMGDINDX SearchDamaged IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].DMGDINDX AS 'ASI SOP Line Item SmartList-Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].DMGDINDX = ['Account Index Master'].ACTINDX
36ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].ITMTSHID AS 'ASI SOP Line Item SmartList-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['ASI SOP Line Item SmartList'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
37IVITMTXB SearchIV Item TaxableIntegerDDL_Tax_Options0
38BKTSLSAM SearchBackout Sales AmountCurrencyDLR19_RBS0_UTR$19
39ORBKTSLS SearchOriginating Backout Sales AmountCurrencyDLR19_RBS0_UTR$19
40TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
41ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
42TXBTXAMT SearchTaxable Tax AmountCurrencyDLR19_RBSO_UTR$19
43OTAXTAMT SearchOriginating Taxable Tax AmountCurrencyDLR17_RBS0_UTR$17
44BSIVCTTL SearchBased On Invoice TotalBooleanYN0
45TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
46ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
47DISCSALE SearchDiscount Available SalesCurrencyDLR17_RBS0_UTR$17
48ORDAVSLS SearchOriginating Discount Available SalesCurrencyDLR17_RBS0_UTR$17
49QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
50ATYALLOC SearchQTY AllocatedCurrencyDLR17_QTY_RBS0_UTR17
51QTYINSVC SearchQTY In ServiceCurrencyDLR17_QTY_RBS0_UTR17
52QTYINUSE SearchQTY In UseCurrencyDLR17_QTY_RBS0_UTR17
53QTYDMGED SearchQTY DamagedCurrencyDLR17_QTY_RBS0_UTR17
54QTYRTRND SearchQTY ReturnedCurrencyDLR17_QTY_RBS0_UTR17
55QTYONHND SearchQTY On HandCurrencyDLR17_QTY_RBS0_STR17
56QTYCANCE SearchQTY CanceledCurrencyDLR17_QTY_RBS0_UTR17
57QTYCANOT SearchQTY Canceled OtherCurrencyDLR17_QTY_RBS0_UTR17
58QTYORDER SearchQTY OrderedCurrencyDLR17_QTY_RBS0_UTR17
59QTYPRBAC SearchQTY Prev Back OrderedCurrencyDLR17_QTY_RBS0_UTR17
60QTYPRBOO SearchQTY Prev BO On OrderCurrencyDLR17_QTY_RBS0_UTR17
61QTYPRINV SearchQTY Prev InvoicedCurrencyDLR17_QTY_RBS0_UTR17
62QTYPRORD SearchQTY Prev OrderedCurrencyDLR17_QTY_RBS0_UTR17
63QTYREMAI SearchQTY RemainingCurrencyDLR17_QTY_RBS0_UTR17
64QTYREMBO SearchQTY Remaining On BOCurrencyDLR17_QTY_RBS0_UTR17
65QTYTBAOR SearchQTY To Back OrderCurrencyDLR17_QTY_RBS0_UTR17
66QTYTOINV SearchQTY To InvoiceCurrencyDLR17_QTY_RBS0_UTR17
67QTYTORDR SearchQTY To OrderCurrencyDLR17_QTY_RBS0_UTR17
68QTYFULFI SearchQTY FulfilledCurrencyDLR17_QTY_RBS0_UTR17
69QTYSLCTD SearchQTY SelectedCurrencyDLR17_QTY_RBS0_UTR17
70QTYBSUOM SearchQTY In Base U Of MCurrencyDLR17_QTY_RBS0_STR17
71EXTQTYAL SearchExisting Qty AvailableCurrencyDLR17_RBS0_UTR$17
72EXTQTYSEL SearchExisting Qty SelectedCurrencyDLR17_QTY_RBS0_STR17
73ReqShipDate SearchRequested Ship DateDateDT8
74FUFILDAT SearchFulfillment DateDateDT8
75ACTLSHIP SearchActual Ship DateDateDT8
76SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].SHIPMTHD AS 'ASI SOP Line Item SmartList-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['ASI SOP Line Item SmartList'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
77SALSTERR SearchSales TerritoryStringSTR15_Sales_Territory15
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].SALSTERR AS 'ASI SOP Line Item SmartList-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['ASI SOP Line Item SmartList'].SALSTERR = ['Sales Territory Master File'].SALSTERR
78SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].SLPRSNID AS 'ASI SOP Line Item SmartList-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['ASI SOP Line Item SmartList'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
79PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
80COMMNTID SearchComment IDStringSTR15_Comment_ID15
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].COMMNTID AS 'ASI SOP Line Item SmartList-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['ASI SOP Line Item SmartList'].COMMNTID = ['Comment Master'].COMMNTID
81BRKFLD1 SearchBreak Field 1IntegerINT11
82BRKFLD2 SearchBreak Field 2IntegerINT11
83BRKFLD3 SearchBreak Field 3IntegerINT11
84CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].CURRNIDX AS 'ASI SOP Line Item SmartList-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['ASI SOP Line Item SmartList'].CURRNIDX = ['Currency Setup'].CURRNIDX
85TRXSORCE SearchTRX SourceStringSTR1313
86SOPLNERR SearchSOP LINE ErrorsLong IntegerML_SOP_LINE_Errors0
87PURCHSTAT SearchPurchasing StatusIntegerDDL_PurchasingStatus0
88QTYONPO SearchQTY On POCurrencyDLR17_QTY_RBS0_UTR17
89QTYRECVD SearchQTY ReceivedCurrencyDLR17_QTY_RBS0_UTR17
90QTYPRVRECVD SearchQTY Prev ReceivedCurrencyDLR17_QTY_RBS0_UTR17
91ORIGTYPE SearchOriginal TypeIntegerDDL_SOP_Type0
92DOCID SearchDocument IDStringSTR15_LBAU15
93DOCDATE SearchDocument DateDateDT8
94GLPOSTDT SearchGL Posting DateDateDT8
95QUOTEDAT SearchQuote DateDateDT8
96QUOEXPDA SearchQuote Expiration DateDateDT8
97ORDRDATE SearchOrder DateDateDT8
98INVODATE SearchInvoice DateDateDT8
99BACKDATE SearchBack Order DateDateDT8
100RETUDATE SearchReturn DateDateDT8
101DISCDATE SearchDiscount DateDateDT8
102DUEDATE SearchDue DateDateDT8
103REPTING SearchRepeatingBooleanCB_Repeating0
104TRXFREQU SearchTRX FrequencyIntegerDDL_TRX_Frequency0
105TIMEREPD SearchTimes RepeatedIntegerINT4_U04
106DYSTINCR SearchDays to IncrementIntegerINT3_RB0_U3
107DTLSTREP SearchDate Last RepeatedDateDT8
108DSTBTCH1 SearchDest Batch 1StringSTR15_LBAU15
109DSTBTCH2 SearchDest Batch 2StringSTR15_LBAU15
110USDOCID1 SearchUse Document ID 1StringSTR15_LBAU15
111USDOCID2 SearchUse Document ID 2StringSTR15_LBAU15
112DISCFRGT SearchDiscount Available FreightCurrencyDLR17_RBS0_UTR$17
113ORDAVFRT SearchOriginating Discount Available FreightCurrencyDLR17_RBS0_UTR$17
114DISCMISC SearchDiscount Available MiscCurrencyDLR17_RBS0_UTR$17
115ORDAVMSC SearchOriginating Discount Available MiscCurrencyDLR17_RBS0_UTR$17
116DISAVAMT SearchDiscount Available AmountCurrencyDLR17_RBS0_UTR$17
117ORDAVAMT SearchOriginating Discount Available AmountCurrencyDLR17_RBS0_UTR$17
118DISCRTND SearchDiscount ReturnedCurrencyDLR17_RBS0_STR$17
119ORDISRTD SearchOriginating Discount ReturnedCurrencyDLR17_RBS0_STR$17
120DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
121ORDISTKN SearchOriginating Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
122DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
123DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
124ORDATKN SearchOriginating Discount Available TakenCurrencyDLR17_RBS0_UTR$17
125PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].PYMTRMID AS 'ASI SOP Line Item SmartList-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['ASI SOP Line Item SmartList'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
126BCHSOURC SearchBatch SourceStringSTR1515
127BACHNUMB SearchBatch NumberStringSTR15_LBAU15
128CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].CUSTNMBR AS 'ASI SOP Line Item SmartList-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['ASI SOP Line Item SmartList'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
129CUSTNAME SearchCustomer NameStringSTR64_Customer_Name64
130CSTPONBR SearchCustomer PO NumberStringSTR20_Document_Number20
131PROSPECT SearchProspectIntegerINT11
132MSTRNUMB SearchMaster NumberLong IntegerLI_MasterNumber9
133PCKSLPNO SearchPacking Slip NumberStringSTR20_IVC_Document_Number17
134PICTICNU SearchPicking Ticket NumberStringSTR20_SOP_Number17
135PRBTADCD SearchPrimary Billto Address CodeStringSTR15_LBAU15
136PRSTADCD SearchPrimary Shipto Address CodeStringSTR15_LBAU15
137CNTCPRSN SearchContact PersonStringSTR6060
138ShipToName SearchShipToNameStringSTR64_Customer_Name64
139ADDRESS1 SearchAddress 1StringSTR6060
140ADDRESS2 SearchAddress 2StringSTR6060
141ADDRESS3 SearchAddress 3StringSTR6060
142CITY SearchCityStringSTR3535
143STATE SearchStateStringSTR30_State29
144ZIPCODE SearchZip CodeStringSTR1010
145COUNTRY SearchCountryStringSTR6060
146PHNUMBR1 SearchPhone Number 1StringPhone_Number14
147PHNUMBR2 SearchPhone Number 2StringPhone_Number14
148FAXNUMBR SearchFax NumberStringSTR14_FAX14
149COMAPPTO SearchCommission Applied ToIntegerGB0
150COMMAMNT SearchCommission AmountCurrencyDLR17_RBS0_STR$17
151OCOMMAMT SearchOriginating Commission AmountCurrencyDLR17_RBSO_STR$17
152CMMSLAMT SearchCommission Sale AmountCurrencyDLR17_RBS0_STR$17
153ORCOSAMT SearchOriginating Commission Sales AmountCurrencyDLR17_RBS0_STR$17
154NCOMAMNT SearchNon-Commissioned AmountCurrencyDLR19_RBS0_STR$19
155ORNCMAMT SearchOriginating Non-Commissioned AmountCurrencyDLR19_RBS0_STR$19
156TRDISPCT SearchTrade Discount PercentIntegerINT4_%24
157SUBTOTAL SearchSubtotalCurrencyDLR17_RBS0_STR$17
158ORSUBTOT SearchOriginating SubtotalCurrencyDLR17_RBS0_STR$17
159REMSUBTO SearchRemaining SubtotalCurrencyDLR17_RBS0_UTR$17
160OREMSUBT SearchOriginating Remaining SubtotalCurrencyDLR17_RBS0_UTR$17
161FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
162ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
163MISCAMNT SearchMisc AmountCurrencyDLR17_RBS0_UTR$17
164ORMISCAMT SearchOriginating Misc AmountCurrencyDLR19_RBSO_UTR$19
165TXENGCLD SearchTax Engine CalledBooleanYN0
166TAXEXMT1 SearchTax Exempt 1StringSTR2525
167TAXEXMT2 SearchTax Exempt 2StringSTR2525
168TXRGNNUM SearchTax Registration NumberStringSTR2525
169TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].TAXSCHID AS 'ASI SOP Line Item SmartList-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['ASI SOP Line Item SmartList'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
170TXSCHSRC SearchTax Schedule SourceIntegerINT11
171FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].FRTSCHID AS 'ASI SOP Line Item SmartList-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['ASI SOP Line Item SmartList'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
172FRTTXAMT SearchFreight Tax AmountCurrencyDLR19_RBSO_UTR$19
173ORFRTTAX SearchOriginating Freight Tax AmountCurrencyDLR19_RBSO_UTR$19
174FRGTTXBL SearchFreight TaxableIntegerDDL_Tax_Options0
175MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].MSCSCHID AS 'ASI SOP Line Item SmartList-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['ASI SOP Line Item SmartList'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
176MSCTXAMT SearchMisc Tax AmountCurrencyDLR19_RBSO_UTR$19
177ORMSCTAX SearchOriginating Misc Tax AmountCurrencyDLR19_RBSO_UTR$19
178MISCTXBL SearchMisc TaxableIntegerDDL_Tax_Options0
179BKTFRTAM SearchBackout Freight AmountCurrencyDLR19_RBS0_UTR$19
180ORBKTFRT SearchOriginating Backout Freight AmountCurrencyDLR19_RBS0_UTR$19
181BKTMSCAM SearchBackout Misc AmountCurrencyDLR19_RBS0_UTR$19
182ORBKTMSC SearchOriginating Backout Misc AmountCurrencyDLR19_RBS0_UTR$19
183BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
184OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
185ECTRX SearchEC TransactionBooleanCB_EC_Transaction0
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.

Click to show/hide Document Printed flag


0	Not an EU Transaction.
1	EU Transaction.
186DOCAMNT SearchDocument AmountCurrencyDLR19_RBSO_UTR$19
187ORDOCAMT SearchOriginating Document AmountCurrencyDLR17_RBS0_STR$17
188PYMTRCVD SearchPayment ReceivedCurrencyDLR19_RBS0_UTR$19
189ORPMTRVD SearchOriginating Payment ReceivedCurrencyDLR19_RBS0_UTR$19
190DEPRECVD SearchDeposit ReceivedCurrencyDLR19_RBS0_UTR$19
191ORDEPRVD SearchOriginating Deposit ReceivedCurrencyDLR19_RBS0_UTR$19
192CODAMNT SearchCOD AmountCurrencyDLR17_RBS0_UTR$17
193ORCODAMT SearchOriginating COD AmountCurrencyDLR17_RBS0_UTR$17
194ACCTAMNT SearchAccount AmountCurrencyDLR19_RBS0_UTR$19
195ORACTAMT SearchOriginating Account AmountCurrencyDLR19_RBS0_UTR$19
196UPSZONE SearchUPS ZoneStringSTR33
197TIMESPRT SearchTimes PrintedIntegerINT4_U04
198PSTGSTUS SearchPosting StatusIntegerINT0
199VOIDSTTS SearchVoid StatusIntegerINT0
200ALLOCABY SearchAllocate ByIntegerDDL_Allocate_By0
201CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].CURNCYID AS 'ASI SOP Line Item SmartList-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['ASI SOP Line Item SmartList'].CURNCYID = ['Currency Setup'].CURNCYID
202RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].RATETPID AS 'ASI SOP Line Item SmartList-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['ASI SOP Line Item SmartList'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
203EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].EXGTBLID AS 'ASI SOP Line Item SmartList-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['ASI SOP Line Item SmartList'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
204XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
205DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
206EXCHDATE SearchExchange DateDateDT_Date6
207TIME1 SearchTimeTimeTM66
208RTCLCMTD SearchRate Calculation MethodIntegerGB0
209MCTRXSTT SearchMC Transaction StateIntegerINT11
210SOPHDRE1 SearchSOP HDR Errors 1Long IntegerML_SOP_HDR_Errors_10
211SOPHDRE2 SearchSOP HDR Errors 2Long IntegerML_SOP_HDR_Errors_20
212SOPHDRFL SearchSOP HDR FlagsLong IntegerML_SOP_HDR_Flags0
213REFRENCE SearchReferenceStringSTR3030
214POSTEDDT SearchPosted DateDateDATE6
215PTDUSRID SearchPosted User IDStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].PTDUSRID AS 'ASI SOP Line Item SmartList-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['ASI SOP Line Item SmartList'].PTDUSRID = ['Users Master'].USERID
216USER2ENT SearchUser To EnterStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].USER2ENT AS 'ASI SOP Line Item SmartList-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['ASI SOP Line Item SmartList'].USER2ENT = ['Users Master'].USERID
217CREATDDT SearchCreated DateDateDT8
218MODIFDT SearchModified DateDateDT8
219Tax_Date SearchTax DateDateDT8
220ITMSHNAM SearchItem Short NameStringSTR1515
221ITEMTYPE SearchItem TypeIntegerDDL_Item_Type0
222ITMGEDSC SearchItem Generic DescriptionStringSTR1010
223STNDCOST SearchStandard CostCurrencyDLR17_RBS0_UTR$17
224CURRCOST SearchCurrent CostCurrencyDLR17_RBS0_UTR$17
225LISTPRCE SearchList PriceCurrencyDLR17_RBS0_STR$17
226ITEMSHWT SearchItem Shipping WeightLong IntegerLI6_RBS2_UT6
227DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
228DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
229TAXOPTNS SearchTax OptionsIntegerDDL_Tax_Options0
230COMMCODE SearchCommission CodeStringSTR15_LBAU15
231IVIVINDX SearchIV IV IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVIVINDX AS 'ASI SOP Line Item SmartList-IV IV Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVIVINDX = ['Account Index Master'].ACTINDX
232IVIVOFIX SearchIV IV Offset IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVIVOFIX AS 'ASI SOP Line Item SmartList-IV IV Offset Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVIVOFIX = ['Account Index Master'].ACTINDX
233IVCOGSIX SearchIV COGS IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVCOGSIX AS 'ASI SOP Line Item SmartList-IV COGS Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVCOGSIX = ['Account Index Master'].ACTINDX
234IVSLSIDX SearchIV Sales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVSLSIDX AS 'ASI SOP Line Item SmartList-IV Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVSLSIDX = ['Account Index Master'].ACTINDX
235IVSLDSIX SearchIV Sales Discounts IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVSLDSIX AS 'ASI SOP Line Item SmartList-IV Sales Discounts Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVSLDSIX = ['Account Index Master'].ACTINDX
236IVSLRNIX SearchIV Sales Returns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVSLRNIX AS 'ASI SOP Line Item SmartList-IV Sales Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVSLRNIX = ['Account Index Master'].ACTINDX
237IVINUSIX SearchIV In Use IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVINUSIX AS 'ASI SOP Line Item SmartList-IV In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVINUSIX = ['Account Index Master'].ACTINDX
238IVINSVIX SearchIV In Service IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVINSVIX AS 'ASI SOP Line Item SmartList-IV In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVINSVIX = ['Account Index Master'].ACTINDX
239IVDMGIDX SearchIV Damaged IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVDMGIDX AS 'ASI SOP Line Item SmartList-IV Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVDMGIDX = ['Account Index Master'].ACTINDX
240IVVARIDX SearchIV Variances IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVVARIDX AS 'ASI SOP Line Item SmartList-IV Variances Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVVARIDX = ['Account Index Master'].ACTINDX
241DPSHPIDX SearchDrop Ship IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].DPSHPIDX AS 'ASI SOP Line Item SmartList-Drop Ship Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].DPSHPIDX = ['Account Index Master'].ACTINDX
242PURPVIDX SearchPurchase Price Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].PURPVIDX AS 'ASI SOP Line Item SmartList-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].PURPVIDX = ['Account Index Master'].ACTINDX
243IVRETIDX SearchInventory Returns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVRETIDX AS 'ASI SOP Line Item SmartList-Inventory Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVRETIDX = ['Account Index Master'].ACTINDX
244ASMVRIDX SearchAssembly Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

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

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].ITMCLSCD AS 'ASI SOP Line Item SmartList-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['ASI SOP Line Item SmartList'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
246ITMTRKOP SearchItem Tracking OptionIntegerDDL_Track0
247LOTTYPE SearchLot TypeStringSTR10_Lot_Type10
248KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
249KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
250KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
251KPDSTHST SearchKeep Distribution HistoryBooleanCB_Keep_Dist_History0
252ALWBKORD SearchAllow Back OrdersBooleanCB_Allow_Back_Orders0
253VCTNMTHD SearchValuation MethodIntegerDDL_Valuation_Method0
254UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].UOMSCHDL AS 'ASI SOP Line Item SmartList-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['ASI SOP Line Item SmartList'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
255ObjRef1 SearchObjRef1Invalid storage type 30Reference0
256ALTITEM1 SearchAlternate Item 1StringSTR30_Item_Number30
257ALTITEM2 SearchAlternate Item 2StringSTR30_Item_Number30
258USCATVLS_1 SearchUser Category Values[1]StringUser_Category_Value10
259USCATVLS_2 SearchUser Category Values[2]StringUser_Category_Value10
260USCATVLS_3 SearchUser Category Values[3]StringUser_Category_Value10
261USCATVLS_4 SearchUser Category Values[4]StringUser_Category_Value10
262USCATVLS_5 SearchUser Category Values[5]StringUser_Category_Value10
263USCATVLS_6 SearchUser Category Values[6]StringUser_Category_Value10
264MSTRCDTY SearchMaster Record TypeIntegerINT11
265WRNTYDYS SearchWarranty DaysIntegerINT44
266ORIGNUMB SearchOriginal NumberStringSTR20_SOP_Number17
267DISAVTKN SearchDiscount Available TakenCurrencyDLR17_RBS0_UTR$17
268TIMETREP SearchTimes To RepeatIntegerINT4_U04
269ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
270SOPMCERR SearchSOP MC Posting Error MessagesLong IntegerSOP MC Posting Error Messages0
271NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].NOTEINDX AS 'ASI SOP Line Item SmartList-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['ASI SOP Line Item SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX
272CUSTCLAS SearchCustomer ClassStringSTR15_Customer_Class15
273CPRCSTNM SearchCorporate Customer NumberStringSTR15_RM_Customer_Number15
274STMTNAME SearchStatement NameStringSTR6464
275ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
276STADDRCD SearchStatement Address CodeStringSTR15_LBAU15
277CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].CHEKBKID AS 'ASI SOP Line Item SmartList-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['ASI SOP Line Item SmartList'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
278CRLMTTYP SearchCredit Limit TypeIntegerGB_Amt_Type0
279CRLMTAMT SearchCredit Limit AmountCurrencyDLR17_RBS0_UTR$17
280CRLMTPER SearchCredit Limit PeriodIntegerDDL0
281CRLMTPAM SearchCredit Limit Period AmountCurrencyDLR17_RBS0_UTR$17
282CUSTDISC SearchCustomer DiscountIntegerINT5_%25
283SHRTNAME SearchShort NameStringSTR1515
284MINPYTYP SearchMinimum Payment TypeIntegerGB_Amt_Type0
285MINPYDLR SearchMinimum Payment DollarCurrencyDLR17_RBS0_UTR$17
286MINPYPCT SearchMinimum Payment PercentIntegerINT5_%25
287FNCHATYP SearchFinance Charge Amt TypeIntegerGB_Amt_Type0
288FNCHPCNT SearchFinance Charge PercentIntegerINT5_%25
289FINCHDLR SearchFinance Charge DollarCurrencyDLR17_RBS0_UTR$17
290MXWOFTYP SearchMaximum Writeoff TypeIntegerGP_Max_Writeoff0
291MXWROFAM SearchMax Writeoff AmountCurrencyDLR17_RBS0_UTR$17
292USERDEF1 SearchUser Defined 1StringSTR2020
293USERDEF2 SearchUser Defined 2StringSTR2020
294BALNCTYP SearchBalance TypeIntegerGB_Bal_Type0
295STMTCYCL SearchStatement CycleIntegerDDL_Stmt_Cycle0
296BANKNAME SearchBank NameStringSTR3030
297BNKBRNCH SearchBank BranchStringSTR2020
298DEFCACTY SearchDefault Cash Account TypeIntegerGB0
299RMCSHACC SearchRM Cash Account IndexLong IntegerLI_1414
300RMARACC SearchRM AR Account IndexLong IntegerLI_1414
301RMSLSACC SearchRM Sales Account IndexLong IntegerLI_1414
302RMIVACC SearchRM IV Account IndexLong IntegerLI_1414
303RMCOSACC SearchRM Cost Of Sales Account IndexLong IntegerLI_1414
304RMTAKACC SearchRM Discounts Taken Account IndexLong IntegerLI_1414
305RMAVACC SearchRM Discounts Avail Account IndexLong IntegerLI_1414
306RMFCGACC SearchRM Finance Charge Account IndexLong IntegerLI_1414
307RMWRACC SearchRM Writeoff Account IndexLong IntegerLI_1414
308FRSTINDT SearchFirst Invoice DateDateDT_Date6
309INACTIVE SearchInactiveBooleanCB_Inactive0
310HOLD SearchHoldBooleanCB_Hold0
311CRCARDID SearchCredit Card IDStringSTR1515
312CRCRDNUM SearchCredit Card NumberStringSTR2020
313CCRDXPDT SearchCredit Card Exp DateDateDT_Date6
314Revalue_Customer SearchRevalue CustomerBooleanCB Revalue Customer0
315Post_Results_To SearchPost Results ToIntegerGB0
316FINCHID SearchFinance Charge IDStringSTR15_Charge_ID15
317GOVCRPID SearchGovernmental Corporate IDStringSTR30_Gov_Corp_ID30
318GOVINDID SearchGovernmental Individual IDStringSTR30_Gov_Indiv_ID30
319TNSFCLIF SearchTotal Amount Of NSF Checks LifeCurrencyDLR19_RBS0_STR$19
320NONSFLIF SearchNumber Of NSF Checks LifeLong IntegerLI6_U06
321CUSTBLNC SearchCustomer BalanceCurrencyDLR19_RBS0_STR$19
322AGPERAMT_1 SearchAging Period Amounts[1]CurrencyDLR17_RBSO_STR$17
323AGPERAMT_2 SearchAging Period Amounts[2]CurrencyDLR17_RBSO_STR$17
324AGPERAMT_3 SearchAging Period Amounts[3]CurrencyDLR17_RBSO_STR$17
325AGPERAMT_4 SearchAging Period Amounts[4]CurrencyDLR17_RBSO_STR$17
326AGPERAMT_5 SearchAging Period Amounts[5]CurrencyDLR17_RBSO_STR$17
327AGPERAMT_6 SearchAging Period Amounts[6]CurrencyDLR17_RBSO_STR$17
328AGPERAMT_7 SearchAging Period Amounts[7]CurrencyDLR17_RBSO_STR$17
329LASTAGED SearchLast AgedDateDATE6
330LSTNSFCD SearchLast NSF Check DateDateDT_Date6
331LPYMTAMT SearchLast Payment AmountCurrencyDLR17_RBS0_STR$17
332LASTPYDT SearchLast Payment DateDateDT_Date6
333LSTTRXDT SearchLast Transaction DateDateDT_Date6
334LSTTRXAM SearchLast Transaction AmountCurrencyDLR17_RBS0_STR$17
335LSTFCHAM SearchLast Finance Charge AmountCurrencyDLR19_RBS0_STR$19
336UPFCHYTD SearchUnpaid Finance Charges YTDCurrencyDLR17_RBS0_UTR$17
337AVDTPLYR SearchAverage Days to Pay - LYRIntegerINT3_U03
338AVDTPLIF SearchAverage Days To Pay - LifeIntegerINT3_U03
339AVGDTPYR SearchAverage Days To Pay - YearIntegerINT3_U03
340NUMADTPL SearchNumber ADTP Documents - LifeLong IntegerLong_10U10
341NUMADTPR SearchNumber ADTP Documents - LYRLong IntegerLong_10U10
342NUMADTPY SearchNumber ADTP Documents - YearLong IntegerLong_10U10
343TDTKNLTD SearchTotal Discounts Taken LTDCurrencyDLR19_RBS0_STR$19
344TDTKNLYR SearchTotal Discounts Taken LYRCurrencyDLR19_RBS0_STR$19
345TDTKNYTD SearchTotal Discounts Taken YTDCurrencyDLR19_RBS0_STR$19
346TDISAYTD SearchTotal Discounts Available YTDCurrencyDLR19_RBS0_STR$19
347RETAINAG SearchRetainageCurrencyDLR19_RBS0_STR$19
348TNSFCYTD SearchTotal Amount Of NSF Checks YTDCurrencyDLR19_RBS0_STR$19
349NONSFYTD SearchNumber Of NSF Checks YTDLong IntegerLI6_U06
350UNPSTDSA SearchUnposted Sales AmountCurrencyDLR19_RBS0_UTR$19
351UNPSTDCA SearchUnposted Cash AmountCurrencyDLR19_RBS0_UTR$19
352UNPSTOSA SearchUnposted Other Sales AmountCurrencyDLR19_RBS0_UTR$19
353UNPSTOCA SearchUnposted Other Cash AmountCurrencyDLR19_RBS0_UTR$19
354NCSCHPMT SearchNon Current Scheduled PaymentsCurrencyDLR19_RBS0_STR$19
355TTLSLLTD SearchTotal Sales LTDCurrencyDLR19_RBS0_STR$19
356TTLSLLYR SearchTotal Sales LYRCurrencyDLR19_RBS0_STR$19
357TTLSLYTD SearchTotal Sales YTDCurrencyDLR19_RBS0_STR$19
358TCOSTLTD SearchTotal Costs LTDCurrencyDLR19_RBS0_STR$19
359TCOSTLYR SearchTotal Costs LYRCurrencyDLR19_RBS0_STR$19
360TCOSTYTD SearchTotal Costs YTDCurrencyDLR19_RBS0_STR$19
361TCSHRLTD SearchTotal Cash Received LTDCurrencyDLR19_RBS0_STR$19
362TCSHRLYR SearchTotal Cash Received LYRCurrencyDLR19_RBS0_STR$19
363TCSHRYTD SearchTotal Cash Received YTDCurrencyDLR19_RBS0_STR$19
364TFNCHLTD SearchTotal Finance Charges LTDCurrencyDLR19_RBS0_STR$19
365TFNCHLYR SearchTotal Finance Charges LYRCurrencyDLR19_RBS0_STR$19
366TFNCHYTD SearchTotal Finance Charges YTDCurrencyDLR19_RBS0_STR$19
367FNCHCYTD SearchFinance Charges CYTDCurrencyDLR19_RBS0_STR$19
368FNCHLYRC SearchFinance Charges LYR CalendarCurrencyDLR19_RBS0_STR$19
369TBDDTLYR SearchTotal Bad Deb LYRCurrencyDLR19_RBS0_STR$19
370TBDDTLTD SearchTotal Bad Debt LTDCurrencyDLR19_RBS0_STR$19
371TBDDTYTD SearchTotal Bad Debt YTDCurrencyDLR19_RBS0_STR$19
372TWVFCLTD SearchTotal Waived FC LTDCurrencyDLR19_RBS0_STR$19
373TWVFCLYR SearchTotal Waived FC LYRCurrencyDLR19_RBS0_STR$19
374TWVFCYTD SearchTotal Waived FC YTDCurrencyDLR19_RBS0_STR$19
375TWROFLTD SearchTotal Writeoffs LTDCurrencyDLR19_RBS0_STR$19
376TWROFLYR SearchTotal Writeoffs LYRCurrencyDLR19_RBS0_STR$19
377TWROFYTD SearchTotal Writeoffs YTDCurrencyDLR19_RBS0_STR$19
378TTLINLTD SearchTotal # Invoices LTDLong IntegerLI6_U06
379TTLINLYR SearchTotal # Invoices LYRLong IntegerLI6_U06
380TTLINYTD SearchTotal # Invoices YTDLong IntegerLI6_U06
381TTLFCLTD SearchTotal # FC LTDLong IntegerLI6_U06
382TTLFCLYR SearchTotal # FC LYRLong IntegerLI6_U06
383TTLFCYTD SearchTotal # FC YTDLong IntegerLI6_U06
384WROFSLIF SearchWrite Offs LIFECurrencyDLR19_RBS0_STR$19
385WROFSLYR SearchWrite Offs LYRCurrencyDLR19_RBS0_STR$19
386WROFSYTD SearchWrite Offs YTDCurrencyDLR19_RBS0_STR$19
387HIBALLTD SearchHigh Balance LTDCurrencyDLR19_RBSO_STR$19
388HIBALLYR SearchHigh Balance LYRCurrencyDLR19_RBSO_STR$19
389HIBALYTD SearchHigh Balance YTDCurrencyDLR19_RBSO_STR$19
390LASTSTDT SearchLast Statement DateDateDATE6
391LSTSTAMT SearchLast Statement AmountCurrencyDLR17_RBS0_STR$17
392DEPRECV SearchDeposits ReceivedCurrencyDLR19_RBS0_STR$19
393ONORDAMT SearchOn Order AmountCurrencyDLR19_RBS0_UTR$19
394DISGRPER SearchDiscount Grace PeriodIntegerINT2_U02
395DOCFMTID SearchDocument Format IDStringSTR15_LBU15
396DUEGRPER SearchDue Date Grace PeriodIntegerINT2_U02
397APLYWITH SearchApply WithholdingBooleanBoolean0
398CORRCTN SearchCorrectionBooleanCB_Correction0
399DOCNCORR SearchDocument Number CorrectedStringDocument_Number20
400PHONE3 SearchPhone 3StringPhone_Number314
401SALEDATE SearchSale DateDateDT8
402SEQNCORR SearchSequence Number CorrectedIntegerINT0
403SHPPGDOC SearchShipping DocumentBooleanCB_Shipping_Document0
404SIMPLIFD SearchSimplifiedBooleanCB_Simplified0
405WITHHAMT SearchWithholding AmountCurrencyDLR19_RBSO_UTR$19
406CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean0
407SOPHDRE3 SearchSOP HDR Errors 3Long IntegerML_SOP_HDR_Errors_30
408ABCCODE SearchABC CodeIntegerDDL_ABC_Code0
409CGSINFLX SearchCOGS Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].CGSINFLX AS 'ASI SOP Line Item SmartList-COGS Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].CGSINFLX = ['Account Index Master'].ACTINDX
410CGSMCIDX SearchCOGS Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].CGSMCIDX AS 'ASI SOP Line Item SmartList-COGS Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].CGSMCIDX = ['Account Index Master'].ACTINDX
411IVINFIDX SearchInventory Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].IVINFIDX AS 'ASI SOP Line Item SmartList-Inventory Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].IVINFIDX = ['Account Index Master'].ACTINDX
412INVMCIDX SearchInventory Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].INVMCIDX AS 'ASI SOP Line Item SmartList-Inventory Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].INVMCIDX = ['Account Index Master'].ACTINDX
413ITEMCODE SearchItem CodeStringSTR1515
414KTACCTSR SearchKit COGS Account SourceIntegerGB0
415LASTGENSN SearchLast Generated Serial NumberStringSTR20_LBAU20
416PriceGroup SearchPrice GroupStringSTR10_LBAU10
417PRICMTHD SearchPrice MethodIntegerDDL_Price_Method0
418PINFLIDX SearchPurch Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].PINFLIDX AS 'ASI SOP Line Item SmartList-Purch Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].PINFLIDX = ['Account Index Master'].ACTINDX
419PURMCIDX SearchPurch Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].PURMCIDX AS 'ASI SOP Line Item SmartList-Purch Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].PURMCIDX = ['Account Index Master'].ACTINDX
420PRCHSUOM SearchPurchasing U Of MStringU_Of_M8
421SELNGUOM SearchSelling U Of MStringU_Of_M8
422TCC SearchTax Commodity CodeStringSTR30_VAT30
423UPPVIDX SearchUnrealized Purchase Price Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI SOP Line Item SmartList'].UPPVIDX AS 'ASI SOP Line Item SmartList-Unrealized Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI SOP Line Item SmartList'].UPPVIDX = ['Account Index Master'].ACTINDX
424ORGSEQNM SearchOriginal Sequence Number CorrectedLong IntegerLI_Sequence_Number10
425ODECPLCU SearchOriginating Decimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
426TTLRTLTD SearchTotal Returns LTDCurrencyDLR19_RBS0_STR$19
427TTLRTLYR SearchTotal Returns LYRCurrencyDLR19_RBS0_STR$19
428TTLRTYTD SearchTotal Returns YTDCurrencyDLR19_RBS0_STR$19
429CUSTNAME1 SearchASI_Customer_NameStringSTR64_Customer_Name64
430CNTCPRSN1 SearchASI_Contact_PersonStringSTR6060
431ASI_Address_Code SearchASI_Address_CodeStringSTR15_Address_Code15
432UPSZONE1 SearchASI_UPS_ZoneStringSTR33
433SHIPMTHD1 SearchASI_Shipping_MethodStringSTR15_Shipping_Method15
434TAXSCHID1 SearchASI_Tax_Schedule_IDStringSTR15_Tax_Schedule_ID15
435ADDRESS11 SearchASI_Address_1StringSTR6060
436ADDRESS21 SearchASI_Address_2StringSTR6060
437ADDRESS31 SearchASI_Address_3StringSTR6060
438COUNTRY1 SearchASI_CountryStringSTR6060
439CITY1 SearchASI_CityStringSTR3535
440STATE1 SearchASI_StateStringSTR30_State29
441ZIP1 SearchASI_ZipStringSTR1010
442PHONE11 SearchASI_Phone_1StringPhone_Number14
443PHONE21 SearchASI_Phone_2StringPhone_Number14
444FAX1 SearchASI_FaxStringSTR14_FAX14
445PRBTADCD1 SearchASI_Primary_Billto_Address_CodeStringSTR15_LBAU15
446PRSTADCD1 SearchASI_Primary_Shipto_Address_CodeStringSTR15_LBAU15
447SLPRSNID1 SearchASI_Salesperson_IDStringSTR15_Salesperson_ID15
448PYMTRMID1 SearchASI_Payment_Terms_IDStringSTR20_Payment_Terms_ID20
449CURNCYID1 SearchASI_Currency_IDStringSTR15_Currency_ID15
450RATETPID1 SearchASI_Rate_Type_IDStringSTR15_Rate_Type_ID15
451PRCLEVEL1 SearchASI_PriceLevelStringSTR10_LBAU10
452COMMENT11 SearchASI_Comment1StringSTR3030
453COMMENT21 SearchASI_Comment2StringSTR3030
454TXRGNNUM1 SearchASI_Tax_Registration_NumberStringSTR2525
455TAXEXMT11 SearchASI_Tax_Exempt_1StringSTR2525
456TAXEXMT21 SearchASI_Tax_Exempt_2StringSTR2525
457SALSTERR1 SearchASI_Sales_TerritoryStringSTR15_Sales_Territory15
458KPCALHST1 SearchASI_Keep_Calendar_HistoryBooleanCB_Keep_Calendar_History0
459KPDSTHST1 SearchASI_Keep_Distribution_HistoryBooleanCB_Keep_Dist_History0
460KPERHIST1 SearchASI_Keep_Period_HistoryBooleanCB_Keep_Period_History0
461KPTRXHST1 SearchASI_Keep_Trx_HistoryBooleanCB_Keep_Trx_History0
462NOTEINDX1 SearchASI_Note_IndexCurrencyDLR1414
463CREATDDT1 SearchASI_Created_DateDateDT8
464MODIFDT1 SearchASI_Modified_DateDateDT8
465PHONE31 SearchASI_Phone_3StringPhone_Number14
466ITEMDESC1 SearchASI_Item_DescriptionStringSTR5050
467ITMTSHID1 SearchASI_Item_Tax_Schedule_IDStringSTR15_LBAU15
468PRCLEVEL11 SearchASI_PriceLevel2StringSTR10_LBAU10
469DECPLQTY1 SearchASI_Decimal_Places_QTYSIntegerDDL_Decimal_Places_QTYS0
470DECPLCUR1 SearchASI_Decimal_Places_CurrencyIntegerDDL_Decimal_Places_Dollars0
471ITEMCODE1 SearchASI_Item_CodeStringSTR1515
472ReqShipDate1 SearchASI_Requested_Ship_DateDateDT8
473FUFILDAT1 SearchASI_Fulfillment_DateDateDT8
474ACTLSHIP1 SearchASI_Actual_Ship_DateDateDT8
475PRCLEVEL111 SearchASI_PriceLevel3StringSTR10_LBAU10
476LOCNCODE1 SearchASI_Location_CodeStringSTR10_Location_Code10
477MRKDNAMT1 SearchASI_Markdown_AmountCurrencyDLR17_RBS0_UTR$17
478SHIPMTHD11 SearchASI_Shipping_Method2StringSTR15_Shipping_Method15
479TRDISAMT1 SearchASI_Trade_Discount_AmountCurrencyDLR17_RBS0_UTR$17
480EXTDCOST1 SearchASI_Extended_CostCurrencyDLR17_RBS0_UTR$17
481TXBTXAMT1 SearchASI_Taxable_Tax_AmountCurrencyDLR19_RBSO_UTR$19
482TAXAMNT1 SearchASI_Tax_AmountCurrencyDLR17_RBS0_UTR$17
483SALSTERR11 SearchASI_Sales_Territory2StringSTR15_Sales_Territory15
484SLPRSNID11 SearchASI_Salesperson_ID2StringSTR15_Salesperson_ID15
485TRXSORCE1 SearchASI_TRX_SourceStringSTR1313
486COMMNTID1 SearchASI_Comment_IDStringSTR15_Comment_ID15
487CREATDDT11 SearchASI_Created_Date2DateDT8
488MODIFDT11 SearchASI_Modified_Date2DateDT8
489ORMRKDAM1 SearchASI_Originating_Markdown_AmountCurrencyDLR17_RBS0_UTR$17
490ORTDISAM1 SearchASI_Originating_Trade_Discount_AmountCurrencyDLR17_RBS0_UTR$17
491BSIVCTTL1 SearchASI_Based_On_Invoice_TotalBooleanYN0
492OREXTCST1 SearchASI_Originating_Extended_CostCurrencyDLR17_RBS0_UTR$17
493OTAXTAMT1 SearchASI_Originating_Taxable_Tax_AmountCurrencyDLR17_RBS0_UTR$17
494ORTAXAMT1 SearchASI_Originating_Tax_AmountCurrencyDLR17_RBS0_UTR$17
495NOTEINDX11 SearchASI_Note_Index2CurrencyDLR1414
496ASI_Currency_Index SearchASI_Currency_IndexIntegerINT33
497SOPLNERR1 SearchASI_SOP_LINE_Errors_MSLBLong IntegerML_SOP_LINE_Errors0
498LOCNCODE11 SearchASI_Location_Code2StringSTR10_Location_Code10
499DOCNCORR1 SearchASI_Document_Number_CorrectedStringDocument_Number20
500TAXSCHID2 SearchASI_Tax_Schedule_ID_2StringSTR15_Tax_Schedule_ID15
501PRSTADCD2 SearchASI_Primary_Shipto_Address_Code_2StringSTR15_LBAU15
502ShipToName1 SearchASI_ShipToNameStringSTR64_Customer_Name64
503CNTCPRSN2 SearchASI_Contact_Person_2StringSTR6060
504ADDRESS111 SearchASI_Address_12StringSTR6060
505ADDRESS211 SearchASI_Address_22StringSTR6060
506ADDRESS311 SearchASI_Address_32StringSTR6060
507CITY11 SearchASI_City2StringSTR3535
508STATE11 SearchASI_State2StringSTR30_State29
509ZIPCODE1 SearchASI_Zip_CodeStringSTR1010
510COUNTRY11 SearchASI_Country2StringSTR6060
511PHONE1 SearchPhone 1StringPhone_Number14
512PHONE2 SearchPhone 2StringPhone_Number14
513PHONE311 SearchASI_Phone_32StringPhone_Number14
514FAXNUMBR1 SearchASI_Fax_NumberStringSTR14_FAX14
515EXCEPTIONALDEMAND SearchExceptional DemandBooleanCB_Exceptional_Demand0
516ASI_Tax_Schedule_Source SearchASI_Tax_Schedule_SourceIntegerASI_Tax_Schedule_Source0
517CONTNBR SearchContract NumberStringSTR1111
518CONTSTARTDTE SearchContract Start DateDateDATE6
519CONTENDDTE SearchContract End DateDateDATE_L0
520CONTITEMNBR SearchContract Item NumberStringSTR30_Item_Number30
521CONTSERIALNBR SearchContract Serial NumberStringSTR20_LBAU20
522SOPSTATUS SearchSOP StatusIntegerINT0
523CUSTPRIORITY SearchCustomer PriorityIntegerDDL_CustomerPriority0
524ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultIntegerDDL_OrderFulfillDefault0
525UMSCHDSC SearchU Of M Schedule DescriptionStringSTR3030
526SHIPCOMPLETE SearchShip Complete DocumentBooleanCB_ShipComplete0
527SHIPCOMPLETE1 SearchASI_Ship_Complete_DocumentBooleanCB_ShipComplete0
azurecurveProductsSmartList (1493)PathnameASI SOP Line Item SmartList (ASIEXP20)

Leave a Reply

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