Table 6154 "E-Document Sales Line"

EDocument · Microsoft.eServices.EDocument.Processing.Import.Sales · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Access	Internal
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	E-Document Entry No.	Integer	—	TableRelation Table 6121 “E-Document” (“E-Document”.“Entry No”); not editable; DataClassification SystemMetadata
2	Line No.	Integer	—	not editable; DataClassification SystemMetadata
3	External Line Id	Text[100]	—	not editable
4	Description	Text[100]	Specifies the description.	not editable
5	Quantity	Decimal	Specifies the quantity.	not editable
6	Unit of Measure	Text[50]	—	not editable
7	Unit Price	Decimal	Specifies the unit price.	not editable
8	Line Extension Amount	Decimal	Specifies the line extension amount.	not editable
9	Line Discount Amount	Decimal	Specifies the line discount amount.	not editable
10	VAT Rate	Decimal	Specifies the VAT rate of this line. via Page 6154 “E-Doc. Sales Draft Subform”	not editable
11	Currency Code	Code[10]	—	not editable
12	Buyer Item Id	Text[100]	—	not editable
13	Seller Item Id	Text[100]	—	not editable
14	Standard Item Id	Text[100]	—	not editable
15	Requested Delivery Date	Date	—	not editable
101	[BC] Sales Line Type	Enum “Sales Line Type”	Specifies the type of entity that will be posted for this sales line, such as Item or Resource.	enum Enum 37 “Sales Line Type”
102	[BC] Sales Line No.	Code[20]	Specifies the item or resource number.	TableRelation Table 15 “G/L Account”, Table 5600 “Fixed Asset”, Table 7 “Standard Text” (if (“[BC] Sales Line Type” = const(” “)) “Standard Text” else if (“[BC] Sales Line Type” = const(“G/L Account”)) “G/L Account” where(“Direct Posting” = const(true)) else if (“[BC] Sales Line Type” = const(“Fixed Asset”)) “Fixed Asset” else if (“[BC] Sales Line Type” = const(“Charge (Item)”)) “Item C…)
103	[BC] Unit of Measure	Code[10]	Specifies the unit of measure code.	TableRelation Table 204 “Unit of Measure” (“Unit of Measure”.Code)
104	[BC] Item Reference No.	Code[50]	Specifies the item reference number.	TableRelation Table 5777 “Item Reference” (“Item Reference”.“Reference No.” where(“Unit of Measure” = field(“[BC] Unit of Measure”), “Variant Code” = field(“[BC] Variant Code”)))
105	[BC] Variant Code	Code[10]	Specifies the variant code.	TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“[BC] Sales Line No.”)))
106	[BC] Shortcut Dimension 1 Code	Code[20]	Specifies the code for Shortcut Dimension 1.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
107	[BC] Shortcut Dimension 2 Code	Code[20]	Specifies the code for Shortcut Dimension 2.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
108	[BC] Dimension Set ID	Integer	Dimension Set ID caption	TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable

Keys

PK: E-Document Entry No., Line No. (clustered)

Procedures

GetNextLineNo(EDocumentEntryNo: Integer): Integer (internal)
InsertForEDocument(EDocumentEntryNo: Integer)
GetFromEDocument(EDocument: Record "E-Document")

Relations

[BC] Sales Line No.: TableRelation Table 15 “G/L Account” (conditional)
[BC] Unit of Measure: TableRelation Table 204 “Unit of Measure”
[BC] Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
[BC] Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
[BC] Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
[BC] Variant Code: TableRelation Table 5401 “Item Variant”
[BC] Sales Line No.: TableRelation Table 5600 “Fixed Asset” (conditional)
[BC] Item Reference No.: TableRelation Table 5777 “Item Reference”
E-Document Entry No.: TableRelation Table 6121 “E-Document”
[BC] Sales Line No.: TableRelation Table 7 “Standard Text” (conditional)

Pages and codeunits on this table

Page 6154 “E-Doc. Sales Draft Subform” (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: "E-Document Sales Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.