Table 46881 "BC14 Posted Sales Inv Line"
HybridBC14 · Microsoft.DataMigration.BC14Reimplementation
Across versions
- BC23-28not present
- BC29-30present
HybridBC14 · Microsoft.DataMigration.BC14Reimplementation · captioned “Posted Sales Invoice Line Migration Data” · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Posted Sales Invoice Line Migration Data |
| 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 | Document No. | Code[20] | — | |
| 2 | Line No. | Integer | — | |
| 3 | Type | Option | — | OptionCaption: ,G/L Account,Item,Resource,Fixed Asset,Charge (Item) |
| 4 | No. | Code[20] | — | |
| 5 | Description | Text[100] | — | |
| 6 | Description 2 | Text[50] | — | |
| 10 | Quantity | Decimal | — | |
| 11 | Unit of Measure Code | Code[10] | — | |
| 12 | Qty. per Unit of Measure | Decimal | — | |
| 20 | Unit Price | Decimal | — | |
| 21 | Line Discount % | Decimal | — | |
| 22 | Line Discount Amount | Decimal | — | |
| 23 | Amount | Decimal | — | |
| 24 | Amount Including VAT | Decimal | — | |
| 30 | Shortcut Dimension 1 Code | Code[20] | — | |
| 31 | Shortcut Dimension 2 Code | Code[20] | — | |
| 40 | VAT % | Decimal | — | |
| 41 | VAT Base Amount | Decimal | — | |
| 50 | Location Code | Code[10] | — | |
| 60 | Gen. Bus. Posting Group | Code[20] | — | |
| 61 | Gen. Prod. Posting Group | Code[20] | — | |
| 62 | VAT Bus. Posting Group | Code[20] | — | |
| 63 | VAT Prod. Posting Group | Code[20] | — | |
| 70 | Bin Code | Code[20] | — |
Keys
- PK: Document No., Line No. (clustered)
- ItemNo: No.
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: "BC14 Posted Sales Inv Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.