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

COMPANY..PA11801 Table Definition

(COMPANY..PA Combined History Detail 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)
''

PAREFNO char(17)
''

PADT datetime
'1/1/1900'
PA Date ...(more) Join Now
PApurordnum char(17)
''
The purcha...(more) Join Now
PACONTNUMBER char(11)
''
PA Contrac...(more) Join Now
PAPROJNUMBER char(15)
''
PA Project...(more) Join Now
join ... more text available
PACOSTCATID char(15)
''
PA Cost Ca...(more) Join Now
PAContMgrID char(15)
''
The contra...(more) Join Now
PAitemnumber char(31)
''

EMPLOYID char(15)
''
Employee I...(more) Join Now APR_BSS00100.EMPLOYID
join ... more text available
PACOSTOWNER char(31)
''

CUSTNMBR char(15)
''
Customer c...(more) Join Now
join ... more text available
PAprojmngrid char(15)
''

PAProjectType smallint
0
Project ty...(more) Join Now
SLPRSNID char(15)
''
Used only ...(more) Join Now
join ... more text available
PATB datetime
'1/1/1900'

PATE datetime
'1/1/1900'

PAconvtmints smallint
0

PAbillnoteidx numeric(19,5)
0.00
PA Billing...(more) Join Now
PAQtyQ numeric(19,5)
0.00

PABase_Qty numeric(19,5)
0.00
PA Base Qt...(more) Join Now
PAUnit_of_Measure char(9)
''
PA Unit of...(more) Join Now
UOMSCHDL char(11)
''
U Of M Sch...(more) Join Now
join ... more text available
PAUNITCOST numeric(19,5)
0.00
PA Unit Co...(more) Join Now
ORUNTCST numeric(19,5)
0.00
Unit Price...(more) Join Now
PABase_Unit_Cost numeric(19,5)
0.00
PA Base Un...(more) Join Now
PAORGBSUNITCST numeric(19,5)
0.00

PAOverhead_Amount numeric(19,5)
0.00

PAORIGOVHDAMT numeric(19,5)
0.00

PAOverheaPercentage numeric(19,5)
0.00
PA Overhea...(more) Join Now
PATOTALOVERH numeric(19,5)
0.00

PAORIGTOTOVRHD numeric(19,5)
0.00

PATOTCST numeric(19,5)
0.00

PAORIGTOTCOST numeric(19,5)
0.00

PAbllngtype smallint
0
1=Billable...(more) Join Now
BKTPURAM numeric(19,5)
0.00
Backout Pu...(more) Join Now
PABILRATE numeric(19,5)
0.00

PAORIGBILLRATE numeric(19,5)
0.00

PA_Base_Billing_Rate numeric(19,5)
0.00

PAORIGBSBILLRTE numeric(19,5)
0.00

PAMARKPERCENT numeric(19,5)
0.00

PAACREV numeric(19,5)
0.00

PAORIACCRREV numeric(19,5)
0.00

PASTD_Qty numeric(19,5)
0.00

PANC_Qty numeric(19,5)
0.00

PASplit_NC numeric(19,5)
0.00

PANB_Qty numeric(19,5)
0.00

PAPurchase_Tax_Options smallint
0
PA Purchas...(more) Join Now
ITMTSHID char(15)
''
Item Tax S...(more) Join Now
TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
FRTAMNT numeric(19,5)
0.00
Freight Am...(more) Join Now
MSCCHAMT numeric(19,5)
0.00
Misc Charg...(more) Join Now
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
LNITMSEQ int
0
Line Item ...(more) Join Now
PAReference_Line_Seq_N int
0

PAexptdate datetime
'1/1/1900'

PABilling_StatusN smallint
0
p>1 = Bill...(more) Join Now
PAUD1 char(21)
''
PA User De...(more) Join Now
PAUD2 char(21)
''
PA User De...(more) Join Now
PAprjclsid char(15)
''

CUSTCLAS char(15)
''
Customer C...(more) Join Now
PAcontclassid char(15)
''
Contains t...(more) Join Now
PACOSTCATCLASID char(15)
''
PA Cost Ca...(more) Join Now
PAPayCode char(7)
''

STATECD char(3)
''
State Code...(more) Join Now W200006.STATECD
LOCLCODE char(7)
''

SUTASTAT char(3)
''
Suta State...(more) Join Now UPR00401.SUTASTAT
WRKRCOMP char(7)
''
Workers Co...(more) Join Now JC00701.WRKRCOMP
PASalary_Posting_Type smallint
0

PAJob_Title char(7)
''

PADepartment char(7)
''

PABilled_QtyN numeric(19,5)
0.00
PA Billed ...(more) Join Now
PABilledTax numeric(19,5)
0.00

PABilled_Misc numeric(19,5)
0.00

PAProfitType smallint
0
PA Profit ...(more) Join Now
PAProfitAmount numeric(19,5)
0.00

PAORIGPROFAMT numeric(19,5)
0.00

PAProfitPercent numeric(19,5)
0.00

PATotalProfit numeric(19,5)
0.00

PAORIGTOTPROF numeric(19,5)
0.00

PAApproved_Quantity numeric(19,5)
0.00
PA Approve...(more) Join Now
PAAPPROVBILLRATE numeric(19,5)
0.00

PAAPPROVMKUPPCT numeric(19,5)
0.00

PAApproved_Billing_Amou numeric(19,5)
0.00

PA_Billed_Profit_Amount_ numeric(19,5)
0.00

PABilledProfitPercentage numeric(19,5)
0.00

PABilled_Amount numeric(19,5)
0.00

PABilled_Freight numeric(19,5)
0.00

PABilled_Discount numeric(19,5)
0.00

PAWrite_UpDown_Amount numeric(19,5)
0.00
PA Write U...(more) Join Now
PAWrite_UpDown_Percenta int
0

PAApprover_ID char(15)
''

PAApprover_Type smallint
0

PAPartial_Bill tinyint
0

PACGBWIPIDX int
0
ACTIDX of ...(more) Join Now
PAUnbilled_AR_Idx int
0

PAUnbilled_Proj_Rev_Idx int
0

PAOverhead_IDX int
0
ACTIDX of ...(more) Join Now
PAContra_Account_IDX int
0

PACogs_Idx int
0
ACTIDX of ...(more) Join Now
PAPaymentMethod smallint
0

PAExpenseType smallint
0
1-Reimburs...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
PRICELVL char(15)
''
Field Type...(more) Join Now
IVIVINDX int
0
IV IV Inde...(more) Join Now
IVIVOFAC_1 char(9)
''

IVIVOFAC_2 char(9)
''

IVIVOFAC_3 char(9)
''

IVIVOFAC_4 char(9)
''

IVIVOFAC_5 char(9)
''

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