Module List >
Module PA tables
PA12000
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PA12000 Table Definition
(COMPANY..PA Change Order Header WORK)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|