About This Guide > txhd_det
  
txhd_det
Tax History Detail
 
 
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