Table 30154 "Shpfy Suggest Payment"

Shopify · Microsoft.Integration.Shopify · captioned “Shopify Suggest Payment” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Shopify Suggest Payment
Access	Internal
TableType	Temporary
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	Entry No.	Integer	—	DataClassification SystemMetadata
2	Shop Code	Code[20]	—	TableRelation Table 30102 “Shpfy Shop” (Shpfy Shop); DataClassification SystemMetadata
3	Shpfy Transaction Id	BigInteger	—	TableRelation Table 30133 “Shpfy Order Transaction” (Shpfy Order Transaction); DataClassification SystemMetadata
4	Customer Ledger Entry No.	Integer	—	TableRelation Table 21 “Cust. Ledger Entry” (Cust. Ledger Entry); DataClassification SystemMetadata
5	Customer No.	Code[20]	—	TableRelation Table 18 “Customer”; DataClassification SystemMetadata
6	Invoice No.	Code[20]	—	TableRelation Table 112 “Sales Invoice Header” (Sales Invoice Header); DataClassification SystemMetadata
7	Amount	Decimal	—
8	Currency Code	Code[10]	—	TableRelation Table 4 “Currency”; DataClassification SystemMetadata
9	Gateway	Text[30]	—
10	Cust. Ledger Entry Dim. Set Id	Integer	—	DataClassification SystemMetadata
11	Shpfy Order No.	Text[50]	—	FlowField: lookup(“Shpfy Order Header”.“Shopify Order No.” where(“Shopify Order Id” = field(“Shpfy Order Id”)))
12	Shpfy Gift Card Id	BigInteger	—	DataClassification SystemMetadata
13	Payment Method Code	Code[10]	—	DataClassification SystemMetadata
14	Shpfy Order Id	BigInteger	—	DataClassification SystemMetadata
15	Credit Memo No.	Code[20]	—	TableRelation Table 114 “Sales Cr.Memo Header” (Sales Cr.Memo Header); DataClassification SystemMetadata

Keys

PK: Entry No. (clustered)

Relations

Invoice No.: TableRelation Table 112 “Sales Invoice Header”
Credit Memo No.: TableRelation Table 114 “Sales Cr.Memo Header”
Customer No.: TableRelation Table 18 “Customer”
Customer Ledger Entry No.: TableRelation Table 21 “Cust. Ledger Entry”
Shop Code: TableRelation Table 30102 “Shpfy Shop”
Shpfy Order No.: CalcFormula Table 30118 “Shpfy Order Header”
Shpfy Transaction Id: TableRelation Table 30133 “Shpfy Order Transaction”
Currency Code: TableRelation Table 4 “Currency”

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: "Shpfy Suggest Payment"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.