Fact tables Sales lines

Description

To this fact table are linked:

Synchronization rules

These are the rules used to define the way the data are extracted from the database and the way the fact table is loaded. There are 10 of them for the Sales lines fact table:

• SQUOTE: Quote lines,
• SQUOTEINV: Invoicing elements of the quotes (for those invoicing elements associated with a BI product),
• SORDER: Order lines and delivery requests,
• SORDERINV: Invoicing elements of the orders,
• SDELIVERY: Validated delivery lines,
• SDELIVINV: Invoicing elements of those deliveries coming from validated deliveries,
• SRETURN: Return lines,
• SINVOICE: Validated delivery lines,
• SINVOICEIN: Invoicing elements of the posted invoices,
• SINVOICEDU: Paid or partly paid open items of the posted invoices.

The table fields can be loaded directly using a field in the database or their value determined via a calculation formula or the call result to a function. Their detailed list is provided below.

The invoicing elements associated with a document are only extracted if the following conditions are complied with:

• there is a product code associated with the setup of the invoicing element,
• the invoicing element is active,
• it is not distributed over the document lines.

Dimensions

These are database tables such as the country table, the site table, the accounting code table, etc.
Some dimensions belong to the Sales moduleand others are common to all the modules (Company, Site, Dimension type). Moreover they can be linked to several fact tables. Links have been established between these dimensions.
When a field in a fact table is linked to a dimension, the corresponding link expression is defined in the fact table (Links tab). The dimension list linked to the fact tableSales lines is provided below.

Hierarchies

These are pre-defined grouping criteria, used to navigate in the report according to the required detail level, by grouping or zooming on the detail of the hierarchy criteria.
These hierarchies are defined for the Datamart. They are detailed below.

Predefined conditions

These are conditions that will be used as filter criteria in the report itself. They are defined for each fact tables.
It can either be simple conditions using fields or constants, or conditions requiring the entry of values (conditions corresponding to the prompts to be entered in the reports).
The list is provided below.

Sub-classes (or Indicators)

In the fact table, each field having as object type: Measurecan be identified as belonging to a sub-class. Thanks to the BO Infoview tool, this classification is used to display this information grouped by indicator in the Sales universe (each indicator having been assigned to a sub-class). In the fact table, these indicators are of Amount or Quantity type: Order amounts, Receipt amounts, Purchase request quantities, etc.

For the Sales lines fact table, the sub-classes listand the list of the fields from which they are made are provided below.

Case of the sales kits and BOMs

• Two additional pieces of information are added in the fact table. They are the BOM component and the link quantity.
• For each line of a BOM, a line is generated with the parent product as product code and the component as component code.
• The quantity is specified on the parent product line only.
• A global analysis is thus possible on a parent product or on the components.

Product code	Component	Quantity	Link quantity	Price	Cost price
PARENT PRODUCT		1	0	100
PARENT PRODUCT	COMPONENT	0	1		10
PARENT PRODUCT	COMPONANT1	0	2		5
PARENT PRODUCT	OPTION1	0	1	10	5

Technical supplements

Data detail

Field code	Normal title	Menu	Table	Object type
DOC	Document	476		Dimension
LINDOC	Document line type	2216		Dimension
DOSSIER	Folder			Technical
DAT	Document date			Dimension
CPY	Company			Technical
FCY	Financial site			Technical
SALFCY	Sales site			Technical
STOFCY	Shipment site			Technical
BPCORD	Sold-to customer			Technical
BPCDLV	Ship-to customer			Technical
BPCINV	Bill-to customer			Technical
BPCPYR	Pay-by customer			Technical
BPCGRU	Group customer			Technical
BPCRSK	Risk customer			Technical
PJT	Project			Technical
CUR	Transaction currency			Technical
CURLOC	Company currency			Technical
CURFOLD	Folder currency			Technical
REP1	Sales representative 1			Technical
REP2	Sales representative 2			Technical
ITMREF	Product			Technical
CPNITMREF	Component product			Technical
AMTSIG	Signed:			Technical
SQHNUM	Quote number			Technical
SQDLIN	Quote line no.			Technical
SOHNUM	Order number			Technical
SOPLIN	Order line no.			Technical
SOQSEQ	Order line sequence no.			Technical
SDHNUM	Delivery number			Technical
SDDLIN	Delivery line no.			Technical
SIHNUM	Invoice number			Technical
SIDLIN	Invoice line no.			Technical
SRHNUM	Return number			Technical
SRDLIN	Return line no.			Technical
DIE1..DIE10	Dimension type codes			Technical
CCE1..CCE10	Analytical dimensions.			Technical
COA1..COA3	Charts of accounts			Technical
ACC1..ACC3	Accounts			Technical
FLOW	Flows	2215		Dimension
QTYSQH_US	STK quote quantity			Measurement
CPNQTYSQH_US	STK quote component quantity			Measurement
QTYSOH_US	STK order quantity			Measurement
CPNQTYSOH_US	STK order component quantity			Measurement
QTYSOD_US	STK quantity to be delivered			Measurement
CPNQTYSOD_US	STK component quantity to be delivered			Measurement
QTYSDH_US	STK delivery quantity			Measurement
CPNQTYSDH_US	STK delivery component quantity			Measurement
QTYSIH_US	STK invoice quantity			Measurement
CPNQTYSIH_US	STK invoice component quantity			Measurement
QTYSRH_US	STK return quantity			Measurement
AMTNOT_SQH	Quote line total ex tax			Measurement
AMTNOT_SOH	Order line total ex tax			Measurement
AMTNOT_SDH	Delivery line total ex tax			Measurement
AMTNOT_SIH	Invoice line total ex tax			Measurement
AMTNOT_SRH	Return line total ex tax			Measurement
AMTATI_SQH	Quote line total tax incl			Measurement
AMTATI_SOH	Order line total tax incl			Measurement
AMTATI_SDH	Delivery line total tax incl			Measurement
AMTATI_SIH	Invoice line total tax incl			Measurement
AMTATI_SRH	Return line total tax incl			Measurement
PFM_SQH	Quote line margin			Measurement
PFM_SOH	Order line margin			Measurement
PFM_SDH	Delivery line margin			Measurement
PFM_SIH	Invoice line margin			Measurement
PFM_SRH	Return line margin			Measurement
DISAMT_SQH	Quote line discount amount			Measurement
DISAMT_SOH	Order line discount amount			Measurement
DISAMT_SDH	Delivery line discount amount			Measurement
DISAMT_SIH	Invoice line discount amount			Measurement
EXPAMT_SQH	Quote line expense amount			Measurement
EXPAMT_SOH	Order line expense amount			Measurement
EXPAMT_SDH	Delivery line expense amount			Measurement
EXPAMT_SIH	Invoice line expense amount			Measurement
DISDTA_SQH	Discount amount of quote invoicing elements			Measurement
DISDTA_SOH	Discount amount of order invoicing elements			Measurement
DISDTA_SDH	Discount amount of delivery invoicing elements			Measurement
DISDTA_SIH	Discount amount of invoice invoicing elements			Measurement
EXPDTA_SQH	Expense amount of quote invoicing elements			Measurement
EXPDTA_SOH	Expense amount of order invoicing elements			Measurement
EXPDTA_SDH	Expense amount of delivery invoicing elements			Measurement
EXPDTA_SIH	Expense amount of invoice invoicing elements			Measurement
AMTPAY	Final amount paid			Measurement
TMPPAY	Temporary amount paid			Measurement
REPAM1_SQH	Commission sales rep 1 quote			Measurement
REPAM1_SOH	Commission sales rep1 order			Measurement
REPAM1_SDH	Commission sales rep1 delivery			Measurement
REPAM1_SIH	Commission sales rep1 invoice			Measurement
REPAM2_SQH	Commission sales rep2 quote			Measurement
REPAM2_SOH	Commission sales rep2 order			Measurement
REPAM2_SDH	Commission sales rep2 delivery			Measurement
REPAM2_SIH	Commission sales rep2 invoice			Measurement

All quantities are also defined in statistical units. *_STK fields also exist as *_ST.

All amounts are expressed in three currencies.

• the fields without extension in transaction currency,
• the fields with the extension *_C in company currency,
• the fields with the extension *_F in folder currency,

List of the specific loading formulas and functions

Specific loading formulas

• string$ ( !(find([F]LINTYP,1,2,6,10,11,12,13) <> 0) , [F:SQD]ITMREF ). This formula is used to load the product code in the component product field if the product in the document is an element belonging to a BOM or a kit.
• ([F]FOCFLG = 3) * 5 + !([F]FOCFLG = 3) * ( (find([F]LINTYP,1,10,11,12,13)) + !(find([F]LINTYP,1,10,11,12,13)) * ( (find([F]LINTYP,2, 6) <> 0) * 3 + !(find([F]LINTYP,2,6) <> 0) * 4 ) ): This formula is used to determine the type of the document line processed. It can be a normal line, an invoicing element, a parent product, a component, a free product or an open item.
• ([F]BETCPY - 1) * 2 + !([F]BETCPY - 1) * ( ([F]BETFCY - 1) * 3 + !([F]BETFCY - 1) ): this formula is used to specify whether the document line concerns a standard flow, an inter-company flow or an inter-site flow.

Specific loading functions

• BICPT.SETDIE(Index,"CAL"): this function returns the dimension type code, stored in the table of origin. It corresponds to the dimension type code stored in parameter CPT\BI\BIDIE+index, with the index being used as parameter.
• BICPT.SETDIE(Index,"CAL") : this function returns the dimension code, stored in the table of origin. It corresponds to the dimension type code stored in parameter CPT\BI\BIDIE+index.
• TRTX3BI.SETCOA(Index,[F]CPY): this function returns the chart of accounts, the ledger number and the company used as parameter.
• TRTX3BI.SETACC(Index,[F]CPY): this function returns the account stored in the table of origin (CPTANALIN), the ledger number and the company used as parameter.
• TRTX3BI.CNVAMT(CUR_ORI,CUR_DES,CUR_SOC,0,0,TYPCUR,DAT,AMOUNT): this function returns the amount of origin converted to the destination currency. Either the exchange rate type and date or the multiplying or dividing exchange rate is used as parameter.
• TRTX3BI.GETCUR(FCY): this function returns the site currency.
• TRTX3BI.GETSYSCUR(): this function returns the folder currency.
• TRTX3BI.CNVQTY(QTY_ORI, UNIT_ORI, UNIT_DES, ITMREF, ABVRFIC , NUMDOC, NUMDOC_LIN, NUMDOC_SEQ, ROUND_CODE, NB_DEC): this function returns the quantity of origin converted to the destination unit.
• TRTVENBI.GETSALDCA( TYPDOC,[F]NUMDOC,[F]NUMDOC_LIN, NUMDOC_SEQ, [F]CUR, TYPVALEUR): this function returns the discount or expense amount for a document line in the requested currency. The last argument makes it possible to choose between expenses(1) and discounts(2).
• TRTVENBI.GETSFIDCA(TYPDOC,[F]NUMDOC,[F]NUMDOC_LIN,NUMDOC_SEQ,[F]CUR,TYPVALEUR): this function returns the amounts of the expense or discount-type invoicing elements distributed on the lines for a document line. The last argument makes it possible to choose between expenses(1) and discounts(2).
• TRTVENBI.GETCOMREP(1,[F]NUMDOC,[F]NUMDOC_LIN,NUMDOC_SEQ,REP): this function returns the commission amount for the sales representative of the document line. The last argument is used to choose between the main sales representative (REP=1) and the secondary sales rep (REP=2).
• TRTX3BI.GETLASTLIN("TABLE", NUMDOC): this function returns the last line number of a document. This function is used to assign line numbers for invoicing elements and open items.

For the various functions using parameter TYPDOC, said parameter can contain the following values:

• 1 = Quote,
• 20 = Orders,
• 13 = Delivery requests,
• 2 = Deliveries,
• 3 = Returns,
• 4 = Invoices/credit memos.

List of dimensions

Common dimensions

• Folder - FOLDERX3
  Table of origin: ADOSSIER
  Update type: Cancels and replaces
  
• Company - COMPANY
  Table of origin: COMPANY
  Update type: Incremental
  
• Site - FACILITY
  Table of origin: FACILITY
  Update type: Incremental
  
• Customers - BPCUSTOMER
  Table of origin: BPCUSTOMER
  Update type: Incremental
  
  BPs - BPARTNER
  Table of origin: BPARTNER
  Update type: Incremental
  
• Projects - PJT
  Table of origin: OPPOR
  Update type: Cancels and replaces
  
• Currency - CURRENCY
  Table of origin: TABCUR
  Update type: Incremental
  
• Sales representative - SALESREP
  Table of origin: SALESREP
  Update type: Cancels and replaces
  
• Product - ITMMASTER
  Table of origin: ITMMASTER
  Update type: Incremental
  
• Account- ACCOUNT
  Table of origin: GACCOUNT
  Update type: Cancels and replaces
  
• Dimension - CENTER
  Table of origin: CACCE
  Update type: Incremental

Dimensions of the Sales module

• Quote - SQUOTE
  Table of origin: SQUOTED
  Update type: Incremental
  
• Sales orders - SORDER
  Table of origin: SORDERQ
  Update type: Incremental
  
• Deliveries - SDELIVERY
  Table of origin: SDELIVERYD
  Update type: Incremental
  
• Sales return - SRETURN
  Table of origin: SRETURND
  Update type: Incremental
  
• Invoice - SINVOICE
  Table of origin: SINVOICED
  Update type: Incremental

Dimensions of the Financials module

• Account pyramid- PYRACC
  Table of origin: GACCPYMPRT
  Update type: Cancels and replaces
  
• Dimension pyramid- PYRCCE
  Table of origin: GCCEPYMPRT
  Update type: Cancels and replaces

Hierarchy list

• SALBPCDGEO- Ship-to-customer geography

- Ship-to-Customer
- Country
- Continent

• SALBPCDITM - Ship-to-Customer - product

Ship-to-Customer
- Product

• SALBPCDPJT - Ship-to-Customer - project

- Ship-to-Customer
- Project

• SALBPCDREP - Ship-to-Customer - sales representative. 1

- Ship-to-Customer
- Sales representative

• SALBPCDSTA - Ship-to-Customer statistics

- Customer
- Customer nature
- Geographical area
- Company size
- Miscellaneous
- Customer category

• SALBPCDGEO- Group customer geography

- Group Customer
- Country
- Continent

• SALBPCGITM - Group customer - product

- Group customer
- Product

• SALBPCGPJT - Group customer - project

- Group customer
- Project

SALBPCDREP - Group customer - sales representative. 1

- Group customer
- Sales representative

SALBPCGSTA - Group customer statistics

- Customer
- Customer nature
- Geographical area
- Company size
- Miscellaneous
- Customer category

• SALBPCIGEO - Bill-to-Customer geography

- Bill-to-Customer
- Country
- Continent

• SALBPCIITM - Bill-to-customer - product

- Bill-to customer
- Product

• SALBPCIPJT - Bill-to-customer - project

- Bill-to-customer
- Project

• SALBPCIREP - Bill-to-customer - sales representative. 1

- Bill-to-customer
- Sales representative

• SALBPCISTA - Bill-to-customer statistics

- Bill-to-customer
- Customer nature
- Geographical area
- Company size
- Miscellaneous
- Customer category

• SALBPCOGEO - Sold-to-customer geography

- Sold-to-customer
- Country
- Continent

• SALBPCOITM - Sold-to-customer - product

- Sold-to-customer
- Product

• SALBPCOPJT - Sold-to-customer - project

- Sold-to-customer
- Project

• SALBPCOREP - Sold-to-customer - sales representative 1

- Sold-to-customer
- Sales representative

• SALBPCOSTA - Sold-to-customer statistics

- Sold-to-customer
- Customer nature
- Geographical area
- Company size
- Miscellaneous
- Customer category

• SALBPCPGEO - Pay-By BP geography

- Pay-By BP
- Country
- Continent

• SALBPCRGEO - Risk customer geography

- Risk customer
- Country
- Continent

• SALBPCROL - Customer roles

- Ship-to-customer
- Sold-to-customer
- Bill-to-customer
- Group customer
- Risk customer

• SALBPCRSTA - Risk customer statistics

- Risk customer
- Customer nature
- Geographical area
- Company size
- Miscellaneous
- Customer category

• SALCITMSTA - Component product statistics

- Product
- Stat.1 prod.
- Stat. 2 product
- Stat. 3 product
- Stat. 4 product
- Stat. 5 product

• SALINVCAR - Carrier Geography

- Carrier
- Country invoice
- Continent invoice

• SALINVGEO - Invoice geography

- Postal code_1
- Town_1
- Department/province code_1
- Region code_1
- Country_1
- Continent_1

• SALITMSTA - Product statistics

- Product
- Stat.1 prod.
- Stat. 2 product
- Stat. 3 product
- Stat. 4 product
- Stat. 5 product

• SALREP1 - Sales representative 2 geography

- Sales representative
- Country
- Continent

• SALREP2 - Sales representative 2 geography

- Sales representative
- Country
- Continent

• SALREPBPCD - Sales rep. - Ship-to-customer group

- Sales representative
- Customer nature

• SALREPBPCG - Sales rep. - Group customer group

- Sales representative
- Customer nature

• SALREPBPCI - Sales rep. - Bill-to-customer group

- Sales representative
- Customer nature

• SALREPBPCO - Sales rep. - Sold-to-customer group

- Sales representative
- Customer nature

• SALREPITM - Sales representative - product

- Sales representative
- Product

• SALREPSITM - Sales representative - Product group

- Sales representative
- Stat.1 prod.

• SALSALCPY - Sales: sales site

- Sales site
- Financial site
- Company

• SALSTMBPCD - Product group - ship-to-customer

- Ship-to-customer
- Stat.1 prod.

• SALSTMBPCG - Product group - group customer

- Group customer
- Stat.1 prod.

• SALSTMBPCI - Product group - bill-to-customer

- Bill-to-customer
- Stat.1 prod.

• SALSTMBPCO - Product group - sold-to-customer

- Sold-to-customer
- Stat.1 prod.

List of the predefined conditions

Code	Title	Dimension
ISALAMTK	Ex tax limit in K currency
ISALBPCDE	Ship-to customer End	BPCUSTOMER
ISALBPCDS	Ship-to customer Start	BPCUSTOMER
ISALBPCGE	Group customer End	BPCUSTOMER
ISALBPCGS	Group customer Start	BPCUSTOMER
ISALBPCIE	Bill-to-customer End	BPCUSTOMER
ISALBPCIS	Bill-to-customer Start	BPCUSTOMER
ISALBPCOE	Sold-to-customer End	BPCUSTOMER
ISALBPCOS	Sold-to-customer Start	BPCUSTOMER
ISALBPCPE	Pay-by-customer End	BPARTNER
ISALBPCPS	Pay-by-customer Start	BPARTNER
ISALBPCRE	Risk customer End	BPCUSTOMER
ISALBPCRS	Risk customer Start:	BPCUSTOMER
ISALCNOE	Credit memo reason End	SINVOICE
ISALCNOS	Credit memo reason Start	SINVOICE
ISALCPYE	Company End	COMPANY
ISALCPYS	Company Start	COMPANY
ISALDAT	Reference deadline
ISALFCYE	Sales site End	FACILITY
ISALFCYS	Sales site Start	FACILITY
ISALITME	Product End	ITMMASTER
ISALITMS	Product Start	ITMMASTER
ISALPERN1E	N-1 analysis end date
ISALPERN1S	N-1 analysis start date
ISALPERNE	N analysis end date
ISALPERNS	N analysis start date
ISALPJT	Off-project included?	PJT
ISALPJTE	Project End	PJT
ISALPJTS	Project Start	PJT
ISALRAT	Weighing percentage
ISALREPE	Sales representative 1 End	SALESREP
ISALREPS	Sales representative 1 Start	SALESREP
ISALSFI	Invoicing elements included?
ISALTSCE	Group 1 Bill-to-customer End	BPCUSTOMER
ISALTSCS	Group 1 Bill-to-customer Start	BPCUSTOMER
ISALTSDE	Group 1 Ship-to-customer End	BPCUSTOMER
ISALTSDS	Group 1 Ship-to-customer Start	BPCUSTOMER
ISALTSGE	Group 1 Group customer End	BPCUSTOMER
ISALTSGS	Group 1 Group customer Start	BPCUSTOMER
ISALTSI2E	Product group 1 - not used End	ITMMASTER
ISALTSI2S	Product group 1 - not used Start	ITMMASTER
ISALTSIE	Product group 1 End	ITMMASTER
ISALTSIS	Product group 1 Start	ITMMASTER
ISALTSOE	Group 1 Sold-to-customer End	BPCUSTOMER
ISALTSOS	Group 1 Sold-to-customer Start	BPCUSTOMER
ISALTSRE	Group 1 Risk customer End	BPCUSTOMER
ISALTSRS	Group 1 Risk customer Start	BPCUSTOMER
SALANNCOU	Current year
SALANNPRE	Previous year
SALCNO	Credit memo
SALCOUINVF	Country : France	SINVOICE
SALINV	Sales invoices

Sub-classes list (Indicators)

Sub-classes (or Indicators)

• Order quantities indicators
• Quote quantities indicators
• Invoice quantities indicators
• Delivery quantities indicators
• Return quantities indicators
• Order Amountsindicators
• Quote Amountsindicators
• Invoice Amountsindicators
• Delivery Amountsindicators
• Return Amountsindicators

List of the fields from which the sub-classes are made.

Order quantities indicators

- STK order quantity
- STA order quantity
- STK order component qty
- STA order component qty
- STK quantity to deliver
- STA quantity to deliver
- STK component qty to deliver
- STA component qty to deliver

Quote quantities indicators

- STK quote quantity
- STA quote quantity
- STK quote component qty
- STA quote component qty

Invoice quantities indicators

- STK invoice quantity
- STA invoice quantity
- STK invoice component qty
- STA invoice component qty

Delivery quantities indicators

- STK delivery quantity
- STA delivery quantity
- STK delivery component qty
- STA delivery component qty

Return quantities indicators

- STK return quantity
- STA return quantity

Order Amounts indicators

- Ex tax amount order line
- Ex tax amount order line Cy
- Ex tax amount order line Folder
- Tax incl. amount order line
- Tax incl. amount order line Cy
- Tax incl. amount order line Folder
- Order line margin
- Order line margin Cy
- Order line margin Folder
- Discount amt order line
- Discount amt order line Cy
- Discount amt order line Folder
- Expense amt order line
- Expense amt order line Cy
- Expense amt order line Folder
- Discount amt order invoicing elt
- Discount amt order invoicing elt Cy
- Discount amt order invoicing elt Folder
- Expense amt order invoicing elt
- Expense amt order invoicing elt Cy
- Expense amt order invoicing elt Folder
- Order sales rep. 1 comm.
- Order sales rep. 1 comm. Cy
- Order sales rep. 1 comm. Folder
- Order sales rep. 2 comm.
- Order sales rep. 2 comm. Cy
- Order sales rep. 2 comm. Folder

Quote Amounts indicators

- Ex tax amount quote line
- Ex tax amount quote line Cy
- Ex tax amount quote line Folder
- Tax incl. amount quote line
- Tax incl. amount quote line Cy
- Tax incl. amount quote line Folder
- Quote line margin
- Quote line margin Cy
- Quote line margin Folder
- Discount amt quote line
- Discount amt quote line Cy
- Discount amt quote line Folder
- Expense amt quote line
- Expense amt quote line Cy
- Expense amt quote line Folder
- Discount amt quote invoicing elt
- Discount amt quote invoicing elt Cy
- Discount amt quote invoicing elt Folder
- Expense amt quote invoicing elt
- Expense amt quote invoicing elt Cy
- Expense amt quote invoicing elt Folder
- Quote sales rep. 1 comm.
- Quote sales rep. 1 comm. Cy
- Quote sales rep. 1 comm. Folder
- Quote sales rep. 2 comm.
- Quote sales rep. 2 comm. Cy
- Quote sales rep. 2 comm. Folder

Invoice Amounts indicators

- Tax ex amount invoice line
- Tax ex amount invoice line Cy
- Tax ex amount invoice line Folder
- Tax incl invoice line
- Tax incl invoice line Cy
- Tax incl invoice line Folder
- Invoice line margin
- Invoice line margin
- Invoice line margin Folder
- Discount amt invoice line
- Discount amt invoice line Cy
- Discount amt invoice line Folder
- Expense amt invoice line
- Expense amt invoice line Cy
- Expense amt invoice line Folder
- Discount amt invoice inv. elt
- Discount amt invoice inv. elt Cy
- Discount amt invoice inv. elt Folder
- Expense amt invoice inv. elt
- Expense amt invoice inv. elt Cy
- Expense amt invoice inv. elt Folder
- Final amount paid
- Final amount paid Cy
- Final amount paid Folder
- Temporary amount paid
- Temporary amount paid Cy
- Temporary amount paid Folder
- Invoice sales representative 1 comm.
- Invoice sales representative 1 comm. Cy
- Invoice sales representative 1 comm. Folder
- Invoice sales representative 2 comm.
- Invoice sales representative 2 comm. Cy
- Invoice sales representative 2 comm. Folder

Delivery Amounts indicators

- Ex tax amount delivery line
- Ex tax amount delivery line Cy
- Ex tax amount delivery line Folder
- Tax incl amount delivery line
- Tax incl amount delivery line Cy
- Tax incl amount delivery line Folder
- Delivery line margin
- Delivery line margin Cy
- Delivery line margin Folder
- Discount amt delivery line
- Discount amt delivery line Cy
- Discount amt delivery line Folder
- Expense amt delivery line
- Expense amt delivery line Cy
- Expense amt delivery line Folder
- Discount amt delivery inv. elt
- Discount amt delivery inv. elt Cy
- Discount amt delivery inv. elt Folder
- Expense amt delivery inv. elt
- Expense amt delivery inv. elt Cy
- Expense amt delivery inv. elt Folder
- Delivery sales representative 1 comm.
- Delivery sales representative 1 comm. Cy
- Delivery sales representative 1 comm. Folder
- Delivery sales representative 2 comm.
- Delivery sales representative 2 comm. Cy
- Delivery sales representative 2 comm. Folder

Return Amounts indicators

- Ex tax amount return line
- Ex tax amount return line Cy
- Ex tax amount return line Folder
- Tax incl return line
Tax incl return line Cy
- Tax incl return line Folder
- Return line margin
- Return line margin Company
- Return line margin Folder