DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Transaction WORK File)

The PM_Transaction_WORK table has one record created for each transaction entered. Each record is assigned to a record in the Batch_Headers table. The vendor ID, shipping method, payment term, address ID and tax schedule are verified using their respective master tables. The Voucher Number - WORK field contains the unique number for this transaction. No two identical voucher numbers may exist in the PM_Transaction_WORK table. The Voucher Number - WORK field has a maximum length of 17 characters, while the Voucher Number field, which is used for posted documents, has a maximum length of 20 characters. This difference allows for recurring transactions to retain the same voucher number in the work table, while a 3-character extension is added during posting to ensure uniqueness in the posted tables. If the Allow Duplicate Invoice Numbers field in the PM_SETP table is set to false, the Document Number must be validated for uniqueness by reading the PM_Key_MSTR table. If Multicurrency is registered and the Currency ID of the transaction does not match the functional currency then the MC_PM_Transactions table will also contain a record for this transaction.

 Display Name:              PM Transaction Work

Physical Name:            PM10000

 


4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
BACHNUMBchar(15) Batch Numb...(more) Join Now
GP 9
join SY00500 on SY00500.BACHNUMB = PM10000.BACHNUMB
BCHSOURCchar(15) Batch Sour...(more) Join Now
GP 9
VCHNUMWKchar(17) Voucher Nu...(more) Join Now
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM10000.VENDORID
DOCNUMBRchar(21) Document N...(more) Join Now
GP 9
DOCTYPEsmallint Document T...(more) Join Now
GP 9
SOURCDOCchar(11) Source Doc...(more) Join Now
GP 9
DOCAMNTnumeric(19,5) Document A...(more) Join Now
GP 9
DOCDATEdatetime Document D...(more) Join Now
GP 9
PSTGDATEdatetime Posting Da...(more) Join Now
GP 9
VADDCDPRchar(15) Vendor Add...(more) Join Now
GP 9
VADCDTROchar(15) Vendor Add...(more) Join Now
GP 9
PYMTRMIDchar(21) Payment Te...(more) Join Now
GP 9
join SY03300 on SY03300.PYMTRMID = PM10000.PYMTRMID
TAXSCHIDchar(15) Tax Schedu...(more) Join Now
GP 9
join TX00101 on TX00101.TAXSCHID = PM10000.TAXSCHID
DUEDATEdatetime Due Date: ...(more) Join Now
GP 9
DSCDLRAMnumeric(19,5) Discount D...(more) Join Now
GP 9
DISCDATEdatetime Discount D...(more) Join Now
GP 9
PRCHAMNTnumeric(19,5) Purchases ...(more) Join Now
GP 9
CHRGAMNTnumeric(19,5) Charge Amo...(more) Join Now
GP 9
CASHAMNTnumeric(19,5) Cash Amoun...(more) Join Now
GP 9
CAMCBKIDchar(15) Cash Amoun...(more) Join Now
GP 9
CDOCNMBRchar(21) Cash Docum...(more) Join Now
GP 9
CAMTDATEdatetime Cash Amoun...(more) Join Now
GP 9
CAMPMTNMchar(21) Cash Amoun...(more) Join Now
GP 9
CHEKAMNTnumeric(19,5) Check Amou...(more) Join Now
GP 9
CHAMCBIDchar(15) Check Amou...(more) Join Now
GP 9
CHEKDATEdatetime Check Date...(more) Join Now
GP 9
CAMPYNBRchar(21) Check Amou...(more) Join Now
GP 9
CRCRDAMTnumeric(19,5) Credit Car...(more) Join Now
GP 9
CCAMPYNMchar(21) Credit Car...(more) Join Now
GP 9
CHEKNMBRchar(21) Check Numb...(more) Join Now
GP 9
CARDNAMEchar(15) Card Name:...(more) Join Now
GP 9
CCRCTNUMchar(21) Credit Car...(more) Join Now
GP 9
CRCARDDTdatetime Credit Car...(more) Join Now
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM10000.CURNCYID
CHEKBKIDchar(15) Checkbook ID Checkbook this transaction affects PAM22222.CHEKBKID
GP 9
join CM00100 on CM00100.CHEKBKID = PM10000.CHEKBKID
TRXDSCRNchar(31) Transactio...(more) Join Now
GP 9
UN1099AMnumeric(19,5) Unapplied ...(more) Join Now
GP 9
TRDISAMTnumeric(19,5) Trade Disc...(more) Join Now
GP 9
TAXAMNTnumeric(19,5) Tax Amount...(more) Join Now
GP 9
FRTAMNTnumeric(19,5) Freight Am...(more) Join Now
GP 9
TEN99AMNTnumeric(19,5) 1099 Amoun...(more) Join Now
GP 9
MSCCHAMTnumeric(19,5) Misc Charg...(more) Join Now
GP 9
PORDNMBRchar(21) Purchase O...(more) Join Now
GP 9
SHIPMTHDchar(15) Shipping M...(more) Join Now
GP 9
join SY03000 on SY03000.SHIPMTHD = PM10000.SHIPMTHD
DISAMTAVnumeric(19,5) Discount A...(more) Join Now
GP 9
DISTKNAMnumeric(19,5) Discount T...(more) Join Now
GP 9
APDSTKAMnumeric(19,5) Applied Di...(more) Join Now
GP 9
WROFAMNTnumeric(19,5) Write Off ...(more) Join Now
GP 9
CURTRXAMnumeric(19,5) Current Tr...(more) Join Now
GP 9
TXENGCLDtinyint Tax Engine...(more) Join Now
GP 9
PMWRKMSGbinary(4) PM WORK Me...(more) Join Now
GP 9
PMDSTMSGbinary(4) PM Distrib...(more) Join Now
GP 9
GSTDSAMTnumeric(19,5) GST Discou...(more) Join Now
GP 9
PGRAMSBJsmallint Percent Of...(more) Join Now
GP 9
PPSAMDEDnumeric(19,5) PPS Amount...(more) Join Now
GP 9
PPSTAXRTsmallint PPS Tax Ra...(more) Join Now
GP 9
PSTGSTUSsmallint Posting St...(more) Join Now
GP 9
POSTEDtinyint Posted: A...(more) Join Now
GP 9
APPLDAMTnumeric(19,5) Applied Am...(more) Join Now
GP 9
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
CNTRLTYPsmallint Control Ty...(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 = PM10000.MDFUSRID
POSTEDDTdatetime Posted Dat...(more) Join Now
GP 9
PTDUSRIDchar(15) Posted Use...(more) Join Now
GP 9
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = PM10000.NOTEINDX
BKTFRTAMnumeric(19,5) Backout Fr...(more) Join Now
GP 9
BKTMSCAMnumeric(19,5) Backout Mi...(more) Join Now
GP 9
BKTPURAMnumeric(19,5) Backout Pu...(more) Join Now
GP 9
PCHSCHIDchar(15) Purchase S...(more) Join Now
GP 9
FRTSCHIDchar(15) Freight ...(more) Join Now
GP 9
join TX00101 on TX00101.FRTSCHID = PM10000.FRTSCHID
MSCSCHIDchar(15) Misc Sched...(more) Join Now
GP 9
join TX00101 on TX00101.MSCSCHID = PM10000.MSCSCHID
PRINTEDtinyint Printed: ...(more) Join Now
GP 9
PRCTDISCsmallint Percent Di...(more) Join Now
GP 9
RETNAGAMnumeric(19,5) Retainage ...(more) Join Now
GP 9
ICTRXtinyint IC TRX: Im...(more) Join Now
GP 9
ICDISTStinyint ICDists: I...(more) Join Now
GP 9
PMICMSGSbinary(4) ICMessages...(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
CORRNXSTtinyint Correction...(more) Join Now
GP 9
VCHRNCORchar(21) Voucher Nu...(more) Join Now
GP 9
PMWRKMS2binary(4) PM Work Me...(more) Join Now
GP 9
BNKRCAMTnumeric(19,5) Bank Recei...(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
BackoutTradeDiscnumeric(19,5) Backout Tr...(more) Join Now
GP 9
CBVATtinyint Cash Based...(more) Join Now
GP 9
TEN99TYPEsmallint 1099 Type:...(more) Join Now
GP 10
TEN99BOXNUMBERsmallint 1099 Box N...(more) Join Now
GP 10
Workflow_Statussmallint
GP 2016
DEX_ROW_TSdatetime Time Stamp...(more) Join Now
GP 10
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9