Table 5475 Sales Invoice Entity Aggregate in 28
- App
- Base Application
- Namespace
- Microsoft.Integration.Entity
Fields, 77Keys, 4Procedures, 10
Versions171819202122232425262728latest
Source29
Fields, 77
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Document Type | Enum Sales Document Type | - |
| 2 | Sell-to Customer No. | Code[20] | - |
| 3 | No. | Code[20] | - |
| 4 | Bill-to Customer No. | Code[20] | - |
| 5 | Bill-to Name | Text[100] | - |
| 7 | Bill-to Address | Text[100] | - |
| 8 | Bill-to Address 2 | Text[50] | - |
| 9 | Bill-to City | Text[30] | - |
| 10 | Bill-to Contact | Text[100] | - |
| 11 | Your Reference | Text[35] | - |
| 12 | Ship-to Code | Code[10] | - |
| 13 | Ship-to Name | Text[100] | - |
| 15 | Ship-to Address | Text[100] | - |
| 16 | Ship-to Address 2 | Text[50] | - |
| 17 | Ship-to City | Text[30] | - |
| 18 | Ship-to Contact | Text[100] | - |
| 20 | Posting Date | Date | - |
| 23 | Payment Terms Code | Code[10] | - |
| 24 | Due Date | Date | - |
| 27 | Shipment Method Code | Code[10] | - |
| 29 | Shortcut Dimension 1 Code | Code[20] | - |
| 30 | Shortcut Dimension 2 Code | Code[20] | - |
| 31 | Customer Posting Group | Code[20] | - |
| 32 | Currency Code | Code[10] | - |
| 35 | Prices Including VAT | Boolean | - |
| 43 | Salesperson Code | Code[20] | - |
| 44 | Order No. | Code[20] | - |
| 56 | Recalculate Invoice Disc. | Boolean | - |
| 60 | Amount | Decimal | - |
| 61 | Amount Including VAT | Decimal | - |
| 70 | VAT Registration No. | Text[20] | - |
| 79 | Sell-to Customer Name | Text[100] | - |
| 81 | Sell-to Address | Text[100] | - |
| 82 | Sell-to Address 2 | Text[50] | - |
| 83 | Sell-to City | Text[30] | - |
| 84 | Sell-to Contact | Text[100] | - |
| 85 | Bill-to Post Code | Code[20] | - |
| 86 | Bill-to County | Text[30] | - |
| 87 | Bill-to Country/Region Code | Code[10] | - |
| 88 | Sell-to Post Code | Code[20] | - |
| 89 | Sell-to County | Text[30] | - |
| 90 | Sell-to Country/Region Code | Code[10] | - |
| 91 | Ship-to Post Code | Code[20] | - |
| 92 | Ship-to County | Text[30] | - |
| 93 | Ship-to Country/Region Code | Code[10] | - |
| 99 | Document Date | Date | - |
| 100 | External Document No. | Code[35] | - |
| 114 | Tax Area Code | Code[20] | - |
| 115 | Tax Liable | Boolean | - |
| 116 | VAT Bus. Posting Group | Code[20] | - |
| 121 | Invoice Discount Calculation | Option | - |
| 122 | Invoice Discount Value | Decimal | - |
| 170 | IsTest | Boolean | - |
| 171 | Sell-to Phone No. | Text[30] | - |
| 172 | Sell-to E-Mail | Text[80] | - |
| 210 | Ship-to Phone No. | Text[30] | - |
| 1304 | Cust. Ledger Entry No. | Integer | - |
| 1305 | Invoice Discount Amount | Decimal | - |
| 1340 | Dispute Status | Code[10] | - |
| 1341 | Promised Pay Date | Date | - |
| 5052 | Sell-to Contact No. | Code[20] | - |
| 8000 | Id | Guid | - |
| 8010 | Dispute Status Id | Guid | - |
| 9600 | Total Tax Amount | Decimal | - |
| 9601 | Status | Enum Invoice Entity Aggregate Status | - |
| 9602 | Posted | Boolean | - |
| 9603 | Subtotal Amount | Decimal | - |
| 9624 | Discount Applied Before Tax | Boolean | - |
| 9630 | Last Modified Date Time | DateTime | - |
| 9631 | Customer Id | Guid | - |
| 9632 | Order Id | Guid | - |
| 9633 | Contact Graph Id | Text[250] | - |
| 9634 | Currency Id | Guid | - |
| 9635 | Payment Terms Id | Guid | - |
| 9636 | Shipment Method Id | Guid | - |
| 9637 | Tax Area ID | Guid | - |
| 9638 | Bill-to Customer Id | Guid | - |
Keys, 4
| Name | Fields | Obsolete |
|---|---|---|
| Key1 | No., Posted | - |
| Key2, clustered | Id | - |
| Key3 | Cust. Ledger Entry No. | - |
| Key4 | Document Date, Status | - |
Procedures, 10
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| UpdateCurrencyId | () | public | - | |
| UpdatePaymentTermsId | () | public | - | |
| UpdateShipmentMethodId | () | public | - | |
| UpdateReferencedRecordIds | () | public | - | |
| IsUsingVAT | () | Boolean | public | - |
| GetIsRenameAllowed | () | Boolean | public | - |
| SetIsRenameAllowed | (Boolean) | public | - | |
| GetParentRecordNativeInvoicing | (var Record Sales Header, var Record Sales Invoice Header) | Boolean | public | - |
| UpdateDisputeStatusId | () | public | - | |
| UpdateDisputeStatus | () | public | - |