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

COMPANY..PA40201 Table Definition

(COMPANY..PA Budget Template File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PACTID char(15)
''

PAPTID char(15)
''

PATU smallint
0
PA Transac...(more) Join Now
PACOSTCATID char(15)
''
PA Cost Ca...(more) Join Now
PAIV_Item_Checkbox tinyint
0

PASTAT smallint
0
Contains t...(more) Join Now
PAProfitType smallint
0
PA Profit ...(more) Join Now
PAbllngtype smallint
0
1=Billable...(more) Join Now
PABase_Qty numeric(19,5)
0.00
PA Base Qt...(more) Join Now
PABase_Unit_Cost numeric(19,5)
0.00
PA Base Un...(more) Join Now
PABaseProfitAmount numeric(19,5)
0.00
PA Base Pr...(more) Join Now PA01301.PABaseProfitAmount
PABaseOvhdCost numeric(19,5)
0.00
PA Base Ov...(more) Join Now PA01301.PABaseOvhdCost
PAForecastBaseOvrhdAmt numeric(19,5)
0.00
PA Forecas...(more) Join Now PA01301.PAForecastBaseOvrhdAmt
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
PABUnitCost numeric(19,5)
0.00
PA Baselin...(more) Join Now PA01301.PABUnitCost
PABTotalCost numeric(19,5)
0.00
Total cost...(more) Join Now
PABBillings numeric(19,5)
0.00
PA Baselin...(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
PABProfitPcnt numeric(19,5)
0.00
PA Baselin...(more) Join Now PA01301.PABProfitPcnt
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
PAForecastBaseQty numeric(19,5)
0.00
PA Forecas...(more) Join Now PA01301.PAForecastBaseQty
PAForecastBaseUnitCost numeric(19,5)
0.00
PA Forecas...(more) Join Now PA01301.PAForecastBaseUnitCost
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
PAFUnitCost numeric(19,5)
0.00
PA Forecas...(more) Join Now PA01301.PAFUnitCost
PAFTotalCost numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAFBillings numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAFProfit numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAFProfitAmt numeric(19,5)
0.00
PA Forecas...(more) Join Now PA01301.PAFProfitAmt
PAFProfitPcnt numeric(19,5)
0.00
PA Forecas...(more) Join Now PA01301.PAFProfitPcnt
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
PAUnit_of_Measure char(9)
''
PA Unit of...(more) Join Now
UOMSCHDL char(11)
''
U Of M Sch...(more) Join Now
join ... more text available
PAUOfMMult numeric(19,5)
0.00
PA UofM Mu...(more) Join Now
See I... more text available
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
PAPay_Code_Hourly char(7)
''
PA Pay Cod...(more) Join Now PA01001.PAPay_Code_Hourly
PAPay_Code_Salary char(7)
''
PA Pay Cod...(more) Join Now PA01001.PAPay_Code_Salary
DECPLCUR smallint
0
Number of ...(more) Join Now
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
TM_WIP_SRC smallint
0
TM WIP SRC...(more) Join Now PA01301.TM_WIP_SRC
TM_COGS_SRC smallint
0
TM COGS SR...(more) Join Now PA01301.TM_COGS_SRC
TM_Cost_Contra_SRC smallint
0
M Cost Con...(more) Join Now PA01301.TM_Cost_Contra_SRC
TM_Unbilled_AR_SRC smallint
0
TM Unbille...(more) Join Now PA01301.TM_Unbilled_AR_SRC
TM_Unbilled_Rev_SRC smallint
0
TM Unbille...(more) Join Now PA01301.TM_Unbilled_Rev_SRC
TM_AR_SRC smallint
0
TM AR SRC ...(more) Join Now PA01301.TM_AR_SRC
TM_Prj_Rev_SRC smallint
0
TM Prj Rev...(more) Join Now PA01301.TM_Prj_Rev_SRC
TM_OVHD_SRC smallint
0
TM OVHD SR...(more) Join Now PA01301.TM_OVHD_SRC
FF_WIP_SRC smallint
0
FF WIP SRC...(more) Join Now PA01301.FF_WIP_SRC
FF_Cost_Contra_SRC smallint
0
FF Cost Co...(more) Join Now PA01301.FF_Cost_Contra_SRC
FF_AR_SRC smallint
0
FF AR SRC ...(more) Join Now PA01301.FF_AR_SRC
FF_Prj_Billings_SRC smallint
0
FF Prj Bil...(more) Join Now PA01301.FF_Prj_Billings_SRC
FF_Prj_Expense_SRC smallint
0
FF Prj Exp...(more) Join Now PA01301.FF_Prj_Expense_SRC
FF_Prj_Revenue_SRC smallint
0
FF Prj Rev...(more) Join Now PA01301.FF_Prj_Revenue_SRC
FF_Prj_Loss_SRC smallint
0
FF Prj Los...(more) Join Now PA01301.FF_Prj_Loss_SRC
FF_BIEE_SRC smallint
0
FF BIEE SR...(more) Join Now PA01301.FF_BIEE_SRC
FF_EIEB_SRC smallint
0
FF EIEB SR...(more) Join Now PA01301.FF_EIEB_SRC
FF_OVHD_SRC smallint
0
FF OVHD SR...(more) Join Now PA01301.FF_OVHD_SRC
PAcostaxscheduleid char(15)
''
PA Cost Ta...(more) Join Now PA01001.PAcostaxscheduleid
PAPurchase_Tax_Options smallint
0
PA Purchas...(more) Join Now
PAbilltaxscheduleid char(15)
''
PA Billing...(more) Join Now
PASales_Tax_Options smallint
0
PA Sales T...(more) Join Now
PAProject_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
PAOverheadRateMethod smallint
0
PA Overhea...(more) Join Now PA01001.PAOverheadRateMethod
PABaselineOvhdAmtPerUnit numeric(19,5)
0.00
PA Baselin...(more) Join Now PA01301.PABaselineOvhdAmtPerUnit
PABaselineOvrhdPct numeric(19,5)
0.00
PA Baselin...(more) Join Now PA01301.PABaselineOvrhdPct
PAForecastOvrhdAmtPerUnt numeric(19,5)
0.00
PA Forecas...(more) Join Now PA01301.PAForecastOvrhdAmtPerUnt
PAForecastOvrhdPct numeric(19,5)
0.00
PA Forecas...(more) Join Now PA01301.PAForecastOvrhdPct
LNITMSEQ int
0
Line Item ...(more) Join Now
PALineItemSeq int
0
PA Line It...(more) Join Now
PAbillnoteidx numeric(19,5)
0.00
PA Billing...(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