GP Tables

ASIEXP20 - ASI SOP Line Item SmartList

Dynamics GP table ASIEXP20 (ASI SOP Line Item SmartList) contains 527 columns including ASI_Order_By, ASI_Favorite_Sequence, SOPTYPE....

SQL Query Builder

527 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
SOPTYPE SOP Type1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order (In SBF, this value is not available.) Integer 2
SOP Document Type values (6)
1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order
SOPNUMBE SOP Number String 22
LNITMSEQ Line Item Sequence Long Integer 4
CMPNTSEQ Component Sequence Long Integer 4
ASI_Document_Status ASI_Document_Status Integer 2
ITEMNMBR Item Number String 32
ITEMDESC Item Description String 102
NONINVEN Non IV Integer 2
DROPSHIP Drop Ship Integer 2
UOFM U Of M String 10
LOCNCODE Location Code String 12
UNITCOST Unit Cost Currency 10
ORUNTCST Originating Unit Cost Currency 10
UNITPRCE Unit Price Currency 10
ORUNTPRC Originating Unit Price Currency 10
XTNDPRCE Extended Price Currency 10
OXTNDPRC Originating Extended Price Currency 10
REMPRICE Remaining Price Currency 10
OREPRICE Originating Remaining Price Currency 10
EXTDCOST Extended Cost Currency 10
OREXTCST Originating Extended Cost Currency 10
MRKDNAMT Markdown Amount Currency 10
ORMRKDAM Originating Markdown Amount Currency 10
MRKDNPCT Markdown Percent Integer 2
MRKDNTYP Markdown Type Integer 2
INVINDX Inventory Index Long Integer 4
CSLSINDX Cost Of Sales Index Long Integer 4
SLSINDX Sales Index Long Integer 4
MKDNINDX Markdown Index Long Integer 4
RTNSINDX Returns Index Long Integer 4
INUSINDX In Use Index Long Integer 4
INSRINDX In Service Index Long Integer 4
DMGDINDX Damaged Index Long Integer 4
ITMTSHID Item Tax Schedule ID String 16
IVITMTXB IV Item Taxable Integer 2
BKTSLSAM Backout Sales Amount Currency 10
ORBKTSLS Originating Backout Sales Amount Currency 10
TAXAMNT Tax Amount Currency 10
ORTAXAMT Originating Tax Amount Currency 10
TXBTXAMT Taxable Tax Amount Currency 10
OTAXTAMT Originating Taxable Tax Amount Currency 10
BSIVCTTL Based On Invoice Total Boolean 2
TRDISAMT Trade Discount Amount Currency 10
ORTDISAM Originating Trade Discount Amount Currency 10
DISCSALE Discount Available Sales Currency 10
ORDAVSLS Originating Discount Available Sales Currency 10
QUANTITY QTY Currency 10
ATYALLOC QTY Allocated Currency 10
QTYINSVC QTY In Service Currency 10
QTYINUSE QTY In Use Currency 10
QTYDMGED QTY Damaged Currency 10
QTYRTRND QTY Returned Currency 10
QTYONHND QTY On Hand Currency 10
QTYCANCE QTY Canceled Currency 10
QTYCANOT QTY Canceled Other Currency 10
QTYORDER QTY Ordered Currency 10
QTYPRBAC QTY Prev Back Ordered Currency 10
QTYPRBOO QTY Prev BO On Order Currency 10
QTYPRINV QTY Prev Invoiced Currency 10
QTYPRORD QTY Prev Ordered Currency 10
QTYREMAI QTY Remaining Currency 10
QTYREMBO QTY Remaining On BO Currency 10
QTYTBAOR QTY To Back Order Currency 10
QTYTOINV QTY To Invoice Currency 10
QTYTORDR QTY To Order Currency 10
QTYFULFI QTY Fulfilled Currency 10
QTYSLCTD QTY Selected Currency 10
QTYBSUOM QTY In Base U Of M Currency 10
EXTQTYAL Existing Qty Available Currency 10
EXTQTYSEL Existing Qty Selected Currency 10
ReqShipDate Requested Ship Date Date 4
FUFILDAT Fulfillment Date Date 4
ACTLSHIP Actual Ship Date Date 4
SHIPMTHD Shipping Method String 16
SALSTERR Sales Territory String 16
SLPRSNID Salesperson ID String 16
PRCLEVEL PriceLevel String 12
COMMNTID Comment ID String 16
BRKFLD1 Break Field 1 Integer 2
BRKFLD2 Break Field 2 Integer 2
BRKFLD3 Break Field 3 Integer 2
CURRNIDX Currency Index Integer 2
TRXSORCE TRX Source String 14
SOPLNERR SOP LINE Errors Long Integer 4
PURCHSTAT Purchasing Status Integer 2
QTYONPO QTY On PO Currency 10
QTYRECVD QTY Received Currency 10
QTYPRVRECVD QTY Prev Received Currency 10
ORIGTYPE Original Type1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order (In SBF, this value is not available.) Integer 2
DOCID Document ID String 16
DOCDATE Document Date Date 4
GLPOSTDT GL Posting Date Date 4
QUOTEDAT Quote Date Date 4
QUOEXPDA Quote Expiration Date Date 4
ORDRDATE Order Date Date 4
INVODATE Invoice Date Date 4
BACKDATE Back Order Date Date 4
RETUDATE Return Date Date 4
DISCDATE Discount Date Date 4
DUEDATE Due Date Date 4
REPTING Repeating0 = Non-repeating document1 = Repeating Boolean 2
TRXFREQU TRX Frequency1 = Weekly2 = Biweekly3 = Semimonthly4 = Monthly5 = Bimonthly6 = Quarterly7 = Miscellaneous Integer 2
TIMEREPD Times Repeated Integer 2
DYSTINCR Days to Increment Integer 2
DTLSTREP Date Last Repeated Date 4
DSTBTCH1 Dest Batch 1 String 16
DSTBTCH2 Dest Batch 2 String 16
USDOCID1 Use Document ID 1 String 16
USDOCID2 Use Document ID 2 String 16
DISCFRGT Discount Available Freight Currency 10
ORDAVFRT Originating Discount Available Freight Currency 10
DISCMISC Discount Available Misc Currency 10
ORDAVMSC Originating Discount Available Misc Currency 10
DISAVAMT Discount Available Amount Currency 10
ORDAVAMT Originating Discount Available Amount Currency 10
DISCRTND Discount Returned Currency 10
ORDISRTD Originating Discount Returned Currency 10
DISTKNAM Discount Taken Amount Currency 10
ORDISTKN Originating Discount Taken Amount Currency 10
DSCPCTAM Discount Percent Amount Integer 2
DSCDLRAM Discount Dollar Amount Currency 10
ORDATKN Originating Discount Available Taken Currency 10
PYMTRMID Payment Terms ID String 22
BCHSOURC Batch Source String 16
BACHNUMB Batch Number String 16
CUSTNMBR Customer Number String 16
CUSTNAME Customer Name String 66
CSTPONBR Customer PO Number String 22
PROSPECT Prospect0 = Existing Customer1 = Prospect Integer 2
MSTRNUMB Master Number Long Integer 4
PCKSLPNO Packing Slip Number String 22
PICTICNU Picking Ticket Number String 22
PRBTADCD Primary Billto Address Code String 16
PRSTADCD Primary Shipto Address Code String 16
CNTCPRSN Contact Person String 62
ShipToName ShipToName String 66
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
CITY City String 36
STATE State String 30
ZIPCODE Zip Code String 12
COUNTRY Country String 62
PHNUMBR1 Phone Number 1 String 22
PHNUMBR2 Phone Number 2 String 22
FAXNUMBR Fax Number String 22
COMAPPTO Commission Applied To Integer 2
COMMAMNT Commission Amount Currency 10
OCOMMAMT Originating Commission Amount Currency 10
CMMSLAMT Commission Sale Amount Currency 10
ORCOSAMT Originating Commission Sales Amount Currency 10
NCOMAMNT Non-Commissioned Amount Currency 10
ORNCMAMT Originating Non-Commissioned Amount Currency 10
TRDISPCT Trade Discount Percent Integer 2
SUBTOTAL Subtotal Currency 10
ORSUBTOT Originating Subtotal Currency 10
REMSUBTO Remaining Subtotal Currency 10
OREMSUBT Originating Remaining Subtotal Currency 10
FRTAMNT Freight Amount Currency 10
ORFRTAMT Originating Freight Amount Currency 10
MISCAMNT Misc Amount Currency 10
ORMISCAMT Originating Misc Amount Currency 10
TXENGCLD Tax Engine Called Boolean 2
TAXEXMT1 Tax Exempt 1 String 26
TAXEXMT2 Tax Exempt 2 String 26
TXRGNNUM Tax Registration Number String 26
TAXSCHID Tax Schedule ID String 16
TXSCHSRC Tax Schedule Source Integer 2
FRTSCHID Freight Schedule ID String 16
FRTTXAMT Freight Tax Amount Currency 10
ORFRTTAX Originating Freight Tax Amount Currency 10
FRGTTXBL Freight Taxable1 = Taxable2 = Nontaxable3 = Base on customers Integer 2
MSCSCHID Misc Schedule ID String 16
MSCTXAMT Misc Tax Amount Currency 10
ORMSCTAX Originating Misc Tax Amount Currency 10
MISCTXBL Misc Taxable1 = Taxable2 = Nontaxable3 = Base on customers Integer 2
BKTFRTAM Backout Freight Amount Currency 10
ORBKTFRT Originating Backout Freight Amount Currency 10
BKTMSCAM Backout Misc Amount Currency 10
ORBKTMSC Originating Backout Misc Amount Currency 10
BCKTXAMT Backout Tax Amount Currency 10
OBTAXAMT Originating Backout Tax Amount Currency 10
ECTRX EC Transaction Boolean 2
DOCAMNT Document Amount Currency 10
ORDOCAMT Originating Document Amount Currency 10
PYMTRCVD Payment Received Currency 10
ORPMTRVD Originating Payment Received Currency 10
DEPRECVD Deposit Received Currency 10
ORDEPRVD Originating Deposit Received Currency 10
CODAMNT COD Amount Currency 10
ORCODAMT Originating COD Amount Currency 10
ACCTAMNT Account Amount Currency 10
ORACTAMT Originating Account Amount Currency 10
UPSZONE UPS Zone String 4
TIMESPRT Times Printed Integer 2
PSTGSTUS Posting Status1 = Work2 = Open3 = History4 = Originating Integer 2
Posting Status values (11)
0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
VOIDSTTS Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. Integer 2
Void Status values (2)
0 = Normal1 = Voided
ALLOCABY Allocate By Integer 2
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
RATETPID Rate Type ID String 16
EXGTBLID Exchange Table ID String 16
XCHGRATE Exchange Rate Currency (Variable) 10
DENXRATE Denomination Exchange Rate Currency (Variable) 10
EXCHDATE Exchange Date Date 4
TIME1 Time Time 4
RTCLCMTD Rate Calculation Method Integer 2
MCTRXSTT MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = 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
SOPHDRE1 SOP HDR Errors 1 Long Integer 4
SOPHDRE2 SOP HDR Errors 2 Long Integer 4
SOPHDRFL SOP HDR Flags Long Integer 4
REFRENCE Reference String 32
POSTEDDT Posted Date Date 4
PTDUSRID Posted User ID String 16
USER2ENT User To Enter String 16
CREATDDT Created Date Date 4
MODIFDT Modified Date Date 4
Tax_Date Tax Date Date 4
ITMSHNAM Item Short Name String 16
ITEMTYPE Item Type1. Sales Inventory (For SBM, this type is Stock Item.)2. Discontinued3. Kit4. Misc Charges5. Services6. Flat Fee (For SBM, this type is Labor.) Integer 2
Item Type values (6)
1 = Sales Inventory2 = Discontinued3 = Kit4 = Misc Charges5 = Services6 = Flat Fee
ITMGEDSC Item Generic Description String 12
STNDCOST Standard Cost Currency 10
CURRCOST Current Cost Currency 10
LISTPRCE List Price Currency 10
ITEMSHWT Item Shipping Weight Long Integer 4
DECPLQTY Decimal Places QTYS Integer 2
DECPLCUR Decimal Places Currency Integer 2
TAXOPTNS Tax Options1.  Taxable2.  Nontaxable3.  Base on customers Integer 2
Tax Options values (3)
1 = Taxable2 = Nontaxable3 = Base on customer/vendor
COMMCODE Commission Code String 16
IVIVINDX IV IV Index Long Integer 4
IVIVOFIX IV IV Offset Index Long Integer 4
IVCOGSIX IV COGS Index Long Integer 4
IVSLSIDX IV Sales Index Long Integer 4
IVSLDSIX IV Sales Discounts Index Long Integer 4
IVSLRNIX IV Sales Returns Index Long Integer 4
IVINUSIX IV In Use Index Long Integer 4
IVINSVIX IV In Service Index Long Integer 4
IVDMGIDX IV Damaged Index Long Integer 4
IVVARIDX IV Variances Index Long Integer 4
DPSHPIDX Drop Ship Index Long Integer 4
PURPVIDX Purchase Price Variance Index Long Integer 4
IVRETIDX Inventory Returns Index Long Integer 4
ASMVRIDX Assembly Variance Index Long Integer 4
ITMCLSCD Item Class Code String 12
ITMTRKOP Item Tracking Option1. None2. Serial Numbers3. Lot Numbers Integer 2
Item Tracking Option values (3)
1 = None2 = Serial Numbers3 = Lot Numbers
LOTTYPE Lot Type String 12
KPERHIST Keep Period History Boolean 2
KPTRXHST Keep Trx History Boolean 2
KPCALHST Keep Calendar History Boolean 2
KPDSTHST Keep Distribution History Boolean 2
ALWBKORD Allow Back Orders Boolean 2
VCTNMTHD Valuation Method1. FIFO Perpetual2. LIFO Perpetual3. Average Perpetual4. FIFO Periodic (This value is not available for SBM.)5. LIFO Periodic (This value is not available for SBM.) Integer 2
Valuation Method values (5)
1 = FIFO Perpetual2 = LIFO Perpetual3 = Average Perpetual4 = FIFO Periodic5 = LIFO Periodic
UOMSCHDL U Of M Schedule String 12
ObjRef1 ObjRef1 Invalid storage type 30 0
ALTITEM1 Alternate Item 1 String 32
ALTITEM2 Alternate Item 2 String 32
USCATVLS_1 User Category Values[1] String 12
USCATVLS_2 User Category Values[2] String 12
USCATVLS_3 User Category Values[3] String 12
USCATVLS_4 User Category Values[4] String 12
USCATVLS_5 User Category Values[5] String 12
USCATVLS_6 User Category Values[6] String 12
MSTRCDTY Master Record Type Integer 2
WRNTYDYS Warranty Days Integer 2
ORIGNUMB Original Number String 22
DISAVTKN Discount Available Taken Currency 10
TIMETREP Times To Repeat Integer 2
ORDDLRAT Originating Discount Dollar Amount Currency 10
SOPMCERR SOP MC Posting Error Messages Long Integer 4
NOTEINDX Note Index Currency 10
CUSTCLAS Customer Class String 16
CPRCSTNM Corporate Customer Number String 16
STMTNAME Statement Name String 66
ADRSCODE Address Code String 16
STADDRCD Statement Address Code String 16
CHEKBKID Checkbook ID String 16
CRLMTTYP Credit Limit Type Integer 2
CRLMTAMT Credit Limit Amount Currency 10
CRLMTPER Credit Limit Period Integer 2
CRLMTPAM Credit Limit Period Amount Currency 10
CUSTDISC Customer Discount Integer 2
SHRTNAME Short Name String 16
MINPYTYP Minimum Payment Type Integer 2
MINPYDLR Minimum Payment Dollar Currency 10
MINPYPCT Minimum Payment Percent Integer 2
FNCHATYP Finance Charge Amt Type Integer 2
FNCHPCNT Finance Charge Percent Integer 2
FINCHDLR Finance Charge Dollar Currency 10
MXWOFTYP Maximum Writeoff Type Integer 2
MXWROFAM Max Writeoff Amount Currency 10
USERDEF1 User Defined 1 String 22
USERDEF2 User Defined 2 String 22
BALNCTYP Balance Type Integer 2
STMTCYCL Statement Cycle1. No Statement2. Weekly3. Biweekly4. Semi Monthly5. Monthly6. Bimonthly7. Quarterly Integer 2
BANKNAME Bank Name String 32
BNKBRNCH Bank Branch String 22
DEFCACTY Default Cash Account Type0. Checkbook1. Customer Integer 2
RMCSHACC RM Cash Account Index Long Integer 4
RMARACC RM AR Account Index Long Integer 4
RMSLSACC RM Sales Account Index Long Integer 4
RMIVACC RM IV Account Index Long Integer 4
RMCOSACC RM Cost Of Sales Account Index Long Integer 4
RMTAKACC RM Discounts Taken Account Index Long Integer 4
RMAVACC RM Discounts Avail Account Index Long Integer 4
RMFCGACC RM Finance Charge Account Index Long Integer 4
RMWRACC RM Writeoff Account Index Long Integer 4
FRSTINDT First Invoice Date Date 4
INACTIVE Inactive Boolean 2
Active Status values (2)
0 = Active1 = Inactive
HOLD Hold Boolean 2
Hold Status values (2)
0 = Not on hold1 = On hold
CRCARDID Credit Card ID String 16
CRCRDNUM Credit Card Number String 22
CCRDXPDT Credit Card Exp Date Date 4
Revalue_Customer Revalue Customer Boolean 2
Post_Results_To Post Results To Integer 2
FINCHID Finance Charge ID String 16
GOVCRPID Governmental Corporate ID String 32
GOVINDID Governmental Individual ID String 32
TNSFCLIF Total Amount Of NSF Checks Life Currency 10
NONSFLIF Number Of NSF Checks Life Long Integer 4
CUSTBLNC Customer Balance Currency 10
AGPERAMT_1 Aging Period Amounts[1] Currency 10
AGPERAMT_2 Aging Period Amounts[2] Currency 10
AGPERAMT_3 Aging Period Amounts[3] Currency 10
AGPERAMT_4 Aging Period Amounts[4] Currency 10
AGPERAMT_5 Aging Period Amounts[5] Currency 10
AGPERAMT_6 Aging Period Amounts[6] Currency 10
AGPERAMT_7 Aging Period Amounts[7] Currency 10
LASTAGED Last Aged Date 4
LSTNSFCD Last NSF Check Date Date 4
LPYMTAMT Last Payment Amount Currency 10
LASTPYDT Last Payment Date Date 4
LSTTRXDT Last Transaction Date Date 4
LSTTRXAM Last Transaction Amount Currency 10
LSTFCHAM Last Finance Charge Amount Currency 10
UPFCHYTD Unpaid Finance Charges YTD Currency 10
AVDTPLYR Average Days to Pay - LYR Integer 2
AVDTPLIF Average Days To Pay - Life Integer 2
AVGDTPYR Average Days To Pay - Year Integer 2
NUMADTPL Number ADTP Documents - Life Long Integer 4
NUMADTPR Number ADTP Documents - LYR Long Integer 4
NUMADTPY Number ADTP Documents - Year Long Integer 4
TDTKNLTD Total Discounts Taken LTD Currency 10
TDTKNLYR Total Discounts Taken LYR Currency 10
TDTKNYTD Total Discounts Taken YTD Currency 10
TDISAYTD Total Discounts Available YTD Currency 10
RETAINAG Retainage Currency 10
TNSFCYTD Total Amount Of NSF Checks YTD Currency 10
NONSFYTD Number Of NSF Checks YTD Long Integer 4
UNPSTDSA Unposted Sales Amount Currency 10
UNPSTDCA Unposted Cash Amount Currency 10
UNPSTOSA Unposted Other Sales Amount Currency 10
UNPSTOCA Unposted Other Cash Amount Currency 10
NCSCHPMT Non Current Scheduled Payments Currency 10
TTLSLLTD Total Sales LTD Currency 10
TTLSLLYR Total Sales LYR Currency 10
TTLSLYTD Total Sales YTD Currency 10
TCOSTLTD Total Costs LTD Currency 10
TCOSTLYR Total Costs LYR Currency 10
TCOSTYTD Total Costs YTD Currency 10
TCSHRLTD Total Cash Received LTD Currency 10
TCSHRLYR Total Cash Received LYR Currency 10
TCSHRYTD Total Cash Received YTD Currency 10
TFNCHLTD Total Finance Charges LTD Currency 10
TFNCHLYR Total Finance Charges LYR Currency 10
TFNCHYTD Total Finance Charges YTD Currency 10
FNCHCYTD Finance Charges CYTD Currency 10
FNCHLYRC Finance Charges LYR Calendar Currency 10
TBDDTLYR Total Bad Deb LYR Currency 10
TBDDTLTD Total Bad Debt LTD Currency 10
TBDDTYTD Total Bad Debt YTD Currency 10
TWVFCLTD Total Waived FC LTD Currency 10
TWVFCLYR Total Waived FC LYR Currency 10
TWVFCYTD Total Waived FC YTD Currency 10
TWROFLTD Total Writeoffs LTD Currency 10
TWROFLYR Total Writeoffs LYR Currency 10
TWROFYTD Total Writeoffs YTD Currency 10
TTLINLTD Total # Invoices LTD Long Integer 4
TTLINLYR Total # Invoices LYR Long Integer 4
TTLINYTD Total # Invoices YTD Long Integer 4
TTLFCLTD Total # FC LTD Long Integer 4
TTLFCLYR Total # FC LYR Long Integer 4
TTLFCYTD Total # FC YTD Long Integer 4
WROFSLIF Write Offs LIFE Currency 10
WROFSLYR Write Offs LYR Currency 10
WROFSYTD Write Offs YTD Currency 10
HIBALLTD High Balance LTD Currency 10
HIBALLYR High Balance LYR Currency 10
HIBALYTD High Balance YTD Currency 10
LASTSTDT Last Statement Date Date 4
LSTSTAMT Last Statement Amount Currency 10
DEPRECV Deposits Received Currency 10
ONORDAMT On Order Amount Currency 10
DISGRPER Discount Grace Period Integer 2
DOCFMTID Document Format ID String 16
DUEGRPER Due Date Grace Period Integer 2
APLYWITH Apply Withholding Boolean 2
CORRCTN Correction Boolean 2
DOCNCORR Document Number Corrected String 22
PHONE3 Phone 3 String 22
SALEDATE Sale Date Date 4
SEQNCORR Sequence Number Corrected Integer 2
SHPPGDOC Shipping Document Boolean 2
SIMPLIFD Simplified Boolean 2
WITHHAMT Withholding Amount Currency 10
CORRNXST Correction to Nonexisting Transaction Boolean 2
SOPHDRE3 SOP HDR Errors 3 Long Integer 4
ABCCODE ABC Code1 – (None)2 – A3 – B4 – C Integer 2
CGSINFLX COGS Inflation Index Long Integer 4
CGSMCIDX COGS Monetary Correction Index Long Integer 4
IVINFIDX Inventory Inflation Index Long Integer 4
INVMCIDX Inventory Monetary Correction Index Long Integer 4
ITEMCODE Item Code String 16
KTACCTSR Kit COGS Account Source0 – COGS accounts from the components1 – COGS account from the kit Integer 2
Kit COGS Account Source values (2)
0 = From component items1 = From kit item
LASTGENSN Last Generated Serial Number String 22
PriceGroup Price Group String 12
PRICMTHD Price Method1 – Currency Amount2 – % of List Price3 – % Markup – Current Cost4 – % Markup – Standard Cost5 – % Margin – Current Cost6 – % Margin – Standard Cost Integer 2
Price Method values (6)
1 = Currency Amount2 = % of List Price3 = % Markup - Current Cost4 = % Markup - Standard Cost5 = % Margin - Current Cost6 = % Margin - Standard Cost
PINFLIDX Purch Inflation Index Long Integer 4
PURMCIDX Purch Monetary Correction Index Long Integer 4
PRCHSUOM Purchasing U Of M String 10
SELNGUOM Selling U Of M String 10
TCC Tax Commodity Code String 32
UPPVIDX Unrealized Purchase Price Variance Index Long Integer 4
ORGSEQNM Original Sequence Number Corrected Long Integer 4
ODECPLCU Originating Decimal Places Currency Integer 2
TTLRTLTD Total Returns LTD Currency 10
TTLRTLYR Total Returns LYR Currency 10
TTLRTYTD Total Returns YTD Currency 10
CUSTNAME1 ASI_Customer_Name String 66
CNTCPRSN1 ASI_Contact_Person String 62
ASI_Address_Code ASI_Address_Code String 16
UPSZONE1 ASI_UPS_Zone String 4
SHIPMTHD1 ASI_Shipping_Method String 16
TAXSCHID1 ASI_Tax_Schedule_ID String 16
ADDRESS11 ASI_Address_1 String 62
ADDRESS21 ASI_Address_2 String 62
ADDRESS31 ASI_Address_3 String 62
COUNTRY1 ASI_Country String 62
CITY1 ASI_City String 36
STATE1 ASI_State String 30
ZIP1 ASI_Zip String 12
PHONE11 ASI_Phone_1 String 22
PHONE21 ASI_Phone_2 String 22
FAX1 ASI_Fax String 22
PRBTADCD1 ASI_Primary_Billto_Address_Code String 16
PRSTADCD1 ASI_Primary_Shipto_Address_Code String 16
SLPRSNID1 ASI_Salesperson_ID String 16
PYMTRMID1 ASI_Payment_Terms_ID String 22
CURNCYID1 ASI_Currency_ID String 16
RATETPID1 ASI_Rate_Type_ID String 16
PRCLEVEL1 ASI_PriceLevel String 12
COMMENT11 ASI_Comment1 String 32
COMMENT21 ASI_Comment2 String 32
TXRGNNUM1 ASI_Tax_Registration_Number String 26
TAXEXMT11 ASI_Tax_Exempt_1 String 26
TAXEXMT21 ASI_Tax_Exempt_2 String 26
SALSTERR1 ASI_Sales_Territory String 16
KPCALHST1 ASI_Keep_Calendar_History Boolean 2
KPDSTHST1 ASI_Keep_Distribution_History Boolean 2
KPERHIST1 ASI_Keep_Period_History Boolean 2
KPTRXHST1 ASI_Keep_Trx_History Boolean 2
NOTEINDX1 ASI_Note_Index Currency 10
CREATDDT1 ASI_Created_Date Date 4
MODIFDT1 ASI_Modified_Date Date 4
PHONE31 ASI_Phone_3 String 22
ITEMDESC1 ASI_Item_Description String 52
ITMTSHID1 ASI_Item_Tax_Schedule_ID String 16
PRCLEVEL11 ASI_PriceLevel2 String 12
DECPLQTY1 ASI_Decimal_Places_QTYS Integer 2
DECPLCUR1 ASI_Decimal_Places_Currency Integer 2
ITEMCODE1 ASI_Item_Code String 16
ReqShipDate1 ASI_Requested_Ship_Date Date 4
FUFILDAT1 ASI_Fulfillment_Date Date 4
ACTLSHIP1 ASI_Actual_Ship_Date Date 4
PRCLEVEL111 ASI_PriceLevel3 String 12
LOCNCODE1 ASI_Location_Code String 12
MRKDNAMT1 ASI_Markdown_Amount Currency 10
SHIPMTHD11 ASI_Shipping_Method2 String 16
TRDISAMT1 ASI_Trade_Discount_Amount Currency 10
EXTDCOST1 ASI_Extended_Cost Currency 10
TXBTXAMT1 ASI_Taxable_Tax_Amount Currency 10
TAXAMNT1 ASI_Tax_Amount Currency 10
SALSTERR11 ASI_Sales_Territory2 String 16
SLPRSNID11 ASI_Salesperson_ID2 String 16
TRXSORCE1 ASI_TRX_Source String 14
COMMNTID1 ASI_Comment_ID String 16
CREATDDT11 ASI_Created_Date2 Date 4
MODIFDT11 ASI_Modified_Date2 Date 4
ORMRKDAM1 ASI_Originating_Markdown_Amount Currency 10
ORTDISAM1 ASI_Originating_Trade_Discount_Amount Currency 10
BSIVCTTL1 ASI_Based_On_Invoice_Total Boolean 2
OREXTCST1 ASI_Originating_Extended_Cost Currency 10
OTAXTAMT1 ASI_Originating_Taxable_Tax_Amount Currency 10
ORTAXAMT1 ASI_Originating_Tax_Amount Currency 10
NOTEINDX11 ASI_Note_Index2 Currency 10
ASI_Currency_Index ASI_Currency_Index Integer 2
SOPLNERR1 ASI_SOP_LINE_Errors_MSLB Long Integer 4
LOCNCODE11 ASI_Location_Code2 String 12
DOCNCORR1 ASI_Document_Number_Corrected String 22
TAXSCHID2 ASI_Tax_Schedule_ID_2 String 16
PRSTADCD2 ASI_Primary_Shipto_Address_Code_2 String 16
ShipToName1 ASI_ShipToName String 66
CNTCPRSN2 ASI_Contact_Person_2 String 62
ADDRESS111 ASI_Address_12 String 62
ADDRESS211 ASI_Address_22 String 62
ADDRESS311 ASI_Address_32 String 62
CITY11 ASI_City2 String 36
STATE11 ASI_State2 String 30
ZIPCODE1 ASI_Zip_Code String 12
COUNTRY11 ASI_Country2 String 62
PHONE1 Phone 1 String 22
PHONE2 Phone 2 String 22
PHONE311 ASI_Phone_32 String 22
FAXNUMBR1 ASI_Fax_Number String 22
EXCEPTIONALDEMAND Exceptional Demand Boolean 2
ASI_Tax_Schedule_Source ASI_Tax_Schedule_Source Integer 2
CONTNBR Contract Number String 12
CONTSTARTDTE Contract Start Date Date 4
CONTENDDTE Contract End Date Date 4
CONTITEMNBR Contract Item Number String 32
CONTSERIALNBR Contract Serial Number String 22
SOPSTATUS SOP Status Integer 2
CUSTPRIORITY Customer Priority Integer 2
ORDERFULFILLDEFAULT Order Fulfillment Shortage Default Integer 2
UMSCHDSC U Of M Schedule Description String 32
SHIPCOMPLETE Ship Complete Document Boolean 2
SHIPCOMPLETE1 ASI_Ship_Complete_Document Boolean 2

Related Tables

Tables that share columns with ASIEXP20. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

TIME1

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP21 ASIEXP24

LNITMSEQ

ASIEXP25 ASIEXP26 DO10100 EDCEI006 EEPAIVRQ ERB10300 ERB10700 ERB11200

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP18 ASIEXP19

XCHGRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

DENXRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07