ASIEXP27 - SmartList Purchasing Receipts | Prospr

ASIEXP27 - SmartList Purchasing Receipts

Query Builder

Select * from ASIEXP27

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

ASIEXP27 - SmartList Purchasing Receipts

Query Builder

Customer Service

Information

My Account

Contact Us