Dynamics GP Table Reference - COMPANY..ASI25844 fields

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

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Module List > Module ASI tables ASI25844

You are currently viewing the COMPANY database.
Change

COMPANY..ASI25844 Table Definition

(COMPANY..)

Field Definitions:

What is the 'source' column?

	Column Name	Data Type Default Value		Source
	CMPANYID	smallint	Company ID...(more) Join Now	WPPU0114.CMPANYID
join ... more text available
	USERID	char	The user t...(more) Join Now
join ... more text available
	PABILLTRXT	smallint

	PADocnumber20	char

	LNITMSEQ	int	Line Item ...(more) Join Now	PA11801.LNITMSEQ

	PASSN	int

	PACOSTDOCNO	char

	PACOSTSEQNO	int

	PAPROJNUMBER	char	PA Project...(more) Join Now	PA11801.PAPROJNUMBER
join ... more text available
	PATU	smallint	PA Transac...(more) Join Now	PA11801.PATU

	PACOSTCATID	char	PA Cost Ca...(more) Join Now	PA11801.PACOSTCATID

	PAbllngtype	smallint	PA Billing...(more) Join Now	PA11801.PAbllngtype

	PACOSTDATE	datetime

	PACOSTOWNER	char

	PAUnit_of_Measure	char	PA Unit of...(more) Join Now	PA11801.PAUnit_of_Measure

	PAUNITCOST	numeric	PA Unit Co...(more) Join Now	PA11801.PAUNITCOST

	PAOrigUnitCost	numeric

	PAProfitType	smallint	PA Profit ...(more) Join Now	PA11801.PAProfitType

	PABILRATE	numeric

	PAORIGBILLRATE	numeric

	PAMARKPERCENT	numeric

	PAQtyQ	numeric

	PAACREV	numeric

	PAORIACCRREV	numeric

	PATOTCST	numeric

	PAORIGTOTCOST	numeric

	PAWrite_UpDown_Amount	numeric	PA Write U...(more) Join Now	PA11801.PAWrite_UpDown_Amount

	PAOrigWUDAmt	numeric

	PAWrite_UpDown_Percenta	int

	PAApproved_Quantity	numeric	PA Approve...(more) Join Now	PA11801.PAApproved_Quantity

	PAAPPROVBILLRATE	numeric

	PAOrigApprBillRate	numeric

	PAAPPROVMKUPPCT	numeric

	PAApproved_Billing_Amou	numeric

	PAOrigApprBillAmt	numeric

	PARecognizedRevenue	numeric

	PAOrigRecogRevenue	numeric

	PAbillnoteidx	numeric	PA Billing...(more) Join Now	PA01101.PAbillnoteidx

	PATMtaxamt	numeric

	PAOrigTaxAmtTM_	numeric

	PAbilltaxscheduleid	char	PA Billing...(more) Join Now	PA23201.PAbilltaxscheduleid

	PABACKBILL	numeric

	PAOrigBackoutBillAmt	numeric

	PA_Trade_Discount_Amount	numeric

	PAOrigTradeDiscAmt	numeric

	PAAR_IDX	int	From the R...(more) Join Now	PA13203.PAAR_IDX

	PACogs_Idx	int	ACTIDX of ...(more) Join Now	PA30101.PACogs_Idx

	PARev_IDX	int

	PAUnbilled_AR_Idx	int

	PAUnbilled_Proj_Rev_Idx	int

	PACGBWIPIDX	int	ACTIDX of ...(more) Join Now	PA30101.PACGBWIPIDX

	PABillSublineErrors	binary

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

	PACOSTCATNME	char

	PACost_Owner_Name	char

	PACOSTCATCLASNME	char

	PA_Cost_Owner_Class_Name	char

	PAJob_Title	char

	PAJobTitleDescription	char

	PABillingDTLLineItemSeq	int

	PATOTALOVERH	numeric

	PAORIGTOTOVRHD	numeric

	PAREFNO	char

	PAReference_Line_Seq_N	int

	PACHGORDNO	char	PA Change ...(more) Join Now	PA05200.PACHGORDNO

	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

DynDeveloper.com

COMPANY..ASI25844 Table Definition

Field Definitions: