Table 28072 "Sales Tax Invoice Line" (NZ)

NZ country layer · Microsoft.Finance.WithholdingTax · BC29-30 · source at ea08af5e · facts from BC29

An object of the NZ localization, not part of W1.

Properties

Property	Value
Caption	Sales Tax Invoice 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 Customer No.	Code[20]	—	TableRelation Customer; not editable
3	Document No.	Code[20]	—	TableRelation Sales Tax Invoice Header
4	Line No.	Integer	—
5	Type	Option	—	OptionCaption: ,G/L Account,Item,Resource,Fixed Asset,Charge (Item)
6	No.	Code[20]	—	TableRelation if (Type = const(“G/L Account”)) “G/L Account” else if (Type = const(Item)) Item else if (Type = const(Resource)) Resource else if (Type = const(“Fixed Asset”)) “Fixed Asset” else if (Type = const(“Charge (Item)”)) “Item Charge”
7	Location Code	Code[10]	—	TableRelation Location where(“Use As In-Transit” = const(false))
8	Posting Group	Code[20]	—	TableRelation if (Type = const(Item)) “Inventory Posting Group” else if (Type = const(“Fixed Asset”)) “FA Posting Group”; not editable
10	Shipment Date	Date	—
11	Description	Text[100]	—
12	Description 2	Text[50]	—
13	Unit of Measure	Text[50]	—
15	Quantity	Decimal	—
22	Unit Price	Decimal	—
23	Unit Cost (LCY)	Decimal	—
25	VAT %	Decimal	—	not editable
27	Line Discount %	Decimal	—
28	Line Discount Amount	Decimal	—
29	Amount	Decimal	—
30	Amount Including VAT	Decimal	—
32	Allow Invoice Disc.	Boolean	—
34	Gross Weight	Decimal	—
35	Net Weight	Decimal	—
36	Units per Parcel	Decimal	—
37	Unit Volume	Decimal	—
38	Appl.-to Item Entry	Integer	—
40	Shortcut Dimension 1 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
41	Shortcut Dimension 2 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
42	Customer Price Group	Code[10]	—	TableRelation Customer Price Group
45	Job No.	Code[20]	—	TableRelation Job
46	Appl.-to Job Entry	Integer	—
50	Job Applies-to ID	Code[20]	—
51	Apply and Close (Job)	Boolean	—
52	Work Type Code	Code[10]	—	TableRelation Work Type
68	Bill-to Customer No.	Code[20]	—	TableRelation Customer; not editable
69	Inv. Discount Amount	Decimal	—
73	Drop Shipment	Boolean	—
74	Gen. Bus. Posting Group	Code[20]	—	TableRelation Gen. Business Posting Group
75	Gen. Prod. Posting Group	Code[20]	—	TableRelation Gen. Product Posting Group
77	VAT Calculation Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”
78	Transaction Type	Code[10]	—	TableRelation Transaction Type
79	Transport Method	Code[10]	—	TableRelation Transport Method
80	Attached to Line No.	Integer	—	TableRelation “Sales Invoice Line”.“Line No.” where(“Document No.” = field(“Document No.”))
81	Exit Point	Code[10]	—	TableRelation Entry/Exit Point
82	Area	Code[10]	—	TableRelation Area
83	Transaction Specification	Code[10]	—	TableRelation Transaction Specification
85	Tax Area Code	Code[20]	—	TableRelation Tax Area
86	Tax Liable	Boolean	—
87	Tax Group Code	Code[20]	—	TableRelation Tax Group
89	VAT Bus. Posting Group	Code[20]	—	TableRelation VAT Business Posting Group
90	VAT Prod. Posting Group	Code[20]	—	TableRelation VAT Product Posting Group
97	Blanket Order No.	Code[20]	—	TableRelation “Sales Header”.“No.” where(“Document Type” = const(“Blanket Order”))
98	Blanket Order Line No.	Integer	—	TableRelation “Sales Line”.“Line No.” where(“Document Type” = const(“Blanket Order”), “Document No.” = field(“Blanket Order No.”))
99	VAT Base Amount	Decimal	—	not editable
100	Unit Cost	Decimal	—	not editable
103	Line Amount	Decimal	—
104	VAT Difference	Decimal	—
106	VAT Identifier	Code[20]	—	not editable
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable
5402	Variant Code	Code[10]	—	TableRelation if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”))
5403	Bin Code	Code[20]	—	TableRelation Bin.Code where(“Location Code” = field(“Location Code”), “Item Filter” = field(“No.”), “Variant Filter” = field(“Variant Code”))
5404	Qty. per Unit of Measure	Decimal	—	not editable
5407	Unit of Measure Code	Code[10]	—	TableRelation if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else “Unit of Measure”
5415	Quantity (Base)	Decimal	—
5600	FA Posting Date	Date	—
5602	Depreciation Book Code	Code[10]	—	TableRelation Depreciation Book
5605	Depr. until FA Posting Date	Boolean	—
5612	Duplicate in Depreciation Book	Code[10]	—	TableRelation Depreciation Book
5613	Use Duplication List	Boolean	—
5700	Responsibility Center	Code[10]	—	TableRelation Responsibility Center
5705	Cross-Reference No.	Code[20]	—
5706	Unit of Measure (Cross Ref.)	Code[10]	—	TableRelation if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”))
5707	Cross-Reference Type	Option	—	OptionCaption: ,Customer,Vendor,Bar Code
5708	Cross-Reference Type No.	Code[30]	—
5709	Item Category Code	Code[20]	—	TableRelation if (Type = const(Item)) “Item Category”
5710	Nonstock	Boolean	Catalog caption
5711	Purchasing Code	Code[10]	—	TableRelation Purchasing
5712	Product Group Code	Code[10]	—	obsolete Removed 28.0; #if not CLEANSCHEMA28
5811	Appl.-from Item Entry	Integer	—
6608	Return Reason Code	Code[10]	—	TableRelation Return Reason
7001	Allow Line Disc.	Boolean	—
7002	Customer Disc. Group	Code[20]	—	TableRelation Customer Discount Group
28040	WHT Business Posting Group	Code[20]	—	TableRelation WHT Business Posting Group
28041	WHT Product Posting Group	Code[20]	—	TableRelation WHT Product Posting Group
28042	WHT Absorb Base	Decimal	—
28070	Paid Amount Incl. VAT	Decimal	—
28071	Paid VAT	Decimal	—
28073	External Document No.	Code[35]	—

Keys

Key1: Document No., Line No. (clustered)
Key2: Blanket Order No., Blanket Order Line No.
Key3: Sell-to Customer No., Type, Document No.
Key4: Sell-to Customer No.
Key5: Document No., WHT Business Posting Group, WHT Product Posting Group

Procedures

GetCurrencyCode(): Code[10]
ShowDimensions()
ShowItemTrackingLines()
CalcVATAmountLines(var SalesInvHeader: Record "Sales Invoice Header"; var VATAmountLine: Record "VAT Amount Line")
RowID1(): Text[250]
ShowSalesInvoice1()
TransferFieldsFrom(SalesInvoiceLine: Record "Sales Invoice Line")
TransferFieldsFrom(SalesCrMemoLine: Record "Sales Cr.Memo Line")

Plus 2 local procedures.

Deprecations

field Product Group Code: Removed 28.0 (#if not CLEANSCHEMA28), “Product Groups became first level children of Item Categories.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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: "Sales Tax Invoice Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A NZ country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.