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

COMPANY..PA31102 Table Definition

(COMPANY..PA PO Receipt Line History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
PAVIDN char(17)
''

RCPTLNNM int
0
Receipt Li...(more) Join Now POP10500.RCPTLNNM
PApurordnum char(17)
''
The purcha...(more) Join Now
ITEMNMBR char(31)
''
Item Number. WO010615.ITEMNMBR
join ... more text available
BackoutTradeDiscTax numeric(19,5)
0.00
Backout Tr...(more) Join Now POP10100.BackoutTradeDiscTax
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
DENXRATE numeric(19,7)
0.00
Exchange R...(more) Join Now
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now MC00100.XCHGRATE
EXGTBLID char(15)
''
Exchange T...(more) Join Now MC00100.EXGTBLID
GLPOSTDT datetime
'1/1/1900'
Date that ...(more) Join Now
ITMTSHID char(15)
''
Item Tax S...(more) Join Now
MCTRXSTT smallint
0
MC Transac...(more) Join Now CM20200.MCTRXSTT
ORD int
0

OrigBackoutTradeDiscTax numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.OrigBackoutTradeDiscTax
ORTDISAM numeric(19,5)
0.00
Orig Trade...(more) Join Now POP10300.ORTDISAM
PAAcctgMethod smallint
0
Useful in ...(more) Join Now
PAACREV numeric(19,5)
0.00

PAApproved_Billing_Amou numeric(19,5)
0.00

PAAPPROVBILLRATE numeric(19,5)
0.00

PAAPPROVMKUPPCT numeric(19,5)
0.00

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

PABaseOvhdCost numeric(19,5)
0.00
PA Base Ov...(more) Join Now PA01301.PABaseOvhdCost
PABase_Qty numeric(19,5)
0.00
PA Base Qt...(more) Join Now
PABase_Unit_Cost numeric(19,5)
0.00
PA Base Un...(more) Join Now
PABilled_Amount numeric(19,5)
0.00

PABilled_Discount numeric(19,5)
0.00

PA_Billed_Profit_Amount_ numeric(19,5)
0.00

PABilledProfitPercentage numeric(19,5)
0.00

PA_Billed_Status tinyint
0
0=Not Bill...(more) Join Now
PABilled_QtyN numeric(19,5)
0.00
PA Billed ...(more) Join Now
PABilledTax numeric(19,5)
0.00

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

PABilling_StatusN smallint
0
p>1 = Bill...(more) Join Now
PAbllngtype smallint
0
1=Billable...(more) Join Now
PACBADDFRMFLY tinyint
0

PACHGORDNO char(17)
''
PA Change ...(more) Join Now
PACogs_Idx int
0
ACTIDX of ...(more) Join Now
PAContra_Account_IDX int
0

PACONTNUMBER char(11)
''
PA Contrac...(more) Join Now
PACOSTCATID char(15)
''
PA Cost Ca...(more) Join Now
PACOSTCATNME char(31)
''
PA Cost Ca...(more) Join Now PA01001.PACOSTCATNME
PAIV_Item_Checkbox tinyint
0

PALineItemSeq int
0
PA Line It...(more) Join Now
PAMARKPERCENT numeric(19,5)
0.00

PA_MC_Accrued_Revenue numeric(19,5)
0.00

PA_MC_Base_Billing_Rate numeric(19,5)
0.00

PA_MC_Billing_Rate numeric(19,5)
0.00

PAMCCURNCYID char(15)
''
PA MC Curr...(more) Join Now
PA_MC_VarianceAccruedRev numeric(19,5)
0.00

PAORIACCRREV numeric(19,5)
0.00

PAORIGBASEOVRHCST numeric(19,5)
0.00

PAORIGBILLRATE numeric(19,5)
0.00

PAORIGOVHDAMT numeric(19,5)
0.00

PAORIGPROFAMT numeric(19,5)
0.00

PAOrigSEC numeric(19,5)
0.00

PAORIGTOTOVRHD numeric(19,5)
0.00

PAORIGTOTPROF numeric(19,5)
0.00

PAOrigVarExt numeric(19,5)
0.00

PAOverhead_Amount numeric(19,5)
0.00

PAOverhead_IDX int
0
ACTIDX of ...(more) Join Now
PAOverheaPercentage numeric(19,5)
0.00
PA Overhea...(more) Join Now
PAPO_Line_Errors binary(4)
0

PAProfitAmount numeric(19,5)
0.00

PAProfitPercent numeric(19,5)
0.00

PAProfitType smallint
0
PA Profit ...(more) Join Now
PAPROJNUMBER char(15)
''
PA Project...(more) Join Now
join ... more text available
PAProjectType smallint
0
Project ty...(more) Join Now
PAPurchase_Tax_Options smallint
0
PA Purchas...(more) Join Now
PAReference_Line_Seq_N int
0

PAShipmentExtCost numeric(19,5)
0.00

PATOTALOVERH numeric(19,5)
0.00

PATotalProfit numeric(19,5)
0.00

PATU smallint
0
PA Transac...(more) Join Now
PAUnbilled_AR_Idx int
0

PAUnbilled_Proj_Rev_Idx int
0

PAUD1 char(21)
''
PA User De...(more) Join Now
PAUD2 char(21)
''
PA User De...(more) Join Now
PA_Variance_Cost tinyint
0

PA_Variance_Accrued_Reve numeric(19,5)
0.00

PA_Variance_QTY_Accrued_ numeric(19,5)
0.00

PAvendid char(15)
''

PACGBWIPIDX int
0
ACTIDX of ...(more) Join Now
POTYPE smallint
0
PO Type T...(more) Join Now POP10100.POTYPE
POPTYPE smallint
0
POP Type D...(more) Join Now POP10300.POPTYPE
PRICELVL char(15)
''
Field Type...(more) Join Now
RATECALC smallint
0
Rate Calc ...(more) Join Now POP10100.RATECALC
RATETPID char(15)
''

receiptdate datetime
'1/1/1900'
Receipt Da...(more) Join Now POP30300.receiptdate
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now WO010213.TIME1
TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
UOMSCHDL char(11)
''
U Of M Sch...(more) Join Now
join ... more text available
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