Table 10003 "Document Line" (CA)
CA country layer · Microsoft.eServices.EDocument
Across versions
- BC23-28not present
- BC29-30present
CA country layer · Microsoft.eServices.EDocument · BC29-30 · source at ea08af5e · facts from BC29
An object of the CA localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | Document Line |
| 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 | Sell-to/Buy-from No. | Code[20] | — | |
| 3 | Document No. | Code[20] | — | TableRelation “Document Header”.“No.” |
| 4 | Line No. | Integer | — | |
| 5 | Type | Enum “Sales Line Type” | — | enum Enum 37 “Sales Line Type” |
| 6 | No. | Code[20] | — | |
| 7 | Location Code | Code[10] | — | |
| 8 | Posting Group | Code[20] | — | |
| 11 | Description | Text[100] | — | |
| 12 | Description 2 | Text[50] | — | |
| 13 | Unit of Measure | Text[50] | — | |
| 15 | Quantity | Decimal | — | |
| 22 | Unit Price/Direct Unit Cost | Decimal | — | |
| 23 | Unit Cost (LCY) | Decimal | — | |
| 25 | VAT % | Decimal | — | |
| 27 | Line Discount % | Decimal | — | |
| 28 | Line Discount Amount | Decimal | — | |
| 29 | Amount | Decimal | — | |
| 30 | Amount Including VAT | Decimal | — | |
| 34 | Gross Weight | Decimal | — | |
| 89 | VAT Bus. Posting Group | Code[20] | — | |
| 90 | VAT Prod. Posting Group | Code[20] | — | |
| 5407 | Unit of Measure Code | Code[10] | — | |
| 10001 | Retention Attached to Line No. | Integer | — | |
| 10002 | Retention VAT % | Decimal | — | |
| 10003 | Custom Transit Number | Text[30] | — | |
| 10004 | SAT Customs Document Type | Code[10] | — |
Keys
- Key1: Document No., Line No. (clustered)
Triggers
OnInsert
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: "Document Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.
A CA country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.