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 TypeSQL DB LengthKeyable Length
1DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
2INVCNMBR SearchInvoice NumberSTR20_IVC_Document_NumberString2217
3LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
4CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer410
5ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
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 CurrencyDDL_Decimal_Places_DollarsInteger20
7DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
8INVINDX SearchInventory IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IDSTR15_LBAUString1615
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 TaxableDDL_Tax_OptionsInteger20
18NONINVEN SearchNon IVINT1Integer21
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 SearchQTYDLR17_QTY_RBS0_STRCurrency1017
20QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency1017
21QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency1017
22QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency1017
23QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency1017
24QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency1017
25EXTQTYSEL SearchExisting Qty SelectedDLR17_QTY_RBS0_STRCurrency1017
26UOFM SearchU Of MU_Of_MString108
The unit of measure. The value in this field must exist in Inventory.
27QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency1017
28UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
29EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
30DISCSALE SearchDiscount Available SalesDLR17_RBS0_UTR$Currency1017
31TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
32ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency1017
33LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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 TypeGBInteger20
35MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency1017
36MRKDNPCT SearchMarkdown PercentINT5_%2Integer25
37PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
38XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency1017
39UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency1017
40TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
41BKTSLSAM SearchBackout Sales AmountDLR19_RBS0_UTR$Currency1019
42TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency1019
43BSIVCTTL SearchBased On Invoice TotalYNBoolean20
44SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
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 TerritorySTR15_Sales_TerritoryString1615
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 SearchDescriptionSTR30String3230
47ITEMDESC SearchItem DescriptionSTR100String102100
48EXPTSHIP SearchExpected Ship DateDTDate48
49ACTLSHIP SearchActual Ship DateDTDate48
50ReqShipDate SearchRequested Ship DateDTDate48
51COMDLRAM SearchCommission Dollar AmountDLR17_RBSO_STR$Currency1017
52CMPSERNM SearchComponent Serial NumberedYNBoolean20
53COMMNTID SearchComment IDSTR15_Comment_IDString1615
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 1INT1Integer21
55BRKFLD2 SearchBreak Field 2INT1Integer21
56BRKFLD3 SearchBreak Field 3INT1Integer21
57TRXSORCE SearchTRX SourceSTR13String1413
58IVCLINEERR SearchIVC LINE ErrorsML_IVC_LINE_ErrorsLong Integer40
59BackoutTradeDisc SearchBackout Trade Discount AmountDLR19_RBS0_UTR$Currency1019
60PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
61SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
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 SearchIsLineIntrastatCBBoolean20
63DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

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

Leave a Reply

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