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

COMPANY..PTE10001 Table Definition

(COMPANY..PTE Timesheet Line)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PTE_Timesheet_Number char
''

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

PATE datetime
'1/1/1900'

PTE_Quantity numeric
0.00

PABase_Qty numeric
0.00
PA Base Qt...(more) Join Now
PAUnit_of_Measure char
''
PA Unit of...(more) Join Now
UOMSCHDL char
''
p>U of M S...(more) Join Now
join ... more text available
PAUNITCOST numeric
0.00
PA Unit Co...(more) Join Now
PAOrigUnitCost numeric
0.00

PABase_Unit_Cost numeric
0.00
PA Base Un...(more) Join Now
PAORGBSUNITCST numeric
0.00

PAEXTCOST numeric
0.00

OREXTCST numeric
0.00
Originatin...(more) Join Now
PATOTCST numeric
0.00

PAORIGTOTCOST numeric
0.00

PAOverhead_Amount numeric
0.00

PAORIGOVHDAMT numeric
0.00

PABaseOvhdCost numeric
0.00

PAORIGBASEOVRHCST numeric
0.00

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

PAORIGTOTOVRHD numeric
0.00

PA_Base_Billing_Rate numeric
0.00

PAORIGBSBILLRTE numeric
0.00

PABILRATE numeric
0.00

PAORIGBILLRATE numeric
0.00

PAMARKPERCENT numeric
0.00

PAACREV numeric
0.00

PAORIACCRREV numeric
0.00

PASTD_Qty numeric
0.00

PANC_Qty numeric
0.00

PANB_Qty numeric
0.00

LNITMSEQ int
0
Line Item ...(more) Join Now
PAbllngtype smallint
0
PA Billing...(more) Join Now
PACONTNUMBER char
''
PA Contrac...(more) Join Now
PAPayCode char
''

PASalary_Posting_Type smallint
0

PAJob_Title char
''

PADepartment char
''

STATECD char
''
State Code...(more) Join Now PA11801.STATECD
LOCLCODE char
''

SUTASTAT char
''
Suta State...(more) Join Now PA11801.SUTASTAT
WRKRCOMP char
''
Workers Co...(more) Join Now PA11801.WRKRCOMP
PAProfitAmount numeric
0.00

PAORIGPROFAMT numeric
0.00

PAProfitPercent numeric
0.00

PATotalProfit numeric
0.00

PAORIGTOTPROF numeric
0.00

PAProfitType smallint
0
PA Profit ...(more) Join Now
PAROUNDAMT numeric
0.00

PABilling_StatusN smallint
0
p>1 = Bill...(more) Join Now
PAbillnoteidx numeric
0.00
PA Billing...(more) Join Now
PAMCCURNCYID char
''
PA MC Curr...(more) Join Now
PA_MC_Billing_Rate numeric
0.00

PA_MC_Base_Billing_Rate numeric
0.00

PA_MC_Accrued_Revenue numeric
0.00

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

EXGTBLID char
''
Exchange T...(more) Join Now
XCHGRATE numeric
0.00
Exchange R...(more) Join Now
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now WO010213.TIME1
RTCLCMTD smallint
0
Rate calcu...(more) Join Now
DENXRATE numeric
0.00
Exchange R...(more) Join Now
MCTRXSTT smallint
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