DynDeveloper.com

DynDeveloper.com

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

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..PM20400 Table Definition

(COMPANY..PM Scheduled Payments Header)

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_DESCchar(31)
GP 9
ORIG_DOC_NUMBERchar(21)
GP 9
ORIG_DOC_TYPEsmallint PAM30524.ORIG_DOC_TYPE
GP 9
ORIG_VOUCHER_NUMchar(21)
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM20400.VENDORID
SCH_DOC_DATEdatetime
GP 9
SCHEDULE_AMOUNTnumeric(19,5) RM30401.SCHEDULE_AMOUNT
GP 9
FuncSchAmntnumeric(19,5) RM30401.FuncSchAmnt
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM20400.CURNCYID
SCHEDULE_INT_TYPE1smallint
GP 9
SCHEDULE_INT_RATEint
GP 9
NUM_PAYMENTSsmallint
GP 9
PYMNT_FREQUENCYsmallint
GP 9
PAYMENT_AMOUNTnumeric(19,5) RM30401.PAYMENT_AMOUNT
GP 9
FIRST_INV_DOC_DATEdatetime
GP 9
FIRST_INV_DUE_DATEdatetime
GP 9
PAY_ACCT_IDXint
GP 9
PAY_OFFSET_ACCT_IDXint
GP 9
INT_EXP_ACCT_IDXint
GP 9
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = PM20400.NOTEINDX
Statussmallint Status Ind...(more) Join Now BM10400.Status
GP 9
CREDIT_MEMO_DOC_NUMchar(21)
GP 9
VADCDTROchar(15) Vendor Add...(more) Join Now
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9