Billable Lines (cisli8110m000)

Use this session to view billable lines and their details.

 

Source Company
The source company.
Source Type
The source document type.
Source Document
The source document number.
Order Line
The line number of the order data.
Order Reference
Additional information related to the order.

Which information is stored depends on the source type:

Source TypeOrder Reference
ContractContract Line
ProjectSold-to Business Partner
Sales OrderShipment
RebateRebate Relation
Warehouse OrderShipment

 

Invoice Status
Billing Sequence
The billing sequence number assigned to the billable line. Default value: 1
Note
  • Only for a sales schedule-related self-billed invoice, the value can be greater than 1.
  • For billable lines that are split as a result of approving a partially matched self-billed invoice, a new billing sequence is created for the matched quantity and amounts.
Texts
If this check box is selected, texts exist.
General
Reference
Department
The department with which the billable line is associated.
Financial Department
If different from the sales office, the financial department.
Sales Representative
The sales representative dealing with the invoice.
Line of Business
The line of business of the business partner.
Area
The area of the business partner.
First Reference
A text used to identify the billable line.
Second Reference
An additional text used to identify the billable line.
Composing Reference
Technical field used for combining multiple lines.
Terms
Delivery Terms
The agreements with the business partner, concerning the way the goods are delivered. Relevant information is printed on various order documents.
Point of Title Passage
The point at which the legal ownership changes. At this point, the risk passes from the seller to the buyer.
Link to Monthly Billing Invoice
If this check box is selected, LN includes the invoice in a monthly billing invoice.

If the Send Monthly Billing Invoice check box in the Invoice-to Business Partners (tccom4112s000) session is selected, this check box is selected by default.

Self-Billing
If this check box is selected, self-billing applies.
Relations
Sold-to Business Partner
Usually a customer's purchase department, the business partner who orders goods or services from your organization, that owns the configurations you maintain, or for whom you perform a project.

The agreement with the sold-to business partner can include the following:

  • Default price and discount agreements
  • Sales order defaults
  • Delivery terms
  • The related ship-to and invoice-to business partner
Ship-to Business Partner
The business partner to which you ship the ordered goods. This usually represents a customer's distribution center or warehouse. The definition includes the default warehouse from which you send the goods, the carrier who carries out the transport, and the related sold-to business partner.
Invoice-to Business Partner
The business partner to which you send invoices. This usually represents a customer's accounts payable department. The definition includes the default currency and exchange rate, invoicing method and frequency, information about the customer's credit limit, the terms and method of payment, and the related pay-by business partner.
Pay-by Business Partner
The pay-by business partner of the invoice.
Address Details
Ship-from Address
The address from which goods are shipped.
Sold-to Address
The address of the sold-to business partner.
Ship-to Address
The address to which goods are shipped.
Invoice-to Address
The address to which the invoice is sent.

This is the address of the invoice-to business partner, or your own company's address.

Pay-by Address
The address of the pay-by business partner.
Order
Order
Order Date
The date and time when the order was entered.
Charge Type
The type of delivery covered by the billable line.

If the billable line refers to anything other than goods, service or costs, select Not Applicable.

Project
The project code.
Lot
A number of items produced and stored together that are identified by a (lot) code. Lots identify goods.
Serial Number
The unique identification of a single physical item. LN uses a mask to generate the serial number. The serial number can consist of multiple data segments that represent, for example, a date, model and color information, sequence number, and so on.

Serial numbers can be generated for items and for tools.

Customer Item Code
The item code that is used by the customer on the billable line.
Ordered Quantity
The total ordered quantity.
Order Unit
The unit for the ordered quantity.
Price
The item's order price.
Price Unit
The unit used for the order price.
Billable Amount
The line amount in the invoice currency.

Related topics

Invoice Currency
The currency in which the invoice amount is expressed.
Delivery
Delivery Date
The date on which the inventory is issued from the replenishment warehouse and transported to the destination warehouse.
Warehouse
The warehouse in which delivered goods are received.
Delivery Point
An address specification within a delivery address. For example, a warehouse dock location.

The supplier uses the delivery point in the shipment building process: the shipments are grouped by delivery point.

Shipment
All goods that are transported to a specific address on a specific date and time by using a specific route. An identifiable part of a load.
Shipment Line
An entity that provides information about one of the items listed on a shipment, such as the weight, the quantity, or the additional costs.
Packing Slip
An order document that shows in detail the contents of a particular package for shipment. The details include a description of the items, the shippers or customers item number, the quantity shipped, and the inventory unit of the shipped items.
Delivered Quantity
The total quantity of delivered items expressed in the items' inventory unit.
Delivery Unit
The unit in which the quantity is expressed.
Weight
If a delivery note is present, this is the weight of the load as stated on the delivery note. Otherwise, the weight of the shipment.
Weight Unit
The unit for the weight of the load as stated on the delivery note. Otherwise, the unit for the weight of the shipment.
Delivery Note
A transport document that provides information on a consignment contained in one truck (or other vehicle) and refers to an order or a set of orders for one consignee at a delivery address. If the truck load contains shipments for various business partners, the load includes more than one delivery note. The information on a delivery note includes the delivery date and address, the customer's name, the contents of the consignment, and so on. In Italy, a delivery note is a legally required document, where it used to be called BAM (Bolla Accompagnamento Merci). Currently it is called DDT (Documento di Trasporto). In Portugal and Spain delivery notes are also used, but there they do not have the same legal status as in Italy.
Carrier / LSP
An organization that provides transport services. You can link a default carrier to both ship-to and ship-from business partners. In addition, you can print sales and purchase orders on a packing list, sorted by carrier.

For ordering and invoicing, you must define a carrier as a business partner.

BO Details
Business Object Name
In the context of financial integration transaction processing, a business object is a logistic entity or event such as an item, a purchase order, a business partner, or a warehouse issue.
Business Object ID
The unique code that identifies a specific business object. For example, the business object ID of a Purchase Order business object is the purchase order number.
Business Object Reference
A transaction identification more detailed than the business object, for example, a receipt number or an order number. You can use the reference during reconciliation to match transactions if the business object alone does not provide enough information, for example, during GRNI reconciliation.
Note

The business object reference is not the same as a reference link.

Business Object GUID
The generated internal code of the business object.
Alternate BO Details
Business Object Name
In the context of financial integration transaction processing, a business object is a logistic entity or event such as an item, a purchase order, a business partner, or a warehouse issue.
Business Object ID
The unique code that identifies a specific business object. For example, the business object ID of a Purchase Order business object is the purchase order number.
Business Object Reference
A transaction identification more detailed than the business object, for example, a receipt number or an order number. You can use the reference during reconciliation to match transactions if the business object alone does not provide enough information, for example, during GRNI reconciliation.
Note

The business object reference is not the same as a reference link.

Invoice
Invoicing Data
Invoice Number
The financial company in which the invoice exists.
Transaction Type
The transaction type and series used to generate document numbers for the invoices.

The transaction category must be Sales Invoices.

LN generates the invoice document numbers when you print the original invoices. Until that moment, the invoicing data is identified in Invoicing by a temporary sequence number.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Transaction types and series.

Invoice Number
The sales invoice document number.
Kind of Order
The kind of order created for the billable line.

Allowed values

Kind of Order

Invoice Type
The kind of invoice. Each Operations Management package has its own types of invoices.
Invoicing Scenario
The invoicing scenario that was linked to the source type in the Invoicing Parameters by Source Type (cisli0101m000) session.
Invoiced Amount Variance
The difference between the self-billed invoice line amounts and the invoice amounts.
LPS Amount
The late-payment surcharge amount in the invoice currency.
Tax Amount
The invoice line tax amount in the invoice currency.
Cut Off Date
The cutoff date of the invoice line for the invoice composition process.
Approval Date
The date that the invoice was approved.
Invoicing Method
A set of parameters that defines, among other things, the types of orders and orders lines that can be combined on an invoice, and the type of invoice to be generated and the costs to be aggregated on Project invoices and Service invoices. You can define different invoicing methods for your invoice-to business partners.
Sales Invoice Company
The financial company in which the sales invoice was generated.
Sales Type
The sales type of the invoice.
Tax
Tax Classification
The tax classification of the invoice line.
Exempt
If this check box is selected, the logistic transaction is exempt from tax.
Tax Country
The country in which the tax must be paid and/or reported. The tax country can be different from the country where the goods are issued or delivered.
Own Tax Number
Your company's tax number.
Tax Code
A code that identifies the tax rate and which determines how LN calculates and registers tax amounts.
BP Tax Country
The country in which the business partner must pay tax.
BP Tax Number
Your business partner's tax number.
Tax Exemption Certificate Number
Tax Exemption Reason Code
A user-defined description that is based on a transaction and its type. Reason codes assist in selecting data for inquiry and for reporting.
ABC-Transaction
If this check box is selected, the invoice applies to trade of type Direct Delivery or External Material Delivery.
Payment
Payment Terms
Agreements about the way in which invoices are paid.

The payment terms include:

  • The period within which invoices must be paid.
  • The discount granted if an invoice is paid within a given period

The payment terms allow you to calculate:

  • The date on which the payment is due
  • The date on which the discount periods expire
  • The discount amount
Late Payment Surcharge
The percentage that is charged over the goods amount or over rendered services that the recipient of the invoice must pay if the invoice is not paid within a specified period.
Late Payment Surcharge Date
The date of the late payment surcharge that applies to the invoice.
Payment Method
The method used to create a payment (purchase invoice) or a receipt (sales invoice).

The payment method defines details such as:

  • The maximum amount
  • The due date
  • Allowance of foreign currencies and other details which must be printed on the report

These are default values that you can change on the order or on the invoice.

Bank Account Code
A record of debit and credit entries to cover transactions involving a particular item, person, or concern. The bank account is identified by a number.

LN can be set to check bank account numbers when you enter them. If the account number does not pass the check, LN displays a warning message.

Bank Account
A bank account of your company.
IBAN
International Bank Account Number. An international standard account identifier for identifying an account held by a financial institution, in order to facilitate automated processing of cross border transactions. The IBAN is provided by the bank/branch servicing the account.
Currency Rate
Rate Determiner
The method to decide which date is used to determine the exchange rates.

During the composing process, all amounts in foreign currencies are converted to the home currency, based on the determined exchange rate.

Exchange Rate Type
The exchange rate type that applies to the invoice.
Rate Date
The currency rates valid on this date apply to the invoice line.
Currency Rate Factor
The factor by which the amount in the transaction currency or the invoice currency is divided before LN converts it to a home currency. A rate factor is often used for currencies that have a relatively low price, for example, Korean Won.
Currency Rate
The factor by which an amount in a different currency is multiplied to calculate the amount in the currency base.
Rate
The currency exchange rate used to convert the invoice currency to the home currency.
Interest Invoice
Original Invoice Transaction Type
The transaction type part of the original invoice document number.
Original Invoice
The invoice number of the original invoice.
Original Invoice Line
The original invoice line.
Original Invoice Due Date
The due date of the original invoice.
Invoice Receipt Document Number
If the invoice was already paid or partially paid, this is the transaction type of the receipt for which the interest invoice is generated.
Document Number
If the invoice was already paid or partially paid, this is the document number of the receipt for which the interest invoice is generated.
Line Number
The line number of the receipt.
Invoice Receipt Date
If the invoice was already paid or partially paid, this is the receipt date.
Invoice Receipt Amount
If the invoice was already paid or partially paid, this is the receipt amount in the invoice currency.
Number of Days for Interest
The number of days over which interest is calculated.
Interest Percentage
The percentage used to calculate the interest.
Manual Sales
Manual Sales
Log Intrastat for Manual Sales
If this check box is selected, Intrastat data is logged for manual sales invoices.
Additional Statistical Info Set
Statistical import/export data that is not available as standard information in LN, but which is required on the sales listing or the Intrastat declaration by some of the EU member states.

You can add up to 15 data fields to the Intrastat statistical data by defining them as extra Intrastat information set. You can assign the extra Intrastat information sets to warehouse order lines.

Control Account
Dimension Types
One of up to twelve available analysis account bases for ledger accounts.
Header Dimensions
Analysis account for ledger accounts to get a vertical view on ledger accounts. Dimensions are used to specify ledger account information.
Dimension Types
One of up to twelve available analysis account bases for ledger accounts.
Posting
Asset Disposal
If this check box is selected, the invoice is related to the disposal of an asset.
Asset

Any informative description field used to refer to, for example:

  • The person or department with authorization to perform a specific task.
  • The business partner's contact.
  • The original invoice number.
GL Code
Represents a ledger account and the corresponding dimensions. GL codes are used to represent ledger accounts to users who are not familiar with the structure of the chart of accounts.

To specific logistic transactions, you can link a GL code. Such integration transactions are mapped directly to the ledger account and dimensions of the GL code, they are not included in the mapping process.

Ledger Account
The ledger account for the credit posting.
Dimension Types
One of up to twelve available analysis account bases for ledger accounts.
Dimensions
Analysis account for ledger accounts to get a vertical view on ledger accounts. Dimensions are used to specify ledger account information.
Dimension Types
One of up to twelve available analysis account bases for ledger accounts.
Contract
Contract
Deliverable
A contract deliverable is a tangible or intangible item that is produced or purchased as a result of a contract.
Schedule
The dates and quantities of an item that can be promised to a customer.

With this report you can determine how much volume can be delivered on time and how much is delivered late.

According to the item master plan, more chairs will be completed later that month. Some of those newly produced chairs have already been promised to other customers.

Example

A customer wants to order 80 office chairs, to be delivered on May 1. However, the CTP quantity on that day is only 30 chairs.

Program
A group of related projects managed in a coordinated way to obtain more benefits and control.
Element
The smallest part of an element structure. An element is used to define the (structure of the) work of the project, so that you can carry it out.
Activity
The smallest part of the activity structure used for a time-scaled budget. An entity that is used to represent a part of a project in an activity structure.

LN distinguishes these activity types:

  • WBS Element
  • Control Account
  • Work Package
  • Planning Package
  • Milestone
Extension
The specific agreements within or in addition to the initial contract. An extension falls outside the initial contract with the sold-to business partner. Extensions can be assigned to the bottom-up budget.

LN distinguishes four extension types:

  • Scope Change
  • Provisional Amount
  • Fluctuation Settlement
  • Quantities to be Settled
Project Line
The project line number.
Total Project Amount in Invoice Currency
The invoice amount.
Progress Date
The registration date for the forecast deviation of revenues.
Order Acceptance Address
The location where the goods are accepted.
Registration Date
The date when the cost transaction is registered.
Wage Part Amount
The percentage of the total contract amount which has been agreed upon with the main contractor that is formed by wage costs.

The amount to be transferred to the first blocked account is calculated with this percentage. This amount is transferred to the first blocked account maintained in Cash Management.

Note

The value displayed here originates from Project.

Blocked Amount
The amount to be transferred to the first blocked account maintained in Cash Management.

The base amount used to calculate the wage part amount:

base amount = (price * quantity) - discount amount - holdback amount

The wage part amount is calculated using this formula:

wage part amount = base amount * wage part of contract amount

The blocked amount is then calculated using this formula:

blocked amount = wage part amount * wage B-account percentage
Note

This field is only relevant in the Netherlands.

Revenue Code
A way to categorize invoiced amounts of the same invoice type in order to analyze revenue history.
Revenue Sequence Number
The number that identifies a data record or a step in a sequence of activities. Sequence numbers are used in many contexts. Usually LN generates the sequence number for the next item or step. Depending on the context, you can overwrite this number. You can sometimes influence the numbering by setting the corresponding parameters.
Installment
Installment Number
An incremental payment method used to spread invoice payments over a period of time. Installments enable you to send invoices for a sales order before or after the ordered goods are actually delivered.
Number of Points
The total number of points currently invoiced for the installment.
Percentage
The tax percentage that applies to the invoice line.
Final Installment
If this check box is selected, the installment is the final installment.
Advances Applicable
If this check box is selected, advance payments apply.
Holdback
Holdback Number
The number of the holdback linked to the invoice.
Holdback Percentage
The holdback amount expressed as a percentage.
Holdback Amount
The holdback amount.
Cost Object
Cost Object
Labor
The task covered by the billable line.
Equipment
The equipment code.
Subcontracting
The subcontracted work covered by the billable line.
Sundry Cost
The sundry costs covered by the billable line.
Overhead
The overhead covered by the billable line.
Amount of Time
The number of time units.
Time Unit
The unit that is used to specify the physical quantity time.
Sales / Warehouse
Sales / Warehouse
Sales Order Type
The sales order type of the sales order.
EDI or Print Invoice
Indicates whether the invoice was sent through electronic data interchange (EDI) or printed.
Product Variant
A unique configuration of a configurable item. The variant results from the configuration process and includes information such as feature options, components, and operations.
Example

Configurable item: electric drill

Options:

  • 3 power sources (batteries, 12 V or 220 V)
  • 2 colors (blue, gray).

A total of 6 product variants can be produced with these options.

Revision
The revision of a revision-controlled manufactured part.
Original Invoice Company
The company for which the billable line was created.
Kit Handling
If this check box is selected, a kit order applies.
Set Number
For a sales order, this number refers to the sales order set.

For an internal invoice, this number refers to the warehouse order set.

Conversion Factor Order Unit
The factor used to convert the quantity in order unit into the quantity in inventory unit.
Reference
Customer Order Number
The order number used by the customer.
Customer Order Line
The order line number used by the customer.
Customer Order Sequence
The order sequence number used by the customer.
Shipment
Identifies a group of items that are called off at the same time.
Installment
Invoicing by Installment
If this check box is selected, invoicing is done by installments.
Original Installment Line
The original installment line.
Self-Billing
Customer Invoice
The invoice number used by the customer.
Customer Invoice Date
The invoice date used by the customer.
Receive Invoice
If this check box is selected, self-billed invoices are electronically received and its data is automatically entered in the self-billed invoice tables.
Matched SBI Relations Code
A number that identifies a set of matched (customer) self-billed invoice lines with billable lines.
Self Billed Invoice Relation Status

One of the following:

  • Matched
  • Rejected
  • Approved
  • Processed
Original Delivered Quantity
The quantity that was originally delivered.
Discount
Totals
Order Discount Amount
The total of order line discount amount for the order.
Line Discount Amount
The total discount amount of the billable line.
Line Discount Specification
Discount Method
A code that indicates the way in which discounts are calculated if multiple discount levels are used.

Discounts are calculated according to one of the following amounts:

  • Gross: the discount is calculated over the gross amount
  • Net: the discount is calculated over the net amount. The net amount is calculated from the gross amount minus discounts at previous levels
Discount Percentage
The percentage that you can subtract from the gross sales price or purchase price.
Discount Amount
The discount given to a business partner, calculated by unit and expressed as a value. For instance, 3 euro.
Service
Service
Service Type
The service classification that service providers offer. The service type determines which availability type applies to a service order header, and provides a default order procedure and coverage type.
Service Contract
The code of the service contract.
Warranty Claim
If this check box is selected, LN includes the claim number in the invoice data along with other service order data.

The cost of goods sold amount for the service order is posted to the Financials.

Claim
The claim number. The value is defaulted from the Service.
Measurement Type
The code of the measurement type.
Measured Value
The item measurement value.
Print on Invoice
If this check box is selected, the invoice line is printed.
VAT Based on
For Service transactions, this field contains the type of delivery to which the invoice applies.
Location Address
The address code of the location where the service order activity must be performed.
Item Identification
Item
The item to be invoiced.
Header/Detail Installation Group
A set of serialized items that have the same location and are owned by the same business partner. Grouping serialized items into an Installation group enables you to maintain them collectively.
Serial Number
The serial number.
Serialized Item (Maintenance)
An item that is uniquely identified by the item code (manufacturer part number) in combination with the serial number.
Tool Number
A number to identify a tool. The combination of a tool type, for example, hammer, and a tool serial number, for example, 1, is unique, and identifies a tool in LN.
Labor
Service Task
The task covered by the billable line.
Times
Actual Start Time
The date and time when the service engineer starts working on the assigned activity.
Actual Finish Time
The date and time when the service engineer completes the assigned activity.
Service Contract
Installment Start Date
The start date of the installment period.
Installment End Date
The installment end date and time.
Number of Periods Financial Spreading
The number of financial periods across which you distribute the installment amounts.
Travel Costs
Travel Time Amount
The cost incurred for travel from the service center to location.
Note

The field is included in invoice data, along with the other service order data, if:

  • In the Invoices (cisli3105m000) session, Service Order Type is set to Service Order or Service Call.
  • The Consolidate Travel cost check box is selected in the Service Order Parameters (tssoc0100m000) session.
Travel Distance Amount
The cost incurred for travel from the service center to location.
Note

The field is included in invoice data, along with the other service order data, if:

  • In the Invoices (cisli3105m000) session, Service Order Type is set to Service Order or Service Call.
  • The Consolidate Travel cost check box is selected in the Service Order Parameters (tssoc0100m000) session.
Costs
Forecast Cost Amount
The estimated cost that will be incurred while servicing items. The amount is expressed in the home currency.
Debit/Credit Notes
Debit/Credit Notes
Type of Document

Either of the following:

  • Sales Invoice
  • Advance Receipt
Invoice
Original Schedule Number
The original schedule number.
Remittance
Remittance Code
The code used to identify the remittance advice.
Remittance Serial Number
The sequence number of the remittance advice.
Credit Analyst
One of your employees in charge of controlling and monitoring the credit that you give to an invoice-to business partner.
Invoice Discount
Invoice Discount Date
The date of the first invoice discount.
Invoice Discount Invoice Currency
The discount amount that applies to the first invoice.
Invoice Discount Date
The date of the second invoice discount.
Invoice Discount Invoice Currency
The discount amount that applies to the second invoice.
Invoice Discount Date
The date of the third invoice discount.
Invoice Discount Invoice Currency
The discount amount that applies to the third invoice.
Rebate
Amounts
Base Amount
The sales order amount on which the rebate is based.
Fixed Amount
If the rebate consists of a fixed amount, this is the rebate amount.
Percentage
Rebate Percentage
The percentage to be paid to a sold-to business partner as a kind of discount for closing a sales order.
Growing Percentage
If the rebate contains a growing percentage, this is the growth percentage.
Texts
Header Text
Descriptive text or comments attached to the header.
Additional Header Text
Additional text attached to the header.
Line Text
Text attached to the billable line.
Detail Text
Detail text attached to the billable line.
Service Item Text
Text attached to a service item.
Solution Text
Text attached to a solution.
Footer Text
Descriptive text or comments attached to the footer.
Conversion Factor Delivery Unit
The conversion factor applied to the delivery unit.
Conversion Factor Price Unit
The conversion factor applied to the price unit.
Amount in Local Currency
The invoice amount in the local currency.
Detail Description
A description of the invoice line.
Settlement Order
If this check box is selected, the invoice applies to an intercompany settlement transaction.
Packing Slip External
The number of an external packing slip.
Draft Guid
The generated internal code.
Additional Information
Invoice Delivery Method
A user-definable way to categorize invoices by their delivery method. LN prints invoices grouped by the invoice delivery method. Per invoice delivery method, LN sorts and prints the invoices within each ZIP/postal code by address.

You can select a default invoice delivery method for each invoice-to business partner.

Technical Reference
The project code.
Business Partner Status
Indicates the actions that can be carried out for the business partner. The status can be: Active, Inactive, or Potential.

For example, you cannot enter a sales order for a business partner with status Potential, or ship goods to a business partner with status Inactive.

Allowed values

Business Partner Status

Original Pay-by Business Partner
If the invoice is factored with recourse, this field contains the pay-by business partner that is linked to the invoice-to business partner of the invoice.

Related topics

Title
The title used on documents addressed to the business partner.
Additional Field
User-defined fields that can be linked to LN tables.

The contents of additional fields can be transferred between LN tables. Additional information fields are meaningless to LN as no functional logic is linked to the contents of these fields.

 

Transaction Origin
Starts the session corresponding to the source type.
COGS by Cost Component
Delivery Notes
Component Lines
Peg Distribution
Self-Billed Invoice Line Relations
Invoice
Displays the invoice details in the Invoices (cisli3605m000) session.
Write Off Self-Billed Invoice
Use this command to write off selected billable lines (sales schedule with Receive Invoice selected and status Confirmed).

For more information, refer to Self-billed invoice matching.