Import/export template > Module Sales > Import/export template SIRHRIB (Sales Invoice (imp no calc.)) 

Use this template to import the employee's first bank ID number from the Sage SIRH product.

Prerequisites

Mandatory fields in the template

The mandatory field is:

  • Employee ID

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

ID number does not exist

Employee not defined in the management of employees.

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]

Business partner

BPCUSTMVT [MVC]

Customer transactions

BPCUSTOMER [BPC]

Customers

BPDLVCUST [BPD]

Ship-to customer

CONTSERV [CON]

Service contract

CPTANALIN [CAL]

Analytical accounting lines

FACILITY [FCY]

Sites

GACCCODE [CAC]

Accounting codes

GACCOUNT [GAC]

Accounts

GTYPACCENT [GTE]

Document types

HDKTASKINV [HDI]

Consumptions to be invoiced

ITMBPC [ITU]

Customer product

ITMCATEG [ITG]

Product category

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

ITMMVT [ITV]

Product-site totals

ITMSALES [ITS]

Products - sales

ITMWRH [ITW]

Products-warehouses

LPN [LPN]

License plate number

PRICSTRUCT [PRS]

Price structure (cust/supp)

SALESREP [REP]

Sales rep

SDELIVERY [SDH]

Delivery header

SDELIVERYD [SDD]

Delivery detail

SERREQUEST [SRE]

Service requests

SFOOTINV [SFI]

Invoicing elements

SINVOICE [SIH]

Sales invoices

SINVOICED [SID]

Sales invoice detail

SINVOICEV [SIV]

Costing sales invoice

SORDER [SOH]

Sales orders - header

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

TABCONTAINER [TCTR]

Container

TABCUR [TCU]

Currency table

TABPRTMOD [TPM]

Print template table

TABSIVTYP [TSV]

Customer invoice type table

TABUNIT [TUN]

Table of units of measure

WAREHOUSE [WRH]

Warehouses