Module List >
Module PA tables
PA23303
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PA23303 Table Definition
(COMPANY..PA Rev Recognition Fee DTL Work File)
Field Definitions:
What is the 'source' column?
| PADocnumber20 |
char(17)
''
|
|
|
|
|
| PADOCDT |
datetime
'1/1/1900'
|
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Customer c...(more) Join Now
|
|
|
join ... more text available
|
| CUTOFDAT |
datetime
'1/1/1900'
|
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PAProjectType |
smallint
0
|
Project ty...(more) Join Now
|
|
|
|
| PAAcctgMethod |
smallint
0
|
Useful in ...(more) Join Now
|
|
|
|
| PASTAT |
smallint
0
|
Contains t...(more) Join Now
|
|
|
|
| PAFeeID |
char(15)
''
|
PA Fee ID ...(more) Join Now
|
|
|
|
| PAFeeType |
smallint
0
|
In additio...(more) Join Now
|
|
|
|
| PAFeeAmount |
numeric(19,5)
0.00
|
PA Fee Amo...(more) Join Now
|
|
|
|
| PAPercentCompleted |
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
|
|
|
|
| PARecognizedFeeAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PACBRecogRev |
tinyint
0
|
|
|
|
|
| PABIEEAMOUNT |
numeric(19,5)
0.00
|
|
|
|
|
| PAEIEBAMOUNT |
numeric(19,5)
0.00
|
|
|
|
|
| PAPostedBillingsN |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Trade_Discount_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Sales_IDX |
int
0
|
|
|
|
|
| PAAR_IDX |
int
0
|
From the R...(more) Join Now
|
|
|
|
| PA_Deferred_RevIDX |
int
0
|
|
|
|
|
| PACGBWIPIDX |
int
0
|
ACTIDX of ...(more) Join Now
|
|
|
|
| PABBillingsIDX |
int
0
|
|
|
|
|
| PARev_IDX |
int
0
|
|
|
|
|
| PA_Retention_AR |
int
0
|
|
|
|
|
| PABBIEEIDX |
int
0
|
|
|
|
|
| PABEIEBIDX |
int
0
|
|
|
|
|
| PA_RR_Subline_ErrorsFee |
binary(4)
0
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| 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
|
|
|
|
|
| PAPostRecogRevN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PALossAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevRecognizedRev |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevBIEEAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevEIEBAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevEarnings |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevBillings |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|