ASIEXP20 - ASI SOP Line Item SmartList | Prospr

ASIEXP20 - ASI SOP Line Item SmartList

Query Builder

Select * from ASIEXP20

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Order_By	ASI_Order_By	Long Integer	4	View
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
SOPNUMBE	SOP Number	String	22	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
ASI_Document_Status	ASI_Document_Status	Integer	2	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
NONINVEN	Non IV	Integer	2	View
DROPSHIP	Drop Ship	Integer	2	View
UOFM	U Of M	String	10	View
LOCNCODE	Location Code	String	12	View
UNITCOST	Unit Cost	Currency	10	View
ORUNTCST	Originating Unit Cost	Currency	10	View
UNITPRCE	Unit Price	Currency	10	View
ORUNTPRC	Originating Unit Price	Currency	10	View
XTNDPRCE	Extended Price	Currency	10	View
OXTNDPRC	Originating Extended Price	Currency	10	View
REMPRICE	Remaining Price	Currency	10	View
OREPRICE	Originating Remaining Price	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
OREXTCST	Originating Extended Cost	Currency	10	View
MRKDNAMT	Markdown Amount	Currency	10	View
ORMRKDAM	Originating Markdown Amount	Currency	10	View
MRKDNPCT	Markdown Percent	Integer	2	View
MRKDNTYP	Markdown Type	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
BKTSLSAM	Backout Sales Amount	Currency	10	View
ORBKTSLS	Originating Backout Sales Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
TXBTXAMT	Taxable Tax Amount	Currency	10	View
OTAXTAMT	Originating Taxable Tax Amount	Currency	10	View
BSIVCTTL	Based On Invoice Total	Boolean	2	View
TRDISAMT	Trade Discount Amount	Currency	10	View
ORTDISAM	Originating Trade Discount Amount	Currency	10	View
DISCSALE	Discount Available Sales	Currency	10	View
ORDAVSLS	Originating Discount Available Sales	Currency	10	View
QUANTITY	QTY	Currency	10	View
ATYALLOC	QTY Allocated	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
QTYCANCE	QTY Canceled	Currency	10	View
QTYCANOT	QTY Canceled Other	Currency	10	View
QTYORDER	QTY Ordered	Currency	10	View
QTYPRBAC	QTY Prev Back Ordered	Currency	10	View
QTYPRBOO	QTY Prev BO On Order	Currency	10	View
QTYPRINV	QTY Prev Invoiced	Currency	10	View
QTYPRORD	QTY Prev Ordered	Currency	10	View
QTYREMAI	QTY Remaining	Currency	10	View
QTYREMBO	QTY Remaining On BO	Currency	10	View
QTYTBAOR	QTY To Back Order	Currency	10	View
QTYTOINV	QTY To Invoice	Currency	10	View
QTYTORDR	QTY To Order	Currency	10	View
QTYFULFI	QTY Fulfilled	Currency	10	View
QTYSLCTD	QTY Selected	Currency	10	View
QTYBSUOM	QTY In Base U Of M	Currency	10	View
EXTQTYAL	Existing Qty Available	Currency	10	View
EXTQTYSEL	Existing Qty Selected	Currency	10	View
ReqShipDate	Requested Ship Date	Date	4	View
FUFILDAT	Fulfillment Date	Date	4	View
ACTLSHIP	Actual Ship Date	Date	4	View
SHIPMTHD	Shipping Method	String	16	View
SALSTERR	Sales Territory	String	16	View
SLPRSNID	Salesperson ID	String	16	View
PRCLEVEL	PriceLevel	String	12	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
CURRNIDX	Currency Index	Integer	2	View
TRXSORCE	TRX Source	String	14	View
SOPLNERR	SOP LINE Errors	Long Integer	4	View
PURCHSTAT	Purchasing Status	Integer	2	View
QTYONPO	QTY On PO	Currency	10	View
QTYRECVD	QTY Received	Currency	10	View
QTYPRVRECVD	QTY Prev Received	Currency	10	View
ORIGTYPE	Original Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
DOCID	Document ID	String	16	View
DOCDATE	Document Date	Date	4	View
GLPOSTDT	GL Posting Date	Date	4	View
QUOTEDAT	Quote Date	Date	4	View
QUOEXPDA	Quote Expiration Date	Date	4	View
ORDRDATE	Order Date	Date	4	View
INVODATE	Invoice Date	Date	4	View
BACKDATE	Back Order Date	Date	4	View
RETUDATE	Return Date	Date	4	View
DISCDATE	Discount Date	Date	4	View
DUEDATE	Due Date	Date	4	View
REPTING	Repeating 0 = Non-repeating document 1 = Repeating	Boolean	2	View
TRXFREQU	TRX Frequency 1 = Weekly 2 = Biweekly 3 = Semimonthly 4 = Monthly 5 = Bimonthly 6 = Quarterly 7 = Miscellaneous	Integer	2	View
TIMEREPD	Times Repeated	Integer	2	View
DYSTINCR	Days to Increment	Integer	2	View
DTLSTREP	Date Last Repeated	Date	4	View
DSTBTCH1	Dest Batch 1	String	16	View
DSTBTCH2	Dest Batch 2	String	16	View
USDOCID1	Use Document ID 1	String	16	View
USDOCID2	Use Document ID 2	String	16	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
DISAVAMT	Discount Available Amount	Currency	10	View
ORDAVAMT	Originating Discount Available Amount	Currency	10	View
DISCRTND	Discount Returned	Currency	10	View
ORDISRTD	Originating Discount Returned	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
ORDISTKN	Originating Discount Taken Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
ORDATKN	Originating Discount Available Taken	Currency	10	View
PYMTRMID	Payment Terms ID	String	22	View
BCHSOURC	Batch Source	String	16	View
BACHNUMB	Batch Number	String	16	View
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View
CSTPONBR	Customer PO Number	String	22	View
PROSPECT	Prospect 0 = Existing Customer 1 = Prospect	Integer	2	View
MSTRNUMB	Master Number	Long Integer	4	View
PCKSLPNO	Packing Slip Number	String	22	View
PICTICNU	Picking Ticket Number	String	22	View
PRBTADCD	Primary Billto Address Code	String	16	View
PRSTADCD	Primary Shipto Address Code	String	16	View
CNTCPRSN	Contact Person	String	62	View
ShipToName	ShipToName	String	66	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
FAXNUMBR	Fax Number	String	22	View
COMAPPTO	Commission Applied To	Integer	2	View
COMMAMNT	Commission Amount	Currency	10	View
OCOMMAMT	Originating Commission Amount	Currency	10	View
CMMSLAMT	Commission Sale Amount	Currency	10	View
ORCOSAMT	Originating Commission Sales Amount	Currency	10	View
NCOMAMNT	Non-Commissioned Amount	Currency	10	View
ORNCMAMT	Originating Non-Commissioned Amount	Currency	10	View
TRDISPCT	Trade Discount Percent	Integer	2	View
SUBTOTAL	Subtotal	Currency	10	View
ORSUBTOT	Originating Subtotal	Currency	10	View
REMSUBTO	Remaining Subtotal	Currency	10	View
OREMSUBT	Originating Remaining Subtotal	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
ORFRTAMT	Originating Freight Amount	Currency	10	View
MISCAMNT	Misc Amount	Currency	10	View
ORMISCAMT	Originating Misc Amount	Currency	10	View
TXENGCLD	Tax Engine Called	Boolean	2	View
TAXEXMT1	Tax Exempt 1	String	26	View
TAXEXMT2	Tax Exempt 2	String	26	View
TXRGNNUM	Tax Registration Number	String	26	View
TAXSCHID	Tax Schedule ID	String	16	View
TXSCHSRC	Tax Schedule Source	Integer	2	View
FRTSCHID	Freight Schedule ID	String	16	View
FRTTXAMT	Freight Tax Amount	Currency	10	View
ORFRTTAX	Originating Freight Tax Amount	Currency	10	View
FRGTTXBL	Freight Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
MSCSCHID	Misc Schedule ID	String	16	View
MSCTXAMT	Misc Tax Amount	Currency	10	View
ORMSCTAX	Originating Misc Tax Amount	Currency	10	View
MISCTXBL	Misc Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
BKTFRTAM	Backout Freight Amount	Currency	10	View
ORBKTFRT	Originating Backout Freight Amount	Currency	10	View
BKTMSCAM	Backout Misc Amount	Currency	10	View
ORBKTMSC	Originating Backout Misc Amount	Currency	10	View
BCKTXAMT	Backout Tax Amount	Currency	10	View
OBTAXAMT	Originating Backout Tax Amount	Currency	10	View
ECTRX	EC Transaction	Boolean	2	View
DOCAMNT	Document Amount	Currency	10	View
ORDOCAMT	Originating Document Amount	Currency	10	View
PYMTRCVD	Payment Received	Currency	10	View
ORPMTRVD	Originating Payment Received	Currency	10	View
DEPRECVD	Deposit Received	Currency	10	View
ORDEPRVD	Originating Deposit Received	Currency	10	View
CODAMNT	COD Amount	Currency	10	View
ORCODAMT	Originating COD Amount	Currency	10	View
ACCTAMNT	Account Amount	Currency	10	View
ORACTAMT	Originating Account Amount	Currency	10	View
UPSZONE	UPS Zone	String	4	View
TIMESPRT	Times Printed	Integer	2	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	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
ALLOCABY	Allocate By	Integer	2	View
CURNCYID	Currency ID	String	16	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	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
SOPHDRE1	SOP HDR Errors 1	Long Integer	4	View
SOPHDRE2	SOP HDR Errors 2	Long Integer	4	View
SOPHDRFL	SOP HDR Flags	Long Integer	4	View
REFRENCE	Reference	String	32	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
Tax_Date	Tax Date	Date	4	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
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	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
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	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
ObjRef1	ObjRef1	Invalid storage type 30	0	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
ORIGNUMB	Original Number	String	22	View
DISAVTKN	Discount Available Taken	Currency	10	View
TIMETREP	Times To Repeat	Integer	2	View
ORDDLRAT	Originating Discount Dollar Amount	Currency	10	View
SOPMCERR	SOP MC Posting Error Messages	Long Integer	4	View
NOTEINDX	Note Index	Currency	10	View
CUSTCLAS	Customer Class	String	16	View
CPRCSTNM	Corporate Customer Number	String	16	View
STMTNAME	Statement Name	String	66	View
ADRSCODE	Address Code	String	16	View
STADDRCD	Statement Address Code	String	16	View
CHEKBKID	Checkbook 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
SHRTNAME	Short Name	String	16	View
MINPYTYP	Minimum Payment Type	Integer	2	View
MINPYDLR	Minimum Payment Dollar	Currency	10	View
MINPYPCT	Minimum Payment Percent	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
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	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
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
HOLD	Hold	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
Post_Results_To	Post Results To	Integer	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
AVDTPLYR	Average Days to Pay - LYR	Integer	2	View
AVDTPLIF	Average Days To Pay - Life	Integer	2	View
AVGDTPYR	Average Days To Pay - Year	Integer	2	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
WROFSLIF	Write Offs LIFE	Currency	10	View
WROFSLYR	Write Offs LYR	Currency	10	View
WROFSYTD	Write Offs YTD	Currency	10	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
ONORDAMT	On Order Amount	Currency	10	View
DISGRPER	Discount Grace Period	Integer	2	View
DOCFMTID	Document Format ID	String	16	View
DUEGRPER	Due Date Grace Period	Integer	2	View
APLYWITH	Apply Withholding	Boolean	2	View
CORRCTN	Correction	Boolean	2	View
DOCNCORR	Document Number Corrected	String	22	View
PHONE3	Phone 3	String	22	View
SALEDATE	Sale Date	Date	4	View
SEQNCORR	Sequence Number Corrected	Integer	2	View
SHPPGDOC	Shipping Document	Boolean	2	View
SIMPLIFD	Simplified	Boolean	2	View
WITHHAMT	Withholding Amount	Currency	10	View
CORRNXST	Correction to Nonexisting Transaction	Boolean	2	View
SOPHDRE3	SOP HDR Errors 3	Long Integer	4	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
ORGSEQNM	Original Sequence Number Corrected	Long Integer	4	View
ODECPLCU	Originating Decimal Places Currency	Integer	2	View
TTLRTLTD	Total Returns LTD	Currency	10	View
TTLRTLYR	Total Returns LYR	Currency	10	View
TTLRTYTD	Total Returns YTD	Currency	10	View
CUSTNAME1	ASI_Customer_Name	String	66	View
CNTCPRSN1	ASI_Contact_Person	String	62	View
ASI_Address_Code	ASI_Address_Code	String	16	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
COUNTRY1	ASI_Country	String	62	View
CITY1	ASI_City	String	36	View
STATE1	ASI_State	String	30	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
SLPRSNID1	ASI_Salesperson_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
PRCLEVEL1	ASI_PriceLevel	String	12	View
COMMENT11	ASI_Comment1	String	32	View
COMMENT21	ASI_Comment2	String	32	View
TXRGNNUM1	ASI_Tax_Registration_Number	String	26	View
TAXEXMT11	ASI_Tax_Exempt_1	String	26	View
TAXEXMT21	ASI_Tax_Exempt_2	String	26	View
SALSTERR1	ASI_Sales_Territory	String	16	View
KPCALHST1	ASI_Keep_Calendar_History	Boolean	2	View
KPDSTHST1	ASI_Keep_Distribution_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
PHONE31	ASI_Phone_3	String	22	View
ITEMDESC1	ASI_Item_Description	String	52	View
ITMTSHID1	ASI_Item_Tax_Schedule_ID	String	16	View
PRCLEVEL11	ASI_PriceLevel2	String	12	View
DECPLQTY1	ASI_Decimal_Places_QTYS	Integer	2	View
DECPLCUR1	ASI_Decimal_Places_Currency	Integer	2	View
ITEMCODE1	ASI_Item_Code	String	16	View
ReqShipDate1	ASI_Requested_Ship_Date	Date	4	View
FUFILDAT1	ASI_Fulfillment_Date	Date	4	View
ACTLSHIP1	ASI_Actual_Ship_Date	Date	4	View
PRCLEVEL111	ASI_PriceLevel3	String	12	View
LOCNCODE1	ASI_Location_Code	String	12	View
MRKDNAMT1	ASI_Markdown_Amount	Currency	10	View
SHIPMTHD11	ASI_Shipping_Method2	String	16	View
TRDISAMT1	ASI_Trade_Discount_Amount	Currency	10	View
EXTDCOST1	ASI_Extended_Cost	Currency	10	View
TXBTXAMT1	ASI_Taxable_Tax_Amount	Currency	10	View
TAXAMNT1	ASI_Tax_Amount	Currency	10	View
SALSTERR11	ASI_Sales_Territory2	String	16	View
SLPRSNID11	ASI_Salesperson_ID2	String	16	View
TRXSORCE1	ASI_TRX_Source	String	14	View
COMMNTID1	ASI_Comment_ID	String	16	View
CREATDDT11	ASI_Created_Date2	Date	4	View
MODIFDT11	ASI_Modified_Date2	Date	4	View
ORMRKDAM1	ASI_Originating_Markdown_Amount	Currency	10	View
ORTDISAM1	ASI_Originating_Trade_Discount_Amount	Currency	10	View
BSIVCTTL1	ASI_Based_On_Invoice_Total	Boolean	2	View
OREXTCST1	ASI_Originating_Extended_Cost	Currency	10	View
OTAXTAMT1	ASI_Originating_Taxable_Tax_Amount	Currency	10	View
ORTAXAMT1	ASI_Originating_Tax_Amount	Currency	10	View
NOTEINDX11	ASI_Note_Index2	Currency	10	View
ASI_Currency_Index	ASI_Currency_Index	Integer	2	View
SOPLNERR1	ASI_SOP_LINE_Errors_MSLB	Long Integer	4	View
LOCNCODE11	ASI_Location_Code2	String	12	View
DOCNCORR1	ASI_Document_Number_Corrected	String	22	View
TAXSCHID2	ASI_Tax_Schedule_ID_2	String	16	View
PRSTADCD2	ASI_Primary_Shipto_Address_Code_2	String	16	View
ShipToName1	ASI_ShipToName	String	66	View
CNTCPRSN2	ASI_Contact_Person_2	String	62	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
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE311	ASI_Phone_32	String	22	View
FAXNUMBR1	ASI_Fax_Number	String	22	View
EXCEPTIONALDEMAND	Exceptional Demand	Boolean	2	View
ASI_Tax_Schedule_Source	ASI_Tax_Schedule_Source	Integer	2	View
CONTNBR	Contract Number	String	12	View
CONTSTARTDTE	Contract Start Date	Date	4	View
CONTENDDTE	Contract End Date	Date	4	View
CONTITEMNBR	Contract Item Number	String	32	View
CONTSERIALNBR	Contract Serial Number	String	22	View
SOPSTATUS	SOP Status	Integer	2	View
CUSTPRIORITY	Customer Priority	Integer	2	View
ORDERFULFILLDEFAULT	Order Fulfillment Shortage Default	Integer	2	View
UMSCHDSC	U Of M Schedule Description	String	32	View
SHIPCOMPLETE	Ship Complete Document	Boolean	2	View
SHIPCOMPLETE1	ASI_Ship_Complete_Document	Boolean	2	View

ASIEXP20 - ASI SOP Line Item SmartList

Query Builder

Customer Service

Information

My Account

Contact Us