DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
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
Module List > Module PA tables PDK10500
You are currently viewing the COMPANY database.
Change

COMPANY..PDK10500 Table Definition

(COMPANY..PDK Employee Expense HDR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
PDK_EE_Trx_Type smallint
0

PDK_EE_No char(31)
''

PDK_Ref_Doc_No char(31)
''

PDK_Document_Status smallint
0

PDK_Trx_Source smallint
0

PDK_Remote_Change tinyint
0

PADOCDT datetime
'1/1/1900'

PAYR smallint
0

EMPLOYID char(15)
''
Employee I...(more) Join Now UPR00100.EMPLOYID
join ... more text available
PAStartDate datetime
'1/1/1900'

PAEnDate datetime
'1/1/1900'
PA End Dat...(more) Join Now PA02101.PAEnDate
PACOMM char(51)
''

PAUD1 char(21)
''
PA User De...(more) Join Now PA01001.PAUD1
PAUD2 char(21)
''
PA User De...(more) Join Now PA01001.PAUD2
PDK_Total_Quantity numeric(19,5)
0.00

PAEXTCOST numeric(19,5)
0.00

OREXTCST numeric(19,5)
0.00
Originatin...(more) Join Now SOP10200.OREXTCST
PAtotcosts numeric(19,5)
0.00

PATACRV numeric(19,5)
0.00

DOCAMNT numeric(19,5)
0.00
Source Doc...(more) Join Now PM10000.DOCAMNT
TEN99AMNT numeric(19,5)
0.00
1099 Amoun...(more) Join Now PM10000.TEN99AMNT
PAVENADDRESSID char(15)
''

PYMTRMID char(21)
''
Payment Te...(more) Join Now PM10000.PYMTRMID
SY033... more text available
DUEDATE datetime
'1/1/1900'
Due Date: ...(more) Join Now PM10000.DUEDATE
DSCDLRAM numeric(19,5)
0.00
Discount D...(more) Join Now PM10000.DSCDLRAM
DISCDATE datetime
'1/1/1900'
Discount D...(more) Join Now PM10000.DISCDATE
DISAMTAV numeric(19,5)
0.00
Discount A...(more) Join Now POP10100.DISAMTAV
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now RM20101.DISTKNAM
BKTPURAM numeric(19,5)
0.00
Backout Pu...(more) Join Now PM20000.BKTPURAM
SHIPMTHD char(15)
''
Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
PRCTDISC smallint
0
Percent Di...(more) Join Now PM20000.PRCTDISC
TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now RM20101.TRDISAMT
FRTAMNT numeric(19,5)
0.00
Freight Am...(more) Join Now PM10000.FRTAMNT
MSCCHAMT numeric(19,5)
0.00
Misc Charg...(more) Join Now PM10000.MSCCHAMT
UN1099AM numeric(19,5)
0.00
Unapplied ...(more) Join Now PM20000.UN1099AM
PAPD datetime
'1/1/1900'

CARDNAME char(15)
''
Card Name:...(more) Join Now PM10000.CARDNAME
CRCRDAMT numeric(19,5)
0.00
Credit Car...(more) Join Now PM10000.CRCRDAMT
CRCARDDT datetime
'1/1/1900'
Credit Car...(more) Join Now PM10000.CRCARDDT
CCRCTNUM char(21)
''
Credit Car...(more) Join Now PM10000.CCRCTNUM
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now RM20101.TAXAMNT
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now PM10000.TAXSCHID
join ... more text available
PAFreight_Taxable_P smallint
0

FRTSCHID char(15)
''
Freight Sc...(more) Join Now RM20101.FRTSCHID
join ... more text available
FRTTXAMT numeric(19,5)
0.00
Freight Ta...(more) Join Now POP10100.FRTTXAMT
PAMisc_Taxable_P smallint
0

MSCSCHID char(15)
''
Misc Sched...(more) Join Now RM20101.MSCSCHID
join ... more text available
MSCTXAMT numeric(19,5)
0.00
Misc Tax A...(more) Join Now POP10100.MSCTXAMT
CHRGAMNT numeric(19,5)
0.00
Charge Amo...(more) Join Now PM10000.CHRGAMNT
NOTEID char(31)
''

PDK_Reporting_Suffix char(5)
''

LNITMSEQ int
0
Line Item ...(more) Join Now PA01301.LNITMSEQ
MANAGER char(15)
''

Manager_Approval_Status smallint
0

SUPERVISOR char(31)
''

Sup_Approval_Status smallint
0

Administrator char(15)
''

Admin_Approval_Status smallint
0

CURNCYID char(15)
''
Currency I...(more) Join Now CM20000
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
RATETPID char(15)
''
A valid Ra...(more) Join Now
EXGTBLID char(15)
''
Exchange T...(more) Join Now CM20200.EXGTBLID
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now CM20200.XCHGRATE
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now CM20200.EXCHDATE
TIME1 datetime
'1/1/1900'
Time see ...(more) Join Now CM20200.TIME1
RTCLCMTD smallint
0
Rate Calcu...(more) Join Now CM20200.RTCLCMTD
DENXRATE numeric(19,7)
0.00
Denominati...(more) Join Now CM20200.DENXRATE
MCTRXSTT smallint
0
MC Transac...(more) Join Now CM20200.MCTRXSTT
ORDOCAMT numeric(19,5)
0.00
Field Type...(more) Join Now SVC30603.ORDOCAMT
OR1099AM numeric(19,5)
0.00
Originatin...(more) Join Now POP10300.OR1099AM
ORDDLRAT numeric(19,5)
0.00
Orig Disco...(more) Join Now POP30300.ORDDLRAT
ODISAMTAV numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ODISAMTAV
ORDISTKN numeric(19,5)
0.00
Orig Disco...(more) Join Now SOP30200.ORDISTKN
ORDAVFRT numeric(19,5)
0.00
Orig Disco...(more) Join Now SOP30200.ORDAVFRT
ODAVPUR numeric(19,5)
0.00
Originatin...(more) Join Now PTE30500.ODAVPUR
ORDAVMSC numeric(19,5)
0.00
Orig Disco...(more) Join Now SOP30200.ORDAVMSC
OBKPURAMT numeric(19,5)
0.00
Originatin...(more) Join Now PTE30501.OBKPURAMT
ORTDISAM numeric(19,5)
0.00
Orig Trade...(more) Join Now POP30300.ORTDISAM
PAORIGTOTCOSTS numeric(19,5)
0.00

PAORIACCRREV numeric(19,5)
0.00

ORCCDAMT numeric(19,5)
0.00
Originatin...(more) Join Now PTE30500.ORCCDAMT
ORTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ORTAXAMT
ORFRTAMT numeric(19,5)
0.00
Orig Freig...(more) Join Now POP10300.ORFRTAMT
ORFRTTAX numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ORFRTTAX
OMISCAMT numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.OMISCAMT
ORMSCTAX numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ORMSCTAX
OCHGAMT numeric(19,5)
0.00
Originatin...(more) Join Now PTE30500.OCHGAMT
PAReimbursableAmount numeric(19,5)
0.00

PAOrigReimbursableAmt numeric(19,5)
0.00

BCKTXAMT numeric(19,5)
0.00
Backout Ta...(more) Join Now POP10100.BCKTXAMT
OBTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.OBTAXAMT
PAREIMBURSTAXAMT numeric(19,5)
0.00

PAORIGREIMTAXAMT numeric(19,5)
0.00

PAerdocnumber char(17)
''

PAREFNO char(17)
''

PDK_Proxy_ID char(15)
''

PDK_EE_App_Update smallint
0

MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
Modified_Time datetime
'1/1/1900'

Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now RM20101.Tax_Date
TaxInvRecvd tinyint
0
Tax Invoic...(more) Join Now POP10300.TaxInvRecvd
TaxInvReqd tinyint
0
Tax Invoic...(more) Join Now POP30300.TaxInvReqd
CAMCBKID char(15)
''
Cash Amoun...(more) Join Now PM10000.CAMCBKID
CDOCNMBR char(21)
''
Cash Docum...(more) Join Now PM10000.CDOCNMBR
CAMTDATE datetime
'1/1/1900'
Cash Amoun...(more) Join Now PM10000.CAMTDATE
CASHAMNT numeric(19,5)
0.00
Cash Amoun...(more) Join Now PM10000.CASHAMNT
ORCASAMT numeric(19,5)
0.00
Originatin...(more) Join Now PTE30500.ORCASAMT
CHAMCBID char(15)
''
Check Amou...(more) Join Now PM10000.CHAMCBID
CHEKNMBR char(21)
''
Check Numb...(more) Join Now PM10000.CHEKNMBR
CHEKDATE datetime
'1/1/1900'
Check Date...(more) Join Now PM10000.CHEKDATE
CHEKAMNT numeric(19,5)
0.00
Check Amou...(more) Join Now PM10000.CHEKAMNT
ORCHKAMT numeric(19,5)
0.00
Originatin...(more) Join Now PTE30500.ORCHKAMT
APRVLUSERID char(15)
''
Approval U...(more) Join Now SY00500.APRVLUSERID
APPRVLDT datetime
'1/1/1900'
Approval D...(more) Join Now SY00500.APPRVLDT
TEN99TYPE smallint
0
1099 Type:...(more) Join Now POP10300.TEN99TYPE
TEN99BOXNUMBER smallint
0
1099 Box N...(more) Join Now POP30300.TEN99BOXNUMBER
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3