One moment please...
 
 
Exact Financials   
 

Data dictionary horder - Sales order history

#Field nameData typeFormatDecExtentDefaultLabel
1adm_nrinteger>>>>>9 0Company
2XXXbase_adm_nrinteger>>>>>9 0XXXBase company
3seqnr_lsohlint64>>>>>>>>>>>9 0Order number
4debtorint64>>>>>>>>>9 0Debtor
5invoice_debtorint64>>>>>>>>>9 0Invoice debtor
6XXXend_user_debtorint64>>>>>>>>>9 0XXXEnd-user debtor
7order_datedate99/99/9999 Order date
8delivery_datedate99/99/9999 Delivery date
9referencecharacterX(60) Reference
10reference_1characterX(60) Reference
11reference_2characterX(60) Reference
12reference_3characterX(60) Reference
13exdescr_codecharacterX(2) Extra description code
14representativecharacterX(12) 0Representative
15sel_codecharacterX(2) Selection code
16curr_codecharacterX(3) Currency
17exch_ratedecimal>>,>>9.9999996 0Exchange rate
18XXXinv_advancelogicalyes/no FALSEXXXInvoiced in advance
19XXXsorder_typeinteger>>>>>>>>>9 21501XXXSales order type
20pay_conditioncharacterX(4) Payment condition
21delivery_methodcharacterX(8) Delivery method
22cost_codecharacterX(8) Cost code
23freight_costsdecimal->>>,>>>,>>>,>>>,>>9.994 0Freight costs
24order_costsdecimal->>>,>>>,>>>,>>>,>>9.994 0Order costs
25vat_code_freight_costscharacterX(3) VAT code
26vat_code_order_costscharacterX(3) VAT code
27XXXcost_centercharacterX(8) XXXCost center
28XXXcost_unitcharacterX(8) XXXCost unit
29order_discount_percdecimal->>9.994 0Order discount
30line_amt_ex_vat_inc_ldiscdecimal->>>,>>>,>>>,>>>,>>9.994 0Line amount
31XXXpackagesinteger9999 0XXX Nr. of packages
32amt_inc_vat_inc_discdecimal->>>,>>>,>>>,>>>,>>9.994 0Order amount
33order_discount_amtdecimal->>>,>>>,>>>,>>>,>>9.994 0Order discount
34userid_approvecharacterX(12) Approved by
35XXXiso_langcodecharacterX(2) XXXISO Language
36delivery_addresscharacterX(8) Delivery address
37delivery_debtorint64>>>>>>>>>9 0Delivery debtor
38XXXdeliv_weekinteger>9 0XXXDelivery week
39XXXroute_codecharacterX(2) XXXRoute
40XXXquotation_nrinteger>>>>>>>>9 0XXXQuotation number
41euserid_crcharacterX(12) User creation
42date_crdate99/99/9999 Date creation
43time_crinteger>>>>>9 0Time creation
44source_crcharacterX(12) Source creation
45euserid_lccharacterX(12) User last changed
46date_lcdate99/99/9999 Date last changed
47time_lcinteger>>>>>9 0Time last changed
48source_lccharacterX(12) Source last changed
49XXXexplos_calc_methodinteger>>>>>>>>>9 30201XXXExplosion calculation method
50XXXflow_numdecimal>>>>>>>>>>>>99 0.0XXXFlow number
51XXXlink_statusinteger>>>>>>>>>9 31401XXXLink status
52text_codecharacterX(8) Text code
53pay_methodinteger>>>>>9 1Payment method
54order_costs_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT order costs
55freight_costs_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT freight costs
56o_costs_ex_vat_inc_discdecimal->>>,>>>,>>>,>>>,>>9.994 0Order costs
57f_costs_ex_vat_inc_discdecimal->>>,>>>,>>>,>>>,>>9.994 0Freight costs
58nr_periods_allocationinteger>>9 0Number of periods
59start_year_allocationinteger9999 0Start year period allocation
60start_period_allocationinteger>>9 0Start period period allocation
61bank_acc_nrcharacterx(34) Bank account
62curr_code_bank_acc_nrcharacterx(3) Currency
63collection_codecharacterX(8) Collection code
64mandate_refcharacterX(35) Mandate reference

Indexes

horder - primary - unique

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2seqnr_lsohlint64>>>>>>>>>>>9Order number

Contents > horder

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 25.809.303
 Assortment:  Date: 30-04-2014
 Release:  Attachment:
 Disclaimer