Invoicing Setup (IVC40100)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Invoicing Setup
Physical Name: IVC40100
Technical Name: IVC_SETP

Group Display Name: Invoice Setup
Group Technical Name: Invoice Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SETUPKEY SearchSetup KeyINTInteger20
2DPYITMCS SearchDisplay Item Unit CostCB_Display_Item_Unit_CostBoolean20
3ACDSTRBN SearchAccount DistributionsCB_Account_DistributionsBoolean20
4TRKVDTRX SearchTrack Voided Trx In HistoryCB_Track_Voided_Trx_In_HistoryBoolean20
5TRXDTL SearchTransaction DetailCB_Transaction_DetailBoolean20
6LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Invoicing Setup'].LOCNCODE AS 'Invoicing Setup-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Invoicing Setup'].LOCNCODE = ['Site Setup'].LOCNCODE
7CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Invoicing Setup'].CHEKBKID AS 'Invoicing Setup-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Invoicing Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
8INVCFRMT SearchInvoice FormatDDL_Invoice_FormatsInteger20
9RETNFRMT SearchReturn FormatDDL_Invoice_FormatsInteger20
10PKSLPFMT SearchPacking Slip FormatDDL_Invoice_FormatsInteger20
11DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
12DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
13USEADVTX SearchUse Advanced TaxesGBInteger20
14NONIVSCH SearchNon IV Item Schedule IDSTR15_Tax_Schedule_IDString1615
15FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Invoicing Setup'].FRTSCHID AS 'Invoicing Setup-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Setup'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
16MSCSCHID SearchMisc Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Invoicing Setup'].MSCSCHID AS 'Invoicing Setup-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Setup'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
17TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Invoicing Setup'].TAXSCHID AS 'Invoicing Setup-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Setup'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
18NONIVTXB SearchNon IV TaxableDDL_Tax_OptionsInteger20
19FRGTTXBL SearchFreight TaxableDDL_Tax_OptionsInteger20
20MISCTXBL SearchMisc TaxableDDL_Tax_OptionsInteger20
21USRDFPR1 SearchUser Defined Prompt 1STR15String1615
22USRDRPR2 SearchUser Defined Prompt 2STR15String1615
23USEACFRM SearchUse Posting Accounts FromGBInteger20
24RTNUSIVC SearchReturn Use InvoiceCB_Return_Use_InvoiceBoolean20
25PKSLPIVC SearchPacking Slip Use InvoiceCB_Packing_Slip_Use_InvoiceBoolean20
26COMMNTID SearchComment IDSTR15_Comment_IDString1615
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Invoicing Setup'].COMMNTID AS 'Invoicing Setup-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Invoicing Setup'].COMMNTID = ['Comment Master'].COMMNTID
27IVCALLOW SearchIVC AllowCBBoolean20
28IVCALLOW_1 SearchIVC Allow[1]CBBoolean20
29IVCALLOW_2 SearchIVC Allow[2]CBBoolean20
30IVCALLOW_3 SearchIVC Allow[3]CBBoolean20
31IVCALLOW_4 SearchIVC Allow[4]CBBoolean20
32IVCALLOW_5 SearchIVC Allow[5]CBBoolean20
33IVCALLOW_6 SearchIVC Allow[6]CBBoolean20
34IVCALLOW_7 SearchIVC Allow[7]CBBoolean20
35IVCALLOW_8 SearchIVC Allow[8]CBBoolean20
36IVCALLOW_9 SearchIVC Allow[9]CBBoolean20
37IVCALLOW_10 SearchIVC Allow[10]CBBoolean20
38IVCALLOW_11 SearchIVC Allow[11]CBBoolean20
39IVCPSSWD SearchIVC PasswordPasswordString1210
40IVCPSSWD_1 SearchIVC Password[1]PasswordString1210
41IVCPSSWD_2 SearchIVC Password[2]PasswordString1210
42IVCPSSWD_3 SearchIVC Password[3]PasswordString1210
43IVCPSSWD_4 SearchIVC Password[4]PasswordString1210
44IVCPSSWD_5 SearchIVC Password[5]PasswordString1210
45IVCPSSWD_6 SearchIVC Password[6]PasswordString1210
46IVCPSSWD_7 SearchIVC Password[7]PasswordString1210
47IVCPSSWD_8 SearchIVC Password[8]PasswordString1210
48IVCPSSWD_9 SearchIVC Password[9]PasswordString1210
49IVCPSSWD_10 SearchIVC Password[10]PasswordString1210
50IVCPSSWD_11 SearchIVC Password[11]PasswordString1210
51IVCSEQNC SearchIVC SequenceINT4Integer24
52IVCSEQNC_1 SearchIVC Sequence[1]INT4Integer24
53IVCSEQNC_2 SearchIVC Sequence[2]INT4Integer24
54IVCSEQNC_3 SearchIVC Sequence[3]INT4Integer24
55IVCSEQNC_4 SearchIVC Sequence[4]INT4Integer24
56IVCSEQNC_5 SearchIVC Sequence[5]INT4Integer24
57IVCSEQNC_6 SearchIVC Sequence[6]INT4Integer24
58IVCSEQNC_7 SearchIVC Sequence[7]INT4Integer24
59IVCSEQNC_8 SearchIVC Sequence[8]INT4Integer24
60IVCSEQNC_9 SearchIVC Sequence[9]INT4Integer24
61IVCSEQNC_10 SearchIVC Sequence[10]INT4Integer24
62IVCSEQNC_11 SearchIVC Sequence[11]INT4Integer24
63IVCDSTCK SearchIVC Dist CheckML_IVC_Dist_CheckLong Integer40
64NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer46
65DEX_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.

Leave a Reply

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