Module List >
Module PM tables
PM10201
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PM10201 Table Definition
(COMPANY..PM Payment Apply To Work File)
One line per payment/voucher; both work and history
Field Definitions:
What is the 'source' column?
| DiscTknTot |
numeric(19,5)
0.00
|
|
|
|
|
| NetCkAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PdTot |
numeric(19,5)
0.00
|
|
|
|
|
| NegTot |
numeric(19,5)
0.00
|
|
|
|
|
| CrdDocAmt |
numeric(19,5)
0.00
|
|
|
|
|
| TotDocAmt |
numeric(19,5)
0.00
|
|
|
|
|
| WrOffTot |
numeric(19,5)
0.00
|
|
|
|
|
| CrdtDesc |
char(31)
''
|
|
|
|
|
| TRXDSCRN |
char(31)
''
|
Transactio...(more) Join Now
|
|
|
|
| PrtOnStb |
tinyint
0
|
|
|
|
|
| PMNTNMBR |
char(21)
''
|
Payment Nu...(more) Join Now
|
CM20300.PMNTNMBR
|
|
|
| KEYFIELD |
char(21)
''
|
|
|
|
|
| APFVCHNM |
char(21)
''
|
|
|
|
|
| APTVCHNM |
char(21)
''
|
|
|
|
|
| APFRDCTY |
smallint
0
|
|
|
|
|
| APTODCTY |
smallint
0
|
|
|
|
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
PM10000.DOCNUMBR
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
|
|
|
| AMNTPAID |
numeric(19,5)
0.00
|
Amount Pai...(more) Join Now
|
SOP10103.AMNTPAID
|
|
|
| CRDTAMNT |
numeric(19,5)
0.00
|
Credit Amo...(more) Join Now
|
GL10001.CRDTAMNT
|
|
|
| DocDueDate |
datetime
'1/1/1900'
|
|
|
|
|
| DOCAMNT |
numeric(19,5)
0.00
|
Source Doc...(more) Join Now
|
PM10000.DOCAMNT
|
|
|
| DISCDATE |
datetime
'1/1/1900'
|
Discount D...(more) Join Now
|
PM10000.DISCDATE
|
|
|
| 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
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| Outstanding_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| Net_Paid_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| Selected_To_Print |
tinyint
0
|
|
|
|
|
| PONUMBER |
char
''
|
PO Number ...(more) Join Now
|
SEE30303.PONUMBER
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|