BC Observatoryunofficial, made by waldo
tableIntegration & APIsofficial - Microsoftderived - from the source, no model text

Table 10752 "SII Doc. Upload State" (ES)

ES country layer · Microsoft.EServices.EDocument

Open in Claude10752-es.mdSource on GitHub

Across versions

  1. BC23-28not present
  2. BC29-30present

ES country layer · Microsoft.EServices.EDocument · captioned “SII Doc. Upload States” · BC29-30 · source at ea08af5e · facts from BC29

An object of the ES localization, not part of W1.

Properties

Property Value
Caption SII Doc. Upload States
DataClassification CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 Id Integer — NotBlank; AutoIncrement
2 Entry No Integer —
3 Document Source Enum “SII Doc. Upload State Document Source” — enum SII Doc. Upload State Document Source; NotBlank
4 Document Type Enum “SII Doc. Upload State Document Type” — enum SII Doc. Upload State Document Type
5 Document No. Code[35] —
6 Posting Date Date —
7 Transaction Type Option — OptionCaption: Regular,Intracommunity,RetryAccepted,Collection In Cash
8 Status Enum “SII Document Status” — enum SII Document Status; NotBlank
9 Is Credit Memo Removal Boolean —
10 Is Manual Boolean —
11 External Document No. Code[35] —
12 Corrected Doc. No. Code[35] —
13 Corr. Posting Date Date —
20 Sales Invoice Type Enum “SII Sales Upload Invoice Type” — enum SII Sales Upload Invoice Type
21 Sales Cr. Memo Type Enum “SII Sales Upload Credit Memo Type” — enum SII Sales Upload Credit Memo Type
22 Sales Special Scheme Code Enum “SII Sales Upload Scheme Code” — enum SII Sales Upload Scheme Code
23 Purch. Invoice Type Enum “SII Purch. Upload Invoice Type” — enum SII Purch. Upload Invoice Type
24 Purch. Cr. Memo Type Enum “SII Purch. Upload Cr. Memo Type” — enum SII Purch. Upload Cr. Memo Type
25 Purch. Special Scheme Code Enum “SII Purch. Upload Scheme Code” — enum SII Purch. Upload Scheme Code
30 CV No. Code[20] — TableRelation if (“Document Source” = const(“Customer Ledger”)) Customer else if (“Document Source” = const(“Vendor Ledger”)) Vendor
31 Total Amount In Cash Decimal —
40 Retry Accepted Boolean —
41 VAT Registration No. Text[20] —
42 CV Name Text[100] —
43 Country/Region Code Code[10] —
44 IDType Enum “SII ID Type” — enum SII ID Type
50 Inv. Entry No Integer — DataClassification SystemMetadata
60 Succeeded Company Name Text[250] —
61 Succeeded VAT Registration No. Text[20] —
62 Issued By Third Party Boolean —
63 First Summary Doc. No. Text[250] —
64 Last Summary Doc. No. Text[250] —
70 Version No. Option — OptionCaption: 1.1,1.0,1.1bis
80 Accepted By User ID Code[50] — TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation
81 Accepted Date Time DateTime — not editable; DataClassification SystemMetadata
82 CSV Response Text[250] — not editable; DataClassification SystemMetadata

Keys

  • Key1: Id (clustered)
  • Key2: Entry No
  • Key3: Status, Is Manual
  • Key4: Document No., Document Source, Document Type

Events published

  • OnAfterValidateDocInfo(var TempSIIDocUploadState: Record "SII Doc. Upload State" temporary; EntryNo: Integer; DocumentSource: Enum "SII Doc. Upload State Document Source"; DocumentType: Enum "SII Doc. Upload State Document Type"; DocumentNo: Code[35]) (integration)
  • OnCreateNewRequestInternalOnBeforeSIIDocUploadStateInsert(var SIIDocUploadState: Record "SII Doc. Upload State"; EntryNo: Integer; InvEntryNo: Integer; DocumentSource: Enum "SII Doc. Upload State Document Source"; DocumentType: Enum "SII Doc. Upload State Document Type"; DocumentNo: Code[35]; ExternalDocumentNo: Code[35]; PostingDate: Date) (integration)
  • OnAfterIsCreditmemoRemovalOnGetCorrectionType(CustLedgerEntry: Record "Cust. Ledger Entry"; var Result: Boolean; var ShouldExit: Boolean) (integration)
  • OnUpdateFieldsForServiceInvoice(DocumentNo: Code[35]; var TempSIIDocUploadState: Record "SII Doc. Upload State" temporary; var Result: Boolean) (integration)
  • OnUpdateFieldsForServiceCreditMemo(DocumentNo: Code[35]; var TempSIIDocUploadState: Record "SII Doc. Upload State" temporary; var Result: Boolean) (integration)

Procedures

  • CreateNewRequest(EntryNo: Integer; DocumentSource: Option "Customer Ledger","Vendor Ledger","Detailed Customer Ledger","Detailed Vendor Ledger"; DocumentType: Option; DocumentNo: Code[35]; ExternalDocumentNo: Code[35]; PostingDate: Date)
  • CreateNewCollectionsInCashRequest(CustomerNo: Code[20]; PostingDate: Date; TotalAmount: Decimal): Boolean
  • CreateNewVendPmtRequest(PmtEntryNo: Integer; InvEntryNo: Integer; DocumentNo: Code[35]; PostingDate: Date)
  • CreateNewVendRefundRequest(PmtEntryNo: Integer; CrEntryNo: Integer; DocumentNo: Code[35]; PostingDate: Date)
  • CreateNewCustPmtRequest(PmtEntryNo: Integer; InvEntryNo: Integer; DocumentNo: Code[30]; PostingDate: Date)
  • CreateNewCustRefundRequest(PmtEntryNo: Integer; CrEntryNo: Integer; DocumentNo: Code[30]; PostingDate: Date)
  • CreateCommunicationErrorRetries()
  • UpdateDocInfoOnSIIDocUploadState(DocFieldNo: Integer)
  • UpdateFieldOnSIIDOcUploadState(FieldNo: Integer)
  • GetSIIDocUploadStateByCustLedgEntry(CustLedgEntry: Record "Cust. Ledger Entry")
  • GetSIIDocUploadStateByVendLedgEntry(VendorLedgerEntry: Record "Vendor Ledger Entry")
  • GetSIIDocUploadStateByDocument(DocSource: Option; DocType: Option; PostingDate: Date; DocNo: Code[20]): Boolean
  • ValidateDocInfo(var TempSIIDocUploadState: Record "SII Doc. Upload State" temporary; EntryNo: Integer; DocumentSource: Enum "SII Doc. Upload State Document Source"; DocumentType: Enum "SII Doc. Upload State Document Type"; DocumentNo: Code[35])
  • IsCreditMemoRemoval(): Boolean
  • GetCorrectionInfo(var CorrectedDocNo: Code[35]; var CorrectionDate: Date; PostingDate: Date)
  • UpdateSalesSIIDocUploadStateInfo(CustNo: Code[20]; InvType: Option; CrMemoType: Option; SpecialSchemeCode: Option; SucceededCompanyName: Text[250]; SucceededVATRegNo: Text[20]; NewIDType: Option)
  • UpdatePurchSIIDocUploadState(VendNo: Code[20]; InvType: Option; CrMemoType: Option; SpecialSchemeCode: Option; SucceededCompanyName: Text[250]; SucceededVATRegNo: Text[20]; NewIDType: Option)
  • GetSpecialSchemeCodes(var RegimeCodes: array[3] of Code[2])
  • AssignPurchSchemeCode(SchemeCode: Enum "SII Purch. Special Scheme Code")
  • AssignSalesSchemeCode(SchemeCode: Enum "SII Sales Special Scheme Code")
  • AssignPurchInvoiceType(InvoiceType: Enum "SII Purch. Invoice Type")
  • AssignSalesInvoiceType(InvoiceType: Enum "SII Sales Invoice Type")
  • AssignPurchCreditMemoType(CreditMemoType: Enum "SII Purch. Credit Memo Type")
  • AssignSalesCreditMemoType(CreditMemoType: Enum "SII Sales Credit Memo Type")

Plus 10 local procedures.

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "SII Doc. Upload State"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A ES country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.

Evidence 1 sources