Share via

Sales Invoice Header 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 clicked 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 check box next to the Shipment on Invoice field in Sales & Receivables Setup, 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 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 prices) copies 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

Field Location
Form Code Field, Sales Invoice Header Table Sales Tax
Activity Code Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Place of Birth Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
PLA Entry No. Field, Sales Invoice Header Table Excise
Service Tax Rounding Type Field, Sales Invoice Header Table Service Tax
Fiscal Code Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Vehicle No. Field, Sales Invoice Header Table Excise
Form No. Field, Sales Invoice Header Table Sales Tax
Transaction No. Serv. Tax Field, Sales Invoice Header Table Service Tax
State Field, Sales Invoice Header Table Sales Tax
VAT Exempted Field, Sales Invoice Header Table Service Tax
Transit Document Field, Sales Invoice Header Table Sales Tax
Last Name Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Resident Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Free Supply Field, Sales Invoice Header Table Sales Tax
Operation Occurred Date Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
LC No. Field, Sales Invoice Header Table Sales Tax
Export or Deemed Export Field, Sales Invoice Header Table Service Tax
First Name Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Nature of Services Field, Sales Invoice Header Table Service Tax
Excise Bus. Posting Group Field, Sales Invoice Header Table Excise
Mode of Transport Field, Sales Invoice Header Table Excise
Service Tax Rounding Precision Field, Sales Invoice Header Table Service Tax
ST Pure Agent Field, Sales Invoice Header Table Service Tax
Type of Supply Code Field, Sales Invoice Header Table United Kingdom Local Functionality
Time of Removal Field, Sales Invoice Header Table Excise
Pay-at Code Field, Sales Invoice Header Table Spain Local Functionality
Date of Birth Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
RG 23 A Entry No. Field, Sales Invoice Header Table Excise
Amount to Customer Field, Sales Invoice Header Table India Local Functionality
Cust. Bank Acc. Code Field, Sales Invoice Header Table Spain Local Functionality
Price Inclusive of Taxes Field, Sales Invoice Header Table Excise
Return Re-Dispatch Rcpt. No. Field, Sales Invoice Header Table India Local Functionality
Calc. Inv. Discount (%) Field, Sales Invoice Header Table Excise
Refers to Period Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Operation Type Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Cumulative Bank Receipts Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Bank Account Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Applies-to Bill No. Field, Sales Invoice Header Table Spain Local Functionality
RG 23 C Entry No. Field, Sales Invoice Header Table Excise
Individual Person Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Service Tariff No. Field, Sales Invoice Header Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Bill to Customer State Field, Sales Invoice Header Table India Local Functionality
LR/RR No. Field, Sales Invoice Header Table Excise
Trading Field, Sales Invoice Header Table India Local Functionality
LR/RR Date Field, Sales Invoice Header Table Excise
Re-Dispatch Field, Sales Invoice Header Table India Local Functionality
PoT Field, Sales Invoice Header Table India Local Functionality
Structure Field, Sales Invoice Header Table India Local Functionality
Enterprise No. Field, Sales Invoice Header Table Belgium Local Functionality
Reference No. Field, Sales Invoice Header Table Finland Local Functionality
Bank Account Field, Sales Invoice Header Table Netherlands Local Functionality
Transaction Mode Field, Sales Invoice Header Table Netherlands Local Functionality
Amount Field, Sales Invoice Header Table Sales and Receivables
Sell-to Customer Name Field, Sales Invoice Header Table Sales and Receivables
Bill-to Contact No. Field, Sales Invoice Header Table Sales and Receivables
Bill-to Country/Region Code Field, Sales Invoice Header Table Sales and Receivables
Order No. Field, Sales Invoice Header Table Sales and Receivables
Comment Field, Sales Invoice Header Table Sales and Receivables
Bal. Account Type Field, Sales Invoice Header Table Sales and Receivables
Quote No. Field, Sales Invoice Header Table Sales and Receivables
Credit Card No. Field, Sales Invoice Header Table Sales and Receivables
Ship-to City Field, Sales Invoice Header Table Sales and Receivables
Ship-to Name Field, Sales Invoice Header Table Sales and Receivables
Your Reference Field, Sales Invoice Header Table Sales and Receivables
Correction Field, Sales Invoice Header Table Sales and Receivables
Ship-to Country/Region Code Field, Sales Invoice Header Table Sales and Receivables
Order No. Series Field, Sales Invoice Header Table Sales and Receivables
Prepayment Order No. Field, Sales Invoice Header Table Sales and Receivables
User ID Field, Sales Invoice Header Table Sales and Receivables
Salesperson Code Field, Sales Invoice Header Table Sales and Receivables
Allow Line Disc. Field, Sales Invoice Header Table Sales and Receivables
Applies-to Doc. No. Field, Sales Invoice Header Table Sales and Receivables
Transaction Specification Field, Sales Invoice Header Table Sales and Receivables
Ship-to Name 2 Field, Sales Invoice Header Table Sales and Receivables
Payment Method Code Field, Sales Invoice Header Table Sales and Receivables
Language Code Field, Sales Invoice Header Table Sales and Receivables
Shipping Agent Code Field, Sales Invoice Header Table Sales and Receivables
Transport Method Field, Sales Invoice Header Table Sales and Receivables
Ship-to Contact Field, Sales Invoice Header Table Sales and Receivables
Currency Factor Field, Sales Invoice Header Table Sales and Receivables
Prepayment No. Series Field, Sales Invoice Header Table Sales and Receivables
Sell-to Contact No. Field, Sales Invoice Header Table Sales and Receivables
Applies-to Doc. Type Field, Sales Invoice Header Table Sales and Receivables
Bill-to Contact Field, Sales Invoice Header Table Sales and Receivables
On Hold Field, Sales Invoice Header Table Sales and Receivables
Sell-to Customer Name 2 Field, Sales Invoice Header Table Sales and Receivables
No. Field, Sales Invoice Header Table Sales and Receivables
Sell-to Address 2 Field, Sales Invoice Header Table Sales and Receivables
Package Tracking No. Field, Sales Invoice Header Table Sales and Receivables
Pre-Assigned No. Series Field, Sales Invoice Header Table Sales and Receivables
Bill-to City Field, Sales Invoice Header Table Sales and Receivables
Sell-to Country/Region Code Field, Sales Invoice Header Table Sales and Receivables
Payment Terms Code Field, Sales Invoice Header Table Sales and Receivables
Sell-to Post Code Field, Sales Invoice Header Table Sales and Receivables
EU 3-Party Trade Field, Sales Invoice Header Table Sales and Receivables
Bill-to Address Field, Sales Invoice Header Table Sales and Receivables
Bill-to County Field, Sales Invoice Header Table Sales and Receivables
Tax Area Code Field, Sales Invoice Header Table Sales and Receivables
Area Field, Sales Invoice Header Table Sales and Receivables
Ship-to County Field, Sales Invoice Header Table Sales and Receivables
Amount Including VAT Field, Sales Invoice Header Table Sales and Receivables
Customer Disc. Group Field, Sales Invoice Header Table Sales and Receivables
Sell-to Customer No. Field, Sales Invoice Header Table Sales and Receivables
Ship-to Address Field, Sales Invoice Header Table Sales and Receivables
Exit Point Field, Sales Invoice Header Table Sales and Receivables
Bill-to Name Field, Sales Invoice Header Table Sales and Receivables
Sell-to County Field, Sales Invoice Header Table Sales and Receivables
Tax Liable Field, Sales Invoice Header Table Sales and Receivables
Shipment Date Field, Sales Invoice Header Table Sales and Receivables
Gen. Bus. Posting Group Field, Sales Invoice Header Table Sales and Receivables
Document Date Field, Sales Invoice Header Table Sales and Receivables
VAT Country/Region Code Field, Sales Invoice Header Table Sales and Receivables
Campaign No. Field, Sales Invoice Header Table Sales and Receivables
Location Code Field, Sales Invoice Header Table Sales and Receivables
Sell-to City Field, Sales Invoice Header Table Sales and Receivables
Shortcut Dimension 1 Code Field, Sales Invoice Header Table Sales and Receivables
Ship-to Code Field, Sales Invoice Header Table Sales and Receivables
Posting Description Field, Sales Invoice Header Table Sales and Receivables
Transaction Type Field, Sales Invoice Header Table Sales and Receivables
Order Date Field, Sales Invoice Header Table Sales and Receivables
VAT Registration No. Field, Sales Invoice Header Table Sales and Receivables
VAT Base Discount % Field, Sales Invoice Header Table Sales and Receivables
Shipment Method Code Field, Sales Invoice Header Table Sales and Receivables
No. Printed Field, Sales Invoice Header Table Sales and Receivables
Posting Date Field, Sales Invoice Header Table Sales and Receivables
Bill-to Name 2 Field, Sales Invoice Header Table Sales and Receivables
Customer Price Group Field, Sales Invoice Header Table Sales and Receivables
Payment Discount % Field, Sales Invoice Header Table Sales and Receivables
Due Date Field, Sales Invoice Header Table Sales and Receivables
Customer Posting Group Field, Sales Invoice Header Table Sales and Receivables
Responsibility Center Field, Sales Invoice Header Table Sales and Receivables
Prepayment Invoice Field, Sales Invoice Header Table Sales and Receivables
Sell-to Address Field, Sales Invoice Header Table Sales and Receivables
VAT Bus. Posting Group Field, Sales Invoice Header Table Sales and Receivables
Invoice Disc. Code Field, Sales Invoice Header Table Sales and Receivables
Source Code Field, Sales Invoice Header Table Sales and Receivables
Shortcut Dimension 2 Code Field, Sales Invoice Header Table Sales and Receivables
Bill-to Customer No. Field, Sales Invoice Header Table Sales and Receivables
Ship-to Address 2 Field, Sales Invoice Header Table Sales and Receivables
Reason Code Field, Sales Invoice Header Table Sales and Receivables
Bill-to Post Code Field, Sales Invoice Header Table Sales and Receivables
Bill-to Address 2 Field, Sales Invoice Header Table Sales and Receivables
Prices Including VAT Field, Sales Invoice Header Table Sales and Receivables
Currency Code Field, Sales Invoice Header Table Sales and Receivables
No. Series Field, Sales Invoice Header Table Sales and Receivables
Get Shipment Used Field, Sales Invoice Header Table Sales and Receivables
Pmt. Discount Date Field, Sales Invoice Header Table Sales and Receivables
Dimension Set ID Field, Sales Invoice Header Table Sales and Receivables
Pre-Assigned No. Field, Sales Invoice Header Table Sales and Receivables
Bal. Account No. Field, Sales Invoice Header Table Sales and Receivables
Ship-to Post Code Field, Sales Invoice Header Table Sales and Receivables
Sell-to Contact Field, Sales Invoice Header Table Sales and Receivables
External Document No. Field, Sales Invoice Header Table Sales and Receivables
EAN No. Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Fax No. Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Phone No. Field, Sales Invoice Header Table Denmark Local Functionality
Account Code Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact E-Mail Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Role Field, Sales Invoice Header Table Denmark Local Functionality
Electronic Invoice Created Field, Sales Invoice Header Table Denmark Local Functionality
Form Code Field, Sales Invoice Header Table India Sales Tax
PLA Entry No. Field, Sales Invoice Header Table India Excise
Service Tax Rounding Type Field, Sales Invoice Header Table India Service Tax
Vehicle No. Field, Sales Invoice Header Table India Excise
Form No. Field, Sales Invoice Header Table India Sales Tax
Transaction No. Serv. Tax Field, Sales Invoice Header Table India Service Tax
State Field, Sales Invoice Header Table India Sales Tax
Transit Document Field, Sales Invoice Header Table India Sales Tax
Free Supply Field, Sales Invoice Header Table India Sales Tax
LC No. Field, Sales Invoice Header Table India Sales Tax
Nature of Services Field, Sales Invoice Header Table India Service Tax
Excise Bus. Posting Group Field, Sales Invoice Header Table India Excise
Mode of Transport Field, Sales Invoice Header Table India Excise
Service Tax Rounding Precision Field, Sales Invoice Header Table India Service Tax
ST Pure Agent Field, Sales Invoice Header Table India Service Tax
Time of Removal Field, Sales Invoice Header Table India Excise
RG 23 A Entry No. Field, Sales Invoice Header Table India Excise
Price Inclusive of Taxes Field, Sales Invoice Header Table India Excise
Calc. Inv. Discount (%) Field, Sales Invoice Header Table India Excise
Amount to Customer Field, Sales Invoice Header Table India Local Functionality
RG 23 C Entry No. Field, Sales Invoice Header Table India Excise
LR/RR No. Field, Sales Invoice Header Table India Excise
Bank Account Field, Sales Invoice Header Table Netherlands Local Functionality
Transaction Mode Field, Sales Invoice Header Table Netherlands Local Functionality
LR/RR Date Field, Sales Invoice Header Table India Excise
Bill to Customer State Field, Sales Invoice Header Table India Local Functionality
Structure Field, Sales Invoice Header Table India Local Functionality
S/T Type Field, Sales Invoice Header Table New Zealand Local Functionality
Tax Document Type Field, Sales Invoice Header Table New Zealand Local Functionality
Certificate Serial No. Field, Sales Invoice Header Table United States Local Functionality
Original String Field, Sales Invoice Header Table United States Local Functionality
Electronic Document Sent Field, Sales Invoice Header Table United States Local Functionality
Total WHT Prepaid Amount (LCY) Field, Sales Invoice Header Table New Zealand Local Functionality
Electronic Document Status Field, Sales Invoice Header Table United States Local Functionality
Tax Exemption No. Field, Sales Invoice Header Table United States Local Functionality
Paid WHT Prepaid Amount (LCY) Field, Sales Invoice Header Table New Zealand Local Functionality
Error Code Field, Sales Invoice Header Table United States Local Functionality
No. of E-Documents Sent Field, Sales Invoice Header Table United States Local Functionality
Signed Document XML Field, Sales Invoice Header Table United States Local Functionality
Digital Stamp PAC Field, Sales Invoice Header Table United States Local Functionality
Original Document XML Field, Sales Invoice Header Table United States Local Functionality
QR Code Field, Sales Invoice Header Table United States Local Functionality
Date/Time First Req. Sent Field, Sales Invoice Header Table United States Local Functionality
Tax Document Marked Field, Sales Invoice Header Table New Zealand Local Functionality
S/T Expiry Date Field, Sales Invoice Header Table New Zealand Local Functionality
Digital Stamp SAT Field, Sales Invoice Header Table United States Local Functionality
Date/Time Canceled Field, Sales Invoice Header Table United States Local Functionality
Tax Date Filter Field, Sales Invoice Header Table New Zealand Local Functionality
Fiscal Invoice Number PAC Field, Sales Invoice Header Table United States Local Functionality
Error Description Field, Sales Invoice Header Table United States Local Functionality
Date/Time Sent Field, Sales Invoice Header Table United States Local Functionality
Posted Tax Document Field, Sales Invoice Header Table New Zealand Local Functionality
Ship-to UPS Zone Field, Sales Invoice Header Table United States Local Functionality
STE Transaction ID Field, Sales Invoice Header Table United States Local Functionality
Date/Time Stamped Field, Sales Invoice Header Table United States Local Functionality
PAC Web Service Name Field, Sales Invoice Header Table United States Local Functionality
Rem. WHT Prepaid Amount (LCY) Field, Sales Invoice Header Table New Zealand Local Functionality
Invoice Print Type Field, Sales Invoice Header Table New Zealand Local Functionality
Printed Tax Document Field, Sales Invoice Header Table New Zealand Local Functionality
WHT Business Posting Group Field, Sales Invoice Header Table New Zealand Local Functionality
Account Code Field, Sales Invoice Header Table Norway Local Functionality
E-Invoice Created Field, Sales Invoice Header Table Norway Local Functionality
GLN No. Field, Sales Invoice Header Table Norway Local Functionality
E-Invoice Field, Sales Invoice Header Table Norway Local Functionality
EAN No. Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Fax No. Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Phone No. Field, Sales Invoice Header Table Denmark Local Functionality
Account Code Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact E-Mail Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Role Field, Sales Invoice Header Table Denmark Local Functionality
Electronic Invoice Created Field, Sales Invoice Header Table Denmark Local Functionality
Form Code Field, Sales Invoice Header Table Sales Tax
PLA Entry No. Field, Sales Invoice Header Table Excise
Vehicle No Field, Sales Invoice Header Table Excise
Form No. Field, Sales Invoice Header Table Sales Tax
State Field, Sales Invoice Header Table Sales Tax
Service Tax Rounding Type Field, Sales Invoice Header Table Service Tax
Transit Document Field, Sales Invoice Header Table Sales Tax
Re-Dispatch Field, Sales Invoice Header Table Service Tax
Free Supply Field, Sales Invoice Header Table Sales Tax
LC No. Field, Sales Invoice Header Table Sales Tax
Excise Bus. Posting Group Field, Sales Invoice Header Table Excise
Mode of Transport Field, Sales Invoice Header Table Excise
Nature of service Field, Sales Invoice Header Table Service Tax
Service Tax Rounding Precision Field, Sales Invoice Header Table Service Tax
ST as pure agent Field, Sales Invoice Header Table Service Tax
Time of Removal Field, Sales Invoice Header Table Excise
RG 23 A Entry No. Field, Sales Invoice Header Table Excise
Price Inclusive of Taxes Field, Sales Invoice Header Table Excise
Calc. Inv. Discount (Percentage) Field, Sales Invoice Header Table Excise
RG 23 C Entry No. Field, Sales Invoice Header Table Excise
LR/RR No Field, Sales Invoice Header Table Excise
LR/RR Date Field, Sales Invoice Header Table Excise
Amount to Customer Field, Sales Invoice Header Table India Local Functionality
Bill to Customer State Field, Sales Invoice Header Table India Local Functionality
Structure Field, Sales Invoice Header Table India Local Functionality
EAN No. Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Fax No. Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Phone No. Field, Sales Invoice Header Table Denmark Local Functionality
Account Code Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact E-Mail Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Role Field, Sales Invoice Header Table Denmark Local Functionality
Electronic Invoice Created Field, Sales Invoice Header Table Denmark Local Functionality
Bank Account Field, Sales Invoice Header Table Netherlands Local Functionality
Transaction Mode Field, Sales Invoice Header Table Netherlands Local Functionality
EAN No. Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Fax No. Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Phone No. Field, Sales Invoice Header Table Denmark Local Functionality
Account Code Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact E-Mail Field, Sales Invoice Header Table Denmark Local Functionality
Sell-to Contact Role Field, Sales Invoice Header Table Denmark Local Functionality
Electronic Invoice Created Field, Sales Invoice Header Table Denmark Local Functionality
Bank Account Field, Sales Invoice Header Table Netherlands Local Functionality
Transaction Mode Field, Sales Invoice Header Table Netherlands Local Functionality

See Also

Reference

Sales Invoice
Sales Invoice Line