Table 31003 "Advance Letter Template CZZ" (CZ)

CZ country layer · Microsoft.Finance.AdvancePayments · captioned “Advance Letter Template” · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	Advance Letter Template
DataClassification	CustomerContent
LookupPageId	Advance Letter Templates CZZ

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	Code	Code[20]	—	NotBlank
2	Description	Text[50]	—
3	Sales/Purchase	Enum “Advance Letter Type CZZ”	—	enum Advance Letter Type CZZ
5	Advance Letter G/L Account	Code[20]	—	TableRelation G/L Account
8	Advance Letter Document Nos.	Code[20]	—	TableRelation No. Series
10	Advance Letter Invoice Nos.	Code[20]	—	TableRelation No. Series
11	Advance Letter Cr. Memo Nos.	Code[20]	—	TableRelation No. Series
13	VAT Bus. Posting Group	Code[20]	—	TableRelation VAT Business Posting Group
25	Automatic Post VAT Document	Boolean	—
26	Automatic Post Non-Ded. VAT	Boolean	Specifies whether non-deductible VAT will be applied to the tax documents automatically. If you select NO, the system will ask you if you want to reduce input tax every time you post a tax document for non-deductible VAT. If you select YES, the reduction will be done automatically after the tax docu…	obsolete Pending 27.0; #if not CLEANSCHEMA30
30	Post VAT Doc. for Rev. Charge	Boolean	Specifies whether the VAT document will be posting for reverse charge.
35	Ext. Doc. No. (VAT Document)	Enum “Ext. Doc. No. VAT Source CZZ”	Specifies how the system will populate the External Document No. when posting Sales Advance Letter VAT documents.	enum Ext. Doc. No. VAT Source CZZ

Keys

PK: Code (clustered)

Procedures

GetExternalDocumentNo(AdvanceLetterNo: Code[20]; ExternalDocumentNo: Code[35]; VATDocumentNo: Code[20]): Code[35] (internal)

Deprecations

field Automatic Post Non-Ded. VAT: Pending 27.0 (#if not CLEANSCHEMA30), “The field is obsolete and will be removed in a future version. Non-deductible VAT must always be posted in advances so this field is useless.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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 Template 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.