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

COMPANY..PA00402 Table Definition

(COMPANY..PA Project Fee Totals Master File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PAPROJNUMBER char(15)
''
PA Project...(more) Join Now
join ... more text available
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
PAUBeginDate datetime
'1/1/1900'
PA Unposte...(more) Join Now PA01301.PAUBeginDate
PAUEndDate datetime
'1/1/1900'
PA Unposte...(more) Join Now PA01301.PAUEndDate
PAUnposted_Fee_Amount numeric(19,5)
0.00

PAUnposted_Tax_Amount numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUNPOSTBIEEAMOUNT numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUNPEIEBAMOUNT numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnpostedRecogRevN numeric(19,5)
0.00
PA Unposte...(more) Join Now
PA_Unposted_Billed_Reten numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnpostDiscDolAmtN numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnpostBillN numeric(19,5)
0.00
PA Unposted Billings The sum of all unposted billings for the contract. Currency storage type, keyable length: 17, storage size: 10.
PAPosted_Fee_Amount numeric(19,5)
0.00

PAPosted_Tax_Amount numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPOSBIEEAMOUNT numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPOSEIEBAMOUNT numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPostRecogRevN numeric(19,5)
0.00
PA Actual ...(more) Join Now
PA_Actual_Billed_Retenti numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPostedDiscDolAmtN numeric(19,5)
0.00

PAPostedBillingsN numeric(19,5)
0.00

PAACTUALBEGDATE datetime
'1/1/1900'
The beginn...(more) Join Now
PA_Actual_End_Date datetime
'1/1/1900'
The beginn...(more) Join Now
PA_Receipts_Amount numeric(19,5)
0.00
PA Receipt...(more) Join Now
PA_Actual_Receipts_Amoun numeric(19,5)
0.00
PA Actual ...(more) Join Now
PA_Earnings numeric(19,5)
0.00
PA Earning...(more) Join Now
PA_Cost_of_Earnings numeric(19,5)
0.00
table styl...(more) Join Now
WROFAMNT numeric(19,5)
0.00
Write Off ...(more) Join Now
ActualWriteOffAmount numeric(19,5)
0.00
Actual Wri...(more) Join Now
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
ActualDiscTakenAmount numeric(19,5)
0.00
Actual Dis...(more) Join Now
PAtaxpaidamt numeric(19,5)
0.00
PA Tax Pai...(more) Join Now
PAPostedTaxPaidN numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPOSTRETAMT numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAUNPOSTRETAMT numeric(19,5)
0.00
PA Unposte...(more) Join Now
PA_Write_Off_Tax_Amount numeric(19,5)
0.00
PA Write O...(more) Join Now
PAActualWOTaxAmt numeric(19,5)
0.00
PA Actual ...(more) Join Now
PA_Terms_Taken_Tax_Amt numeric(19,5)
0.00
PA Terms T...(more) Join Now
PAActualTermsTakenTax numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPosted_Earnings numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAActualCostofEarnings numeric(19,5)
0.00
PA Actual ...(more) Join Now
PA_MC_Fee_Amount numeric(19,5)
0.00
PA MC Fee ...(more) Join Now
PA_MC_Unposted_Fee_Amt numeric(19,5)
0.00

PA_MC_Unposted_Tax_Amt numeric(19,5)
0.00

PA_MC_Unposted_Discount numeric(19,5)
0.00

PAMCUnpostBillN numeric(19,5)
0.00
PA MC Unpo...(more) Join Now
PA_MC_Actual_Fee_Amount numeric(19,5)
0.00

PA_MC_Actual_Tax_Amount numeric(19,5)
0.00

PA_MC_Actual_Discount numeric(19,5)
0.00

PAMCActualBillings numeric(19,5)
0.00
PA MC Actu...(more) Join Now
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