Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IVC10101
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Invoicing Transaction Amounts Work Group Display Name: Invoice Work
Physical Name: IVC10101
Technical Name: IVC_LINE_WORK
Group Technical Name: Invoice Work
| 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 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].ITEMNMBR AS 'Invoicing Transaction Amounts Work-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Invoicing Transaction Amounts Work'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 6 | DECPLCUR | Decimal Places Currency | Integer | DDL_Decimal_Places_Dollars | 0 | |
| 7 | DECPLQTY | Decimal Places QTYS | Integer | DDL_Decimal_Places_QTYS | 0 | |
| 8 | INVINDX | Inventory Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].INVINDX AS 'Invoicing Transaction Amounts Work-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Invoicing Transaction Amounts Work'].INVINDX = ['Account Index Master'].ACTINDX | ||||||
| 9 | CSLSINDX | Cost Of Sales Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].CSLSINDX AS 'Invoicing Transaction Amounts Work-Cost Of Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Invoicing Transaction Amounts Work'].CSLSINDX = ['Account Index Master'].ACTINDX | ||||||
| 10 | SLSINDX | Sales Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].SLSINDX AS 'Invoicing Transaction Amounts Work-Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Invoicing Transaction Amounts Work'].SLSINDX = ['Account Index Master'].ACTINDX | ||||||
| 11 | MKDNINDX | Markdown Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].MKDNINDX AS 'Invoicing Transaction Amounts Work-Markdown Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Invoicing Transaction Amounts Work'].MKDNINDX = ['Account Index Master'].ACTINDX | ||||||
| 12 | RTNSINDX | Returns Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].RTNSINDX AS 'Invoicing Transaction Amounts Work-Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Invoicing Transaction Amounts Work'].RTNSINDX = ['Account Index Master'].ACTINDX | ||||||
| 13 | INUSINDX | In Use Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].INUSINDX AS 'Invoicing Transaction Amounts Work-In Use Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Invoicing Transaction Amounts Work'].INUSINDX = ['Account Index Master'].ACTINDX | ||||||
| 14 | INSRINDX | In Service Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].INSRINDX AS 'Invoicing Transaction Amounts Work-In Service Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Invoicing Transaction Amounts Work'].INSRINDX = ['Account Index Master'].ACTINDX | ||||||
| 15 | DMGDINDX | Damaged Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].DMGDINDX AS 'Invoicing Transaction Amounts Work-Damaged Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Invoicing Transaction Amounts Work'].DMGDINDX = ['Account Index Master'].ACTINDX | ||||||
| 16 | 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 Work'].ITMTSHID AS 'Invoicing Transaction Amounts Work-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Invoicing Transaction Amounts Work'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 17 | IVITMTXB | IV Item Taxable | Integer | DDL_Tax_Options | 0 | |
| 18 | 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 | ||||||
| 19 | QUANTITY | QTY | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 20 | QTYINSVC | QTY In Service | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 21 | QTYINUSE | QTY In Use | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 22 | QTYDMGED | QTY Damaged | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 23 | QTYRTRND | QTY Returned | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 24 | QTYONHND | QTY On Hand | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 25 | EXTQTYSEL | Existing Qty Selected | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 26 | UOFM | U Of M | String | U_Of_M | 8 | |
| The unit of measure. The value in this field must exist in Inventory. | ||||||
| 27 | QTYBSUOM | QTY In Base U Of M | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 28 | UNITCOST | Unit Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 29 | EXTDCOST | Extended Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 30 | DISCSALE | Discount Available Sales | Currency | DLR17_RBS0_UTR$ | 17 | |
| 31 | TRDISAMT | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 32 | ATYALLOC | QTY Allocated | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 33 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].LOCNCODE AS 'Invoicing Transaction Amounts Work-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Invoicing Transaction Amounts Work'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
| 34 | MRKDNTYP | Markdown Type | Integer | GB | 0 | |
| 35 | MRKDNAMT | Markdown Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 36 | MRKDNPCT | Markdown Percent | Integer | INT5_%2 | 5 | |
| 37 | PRCLEVEL | PriceLevel | String | STR10_LBAU | 10 | |
| 38 | XTNDPRCE | Extended Price | Currency | DLR17_RBS0_STR$ | 17 | |
| 39 | UNITPRCE | Unit Price | Currency | DLR17_RBS0_STR$ | 17 | |
| 40 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 41 | BKTSLSAM | Backout Sales Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 42 | TXBTXAMT | Taxable Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 43 | BSIVCTTL | Based On Invoice Total | Boolean | YN | 0 | |
| 44 | SLPRSNID | Salesperson ID | String | STR15_Salesperson_ID | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].SLPRSNID AS 'Invoicing Transaction Amounts Work-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['Invoicing Transaction Amounts Work'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
| 45 | SALSTERR | Sales Territory | String | STR15_Sales_Territory | 15 | |
Key to the Sales Territory Master File (RM00303).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].SALSTERR AS 'Invoicing Transaction Amounts Work-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['Invoicing Transaction Amounts Work'].SALSTERR = ['Sales Territory Master File'].SALSTERR | ||||||
| 46 | DSCRIPTN | Description | String | STR30 | 30 | |
| 47 | ITEMDESC | Item Description | String | STR100 | 100 | |
| 48 | EXPTSHIP | Expected Ship Date | Date | DT | 8 | |
| 49 | ACTLSHIP | Actual Ship Date | Date | DT | 8 | |
| 50 | ReqShipDate | Requested Ship Date | Date | DT | 8 | |
| 51 | COMDLRAM | Commission Dollar Amount | Currency | DLR17_RBSO_STR$ | 17 | |
| 52 | CMPSERNM | Component Serial Numbered | Boolean | YN | 0 | |
| 53 | COMMNTID | Comment ID | String | STR15_Comment_ID | 15 | |
Key to the Comment Master (SY04200).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].COMMNTID AS 'Invoicing Transaction Amounts Work-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['Invoicing Transaction Amounts Work'].COMMNTID = ['Comment Master'].COMMNTID | ||||||
| 54 | BRKFLD1 | Break Field 1 | Integer | INT1 | 1 | |
| 55 | BRKFLD2 | Break Field 2 | Integer | INT1 | 1 | |
| 56 | BRKFLD3 | Break Field 3 | Integer | INT1 | 1 | |
| 57 | TRXSORCE | TRX Source | String | STR13 | 13 | |
| 58 | IVCLINEERR | IVC LINE Errors | Long Integer | ML_IVC_LINE_Errors | 0 | |
| 59 | BackoutTradeDisc | Backout Trade Discount Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 60 | PRSTADCD | Primary Shipto Address Code | String | STR15_LBAU | 15 | |
| 61 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['Invoicing Transaction Amounts Work'].SHIPMTHD AS 'Invoicing Transaction Amounts Work-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
IVC10101 AS ['Invoicing Transaction Amounts Work']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['Invoicing Transaction Amounts Work'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
| 62 | ISLINEINTRA | IsLineIntrastat | Boolean | CB | 0 | |