Module List > Module PM tables PM10500
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?

 Column NameData Type
Default Value
 Source
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now
DOCTYPE smallint
0
Document T...(more) Join Now
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
TAXDTLID char(15)
''
Tax Detail...(more) Join Now
BKOUTTAX tinyint
0
Backout Ta...(more) Join Now
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
ORTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now
PCTAXAMT numeric(19,5)
0.00
Purchase T...(more) Join Now
ORPURTAX numeric(19,5)
0.00
Originatin...(more) Join Now
FRTTXAMT numeric(19,5)
0.00
Freight Ta...(more) Join Now
ORFRTTAX numeric(19,5)
0.00
Originatin...(more) Join Now
MSCTXAMT numeric(19,5)
0.00
Misc Tax A...(more) Join Now
ORMSCTAX numeric(19,5)
0.00
Originatin...(more) Join Now
ACTINDX int
0
Account In...(more) Join Now
join ... more text available
TRXSORCE char(13)
''
Transactio...(more) Join Now
TDTTXPUR numeric(19,5)
0.00
Tax Detail...(more) Join Now
ORTXBPUR numeric(19,5)
0.00
Originatin...(more) Join Now
TXDTTPUR numeric(19,5)
0.00
Tax Detail...(more) Join Now
ORTOTPUR numeric(19,5)
0.00
Originatin...(more) Join Now
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
POSTED tinyint
0
Posted: S...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3