Module List > Module RM tables RM20401
You are currently viewing the COMPANY database.
Change

COMPANY..RM20401 Table Definition

(COMPANY..RM Scheduled Payment Line)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SCHEDULE_NUMBER char(21)
''

DOCNUMBR char(21)
''
Document N...(more) Join Now
Schedule_Payment_Number smallint
0

CUSTNMBR char(15)
''
Customer I...(more) Join Now
join ... more text available
PAYMENT_AMOUNT numeric(19,5)
0.00

INTEREST_AMOUNT numeric(19,5)
0.00

PRINCIPAL_AMOUNT numeric(19,5)
0.00

PRINCIPAL_BALANCE numeric(19,5)
0.00

DUEDATE datetime
'1/1/1900'
Due Date: ...(more) Join Now PM10000.DUEDATE
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
Status smallint
0
Status Ind...(more) Join Now BM10400.Status
MARKED tinyint
0

MKDBYUSR 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