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_ExplorerSeq 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).
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 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).
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 Long Integer LI_14 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 Long Integer LI_14 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 Long Integer LI_14 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 Long Integer LI_14 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 Long Integer LI_14 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 Long Integer LI_14 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 Long Integer LI_14 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 String STR15_LBAU 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 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).
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 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).
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 String STR15_Sales_Territory 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 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).
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 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