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

COMPANY..PA10201 Table Definition

(COMPANY..PA Miscellaneous Log Detail File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PSMISCLTRXTYPE smallint
0

PAMISCLDOCNO char(17)
''

PAREFNO char(17)
''

PSMISCID char(15)
''

PADT datetime
'1/1/1900'
PA Date ...(more) Join Now
PAPROJNUMBER char(15)
''
PA Project...(more) Join Now
join ... more text available
PACOSTCATID char(15)
''
PA Cost Ca...(more) Join Now
PAQtyQ numeric(19,5)
0.00

PABase_Qty numeric(19,5)
0.00
PA Base Qt...(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
PAROUNDAMT numeric(19,5)
0.00

PAUNITCOST numeric(19,5)
0.00
PA Unit Co...(more) Join Now
ORUNTCST numeric(19,5)
0.00
Unit Price...(more) Join Now
PABase_Unit_Cost numeric(19,5)
0.00
PA Base Un...(more) Join Now
PAORGBSUNITCST numeric(19,5)
0.00

PAEXTCOST numeric(19,5)
0.00

OREXTCST numeric(19,5)
0.00
Originatin...(more) Join Now SOP10200.OREXTCST
PATOTCST numeric(19,5)
0.00

PAORIGTOTCOST numeric(19,5)
0.00

PAOverhead_Amount numeric(19,5)
0.00

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

PAORIGBASEOVRHCST numeric(19,5)
0.00

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

PAORIGTOTOVRHD numeric(19,5)
0.00

PABILRATE numeric(19,5)
0.00

PAORIGBILLRATE numeric(19,5)
0.00

PA_Base_Billing_Rate numeric(19,5)
0.00

PAORIGBSBILLRTE numeric(19,5)
0.00

PAMARKPERCENT numeric(19,5)
0.00

PAACREV numeric(19,5)
0.00

PAORIACCRREV numeric(19,5)
0.00

PASTD_Qty numeric(19,5)
0.00

PANC_Qty numeric(19,5)
0.00

PANB_Qty numeric(19,5)
0.00

LNITMSEQ int
0
Line Item ...(more) Join Now
PAReference_Line_Seq_N int
0

PAbillnoteidx numeric(19,5)
0.00
PA Billing...(more) Join Now
PAbllngtype smallint
0
1=Billable...(more) Join Now
PACONTNUMBER char(11)
''
PA Contrac...(more) Join Now
PAProfitType smallint
0
PA Profit ...(more) Join Now
PAProfitPercent numeric(19,5)
0.00

PAProfitAmount numeric(19,5)
0.00

PAORIGPROFAMT numeric(19,5)
0.00

PATotalProfit numeric(19,5)
0.00

PAORIGTOTPROF numeric(19,5)
0.00

PAexptdate datetime
'1/1/1900'

PAML_Line_Errors binary(4)
0

PAMLLINEERR2 binary(4)
0

PAApproved_Quantity numeric(19,5)
0.00
PA Approve...(more) Join Now
PAAPPROVBILLRATE numeric(19,5)
0.00

PAAPPROVMKUPPCT numeric(19,5)
0.00

PAApproved_Billing_Amou numeric(19,5)
0.00

PABilledProfitPercentage numeric(19,5)
0.00

PA_Billed_Profit_Amount_ numeric(19,5)
0.00

PABilled_Amount numeric(19,5)
0.00

PABilledTax numeric(19,5)
0.00

PABilled_Misc numeric(19,5)
0.00

PABilled_Freight numeric(19,5)
0.00

PABilled_Discount numeric(19,5)
0.00

PAWrite_UpDown_Amount numeric(19,5)
0.00
PA Write U...(more) Join Now
PAWrite_UpDown_Percenta int
0

PAApprover_ID char(15)
''

PABilled_QtyN numeric(19,5)
0.00
PA Billed ...(more) Join Now
PAApprover_Type smallint
0

PAPartial_Bill tinyint
0

PABilling_StatusN smallint
0
p>1 = Bill...(more) Join Now
PACGBWIPIDX int
0
ACTIDX of ...(more) Join Now
PAUnbilled_AR_Idx int
0

PACogs_Idx int
0
ACTIDX of ...(more) Join Now
PAContra_Account_IDX int
0

PAOverhead_IDX int
0
ACTIDX of ...(more) Join Now
PAUnbilled_Proj_Rev_Idx int
0

RNDDIFF int
0
Rounding D...(more) Join Now MC40201.RNDDIFF
PACHGORDNO char(17)
''
PA Change ...(more) Join Now
PACBADDFRMFLY tinyint
0

PAMCCURNCYID char(15)
''
PA MC Curr...(more) Join Now
PA_MC_Billing_Rate numeric(19,5)
0.00

PA_MC_Base_Billing_Rate numeric(19,5)
0.00

PA_MC_Accrued_Revenue numeric(19,5)
0.00

CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
RATETPID char(15)
''

EXGTBLID char(15)
''
Exchange T...(more) Join Now MC00100.EXGTBLID
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now MC00100.XCHGRATE
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now WO010213.TIME1
RATECALC smallint
0
Rate Calc ...(more) Join Now POP10100.RATECALC
DENXRATE numeric(19,7)
0.00
Exchange R...(more) Join Now
MCTRXSTT smallint
0
MC Transac...(more) Join Now CM20200.MCTRXSTT
Correcting_Trx_Type smallint
0
Correcting...(more) Join Now GL10000.Correcting_Trx_Type
PAORIGINLDOCNUM char(17)
''

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