Dynamics GP Table Reference - COMPANY..ASI25817 fields

	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 ASI25817

You are currently viewing the COMPANY database.
Change

COMPANY..ASI25817 Table Definition

(COMPANY..)

Field Definitions:

	Column Name	Data 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
	LNITMSEQ	int	Line Item ...(more) Join Now	PA11801.LNITMSEQ

	SEQNUMBR	int	Sequence N...(more) Join Now	HR2EMP02.SEQNUMBR

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

	PAPROJNUMBER	char	PA Project...(more) Join Now	PA11801.PAPROJNUMBER
join ... more text available
	PAIFTMHeading	char

	PAIFTMTrxLine	char

	PAIFTMTrxLinesTotal	char

	PAIFCPFPHeading	char

	PAIFCPFPTrxLine	char

	PAIFCPFPTrxLinesTotal	char

	PAIFFeeHeading	char

	PAIFFeeLine	char

	PAIFFeeLinesTotal	char

	PAIFTaxLine	char

	PAIFTotalLine1	char

	PAIFFooterLine	char

	PAIFNoteLine	char

	PADocnumber20	char

	PAIFDescription	char

	PAIFDescription2	char

	PAIFNotFirstOnList_1	tinyint

	PAIFNotFirstOnList_2	tinyint

	PA_Inv_Frmt_Divider	smallint

	PAInvFrmtAmount	numeric

	PAInvFrmtAmount1	numeric

	PAInvFrmtTaxDetailID_1	char

	PAInvFrmtTaxDetailID_2	char

	PAInvFrmtTaxDetailID_3	char

	PAInvFrmtTaxDetailID_4	char

	PAInvFrmtTaxDetailID_5	char

	PAInvFrmtTaxDetailID_6	char

	PAInvFrmtTaxDetailID_7	char

	PAInvFrmtTaxDetailID_8	char

	PAInvFrmtTaxDetailID_9	char

	PAInvFrmtTaxDetailID_10	char

	PAIFTaxDetailName_1	char

	PAIFTaxDetailName_2	char

	PAIFTaxDetailName_3	char

	PAIFTaxDetailName_4	char

	PAIFTaxDetailName_5	char

	PAIFTaxDetailName_6	char

	PAIFTaxDetailName_7	char

	PAIFTaxDetailName_8	char

	PAIFTaxDetailName_9	char

	PAIFTaxDetailName_10	char

	PAIFTaxAmount_1	numeric

	PAIFTaxAmount_2	numeric

	PAIFTaxAmount_3	numeric

	PAIFTaxAmount_4	numeric

	PAIFTaxAmount_5	numeric

	PAIFTaxAmount_6	numeric

	PAIFTaxAmount_7	numeric

	PAIFTaxAmount_8	numeric

	PAIFTaxAmount_9	numeric

	PAIFTaxAmount_10	numeric

	PAIFTaxAmount1_1	numeric

	PAIFTaxAmount1_2	numeric

	PAIFTaxAmount1_3	numeric

	PAIFTaxAmount1_4	numeric

	PAIFTaxAmount1_5	numeric

	PAIFTaxAmount1_6	numeric

	PAIFTaxAmount1_7	numeric

	PAIFTaxAmount1_8	numeric

	PAIFTaxAmount1_9	numeric

	PAIFTaxAmount1_10	numeric

	PACOSTDATE	datetime

	PAQtyQ	numeric

	PAACREV	numeric

	PAORIACCRREV	numeric

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

	PAApproved_Billing_Amou	numeric

	PAOrigApprBillAmt	numeric

	PARecognizedRevenue	numeric

	PAOrigRecogRevenue	numeric

	PATMtaxamt	numeric

	PAOrigTaxAmtTM_	numeric

	PATOTALOVERH	numeric

	PAORIGTOTOVRHD	numeric

	PAPercentCompleted	numeric

	PATOTCST	numeric

	PAORIGTOTCOST	numeric

	PATQTY	numeric

	PAFFbillamount	numeric

	PAOrigBillingAmtFF	numeric

	PAFFtaxamt	numeric

	PAOrigTaxAmtFF	numeric

	PAPreviously_Billed	numeric

	PAOrigPrevBill	numeric

	PAAmount_Earned	numeric

	PAOrigAmtEarned	numeric

	PABACKBILL	numeric

	PAOrigBackoutBillAmt	numeric

	PARetentionFeeAmount	numeric	PA Retenti...(more) Join Now	PA01101.PARetentionFeeAmount

	PAOrigRetentionFeeAmt	numeric

	PA_Trade_Discount_Amount	numeric

	PAOrigTradeDiscAmt	numeric

	PAFeeID	char	PA Fee ID ...(more) Join Now	PA05200.PAFeeID

	PAFeebillamount	numeric

	PAOrigBillingAmtFee	numeric

	PAFeetaxamount	numeric

	PAOrigTaxAmtFee	numeric

	PAUD1	char	PA User De...(more) Join Now	PA11801.PAUD1

	PAUD2	char	PA User De...(more) Join Now	PA11801.PAUD2

	PA_Previous_Retention	numeric

	PAOPREVRETENTION	numeric

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

	PAOrigWUDAmt	numeric

	PAWrite_UpDown_Percenta	int

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

	PAProject_Amount	numeric	PA Project...(more) Join Now	PA01101.PAProject_Amount

	PAProject_Amount1	numeric

	PATOTCHGORDAMT	numeric

	PATOTCHGORDAMT2	numeric

	PACOBASEPROJAMT	numeric

	PACOBASEPROJAMT2	numeric

	PACOBSLNFEEPROJAMT	numeric

	PACOBSLNFEEPROJAMT2	numeric

	PATOTCHGORDAMT1	numeric

	PATOTCHGORDAMT11	numeric

	PACOBASEPROJAMT1	numeric

	PACOBASEPROJAMT11	numeric

	PACOBSLNFEEPROJAMT1	numeric

	PACOBSLNFEEPROJAMT11	numeric

	PAPostedBillingsN	numeric	PA Actual ...(more) Join Now	PA01101.PAPostedBillingsN

	PAPostedBillingsN1	numeric

	PAPOSTRETAMT	numeric	PA Actual ...(more) Join Now	PA01101.PAPOSTRETAMT

	PAPOSTRETAMT1	numeric

	PABillingAmount1	numeric

	PAOrigBillAmount1	numeric

	PATMbillamount1	numeric

	PAOrigBillingAmtTM1	numeric

	PAFFbillamount1	numeric

	PAOrigBillingAmtFF1	numeric

	PAFeebillamount1	numeric

	PAOrigBillingAmtFee1	numeric

	PAtotbillings	numeric

	PAOrigTotalBilings	numeric

	PAFeebillamount2	numeric

	PAFeebillamount21	numeric

	PAFeebillamount211	numeric

	PAFeebillamount2111	numeric

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

	DEX_ROW_ID	int auto number (1,1)	Unique ide...(more) Join Now

DynDeveloper.com

COMPANY..ASI25817 Table Definition

Field Definitions: