Module List >
Module PA tables
PA50105
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PA50105 Table Definition
(COMPANY..RMPMOpen)
Field Definitions:
What is the 'source' column?
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
WRS10001.USERID
|
|
join ... more text available
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
PM30200.DOCTYPE
|
|
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
RVLPD029.DOCNUMBR
|
|
|
| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
PP100101.VCHRNMBR
|
|
|
| MODULEID |
smallint
0
|
|
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
RM20101.DOCDATE
|
|
|
| DUEDATE |
datetime
'1/1/1900'
|
Due Date: ...(more) Join Now
|
PM10000.DUEDATE
|
|
|
| CustVenID |
char(15)
''
|
|
|
|
|
| CURTRXAM |
numeric(19,5)
0.00
|
|
|
|
|
| ORCTRXAM |
numeric(19,5)
0.00
|
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
MC40200.CURNCYID
|
|
join ... more text available
|
| VOIDSTTS |
smallint
0
|
Void Statu...(more) Join Now
|
POP30300.VOIDSTTS
|
|
|
| APPLDAMT |
numeric(19,5)
0.00
|
|
|
|
|
| ORAPPAMT |
numeric(19,5)
0.00
|
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| ORDISTKN |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
SOP10100.ORDISTKN
|
|
|
| DISAVTKN |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
RM20101.DISAVTKN
|
|
|
| ORDATKN |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
SOP10100.ORDATKN
|
|
|
| TAXDTLID |
char(15)
''
|
|
|
|
|
| GSTDSAMT |
numeric(19,5)
0.00
|
GST Discou...(more) Join Now
|
RM20101.GSTDSAMT
|
|
|
| PPSAMDED |
numeric(19,5)
0.00
|
PPS Amount...(more) Join Now
|
RM20101.PPSAMDED
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|