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 TypeLength
1SETUPKEY SearchSetup KeyINTInteger0
2DPYITMCS SearchDisplay Item Unit CostCB_Display_Item_Unit_CostBoolean0
3ACDSTRBN SearchAccount DistributionsCB_Account_DistributionsBoolean0
4TRKVDTRX SearchTrack Voided Trx In HistoryCB_Track_Voided_Trx_In_HistoryBoolean0
5TRXDTL SearchTransaction DetailCB_Transaction_DetailBoolean0
6LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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_IDString15
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_FormatsInteger0
9RETNFRMT SearchReturn FormatDDL_Invoice_FormatsInteger0
10PKSLPFMT SearchPacking Slip FormatDDL_Invoice_FormatsInteger0
11DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
12DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
13USEADVTX SearchUse Advanced TaxesGBInteger0
14NONIVSCH SearchNon IV Item Schedule IDSTR15_Tax_Schedule_IDString15
15FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
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_LBAUString15
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_IDString15
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_OptionsInteger0
19FRGTTXBL SearchFreight TaxableDDL_Tax_OptionsInteger0
20MISCTXBL SearchMisc TaxableDDL_Tax_OptionsInteger0
21USRDFPR1 SearchUser Defined Prompt 1STR15String15
22USRDRPR2 SearchUser Defined Prompt 2STR15String15
23USEACFRM SearchUse Posting Accounts FromGBInteger0
24RTNUSIVC SearchReturn Use InvoiceCB_Return_Use_InvoiceBoolean0
25PKSLPIVC SearchPacking Slip Use InvoiceCB_Packing_Slip_Use_InvoiceBoolean0
26COMMNTID SearchComment IDSTR15_Comment_IDString15
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 AllowCBBoolean0
28IVCALLOW_1 SearchIVC Allow[1]CBBoolean0
29IVCALLOW_2 SearchIVC Allow[2]CBBoolean0
30IVCALLOW_3 SearchIVC Allow[3]CBBoolean0
31IVCALLOW_4 SearchIVC Allow[4]CBBoolean0
32IVCALLOW_5 SearchIVC Allow[5]CBBoolean0
33IVCALLOW_6 SearchIVC Allow[6]CBBoolean0
34IVCALLOW_7 SearchIVC Allow[7]CBBoolean0
35IVCALLOW_8 SearchIVC Allow[8]CBBoolean0
36IVCALLOW_9 SearchIVC Allow[9]CBBoolean0
37IVCALLOW_10 SearchIVC Allow[10]CBBoolean0
38IVCALLOW_11 SearchIVC Allow[11]CBBoolean0
39IVCPSSWD SearchIVC PasswordPasswordString10
40IVCPSSWD_1 SearchIVC Password[1]PasswordString10
41IVCPSSWD_2 SearchIVC Password[2]PasswordString10
42IVCPSSWD_3 SearchIVC Password[3]PasswordString10
43IVCPSSWD_4 SearchIVC Password[4]PasswordString10
44IVCPSSWD_5 SearchIVC Password[5]PasswordString10
45IVCPSSWD_6 SearchIVC Password[6]PasswordString10
46IVCPSSWD_7 SearchIVC Password[7]PasswordString10
47IVCPSSWD_8 SearchIVC Password[8]PasswordString10
48IVCPSSWD_9 SearchIVC Password[9]PasswordString10
49IVCPSSWD_10 SearchIVC Password[10]PasswordString10
50IVCPSSWD_11 SearchIVC Password[11]PasswordString10
51IVCSEQNC SearchIVC SequenceINT4Integer4
52IVCSEQNC_1 SearchIVC Sequence[1]INT4Integer4
53IVCSEQNC_2 SearchIVC Sequence[2]INT4Integer4
54IVCSEQNC_3 SearchIVC Sequence[3]INT4Integer4
55IVCSEQNC_4 SearchIVC Sequence[4]INT4Integer4
56IVCSEQNC_5 SearchIVC Sequence[5]INT4Integer4
57IVCSEQNC_6 SearchIVC Sequence[6]INT4Integer4
58IVCSEQNC_7 SearchIVC Sequence[7]INT4Integer4
59IVCSEQNC_8 SearchIVC Sequence[8]INT4Integer4
60IVCSEQNC_9 SearchIVC Sequence[9]INT4Integer4
61IVCSEQNC_10 SearchIVC Sequence[10]INT4Integer4
62IVCSEQNC_11 SearchIVC Sequence[11]INT4Integer4
63IVCDSTCK SearchIVC Dist CheckML_IVC_Dist_CheckLong Integer0
64NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer6
65DEX_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.

Leave a Reply

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