Import/export template > Module Sales > Import/export template SIHIMPCAL (Sales Invoices(imp calcul.))
 |
 |
Sales Invoices(imp calcul.)
Use this template to import sales invoices, where the invoice footer calculation is triggered.
You can import the first ten invoicing elements. The analytical dimension types are not imported, they must be set up by default.
This import template is not exhaustive: the configuration is submitted for information purposes only.
Tables used
This template can be used in import and export modes. The data is updated in the following tables :
| Table |
Table description |
|---|---|
|
BPARTNER [BPR] |
|
|
BPCUSTMVT [MVC] |
Customer transactions |
|
BPCUSTOMER [BPC] |
|
|
BPDLVCUST [BPD] |
|
|
CONTSERV [CON] |
|
|
CPTANALIN [CAL] |
Analytical accounting lines |
|
FACILITY [FCY] |
|
|
GACCCODE [CAC] |
|
|
GACCOUNT [GAC] |
|
|
GTYPACCENT [GTE] |
|
|
HDKTASKINV [HDI] |
Consumptions to be invoiced |
|
ITMBPC [ITU] |
|
|
ITMCATEG [ITG] |
|
|
ITMFACILIT [ITF] |
|
|
ITMMASTER [ITM] |
|
|
ITMMVT [ITV] |
Product-site totals |
|
ITMSALES [ITS] |
|
|
ITMWRH [ITW] |
|
|
PRICSTRUCT [PRS] |
|
|
SALESREP [REP] |
|
|
SDELIVERY [SDH] |
|
|
SDELIVERYD [SDD] |
Delivery detail |
|
SERREQUEST [SRE] |
|
|
SFOOTINV [SFI] |
|
|
SINVOICE [SIH] |
Sales invoices |
|
SINVOICED [SID] |
Sales invoice detail |
|
SINVOICEV [SIV] |
Costing sales invoice |
|
SORDER [SOH] |
|
|
SORDERP [SOP] |
Sales orders - price |
|
SORDERQ [SOQ] |
Sales orders - quantities |
|
SPRICLINK [SPK] |
Sales price list search |
|
SPRICLIST [SPL] |
Customer price lists |
|
SRETURND [SRD] |
Sales return detail |
|
STOCK [STO] |
Stock |
|
STOJOU [STJ] |
Stock journal |
|
STOLOT [STL] |
Lot numbers |
|
SVCRFOOT [SVF] |
Sales document - footer el. |
|
SVCRVAT [SVV] |
Sales document - tax |
|
TABCUR [TCU] |
|
|
TABPRTMOD [TPM] |
|
|
TABSIVTYP [TSV] |
|
|
TABUNIT [TUN] |
|
|
WAREHOUSE [WRH] |