Invoicing Transaction Amounts History (IVC30102)

azurecurveProductsMicrosoft Dynamics GP (0)SalesInvoicing Transaction Amounts History (IVC30102)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Invoicing Transaction Amounts History
Physical Name: IVC30102
Technical Name: IVC_LINE_HIST

Group Display Name: Invoice History
Group Technical Name: Invoice History

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
5NONINVEN 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
6ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts History'].ITEMNMBR AS 'Invoicing Transaction Amounts History-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Invoicing Transaction Amounts History'].ITEMNMBR = ['Item Master'].ITEMNMBR
7DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
8DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
9ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts History'].ITMTSHID AS 'Invoicing Transaction Amounts History-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Transaction Amounts History'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
10IVITMTXB SearchIV Item TaxableDDL_Tax_OptionsInteger20
11QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency1017
12QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency1017
13QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency1017
14QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency1017
15QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency1017
16QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency1017
17EXTQTYSEL SearchExisting Qty SelectedDLR17_QTY_RBS0_STRCurrency1017
18UOFM SearchU Of MU_Of_MString108
The unit of measure. The value in this field must exist in Inventory.
19QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency1017
20UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
21EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
22ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency1017
23LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts History'].LOCNCODE AS 'Invoicing Transaction Amounts History-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Invoicing Transaction Amounts History'].LOCNCODE = ['Site Setup'].LOCNCODE
24MRKDNTYP SearchMarkdown TypeGBInteger20
25MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency1017
26MRKDNPCT SearchMarkdown PercentINT5_%2Integer25
27PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
28XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency1017
29UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency1017
30TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
31BKTSLSAM SearchBackout Sales AmountDLR19_RBS0_UTR$Currency1019
32TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency1019
33SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

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

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts History'].SALSTERR AS 'Invoicing Transaction Amounts History-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Invoicing Transaction Amounts History'].SALSTERR = ['Sales Territory Master File'].SALSTERR
35DSCRIPTN SearchDescriptionSTR30String3230
36ITEMDESC SearchItem DescriptionSTR100String102100
37EXPTSHIP SearchExpected Ship DateDTDate48
38ACTLSHIP SearchActual Ship DateDTDate48
39ReqShipDate SearchRequested Ship DateDTDate48
40COMDLRAM SearchCommission Dollar AmountDLR17_RBSO_STR$Currency1017
41CMPSERNM SearchComponent Serial NumberedYNBoolean20
42COMMNTID SearchComment IDSTR15_Comment_IDString1615
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts History'].COMMNTID AS 'Invoicing Transaction Amounts History-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Invoicing Transaction Amounts History'].COMMNTID = ['Comment Master'].COMMNTID
43BRKFLD1 SearchBreak Field 1INT1Integer21
44BRKFLD2 SearchBreak Field 2INT1Integer21
45BRKFLD3 SearchBreak Field 3INT1Integer21
46TRXSORCE SearchTRX SourceSTR13String1413
47PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
48SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Invoicing Transaction Amounts History'].SHIPMTHD AS 'Invoicing Transaction Amounts History-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Invoicing Transaction Amounts History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
49ISLINEINTRA SearchIsLineIntrastatCBBoolean20
50DEX_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 History (IVC30102)

Leave a Reply

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