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

COMPANY..PTE30501 Table Definition

(COMPANY..PTE_Employee_Expense_Line_HIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PTE_Empl_Expense_Doc_No 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
PAitemnumber char
''

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
ORUNTCST numeric
0.00
Unit Price...(more) Join Now
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
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

PABILRATE numeric
0.00

PAORIGBILLRATE numeric
0.00

PA_Base_Billing_Rate numeric
0.00

PAORIGBSBILLRTE numeric
0.00

PAMARKPERCENT numeric
0.00

PAACREV numeric
0.00

PAORIACCRREV numeric
0.00

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
PASTD_Qty numeric
0.00

PANC_Qty numeric
0.00

PANB_Qty numeric
0.00

LNITMSEQ int
0
Line Item ...(more) Join Now
PAREFNO char
''

PAReference_Line_Seq_N int
0

PAbllngtype smallint
0
PA Billing...(more) Join Now
PACONTNUMBER char
''
PA Contrac...(more) Join Now
PAbillnoteidx numeric
0.00
PA Billing...(more) Join Now
BKTPURAM numeric
0.00
Backout Pu...(more) Join Now
OBKPURAMT numeric
0.00
Originatin...(more) Join Now
PAPurchase_Tax_Options smallint
0
PA Purchas...(more) Join Now
TAXAMNT numeric
0.00
Tax Amount...(more) Join Now
ORTAXAMT numeric
0.00
Originatin...(more) Join Now
BCKTXAMT numeric
0.00
Backout Ta...(more) Join Now
OBTAXAMT numeric
0.00
Originatin...(more) Join Now
ITMTSHID char
''
Item Tax S...(more) Join Now
PABilling_StatusN smallint
0
p>1 = Bill...(more) Join Now
PAReimbursableAmount numeric
0.00

PAOrigReimbursableAmt numeric
0.00

PAROUNDAMT numeric
0.00

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
RATECALC smallint
0
Rate Calc ...(more) Join Now
PAExpenseType smallint
0
1-Reimburs...(more) Join Now
PAPaymentMethod smallint
0

DENXRATE numeric
0.00
Exchange R...(more) Join Now
MCTRXSTT smallint
0

PAtotcosts numeric
0.00

PAORIGTOTCOSTS numeric
0.00

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