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

COMPANY..ASI25804 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
USERID char

 The user t...(more) Join Now
join ... more text available
CMPANYID smallint

 Company ID...(more) Join Now WPPU0114.CMPANYID
join ... more text available
PADocnumber20 char
PACONTNUMBER char

 PA Contrac...(more) Join Now PA01101.PACONTNUMBER
PAPROJNUMBER char

 PA Project...(more) Join Now PA11801.PAPROJNUMBER
join ... more text available
PAPrintSortOrd smallint
PACOSTDATE datetime
PABILLITEMID char
PABILLSEQ int
PABILLSUBLINESEQ int
PABill_Format_Key smallint
PAIFNotFirstOnList_1 tinyint
PAIFNotFirstOnList_2 tinyint
PATranType smallint

 The Type o...(more) Join Now PA01901.PATranType
PABILLDOCNO int
PAREFNO char
PACOMM char
PABILLITEMNAME char
PA_Biller_Item_Name_2 char
PACOSTDOCNO char
PACOSTSEQNO int
PACOSTDOCDATE datetime
PACOSTOWNER char
PACost_Owner_Name char
PACOSTCATID char

 PA Cost Ca...(more) Join Now PA11801.PACOSTCATID
PACOSTCATNME char
PAJob_Title char
PABILRATE numeric
PAORIGBILLRATE numeric
PAQtyQ numeric
PAACREV numeric
PAORIACCRREV numeric
PAtotcosts numeric
PAORIGTOTCOSTS numeric
PABilled_QtyN numeric

 PA Billed ...(more) Join Now PA11801.PABilled_QtyN
PANETBILLAMT numeric
PAONETBILLINGAMT numeric
PARecognizedRevenue numeric
PAOrigRecogRevenue numeric
TAXAMNT numeric

 Tax Amount...(more) Join Now PA11801.TAXAMNT
ORTAXAMT numeric

 Originatin...(more) Join Now PTE30501.ORTAXAMT
PABACKBILL numeric
PAOrigBackoutBillAmt numeric
TRDISAMT numeric

 Trade Disc...(more) Join Now PA11801.TRDISAMT
ORTDISAM numeric
PATOTALOVERH numeric
PAORIGTOTOVRHD numeric
PATax_Detail_ID_Array_1 char
PATax_Detail_ID_Array_2 char
PATax_Detail_ID_Array_3 char
PATax_Detail_ID_Array_4 char
PATax_Detail_ID_Array_5 char
PATax_Detail_ID_Array_6 char
PATax_Detail_ID_Array_7 char
PATax_Detail_ID_Array_8 char
PATax_Detail_ID_Array_9 char
PATax_Detail_ID_Array_10 char
PATax_Amount_Array_1 numeric
PATax_Amount_Array_2 numeric
PATax_Amount_Array_3 numeric
PATax_Amount_Array_4 numeric
PATax_Amount_Array_5 numeric
PATax_Amount_Array_6 numeric
PATax_Amount_Array_7 numeric
PATax_Amount_Array_8 numeric
PATax_Amount_Array_9 numeric
PATax_Amount_Array_10 numeric
PAOTaxAmtArr_1 numeric
PAOTaxAmtArr_2 numeric
PAOTaxAmtArr_3 numeric
PAOTaxAmtArr_4 numeric
PAOTaxAmtArr_5 numeric
PAOTaxAmtArr_6 numeric
PAOTaxAmtArr_7 numeric
PAOTaxAmtArr_8 numeric
PAOTaxAmtArr_9 numeric
PAOTaxAmtArr_10 numeric
PAbillnoteidx numeric

 PA Billing...(more) Join Now PA01101.PAbillnoteidx
PAitemnumber char
ITEMNMBR char

 span style...(more) Join Now JC00701.ITEMNMBR
join ... more text available
ITEMDESC char

 Item Descr...(more) Join Now WO010116.ITEMDESC
SERLTNUM char

 Serial/Lot...(more) Join Now RVPS0132.SERLTNUM
PAbllngtype smallint

 PA Billing...(more) Join Now PA11801.PAbllngtype
PAUnit_of_Measure char

 PA Unit of...(more) Join Now PA11801.PAUnit_of_Measure
PAMARKPERCENT numeric
PAGROSSBILLAMT numeric
PAOGROSSBILLINGAMT numeric
PAMUDP1 smallint
PAMUDD numeric
PAOMUDD numeric
PASales_Tax_Options smallint

 PA Sales T...(more) Join Now PA02101.PASales_Tax_Options
TAXSCHID char
join ... more text available
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
PAtx500 text
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