Table "Sales Invoice Header"
ID 112
Namespace: Microsoft.Sales.History
Properties
Fields
Name |
Type |
Description |
"Sell-to Customer No." |
Code[20]
|
|
"No." |
Code[20]
|
|
"Bill-to Customer No." |
Code[20]
|
|
"Bill-to Name" |
Text[100]
|
|
"Bill-to Name 2" |
Text[50]
|
|
"Bill-to Address" |
Text[100]
|
|
"Bill-to Address 2" |
Text[50]
|
|
"Bill-to City" |
Text[30]
|
|
"Bill-to Contact" |
Text[100]
|
|
"Your Reference" |
Text[35]
|
|
"Ship-to Code" |
Code[10]
|
|
"Ship-to Name" |
Text[100]
|
|
"Ship-to Name 2" |
Text[50]
|
|
"Ship-to Address" |
Text[100]
|
|
"Ship-to Address 2" |
Text[50]
|
|
"Ship-to City" |
Text[30]
|
|
"Ship-to Contact" |
Text[100]
|
|
"Order Date" |
Date
|
|
"Posting Date" |
Date
|
|
"Shipment Date" |
Date
|
|
"Posting Description" |
Text[100]
|
|
"Payment Terms Code" |
Code[10]
|
|
"Due Date" |
Date
|
|
"Payment Discount %" |
Decimal
|
|
"Pmt. Discount Date" |
Date
|
|
"Shipment Method Code" |
Code[10]
|
|
"Location Code" |
Code[10]
|
|
"Shortcut Dimension 1 Code" |
Code[20]
|
|
"Shortcut Dimension 2 Code" |
Code[20]
|
|
"Customer Posting Group" |
Code[20]
|
|
"Currency Code" |
Code[10]
|
|
"Currency Factor" |
Decimal
|
|
"Customer Price Group" |
Code[10]
|
|
"Prices Including VAT" |
Boolean
|
|
"Invoice Disc. Code" |
Code[20]
|
|
"Customer Disc. Group" |
Code[20]
|
|
"Language Code" |
Code[10]
|
|
"Format Region" |
Text[80]
|
|
"Salesperson Code" |
Code[20]
|
|
"Order No." |
Code[20]
|
|
Comment |
Boolean
|
|
"No. Printed" |
Integer
|
|
"On Hold" |
Code[3]
|
|
"Applies-to Doc. Type" |
Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type"
|
|
"Applies-to Doc. No." |
Code[20]
|
|
"Bal. Account No." |
Code[20]
|
|
Amount |
Decimal
|
|
"Amount Including VAT" |
Decimal
|
|
"VAT Registration No." |
Text[20]
|
|
"Registration Number" |
Text[50]
|
|
"Reason Code" |
Code[10]
|
|
"Gen. Bus. Posting Group" |
Code[20]
|
|
"EU 3-Party Trade" |
Boolean
|
|
"Transaction Type" |
Code[10]
|
|
"Transport Method" |
Code[10]
|
|
"VAT Country/Region Code" |
Code[10]
|
|
"Sell-to Customer Name" |
Text[100]
|
|
"Sell-to Customer Name 2" |
Text[50]
|
|
"Sell-to Address" |
Text[100]
|
|
"Sell-to Address 2" |
Text[50]
|
|
"Sell-to City" |
Text[30]
|
|
"Sell-to Contact" |
Text[100]
|
|
"Bill-to Post Code" |
Code[20]
|
|
"Bill-to County" |
Text[30]
|
|
"Bill-to Country/Region Code" |
Code[10]
|
|
"Sell-to Post Code" |
Code[20]
|
|
"Sell-to County" |
Text[30]
|
|
"Sell-to Country/Region Code" |
Code[10]
|
|
"Ship-to Post Code" |
Code[20]
|
|
"Ship-to County" |
Text[30]
|
|
"Ship-to Country/Region Code" |
Code[10]
|
|
"Bal. Account Type" |
Microsoft.Bank.Payment."Payment Balance Account Type"
|
|
"Exit Point" |
Code[10]
|
|
Correction |
Boolean
|
|
"Document Date" |
Date
|
|
"External Document No." |
Code[35]
|
|
"Area" |
Code[10]
|
|
"Transaction Specification" |
Code[10]
|
|
"Payment Method Code" |
Code[10]
|
|
"Shipping Agent Code" |
Code[10]
|
|
"Package Tracking No." |
Text[30]
|
|
"Pre-Assigned No. Series" |
Code[20]
|
|
"No. Series" |
Code[20]
|
|
"Order No. Series" |
Code[20]
|
|
"Pre-Assigned No." |
Code[20]
|
|
"User ID" |
Code[50]
|
|
"Source Code" |
Code[10]
|
|
"Tax Area Code" |
Code[20]
|
|
"Tax Liable" |
Boolean
|
|
"VAT Bus. Posting Group" |
Code[20]
|
|
"VAT Base Discount %" |
Decimal
|
|
"Invoice Discount Calculation" |
Option
|
|
"Invoice Discount Value" |
Decimal
|
|
"Prepayment No. Series" |
Code[20]
|
|
"Prepayment Invoice" |
Boolean
|
|
"Prepayment Order No." |
Code[20]
|
|
"Quote No." |
Code[20]
|
|
"Company Bank Account Code" |
Code[20]
|
|
"Sell-to Phone No." |
Text[30]
|
|
"Sell-to E-Mail" |
Text[80]
|
|
"Payment Instructions" |
Blob
|
|
"Payment Instructions Name" |
Text[20]
|
|
"VAT Reporting Date" |
Date
|
|
"Payment Reference" |
Code[50]
|
|
"Work Description" |
Blob
|
|
"Dimension Set ID" |
Integer
|
|
"Payment Service Set ID" |
Integer
|
|
"Document Exchange Identifier" |
Text[50]
|
|
"Document Exchange Status" |
Microsoft.Sales.History."Sales Document Exchange Status"
|
|
"Doc. Exch. Original Identifier" |
Text[50]
|
|
"Coupled to CRM" |
Boolean
|
|
"Coupled to Dataverse" |
Boolean
|
|
"Direct Debit Mandate ID" |
Code[35]
|
|
Closed |
Boolean
|
|
"Remaining Amount" |
Decimal
|
|
"Cust. Ledger Entry No." |
Integer
|
|
"Invoice Discount Amount" |
Decimal
|
|
Cancelled |
Boolean
|
|
Corrective |
Boolean
|
|
Reversed |
Boolean
|
|
"Dispute Status" |
Code[10]
|
|
"Promised Pay Date" |
Date
|
|
"Campaign No." |
Code[20]
|
|
"Sell-to Contact No." |
Code[20]
|
|
"Bill-to Contact No." |
Code[20]
|
|
"Opportunity No." |
Code[20]
|
|
"Responsibility Center" |
Code[10]
|
|
"Price Calculation Method" |
Microsoft.Pricing.Calculation."Price Calculation Method"
|
|
"Allow Line Disc." |
Boolean
|
|
"Get Shipment Used" |
Boolean
|
|
Id |
Guid
|
|
"Draft Invoice SystemId" |
Guid
|
|
"Dispute Status Id" |
Guid
|
|
SystemId |
Guid
|
|
SystemCreatedAt |
DateTime
|
|
SystemCreatedBy |
Guid
|
|
SystemModifiedAt |
DateTime
|
|
SystemModifiedBy |
Guid
|
|
SystemRowVersion |
BigInteger
|
|
Methods
IsFullyOpen
procedure IsFullyOpen(): Boolean
Returns
CheckNoPrinted
procedure CheckNoPrinted()
SendRecords
SendProfile
procedure SendProfile(var DocumentSendingProfile: Record "Document Sending Profile")
Parameters
Name |
Type |
Description |
DocumentSendingProfile
|
Record "Document Sending Profile"
|
|
PrintRecords
procedure PrintRecords(ShowRequestPage: Boolean)
Parameters
Name |
Type |
Description |
ShowRequestPage
|
Boolean
|
|
UpdateDisputeStatus
procedure UpdateDisputeStatus()
UpdateDisputeStatusId
procedure UpdateDisputeStatusId()
PrintToDocumentAttachment
procedure PrintToDocumentAttachment(var SalesInvoiceHeader: Record "Sales Invoice Header")
Parameters
Name |
Type |
Description |
SalesInvoiceHeader
|
Record "Sales Invoice Header"
|
|
EmailRecords
procedure EmailRecords(ShowDialog: Boolean)
Parameters
Name |
Type |
Description |
ShowDialog
|
Boolean
|
|
GetDocTypeTxt
procedure GetDocTypeTxt(): Text[50]
Returns
Type |
Description |
Text[50]
|
|
Navigate
LookupAdjmtValueEntries
procedure LookupAdjmtValueEntries()
GetCustomerVATRegistrationNumber
procedure GetCustomerVATRegistrationNumber(): Text
Returns
GetCustomerVATRegistrationNumberLbl
procedure GetCustomerVATRegistrationNumberLbl(): Text
Returns
GetCustomerGlobalLocationNumber
procedure GetCustomerGlobalLocationNumber(): Text
Returns
GetCustomerGlobalLocationNumberLbl
procedure GetCustomerGlobalLocationNumberLbl(): Text
Returns
GetSellToCustomerFaxNo
procedure GetSellToCustomerFaxNo(): Text
Returns
GetPaymentReference
procedure GetPaymentReference(): Text
Returns
GetPaymentReferenceLbl
procedure GetPaymentReferenceLbl(): Text
Returns
GetLegalStatement
procedure GetLegalStatement(): Text
Returns
GetRemainingAmount
procedure GetRemainingAmount(): Decimal
Returns
ShowDimensions
procedure ShowDimensions()
SetSecurityFilterOnRespCenter
procedure SetSecurityFilterOnRespCenter()
GetDocExchStatusStyle
procedure GetDocExchStatusStyle(): Text
Returns
ShowActivityLog
procedure ShowActivityLog()
StartTrackingSite
procedure StartTrackingSite()
GetSelectedPaymentsText
procedure GetSelectedPaymentsText(): Text
Returns
GetWorkDescription
procedure GetWorkDescription(): Text
Returns
GetCurrencySymbol
procedure GetCurrencySymbol(): Text[10]
Returns
Type |
Description |
Text[10]
|
|
DocExchangeStatusIsSent
procedure DocExchangeStatusIsSent(): Boolean
Returns
ShowCanceledOrCorrCrMemo
procedure ShowCanceledOrCorrCrMemo()
ShowCorrectiveCreditMemo
procedure ShowCorrectiveCreditMemo()
ShowCancelledCreditMemo
procedure ShowCancelledCreditMemo()
GetDefaultEmailDocumentName
procedure GetDefaultEmailDocumentName(): Text[150]
Returns
Type |
Description |
Text[150]
|
|
See also