| PACTID |
char(15)
''
|
|
|
|
|
| PAPTID |
char(15)
''
|
|
|
|
|
| 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
|
|
|
|
| PABUnitCost |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
PA01301.PABUnitCost
|
|
|
| PABTotalCost |
numeric(19,5)
0.00
|
Total cost...(more) Join Now
|
|
|
|
| PABProfitAmt |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
PA01301.PABProfitAmt
|
|
|
| PABBillings |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| 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
|
| PAUOfMMult |
numeric(19,5)
0.00
|
PA UofM Mu...(more) Join Now
|
|
|
See I... more text available
|
| PRICELVL |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| PAbllngtype |
smallint
0
|
1=Billable...(more) Join Now
|
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PAPurchase_Tax_Options |
smallint
0
|
PA Purchas...(more) Join Now
|
|
|
|
| PAcostaxscheduleid |
char(15)
''
|
PA Cost Ta...(more) Join Now
|
PA01001.PAcostaxscheduleid
|
|
|
| PASales_Tax_Options |
smallint
0
|
PA Sales T...(more) Join Now
|
|
|
|
| PAbilltaxscheduleid |
char(15)
''
|
PA Billing...(more) Join Now
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| PALineItemSeq |
int
0
|
PA Line It...(more) Join Now
|
|
|
|
| REQDATE |
datetime
'1/1/1900'
|
Required D...(more) Join Now
|
POP10100.REQDATE
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|