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

COMPANY..PA10200 Table Definition

(COMPANY..PA Miscellaneous Log Header File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PSMISCLTRXTYPE smallint
0

PAMISCLDOCNO char(17)
''

PADOCDT datetime
'1/1/1900'

PAYR smallint
0

USERID char(15)
''
The user t...(more) Join Now WRS10001.USERID
join ... more text available
BACHNUMB char(15)
''
Batch Numb...(more) Join Now UPR10304.BACHNUMB
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
PAREFNO char(17)
''

PSMISCID char(15)
''

PAREPD smallint
0

PAREPDT datetime
'1/1/1900'

PAPeriodEndDate datetime
'1/1/1900'

PACOMM char(51)
''

PAUD1 char(21)
''
PA User De...(more) Join Now
PAUD2 char(21)
''
PA User De...(more) Join Now
PATQTY numeric(19,5)
0.00

PAtotcosts numeric(19,5)
0.00

PATACRV numeric(19,5)
0.00

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
PAreptsuff char(5)
''

PAPD datetime
'1/1/1900'

LNITMSEQ int
0
Line Item ...(more) Join Now
PAML_HDR_Errors binary(4)
0

PAML_Dist_Errors binary(4)
0

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
PAORIGTOTCOSTS numeric(19,5)
0.00

PAORIACCRREV numeric(19,5)
0.00

Correcting_Trx_Type smallint
0
Correcting...(more) Join Now GL10000.Correcting_Trx_Type
PAORIGINLDOCNUM char(17)
''

CREATDDT datetime
'1/1/1900'
Date this ...(more) Join Now RM00102.CREATDDT
CRUSRID char(15)
''

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