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 PA30500
You are currently viewing the COMPANY database.
Change

COMPANY..PA30500 Table Definition

(COMPANY..PA Employee Expense Header History File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
PAertrxtype smallint
0

PAerdocnumber char(17)
''

PDK_EE_No char(31)
''

PADOCDT datetime
'1/1/1900'

PAPD datetime
'1/1/1900'

USERID char(15)
''
The user t...(more) Join Now WRS10001.USERID
join ... more text available
BACHNUMB char(15)
''
Batch Numb...(more) Join Now UPR10304.BACHNUMB
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
SHIPMTHD char(15)
''
Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
PAREFNO char(17)
''

PAUD1 char(21)
''
PA User De...(more) Join Now
PAUD2 char(21)
''
PA User De...(more) Join Now
EMPLOYID char(15)
''
Employee I...(more) Join Now APR_BSS00100.EMPLOYID
join ... more text available
PAVENADDRESSID char(15)
''

PAStartDate datetime
'1/1/1900'

PAEnDate datetime
'1/1/1900'
PA End Dat...(more) Join Now
PAreptsuff char(5)
''

PAYR smallint
0

PACOMM char(51)
''

PYMTRMID char(21)
''
Payment Te...(more) Join Now RM50105.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
ORDDLRAT numeric(19,5)
0.00
Originatin...(more) Join Now
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
ODISAMTAV numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ODISAMTAV
PRCTDISC smallint
0
Percent Di...(more) Join Now PM20000.PRCTDISC
CURNCYID char(15)
''
Currency I...(more) Join Now MC40200.CURNCYID
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
PATQTY 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

PAORIGTOTCOSTS numeric(19,5)
0.00

PAREIMBURSTAXAMT numeric(19,5)
0.00

PAORIGREIMTAXAMT numeric(19,5)
0.00

BKTPURAM numeric(19,5)
0.00
Backout Pu...(more) Join Now
PATACRV numeric(19,5)
0.00

PAORIACCRREV numeric(19,5)
0.00

TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
ORTDISAM numeric(19,5)
0.00
Orig Trade...(more) Join Now POP10300.ORTDISAM
PAFreight_Taxable_P smallint
0

FRTSCHID char(15)
''
Freight Sc...(more) Join Now RM20101.FRTSCHID
join ... more text available
FRTAMNT numeric(19,5)
0.00
Freight Am...(more) Join Now
ORFRTAMT numeric(19,5)
0.00
Orig Freig...(more) Join Now POP30300.ORFRTAMT
FRTTXAMT numeric(19,5)
0.00
Freight Ta...(more) Join Now POP10100.FRTTXAMT
ORFRTTAX numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ORFRTTAX
PAMisc_Taxable_P smallint
0

MSCSCHID char(15)
''
Misc Sched...(more) Join Now RM20101.MSCSCHID
join ... more text available
MSCCHAMT numeric(19,5)
0.00
Misc Charg...(more) Join Now
OMISCAMT numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.OMISCAMT
MSCTXAMT numeric(19,5)
0.00
Misc Tax A...(more) Join Now POP10100.MSCTXAMT
ORMSCTAX numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ORMSCTAX
DOCAMNT numeric(19,5)
0.00
Source Doc...(more) Join Now
ORDOCAMT numeric(19,5)
0.00
Field Type...(more) Join Now SVC30603.ORDOCAMT
TEN99AMNT numeric(19,5)
0.00
1099 Amoun...(more) Join Now PM10000.TEN99AMNT
OR1099AM numeric(19,5)
0.00
Originatin...(more) Join Now POP10300.OR1099AM
UN1099AM numeric(19,5)
0.00
Unapplied ...(more) Join Now PM20000.UN1099AM
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
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
CAMPMTNM char(21)
''
Cash Amoun...(more) Join Now PM10000.CAMPMTNM
CHRGAMNT numeric(19,5)
0.00
Charge Amo...(more) Join Now PM10000.CHRGAMNT
OCHGAMT numeric(19,5)
0.00
Originatin...(more) Join Now PTE30500.OCHGAMT
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
CHEKNMBR char(21)
''

CHEKDATE datetime
'1/1/1900'
Check Date...(more) Join Now PM10000.CHEKDATE
CAMPYNBR char(21)
''
Check Amou...(more) Join Now PM10000.CAMPYNBR
CHAMCBID char(15)
''
Check Amou...(more) Join Now PM10000.CHAMCBID
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
TAXSCHID char(15)
''

join ... more text available
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
ORTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now PTE30501.ORTAXAMT
CARDNAME char(15)
''
Card Name:...(more) Join Now PM10000.CARDNAME
CRCRDAMT numeric(19,5)
0.00
Credit Car...(more) Join Now PM10000.CRCRDAMT
ORCCDAMT numeric(19,5)
0.00
Originatin...(more) Join Now PTE30500.ORCCDAMT
CRCARDDT datetime
'1/1/1900'
Credit Car...(more) Join Now PM10000.CRCARDDT
CCAMPYNM char(21)
''
Credit Car...(more) Join Now PM10000.CCAMPYNM
CCRCTNUM char(21)
''
Credit Car...(more) Join Now PM10000.CCRCTNUM
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
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
ORDAVMSC numeric(19,5)
0.00
Orig Disco...(more) Join Now SOP30200.ORDAVMSC
ODAVPUR numeric(19,5)
0.00
Originatin...(more) Join Now PTE30500.ODAVPUR
PAReimbursableAmount numeric(19,5)
0.00

PAOrigReimbursableAmt numeric(19,5)
0.00

RATETPID char(15)
''

EXGTBLID char(15)
''
Exchange T...(more) Join Now MC00100.EXGTBLID
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now MC00100.XCHGRATE
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now WO010213.TIME1
RTCLCMTD smallint
0
Rate calcu...(more) Join Now MC40300.RTCLCMTD
DENXRATE numeric(19,7)
0.00
Exchange R...(more) Join Now
MCTRXSTT smallint
0
MC Transac...(more) Join Now CM20200.MCTRXSTT
PApostoDynPM tinyint
0

Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now RM20101.Tax_Date
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
TaxInvRecvd tinyint
0
Tax Invoic...(more) Join Now POP10300.TaxInvRecvd
TaxInvReqd tinyint
0
Tax Invoic...(more) Join Now POP30300.TaxInvReqd
Correcting_Trx_Type smallint
0
Correcting...(more) Join Now GL10000.Correcting_Trx_Type
PAORIGINLDOCNUM char(17)
''

TEN99TYPE smallint
0
1099 Type:...(more) Join Now POP10300.TEN99TYPE
TEN99BOXNUMBER smallint
0
1099 Box N...(more) Join Now POP30300.TEN99BOXNUMBER
CREATDDT datetime
'1/1/1900'
Date this ...(more) Join Now RM00102.CREATDDT
CRUSRID char(15)
''

POSTEDDT datetime
'1/1/1900'
Posted Date The system date at the time the transaction iso psted B3950340.POSTEDDT
PSTUSRID char(15)
''

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