| # Invoice Lines (cisli3110m000) Use this session to view invoice lines and their details. Invoice Number The financial company in which the invoice exists. / 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. / The sales invoice document number. Invoice Date The date and time when the invoice was created. Note If the status of the line is Ready to Print, you can change the invoice date to the current date or to another date in the past, as required. If material pricing data exists, you cannot change the invoice date. Invoice Status Line The invoice line number. Source Company The source company. Source Type The source document type. Order Number The source document number. Order Line The line number of the order data. Source Document The source company. Order Order Item Description The item description. Line Description A description of the invoice line. 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. First Reference A text used to identify the invoice. Second Reference An additional text used to identify the invoice. Delivery 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. / An entity that provides information about one of the items listed on a shipment, such as the weight, the quantity, or the additional costs. Delivered Quantity 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. The unit in which the weight is expressed. 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. Business Object 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. 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 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 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. Amounts Invoice Currency Net Line Amount The line amount in the invoice currency. Tax Base Amount The net order amount or the net invoice amount in the invoice currency. LPS Amount Line Discount Amount The total discount amount of the invoice line. Order Discount Amount The total of order line discount amount for the order. Customs Value The total value of all items in your shipment which determines the amount of import duty and other taxes. First Invoice Discount The discount amount that applies to the first invoice. Second Invoice Discount The discount amount that applies to the first invoice. Third Invoice Discount Home Currency Amount in The invoice amount in the home currency. Tax Base Amount in The net order amount or the net invoice amount in the home currency. LPS Amount in Line Discount Amount in The discount amount in the home currency. Order Discount Amount in The total discount amount of the order in the home currency. Customs Value in Home Currency The total value of all items in your shipment which determines the amount of import duty and other taxes. First Discount Amount in Second Discount Amount in The discount amount that applies to the second invoice expressed in the home currency. Third Discount Amount in The discount amount that applies to the third invoice expressed in the home currency. Dates LPS Date First Invoice Discount Date The date of the first invoice discount. Second Invoice Discount Date Third Invoice Discount Date Exchange Rate Rate Rate Factor Rate Date The currency rates valid on this date apply to the invoice line. Exchange Rate Type Variable Composing Criteria Tax Code A code that identifies the tax rate and which determines how LN calculates and registers tax amounts. Business Partner Tax Country The business partner's tax country. ABC Transaction If this check box is selected, the invoice applies to trade of type Direct Delivery or External Material Delivery. Department The department with which the invoice line is associated. Sales Representative The sales representative dealing with the invoice. Manual Sales Invoice Line of Business The line of business of the business partner. Area The area of the business partner. 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. 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 Sold-to Address The address of the sold-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. Ship-to Address The address of the ship-to business partner. Interest Invoice Original Invoice The transaction type part of the original invoice document number. The document number of the original invoice. Original Invoice Line The line number of the original invoice. 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. Invoice Receipt Line 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. Related topics Interest calculation on overdue invoices Schedule Line If a payment schedule is attached to the invoice, this is the schedule line number for which the interest invoice was generated. If no payment schedule is attached to the invoice, sets this field to 100. If no more interest invoices related to the invoice will be generated, creates a record with the sum total of the interest invoices and for this record, sets the schedule line number to zero. Number of Days for Interest The number of days over which interest is calculated. Related topics Interest calculation on overdue invoices Interest Percentage The percentage used to calculate the interest. Related topics Interest calculation on overdue invoices Manual Sales Manual Sales Operational Company The company to which a department, warehouse, or project belongs. In most cases, this is the logistic company in which the department, warehouse, or project was created. Logistic transactions originating from a department, warehouse, or project can only be created in their operational company. Gross Amount The total amount from which taxes, rebates, discounts, and so on are to be deducted to reach the net amount. The gross amount is calculated by multiplying the order quantity with the (book) price. Log Intrastat If this check box is selected, Intrastat data is logged for manual sales invoices. Add. 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. 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. Posting Reference 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. 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. 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. 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. 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. Customer Order The number the sold-to business partner assigned to the order. In the automotive industry, it can represent the sold-to business partner's purchase contract number. Amount of Time The number of time units. The unit that is used to specify the physical quantity time. Invoice-to Contact The contact for the invoice-to business partner. Contract Award Date The date when the contract line was awarded. Contract Item The item to be invoiced. Customer Item Code The item code that is used by the customer on the billable line. 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. Task A specification of the type of work that is carried out by a service employee. You can use tasks to specify the labor required to carry out an activity. A specific labor rate can be linked to a task. Equipment The equipment code. Subcontracting The subcontracted work covered by the invoice line. Sundry Cost The sundry costs covered by the invoice line. Overhead The overhead costs covered by the invoice line. Progress Date The registration date for the forecast deviation of revenues. Fee Type 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. No. of Points The total number of points currently invoiced for the installment. Percentage The tax percentage that applies to the invoice line. Holdback Holdback Number The holdback number. Hold Back Percentage The holdback amount expressed as a percentage. Holdback Amount The holdback amount. Revenue 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. Sales / Warehouse Sales / Warehouse Warehouse The warehouse from which the goods were shipped. 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. 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. Kit Handling If this check box is selected, a kit order applies. 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 invoice line was created. Original Invoice Transaction Type The transaction type part of the original invoice document number. Original Invoice The invoice number of the original invoice. Reference Customer Item Code The item code used by the customer. Header Customer Order 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. 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. Packing Slip External The number of an external packing slip. Shipment Reference Identifies a group of items that are called off at the same time. Installment Advances Applicable If this check box is selected, advance payments apply. Invoicing by Installment If this check box is selected, invoicing is done by installments. Revenue Recognition at Installments (Sales) If this check box is selected, LN takes installment invoice amounts into account for revenue recognition. Note When selected, for Normal and Guarantee installments, the following applies: The Sales Order / Revenue Analysis integration document is used instead of the Sales Order / Normal Installment and Sales Order / Settled Guarantee Installment documents. When sales order lines are invoiced, no currency difference postings are created for the reversal of installments. Original Installment Line The original installment line. Self-Billing SBI Correction If this check box is selected, a correction applies to the amount of a self-billed invoice. Matched SBI Relations Code A number that identifies a set of matched (customer) self-billed invoice lines with billable lines. Invoiced Amount Variance The correction amount in case the self-billed invoice exceeds or falls short of the original amount. Invoiced Amount Variance The amount variance in the home currency. One of a company's base currencies in which LN registers and reports amounts. In a multicurrency system, up to three home currencies can be defined: The local currency Two reporting currencies Conversion Factor Conv. Factor Price Unit The conversion factor applied to the price unit. Conv. Factor Quantity Unit The factor used to convert the quantity in order unit into the quantity in inventory unit. Conv. Factor Delivery Unit The conversion factor applied to the delivery unit. Discount 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 Location Address The location address where the service is performed. Task The task to which the invoice refers. 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 Financials. Claim The claim number. The value is defaulted from Service. Reference Activity The smallest unit of work that is required to carry out maintenance. Master Routing A set of operations that can be carried out. The reference activities based on which operations are added to a master routing, must have the same characteristics, such as item, functional element, and service department. Example All the inspections, tests, cleaning activities, assembly activities, disassembly activities, and repair activities that you can carry out on an engine. Routing Option A subset of master routing. A predefined set of operations that can be carried out. Each operation is identified by a unique sequence number. Print on Invoice If this check box is selected, the installation group is printed on the invoice. VAT Based on For Service transactions, this field contains the type of delivery to which the invoice applies. Item Identification Item If the invoice concerns a serialized item, this is the item code. Serial Number If the invoice concerns a serialized item, this is the item code. Serial Number The serial number of the item. Installation Group The installation group to which the invoice refers. 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. Costs Costs The cost amount. Quotation Costs Costs incurred for quotation. Forecast Cost Amount The forecast cost amount in the invoice currency. Note This field is used for posting costs to Financials. Forecast Cost Amount The forecast cost amount in the home currency. 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 Travel Total Line for Distance and Time 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 Travel Total Line for Distance and Time check box is selected in the Service Order Parameters (tssoc0100m000) session. Service Contract Installment Start Date The start date of the installment period. Installment End Date The installment end date and time. Discount Percentage The percentage that you can subtract from the gross sales price or purchase price. Conversion Factor Conv. Factor Price Unit The factor used to convert the price unit. Conv. Factor Price Unit The factor used to convert the quantity in order unit into the quantity in inventory unit. Freight Freight Original Order Reference Debit/Credit Notes Debit/Credit Notes Type of Document The transaction type of the original invoice. 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. Tax Code A code that identifies the tax rate and which determines how LN calculates and registers tax amounts. BP Tax Country The business partner's tax country. Tax Amount The tax amount in the invoice currency. The currency in which the invoice amount is expressed. Tax Amount in Home Currency The invoice line tax amount in the home currency. Original Invoice Original Invoice Transaction Type The transaction type part of the original invoice document number. Original Invoice The line number on the invoice. Original Schedule No The original schedule number. Remittance Remittance Code The remittance advice code. Serial Number The sequence number of the remittance advice. Credit Analyst The credit analyst. 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 If the rebate consists of a percentage, this is the rebate percentage. 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 invoice line. Detail Text Detail text attached to the invoice line. Item Text Solution Text Text attached to a solution. Footer Text Descriptive text or comments attached to the footer. Initial Hidden 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. Segments The dimensions used for segment reporting. Ordered Quantity The total ordered quantity. The unit in which the quantity is expressed. Ordered Quantity The total ordered quantity. 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. The unit for the weight of the load as stated on the delivery note. Otherwise, the unit for the weight of the shipment. Original Invoice Line Number The original invoice line. Remittance Advice Raised Company The company used to process and post the remittance advices. Project The project code. Customer Order The number the sold-to business partner assigned to the order. In the automotive industry, it can represent the sold-to business partner's purchase contract number. 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. Tax Amount The invoice line tax amount in the invoice currency. 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. Aggregation Sequence Lines that share the same sequence number are printed as a single line on the invoice. Kind of Order The kind of order created for the billable line. Allowed values Kind of Order Header Description Invoice Type The invoicing scenario that was linked to the source type in the Invoicing Parameters by Source Type (cisli0101m000) session. Sales Order Type The order type, which determines the sessions that are part of the order procedure and how and in which sequence this procedure is executed. Tax Country The tax country of the invoice line. Project The project code. Charge Type The type of delivery covered by the invoice line. If the invoice refers to anything other than goods, service or costs, select Not Applicable. |