SEE30303 - Inventory Transaction History Detail
Dynamics GP table SEE30303 (Inventory Transaction History Detail) contains 41 columns including ITEMNMBR, SEQNUMBR, DOCDATE....
SQL Query Builder
41 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| ITEMNMBR | Item Number | String | 32 | ||
| SEQNUMBR | Sequence Number | Long Integer | 4 | ||
| DOCDATE | Document Date | Date | 4 | ||
| GLPOSTDT | GL Posting Date | Date | 4 | ||
| DOCNUMBR | Document 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 | |||||
| LOCNCODE | Location Code | String | 12 | ||
| RCPTNMBR | Receipt Number | String | 22 | ||
| RCTSEQNM | Receipt SEQ Number | Long Integer | 4 | ||
| PCHSRCTY | Purchase Receipt Type | Integer | 2 | ||
Purchase Receipt Type values (8) 1 = Adjustment2 = Variance3 = Transfer4 = Override5 = Receipt6 = Return7 = Assembly8 = In-Transit | |||||
| 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 | |||||
| UOFM | U Of M | String | 10 | ||
| TRXQTYInBase | TRX QTY In Base | Currency | 10 | ||
| TRXQTY | TRX QTY | Currency | 10 | ||
| VARIANCEQTY | Variance Qty | Currency | 10 | ||
| UNITCOST | Unit Cost | Currency | 10 | ||
| EXTDCOST | Extended Cost | Currency | 10 | ||
| DECPLQTY | Decimal Places QTYS | Integer | 2 | ||
| DECPLCUR | Decimal Places Currency | Integer | 2 | ||
| IsOverrideReceipt | IsOverrideReceipt | Boolean | 2 | ||
| IsOverrideRelieved | IsOverrideRelieved | Boolean | 2 | ||
| OverrideRelievedDate | OverrideRelievedDate | Date | 4 | ||
| RCPTNMBR1 | Originating Revalued Receipt Number | String | 22 | ||
| HSTMODUL | History Module | String | 4 | ||
| ORTRXSRC | Originating TRX Source | String | 14 | ||
| LNSEQNBR | Line SEQ Number | Currency | 10 | ||
| LNITMSEQ | Line Item Sequence | Long Integer | 4 | ||
| CMPNTSEQ | Component Sequence | Long Integer | 4 | ||
| SRCRFRNCNMBR | Source Reference Number | String | 32 | ||
| VENDORID | Vendor ID | String | 16 | ||
| PONUMBER | PO Number | String | 18 | ||
| TRXREFERENCE | Transaction Reference | Integer | 2 | ||
| VCTNMTHD | Valuation Method1. FIFO Perpetual2. LIFO Perpetual3. Average Perpetual4. FIFO Periodic (This value is not available for SBM.)5. LIFO Periodic (This value is not available for SBM.) | Integer | 2 | ||
Valuation Method values (5) 1 = FIFO Perpetual2 = LIFO Perpetual3 = Average Perpetual4 = FIFO Periodic5 = LIFO Periodic | |||||
| IVIVINDX | IV IV Index | Long Integer | 4 | ||
| IVIVOFIX | IV IV Offset Index | Long Integer | 4 | ||
| JRNENTRY | Journal Entry | Long Integer | 4 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| DEBITAMT | Debit Amount | Currency | 10 | ||
| CRDTAMNT | Credit Amount | Currency | 10 | ||
| DATE1 | Date | Date | 4 | ||
| TIME1 | Time | Time | 4 | ||
Related Tables
Tables that share columns with SEE30303. Click "Join" to add to your query.