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

COMPANY..PA01304 Table Definition

(COMPANY..PA Budget Periodic 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
PATU smallint
0
PA Transac...(more) Join Now
PAsfid smallint
0
PA Source ...(more) Join Now PA01301.PAsfid
PACOSTCATID char(15)
''
PA Cost Ca...(more) Join Now
PERIODID smallint
0

YEAR1 smallint
0
Year...(more) Join Now SY40101.YEAR1
PAPeriodStartDate datetime
'1/1/1900'

PAPeriodEndDate datetime
'1/1/1900'

PERIODDT datetime
'1/1/1900'

PAACTUALBEGDATE datetime
'1/1/1900'
The beginn...(more) Join Now
PA_Actual_End_Date datetime
'1/1/1900'
The beginn...(more) Join Now
PABQuantity numeric(19,5)
0.00
Contains t...(more) Join Now
PAFeeAmount numeric(19,5)
0.00
PA Fee Amo...(more) Join Now
PABUnitCost numeric(19,5)
0.00
PA Baselin...(more) Join Now PA01301.PABUnitCost
PABTotalCost numeric(19,5)
0.00
Total cost...(more) Join Now
PABProfit numeric(19,5)
0.00
Baseline p...(more) Join Now
PABProfitAmt numeric(19,5)
0.00
PA Baselin...(more) Join Now PA01301.PABProfitAmt
PABBillings numeric(19,5)
0.00
PA Baselin...(more) Join Now
PABTaxPaidAmt numeric(19,5)
0.00
The sum of...(more) Join Now
PABTaxChargedAmt numeric(19,5)
0.00
PA Baselin...(more) Join Now
PABaselineOvhdCost numeric(19,5)
0.00
PA Baselin...(more) Join Now
PAFQuantity numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAFUnitCost numeric(19,5)
0.00
PA Forecas...(more) Join Now PA01301.PAFUnitCost
PAFTotalCost numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAFProfit numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAFBillings numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAFTaxPaidAmt numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAFTaxChargedAmt numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAForecastOvhdCost numeric(19,5)
0.00
PA Forecas...(more) Join Now
LNITMSEQ int
0
Line Item ...(more) Join Now
PAUnpostedQty numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnpostedTotalCostN numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnposted_Overhead numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnpostedProfitN numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnposted_Tax_Amount numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnpostAccrRevN numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnpostedCommitedQty numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnpostedCommitedCost numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnpostedCommitedTaxAmt numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnpostedRecogRevN numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnposted_Fee_Amount numeric(19,5)
0.00

PAUNPOSTBIEEAMOUNT numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUNPEIEBAMOUNT numeric(19,5)
0.00
PA Unposte...(more) Join Now
PA_Unposted_Billed_Reten numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAunpostbillamt numeric(19,5)
0.00
PA Unposte...(more) Join Now PA01301.PAunpostbillamt
PAPostedQty numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPostedTotalCostN numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPosted_Overhead numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPostedProfitN numeric(19,5)
0.00
PA Actual Profit PA Actual profit is computed as: PA Actual Profit = PA Actual Billings – PA Actual Total Cost
PAPosted_Tax_Amount numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPosted_Accr_RevN numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPostedCommitedQty numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPostRecogRevN numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPostedCommitedCost numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPostedCommitedTaxAmt numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPosted_Fee_Amount numeric(19,5)
0.00

PAPOSBIEEAMOUNT numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPOSEIEBAMOUNT numeric(19,5)
0.00
PA Actual ...(more) Join Now
PA_Actual_Billed_Retenti numeric(19,5)
0.00
PA Actual ...(more) Join Now
PApostbillamt numeric(19,5)
0.00
PA Actual ...(more) Join Now PA01301.PApostbillamt
PAWrite_UpDown_Amount numeric(19,5)
0.00
PA Write U...(more) Join Now
PAApproved_Quantity numeric(19,5)
0.00
PA Approve...(more) Join Now
PARemaining_Quantity numeric(19,5)
0.00

PABilled_QtyN numeric(19,5)
0.00
PA Billed ...(more) Join Now
PAApproved_Cost numeric(19,5)
0.00
PA Approve...(more) Join Now
PARemaining_Cost numeric(19,5)
0.00

PABilled_Cost numeric(19,5)
0.00
PA Billed Cost The total billed cost for the contract. Currency storage type, keyable length: 17, storage size: 10.
PAApproved_Accrued_Reve numeric(19,5)
0.00
PA Approve...(more) Join Now
PARemaining_Accrued_Rev numeric(19,5)
0.00

PABilled_Accrued_Revenu numeric(19,5)
0.00
PA Billed ...(more) Join Now
PACostPcntCompleted numeric(19,5)
0.00
PA Cost Pe...(more) Join Now
PAQuantityPcntCompleted numeric(19,5)
0.00
PA Quantit...(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
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.
PAUnpostDiscDolAmtN numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnposted_Sales_Tax_Am numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAPostedBillingsN numeric(19,5)
0.00

PAPostedDiscDolAmtN numeric(19,5)
0.00

PAPosted_Sales_Tax_Amou numeric(19,5)
0.00

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
PACommitted_Costs numeric(19,5)
0.00
PA Committ...(more) Join Now
PACommitted_Qty numeric(19,5)
0.00
PA Committ...(more) Join Now
PAPOCost numeric(19,5)
0.00
PA PO Cost...(more) Join Now
PAPOQty numeric(19,5)
0.00
PA PO Qty ...(more) Join Now
PAPOPostedCost numeric(19,5)
0.00
PA PO Actu...(more) Join Now
PAPOPostedQty numeric(19,5)
0.00
PA PO Actu...(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
PAUnpostedLossAmount numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAActualLossAmount numeric(19,5)
0.00
PA Actual ...(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