Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IVC30102
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Invoicing Transaction Amounts History Group Display Name: Invoice History
Physical Name: IVC30102
Technical Name: IVC_LINE_HIST
Group Technical Name: Invoice History
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | DOCTYPE | Document Type | Integer | DDL_Document_Type | 0 | |
2 | INVCNMBR | Invoice Number | String | STR20_IVC_Document_Number | 17 | |
3 | LNITMSEQ | Line Item Sequence | Long Integer | LI_Sequence_Number | 10 | |
4 | CMPNTSEQ | Component Sequence | Long Integer | LI_Sequence_Number | 10 | |
5 | NONINVEN | Non IV | Integer | INT1 | 1 | |
Used to indicate whether an item is an inventory item or non-inventory item.
Click to show/hide PO Line Statuses0 Inventory item
1 Non-inventory item | ||||||
6 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Invoicing Transaction Amounts History'].ITEMNMBR AS 'Invoicing Transaction Amounts History-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Invoicing Transaction Amounts History'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
7 | DECPLCUR | Decimal Places Currency | Integer | DDL_Decimal_Places_Dollars | 0 | |
8 | DECPLQTY | Decimal Places QTYS | Integer | DDL_Decimal_Places_QTYS | 0 | |
9 | ITMTSHID | Item Tax Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['Invoicing Transaction Amounts History'].ITMTSHID AS 'Invoicing Transaction Amounts History-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Invoicing Transaction Amounts History'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
10 | IVITMTXB | IV Item Taxable | Integer | DDL_Tax_Options | 0 | |
11 | QUANTITY | QTY | Currency | DLR17_QTY_RBS0_STR | 17 | |
12 | QTYINSVC | QTY In Service | Currency | DLR17_QTY_RBS0_UTR | 17 | |
13 | QTYINUSE | QTY In Use | Currency | DLR17_QTY_RBS0_UTR | 17 | |
14 | QTYDMGED | QTY Damaged | Currency | DLR17_QTY_RBS0_UTR | 17 | |
15 | QTYRTRND | QTY Returned | Currency | DLR17_QTY_RBS0_UTR | 17 | |
16 | QTYONHND | QTY On Hand | Currency | DLR17_QTY_RBS0_STR | 17 | |
17 | EXTQTYSEL | Existing Qty Selected | Currency | DLR17_QTY_RBS0_STR | 17 | |
18 | UOFM | U Of M | String | U_Of_M | 8 | |
The unit of measure. The value in this field must exist in Inventory. | ||||||
19 | QTYBSUOM | QTY In Base U Of M | Currency | DLR17_QTY_RBS0_STR | 17 | |
20 | UNITCOST | Unit Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
21 | EXTDCOST | Extended Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
22 | ATYALLOC | QTY Allocated | Currency | DLR17_QTY_RBS0_UTR | 17 | |
23 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Invoicing Transaction Amounts History'].LOCNCODE AS 'Invoicing Transaction Amounts History-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Invoicing Transaction Amounts History'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
24 | MRKDNTYP | Markdown Type | Integer | GB | 0 | |
25 | MRKDNAMT | Markdown Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
26 | MRKDNPCT | Markdown Percent | Integer | INT5_%2 | 5 | |
27 | PRCLEVEL | PriceLevel | String | STR10_LBAU | 10 | |
28 | XTNDPRCE | Extended Price | Currency | DLR17_RBS0_STR$ | 17 | |
29 | UNITPRCE | Unit Price | Currency | DLR17_RBS0_STR$ | 17 | |
30 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
31 | BKTSLSAM | Backout Sales Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
32 | TXBTXAMT | Taxable Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
33 | SLPRSNID | Salesperson ID | String | STR15_Salesperson_ID | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['Invoicing Transaction Amounts History'].SLPRSNID AS 'Invoicing Transaction Amounts History-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['Invoicing Transaction Amounts History'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
34 | SALSTERR | Sales Territory | String | STR15_Sales_Territory | 15 | |
Key to the Sales Territory Master File (RM00303).
Click to show/hideSELECT
['Invoicing Transaction Amounts History'].SALSTERR AS 'Invoicing Transaction Amounts History-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['Invoicing Transaction Amounts History'].SALSTERR = ['Sales Territory Master File'].SALSTERR | ||||||
35 | DSCRIPTN | Description | String | STR30 | 30 | |
36 | ITEMDESC | Item Description | String | STR100 | 100 | |
37 | EXPTSHIP | Expected Ship Date | Date | DT | 8 | |
38 | ACTLSHIP | Actual Ship Date | Date | DT | 8 | |
39 | ReqShipDate | Requested Ship Date | Date | DT | 8 | |
40 | COMDLRAM | Commission Dollar Amount | Currency | DLR17_RBSO_STR$ | 17 | |
41 | CMPSERNM | Component Serial Numbered | Boolean | YN | 0 | |
42 | COMMNTID | Comment ID | String | STR15_Comment_ID | 15 | |
Key to the Comment Master (SY04200).
Click to show/hideSELECT
['Invoicing Transaction Amounts History'].COMMNTID AS 'Invoicing Transaction Amounts History-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['Invoicing Transaction Amounts History'].COMMNTID = ['Comment Master'].COMMNTID | ||||||
43 | BRKFLD1 | Break Field 1 | Integer | INT1 | 1 | |
44 | BRKFLD2 | Break Field 2 | Integer | INT1 | 1 | |
45 | BRKFLD3 | Break Field 3 | Integer | INT1 | 1 | |
46 | TRXSORCE | TRX Source | String | STR13 | 13 | |
47 | PRSTADCD | Primary Shipto Address Code | String | STR15_LBAU | 15 | |
48 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['Invoicing Transaction Amounts History'].SHIPMTHD AS 'Invoicing Transaction Amounts History-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
IVC30102 AS ['Invoicing Transaction Amounts History']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['Invoicing Transaction Amounts History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
49 | ISLINEINTRA | IsLineIntrastat | Boolean | CB | 0 |