AccountId | Account | Calculated (calculated) | | A denormalised copy of the parent invoice's customer, calculated as the invoice's AccountId converted to text. Note it is stored as a string rather than a key, so it is not a usable foreign key or lookup — join through the parent invoice instead. |
AllocatedQuantity | Allocated Quantity | Decimal | | What was still allocated, not picked or delivered, on the allocation line when this line was invoiced. Zero on lines with no allocation. |
Amount | Amount | Calculated (calculated) | | The line value after discounts: Base Amount less Net Discount, Net Scheme Discount and Additional Discount Share. With Apply Post Tax Discount it is Base Amount less the additional discount share, and the discounts come off Gross Amount instead. Becomes the GL Amount posted to the sales account. |
ApplyPostTaxDiscount | Apply Post Tax Discount | Boolean | | When ticked, discounts are worked out on base plus tax and taken off after tax, so they reduce Gross Amount rather than Amount. |
AssessableAmount | Assessable Amount | Calculated (calculated) | | |
AssetId | Asset | Lookup → Asset | | |
Barcode | Barcode | Text | | |
BaseAmount | Base Amount | Calculated (calculated) | | Quantity times the unit price (Unit Price (Alt) when above zero, else Unit Price). Unlike an order line, cancelled quantity is not deducted. |
BenefitIndex | Benefit Index | Number | | |
BillingFrequency | Billing Frequency | Text | | |
BillingType | Billing Type | Text | | |
BranchId | Branch | Text | | |
CancelledQuantity | Cancelled Quantity | Decimal | | Set to the full quantity when the invoice is cancelled. Not deducted from Base Amount. |
ChargeType | Charge Type | Text | | Values: One Time. |
ClaimLineId | Claim Line | Lookup → ClaimLine | | |
ContractDiscount | Contract Discount | Percent | | Contract discount percentage from the discount-group rule, 0 to 100. |
ContractDiscountAmount | Contract Discount Amount | Currency | | |
ConversionRatio | Conversion Ratio | Decimal | | |
ConversionRatio1 | Conversion Ratio 1 | Decimal | | |
CostPrice | Cost Price | Currency | | Dead: no code path anywhere populates it. An earlier invoice-time cost-of-goods-sold block summed this field and therefore always computed zero; it was removed deliberately, and cost of goods sold is now recognised at goods issue from engine cost instead. Do not use this field for margin. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
DeliveredQuantity | Delivered Quantity | Decimal | | What was already delivered from the allocation line before this line was invoiced. Zero on lines with no allocation. Delivery orders raised from the invoice count in Delivery Quantity instead. |
DeliveryOrderLineId | Delivery Order Line | Lookup → DeliveryOrderLine | | The delivery order line this line was invoiced from, on invoices created from a delivery order. |
DeliveryQuantity | Delivery Quantity | Decimal | | Total quantity on delivery order lines raised from this invoice line. |
Discount | Discount | Percent | | Regular discount percentage, 0 to 100. Taken from the invoice's Discount when that is set. |
Discount2 | Cash Discount | Percent | | Cash discount percentage, 0 to 100. |
DiscountAmount | Discount Amount | Currency | | It is one of three pairs (with Discount2/DiscountAmount2 and ContractDiscount/ContractDiscountAmount) that add up into NetDiscount. |
DiscountAmount2 | Cash Discount Amount | Currency | | |
DiscountGroupRuleId | Discount Group Rule | Lookup → DiscountGroupRule | | |
EligibleReturnQuantity | Eligible Return Quantity | Calculated (calculated) | | Quantity less Cancelled Quantity and Returned Quantity: what can still be returned on a credit note. |
ExternalId | External ID | Text | | |
FieldSalesId | Field Sales | Lookup → FieldSales | | |
FreeQuantity | FreeQuantity | Decimal | | Not an independently entered figure: it is the line's own Quantity when the line was generated by the promotional-scheme engine, and zero otherwise. It exists so free-goods lines can be reported without inspecting the scheme linkage, and it is both a stored column and a calculated fallback. |
GeneralLedgerId | General Ledger | Lookup → GeneralLedger | | |
GLAccountId | GL Account | Lookup → GLAccount | | Optional sales account for this line. When set it wins over posting definitions and the chart-of-accounts default sales account when the invoice is posted. |
GLAmount | GL Amount | Calculated (calculated) | | The value posted to the line's sales account; equal to Amount. |
GLPostingType | GL Posting Type | Text | | |
GrossAmount | Gross Amount | Calculated (calculated) | | Amount plus Tax Amount, less the discounts when Apply Post Tax Discount is on. This is what the line adds to the invoice total. |
HsnSacCode | HSN/SAC Code | Text | | The goods or services code used on GST returns and e-invoices. Copied from the item when blank and again when the item changes; must be 4, 6 or 8 digits. |
Id | Id | Guid | Yes | |
InventoryFulfilmentAllocationLineId | Inventory Fulfillment Allocation Line | Lookup → InventoryFulfilmentAllocationLine | | The allocation line this line was invoiced from, on lines invoiced from allocated stock. Decides which stock figures the inventory posting moves. |
InventoryLedgerId | Inventory Ledger | Lookup → InventoryLedger | | The inventory ledger entry the line posted. Set by Post Inventory on the invoice; while set, quantity or price changes re-post the stock movement. |
InvLineName | InvLineName (For E-invoice) | Text | | A system-generated line document name in the form INVL-ddMMyyyy followed by the last three digits of the sequence, reformatted from the name the document-naming service produced. It is stamped on insert and not maintained afterwards. |
InvoiceDiscount | Invoice Discount | Calculated (calculated) | | The invoice header's discount percentage, read from the invoice. |
InvoiceId | Sale Invoice | Lookup → Invoice | | The sales invoice the line belongs to. A new line, or a line moved to another invoice, is checked against that invoice's partner account and branch. |
IsClaimed | Claimed | Boolean | | The line has been included in a trade claim. |
IsGLPosted | GL Posted | Boolean | | |
IsGLPostingApproved | GL Posting Approved | Boolean | | |
IsILPosted | IL Posted | Boolean | | |
IsILPostingApproved | IL Posting Approved | Boolean | | Set when the line is posted to the inventory ledger. An asset-tracked item needs an Item Lot first. |
IsPriceBundled | Price Bundled | Boolean | | The line is priced inside its package, so its unit price must be zero. |
IsSchemeGenerated | Scheme Generated | Boolean | | The line was created by a scheme, such as a free item. |
ItemAliasId | Item Alias | Lookup → ItemAlias | | |
ItemAlternateId | Alternate Item | Lookup → ItemAlternate | | |
ItemComponentId | Item Component | Lookup → ItemComponent | | |
ItemId | Item | Lookup → Item | | The item billed. Required unless a Description is given. On creation it must be active and not a package-only component; a superseded item is swapped for its successor. It cannot be changed after the line is saved, and on a line created from an order it follows the order line. |
ItemLotId | Item Lot | Lookup → ItemLot | | The specific lot billed, limited to lots of the line's item and SKU. Set from the allocation line on lines invoiced from allocated stock. Required before inventory posting for an asset-tracked item. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | The lot category billed, limited to the item's lot types and used when matching price and tax rules. |
ItemName | Item Name | Text | | |
ItemServiceContractId | Service Contract | Lookup → ItemServiceContract | | |
LimitExpiryDays | Limit Expiry Days | Number | | |
LineNumber | Line Number | Text | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | | The line's own document number, generated on save from the Invoice Line Document Name Setting (series SIL, a date part and a six-digit counter). |
NetDiscount | Net Discount | Calculated (calculated) | | The regular, cash and contract discounts together. In each pair an amount above zero wins over the percentage; percentages apply to the base, or to base plus tax when Apply Post Tax Discount is on. |
NetSchemeDiscount | Net Scheme Discount | Calculated (calculated) | | The scheme benefit: Scheme Discount Amount when above zero, otherwise Scheme Discount percent of the base. |
OrderLineId | Order Line | Lookup → OrderLine | | The sales order line this line was invoiced from. The order line's Invoice Quantity, Allocated Invoiced Quantity and OTC Invoiced Quantity are summed from its invoice lines. |
OriginalAssetId | Original Asset | Lookup → Asset | | |
OriginalItemId | Original Item | Lookup → Item | | The item the line was entered with before it was replaced by its successor or a chosen alternate. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PackageInvoiceLineId | Package Invoice Line | Lookup → InvoiceLine | | The package line this component line belongs to. Deleting the package line deletes its components; a mandatory component cannot be deleted on its own. |
PackageOrderLineId | Package Order Line | Lookup → OrderLine | | |
PartnerAccountId | Partner Account | Calculated (calculated) | | A denormalised copy of the parent invoice's owning company, calculated as the invoice's PartnerAccountId converted to text. Like AccountId on this entity it is a string, not a key, so it cannot be used as a relation and exists only to make line-level queries filterable by company. |
PendingDeliveryQuantity | Pending Delivery Quantity | Calculated (calculated) | | Quantity less Cancelled Quantity and Delivered Quantity. The invoice's Delivery action needs at least one line above zero. |
PendingShipmentQuantity | Pending Shipment Quantity | Calculated (calculated) | | Quantity less Shipment Quantity. |
PickedQuantity | Picked Quantity | Decimal | | What was already picked on the allocation line when this line was invoiced. Zero on lines with no allocation. |
PriceAsOnDate | Price As On Date | Date | | The date prices are read for. Changing it re-prices the line. |
PriceListId | Price List | Lookup → PriceList | | The price list the line was priced from. Changing it re-prices the line. |
PriceListRuleId | Price List Rule | Lookup → PriceListRule | | The price-list rule that supplied the price. Changing it re-prices the line. |
Quantity | Quantity | Decimal | | Quantity billed. Defaults to 0 and must be above zero. It cannot be reduced below the returned quantity. Changing it re-taxes the line, re-evaluates schemes and re-posts stock already in the inventory ledger. |
RecordTypeId | Record Type | Guid, hidden | | |
RequestedQuantity | Requested Quantity | Decimal | | |
ReturnedQuantity | Returned Quantity | Decimal | | Total quantity on sale-return credit note lines raised against this line. Cannot exceed Quantity, and any returned quantity blocks deleting the line. |
RNAExternalId | RNA External ID | Text | | |
RNASaleInvoiceExternalId | RNA Sale Invoice External ID | Text | | |
SchemeBenefitId | Scheme Benefit | Lookup → SchemeBenefit | | |
SchemeDiscount | Scheme Discount | Percent | | Scheme discount percentage written by the scheme engine, 0 to 100. |
SchemeDiscountAmount | Scheme Discount Amount | Currency | | |
SchemeLineId | Scheme Slab | Lookup → SchemeLine | | |
SchemeRewardPoints | Scheme Reward Points | LargeNumber | | |
ServiceOrderLineId | Service Order Line | Lookup → ServiceOrderLine | | The service order line this line bills. |
ShipmentQuantity | Shipment Quantity | Decimal | | |
SkipScheme | Skip Scheme | Boolean | | Leaves this line out of scheme evaluation. |
SKUId | SKU | Lookup → SKU | | The item variant billed. Required for items that need a SKU and limited to the item's SKUs. It cannot be changed after the line is saved. |
SoftCommittedQuantity | Soft Committed Quantity | Calculated (calculated) | | The line's quantity when its source order line or service order line has an inventory ledger entry, otherwise zero. |
StorageLocationId | Storage Location | Lookup → StorageLocation | | |
SubscriptionId | Subscription | Lookup → Subscription | | |
SubscriptionUsageId | Subscription Usage | Lookup → SubscriptionUsage | | |
SubscriptionUsageSummaryId | Subscription Usage Summary | Lookup → SubscriptionUsageSummary | | |
Tax1 | Tax 1 | Currency | | The first of six generic tax-component slots, not a fixed tax type. Which component lands here is decided by the posting-field name configured on the Tax master in the line's tax group, so slot 1 might be CGST on one tenant and IGST on another. Every slot is cleared and recomputed whenever the line's taxes are recalculated. |
Tax1Name | Tax Name 1 | Text | | |
Tax1Rate | Tax Rate 1 | Currency | | |
Tax1Type | Tax Type 1 | Text | | A copy of the tax type from the Tax master that filled slot 1, stamped when the line's taxes were computed. Posting uses it to pick the tax account for the leg (an account whose subtype names this component wins over the generic tax account), and a slot with an empty type is skipped entirely at posting time even if its amount is non-zero. |
Tax2 | Tax 2 | Currency | | |
Tax2Name | Tax Name 2 | Text | | |
Tax2Rate | Tax Rate 2 | Currency | | |
Tax2Type | Tax Type 2 | Text | | |
Tax3 | Tax 3 | Currency | | |
Tax3Name | Tax Name 3 | Text | | |
Tax3Rate | Tax Rate 3 | Currency | | |
Tax3Type | Tax Type 3 | Text | | |
Tax4 | Tax 4 | Currency | | |
Tax4Name | Tax Name 4 | Text | | |
Tax4Rate | Tax Rate 4 | Currency | | |
Tax4Type | Tax Type 4 | Text | | |
Tax5 | Tax 5 | Currency | | |
Tax5Name | Tax Name 5 | Text | | |
Tax5Rate | Tax Rate 5 | Currency | | |
Tax5Type | Tax Type 5 | Text | | |
Tax6 | Tax 6 | Currency | | |
Tax6Name | Tax Name 6 | Text | | |
Tax6Rate | Tax Rate 6 | Currency | | |
Tax6Type | Tax Type 6 | Text | | |
TaxAmount | Tax Amount | Currency | | Total tax on the line, calculated from its tax group into the Tax 1 to Tax 6 slots. |
TaxGroupId | Tax Group | Lookup → TaxGroup | | The taxes that apply, picked from the tax rules when the line is created. Changing it re-taxes the line; on a line created from an order it cannot be changed. |
TdsSectionId | TDS Section | Lookup → TdsSection | | The tax-collected-at-source section for the line, offered on the finance quick-add form. Changing it recalculates the line's TCS. |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | The cost side of the line, copied from the inventory fulfilment allocation line when the invoice is built from allocated stock, so it reflects the lot or layer cost actually drawn. It does not participate in any price, discount or tax formula and is not what the cost-of-goods-sold journal uses. |
UnitPrice | Unit Price | Currency | | Price per unit, filled from the price list when left empty. Cannot be negative, and must be zero on a bundled package component. |
UnitPrice2 | Unit Price (Alt) | Currency | | Alternative unit price. When above zero it replaces Unit Price in Base Amount and in the tax calculation. Copied from the order line on invoiced lines. |
UOM | UOM | Text | | |
UOM1 | UOM1 | Text | | |
UOMQuantity | UOM Quantity | Decimal | | |
UOMQuantity1 | UOM Quantity 1 | Decimal | | |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
