ASIEXP26 - SmartList Invoicing Transaction Amounts Work | Prospr

ASIEXP26 - SmartList Invoicing Transaction Amounts Work

Query Builder

Select * from ASIEXP26

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
DOCTYPE	Document Type	Integer	2	View
INVCNMBR	Invoice Number	String	22	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
DECPLCUR	Decimal Places Currency	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
INVINDX	Inventory Index	Long Integer	4	View
CSLSINDX	Cost Of Sales Index	Long Integer	4	View
SLSINDX	Sales Index	Long Integer	4	View
MKDNINDX	Markdown Index	Long Integer	4	View
RTNSINDX	Returns Index	Long Integer	4	View
INUSINDX	In Use Index	Long Integer	4	View
INSRINDX	In Service Index	Long Integer	4	View
DMGDINDX	Damaged Index	Long Integer	4	View
ITMTSHID	Item Tax Schedule ID	String	16	View
IVITMTXB	IV Item Taxable	Integer	2	View
NONINVEN	Non IV	Integer	2	View
QUANTITY	QTY	Currency	10	View
QTYINSVC	QTY In Service	Currency	10	View
QTYINUSE	QTY In Use	Currency	10	View
QTYDMGED	QTY Damaged	Currency	10	View
QTYRTRND	QTY Returned	Currency	10	View
QTYONHND	QTY On Hand	Currency	10	View
EXTQTYSEL	Existing Qty Selected	Currency	10	View
UOFM	U Of M	String	10	View
QTYBSUOM	QTY In Base U Of M	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
DISCSALE	Discount Available Sales	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
ATYALLOC	QTY Allocated	Currency	10	View
LOCNCODE	Location Code	String	12	View
MRKDNTYP	Markdown Type	Integer	2	View
MRKDNAMT	Markdown Amount	Currency	10	View
MRKDNPCT	Markdown Percent	Integer	2	View
PRCLEVEL	PriceLevel	String	12	View
XTNDPRCE	Extended Price	Currency	10	View
UNITPRCE	Unit Price	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
BKTSLSAM	Backout Sales Amount	Currency	10	View
TXBTXAMT	Taxable Tax Amount	Currency	10	View
BSIVCTTL	Based On Invoice Total	Boolean	2	View
SLPRSNID	Salesperson ID	String	16	View
SALSTERR	Sales Territory	String	16	View
DSCRIPTN	Description	String	32	View
ITEMDESC	Item Description	String	102	View
EXPTSHIP	Expected Ship Date	Date	4	View
ACTLSHIP	Actual Ship Date	Date	4	View
ReqShipDate	Requested Ship Date	Date	4	View
COMDLRAM	Commission Dollar Amount	Currency	10	View
CMPSERNM	Component Serial Numbered	Boolean	2	View
COMMNTID	Comment ID	String	16	View
BRKFLD1	Break Field 1	Integer	2	View
BRKFLD2	Break Field 2	Integer	2	View
BRKFLD3	Break Field 3	Integer	2	View
TRXSORCE	TRX Source	String	14	View
IVCLINEERR	IVC LINE Errors	Long Integer	4	View
ASI_Customer_Number	ASI_Customer_Number	String	16	View

ASIEXP26 - SmartList Invoicing Transaction Amounts Work

Query Builder

Customer Service

Information

My Account

Contact Us