Invoicing Transaction Amounts Work (IVC10101)

azurecurveProductsMicrosoft Dynamics GP (0)SalesInvoicing Transaction Amounts Work (IVC10101)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IVC10101

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Invoicing Transaction Amounts Work
Physical Name: IVC10101
Technical Name: IVC_LINE_WORK

Group Display Name: Invoice Work
Group Technical Name: Invoice Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
2INVCNMBR SearchInvoice NumberStringSTR20_IVC_Document_Number17
3LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
4CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
5ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].ITEMNMBR AS 'Invoicing Transaction Amounts Work-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Invoicing Transaction Amounts Work'].ITEMNMBR = ['Item Master'].ITEMNMBR
6DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
7DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
8INVINDX SearchInventory IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].INVINDX AS 'Invoicing Transaction Amounts Work-Inventory Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Invoicing Transaction Amounts Work'].INVINDX = ['Account Index Master'].ACTINDX
9CSLSINDX SearchCost Of Sales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].CSLSINDX AS 'Invoicing Transaction Amounts Work-Cost Of Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Invoicing Transaction Amounts Work'].CSLSINDX = ['Account Index Master'].ACTINDX
10SLSINDX SearchSales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].SLSINDX AS 'Invoicing Transaction Amounts Work-Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Invoicing Transaction Amounts Work'].SLSINDX = ['Account Index Master'].ACTINDX
11MKDNINDX SearchMarkdown IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].MKDNINDX AS 'Invoicing Transaction Amounts Work-Markdown Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Invoicing Transaction Amounts Work'].MKDNINDX = ['Account Index Master'].ACTINDX
12RTNSINDX SearchReturns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].RTNSINDX AS 'Invoicing Transaction Amounts Work-Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Invoicing Transaction Amounts Work'].RTNSINDX = ['Account Index Master'].ACTINDX
13INUSINDX SearchIn Use IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].INUSINDX AS 'Invoicing Transaction Amounts Work-In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Invoicing Transaction Amounts Work'].INUSINDX = ['Account Index Master'].ACTINDX
14INSRINDX SearchIn Service IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].INSRINDX AS 'Invoicing Transaction Amounts Work-In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Invoicing Transaction Amounts Work'].INSRINDX = ['Account Index Master'].ACTINDX
15DMGDINDX SearchDamaged IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].DMGDINDX AS 'Invoicing Transaction Amounts Work-Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Invoicing Transaction Amounts Work'].DMGDINDX = ['Account Index Master'].ACTINDX
16ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].ITMTSHID AS '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
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Transaction Amounts Work'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
17IVITMTXB SearchIV Item TaxableIntegerDDL_Tax_Options0
18NONINVEN SearchNon IVIntegerINT11
Used to indicate whether an item is an inventory item or non-inventory item.

Click to show/hide PO Line Statuses

0	Inventory item
1	Non-inventory item
19QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
20QTYINSVC SearchQTY In ServiceCurrencyDLR17_QTY_RBS0_UTR17
21QTYINUSE SearchQTY In UseCurrencyDLR17_QTY_RBS0_UTR17
22QTYDMGED SearchQTY DamagedCurrencyDLR17_QTY_RBS0_UTR17
23QTYRTRND SearchQTY ReturnedCurrencyDLR17_QTY_RBS0_UTR17
24QTYONHND SearchQTY On HandCurrencyDLR17_QTY_RBS0_STR17
25EXTQTYSEL SearchExisting Qty SelectedCurrencyDLR17_QTY_RBS0_STR17
26UOFM SearchU Of MStringU_Of_M8
The unit of measure. The value in this field must exist in Inventory.
27QTYBSUOM SearchQTY In Base U Of MCurrencyDLR17_QTY_RBS0_STR17
28UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
29EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
30DISCSALE SearchDiscount Available SalesCurrencyDLR17_RBS0_UTR$17
31TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
32ATYALLOC SearchQTY AllocatedCurrencyDLR17_QTY_RBS0_UTR17
33LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].LOCNCODE AS 'Invoicing Transaction Amounts Work-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Invoicing Transaction Amounts Work'].LOCNCODE = ['Site Setup'].LOCNCODE
34MRKDNTYP SearchMarkdown TypeIntegerGB0
35MRKDNAMT SearchMarkdown AmountCurrencyDLR17_RBS0_UTR$17
36MRKDNPCT SearchMarkdown PercentIntegerINT5_%25
37PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
38XTNDPRCE SearchExtended PriceCurrencyDLR17_RBS0_STR$17
39UNITPRCE SearchUnit PriceCurrencyDLR17_RBS0_STR$17
40TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
41BKTSLSAM SearchBackout Sales AmountCurrencyDLR19_RBS0_UTR$19
42TXBTXAMT SearchTaxable Tax AmountCurrencyDLR19_RBSO_UTR$19
43BSIVCTTL SearchBased On Invoice TotalBooleanYN0
44SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].SLPRSNID AS 'Invoicing Transaction Amounts Work-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Invoicing Transaction Amounts Work'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
45SALSTERR SearchSales TerritoryStringSTR15_Sales_Territory15
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].SALSTERR AS 'Invoicing Transaction Amounts Work-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Invoicing Transaction Amounts Work'].SALSTERR = ['Sales Territory Master File'].SALSTERR
46DSCRIPTN SearchDescriptionStringSTR3030
47ITEMDESC SearchItem DescriptionStringSTR100100
48EXPTSHIP SearchExpected Ship DateDateDT8
49ACTLSHIP SearchActual Ship DateDateDT8
50ReqShipDate SearchRequested Ship DateDateDT8
51COMDLRAM SearchCommission Dollar AmountCurrencyDLR17_RBSO_STR$17
52CMPSERNM SearchComponent Serial NumberedBooleanYN0
53COMMNTID SearchComment IDStringSTR15_Comment_ID15
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].COMMNTID AS 'Invoicing Transaction Amounts Work-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Invoicing Transaction Amounts Work'].COMMNTID = ['Comment Master'].COMMNTID
54BRKFLD1 SearchBreak Field 1IntegerINT11
55BRKFLD2 SearchBreak Field 2IntegerINT11
56BRKFLD3 SearchBreak Field 3IntegerINT11
57TRXSORCE SearchTRX SourceStringSTR1313
58IVCLINEERR SearchIVC LINE ErrorsLong IntegerML_IVC_LINE_Errors0
59BackoutTradeDisc SearchBackout Trade Discount AmountCurrencyDLR19_RBS0_UTR$19
60PRSTADCD SearchPrimary Shipto Address CodeStringSTR15_LBAU15
61SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts Work'].SHIPMTHD AS 'Invoicing Transaction Amounts Work-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Invoicing Transaction Amounts Work'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
62ISLINEINTRA SearchIsLineIntrastatBooleanCB0
azurecurveProductsMicrosoft Dynamics GP (0)SalesInvoicing Transaction Amounts Work (IVC10101)

Leave a Reply

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