AAG20001 - aaSubLedgerDist | Prospr - Dynamics GP Table Reference

AAG20001 - aaSubLedgerDist

Query Builder

Select * from AAG20001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
aaSubLedgerHdrID	aaSubLedgerHdrID	Long Integer	4	View
aaSubLedgerDistID	aaSubLedgerDistID	Long Integer	4	View
INTERID	Intercompany ID	String	6	View
CorrespondingUnit	CorrespondingUnit	String	6	View
ACTINDX	Account Index	Long Integer	4	View
DISTTYPE	Distribution Type 1 = Cash 2 = Payable 3 = Discount Available 4 = Discount Taken 5 = Finance Charge 6 = Purchase 8 = Misc. Charge 9 = Freight 10 = Taxes 11 = Writeoffs 12 = Other 13 = GST Disc	Integer	2	View
ACCTTYPE	Account Type Field values: 1 = Posting Account 2 = Unit Account 3 = Posting Allocation Account 4 = Unit Allocation Account	Integer	2	View
aaBrowseType	aaBrowseType	Integer	2	View
DECPLACS	Decimal Places	Integer	2	View
DEBITAMT	Debit Amount	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
SEQNUMBR	Sequence Number	Long Integer	4	View
GLPOSTDT	GL Posting Date	Date	4	View
aaCustID	aaCustID	String	16	View
aaVendID	aaVendID	String	16	View
aaSiteID	aaSiteID	String	12	View
aaItemID	aaItemID	String	32	View
EMPLOYID	Employee ID	String	16	View
aaAssetID	aaAssetID	String	22	View
aaBookID	aaBookID	String	16	View
aaCopyStatus	aaCopyStatus	Integer	2	View
aaWinWasOpen	aaWinWasOpen	Boolean	2	View
POSTED	Posted	Boolean	2	View
HISTORY	History	Boolean	2	View
aaDistErrors	aaDistErrors	Long Integer	4	View
APTVCHNM	Apply To Voucher Number	String	22	View
APTODCTY	Apply To Document Type	Integer	2	View
aaFutureDist	aaFutureDist	Long Integer	4	View
aaOffsetAcct	aaOffsetAccount	Boolean	2	View
ITEMNMBR	Item Number	String	32	View
TRXLOCTN	TRX Location	String	12	View
BINNMBR	Bin Number	String	22	View
TRNSTLOC	Transfer To Location	String	12	View
TRXQTY	TRX QTY	Currency	10	View
PYRLRTYP	Payroll Record Type 1 = Regular Pay Codes 2 = Deductions 3 = Benefits 4 = Taxes 5 = LocalTax	Integer	2	View
TRXNUMBER	TRX Number	Long Integer	4	View
aaChangeDate	aaChangeDate	Date	4	View
aaChangeTime	aaChangeTime	Time	4	View

AAG20001 - aaSubLedgerDist

Query Builder

Customer Service

Information

My Account

Contact Us