transactionLine
The transactionLine table.
Columns
| Name | Type | References | Description |
| uniquekey [KEY] | Integer | Unique Key | |
| id [KEY] | Integer | ID | |
| actualshipdate | Date | Actual Ship/Receipt/Pickup Date | |
| accountinglinetype | Date | Amort. End Date | |
| amortizationresidual | String | Residual | |
| amortizationsched | String | Amort. Schedule | |
| amortizstartdate | Date | Amort. Start Date | |
| amountlinked | Decimal | Amount Linked | |
| assemblycomponent | Boolean | Assembly Component | |
| billeddate | Date | Date Billed | |
| billingschedule | String | Billing Schedule | |
| billvariancestatus | String | Bill Variance Status | |
| blandedcost | Boolean | Landed Cost | |
| bomquantity | Decimal | BOM Quantity | |
| buildvariance | Double | Build Variance | |
| category | String | Expense Category | |
| chargetype | String | Charge Type | |
| class | String | Class | |
| cleared | Boolean | Cleared | |
| cleareddate | Date | Date Cleared | |
| commitinventory | String | Commit | |
| commitmentfirm | Boolean | Commitment Confirmed | |
| componentyield | Double | Component Yield | |
| costestimate | Decimal | Est. Cost | |
| costestimaterate | String | Est. Rate | |
| costestimatetype | String | Cost Estimate Type | |
| createdfrom | String | Created From | |
| createdpo | String | Special Order | |
| creditforeignamount | Decimal | Amount (Credit) (Transaction Currency) | |
| debitforeignamount | Decimal | Amount (Debit) (Transaction Currency) | |
| department | String | Department | |
| documentnumber | String | Document Number | |
| donotdisplayline | Boolean | Technical Line | |
| dropship | Boolean | Drop Ship Item | |
| duetofromsubsidiary | Integer | DueToFromSubsidiary | |
| entity | String | Entity | |
| estgrossprofit | Decimal | Est. Gross Profit | |
| estgrossprofitpercent | Double | Est. Gross Profit Percent | |
| estimatedamount | Decimal | Estimated Amount | |
| expectedreceiptdate | Date | Expected Receipt Date | |
| expectedshipdate | Date | Expected Ship Date | |
| expenseaccount | String | Expense Account | |
| foreignamount | Decimal | Amount (Transaction Currency) | |
| foreignamountpaid | Decimal | Amount Paid (Transaction Currency) | |
| foreignamountunpaid | Decimal | Amount Unpaid (Transaction Currency) | |
| foreignpaymentamountunused | Decimal | Payment Amount Unused (Transaction Currency) | |
| foreignpaymentamountused | Decimal | Payment Amount Used (Transaction Currency) | |
| fulfillable | Boolean | To Be Fulfilled / Received | |
| fxamountlinked | Decimal | Amount Linked (Transaction Currency) | |
| hasfulfillableitems | Boolean | Fulfillable | |
| inventorylocation | String | Inventory Location | |
| inventoryreportinglocation | String | Inventory Reporting Location | |
| inventorysubsidiary | String | Inventory Subsidiary | |
| isbillable | Boolean | Billable | |
| isclosed | Boolean | Closed | |
| iscogs | Boolean | Is COGS | |
| isfullyshipped | Boolean | Fully Shipped/Received/Picked Up | |
| isfxvariance | Boolean | Is Fx Variance | |
| isinventoryaffecting | Boolean | Inventory Affecting | |
| isrevrectransaction | Boolean | Is Amortization/Revenue Recognition | |
| isscrap | Boolean | Is Scrap | |
| item | String | Item | |
| itemtype | String | Item Type | |
| kitcomponent | Boolean | Kit Component | |
| kitmemberof | Integer | Member of Line | |
| landedcostcategory | String | Landed Cost Category | |
| landedcostperline | Boolean | Landed Cost per Line | |
| linelastmodifieddate | Datetime | Line Last Modified Date | |
| linesequencenumber | Integer | Line Number | |
| location | String | Location | |
| mainline | Boolean | Main Line | |
| matchbilltoreceipt | Boolean | Match Bill To Receipt | |
| memo | String | Memo | |
| netamount | Decimal | Amount (Net) (Transaction Currency) | |
| oldcommitmentfirm | Boolean | -No label- | |
| orderpriority | Double | Order Priority | |
| paymentmethod | String | Payment Method | |
| price | String | Price Level | |
| processedbyrevcommit | Boolean | Processed by Rev Commit | |
| quantity | Double | Quantity | |
| quantitybackordered | Double | Back Ordered | |
| quantitybilled | Double | Quantity Billed | |
| quantitycommitted | Double | Committed | |
| quantityonshipments | Double | Quantity On Shipments | |
| quantitypicked | Double | Quantity Picked | |
| quantityrejected | Double | Quantity Rejected | |
| quantityshiprecv | Double | Quantity Shipped/Received/Picked Up | |
| rate | Decimal | Rate | |
| requestdate | Date | Requested Date | |
| requestnote | String | Request Note | |
| shipmethod | String | Ship Via | |
| specialorder | Boolean | Special Order Item | |
| subsidiary | String | Subsidiary | |
| taxline | Boolean | Tax Line | |
| transaction | String | Transaction | |
| transactiondiscount | Boolean | Transaction Discount | |
| transactionlinetype | String | Line Type | |
| transferorderitemlineid | Integer | Transfer Order Item Line Id | |
| units | String | Units | |
| vsoeisestimate | Boolean | Estimate |