trgl_det

About This Guide > trgl_det

trgl_det

Inventory Transaction and General Ledger Cross-Reference


	Field Name	Label	Col-Label	Format	Dec
	oid_trgl_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
	trgl__qadc01			x(8)
	trgl_cr_acct	Cr Acct		x(8)
	trgl_cr_cc	Cr Cost Ctr	CC	x(4)
	trgl_cr_line	Line		>>>9
	trgl_cr_proj	Cr Project	Project	x(8)
	trgl_cr_sub	Cr Sub-Acct	Sub-Acct	x(8)
	trgl_domain	Domain		x(8)
	trgl_dr_acct	Dr Acct		x(8)
	trgl_dr_cc	Dr Cost Ctr	CC	x(4)
	trgl_dr_line	Line		>>>9
	trgl_dr_proj	Dr Project	Project	x(8)
	trgl_dr_sub	Dr Sub-Acct	Sub-Acct	x(8)
	trgl_dy_code	Daybook		x(8)
	trgl_dy_num	Entry Number		x(40)
	trgl_eff_trans	Current		yes/no
	trgl_gl_amt	Amount		->>>>>,>>9.99	10
	trgl_gl_ref	GL Reference		x(14)
	trgl_sequence	Sequence		->,>>>,>>9
	trgl_trnbr	Transaction	Trans	>>>>>>>>>9
	trgl_type	Type		x(8)
	trgl_user1	Ufld1		x(8)
	trgl_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_trgl_det	yes	oid_trgl_det	yes	no
	trgl_dr_cr	no	trgl_domain	yes	no
			trgl_dr_acct	yes	no
			trgl_dr_sub	yes	no
			trgl_dr_cc	yes	no
			trgl_cr_acct	yes	no
			trgl_cr_sub	yes	no
			trgl_cr_cc	yes	no
	trgl_dy_code	no	trgl_domain	yes	no
			trgl_dy_code	yes	no
			trgl_dy_num	yes	no
∗	trgl_nbr_ref	yes	trgl_domain	yes	no
			trgl_trnbr	yes	no
			trgl_gl_ref	yes	no
			trgl_sequence	yes	no
	trgl_ref_nbr	no	trgl_domain	yes	no
			trgl_gl_ref	yes	no
			trgl_trnbr	yes	no
	trgl_type_nbr_ref	no	trgl_domain	yes	no
			trgl_type	yes	no
			trgl_trnbr	yes	no
			trgl_gl_ref	yes	no