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 Group Display Name: Invoice Setup
Physical Name: IVC40100
Technical Name: IVC_SETP
Group Technical Name: Invoice Setup
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | SETUPKEY | Setup Key | Integer | INT | 0 | |
2 | DPYITMCS | Display Item Unit Cost | Boolean | CB_Display_Item_Unit_Cost | 0 | |
3 | ACDSTRBN | Account Distributions | Boolean | CB_Account_Distributions | 0 | |
4 | TRKVDTRX | Track Voided Trx In History | Boolean | CB_Track_Voided_Trx_In_History | 0 | |
5 | TRXDTL | Transaction Detail | Boolean | CB_Transaction_Detail | 0 | |
6 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['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 | ||||||
7 | CHEKBKID | Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['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 | ||||||
8 | INVCFRMT | Invoice Format | Integer | DDL_Invoice_Formats | 0 | |
9 | RETNFRMT | Return Format | Integer | DDL_Invoice_Formats | 0 | |
10 | PKSLPFMT | Packing Slip Format | Integer | DDL_Invoice_Formats | 0 | |
11 | DECPLQTY | Decimal Places QTYS | Integer | DDL_Decimal_Places_QTYS | 0 | |
12 | DECPLCUR | Decimal Places Currency | Integer | DDL_Decimal_Places_Dollars | 0 | |
13 | USEADVTX | Use Advanced Taxes | Integer | GB | 0 | |
14 | NONIVSCH | Non IV Item Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
15 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
16 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
17 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
18 | NONIVTXB | Non IV Taxable | Integer | DDL_Tax_Options | 0 | |
19 | FRGTTXBL | Freight Taxable | Integer | DDL_Tax_Options | 0 | |
20 | MISCTXBL | Misc Taxable | Integer | DDL_Tax_Options | 0 | |
21 | USRDFPR1 | User Defined Prompt 1 | String | STR15 | 15 | |
22 | USRDRPR2 | User Defined Prompt 2 | String | STR15 | 15 | |
23 | USEACFRM | Use Posting Accounts From | Integer | GB | 0 | |
24 | RTNUSIVC | Return Use Invoice | Boolean | CB_Return_Use_Invoice | 0 | |
25 | PKSLPIVC | Packing Slip Use Invoice | Boolean | CB_Packing_Slip_Use_Invoice | 0 | |
26 | COMMNTID | Comment ID | String | STR15_Comment_ID | 15 | |
Key to the Comment Master (SY04200).
Click to show/hideSELECT
['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 | ||||||
27 | IVCALLOW | IVC Allow | CB | Boolean | 0 | |
28 | IVCALLOW_1 | IVC Allow[1] | Boolean | CB | 0 | |
29 | IVCALLOW_2 | IVC Allow[2] | Boolean | CB | 0 | |
30 | IVCALLOW_3 | IVC Allow[3] | Boolean | CB | 0 | |
31 | IVCALLOW_4 | IVC Allow[4] | Boolean | CB | 0 | |
32 | IVCALLOW_5 | IVC Allow[5] | Boolean | CB | 0 | |
33 | IVCALLOW_6 | IVC Allow[6] | Boolean | CB | 0 | |
34 | IVCALLOW_7 | IVC Allow[7] | Boolean | CB | 0 | |
35 | IVCALLOW_8 | IVC Allow[8] | Boolean | CB | 0 | |
36 | IVCALLOW_9 | IVC Allow[9] | Boolean | CB | 0 | |
37 | IVCALLOW_10 | IVC Allow[10] | Boolean | CB | 0 | |
38 | IVCALLOW_11 | IVC Allow[11] | Boolean | CB | 0 | |
39 | IVCPSSWD_1 | IVC Password[1] | String | Password | 10 | |
40 | IVCPSSWD_2 | IVC Password[2] | String | Password | 10 | |
41 | IVCPSSWD | IVC Password | Password | String | 10 | |
42 | IVCPSSWD_3 | IVC Password[3] | String | Password | 10 | |
43 | IVCPSSWD_4 | IVC Password[4] | String | Password | 10 | |
44 | IVCPSSWD_5 | IVC Password[5] | String | Password | 10 | |
45 | IVCPSSWD_6 | IVC Password[6] | String | Password | 10 | |
46 | IVCPSSWD_7 | IVC Password[7] | String | Password | 10 | |
47 | IVCPSSWD_8 | IVC Password[8] | String | Password | 10 | |
48 | IVCPSSWD_9 | IVC Password[9] | String | Password | 10 | |
49 | IVCPSSWD_10 | IVC Password[10] | String | Password | 10 | |
50 | IVCPSSWD_11 | IVC Password[11] | String | Password | 10 | |
51 | IVCSEQNC_1 | IVC Sequence[1] | Integer | INT4 | 4 | |
52 | IVCSEQNC_2 | IVC Sequence[2] | Integer | INT4 | 4 | |
53 | IVCSEQNC_3 | IVC Sequence[3] | Integer | INT4 | 4 | |
54 | IVCSEQNC | IVC Sequence | INT4 | Integer | 4 | |
55 | IVCSEQNC_4 | IVC Sequence[4] | Integer | INT4 | 4 | |
56 | IVCSEQNC_5 | IVC Sequence[5] | Integer | INT4 | 4 | |
57 | IVCSEQNC_6 | IVC Sequence[6] | Integer | INT4 | 4 | |
58 | IVCSEQNC_7 | IVC Sequence[7] | Integer | INT4 | 4 | |
59 | IVCSEQNC_8 | IVC Sequence[8] | Integer | INT4 | 4 | |
60 | IVCSEQNC_9 | IVC Sequence[9] | Integer | INT4 | 4 | |
61 | IVCSEQNC_10 | IVC Sequence[10] | Integer | INT4 | 4 | |
62 | IVCSEQNC_11 | IVC Sequence[11] | Integer | INT4 | 4 | |
63 | IVCDSTCK | IVC Dist Check | Long Integer | ML_IVC_Dist_Check | 0 | |
64 | NUMOFTRX | Number Of TRX | Long Integer | LI6_U0 | 6 |