Share via

Sales Invoice Line Table

  • Article

Automatically creates a sales invoice that is shown in the Posted Sales Invoice window when you post a sales invoice.

The sales invoice is created when you click Actions, point to Post or Post and Print on a sales order, and then choose one of the following:

  • Ship

  • Invoice

  • Ship and Invoice

Important

If there is a check mark in the Shipment on Invoice check box in the Sales & Receivables Setup window, a shipment will also be created when you post an invoice.

A sales invoice consists of a sales invoice header and one or more sales invoice lines.

The sales invoice header contains all the relevant information about both the sell-to and bill-to customers such as name, address, document number, and date. The program copied the information from the sales header when it was posted.

Sales invoice lines contain information (such as item number, quantity and price) copied from the posted sales line.

You cannot change any of the fields on a sales invoice header or lines because the invoice has already been posted.

List of Fields in the Table

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
TCS Nature of Collection Field, Sales Invoice Line Table Income Tax
Amount Including Tax Field, Sales Invoice Line Table Sales Tax
Assessable Value Field, Sales Invoice Line Table Income Tax
State Field, Sales Invoice Line Table Sales Tax
Tax Base Amount Field, Sales Invoice Line Table Sales Tax
Amount Added to Tax Base Field, Sales Invoice Line Table Sales Tax
Service Tax Amount Field, Sales Invoice Line Table Service Tax
Service Tax Group Field, Sales Invoice Line Table Service Tax
SAED Amount Field, Sales Invoice Line Table Excise
Excise Accounting Type Field, Sales Invoice Line Table Excise
Abatement Percentage Field, Sales Invoice Line Table Excise
Service Tax eCess Amount Field, Sales Invoice Line Table Service Tax
VAT Type Field, Sales Invoice Line Table Service Tax
Capital Item Field, Sales Invoice Line Table Excise
Concessional Code Field, Sales Invoice Line Table Income Tax
Total TDS/TCS Incl. SHE CESS Field, Sales Invoice Line Table Excise
Form Code Field, Sales Invoice Line Table Sales Tax
TCS Type Field, Sales Invoice Line Table Income Tax
Per Contract Field, Sales Invoice Line Table Service Tax
Surcharge Base Amount Field, Sales Invoice Line Table Service Tax
TDS/TCS Amount Field, Sales Invoice Line Table Service Tax
Excise Prod. Posting Group Field, Sales Invoice Line Table Excise
MRP Price Field, Sales Invoice Line Table Excise
Form No. Field, Sales Invoice Line Table Sales Tax
Surcharge Percentage Field, Sales Invoice Line Table Income Tax
CVD Field, Sales Invoice Line Table Excise
Service Tax Registration No. Field, Sales Invoice Line Table Service Tax
Bal. TDS/TCS Including SHECESS Field, Sales Invoice Line Table Income Tax
Tax Percentage Field, Sales Invoice Line Table Sales Tax
Surcharge Amount Field, Sales Invoice Line Table Income Tax
ADC VAT Amount Field, Sales Invoice Line Table Excise
TDS/TCS Assessee Code Field, Sales Invoice Line Table Income Tax
CESS Amount Field, Sales Invoice Line Table Excise
eCESS on TDS/TCS Amount Field, Sales Invoice Line Table Service Tax
Service Tax SHE Cess Amount Field, Sales Invoice Line Table Service Tax
TDS/TCS Percentage Field, Sales Invoice Line Table Income Tax
NCCD Amount Field, Sales Invoice Line Table Excise
AED(GSI) Amount Field, Sales Invoice Line Table Excise
ADE Amount Field, Sales Invoice Line Table Excise
Excise Base Amount Field, Sales Invoice Line Table Excise
Service Tax Base Field, Sales Invoice Line Table Service Tax
Excise Amount Field, Sales Invoice Line Table Excise
eCESS Percentage on TDS/TCS Field, Sales Invoice Line Table Income Tax
eCess Amount Field, Sales Invoice Line Table Excise
TDS/TCS Base Amount Field, Sales Invoice Line Table Income Tax
Direct Debit to PLA/RG Field, Sales Invoice Line Table Excise
CIF Amount Field, Sales Invoice Line Table Excise
SHE Cess Percentage On TDS/TCS Field, Sales Invoice Line Table Excise
Tax Amount Field, Sales Invoice Line Table Income Tax
WHT Product Posting Group Field, Sales Invoice Line Table New Zealand Local Functionality
WHT Absorb Base Field, Sales Invoice Line Table New Zealand Local Functionality
SED Amount Field, Sales Invoice Line Table Excise
Price Inclusive Of Tax Field, Sales Invoice Line Table Excise
Free Supply Field, Sales Invoice Line Table Excise
Prepayment % Field, Sales Invoice Line Table New Zealand Local Functionality
Custom SHECess Amount Field, Sales Invoice Line Table Excise
S/T Exempt Field, Sales Invoice Line Table New Zealand Local Functionality
UPIT Rounding Inserted Field, Sales Invoice Line Table Excise
Excise Effective Rate Field, Sales Invoice Line Table Excise
Amount Added to Excise Base Field, Sales Invoice Line Table Excise
SHE Cess Amount Field, Sales Invoice Line Table Excise
Claim Deferred Excise Field, Sales Invoice Line Table Excise
Amount Including Excise Field, Sales Invoice Line Table Excise
WHT Business Posting Group Field, Sales Invoice Line Table New Zealand Local Functionality
SHE Cess On TDS/TCS Amount Field, Sales Invoice Line Table Excise
BCD Amount Field, Sales Invoice Line Table Excise
Amount To Customer UPIT Field, Sales Invoice Line Table Excise
Effective Rate Field, Sales Invoice Line Table Excise
Excise Bus. Posting Group Field, Sales Invoice Line Table Excise
MRP Field, Sales Invoice Line Table Excise
Unit Price Incl. Of Tax Field, Sales Invoice Line Table Excise
Package Tracking No. Field, Sales Invoice Line Table United States Local Functionality
BED Amount Field, Sales Invoice Line Table Excise
ADET Amount Field, Sales Invoice Line Table Excise
PIT Structure Field, Sales Invoice Line Table Excise
AED(TTA) Amount Field, Sales Invoice Line Table Excise
Reverse Charge Field, Sales Invoice Line Table United Kingdom Local Functionality
Reverse Charge Item Field, Sales Invoice Line Table United Kingdom Local Functionality
Excise Base Quantity Field, Sales Invoice Line Table Excise
Return Re-Dispatch Rcpt. No. Field, Sales Invoice Line Table India Local Functionality
Periodic Starting Date Field, Sales Invoice Line Table Sweden Local Functionality
Account Code Field, Sales Invoice Line Table Norway Local Functionality
Auto. Acc. Group Field, Sales Invoice Line Table Sweden Local Functionality
Periodic Template Code Field, Sales Invoice Line Table Sweden Local Functionality
Standard Deduction % Field, Sales Invoice Line Table India Local Functionality
VAT Code Field, Sales Invoice Line Table Norway Local Functionality
Source Document No. Field, Sales Invoice Line Table India Local Functionality
Amount To Customer Field, Sales Invoice Line Table India Local Functionality
Supplementary Field, Sales Invoice Line Table India Local Functionality
Standard Deduction Amount Field, Sales Invoice Line Table India Local Functionality
Return Rcpt line No. Field, Sales Invoice Line Table India Local Functionality
Charges To Customer Field, Sales Invoice Line Table India Local Functionality
Re-Dispatch Field, Sales Invoice Line Table India Local Functionality
Process Carried Out Field, Sales Invoice Line Table India Local Functionality
Qty. to be Re-Dispatched Field, Sales Invoice Line Table India Local Functionality
Identification Mark Field, Sales Invoice Line Table India Local Functionality
Source Document Type Field, Sales Invoice Line Table India Local Functionality
EC Difference Field, Sales Invoice Line Table Spain Local Functionality
Allow Invoice Disc. Field, Sales Invoice Line Table Sales and Receivables
Tax Area Code Field, Sales Invoice Line Table Sales and Receivables
Quantity Field, Sales Invoice Line Table Sales and Receivables
Tax Group Code Field, Sales Invoice Line Table Sales and Receivables
IC Partner Ref. Type Field, Sales Invoice Line Table Sales and Receivables
Units per Parcel Field, Sales Invoice Line Table Sales and Receivables
Variant Code Field, Sales Invoice Line Table Sales and Receivables
Qty. per Unit of Measure Field, Sales Invoice Line Table Sales and Receivables
Unit of Measure Field, Sales Invoice Line Table Sales and Receivables
Amount Including VAT Field, Sales Invoice Line Table Sales and Receivables
IC Partner Code Field, Sales Invoice Line Table Sales and Receivables
Location Code Field, Sales Invoice Line Table Sales and Receivables
Shipment Line No. Field, Sales Invoice Line Table Sales and Receivables
Posting Date Field, Sales Invoice Line Table Sales and Receivables
Return Reason Code Field, Sales Invoice Line Table Sales and Receivables
IC Partner Reference Field, Sales Invoice Line Table Sales and Receivables
Cross-Reference No. Field, Sales Invoice Line Table Sales and Receivables
Bill-to Customer No. Field, Sales Invoice Line Table Sales and Receivables
Customer Price Group Field, Sales Invoice Line Table Sales and Receivables
VAT Calculation Type Field, Sales Invoice Line Table Sales and Receivables
Quantity (Base) Field, Sales Invoice Line Table Sales and Receivables
Purchasing Code Field, Sales Invoice Line Table Sales and Receivables
Type Field, Sales Invoice Line Table Sales and Receivables
VAT Bus. Posting Group Field, Sales Invoice Line Table Sales and Receivables
Transaction Specification Field, Sales Invoice Line Table Sales and Receivables
Item Category Code Field, Sales Invoice Line Table Sales and Receivables
Cross-Reference Type Field, Sales Invoice Line Table Sales and Receivables
Net Weight Field, Sales Invoice Line Table Sales and Receivables
Blanket Order No. Field, Sales Invoice Line Table Sales and Receivables
Gen. Bus. Posting Group Field, Sales Invoice Line Table Sales and Receivables
Job Task No. Field, Sales Invoice Line Table Sales and Receivables
Description 2 Field, Sales Invoice Line Table Sales and Receivables
VAT Difference Field, Sales Invoice Line Table Sales and Receivables
Depr. until FA Posting Date Field, Sales Invoice Line Table Sales and Receivables
Unit Volume Field, Sales Invoice Line Table Sales and Receivables
Product Group Code Field, Sales Invoice Line Table Sales and Receivables
Area Field, Sales Invoice Line Table Sales and Receivables
Posting Group Field, Sales Invoice Line Table Sales and Receivables
Work Type Code Field, Sales Invoice Line Table Sales and Receivables
No. Field, Sales Invoice Line Table Sales and Receivables
VAT Base Amount Field, Sales Invoice Line Table Sales and Receivables
Blanket Order Line No. Field, Sales Invoice Line Table Sales and Receivables
Shortcut Dimension 2 Code Field, Sales Invoice Line Table Sales and Receivables
Appl.-from Item Entry Field, Sales Invoice Line Table Sales and Receivables
Line Amount Field, Sales Invoice Line Table Sales and Receivables
Tax Liable Field, Sales Invoice Line Table Sales and Receivables
Shipment Date Field, Sales Invoice Line Table Sales and Receivables
Gross Weight Field, Sales Invoice Line Table Sales and Receivables
Inv. Discount Amount Field, Sales Invoice Line Table Sales and Receivables
Job No. Field, Sales Invoice Line Table Sales and Receivables
Transport Method Field, Sales Invoice Line Table Sales and Receivables
Amount Field, Sales Invoice Line Table Sales and Receivables
Exit Point Field, Sales Invoice Line Table Sales and Receivables
Line No. Field, Sales Invoice Line Table Sales and Receivables
Cross-Reference Type No. Field, Sales Invoice Line Table Sales and Receivables
Gen. Prod. Posting Group Field, Sales Invoice Line Table Sales and Receivables
Drop Shipment Field, Sales Invoice Line Table Sales and Receivables
Unit Price Field, Sales Invoice Line Table Sales and Receivables
Transaction Type Field, Sales Invoice Line Table Sales and Receivables
Unit Cost Field, Sales Invoice Line Table Sales and Receivables
FA Posting Date Field, Sales Invoice Line Table Sales and Receivables
Document No. Field, Sales Invoice Line Table Sales and Receivables
Dimension Set ID Field, Sales Invoice Line Table Sales and Receivables
Customer Disc. Group Field, Sales Invoice Line Table Sales and Receivables
Bin Code Field, Sales Invoice Line Table Sales and Receivables
Duplicate in Depreciation Book Field, Sales Invoice Line Table Sales and Receivables
Shipment No. Field, Sales Invoice Line Table Sales and Receivables
Allow Line Disc. Field, Sales Invoice Line Table Sales and Receivables
VAT % Field, Sales Invoice Line Table Sales and Receivables
Unit of Measure (Cross Ref.) Field, Sales Invoice Line Table Sales and Receivables
System-Created Entry Field, Sales Invoice Line Table Sales and Receivables
Nonstock Field, Sales Invoice Line Table Sales and Receivables
Shortcut Dimension 1 Code Field, Sales Invoice Line Table Sales and Receivables
Unit Cost (LCY) Field, Sales Invoice Line Table Sales and Receivables
Line Discount % Field, Sales Invoice Line Table Sales and Receivables
Sell-to Customer No. Field, Sales Invoice Line Table Sales and Receivables
Responsibility Center Field, Sales Invoice Line Table Sales and Receivables
Description Field, Sales Invoice Line Table Sales and Receivables
VAT Prod. Posting Group Field, Sales Invoice Line Table Sales and Receivables
Prepayment Line Field, Sales Invoice Line Table Sales and Receivables
Line Discount Amount Field, Sales Invoice Line Table Sales and Receivables
Use Duplication List Field, Sales Invoice Line Table Sales and Receivables
Unit of Measure Code Field, Sales Invoice Line Table Sales and Receivables
Job Contract Entry No. Field, Sales Invoice Line Table Sales and Receivables
Appl.-to Item Entry Field, Sales Invoice Line Table Sales and Receivables
Depreciation Book Code Field, Sales Invoice Line Table Sales and Receivables
VAT Identifier Field, Sales Invoice Line Table Sales and Receivables
Attached to Line No. Field, Sales Invoice Line Table Sales and Receivables
VAT Clause Code Field, Sales Invoice Line Table General Ledger
Account Code Field, Sales Invoice Line Table Denmark Local Functionality
Subtotal gross Field, Sales Invoice Line Table Switzerland Local Functionality
Classification Field, Sales Invoice Line Table Switzerland Local Functionality
Subtotal net Field, Sales Invoice Line Table Switzerland Local Functionality
Position Field, Sales Invoice Line Table Switzerland Local Functionality
Quote-Level Field, Sales Invoice Line Table Switzerland Local Functionality
Service Tariff No. Field, Sales Invoice Line Table Italy Local Functionality
Order No. Field, Sales Invoice Line Table Switzerland Local Functionality
Deductible % Field, Sales Invoice Line Table Italy Local Functionality
Title No. Field, Sales Invoice Line Table Switzerland Local Functionality
Order Line No. Field, Sales Invoice Line Table Switzerland Local Functionality
Pmt. Disc. Given Amount Field, Sales Invoice Line Table Spain Local Functionality
EC % Field, Sales Invoice Line Table Spain Local Functionality
Include in VAT Transac. Rep. Field, Sales Invoice Line Table Italy Local Functionality

See Also

Reference

Sales Invoice