DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Distribution WORK OPEN)

A record in PM_Distribution_WORK_OPEN must be created for each distribution line in each transaction. Each amount in the PM_Transaction_WORK table and its related amount in the MC_PM_Transactions table, such as purchase amount, freight amount, and cash amount, has a distribution created for it. A distribution type is assigned based on which amount the distribution is for. All amounts need to be taken into consideration when creating the distributions, since a transaction will not post if the amount distributed for a type does not balance with the amounts in the PM_Transaction_WORK and MC_PM_Transactions records. The balance must also be of the correct debit or credit balance, dependent upon the transaction type. The amount indicated by the 'Other' distribution type is not related to any amount in the PM_Transaction_WORK or MC_PM_Transactions records. This type permits balanced adjustments to General Ledger. The debit amount must equal the credit amount for all 'Other' type distributions for the transaction to post.  You can also enter unit accounts with a distribution type of UNIT. The amounts entered for unit accounts do not need to balance.  They are not validated since they may have varying numbers of decimal places. (In SBF, you cannot enter unit accounts.)

All amounts for the transaction must be accounted for in the PM_Distribution_WORK_OPEN table. There may be an unlimited number of distribution records for each transaction. By default, there will be only one distribution per distribution type, but the user may split that record into an unlimited number of distributions as long as the total for that particular type is correct.

The "Other" distribution type is useful for appending non-related distributions to the current transaction. These distributions will post to General Ledger with the distributions for the current transaction. Dynamics verifies only that for "Other" distribution types, debits equal credits. This allows for maximum flexibility while still allowing tight verification of the posting for the transaction.

Display Name:              PM Distribution WORK OPEN

Physical Name:            PM10100


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
DSTSQNUMint Distributi...(more) Join Now
GP 9
CNTRLTYPsmallint Control Ty...(more) Join Now
GP 9
CRDTAMNTnumeric(19,5) Credit Amo...(more) Join Now
GP 9
DEBITAMTnumeric(19,5) Debit Amou...(more) Join Now
GP 9
DSTINDXint Distributi...(more) Join Now
GP 9
DISTTYPEsmallint Distributi...(more) Join Now
GP 9
CHANGEDtinyint Changed: ...(more) Join Now
GP 9
USERIDchar(15) The user t...(more) Join Now
GP 9
join DYNAMICS..SY01400 on SY01400.USERID = PM10100.USERID
PSTGSTUSsmallint Posting St...(more) Join Now
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM10100.VENDORID
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
PSTGDATEdatetime Posting Da...(more) Join Now
GP 9
INTERIDchar(5) Intercompa...(more) Join Now
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM10100.CURNCYID
CURRNIDXsmallint Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURRNIDX = PM10100.CURRNIDX
ORCRDAMTnumeric(19,5) Originatin...(more) Join Now
GP 9
ORDBTAMTnumeric(19,5) Originatin...(more) Join Now
GP 9
APTVCHNMchar(21)
GP 9
APTODCTYsmallint
GP 9
SPCLDISTsmallint Specialize...(more) Join Now
GP 9
DistRefchar(31) Distributi...(more) Join Now
GP 9
RATETPIDchar(15) Rate Type ...(more) Join Now
GP 9
EXGTBLIDchar(15) Exchange T...(more) Join Now
GP 9
XCHGRATEnumeric(19,7) Exchange R...(more) Join Now
GP 9
EXCHDATEdatetime Exchange D...(more) Join Now
GP 9
TIME1datetime
GP 9
RTCLCMTDsmallint Rate Calcu...(more) Join Now
GP 9
DECPLACSsmallint Decimal Pl...(more) Join Now
GP 9
EXPNDATEdatetime Expiration...(more) Join Now
GP 9
ICCURRIDchar(15) ICCurrency...(more) Join Now
GP 9
ICCURRIXsmallint ICCurrency...(more) Join Now
GP 9
DENXRATEnumeric(19,7) Denominati...(more) Join Now
GP 9
MCTRXSTTsmallint MC Transac...(more) Join Now
GP 9
CorrespondingUnitchar(5) Correspond...(more) Join Now
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9