DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Module List > Module PM tables > PM20401

DynDeveloper Table Reference is now in Wiki format! Registered users have the ability to improve the table reference, add comments, and make the world a better place
You are currently viewing the COMPANY database.
Change

COMPANY..PM20401 Table Definition

(COMPANY..PM Scheduled Payment LINE)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
SCHEDULE_NUMBERchar(21) B3920401.SCHEDULE_NUMBER
GP 9
Schedule_Payment_Numbersmallint
GP 9
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
PAYMENT_AMOUNTnumeric(19,5) RM30401.PAYMENT_AMOUNT
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM20401.VENDORID
INTEREST_AMOUNTnumeric(19,5) RM20401.INTEREST_AMOUNT
GP 9
PRINCIPAL_AMOUNTnumeric(19,5) RM20401.PRINCIPAL_AMOUNT
GP 9
PRINCIPAL_BALANCEnumeric(19,5) RM20401.PRINCIPAL_BALANCE
GP 9
DOCDATEdatetime The date a...(more) Join Now
GP 9
DUEDATEdatetime Due Date: ...(more) Join Now PM10000.DUEDATE
GP 9
Statussmallint Status Ind...(more) Join Now BM10400.Status
GP 9
MARKEDtinyint PAM10525.MARKED
GP 9
MKDBYUSRchar(15) RVLPD026.MKDBYUSR
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9