ASIEXP25 - SmartList Invoicing Transaction Work | Prospr

ASIEXP25 - SmartList Invoicing Transaction Work

Query Builder

Select * from ASIEXP25

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
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
PCKSLPNO	Packing Slip Number	String	22	View
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View
CSTPONBR	Customer PO Number	String	22	View
POSTDATE	Post Date	Date	4	View
GLPOSTDT	GL Posting Date	Date	4	View
DOCDATE	Document Date	Date	4	View
QUOTEDAT	Quote Date	Date	4	View
ORDRDATE	Order Date	Date	4	View
DISCDATE	Discount Date	Date	4	View
DUEDATE	Due Date	Date	4	View
HOLDNT	Hold NT	Boolean	2	View
SHIPMTHD	Shipping Method	String	16	View
TAXEXMT1	Tax Exempt 1	String	26	View
TAXEXMT2	Tax Exempt 2	String	26	View
TAXSCHID	Tax Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
FRGTTXBL	Freight Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
FRTTXAMT	Freight Tax Amount	Currency	10	View
MSCSCHID	Misc Schedule ID	String	16	View
MISCTXBL	Misc Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
MSCTXAMT	Misc Tax Amount	Currency	10	View
SLPRSNID	Salesperson ID	String	16	View
SALSTERR	Sales Territory	String	16	View
TXRGNNUM	Tax Registration Number	String	26	View
PYMTRMID	Payment Terms ID	String	22	View
PRCLEVEL	PriceLevel	String	12	View
LOCNCODE	Location Code	String	12	View
CURNCYID	Currency ID	String	16	View
COMMNTID	Comment ID	String	16	View
DOCAMNT	Document Amount	Currency	10	View
SUBTOTAL	Subtotal	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
MISCAMNT	Misc Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
TXBTXAMT	Taxable Tax Amount	Currency	10	View
BCKTXAMT	Backout Tax Amount	Currency	10	View
BKTSLSAM	Backout Sales Amount	Currency	10	View
BKTFRTAM	Backout Freight Amount	Currency	10	View
BKTMSCAM	Backout Misc Amount	Currency	10	View
DISCFRGT	Discount Available Freight	Currency	10	View
DISCMISC	Discount Available Misc	Currency	10	View
TRDISPCT	Trade Discount Percent	Integer	2	View
TRDISAMT	Trade Discount Amount	Currency	10	View
ACCTAMNT	Account Amount	Currency	10	View
PYMTRCVD	Payment Received	Currency	10	View
CODAMNT	COD Amount	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
DISCRTND	Discount Returned	Currency	10	View
DISAVTKN	Discount Available Taken	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
DISAVAMT	Discount Available Amount	Currency	10	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
MRKDNAMT	Markdown Amount	Currency	10	View
PRBTADCD	Primary Billto Address Code	String	16	View
PRSTADCD	Primary Shipto Address Code	String	16	View
CNTCPRSN	Contact Person	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
PHNUMBR1	Phone Number 1	String	22	View
PHNUMBR2	Phone Number 2	String	22	View
PHONE3	Phone 3	String	22	View
FAXNUMBR	Fax Number	String	22	View
COMAPPTO	Commission Applied To	Integer	2	View
COMDLRAM	Commission Dollar Amount	Currency	10	View
NCOMAMNT	Non-Commissioned Amount	Currency	10	View
UPSZONE	UPS Zone	String	4	View
LSTUSRED	Last User to Edit	String	16	View
LSTEDTDT	Last Edit Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
USER2ENT	User To Enter	String	16	View
NOTEINDX	Note Index	Currency	10	View
TIMESPRT	Times Printed	Integer	2	View
NOCARTNS	Number Of Cartons	Integer	2	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	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
TRXSORCE	TRX Source	String	14	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
IVCHDER1	IVC HDR Errors 1	Long Integer	4	View
IVCHDER2	IVC HDR Errors 2	Long Integer	4	View
IVCLINEERR	IVC LINE Errors	Long Integer	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	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
ECTRX	EC Transaction	Boolean	2	View
ShipToName	ShipToName	String	66	View
Tax_Date	Tax Date	Date	4	View
APLYWITH	Apply Withholding	Boolean	2	View
WITHHAMT	Withholding Amount	Currency	10	View
CMMTTEXT	Comment Text	Text	2	View

ASIEXP25 - SmartList Invoicing Transaction Work

Query Builder

Customer Service

Information

My Account

Contact Us