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

COMPANY..PA01201 Table Definition

(COMPANY..PA Project Master File)

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
PACONTNUMBER char(11)
''
PA Contrac...(more) Join Now
PAcontid char(15)
''
The ID for...(more) Join Now
PAprojid char(15)
''
Project ID...(more) Join Now
PAprojname char(31)
''
Project Na...(more) Join Now
PAPROJNUMBER char(15)
''
PA Project...(more) Join Now
PAprjclsid char(15)
''
Project Cl...(more) Join Now
PAProjectType smallint
0
Project ty...(more) Join Now
PAAcctgMethod smallint
0
Useful in ...(more) Join Now
PASTAT smallint
0
Contains t...(more) Join Now
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
PApurordnum char(17)
''
The purcha...(more) Join Now
PABBeginDate datetime
'1/1/1900'
The beginn...(more) Join Now
PABEndDate datetime
'1/1/1900'
The beginn...(more) Join Now
PABQuantity numeric(19,5)
0.00
Contains t...(more) Join Now
PABTotalCost numeric(19,5)
0.00
Total cost...(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
PAACTUALBEGDATE datetime
'1/1/1900'
The beginn...(more) Join Now
PA_Actual_End_Date datetime
'1/1/1900'
The beginn...(more) Join Now
PAFBeginDate datetime
'1/1/1900'
The beginn...(more) Join Now
PAFEndDate datetime
'1/1/1900'
The beginn...(more) Join Now
PAFQuantity numeric(19,5)
0.00
PA Forecas...(more) Join Now
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
PAcloseProjcosts tinyint
0
Allow or d...(more) Join Now
PAclosetobillings tinyint
0
Allow or d...(more) Join Now
PADepartment char(7)
''
Department...(more) Join Now
PAEstimatorID char(15)
''
Estimator ...(more) Join Now
PAprojmngrid char(15)
''
Project Ma...(more) Join Now
PABusMgrID char(15)
''
The busine...(more) Join Now
LOCATNID char(15)
''
The locati...(more) Join Now
join ... more text available
SLPRSNID char(15)
''
Used only ...(more) Join Now
join ... more text available
SALSTERR char(15)
''
Defaults w...(more) Join Now
join ... more text available
COMPRCNT smallint
0
The Commis...(more) Join Now
COMAPPTO smallint
0
The method...(more) Join Now
CNTCPRSN char(61)
''
Contact pe...(more) Join Now
PRBTADCD char(15)
''
The addres...(more) Join Now
join ... more text available
PALabor_Rate_Table_ID char(31)
''
PA Labor R...(more) Join Now PA01301.PALabor_Rate_Table_ID
PALabor_RateTable_Type smallint
0
PA Labor R...(more) Join Now PA01301.PALabor_RateTable_Type
PALabor_Rate_Table_Acc tinyint
0
PA Labor R...(more) Join Now PA01301.PALabor_Rate_Table_Acc
PAEquip_Rate_Table_ID char(31)
''
PA Equip R...(more) Join Now PA01301.PAEquip_Rate_Table_ID
PAEquip_Rate_Table_Acc tinyint
0
PA Equip R...(more) Join Now PA01301.PAEquip_Rate_Table_Acc
PAbllngtype smallint
0
1=Billable...(more) Join Now
PAService_Fee_Amount numeric(19,5)
0.00
PA Service...(more) Join Now
PAProject_Fee_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
PARetainer_Fee_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
PARetentionFeeAmount numeric(19,5)
0.00
PA Retenti...(more) Join Now
PAProject_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
ACCTAMNT numeric(19,5)
0.00
Account Am...(more) Join Now
PABILLFORMAT char(15)
''
The defaul...(more) Join Now
DSCPCTAM smallint
0
Discount P...(more) Join Now
PA_Retention_Percent numeric(19,5)
0.00
PA Retenti...(more) Join Now
PAtotcbts tinyint
0
PA Label C...(more) Join Now
PAtotcbEL tinyint
0
PA Label C...(more) Join Now
PAtotcbML tinyint
0
PA Label C...(more) Join Now
PAtotcbvi tinyint
0
PA Label C...(more) Join Now
PAtotcber tinyint
0
PA Label C...(more) Join Now
PAtotcbinv tinyint
0
PA Label C...(more) Join Now
PAtotcbfee tinyint
0
PA Label C...(more) Join Now
PAUD1Proj char(51)
''
User Defin...(more) Join Now
PAUD2_Proj char(51)
''
User Defin...(more) Join Now
PASegmentCB tinyint
0
Combine ea...(more) Join Now
PAbillnoteidx numeric(19,5)
0.00
PA Billing...(more) Join Now
PAbillnoteidxts numeric(19,5)
0.00
Default tr...(more) Join Now
PAELbillniteidx numeric(19,5)
0.00
Default tr...(more) Join Now
PAbillnoteidxML numeric(19,5)
0.00
Default tr...(more) Join Now
PAbillnoteidxvi numeric(19,5)
0.00
Default tr...(more) Join Now
PAbillnoteidxee numeric(19,5)
0.00
Default tr...(more) Join Now
PAbillnoteidxinv numeric(19,5)
0.00
Stores the...(more) Join Now
PAbillnoteidxfee numeric(19,5)
0.00
Stores the...(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
PAUnpostedRecogRevN 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
PAUnposted_Project_Fee numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnposted_Retainer_Fee numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUnposted_Service_Fee numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAUNPOSTRETAMT 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
PA_Unposted_Billed_Reten numeric(19,5)
0.00
PA Unposte...(more) Join Now
PAPostedQty numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPostedTotalCostN 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
PAPostRecogRevN numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPostedCommitedQty 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_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
PAPosted_Service_Fee numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPOSTRETAMT 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
PA_Actual_Billed_Retenti numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAWrite_UpDown_Amount numeric(19,5)
0.00
PA Write U...(more) Join Now
PABilled_QtyN numeric(19,5)
0.00
PA Billed ...(more) Join Now
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.
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
Posted Bil...(more) Join Now
PAPostedDiscDolAmtN numeric(19,5)
0.00

PAPosted_Sales_Tax_Amou numeric(19,5)
0.00

PABCWPAMT numeric(19,5)
0.00
PA BCWP Am...(more) Join Now
PABCWSAMT numeric(19,5)
0.00
PA BCWS Amount Currency storage type, keyable length: 17, storage size: 10.
PAACWPAMT numeric(19,5)
0.00
PA ACWP Am...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
PAPosted_Overhead numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAApproved_Accrued_Reve numeric(19,5)
0.00
PA Approve...(more) Join Now
PAApproved_Cost numeric(19,5)
0.00
PA Approve...(more) Join Now
PAApproved_Quantity numeric(19,5)
0.00
PA Approve...(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
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
PApretainage numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAunpretainage 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
WRKRCOMP char(7)
''
Workers Co...(more) Join Now JC00701.WRKRCOMP
SUTASTAT char(3)
''
Suta State...(more) Join Now UPR00401.SUTASTAT
PA_Actual_Billing_not_RM numeric(19,5)
0.00

PA_ActualDiscnotRM numeric(19,5)
0.00

PA_RestrictCustomerList tinyint
0
PA Restric...(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
PAMCCURNCYID char(15)
''
PA MC Curr...(more) Join Now
PAMCProjectAmount numeric(19,5)
0.00
PA MC Proj...(more) Join Now
PAMCUnpostBillN numeric(19,5)
0.00
PA MC Unpo...(more) Join Now
PAMCUnpostedSalesTax numeric(19,5)
0.00
PA MC Unpo...(more) Join Now
PAMCUnpostedDiscount numeric(19,5)
0.00
PA MC Unpo...(more) Join Now
PAMCActualBillings numeric(19,5)
0.00
PA MC Actu...(more) Join Now
PAMCActualSalesTaxAmt numeric(19,5)
0.00
PA MC Actu...(more) Join Now
PAMCActualDiscountAmt numeric(19,5)
0.00
PA MC Actu...(more) Join Now
PAMCBBillings numeric(19,5)
0.00
PA MC Base...(more) Join Now
PAMCFBillings numeric(19,5)
0.00
PA MC Fore...(more) Join Now
PA_MC_Project_Fee_Amount numeric(19,5)
0.00
PA MC Proj...(more) Join Now
PA_MC_Service_Fee_Amount numeric(19,5)
0.00
PA MC Serv...(more) Join Now
PA_MC_Retainer_Fee_Amt numeric(19,5)
0.00
PA MC Reta...(more) Join Now
PA_MC_UnpostedProjectFee numeric(19,5)
0.00
PA MC Unpo...(more) Join Now
PA_MC_Unposted_Retainer numeric(19,5)
0.00
PA MC Unpo...(more) Join Now
PA_MC_UnpostedServiceFee numeric(19,5)
0.00
Contains t...(more) Join Now
PA_MC_Actual_Project_Fee numeric(19,5)
0.00
PA MC Actu...(more) Join Now
PA_MC_Actual_RetainerFee numeric(19,5)
0.00
PA MC Actu...(more) Join Now
PA_MC_Actual_Service_Fee numeric(19,5)
0.00
PA MC Actu...(more) Join Now
PANOTIFBILL tinyint
0

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