Invoicing Transaction History (IVC30101)

azurecurveProductsMicrosoft Dynamics GP (0)SalesInvoicing Transaction History (IVC30101)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Invoicing Transaction History
Physical Name: IVC30101
Technical Name: IVC_HDR_HIST

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
2INVCNMBR SearchInvoice NumberStringSTR20_IVC_Document_Number17
3BACHNUMB SearchBatch NumberStringSTR15_LBAU15
4BCHSOURC SearchBatch SourceStringSTR1515
5PCKSLPNO SearchPacking Slip NumberStringSTR20_IVC_Document_Number17
6CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].CUSTNMBR AS 'Invoicing Transaction History-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Invoicing Transaction History'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
7CUSTNAME SearchCustomer NameStringSTR64_Customer_Name64
8CSTPONBR SearchCustomer PO NumberStringSTR20_Document_Number20
9POSTDATE SearchPost DateDateDT_Date6
10GLPOSTDT SearchGL Posting DateDateDT8
11DOCDATE SearchDocument DateDateDT8
12QUOTEDAT SearchQuote DateDateDT8
13ORDRDATE SearchOrder DateDateDT8
14DISCDATE SearchDiscount DateDateDT8
15DUEDATE SearchDue DateDateDT8
16HOLDNT SearchHold NTBooleanCB0
17SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].SHIPMTHD AS 'Invoicing Transaction History-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Invoicing Transaction History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
18TAXEXMT1 SearchTax Exempt 1StringSTR2525
19TAXEXMT2 SearchTax Exempt 2StringSTR2525
20TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].TAXSCHID AS 'Invoicing Transaction History-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Transaction History'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
21FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].FRTSCHID AS 'Invoicing Transaction History-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Transaction History'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
22FRGTTXBL SearchFreight TaxableIntegerDDL_Tax_Options0
23FRTTXAMT SearchFreight Tax AmountCurrencyDLR19_RBSO_UTR$19
24MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].MSCSCHID AS 'Invoicing Transaction History-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Transaction History'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
25MISCTXBL SearchMisc TaxableIntegerDDL_Tax_Options0
26MSCTXAMT SearchMisc Tax AmountCurrencyDLR19_RBSO_UTR$19
27MRKDNAMT SearchMarkdown AmountCurrencyDLR17_RBS0_UTR$17
28SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

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

Click to show/hide

SELECT
       ['Invoicing Transaction History'].SALSTERR AS 'Invoicing Transaction History-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Invoicing Transaction History'].SALSTERR = ['Sales Territory Master File'].SALSTERR
30TXRGNNUM SearchTax Registration NumberStringSTR2525
31PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].PYMTRMID AS 'Invoicing Transaction History-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['Invoicing Transaction History'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
32PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
33LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].LOCNCODE AS 'Invoicing Transaction History-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Invoicing Transaction History'].LOCNCODE = ['Site Setup'].LOCNCODE
34CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].CURNCYID AS 'Invoicing Transaction History-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Invoicing Transaction History'].CURNCYID = ['Currency Setup'].CURNCYID
35COMMNTID SearchComment IDStringSTR15_Comment_ID15
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].COMMNTID AS 'Invoicing Transaction History-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Invoicing Transaction History'].COMMNTID = ['Comment Master'].COMMNTID
36DOCAMNT SearchDocument AmountCurrencyDLR19_RBSO_UTR$19
37SUBTOTAL SearchSubtotalCurrencyDLR17_RBS0_STR$17
38FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
39MISCAMNT SearchMisc AmountCurrencyDLR17_RBS0_UTR$17
40TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
41TXBTXAMT SearchTaxable Tax AmountCurrencyDLR19_RBSO_UTR$19
42TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
43ACCTAMNT SearchAccount AmountCurrencyDLR19_RBS0_UTR$19
44PYMTRCVD SearchPayment ReceivedCurrencyDLR19_RBS0_UTR$19
45CODAMNT SearchCOD AmountCurrencyDLR17_RBS0_UTR$17
46EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
47DISAVTKN SearchDiscount Available TakenCurrencyDLR17_RBS0_UTR$17
48DISCRTND SearchDiscount ReturnedCurrencyDLR17_RBS0_STR$17
49DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
50DISAVAMT SearchDiscount Available AmountCurrencyDLR17_RBS0_UTR$17
51DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
52DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
53PRBTADCD SearchPrimary Billto Address CodeStringSTR15_LBAU15
54PRSTADCD SearchPrimary Shipto Address CodeStringSTR15_LBAU15
55CNTCPRSN SearchContact PersonStringSTR6060
56ADDRESS1 SearchAddress 1StringSTR6060
57ADDRESS2 SearchAddress 2StringSTR6060
58ADDRESS3 SearchAddress 3StringSTR6060
59CITY SearchCityStringSTR3535
60STATE SearchStateStringSTR30_State29
61ZIPCODE SearchZip CodeStringSTR1010
62CCode SearchCountry CodeStringSTR6_VAT6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].CCode AS 'Invoicing Transaction History-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Invoicing Transaction History'].CCode = ['VAT Country Code MSTR'].CCode
63COUNTRY SearchCountryStringSTR6060
64PHNUMBR1 SearchPhone Number 1StringPhone_Number14
65PHNUMBR2 SearchPhone Number 2StringPhone_Number14
66PHONE3 SearchPhone 3StringPhone_Number314
67FAXNUMBR SearchFax NumberStringSTR14_FAX14
68COMAPPTO SearchCommission Applied ToIntegerGB0
69COMDLRAM SearchCommission Dollar AmountCurrencyDLR17_RBSO_STR$17
70NCOMAMNT SearchNon-Commissioned AmountCurrencyDLR19_RBS0_STR$19
71UPSZONE SearchUPS ZoneStringSTR33
72LSTUSRED SearchLast User to EditStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].LSTUSRED AS 'Invoicing Transaction History-Last User to Edit'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Invoicing Transaction History'].LSTUSRED = ['Users Master'].USERID
73LSTEDTDT SearchLast Edit DateDateDT_Date6
74MODIFDT SearchModified DateDateDT8
75CREATDDT SearchCreated DateDateDT8
76USER2ENT SearchUser To EnterStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].USER2ENT AS 'Invoicing Transaction History-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Invoicing Transaction History'].USER2ENT = ['Users Master'].USERID
77NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Invoicing Transaction History'].NOTEINDX AS 'Invoicing Transaction History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       IVC30101 AS ['Invoicing Transaction History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Invoicing Transaction History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
78TIMESPRT SearchTimes PrintedIntegerINT4_U04
79NOCARTNS SearchNumber Of CartonsIntegerINT4_U04
80USERDEF1 SearchUser Defined 1StringSTR2020
81USERDEF2 SearchUser Defined 2StringSTR2020
82VOIDSTTS SearchVoid StatusIntegerINT0
83TRXSORCE SearchTRX SourceStringSTR1313
84LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
85COMMENT SearchCommentSTR50String50
86COMMENT_1 SearchComment[1]StringSTR5050
87COMMENT_2 SearchComment[2]StringSTR5050
88COMMENT_3 SearchComment[3]StringSTR5050
89COMMENT_4 SearchComment[4]StringSTR5050
90ECTRX SearchEC TransactionBooleanCB_EC_Transaction0
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.

Click to show/hide Document Printed flag


0	Not an EU Transaction.
1	EU Transaction.
91ShipToName SearchShipToNameStringSTR64_Customer_Name64
92Tax_Date SearchTax DateDateDT8
93APLYWITH SearchApply WithholdingBooleanBoolean0
94WITHHAMT SearchWithholding AmountCurrencyDLR19_RBSO_UTR$19
95CMMTTEXT SearchComment TextTextTX500500
azurecurveProductsMicrosoft Dynamics GP (0)SalesInvoicing Transaction History (IVC30101)

Leave a Reply

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