AccountId | Account | Lookup → Account | | |
Amount | Amount | Calculated (calculated) | | Base amount less the net discount and net scheme discount: the line's taxable value and the amount posted to its debit account. Calculated. |
ApplyPostTaxDiscount | Apply Post Tax Discount | Boolean | Yes | When set, percent discounts are taken on the base amount plus tax instead of the base amount. |
BaseAmount | Base Amount | Calculated (calculated) | | Quantity times the unit cost (Unit Cost 2 when that is above zero, otherwise Unit Cost). Calculated. |
BenefitId | Scheme Benefit | Lookup → SchemeBenefit | | The scheme benefit that produced the line's scheme discount, filled by the scheme engine. |
BillId | Bill | Lookup → Bill | | The bill the line belongs to. Set when the line is created and cannot be changed afterwards. |
BranchId | Branch | Calculated (calculated) | | The bill's branch, calculated from the bill. |
CashDiscount | Cash Discount | Percent | | A value here therefore does not reduce Amount, GrossAmount or anything posted. |
CashDiscountAmount | Cash Discount Amount | Currency | | The explicit counterpart of the cash-discount rate, and equally unused: it appears in no discount formula and in no posting path, so recording it changes nothing about the line's value or the ledger. Treat it as documentation of terms, not as an amount that will be taken. |
ContractDiscount | Contract Discount | Percent | | A contract percent discount, 0 to 100, added to the net discount. Ignored when Contract Discount Amount is above zero. |
ContractDiscountAmount | Contract Discount Amount | Currency | | A fixed contract discount amount, used instead of Contract Discount when above zero. |
ConversionRatio | Conversion Ratio | LargeNumber | | |
ConversionRatio1 | Conversion Ratio 1 | LargeNumber | | |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
Description | Description | Text | | Free text for the line. Copied from the purchase-order line on order releases, otherwise typed. Used as the journal narration when the line has no item. |
Discount | Discount | Percent | | Percent discount on the line, 0 to 100. Ignored when Discount Amount is above zero. |
Discount2 | Discount 2 | Decimal | | A second percent discount, 0 to 100, added to the net discount. Ignored when Discount Amount 2 is above zero. |
DiscountAmount | Discount Amount | Currency | | A fixed discount amount. When above zero it is used instead of the Discount percent. |
DiscountAmount2 | Discount Amount 2 | Currency | | A second fixed discount amount, used instead of Discount 2 when above zero. |
EligibleReturnQuantity | Eligible Return Quantity | Calculated (calculated) | | Quantity less Returned Quantity: what can still be returned. Calculated. |
ExternalId | External | Text, unique | | |
GeneralLedgerId | General Ledger | Lookup → GeneralLedger | | A journal reference that cannot be edited by users. The bill's journal is linked to the bill itself. |
GLAccountId | GL Account | Lookup → GLAccount | | An explicit account to debit for the line. Wins over posting definitions and the chart's defaults. Copied from the purchase-order line on order releases. The picker is not filtered by company. |
GLAmount | GL Amount | Calculated (calculated) | | The amount posted to the general ledger for the line; equal to Amount. Calculated. |
GLPostingType | GL Posting Type | PickList | | Decides the debit account for a line that has no GL Account and no goods-receipt link: the value Inventory debits the inventory account, anything else or blank debits expense. The shipped picklist has no values, so an administrator adds them before users can choose one. |
GoodsReceiptLineId | Goods Receipt Line | Lookup → GoodsReceiptLine | | The goods-receipt line this line bills, set by Release Bill or by an order release after receipt. A line with it debits the goods-received-not-invoiced account when posted, and its stock posting moves the quantity off Inward. Cannot change once the line has been saved with a quantity. |
GrossAmount | Gross Amount | Calculated (calculated) | | Amount plus tax, less the discounts again when Apply Post Tax Discount is set. Calculated. Shown as Gross Amount in the lines list. |
HsnSacCode | HSN/SAC Code | Text | | The HSN or SAC code, copied from the item when the line is created and again when its item changes. For businesses in India a filled-in code must have 4, 6 or 8 digits. On no shipped form. |
Id | Id | Guid | Yes | |
InventoryLedgerId | Inventory Ledger | Lookup → InventoryLedger | | The inventory-ledger entry made for the line by Post Inventory. While set, a quantity or cost change re-posts the line's stock and deleting the line reverses it; Post Inventory skips lines that have it. |
InvoiceQuantity | Invoice Quantity | Calculated (calculated) | | Quantity less Returned Quantity: the quantity still billed after returns. Calculated. |
IsCustomerBillable | Customer Billable | Boolean | Yes | |
IsGLPosted | GL Posted | Boolean | Yes | A system flag that users cannot edit. |
IsGLPostingApproved | GL Posting Approved | Boolean | Yes | |
IsILPosted | IL Posted | Boolean | Yes | |
IsILPostingApproved | IL Posting Approved | Boolean | Yes | |
IsSchemeGenerated | Scheme Generated | Boolean | Yes | Set on lines that the scheme engine itself added to the document. |
ItemId | Item | Lookup → Item | | The item billed. Optional, so a line can be a description-only charge. A new line's item must be active and must not be a discount item. Cannot change once the line has been saved with a quantity, and never on a line that came from a goods receipt. |
ItemLotId | Item Lot | Lookup → ItemLot | | The stock lot billed. Copied from the goods-receipt line on released lines. Locked like Item. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | The lot type of the line. Copied from the goods-receipt line on released lines. |
ItemName | Item Name | Text | | Item name text used as the journal line narration when filled; the item itself is in Item. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | | The line number, generated on create from document numbering (shipped series BL, the date as DDMMYYYY and a six-digit counter). Shown as Bill Line Number in the lines list. |
NetDiscount | Net Discount | Calculated (calculated) | | The total of the line's discount, second discount and contract discount, each taken as the fixed amount when set or else the percent of the base amount. Calculated. |
NetSchemeDiscount | Net Scheme Discount | Calculated (calculated) | | The scheme discount as an amount: the fixed amount when set, otherwise the percent of the base amount. Calculated. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Calculated (calculated) | | The bill's partner account (your company), calculated from the bill. |
PriceAsOnDate | Price As On Date | Date | | The date prices are looked up for. Changing it reprices the line. |
PriceListId | Price List | Lookup → PriceList | | The price list the line was priced from. Changing it reprices the line. |
PriceListRuleId | Price List Rule | Lookup → PriceListRule | | The price-list rule that priced the line. Changing it reprices the line. |
PurchaseOrderLineId | Purchase Order Line | Lookup → PurchaseOrderLine | | The purchase-order line this line bills, set by Release Invoice. Its quantity counts as billed on that order line. Only lines with this link are counted by the three-way match. Cannot change once the line has been saved with a quantity. |
Quantity | Quantity | LargeNumber | | The quantity billed. Required on quick add (a whole number of at least 1). Cannot be negative or lower than the quantity already returned. The sum of bill-line quantities is the billed quantity on the source purchase-order and goods-receipt lines, so changing or deleting it releases quantity back to them. |
RecordTypeId | Record Type | Guid, hidden | | |
ReturnedQuantity | Returned Quantity | LargeNumber | | Quantity returned to the supplier against this line, rolled up from the lines of vendor credits (bill returns) that name it. A line with a returned quantity cannot be deleted. |
SchemeDiscount | Scheme Discount | Percent | | Percent scheme discount, 0 to 100. Bill lines run through the scheme engine like sales lines, which can fill it. |
SchemeDiscountAmount | Scheme Discount Amount | Currency | | A fixed scheme discount amount, used instead of the Scheme Discount percent when above zero. |
SchemeLineId | Scheme Line | Lookup → SchemeLine | | The scheme line that applied to this line, filled by the scheme engine. |
SchemeRewardPoints | Scheme Reward Points | LargeNumber | | |
SkipScheme | Skip Scheme | Boolean | | When set, the scheme engine leaves the line out. |
SKUId | SKU | Lookup → SKU | | The item's SKU. Required when the item requires a SKU, and must be one of the item's SKUs (the picker is filtered to them). Locked like Item. |
StorageLocationId | Storage Location | Lookup → StorageLocation | | The storage location used for the line's stock entry when Post Inventory runs. |
Tax1 | Tax1 | Currency | | Tax amount of the line's first tax component, from its tax group. Tax2 to Tax6 hold the further components (for example cess) the same way. |
Tax1Name | Tax1 Name | Text | | Name of the first tax component, such as CGST, copied from the tax group. |
Tax1Rate | Tax1 Rate | Currency | | Rate of the first tax component, copied from the tax group. |
Tax1Type | Tax1 Type | Text | | Type of the first tax component. A component with no type is not posted to the general ledger. |
Tax2 | Tax2 | Currency | | |
Tax2Name | Tax2 Name | Text | | |
Tax2Rate | Tax2 Rate | Currency | | |
Tax2Type | Tax2 Type | Text | | |
Tax3 | Tax3 | Currency | | |
Tax3Name | Tax3 Name | Text | | |
Tax3Rate | Tax3 Rate | Currency | | |
Tax3Type | Tax3 Type | Text | | |
Tax4 | Tax4 | Currency | | |
Tax4Name | Tax4 Name | Text | | |
Tax4Rate | Tax4 Rate | Currency | | |
Tax4Type | Tax4 Type | Text | | |
Tax5 | Tax5 | Currency | | |
Tax5Name | Tax5 Name | Text | | |
Tax5Rate | Tax5 Rate | Currency | | |
Tax5Type | Tax5 Type | Text | | |
Tax6 | Tax6 | Currency | | |
Tax6Name | Tax6 Name | Text | | |
Tax6Rate | Tax6 Rate | Currency | | |
Tax6Type | Tax6 Type | Text | | |
TaxAmount | Tax Amount | Currency | | The line's total tax from its tax components. Rounded per document when the Finance tax-rounding setting is Document. |
TaxGroupId | Tax Group | Lookup → TaxGroup | | The line's tax group. Its taxes are recalculated when Tax Group, Item, SKU, Quantity or Amount change. Copied from the source line on releases, and cannot be changed on a line that came from a goods receipt. |
TdsSectionId | TDS Section | Lookup → TdsSection | | The TDS section for withholding on this line, labelled TDS/TCS Section on the form. Defaulted from the vendor's default section on new lines. Tax is deducted when the bill posts if the section's deduction point is the bill, otherwise at payment. |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | The cost per unit. A cost typed on a new line is kept; an empty one is filled from the bill's price list when a rule matches. Changing the line's Price List or Price As On Date reprices it and replaces a typed cost. Description-only lines released from a purchase order keep the order's cost. |
UnitCost2 | Unit Cost 2 | Decimal | | An override cost. When above zero it is used instead of Unit Cost for the base amount. Filled from the matching price-list rule's second price when the line is priced; on no shipped form. |
UOM | UOM | Text | | Unit of measure text for the quantity. |
UOM1 | UOM1 | PickList | | An alternative unit of measure. Quantity is recalculated from the unit quantities when they change. |
UOMQuantity | UOM Quantity | LargeNumber | | Quantity in the line's unit of measure. Changing it recalculates Quantity. |
UOMQuantity1 | UOM Quantity 1 | LargeNumber | | Quantity in the alternative unit of measure. Changing it recalculates Quantity. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
