Invoicing Transaction Work (IVC10100)

azurecurveProductsMicrosoft Dynamics GP (0)SalesInvoicing Transaction Work (IVC10100)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Invoicing Transaction Work
Physical Name: IVC10100
Technical Name: IVC_HDR_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
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 Work'].CUSTNMBR AS 'Invoicing Transaction Work-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       IVC10100 AS ['Invoicing Transaction Work']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Invoicing Transaction Work'].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 Work'].SHIPMTHD AS 'Invoicing Transaction Work-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       IVC10100 AS ['Invoicing Transaction Work']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Invoicing Transaction Work'].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 Work'].TAXSCHID AS 'Invoicing Transaction Work-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC10100 AS ['Invoicing Transaction Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Transaction Work'].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 Work'].FRTSCHID AS 'Invoicing Transaction Work-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC10100 AS ['Invoicing Transaction Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Transaction Work'].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 Work'].MSCSCHID AS 'Invoicing Transaction Work-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC10100 AS ['Invoicing Transaction Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Transaction Work'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
25MISCTXBL SearchMisc TaxableIntegerDDL_Tax_Options0
26MSCTXAMT SearchMisc Tax AmountCurrencyDLR19_RBSO_UTR$19
27SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['Invoicing Transaction Work'].CCode AS 'Invoicing Transaction Work-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       IVC10100 AS ['Invoicing Transaction Work']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Invoicing Transaction Work'].CCode = ['VAT Country Code MSTR'].CCode
70COUNTRY SearchCountryStringSTR6060
71PHNUMBR1 SearchPhone Number 1StringPhone_Number14
72PHNUMBR2 SearchPhone Number 2StringPhone_Number14
73PHONE3 SearchPhone 3StringPhone_Number314
74FAXNUMBR SearchFax NumberStringSTR14_FAX14
75COMAPPTO SearchCommission Applied ToIntegerGB0
76COMDLRAM SearchCommission Dollar AmountCurrencyDLR17_RBSO_STR$17
77NCOMAMNT SearchNon-Commissioned AmountCurrencyDLR19_RBS0_STR$19
78UPSZONE SearchUPS ZoneStringSTR33
79LSTUSRED SearchLast User to EditStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Invoicing Transaction Work'].LSTUSRED AS 'Invoicing Transaction Work-Last User to Edit'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       IVC10100 AS ['Invoicing Transaction Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Invoicing Transaction Work'].LSTUSRED = ['Users Master'].USERID
80LSTEDTDT SearchLast Edit DateDateDT_Date6
81MODIFDT SearchModified DateDateDT8
82CREATDDT SearchCreated DateDateDT8
83USER2ENT SearchUser To EnterStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

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

Click to show/hide

SELECT
       ['Invoicing Transaction Work'].NOTEINDX AS 'Invoicing Transaction Work-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       IVC10100 AS ['Invoicing Transaction Work']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Invoicing Transaction Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX
85TIMESPRT SearchTimes PrintedIntegerINT4_U04
86NOCARTNS SearchNumber Of CartonsIntegerINT4_U04
87USERDEF1 SearchUser Defined 1StringSTR2020
88USERDEF2 SearchUser Defined 2StringSTR2020
89VOIDSTTS SearchVoid StatusIntegerINT0
90TRXSORCE SearchTRX SourceStringSTR1313
91PSTGSTUS SearchPosting StatusIntegerINT0
92IVCHDER1 SearchIVC HDR Errors 1Long IntegerML_IVC_HDR_Errors_10
93IVCHDER2 SearchIVC HDR Errors 2Long IntegerML_IVC_HDR_Errors_20
94IVCLINEERR SearchIVC LINE ErrorsLong IntegerML_IVC_LINE_Errors0
95LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
96COMMENT SearchCommentSTR50String50
97COMMENT_1 SearchComment[1]StringSTR5050
98COMMENT_2 SearchComment[2]StringSTR5050
99COMMENT_3 SearchComment[3]StringSTR5050
100COMMENT_4 SearchComment[4]StringSTR5050
101ECTRX 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.
102ShipToName SearchShipToNameStringSTR64_Customer_Name64
103Tax_Date SearchTax DateDateDT8
104APLYWITH SearchApply WithholdingBooleanBoolean0
105WITHHAMT SearchWithholding AmountCurrencyDLR19_RBSO_UTR$19
106BackoutTradeDisc SearchBackout Trade Discount AmountCurrencyDLR19_RBS0_UTR$19
107CMMTTEXT SearchComment TextTextTX500500
azurecurveProductsMicrosoft Dynamics GP (0)SalesInvoicing Transaction Work (IVC10100)

Leave a Reply

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