Module List > Module IVC tables IVC10102
You are currently viewing the COMPANY database.
Change

COMPANY..IVC10102 Table Definition

(COMPANY..Invoicing Serial and Lot Number Work)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
INVCNMBR char(21)
''
Invoice Nu...(more) Join Now
DOCTYPE smallint
0
Document T...(more) Join Now
CMPNTSEQ int
0
Component ...(more) Join Now
LNITMSEQ int
0
Line Item ...(more) Join Now
QTYTYPE smallint
0
QTY Type: ...(more) Join Now
SLTSQNUM int
0
Serial/Lot...(more) Join Now
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
SERLTNUM char(21)
''
Serial/Lot...(more) Join Now
SERLTQTY numeric(19,5)
0.00
Serial/Lot...(more) Join Now
DATERECD datetime
'1/1/1900'
Date Recei...(more) Join Now
DTSEQNUM numeric(19,5)
0.00
Date SEQ N...(more) Join Now
UNITCOST numeric(19,5)
0.00
Unit Cost:...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
POSTED tinyint
0
Posted: Wh...(more) Join Now
OVRSERLT smallint
0
Override S...(more) Join Now
MFGDATE datetime
'1/1/1900'
Manufactur...(more) Join Now
EXPNDATE datetime
'1/1/1900'
Expiration...(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