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

COMPANY..PA11800 Table Definition

(COMPANY..PA Combined History Header file)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
PATU smallint
0
PA Transac...(more) Join Now
PADocnumber20 char(17)
''

PATRXType smallint
0

PADOCDT 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
PAREFNO char(17)
''

PAUD1 char(21)
''
PA User De...(more) Join Now
PAUD2 char(21)
''
PA User De...(more) Join Now
VENDORID char(15)
''
Vendor ID ...(more) Join Now WC010931.VENDORID
join ... more text available
PACOSTOWNER char(31)
''

PAREPD smallint
0

PAREPDT datetime
'1/1/1900'

PAreptsuff char(5)
''

PAYR smallint
0

PAVENINVNO char(21)
''

PAVENADDRESSID char(15)
''

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
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
PRCTDISC smallint
0
Percent Di...(more) Join Now PM20000.PRCTDISC
CURNCYID char(15)
''
Currency I...(more) Join Now MC40200.CURNCYID
join ... more text available
SHIPMTHD char(15)
''
Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
PATQTY numeric(19,5)
0.00

PAtotcosts numeric(19,5)
0.00

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

TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
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
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
MSCCHAMT numeric(19,5)
0.00
Misc Charg...(more) Join Now
MSCTXAMT numeric(19,5)
0.00
Misc Tax A...(more) Join Now POP10100.MSCTXAMT
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
DOCAMNT numeric(19,5)
0.00
Source Doc...(more) Join Now
TEN99AMNT numeric(19,5)
0.00
1099 Amoun...(more) Join Now PM10000.TEN99AMNT
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
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
CHEKAMNT numeric(19,5)
0.00
Check Amou...(more) Join Now PM10000.CHEKAMNT
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
CRCRDAMT numeric(19,5)
0.00
Credit Car...(more) Join Now PM10000.CRCRDAMT
CARDNAME char(15)
''
Card Name:...(more) Join Now PM10000.CARDNAME
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
CHRGAMNT numeric(19,5)
0.00
Charge Amo...(more) Join Now PM10000.CHRGAMNT
LNITMSEQ int
0
Line Item ...(more) Join Now
PAPD datetime
'1/1/1900'

VOIDSTTS smallint
0
Void Statu...(more) Join Now POP30300.VOIDSTTS
VOIDDATE datetime
'1/1/1900'
Void Date ...(more) Join Now CM20300.VOIDDATE
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
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
PAORIGTOTCOSTS numeric(19,5)
0.00

PAORIACCRREV numeric(19,5)
0.00

DISAVAMT numeric(19,5)
0.00
Discount A...(more) Join Now RM20101.DISAVAMT
TAXSCHID char(15)
''

join ... more text available
PYMNTTRM char(15)
''

POPTYPE smallint
0
POP Type D...(more) Join Now POP10300.POPTYPE
VNDDOCNM char(21)
''
Vendor Doc...(more) Join Now POP10300.VNDDOCNM
ACTLSHIP datetime
'1/1/1900'
Actual Shi...(more) Join Now POP30300.ACTLSHIP
GLPOSTDT datetime
'1/1/1900'
Date that ...(more) Join Now
DSCPCTAM smallint
0
Discount P...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now PP100101.VCHRNMBR
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