Module List > Module Manufacturing tables ICJC3500
You are currently viewing the COMPANY database.
Change

COMPANY..ICJC3500 Table Definition

(COMPANY..ICJC_DPOP_Transaction_MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
JOBNUMBER_I char(31)
''

Link_ID int
0

CHILDTYPE_I smallint
0

CITEMNUMBERI smallint
0

SEQNUMBR int
0
Sequence N...(more) Join Now IV10400.SEQNUMBR
AMT_I numeric(19,5)
0.00

RE_I tinyint
0

POSITIVE_I tinyint
0

APPLIED_I tinyint
0

REVENUEEXPENSECODE_I char(21)
''

ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
ITEMDESC char(101)
''
Item Descr...(more) Join Now POP10110.ITEMDESC
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
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