One moment please...
 
 
Exact Financials   
 

Data dictionary lpeil - Purchase invoice lines

#Field nameData typeFormatDecExtentDefaultLabel
1adm_nrinteger>>>>>9 0Company
2entry_numberint64>>>>>>>>>>>9 0Purchase invoice number
3linenr_lpeilinteger>>>9 0Purchase invoice line
4linenr_lpeil_userinteger>>>9 0Line number (User)
5item_codecharacterX(20) Item
6external_item_codecharacterX(20) External item code
7descrcharacterX(60) Description
8quantity_invoiceddecimal->>>,>>>,>>9.9996 0Quantity
9vat_codecharacterX(3) VAT code
10price_ex_discdecimal->>>,>>>,>>9.9996 0Price
11commitment_nrint64>>>>>>>>>>>9 0Commitment
12commitment_lineinteger>>>9 0Commitment line
13cost_centercharacterX(8) Cost center
14cost_unitcharacterX(8) Cost unit
15mdim_code_1characterX(8) Mdim
16mdim_code_2characterX(8) Mdim
17mdim_code_3characterX(8) Mdim
18mdim_code_4characterX(8) Mdim
19mdim_code_5characterX(8) Mdim
20project_codecharacterX(10) Project
21cost_cat_codecharacterX(8) Cost category
22project_cost_centercharacterX(8) Cost center
23project_descrcharacterX(60) Description
24asset_codecharacterX(12) Asset
25amt_ex_vat_ex_discdecimal->>>,>>>,>>>,>>>,>>9.994 0Gross line amount
26line_discount_percdecimal->>9.994 0Line discount
27line_discount_amtdecimal->>>,>>>,>>>,>>>,>>9.994 0Line discount
28amt_ex_vat_inc_discdecimal->>>,>>>,>>>,>>>,>>9.994 0Net line amount
29amt_inc_vat_inc_discdecimal->>>,>>>,>>>,>>>,>>9.994 0Net line amount inc VAT
30line_vat_amt_ex_discdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT amount
31scpdecimal->>>,>>>,>>9.9996 0Standard cost price
32order_costsdecimal->>>,>>>,>>>,>>>,>>9.994 0Order costs
33vat_code_order_costscharacterX(3) VAT code
34order_costs_ex_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0Order costs
35order_costs_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT order costs
36freight_costsdecimal->>>,>>>,>>>,>>>,>>9.994 0Freight costs
37vat_code_freight_costscharacterX(3) VAT code
38freight_costs_ex_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0Freight costs
39freight_costs_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT freight costs
40invoice_discount_amtdecimal->>>,>>>,>>>,>>>,>>9.994 0Invoice discount
41invoice_discount_vatdecimal->>>,>>>,>>>,>>>,>>9.994 0VAT invoice discount
42euserid_crcharacterX(12) User creation
43date_crdate99/99/9999 Date creation
44time_crinteger>>>>>9 0Time creation
45source_crcharacterX(8) Source creation
46euserid_lccharacterX(12) User last changed
47date_lcdate99/99/9999 Date last changed
48time_lcinteger>>>>>9 0Time last changed
49source_lccharacterX(8) Source last changed
50price_surchargedecimal->>>,>>>,>>9.9996 0Surcharge
51master_asset_idcharacterX(8) Asset set
52asset_quantitydecimal->>>,>>>,>>9.9994 0Quantity
53asset_descriptioncharacterX(60) Description
54get_receiptlogicalTRUE/FALSE FALSEReceipt
55delivery_datedate99/99/9999 Required delivery date
56location_codecharacterX(8) Location
57pricelist_codecharacterX(3) Price list
58discount_typeinteger>>>>>9 0Discount type
59discount_calculationinteger>>>>>9 0Discount calculation
60is_commitment_correctionlogicalyes/no noCorrection

Indexes

lpeilix - primary - unique

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2entry_numberint64>>>>>>>>>>>9Purchase invoice number
3linenr_lpeilinteger>>>9Purchase invoice line

lpeil03ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2entry_numberint64>>>>>>>>>>>9Purchase invoice number
3linenr_lpeil_userinteger>>>9Line number (User)

lpeil2ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2item_codecharacterX(20)Item
3entry_numberint64>>>>>>>>>>>9Purchase invoice number
4linenr_lpeilinteger>>>9Purchase invoice line

Contents > lpeil

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