Module List >
Module PM tables
PM80500
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PM80500 Table Definition
(COMPANY..PM Reprint Posting Journal Apply To File)
Field Definitions:
What is the 'source' column?
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| APFRDCNM |
char(21)
''
|
Apply From...(more) Join Now
|
RM20201.APFRDCNM
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
join ... more text available
|
| APTVCHNM |
char(21)
''
|
|
|
|
|
| APTODCTY |
smallint
0
|
Apply to D...(more) Join Now
|
|
|
|
| APTODCNM |
char(21)
''
|
Apply To D...(more) Join Now
|
RM20201.APTODCNM
|
|
|
| APPLDAMT |
numeric(19,5)
0.00
|
Applied Am...(more) Join Now
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Write Off ...(more) Join Now
|
|
|
|
| PPSAMDED |
numeric(19,5)
0.00
|
PPS Amount...(more) Join Now
|
|
|
|
| GSTDSAMT |
numeric(19,5)
0.00
|
GST Discou...(more) Join Now
|
|
|
|
| TAXDTLID |
char(15)
''
|
Tax Detail...(more) Join Now
|
|
|
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Dat...(more) Join Now
|
|
|
|
| PTDUSRID |
char(15)
''
|
Posted Use...(more) Join Now
|
|
|
|
| TEN99AMNT |
numeric(19,5)
0.00
|
1099 Amoun...(more) Join Now
|
|
|
|
| DISAVTKN |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
|
|
|
| APTODCDT |
datetime
'1/1/1900'
|
|
|
|
|
| KEYSOURC |
char(41)
''
|
|
|
|
|
| ORAPPAMT |
numeric(19,5)
0.00
|
|
|
|
|
| ORDISTKN |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
|
|
|
| ORWROFAM |
numeric(19,5)
0.00
|
|
|
|
|
| ORDATKN |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
|
|
|
| RLGANLOS |
numeric(19,5)
0.00
|
Realized G...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|