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