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

COMPANY..PA23100 Table Definition

(COMPANY..PA Billing Header OPEN)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
PABILLTRXT smallint
0

PADocnumber20 char(17)
''

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
PADOCDT datetime
'1/1/1900'

PAPD datetime
'1/1/1900'

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
PAuserid char(15)
''

LSTEDTDT datetime
'1/1/1900'
Last Edit ...(more) Join Now RM20101.LSTEDTDT
LSTUSRED char(15)
''
Last User ...(more) Join Now RM20101.LSTUSRED
PAREFNO char(17)
''

CUSTNMBR char(15)
''
Customer c...(more) Join Now
join ... more text available
CSTPONBR char(21)
''
Tax Schedu...(more) Join Now RM10301.CSTPONBR
PRBTADCD char(15)
''
The addres...(more) Join Now
join ... more text available
PYMTRMID char(21)
''
Payment Te...(more) Join Now RM50105.PYMTRMID
SY033... more text available
PABILLFORMAT char(15)
''
The defaul...(more) Join Now
PACOMM char(51)
''

CURNCYID char(15)
''
Currency I...(more) Join Now MC40200.CURNCYID
join ... more text available
PAUD1 char(21)
''
PA User De...(more) Join Now
PAUD2 char(21)
''
PA User De...(more) Join Now
CASHAMNT numeric(19,5)
0.00
Cash Amoun...(more) Join Now PM10000.CASHAMNT
CBKIDCSH char(15)
''
Checkbook ...(more) Join Now RM20101.CBKIDCSH
CASHDATE datetime
'1/1/1900'
Cash Date:...(more) Join Now RM10301.CASHDATE
DCNUMCSH char(21)
''
Document N...(more) Join Now RM10301.DCNUMCSH
CHEKAMNT numeric(19,5)
0.00
Check Amou...(more) Join Now PM10000.CHEKAMNT
CBKIDCHK char(15)
''
Checkbook ...(more) Join Now RM20101.CBKIDCHK
CHEKNMBR char(21)
''

CHEKDATE datetime
'1/1/1900'
Check Date...(more) Join Now PM10000.CHEKDATE
DCNUMCHK char(21)
''
Document N...(more) Join Now RM10301.DCNUMCHK
CRCRDAMT numeric(19,5)
0.00
Credit Car...(more) Join Now PM10000.CRCRDAMT
CRCRDNAM char(15)
''
Credit Car...(more) Join Now RM10301.CRCRDNAM
RCTNCCRD char(21)
''
Receipt Nu...(more) Join Now RM10301.RCTNCCRD
CRCARDDT datetime
'1/1/1900'
Credit Car...(more) Join Now PM10000.CRCARDDT
DCNUMCRD char(21)
''
Document N...(more) Join Now RM10301.DCNUMCRD
DSCPCTAM smallint
0
Discount P...(more) Join Now
DSCDLRAM numeric(19,5)
0.00
Discount D...(more) Join Now PM10000.DSCDLRAM
DISAVAMT numeric(19,5)
0.00
Discount A...(more) Join Now RM20101.DISAVAMT
DISCAMNT numeric(19,5)
0.00

DISCDATE datetime
'1/1/1900'
Discount D...(more) Join Now PM10000.DISCDATE
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
DISCRTND numeric(19,5)
0.00
Discount R...(more) Join Now RM20101.DISCRTND
PABillingAmount numeric(19,5)
0.00

TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
PA_Freight_Amount numeric(19,5)
0.00

FRTTXAMT numeric(19,5)
0.00
Freight Ta...(more) Join Now POP10100.FRTTXAMT
PA_Misc_Amount numeric(19,5)
0.00

MSCTXAMT numeric(19,5)
0.00
Misc Tax A...(more) Join Now POP10100.MSCTXAMT
PATOTTAX numeric(19,5)
0.00

PABACKBILL numeric(19,5)
0.00

BKTFRTAM numeric(19,5)
0.00
Backout Fr...(more) Join Now RM20101.BKTFRTAM
BKTMSCAM numeric(19,5)
0.00
Backout Mi...(more) Join Now RM20101.BKTMSCAM
DOCAMNT numeric(19,5)
0.00
Source Doc...(more) Join Now
DUEDATE datetime
'1/1/1900'
Due Date: ...(more) Join Now PM10000.DUEDATE
APPLDAMT numeric(19,5)
0.00

PALastDateApplied datetime
'1/1/1900'

SLPRSNID char(15)
''
Used only ...(more) Join Now
join ... more text available
SALSTERR char(15)
''
Defaults w...(more) Join Now
join ... more text available
TAXSCHID char(15)
''

join ... more text available
COMDLRAM numeric(19,5)
0.00
Commission...(more) Join Now RM20101.COMDLRAM
COMAPPTO smallint
0
The method...(more) Join Now
LNITMSEQ int
0
Line Item ...(more) Join Now
CUTOFDAT datetime
'1/1/1900'

SHIPMTHD char(15)
''
Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
MSCSCHID char(15)
''
Misc Sched...(more) Join Now RM20101.MSCSCHID
join ... more text available
MISCTXBL smallint
0

FRTSCHID char(15)
''
Freight Sc...(more) Join Now RM20101.FRTSCHID
join ... more text available
FRGTTXBL smallint
0

PARetentionFeeAmount numeric(19,5)
0.00
PA Retenti...(more) Join Now
PAtotbillings numeric(19,5)
0.00

PARetainer_Fee_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
PAApplyTax tinyint
0

PA_Applied_Freight_Misc numeric(19,5)
0.00

AGNGBUKT smallint
0

PAlastprtby char(15)
''

PAlastprtdate datetime
'1/1/1900'

ORCASAMT numeric(19,5)
0.00
Originatin...(more) Join Now PTE30500.ORCASAMT
ORCHKAMT numeric(19,5)
0.00
Originatin...(more) Join Now PTE30500.ORCHKAMT
ORCCDAMT numeric(19,5)
0.00
Originatin...(more) Join Now PTE30500.ORCCDAMT
ORDDLRAT numeric(19,5)
0.00
Originatin...(more) Join Now
ORDAVAMT numeric(19,5)
0.00
Orig Disco...(more) Join Now POP10300.ORDAVAMT
ORTDISAM numeric(19,5)
0.00
Orig Trade...(more) Join Now POP10300.ORTDISAM
ORFRTTAX numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ORFRTTAX
ORMSCTAX numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ORMSCTAX
ORBKTFRT numeric(19,5)
0.00
Orig Backo...(more) Join Now SOP30200.ORBKTFRT
ORBKTMSC numeric(19,5)
0.00
Orig Backo...(more) Join Now SOP30200.ORBKTMSC
ORDOCAMT numeric(19,5)
0.00
Field Type...(more) Join Now SVC30603.ORDOCAMT
ORAPPAMT numeric(19,5)
0.00

ORCOMAMT numeric(19,5)
0.00
Field Type...(more) Join Now SVC00600.ORCOMAMT
PAOrigBillAmount numeric(19,5)
0.00

PAOrigFreightAmt numeric(19,5)
0.00

PAOrigMiscAmt numeric(19,5)
0.00

PAOrigTotalTaxAmt numeric(19,5)
0.00

PAOrigBackoutBillAmt numeric(19,5)
0.00

PAOrigRetentionFeeAmt numeric(19,5)
0.00

PAOrigTotalBilings numeric(19,5)
0.00

PAOrigRetainerFeeAmt numeric(19,5)
0.00

PAOrigDiscTakenAmt numeric(19,5)
0.00

PAOrigDiscRetAmt numeric(19,5)
0.00

PAOrigAppliedFreightMisc numeric(19,5)
0.00

CURRNIDX smallint
0
Currency I...(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
MCTRXSTT smallint
0
MC Transac...(more) Join Now CM20200.MCTRXSTT
PAPostoDynRM tinyint
0

Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now RM20101.Tax_Date
PA_Third_Party_CB tinyint
0

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
BackoutTradeDiscTax numeric(19,5)
0.00
Backout Tr...(more) Join Now POP10100.BackoutTradeDiscTax
OrigBackoutTradeDiscTax numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.OrigBackoutTradeDiscTax
PA_Backout_Retention_Tax numeric(19,5)
0.00

PA_OrigBackRetentionTax numeric(19,5)
0.00

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