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