Table "Sales Header Archive"
ID 5107
Namespace: Microsoft.Sales.Archive
Properties
| Name | Value |
|---|---|
| Caption | Sales Header Archive |
| DataCaptionFields | 3,79,5047 |
| DrillDownPageID | Microsoft.Sales.Archive."Sales List Archive" |
| LookupPageID | Microsoft.Sales.Archive."Sales List Archive" |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Document Type" | Microsoft.Sales.Document."Sales Document Type" | |
| "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 | |
| "Price Group Code" | Code[10] | |
| "Prices Including VAT" | Boolean | |
| "Invoice Disc. Code" | Code[20] | |
| "Cust./Item Disc. Gr." | Code[20] | |
| "Language Code" | Code[10] | |
| "Format Region" | Text[80] | |
| "Salesperson Code" | Code[20] | |
| "Order Class" | Code[10] | |
| 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] | |
| Ship | Boolean | |
| Invoice | Boolean | |
| Amount | Decimal | |
| "Amount Including VAT" | Decimal | |
| "Shipping No." | Code[20] | |
| "Posting No." | Code[20] | |
| "Last Shipping No." | Code[20] | |
| "Last Posting No." | Code[20] | |
| "Prepayment No." | Code[20] | |
| "Last Prepayment No." | Code[20] | |
| "Prepmt. Cr. Memo No." | Code[20] | |
| "Last Prepmt. Cr. Memo No." | Code[20] | |
| "VAT Registration No." | Text[20] | |
| "Combine Shipments" | Boolean | |
| "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] | |
| "No. Series" | Code[20] | |
| "Posting No. Series" | Code[20] | |
| "Shipping No. Series" | Code[20] | |
| "Tax Area Code" | Code[20] | |
| "Tax Liable" | Boolean | |
| "VAT Bus. Posting Group" | Code[20] | |
| Reserve | Microsoft.Inventory.Tracking."Reserve Method" | |
| "Applies-to ID" | Code[50] | |
| "VAT Base Discount %" | Decimal | |
| Status | Microsoft.Sales.Document."Sales Document Status" | |
| "Invoice Discount Calculation" | Option | |
| "Invoice Discount Value" | Decimal | |
| "Send IC Document" | Boolean | |
| "IC Status" | Microsoft.Intercompany.Setup."Sales Document IC Status" | |
| "Sell-to IC Partner Code" | Code[20] | |
| "Bill-to IC Partner Code" | Code[20] | |
| "IC Reference Document No." | Code[20] | |
| "IC Direction" | Microsoft.Intercompany.Setup."IC Direction Type" | |
| "Prepayment %" | Decimal | |
| "Prepayment No. Series" | Code[20] | |
| "Compress Prepayment" | Boolean | |
| "Prepayment Due Date" | Date | |
| "Prepmt. Cr. Memo No. Series" | Code[20] | |
| "Prepmt. Posting Description" | Text[100] | |
| "Prepmt. Pmt. Discount Date" | Date | |
| "Prepmt. Payment Terms Code" | Code[10] | |
| "Prepmt. Payment Discount %" | Decimal | |
| "No. of Archived Versions" | Integer | |
| "Sales Quote No." | Code[20] | |
| "Quote Valid Until Date" | Date | |
| "Quote Sent to Customer" | DateTime | |
| "Quote Accepted" | Boolean | |
| "Quote Accepted Date" | Date | |
| "Company Bank Account Code" | Code[20] | |
| "Incoming Document Entry No." | Integer | |
| "Sell-to Phone No." | Text[30] | |
| "Sell-to E-Mail" | Text[80] | |
| "VAT Reporting Date" | Date | |
| "Rcvd-from Country/Region Code" | Code[10] | |
| "Rcvd.-from Count./Region Code" | Code[10] | |
| "Work Description" | Blob | |
| "Dimension Set ID" | Integer | |
| "Credit Card No." | Code[20] | |
| "Source Doc. Exists" | Boolean | |
| "Last Archived Date" | DateTime | |
| "Interaction Exist" | Boolean | |
| "Time Archived" | Time | |
| "Date Archived" | Date | |
| "Archived By" | Code[50] | |
| "Version No." | Integer | |
| "Doc. No. Occurrence" | Integer | |
| "Campaign No." | Code[20] | |
| "Sell-to Customer Template Code" | Code[10] | |
| "Sell-to Contact No." | Code[20] | |
| "Bill-to Contact No." | Code[20] | |
| "Bill-to Customer Template Code" | Code[10] | |
| "Opportunity No." | Code[20] | |
| "Sell-to Customer Templ. Code" | Code[20] | |
| "Bill-to Customer Templ. Code" | Code[20] | |
| "Responsibility Center" | Code[10] | |
| "Shipping Advice" | Microsoft.Foundation.Shipping."Sales Header Shipping Advice" | |
| "Completely Shipped" | Boolean | |
| "Posting from Whse. Ref." | Integer | |
| "Location Filter" | Code[10] | |
| "Requested Delivery Date" | Date | |
| "Promised Delivery Date" | Date | |
| "Shipping Time" | DateFormula | |
| "Outbound Whse. Handling Time" | DateFormula | |
| "Shipping Agent Service Code" | Code[10] | |
| "Late Order Shipping" | Boolean | |
| "Date Filter" | Date | |
| Receive | Boolean | |
| "Return Receipt No." | Code[20] | |
| "Return Receipt No. Series" | Code[20] | |
| "Last Return Receipt No." | Code[20] | |
| "Price Calculation Method" | Microsoft.Pricing.Calculation."Price Calculation Method" | |
| "Allow Line Disc." | Boolean | |
| "Get Shipment Used" | Boolean | |
| "Assigned User ID" | Code[50] | |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |
Methods
ShowDimensions
procedure ShowDimensions()SetSecurityFilterOnRespCenter
procedure SetSecurityFilterOnRespCenter()