| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PACOSTCATID |
char(15)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Number.
|
WO010615.ITEMNMBR
|
|
join ... more text available
|
| PABase_Qty |
numeric(19,5)
0.00
|
PA Base Qt...(more) Join Now
|
|
|
|
| PABase_Unit_Cost |
numeric(19,5)
0.00
|
PA Base Un...(more) Join Now
|
|
|
|
| PABaseProfitAmount |
numeric(19,5)
0.00
|
PA Base Pr...(more) Join Now
|
PA01301.PABaseProfitAmount
|
|
|
| PABaseOvhdCost |
numeric(19,5)
0.00
|
PA Base Ov...(more) Join Now
|
PA01301.PABaseOvhdCost
|
|
|
| PABQuantity |
numeric(19,5)
0.00
|
Contains t...(more) Join Now
|
|
|
|
| PAForecastBaseQty |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
PA01301.PAForecastBaseQty
|
|
|
| PAForecastBaseUnitCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
PA01301.PAForecastBaseUnitCost
|
|
|
| PAForecastBaseProfitAmt |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
PA01301.PAForecastBaseProfitAmt
|
|
|
| PABUnitCost |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
PA01301.PABUnitCost
|
|
|
| PABTotalCost |
numeric(19,5)
0.00
|
Total cost...(more) Join Now
|
|
|
|
| PABBillings |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PABProfitAmt |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
PA01301.PABProfitAmt
|
|
|
| PABaselineOvhdCost |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PABTaxPaidAmt |
numeric(19,5)
0.00
|
The sum of...(more) Join Now
|
|
|
|
| PABTaxChargedAmt |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PABaselinePTaxOptions |
smallint
0
|
PA Baselin...(more) Join Now
|
PA01301.PABaselinePTaxOptions
|
|
|
| PABaselineCTaxSchedID |
char(15)
''
|
PA Baselin...(more) Join Now
|
PA01301.PABaselineCTaxSchedID
|
|
|
| PABaselineSTaxOptions |
smallint
0
|
PA Baselin...(more) Join Now
|
PA01301.PABaselineSTaxOptions
|
|
|
| PABaselineBTaxSchedID |
char(15)
''
|
PA Baselin...(more) Join Now
|
PA01301.PABaselineBTaxSchedID
|
|
|
| PAFQuantity |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFUnitCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
PA01301.PAFUnitCost
|
|
|
| PAFTotalCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFBillings |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFProfitAmt |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
PA01301.PAFProfitAmt
|
|
|
| PAForecastOvhdCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFTaxPaidAmt |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFTaxChargedAmt |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAForecastPTaxOptions |
smallint
0
|
PA Forecas...(more) Join Now
|
PA01301.PAForecastPTaxOptions
|
|
|
| PAForecastCTaxSchedID |
char(15)
''
|
PA Forecas...(more) Join Now
|
PA01301.PAForecastCTaxSchedID
|
|
|
| PAForecastSTaxOptions |
smallint
0
|
PA Forecas...(more) Join Now
|
PA01301.PAForecastSTaxOptions
|
|
|
| PAForecastBTaxSchedID |
char(15)
''
|
PA Forecas...(more) Join Now
|
PA01301.PAForecastBTaxSchedID
|
|
|
| UOFM |
char(9)
''
|
U Of M: Th...(more) Join Now
|
SOP10200.UOFM
|
|
See I... more text available
|
| UOMSCHDL |
char(11)
''
|
U Of M Sch...(more) Join Now
|
|
|
join ... more text available
|
| PRICELVL |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| PAUOfMMult |
numeric(19,5)
0.00
|
PA UofM Mu...(more) Join Now
|
|
|
See I... more text available
|
| PAbllngtype |
smallint
0
|
1=Billable...(more) Join Now
|
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| PAPostedQty |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PApstdcosts |
numeric(19,5)
0.00
|
|
|
|
|
| PAPosted_Accr_RevN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Return_QTY |
numeric(19,5)
0.00
|
|
|
|
|
| PAPosted_Return_Costs |
numeric(19,5)
0.00
|
|
|
|
|
| PAActualReturnAccrRev |
numeric(19,5)
0.00
|
|
|
|
|
| PAunpcosts |
numeric(19,5)
0.00
|
|
|
|
|
| PAUnpQty |
numeric(19,5)
0.00
|
|
|
|
|
| PAUnpostAccrRevN |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Return_QTY |
numeric(19,5)
0.00
|
|
|
|
|
| PAUnposted_Return_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| PAUnpostedReturnAccrRev |
numeric(19,5)
0.00
|
|
|
|
|
| PAPOCost |
numeric(19,5)
0.00
|
PA PO Cost...(more) Join Now
|
|
|
|
| PAPOQty |
numeric(19,5)
0.00
|
PA PO Qty ...(more) Join Now
|
|
|
|
| PACommitted_Costs |
numeric(19,5)
0.00
|
PA Committ...(more) Join Now
|
|
|
|
| PACommitted_Qty |
numeric(19,5)
0.00
|
PA Committ...(more) Join Now
|
|
|
|
| PAPOPostedQty |
numeric(19,5)
0.00
|
PA PO Actu...(more) Join Now
|
|
|
|
| PAPOPostedCost |
numeric(19,5)
0.00
|
PA PO Actu...(more) Join Now
|
|
|
|
| REQDATE |
datetime
'1/1/1900'
|
Required D...(more) Join Now
|
POP10100.REQDATE
|
|
|
| PALineItemSeq |
int
0
|
PA Line It...(more) Join Now
|
|
|
|
| PAPostedBillingsN |
numeric(19,5)
0.00
|
|
|
|
|
| PAUnposted_Tax_Amount |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAPosted_Tax_Amount |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PACHGORDNO |
char(17)
''
|
PA Change ...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|