Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

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

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

COMPANY..PM10200 Table Definition

(COMPANY..PM Apply To WORK OPEN File)
One line for each PAYMENT that has a payment and is not fully paid
4Penny.net

Field Definitions:

What is the 'source' column?

Column NameData Type
Default Value
 Source
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
DATE1 datetime
'1/1/1900'
The date o...(more) Join Now
GLPOSTDT datetime
'1/1/1900'
Date that ...(more) Join Now
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now WO010213.TIME1
APTVCHNM char(21)
''
Apply To V...(more) Join Now
APTODCTY smallint
0
Apply To D...(more) Join Now
APTODCNM char(21)
''
Apply To D...(more) Join Now RM20201.APTODCNM
APTODCDT datetime
'1/1/1900'
Apply To D...(more) Join Now
ApplyToGLPostDate datetime
'1/1/1900'
Apply To G...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
APPLDAMT numeric(19,5)
0.00
Applied Am...(more) Join Now
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
DISAVTKN numeric(19,5)
0.00
Discount A...(more) Join Now
WROFAMNT numeric(19,5)
0.00
Write Off ...(more) Join Now
ORAPPAMT numeric(19,5)
0.00
Originatin...(more) Join Now
ORDISTKN numeric(19,5)
0.00
Orig Disco...(more) Join Now
ORDATKN numeric(19,5)
0.00
Orig Disco...(more) Join Now
ORWROFAM numeric(19,5)
0.00
Originatin...(more) Join Now
APTOEXRATE numeric(19,7)
0.00
Exchange R...(more) Join Now
APTODENRATE numeric(19,7)
0.00
Denominati...(more) Join Now
APTORTCLCMETH smallint
0
Rate Calcu...(more) Join Now
APTOMCTRXSTT smallint
0
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
ApplyFromGLPostDate datetime
'1/1/1900'
Apply From...(more) Join Now
FROMCURR char(15)
''
Currency I...(more) Join Now
APFRMAPLYAMT numeric(19,5)
0.00
Functional...(more) Join Now
APFRMDISCTAKEN numeric(19,5)
0.00
Functional...(more) Join Now
APFRMDISCAVAIL numeric(19,5)
0.00
Functional...(more) Join Now
APFRMWROFAMT numeric(19,5)
0.00
Functional...(more) Join Now
ActualApplyToAmount numeric(19,5)
0.00
Actual App...(more) Join Now
ActualDiscTakenAmount numeric(19,5)
0.00
Actual Dis...(more) Join Now
ActualDiscAvailTaken numeric(19,5)
0.00
Actual Dis...(more) Join Now
ActualWriteOffAmount numeric(19,5)
0.00
Actual Wri...(more) Join Now
APFRMEXRATE numeric(19,7)
0.00
Apply From...(more) Join Now
APFRMDENRATE numeric(19,7)
0.00
Denominati...(more) Join Now
APFRMRTCLCMETH smallint
0
Apply From...(more) Join Now
APFRMMCTRXSTT smallint
0
Apply From...(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
POSTED tinyint
0
Posted: A...(more) Join Now
TEN99AMNT numeric(19,5)
0.00
1099 Amoun...(more) Join Now
RLGANLOS numeric(19,5)
0.00
Realized G...(more) Join Now
APYFRMRNDAMT numeric(19,5)
0.00
Round Amou...(more) Join Now
APYTORNDAMT numeric(19,5)
0.00
Round Amou...(more) Join Now
APYTORNDDISC numeric(19,5)
0.00
Round Disc...(more) Join Now
OAPYFRMRNDAMT numeric(19,5)
0.00
Originatin...(more) Join Now
OAPYTORNDAMT numeric(19,5)
0.00
Originatin...(more) Join Now
OAPYTORNDDISC numeric(19,5)
0.00
Originatin...(more) Join Now
Settled_Gain_CreditCurrT numeric(19,5)
0.00
Settled Ga...(more) Join Now
Settled_Loss_CreditCurrT numeric(19,5)
0.00
Settled Lo...(more) Join Now
Settled_Gain_DebitCurrTr numeric(19,5)
0.00
Settled Ga...(more) Join Now
Settled_Loss_DebitCurrTr numeric(19,5)
0.00
Settled Lo...(more) Join Now
Settled_Gain_DebitDiscAv numeric(19,5)
0.00
Settled Ga...(more) Join Now
Settled_Loss_DebitDiscAv numeric(19,5)
0.00
Settled Lo...(more) Join Now
Revaluation_Status smallint
0
Revaluatio...(more) Join Now
Credit1099Amount numeric(19,5)
0.00
1099 Amoun...(more) Join Now
DEFTEN99TYPE smallint
0
Default 10...(more) Join Now
DEFTEN99BOXNUMBER smallint
0
Default 10...(more) Join Now
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