transactionLine
Stores individual line items within a financial transaction, detailing products, quantities, and pricing.
Columns
| Name | Type | References | Description |
| uniquekey [KEY] | Integer | Stores the unique key assigned to the transaction line, ensuring accurate record identification and tracking. | |
| id [KEY] | Integer | Represents the internal identifier of the transaction line, uniquely distinguishing it from other entries. | |
| actualshipdate | Date | Records the actual date when the item was shipped, received, or picked up, ensuring accurate logistics tracking. | |
| accountinglinetype | Date | Indicates the end date of the amortization schedule, ensuring proper revenue and expense recognition. | |
| amortizationresidual | String | Stores the remaining residual value after amortization calculations, aiding in financial forecasting. | |
| amortizationsched | String | Links the transaction line to the amortization schedule, ensuring structured cost allocation over time. | |
| amortizstartdate | Date | Records the start date of the amortization period, defining when financial adjustments begin. | |
| amountlinked | Decimal | Indicates the amount linked to this transaction line from related financial records, supporting reconciliations. | |
| assemblycomponent | Boolean | Determines whether the transaction line represents an assembly component. If the value is true, it is part of a bill of materials. | |
| billeddate | Date | Specifies the date when the transaction line was billed, ensuring accurate financial reporting and invoicing. | |
| billingschedule | String | Defines the billing schedule applied to this transaction line, managing installment or recurring billing scenarios. | |
| billvariancestatus | String | Tracks whether there is a variance in the billed amount compared to expected values, ensuring financial accuracy. | |
| blandedcost | Boolean | Indicates whether the transaction line includes landed costs. If the value is true, additional cost elements are considered in calculations. | |
| bomquantity | Decimal | Stores the quantity of components required per the bill of materials (BOM), used in manufacturing and cost tracking. | |
| buildvariance | Double | Represents the variance between planned and actual production quantities, ensuring accurate cost and inventory management. | |
| category | String | Specifies the expense category associated with the transaction line, enabling accurate financial classification. | |
| chargetype | String | Defines the type of charge applied to the transaction, such as freight, service fees, or handling charges. | |
| class | String | Indicates the classification of the transaction line, often used for reporting and financial segmentation. | |
| cleared | Boolean | Specifies whether the transaction line has been cleared for financial settlement. If the value is true, the transaction is reconciled. | |
| cleareddate | Date | Records the date when the transaction line was cleared, ensuring accurate reconciliation in financial reporting. | |
| commitinventory | String | Specifies how inventory commitment is handled for the transaction line, ensuring stock availability tracking. | |
| commitmentfirm | Boolean | Indicates whether the commitment is firm and cannot be altered. If the value is true, the inventory is allocated permanently. | |
| componentyield | Double | Records the expected yield percentage of components in production, used for inventory and cost management. | |
| costestimate | Decimal | Stores the estimated cost of the transaction line, aiding in budgeting and financial planning. | |
| costestimaterate | String | Represents the estimated cost rate applied to the transaction line, ensuring pricing consistency. | |
| costestimatetype | String | Defines the method used to estimate costs for the transaction line, supporting financial projections. | |
| createdfrom | String | Indicates the source from which this transaction line was generated, ensuring traceability in financial records. | |
| createdpo | String | Specifies whether the transaction line is linked to a special purchase order, used for tracking procurement processes. | |
| creditforeignamount | Decimal | Records the credited amount in the transaction’s foreign currency, ensuring accurate financial reconciliation for international transactions. | |
| debitforeignamount | Decimal | Records the debited amount in the transaction’s foreign currency, ensuring accurate international financial reporting. | |
| department | String | Specifies the department associated with the transaction line, supporting cost allocation and departmental tracking. | |
| documentnumber | String | Stores the document number assigned to the transaction, ensuring unique identification and reference. | |
| donotdisplayline | Boolean | Indicates whether the transaction line should be hidden from standard views. If the value is true, it is a technical entry. | |
| dropship | Boolean | Determines whether the item in the transaction is a drop-ship item. If the value is true, the item is shipped directly from the supplier. | |
| duetofromsubsidiary | Integer | Links the transaction line to an intercompany transaction between subsidiaries, ensuring proper accounting reconciliation. | |
| entity | String | Identifies the entity (such as a customer, vendor, or employee) associated with the transaction line, supporting financial tracking. | |
| estgrossprofit | Decimal | Stores the estimated gross profit for the transaction line, helping assess profitability at an item level. | |
| estgrossprofitpercent | Double | Calculates the estimated gross profit percentage for the transaction line, ensuring accurate profitability analysis. | |
| estimatedamount | Decimal | Represents the estimated amount for the transaction line, often used in budgeting and forecasting scenarios. | |
| expectedreceiptdate | Date | Specifies the expected date for receiving the items in the transaction, supporting inventory and logistics planning. | |
| expectedshipdate | Date | Indicates the expected shipping date for the items in the transaction, helping in order fulfillment tracking. | |
| expenseaccount | String | Defines the expense account associated with the transaction line, ensuring correct financial postings in the general ledger. | |
| foreignamount | Decimal | Stores the transaction amount in a foreign currency, ensuring proper exchange rate calculations and financial reporting. | |
| foreignamountpaid | Decimal | Indicates the amount that has been paid in the foreign currency of the transaction, ensuring accurate payment tracking. | |
| foreignamountunpaid | Decimal | Specifies the remaining unpaid amount in the transaction’s foreign currency, useful for outstanding balances. | |
| foreignpaymentamountunused | Decimal | Records the portion of a payment that remains unused in the transaction’s foreign currency. | |
| foreignpaymentamountused | Decimal | Indicates the amount of payment applied to the transaction in the foreign currency, ensuring accurate reconciliation. | |
| fulfillable | Boolean | Determines whether the transaction line contains items that need to be fulfilled. If the value is true, fulfillment is required. | |
| fxamountlinked | Decimal | Specifies the amount linked to another transaction in the foreign currency, ensuring correct inter-transaction tracking. | |
| hasfulfillableitems | Boolean | Indicates whether the transaction includes fulfillable items. If the value is true, at least one item requires fulfillment. | |
| inventorylocation | String | Defines the inventory location where the items in the transaction are stored, ensuring proper stock tracking. | |
| inventoryreportinglocation | String | Specifies the reporting location for inventory in multi-location warehouses, supporting inventory management. | |
| inventorysubsidiary | String | Links the transaction line to the subsidiary that owns the inventory, ensuring proper financial consolidation. | |
| isbillable | Boolean | Determines whether the transaction line is billable. If the value is true, the amount can be invoiced to the customer. | |
| isclosed | Boolean | Indicates whether the transaction line has been closed. If the value is true, no further modifications or processing is allowed. | |
| iscogs | Boolean | Determines whether the transaction line represents a cost of goods sold (COGS) entry, ensuring accurate expense tracking. | |
| isfullyshipped | Boolean | Specifies whether the items in the transaction have been fully shipped, received, or picked up. If the value is true, fulfillment is complete. | |
| isfxvariance | Boolean | Indicates whether the transaction line has a foreign exchange variance. If the value is true, currency conversion differences exist. | |
| isinventoryaffecting | Boolean | Indicates whether the transaction line affects inventory levels. If the value is true, stock adjustments occur. | |
| isrevrectransaction | Boolean | Determines if the transaction line is part of amortization or revenue recognition processes. | |
| isscrap | Boolean | Specifies whether the item in this transaction line is classified as scrap. If the value is true, it is not part of inventory valuation. | |
| item | String | Represents the item associated with the transaction line, ensuring proper product or service identification. | |
| itemtype | String | Defines the type of item recorded in the transaction line, such as inventory, service, or non-inventory. | |
| kitcomponent | Boolean | Indicates whether the transaction line is part of a kit or bundle. If the value is true, it is a kit component. | |
| kitmemberof | Integer | Identifies the parent transaction line that this component belongs to within a kit or bundle. | |
| landedcostcategory | String | Defines the landed cost category associated with the transaction line, such as shipping, duties, or handling fees. | |
| landedcostperline | Boolean | Determines whether landed costs are applied per line item. If the value is true, costs are allocated at a detailed level. | |
| linelastmodifieddate | Datetime | Records the date and time when the transaction line was last modified, ensuring accurate audit tracking. | |
| linesequencenumber | Integer | Stores the sequence number of the transaction line, ensuring proper order in multi-line transactions. | |
| location | String | Specifies the physical or logical location associated with the transaction line, often used for inventory tracking. | |
| mainline | Boolean | Indicates whether the transaction line represents the main transaction entry. If the value is true, it is the primary record. | |
| matchbilltoreceipt | Boolean | Specifies whether the transaction line is matched to a receipt for verification. If the value is true, it ensures billing accuracy. | |
| memo | String | Stores additional information or comments related to the transaction line, helping in documentation and reporting. | |
| netamount | Decimal | Represents the net amount of the transaction line after discounts and adjustments, recorded in the transaction currency. | |
| oldcommitmentfirm | Boolean | Indicates whether the previous inventory commitment was firm. If the value is true, changes were restricted. | |
| orderpriority | Double | Specifies the priority level assigned to the transaction line, helping in order fulfillment sequencing. | |
| paymentmethod | String | Defines the payment method associated with the transaction line, such as credit card, wire transfer, or cash. | |
| price | String | Specifies the price level applied to the transaction line, ensuring correct pricing based on customer agreements or tiers. | |
| processedbyrevcommit | Boolean | Determines whether the transaction line was processed by the revenue commitment module for financial recognition. | |
| quantity | Double | Stores the quantity of items or units associated with the transaction line, ensuring proper inventory and billing tracking. | |
| quantitybackordered | Double | Indicates the quantity of items that were backordered due to stock unavailability. | |
| quantitybilled | Double | Records the quantity of items that have been billed to the customer, ensuring correct invoicing. | |
| quantitycommitted | Double | Represents the quantity of items allocated to an order, ensuring stock is reserved for fulfillment. | |
| quantityonshipments | Double | Specifies the quantity of items currently assigned to outgoing shipments, ensuring accurate logistics tracking. | |
| quantitypicked | Double | Indicates the number of items that have been picked for order fulfillment but not yet shipped. | |
| quantityrejected | Double | Records the quantity of items that were rejected due to quality issues or discrepancies in the transaction. | |
| quantityshiprecv | Double | Represents the quantity of items that have been shipped, received, or picked up, ensuring accurate inventory tracking. | |
| rate | Decimal | Stores the rate applied to the transaction line, ensuring accurate pricing and financial calculations. | |
| requestdate | Date | Indicates the date when the item or service was requested, supporting scheduling and demand planning. | |
| requestnote | String | Stores additional notes related to the request, providing further details for internal processing. | |
| shipmethod | String | Defines the shipping method used for this transaction line, ensuring proper logistics coordination. | |
| specialorder | Boolean | Determines whether the transaction line item is classified as a special order. If the value is true, it requires unique handling. | |
| subsidiary | String | Identifies the subsidiary responsible for the transaction, ensuring accurate financial consolidation in multi-entity businesses. | |
| taxline | Boolean | Indicates whether the transaction line represents a tax entry. If the value is true, it is used for tax calculations. | |
| transaction | String | Links the transaction line to the main transaction record, ensuring accurate financial tracking and auditing. | |
| transactiondiscount | Boolean | Specifies whether the transaction line is subject to a discount. If the value is true, discounts apply to this line item. | |
| transactionlinetype | String | Defines the type of transaction line, such as sales, purchase, or journal entry, ensuring correct financial classification. | |
| transferorderitemlineid | Integer | Stores the unique identifier for the item line in a transfer order, ensuring proper tracking of stock movements. | |
| units | String | Defines the measurement units associated with the transaction line, such as pieces, kilograms, or hours. | |
| vsoeisestimate | Boolean | Determines whether the transaction line is an estimated value under Vendor-Specific Objective Evidence (VSOE) guidelines. |