dataset BMfgIntrastatControl

class dataset

object identification

primary key
iec_domain
alternate key
oid_iec_ctrl

table tiec_ctrl

field name	data type	mnd.	description
iec_authority	character(80)	no	Authority
iec_agent	character(80)	no	Agent
iec_agent_id	character(30)	no	Branch ID
iec_com_code	character(80)	no	Commodity Code
iec_declarant	character(80)	no	Declarant
iec_declarant_id	character(30)	no	Branch ID
iec_flow_arr	character(30)	no	Flow Indicator - Arrivals
iec_flow_disp	character(30)	no	Flow Indicator - Dispatches
iec_incl_memo	logical	no	Include Memo Items
iec_int_com_code	character(80)	no	Intangible Items Commodity Code
iec_mode_transp	character(30)	no	Mode of Transport
iec_nat_trans	character(30)	no	Nature of Transaction
iec_net_wt_min	decimal(10)	no	Intrastat Net Weight Minimum
iec_net_wt_um	character(30)	no	Intrastat Net Weight UM
iec_port_arrdisp	character(80)	no	Port of Arr/Disp
iec_port_transh	character(80)	no	Port of Transshipment
iec_ref_logic	character(30)	no	Reference Date Logic
iec_stat_proc	character(80)	no	Statistical Procedure
iec_terms_deliv	character(30)	no	Terms of Delivery
iec_use_instat	logical	no	Use Intrastat
iec__qadi02	integer	no
iec_userid	character(80)	no	User ID
iec_mod_date	date	no	Modified Date
iec__qadi01	integer	no
iec_region	character(30)	no	Region of Origin/Dest
iec_declaration_id	integer	no	Declaration ID
iec__chr01	character(80)	no
iec__chr02	character(80)	no
iec__chr03	character(80)	no
iec__chr04	character(80)	no
iec__dec01	decimal(10)	no
iec__log01	logical	no
iec__log02	logical	no
iec__qadc01	character(80)	no
iec__qadc02	character(80)	no
iec__qadc03	character(80)	no
iec__qadc04	character(80)	no
iec__qadd01	decimal(10)	no
iec__qadl01	logical	no
iec__qadl02	logical	no
iec_impexp	logical	no	Imp/Exp Default
iec_user1	character(80)	no	Ufld1
iec_user2	character(80)	no	Ufld2
iec_act_in_type_list	character(80)	no	Active IntraStat Type List
iec_act_ex_type_list	character(80)	no	Active ExtraStat Type List
iec_corr_flow_arr	character(30)	no	Correction Flow Of Arrival
iec_corr_flow_disp	character(30)	no	Correction Flow Of Dispatch
iec_use_extrastat	logical	no	Use ExtraStat
iec_container	logical	no	Container
iec_preference	integer	no	Preference
iec_domain	character(8)	yes	Domain
oid_iec_ctrl	decimal(10)	no
iec_add_freight_to_so	logical	no	Add Freight to SO Price
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