One moment please...
 
 
Exact Financials   
 

Data dictionary scentry - scenario entry lines - 7.20

#Field nameData typeFormatDecExtentDefaultLabel
1adm_nrinteger>>>>>9 ?Company
2journal_nrinteger>>9 ?Journal
3scenario_codecharacterx(12) ?Scenario
4line_nrinteger>>>>>9 ?Line
5linenr_scentry_userinteger>>>9 0Line number (User)
6change_line_nrlogicalyes/no yesChange line
7acc_nrcharacterx(12) Account
8change_acc_nrlogicalyes/no yesChange account
9descrcharacterX(60) Description
10change_descrlogicalyes/no yesChange description
11debtorint64>>>>>>>>>9 0Debtor
12change_debtorlogicalyes/no yesChange debtor
13creditorint64>>>>>>>>>9 0Creditor
14change_creditorlogicalyes/no yesChange creditor
15vat_codecharacterx(3) 0VAT code
16change_vat_codelogicalyes/no yesChange VAT code
17curr_codecharacterx(3) Currency
18change_curr_codelogicalyes/no yesChange currency
19amt_currdecimal->>>,>>>,>>>,>>>,>>9.994 0Currency amount
20perc_amt_currdecimal->>9.992 0Percentage header currency amount
21change_amt_currlogicalyes/no yesChange Currency amount
22vat_amt_currdecimal->>>,>>>,>>>,>>>,>>9.994 0Currency VAT amount
23change_vat_amt_currlogicalyes/no yesChange currency VAT amount
24cost_centercharacterx(12) Cost center
25change_cost_centerlogicalyes/no yesChange Cost center
26cost_unitcharacterx(12) Cost unit
27change_cost_unitlogicalyes/no yesChange cost unit
28qtydecimal->>>>>>>>>9.994 0Quantity
29change_qtylogicalyes/no yesChange quantity
30rev_entrylogicalyes/no yesReversal entry
31change_rev_entrylogicalyes/no yesChange reversal entry
32del_acqinteger>>>>>9 0Supply/acquisition
33change_del_acqlogicalyes/no yesChange Supply/acquisition
34mcode1characterx(12) Mdim 1
35change_mcode1logicalyes/no yesChange mdim 1
36mcode2characterx(12) Mdim 2
37change_mcode2logicalyes/no yesChange
38mcode3characterx(12) Mdim 3
39change_mcode3logicalyes/no yesChange
40mcode4characterx(12) Mdim 4
41change_mcode4logicalyes/no yesChange
42mcode5characterx(12) Mdim 5
43change_mcode5logicalyes/no yesChange
44invoice_nr_typeinteger>>>>>9 1Invoice type
45change_invoice_nr_typelogicalyes/no yesChange
46ca_acc_nrcharacterx(12) Account
47change_ca_acc_nrlogicalyes/no yesChange
48ca_cost_centercharacterx(12) Cost center
49change_ca_cost_centerlogicalyes/no yesChange
50ca_cost_unitcharacterx(12) intercompany cost unit
51change_ca_cost_unitlogicalyes/no yesChange
52ca_qtydecimal->>>>>>>>>9.994 0Quantity
53change_ca_qtylogicalyes/no yesChange
54ca_debtorint64>>>>>>>>>9 0IC debtor
55change_ca_debtorlogicalyes/no yesChange
56ca_creditint64>>>>>>>>>9 0IC creditor
57change_ca_creditlogicalyes/no yesChange IC creditor
58ca_invoice_nr_typeinteger>>>>>9 1IC invoice type
59change_ca_invoice_nr_typelogicalyes/no yesChange IC invoice type
60time_lcinteger->,>>>,>>9 ?
61date_lcdate99/99/9999
62euserid_lccharacterX(12)
63type_lccharacterx(8)
64source_lccharacterx(12)
65project_codecharacterx(12) Project
66project_descriptioncharacterX(60) Project description
67project_cost_centercharacterx(12) Project cost center
68project_cost_cat_codecharacterx(12) Project cost category
69result_typeinteger>>>>>9 1Result type
70change_project_codelogicalyes/no yesChange
71change_pro_cost_cat_codelogicalyes/no yesChange
72change_project_cost_centerlogicalyes/no yesChange
73change_project_descriptionlogicalyes/no yesChange
74change_result_typelogicalyes/no yesChange
75change_ic_acc_nrlogicalyes/no yesChange
76change_ic_cost_centerlogicalyes/no yesChange
77change_ic_cost_unitlogicalyes/no yesChange
78change_ic_mdim_code_1logicalyes/no yesChange
79change_ic_mdim_code_2logicalyes/no yesChange
80change_ic_mdim_code_3logicalyes/no yesChange
81change_ic_mdim_code_4logicalyes/no yesChange
82change_ic_mdim_code_5logicalyes/no yesChange
83change_ic_project_codelogicalyes/no yesChange
84change_ic_cost_cat_codelogicalyes/no yesChange
85change_ic_pro_cost_centerlogicalyes/no yesChange
86change_ic_project_descrlogicalyes/no yesChange
87change_ic_result_typelogicalyes/no yesChange
88change_ic_qtylogicalyes/no yesChange
89nr_periods_allocationinteger>>9 0Number of periods
90change_nr_periods_allocatlogicalyes/no yesChange

Indexes

scentryix - primary - unique

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2journal_nrinteger>>9Journal
3scenario_codecharacterx(12)Scenario
4line_nrinteger>>>>>9Line

scentry04ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2journal_nrinteger>>9Journal
3scenario_codecharacterx(12)Scenario
4linenr_scentry_userinteger>>>9Line number (User)

scentry2ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2journal_nrinteger>>9Journal
3debtorint64>>>>>>>>>9Debtor
4scenario_codecharacterx(12)Scenario
5line_nrinteger>>>>>9Line

scentry3ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2journal_nrinteger>>9Journal
3creditorint64>>>>>>>>>9Creditor
4scenario_codecharacterx(12)Scenario
5line_nrinteger>>>>>9Line

Contents > scentry

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