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

COMPANY..PA23401 Table Definition

(COMPANY..PA Change Order Detail OPEN)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PACONTNUMBER char(11)
''
PA Contrac...(more) Join Now
PACHGORDNO char(17)
''
PA Change ...(more) Join Now
PACOTRKCHGBY smallint
0

LNITMSEQ int
0
Line Item ...(more) Join Now
PAPROJNUMBER char(15)
''
PA Project...(more) Join Now
join ... more text available
PATU smallint
0
PA Transac...(more) Join Now
PACOSTCATID char(15)
''
PA Cost Ca...(more) Join Now
PALineItemSeq int
0
PA Line It...(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
PAPREVBEGINDT datetime
'1/1/1900'

PAbegindate datetime
'1/1/1900'
PA Begin D...(more) Join Now
PAPREVENDDT datetime
'1/1/1900'

PAEnDate datetime
'1/1/1900'
PA End Dat...(more) Join Now
PAPREVPYCDESLY char(7)
''

PAPay_Code_Salary char(7)
''
PA Pay Cod...(more) Join Now PA01001.PAPay_Code_Salary
PAPREVPYCODEHOURLY char(7)
''

PAPay_Code_Hourly char(7)
''
PA Pay Cod...(more) Join Now PA01001.PAPay_Code_Hourly
PAProfitType smallint
0
PA Profit ...(more) Join Now
PAbllngtype smallint
0
1=Billable...(more) Join Now
PAPREVPURCHTXOPT smallint
0

PAPurchase_Tax_Options smallint
0
PA Purchas...(more) Join Now
PAPREVCOSTXSCHED char(15)
''

PAPURCHTAXSCHED char(15)
''

DECPLQTY smallint
0
Decimal Pl...(more) Join Now
DECPLCUR smallint
0
Number of ...(more) Join Now
PAPREVSALESTXOPT smallint
0

PASales_Tax_Options smallint
0
PA Sales T...(more) Join Now
PAPREVBILLTXSCHED char(15)
''

PAbilltaxscheduleid char(15)
''
PA Billing...(more) Join Now
PAVarianceQty numeric(19,5)
0.00

PAQtyQ numeric(19,5)
0.00

PAVarianceCosts numeric(19,5)
0.00

PAUNITCOST numeric(19,5)
0.00
PA Unit Co...(more) Join Now
PAVARTOTCOST numeric(19,5)
0.00

PAVAROVERHDAMT numeric(19,5)
0.00

PATOTALOVERH numeric(19,5)
0.00

PAVAROVERHDPRCNT numeric(19,5)
0.00

PAOverheaPercentage numeric(19,5)
0.00
PA Overhea...(more) Join Now
PAVAROVRHDUNIT numeric(19,5)
0.00

PAOvhdAmtPerUnit numeric(19,5)
0.00
PA Overhea...(more) Join Now PA01001.PAOvhdAmtPerUnit
PATOTCST numeric(19,5)
0.00

PAVARMUPRCNT numeric(19,5)
0.00

PAProfitPercent numeric(19,5)
0.00

PAVARPROFAMT numeric(19,5)
0.00

PAProfitAmount numeric(19,5)
0.00

PAVARTOTLPROF numeric(19,5)
0.00

PATotalProfit numeric(19,5)
0.00

PAVARTOTBILLINGS numeric(19,5)
0.00

PAtotbillings numeric(19,5)
0.00

PAORIGBUDGTAMT numeric(19,5)
0.00

PAROGPROJAMT numeric(19,5)
0.00

PAVARPROJAMT numeric(19,5)
0.00

PAProject_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
PAPREVPROJAMT numeric(19,5)
0.00

PAPREVBASEQTY numeric(19,5)
0.00

PABase_Qty numeric(19,5)
0.00
PA Base Qt...(more) Join Now
PAPREVBSEUNTCST numeric(19,5)
0.00

PABase_Unit_Cost numeric(19,5)
0.00
PA Base Un...(more) Join Now
PAPREVBSOVERHDCST numeric(19,5)
0.00

PABaseOvhdCost numeric(19,5)
0.00
PA Base Ov...(more) Join Now PA01301.PABaseOvhdCost
PAPREVBSPROFAMT numeric(19,5)
0.00

PABaseProfitAmount numeric(19,5)
0.00
PA Base Pr...(more) Join Now PA01301.PABaseProfitAmount
PAPROPQUOTEAMT numeric(19,5)
0.00

PAFINQUOTEAMT numeric(19,5)
0.00

PAQUOTEPREPBY char(21)
''

PAQUOTEAPPRVBY char(21)
''

PAREVBUDGTAMT numeric(19,5)
0.00

PAREVPROJAMT numeric(19,5)
0.00

PAsequencenumber smallint
0

APPRVLDT datetime
'1/1/1900'
Approval D...(more) Join Now
PAClose_CB tinyint
0

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
PAPostRecogRevN 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
PApostbillamt numeric(19,5)
0.00
PA Actual ...(more) Join Now PA01301.PApostbillamt
PA_Actual_Receipts_Amoun numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAPostedBillingsN numeric(19,5)
0.00

PAPostedDiscDolAmtN numeric(19,5)
0.00

PAPosted_Sales_Tax_Amou numeric(19,5)
0.00

ActualWriteOffAmount numeric(19,5)
0.00
Actual Wri...(more) Join Now
ActualDiscTakenAmount numeric(19,5)
0.00
Actual Dis...(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
PAActualWOTaxAmt numeric(19,5)
0.00
PA Actual ...(more) Join Now
PAActualTermsTakenTax 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