|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_txhd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
txhd__chr01
|
|
|
x(8)
|
|
|
|
txhd__chr02
|
|
|
x(8)
|
|
|
|
txhd__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
txhd__dec02
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
txhd__dte01
|
|
|
99/99/99
|
|
|
|
txhd__log01
|
|
|
yes/no
|
|
|
|
txhd__qad01
|
|
|
x(8)
|
|
|
|
txhd__qad02
|
|
|
x(8)
|
|
|
|
txhd__qad03
|
|
|
yes/no
|
|
|
|
txhd__qad04
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
txhd__qad05
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
txhd__qad06
|
|
|
99/99/99
|
|
|
|
txhd_chg_date
|
Date Last Changed
|
Chg Date
|
99/99/99
|
|
|
|
txhd_comm_code
|
Commodity Code
|
Com Code
|
x(8)
|
|
|
|
txhd_container
|
Container Indicator
|
C
|
x(1)
|
|
|
|
txhd_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
txhd_cust_ctry
|
Cust Tax Reg Ctry
|
Cust Country
|
x(3)
|
|
|
|
txhd_cust_num
|
Cust Tax Reg Nbr
|
Customer TRN
|
x(15)
|
|
|
|
txhd_db_export
|
Date Exported From Database
|
DBE Date
|
99/99/99
|
|
|
|
txhd_del_terms
|
Terms of Delivery
|
T D
|
x(3)
|
|
|
|
txhd_desdis_ctry
|
Destination/Dispatch Country
|
D C
|
x(3)
|
|
|
|
txhd_desdis_port
|
Destination/Dispatch Port
|
D P
|
x(8)
|
|
|
|
txhd_domain
|
Domain
|
|
x(8)
|
|
|
|
txhd_edit_hist
|
Editable Record
|
E
|
yes/no
|
|
|
|
txhd_effdate
|
Effective
|
|
99/99/99
|
|
|
|
txhd_enter_date
|
Date Entered
|
Date Ent
|
99/99/99
|
|
|
|
txhd_fiscal_class
|
Fiscal Class
|
|
x(18)
|
|
|
|
txhd_flow_in
|
Flow Indicator
|
FI
|
yes/no
|
|
|
|
txhd_inv_value
|
Invoice Value
|
|
->>>>,>>>,>>>,>>9.99
|
10
|
|
|
txhd_line
|
Line
|
|
>>>>9
|
|
|
|
txhd_nbr
|
Number
|
|
x(8)
|
|
|
|
txhd_net_wt
|
Net Weight
|
Net Wt
|
->>>>>>>9
|
|
|
|
txhd_orig_ctry
|
Country of Origin
|
C O
|
x(3)
|
|
|
|
txhd_posted
|
Posted in Tax Book
|
P
|
yes/no
|
|
|
|
txhd_proc_ind
|
Process Indicator
|
PI
|
yes/no
|
|
|
|
txhd_program
|
Program
|
|
x(12)
|
|
|
|
txhd_ref
|
Reference
|
Ref
|
x(8)
|
|
|
|
txhd_site
|
Site
|
|
x(8)
|
|
|
|
txhd_stat_proc
|
Statistical Procedure
|
SP
|
x(2)
|
|
|
|
txhd_stat_submit
|
Statistical Submit Date
|
StatDate
|
99/99/99
|
|
|
|
txhd_stat_value
|
Statistical Value
|
|
->>>>,>>>,>>>,>>9.99
|
10
|
|
|
txhd_suppl_unit
|
Supplementary Units
|
Sup Units
|
>>>>>>>>9
|
|
|
|
txhd_taric
|
Taric Code
|
T C
|
x(3)
|
|
|
|
txhd_tax_code
|
Tax Code
|
|
x(8)
|
|
|
|
txhd_tax_ctry
|
Tax Registration Country
|
TRC
|
x(3)
|
|
|
|
txhd_tax_nbr
|
Tax Registration Number
|
TRN
|
x(15)
|
|
|
|
txhd_tax_usage
|
Nature of Operation
|
Nature
|
x(8)
|
|
|
|
txhd_td_stat_in
|
Included in Trade Statistics
|
S
|
yes/no
|
|
|
|
txhd_tr_nbr
|
Transaction Number
|
Tran Nbr
|
>>>>>>>>>9
|
|
|
|
txhd_tr_type
|
Transaction Type
|
TT
|
x(2)
|
|
|
|
txhd_tran_mode
|
Mode of Transportation
|
MT
|
x(1)
|
|
|
|
txhd_trans_ref
|
Original Transaction Reference
|
Orig Ref
|
x(14)
|
|
|
|
txhd_transh_port
|
Transhipment Port
|
T P
|
x(8)
|
|
|
|
txhd_trl
|
Trailer
|
Trlr
|
x(4)
|
|
|
|
txhd_user_id
|
User ID Entered
|
User ID
|
x(8)
|
|
|
|
txhd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
txhd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
txhd_usr_id_chg
|
Last Change User ID
|
Chg User
|
x(8)
|
|
|
|
txhd_vat_sl_date
|
VAT Sales List Submit Date
|
VSL Date
|
99/99/99
|
|
|
|
txhd_vat_sl_in
|
Included in VAT Sales List
|
V
|
yes/no
|
|
|
|
txhd_vat_value
|
Value of Goods
|
|
->>>>,>>>,>>>,>>9.99
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_txhd_det
|
yes
|
oid_txhd_det
|
yes
|
no
|
|
|
txhd_fiscal_class
|
no
|
txhd_domain
|
yes
|
no
|
|
|
|
|
txhd_fiscal_class
|
yes
|
no
|
|
|
|
|
txhd_tr_type
|
yes
|
no
|
|
|
|
|
txhd_ref
|
yes
|
no
|
|
|
|
|
txhd_nbr
|
yes
|
no
|
|
|
|
|
txhd_line
|
yes
|
no
|
|
|
txhd_post_type
|
no
|
txhd_domain
|
yes
|
no
|
|
|
|
|
txhd_posted
|
yes
|
no
|
|
|
|
|
txhd_tr_type
|
yes
|
no
|
|
|
|
|
txhd_ref
|
yes
|
no
|
|
|
|
|
txhd_nbr
|
yes
|
no
|
|
|
|
|
txhd_line
|
yes
|
no
|
|
|
txhd_ref_nbr
|
yes
|
txhd_domain
|
yes
|
no
|
|
|
|
|
txhd_ref
|
yes
|
no
|
|
|
|
|
txhd_nbr
|
yes
|
no
|
|
|
|
|
txhd_line
|
yes
|
no
|
|
|
|
|
txhd_trl
|
yes
|
no
|
|
|
|
|
txhd_tr_type
|
yes
|
no
|
|
|
|
|
txhd_tax_code
|
yes
|
no
|
|
∗
|
txhd_tr_nbr
|
yes
|
txhd_domain
|
yes
|
no
|
|
|
|
|
txhd_tr_nbr
|
yes
|
no
|