Module List > Module TM tables OpenItem
You are currently viewing the COMPANY database.
Change

COMPANY..OpenItem Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ITEMNMBR char
''
span style...(more) Join Now JC00701.ITEMNMBR
join ... more text available
ITEMDESC char
''
Item Descr...(more) Join Now WO010116.ITEMDESC
ITMSHNAM char
''

ITMGEDSC char
''

ITMCLSCD char
''
Item Class...(more) Join Now IV00101.ITMCLSCD
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
AA_Document_Type char
''

AA_Name char
''

CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
TIMESPRT smallint
0
Times Prin...(more) Join Now MOP1200.TIMESPRT
SOPNUMBE char
''

SOPTYPE smallint
0

CMPNTSEQ int
0

LNITMSEQ int
0
Line Item ...(more) Join Now PA11801.LNITMSEQ
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now RM20101.DOCDATE
QUANTITY numeric
0.00
QTY: The n...(more) Join Now SCSU0030.QUANTITY
UNITPRCE numeric
0.00
Field Type...(more) Join Now SCSU0020.UNITPRCE
XTNDPRCE numeric
0.00
Field Type...(more) Join Now SC020630.XTNDPRCE
VENDORID char
''
Vendor ID:...(more) Join Now PM00200.VENDORID
join ... more text available
PONUMBER char
''
PO Number ...(more) Join Now SEE30303.PONUMBER
UNITCOST numeric
0.00
Unit Cost:...(more) Join Now SEE30303.UNITCOST
EXTDCOST numeric
0.00
Extended C...(more) Join Now SEE30303.EXTDCOST
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