One moment please...
 
 
Exact Financials   
 

Data dictionary llrech - Recurring headers - 7.20

#Field nameData typeFormatDecExtentDefaultLabel
1adm_nrinteger>>>>>9 ?Company
2rec_typeinteger>>>>>9 ?Type
3seqnr_llrechinteger>>>>>>>9 ?Number
4rec_stateinteger>>>>>9 0State
5creditorint64>>>>>>>>>9 0Creditor
6invoice_codeinteger>>9 0Invoice code
7sel_codecharacterX(2) Selection code
8representativecharacterX(12) 0Representative
9curr_codecharacterX(3) Currency
10pay_conditioncharacterX(4) Payment condition
11referencecharacterX(60) Reference
12reference_1characterX(60) Reference
13reference_2characterX(60) Reference
14reference_3characterX(60) Reference
15exdescr_codecharacterX(2) Extra description code
16text_codecharacterx(12) Text code
17order_methodcharacterx(12) Order method
18delivery_methodcharacterx(12) Delivery method
19line_amt_ex_vat_ex_ldiscdecimal->>>,>>>,>>>,>>>,>>9.994 0Line amount
20line_discount_amt_ex_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0Line discount amount
21cost_codecharacterx(12) Cost code
22order_costsdecimal->>>,>>>,>>>,>>>,>>9.994 0Order costs
23vat_code_order_costscharacterX(3) VAT code
24order_costs_ex_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0Order costs
25freight_costsdecimal->>>,>>>,>>>,>>>,>>9.994 0Freight costs
26vat_code_freight_costscharacterX(3) VAT code
27freight_costs_ex_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0Freight costs
28invoice_discount_percdecimal->>9.994 0Invoice discount
29invoice_discount_amtdecimal->>>,>>>,>>>,>>>,>>9.994 0Invoice discount
30line_vat_amtdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT line amount
31order_costs_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT order costs
32freight_costs_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT freight costs
33invoice_discount_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT invoice discount
34amt_inc_vat_inc_discdecimal->>>,>>>,>>>,>>>,>>9.994 0Total amount
35userid_approvecharacterX(12) Approved by
36origininteger>>>>>9 0Origin
37nr_periods_allocationinteger>>9 0Number of periods
38invoice_ownercharacterX(12) 0Invoice owner
39percentage_1decimal->>9.994 0Percentage
40amount_1decimal->>>,>>>,>>>,>>>,>>9.994 0Amount
41percentage_2decimal->>9.994 0Percentage
42amount_2decimal->>>,>>>,>>>,>>>,>>9.994 0Amount
43percentage_3decimal->>9.994 0Percentage
44amount_3decimal->>>,>>>,>>>,>>>,>>9.994 0Amount
45percentage_4decimal->>9.994 0Percentage
46amount_4decimal->>>,>>>,>>>,>>>,>>9.994 0Amount
47percentage_5decimal->>9.994 0Percentage
48amount_5decimal->>>,>>>,>>>,>>>,>>9.994 0Amount
49amount_inc_vat_inc_disc_bldecimal->>>,>>>,>>>,>>>,>>9.994 0Amount blocked account
50generation_frequencyinteger>>>>>9 0Frequency
51generation_dateinteger>>>>>9 0Date
52offset_daysinteger->>9 0Offset days
53euserid_crcharacterX(12) User creation
54date_crdate99/99/9999 Date creation
55time_crinteger>>>>>9 ?Time creation
56source_crcharacterx(12) Source creation
57euserid_lccharacterX(12) User last changed
58date_lcdate99/99/9999 Date last changed
59time_lcinteger>>>>>9 ?Time last changed
60source_lccharacterx(12) Source last changed
61payment_methodinteger>>>>>9 0Payment method

Indexes

llrech01ix - primary - unique

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2rec_typeinteger>>>>>9Type
3seqnr_llrechinteger>>>>>>>9Number

Contents > llrech

     
 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: 26.936.380
 Assortment:  Date: 27-01-2016
 Release:  Attachment:
 Disclaimer