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 > PM10300

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

(COMPANY..PM Payment WORK)

PM10300 unposted APPLY header. On line per PAYMENT

A payment record will be created only when a check is printed from the transaction entry window. The sole purpose of this record will be to store the check information for Report Writer. If you do not print any checks from the transaction entry window, you will not need to create any records for this table.

 

If an alignment form is printed, Dynamics will set values only for fields needed for keys and other required fields. All other fields will be filled with maximum values for amount fields or strings of X's for string fields.


4Penny.net

Field Definitions:

What is the 'source' column?

Column NameData Type
Default Value
 Source
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
PMNTNMBR char(21)
''
Payment Nu...(more) Join Now
CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now
DOCNUMBR char(21)
''
Document N...(more) Join Now
APPLDAMT numeric(19,5)
0.00
Applied Am...(more) Join Now
CURTRXAM numeric(19,5)
0.00
Current Tr...(more) Join Now
CHEKTOTL numeric(19,5)
0.00
Check Tota...(more) Join Now
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
VENDNAME char(65)
''
Vendor Nam...(more) Join Now
COMMENT1 char(31)
''
Comment1: ...(more) Join Now
ADDRESS1 char(61)
''
Address 1:...(more) Join Now
ADDRESS2 char(61)
''
Address 2:...(more) Join Now
ADDRESS3 char(61)
''
Address 3:...(more) Join Now
CITY char(35)
''
City: Chec...(more) Join Now
STATE char(29)
''
State: Che...(more) Join Now
ZIPCODE char(11)
''
Zip Code: ...(more) Join Now
COUNTRY char(61)
''
Country: ...(more) Join Now
VNDCHKNM char(65)
''
Vendor Che...(more) Join Now
SOURCDOC char(11)
''
Source Doc...(more) Join Now
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
DISAMTAV 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
VOIDED tinyint
0
Voided: C...(more) Join Now
REPRNTED smallint
0
Reprinted:...(more) Join Now
GSTDSAMT numeric(19,5)
0.00
GST Discou...(more) Join Now
PGRAMSBJ smallint
0
Percent Of...(more) Join Now
PPSTAXRT smallint
0
PPS Tax Ra...(more) Join Now
PPSAMDED numeric(19,5)
0.00
PPS Amount...(more) Join Now
LDOCRMTC smallint
0
List Docum...(more) Join Now
SDORMBY smallint
0
Sort Docum...(more) Join Now
KEYFIELD char(21)
''
Key Field:...(more) Join Now
AMWDSNBR char(61)
''
Amount in ...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now
CNTRLTYP smallint
0
Control Ty...(more) Join Now
DOCTYPE smallint
0
Document T...(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
PSTGSTUS smallint
0
Posting St...(more) Join Now
POSTEDDT datetime
'1/1/1900'
Posted Dat...(more) Join Now
PTDUSRID char(15)
''
Posted Use...(more) Join Now
PMWRKMSG binary(4)
0
PM WORK Me...(more) Join Now
PMWRKMS2 binary(4)
0
PM WORK M...(more) Join Now
PMDSTMSG binary(4)
0
PM Distrib...(more) Join Now
CHKCOMNT char(61)
''
Check Comm...(more) Join Now
PSTGDATE datetime
'1/1/1900'

STRGA255 char(255)
''
String A 2...(more) Join Now
STRGB255 char(255)
''
String B 2...(more) Join Now
SEPRMTNC tinyint
0
Separate R...(more) Join Now
STBOVRFL tinyint
0
Stub Overf...(more) Join Now
CTYSTZIP char(47)
''
City-State...(more) Join Now
TotDocAmt numeric(19,5)
0.00
Total Docu...(more) Join Now
TotAmtPaid numeric(19,5)
0.00
Total Amou...(more) Join Now
TotCrdAmt numeric(19,5)
0.00
Total Cred...(more) Join Now
TotalPaidTot numeric(19,5)
0.00
Total Paid...(more) Join Now
TotNegTot numeric(19,5)
0.00
Total Nega...(more) Join Now
TotCrdDocAmt numeric(19,5)
0.00
Total Cred...(more) Join Now
TotTotDocAmt numeric(19,5)
0.00
Total Tota...(more) Join Now
TotDiscTknAmt numeric(19,5)
0.00
Total Disc...(more) Join Now
TotWOAmt numeric(19,5)
0.00
Total Writ...(more) Join Now
TotPPSAmtDed numeric(19,5)
0.00
Total PPS ...(more) Join Now
TotGSTDiscAmt numeric(19,5)
0.00
Total GST ...(more) Join Now
TotDiscTknTot numeric(19,5)
0.00
Total Disc...(more) Join Now
TotWOTot numeric(19,5)
0.00
Total Writ...(more) Join Now
Outstanding_Amount numeric(19,5)
0.00
Outstandin...(more) Join Now
Net_Paid_Amount numeric(19,5)
0.00
Net Amount...(more) Join Now
Electronic tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
PONUMBER char
''
PO Number ...(more) Join Now SEE30303.PONUMBER
CARDNAME char
''

AMTINWDS text

Amount in ...(more) Join Now
PYENTTYP smallint
''







Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables