ASIEXP12 - ASI GL Transaction SmartList | Prospr

ASIEXP12 - ASI GL Transaction SmartList

Query Builder

Select * from ASIEXP12

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Order_By	ASI_Order_By	Long Integer	4	View
JRNENTRY	Journal Entry	Long Integer	4	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
ASI_Document_Status	ASI_Document_Status	Integer	2	View
RCTRXSEQ	Recurring TRX Sequence	Currency	10	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
REFRENCE	Reference	String	32	View
DSCRIPTN	Description	String	32	View
TRXDATE	TRX Date	Date	4	View
ACTINDX	Account Index	Long Integer	4	View
POLLDTRX	Polled Transaction	Boolean	2	View
RVRSNGDT	Reversing Date	Date	4	View
RCRNGTRX	Recurring TRX	Boolean	2	View
BALFRCLC	Balance For Calculation 0 = Year To Date 1 = TRX Period	Integer	2	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
LASTUSER	Last User	String	16	View
LSTDTEDT	Last Date Edited	Date	4	View
USWHPSTD	User Who Posted	String	16	View
ORGNTSRC	Originating Source	String	16	View
ORGNATYP	Originating Type	Integer	2	View
QKOFSET	Quick Offset	Integer	2	View
TRXTYPE	Transaction Type	Integer	2	View
SQNCLINE	Sequence Line	Currency	10	View
TRXSORCE	TRX Source	String	14	View
RVTRXSRC	Reversing TRX Source	String	14	View
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
ORTRXTYP	Originating TRX Type	Integer	2	View
ORCTRNUM	Originating Control Number	String	22	View
ORMSTRID	Originating Master ID	String	32	View
ORMSTRNM	Originating Master Name	String	66	View
ORDOCNUM	Originating Document Number	String	22	View
ORPSTDDT	Originating Posted Date	Date	4	View
ORTRXSRC	Originating TRX Source	String	14	View
OrigDTASeries	Originating DTA Series	Integer	2	View
OrigSeqNum	Originating Sequence Number	Long Integer	4	View
DTA_GL_Status	DTA GL Status	Integer	2	View
DTAControlNum	DTA Control Number	String	22	View
DTATRXType	DTA TRX Type	Integer	2	View
DTA_Index	DTA Index	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
NOTEINDX	Note Index	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
DEBITAMT	Debit Amount	Currency	10	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
PERIODID	Period ID	Integer	2	View
OPENYEAR	Open Year	Integer	2	View
HSTYEAR	History Year	Integer	2	View
CLOSEDYR	Closed Year	Integer	2	View
HISTRX	History TRX	Boolean	2	View
REVPRDID	Reversing Period ID	Integer	2	View
REVYEAR	Reversing Year	Integer	2	View
REVCLYR	Reversing Closed Year	Integer	2	View
REVHIST	Reversing History TRX	Boolean	2	View
ERRSTATE	Error State	Long Integer	4	View
ICTRX	IC TRX	Boolean	2	View
ORCOMID	Originating Company ID	String	6	View
ORIGINJE	Originating Journal Entry	Long Integer	4	View
ICDISTS	ICDists	Boolean	2	View
PRNTSTUS	Printing Status	Integer	2	View
DOCDATE	Document Date	Date	4	View
ACTNUMBR_1	Account Number:Account_Segment_Pool1	String	10	View
ACTNUMBR_2	Account Number:Account_Segment_Pool2	String	10	View
ACTNUMBR_3	Account Number:Account_Segment_Pool3	String	10	View
ACTNUMBR_4	Account Number:Account_Segment_Pool4	String	10	View
ACTNUMBR_5	Account Number:Account_Segment_Pool5	String	10	View
ACTDESCR	Account Description	String	52	View
ACCTTYPE	Account Type Field values: 1 = Posting Account 2 = Unit Account 3 = Posting Allocation Account 4 = Unit Allocation Account	Integer	2	View
PSTNGTYP	Posting Type 0 = Balance Sheet 1 = Profit and Loss	Integer	2	View
TRXAMNT	TRX Amount	Currency	10	View
FXDORVAR	Fixed Or Variable 1 = Fixed Allocation 2 = Variable Allocation	Integer	2	View
INTERID	Intercompany ID	String	6	View
ORIGAMT	Originating Amount	Currency	10	View
DECPLACS	Decimal Places	Integer	2	View
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
GLHDRMSG	GL HDR Messages	Long Integer	4	View
GLHDRMS2	GL HDR Messages2	Long Integer	4	View
GLHDRVAL	GL Header Valid	Long Integer	4	View
GLLINMSG	GL LINE Messages	Long Integer	4	View
GLLINMS2	GL LINE Messages2	Long Integer	4	View
GLLINVAL	GL Line Valid	Long Integer	4	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
PPSGNMBR	Period Posting Number	Long Integer	4	View
PSTGNMBR	Posting Number	Long Integer	4	View
LNESTAT	Line Status	Integer	2	View
ASI_Account_Type	ASI_Account_Type	Integer	2	View
ASI_Posting_Type	ASI_Posting_Type	Integer	2	View
MNACSGMT	Main Account Segment	String	68	View
ACCATNUM	Account Category Number 1 = Cash 2 = Short Term Investments 3 = Accounts Receivable 4 = Notes Receivable 5 = Inventory 6 = Work In Process 7 = Prepaid Expenses 8 = Long-Term Investments 9 = Property, Plant and Equipment 10 = Accumulated Depreciation 11 = Intangible Assets 12 = Other Assets 13 = Accounts Payable 14 = Notes Payable 15 = Current Maturities Of Long-Term Debt 16 = Taxes Payable 17 = Interest Payable 18 = Dividends Payable 19 = Leases Payable (Current) 20 = Sinking Fund Payable (Current) 21 = Other Current Liabilities 22 = Long-Term Debt 23 = Common Stock 24 = Preferred Stock 25 = Additional Paid-In Capital - Common 26 = Additional Paid-In Capital - Preferred 27 = Retained Earnings 28 = Treasury Stock 29 = Common Dividends 30 = Preferred Dividends 31 = Sales 32 = Sales Returns And Discounts 33 = Cost Of Goods Sold 34 = Selling Expense 35 = Administrative Expense 36 = Salaries Expense 37 = Other Employee Expenses 38 = Interest Expense 39 = Tax Expense 40 = Depreciation Expense 41 = Income Tax Expense 42 = Other Expenses 43 = Other Income 44 = Charges Not Using Working Capital 45 = Revenues Not Producing Working Capital 46 = Gain/Loss On Asset Disposal 47 = Amortization Of Intangible Assets 48 = Non-Financial Accounts	Integer	2	View
ACTIVE	Active 0 = False, for inactive records 1 = True, for active records	Boolean	2	View
TPCLBLNC	Typical Balance 0 = Debit 1 = Credit	Integer	2	View
ASI_Decimal_Places	ASI_Decimal_Places	Integer	2	View
ASI_Account_Description	ASI_Account_Description	String	52	View
ASI_Fixed_Or_Variable	ASI_Fixed_Or_Variable	Integer	2	View
ASI_Balance_For_Calculat	ASI_Balance_For_Calculation	Integer	2	View
DSPLKUPS	Display In Lookups 1 = Sales 2 = Inventory 3 = Purchasing 4 = Payroll	Long Integer	4	View
CNVRMTHD	Conversion Method 1 = Current Rate 2 = Average Rate 3 = Historical Rate	Integer	2	View
HSTRCLRT	Historical Rate	Currency (Variable)	10	View
NOTEINDX1	ASI_Note_Index	Currency	10	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
PostSlsIn	Post Sales In 1 = Detail 2 = Summary	Integer	2	View
PostIvIn	Post Inventory In 1 = Detail 2 = Summary	Integer	2	View
PostPurchIn	Post Purchasing In 1 = Detail 2 = Summary	Integer	2	View
PostPRIn	Post Payroll In 1 = Detail 2 = Summary	Integer	2	View
ADJINFL	Adjust for Inflation	Boolean	2	View
INFLAEQU	Inflation Equity Account Index	Long Integer	4	View
INFLAREV	Inflation Revenue Account Index	Long Integer	4	View
ALIAS	Alias	Integer	2	View
CorrespondingUnit	CorrespondingUnit	String	6	View
Tax_Date	Tax Date	Date	4	View
VOIDED	Voided	Boolean	2	View
Back_Out_JE	Back Out JE	Long Integer	4	View
Back_Out_JE_Year	Back Out JE Year	Integer	2	View
Original_JE	Original JE	Long Integer	4	View
Original_JE_Year	Original JE Year	Integer	2	View
Original_JE_Seq_Num	Original JE Seq Num	Currency	10	View
Correcting_JE	Correcting JE	Long Integer	4	View
Correcting_JE_Year	Correcting JE Year	Integer	2	View

ASIEXP12 - ASI GL Transaction SmartList

Query Builder

Customer Service

Information

My Account

Contact Us