Table 31007 "Advance Letter Application CZZ" (CZ)
CZ country layer · Microsoft.Finance.AdvancePayments
Across versions
- BC23-28not present
- BC29-30present
CZ country layer · Microsoft.Finance.AdvancePayments · captioned “Advance Letter Application” · BC29-30 · source at ea08af5e · facts from BC29
An object of the CZ localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | Advance Letter Application |
| 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 | Advance Letter Type | Enum “Advance Letter Type CZZ” | — | enum Advance Letter Type CZZ |
| 2 | Advance Letter No. | Code[20] | — | TableRelation if (“Advance Letter Type” = const(Sales)) “Sales Adv. Letter Header CZZ”.“No.” else if (“Advance Letter Type” = const(Purchase)) “Purch. Adv. Letter Header CZZ”.“No.” |
| 3 | Document Type | Enum “Adv. Letter Usage Doc.Type CZZ” | — | enum Adv. Letter Usage Doc.Type CZZ |
| 4 | Document No. | Code[20] | — | TableRelation if (“Document Type” = const(“Sales Order”)) “Sales Header”.“No.” where(“Document Type” = const(Order)) else if (“Document Type” = const(“Sales Invoice”)) “Sales Header”.“No.” where(“Document Type” = const(Invoice)) else if (“Document Type” = const(“Purchase Order”)) “Purchase Header”.“No.” where(“Do… |
| 8 | Amount | Decimal | — | |
| 9 | Amount (LCY) | Decimal | — | |
| 11 | Amount to Use | Decimal | — | |
| 12 | Amount to Use (LCY) | Decimal | — | |
| 20 | Currency Code | Code[10] | — | TableRelation Currency; not editable |
| 21 | Currency Factor | Decimal | — | not editable |
| 50 | Posting Date | Date | — | not editable |
| 51 | Job No. | Code[20] | Specifies the project number for the sales advance document. | TableRelation Job.“No.”; not editable |
| 52 | Job Task No. | Code[20] | Specifies the project task number of the sales advance document. | TableRelation “Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)); not editable |
Keys
- PK: Advance Letter Type, Advance Letter No., Document Type, Document No. (clustered)
Events published
OnGetPossiblePurchAdvanceOnBeforeInsertNewAdvanceLetterApplication(var NewAdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ"; AdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ")(integration)OnGetPossibleSalesAdvanceOnBeforeInsertNewAdvanceLetterApplication(var NewAdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ"; AdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ")(integration)OnGetAssignedAdvanceOnBeforeInsertNewAdvanceLetterApplication(var NewAdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ"; AdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ")(integration)
Procedures
GetPossibleSalesAdvance(NewFromAdvLetterUsageDocTypeCZZ: Enum "Adv. Letter Usage Doc.Type CZZ"; NewFromDocumentNo: Code[20]; NewBillToCustomerNo: Code[20]; NewPostingDate: Date; NewCurrencyCode: Code[10]; var NewAdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ")GetPossiblePurchAdvance(NewFromAdvLetterUsageDocTypeCZZ: Enum "Adv. Letter Usage Doc.Type CZZ"; NewFromDocumentNo: Code[20]; NewPayToVendorNo: Code[20]; NewPostingDate: Date; NewCurrencyCode: Code[10]; var NewAdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ")GetAssignedAdvance(NewFromAdvLetterUsageDocTypeCZZ: Enum "Adv. Letter Usage Doc.Type CZZ"; NewFromDocumentNo: Code[20]; var NewAdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ")GetAssignedAdvance(JobNo: Code[20]; var NewAdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ")GetAssignedAdvance(JobNo: Code[20]; JobTaskNo: Code[20]; var NewAdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ")CopyFrom(AdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ")(internal)CopyFrom(SalesAdvLetterHeaderCZZ: Record "Sales Adv. Letter Header CZZ")(internal)CopyFrom(PurchAdvLetterHeaderCZZ: Record "Purch. Adv. Letter Header CZZ")(internal)Add(AdvanceLetterApplicationCZZ: Record "Advance Letter Application CZZ")(internal)ApplyChanges()(internal)CheckVATRegistrationNoDifference()
Plus 2 local procedures.
Triggers
OnDelete
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: "Advance Letter Application CZZ"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.
A CZ country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.