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 |