| PATSTYP |
smallint
0
|
|
|
|
|
| PATSNO |
char(17)
''
|
|
|
|
|
| PDK_TS_No |
char(31)
''
|
|
|
|
|
| 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)
''
|
|
|
|
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
APR_BSS00100.EMPLOYID
|
|
join ... more text available
|
| PA_Employed_By |
smallint
0
|
1=Companyb...(more) Join Now
|
|
|
|
| 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)
''
|
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| PAPD |
datetime
'1/1/1900'
|
|
|
|
|
| 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
|
|
|
|
|
| PDK_Proxy_ID |
char(15)
''
|
|
|
|
|
| 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)
''
|
|
|
|
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Date The system date at the time the transaction iso psted
|
B3950340.POSTEDDT
|
|
|
| PTDUSRID |
char(15)
''
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|