SmartList Purchasing Receipts (ASIEXP27)

azurecurveProductsSmartList (1493)PathnameSmartList Purchasing Receipts (ASIEXP27)

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

Product: SmartList (1493)
Series:

Display Name: SmartList Purchasing Receipts
Physical Name: ASIEXP27
Technical Name: ASI_POP_Receipt_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
2ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
3ASI_Document_Status SearchASI_Document_StatusIntegerINT0
4POPRCTNM SearchPOP Receipt NumberStringSTR17_POP_Number17
5POPTYPE SearchPOP TypeIntegerDDL_POP_Type0
6VNDDOCNM SearchVendor Document NumberStringSTR20_Document_Number20
7receiptdate SearchReceipt DateDateDT8
8GLPOSTDT SearchGL Posting DateDateDT8
9ACTLSHIP SearchActual Ship DateDateDT8
10BCHSOURC SearchBatch SourceStringSTR1515
11BACHNUMB SearchBatch NumberStringSTR15_LBAU15
12VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SmartList Purchasing Receipts'].VENDORID AS 'SmartList Purchasing Receipts-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ASIEXP27 AS ['SmartList Purchasing Receipts']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SmartList Purchasing Receipts'].VENDORID = ['PM Vendor Master File'].VENDORID
13VENDNAME SearchVendor NameStringSTR64_Vendor_Name64
14SUBTOTAL SearchSubtotalCurrencyDLR17_RBS0_STR$17
15TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
16TRDPCTPR SearchTrade Discount Percent (Precise)Currency (Variable)Trade Discount Percent (Precise)23
17FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
18MISCAMNT SearchMisc AmountCurrencyDLR17_RBS0_UTR$17
19TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
20TEN99AMNT Search1099 AmountCurrencyDLR17_RBS0_UTR$17
21PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['SmartList Purchasing Receipts'].PYMTRMID AS 'SmartList Purchasing Receipts-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP27 AS ['SmartList Purchasing Receipts']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['SmartList Purchasing Receipts'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
22DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
23DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
24DISAVAMT SearchDiscount Available AmountCurrencyDLR17_RBS0_UTR$17
25DISCDATE SearchDiscount DateDateDT8
26DUEDATE SearchDue DateDateDT8
27REFRENCE SearchReferenceStringSTR3030
28VOIDSTTS SearchVoid StatusIntegerINT0
29POPHDR1 SearchPOP HDR Errors 1Long IntegerML_POP_HDR_Errors_10
30POPHDR2 SearchPOP HDR Errors 2Long IntegerML_POP_HDR_Errors_20
31POPLNERR SearchPOP LINE ErrorsLong IntegerML_POP_LINE_Errors0
32POSTEDDT SearchPosted DateDateDATE6
33PTDUSRID SearchPosted User IDStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Purchasing Receipts'].PTDUSRID AS 'SmartList Purchasing Receipts-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP27 AS ['SmartList Purchasing Receipts']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Purchasing Receipts'].PTDUSRID = ['Users Master'].USERID
34USER2ENT SearchUser To EnterStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Purchasing Receipts'].USER2ENT AS 'SmartList Purchasing Receipts-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP27 AS ['SmartList Purchasing Receipts']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Purchasing Receipts'].USER2ENT = ['Users Master'].USERID
35CREATDDT SearchCreated DateDateDT8
36MODIFDT SearchModified DateDateDT8
37TRXSORCE SearchTRX SourceStringSTR1313
38VCHRNMBR SearchVoucher NumberStringSTR20_LBAU20
39Tax_Date SearchTax DateDateDT8
40CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

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

Click to show/hide

SELECT
       ['SmartList Purchasing Receipts'].CURRNIDX AS 'SmartList Purchasing Receipts-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ASIEXP27 AS ['SmartList Purchasing Receipts']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Purchasing Receipts'].CURRNIDX = ['Currency Setup'].CURRNIDX
42RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

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

Click to show/hide

SELECT
       ['SmartList Purchasing Receipts'].EXGTBLID AS 'SmartList Purchasing Receipts-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       ASIEXP27 AS ['SmartList Purchasing Receipts']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['SmartList Purchasing Receipts'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
44XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
45EXCHDATE SearchExchange DateDateDT_Date6
46TIME1 SearchTimeTimeTM66
47RATECALC SearchRate Calc MethodIntegerINT0
48DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
49MCTRXSTT SearchMC Transaction StateIntegerINT11
50ORSUBTOT SearchOriginating SubtotalCurrencyDLR17_RBS0_STR$17
51ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
52ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
53ORMISCAMT SearchOriginating Misc AmountCurrencyDLR19_RBSO_UTR$19
54ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
55OR1099AM SearchOriginating 1099 AmountCurrencyDLR17_RBS0_UTR$17
56ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
57ORDAVAMT SearchOriginating Discount Available AmountCurrencyDLR17_RBS0_UTR$17
58WITHHAMT SearchWithholding AmountCurrencyDLR19_RBSO_UTR$19
59SIMPLIFD SearchSimplifiedBooleanCB_Simplified0
60ECTRX 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.
61TXRGNNUM SearchTax Registration NumberStringSTR2525
62TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Purchasing Receipts'].TAXSCHID AS 'SmartList Purchasing Receipts-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP27 AS ['SmartList Purchasing Receipts']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Purchasing Receipts'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
63BSIVCTTL SearchBased On Invoice TotalBooleanYN0
64Purchase_Freight_Taxable SearchPurchase Freight TaxableIntegerDDL_Purchase_Tax_Options0
65Purchase_Misc_Taxable SearchPurchase Misc TaxableIntegerDDL_Purchase_Tax_Options0
66FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Purchasing Receipts'].FRTSCHID AS 'SmartList Purchasing Receipts-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP27 AS ['SmartList Purchasing Receipts']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Purchasing Receipts'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
67MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Purchasing Receipts'].MSCSCHID AS 'SmartList Purchasing Receipts-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP27 AS ['SmartList Purchasing Receipts']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Purchasing Receipts'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
68FRTTXAMT SearchFreight Tax AmountCurrencyDLR19_RBSO_UTR$19
69ORFRTTAX SearchOriginating Freight Tax AmountCurrencyDLR19_RBSO_UTR$19
70MSCTXAMT SearchMisc Tax AmountCurrencyDLR19_RBSO_UTR$19
71ORMSCTAX SearchOriginating Misc Tax AmountCurrencyDLR19_RBSO_UTR$19
72DISCFRGT SearchDiscount Available FreightCurrencyDLR17_RBS0_UTR$17
73ORDAVFRT SearchOriginating Discount Available FreightCurrencyDLR17_RBS0_UTR$17
74DISCMISC SearchDiscount Available MiscCurrencyDLR17_RBS0_UTR$17
75ORDAVMSC SearchOriginating Discount Available MiscCurrencyDLR17_RBS0_UTR$17
76BackoutFreightTaxAmt SearchBackout Freight Tax AmountCurrencyDLR17_RBS0_UTR$17
77OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountCurrencyDLR17_RBS0_UTR$17
78BackoutMiscTaxAmt SearchBackout Misc Tax AmountCurrencyDLR17_RBS0_UTR$17
79OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountCurrencyDLR17_RBS0_UTR$17
80BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
81OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
82TaxInvReqd SearchTax Invoice RequiredBooleanCB_Tax_Invoice_Required0
83TaxInvRecvd SearchTax Invoice ReceivedBooleanCB_Tax_Invoice_Received0
84APLYWITH SearchApply WithholdingBooleanBoolean0
85PPSTAXRT SearchPPS Tax RateIntegerINT5_%25
86SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SmartList Purchasing Receipts'].SHIPMTHD AS 'SmartList Purchasing Receipts-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP27 AS ['SmartList Purchasing Receipts']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SmartList Purchasing Receipts'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
87PSTGSTUS SearchPosting StatusIntegerINT0
88HIESTBAL SearchHighest BalanceCurrencyDLR17_RBS0_UTR$17
89CURRBLNC SearchCurrent BalanceCurrencyDLR19_RBS0_STR$19
90NOINVYTD SearchNumber of Invoices YTDLong IntegerLI_9U09
91NOINVLIF SearchNumber of Invoices LIFELong IntegerLI_9U09
92NOINVLYR SearchNumber of Invoices LYRLong IntegerLI_9U09
93NOPINYTD SearchNumber of Paid Invoices YTDLong IntegerLI_9U09
94NOPILIFE SearchNumber of Paid Invoices LIFELong IntegerLI_9U09
95AMBLDTYD SearchAmount Billed YTDCurrencyDLR19_RBS0_STR$19
96AMBLDLIF SearchAmount Billed LIFECurrencyDLR19_RBS0_STR$19
97AMBLDLYR SearchAmount Billed LYRCurrencyDLR19_RBS0_STR$19
98AMTPDYTD SearchAmount Paid YTDCurrencyDLR19_RBS0_STR$19
99AMTPDLIF SearchAmount Paid LIFECurrencyDLR19_RBS0_STR$19
100AMTPDLYR SearchAmount Paid LYRCurrencyDLR19_RBS0_STR$19
101TEN99AYTD Search1099 Amount YTDCurrencyDLR19_RBS0_STR$19
102TEN99ALIF Search1099 Amount LIFECurrencyDLR19_RBS0_STR$19
103TEN99ALYR Search1099 Amount LYRCurrencyDLR19_RBS0_STR$19
104DISAVYTD SearchDiscount Available YTDCurrencyDLR19_RBS0_STR$19
105DISAVLIF SearchDiscount Available LIFECurrencyDLR19_RBS0_STR$19
106DISAVLYR SearchDiscount Available LYRCurrencyDLR19_RBS0_STR$19
107DISTKYTD SearchDiscount Taken YTDCurrencyDLR19_RBS0_STR$19
108DISTKNLF SearchDiscount Taken LIFECurrencyDLR19_RBS0_STR$19
109DISTKLYR SearchDiscount Taken LYRCurrencyDLR19_RBS0_STR$19
110DISLSYTD SearchDiscount Lost YTDCurrencyDLR19_RBS0_STR$19
111DISLSTLF SearchDiscount Lost LIFECurrencyDLR19_RBS0_STR$19
112DISLSLYR SearchDiscount Lost LYRCurrencyDLR19_RBS0_STR$19
113FINCHYTD SearchFinance Charge YTDCurrencyDLR19_RBS0_STR$19
114FINCHLIF SearchFinance Charge LIFECurrencyDLR19_RBS0_STR$19
115FINCHLYR SearchFinance Charge LYRCurrencyDLR19_RBS0_STR$19
116WROFSYTD SearchWrite Offs YTDCurrencyDLR19_RBS0_STR$19
117WROFSLIF SearchWrite Offs LIFECurrencyDLR19_RBS0_STR$19
118WROFSLYR SearchWrite Offs LYRCurrencyDLR19_RBS0_STR$19
119RTRNSYTD SearchReturns YTDCurrencyDLR19_RBS0_STR$19
120RTRNSLIF SearchReturns LIFECurrencyDLR19_RBS0_STR$19
121RTRNSLYR SearchReturns LYRCurrencyDLR19_RBS0_STR$19
122TRDTYTD SearchTrade Discounts Taken YTDCurrencyDLR19_RBSO_STR$19
123TRDTKLIF SearchTrade Discounts Taken LIFECurrencyDLR19_RBSO_STR$19
124TRDTLYR SearchTrade Discounts Taken LYRCurrencyDLR19_RBSO_STR$19
125NFNCHYTD SearchNumber of Finance Charges YTDLong IntegerLI_9U09
126NFNCHLIF SearchNumber of Finance Charges LIFELong IntegerLI_9U09
127NFNCHLYR SearchNumber of Finance Charges LYRLong IntegerLI_9U09
128RTNGOWED SearchRetainage OwedCurrencyDLR17_RBS0_STR$17
129LSTCHNUM SearchLast Check NumberStringCheck_Number20
130LSTCHKDT SearchLast Check DateDateDT8
131LSTCHAMT SearchLast Check AmountCurrencyDLR17_RBS0_UTR$17
132LSTINNUM SearchLast Invoice NumberStringSTR2020
133LSTINVAM SearchLast Invoice AmountCurrencyDLR17_RBS0_UTR$17
134LSTPURDT SearchLast Purchase DateDateDT8
135FSTPURDT SearchFirst Purchase DateDateDT8
136CURUNPBN SearchCurrent Unapplied Payment BalanceCurrencyDLR17_RBS0_UTR$17
137UNPDFNCH SearchUnpaid Finance ChargesCurrencyDLR17_RBS0_UTR$17
138DYCHTCLR SearchDays Checks To ClearIntegerINT3_U03
139AVGDTPYR SearchAverage Days To Pay - YearIntegerINT3_U03
140AVDTPLIF SearchAverage Days To Pay - LifeIntegerINT3_U03
141ACCRDINV SearchAccured InventoryCurrencyDLR17_RBS0_STR$17
142ONORDAMT SearchOn Order AmountCurrencyDLR19_RBS0_UTR$19
143WITHYTD SearchWithholding YTDCurrencyDLR19_RBS0_STR$19
144Withholding_LIFE SearchWithholding LIFECurrencyDLR19_RBS0_STR$19
145WITHLYR SearchWithholding LYRCurrencyDLR19_RBS0_STR$19
146User_Defined_List01 SearchUser Defined List01StringSTR3030
147User_Defined_List02 SearchUser Defined List02StringSTR3030
148User_Defined_List03 SearchUser Defined List03StringSTR3030
149User_Defined_List04 SearchUser Defined List04StringSTR3030
150User_Defined_List05 SearchUser Defined List05StringSTR3030
151User_Defined_Text01 SearchUser Defined Text01StringSTR3030
152User_Defined_Text02 SearchUser Defined Text02StringSTR3030
153User_Defined_Text03 SearchUser Defined Text03StringSTR3030
154User_Defined_Text04 SearchUser Defined Text04StringSTR3030
155User_Defined_Text05 SearchUser Defined Text05StringSTR3030
156User_Defined_Text06 SearchUser Defined Text06StringSTR3030
157User_Defined_Text07 SearchUser Defined Text07StringSTR3030
158User_Defined_Text08 SearchUser Defined Text08StringSTR3030
159User_Defined_Text09 SearchUser Defined Text09StringSTR3030
160User_Defined_Text10 SearchUser Defined Text10StringSTR3030
161User_Defined_Date01 SearchUser Defined Date01DateDT8
162User_Defined_Date02 SearchUser Defined Date02DateDT8
163User_Defined_Date03 SearchUser Defined Date03DateDT8
164User_Defined_Date04 SearchUser Defined Date04DateDT8
165User_Defined_Date05 SearchUser Defined Date05DateDT8
166User_Defined_Date06 SearchUser Defined Date06DateDT8
167User_Defined_Date07 SearchUser Defined Date07DateDT8
168User_Defined_Date08 SearchUser Defined Date08DateDT8
169User_Defined_Date09 SearchUser Defined Date09DateDT8
170User_Defined_Date10 SearchUser Defined Date10DateDT8
171User_Defined_Date11 SearchUser Defined Date11DateDT8
172User_Defined_Date12 SearchUser Defined Date12DateDT8
173User_Defined_Date13 SearchUser Defined Date13DateDT8
174User_Defined_Date14 SearchUser Defined Date14DateDT8
175User_Defined_Date15 SearchUser Defined Date15DateDT8
176User_Defined_Date16 SearchUser Defined Date16DateDT8
177User_Defined_Date17 SearchUser Defined Date17DateDT8
178User_Defined_Date18 SearchUser Defined Date18DateDT8
179User_Defined_Date19 SearchUser Defined Date19DateDT8
180User_Defined_Date20 SearchUser Defined Date20DateDT8
181VADCDTRO SearchVendor Address Code - Remit ToStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['SmartList Purchasing Receipts'].VADCDTRO AS 'SmartList Purchasing Receipts-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ASIEXP27 AS ['SmartList Purchasing Receipts']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['SmartList Purchasing Receipts'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['SmartList Purchasing Receipts'].VENDORID = ['PM Address MSTR'].VENDORID
azurecurveProductsSmartList (1493)PathnameSmartList Purchasing Receipts (ASIEXP27)

Leave a Reply

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