Dynamics GP payment terms tableMicrosoft Dynamics GP accounts Payable manualDynamics GP Purchasing Invoice EntryDynamics GP Vendor Email Options tableBuild Payment Batch in great plains

Dynamics GP Table Reference - COMPANY..PM tables

文章推薦指數： 80 %
投票人數：10人

Dynamics GP Table Reference - COMPANY..PM tables. ... PM00100, PM Class Master File. PM00101, Vendor Class Accounts ... PM10400, PM Manual Payment WORK File. SearchtheGPTables SearchbyTABLENAME SearchbyFIELDNAME TheseareourPMscripts.AllofourscriptsforDynamicsGPcanbefoundhere PMScripts eConnect  taGetPMNextPaymentNumber  taGetPMNextVoucherNumberusageexample  taPMTransacitonInsertwrapper  taPMTransactionInsertWrapper,includingdistributions Functions  ddf_CommaSeparatedPOs  ddf_CommaSeparatedReceipts General  A/PDistributiontoGL-whenusingIntercompany  AllVendorsthatdonothavearecordinthetransactionaltables  insertmissinglinesintheVendorMasterPM00200  Moveadebitandcredittohistory  seePMAgedTB  seepmHATBWrapper  StoredprocedurethatmimicsthePayablesInquiry'Re-createcheckstub'button StoredProcedures  dd_PMApply_SEL  dd_PMVendorDocument_SEL Views  ddv_PayablesWithPOs ModuleList >ModuleCOMPANY..PMtables DynDeveloperTableReferenceisinWikiformat!Registeredusershavetheabilitytoimprovethetablereference,addcomments,andgenerallymaketheworldabetterplace. YouarecurrentlyviewingtheCOMPANY database.Change FreqUsed DisplayName  PM00100PMClassMasterFile Thisfileholdsallthevendorclasssetupinformation. Theprimarypurposeofaclassismakechangestoallvendorsinaclassquickly. TheinformationinthePMClassMasterissosimilartothePMVendorMasterthatitisnotrepeatedhere. The2fieldsthataredifferentaredocumentedbelow.InSBF,thistableisnotavailable.  PM00101VendorClassAccounts Thistableholdstheextrapurchasesaccountsforaclass.InSBF,thistableisnotavailable. PM00200PMVendorMasterFile  PM00201PMVendorMasterSummary ThePMVendorMasterSummarycontainssummaryinformationaboutthevendors. YTD,LastYear,&LTDtotalsaswellaslastamountsandhighestbalancesforthevendor. ItwouldnormallynotbeimportedintounlessyouwantedimportedlastyearsorLifeToDateinformationforcomparativepurposes. TheVendorMasterSummarytotalsforCurrentBalance,UnappliedPayments,UnpaidFinanceCharges,&OnOrderamountsarerecalculatedonreconcilingvendors  PM00202PMVendorMasterPeriodSummary Thisfilewouldnotnormallybeimportedinto. Anexceptionwouldbetoprovidetotalsforpreviousperiodsandyearsbeforedynamicswasusedforcomparativereportstocurrentdata.  PM00203VendorAccounts ThistableholdsadditionalpurchasingaccountsforaVendor.  PM00204Purchasing1099PeriodDetail Thisfilewouldnotnormallybeimportedinto. Anexceptionwouldbetoprovidetotalsforpreviousperiodsandyearsbeforedynamicswasusedforcomparativereportstocurrentdata. Thiscontains1099dataforeachcalendarperiodfromthePMVendorMasterPeriodSummarytableandbreaksthe1099amountintothespecific1099Typeand1099BoxNumber.  PM00300PMAddressMSTR ThePMAddressMasterholdsthePrimaryAddressIDaswellasadditionaladdressesfortheVendor. ThePrimaryAddressID(andanyadditionalID’s)fromtheVendorCardmustexistinthistable  PM00400PMKeyMasterFile ThePM_Key_MSTRtableisusedtovalidatetheuniquenessofcontrolnumbersinthesystem.Acombinationofthecontrolnumberandcontroltypeensureuniqueness.ThecontrolnumbersusedwithtransactionentryareVoucherNumber-Work,CashAmountPaymentNumber,CheckAmountPaymentNumber,andCreditCardAmountPaymentNumber.ThePM_Key_MSTRtablealsoisusedtoensureuniquenessfortheDocumentNumberandCheckNumber.ThePM_Key_MSTRtablewillcontainarecordforthenumbersitistracking,nomatteriftheyresideinwork,openorhistorytables.ArecordwillremaininthePM_Key_MSTRtableuntilalltransactiondataforthecontrolnumberitistrackinghasbeendeleted(i.e.thetransactionrecord,alldistributions,alltaxes).  Whenacontrolnumberisinitiallyentered,aPM_Key_MSTRtablerecordissavedwiththecontrolnumbertopreventanotheruserfromusingthesamecontrolnumber.ThiskeysrecordwillbegivenaDocumentStatusof0.Thismeansthecontrolnumberisreservedforusebyanunsavedworkrecord.Whenthetransactionrecordisactuallysaved,thisstatuswillbechangedto1.Asthetransactionmovesthroughthesystem,thisstatuschangestoreflectthecurrentlocation.TheotherDocumentStatussettingsare1forwork,2foropen,and3forhistory. InlieuofimportingintothePMKeyMastertable,transactionscanbeimportedintothePayablesTransactionWorktable,withanassociatedcontrolnumber,andchecklinksrunonthePayablesTransactionLogicaltable. ThiswillcreatethecorrespondingrecordinthePMKeyMastertable. DisplayName:             PMKeyMasterFile PhysicalName:           PM00400 AkeysrecordfortheVoucherNumber-WORKshouldbecreatedfirst. ThisrecordisalsousedtotrackDocumentNumberuniquenessifAllowDuplicateInvoicesoftablePM_SETPissettofalse.  PM09200   PM09300  FreqUsed DisplayName PM10000PMTransactionWORKFile ThePM_Transaction_WORKtablehasonerecordcreatedforeachtransactionentered.EachrecordisassignedtoarecordintheBatch_Headerstable.ThevendorID,shippingmethod,paymentterm,addressIDandtaxscheduleareverifiedusingtheirrespectivemastertables.TheVoucherNumber-WORKfieldcontainstheuniquenumberforthistransaction.NotwoidenticalvouchernumbersmayexistinthePM_Transaction_WORKtable.TheVoucherNumber-WORKfieldhasamaximumlengthof17characters,whiletheVoucherNumberfield,whichisusedforposteddocuments,hasamaximumlengthof20characters.Thisdifferenceallowsforrecurringtransactionstoretainthesamevouchernumberintheworktable,whilea3-characterextensionisaddedduringpostingtoensureuniquenessinthepostedtables.IftheAllowDuplicateInvoiceNumbersfieldinthePM_SETPtableissettofalse,theDocumentNumbermustbevalidatedforuniquenessbyreadingthePM_Key_MSTRtable.IfMulticurrencyisregisteredandtheCurrencyIDofthetransactiondoesnotmatchthefunctionalcurrencythentheMC_PM_Transactionstablewillalsocontainarecordforthistransaction.  DisplayName:             PMTransactionWork PhysicalName:           PM10000   PM10100PMDistributionWORKOPEN ArecordinPM_Distribution_WORK_OPENmustbecreatedforeachdistributionlineineachtransaction.EachamountinthePM_Transaction_WORKtableanditsrelatedamountintheMC_PM_Transactionstable,suchaspurchaseamount,freightamount,andcashamount,hasadistributioncreatedforit.Adistributiontypeisassignedbasedonwhichamountthedistributionisfor.Allamountsneedtobetakenintoconsiderationwhencreatingthedistributions,sinceatransactionwillnotpostiftheamountdistributedforatypedoesnotbalancewiththeamountsinthePM_Transaction_WORKandMC_PM_Transactionsrecords.Thebalancemustalsobeofthecorrectdebitorcreditbalance,dependentuponthetransactiontype.Theamountindicatedbythe'Other'distributiontypeisnotrelatedtoanyamountinthePM_Transaction_WORKorMC_PM_Transactionsrecords.ThistypepermitsbalancedadjustmentstoGeneralLedger.Thedebitamountmustequalthecreditamountforall'Other'typedistributionsforthetransactiontopost. YoucanalsoenterunitaccountswithadistributiontypeofUNIT.Theamountsenteredforunitaccountsdonotneedtobalance. Theyarenotvalidatedsincetheymayhavevaryingnumbersofdecimalplaces.(InSBF,youcannotenterunitaccounts.) AllamountsforthetransactionmustbeaccountedforinthePM_Distribution_WORK_OPENtable.Theremaybeanunlimitednumberofdistributionrecordsforeachtransaction.Bydefault,therewillbeonlyonedistributionperdistributiontype,buttheusermaysplitthatrecordintoanunlimitednumberofdistributionsaslongasthetotalforthatparticulartypeiscorrect. The"Other"distributiontypeisusefulforappendingnon-relateddistributionstothecurrenttransaction.ThesedistributionswillposttoGeneralLedgerwiththedistributionsforthecurrenttransaction.Dynamicsverifiesonlythatfor"Other"distributiontypes,debitsequalcredits.Thisallowsformaximumflexibilitywhilestillallowingtightverificationofthepostingforthetransaction. DisplayName:             PMDistributionWORKOPEN PhysicalName:           PM10100  PM10200PMApplyToWORKOPENFile OnelineforeachPAYMENTthathasapaymentandisnotfullypaid  PM10201PMPaymentApplyToWorkFile Onelineperpayment/voucher;bothworkandhistory  PM10300PMPaymentWORK PM10300unpostedAPPLYheader.OnlineperPAYMENT Apaymentrecordwillbe createdonlywhenacheckisprintedfromthetransactionentrywindow.Thesole purposeofthisrecordwillbetostorethecheckinformationforReport Writer.Ifyoudonotprintanychecksfromthetransactionentrywindow,you willnotneedtocreateanyrecordsforthistable.   Ifanalignmentformisprinted,Dynamicswillsetvalues onlyforfieldsneededforkeysandotherrequiredfields.Allotherfields willbefilledwithmaximumvaluesforamountfieldsorstringsofX'sfor stringfields.  PM10400PMManualPaymentWORKFile The PM_Manual_Payment_WORKtableistheprimarystorageareaformanualpayments. ItcontainsfieldslinkingittotheBatch_Headerstablewherebatch informationisstored,tothePM_Keys_MSTRtablewhereusedpaymentnumbersare stored,andtotheCM_Checkbook_MSTRtablewhereDocumentNumbersarestored. AllofthesetablesmustbemaintainedastoensureuniquecontrolIDvalues. IfMulticurrencyisregisteredandtheCurrencyIDofthepaymentdoesnot matchthefunctionalcurrencythentheMC_PM_Transactionstablewillalso containarecordforthispayment.  PM10500PMTaxWorkFile Recordsinthistable containthedetailedtaxinformationassociatedwiththetransaction.These recordsarecreatedonlyiftaxeshavebeencomputedforthetransaction.They mustbalancetothetotalamountoftaxescalculatedforthistransaction.   Thistablecontainsall ofthetaxdetailrecordsthatneedtobedistributedforthedocument.The totalofalltheserecordsmustbeequaltotheamountoftaxinthe'Tax Amount'fieldinthePM_Transaction_WORKtable(withtheexceptionof'Tax IncludedWithItemPrice'details).Theremaybeanunlimitednumberoftax distributionrecordsusedtodistributethetaxamountforanygiven transaction.Postingrequiresthattheamountenteredintothe'TaxAmount' field(plusanybackoutamounts)mustbeaccountedforinthedistributions. Also,postingdoesnotverifythatthetaxschedulesarestillvalidatthe timeofposting;ratheritverifiesthattheTaxDetailIDsarestillvalidat thetimeofposting.  PM10600PMDistributionVoidWORKTemporaryFile  PM10801PMPaymentStubDuplicate  PM10900VoidPaymentWORKTemporaryFile  PM10901PMVoidTransactionWORKTemporaryFile  PM10902PMTaxVoidWorkTemporaryFile FreqUsed DisplayName PM20000PMTransactionOPENFile PM20100PMApplyToOPENOPENTemporaryFile PM20100unpostedAPPLYdetail  PM20200PMDistributionOPENOPENTemporaryFile  PM20400PMScheduledPaymentsHeader  PM20401PMScheduledPaymentLINE FreqUsed DisplayName PM30200PMPaidTransactionHistoryFile PM30300PMApplyToHistoryFile  PM30401PMScheduledPaymentsHeaderHistory PM30600PMDistributionHistoryFile  PM30700PMTaxHistoryFile  PM30800PMTaxInvoices FreqUsed DisplayName  PM40100PMSetupFile  PM40101PMPeriodSetupFile  PM40102PayablesDocumentTypes  PM40103PayablesDistributionTypeSETP  PM40104PM1099SetupFile  PM50100PMHistoryRemovalTempoaryFile  PM50503   PM50504   PM70500PurchasingReportOptions  PM80100ReprintTransactionBatchHeaders  PM80200VoidReprintVoidPaymentWORK  PM80300PMReprintVoidTransactionWORK  PM80500PMReprintPostingJournalApplyToFile  PM80600PMReprintDistribution  PM80700PMReprintTax  PM80800PMReprintTransactionCheckRegisterFile  PM80900PMMassVoucherApplyTempFile  PM80905PayablesApplyDocumentBrowse  PM80950PMRemittanceTemp  PM80960PMExceptionListTemp  PM81000ModifiedVendorClassAccounts TableDefinitionQuickLinks AllTables SOPTables RMTables GLTables POPTables HRTables PMTables UPRTables IVTables OlympicTables 3

請為這篇文章評分？

延伸文章資訊