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 TypeLength
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
2ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
3ASI_Document_Status SearchASI_Document_StatusINTInteger0
4DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
5INVCNMBR SearchInvoice NumberSTR20_IVC_Document_NumberString17
6LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
7CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer10
8ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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_DollarsInteger0
10DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
11INVINDX SearchInventory IndexLI_14Long Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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_LBAUString15
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_OptionsInteger0
21NONINVEN SearchNon IVINT1Integer1
22QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency17
23QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency17
24QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency17
25QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency17
26QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency17
27QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency17
28EXTQTYSEL SearchExisting Qty SelectedDLR17_QTY_RBS0_STRCurrency17
29UOFM SearchU Of MU_Of_MString8
30QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency17
31UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
32EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
33DISCSALE SearchDiscount Available SalesDLR17_RBS0_UTR$Currency17
34TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
35ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency17
36LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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 TypeGBInteger0
38MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency17
39MRKDNPCT SearchMarkdown PercentINT5_%2Integer5
40PRCLEVEL SearchPriceLevelSTR10_LBAUString10
41XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency17
42UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency17
43TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
44BKTSLSAM SearchBackout Sales AmountDLR19_RBS0_UTR$Currency19
45TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency19
46BSIVCTTL SearchBased On Invoice TotalYNBoolean0
47SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
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_TerritoryString15
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 SearchDescriptionSTR30String30
50ITEMDESC SearchItem DescriptionSTR100String100
51EXPTSHIP SearchExpected Ship DateDTDate8
52ACTLSHIP SearchActual Ship DateDTDate8
53ReqShipDate SearchRequested Ship DateDTDate8
54COMDLRAM SearchCommission Dollar AmountDLR17_RBSO_STR$Currency17
55CMPSERNM SearchComponent Serial NumberedYNBoolean0
56COMMNTID SearchComment IDSTR15_Comment_IDString15
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 1INT1Integer1
58BRKFLD2 SearchBreak Field 2INT1Integer1
59BRKFLD3 SearchBreak Field 3INT1Integer1
60TRXSORCE SearchTRX SourceSTR13String13
61IVCLINEERR SearchIVC LINE ErrorsML_IVC_LINE_ErrorsLong Integer0
62ASI_Customer_Number SearchASI_Customer_NumberSTR15_RM_Customer_NumberString15
azurecurveProductsSmartList (1493)PathnameSmartList Invoicing Transaction Amounts Work (ASIEXP26)

Leave a Reply

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