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 TypeLength
1DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
2INVCNMBR SearchInvoice NumberSTR20_IVC_Document_NumberString17
3LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
4CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer10
5NONINVEN SearchNon IVINT1Integer1
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_NumberString30
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_DollarsInteger0
8DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
9ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString15
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_OptionsInteger0
11QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency17
12QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency17
13QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency17
14QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency17
15QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency17
16QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency17
17EXTQTYSEL SearchExisting Qty SelectedDLR17_QTY_RBS0_STRCurrency17
18UOFM SearchU Of MU_Of_MString8
The unit of measure. The value in this field must exist in Inventory.
19QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency17
20UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
21EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
22ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency17
23LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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 TypeGBInteger0
25MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency17
26MRKDNPCT SearchMarkdown PercentINT5_%2Integer5
27PRCLEVEL SearchPriceLevelSTR10_LBAUString10
28XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency17
29UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency17
30TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
31BKTSLSAM SearchBackout Sales AmountDLR19_RBS0_UTR$Currency19
32TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency19
33SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
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_TerritoryString15
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 SearchDescriptionSTR30String30
36ITEMDESC SearchItem DescriptionSTR100String100
37EXPTSHIP SearchExpected Ship DateDTDate8
38ACTLSHIP SearchActual Ship DateDTDate8
39ReqShipDate SearchRequested Ship DateDTDate8
40COMDLRAM SearchCommission Dollar AmountDLR17_RBSO_STR$Currency17
41CMPSERNM SearchComponent Serial NumberedYNBoolean0
42COMMNTID SearchComment IDSTR15_Comment_IDString15
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 1INT1Integer1
44BRKFLD2 SearchBreak Field 2INT1Integer1
45BRKFLD3 SearchBreak Field 3INT1Integer1
46TRXSORCE SearchTRX SourceSTR13String13
47PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
48SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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 SearchIsLineIntrastatCBBoolean0
50DEX_ROW_ID Searchintint10

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 *