IVC10102 - Invoicing Serial and Lot Number Work
Dynamics GP table IVC10102 (Invoicing Serial and Lot Number Work) contains 17 columns including INVCNMBR, DOCTYPE, CMPNTSEQ....
SQL Query Builder
17 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| INVCNMBR | Invoice Number | String | 22 | ||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| CMPNTSEQ | Component Sequence | Long Integer | 4 | ||
| LNITMSEQ | Line Item Sequence | Long Integer | 4 | ||
| QTYTYPE | QTY Type1 = On Hand2 = Returned3 = In Use4 = In Service5 = Damaged | Integer | 2 | ||
Quantity Type values (5) 1 = On Hand2 = Returned3 = In Use4 = In Service5 = Damaged | |||||
| SLTSQNUM | Serial/Lot SEQ Number | Long Integer | 4 | ||
| ITEMNMBR | Item Number | String | 32 | ||
| SERLTNUM | Serial/Lot Number | String | 22 | ||
| SERLTQTY | Serial/Lot QTY | Currency | 10 | ||
| DATERECD | Date Received | Date | 4 | ||
| DTSEQNUM | Date SEQ Number | Currency | 10 | ||
| UNITCOST | Unit Cost | Currency | 10 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| POSTED | Posted | Boolean | 2 | ||
| OVRSERLT | Override Serial/Lot | Integer | 2 | ||
| MFGDATE | Manufacture Date | Date | 4 | ||
| EXPNDATE | Expiration Date | Date | 4 | ||
Related Tables
Tables that share columns with IVC10102. Click "Join" to add to your query.