Module List > Module PA tables PA00601
You are currently viewing the COMPANY database.
Change

COMPANY..PA00601 Table Definition

(COMPANY..PA Employee MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char(15)
''
Employee I...(more) Join Now APR_BSS00100.EMPLOYID
join ... more text available
PAfileemplreim tinyint
0
Set to 1 t...(more) Join Now
PANOTA1099VENDOR tinyint
0
Set to 1 t...(more) Join Now
PApmcb tinyint
0

PAbmcb tinyint
0

PAEmployee_Type smallint
0
0 = Full T...(more) Join Now
PA_Employed_By smallint
0
1=Companyb...(more) Join Now
PAPayCode char(7)
''

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
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
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 CM20200.MCTRXSTT
PAUnit_of_Measure char(9)
''
PA Unit of...(more) Join Now
PAUNITCOST numeric(19,5)
0.00
PA Unit Co...(more) Join Now
PATMProfitType smallint
0
PA Profit ...(more) Join Now PA01001.PATMProfitType
PATMProfitAmount numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PATMProfitAmount
PA_Orig_Profit_AmtTM numeric(19,5)
0.00

PATMProfitPercent numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PATMProfitPercent
PAProfit_Type__CP smallint
0
PA Profit ...(more) Join Now PA01001.PAProfit_Type__CP
PAProfitAmountCP numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PAProfitAmountCP
PAProfitPercentCP numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PAProfitPercentCP
PAFFProfitType smallint
0
PA Profit ...(more) Join Now PA01001.PAFFProfitType
PAFFProfitAmount numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PAFFProfitAmount
PAFFProfitPercent numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PAFFProfitPercent
VENDORID char(15)
''
Vendor ID ...(more) Join Now WC010931.VENDORID
join ... more text available
PAOverheadRateMethod smallint
0
PA Overhea...(more) Join Now PA01001.PAOverheadRateMethod
PAOvhdAmtPerUnit numeric(19,5)
0.00
PA Overhea...(more) Join Now PA01001.PAOvhdAmtPerUnit
PAOverheaPercentage numeric(19,5)
0.00
PA Overhea...(more) Join Now
PAUD1 char(21)
''
PA User De...(more) Join Now
PAUD2 char(21)
''
PA User De...(more) Join Now
PA_Allow_Vendor_For_PO tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3