Module List > Module IV tables IV10000
You are currently viewing the COMPANY database.
Change

COMPANY..IV10000 Table Definition

(COMPANY..Inventory Transaction Work)

This file is used to store the general transaction header information for Inventory transactions. These transactions are entered using the transaction entry forms IV_Transaction_Entry and IV_Transfer_Entry. Line items for transactions are stored in the IV_TRX_WORK_LINE file. If the transaction is assigned to a recurring batch, the transaction will remain in the IV_TRX_WORK_HDR file after posting occurs. If it is assigned to a single-use batch, the transaction will be deleted after posting.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
IVDOCNBR char(17)
''
IV Documen...(more) Join Now
RCDOCNUM char(21)
''
Recurring ...(more) Join Now
IVDOCTYP smallint
0
IV Documen...(more) Join Now
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
MDFUSRID char(15)
''
User that ...(more) Join Now
join ... more text available
POSTEDDT datetime
'1/1/1900'
Posted Dat...(more) Join Now
PTDUSRID char(15)
''
Posted Use...(more) Join Now
GLPOSTDT datetime
'1/1/1900'
GL Posting...(more) Join Now
PSTGSTUS smallint
0
Posting St...(more) Join Now
TRXQTYTL numeric(19,5)
0.00
TRX QTY To...(more) Join Now
IVWHRMSG binary(4)
0
IV WORK HD...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
SRCRFRNCNMBR char(31)
''
Source Ref...(more) Join Now
SOURCEINDICATOR smallint
0
Source Ind...(more) Join Now
DEX_ROW_TS datetime
(getutcdate())
Time Stamp...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3