Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SEE30303
Product: HITB Report (5597)
Series:
Display Name: Inventory Transaction History Detail
Physical Name: SEE30303
Technical Name: ivHITBDetail
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | ITEMNMBR  | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hide | ||||||
| 2 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 | |
| 3 | DOCDATE | Document Date | Date | DT | 8 | |
| 4 | GLPOSTDT | GL Posting Date | Date | DT | 8 | |
| 5 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
| 6 | DOCTYPE | Document Type | Integer | DDL_Document_Type | 0 | |
| 7 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hide | ||||||
| 8 | RCPTNMBR | Receipt Number | String | STR20_Document_Number | 20 | |
| 9 | RCTSEQNM | Receipt SEQ Number | Long Integer | long | 8 | |
| 10 | PCHSRCTY | Purchase Receipt Type | Integer | DDL_Purchase_Receipt_Type | 0 | |
| 11 | QTYTYPE | QTY Type | Integer | DDL_QTY_Type | 0 | |
| 12 | UOFM | U Of M | String | U_Of_M | 8 | |
| 13 | TRXQTYInBase | TRX QTY In Base | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 14 | TRXQTY | TRX QTY | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 15 | VARIANCEQTY | Variance Qty | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 16 | UNITCOST | Unit Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 17 | EXTDCOST | Extended Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 18 | DECPLQTY | Decimal Places QTYS | Integer | DDL_Decimal_Places_QTYS | 0 | |
| 19 | DECPLCUR | Decimal Places Currency | Integer | DDL_Decimal_Places_Dollars | 0 | |
| 20 | IsOverrideReceipt | IsOverrideReceipt | Boolean | Boolean | 0 | |
| 21 | IsOverrideRelieved | IsOverrideRelieved | Boolean | Boolean | 0 | |
| 22 | OverrideRelievedDate | OverrideRelievedDate | Date | DT | 8 | |
| 23 | RCPTNMBR1 | Originating Revalued Receipt Number | String | STR20_Document_Number | 20 | |
| 24 | HSTMODUL | History Module | String | STR3 | 3 | |
| 25 | ORTRXSRC | Originating TRX Source | String | STR13 | 13 | |
| 26 | LNSEQNBR | Line SEQ Number | Currency | Sequence_Number | 19 | |
| 27 | LNITMSEQ | Line Item Sequence | Long Integer | LI_Sequence_Number | 10 | |
| 28 | CMPNTSEQ | Component Sequence | Long Integer | LI_Sequence_Number | 10 | |
| 29 | SRCRFRNCNMBR | Source Reference Number | String | STR30 | 30 | |
| 30 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hide | ||||||
| 31 | PONUMBER | PO Number | String | STR17_POP_Number | 17 | |
| 32 | TRXREFERENCE | Transaction Reference | Integer | Transaction Reference | 0 | |
| 33 | VCTNMTHD | Valuation Method | Integer | DDL_Valuation_Method | 0 | |
| 34 | IVIVINDX | IV IV Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hide | ||||||
| 35 | IVIVOFIX | IV IV Offset Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hide | ||||||
| 36 | JRNENTRY | Journal Entry | Long Integer | LI8_U0 | 8 | |
| 37 | TRXSORCE | TRX Source | String | STR13 | 13 | |
| 38 | DEBITAMT | Debit Amount | Currency | DLR19_$S2 | 19 | |
| 39 | CRDTAMNT | Credit Amount | Currency | DLR19_$S2 | 19 | |
| 40 | DATE1 | Date | Date | DT6 | 6 | |
| 41 | TIME1 | Time | Time | TM6 | 6 | |