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 TypeSQL DB LengthKeyable Length
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
2ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
3ASI_Document_Status SearchASI_Document_StatusINTInteger20
4POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString1817
5POPTYPE SearchPOP TypeDDL_POP_TypeInteger20
6VNDDOCNM SearchVendor Document NumberSTR20_Document_NumberString2220
7receiptdate SearchReceipt DateDTDate48
8GLPOSTDT SearchGL Posting DateDTDate48
9ACTLSHIP SearchActual Ship DateDTDate48
10BCHSOURC SearchBatch SourceSTR15String1615
11BACHNUMB SearchBatch NumberSTR15_LBAUString1615
12VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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_NameString6664
14SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency1017
15TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
16TRDPCTPR SearchTrade Discount Percent (Precise)Trade Discount Percent (Precise)Currency (Variable)1223
17FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
18MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency1017
19TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
20TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency1017
21PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
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_%2Integer25
23DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
24DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency1017
25DISCDATE SearchDiscount DateDTDate48
26DUEDATE SearchDue DateDTDate48
27REFRENCE SearchReferenceSTR30String3230
28VOIDSTTS SearchVoid StatusINTInteger20
29POPHDR1 SearchPOP HDR Errors 1ML_POP_HDR_Errors_1Long Integer40
30POPHDR2 SearchPOP HDR Errors 2ML_POP_HDR_Errors_2Long Integer40
31POPLNERR SearchPOP LINE ErrorsML_POP_LINE_ErrorsLong Integer40
32POSTEDDT SearchPosted DateDATEDate46
33PTDUSRID SearchPosted User IDSTR15String1615
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_IDString1615
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 DateDTDate48
36MODIFDT SearchModified DateDTDate48
37TRXSORCE SearchTRX SourceSTR13String1413
38VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
39Tax_Date SearchTax DateDTDate48
40CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 IndexINT3Integer23
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_IDString1615
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_IDString1615
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)1014
45EXCHDATE SearchExchange DateDT_DateDate46
46TIME1 SearchTimeTM6Time46
47RATECALC SearchRate Calc MethodINTInteger20
48DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
49MCTRXSTT SearchMC Transaction StateINT1Integer21
50ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency1017
51ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
52ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
53ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency1019
54ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
55OR1099AM SearchOriginating 1099 AmountDLR17_RBS0_UTR$Currency1017
56ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency1011
57ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency1017
58WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency1019
59SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
60ECTRX SearchEC TransactionCB_EC_TransactionBoolean20
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 NumberSTR25String2625
62TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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 TotalYNBoolean20
64Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger20
65Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger20
66FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
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_LBAUString1615
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$Currency1019
69ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency1019
70MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency1019
71ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency1019
72DISCFRGT SearchDiscount Available FreightDLR17_RBS0_UTR$Currency1017
73ORDAVFRT SearchOriginating Discount Available FreightDLR17_RBS0_UTR$Currency1017
74DISCMISC SearchDiscount Available MiscDLR17_RBS0_UTR$Currency1017
75ORDAVMSC SearchOriginating Discount Available MiscDLR17_RBS0_UTR$Currency1017
76BackoutFreightTaxAmt SearchBackout Freight Tax AmountDLR17_RBS0_UTR$Currency1017
77OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountDLR17_RBS0_UTR$Currency1017
78BackoutMiscTaxAmt SearchBackout Misc Tax AmountDLR17_RBS0_UTR$Currency1017
79OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountDLR17_RBS0_UTR$Currency1017
80BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency1017
81OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency1017
82TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean20
83TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
84APLYWITH SearchApply WithholdingBooleanBoolean20
85PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
86SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
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 StatusINTInteger20
88HIESTBAL SearchHighest BalanceDLR17_RBS0_UTR$Currency1017
89CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency1019
90NOINVYTD SearchNumber of Invoices YTDLI_9U0Long Integer49
91NOINVLIF SearchNumber of Invoices LIFELI_9U0Long Integer49
92NOINVLYR SearchNumber of Invoices LYRLI_9U0Long Integer49
93NOPINYTD SearchNumber of Paid Invoices YTDLI_9U0Long Integer49
94NOPILIFE SearchNumber of Paid Invoices LIFELI_9U0Long Integer49
95AMBLDTYD SearchAmount Billed YTDDLR19_RBS0_STR$Currency1019
96AMBLDLIF SearchAmount Billed LIFEDLR19_RBS0_STR$Currency1019
97AMBLDLYR SearchAmount Billed LYRDLR19_RBS0_STR$Currency1019
98AMTPDYTD SearchAmount Paid YTDDLR19_RBS0_STR$Currency1019
99AMTPDLIF SearchAmount Paid LIFEDLR19_RBS0_STR$Currency1019
100AMTPDLYR SearchAmount Paid LYRDLR19_RBS0_STR$Currency1019
101TEN99AYTD Search1099 Amount YTDDLR19_RBS0_STR$Currency1019
102TEN99ALIF Search1099 Amount LIFEDLR19_RBS0_STR$Currency1019
103TEN99ALYR Search1099 Amount LYRDLR19_RBS0_STR$Currency1019
104DISAVYTD SearchDiscount Available YTDDLR19_RBS0_STR$Currency1019
105DISAVLIF SearchDiscount Available LIFEDLR19_RBS0_STR$Currency1019
106DISAVLYR SearchDiscount Available LYRDLR19_RBS0_STR$Currency1019
107DISTKYTD SearchDiscount Taken YTDDLR19_RBS0_STR$Currency1019
108DISTKNLF SearchDiscount Taken LIFEDLR19_RBS0_STR$Currency1019
109DISTKLYR SearchDiscount Taken LYRDLR19_RBS0_STR$Currency1019
110DISLSYTD SearchDiscount Lost YTDDLR19_RBS0_STR$Currency1019
111DISLSTLF SearchDiscount Lost LIFEDLR19_RBS0_STR$Currency1019
112DISLSLYR SearchDiscount Lost LYRDLR19_RBS0_STR$Currency1019
113FINCHYTD SearchFinance Charge YTDDLR19_RBS0_STR$Currency1019
114FINCHLIF SearchFinance Charge LIFEDLR19_RBS0_STR$Currency1019
115FINCHLYR SearchFinance Charge LYRDLR19_RBS0_STR$Currency1019
116WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency1019
117WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency1019
118WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency1019
119RTRNSYTD SearchReturns YTDDLR19_RBS0_STR$Currency1019
120RTRNSLIF SearchReturns LIFEDLR19_RBS0_STR$Currency1019
121RTRNSLYR SearchReturns LYRDLR19_RBS0_STR$Currency1019
122TRDTYTD SearchTrade Discounts Taken YTDDLR19_RBSO_STR$Currency1019
123TRDTKLIF SearchTrade Discounts Taken LIFEDLR19_RBSO_STR$Currency1019
124TRDTLYR SearchTrade Discounts Taken LYRDLR19_RBSO_STR$Currency1019
125NFNCHYTD SearchNumber of Finance Charges YTDLI_9U0Long Integer49
126NFNCHLIF SearchNumber of Finance Charges LIFELI_9U0Long Integer49
127NFNCHLYR SearchNumber of Finance Charges LYRLI_9U0Long Integer49
128RTNGOWED SearchRetainage OwedDLR17_RBS0_STR$Currency1017
129LSTCHNUM SearchLast Check NumberCheck_NumberString2220
130LSTCHKDT SearchLast Check DateDTDate48
131LSTCHAMT SearchLast Check AmountDLR17_RBS0_UTR$Currency1017
132LSTINNUM SearchLast Invoice NumberSTR20String2220
133LSTINVAM SearchLast Invoice AmountDLR17_RBS0_UTR$Currency1017
134LSTPURDT SearchLast Purchase DateDTDate48
135FSTPURDT SearchFirst Purchase DateDTDate48
136CURUNPBN SearchCurrent Unapplied Payment BalanceDLR17_RBS0_UTR$Currency1017
137UNPDFNCH SearchUnpaid Finance ChargesDLR17_RBS0_UTR$Currency1017
138DYCHTCLR SearchDays Checks To ClearINT3_U0Integer23
139AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer23
140AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer23
141ACCRDINV SearchAccured InventoryDLR17_RBS0_STR$Currency1017
142ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
143WITHYTD SearchWithholding YTDDLR19_RBS0_STR$Currency1019
144Withholding_LIFE SearchWithholding LIFEDLR19_RBS0_STR$Currency1019
145WITHLYR SearchWithholding LYRDLR19_RBS0_STR$Currency1019
146User_Defined_List01 SearchUser Defined List01STR30String3230
147User_Defined_List02 SearchUser Defined List02STR30String3230
148User_Defined_List03 SearchUser Defined List03STR30String3230
149User_Defined_List04 SearchUser Defined List04STR30String3230
150User_Defined_List05 SearchUser Defined List05STR30String3230
151User_Defined_Text01 SearchUser Defined Text01STR30String3230
152User_Defined_Text02 SearchUser Defined Text02STR30String3230
153User_Defined_Text03 SearchUser Defined Text03STR30String3230
154User_Defined_Text04 SearchUser Defined Text04STR30String3230
155User_Defined_Text05 SearchUser Defined Text05STR30String3230
156User_Defined_Text06 SearchUser Defined Text06STR30String3230
157User_Defined_Text07 SearchUser Defined Text07STR30String3230
158User_Defined_Text08 SearchUser Defined Text08STR30String3230
159User_Defined_Text09 SearchUser Defined Text09STR30String3230
160User_Defined_Text10 SearchUser Defined Text10STR30String3230
161User_Defined_Date01 SearchUser Defined Date01DTDate48
162User_Defined_Date02 SearchUser Defined Date02DTDate48
163User_Defined_Date03 SearchUser Defined Date03DTDate48
164User_Defined_Date04 SearchUser Defined Date04DTDate48
165User_Defined_Date05 SearchUser Defined Date05DTDate48
166User_Defined_Date06 SearchUser Defined Date06DTDate48
167User_Defined_Date07 SearchUser Defined Date07DTDate48
168User_Defined_Date08 SearchUser Defined Date08DTDate48
169User_Defined_Date09 SearchUser Defined Date09DTDate48
170User_Defined_Date10 SearchUser Defined Date10DTDate48
171User_Defined_Date11 SearchUser Defined Date11DTDate48
172User_Defined_Date12 SearchUser Defined Date12DTDate48
173User_Defined_Date13 SearchUser Defined Date13DTDate48
174User_Defined_Date14 SearchUser Defined Date14DTDate48
175User_Defined_Date15 SearchUser Defined Date15DTDate48
176User_Defined_Date16 SearchUser Defined Date16DTDate48
177User_Defined_Date17 SearchUser Defined Date17DTDate48
178User_Defined_Date18 SearchUser Defined Date18DTDate48
179User_Defined_Date19 SearchUser Defined Date19DTDate48
180User_Defined_Date20 SearchUser Defined Date20DTDate48
181VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString1615
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 *