General

Attribute

Description

Example / Calculation

•Calculated Cost

This is the calculated cost per cost category, per job, per sub-job

 

 

 

•Calculated Margin

[Invoiced Value] - [Calculated Cost]

 

•Calculated Margin %

[Calculated Margin] / [Invoiced Value]

 

•Calculator

Job calculator

 

 

•Created By

The person who created the sales order.

 

 

•Created Via

How was the sales order created?

Possible values:

•Not created via internet

•PBM customer portal

•Web4labels online calculation

•RFQ labels

•Web4labels RFQ

•Tender

•Online calculation

 

 

•Creation Date

The creation date and time of the sales order. This column is linked to the dimen­sion "Date".

 

 

•Criterion1

First criterion field

 

 

•Criterion2

Second criterion field

 

 

•Customer Count

Number of unique Customers

 

 

•Document Type

Type of the document.

Possible values:

"Invoice", "Credit Note"

"Invoice"

 

•Exchange Rate

Exchange rate.

 

 

•Financial Year ID

ID of the financial year.

 

 

•Free field

Free field

 

 

•Invoice ID

ID of the invoice.

 

 

•Invoice Price Line Descrip­tion1

The first description of the invoice line item. The description comes directly from the parameters, meaning overwriting it in the sales order doesn't influence the value.

 

 

•Invoice Price Line Descrip­tion2

The second description of the invoice line item. The description comes directly from the parameters, meaning overwriting it in the sales order doesn't influence the value.

 

 

•Invoice Price Line Keyword

The keyword of the invoice line item. The keyword comes directly from the parameters, meaning overwriting it in the sales order doesn't influence the value.

 

 

•Invoice Site

Site of the invoice.

 

 

•Invoice Status1 ... 10

Free invoice statuses

 

 

•Invoiced Value

This is the invoiced value in system currency.

 

 

•Job Count

Number of unique jobs

 

 

•Journal ID

ID of the journal.

 

 

•Packing Slip ID

Packing Slip ID or Delivery Note No.

 

 

•Period

Period description.

 

 

•Price Category

For which volume or units is the price given. Price per ...

Possible values:

1: Discount/ Supplement

2: Fixed amount

3: /kg or /lb

4: /page

5: /piece

6: /100

7: /1000

8: /100000

9: /1000 kg or /sn tn

B: /m or /ft

C: /m² or /msi

Unknown

 

 

•Real Cost

This is the real costs per cost category, per job, per sub-job, per productive.

 

 

•Real Margin

[Invoiced Value] - [Real Cost]

 

•Real Margin %

[Real Margin] / [Invoiced Value]

 

•Representative

Representative name

 

 

•Representative ID

Unique ID of the representative

 

 

•Sales Order ID

ID of the sales order. The "Sales Order ID" has a unique value for every record within this table.

 

 

•Sequence Nr

Sequence of the invoice lines.

 

 

•SK Estimate

 

 

 

•User

The user who created the invoice.

 

 

•Version ID

ID of the version in the job.

 

 

 

 

 

 

 

 

 

HD Privacy Statement  |  Imprint  |  Prinect Know How