Table "Sales Order Entity Buffer"
ID 5495
Namespace: Microsoft.Integration.Entity
Properties
| Name | Value |
|---|---|
| Caption | Sales Order Entity Buffer |
| ReplicateData | False |
| DataClassification | CustomerContent |
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 Address" | Text[100] | |
| "Bill-to Address 2" | Text[50] | |
| "Bill-to City" | Text[30] | |
| "Bill-to Contact" | Text[100] | |
| "Ship-to Code" | Code[10] | |
| "Ship-to Name" | Text[100] | |
| "Ship-to Address" | Text[100] | |
| "Ship-to Address 2" | Text[50] | |
| "Ship-to City" | Text[30] | |
| "Ship-to Contact" | Text[100] | |
| "Posting Date" | Date | |
| "Payment Terms Code" | Code[10] | |
| "Shipment Method Code" | Code[10] | |
| "Shortcut Dimension 1 Code" | Code[20] | |
| "Shortcut Dimension 2 Code" | Code[20] | |
| "Customer Posting Group" | Code[20] | |
| "Currency Code" | Code[10] | |
| "Prices Including VAT" | Boolean | |
| "Salesperson Code" | Code[20] | |
| "Recalculate Invoice Disc." | Boolean | |
| Amount | Decimal | |
| "Amount Including VAT" | Decimal | |
| "Sell-to Customer Name" | Text[100] | |
| "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] | |
| "Document Date" | Date | |
| "External Document No." | Code[35] | |
| "Sell-to Phone No." | Text[30] | |
| "Sell-to E-Mail" | Text[80] | |
| "Ship-to Phone No." | Text[30] | |
| "Cust. Ledger Entry No." | Integer | |
| "Invoice Discount Amount" | Decimal | |
| "Sell-To Contact No." | Code[20] | |
| "Shipping Advice" | Option | |
| "Completely Shipped" | Boolean | |
| "Requested Delivery Date" | Date | |
| Id | Guid | |
| "Total Tax Amount" | Decimal | |
| Status | Enum Microsoft.Integration.Entity."Sales Order Entity Buffer Status" | |
| "Discount Applied Before Tax" | Boolean | |
| "Last Modified Date Time" | DateTime | |
| "Customer Id" | Guid | |
| "Contact Graph Id" | Text[250] | |
| "Currency Id" | Guid | |
| "Payment Terms Id" | Guid | |
| "Shipment Method Id" | Guid | |
| "Bill-to Customer Id" | Guid | |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |
Methods
UpdateCurrencyId
procedure UpdateCurrencyId()UpdatePaymentTermsId
procedure UpdatePaymentTermsId()UpdateShipmentMethodId
procedure UpdateShipmentMethodId()UpdateReferencedRecordIds
procedure UpdateReferencedRecordIds()