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

COMPANY..PA23400 Table Definition

(COMPANY..PA Change Order Header OPEN)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PACHGORDNO char(17)
''
PA Change ...(more) Join Now
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
PAbegindate datetime
'1/1/1900'
PA Begin D...(more) Join Now
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

PAProject_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
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
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
PACOTOTBILL numeric(19,5)
0.00

PACOTOTCOST 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