GP Tables

ASIEXP12 - ASI GL Transaction SmartList

Dynamics GP table ASIEXP12 (ASI GL Transaction SmartList) contains 130 columns including ASI_Order_By, JRNENTRY, BACHNUMB....

SQL Query Builder

130 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
JRNENTRY Journal Entry Long Integer 4
BACHNUMB Batch Number String 16
BCHSOURC Batch Source String 16
ASI_Document_Status ASI_Document_Status Integer 2
RCTRXSEQ Recurring TRX Sequence Currency 10
SOURCDOC Source Document1= Invoice2= Finance Charge3= Miscellaneous Charges4= Return5= Credit Memo String 12
REFRENCE Reference String 32
DSCRIPTN Description String 32
TRXDATE TRX Date Date 4
ACTINDX Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. Long Integer 4
POLLDTRX Polled Transaction Boolean 2
RVRSNGDT Reversing Date Date 4
RCRNGTRX Recurring TRX Boolean 2
BALFRCLC Balance For Calculation0 = Year To Date1 = TRX Period Integer 2
PSTGSTUS Posting Status1 = Work2 = Open3 = History4 = Originating Integer 2
Posting Status values (11)
0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
LASTUSER Last User String 16
LSTDTEDT Last Date Edited Date 4
USWHPSTD User Who Posted String 16
ORGNTSRC Originating Source String 16
ORGNATYP Originating Type Integer 2
QKOFSET Quick Offset Integer 2
TRXTYPE Transaction Type Integer 2
Transaction Type values (2)
0 = Standard1 = Reversing
SQNCLINE Sequence Line Currency 10
TRXSORCE TRX Source String 14
RVTRXSRC Reversing TRX Source String 14
SERIES Series1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll - USA7 = Project Integer 2
Module Series values (8)
1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll7 = Project10 = 3rd Party
ORTRXTYP Originating TRX Type Integer 2
ORCTRNUM Originating Control Number String 22
ORMSTRID Originating Master ID String 32
ORMSTRNM Originating Master Name String 66
ORDOCNUM Originating Document Number String 22
ORPSTDDT Originating Posted Date Date 4
ORTRXSRC Originating TRX Source String 14
OrigDTASeries Originating DTA Series Integer 2
OrigSeqNum Originating Sequence Number Long Integer 4
DTA_GL_Status DTA GL Status Integer 2
DTAControlNum DTA Control Number String 22
DTATRXType DTA TRX Type Integer 2
DTA_Index DTA Index Currency 10
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
CURRNIDX Currency Index Integer 2
RATETPID Rate Type ID String 16
EXGTBLID Exchange Table ID String 16
XCHGRATE Exchange Rate Currency (Variable) 10
EXCHDATE Exchange Date Date 4
TIME1 Time Time 4
RTCLCMTD Rate Calculation Method Integer 2
NOTEINDX Note Index Currency 10
CRDTAMNT Credit Amount Currency 10
DEBITAMT Debit Amount Currency 10
ORCRDAMT Originating Credit Amount Currency 10
ORDBTAMT Originating Debit Amount Currency 10
PERIODID Period ID Integer 2
OPENYEAR Open Year Integer 2
HSTYEAR History Year Integer 2
CLOSEDYR Closed Year Integer 2
HISTRX History TRX Boolean 2
REVPRDID Reversing Period ID Integer 2
REVYEAR Reversing Year Integer 2
REVCLYR Reversing Closed Year Integer 2
REVHIST Reversing History TRX Boolean 2
ERRSTATE Error State Long Integer 4
ICTRX IC TRX Boolean 2
ORCOMID Originating Company ID String 6
ORIGINJE Originating Journal Entry Long Integer 4
ICDISTS ICDists Boolean 2
PRNTSTUS Printing Status Integer 2
DOCDATE Document Date Date 4
ACTNUMBR_1 Account Number:Account_Segment_Pool1 String 10
ACTNUMBR_2 Account Number:Account_Segment_Pool2 String 10
ACTNUMBR_3 Account Number:Account_Segment_Pool3 String 10
ACTNUMBR_4 Account Number:Account_Segment_Pool4 String 10
ACTNUMBR_5 Account Number:Account_Segment_Pool5 String 10
ACTDESCR Account Description String 52
ACCTTYPE Account TypeField values:1 = Posting Account2 = Unit Account3 = Posting Allocation Account4 = Unit Allocation Account Integer 2
Account Type values (4)
1 = Posting Account2 = Unit Account3 = Posting Allocation Account4 = Unit Allocation Account
PSTNGTYP Posting Type0 = Balance Sheet1 = Profit and Loss Integer 2
Posting Type values (2)
0 = Balance Sheet1 = Profit and Loss
TRXAMNT TRX Amount Currency 10
FXDORVAR Fixed Or Variable1 = Fixed Allocation2 = Variable Allocation Integer 2
Fixed or Variable Allocation values (2)
1 = Fixed Allocation2 = Variable Allocation
INTERID Intercompany ID String 6
ORIGAMT Originating Amount Currency 10
DECPLACS Decimal Places Integer 2
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
GLHDRMSG GL HDR Messages Long Integer 4
GLHDRMS2 GL HDR Messages2 Long Integer 4
GLHDRVAL GL Header Valid Long Integer 4
GLLINMSG GL LINE Messages Long Integer 4
GLLINMS2 GL LINE Messages2 Long Integer 4
GLLINVAL GL Line Valid Long Integer 4
DENXRATE Denomination Exchange Rate Currency (Variable) 10
MCTRXSTT MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = 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
PPSGNMBR Period Posting Number Long Integer 4
PSTGNMBR Posting Number Long Integer 4
LNESTAT Line Status Integer 2
ASI_Account_Type ASI_Account_Type Integer 2
ASI_Posting_Type ASI_Posting_Type Integer 2
MNACSGMT Main Account Segment String 68
ACCATNUM Account Category Number1 = Cash2 = Short Term Investments3 = Accounts Receivable4 = Notes Receivable5 = Inventory6 = Work In Process7 = Prepaid Expenses8 = Long-Term Investments9 = Property, Plant and Equipment10 = Accumulated Depreciation11 = Intangible Assets12 = Other Assets13 = Accounts Payable14 = Notes Payable15 = Current Maturities Of Long-Term Debt16 = Taxes Payable17 = Interest Payable18 = Dividends Payable19 = Leases Payable (Current)20 = Sinking Fund Payable (Current)21 = Other Current Liabilities22 = Long-Term Debt23 = Common Stock24 = Preferred Stock25 = Additional Paid-In Capital - Common26 = Additional Paid-In Capital - Preferred27 = Retained Earnings28 = Treasury Stock29 = Common Dividends30 = Preferred Dividends31 = Sales32 = Sales Returns And Discounts33 = Cost Of Goods Sold34 = Selling Expense35 = Administrative Expense36 = Salaries Expense37 = Other Employee Expenses38 = Interest Expense39 = Tax Expense40 = Depreciation Expense41 = Income Tax Expense42 = Other Expenses43 = Other Income44 = Charges Not Using Working Capital45 = Revenues Not Producing Working Capital46 = Gain/Loss On Asset Disposal47 = Amortization Of Intangible Assets48 = Non-Financial Accounts Integer 2
ACTIVE Active0 = False, for inactive records1 = True, for active records Boolean 2
TPCLBLNC Typical Balance0 = Debit1 = Credit Integer 2
Typical Balance values (2)
0 = Debit1 = Credit
ASI_Decimal_Places ASI_Decimal_Places Integer 2
ASI_Account_Description ASI_Account_Description String 52
ASI_Fixed_Or_Variable ASI_Fixed_Or_Variable Integer 2
ASI_Balance_For_Calculat ASI_Balance_For_Calculation Integer 2
DSPLKUPS Display In Lookups1 = Sales2 = Inventory3 = Purchasing4 = Payroll Long Integer 4
CNVRMTHD Conversion Method1 = Current Rate2 = Average Rate3 = Historical Rate Integer 2
HSTRCLRT Historical Rate Currency (Variable) 10
NOTEINDX1 ASI_Note_Index Currency 10
CREATDDT Created Date Date 4
MODIFDT Modified Date Date 4
USERDEF1 User Defined 1 String 22
USERDEF2 User Defined 2 String 22
PostSlsIn Post Sales In1 = Detail2 = Summary Integer 2
PostIvIn Post Inventory In1 = Detail2 = Summary Integer 2
PostPurchIn Post Purchasing In1 = Detail2 = Summary Integer 2
PostPRIn Post Payroll In1 = Detail2 = Summary Integer 2
ADJINFL Adjust for Inflation Boolean 2
INFLAEQU Inflation Equity Account Index Long Integer 4
INFLAREV Inflation Revenue Account Index Long Integer 4
ALIAS Alias Integer 2
CorrespondingUnit CorrespondingUnit String 6
Tax_Date Tax Date Date 4
VOIDED Voided Boolean 2
Back_Out_JE Back Out JE Long Integer 4
Back_Out_JE_Year Back Out JE Year Integer 2
Original_JE Original JE Long Integer 4
Original_JE_Year Original JE Year Integer 2
Original_JE_Seq_Num Original JE Seq Num Currency 10
Correcting_JE Correcting JE Long Integer 4
Correcting_JE_Year Correcting JE Year Integer 2

Related Tables

Tables that share columns with ASIEXP12. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

TIME1

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP18 ASIEXP19 ASIEXP20

XCHGRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

DENXRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

BACHNUMB

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP19 ASIEXP20 ASIEXP25 ASIEXP27

EXGTBLID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07