Module List > Module PA tables PT10000
You are currently viewing the COMPANY database.
Change

COMPANY..PT10000 Table Definition

(COMPANY..Project Distributions)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PROJNAME char(21)
''

ITEMNMBR char(31)
''
span style...(more) Join Now IV00103.ITEMNMBR
join ... more text available
ITEMDESC char(101)
''
Item Descr...(more) Join Now IV00101.ITEMDESC
NONINVEN smallint
0
Non-IV: Th...(more) Join Now SOP10200.NONINVEN
ProjDistDocSource smallint
0

DOCNUMBR char(21)
''
Document N...(more) Join Now PM10000.DOCNUMBR
LNITMSEQ int
0
Line Item ...(more) Join Now PA01301.LNITMSEQ
CMPNTSEQ int
0
Component ...(more) Join Now SOP10200.CMPNTSEQ
DSTSQNUM int
0
Distributi...(more) Join Now CM20400.DSTSQNUM
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
Whom char(31)
''

ProjDistType smallint
0

ProDistCategory smallint
0

INCORDEC smallint
0

DISTAMNT numeric(19,5)
0.00

QUANTITY numeric(19,5)
0.00
QTY: The n...(more) Join Now SOP10200.QUANTITY
BillableType smallint
0

DECPLQTY smallint
0
Decimal Pl...(more) Join Now
DECPLCUR smallint
0
Number of ...(more) Join Now
POSTED tinyint
0
Posted: S...(more) Join Now RM10301.POSTED
ProjDistBillStatus smallint
0

PayCode char(7)
''

PAYRATE numeric(19,5)
0.00

SOPNUMBE char(21)
''
The number...(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