ASIEXP21 - SmartList Purchasing Line Items | Prospr

ASIEXP21 - SmartList Purchasing Line Items

Query Builder

Select * from ASIEXP21

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Order_By	ASI_Order_By	Long Integer	4	View
PONUMBER	PO Number	String	18	View
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
ORD	Ord	Long Integer	4	View
POLNESTA	PO Line Status 1 – New 2 – Released 3 – Change Order 4 – Received 5 – Closed 6 – Canceled	Integer	2	View
POTYPE	PO Type 1 = Standard 2 = Drop Ship 3 = Blanket 4 = Blanket Drop Ship	Integer	2	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
VENDORID	Vendor ID	String	16	View
VNDITNUM	Vendor Item Number	String	32	View
VNDITDSC	Vendor Item Description	String	102	View
NONINVEN	Non IV	Integer	2	View
UOFM	U Of M	String	10	View
UMQTYINB	U Of M QTY In Base	Currency	10	View
QTYORDER	QTY Ordered	Currency	10	View
QTYCANCE	QTY Canceled	Currency	10	View
QTYCMTBASE	QTY Committed In Base	Currency	10	View
QTYUNCMTBASE	QTY Uncommitted In Base	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
INVINDX	Inventory Index	Long Integer	4	View
REQDATE	Required Date	Date	4	View
PRMDATE	Promised Date	Date	4	View
PRMSHPDTE	Promised Ship Date	Date	4	View
REQSTDBY	Requested By	String	22	View
COMMNTID	Comment ID	String	16	View
DOCTYPE	Document Type	Integer	2	View
POLNEARY_1	PO Line Note ID Array[1]	Currency	10	View
POLNEARY_2	PO Line Note ID Array[2]	Currency	10	View
POLNEARY_3	PO Line Note ID Array[3]	Currency	10	View
POLNEARY_4	PO Line Note ID Array[4]	Currency	10	View
POLNEARY_5	PO Line Note ID Array[5]	Currency	10	View
POLNEARY_6	PO Line Note ID Array[6]	Currency	10	View
POLNEARY_7	PO Line Note ID Array[7]	Currency	10	View
POLNEARY_8	PO Line Note ID Array[8]	Currency	10	View
POLNEARY_9	PO Line Note ID Array[9]	Currency	10	View
DECPLCUR	Decimal Places Currency	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	View
BRKFLD1	Break Field 1	Integer	2	View
PO_Line_Status_Orig	PO Line Status Orig	Integer	2	View
QTY_Canceled_Orig	QTY Canceled Orig	Currency	10	View
OPOSTSUB	Originating Posted Subtotal	Currency	10	View
JOBNUMBR	Job Number	String	18	View
COSTCODE	Cost Code	String	28	View
COSTTYPE	Cost Code Type	Integer	2	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
RATECALC	Rate Calc Method	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
ORUNTCST	Originating Unit Cost	Currency	10	View
OREXTCST	Originating Extended Cost	Currency	10	View
LINEORIGIN	Line Origin	Integer	2	View
FREEONBOARD	Free On Board	Integer	2	View
ODECPLCU	Originating Decimal Places Currency	Integer	2	View
Capital_Item	Capital Item	Boolean	2	View
Product_Indicator	Product Indicator	Integer	2	View
Source_Document_Number	Source Document Number	String	12	View
Source_Document_Line_Num	Source Document Line Number	Integer	2	View
ASI_Document_Status	ASI_Document_Status	Integer	2	View
STATGRP	Status Group	Integer	2	View
USER2ENT	User To Enter	String	16	View
CONFIRM1	Confirm With	String	22	View
DOCDATE	Document Date	Date	4	View
LSTEDTDT	Last Edit Date	Date	4	View
LSTPRTDT	Last Printed Date	Date	4	View
REQTNDT	Requisition Date	Date	4	View
SHIPMTHD	Shipping Method	String	16	View
TXRGNNUM	Tax Registration Number	String	26	View
REMSUBTO	Remaining Subtotal	Currency	10	View
SUBTOTAL	Subtotal	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
MSCCHAMT	Misc Charges Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
VENDNAME	Vendor Name	String	66	View
MINORDER	Minimum Order	Currency	10	View
VADCDPAD	Vendor Address Code - Purchase Address	String	16	View
CMPANYID	Company ID	Integer	2	View
PRBTADCD	Primary Billto Address Code	String	16	View
PRSTADCD	Primary Shipto Address Code	String	16	View
CMPNYNAM	Company Name	String	66	View
CONTACT	Contact	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
COUNTRY	Country	String	62	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
FAX	Fax	String	22	View
PYMTRMID	Payment Terms ID	String	22	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
DISAMTAV	Discount Amount Available	Currency	10	View
DISCDATE	Discount Date	Date	4	View
DUEDATE	Due Date	Date	4	View
TRDPCTPR	Trade Discount Percent (Precise)	Currency (Variable)	12	View
CUSTNMBR	Customer Number	String	16	View
TIMESPRT	Times Printed	Integer	2	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
PONOTIDS_1	PO Note ID Array[1]	Currency	10	View
PONOTIDS_2	PO Note ID Array[2]	Currency	10	View
PONOTIDS_3	PO Note ID Array[3]	Currency	10	View
PONOTIDS_4	PO Note ID Array[4]	Currency	10	View
PONOTIDS_5	PO Note ID Array[5]	Currency	10	View
PONOTIDS_6	PO Note ID Array[6]	Currency	10	View
PONOTIDS_7	PO Note ID Array[7]	Currency	10	View
PONOTIDS_8	PO Note ID Array[8]	Currency	10	View
PONOTIDS_9	PO Note ID Array[9]	Currency	10	View
PONOTIDS_10	PO Note ID Array[10]	Currency	10	View
PONOTIDS_11	PO Note ID Array[11]	Currency	10	View
PONOTIDS_12	PO Note ID Array[12]	Currency	10	View
PONOTIDS_13	PO Note ID Array[13]	Currency	10	View
PONOTIDS_14	PO Note ID Array[14]	Currency	10	View
PONOTIDS_15	PO Note ID Array[15]	Currency	10	View
COMMENT_1	Comment[1]	String	52	View
COMMENT_2	Comment[2]	String	52	View
COMMENT_3	Comment[3]	String	52	View
COMMENT_4	Comment[4]	String	52	View
CANCSUB	Canceled Subtotal	Currency	10	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	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
OREMSUBT	Originating Remaining Subtotal	Currency	10	View
ORSUBTOT	Originating Subtotal	Currency	10	View
Originating_Canceled_Sub	Originating Canceled Subtotal	Currency	10	View
ORTDISAM	Originating Trade Discount Amount	Currency	10	View
ORFRTAMT	Originating Freight Amount	Currency	10	View
OMISCAMT	Originating Misc Charges Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
ORDDLRAT	Originating Discount Dollar Amount	Currency	10	View
ODISAMTAV	Originating Discount Amount Available	Currency	10	View
BUYERID	Buyer ID	String	16	View
ONORDAMT	On Order Amount	Currency	10	View
ORORDAMT	Originating On Order Amount	Currency	10	View
HOLD	Hold	Boolean	2	View
ONHOLDDATE	On Hold Date	Date	4	View
ONHOLDBY	On Hold By	String	16	View
HOLDREMOVEDATE	Hold Remove Date	Date	4	View
HOLDREMOVEBY	Hold Remove By	String	16	View
ALLOWSOCMTS	Allow SO Commitments	Boolean	2	View
NOTEINDX	Note Index	Currency	10	View
ITMSHNAM	Item Short Name	String	16	View
ITEMTYPE	Item Type 1. Sales Inventory (For SBM, this type is Stock Item.) 2. Discontinued 3. Kit 4. Misc Charges 5. Services 6. Flat Fee (For SBM, this type is Labor.)	Integer	2	View
ITMGEDSC	Item Generic Description	String	12	View
STNDCOST	Standard Cost	Currency	10	View
CURRCOST	Current Cost	Currency	10	View
LISTPRCE	List Price	Currency	10	View
ITEMSHWT	Item Shipping Weight	Long Integer	4	View
ITMTSHID	Item Tax Schedule ID	String	16	View
TAXOPTNS	Tax Options 1. Taxable 2. Nontaxable 3. Base on customers	Integer	2	View
COMMCODE	Commission Code	String	16	View
IVIVINDX	IV IV Index	Long Integer	4	View
IVIVOFIX	IV IV Offset Index	Long Integer	4	View
IVCOGSIX	IV COGS Index	Long Integer	4	View
IVSLSIDX	IV Sales Index	Long Integer	4	View
IVSLDSIX	IV Sales Discounts Index	Long Integer	4	View
IVSLRNIX	IV Sales Returns Index	Long Integer	4	View
IVINUSIX	IV In Use Index	Long Integer	4	View
IVINSVIX	IV In Service Index	Long Integer	4	View
IVDMGIDX	IV Damaged Index	Long Integer	4	View
IVVARIDX	IV Variances Index	Long Integer	4	View
DPSHPIDX	Drop Ship Index	Long Integer	4	View
PURPVIDX	Purchase Price Variance Index	Long Integer	4	View
IVRETIDX	Inventory Returns Index	Long Integer	4	View
ASMVRIDX	Assembly Variance Index	Long Integer	4	View
ITMCLSCD	Item Class Code	String	12	View
LOTTYPE	Lot Type	String	12	View
KPERHIST	Keep Period History	Boolean	2	View
KPTRXHST	Keep Trx History	Boolean	2	View
KPCALHST	Keep Calendar History	Boolean	2	View
KPDSTHST	Keep Distribution History	Boolean	2	View
ALWBKORD	Allow Back Orders	Boolean	2	View
VCTNMTHD	Valuation Method 1. FIFO Perpetual 2. LIFO Perpetual 3. Average Perpetual 4. FIFO Periodic (This value is not available for SBM.) 5. LIFO Periodic (This value is not available for SBM.)	Integer	2	View
UOMSCHDL	U Of M Schedule	String	12	View
ALTITEM1	Alternate Item 1	String	32	View
ALTITEM2	Alternate Item 2	String	32	View
USCATVLS_1	User Category Values[1]	String	12	View
USCATVLS_2	User Category Values[2]	String	12	View
USCATVLS_3	User Category Values[3]	String	12	View
USCATVLS_4	User Category Values[4]	String	12	View
USCATVLS_5	User Category Values[5]	String	12	View
USCATVLS_6	User Category Values[6]	String	12	View
MSTRCDTY	Master Record Type	Integer	2	View
WRNTYDYS	Warranty Days	Integer	2	View
PRCLEVEL	PriceLevel	String	12	View
VNDCHKNM	Vendor Check Name	String	66	View
VENDSHNM	Vendor Short Name	String	16	View
VADDCDPR	Vendor Address Code - Primary	String	16	View
VADCDSFR	Vendor Address Code - Ship From	String	16	View
VADCDTRO	Vendor Address Code - Remit To	String	16	View
VNDCLSID	Vendor Class ID	String	12	View
VNDCNTCT	Vendor Contact	String	62	View
UPSZONE	UPS Zone	String	4	View
TAXSCHID	Tax Schedule ID	String	16	View
ACNMVNDR	Account Number With Vendor	String	22	View
TXIDNMBR	Tax ID Number	String	12	View
VENDSTTS	Vendor Status 1. Active 2. Inactive 3. Temporary	Integer	2	View
PARVENID	Parent Vendor ID	String	16	View
TRDDISCT	Trade Discount	Integer	2	View
TEN99TYPE	1099 Type 1 – Not a 1099 vendor 2 – Dividend 3 – Interest 4 - Miscellaneous	Integer	2	View
MINPYTYP	Minimum Payment Type	Integer	2	View
MINPYPCT	Minimum Payment Percent	Integer	2	View
MINPYDLR	Minimum Payment Dollar	Currency	10	View
MXIAFVND	Maximum Invoice Amount For Vendors	Integer	2	View
MAXINDLR	Maximum Invoice Dollar	Currency	10	View
COMMENT1	Comment1	String	32	View
COMMENT2	Comment2	String	32	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
CRLMTDLR	Credit Limit Dollar	Currency	10	View
PYMNTPRI	Payment Priority	String	4	View
KGLDSTHS	Keep GL Dist History	Boolean	2	View
PTCSHACF	Post To Cash Account From	Integer	2	View
CREDTLMT	Credit Limit	Integer	2	View
WRITEOFF	Writeoff	Integer	2	View
MXWOFAMT	Maximum Write Off Amount	Currency	10	View
SBPPSDED	Subject To PPS Deductions	Boolean	2	View
PPSTAXRT	PPS Tax Rate	Integer	2	View
DXVARNUM	Deduction Exemption/Variation Number	String	26	View
CRTCOMDT	Certificate Commencing Date	Date	4	View
CRTEXPDT	Certificate Expiration Date	Date	4	View
RTOBUTKN	Reporting Obligation Undertaken	Boolean	2	View
XPDTOBLG	Expiration Date Obligation	Boolean	2	View
PRSPAYEE	Prescribed Payee	Boolean	2	View
PMAPINDX	PM AP Index	Long Integer	4	View
PMCSHIDX	PM Cash Index	Long Integer	4	View
PMDAVIDX	PM Discount Available Index	Long Integer	4	View
PMDTKIDX	PM Discount Taken Index	Long Integer	4	View
PMFINIDX	PM Finance Charge Index	Long Integer	4	View
PMMSCHIX	PM Misc Charges Index	Long Integer	4	View
PMFRTIDX	PM Freight Index	Long Integer	4	View
PMTAXIDX	PM Tax Index	Long Integer	4	View
PMWRTIDX	PM Write Offs Index	Long Integer	4	View
PMPRCHIX	PM Purchases Index	Long Integer	4	View
PMRTNGIX	PM Retainage Index	Long Integer	4	View
PMTDSCIX	PM Trade Discount Index	Long Integer	4	View
ACPURIDX	Accrued Purchases Index	Long Integer	4	View
CHEKBKID	Checkbook ID	String	16	View
Revalue_Vendor	Revalue Vendor	Boolean	2	View
Post_Results_To	Post Results To	Integer	2	View
POSTATUS	PO Status 1 – New 2 – Released 3 – Change Order 4 – Received 5 – Closed 6 – Canceled	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
FINCHLIF	Finance Charge LIFE	Currency	10	View
FINCHLYR	Finance Charge LYR	Currency	10	View
FINCHYTD	Finance Charge YTD	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
TRDTKLIF	Trade Discounts Taken LIFE	Currency	10	View
TRDTLYR	Trade Discounts Taken LYR	Currency	10	View
TRDTYTD	Trade Discounts Taken YTD	Currency	10	View
NFNCHLIF	Number of Finance Charges LIFE	Long Integer	4	View
NFNCHLYR	Number of Finance Charges LYR	Long Integer	4	View
NFNCHYTD	Number of Finance Charges YTD	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
CUSTNAME	Customer Name	String	66	View
CUSTCLAS	Customer Class	String	16	View
CPRCSTNM	Corporate Customer Number	String	16	View
CNTCPRSN	Contact Person	String	62	View
STMTNAME	Statement Name	String	66	View
SHRTNAME	Short Name	String	16	View
ADRSCODE	Address Code	String	16	View
STADDRCD	Statement Address Code	String	16	View
SLPRSNID	Salesperson ID	String	16	View
CRLMTTYP	Credit Limit Type	Integer	2	View
CRLMTAMT	Credit Limit Amount	Currency	10	View
CRLMTPER	Credit Limit Period	Integer	2	View
CRLMTPAM	Credit Limit Period Amount	Currency	10	View
CUSTDISC	Customer Discount	Integer	2	View
FNCHATYP	Finance Charge Amt Type	Integer	2	View
FNCHPCNT	Finance Charge Percent	Integer	2	View
FINCHDLR	Finance Charge Dollar	Currency	10	View
MXWOFTYP	Maximum Writeoff Type	Integer	2	View
MXWROFAM	Max Writeoff Amount	Currency	10	View
TAXEXMT1	Tax Exempt 1	String	26	View
TAXEXMT2	Tax Exempt 2	String	26	View
BALNCTYP	Balance Type	Integer	2	View
STMTCYCL	Statement Cycle 1. No Statement 2. Weekly 3. Biweekly 4. Semi Monthly 5. Monthly 6. Bimonthly 7. Quarterly	Integer	2	View
BANKNAME	Bank Name	String	32	View
BNKBRNCH	Bank Branch	String	22	View
SALSTERR	Sales Territory	String	16	View
DEFCACTY	Default Cash Account Type 0. Checkbook 1. Customer	Integer	2	View
RMCSHACC	RM Cash Account Index	Long Integer	4	View
RMARACC	RM AR Account Index	Long Integer	4	View
RMSLSACC	RM Sales Account Index	Long Integer	4	View
RMIVACC	RM IV Account Index	Long Integer	4	View
RMCOSACC	RM Cost Of Sales Account Index	Long Integer	4	View
RMTAKACC	RM Discounts Taken Account Index	Long Integer	4	View
RMAVACC	RM Discounts Avail Account Index	Long Integer	4	View
RMFCGACC	RM Finance Charge Account Index	Long Integer	4	View
RMWRACC	RM Writeoff Account Index	Long Integer	4	View
FRSTINDT	First Invoice Date	Date	4	View
INACTIVE	Inactive	Boolean	2	View
CRCARDID	Credit Card ID	String	16	View
CRCRDNUM	Credit Card Number	String	22	View
CCRDXPDT	Credit Card Exp Date	Date	4	View
Revalue_Customer	Revalue Customer	Boolean	2	View
FINCHID	Finance Charge ID	String	16	View
GOVCRPID	Governmental Corporate ID	String	32	View
GOVINDID	Governmental Individual ID	String	32	View
TNSFCLIF	Total Amount Of NSF Checks Life	Currency	10	View
NONSFLIF	Number Of NSF Checks Life	Long Integer	4	View
CUSTBLNC	Customer Balance	Currency	10	View
AGPERAMT_1	Aging Period Amounts[1]	Currency	10	View
AGPERAMT_2	Aging Period Amounts[2]	Currency	10	View
AGPERAMT_3	Aging Period Amounts[3]	Currency	10	View
AGPERAMT_4	Aging Period Amounts[4]	Currency	10	View
AGPERAMT_5	Aging Period Amounts[5]	Currency	10	View
AGPERAMT_6	Aging Period Amounts[6]	Currency	10	View
AGPERAMT_7	Aging Period Amounts[7]	Currency	10	View
LASTAGED	Last Aged	Date	4	View
LSTNSFCD	Last NSF Check Date	Date	4	View
LPYMTAMT	Last Payment Amount	Currency	10	View
LASTPYDT	Last Payment Date	Date	4	View
LSTTRXDT	Last Transaction Date	Date	4	View
LSTTRXAM	Last Transaction Amount	Currency	10	View
LSTFCHAM	Last Finance Charge Amount	Currency	10	View
UPFCHYTD	Unpaid Finance Charges YTD	Currency	10	View
NUMADTPL	Number ADTP Documents - Life	Long Integer	4	View
NUMADTPR	Number ADTP Documents - LYR	Long Integer	4	View
NUMADTPY	Number ADTP Documents - Year	Long Integer	4	View
TDTKNLTD	Total Discounts Taken LTD	Currency	10	View
TDTKNLYR	Total Discounts Taken LYR	Currency	10	View
TDTKNYTD	Total Discounts Taken YTD	Currency	10	View
TDISAYTD	Total Discounts Available YTD	Currency	10	View
RETAINAG	Retainage	Currency	10	View
TNSFCYTD	Total Amount Of NSF Checks YTD	Currency	10	View
NONSFYTD	Number Of NSF Checks YTD	Long Integer	4	View
UNPSTDSA	Unposted Sales Amount	Currency	10	View
UNPSTDCA	Unposted Cash Amount	Currency	10	View
UNPSTOSA	Unposted Other Sales Amount	Currency	10	View
UNPSTOCA	Unposted Other Cash Amount	Currency	10	View
NCSCHPMT	Non Current Scheduled Payments	Currency	10	View
TTLSLLTD	Total Sales LTD	Currency	10	View
TTLSLLYR	Total Sales LYR	Currency	10	View
TTLSLYTD	Total Sales YTD	Currency	10	View
TCOSTLTD	Total Costs LTD	Currency	10	View
TCOSTLYR	Total Costs LYR	Currency	10	View
TCOSTYTD	Total Costs YTD	Currency	10	View
TCSHRLTD	Total Cash Received LTD	Currency	10	View
TCSHRLYR	Total Cash Received LYR	Currency	10	View
TCSHRYTD	Total Cash Received YTD	Currency	10	View
TFNCHLTD	Total Finance Charges LTD	Currency	10	View
TFNCHLYR	Total Finance Charges LYR	Currency	10	View
TFNCHYTD	Total Finance Charges YTD	Currency	10	View
FNCHCYTD	Finance Charges CYTD	Currency	10	View
FNCHLYRC	Finance Charges LYR Calendar	Currency	10	View
TBDDTLYR	Total Bad Deb LYR	Currency	10	View
TBDDTLTD	Total Bad Debt LTD	Currency	10	View
TBDDTYTD	Total Bad Debt YTD	Currency	10	View
TWVFCLTD	Total Waived FC LTD	Currency	10	View
TWVFCLYR	Total Waived FC LYR	Currency	10	View
TWVFCYTD	Total Waived FC YTD	Currency	10	View
TWROFLTD	Total Writeoffs LTD	Currency	10	View
TWROFLYR	Total Writeoffs LYR	Currency	10	View
TWROFYTD	Total Writeoffs YTD	Currency	10	View
TTLINLTD	Total # Invoices LTD	Long Integer	4	View
TTLINLYR	Total # Invoices LYR	Long Integer	4	View
TTLINYTD	Total # Invoices YTD	Long Integer	4	View
TTLFCLTD	Total # FC LTD	Long Integer	4	View
TTLFCLYR	Total # FC LYR	Long Integer	4	View
TTLFCYTD	Total # FC YTD	Long Integer	4	View
HIBALLTD	High Balance LTD	Currency	10	View
HIBALLYR	High Balance LYR	Currency	10	View
HIBALYTD	High Balance YTD	Currency	10	View
LASTSTDT	Last Statement Date	Date	4	View
LSTSTAMT	Last Statement Amount	Currency	10	View
DEPRECV	Deposits Received	Currency	10	View
ABCCODE	ABC Code 1 – (None) 2 – A 3 – B 4 – C	Integer	2	View
CGSINFLX	COGS Inflation Index	Long Integer	4	View
CGSMCIDX	COGS Monetary Correction Index	Long Integer	4	View
IVINFIDX	Inventory Inflation Index	Long Integer	4	View
INVMCIDX	Inventory Monetary Correction Index	Long Integer	4	View
ITEMCODE	Item Code	String	16	View
KTACCTSR	Kit COGS Account Source 0 – COGS accounts from the components 1 – COGS account from the kit	Integer	2	View
LASTGENSN	Last Generated Serial Number	String	22	View
PriceGroup	Price Group	String	12	View
PRICMTHD	Price Method 1 – Currency Amount 2 – % of List Price 3 – % Markup – Current Cost 4 – % Markup – Standard Cost 5 – % Margin – Current Cost 6 – % Margin – Standard Cost	Integer	2	View
PINFLIDX	Purch Inflation Index	Long Integer	4	View
PURMCIDX	Purch Monetary Correction Index	Long Integer	4	View
PRCHSUOM	Purchasing U Of M	String	10	View
SELNGUOM	Selling U Of M	String	10	View
TCC	Tax Commodity Code	String	32	View
UPPVIDX	Unrealized Purchase Price Variance Index	Long Integer	4	View
DISGRPER	Discount Grace Period	Integer	2	View
DOCFMTID	Document Format ID	String	16	View
DUEGRPER	Due Date Grace Period	Integer	2	View
PHONE3	Phone 3	String	22	View
TaxInvRecvd	Tax Invoice Received	Boolean	2	View
Withholding_LIFE	Withholding LIFE	Currency	10	View
WITHLYR	Withholding LYR	Currency	10	View
WITHYTD	Withholding YTD	Currency	10	View
Change_Order_Flag	Change Order Flag	Integer	2	View
PO_Field_Changes	PO Field Changes	Long Integer	4	View
PO_Status_Orig	PO Status Orig 1 – New 2 – Released 3 – Change Order 4 – Received 5 – Closed 6 – Canceled	Integer	2	View
Revision_Number	Revision Number	Integer	2	View
LOCNCODE	Location Code	String	12	View
RELEASEBYDATE	Release By Date	Date	4	View
Released_Date	Released Date	Date	4	View
UPSZONE1	ASI_UPS_Zone	String	4	View
SHIPMTHD1	ASI_Shipping_Method	String	16	View
TAXSCHID1	ASI_Tax_Schedule_ID	String	16	View
ADDRESS11	ASI_Address_1	String	62	View
ADDRESS21	ASI_Address_2	String	62	View
ADDRESS31	ASI_Address_3	String	62	View
CITY1	ASI_City	String	36	View
STATE1	ASI_State	String	30	View
COUNTRY1	ASI_Country	String	62	View
ZIP1	ASI_Zip	String	12	View
PHONE11	ASI_Phone_1	String	22	View
PHONE21	ASI_Phone_2	String	22	View
FAX1	ASI_Fax	String	22	View
PRBTADCD1	ASI_Primary_Billto_Address_Code	String	16	View
PRSTADCD1	ASI_Primary_Shipto_Address_Code	String	16	View
CHEKBKID1	ASI_Checkbook_ID	String	16	View
PYMTRMID1	ASI_Payment_Terms_ID	String	22	View
CURNCYID1	ASI_Currency_ID	String	16	View
RATETPID1	ASI_Rate_Type_ID	String	16	View
ASI_Minimum_Payment_Type	ASI_Minimum_Payment_Type	Integer	2	View
MINPYDLR1	ASI_Minimum_Payment_Dollar	Currency	10	View
MINPYPCT1	ASI_Minimum_Payment_Percent	Integer	2	View
COMMENT11	ASI_Comment1	String	32	View
COMMENT21	ASI_Comment2	String	32	View
USERDEF11	ASI_User_Defined_1	String	22	View
USERDEF21	ASI_User_Defined_2	String	22	View
TXRGNNUM1	ASI_Tax_Registration_Number	String	26	View
HOLD1	ASI_Hold	Boolean	2	View
KPDSTHST1	ASI_Keep_Distribution_History	Boolean	2	View
KPCALHST1	ASI_Keep_Calendar_History	Boolean	2	View
KPERHIST1	ASI_Keep_Period_History	Boolean	2	View
KPTRXHST1	ASI_Keep_Trx_History	Boolean	2	View
NOTEINDX1	ASI_Note_Index	Currency	10	View
CREATDDT1	ASI_Created_Date	Date	4	View
MODIFDT1	ASI_Modified_Date	Date	4	View
FRSTINDT1	ASI_First_Invoice_Date	Date	4	View
AVDTPLIF1	ASI_Average_Days_To_Pay_Life	Integer	2	View
AVDTPLYR1	ASI_Average_Days_to_Pay_LYR	Integer	2	View
AVGDTPYR1	ASI_Average_Days_To_Pay_Year	Integer	2	View
WROFSLIF1	ASI_Write_Offs_LIFE	Currency	10	View
WROFSLYR1	ASI_Write_Offs_LYR	Currency	10	View
WROFSYTD1	ASI_Write_Offs_YTD	Currency	10	View
ONORDAMT1	ASI_On_Order_Amount	Currency	10	View
ASI_Post_Results_To	ASI_Post_Results_To	Integer	2	View
DISGRPER1	ASI_Discount_Grace_Period	Integer	2	View
DOCFMTID1	ASI_Document_Format_ID	String	16	View
DUEGRPER1	ASI_Due_Date_Grace_Period	Integer	2	View
PHONE31	ASI_Phone_3	String	22	View
ITEMDESC1	ASI_Item_Description	String	52	View
NOTEINDX11	ASI_Note_Index2	Currency	10	View
DECPLQTY1	ASI_Decimal_Places_QTYS	Integer	2	View
DECPLCUR1	ASI_Decimal_Places_Currency	Integer	2	View
ITMTRKOP1	ASI_Item_Tracking_Option	Integer	2	View
VCTNMTHD1	ASI_Valuation_Method	Integer	2	View
MODIFDT11	ASI_Modified_Date2	Date	4	View
CREATDDT11	ASI_Created_Date2	Date	4	View
PRCLEVEL1	ASI_PriceLevel	String	12	View
PRMDATE1	ASI_Promised_Date	Date	4	View
PRMSHPDTE1	ASI_Promised_Ship_Date	Date	4	View
LOCNCODE1	ASI_Location_Code	String	12	View
COMMNTID1	ASI_Comment_ID	String	16	View
CURNCYID11	ASI_Currency_ID2	String	16	View
ASI_Currency_Index	ASI_Currency_Index	Integer	2	View
XCHGRATE1	ASI_Exchange_Rate	Currency (Variable)	10	View
RATECALC1	ASI_Rate_Calc_Method	Integer	2	View
DENXRATE1	ASI_Denomination_Exchange_Rate	Currency (Variable)	10	View
Change_Order_Flag1	ASI_Change_Order_Flag	Boolean	2	View
VENDNAME1	ASI_Vendor_Name	String	66	View
VADCDPAD1	ASI_Vendor_Address_Code_Purchase_Address	String	16	View
ADDRESS111	ASI_Address_12	String	62	View
ADDRESS211	ASI_Address_22	String	62	View
ADDRESS311	ASI_Address_32	String	62	View
CITY11	ASI_City2	String	36	View
STATE11	ASI_State2	String	30	View
ZIPCODE1	ASI_Zip_Code	String	12	View
COUNTRY11	ASI_Country2	String	62	View
PHNUMBR11	ASI_Phone_Number_1	String	22	View
PHNUMBR21	ASI_Phone_Number_2	String	22	View
FAXNUMBR1	ASI_Fax_Number	String	22	View
SHIPMTHD11	ASI_Shipping_Method2	String	16	View
CURNCYID111	ASI_Currency_ID3	String	16	View
TXRGNNUM11	ASI_Tax_Registration_Number2	String	26	View
MINORDER1	ASI_Minimum_Order	Currency	10	View
PYMTRMID11	ASI_Payment_Terms_ID2	String	22	View
COMMENT111	ASI_Comment12	String	32	View
COMMENT211	ASI_Comment22	String	32	View
KPCALHST11	ASI_Keep_Calendar_History2	Boolean	2	View
KPERHIST11	ASI_Keep_Period_History2	Boolean	2	View
KPTRXHST11	ASI_Keep_Trx_History2	Boolean	2	View
HOLD11	ASI_Hold2	Boolean	2	View
PURPVIDX1	ASI_Purchase_Price_Variance_Index	Long Integer	4	View
NOTEINDX111	ASI_Note_Index3	Currency	10	View
MODIFDT111	ASI_Modified_Date3	Date	4	View
CREATDDT111	ASI_Created_Date3	Date	4	View
RATETPID11	ASI_Rate_Type_ID2	String	16	View
FREEONBOARD1	ASI_Free_On_Board	Integer	2	View
DISGRPER11	ASI_Discount_Grace_Period2	Integer	2	View
DUEGRPER11	ASI_Due_Date_Grace_Period2	Integer	2	View
GOVCRPID1	ASI_Governmental_Corporate_ID	String	32	View
GOVINDID1	ASI_Governmental_Individual_ID	String	32	View
PHONE311	ASI_Phone_32	String	22	View
ONORDAMT11	ASI_On_Order_Amount2	Currency	10	View
ASI_Required_Date	ASI_Required_Date	Date	4	View
LOCNCODE11	ASI_Location_Code2	String	12	View
TRXSORCE	TRX Source	String	14	View
Purchase_IV_Item_Taxable	Purchase IV Item Taxable 1 – Taxable 2 – Nontaxable 3 – Base on Vendor	Integer	2	View
Purchase_Item_Tax_Schedu	Purchase Item Tax Schedule ID	String	16	View
Purchase_Site_Tax_Schedu	Purchase Site Tax Schedule ID	String	16	View
BSIVCTTL	Based On Invoice Total	Boolean	2	View
TAXAMNT1	ASI_Tax_Amount	Currency	10	View
ORTAXAMT1	ASI_Originating_Tax_Amount	Currency	10	View
Landed_Cost_Group_ID	Landed Cost Group ID	String	16	View
PLNNDSPPLID	Planned Supply ID	Integer	2	View
ASISHIPMTHD3	ASI_Shipping_Method3	String	16	View
ORIGPRMDATE	Original Promised Date	Date	4	View
FSTRCPTDT	First Receipt Date	Date	4	View
LSTRCPTDT	Last Receipt Date	Date	4	View
CNTRLEXTQTY	Control Line Ext Qty	Currency	10	View
CNTRLEXTCOST	Control Line Ext Cost	Currency	10	View
REMAINEXTQTY	Remaining Ext Qty	Currency	10	View
ASI_Address_Code	ASI_Address_Code	String	16	View
CMPNYNAM1	ASI_Company_Name	String	66	View
CONTACT1	ASI_Contact	String	62	View
ADDRESS1111	ASI_Address_13	String	62	View
ADDRESS2111	ASI_Address_23	String	62	View
ADDRESS3111	ASI_Address_33	String	62	View
CITY3	ASI_City3	String	36	View
STATE3	ASI_State3	String	30	View
ZIP3	ASI_Zip3	String	12	View
COUNTRY3	ASI_Country3	String	62	View
PHONE1111	ASI_Phone_13	String	22	View
PHONE2111	ASI_Phone_23	String	22	View
PHONE3111	ASI_Phone_33	String	22	View
FAX3	ASI_Fax3	String	22	View
ADDRSOURCE	Address Source	Integer	2	View
PURCHSITETXSCHSRC	Purchase Site Tax Schedule Source	Integer	2	View
UMSCHDSC	U Of M Schedule Description	String	32	View
QTYSHPPD	QTY Shipped	Currency	10	View
QTYINVCD	QTY Invoiced	Currency	10	View
QTYREJ	QTY Rejected	Currency	10	View
QTYMATCH	QTY Matched	Currency	10	View
ProjNum	Project Number	String	16	View
CostCatID	Cost Category ID	String	16	View
Total_Landed_Cost_Amount	Total Landed Cost Amount	Currency	10	View
QTYINVRESERVE	QTY Invoice Reserve	Currency	10	View
QTYRESERVED	QTY Reserved	Currency	10	View

ASIEXP21 - SmartList Purchasing Line Items

Query Builder

Customer Service

Information

My Account

Contact Us