Table 5508 "Purch. Cr. Memo Entity Buffer"

Base Application · Microsoft.Integration.Entity · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 30083 “APIV2 - Purchase Credit Memos” (5 Learn pages).

Properties

Property	Value
Caption	Purch. Cr. Memo Entity Buffer
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
2	Buy-from Vendor No.	Code[20]	—	TableRelation Table 23 “Vendor”; NotBlank
3	No.	Code[20]	—
4	Pay-to Vendor No.	Code[20]	—	TableRelation Table 23 “Vendor”; NotBlank
5	Pay-to Name	Text[100]	—	TableRelation Vendor.Name
7	Pay-to Address	Text[100]	—
8	Pay-to Address 2	Text[50]	—
9	Pay-to City	Text[30]	—	TableRelation Table 225 “Post Code” (if (“Pay-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Pay-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Pay-to Country/Region Code”)))
10	Pay-to Contact	Text[100]	—
20	Posting Date	Date	—
23	Payment Terms Code	Code[10]	—	TableRelation Table 3 “Payment Terms” (Payment Terms)
24	Due Date	Date	—
27	Shipment Method Code	Code[10]	—	TableRelation Table 10 “Shipment Method” (Shipment Method)
29	Shortcut Dimension 1 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
30	Shortcut Dimension 2 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
31	Vendor Posting Group	Code[20]	—	TableRelation Table 93 “Vendor Posting Group” (Vendor Posting Group)
32	Currency Code	Code[10]	—	TableRelation Table 4 “Currency”
35	Prices Including VAT	Boolean	—
43	Purchaser Code	Code[20]	—	TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser)
52	Applies-to Doc. Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”
53	Applies-to Doc. No.	Code[20]	—
60	Amount	Decimal	—
61	Amount Including VAT	Decimal	—
69	Vendor Cr. Memo No. + BC26	Code[35]	—
73	Reason Code	Code[10]	—	TableRelation Table 231 “Reason Code” (Reason Code)
79	Buy-from Vendor Name	Text[100]	—	TableRelation Vendor.Name
81	Buy-from Address	Text[100]	—
82	Buy-from Address 2	Text[50]	—
83	Buy-from City	Text[30]	—	TableRelation Table 225 “Post Code” (if (“Buy-from Country/Region Code” = const(‘’)) “Post Code”.City else if (“Buy-from Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Buy-from Country/Region Code”)))
84	Buy-from Contact	Text[100]	—
85	Pay-to Post Code	Code[20]	—	TableRelation Table 225 “Post Code” (if (“Pay-to Country/Region Code” = const(‘’)) “Post Code” else if (“Pay-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Pay-to Country/Region Code”)))
86	Pay-to County	Text[30]	—
87	Pay-to Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
88	Buy-from Post Code	Code[20]	—	TableRelation Table 225 “Post Code” (if (“Buy-from Country/Region Code” = const(‘’)) “Post Code” else if (“Buy-from Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Buy-from Country/Region Code”)))
89	Buy-from County	Text[30]	—
90	Buy-from Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
99	Document Date	Date	—
1304	Vendor Ledger Entry No.	Integer	—	TableRelation Table 25 “Vendor Ledger Entry” (“Vendor Ledger Entry”.“Entry No.”)
1305	Invoice Discount Amount	Decimal	—
5052	Buy-from Contact No.	Code[20]	—	TableRelation Table 5050 “Contact”
8000	Id	Guid	—	DataClassification SystemMetadata
9600	Total Tax Amount	Decimal	—
9601	Status	Enum “Purch. Cr. Memo Entity Status”	—	enum Enum 5508 “Purch. Cr. Memo Entity Status”
9602	Posted	Boolean	—
9624	Discount Applied Before Tax	Boolean	—
9631	Vendor Id	Guid	—	TableRelation Vendor.SystemId; DataClassification SystemMetadata
9634	Currency Id	Guid	—	TableRelation Currency.SystemId; DataClassification SystemMetadata
9635	Payment Terms Id	Guid	—	TableRelation Table 3 “Payment Terms” (“Payment Terms”.SystemId); DataClassification SystemMetadata
9636	Shipment Method Id	Guid	—	TableRelation Table 10 “Shipment Method” (“Shipment Method”.SystemId); DataClassification SystemMetadata
9638	Pay-to Vendor Id	Guid	—	TableRelation Vendor.SystemId; DataClassification SystemMetadata
9639	Reason Code Id	Guid	—	TableRelation Table 231 “Reason Code” (“Reason Code”.SystemId); DataClassification SystemMetadata

Keys

Key1: No., Posted
Key2: Id (clustered)
Key3: Vendor Ledger Entry No.

Procedures

UpdateCurrencyId()
UpdatePaymentTermsId()
UpdateReasonCodeId()
UpdateShipmentMethodId()
UpdateReferencedRecordIds()
GetIsRenameAllowed(): Boolean
SetIsRenameAllowed(RenameAllowed: Boolean)

Plus 8 local procedures.

Triggers

OnInsert, OnModify, OnRename

Relations

Shipment Method Code: TableRelation Table 10 “Shipment Method”
Shipment Method Id: TableRelation Table 10 “Shipment Method”
Purchaser Code: TableRelation Table 13 “Salesperson/Purchaser”
Buy-from City: TableRelation Table 225 “Post Code” (conditional)
Buy-from Post Code: TableRelation Table 225 “Post Code” (conditional)
Pay-to City: TableRelation Table 225 “Post Code” (conditional)
Pay-to Post Code: TableRelation Table 225 “Post Code” (conditional)
Buy-from Vendor No.: TableRelation Table 23 “Vendor”
Pay-to Vendor No.: TableRelation Table 23 “Vendor”
Reason Code: TableRelation Table 231 “Reason Code”
Reason Code Id: TableRelation Table 231 “Reason Code”
Vendor Ledger Entry No.: TableRelation Table 25 “Vendor Ledger Entry”
Payment Terms Code: TableRelation Table 3 “Payment Terms”
Payment Terms Id: TableRelation Table 3 “Payment Terms”
Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Currency Code: TableRelation Table 4 “Currency”
Buy-from Contact No.: TableRelation Table 5050 “Contact”
Buy-from Country/Region Code: TableRelation Table 9 “Country/Region”
Pay-to Country/Region Code: TableRelation Table 9 “Country/Region”
Vendor Posting Group: TableRelation Table 93 “Vendor Posting Group”

Pages and codeunits on this table

Page 30083 “APIV2 - Purchase Credit Memos” (source table)

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: "Purch. Cr. Memo Entity Buffer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.