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

COMPANY..PA30101 Table Definition

(COMPANY..PA Timesheet Detail History File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PATSTYP smallint
0

PATSNO char(17)
''

PAREFNO char(17)
''

EMPLOYID char(15)
''
Employee I...(more) Join Now APR_BSS00100.EMPLOYID
join ... more text available
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
PATB datetime
'1/1/1900'

PATE datetime
'1/1/1900'

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

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

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

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

PASplit_NC 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
PAPayCode char(7)
''

PASalary_Posting_Type smallint
0

PAJob_Title char(7)
''

PADepartment char(7)
''

STATECD char(3)
''
State Code...(more) Join Now W200006.STATECD
LOCLCODE char(7)
''

SUTASTAT char(3)
''
Suta State...(more) Join Now UPR00401.SUTASTAT
WRKRCOMP char(7)
''
Workers Co...(more) Join Now JC00701.WRKRCOMP
PAexptdate datetime
'1/1/1900'

PABilled_QtyN numeric(19,5)
0.00
PA Billed ...(more) Join Now
PABilledTax numeric(19,5)
0.00

PABilled_Misc numeric(19,5)
0.00

PAProfitType smallint
0
PA Profit ...(more) Join Now
PAProfitAmount numeric(19,5)
0.00

PAORIGPROFAMT numeric(19,5)
0.00

PAProfitPercent numeric(19,5)
0.00

PATotalProfit numeric(19,5)
0.00

PAORIGTOTPROF numeric(19,5)
0.00

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

PA_Billed_Profit_Amount_ numeric(19,5)
0.00

PABilledProfitPercentage numeric(19,5)
0.00

PABilled_Amount 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)
''

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

PAUnbilled_Proj_Rev_Idx int
0

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

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

PA_Billed_Status tinyint
0
0=Not Bill...(more) Join Now
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