One moment please...
 
 
Exact Financials   
 

Data dictionary lsihl - Sales invoice headers

#Field nameData typeFormatDecExtentDefaultLabel
1adm_nrinteger>>>>>9 0Company
2invoice_codeinteger>>>>>>>9 0Invoice code
3seqnr_lsihlinteger>>>>>>>9 0Sequence number
4invoice_statusinteger>>>>>9 0Status
5debtorint64>>>>>>>>>9 0Debtor
6invoice_debtorint64>>>>>>>>>9 0Invoice debtor
7sel_codecharacterX(2) Selection code
8representativecharacterX(12) 0Representative
9curr_codecharacterX(3) Currency
10exch_ratedecimal>>,>>9.9999996 0Exchange rate
11pay_conditioncharacterX(4) Payment condition
12pay_methodinteger>>>>>9 1Payment method
13referencecharacterX(60) Reference
14reference_1characterX(60) Reference
15reference_2characterX(60) Reference
16reference_3characterX(60) Reference
17exdescr_codecharacterX(2) Extra description code
18text_codecharacterX(8) Text code
19order_datedate99/99/9999 Order date
20delivery_debtorint64>>>>>>>>>9 0Delivery debtor
21delivery_datedate99/99/9999 Delivery date
22delivery_methodcharacterX(8) Delivery method
23delivery_addresscharacterX(8) Delivery address
24line_amt_ex_vat_inc_ldiscdecimal->>>,>>>,>>>,>>>,>>9.994 0Line amount
25cost_codecharacterX(8) Cost code
26order_costsdecimal->>>,>>>,>>>,>>>,>>9.994 0Order costs
27vat_code_order_costscharacterX(3) VAT code
28o_costs_ex_vat_inc_discdecimal->>>,>>>,>>>,>>>,>>9.994 0Order costs
29freight_costsdecimal->>>,>>>,>>>,>>>,>>9.994 0Freight costs
30vat_code_freight_costscharacterX(3) VAT code
31f_costs_ex_vat_inc_discdecimal->>>,>>>,>>>,>>>,>>9.994 0Freight costs
32invoice_discount_percdecimal->>9.994 0Order discount
33invoice_discount_amtdecimal->>>,>>>,>>>,>>>,>>9.994 0Order discount
34order_costs_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT order costs
35freight_costs_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT freight costs
36amt_inc_vat_inc_discdecimal->>>,>>>,>>>,>>>,>>9.994 0Order amount
37approvedlogicalyes/no noApproved
38userid_approvecharacterX(12) Approved by
39seqnr_lsohlint64>>>>>>>>>>>9 0Order number
40invoice_typeinteger>>>>>9 0Invoice type
41invoice_nrint64>>>>>>>>>>>9 0Invoice number
42original_invoice_nrint64>>>>>>>>>>>9 0Original invoice number
43invoice_datedate99/99/9999 Invoice date
44euserid_crcharacterX(12) User creation
45date_crdate99/99/9999 Date creation
46time_crinteger>>>>>9 0Time creation
47source_crcharacterX(8) Source creation
48euserid_lccharacterX(12) User last changed
49date_lcdate99/99/9999 Date last changed
50time_lcinteger>>>>>9 0Time last changed
51source_lccharacterX(8) Source last changed
52nr_periods_allocationinteger>>9 0Number of periods
53start_year_allocationinteger9999 0Start year period allocation
54start_period_allocationinteger>>9 0Start period period allocation
55bank_acc_nrcharacterx(34) Bank account
56curr_code_bank_acc_nrcharacterx(3) Currency
57collection_codecharacterX(8) Collection code
58mandate_refcharacterX(35) Mandate reference

Indexes

lsihlix - primary - unique

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2invoice_codeinteger>>>>>>>9Invoice code
3seqnr_lsihlinteger>>>>>>>9Sequence number

lsihl2ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2invoice_statusinteger>>>>>9Status
3invoice_codeinteger>>>>>>>9Invoice code
4seqnr_lsihlinteger>>>>>>>9Sequence number

lsihl3ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2seqnr_lsohlint64>>>>>>>>>>>9Order number
3invoice_codeinteger>>>>>>>9Invoice code
4seqnr_lsihlinteger>>>>>>>9Sequence number

lsihl4ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2invoice_debtorint64>>>>>>>>>9Invoice debtor
3invoice_codeinteger>>>>>>>9Invoice code
4seqnr_lsihlinteger>>>>>>>9Sequence number

Contents > lsihl

     
 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.476
 Assortment:  Date: 01-05-2014
 Release:  Attachment:
 Disclaimer