GP Tables

IV10000 - Inventory Transaction Work Header

Stores unposted inventory transaction headers (adjustments, transfers, variances).

SQL Query Builder

19 Columns

Column Description Type Length
BACHNUMB char(15) ''
BCHSOURC char(15) ''
IVDOCNBR char(17) ''
RCDOCNUM char(21) ''
IVDOCTYP smallint 0
DOCDATE datetime '1/1/1900'
MODIFDT datetime '1/1/1900'
MDFUSRID char(15) ''
POSTEDDT datetime '1/1/1900'
PTDUSRID char(15) ''
GLPOSTDT datetime '1/1/1900'
PSTGSTUS smallint 0
Posting Status values (11)
0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
TRXQTYTL numeric(19,5) 0.00
IVWHRMSG binary(4) 0
NOTEINDX numeric(19,5) 0.00
SRCRFRNCNMBR char(31) ''
SOURCEINDICATOR smallint 0
DEX_ROW_TS datetime (getutcdate())
DEX_ROW_ID int auto number (1,1)

Reporting Tips

  • - Source Indicator field shows the originating module (e.g., 6=Stock Count, 11=Project Accounting)

Related Tables

Tables that share columns with IV10000. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

MDFUSRID

ASIEXP09 ASIEXP19 ASIEXP22 CM20200 CM20300 CT00002 CT00102 CT40401

NOTEINDX

AAG00201 AAG00300 AAG00400 AAG00401 AF40100 AF40103 AF40106 APR_BLM42100

BACHNUMB

APR_APR30000 ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20