Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP26
Product: SmartList (1493)
Series:
Display Name: SmartList Invoicing Transaction Amounts Work
Physical Name: ASIEXP26
Technical Name: ASI_IVC_LINE_WORK_Explorer
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
|---|
| 1 | ASI_Favorite_Sequence  | ASI_Favorite_Sequence | Long Integer | ASI_LI_10_RU | 10 |
| 2 | ASI_Order_By | ASI_Order_By | Long Integer | LI_14 | 14 |
| 3 | ASI_Document_Status | ASI_Document_Status | Integer | INT | 0 |
| 4 | DOCTYPE | Document Type | Integer | DDL_Document_Type | 0 |
| 5 | INVCNMBR | Invoice Number | String | STR20_IVC_Document_Number | 17 |
| 6 | LNITMSEQ | Line Item Sequence | Long Integer | LI_Sequence_Number | 10 |
| 7 | CMPNTSEQ | Component Sequence | Long Integer | LI_Sequence_Number | 10 |
| 8 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 |
| Key to the Item Master (IV00101).
SELECT
['SmartList Invoicing Transaction Amounts Work'].ITEMNMBR AS 'SmartList Invoicing Transaction Amounts Work-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SmartList Invoicing Transaction Amounts Work'].ITEMNMBR = ['Item Master'].ITEMNMBR |
| 9 | DECPLCUR | Decimal Places Currency | Integer | DDL_Decimal_Places_Dollars | 0 |
| 10 | DECPLQTY | Decimal Places QTYS | Integer | DDL_Decimal_Places_QTYS | 0 |
| 11 | INVINDX | Inventory Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Invoicing Transaction Amounts Work'].INVINDX AS 'SmartList Invoicing Transaction Amounts Work-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Invoicing Transaction Amounts Work'].INVINDX = ['Account Index Master'].ACTINDX |
| 12 | CSLSINDX | Cost Of Sales Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Invoicing Transaction Amounts Work'].CSLSINDX AS 'SmartList Invoicing Transaction Amounts Work-Cost Of Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Invoicing Transaction Amounts Work'].CSLSINDX = ['Account Index Master'].ACTINDX |
| 13 | SLSINDX | Sales Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Invoicing Transaction Amounts Work'].SLSINDX AS 'SmartList Invoicing Transaction Amounts Work-Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Invoicing Transaction Amounts Work'].SLSINDX = ['Account Index Master'].ACTINDX |
| 14 | MKDNINDX | Markdown Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Invoicing Transaction Amounts Work'].MKDNINDX AS 'SmartList Invoicing Transaction Amounts Work-Markdown Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Invoicing Transaction Amounts Work'].MKDNINDX = ['Account Index Master'].ACTINDX |
| 15 | RTNSINDX | Returns Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Invoicing Transaction Amounts Work'].RTNSINDX AS 'SmartList Invoicing Transaction Amounts Work-Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Invoicing Transaction Amounts Work'].RTNSINDX = ['Account Index Master'].ACTINDX |
| 16 | INUSINDX | In Use Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Invoicing Transaction Amounts Work'].INUSINDX AS 'SmartList Invoicing Transaction Amounts Work-In Use Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Invoicing Transaction Amounts Work'].INUSINDX = ['Account Index Master'].ACTINDX |
| 17 | INSRINDX | In Service Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Invoicing Transaction Amounts Work'].INSRINDX AS 'SmartList Invoicing Transaction Amounts Work-In Service Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Invoicing Transaction Amounts Work'].INSRINDX = ['Account Index Master'].ACTINDX |
| 18 | DMGDINDX | Damaged Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Invoicing Transaction Amounts Work'].DMGDINDX AS 'SmartList Invoicing Transaction Amounts Work-Damaged Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Invoicing Transaction Amounts Work'].DMGDINDX = ['Account Index Master'].ACTINDX |
| 19 | ITMTSHID | Item Tax Schedule ID | String | STR15_LBAU | 15 |
| Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
SELECT
['SmartList Invoicing Transaction Amounts Work'].ITMTSHID AS 'SmartList Invoicing Transaction Amounts Work-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Invoicing Transaction Amounts Work'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID |
| 20 | IVITMTXB | IV Item Taxable | Integer | DDL_Tax_Options | 0 |
| 21 | NONINVEN | Non IV | Integer | INT1 | 1 |
| 22 | QUANTITY | QTY | Currency | DLR17_QTY_RBS0_STR | 17 |
| 23 | QTYINSVC | QTY In Service | Currency | DLR17_QTY_RBS0_UTR | 17 |
| 24 | QTYINUSE | QTY In Use | Currency | DLR17_QTY_RBS0_UTR | 17 |
| 25 | QTYDMGED | QTY Damaged | Currency | DLR17_QTY_RBS0_UTR | 17 |
| 26 | QTYRTRND | QTY Returned | Currency | DLR17_QTY_RBS0_UTR | 17 |
| 27 | QTYONHND | QTY On Hand | Currency | DLR17_QTY_RBS0_STR | 17 |
| 28 | EXTQTYSEL | Existing Qty Selected | Currency | DLR17_QTY_RBS0_STR | 17 |
| 29 | UOFM | U Of M | String | U_Of_M | 8 |
| 30 | QTYBSUOM | QTY In Base U Of M | Currency | DLR17_QTY_RBS0_STR | 17 |
| 31 | UNITCOST | Unit Cost | Currency | DLR17_RBS0_UTR$ | 17 |
| 32 | EXTDCOST | Extended Cost | Currency | DLR17_RBS0_UTR$ | 17 |
| 33 | DISCSALE | Discount Available Sales | Currency | DLR17_RBS0_UTR$ | 17 |
| 34 | TRDISAMT | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 |
| 35 | ATYALLOC | QTY Allocated | Currency | DLR17_QTY_RBS0_UTR | 17 |
| 36 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 |
| Key to the Site Setup (IV40700).
SELECT
['SmartList Invoicing Transaction Amounts Work'].LOCNCODE AS 'SmartList Invoicing Transaction Amounts Work-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SmartList Invoicing Transaction Amounts Work'].LOCNCODE = ['Site Setup'].LOCNCODE |
| 37 | MRKDNTYP | Markdown Type | Integer | GB | 0 |
| 38 | MRKDNAMT | Markdown Amount | Currency | DLR17_RBS0_UTR$ | 17 |
| 39 | MRKDNPCT | Markdown Percent | Integer | INT5_%2 | 5 |
| 40 | PRCLEVEL | PriceLevel | String | STR10_LBAU | 10 |
| 41 | XTNDPRCE | Extended Price | Currency | DLR17_RBS0_STR$ | 17 |
| 42 | UNITPRCE | Unit Price | Currency | DLR17_RBS0_STR$ | 17 |
| 43 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 |
| 44 | BKTSLSAM | Backout Sales Amount | Currency | DLR19_RBS0_UTR$ | 19 |
| 45 | TXBTXAMT | Taxable Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 |
| 46 | BSIVCTTL | Based On Invoice Total | Boolean | YN | 0 |
| 47 | SLPRSNID | Salesperson ID | String | STR15_Salesperson_ID | 15 |
| Key to the RM Salesperson Master (RM00301).
SELECT
['SmartList Invoicing Transaction Amounts Work'].SLPRSNID AS 'SmartList Invoicing Transaction Amounts Work-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['SmartList Invoicing Transaction Amounts Work'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID |
| 48 | SALSTERR | Sales Territory | String | STR15_Sales_Territory | 15 |
| Key to the Sales Territory Master File (RM00303).
SELECT
['SmartList Invoicing Transaction Amounts Work'].SALSTERR AS 'SmartList Invoicing Transaction Amounts Work-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['SmartList Invoicing Transaction Amounts Work'].SALSTERR = ['Sales Territory Master File'].SALSTERR |
| 49 | DSCRIPTN | Description | String | STR30 | 30 |
| 50 | ITEMDESC | Item Description | String | STR100 | 100 |
| 51 | EXPTSHIP | Expected Ship Date | Date | DT | 8 |
| 52 | ACTLSHIP | Actual Ship Date | Date | DT | 8 |
| 53 | ReqShipDate | Requested Ship Date | Date | DT | 8 |
| 54 | COMDLRAM | Commission Dollar Amount | Currency | DLR17_RBSO_STR$ | 17 |
| 55 | CMPSERNM | Component Serial Numbered | Boolean | YN | 0 |
| 56 | COMMNTID | Comment ID | String | STR15_Comment_ID | 15 |
| Key to the Comment Master (SY04200).
SELECT
['SmartList Invoicing Transaction Amounts Work'].COMMNTID AS 'SmartList Invoicing Transaction Amounts Work-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
ASIEXP26 AS ['SmartList Invoicing Transaction Amounts Work']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['SmartList Invoicing Transaction Amounts Work'].COMMNTID = ['Comment Master'].COMMNTID |
| 57 | BRKFLD1 | Break Field 1 | Integer | INT1 | 1 |
| 58 | BRKFLD2 | Break Field 2 | Integer | INT1 | 1 |
| 59 | BRKFLD3 | Break Field 3 | Integer | INT1 | 1 |
| 60 | TRXSORCE | TRX Source | String | STR13 | 13 |
| 61 | IVCLINEERR | IVC LINE Errors | Long Integer | ML_IVC_LINE_Errors | 0 |
| 62 | ASI_Customer_Number | ASI_Customer_Number | String | STR15_RM_Customer_Number | 15 |
