DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
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
Module List > Module PM tables PM20100
You are currently viewing the COMPANY database.
Change

COMPANY..PM20100 Table Definition

(COMPANY..PM Apply To OPEN OPEN Temporary File)
PM20100 unposted APPLY detail
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
KEYSOURC char(41)
''
System gen...(more) Join Now
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now WO010213.TIME1
VENDORID char(15)
''
Vendor ID ...(more) Join Now
join ... more text available
POSTED tinyint
0
Posted: A...(more) Join Now
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
APTVCHNM char(21)
''
Apply To V...(more) Join Now
APTODCTY smallint
0
Apply To D...(more) Join Now
APTODCDT datetime
'1/1/1900'
Apply To D...(more) Join Now
APTODCNM char(21)
''
Apply To D...(more) Join Now RM20201.APTODCNM
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
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
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
Apply_To_Document_Amount numeric(19,5)
0.00
Apply To D...(more) Join Now
Apply_To_Orig_Doc_Amount numeric(19,5)
0.00
Apply To O...(more) Join Now
Apply_To_Discount_Date datetime
'1/1/1900'
Apply To D...(more) Join Now
Apply_To_Due_Date datetime
'1/1/1900'
Apply To D...(more) Join Now
Apply_To_Description char(31)
''
Apply To D...(more) Join Now
Apply_To_IS_MC_Trx smallint
0
Apply To i...(more) Join Now
ApplyToGLPostDate datetime
'1/1/1900'
Apply To G...(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
ISMCTRX smallint
0
Field Type...(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
FROMCURR char(15)
''
Currency I...(more) Join Now
Apply_From_Document_Amou numeric(19,5)
0.00
Document A...(more) Join Now
Apply_From_Orig_Doc_Amou numeric(19,5)
0.00
Originatin...(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
Apply_From_Description char(31)
''
Apply From...(more) Join Now
Apply_From_IS_MC_Trx 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
UPDTKNAM numeric(19,5)
0.00
Unposted D...(more) Join Now
UPGSTDAM numeric(19,5)
0.00
 Unpo...(more) Join Now
UNPPPSAD numeric(19,5)
0.00
span style...(more) Join Now
UPWROFAM numeric(19,5)
0.00
Unposted W...(more) Join Now
PMDSTMSG binary(4)
0
PM Distrib...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
MDFUSRID char(15)
''
User that ...(more) Join Now
join ... more text available
POSTEDDT datetime
'1/1/1900'
Posted Dat...(more) Join Now
PTDUSRID char(15)
''
Posted Use...(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
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now
DECPLCUR smallint
0
 DECPLCUR –...(more) Join Now
RATECALC smallint
0
Rate Calc ...(more) Join Now
Payment_To_Print_On_Stub char(21)
''
Payment To...(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
VADCDTRO char(15)
''
Vendor Add...(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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3