DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Tax Work File)

Records in this table contain the detailed tax information associated with the transaction. These records are created only if taxes have been computed for the transaction. They must balance to the total amount of taxes calculated for this transaction.

 

This table contains all of the tax detail records that need to be distributed for the document. The total of all these records must be equal to the amount of tax in the 'Tax Amount' field in the PM_Transaction_WORK table (with the exception of 'Tax Included With Item Price' details). There may be an unlimited number of tax distribution records used to distribute the tax amount for any given transaction. Posting requires that the amount entered into the 'Tax Amount' field (plus any backout amounts) must be accounted for in the distributions. Also, posting does not verify that the tax schedules are still valid at the time of posting; rather it verifies that the Tax Detail IDs are still valid at the time of posting.


4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM10500.VENDORID
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
DOCTYPEsmallint Document T...(more) Join Now
GP 9
BACHNUMBchar(15) Batch Numb...(more) Join Now
GP 9
join SY00500 on SY00500.BACHNUMB = PM10500.BACHNUMB
TAXDTLIDchar(15) Tax Detail...(more) Join Now
GP 9
BKOUTTAXtinyint Backout Ta...(more) Join Now
GP 9
TAXAMNTnumeric(19,5) Tax Amount...(more) Join Now
GP 9
ORTAXAMTnumeric(19,5) Originatin...(more) Join Now
GP 9
PCTAXAMTnumeric(19,5) Purchase T...(more) Join Now
GP 9
ORPURTAXnumeric(19,5) Originatin...(more) Join Now
GP 9
FRTTXAMTnumeric(19,5) Freight Ta...(more) Join Now
GP 9
ORFRTTAXnumeric(19,5) Originatin...(more) Join Now
GP 9
MSCTXAMTnumeric(19,5) Misc Tax A...(more) Join Now
GP 9
ORMSCTAXnumeric(19,5) Originatin...(more) Join Now
GP 9
ACTINDXint Account In...(more) Join Now
GP 9
join GL00100 on GL00100.ACTINDX = PM10500.ACTINDX
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
TDTTXPURnumeric(19,5) Tax Detail...(more) Join Now
GP 9
ORTXBPURnumeric(19,5) Originatin...(more) Join Now
GP 9
TXDTTPURnumeric(19,5) Tax Detail...(more) Join Now
GP 9
ORTOTPURnumeric(19,5) Originatin...(more) Join Now
GP 9
CURRNIDXsmallint Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURRNIDX = PM10500.CURRNIDX
POSTEDtinyint Posted: S...(more) Join Now
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9