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

COMPANY..PA00511 Table Definition

(COMPANY..PA Customer Periodic Totals MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CUSTNMBR char(15)
''
Customer c...(more) Join Now
join ... more text available
YEAR1 smallint
0
Year...(more) Join Now SY40101.YEAR1
PERIODID smallint
0

PABQuantity numeric(19,5)
0.00
Contains t...(more) Join Now
PABProfit numeric(19,5)
0.00
Baseline p...(more) Join Now
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
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
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
PAUnpostedQty numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAPostedQty numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAUnpostedProfitN numeric(19,5)
0.00
PA Unposte...(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
PAUnpostAccrRevN numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAPosted_Accr_RevN numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAUnpostedTotalCostN numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAPostedTotalCostN numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAUnposted_Overhead numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAPosted_Overhead numeric(19,5)
0.00
PA Actual ...(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.
PAPostedBillingsN numeric(19,5)
0.00

PAUnposted_Fee_Amount numeric(19,5)
0.00

PAPosted_Fee_Amount numeric(19,5)
0.00

PAUnpostedRecogRevN numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAPostRecogRevN numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAUNPEIEBAMOUNT numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAPOSEIEBAMOUNT numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAUNPOSTBIEEAMOUNT numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAPOSBIEEAMOUNT numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAWrite_UpDown_Amount numeric(19,5)
0.00
PA Write U...(more) Join Now
PAUnposted_Retainer_Fee numeric(19,5)
0.00
PA Unposte...(more) Join Now
PA_Unposted_Billed_Reten numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUNPOSTRETAMT numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnposted_Service_Fee numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnposted_Project_Fee numeric(19,5)
0.00
PA Unposte...(more) Join Now
PA_Actual_Billed_Retenti numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPosted_Project_Fee numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPosted_Retainer_Fee numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPOSTRETAMT numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPosted_Service_Fee numeric(19,5)
0.00
PA Actual ...(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
PAFeeAmount numeric(19,5)
0.00
PA Fee Amo...(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
PABTotalCost numeric(19,5)
0.00
Total cost...(more) Join Now
PAFTotalCost numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAUnposted_Sales_Tax_Am numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAPosted_Sales_Tax_Amou numeric(19,5)
0.00

PACostPcntCompleted numeric(19,5)
0.00
PA Cost Pe...(more) Join Now
PAQuantityPcntCompleted numeric(19,5)
0.00
PA Quantit...(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
PAPOPostedCost numeric(19,5)
0.00
PA PO Actu...(more) Join Now
PAPOPostedQty numeric(19,5)
0.00
PA PO Actu...(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
PAUnposted_Tax_Amount numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAPosted_Tax_Amount numeric(19,5)
0.00
PA Actual ...(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
PAPostedDiscDolAmtN numeric(19,5)
0.00

PAUnpostDiscDolAmtN numeric(19,5)
0.00
PA Unposte...(more) Join Now
PABilled_Accrued_Revenu numeric(19,5)
0.00
PA Billed ...(more) Join Now
PABilled_QtyN numeric(19,5)
0.00
PA Billed ...(more) Join Now
PAApproved_Accrued_Reve numeric(19,5)
0.00
PA Approve...(more) Join Now
PAApproved_Quantity numeric(19,5)
0.00
PA Approve...(more) Join Now
PApretainage numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAunpretainage numeric(19,5)
0.00
PA Unposte...(more) Join Now
PA_Actual_Freight_Amount numeric(19,5)
0.00

PA_Unposted_Freight_Amou numeric(19,5)
0.00

PA_Actual_Misc_Amount numeric(19,5)
0.00

PA_Unposted_Misc_Amount numeric(19,5)
0.00

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
PAFQLaborOnly numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAAQLaborOnly 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