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

COMPANY..PA01202 Table Definition

(COMPANY..PA MC Project Master File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PAPROJNUMBER char(15)
''
PA Project...(more) Join Now
join ... more text available
PAMCCURNCYID char(15)
''
PA MC Curr...(more) Join Now
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
PABRATETPID char(15)
''

PABEXGTBLID char(15)
''

PABXCHGRATE numeric(19,7)
0.00

PABEXCHDATE datetime
'1/1/1900'

PABTIME1 datetime
'1/1/1900'

PABRTCLCMTD smallint
0

PABDENXRATE numeric(19,7)
0.00

PABMCTRXSTT smallint
0

PAFRATETPID char(15)
''

PAFEXGTBLID char(15)
''

PAFXCHGRATE numeric(19,7)
0.00

PAFEXCHDATE datetime
'1/1/1900'

PAFTIME1 datetime
'1/1/1900'

PAFRTCLCMTD smallint
0

PAFDENXRATE numeric(19,7)
0.00

PAFMCTRXSTT smallint
0

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