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

COMPANY..PA12000 Table Definition

(COMPANY..PA Change Order Header WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PACHGORDNO char(17)
''
PA Change ...(more) Join Now
PACREATEADDFLY tinyint
0

PACONTNUMBER char(11)
''
PA Contrac...(more) Join Now
CUSTNMBR char(15)
''
Customer c...(more) Join Now
join ... more text available
PADOCDT datetime
'1/1/1900'

PACODESC char(31)
''

PACOCUSTNO char(21)
''

PACOTYPE smallint
0

PACOSTATUS smallint
0

REQSTDBY char(21)
''
Requested ...(more) Join Now POP10110.REQSTDBY
PAESTBY char(21)
''

PAREVBY char(15)
''

PAREVPOSITION char(31)
''

PALSTREVSEDATE datetime
'1/1/1900'

LSTUSRED char(15)
''
Last User ...(more) Join Now RM20101.LSTUSRED
PAPREVBEGINDT datetime
'1/1/1900'

PAbegindate datetime
'1/1/1900'
PA Begin D...(more) Join Now
PAPREVENDDT datetime
'1/1/1900'

PAEnDate datetime
'1/1/1900'
PA End Dat...(more) Join Now
PAAPPROVBY char(15)
''

DSCRIPTN char(31)
''

APPRVLDT datetime
'1/1/1900'
Approval D...(more) Join Now
PAGBTRKCHG smallint
0

PAREVSBUDGMT numeric(19,5)
0.00

PACOREVSFEEAMT numeric(19,5)
0.00

PATOTCHGORDAMT numeric(19,5)
0.00
PA Total C...(more) Join Now PA01301.PATOTCHGORDAMT
PAPREVPROJAMT numeric(19,5)
0.00

PAVARPROFAMT numeric(19,5)
0.00

PAREVPROJAMT numeric(19,5)
0.00

PAProject_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
PAREVREASON char(31)
''

PADOCSTATUS smallint
0

PAsequencenumber smallint
0

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
NOTEINDX2 numeric(19,5)
0.00
Note Index...(more) Join Now UPR00100.NOTEINDX2
PACOTOTCOST numeric(19,5)
0.00

PACOTOTBILL numeric(19,5)
0.00

PACOTOTQTY numeric(19,5)
0.00

PAVARTOTBILLINGS numeric(19,5)
0.00

PAVARTOTCOST numeric(19,5)
0.00

PAVARTOTQTY numeric(19,5)
0.00

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