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

COMPANY..PA10603 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
POPRequisitionNumber char
''

ORD int
0

ITEMNMBR char
''
span style...(more) Join Now JC00701.ITEMNMBR
join ... more text available
DATEVAL datetime
'1/1/1900'

FRTAMNT numeric
0.00
Freight Am...(more) Join Now
ITMTSHID char
''
Item Tax S...(more) Join Now
ORFRTAMT numeric
0.00
Originatin...(more) Join Now PTE30500.ORFRTAMT
PABase_Qty numeric
0.00
PA Base Qt...(more) Join Now
PABase_Unit_Cost numeric
0.00
PA Base Un...(more) Join Now
PAbillnoteidx numeric
0.00
PA Billing...(more) Join Now
PACBADDFRMFLY tinyint
0

PACHGORDNO char
''
PA Change ...(more) Join Now
PACogs_Idx int
0
ACTIDX of ...(more) Join Now
PACOSTCATID char
''
PA Cost Ca...(more) Join Now
PAIV_Item_Checkbox tinyint
0

PALineItemSeq int
0
PA Line It...(more) Join Now
PAORGBSUNITCST numeric
0.00

PAprojname char
''

PAPROJNUMBER char
''
PA Project...(more) Join Now
join ... more text available
PAProjectType smallint
0
Project ty...(more) Join Now
PAPurchase_Tax_Options smallint
0
PA Purchas...(more) Join Now
PATU smallint
0
PA Transac...(more) Join Now
PACGBWIPIDX int
0
ACTIDX of ...(more) Join Now
PostedSubtotal numeric
0.00

PRICELVL char
''
Field Type...(more) Join Now
UOMSCHDL char
''
U Of M Sch...(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