DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Paid Transaction History File)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM30200.VENDORID
DOCTYPEsmallint Document T...(more) Join Now
GP 9
DOCDATEdatetime The date a...(more) Join Now
GP 9
DOCNUMBRchar(21) Document N...(more) Join Now PM10000.DOCNUMBR
GP 9
DOCAMNTnumeric(19,5) Source Doc...(more) Join Now PM10000.DOCAMNT
GP 9
CURTRXAMnumeric(19,5) Current Tr...(more) Join Now PM10000.CURTRXAM
GP 9
DISTKNAMnumeric(19,5) Discount T...(more) Join Now
GP 9
DISCAMNTnumeric(19,5) PAM60501.DISCAMNT
GP 9
DSCDLRAMnumeric(19,5) Discount D...(more) Join Now
GP 9
BACHNUMBchar(15) Batch Numb...(more) Join Now
GP 9
join SY00500 on SY00500.BACHNUMB = PM30200.BACHNUMB
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
BCHSOURCchar(15) Batch Sour...(more) Join Now
GP 9
DISCDATEdatetime Discount D...(more) Join Now PM10000.DISCDATE
GP 9
DUEDATEdatetime Due Date: ...(more) Join Now PM10000.DUEDATE
GP 9
PORDNMBRchar(21) Purchase O...(more) Join Now
GP 9
TEN99AMNTnumeric(19,5) 1099 Amoun...(more) Join Now
GP 9
WROFAMNTnumeric(19,5) Write Off ...(more) Join Now
GP 9
DISAMTAVnumeric(19,5) Discount A...(more) Join Now
GP 9
TRXDSCRNchar(31) Transactio...(more) Join Now
GP 9
UN1099AMnumeric(19,5) Unapplied ...(more) Join Now
GP 9
BKTPURAMnumeric(19,5) Backout Pu...(more) Join Now
GP 9
BKTFRTAMnumeric(19,5) Backout Fr...(more) Join Now
GP 9
BKTMSCAMnumeric(19,5) Backout Mi...(more) Join Now
GP 9
VOIDEDtinyint Voided TRU...(more) Join Now CM20100.VOIDED
GP 9
HOLDtinyint Hold: 1 i...(more) Join Now RM00101.HOLD
GP 9
CHEKBKIDchar(15) Checkbook ID Checkbook this transaction affects PAM22222.CHEKBKID
GP 9
join CM00100 on CM00100.CHEKBKID = PM30200.CHEKBKID
DINVPDOFdatetime Date Invoi...(more) Join Now PM20000.DINVPDOF
GP 9
PPSAMDEDnumeric(19,5) PPS Amount...(more) Join Now
GP 9
PPSTAXRTsmallint PPS Tax Ra...(more) Join Now
GP 9
PGRAMSBJsmallint Percent Of...(more) Join Now
GP 9
GSTDSAMTnumeric(19,5) GST Discou...(more) Join Now
GP 9
POSTEDDTdatetime Posted Dat...(more) Join Now
GP 9
PTDUSRIDchar(15) Posted Use...(more) Join Now
GP 9
MODIFDTdatetime Date the r...(more) Join Now
GP 9
MDFUSRIDchar(15) User that ...(more) Join Now
GP 9
join DYNAMICS..SY01400 on SY01400.USERID = PM30200.MDFUSRID
PYENTTYPsmallint
GP 9
CARDNAMEchar(15) Card Name:...(more) Join Now PM10000.CARDNAME
GP 9
PRCHAMNTnumeric(19,5) Purchases ...(more) Join Now
GP 9
TRDISAMTnumeric(19,5) Trade Disc...(more) Join Now
GP 9
MSCCHAMTnumeric(19,5) Misc Charg...(more) Join Now
GP 9
FRTAMNTnumeric(19,5) Freight Am...(more) Join Now
GP 9
TAXAMNTnumeric(19,5) Tax Amount...(more) Join Now
GP 9
TTLPYMTSnumeric(19,5) Total Paym...(more) Join Now
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM30200.CURNCYID
PYMTRMIDchar(21) Payment Te...(more) Join Now PM10000.PYMTRMID
GP 9
join SY03300 on SY03300.PYMTRMID = PM30200.PYMTRMID
SHIPMTHDchar(15) Shipping M...(more) Join Now
GP 9
join SY03000 on SY03000.SHIPMTHD = PM30200.SHIPMTHD
TAXSCHIDchar(15) Tax Schedu...(more) Join Now PM10000.TAXSCHID
GP 9
join TX00101 on TX00101.TAXSCHID = PM30200.TAXSCHID
PCHSCHIDchar(15) Purchase S...(more) Join Now
GP 9
FRTSCHIDchar(15) Freight ...(more) Join Now
GP 9
join TX00101 on TX00101.FRTSCHID = PM30200.FRTSCHID
MSCSCHIDchar(15) Misc Sched...(more) Join Now
GP 9
join TX00101 on TX00101.MSCSCHID = PM30200.MSCSCHID
PSTGDATEdatetime Posting Da...(more) Join Now PM10000.PSTGDATE
GP 9
DISAVTKNnumeric(19,5) Discount A...(more) Join Now
GP 9
CNTRLTYPsmallint Control Ty...(more) Join Now
GP 9
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = PM30200.NOTEINDX
PRCTDISCsmallint Percent Di...(more) Join Now
GP 9
RETNAGAMnumeric(19,5) Retainage ...(more) Join Now
GP 9
VOIDPDATEdatetime Void GL Po...(more) Join Now CM20300.VOIDPDATE
GP 9
ICTRXtinyint IC TRX: Im...(more) Join Now
GP 9
Tax_Datedatetime Tax Date: ...(more) Join Now
GP 9
PRCHDATEdatetime Purchase D...(more) Join Now
GP 9
CORRCTNtinyint Correction...(more) Join Now
GP 9
SIMPLIFDtinyint Simplified...(more) Join Now
GP 9
APLYWITHtinyint Apply With...(more) Join Now
GP 9
Electronictinyint Electronic...(more) Join Now
GP 9
ECTRXtinyint EC Transac...(more) Join Now
GP 9
DocPrintedtinyint DocPrinted...(more) Join Now
GP 9
TaxInvReqdtinyint Tax Invoic...(more) Join Now
GP 9
VNDCHKNMchar(65) Vendor Che...(more) Join Now
GP 9
BackoutTradeDiscnumeric(19,5) Backout Tr...(more) Join Now
GP 9
CBVATtinyint Cash Based...(more) Join Now
GP 9
VADCDTROchar(15) Vendor Add...(more) Join Now
GP 9
TEN99TYPEsmallint 1099 Type:...(more) Join Now
GP 10
TEN99BOXNUMBERsmallint 1099 Box N...(more) Join Now
GP 10
PONUMBERchar PAM_VMS_MAPPINGS.PONumber
GP 2013
DEX_ROW_TSdatetime Time Stamp...(more) Join Now
GP 10
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9
Workflow_Statussmallint
GP 2016