GL


Field Name	Label	Col-Label	Format	Dec
BankAPDiscountGL_ID	AP Discount Account	AP Discount	9999999999
BankAPInterestGL_ID	AP Interest Account		9999999999
BankARDiscountGL_ID	AR Discount Account	AR Discount	9999999999
BankARInterestGL_ID	AR Interest Account		9999999999
BankDiscountGL_ID	Discount Account		9999999999
BankJournalProfile_ID	Banking Daybook Profile		9999999999
BudgetGroup_ID	Budget Group 1		9999999999
BusinessRelation_ID	Link to BusinessRelation		9999999999
CashGroup_ID	Cash Group		9999999999
CashInJournalProfile_ID	Cash Received Daybook Profile		9999999999
CashOutJournalProfile_ID	Cash Paid Daybook Profile		9999999999
CostCentreProfile_ID	Link to Profile		9999999999
Currency_ID	Currency Code	Curr	9999999999
CustomCombo0	Custom Combo Field		x(20)
CustomCombo1	Custom Combo Field		x(20)
CustomCombo10	Custom Combo Field		x(20)
CustomCombo11	Custom Combo Field		x(20)
CustomCombo12	Custom Combo Field		x(20)
CustomCombo13	Custom Combo Field		x(20)
CustomCombo14	Custom Combo Field		x(20)
CustomCombo2	Custom Combo Field		x(20)
CustomCombo3	Custom Combo Field		x(20)
CustomCombo4	Custom Combo Field		x(20)
CustomCombo5	Custom Combo Field		x(20)
CustomCombo6	Custom Combo Field		x(20)
CustomCombo7	Custom Combo Field		x(20)
CustomCombo8	Custom Combo Field		x(20)
CustomCombo9	Custom Combo Field		x(20)
CustomDate0	Custom Date Field		99/99/9999
CustomDate1	Custom Date Field		99/99/9999
CustomDate2	Custom Date Field		99/99/9999
CustomDate3	Custom Date Field		99/99/9999
CustomDate4	Custom Date Field		99/99/9999
CustomDecimal0	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal1	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal2	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal3	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal4	Custom Decimal Field		->,>>>,>>9.99	4
CustomInteger0	Custom Integer Field		->,>>>,>>9
CustomInteger1	Custom Integer Field		->,>>>,>>9
CustomInteger2	Custom Integer Field		->,>>>,>>9
CustomInteger3	Custom Integer Field		->,>>>,>>9
CustomInteger4	Custom Integer Field		->,>>>,>>9
CustomLong0	Custom Long Field		x(255)
CustomLong1	Custom Long Field		x(255)
CustomNote	Custom Note Field		x(2000)
CustomShort0	Custom Short Field		x(20)
CustomShort1	Custom Short Field		x(20)
CustomShort10	Custom Short Field		x(20)
CustomShort11	Custom Short Field		x(20)
CustomShort12	Custom Short Field		x(20)
CustomShort13	Custom Short Field		x(20)
CustomShort14	Custom Short Field		x(20)
CustomShort15	Custom Short Field		x(20)
CustomShort16	Custom Short Field		x(20)
CustomShort17	Custom Short Field		x(20)
CustomShort18	Custom Short Field		x(20)
CustomShort19	Custom Short Field		x(20)
CustomShort2	Custom Short Field		x(20)
CustomShort3	Custom Short Field		x(20)
CustomShort4	Custom Short Field		x(20)
CustomShort5	Custom Short Field		x(20)
CustomShort6	Custom Short Field		x(20)
CustomShort7	Custom Short Field		x(20)
CustomShort8	Custom Short Field		x(20)
CustomShort9	Custom Short Field		x(20)
DeductionJournalProfile_ID	Deduction Daybook Profile		9999999999
DivisionProfile_ID	Link to Profile		9999999999
GL_ID	Record ID		9999999999
GLAnalysisLimitation	Analysis Limitation	Analysis Limit	x(20)
GLAnalysisSetOnByUsr_ID	Link to Usr		9999999999
GLAnalysisSetOnOnDate	GL Analysis Set On Date		99/99/9999
GLCategory	Category		x(20)
GLCode	Account		x(8)
GLDescription	Description		x(24)
GLDivisionSetOnByUsr_ID	Link to Usr		9999999999
GLDivisionSetOnOnDate	GL Sub-Account Set On Date		99/99/9999
GLExchangeMethod	Consolidation Method		x(20)
GLIsActive	Active		yes/no
GLIsAutomaticAccount	Automatic Account	Auto	yes/no
GLIsBalanceAccount	Balance Account		yes/no
GLIsCostCentreAccount	Cost Center Account		yes/no
GLIsDebitAccount	Debit/Credit		yes/no
GLIsDivisionAccount	Sub-Account		yes/no
GLIsFixedInterco	Fixed Intercompany	Fixed IC	yes/no
GLIsIntercoAccount	Intercompany Account		yes/no
GLIsLocalCurrency	Base Currency Only	Base Curr	yes/no
GLIsProjectAccount	Project Analysis	Proj Analysis	yes/no
GLIsQuantityAccount	Quantity		yes/no
GLIsSafAccount	SAF Enabled	SAF	yes/no
GLIsValueDate	Value Dates	Val Date	yes/no
GLIsWithBudget	Budget Enabled		yes/no
GLRevaluationCCMethod	SC Revaluation Method	SC Rev Method	x(20)
GLRevaluationMethod	TC Revaluation Method	TC Rev Method	x(20)
GLSystemTypeCode	System Type	Sys Type	x(20)
GLTypeCode	GL Type		x(20)
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
ProjectProfile_ID	Link to Profile		9999999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Report2BudgetGroup_ID	Budget Group 2		9999999999
Report3BudgetGroup_ID	Budget Group 3		9999999999
Report4BudgetGroup_ID	Budget Group 4		9999999999
RevalCCExchangeRateType_ID	Link to ExchangeRateType		9999999999
RevalExchangeRateType_ID	Link to ExchangeRateType		9999999999
RevaluationGL_ID	Link to GL		9999999999
SharedSet_ID	Link to SharedSet		9999999999
Unit_ID	GL Account Unit of Measure	UM	9999999999
UsrDefExchangeRateType_ID	Consolidation Rate Type	Rate Type	9999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	BankAPDiscGLIdx	no	BankAPDiscountGL_ID	yes	no
	BankAPIntGLIdx	no	BankAPInterestGL_ID	yes	no
	BankARDiscGLIdx	no	BankARDiscountGL_ID	yes	no
	BankARIntGLIdx	no	BankARInterestGL_ID	yes	no
	BankDiscGLIdx	no	BankDiscountGL_ID	yes	no
	BankJrnlProfIdx	no	BankJournalProfile_ID	yes	no
	BudgetGroup	no	BudgetGroup_ID	yes	no
	BusinessRelation	no	BusinessRelation_ID	yes	no
	CashGroupIdx	no	CashGroup_ID	yes	no
	CashInProfIdx	no	CashInJournalProfile_ID	yes	no
	CashOutProfIdx	no	CashOutJournalProfile_ID	yes	no
	CCProfIdx	no	CostCentreProfile_ID	yes	no
	Code	no	GLCode	yes	no
	CurrencyIdx	no	Currency_ID	yes	no
	DeductProfile	no	DeductionJournalProfile_ID	yes	no
	DivOnUsrIdx	no	GLDivisionSetOnByUsr_ID	yes	no
	DivProfIdx	no	DivisionProfile_ID	yes	no
	GLAnalOnUsrIdx	no	GLAnalysisSetOnByUsr_ID	yes	no
	GLDescription	no	GLDescription	yes	no
	GLIsBalIdx	no	GLIsBalanceAccount	yes	no
	GLIsWithBudgetIdx	no	GLIsWithBudget	yes	no
	GLSystemTypeIdx	no	GLSystemTypeCode	yes	no
	GLType	no	GLTypeCode	yes	no
	IsActive	no	GLIsActive	yes	no
	LastModIdx	no	LastModifiedDate	yes	no
∗	Prim	yes	GL_ID	yes	no
	ProjProfIdx	no	ProjectProfile_ID	yes	no
	Rep2BudGrpIdx	no	Report2BudgetGroup_ID	yes	no
	Rep3BudGrpIdx	no	Report3BudgetGroup_ID	yes	no
	Rep4BudGrpIdx	no	Report4BudgetGroup_ID	yes	no
	RevalCCExchRtIdx	no	RevalCCExchangeRateType_ID	yes	no
	RevalExchRtIdx	no	RevalExchangeRateType_ID	yes	no
	RevaluationGL	no	RevaluationGL_ID	yes	no
	SharedSet	no	SharedSet_ID	yes	no
	SharedSetAndCode	yes	SharedSet_ID	yes	no
			GLCode	yes	no
	UnitIdx	no	Unit_ID	yes	no
	UsrDefExchRtIdx	no	UsrDefExchangeRateType_ID	yes	no
	ViewIndex	no	SharedSet_ID	yes	no
			GLIsActive	yes	no
			GLCode	yes	no