SmartList Invoicing Transaction Amounts Work (ASIEXP26)

azurecurveProductsSmartList (1493)PathnameSmartList Invoicing Transaction Amounts Work (ASIEXP26)

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_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
2ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
3ASI_Document_Status SearchASI_Document_StatusINTInteger20
4DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
5INVCNMBR SearchInvoice NumberSTR20_IVC_Document_NumberString2217
6LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
7CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer410
8ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
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'].ITEMNMBR
9DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
10DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
11INVINDX SearchInventory IndexLI_14Long Integer414
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'].ACTINDX
12CSLSINDX SearchCost Of Sales IndexLI_14Long Integer414
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'].ACTINDX
13SLSINDX SearchSales IndexLI_14Long Integer414
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'].ACTINDX
14MKDNINDX SearchMarkdown IndexLI_14Long Integer414
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'].ACTINDX
15RTNSINDX SearchReturns IndexLI_14Long Integer414
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'].ACTINDX
16INUSINDX SearchIn Use IndexLI_14Long Integer414
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'].ACTINDX
17INSRINDX SearchIn Service IndexLI_14Long Integer414
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'].ACTINDX
18DMGDINDX SearchDamaged IndexLI_14Long Integer414
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'].ACTINDX
19ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
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'].TAXSCHID
20IVITMTXB SearchIV Item TaxableDDL_Tax_OptionsInteger20
21NONINVEN SearchNon IVINT1Integer21
22QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency1017
23QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency1017
24QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency1017
25QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency1017
26QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency1017
27QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency1017
28EXTQTYSEL SearchExisting Qty SelectedDLR17_QTY_RBS0_STRCurrency1017
29UOFM SearchU Of MU_Of_MString108
30QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency1017
31UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
32EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
33DISCSALE SearchDiscount Available SalesDLR17_RBS0_UTR$Currency1017
34TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
35ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency1017
36LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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'].LOCNCODE
37MRKDNTYP SearchMarkdown TypeGBInteger20
38MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency1017
39MRKDNPCT SearchMarkdown PercentINT5_%2Integer25
40PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
41XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency1017
42UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency1017
43TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
44BKTSLSAM SearchBackout Sales AmountDLR19_RBS0_UTR$Currency1019
45TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency1019
46BSIVCTTL SearchBased On Invoice TotalYNBoolean20
47SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
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'].SLPRSNID
48SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
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'].SALSTERR
49DSCRIPTN SearchDescriptionSTR30String3230
50ITEMDESC SearchItem DescriptionSTR100String102100
51EXPTSHIP SearchExpected Ship DateDTDate48
52ACTLSHIP SearchActual Ship DateDTDate48
53ReqShipDate SearchRequested Ship DateDTDate48
54COMDLRAM SearchCommission Dollar AmountDLR17_RBSO_STR$Currency1017
55CMPSERNM SearchComponent Serial NumberedYNBoolean20
56COMMNTID SearchComment IDSTR15_Comment_IDString1615
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'].COMMNTID
57BRKFLD1 SearchBreak Field 1INT1Integer21
58BRKFLD2 SearchBreak Field 2INT1Integer21
59BRKFLD3 SearchBreak Field 3INT1Integer21
60TRXSORCE SearchTRX SourceSTR13String1413
61IVCLINEERR SearchIVC LINE ErrorsML_IVC_LINE_ErrorsLong Integer40
62ASI_Customer_Number SearchASI_Customer_NumberSTR15_RM_Customer_NumberString1615
azurecurveProductsSmartList (1493)PathnameSmartList Invoicing Transaction Amounts Work (ASIEXP26)

Leave a Reply

Your email address will not be published. Required fields are marked *