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

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_SequenceASI_LI_10_RULong Integer10
2ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
3ASI_Document_Status SearchASI_Document_StatusINTInteger0
4POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString17
5POPTYPE SearchPOP TypeDDL_POP_TypeInteger0
6VNDDOCNM SearchVendor Document NumberSTR20_Document_NumberString20
7receiptdate SearchReceipt DateDTDate8
8GLPOSTDT SearchGL Posting DateDTDate8
9ACTLSHIP SearchActual Ship DateDTDate8
10BCHSOURC SearchBatch SourceSTR15String15
11BACHNUMB SearchBatch NumberSTR15_LBAUString15
12VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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 NameSTR64_Vendor_NameString64
14SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency17
15TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
16TRDPCTPR SearchTrade Discount Percent (Precise)Trade Discount Percent (Precise)Currency (Variable)23
17FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
18MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency17
19TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
20TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency17
21PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
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 AmountINT5_%2Integer5
23DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency11
24DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency17
25DISCDATE SearchDiscount DateDTDate8
26DUEDATE SearchDue DateDTDate8
27REFRENCE SearchReferenceSTR30String30
28VOIDSTTS SearchVoid StatusINTInteger0
29POPHDR1 SearchPOP HDR Errors 1ML_POP_HDR_Errors_1Long Integer0
30POPHDR2 SearchPOP HDR Errors 2ML_POP_HDR_Errors_2Long Integer0
31POPLNERR SearchPOP LINE ErrorsML_POP_LINE_ErrorsLong Integer0
32POSTEDDT SearchPosted DateDATEDate6
33PTDUSRID SearchPosted User IDSTR15String15
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 EnterSTR15_User_IDString15
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 DateDTDate8
36MODIFDT SearchModified DateDTDate8
37TRXSORCE SearchTRX SourceSTR13String13
38VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
39Tax_Date SearchTax DateDTDate8
40CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 IndexINT3Integer3
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 IDSTR15_Rate_Type_IDString15
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 IDSTR15_Exchange_Table_IDString15
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 RateDLR14_Exchange_RateCurrency (Variable)14
45EXCHDATE SearchExchange DateDT_DateDate6
46TIME1 SearchTimeTM6Time6
47RATECALC SearchRate Calc MethodINTInteger0
48DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
49MCTRXSTT SearchMC Transaction StateINT1Integer1
50ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency17
51ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
52ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
53ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency19
54ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
55OR1099AM SearchOriginating 1099 AmountDLR17_RBS0_UTR$Currency17
56ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
57ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency17
58WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency19
59SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean0
60ECTRX 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.
61TXRGNNUM SearchTax Registration NumberSTR25String25
62TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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 TotalYNBoolean0
64Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger0
65Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger0
66FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
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 IDSTR15_LBAUString15
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 AmountDLR19_RBSO_UTR$Currency19
69ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency19
70MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency19
71ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency19
72DISCFRGT SearchDiscount Available FreightDLR17_RBS0_UTR$Currency17
73ORDAVFRT SearchOriginating Discount Available FreightDLR17_RBS0_UTR$Currency17
74DISCMISC SearchDiscount Available MiscDLR17_RBS0_UTR$Currency17
75ORDAVMSC SearchOriginating Discount Available MiscDLR17_RBS0_UTR$Currency17
76BackoutFreightTaxAmt SearchBackout Freight Tax AmountDLR17_RBS0_UTR$Currency17
77OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountDLR17_RBS0_UTR$Currency17
78BackoutMiscTaxAmt SearchBackout Misc Tax AmountDLR17_RBS0_UTR$Currency17
79OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountDLR17_RBS0_UTR$Currency17
80BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency17
81OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency17
82TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean0
83TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean0
84APLYWITH SearchApply WithholdingBooleanBoolean0
85PPSTAXRT SearchPPS Tax RateINT5_%2Integer5
86SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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 StatusINTInteger0
88HIESTBAL SearchHighest BalanceDLR17_RBS0_UTR$Currency17
89CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency19
90NOINVYTD SearchNumber of Invoices YTDLI_9U0Long Integer9
91NOINVLIF SearchNumber of Invoices LIFELI_9U0Long Integer9
92NOINVLYR SearchNumber of Invoices LYRLI_9U0Long Integer9
93NOPINYTD SearchNumber of Paid Invoices YTDLI_9U0Long Integer9
94NOPILIFE SearchNumber of Paid Invoices LIFELI_9U0Long Integer9
95AMBLDTYD SearchAmount Billed YTDDLR19_RBS0_STR$Currency19
96AMBLDLIF SearchAmount Billed LIFEDLR19_RBS0_STR$Currency19
97AMBLDLYR SearchAmount Billed LYRDLR19_RBS0_STR$Currency19
98AMTPDYTD SearchAmount Paid YTDDLR19_RBS0_STR$Currency19
99AMTPDLIF SearchAmount Paid LIFEDLR19_RBS0_STR$Currency19
100AMTPDLYR SearchAmount Paid LYRDLR19_RBS0_STR$Currency19
101TEN99AYTD Search1099 Amount YTDDLR19_RBS0_STR$Currency19
102TEN99ALIF Search1099 Amount LIFEDLR19_RBS0_STR$Currency19
103TEN99ALYR Search1099 Amount LYRDLR19_RBS0_STR$Currency19
104DISAVYTD SearchDiscount Available YTDDLR19_RBS0_STR$Currency19
105DISAVLIF SearchDiscount Available LIFEDLR19_RBS0_STR$Currency19
106DISAVLYR SearchDiscount Available LYRDLR19_RBS0_STR$Currency19
107DISTKYTD SearchDiscount Taken YTDDLR19_RBS0_STR$Currency19
108DISTKNLF SearchDiscount Taken LIFEDLR19_RBS0_STR$Currency19
109DISTKLYR SearchDiscount Taken LYRDLR19_RBS0_STR$Currency19
110DISLSYTD SearchDiscount Lost YTDDLR19_RBS0_STR$Currency19
111DISLSTLF SearchDiscount Lost LIFEDLR19_RBS0_STR$Currency19
112DISLSLYR SearchDiscount Lost LYRDLR19_RBS0_STR$Currency19
113FINCHYTD SearchFinance Charge YTDDLR19_RBS0_STR$Currency19
114FINCHLIF SearchFinance Charge LIFEDLR19_RBS0_STR$Currency19
115FINCHLYR SearchFinance Charge LYRDLR19_RBS0_STR$Currency19
116WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency19
117WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency19
118WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency19
119RTRNSYTD SearchReturns YTDDLR19_RBS0_STR$Currency19
120RTRNSLIF SearchReturns LIFEDLR19_RBS0_STR$Currency19
121RTRNSLYR SearchReturns LYRDLR19_RBS0_STR$Currency19
122TRDTYTD SearchTrade Discounts Taken YTDDLR19_RBSO_STR$Currency19
123TRDTKLIF SearchTrade Discounts Taken LIFEDLR19_RBSO_STR$Currency19
124TRDTLYR SearchTrade Discounts Taken LYRDLR19_RBSO_STR$Currency19
125NFNCHYTD SearchNumber of Finance Charges YTDLI_9U0Long Integer9
126NFNCHLIF SearchNumber of Finance Charges LIFELI_9U0Long Integer9
127NFNCHLYR SearchNumber of Finance Charges LYRLI_9U0Long Integer9
128RTNGOWED SearchRetainage OwedDLR17_RBS0_STR$Currency17
129LSTCHNUM SearchLast Check NumberCheck_NumberString20
130LSTCHKDT SearchLast Check DateDTDate8
131LSTCHAMT SearchLast Check AmountDLR17_RBS0_UTR$Currency17
132LSTINNUM SearchLast Invoice NumberSTR20String20
133LSTINVAM SearchLast Invoice AmountDLR17_RBS0_UTR$Currency17
134LSTPURDT SearchLast Purchase DateDTDate8
135FSTPURDT SearchFirst Purchase DateDTDate8
136CURUNPBN SearchCurrent Unapplied Payment BalanceDLR17_RBS0_UTR$Currency17
137UNPDFNCH SearchUnpaid Finance ChargesDLR17_RBS0_UTR$Currency17
138DYCHTCLR SearchDays Checks To ClearINT3_U0Integer3
139AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer3
140AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer3
141ACCRDINV SearchAccured InventoryDLR17_RBS0_STR$Currency17
142ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency19
143WITHYTD SearchWithholding YTDDLR19_RBS0_STR$Currency19
144Withholding_LIFE SearchWithholding LIFEDLR19_RBS0_STR$Currency19
145WITHLYR SearchWithholding LYRDLR19_RBS0_STR$Currency19
146User_Defined_List01 SearchUser Defined List01STR30String30
147User_Defined_List02 SearchUser Defined List02STR30String30
148User_Defined_List03 SearchUser Defined List03STR30String30
149User_Defined_List04 SearchUser Defined List04STR30String30
150User_Defined_List05 SearchUser Defined List05STR30String30
151User_Defined_Text01 SearchUser Defined Text01STR30String30
152User_Defined_Text02 SearchUser Defined Text02STR30String30
153User_Defined_Text03 SearchUser Defined Text03STR30String30
154User_Defined_Text04 SearchUser Defined Text04STR30String30
155User_Defined_Text05 SearchUser Defined Text05STR30String30
156User_Defined_Text06 SearchUser Defined Text06STR30String30
157User_Defined_Text07 SearchUser Defined Text07STR30String30
158User_Defined_Text08 SearchUser Defined Text08STR30String30
159User_Defined_Text09 SearchUser Defined Text09STR30String30
160User_Defined_Text10 SearchUser Defined Text10STR30String30
161User_Defined_Date01 SearchUser Defined Date01DTDate8
162User_Defined_Date02 SearchUser Defined Date02DTDate8
163User_Defined_Date03 SearchUser Defined Date03DTDate8
164User_Defined_Date04 SearchUser Defined Date04DTDate8
165User_Defined_Date05 SearchUser Defined Date05DTDate8
166User_Defined_Date06 SearchUser Defined Date06DTDate8
167User_Defined_Date07 SearchUser Defined Date07DTDate8
168User_Defined_Date08 SearchUser Defined Date08DTDate8
169User_Defined_Date09 SearchUser Defined Date09DTDate8
170User_Defined_Date10 SearchUser Defined Date10DTDate8
171User_Defined_Date11 SearchUser Defined Date11DTDate8
172User_Defined_Date12 SearchUser Defined Date12DTDate8
173User_Defined_Date13 SearchUser Defined Date13DTDate8
174User_Defined_Date14 SearchUser Defined Date14DTDate8
175User_Defined_Date15 SearchUser Defined Date15DTDate8
176User_Defined_Date16 SearchUser Defined Date16DTDate8
177User_Defined_Date17 SearchUser Defined Date17DTDate8
178User_Defined_Date18 SearchUser Defined Date18DTDate8
179User_Defined_Date19 SearchUser Defined Date19DTDate8
180User_Defined_Date20 SearchUser Defined Date20DTDate8
181VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString15
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 *