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