| 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
|
|
|
|