eswps_det


Field Name	Label	Col-Label	Format	Dec
eswps__qadc01			x(24)
eswps__qadc02			x(24)
eswps_code	Code		X(32)
eswps_include	Include		yes/no
eswps_mod_date	Modified Date	Mod Date	99/99/99
eswps_mod_userid	User ID		x(8)
eswps_multiple	Multiple		yes/no
eswps_order	Order		>>>9
eswps_table_name	Structure Table Name		X(32)
eswps_user1	User Field Character 1		x(24)
eswps_user2	User Field Character 2		x(24)
oid_eswp_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_eswps_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_eswps_det_parent			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
	eswps_code	yes	oid_eswp_mstr	yes	no
			eswps_code	yes	no
∗	eswps_oid_eswp_mstr	yes	oid_eswp_mstr	yes	no
			oid_eswps_det_parent	yes	no
			eswps_order	yes	no
	oid_eswps_det	yes	oid_eswps_det	yes	no


Field Name	Label	Col-Label	Format	Dec
eswp__qadc01			x(24)
eswp__qadc02			x(24)
eswp_collection	Collection		X(16)
eswp_comment_prompt	Prompt For Comment	Prompt!Comment	yes/no
eswp_data_frame_opt	Data Frame Optional	Data!Opt	yes/no
eswp_esig_active	Esig Active	Active	yes/no
eswp_filter_mode	Filter Mode	Filter	X(2)
eswp_latest_display	Display Latest E-Sig	Display!Latest	yes/no
eswp_mod_date	Modified Date	Mod Date	99/99/99
eswp_mod_userid	User ID		x(8)
eswp_preview_prompt	Prompt For Preview E-Sig	Prompt!Preview	yes/no
eswp_profile_type	Profile Type	Type	X(2)
eswp_user1	User Field Character 1		x(24)
eswp_user2	User Field Character 2		x(24)
oid_escat_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_eswp_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
	eswp_collection	no	eswp_collection	yes	no
	eswp_escat_mstr_oid	no	oid_escat_mstr	yes	no
∗	eswp_oid_escat_mstr	yes	eswp_profile_type	yes	no
			eswp_collection	yes	no
			oid_escat_mstr	yes	no
	oid_eswp_mstr	yes	oid_eswp_mstr	yes	no


Field Name	Label	Col-Label	Format	Dec
es__chr01	User Field #1		x(8)
es__chr02	User Field #2		x(8)
es__chr03	User Field #3		x(8)
es__chr04	User Field #4		x(8)
es__dec01	User Decimal #1		->>>,>>>,>>9.99<<<<	10
es__dec02	User Decimal #2		->>>,>>>,>>9.99<<<<	10
es__dec03	User Decimal #3		->>>,>>>,>>9.99<<<<	10
es__dte01	User Date #1		99/99/99
es__dte02	User Date #2		99/99/99
es__dte03	User Date #3		99/99/99
es__log01	User Logical #1		yes/no
es__log02	User Logical #2		yes/no
es__log03	User Logical #3		yes/no
es__qadc01	Qad Field #1		x(8)
es__qadc02	Qad Field #2		x(8)
es__qadc03	Qad Field #3		x(8)
es__qadc04	Qad Field #4		x(8)
es__qadd01	Qad Date #1		99/99/99
es__qadd02	Qad Date #2		99/99/99
es__qadd03	Qad Date #3		99/99/99
es__qadde01	Qad Decimal #1		->>>,>>>,>>9.99<<<<	10
es__qadde02	Qad Decimal #2		->>>,>>>,>>9.99<<<<	10
es__qadde03	Qad Decimal #3		->>>,>>>,>>9.99<<<<	10
es__qadl01	Qad Logical #1		yes/no
es__qadl02	Qad Logical #2		yes/no
es__qadl03	Qad Logical #3		yes/no
es_act_date	Actual Date	Act Date	99/99/99
es_ca_category	Category		x(8)
es_ca_int_type	Work Code	Wk Code	x(8)
es_ca_pri	Call Priority		>>9
es_ca_problem	Call Problem	Problem	x(8)
es_ca_severity	Call Severity	Severity	x(8)
es_ca_status	Status		x(8)
es_ca_type	Call Type	Type	x(8)
es_cmtindx	Comment Index	Comment	>>>>>>>9
es_days_in	Days Allowed In Status	Days	>>>>>9
es_desc	Description		x(24)
es_doc_desc[7]	Description		x(24)
es_doc_exec[7]	Program		x(8)
es_doc_paged[7]	Paged		yes/no
es_doc_printed[7]	Document Printed	Prt	yes/no
es_doc_printer[7]	Printer		x(8)
es_doc_printit[7]	Print	Prt	yes/no
es_docs_printed	All Documents Printed		yes/no
es_domain	Domain		x(8)
es_due_date	Due Date		99/99/99
es_es_nbr	Escalation		x(8)
es_esc_program	Escalation Program	Esc Program	x(12)
es_escalate	Escalate	Esc	yes/no
es_group	Group		x(8)
es_initial_date	Initial Date	Initial	99/99/99
es_itm_line	Line	Ln	>>9
es_message	Messages	Msg	yes/no
es_message_list	Distribution List		x(24)
es_nbr	Number		x(8)
es_next_que	Queue		x(8)
es_next_status	Status		x(8)	0
es_page	Page		yes/no
es_prefix			x(4)
es_pri_bump	Bump Priority	Pri	>>9
es_print	Print	Prt	yes/no
es_program	Program		x(12)
es_repair_step	Repair Step	Step	x(2)
es_seq	Sequence	Seq	>>9
es_time_in	Time Allowed in Status		99:99
es_user1	Ufld1		x(8)
es_user2	Ufld2		x(8)
oid_es_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	es_nbr	yes	es_domain	yes	no
			es_nbr	yes	no
			es_prefix	yes	no
			es_itm_line	yes	no
			es_ca_status	yes	no
			es_ca_int_type	yes	no
			es_ca_type	yes	no
			es_ca_severity	yes	no
			es_ca_problem	yes	no
			es_seq	yes	no
	oid_es_mstr	yes	oid_es_mstr	yes	no


Field Name	Label	Col-Label	Format	Dec
ettcd__qadc01			x(24)
ettcd__qadc02			x(24)
ettcd__qadd01			->>>>,>>>,>>9.9<<<<<<<<<	10
ettcd__qadt01			99/99/99
ettcd_amt	Trade amount		->>,>>>,>>>,>>9.99<	10
ettcd_batch_nbr	Batch Number		x(8)
ettcd_desc	Description		x(48)
ettcd_domain	Domain		x(8)
ettcd_exp_date	Expire Date		99/99/99
ettcd_gwt	Gross Weight		>,>>>,>>9.9<<<<<<<<	10
ettcd_hazardous_code	Hazardous Code		x(8)
ettcd_item	Container Item		x(18)
ettcd_line	Order Line		x(8)
ettcd_mod_date	Last Modified Date	Mod Date	99/99/99
ettcd_mod_userid	Last Modified User Id		x(8)
ettcd_order	Order		x(8)
ettcd_qty	Qty To Ship		>,>>>,>>9.9<<<<<<<<	10
ettcd_receipt_id	Receipt Id		x(20)
ettcd_tariff_nbr	Custom Tariff Nbr		x(14)
ettcd_trade_id	ID		x(14)
ettcd_trade_reason	Trade Reason		x(1)
ettcd_transport_licence	Transport Licence		x(8)
ettcd_user1	User Field Character 1		x(24)
ettcd_user2	User Field Character 2		x(24)
ettcd_wt_um	Weight UM		x(2)
oid_abs_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_ettc_mstr	Unique application generated record identifier.		>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_ettcd_det	Unique application generated record identifier.		>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	ettcd_trade_id	yes	ettcd_domain	yes	no
			ettcd_trade_id	yes	no
			ettcd_order	yes	no
			ettcd_line	yes	no
			ettcd_item	yes	no
	oid_abs_mstr	no	oid_abs_mstr	yes	no
	oid_ettc_mstr	no	oid_ettc_mstr	yes	no
	oid_ettcd_det	yes	oid_ettcd_det	yes	no


Field Name	Label	Col-Label	Format	Dec
ettc__qadc01			x(24)
ettc__qadc02			x(24)
ettc__qadd01			->>>>,>>>,>>9.9<<<<<<<<<	10
ettc__qadt01			99/99/99
ettc_arr_date	Arrive Date		99/99/99
ettc_arr_time	Arrive Time		>>>>>>>9
ettc_carrier	Carrier		x(8)
ettc_domain	Domain		x(8)
ettc_flow	Flow		x(2)
ettc_load_addr	Load Address		x(8)
ettc_mod_date	Last Modified Date	Mod Date	99/99/99
ettc_mod_userid	Last Modified User Id		x(8)
ettc_modby_carrier	Mod by carrier		Yes/No
ettc_shipfrom	Ship-from Id		x(8)
ettc_shipto	Ship-to Id		x(8)
ettc_shp_date	Ship Date		99/99/99
ettc_shp_time	Ship Time		>>>>>>>9
ettc_submission_date	Submission Date		99/99/99
ettc_submission_status	Status		x(10)
ettc_trade_id	ID		x(14)
ettc_trade_nbr	Trade Number		x(24)
ettc_trade_type	Trade type		x(1)
ettc_unload_addr	Unload Address		x(8)
ettc_unload_report	Unload Report		x(1)
ettc_user1	User Field Character 1		x(24)
ettc_user2	User Field Character 2		x(24)
ettc_veh_ref1	Vehicle Id 1		x(12)
ettc_veh_ref1_ctry	Vehicle Id 1 Country		x(3)
ettc_veh_ref2	Vehicle Id 2		x(12)
ettc_veh_ref2_ctry	Vehicle Id 2 Country		x(3)
ettc_veh_ref3	Vehicle Id 3		x(12)
ettc_veh_ref3_ctry	Vehicle Id 3 Country		x(3)
oid_ettc_mstr	Unique application generated record identifier.		>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	ettc_id	yes	ettc_domain	yes	no
			ettc_trade_id	yes	no
	ettc_shipfrom	no	ettc_domain	yes	no
			ettc_shipfrom	yes	no
			ettc_shipto	yes	no
	ettc_status_date	no	ettc_domain	yes	no
			ettc_submission_status	yes	no
			ettc_submission_date	yes	no
	oid_ettc_mstr	yes	oid_ettc_mstr	yes	no


Field Name	Label	Col-Label	Format	Dec
et__qadc01			x(8)
et__qadc02			x(8)
et__qadc03			x(8)
et__qadc05	QAD Character Field 5		x(8)
et__qadd01			->>>,>>>,>>9.99	10
et__qadd02			->>>,>>>,>>9.99	10
et__qadd03			->>>,>>>,>>9.99	10
et__qadi01			>>>>>>9
et__qadi02			>>>>>>9
et__qadi03			>>>>>>9
et__qadi04			->>>>>>>9
et__qadl01			yes/no
et__qadl02			yes/no
et__qadl03			yes/no
et__qadl04	QAD Logical Field 4		yes/no
et__qadl05	QAD Logical Field 5		yes/no
et__qadt01			99/99/99
et__qadt02			99/99/99
et__qadt03			99/99/99
et__qadt04	QAD Date Field 4		99/99/99
et_base_curr	Old Base Currency		x(3)
et_conv_acct	Conversion Rounding Acct		x(8)
et_conv_cc	Conversion Rounding CC		x(4)
et_conv_sub	Conversion Rounding Sub-Acct	Sub-Acct	x(8)
et_domain	Domain		x(8)
et_gl_eff_dt	GL Effective Date		99/99/99
et_print_dc	Print SO/Invc In Dual Cur		yes/no
et_rate_active	Euro Cur Exch Rates Active		yes/no
et_show_diff	Show Conversion Rounding Diff		yes/no
et_start_conv	Start Conversion		yes/no
et_user1	Ufld1		x(8)
et_user2	Ufld2		x(8)
oid_et_ctrl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	et_index1	yes	et_domain	yes	no
	oid_et_ctrl	yes	oid_et_ctrl	yes	no


Field Name	Label	Col-Label	Format	Dec
euc__chr01	User Character Field 1		X(8)
euc__dte01	User Date Field 1		99/99/99
euc__int01	User Integer Field 1		->,>>>,>>9
euc__log01	User Logical Field 1		yes/no
euc__qadc01	QAD Character Field 1		X(8)
euc__qadi01	QAD Integer Field 1		->,>>>,>>9
euc__qadi02			->>>>>>>9
euc__qadl01	Create ISB		yes/no
euc__qadl02	QAD Logical Field		yes/no
euc__qadt01	QAD Date Field 1		99/99/99
euc_create_isb	Create ISB		yes/no
euc_domain	Domain		x(8)
euc_mod_date	Modified Date	Mod Date	99/99/99
euc_mod_userid	User ID		X(8)
euc_nbr	Next Enduser		99999999
euc_schedule	Operating Schedule		x(8)
euc_user1	Ufld1		x(8)
euc_user2	Ufld2		x(8)
oid_euc_ctrl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	euc_index1	yes	euc_domain	yes	no
	oid_euc_ctrl	yes	oid_euc_ctrl	yes	no


Field Name	Label	Col-Label	Format	Dec
eud__chr01	User Character Field 1		X(8)
eud__chr02	User Character Field 2		X(8)
eud__chr03	User Character Field 3		X(8)
eud__dte01	User Date Field 1		99/99/99
eud__int01	User Integer Field 1		->,>>>,>>9
eud__log01	User Logical Field 1		yes/no
eud__qadc01	QAD Character Field 1		X(8)
eud__qadc02	QAD Character Field 2		X(8)
eud__qadc03	QAD Character Field 3		X(8)
eud__qadi01	QAD Integer Field 1		->,>>>,>>9
eud__qadl01	QAD Logical Field 1		yes/no
eud__qadt01	QAD Date Field 1		99/99/99
eud_addr	End User		x(8)
eud_domain	Domain		x(8)
eud_fax	Fax		x(20)
eud_ls_type	List Type		x(8)
eud_mail_addr	Mail Address		x(24)
eud_mod_date	Modified Date	Mod Date	99/99/99
eud_mod_userid	User ID		X(8)
eud_nametype	Contact Type		x(1)
eud_phone	Phone		x(20)
eud_sort	Name		x(35)
eud_title	Title		x(20)
eud_type	Contact Type		x(20)
eud_updt	Last Update		99/99/99
eud_user1	Ufld1		x(8)
eud_user2	Ufld2		x(8)
oid_eud_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
	eud_addr	no	eud_domain	yes	no
			eud_addr	yes	no
			eud_ls_type	yes	no
			eud_sort	yes	no
∗	eud_addrsort	yes	eud_domain	yes	no
			eud_addr	yes	no
			eud_sort	yes	no
	eud_nametype	no	eud_domain	yes	no
			eud_addr	yes	no
			eud_nametype	yes	no
			eud_sort	yes	no
	eud_phone	no	eud_domain	yes	no
			eud_phone	yes	no
	eud_sort	no	eud_domain	yes	no
			eud_sort	yes	no
	oid_eud_det	yes	oid_eud_det	yes	no


Field Name	Label	Col-Label	Format	Dec
eus__qadc01			x(24)
eus__qadc02			x(24)
eus_days[7]	Days		yes/no
eus_domain	Domain		x(8)
eus_etime[7]	End Time		99:99
eus_eu_nbr	End User		x(8)
eus_mid_etime[7]	Stop Midday		99:99
eus_mid_stime[7]	Start Midday		99:99
eus_mod_date	Modified Date	Mod Date	99/99/99
eus_mod_userid	User ID		x(8)
eus_schedule	Operating Schedule		x(8)
eus_stime[7]	Start Time		99:99
eus_user1	User Field Character1		x(24)
eus_user2	User Field Character2		x(24)
oid_eus_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	eus_schedule	yes	eus_domain	yes	no
			eus_schedule	yes	no
			eus_eu_nbr	yes	no
	oid_eus_mstr	yes	oid_eus_mstr	yes	no


Field Name	Label	Col-Label	Format	Dec
eu__chr01			x(8)
eu__chr02			x(8)
eu__chr03			x(8)
eu__chr04			x(8)
eu__chr05			x(8)
eu__chr06			x(8)
eu__chr07			x(8)
eu__chr08			x(8)
eu__chr09			x(8)
eu__chr10			x(8)
eu__dec01			->>>,>>>,>>9.99	10
eu__dec02			->>>,>>>,>>9.99	10
eu__dec03			->>>,>>>,>>9.99	10
eu__dte01			99/99/99
eu__dte02			99/99/99
eu__dte03			99/99/99
eu__dte04			99/99/99
eu__log01			yes/no
eu__log02			yes/no
eu__log03			yes/no
eu__log04			yes/no
eu__log05			yes/no
eu__qadc01	QAD Character Field 1		X(8)
eu__qadc02	QAD Character Field 2		X(8)
eu__qadc03	QAD Character Field 3		X(8)
eu__qadd01	QAD Decimal Field 1		->>>>,>>>,>>9.99<<<	10
eu__qadi01	QAD Integer Field 1		->,>>>,>>9
eu__qadi02	QAD Integer Field 2		->,>>>,>>9
eu__qadl01	QAD Logical Field 1		yes/no
eu__qadl02	QAD Logical Field 2		yes/no
eu__qadl03	QAD Logical Field 3		yes/no
eu__qadt01	QAD Date Field 1		99/99/99
eu__qadt02	QAD Date Field 2		99/99/99
eu_addr	End User		x(8)
eu_application	Application		x(40)
eu_autorenew	Auto Renew Contracts		yes/no
eu_channel	Channel	Chan	x(4)
eu_cm_nbr	Customer No	Cus No	x(8)
eu_cmtindx	Comment Idx		>>>>>>9
eu_create_isb	Create ISB		yes/no
eu_disc_pct	Disc %		->>9.99%	10
eu_domain	Domain		x(8)
eu_ed_time	End Time	Ed Tm	99:99
eu_eng_code	Engineer Code	Eng Cd	x(8)
eu_eng_group	Engineer Group		x(8)
eu_eng_sec	Secondary Eng		x(8)	0
eu_es_nbr	Escalation	Esc	x(8)
eu_lang	Language		x(2)
eu_login	Login		x(12)
eu_mod_date	Modified Date	Mod Date	99/99/99
eu_mod_userid	User ID		X(8)
eu_modem	Modem Phone	Modem	x(20)
eu_msg	Message		x(60)
eu_msg_end	End Date		99/99/99
eu_name	Name		x(35)
eu_node	Node		x(8)
eu_node_type	Node Type		x(8)
eu_office	Office		x(8)
eu_phone	Phone		x(20)
eu_po_accum	Accumulated PO Total		>>>>,>>>,>>9.99<<<	10
eu_po_limit	PO Limit		>>>>,>>>,>>9.99<<<	10
eu_po_nbr	Purchase Order	PO	x(22)
eu_po_reqd	PO Required		yes/no
eu_pri	Call Priority	Pri	>>>9
eu_rebuild_isb	Rebuild Isb		yes/no
eu_receipt_days	Days to Receive		>>9
eu_renew_days	Days to Renew		>>9
eu_reseller	Reseller		yes/no
eu_review	Review Date		99/99/99
eu_rsb	Responsible		x(24)
eu_schedule	Operating Schedule		x(8)
eu_sep_invoice	Separate Invoice		yes/no
eu_ship_days	Days to Ship		>>9
eu_sic_code	SIC Code		x(8)
eu_sort	Name		x(35)
eu_st_time	Start Time	St Tm	99:99
eu_status	Status		x(4)
eu_svc_area	Service Area	Svc Area	x(18)
eu_time_zone	Hours from GMT		>>9
eu_trv_dist	Travel Dist	Trvl Dst	>>9
eu_trv_time	Travel Time		999:99	0
eu_trv_um	Travel UM	TU	x(2)
eu_type	Type		x(8)
eu_un_billed	Un Billed		>>>>,>>>,>>9.99<<<	10
eu_updates	Updates		x(8)
eu_user1	Ufld1		x(8)
eu_user2	Ufld2		x(8)
eu_zip	Post		x(10)
oid_eu_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	eu_addr	yes	eu_domain	yes	no
			eu_addr	yes	no
	eu_cmeu_nbr	yes	eu_domain	yes	no
			eu_cm_nbr	yes	no
			eu_addr	yes	no
	eu_sort_addr	yes	eu_domain	yes	no
			eu_sort	yes	no
			eu_addr	yes	no
	eu_zip	no	eu_domain	yes	no
			eu_zip	yes	no
			eu_addr	yes	no
	oid_eu_mstr	yes	oid_eu_mstr	yes	no


Field Name	Label	Col-Label	Format	Dec
DaemonId	Daemon ID		-99999999999
EventDaemon_ID	Record ID		-99999999999
EventDaemonAdapter	Adapter		x(60)
EventDaemonAdapterCnString	Connection String		x(40)
EventDaemonBroker	Broker		x(60)
EventDaemonBrokerPassword	Broker Password		x(40)
EventDaemonBrokerUser	Broker User		x(40)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999


	Index-Name	Uni	Field-Name	Asc	Abbr
	Daemon_FK	no	DaemonId	yes	no
∗	EventDaemon_PK	yes	EventDaemon_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
ExchangeRate	Exchange Rate	Rate	->,>>>,>>9.9999999999	10
ExchangeRate_ID	Record ID		-99999999999
ExchangeRateScale	Scale Factor		->,>>>,>>9.9999999999	10
ExchangeRateType_ID	Exchange Rate Type	Rate Type	-99999999999
ExchangeRateValidDateFrom	Valid from		99/99/9999
ExchangeRateValidDateTill	Valid to		99/99/9999
FromCurrency_ID	From Currency Code	From Curr	-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
SharedSet_ID	Link to SharedSet		-99999999999
ToCurrency_ID	To Currency Code	To Curr	-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	CombiTillIdx	no	SharedSet_ID	yes	no
			FromCurrency_ID	yes	no
			ToCurrency_ID	yes	no
			ExchangeRateValidDateTill	yes	no
	CombiTypeTillIdx	no	SharedSet_ID	yes	no
			FromCurrency_ID	yes	no
			ToCurrency_ID	yes	no
			ExchangeRateType_ID	yes	no
			ExchangeRateValidDateTill	yes	no
	DateFrom	no	ExchangeRateValidDateFrom	yes	no
	DateTill	no	ExchangeRateValidDateTill	yes	no
	FromCurrency	no	FromCurrency_ID	yes	no
∗	Prim	yes	ExchangeRate_ID	yes	no
	RateType	no	ExchangeRateType_ID	yes	no
	SharedSet	no	SharedSet_ID	yes	no
	SSTillIdx	no	SharedSet_ID	yes	no
			ExchangeRateValidDateTill	yes	no
	ToCurrency	no	ToCurrency_ID	yes	no
	UniqueIndex	yes	SharedSet_ID	yes	no
			ExchangeRateType_ID	yes	no
			FromCurrency_ID	yes	no
			ToCurrency_ID	yes	no
			ExchangeRateValidDateFrom	yes	no


Field Name	Label	Col-Label	Format	Dec
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	Record ID		-99999999999
ExchangeRateTypeCode	Exchange Rate Type	Rate Type	x(20)
ExchangeRateTypeDescript	Description		x(40)
ExchangeRateTypeIsActive	Active		yes/no
ExchangeRateTypeIsExported	Exported		yes/no
ExchangeRateTypeIsFallBack	Fall Back On Accounting Type		yes/no
ExchangeRateTypeIsSystem	System-Owned	System	yes/no
ExchangeRateTypeIsTillDate	With Valid Till Date		yes/no
ExchangeRateTypeValidity	Default Validity (days)		>>9
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
	Code	yes	ExchangeRateTypeCode	yes	no
∗	Prim	yes	ExchangeRateType_ID	yes	no
	ViewIndex	no	ExchangeRateTypeIsActive	yes	no
			ExchangeRateTypeCode	yes	no


Field Name	Label	Col-Label	Format	Dec
ExpenseCode	Expense Code		x(20)
ExpenseCode_ID	Record ID		-99999999999
ExpenseCodeDescription	Description		x(40)
ExpenseCodeIsActive	Active		yes/no
ExpenseCodeType	Expense Type	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
	Code	no	ExpenseCode	yes	no
	CodeAndType	yes	ExpenseCode	yes	no
			ExpenseCodeType	yes	no
∗	Prim	yes	ExpenseCode_ID	yes	no
	ViewIndex	no	ExpenseCodeIsActive	yes	no
			ExpenseCode	yes	no


Field Name	Label	Col-Label	Format	Dec
CostCentreGL_ID	Expense Acc (CC)		-99999999999
EmployeeExpenseCode_ID	Employee Expense Code		-99999999999
ExpenseGLMatrix_ID	Record ID		-99999999999
ItemExpenseCode_ID	Item Expense Code		-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)
NoAnalysisGL_ID	Expense Account (No Analysis)		-99999999999
ProjectGL_ID	Expense Acc (Prj)		-99999999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
SharedSet_ID	Link to SharedSet		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	CostCentreGL	no	CostCentreGL_ID	yes	no
	EmployeeExp	no	EmployeeExpenseCode_ID	yes	no
	ItemExp	no	ItemExpenseCode_ID	yes	no
	NoAnalysisGL	no	NoAnalysisGL_ID	yes	no
∗	Prim	yes	ExpenseGLMatrix_ID	yes	no
	ProjectGL	no	ProjectGL_ID	yes	no
	SharedSet	no	SharedSet_ID	yes	no
	UniqueKey	yes	SharedSet_ID	yes	no
			ItemExpenseCode_ID	yes	no
			EmployeeExpenseCode_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
CInvoice_ID	Link to CInvoice		-99999999999
ExpNote_ID	Link to ExpNote		-99999999999
ExpNoteCInvoice_ID	Record ID		-99999999999
ExpNoteCInvoiceDeductLC	BC Deductible		->>>,>>>,>>>,>>9.99	4
ExpNoteCInvoiceDeductTC	TC Deductible		->>>,>>>,>>>,>>9.99	4
ExpNoteCInvoiceIsReturned	Is Returned	Returned	yes/no
ExpNoteCInvoiceStatusCode	Status Code	Status	x(20)
ExpNoteCInvoiceToReturnTC	TC To Return		->>>,>>>,>>>,>>9.99	4
ExpNoteCInvoiceTypeCode	Type Code	Type	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999


	Index-Name	Uni	Field-Name	Asc	Abbr
	CInvoice	no	CInvoice_ID	yes	no
	ExpNote	no	ExpNote_ID	yes	no
∗	Prim	yes	ExpNoteCInvoice_ID	yes	no
	UniqueIdx	yes	ExpNote_ID	yes	no
			CInvoice_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
ExpNoteLine_ID	Link to ExpNoteLine		-99999999999
ExpNoteLineSaf_ID	Record ID		-99999999999
ExpNoteLineSafInputSeq	Sequence	Seq	->,>>>,>>9
ExpNoteLineSafParentType	Parent Type	Parent	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Saf_ID	Link to Saf		-99999999999
SafStructure_ID	Link to SafStructure		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	ExpNoteLine	no	ExpNoteLine_ID	yes	no
∗	Prim	yes	ExpNoteLineSaf_ID	yes	no
	Saf	no	Saf_ID	yes	no
	SafStructure	no	SafStructure_ID	yes	no
	UniqueIdx	yes	ExpNoteLine_ID	yes	no
			ExpNoteLineSafParentType	yes	no
			ExpNoteLineSafInputSeq	yes	no