GP Tables

ASIEXP27 - SmartList Purchasing Receipts

Dynamics GP table ASIEXP27 (SmartList Purchasing Receipts) contains 181 columns including ASI_Favorite_Sequence, ASI_Order_By, ASI_Document_Status....

SQL Query Builder

181 Columns

Column Description Type Length
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
ASI_Order_By ASI_Order_By Long Integer 4
ASI_Document_Status ASI_Document_Status Integer 2
POPRCTNM POP Receipt Number String 18
POPTYPE POP Type Integer 2
VNDDOCNM Vendor Document Number String 22
receiptdate Receipt Date Date 4
GLPOSTDT GL Posting Date Date 4
ACTLSHIP Actual Ship Date Date 4
BCHSOURC Batch Source String 16
BACHNUMB Batch Number String 16
VENDORID Vendor ID String 16
VENDNAME Vendor Name String 66
SUBTOTAL Subtotal Currency 10
TRDISAMT Trade Discount Amount Currency 10
TRDPCTPR Trade Discount Percent (Precise) Currency (Variable) 12
FRTAMNT Freight Amount Currency 10
MISCAMNT Misc Amount Currency 10
TAXAMNT Tax Amount Currency 10
TEN99AMNT 1099 Amount Currency 10
PYMTRMID Payment Terms ID String 22
DSCPCTAM Discount Percent Amount Integer 2
DSCDLRAM Discount Dollar Amount Currency 10
DISAVAMT Discount Available Amount Currency 10
DISCDATE Discount Date Date 4
DUEDATE Due Date Date 4
REFRENCE Reference String 32
VOIDSTTS Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. Integer 2
Void Status values (2)
0 = Normal1 = Voided
POPHDR1 POP HDR Errors 1 Long Integer 4
POPHDR2 POP HDR Errors 2 Long Integer 4
POPLNERR POP LINE Errors Long Integer 4
POSTEDDT Posted Date Date 4
PTDUSRID Posted User ID String 16
USER2ENT User To Enter String 16
CREATDDT Created Date Date 4
MODIFDT Modified Date Date 4
TRXSORCE TRX Source String 14
VCHRNMBR Voucher Number String 22
Tax_Date Tax Date Date 4
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
CURRNIDX Currency Index Integer 2
RATETPID Rate Type ID String 16
EXGTBLID Exchange Table ID String 16
XCHGRATE Exchange Rate Currency (Variable) 10
EXCHDATE Exchange Date Date 4
TIME1 Time Time 4
RATECALC Rate Calc Method Integer 2
DENXRATE Denomination Exchange Rate Currency (Variable) 10
MCTRXSTT MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = Originating is not a denomination; Functional is the Euro currency.3 = Originating is not a denomination; Functional is a denomination.4 = Originating is a denomination; Functional is not a denomination.5 = Originating is a denomination; Functional is a denomination.6 = Originating is a denomination; Functional is the Euro currency.7 = Originating is the Euro currency; Functional is a denomination.8 = Originating is the Euro currency; Functional is not a denomination. Integer 2
ORSUBTOT Originating Subtotal Currency 10
ORTDISAM Originating Trade Discount Amount Currency 10
ORFRTAMT Originating Freight Amount Currency 10
ORMISCAMT Originating Misc Amount Currency 10
ORTAXAMT Originating Tax Amount Currency 10
OR1099AM Originating 1099 Amount Currency 10
ORDDLRAT Originating Discount Dollar Amount Currency 10
ORDAVAMT Originating Discount Available Amount Currency 10
WITHHAMT Withholding Amount Currency 10
SIMPLIFD Simplified Boolean 2
ECTRX EC Transaction Boolean 2
TXRGNNUM Tax Registration Number String 26
TAXSCHID Tax Schedule ID String 16
BSIVCTTL Based On Invoice Total Boolean 2
Purchase_Freight_Taxable Purchase Freight Taxable Integer 2
Purchase_Misc_Taxable Purchase Misc Taxable Integer 2
FRTSCHID Freight Schedule ID String 16
MSCSCHID Misc Schedule ID String 16
FRTTXAMT Freight Tax Amount Currency 10
ORFRTTAX Originating Freight Tax Amount Currency 10
MSCTXAMT Misc Tax Amount Currency 10
ORMSCTAX Originating Misc Tax Amount Currency 10
DISCFRGT Discount Available Freight Currency 10
ORDAVFRT Originating Discount Available Freight Currency 10
DISCMISC Discount Available Misc Currency 10
ORDAVMSC Originating Discount Available Misc Currency 10
BackoutFreightTaxAmt Backout Freight Tax Amount Currency 10
OrigBackoutFreightTaxAmt Originating Backout Freight Tax Amount Currency 10
BackoutMiscTaxAmt Backout Misc Tax Amount Currency 10
OrigBackoutMiscTaxAmt Originating Backout Misc Tax Amount Currency 10
BCKTXAMT Backout Tax Amount Currency 10
OBTAXAMT Originating Backout Tax Amount Currency 10
TaxInvReqd Tax Invoice Required Boolean 2
TaxInvRecvd Tax Invoice Received Boolean 2
APLYWITH Apply Withholding Boolean 2
PPSTAXRT PPS Tax Rate Integer 2
SHIPMTHD Shipping Method String 16
PSTGSTUS Posting Status1 = Work2 = Open3 = History4 = Originating Integer 2
Posting Status values (11)
0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
HIESTBAL Highest Balance Currency 10
CURRBLNC Current Balance Currency 10
NOINVYTD Number of Invoices YTD Long Integer 4
NOINVLIF Number of Invoices LIFE Long Integer 4
NOINVLYR Number of Invoices LYR Long Integer 4
NOPINYTD Number of Paid Invoices YTD Long Integer 4
NOPILIFE Number of Paid Invoices LIFE Long Integer 4
AMBLDTYD Amount Billed YTD Currency 10
AMBLDLIF Amount Billed LIFE Currency 10
AMBLDLYR Amount Billed LYR Currency 10
AMTPDYTD Amount Paid YTD Currency 10
AMTPDLIF Amount Paid LIFE Currency 10
AMTPDLYR Amount Paid LYR Currency 10
TEN99AYTD 1099 Amount YTD Currency 10
TEN99ALIF 1099 Amount LIFE Currency 10
TEN99ALYR 1099 Amount LYR Currency 10
DISAVYTD Discount Available YTD Currency 10
DISAVLIF Discount Available LIFE Currency 10
DISAVLYR Discount Available LYR Currency 10
DISTKYTD Discount Taken YTD Currency 10
DISTKNLF Discount Taken LIFE Currency 10
DISTKLYR Discount Taken LYR Currency 10
DISLSYTD Discount Lost YTD Currency 10
DISLSTLF Discount Lost LIFE Currency 10
DISLSLYR Discount Lost LYR Currency 10
FINCHYTD Finance Charge YTD Currency 10
FINCHLIF Finance Charge LIFE Currency 10
FINCHLYR Finance Charge LYR Currency 10
WROFSYTD Write Offs YTD Currency 10
WROFSLIF Write Offs LIFE Currency 10
WROFSLYR Write Offs LYR Currency 10
RTRNSYTD Returns YTD Currency 10
RTRNSLIF Returns LIFE Currency 10
RTRNSLYR Returns LYR Currency 10
TRDTYTD Trade Discounts Taken YTD Currency 10
TRDTKLIF Trade Discounts Taken LIFE Currency 10
TRDTLYR Trade Discounts Taken LYR Currency 10
NFNCHYTD Number of Finance Charges YTD Long Integer 4
NFNCHLIF Number of Finance Charges LIFE Long Integer 4
NFNCHLYR Number of Finance Charges LYR Long Integer 4
RTNGOWED Retainage Owed Currency 10
LSTCHNUM Last Check Number String 22
LSTCHKDT Last Check Date Date 4
LSTCHAMT Last Check Amount Currency 10
LSTINNUM Last Invoice Number String 22
LSTINVAM Last Invoice Amount Currency 10
LSTPURDT Last Purchase Date Date 4
FSTPURDT First Purchase Date Date 4
CURUNPBN Current Unapplied Payment Balance Currency 10
UNPDFNCH Unpaid Finance Charges Currency 10
DYCHTCLR Days Checks To Clear Integer 2
AVGDTPYR Average Days To Pay - Year Integer 2
AVDTPLIF Average Days To Pay - Life Integer 2
ACCRDINV Accured Inventory Currency 10
ONORDAMT On Order Amount Currency 10
WITHYTD Withholding YTD Currency 10
Withholding_LIFE Withholding LIFE Currency 10
WITHLYR Withholding LYR Currency 10
User_Defined_List01 User Defined List01 String 32
User_Defined_List02 User Defined List02 String 32
User_Defined_List03 User Defined List03 String 32
User_Defined_List04 User Defined List04 String 32
User_Defined_List05 User Defined List05 String 32
User_Defined_Text01 User Defined Text01 String 32
User_Defined_Text02 User Defined Text02 String 32
User_Defined_Text03 User Defined Text03 String 32
User_Defined_Text04 User Defined Text04 String 32
User_Defined_Text05 User Defined Text05 String 32
User_Defined_Text06 User Defined Text06 String 32
User_Defined_Text07 User Defined Text07 String 32
User_Defined_Text08 User Defined Text08 String 32
User_Defined_Text09 User Defined Text09 String 32
User_Defined_Text10 User Defined Text10 String 32
User_Defined_Date01 User Defined Date01 Date 4
User_Defined_Date02 User Defined Date02 Date 4
User_Defined_Date03 User Defined Date03 Date 4
User_Defined_Date04 User Defined Date04 Date 4
User_Defined_Date05 User Defined Date05 Date 4
User_Defined_Date06 User Defined Date06 Date 4
User_Defined_Date07 User Defined Date07 Date 4
User_Defined_Date08 User Defined Date08 Date 4
User_Defined_Date09 User Defined Date09 Date 4
User_Defined_Date10 User Defined Date10 Date 4
User_Defined_Date11 User Defined Date11 Date 4
User_Defined_Date12 User Defined Date12 Date 4
User_Defined_Date13 User Defined Date13 Date 4
User_Defined_Date14 User Defined Date14 Date 4
User_Defined_Date15 User Defined Date15 Date 4
User_Defined_Date16 User Defined Date16 Date 4
User_Defined_Date17 User Defined Date17 Date 4
User_Defined_Date18 User Defined Date18 Date 4
User_Defined_Date19 User Defined Date19 Date 4
User_Defined_Date20 User Defined Date20 Date 4
VADCDTRO Vendor Address Code - Remit To String 16

Related Tables

Tables that share columns with ASIEXP27. Click "Join" to add to your query.

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

TIME1

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP18 ASIEXP19

XCHGRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

DENXRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

BACHNUMB

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25

EXGTBLID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

VENDORID

ASIEXP03 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP16 ASIEXP21 ASIEXP23 ASIEXP28