| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| PADocnumber20 |
char(17)
''
|
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Customer c...(more) Join Now
|
|
|
join ... more text available
|
| PACONTNUMBER |
char(11)
''
|
PA Contrac...(more) Join Now
|
|
|
|
| PADOCDT |
datetime
'1/1/1900'
|
|
|
|
|
| CUTOFDAT |
datetime
'1/1/1900'
|
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PAprojname |
char(31)
''
|
|
|
|
|
| PASegmentCB |
tinyint
0
|
Combine ea...(more) Join Now
|
|
|
|
| PA_Combine_Mode |
smallint
0
|
|
|
|
|
| PAProjectType |
smallint
0
|
Project ty...(more) Join Now
|
|
|
|
| PAAcctgMethod |
smallint
0
|
Useful in ...(more) Join Now
|
|
|
|
| PASTAT |
smallint
0
|
Contains t...(more) Join Now
|
|
|
|
| PAPercentCompleted |
numeric(19,5)
0.00
|
|
|
|
|
| PAProject_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| PAFTotalCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFQuantity |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFBillings |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAPostCost |
numeric(19,5)
0.00
|
|
|
|
|
| PAPostedQty |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PA_Actual_CostContract |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Actual_QtyContract |
numeric(19,5)
0.00
|
|
|
|
|
| PARevenueEarned |
numeric(19,5)
0.00
|
|
|
|
|
| PAREB |
numeric(19,5)
0.00
|
|
|
|
|
| PAREF |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Cost_of_Earnings |
numeric(19,5)
0.00
|
table styl...(more) Join Now
|
|
|
|
| PABRecognizedProjAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PABRecognizedBudgAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PARecognizedFeeAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PABIEEAMOUNT |
numeric(19,5)
0.00
|
|
|
|
|
| PAEIEBAMOUNT |
numeric(19,5)
0.00
|
|
|
|
|
| PARRLNEERR |
binary(4)
0
|
|
|
|
|
| PA_ActualCost__LossTest |
numeric(19,5)
0.00
|
|
|
|
|
| PA_ProjAmt__LossTest |
numeric(19,5)
0.00
|
|
|
|
|
| PA_ActualRecogRev__LossT |
numeric(19,5)
0.00
|
|
|
|
|
| PA_ActualBlgs__XcessTest |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Earnings__XcessTest |
numeric(19,5)
0.00
|
|
|
|
|
| PAPostedBillingsN |
numeric(19,5)
0.00
|
|
|
|
|
| PAPostRecogRevN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PALossAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAFQLaborOnly |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFTCLaborOnly |
numeric(19,5)
0.00
|
|
|
|
|
| PAAQLaborOnly |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAACLaborOnly |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|