The financial company in which the invoice exists.
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
Invoice Status Invoicing 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 The raw materials, subassemblies, finished products, and tools that can be purchased, stored, manufactured, and sold. An item can also represent a set of items handled as one kit, or which exist in multiple product variants. You can also define nonphysical items, which are not retained in inventory but can be used to post costs or to invoice services to customers. The examples of nonphysical items:
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. Intercompany Trade Scenario A business process, such as External Material Delivery Sales, involving two parts of an organization defined as entities. An intercompany trade scenario is linked to an intercompany trade agreement. The intercompany trade scenario and the intercompany trade agreement are linked to an intercompany trade relationship. Example The entities sales office S1 and warehouse W1 are part of organization A, but they are located in different countries. To fulfill a sales order to an external customer, S1 instructs W1 to deliver the goods to the customer. W1 sends an internal invoice to S1 to cover the costs for the goods and the delivery. The amount of the internal invoice is based on the sales order price. 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 The weight of the load as stated on the delivery note. The value in this field is populated only if a delivery note is present. 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. Amounts Invoice Currency Net Line Amount The line amount in the invoice currency. Taxable 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 Third Invoice Discount Shifted Tax Amount in Home Currency The shifted tax amount for the sales tax, expressed in the home currency. Shifted Tax Amount The shifted tax amount for the sales tax, expressed in the invoice currency. Home Currency Amount in The invoice amount in the home currency. Taxable 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. 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 The business partner who orders goods or services from your organization, who owns the configurations you maintain, or for whom you perform a project. Usually a customer's purchase department. The agreement with the sold-to business partner can include:
Sold-to Address The address of the sold-to business partner. Ship-to Business Partner The business partner to whom 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 of the original invoice used to calculate interest. 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. Schedule Line If a payment schedule is attached to the invoice, this is the schedule line number for which the interest invoice was generated. Note If no payment schedule is attached to the invoice, LN sets this field to 100. If no more interest invoices related to the invoice will be generated, LN creates a record with the sum total of the interest invoices and for this record, LN sets the schedule line number to zero. 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 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 Any informative description field used to refer to, for example:
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:
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:
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 assigned to the order or contract by the sold-to business partner (for example, the sold-to business partner's purchase contract number). The customer order number can be used to identify a sales contract line. 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:
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 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 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. 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:
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:
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 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: 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:
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 serial number. 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 time-based 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:
Travel Distance Amount The distance-based 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:
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 Any informative description field used to refer to, for example:
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 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 A user-defined description that is based on a transaction and its type. Reason codes assist in selecting data for inquiry and for reporting. 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. 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 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. Delivery Unit The unit in which the quantity is expressed. Ordered Quantity The total ordered quantity. Weight The weight of the load as stated on the delivery note. The value in this field is populated only if a delivery note is present. 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 assigned to the order or contract by the sold-to business partner (for example, the sold-to business partner's purchase contract number). The customer order number can be used to identify a sales contract line. Additional Field User-defined fields of various field formats that can be added to various sessions, in which users can edit these fields. No functional logic is linked to the contents of these fields. Additional information fields can be linked to database tables. When linked to a table, the fields are displayed in the sessions corresponding to the database tables. For example, a field defined for the whinh200 table is displayed as an extra field in the Warehousing Orders (whinh2100m000) session. The contents of additional fields can be transferred between database tables. For example, the information specified by a user in additional information field A of the Warehousing Orders (whinh2100m000) session is transferred to additional information field A in the Shipments (whinh4130m000) session. For this purpose, additional information fields with identical field formats and field name A must be present for the whinh200 and the whinh430 tables (whinh430 corresponds to the Shipments (whinh4130m000) session). 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
Aggregation Sequence Lines that share the same sequence number are printed as a single line on the invoice. Kind of Order Header Description Invoice Line Type The invoicing scenario that was linked to the source type in the Invoicing Transaction Types (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.
| |||