Dynamics GP Table Reference - COMPANY..ASI25816 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 ASI25816

You are currently viewing the COMPANY database.
Change

COMPANY..ASI25816 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

	PAIFBreak1	char

	PAIFGroupBreak2	char

	PAIFGroupBreak3	char

	PAIFGroupBreak4	char

	PAIFGroupBreak5	char

	PAIFGroupBreak6	char

	PAIFGroupBreak7	char

	PAIFGroupBreak8	char

	PAIFGroupBreak9	char

	PAIFBreak10	char

	PAIFGroupBreak11	char

	PAIFGroupBreak12	char

	PAIFGroupBreak13	char

	PAIFGroupBreak14	char

	PAIFGroupBreak15	char

	PABILLTRXT	smallint

	PADocnumber20	char

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

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

	PAIFLabel	char

	PAIFSTRAmount	char

	PAIFOSTRAMT	char

	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

	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

	PAFeebillamount	numeric

	PAOrigBillingAmtFee	numeric

	PAFeetaxamount	numeric

	PAOrigTaxAmtFee	numeric

	TRDISAMT	numeric	Trade Disc...(more) Join Now	PA11801.TRDISAMT

	ORTDISAM	numeric

	PA_Freight_Amount	numeric

	PAOrigFreightAmt	numeric

	PA_Misc_Amount	numeric

	PAOrigMiscAmt	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

	PATOTTAX	numeric

	PAOrigTotalTaxAmt	numeric

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

	PAOrigRetainerFeeAmt	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

	PAFeeType	smallint	In additio...(more) Join Now	PA02101.PAFeeType

	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

	PA_Applied_Retainer	numeric

	PAOrigAppliedDocAmt	numeric

	PA_Applied_Freight_Misc	numeric

	PAOrigAppliedFreightMisc	numeric

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

DynDeveloper.com

COMPANY..ASI25816 Table Definition

Field Definitions: