GLConsolidCy


Field Name	Label	Col-Label	Format	Dec
Company_ID	Link To Company		-99999999999
CustomCombo0	Custom Combo Field		x(20)
CustomCombo1	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)
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)
ExchangeRateType_ID	Link to ExchnageRateType		-99999999999
GL_ID	Link to GL		-99999999999
GLConsolidCy_ID	Record ID		-99999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999


	Index-Name	Uni	Field-Name	Asc	Abbr
	CyIdx	no	Company_ID	yes	no
	GLIdx	no	GL_ID	yes	no
∗	Prim	yes	GLConsolidCy_ID	yes	no
	RateTpIdx	no	ExchangeRateType_ID	yes	no
	UniqueIdx	yes	GL_ID	yes	no
			Company_ID	yes	no
			ExchangeRateType_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
glcor__qadc01			x(24)
glcor__qadc02			x(24)
glcor_ap	Accounts Payable	AP	yes/no
glcor_ar	Accounts Receivable	AR	yes/no
glcor_cons_trf	Consignment Transfer		yes/no
glcor_cst_adj	Cost Adjustment		yes/no
glcor_cum_wo	Cumulative WO Close		yes/no
glcor_cust_cons	Customer Consignment		yes/no
glcor_do_rcpt	DO Receipt		yes/no
glcor_do_shpmt	DO Shipment		yes/no
glcor_domain	Domain		x(8)
glcor_downtime	Downtime		yes/no
glcor_expense	Expense		yes/no
glcor_ic_wip	WIP Adjustment		yes/no
glcor_inv_adj	Inventory Adjustment		yes/no
glcor_iss_rcpt	WO Issue/Receipt		yes/no
glcor_iss_unp	Issue Unplannned		yes/no
glcor_labor	Labor		yes/no
glcor_mod_date	Modified Date	Mod Date	99/99/99
glcor_mod_userid	User ID		x(8)
glcor_po_rcpt	PO Receipt		yes/no
glcor_rcpt_unp	Receipt Unplannned		yes/no
glcor_rework	Rework		yes/no
glcor_rtn_stk	Return to Stock		yes/no
glcor_rtn_supp	Return to Suppler		yes/no
glcor_scrap	Scrap		yes/no
glcor_so_corr	GL Correction		yes/no
glcor_so_shpmt	SO Shipment		yes/no
glcor_so_summ	GL Summariazation		yes/no
glcor_sub_con	Subcontract		yes/no
glcor_supp_cons	Supplier Consignment		yes/no
glcor_transfer	Transfer		yes/no
glcor_user1	User Field Character 1		x(24)
glcor_user2	User Field Character 2		x(24)
glcor_wo_close	WO Close		yes/no
glcor_wo_wip	WIP Adjustment		yes/no
oid_glcor_ctrl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	glcor_index1	yes	glcor_domain	yes	no
	oid_glcor_ctrl	yes	oid_glcor_ctrl	yes	no


Field Name	Label	Col-Label	Format	Dec
glc__qad01			yes/no
glc__qad02			x(4)
glc__qad03			yes/no
glc__qad04			yes/no
glc_domain	Domain		x(8)
glc_end	Period End	Per End	99/99/99
glc_per	Period	Per	>>9
glc_start	Period Start	Per Beg	99/99/99
glc_user1	Ufld1		x(8)
glc_user2	Ufld2		x(8)
glc_year	Year		9999
glc_yr_end	Year-End/Regular	Year!End	YearEnd/Regular
oid_glc_cal			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	glc_index	yes	glc_domain	yes	no
			glc_year	yes	no
			glc_per	yes	no
	glc_start	no	glc_domain	yes	no
			glc_start	yes	no
	oid_glc_cal	yes	oid_glc_cal	yes	no


Field Name	Label	Col-Label	Format	Dec
ControlGL_ID	Link to Control GL		-99999999999
GLMirror_ID	Record ID		-99999999999
MirrorGL_ID	Link to Mirror GL		-99999999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999


	Index-Name	Uni	Field-Name	Asc	Abbr
	ControlGL	yes	ControlGL_ID	yes	no
	MirrorGL	no	MirrorGL_ID	yes	no
∗	Prim	yes	GLMirror_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
Company_ID	Link to Company		-99999999999
Currency_ID	Link To Currency		-99999999999
GL_ID	Link to GL		-99999999999
GLOpenItem_ID	Record ID		-99999999999
GLOpenItemBalanceCC	SC Balance		->>>,>>>,>>>,>>9.99	4
GLOpenItemBalanceCreditCC	SC Credit Balance		->>>,>>>,>>>,>>9.99	4
GLOpenItemBalanceCreditLC	BC Balance Credit		->>>,>>>,>>>,>>9.99	4
GLOpenItemBalanceCreditTC	TC Credit Balance		->>>,>>>,>>>,>>9.99	4
GLOpenItemBalanceDebitCC	SC Debit Balance		->>>,>>>,>>>,>>9.99	4
GLOpenItemBalanceDebitLC	BC Balance Debit		->>>,>>>,>>>,>>9.99	4
GLOpenItemBalanceDebitTC	TC Debit Balance		->>>,>>>,>>>,>>9.99	4
GLOpenItemBalanceLC	BC Balance		->>>,>>>,>>>,>>9.99	4
GLOpenItemBalanceTC	TC Balance		->>>,>>>,>>>,>>9.99	4
GLOpenItemClosingDate	Closing Date		99/99/9999
GLOpenItemIsOpen	Open		yes/no
GLOpenItemKey	Allocation Key		x(40)
GLOpenItemOriginalCreditCC	SC Original Credit		->>>,>>>,>>>,>>9.99	4
GLOpenItemOriginalCreditLC	BC Original Credit		->>>,>>>,>>>,>>9.99	4
GLOpenItemOriginalCreditTC	TC Original Credit		->>>,>>>,>>>,>>9.99	4
GLOpenItemOriginalDebitCC	SC Original Debit		->>>,>>>,>>>,>>9.99	4
GLOpenItemOriginalDebitLC	BC Original Debit		->>>,>>>,>>>,>>9.99	4
GLOpenItemOriginalDebitTC	TC Original Debit		->>>,>>>,>>>,>>9.99	4
GLOpenItemPeriod	GL Calendar Period		99
GLOpenItemPostDate	Posting Date		99/99/9999
GLOpenItemYear	GL Calendar Year		9999
GLOpenItemYearPeriod	GL Calendar Year/Period		999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
PostingLine_ID	Link to PostingLine		-99999999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999


	Index-Name	Uni	Field-Name	Asc	Abbr
	ClosingDate	no	GLOpenItemClosingDate	yes	no
	CompanyGLClose	no	Company_ID	yes	no
			GL_ID	yes	no
			GLOpenItemClosingDate	yes	no
	CompanyIdx	no	Company_ID	yes	no
	CurrecyIdx	no	Currency_ID	yes	no
	CyGLYPIdx	no	Company_ID	yes	no
			GL_ID	yes	no
			GLOpenItemYearPeriod	yes	no
	CyYrPdIdx	no	Company_ID	yes	no
			GLOpenItemYearPeriod	yes	no
	GL	no	GL_ID	yes	no
	GLClosingDate	no	GL_ID	yes	no
			GLOpenItemClosingDate	yes	no
	GLOpenItemKey	yes	GL_ID	yes	no
			GLOpenItemKey	yes	no
	IsOpenIdx	no	GLOpenItemIsOpen	yes	no
	PdIdx	no	GLOpenItemPeriod	yes	no
	PostDateIdx	no	GLOpenItemPostDate	yes	no
	PostingLine	no	PostingLine_ID	yes	no
∗	prim	yes	GLOpenItem_ID	yes	no
	YrIdx	no	GLOpenItemYear	yes	no


Field Name	Label	Col-Label	Format	Dec
Company_ID	Link to Company (redundant)		-99999999999
Currency_ID	Link To Currency		-99999999999
GL_ID	Link to GL (redundant)		-99999999999
GLOpenItem_ID	Link to GLOpenItem		-99999999999
GLOpenItemMovement_ID	Record ID		-99999999999
GLOpenItemMovementPeriod	GL Calendar Period		99
GLOpenItemMovementPostDate	Posting Date		99/99/9999
GLOpenItemMovementType	Type		x(20)
GLOpenItemMovementYear	GL Calendar Year		9999
GLOpenItemMovementYearPeriod	GL Calendar Year/Period		999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
PostingLine_ID	Link to PostingLine		-99999999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999


	Index-Name	Uni	Field-Name	Asc	Abbr
	CurrecyIdx	no	Currency_ID	yes	no
	CyGLYPIdx	no	Company_ID	yes	no
			GL_ID	yes	no
			GLOpenItemMovementYearPeriod	yes	no
	CyIdx	no	Company_ID	yes	no
	CyYrPdIdx	no	Company_ID	yes	no
			GLOpenItemMovementYearPeriod	yes	no
	GLIdx	no	GLOpenItem_ID	yes	no
	GLOIMovDt	no	GLOpenItemMovementPostDate	yes	no
	GLOIMovTp	no	GLOpenItemMovementType	yes	no
	GLOpenItem	no	GLOpenItem_ID	yes	no
	PdIdx	no	GLOpenItemMovementPeriod	yes	no
	PostLine	no	PostingLine_ID	yes	no
∗	prim	yes	GLOpenItemMovement_ID	yes	no
	YrIdx	no	GLOpenItemMovementYear	yes	no


Field Name	Label	Col-Label	Format	Dec
FromGL_ID	Link to GL		-99999999999
GLReportLink_ID	Record ID		-99999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
ToGL_ID	Link to GL		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	Prim	yes	GLReportLink_ID	yes	no
	UniqueIdx	yes	FromGL_ID	yes	no
			ToGL_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
GL_ID	Link to GL		-99999999999
GLSafDefault_ID	Record ID		-99999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Saf_ID	SAF Code		-99999999999
SafConcept_ID	SAF Concept Code		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	GL	no	GL_ID	yes	no
∗	Prim	yes	GLSafDefault_ID	yes	no
	Saf	no	Saf_ID	yes	no
	SafConcept	no	SafConcept_ID	yes	no
	UniqueIdx	yes	SafConcept_ID	yes	no
			GL_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
GLSystemTypeCode	GL System Type		x(20)
GLSystemTypeIsActive	Active	Act	yes/no
GLSystemTypeTranslated	GL System 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)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999


	Index-Name	Uni	Field-Name	Asc	Abbr
	Active	no	GLSystemTypeIsActive	yes	no
∗	Prim	yes	GLSystemTypeCode	yes	no
	ViewIndex	no	GLSystemTypeIsActive	yes	no
			GLSystemTypeCode	yes	no


Field Name	Label	Col-Label	Format	Dec
gltsaf__qadc01			x(24)
gltsaf__qadc02			x(24)
gltsaf_code	SAF Value		x(20)
gltsaf_concept_code	SAF Code		x(20)
gltsaf_domain	Domain		x(8)
gltsaf_mod_date	Modified Date	Mod Date	99/99/99
gltsaf_mod_userid	User ID		x(8)
gltsaf_user1	User Field Character 1		x(24)
gltsaf_user2	User Field Character 2		x(24)
oid_glt_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_gltsaf_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
	gltsaf_concept	no	gltsaf_domain	yes	no
			gltsaf_concept_code	yes	no
∗	gltsaf_oid_glt_det	yes	oid_glt_det	yes	no
			gltsaf_concept_code	yes	no
	oid_gltsaf_det	yes	oid_gltsaf_det	yes	no


Field Name	Label	Col-Label	Format	Dec
gltw__qadc01			x(8)
gltw_acct	Account		x(8)
gltw_addr	Address		x(8)
gltw_amt	Amount		->,>>>,>>>,>>9.99<<<<<<<	10
gltw_batch	Batch		x(50)
gltw_cc	Cost Ctr	CC	x(4)
gltw_correction	Correction	Corr	yes/no
gltw_curr	Currency	Cur	x(3)
gltw_curramt	Currency Amount		->,>>>,>>>,>>9.99<<<<<<<	10
gltw_date	Date		99/99/99
gltw_desc	Description		x(24)
gltw_doc	Document		x(16)
gltw_doc_typ	Document Type	T	x(2)
gltw_domain	Domain		x(8)
gltw_dy_code	Daybook		x(8)
gltw_dy_num	Entry Num		x(40)
gltw_ecur_amt	Amount in Entity Currency	Amt in Entity Curr	->>,>>>,>>>,>>9.99	10
gltw_effdate	Effective	Eff Date	99/99/99
gltw_entity	Entity		x(20)
gltw_ex_rate	Exchange Rate		>>>>,>>>,>>9.9<<<<<<<<<	10
gltw_ex_rate2	Exch Rate 2		>>>>,>>>,>>9.9<<<<<<<<<	10
gltw_ex_ratetype	Rate Type		x(8)
gltw_exru_seq	Sequence		>>>>>>>>9
gltw_fx_ind	FX Conversion Index	FX	x(1)
gltw_line	Line		>>>9
gltw_project	Project		x(8)
gltw_ref	Reference		x(60)
gltw_rflag	Reversing/Retroactive Line	Rev!Ret	yes/no
gltw_sub	Sub-Account	Sub-Acct	x(8)
gltw_tr_type	Transaction Type	t	x(2)
gltw_user1	Ufld1		x(8)
gltw_user2	Ufld2		x(8)
gltw_userid	Session ID		x(50)
oid_gltw_wkfl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	gltw_ref	yes	gltw_domain	yes	no
			gltw_ref	yes	no
			gltw_line	yes	no
			gltw_rflag	yes	no
	gltw_userid	no	gltw_domain	yes	no
			gltw_userid	yes	no
			gltw_acct	yes	no
			gltw_cc	yes	no
			gltw_project	yes	no
			gltw_effdate	yes	no
	oid_gltw_wkfl	yes	oid_gltw_wkfl	yes	no


Field Name	Label	Col-Label	Format	Dec
GLTypeCode	GL Type		x(20)
GLTypeIsActive	Active	Act	yes/no
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	prim	yes	GLTypeCode	yes	no
	ViewIndex	no	GLTypeIsActive	yes	no
			GLTypeCode	yes	no


Field Name	Label	Col-Label	Format	Dec
glt__qadc01			x(8)
glt_acct	Account		x(8)
glt_addr	Address		x(8)
glt_amt	Amount		->>,>>>,>>>,>>9.99	10
glt_batch	Batch		x(8)
glt_cc	Cost Ctr	CC	x(4)
glt_correction	Correction	Corr	yes/no
glt_curr	Currency	Cur	x(3)
glt_curr_amt	Currency Amount		->>,>>>,>>>,>>9.99	10
glt_date	Entered		99/99/99
glt_desc	Description		x(24)
glt_doc	Document		x(16)
glt_doc_type	Document Type	T	x(2)
glt_domain	Domain		x(8)
glt_dy_code	Daybook		x(8)
glt_dy_num	Entry Number		x(40)
glt_ecur_amt	Amount in Entity Currency	Amt in Entity Curr	->>,>>>,>>>,>>9.99	10
glt_effdate	Effective	Eff Date	99/99/99
glt_en_exrate	Entity Exch Rate		>>>>,>>>,>>9.9<<<<<<<<<	10
glt_en_exrate2	Entity Exch Rate 2		>>>>,>>>,>>9.9<<<<<<<<<	10
glt_en_exru_seq	Sequence		>>>>>>>>9
glt_entity	Entity	Enty	x(20)
glt_entr_exrate	Entered Exchange Rate	Entered Ex Rate	>>,>>9.99999<<<<<	10
glt_error	Error Message		x(16)
glt_ex_rate	Exch Rate		>>>>,>>>,>>9.9<<<<<<<<<	10
glt_ex_rate2	Exch Rate 2		>>>>,>>>,>>9.9<<<<<<<<<	10
glt_ex_ratetype	Rate Type		x(8)
glt_exp	Transaction Posted	Trans!Posted	yes/no
glt_exru_seq	Sequence		>>>>>>>>9
glt_fx_ind	FX Conversion Index	FX	x(1)
glt_interco_ref	Intercompany Reference		x(40)
glt_lgd_nbr	Legal Doc Nbr	Legal Doc	x(12)
glt_line	Line		>>>9
glt_mgmt_curr	Management Currency	Mgmt!Curr	x(3)
glt_mgmt_curr_amt	Management Currency Amount	Mgmt Curr!Amount	->>,>>>,>>>,>>9.99	10
glt_mgmt_ex_rate	Exchange Rate	Exch Rate	>>>>,>>>,>>9.9<<<<<<<<<	10
glt_mgmt_ex_rate2	Management Curr Exchange Rate	Mgmt Curr!Exch Rate	>>>>,>>>,>>9.9<<<<<<<<<	10
glt_mgmt_ex_ratetype	Management Exchange Rate Type	Mgmt Exch!Rate Type	x(8)
glt_mirror_line_ref	Mirror Line Ref	Mirr!LnRef	x(20)
glt_mirror_ref	Mirror Ref	Mirror!Ref	x(20)
glt_per	Period	Per	>>9
glt_proc_by_otp	Proc By OTP		yes/no
glt_project	Project		x(8)
glt_ref	GL Reference		x(14)
glt_rflag	Reversing/Retroactive Line	Rev!Ret	yes/no
glt_src_desc	Source GL Description		x(32)
glt_sub	Sub-Account	Sub-Acct	x(8)
glt_sum_values	Sum Values		x(16)
glt_tmp_nbr	Temporary Number		yes/no
glt_tr_type	Transaction Type	T	x(2)
glt_unb	Unbalanced	Unb	yes/no
glt_user1	Ufld1		x(8)
glt_user2	Ufld2		x(8)
glt_userid	User ID		x(8)
glt_year	Year		9999
oid_glt_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
	glt_acc	no	glt_domain	yes	no
			glt_acct	yes	no
	glt_batch	no	glt_domain	yes	no
			glt_batch	yes	no
			glt_ref	yes	no
			glt_rflag	yes	no
			glt_line	yes	no
	glt_costctr	no	glt_domain	yes	no
			glt_cc	yes	no
	glt_dy_code	no	glt_domain	yes	no
			glt_dy_code	yes	no
			glt_dy_num	yes	no
	glt_eff_ref_line	no	glt_domain	yes	no
			glt_effdate	yes	no
			glt_ref	yes	no
			glt_line	yes	no
	glt_ent_dy_eff_ref	no	glt_domain	yes	no
			glt_entity	yes	no
			glt_dy_code	yes	no
			glt_effdate	yes	no
			glt_ref	yes	no
	glt_ent_eff_ref	no	glt_domain	yes	no
			glt_entity	yes	no
			glt_effdate	yes	no
			glt_ref	yes	no
	glt_index	no	glt_domain	yes	no
			glt_entity	yes	no
			glt_acct	yes	no
			glt_sub	yes	no
			glt_cc	yes	no
			glt_effdate	yes	no
			glt_project	yes	no
			glt_ref	yes	no
	glt_lgd_nbr	no	glt_domain	yes	no
			glt_lgd_nbr	yes	no
	glt_project	no	glt_domain	yes	no
			glt_project	yes	no
∗	glt_ref	yes	glt_domain	yes	no
			glt_ref	yes	no
			glt_rflag	yes	no
			glt_line	yes	no
	glt_ref_line	no	glt_domain	yes	no
			glt_ref	yes	no
			glt_line	yes	no
	glt_ref_proc_by_otp	no	glt_domain	yes	no
			glt_ref	yes	no
			glt_proc_by_otp	yes	no
	glt_subacct	no	glt_domain	yes	no
			glt_sub	yes	no
	glt_sum_values	no	glt_sum_values	yes	no
			glt_line	yes	no
	glt_tr_type	no	glt_domain	yes	no
			glt_tr_type	yes	no
			glt_ref	yes	no
			glt_line	yes	no
	glt_unb	no	glt_domain	yes	no
			glt_unb	yes	no
			glt_ref	yes	no
			glt_rflag	yes	no
			glt_line	yes	no
	oid_glt_det	yes	oid_glt_det	yes	no


Field Name	Label	Col-Label	Format	Dec
CustomCombo0			x(20)
CustomCombo1			x(20)
CustomCombo2			x(20)
CustomCombo3			x(20)
CustomCombo4			x(20)
CustomCombo5			x(20)
CustomCombo6			x(20)
CustomCombo7			x(20)
CustomCombo8			x(20)
CustomCombo9			x(20)
CustomDate0			99/99/9999
CustomDate1			99/99/9999
CustomDate2			99/99/9999
CustomDate3			99/99/9999
CustomDate4			99/99/9999
CustomDecimal0			->,>>>,>>9.99	4
CustomDecimal1			->,>>>,>>9.99	4
CustomDecimal2			->,>>>,>>9.99	4
CustomDecimal3			->,>>>,>>9.99	4
CustomDecimal4			->,>>>,>>9.99	4
CustomInteger0			->,>>>,>>9
CustomInteger1			->,>>>,>>9
CustomInteger2			->,>>>,>>9
CustomInteger3			->,>>>,>>9
CustomInteger4			->,>>>,>>9
CustomLong0			x(255)
CustomLong1			x(255)
CustomNote			x(2000)
CustomShort0			x(20)
CustomShort1			x(20)
CustomShort2			x(20)
CustomShort3			x(20)
CustomShort4			x(20)
CustomShort5			x(20)
CustomShort6			x(20)
CustomShort7			x(20)
CustomShort8			x(20)
CustomShort9			x(20)
GL_ID	Link to GL		-99999999999
GLVat_ID	Record ID		-99999999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Vat_ID	Link to Vat		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	GL	no	GL_ID	yes	no
	GLVat	yes	GL_ID	yes	no
			Vat_ID	yes	no
∗	Prim	yes	GLVat_ID	yes	no
	Vat	no	Vat_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
gl__qad01			>>>>>>9
gl__qadc01			x(8)
gl__qadc02			x(4)
gl__qadc03			x(8)
gl__qadc04			x(4)
gl__qadc05			x(8)
gl__qadc06			x(4)
gl__qadc07			x(8)
gl__qadc08			x(4)
gl__qadc09	Bank Acct Validation		x(2)
gl__qadl01			yes/no
gl_ap_acct	Payables		x(8)
gl_ap_cc	AP Cost Ctr	CC	x(4)
gl_ap_sub	Payables Sub-Acct	Sub-Acct	x(8)
gl_apds_acct	AP Discount	AP Disc	x(8)
gl_apds_cc	AP Disc Cost Ctr	CC	x(4)
gl_apds_sub	AP Discount Sub	Sub-Acct	x(8)
gl_apvr_acct	AP Rate Variance	AP Rate	x(8)
gl_apvr_cc	AP Rate Var Cost Ctr	CC	x(4)
gl_apvr_sub	AP Rate Variance Sub	Sub-Acct	x(8)
gl_apvrx_acct	Expensed Item Rate Var	AP Rate	x(8)
gl_apvrx_cc	Expensed Items Rate Var CC	CC	x(4)
gl_apvrx_sub	Exp Item Rate Var Sub	Sub-Acct	x(8)
gl_apvu_acct	AP Usage Variance	AP Usage	x(8)
gl_apvu_cc	AP Usage Var Cost Ctr	CC	x(4)
gl_apvu_sub	AP Usage Variance Sub	Sub-Acct	x(8)
gl_apvux_acct	Expensed Item Usage Var	AP Usage	x(8)
gl_apvux_cc	Expense Items Use Var CC	CC	x(4)
gl_apvux_sub	Exp Item Usage Sub	Sub-Acct	x(8)
gl_ar_acct	Receivables		x(8)
gl_ar_cc	AR Cost Ctr	CC	x(4)
gl_ar_sub	Receivables Sub-Acct	Sub-Acct	x(8)
gl_base_curr	Base Currency	Cur	x(3)
gl_bdn_acct	Burden		x(8)
gl_bdn_cc	Burden Cost Ctr	CC	x(4)
gl_bdn_sub	Burden Sub-Acct	Sub-Acct	x(8)
gl_bvar_acct	Burden Usage Var	Bdn Use	x(8)
gl_bvar_cc	Burden Usage Variance CC	CC	x(4)
gl_bvar_sub	Burden Usage Var Sub	Sub-Acct	x(8)
gl_bvrr_acct	Burden Rate Var	Bdn Rate	x(8)
gl_bvrr_cc	Burden Rate Variance CC	CC	x(4)
gl_bvrr_sub	Burden Rate Var Sub	Sub-Acct	x(8)
gl_can	Canadian Tax		yes/no
gl_cbdn_acct	COGS Burden Acct	COGS-Bdn	x(8)
gl_cbdn_cc	COGS Burden CC	CC	x(4)
gl_cbdn_sub	COGS Burden Sub-Acct	Sub-Acct	x(8)
gl_cchg_acct	Cost Revalue Acct	Revalue	x(8)
gl_cchg_cc	Cost Revalue Cost Ctr	CC	x(4)
gl_cchg_sub	Cost Revalue Sub-Acct	Sub-Acct	x(8)
gl_clbr_acct	COGS Labor Acct	COGS-Lbr	x(8)
gl_clbr_cc	COGS Labor CC	CC	x(4)
gl_clbr_sub	COGS Labor Sub-Acct	Sub-Acct	x(8)
gl_cmtl_acct	COGS Material Acct	COGS-Mtl	x(8)
gl_cmtl_cc	COGS Material CC	CC	x(4)
gl_cmtl_sub	COGS Material Sub-Acct	Sub-Acct	x(8)
gl_cog_acct	Cost of Goods	COGS	x(8)
gl_cog_cc	Cost of Goods Cost Ctr	CC	x(4)
gl_cog_sub	Cost of Goods Sub_Acct	Sub-Acct	x(8)
gl_cop_acct	Cost Of Production	COP	x(8)
gl_cop_cc	Cost of Production Cost Ctr	CC	x(4)
gl_cop_sub	Cost Of Production Sub	Sub-Acct	x(8)
gl_covh_acct	COGS Overhead Acct	COGS-Ovh	x(8)
gl_covh_cc	COGS Overhead CC	CC	x(4)
gl_covh_sub	COGS Overhead Sub-Acct	Sub-Acct	x(8)
gl_crterms_acct	Credit Terms Interest Account		x(8)
gl_crterms_cc	Credit Terms Interest CC	CC	x(4)
gl_crterms_sub	Credit Terms Int Sub	Sub-Acct	x(8)
gl_cs_acct	Sales Cash	Cash	x(8)
gl_cs_cc	Cash Cost Ctr	CC	X(4)
gl_cs_sub	Sales Cash Sub-Acct	Sub-Acct	x(8)
gl_csub_acct	COGS Subcontract Acct	COGS-Sub	x(8)
gl_csub_cc	COGS Subcontract CC	CC	x(4)
gl_csub_sub	COGS Subcontract Sub-Acct	Sub-Acct	x(8)
gl_disc_acct	Sales Discount	Disc	x(8)
gl_disc_cc	Disc Cost Ctr	CC	x(4)
gl_disc_sub	Sales Disc Sub-Acct	Sub-Acct	x(8)
gl_domain	Domain		x(8)
gl_dscr_acct	Inv Discrep Acct	Discrep	x(8)
gl_dscr_cc	Inv Discrep Cost Ctr	CC	x(4)
gl_dscr_sub	Inv Discrep Sub-Acct	Sub-Acct	x(8)
gl_entity	Entity	Enty	x(20)
gl_esls_acct	Exempt Sales Acct	Exempt Sls	x(8)
gl_esls_cc	Exempt Sales Cost Ctr	Exempt Sls	x(4)
gl_ex_ratetype	Exchange Rate Type	Rate Type	x(8)
gl_ex_rnd_acct	Exchange Rounding Acct	Exch Rnd	x(8)
gl_ex_rnd_cc	Exchange Rounding CC	CC	x(4)
gl_ex_rnd_sub	Exchange Rounding Sub	Sub-Acct	x(8)
gl_ex_round	Round Factor		->9
gl_fin_acct	Sales Finance	Finance	x(8)
gl_fin_cc	Finance Cost Ctr	CC	x(4)
gl_fin_sub	Sales Finance Sub	Sub-Acct	x(8)
gl_flr_acct	Floor Stock Account	Flr Acct	x(8)
gl_flr_cc	Floor Stock CC	CC	x(4)
gl_flr_sub	Floor Stock Sub-Acct	Sub-Acct	x(8)
gl_frtacc_acct	Sales Freight Accrued Account	Frt Accr	x(8)
gl_frtacc_cc	Cost Center	CC	x(4)
gl_frtacc_sub	Sales Frt Accrued Sub	Sub-Acct	x(8)
gl_frtapp_acct	Sales Freight Applied Account	Frt Appl	x(8)
gl_frtapp_cc	Cost Center	CC	x(4)
gl_frtapp_sub	Sales Frt Applied Sub	Sub-Acct	x(8)
gl_fsaccr_acct	Accrued Revenue	Accrued	x(8)
gl_fsaccr_cc	Accrued Revenue CC		x(4)
gl_fsaccr_sub	Accrued Revenue Sub-Acct		x(8)
gl_fsbdn_acct	Service Burden		X(8)
gl_fsbdn_cc	Service Burden CC	CC	X(4)
gl_fsbdn_sub	Service Burden Sub	Sub-Acct	x(8)
gl_fscm_inv_acct	Customer Inventory	Cust Inv	X(8)
gl_fscm_inv_cc	Customer Inventory CC	CC	X(4)
gl_fscm_inv_sub	Customer Inv Sub	Sub-Acct	x(8)
gl_fsdef_acct	Deferred Revenue	Deferred	x(8)
gl_fsdef_cc	Deferred Revenue CC		x(4)
gl_fsdef_sub	Deferred Revenue Sub-Acct		x(8)
gl_fsexd_acct	Expense Due Employee	Exp Due	X(8)
gl_fsexd_cc	Expense Due CC	CC	X(4)
gl_fsexd_sub	Expense Due Emp Sub	Sub-Acct	x(8)
gl_fsexp_acct	Service Expense		X(8)
gl_fsexp_cc	Service Expense CC	CC	X(4)
gl_fsexp_sub	Service Expense Sub	Sub-Acct	x(8)
gl_fslbr_acct	Service Labor		X(8)
gl_fslbr_cc	Service Labor CC	CC	X(4)
gl_fslbr_sub	Service Labor Sub	Sub-Acct	x(8)
gl_fsrc_inv_acct	Repair Center Inventory	Repair Ctr Inv	X(8)
gl_fsrc_inv_cc	Repair Center Inv CC	CC	X(4)
gl_fsrc_inv_sub	Repair Center Inv Sub	Sub-Acct	x(8)
gl_index1	Index		>>>>>9
gl_inv_acct	Inventory Acct	Inventory	x(8)
gl_inv_cc	Inventory Cost Ctr	CC	x(4)
gl_inv_sub	Inventory Sub-Acct	Sub-Acct	x(8)
gl_lang	Default System Language		x(2)
gl_late_acct	Credit Terms Late Interest Acct	Late Acct	x(8)
gl_late_cc	Credit Terms Late Interest CC	CC	x(4)
gl_late_sub	Cr Terms Late Inte Sub	Sub-Acct	x(8)
gl_lbr_acct	Labor		x(8)
gl_lbr_cc	Labor Cost Ctr	CC	x(4)
gl_lbr_sub	Labor Sub-Acct	Sub-Acct	x(8)
gl_lvar_acct	Labor Usage Var	Lbr Use	x(8)
gl_lvar_cc	Labor Usage Variance CC	CC	x(4)
gl_lvar_sub	Labor Usage Var Sub	Sub-Acct	x(8)
gl_lvrr_acct	Labor Rate Var	Lbr Rate	x(8)
gl_lvrr_cc	Labor Rate Variance CC	CC	x(4)
gl_lvrr_sub	Labor Rate Var Sub	Sub-Acct	x(8)
gl_mvar_acct	Material Usage Var	Mtl Use	x(8)
gl_mvar_cc	Material Usage Variance CC	CC	x(4)
gl_mvar_sub	Material Usage Var Sub	Sub-Acct	x(8)
gl_mvrr_acct	Material Rate Var	Mtl Rate	x(8)
gl_mvrr_cc	Material Rate Variance CC	CC	x(4)
gl_mvrr_sub	Material Rate Var Sub	Sub-Acct	x(8)
gl_ot_acct	Overtime		x(8)
gl_ot_cc	Overtime Cost Ctr	CC	x(4)
gl_ot_sub	Overtime Sub-Acct	Sub-Acct	x(8)
gl_ovh_acct	Overhead Appl Acct	Overhead	x(8)
gl_ovh_cc	Overhead Appl CC	CC	x(4)
gl_ovh_sub	Overhead Appl Sub-Acct	Sub-Acct	x(8)
gl_ppv_acct	PO Price Variance	PO Var	x(8)
gl_ppv_cc	PO Price Var Cost Ctr	CC	x(4)
gl_ppv_sub	PO Price Variance Sub	Sub-Acct	x(8)
gl_pur_acct	Purchases		x(8)
gl_pur_cc	Purchases Cost Ctr	CC	x(4)
gl_pur_sub	Purchases Sub	Sub-Acct	x(8)
gl_rcpt_acct	PO Receipts Acct	PO Rct	x(8)
gl_rcpt_cc	PO Receipts Cost Ctr	CC	x(4)
gl_rcpt_sub	PO Receipts Sub-Acct	Sub-Acct	x(8)
gl_rcptx_acct	Expensed Item Receipts	PO Rct	x(8)
gl_rcptx_cc	Expensed Receipts Cost Ctr	CC	x(4)
gl_rcptx_sub	Exp Item Receipts Sub	Sub-Acct	x(8)
gl_rgain_acct	Realized Exchange Gain Acct	Realized Gain	x(8)
gl_rgain_cc	Realized Exchange Gain CC	CC	x(4)
gl_rgain_sub	Realized Exch Gain Sub	Sub-Acct	x(8)
gl_rloss_acct	Realized Exchange Loss Acct	Realized Loss	x(8)
gl_rloss_cc	Realized Exchange Loss CC	CC	x(4)
gl_rloss_sub	Realized Exch Loss Sub	Sub-Acct	x(8)
gl_rmar_acct	Service Returns	Returns	X(8)
gl_rmar_cc	Service Returns CC	CC	X(4)
gl_rmar_sub	Service Returns Sub	Sub-Acct	x(8)
gl_rnd_mthd	Rounding Method	Rnd!Mthd	x(1)
gl_rtns_acct	Sales Returns	Returns	x(8)
gl_rtns_cc	Returns Cost Ctr	CC	x(4)
gl_rtns_sub	Sales Returns Sub	Sub-Acct	x(8)
gl_scrp_acct	Scrap		x(8)
gl_scrp_cc	Scrap Cost Ctr	CC	x(4)
gl_scrp_sub	Scrap Sub-Acct	Sub-Acct	x(8)
gl_sls_acct	Sales		x(8)
gl_sls_cc	Sales Cost Ctr	CC	x(4)
gl_sls_sub	Sales Sub-Account	Sub-Acct	x(8)
gl_sub_len	Sub-Module Sub-Account Length	Sub!Len	9
gl_svar_acct	Subcontract Usage Var	Sub Use	x(8)
gl_svar_cc	Subcontract Usage Variance CC	CC	x(4)
gl_svar_sub	Sub Usage Var Sub	Sub-Acct	x(8)
gl_svrr_acct	Subcontract Rate Var	Sub Rate	x(8)
gl_svrr_cc	Subcontract Rate Variance CC	CC	x(4)
gl_svrr_sub	Sub Rate Var Sub	Sub-Acct	x(8)
gl_symbol	Symbol		x(1)
gl_tax_type	Tax Type		x(3)
gl_tax1_acct	Sales Tax 1	Tax1	x(8)
gl_tax1_cc	Tax Cost Ctr	CC	x(4)
gl_tax2_acct	Sales Tax 2	Tax2	x(8)
gl_tax2_cc	Tax Cost Ctr	CC	x(4)
gl_tax3_acct	Sales Tax 3	Tax3	x(8)
gl_tax3_cc	Tax Cost Ctr	CC	x(4)
gl_term_acct	Sales Terms	Terms	x(8)
gl_term_cc	Terms Cost Ctr	CC	x(4)
gl_term_sub	Sales Terms Sub	Sub-Acct	x(8)
gl_timezone	Server Time Zone		x(8)
gl_txap_acct	AP Tax Account	AP Tax	x(8)
gl_txap_cc	AP Tax Cost Center	CC	x(4)
gl_txap_cn_acct	AP Tax CN Account	AP Tax CN Acct	x(8)
gl_txap_cn_sub	AP Tax CN Sub-Account	AP Tax CN Sub-Acct	x(8)
gl_txap_sub	AP Tax Sub-Account	Sub-Acct	x(8)
gl_txapr_acct	AP Retained Tax Acct	Ret Tax	x(8)
gl_txapr_cc	AP Retained Tax CC	CC	x(4)
gl_txapr_cn_acct	AP Tax Ret CN Account	AP Tax Ret CN Acct	x(8)
gl_txapr_cn_sub	AP Tax Ret CN Sub-Account	AP Tax Ret CN Sub-Acct	x(8)
gl_txapr_sub	AP Retained Tax Sub-Account	Sub-Acct	x(8)
gl_txar_acct	AR Sales Tax Account	AR Tax	x(8)
gl_txar_cc	AR Sales Tax CC	CC	x(4)
gl_txar_cn_acct	Sales Tax CN Acct		x(8)
gl_txar_cn_sub	Sales Tax CN Sub-Account	Sales Tax CN Sub-Acct	x(8)
gl_txar_sub	AR Sales Tax Sub-Account	Sub-Acct	x(8)
gl_txara_acct	AR Absorbed Tax Acct	Abs Tax	x(8)
gl_txara_cc	AR Absorbed Tax CC	CC	x(4)
gl_txara_cn_acct	Sales Tax Abs CN Acct		x(8)
gl_txara_cn_sub	Sales Tax Abs CN Sub-Acct		x(8)
gl_txara_sub	AR Absorbed Tax Sub-Account	Sub-Acct	x(8)
gl_ugain_acct	Unrealized Exchange Gain Acct	Unrealized Gain	x(8)
gl_ugain_cc	Unrealized Exchange Gain CC	CC	x(4)
gl_ugain_sub	Unrealized Exchange Gain Sub	Sub-Acct	x(8)
gl_uloss_acct	Unrealized Exchange Loss Acct	Unrealized Loss	x(8)
gl_uloss_cc	Unrealized Exchange Loss CC	CC	x(4)
gl_uloss_sub	Unrealized Exchange Loss Sub	Sub-Acct	x(8)
gl_user_acct	Exempt Sales Acct		x(8)
gl_user_cc	Exempt Sales Cost Ctr	CC	x(4)
gl_user_sub	Exempt Sales Sub-Acct	Sub-Acct	x(8)
gl_user1	Ufld1		x(8)
gl_user2	Ufld2		x(8)
gl_vat	Value Added Tax		yes/no
gl_verify	Verify GL Accounts	Verify GL	yes/no
gl_wip_acct	Work in Process	WIP	x(8)
gl_wip_cc	Work in Process Cost Ctr	CC	x(4)
gl_wip_sub	Work in Process Sub	Sub-Acct	x(8)
gl_wvar_acct	Method Variance	Mthd Var	x(8)
gl_wvar_cc	Method Variance CC	CC	x(4)
gl_wvar_sub	Method Variance Sub	Sub-Acct	x(8)
gl_xfer_acct	Transfer Variance	Transfer	x(8)
gl_xfer_cc	Transfer Variance Cost Ctr	CC	x(4)
gl_xfer_sub	Transfer Variance Sub	Sub-Acct	x(8)
gl_xvar_acct	Mix Var	Mix	x(8)
gl_xvar_cc	Mix Var CC	CC	x(4)
gl_xvar_sub	Mix Var Sub-Acct	Sub-Acct	x(8)
oid_gl_ctrl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	gl_index1	yes	gl_domain	yes	no
	gl_verify	no	gl_domain	yes	no
			gl_verify	yes	no
	oid_gl_ctrl	yes	oid_gl_ctrl	yes	no