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

COMPANY..PDK10001 Table Definition

(COMPANY..PDK Timesheet LINE)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PDK_TS_No char(31)
''

EMPLOYID char(15)
''
Employee I...(more) Join Now UPR00100.EMPLOYID
join ... more text available
PADT datetime
'1/1/1900'
PA Date ...(more) Join Now PA05200.PADT
PAPROJNUMBER char(15)
''
PA Project...(more) Join Now PA01301.PAPROJNUMBER
join ... more text available
PACOSTCATID char(15)
''
PA Cost Ca...(more) Join Now PA01001.PACOSTCATID
PATB datetime
'1/1/1900'

PATE datetime
'1/1/1900'

PDK_Quantity numeric(19,5)
0.00

PABase_Qty numeric(19,5)
0.00
PA Base Qt...(more) Join Now PA01301.PABase_Qty
PAUnit_of_Measure char(9)
''
PA Unit of...(more) Join Now PA01001.PAUnit_of_Measure
UOMSCHDL char(11)
''
U Of M Sch...(more) Join Now PA01001.UOMSCHDL
join ... more text available
PAUNITCOST numeric(19,5)
0.00
PA Unit Co...(more) Join Now PA01001.PAUNITCOST
ORUNTCST numeric(19,5)
0.00
Unit Price...(more) Join Now SOP10200.ORUNTCST
PABase_Unit_Cost numeric(19,5)
0.00
PA Base Un...(more) Join Now PA01301.PABase_Unit_Cost
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

PAORIGOVHDAMT numeric(19,5)
0.00

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

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

PAORIGTOTOVRHD numeric(19,5)
0.00

PA_Base_Billing_Rate numeric(19,5)
0.00

PAORIGBSBILLRTE numeric(19,5)
0.00

PABILRATE numeric(19,5)
0.00

PAORIGBILLRATE 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 PA01301.LNITMSEQ
PAREFNO char(17)
''

PAReference_Line_Seq_N int
0

PAbllngtype smallint
0
PA Billing...(more) Join Now PA01301.PAbllngtype
PACONTNUMBER char(11)
''
PA Contrac...(more) Join Now PA01101.PACONTNUMBER
PAPayCode char(7)
''

PASalary_Posting_Type smallint
0

PAJob_Title char(7)
''

PADepartment char(7)
''

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

SUTASTAT char(3)
''
Suta State...(more) Join Now UPR00100.SUTASTAT
WRKRCOMP char(7)
''
Workers Co...(more) Join Now UPR00100.WRKRCOMP
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

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

PABilling_StatusN smallint
0
p>1 = Bill...(more) Join Now PA30301.PABilling_StatusN
PDK_Billing_Note_ID char(41)
''

PACHGORDNO char(17)
''
PA Change ...(more) Join Now PA01301.PACHGORDNO
PAMCCURNCYID char(15)
''
PA MC Curr...(more) Join Now PA01301.PAMCCURNCYID
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 CM20200.CURRNIDX
join ... more text available
RATETPID char(15)
''
A valid Ra...(more) Join Now
EXGTBLID char(15)
''
Exchange T...(more) Join Now CM20200.EXGTBLID
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now CM20200.XCHGRATE
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now CM20200.EXCHDATE
TIME1 datetime
'1/1/1900'
Time see ...(more) Join Now CM20200.TIME1
RATECALC smallint
0
Rate Calc ...(more) Join Now POP10100.RATECALC
DENXRATE numeric(19,7)
0.00
Denominati...(more) Join Now CM20200.DENXRATE
MCTRXSTT smallint
0
MC Transac...(more) Join Now CM20200.MCTRXSTT
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