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_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ASI_Favorite_Sequence 
ASI_Favorite_Sequence ASI_LI_10_RU Long Integer 10 2 ASI_Order_By ASI_Order_By LI_14 Long Integer 14 3 ASI_Document_Status ASI_Document_Status INT Integer 0 4 POPRCTNM POP Receipt Number STR17_POP_Number String 17 5 POPTYPE POP Type DDL_POP_Type Integer 0 6 VNDDOCNM Vendor Document Number STR20_Document_Number String 20 7 receiptdate Receipt Date DT Date 8 8 GLPOSTDT GL Posting Date DT Date 8 9 ACTLSHIP Actual Ship Date DT Date 8 10 BCHSOURC Batch Source STR15 String 15 11 BACHNUMB Batch Number STR15_LBAU String 15 12 VENDORID Vendor ID STR_15_Vendor_ID String 15 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'].VENDORID13 VENDNAME Vendor Name STR64_Vendor_Name String 64 14 SUBTOTAL Subtotal DLR17_RBS0_STR$ Currency 17 15 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 16 TRDPCTPR Trade Discount Percent (Precise) Trade Discount Percent (Precise) Currency (Variable) 23 17 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 18 MISCAMNT Misc Amount DLR17_RBS0_UTR$ Currency 17 19 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 20 TEN99AMNT 1099 Amount DLR17_RBS0_UTR$ Currency 17 21 PYMTRMID Payment Terms ID STR20_Payment_Terms_ID String 20 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'].PYMTRMID22 DSCPCTAM Discount Percent Amount INT5_%2 Integer 5 23 DSCDLRAM Discount Dollar Amount DLR11_RBS0_UTR$ Currency 11 24 DISAVAMT Discount Available Amount DLR17_RBS0_UTR$ Currency 17 25 DISCDATE Discount Date DT Date 8 26 DUEDATE Due Date DT Date 8 27 REFRENCE Reference STR30 String 30 28 VOIDSTTS Void Status INT Integer 0 29 POPHDR1 POP HDR Errors 1 ML_POP_HDR_Errors_1 Long Integer 0 30 POPHDR2 POP HDR Errors 2 ML_POP_HDR_Errors_2 Long Integer 0 31 POPLNERR POP LINE Errors ML_POP_LINE_Errors Long Integer 0 32 POSTEDDT Posted Date DATE Date 6 33 PTDUSRID Posted User ID STR15 String 15 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'].USERID34 USER2ENT User To Enter STR15_User_ID String 15 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'].USERID35 CREATDDT Created Date DT Date 8 36 MODIFDT Modified Date DT Date 8 37 TRXSORCE TRX Source STR13 String 13 38 VCHRNMBR Voucher Number STR20_LBAU String 20 39 Tax_Date Tax Date DT Date 8 40 CURNCYID Currency ID STR15_Currency_ID String 15 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'].CURNCYID41 CURRNIDX Currency Index INT3 Integer 3 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'].CURRNIDX42 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 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'].RATETPID43 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 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'].EXGTBLID44 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 45 EXCHDATE Exchange Date DT_Date Date 6 46 TIME1 Time TM6 Time 6 47 RATECALC Rate Calc Method INT Integer 0 48 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 49 MCTRXSTT MC Transaction State INT1 Integer 1 50 ORSUBTOT Originating Subtotal DLR17_RBS0_STR$ Currency 17 51 ORTDISAM Originating Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 52 ORFRTAMT Originating Freight Amount DLR17_RBS0_UTR$ Currency 17 53 ORMISCAMT Originating Misc Amount DLR19_RBSO_UTR$ Currency 19 54 ORTAXAMT Originating Tax Amount DLR17_RBS0_UTR$ Currency 17 55 OR1099AM Originating 1099 Amount DLR17_RBS0_UTR$ Currency 17 56 ORDDLRAT Originating Discount Dollar Amount DLR11_RBS0_UTR$ Currency 11 57 ORDAVAMT Originating Discount Available Amount DLR17_RBS0_UTR$ Currency 17 58 WITHHAMT Withholding Amount DLR19_RBSO_UTR$ Currency 19 59 SIMPLIFD Simplified CB_Simplified Boolean 0 60 ECTRX EC Transaction CB_EC_Transaction Boolean 0 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.61 TXRGNNUM Tax Registration Number STR25 String 25 62 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 15 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'].TAXSCHID63 BSIVCTTL Based On Invoice Total YN Boolean 0 64 Purchase_Freight_Taxable Purchase Freight Taxable DDL_Purchase_Tax_Options Integer 0 65 Purchase_Misc_Taxable Purchase Misc Taxable DDL_Purchase_Tax_Options Integer 0 66 FRTSCHID Freight Schedule ID STR15_LBAU String 15 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'].TAXSCHID67 MSCSCHID Misc Schedule ID STR15_LBAU String 15 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'].TAXSCHID68 FRTTXAMT Freight Tax Amount DLR19_RBSO_UTR$ Currency 19 69 ORFRTTAX Originating Freight Tax Amount DLR19_RBSO_UTR$ Currency 19 70 MSCTXAMT Misc Tax Amount DLR19_RBSO_UTR$ Currency 19 71 ORMSCTAX Originating Misc Tax Amount DLR19_RBSO_UTR$ Currency 19 72 DISCFRGT Discount Available Freight DLR17_RBS0_UTR$ Currency 17 73 ORDAVFRT Originating Discount Available Freight DLR17_RBS0_UTR$ Currency 17 74 DISCMISC Discount Available Misc DLR17_RBS0_UTR$ Currency 17 75 ORDAVMSC Originating Discount Available Misc DLR17_RBS0_UTR$ Currency 17 76 BackoutFreightTaxAmt Backout Freight Tax Amount DLR17_RBS0_UTR$ Currency 17 77 OrigBackoutFreightTaxAmt Originating Backout Freight Tax Amount DLR17_RBS0_UTR$ Currency 17 78 BackoutMiscTaxAmt Backout Misc Tax Amount DLR17_RBS0_UTR$ Currency 17 79 OrigBackoutMiscTaxAmt Originating Backout Misc Tax Amount DLR17_RBS0_UTR$ Currency 17 80 BCKTXAMT Backout Tax Amount DLR17_RBS0_UTR$ Currency 17 81 OBTAXAMT Originating Backout Tax Amount DLR17_RBS0_UTR$ Currency 17 82 TaxInvReqd Tax Invoice Required CB_Tax_Invoice_Required Boolean 0 83 TaxInvRecvd Tax Invoice Received CB_Tax_Invoice_Received Boolean 0 84 APLYWITH Apply Withholding Boolean Boolean 0 85 PPSTAXRT PPS Tax Rate INT5_%2 Integer 5 86 SHIPMTHD Shipping Method STR15_Shipping_Method String 15 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'].SHIPMTHD87 PSTGSTUS Posting Status INT Integer 0 88 HIESTBAL Highest Balance DLR17_RBS0_UTR$ Currency 17 89 CURRBLNC Current Balance DLR19_RBS0_STR$ Currency 19 90 NOINVYTD Number of Invoices YTD LI_9U0 Long Integer 9 91 NOINVLIF Number of Invoices LIFE LI_9U0 Long Integer 9 92 NOINVLYR Number of Invoices LYR LI_9U0 Long Integer 9 93 NOPINYTD Number of Paid Invoices YTD LI_9U0 Long Integer 9 94 NOPILIFE Number of Paid Invoices LIFE LI_9U0 Long Integer 9 95 AMBLDTYD Amount Billed YTD DLR19_RBS0_STR$ Currency 19 96 AMBLDLIF Amount Billed LIFE DLR19_RBS0_STR$ Currency 19 97 AMBLDLYR Amount Billed LYR DLR19_RBS0_STR$ Currency 19 98 AMTPDYTD Amount Paid YTD DLR19_RBS0_STR$ Currency 19 99 AMTPDLIF Amount Paid LIFE DLR19_RBS0_STR$ Currency 19 100 AMTPDLYR Amount Paid LYR DLR19_RBS0_STR$ Currency 19 101 TEN99AYTD 1099 Amount YTD DLR19_RBS0_STR$ Currency 19 102 TEN99ALIF 1099 Amount LIFE DLR19_RBS0_STR$ Currency 19 103 TEN99ALYR 1099 Amount LYR DLR19_RBS0_STR$ Currency 19 104 DISAVYTD Discount Available YTD DLR19_RBS0_STR$ Currency 19 105 DISAVLIF Discount Available LIFE DLR19_RBS0_STR$ Currency 19 106 DISAVLYR Discount Available LYR DLR19_RBS0_STR$ Currency 19 107 DISTKYTD Discount Taken YTD DLR19_RBS0_STR$ Currency 19 108 DISTKNLF Discount Taken LIFE DLR19_RBS0_STR$ Currency 19 109 DISTKLYR Discount Taken LYR DLR19_RBS0_STR$ Currency 19 110 DISLSYTD Discount Lost YTD DLR19_RBS0_STR$ Currency 19 111 DISLSTLF Discount Lost LIFE DLR19_RBS0_STR$ Currency 19 112 DISLSLYR Discount Lost LYR DLR19_RBS0_STR$ Currency 19 113 FINCHYTD Finance Charge YTD DLR19_RBS0_STR$ Currency 19 114 FINCHLIF Finance Charge LIFE DLR19_RBS0_STR$ Currency 19 115 FINCHLYR Finance Charge LYR DLR19_RBS0_STR$ Currency 19 116 WROFSYTD Write Offs YTD DLR19_RBS0_STR$ Currency 19 117 WROFSLIF Write Offs LIFE DLR19_RBS0_STR$ Currency 19 118 WROFSLYR Write Offs LYR DLR19_RBS0_STR$ Currency 19 119 RTRNSYTD Returns YTD DLR19_RBS0_STR$ Currency 19 120 RTRNSLIF Returns LIFE DLR19_RBS0_STR$ Currency 19 121 RTRNSLYR Returns LYR DLR19_RBS0_STR$ Currency 19 122 TRDTYTD Trade Discounts Taken YTD DLR19_RBSO_STR$ Currency 19 123 TRDTKLIF Trade Discounts Taken LIFE DLR19_RBSO_STR$ Currency 19 124 TRDTLYR Trade Discounts Taken LYR DLR19_RBSO_STR$ Currency 19 125 NFNCHYTD Number of Finance Charges YTD LI_9U0 Long Integer 9 126 NFNCHLIF Number of Finance Charges LIFE LI_9U0 Long Integer 9 127 NFNCHLYR Number of Finance Charges LYR LI_9U0 Long Integer 9 128 RTNGOWED Retainage Owed DLR17_RBS0_STR$ Currency 17 129 LSTCHNUM Last Check Number Check_Number String 20 130 LSTCHKDT Last Check Date DT Date 8 131 LSTCHAMT Last Check Amount DLR17_RBS0_UTR$ Currency 17 132 LSTINNUM Last Invoice Number STR20 String 20 133 LSTINVAM Last Invoice Amount DLR17_RBS0_UTR$ Currency 17 134 LSTPURDT Last Purchase Date DT Date 8 135 FSTPURDT First Purchase Date DT Date 8 136 CURUNPBN Current Unapplied Payment Balance DLR17_RBS0_UTR$ Currency 17 137 UNPDFNCH Unpaid Finance Charges DLR17_RBS0_UTR$ Currency 17 138 DYCHTCLR Days Checks To Clear INT3_U0 Integer 3 139 AVGDTPYR Average Days To Pay - Year INT3_U0 Integer 3 140 AVDTPLIF Average Days To Pay - Life INT3_U0 Integer 3 141 ACCRDINV Accured Inventory DLR17_RBS0_STR$ Currency 17 142 ONORDAMT On Order Amount DLR19_RBS0_UTR$ Currency 19 143 WITHYTD Withholding YTD DLR19_RBS0_STR$ Currency 19 144 Withholding_LIFE Withholding LIFE DLR19_RBS0_STR$ Currency 19 145 WITHLYR Withholding LYR DLR19_RBS0_STR$ Currency 19 146 User_Defined_List01 User Defined List01 STR30 String 30 147 User_Defined_List02 User Defined List02 STR30 String 30 148 User_Defined_List03 User Defined List03 STR30 String 30 149 User_Defined_List04 User Defined List04 STR30 String 30 150 User_Defined_List05 User Defined List05 STR30 String 30 151 User_Defined_Text01 User Defined Text01 STR30 String 30 152 User_Defined_Text02 User Defined Text02 STR30 String 30 153 User_Defined_Text03 User Defined Text03 STR30 String 30 154 User_Defined_Text04 User Defined Text04 STR30 String 30 155 User_Defined_Text05 User Defined Text05 STR30 String 30 156 User_Defined_Text06 User Defined Text06 STR30 String 30 157 User_Defined_Text07 User Defined Text07 STR30 String 30 158 User_Defined_Text08 User Defined Text08 STR30 String 30 159 User_Defined_Text09 User Defined Text09 STR30 String 30 160 User_Defined_Text10 User Defined Text10 STR30 String 30 161 User_Defined_Date01 User Defined Date01 DT Date 8 162 User_Defined_Date02 User Defined Date02 DT Date 8 163 User_Defined_Date03 User Defined Date03 DT Date 8 164 User_Defined_Date04 User Defined Date04 DT Date 8 165 User_Defined_Date05 User Defined Date05 DT Date 8 166 User_Defined_Date06 User Defined Date06 DT Date 8 167 User_Defined_Date07 User Defined Date07 DT Date 8 168 User_Defined_Date08 User Defined Date08 DT Date 8 169 User_Defined_Date09 User Defined Date09 DT Date 8 170 User_Defined_Date10 User Defined Date10 DT Date 8 171 User_Defined_Date11 User Defined Date11 DT Date 8 172 User_Defined_Date12 User Defined Date12 DT Date 8 173 User_Defined_Date13 User Defined Date13 DT Date 8 174 User_Defined_Date14 User Defined Date14 DT Date 8 175 User_Defined_Date15 User Defined Date15 DT Date 8 176 User_Defined_Date16 User Defined Date16 DT Date 8 177 User_Defined_Date17 User Defined Date17 DT Date 8 178 User_Defined_Date18 User Defined Date18 DT Date 8 179 User_Defined_Date19 User Defined Date19 DT Date 8 180 User_Defined_Date20 User Defined Date20 DT Date 8 181 VADCDTRO Vendor Address Code - Remit To STR15_Address_Code String 15 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