| PACOSTCATID |
char(15)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PACOSTCATNME |
char(31)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PACOSTCATCLASID |
char(15)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PAinactive |
tinyint
0
|
|
|
|
|
| PATU |
smallint
0
|
PA Transac...(more) Join Now
|
|
|
|
| PAIV_Item_Checkbox |
tinyint
0
|
|
|
|
|
| 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
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| PAUNITCOST |
numeric(19,5)
0.00
|
PA Unit Co...(more) Join Now
|
|
|
|
| PAPay_Code_Hourly |
char(7)
''
|
PA Pay Cod...(more) Join Now
|
|
|
|
| PAPay_Code_Salary |
char(7)
''
|
PA Pay Cod...(more) Join Now
|
|
|
|
| PATMProfitType |
smallint
0
|
p>PA Profi...(more) Join Now
|
|
|
|
| PATMProfitAmount |
numeric(19,5)
0.00
|
PA Profit ...(more) Join Now
|
|
|
|
| PA_Orig_Profit_AmtTM |
numeric(19,5)
0.00
|
|
|
|
|
| PATMProfitPercent |
numeric(19,5)
0.00
|
PA Profit ...(more) Join Now
|
|
|
|
| PAProfit_Type__CP |
smallint
0
|
p>PA Profi...(more) Join Now
|
|
|
|
| PAProfitAmountCP |
numeric(19,5)
0.00
|
PA Profit ...(more) Join Now
|
|
|
|
| PAProfitPercentCP |
numeric(19,5)
0.00
|
PA Profit ...(more) Join Now
|
|
|
|
| PAFFProfitType |
smallint
0
|
p>PA Profi...(more) Join Now
|
|
|
|
| PAFFProfitAmount |
numeric(19,5)
0.00
|
PA Profit ...(more) Join Now
|
|
|
|
| PAFFProfitPercent |
numeric(19,5)
0.00
|
PA Profit ...(more) Join Now
|
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| PAcostaxscheduleid |
char(15)
''
|
PA Cost Ta...(more) Join Now
|
|
|
|
| PAPurchase_Tax_Options |
smallint
0
|
PA Purchas...(more) Join Now
|
|
|
|
| PAbilltaxscheduleid |
char(15)
''
|
PA Billing...(more) Join Now
|
|
|
|
| PASales_Tax_Options |
smallint
0
|
PA Sales T...(more) Join Now
|
|
|
|
| PAUD1 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PAUD2 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PAOverheadRateMethod |
smallint
0
|
PA Overhea...(more) Join Now
|
|
|
|
| PAOvhdAmtPerUnit |
numeric(19,5)
0.00
|
PA Overhea...(more) Join Now
|
|
|
|
| PAOverheaPercentage |
numeric(19,5)
0.00
|
PA Overhea...(more) Join Now
|
|
|
|
| PANOTEINDEX |
numeric(19,5)
0.00
|
PA Note In...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
MC40200.CURNCYID
|
|
join ... more text available
|
| 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
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Exchange D...(more) Join Now
|
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
MC00100.XCHGRATE
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time Time...(more) Join Now
|
WO010213.TIME1
|
|
|
| RTCLCMTD |
smallint
0
|
Rate calcu...(more) Join Now
|
MC40300.RTCLCMTD
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|