dataset BMfgUnpostedTransDetail

class dataset

object identification

primary key
glt_domain
glt_ref
glt_rflag
glt_line
alternate key
oid_glt_det

table tglt_det

field name	data type	mnd.	description
glt_entity	character(30)	no	Entity
glt_acct	character(80)	no	Account
glt_cc	character(30)	no	Cost Ctr
glt_ref	character(30)	no	GL Reference
glt_desc	character(80)	no	Description
glt_date	date	no	Entered
glt_effdate	date	no	Effective
glt_amt	decimal(10)	no	Amount
glt_userid	character(80)	no	User ID
glt_project	character(80)	no	Project
glt_batch	character(80)	no	Batch
glt_curr	character(30)	no	Currency
glt_curr_amt	decimal(10)	no	Currency Amount
glt_unb	logical	no	Unbalanced
glt_tr_type	character(30)	no	Transaction Type
glt_error	character(30)	no	Error Message
glt_line	integer	no	Line
glt_ex_rate	decimal(10)	no	Exch Rate
glt_addr	character(80)	no	Address
glt_doc	character(30)	no	Document
glt_doc_type	character(30)	no	Document Type
glt_user1	character(80)	no	Ufld1
glt_user2	character(80)	no	Ufld2
glt_fx_ind	character(30)	no	FX Conversion Index
glt_sub	character(80)	no	Sub-Account
glt_rflag	logical	no	Reversing/Retroactive Line
glt_ecur_amt	decimal(10)	no	Amount in Entity Currency
glt_en_exrate	decimal(10)	no	Entity Exch Rate
glt_entr_exrate	decimal(10)	no	Entered Exchange Rate
glt_per	integer	no	Period
glt_year	integer	no	Year
glt__qadc01	character(80)	no
glt_correction	logical	no	Correction
glt_dy_code	character(80)	no	Daybook
glt_dy_num	character(80)	no	Entry Number
glt_ex_rate2	decimal(10)	no	Exch Rate 2
glt_ex_ratetype	character(80)	no	Rate Type
glt_en_exrate2	decimal(10)	no	Entity Exch Rate 2
glt_exru_seq	integer	no	Sequence
glt_en_exru_seq	integer	no	Sequence
glt_src_desc	character(80)	no	Source GL Description
glt_domain	character(8)	yes	Domain
oid_glt_det	decimal(10)	no
glt_interco_ref	character(40)	no	Intercompany Reference
glt_exp	logical	no	Transaction Posted
glt_mgmt_curr	character(30)	no	Management Currency
glt_mgmt_curr_amt	decimal(2)	no	Management Currency Amount
glt_mgmt_ex_rate	decimal(2)	no	Exchange Rate
glt_mgmt_ex_ratetype	character(80)	no	Management Exchange Rate Type
glt_mgmt_ex_rate2	decimal(2)	no	Management Curr Exchange Rate
glt_mirror_ref	character(20)	no	Mirror Ref
glt_mirror_line_ref	character(20)	no	Mirror Line Ref
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	no	empty string
tc_Status	character	no	update status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character