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

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_ByLI_14Long Integer14
2ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
3SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger0
4SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString17
5LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
6CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer10
7ASI_Document_Status SearchASI_Document_StatusINTInteger0
8ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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 DescriptionSTR100String100
10NONINVEN SearchNon IVINT1Integer1
11DROPSHIP SearchDrop ShipINT2Integer2
12UOFM SearchU Of MU_Of_MString8
13LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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 CostDLR17_RBS0_UTR$Currency17
15ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency17
16UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency17
17ORUNTPRC SearchOriginating Unit PriceDLR17_RBS0_STR$Currency17
18XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency17
19OXTNDPRC SearchOriginating Extended PriceDLR17_RBS0_STR$Currency17
20REMPRICE SearchRemaining PriceDLR17_RBS0_UTR$Currency17
21OREPRICE SearchOriginating Remaining PriceDLR17_RBS0_UTR$Currency17
22EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
23OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency17
24MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency17
25ORMRKDAM SearchOriginating Markdown AmountDLR17_RBS0_UTR$Currency17
26MRKDNPCT SearchMarkdown PercentINT5_%2Integer5
27MRKDNTYP SearchMarkdown TypeGBInteger0
28INVINDX SearchInventory IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IDSTR15_LBAUString15
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 TaxableDDL_Tax_OptionsInteger0
38BKTSLSAM SearchBackout Sales AmountDLR19_RBS0_UTR$Currency19
39ORBKTSLS SearchOriginating Backout Sales AmountDLR19_RBS0_UTR$Currency19
40TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
41ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
42TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency19
43OTAXTAMT SearchOriginating Taxable Tax AmountDLR17_RBS0_UTR$Currency17
44BSIVCTTL SearchBased On Invoice TotalYNBoolean0
45TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
46ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
47DISCSALE SearchDiscount Available SalesDLR17_RBS0_UTR$Currency17
48ORDAVSLS SearchOriginating Discount Available SalesDLR17_RBS0_UTR$Currency17
49QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency17
50ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency17
51QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency17
52QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency17
53QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency17
54QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency17
55QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency17
56QTYCANCE SearchQTY CanceledDLR17_QTY_RBS0_UTRCurrency17
57QTYCANOT SearchQTY Canceled OtherDLR17_QTY_RBS0_UTRCurrency17
58QTYORDER SearchQTY OrderedDLR17_QTY_RBS0_UTRCurrency17
59QTYPRBAC SearchQTY Prev Back OrderedDLR17_QTY_RBS0_UTRCurrency17
60QTYPRBOO SearchQTY Prev BO On OrderDLR17_QTY_RBS0_UTRCurrency17
61QTYPRINV SearchQTY Prev InvoicedDLR17_QTY_RBS0_UTRCurrency17
62QTYPRORD SearchQTY Prev OrderedDLR17_QTY_RBS0_UTRCurrency17
63QTYREMAI SearchQTY RemainingDLR17_QTY_RBS0_UTRCurrency17
64QTYREMBO SearchQTY Remaining On BODLR17_QTY_RBS0_UTRCurrency17
65QTYTBAOR SearchQTY To Back OrderDLR17_QTY_RBS0_UTRCurrency17
66QTYTOINV SearchQTY To InvoiceDLR17_QTY_RBS0_UTRCurrency17
67QTYTORDR SearchQTY To OrderDLR17_QTY_RBS0_UTRCurrency17
68QTYFULFI SearchQTY FulfilledDLR17_QTY_RBS0_UTRCurrency17
69QTYSLCTD SearchQTY SelectedDLR17_QTY_RBS0_UTRCurrency17
70QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency17
71EXTQTYAL SearchExisting Qty AvailableDLR17_RBS0_UTR$Currency17
72EXTQTYSEL SearchExisting Qty SelectedDLR17_QTY_RBS0_STRCurrency17
73ReqShipDate SearchRequested Ship DateDTDate8
74FUFILDAT SearchFulfillment DateDTDate8
75ACTLSHIP SearchActual Ship DateDTDate8
76SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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 TerritorySTR15_Sales_TerritoryString15
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 IDSTR15_Salesperson_IDString15
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 SearchPriceLevelSTR10_LBAUString10
80COMMNTID SearchComment IDSTR15_Comment_IDString15
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 1INT1Integer1
82BRKFLD2 SearchBreak Field 2INT1Integer1
83BRKFLD3 SearchBreak Field 3INT1Integer1
84CURRNIDX SearchCurrency IndexINT3Integer3
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 SourceSTR13String13
86SOPLNERR SearchSOP LINE ErrorsML_SOP_LINE_ErrorsLong Integer0
87PURCHSTAT SearchPurchasing StatusDDL_PurchasingStatusInteger0
88QTYONPO SearchQTY On PODLR17_QTY_RBS0_UTRCurrency17
89QTYRECVD SearchQTY ReceivedDLR17_QTY_RBS0_UTRCurrency17
90QTYPRVRECVD SearchQTY Prev ReceivedDLR17_QTY_RBS0_UTRCurrency17
91ORIGTYPE SearchOriginal TypeDDL_SOP_TypeInteger0
92DOCID SearchDocument IDSTR15_LBAUString15
93DOCDATE SearchDocument DateDTDate8
94GLPOSTDT SearchGL Posting DateDTDate8
95QUOTEDAT SearchQuote DateDTDate8
96QUOEXPDA SearchQuote Expiration DateDTDate8
97ORDRDATE SearchOrder DateDTDate8
98INVODATE SearchInvoice DateDTDate8
99BACKDATE SearchBack Order DateDTDate8
100RETUDATE SearchReturn DateDTDate8
101DISCDATE SearchDiscount DateDTDate8
102DUEDATE SearchDue DateDTDate8
103REPTING SearchRepeatingCB_RepeatingBoolean0
104TRXFREQU SearchTRX FrequencyDDL_TRX_FrequencyInteger0
105TIMEREPD SearchTimes RepeatedINT4_U0Integer4
106DYSTINCR SearchDays to IncrementINT3_RB0_UInteger3
107DTLSTREP SearchDate Last RepeatedDTDate8
108DSTBTCH1 SearchDest Batch 1STR15_LBAUString15
109DSTBTCH2 SearchDest Batch 2STR15_LBAUString15
110USDOCID1 SearchUse Document ID 1STR15_LBAUString15
111USDOCID2 SearchUse Document ID 2STR15_LBAUString15
112DISCFRGT SearchDiscount Available FreightDLR17_RBS0_UTR$Currency17
113ORDAVFRT SearchOriginating Discount Available FreightDLR17_RBS0_UTR$Currency17
114DISCMISC SearchDiscount Available MiscDLR17_RBS0_UTR$Currency17
115ORDAVMSC SearchOriginating Discount Available MiscDLR17_RBS0_UTR$Currency17
116DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency17
117ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency17
118DISCRTND SearchDiscount ReturnedDLR17_RBS0_STR$Currency17
119ORDISRTD SearchOriginating Discount ReturnedDLR17_RBS0_STR$Currency17
120DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
121ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
122DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer5
123DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency11
124ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency17
125PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
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 SourceSTR15String15
127BACHNUMB SearchBatch NumberSTR15_LBAUString15
128CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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 NameSTR64_Customer_NameString64
130CSTPONBR SearchCustomer PO NumberSTR20_Document_NumberString20
131PROSPECT SearchProspectINT1Integer1
132MSTRNUMB SearchMaster NumberLI_MasterNumberLong Integer9
133PCKSLPNO SearchPacking Slip NumberSTR20_IVC_Document_NumberString17
134PICTICNU SearchPicking Ticket NumberSTR20_SOP_NumberString17
135PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString15
136PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
137CNTCPRSN SearchContact PersonSTR60String60
138ShipToName SearchShipToNameSTR64_Customer_NameString64
139ADDRESS1 SearchAddress 1STR60String60
140ADDRESS2 SearchAddress 2STR60String60
141ADDRESS3 SearchAddress 3STR60String60
142CITY SearchCitySTR35String35
143STATE SearchStateSTR30_StateString29
144ZIPCODE SearchZip CodeSTR10String10
145COUNTRY SearchCountrySTR60String60
146PHNUMBR1 SearchPhone Number 1Phone_NumberString14
147PHNUMBR2 SearchPhone Number 2Phone_NumberString14
148FAXNUMBR SearchFax NumberSTR14_FAXString14
149COMAPPTO SearchCommission Applied ToGBInteger0
150COMMAMNT SearchCommission AmountDLR17_RBS0_STR$Currency17
151OCOMMAMT SearchOriginating Commission AmountDLR17_RBSO_STR$Currency17
152CMMSLAMT SearchCommission Sale AmountDLR17_RBS0_STR$Currency17
153ORCOSAMT SearchOriginating Commission Sales AmountDLR17_RBS0_STR$Currency17
154NCOMAMNT SearchNon-Commissioned AmountDLR19_RBS0_STR$Currency19
155ORNCMAMT SearchOriginating Non-Commissioned AmountDLR19_RBS0_STR$Currency19
156TRDISPCT SearchTrade Discount PercentINT4_%2Integer4
157SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency17
158ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency17
159REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency17
160OREMSUBT SearchOriginating Remaining SubtotalDLR17_RBS0_UTR$Currency17
161FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
162ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
163MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency17
164ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency19
165TXENGCLD SearchTax Engine CalledYNBoolean0
166TAXEXMT1 SearchTax Exempt 1STR25String25
167TAXEXMT2 SearchTax Exempt 2STR25String25
168TXRGNNUM SearchTax Registration NumberSTR25String25
169TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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 SourceINT1Integer1
171FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
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 AmountDLR19_RBSO_UTR$Currency19
173ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency19
174FRGTTXBL SearchFreight TaxableDDL_Tax_OptionsInteger0
175MSCSCHID SearchMisc Schedule IDSTR15_LBAUString15
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 AmountDLR19_RBSO_UTR$Currency19
177ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency19
178MISCTXBL SearchMisc TaxableDDL_Tax_OptionsInteger0
179BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency19
180ORBKTFRT SearchOriginating Backout Freight AmountDLR19_RBS0_UTR$Currency19
181BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency19
182ORBKTMSC SearchOriginating Backout Misc AmountDLR19_RBS0_UTR$Currency19
183BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency17
184OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency17
185ECTRX SearchEC TransactionCB_EC_TransactionBoolean0
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 AmountDLR19_RBSO_UTR$Currency19
187ORDOCAMT SearchOriginating Document AmountDLR17_RBS0_STR$Currency17
188PYMTRCVD SearchPayment ReceivedDLR19_RBS0_UTR$Currency19
189ORPMTRVD SearchOriginating Payment ReceivedDLR19_RBS0_UTR$Currency19
190DEPRECVD SearchDeposit ReceivedDLR19_RBS0_UTR$Currency19
191ORDEPRVD SearchOriginating Deposit ReceivedDLR19_RBS0_UTR$Currency19
192CODAMNT SearchCOD AmountDLR17_RBS0_UTR$Currency17
193ORCODAMT SearchOriginating COD AmountDLR17_RBS0_UTR$Currency17
194ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency19
195ORACTAMT SearchOriginating Account AmountDLR19_RBS0_UTR$Currency19
196UPSZONE SearchUPS ZoneSTR3String3
197TIMESPRT SearchTimes PrintedINT4_U0Integer4
198PSTGSTUS SearchPosting StatusINTInteger0
199VOIDSTTS SearchVoid StatusINTInteger0
200ALLOCABY SearchAllocate ByDDL_Allocate_ByInteger0
201CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 IDSTR15_Rate_Type_IDString15
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 IDSTR15_Exchange_Table_IDString15
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 RateDLR14_Exchange_RateCurrency (Variable)14
205DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
206EXCHDATE SearchExchange DateDT_DateDate6
207TIME1 SearchTimeTM6Time6
208RTCLCMTD SearchRate Calculation MethodGBInteger0
209MCTRXSTT SearchMC Transaction StateINT1Integer1
210SOPHDRE1 SearchSOP HDR Errors 1ML_SOP_HDR_Errors_1Long Integer0
211SOPHDRE2 SearchSOP HDR Errors 2ML_SOP_HDR_Errors_2Long Integer0
212SOPHDRFL SearchSOP HDR FlagsML_SOP_HDR_FlagsLong Integer0
213REFRENCE SearchReferenceSTR30String30
214POSTEDDT SearchPosted DateDATEDate6
215PTDUSRID SearchPosted User IDSTR15String15
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 EnterSTR15_User_IDString15
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 DateDTDate8
218MODIFDT SearchModified DateDTDate8
219Tax_Date SearchTax DateDTDate8
220ITMSHNAM SearchItem Short NameSTR15String15
221ITEMTYPE SearchItem TypeDDL_Item_TypeInteger0
222ITMGEDSC SearchItem Generic DescriptionSTR10String10
223STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency17
224CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency17
225LISTPRCE SearchList PriceDLR17_RBS0_STR$Currency17
226ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer6
227DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
228DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
229TAXOPTNS SearchTax OptionsDDL_Tax_OptionsInteger0
230COMMCODE SearchCommission CodeSTR15_LBAUString15
231IVIVINDX SearchIV IV IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 CodeSTR10_Class_IDString10
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 OptionDDL_TrackInteger0
247LOTTYPE SearchLot TypeSTR10_Lot_TypeString10
248KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
249KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
250KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
251KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean0
252ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean0
253VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger0
254UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
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 SearchObjRef1ReferenceInvalid storage type 300
256ALTITEM1 SearchAlternate Item 1STR30_Item_NumberString30
257ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString30
258USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString10
259USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString10
260USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString10
261USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString10
262USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString10
263USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString10
264MSTRCDTY SearchMaster Record TypeINT1Integer1
265WRNTYDYS SearchWarranty DaysINT4Integer4
266ORIGNUMB SearchOriginal NumberSTR20_SOP_NumberString17
267DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency17
268TIMETREP SearchTimes To RepeatINT4_U0Integer4
269ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
270SOPMCERR SearchSOP MC Posting Error MessagesSOP MC Posting Error MessagesLong Integer0
271NOTEINDX SearchNote IndexDLR14Currency14
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 ClassSTR15_Customer_ClassString15
273CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
274STMTNAME SearchStatement NameSTR64String64
275ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
276STADDRCD SearchStatement Address CodeSTR15_LBAUString15
277CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
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 TypeGB_Amt_TypeInteger0
279CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency17
280CRLMTPER SearchCredit Limit PeriodDDLInteger0
281CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency17
282CUSTDISC SearchCustomer DiscountINT5_%2Integer5
283SHRTNAME SearchShort NameSTR15String15
284MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger0
285MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency17
286MINPYPCT SearchMinimum Payment PercentINT5_%2Integer5
287FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger0
288FNCHPCNT SearchFinance Charge PercentINT5_%2Integer5
289FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency17
290MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger0
291MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency17
292USERDEF1 SearchUser Defined 1STR20String20
293USERDEF2 SearchUser Defined 2STR20String20
294BALNCTYP SearchBalance TypeGB_Bal_TypeInteger0
295STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger0
296BANKNAME SearchBank NameSTR30String30
297BNKBRNCH SearchBank BranchSTR20String20
298DEFCACTY SearchDefault Cash Account TypeGBInteger0
299RMCSHACC SearchRM Cash Account IndexLI_14Long Integer14
300RMARACC SearchRM AR Account IndexLI_14Long Integer14
301RMSLSACC SearchRM Sales Account IndexLI_14Long Integer14
302RMIVACC SearchRM IV Account IndexLI_14Long Integer14
303RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer14
304RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer14
305RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer14
306RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer14
307RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer14
308FRSTINDT SearchFirst Invoice DateDT_DateDate6
309INACTIVE SearchInactiveCB_InactiveBoolean0
310HOLD SearchHoldCB_HoldBoolean0
311CRCARDID SearchCredit Card IDSTR15String15
312CRCRDNUM SearchCredit Card NumberSTR20String20
313CCRDXPDT SearchCredit Card Exp DateDT_DateDate6
314Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean0
315Post_Results_To SearchPost Results ToGBInteger0
316FINCHID SearchFinance Charge IDSTR15_Charge_IDString15
317GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
318GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString30
319TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency19
320NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer6
321CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency19
322AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency17
323AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency17
324AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency17
325AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency17
326AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency17
327AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency17
328AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency17
329LASTAGED SearchLast AgedDATEDate6
330LSTNSFCD SearchLast NSF Check DateDT_DateDate6
331LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency17
332LASTPYDT SearchLast Payment DateDT_DateDate6
333LSTTRXDT SearchLast Transaction DateDT_DateDate6
334LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency17
335LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency19
336UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency17
337AVDTPLYR SearchAverage Days to Pay - LYRINT3_U0Integer3
338AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer3
339AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer3
340NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer10
341NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer10
342NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer10
343TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency19
344TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency19
345TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency19
346TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency19
347RETAINAG SearchRetainageDLR19_RBS0_STR$Currency19
348TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency19
349NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer6
350UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency19
351UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency19
352UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency19
353UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency19
354NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency19
355TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency19
356TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency19
357TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency19
358TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency19
359TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency19
360TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency19
361TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency19
362TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency19
363TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency19
364TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency19
365TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency19
366TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency19
367FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency19
368FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency19
369TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency19
370TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency19
371TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency19
372TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency19
373TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency19
374TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency19
375TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency19
376TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency19
377TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency19
378TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer6
379TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer6
380TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer6
381TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer6
382TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer6
383TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer6
384WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency19
385WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency19
386WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency19
387HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency19
388HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency19
389HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency19
390LASTSTDT SearchLast Statement DateDATEDate6
391LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency17
392DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency19
393ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency19
394DISGRPER SearchDiscount Grace PeriodINT2_U0Integer2
395DOCFMTID SearchDocument Format IDSTR15_LBUString15
396DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
397APLYWITH SearchApply WithholdingBooleanBoolean0
398CORRCTN SearchCorrectionCB_CorrectionBoolean0
399DOCNCORR SearchDocument Number CorrectedDocument_NumberString20
400PHONE3 SearchPhone 3Phone_Number3String14
401SALEDATE SearchSale DateDTDate8
402SEQNCORR SearchSequence Number CorrectedINTInteger0
403SHPPGDOC SearchShipping DocumentCB_Shipping_DocumentBoolean0
404SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean0
405WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency19
406CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean0
407SOPHDRE3 SearchSOP HDR Errors 3ML_SOP_HDR_Errors_3Long Integer0
408ABCCODE SearchABC CodeDDL_ABC_CodeInteger0
409CGSINFLX SearchCOGS Inflation IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 CodeSTR15String15
414KTACCTSR SearchKit COGS Account SourceGBInteger0
415LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString20
416PriceGroup SearchPrice GroupSTR10_LBAUString10
417PRICMTHD SearchPrice MethodDDL_Price_MethodInteger0
418PINFLIDX SearchPurch Inflation IndexLI_14Long Integer14
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 IndexLI_14Long Integer14
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 MU_Of_MString8
421SELNGUOM SearchSelling U Of MU_Of_MString8
422TCC SearchTax Commodity CodeSTR30_VATString30
423UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer14
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 CorrectedLI_Sequence_NumberLong Integer10
425ODECPLCU SearchOriginating Decimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
426TTLRTLTD SearchTotal Returns LTDDLR19_RBS0_STR$Currency19
427TTLRTLYR SearchTotal Returns LYRDLR19_RBS0_STR$Currency19
428TTLRTYTD SearchTotal Returns YTDDLR19_RBS0_STR$Currency19
429CUSTNAME1 SearchASI_Customer_NameSTR64_Customer_NameString64
430CNTCPRSN1 SearchASI_Contact_PersonSTR60String60
431ASI_Address_Code SearchASI_Address_CodeSTR15_Address_CodeString15
432UPSZONE1 SearchASI_UPS_ZoneSTR3String3
433SHIPMTHD1 SearchASI_Shipping_MethodSTR15_Shipping_MethodString15
434TAXSCHID1 SearchASI_Tax_Schedule_IDSTR15_Tax_Schedule_IDString15
435ADDRESS11 SearchASI_Address_1STR60String60
436ADDRESS21 SearchASI_Address_2STR60String60
437ADDRESS31 SearchASI_Address_3STR60String60
438COUNTRY1 SearchASI_CountrySTR60String60
439CITY1 SearchASI_CitySTR35String35
440STATE1 SearchASI_StateSTR30_StateString29
441ZIP1 SearchASI_ZipSTR10String10
442PHONE11 SearchASI_Phone_1Phone_NumberString14
443PHONE21 SearchASI_Phone_2Phone_NumberString14
444FAX1 SearchASI_FaxSTR14_FAXString14
445PRBTADCD1 SearchASI_Primary_Billto_Address_CodeSTR15_LBAUString15
446PRSTADCD1 SearchASI_Primary_Shipto_Address_CodeSTR15_LBAUString15
447SLPRSNID1 SearchASI_Salesperson_IDSTR15_Salesperson_IDString15
448PYMTRMID1 SearchASI_Payment_Terms_IDSTR20_Payment_Terms_IDString20
449CURNCYID1 SearchASI_Currency_IDSTR15_Currency_IDString15
450RATETPID1 SearchASI_Rate_Type_IDSTR15_Rate_Type_IDString15
451PRCLEVEL1 SearchASI_PriceLevelSTR10_LBAUString10
452COMMENT11 SearchASI_Comment1STR30String30
453COMMENT21 SearchASI_Comment2STR30String30
454TXRGNNUM1 SearchASI_Tax_Registration_NumberSTR25String25
455TAXEXMT11 SearchASI_Tax_Exempt_1STR25String25
456TAXEXMT21 SearchASI_Tax_Exempt_2STR25String25
457SALSTERR1 SearchASI_Sales_TerritorySTR15_Sales_TerritoryString15
458KPCALHST1 SearchASI_Keep_Calendar_HistoryCB_Keep_Calendar_HistoryBoolean0
459KPDSTHST1 SearchASI_Keep_Distribution_HistoryCB_Keep_Dist_HistoryBoolean0
460KPERHIST1 SearchASI_Keep_Period_HistoryCB_Keep_Period_HistoryBoolean0
461KPTRXHST1 SearchASI_Keep_Trx_HistoryCB_Keep_Trx_HistoryBoolean0
462NOTEINDX1 SearchASI_Note_IndexDLR14Currency14
463CREATDDT1 SearchASI_Created_DateDTDate8
464MODIFDT1 SearchASI_Modified_DateDTDate8
465PHONE31 SearchASI_Phone_3Phone_NumberString14
466ITEMDESC1 SearchASI_Item_DescriptionSTR50String50
467ITMTSHID1 SearchASI_Item_Tax_Schedule_IDSTR15_LBAUString15
468PRCLEVEL11 SearchASI_PriceLevel2STR10_LBAUString10
469DECPLQTY1 SearchASI_Decimal_Places_QTYSDDL_Decimal_Places_QTYSInteger0
470DECPLCUR1 SearchASI_Decimal_Places_CurrencyDDL_Decimal_Places_DollarsInteger0
471ITEMCODE1 SearchASI_Item_CodeSTR15String15
472ReqShipDate1 SearchASI_Requested_Ship_DateDTDate8
473FUFILDAT1 SearchASI_Fulfillment_DateDTDate8
474ACTLSHIP1 SearchASI_Actual_Ship_DateDTDate8
475PRCLEVEL111 SearchASI_PriceLevel3STR10_LBAUString10
476LOCNCODE1 SearchASI_Location_CodeSTR10_Location_CodeString10
477MRKDNAMT1 SearchASI_Markdown_AmountDLR17_RBS0_UTR$Currency17
478SHIPMTHD11 SearchASI_Shipping_Method2STR15_Shipping_MethodString15
479TRDISAMT1 SearchASI_Trade_Discount_AmountDLR17_RBS0_UTR$Currency17
480EXTDCOST1 SearchASI_Extended_CostDLR17_RBS0_UTR$Currency17
481TXBTXAMT1 SearchASI_Taxable_Tax_AmountDLR19_RBSO_UTR$Currency19
482TAXAMNT1 SearchASI_Tax_AmountDLR17_RBS0_UTR$Currency17
483SALSTERR11 SearchASI_Sales_Territory2STR15_Sales_TerritoryString15
484SLPRSNID11 SearchASI_Salesperson_ID2STR15_Salesperson_IDString15
485TRXSORCE1 SearchASI_TRX_SourceSTR13String13
486COMMNTID1 SearchASI_Comment_IDSTR15_Comment_IDString15
487CREATDDT11 SearchASI_Created_Date2DTDate8
488MODIFDT11 SearchASI_Modified_Date2DTDate8
489ORMRKDAM1 SearchASI_Originating_Markdown_AmountDLR17_RBS0_UTR$Currency17
490ORTDISAM1 SearchASI_Originating_Trade_Discount_AmountDLR17_RBS0_UTR$Currency17
491BSIVCTTL1 SearchASI_Based_On_Invoice_TotalYNBoolean0
492OREXTCST1 SearchASI_Originating_Extended_CostDLR17_RBS0_UTR$Currency17
493OTAXTAMT1 SearchASI_Originating_Taxable_Tax_AmountDLR17_RBS0_UTR$Currency17
494ORTAXAMT1 SearchASI_Originating_Tax_AmountDLR17_RBS0_UTR$Currency17
495NOTEINDX11 SearchASI_Note_Index2DLR14Currency14
496ASI_Currency_Index SearchASI_Currency_IndexINT3Integer3
497SOPLNERR1 SearchASI_SOP_LINE_Errors_MSLBML_SOP_LINE_ErrorsLong Integer0
498LOCNCODE11 SearchASI_Location_Code2STR10_Location_CodeString10
499DOCNCORR1 SearchASI_Document_Number_CorrectedDocument_NumberString20
500TAXSCHID2 SearchASI_Tax_Schedule_ID_2STR15_Tax_Schedule_IDString15
501PRSTADCD2 SearchASI_Primary_Shipto_Address_Code_2STR15_LBAUString15
502ShipToName1 SearchASI_ShipToNameSTR64_Customer_NameString64
503CNTCPRSN2 SearchASI_Contact_Person_2STR60String60
504ADDRESS111 SearchASI_Address_12STR60String60
505ADDRESS211 SearchASI_Address_22STR60String60
506ADDRESS311 SearchASI_Address_32STR60String60
507CITY11 SearchASI_City2STR35String35
508STATE11 SearchASI_State2STR30_StateString29
509ZIPCODE1 SearchASI_Zip_CodeSTR10String10
510COUNTRY11 SearchASI_Country2STR60String60
511PHONE1 SearchPhone 1Phone_NumberString14
512PHONE2 SearchPhone 2Phone_NumberString14
513PHONE311 SearchASI_Phone_32Phone_NumberString14
514FAXNUMBR1 SearchASI_Fax_NumberSTR14_FAXString14
515EXCEPTIONALDEMAND SearchExceptional DemandCB_Exceptional_DemandBoolean0
516ASI_Tax_Schedule_Source SearchASI_Tax_Schedule_SourceASI_Tax_Schedule_SourceInteger0
517CONTNBR SearchContract NumberSTR11String11
518CONTSTARTDTE SearchContract Start DateDATEDate6
519CONTENDDTE SearchContract End DateDATE_LDate0
520CONTITEMNBR SearchContract Item NumberSTR30_Item_NumberString30
521CONTSERIALNBR SearchContract Serial NumberSTR20_LBAUString20
522SOPSTATUS SearchSOP StatusINTInteger0
523CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger0
524ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger0
525UMSCHDSC SearchU Of M Schedule DescriptionSTR30String30
526SHIPCOMPLETE SearchShip Complete DocumentCB_ShipCompleteBoolean0
527SHIPCOMPLETE1 SearchASI_Ship_Complete_DocumentCB_ShipCompleteBoolean0
azurecurveProductsSmartList (1493)PathnameASI SOP Line Item SmartList (ASIEXP20)

Leave a Reply

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