Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

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

DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally 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?

Column NameData Type
Default Value
 Source
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
VCHNUMWK char(17)
''
Voucher Nu...(more) Join Now
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
DOCNUMBR char(21)
''
Document N...(more) Join Now
DOCTYPE smallint
0
Document T...(more) Join Now
SOURCDOC char(11)
''
Source Doc...(more) Join Now
DOCAMNT numeric(19,5)
0.00
Document A...(more) Join Now
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now
PSTGDATE datetime
'1/1/1900'

VADDCDPR char(15)
''
Vendor Add...(more) Join Now
VADCDTRO char(15)
''
Vendor Add...(more) Join Now
PYMTRMID char(21)
''
Payment Te...(more) Join Now
SY033... more text available
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
join ... more text available
DUEDATE datetime
'1/1/1900'
Due Date: ...(more) Join Now
DSCDLRAM numeric(19,5)
0.00
Discount D...(more) Join Now
DISCDATE datetime
'1/1/1900'
Discount D...(more) Join Now
PRCHAMNT numeric(19,5)
0.00
Purchases ...(more) Join Now
CHRGAMNT numeric(19,5)
0.00
Charge Amo...(more) Join Now
CASHAMNT numeric(19,5)
0.00
Cash Amoun...(more) Join Now
CAMCBKID char(15)
''
Cash Amoun...(more) Join Now
CDOCNMBR char(21)
''
Cash Docum...(more) Join Now
CAMTDATE datetime
'1/1/1900'
Cash Amoun...(more) Join Now
CAMPMTNM char(21)
''
Cash Amoun...(more) Join Now
CHEKAMNT numeric(19,5)
0.00
Check Amou...(more) Join Now
CHAMCBID char(15)
''
Check Amou...(more) Join Now
CHEKDATE datetime
'1/1/1900'
Check Date...(more) Join Now
CAMPYNBR char(21)
''
Check Amou...(more) Join Now
CRCRDAMT numeric(19,5)
0.00
Credit Car...(more) Join Now
CCAMPYNM char(21)
''
Credit Car...(more) Join Now
CHEKNMBR char(21)
''
Check Numb...(more) Join Now
CARDNAME char(15)
''
Card Name:...(more) Join Now
CCRCTNUM char(21)
''
Credit Car...(more) Join Now
CRCARDDT datetime
'1/1/1900'
Credit Car...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
TRXDSCRN char(31)
''
Transactio...(more) Join Now
UN1099AM numeric(19,5)
0.00
Unapplied ...(more) Join Now
TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
FRTAMNT numeric(19,5)
0.00
Freight Am...(more) Join Now
TEN99AMNT numeric(19,5)
0.00
1099 Amoun...(more) Join Now
MSCCHAMT numeric(19,5)
0.00
Misc Charg...(more) Join Now
PORDNMBR char(21)
''
Purchase O...(more) Join Now
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
DISAMTAV numeric(19,5)
0.00
Discount A...(more) Join Now
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
APDSTKAM numeric(19,5)
0.00
Applied Di...(more) Join Now
WROFAMNT numeric(19,5)
0.00
Write Off ...(more) Join Now
CURTRXAM numeric(19,5)
0.00
Current Tr...(more) Join Now
TXENGCLD tinyint
0
Tax Engine...(more) Join Now
PMWRKMSG binary(4)
0
PM WORK Me...(more) Join Now
PMDSTMSG binary(4)
0
PM Distrib...(more) Join Now
GSTDSAMT numeric(19,5)
0.00
GST Discou...(more) Join Now
PGRAMSBJ smallint
0
Percent Of...(more) Join Now
PPSAMDED numeric(19,5)
0.00
PPS Amount...(more) Join Now
PPSTAXRT smallint
0
PPS Tax Ra...(more) Join Now
PSTGSTUS smallint
0
Posting St...(more) Join Now
POSTED tinyint
0
Posted: A...(more) Join Now
APPLDAMT numeric(19,5)
0.00
Applied Am...(more) Join Now
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now
CNTRLTYP smallint
0
Control Ty...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
MDFUSRID char(15)
''
User that ...(more) Join Now
join ... more text available
POSTEDDT datetime
'1/1/1900'
Posted Dat...(more) Join Now
PTDUSRID char(15)
''
Posted Use...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
BKTFRTAM numeric(19,5)
0.00
Backout Fr...(more) Join Now
BKTMSCAM numeric(19,5)
0.00
Backout Mi...(more) Join Now
BKTPURAM numeric(19,5)
0.00
Backout Pu...(more) Join Now
PCHSCHID char(15)
''
Purchase S...(more) Join Now
FRTSCHID char(15)
''
Freight ...(more) Join Now
join ... more text available
MSCSCHID char(15)
''
Misc Sched...(more) Join Now
join ... more text available
PRINTED tinyint
0
Printed: ...(more) Join Now
PRCTDISC smallint
0
Percent Di...(more) Join Now
RETNAGAM numeric(19,5)
0.00
Retainage ...(more) Join Now
ICTRX tinyint
0
IC TRX: Im...(more) Join Now
ICDISTS tinyint
0
ICDists: I...(more) Join Now
PMICMSGS binary(4)
0
ICMessages...(more) Join Now
Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now
PRCHDATE datetime
'1/1/1900'
Purchase D...(more) Join Now
CORRCTN tinyint
0
Correction...(more) Join Now
SIMPLIFD tinyint
0
Simplified...(more) Join Now
CORRNXST tinyint
0
Correction...(more) Join Now
VCHRNCOR char(21)
''
Voucher Nu...(more) Join Now
PMWRKMS2 binary(4)
0
PM Work Me...(more) Join Now
BNKRCAMT numeric(19,5)
0.00
Bank Recei...(more) Join Now
APLYWITH tinyint
0
Apply With...(more) Join Now
Electronic tinyint
0

ECTRX tinyint
0
EC Transac...(more) Join Now
DocPrinted tinyint
0
DocPrinted...(more) Join Now
TaxInvReqd tinyint
0
Tax Invoic...(more) Join Now
BackoutTradeDisc numeric(19,5)
0.00
Backout Tr...(more) Join Now
CBVAT tinyint
0
Cash Based...(more) Join Now
TEN99TYPE smallint
0
1099 Type:...(more) Join Now
TEN99BOXNUMBER smallint
0
1099 Box N...(more) Join Now
Workflow_Status smallint
0

DEX_ROW_TS datetime
(getutcdate())
Time Stamp...(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