transaction
The transaction table.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Internal ID | |
| abbrevtype | String | Abbrev. Type | |
| accountbasednumber | String | Account Based Number | |
| actionitem | String | Action Item | |
| actualproductionenddate | Date | Actual Production End Date | |
| actualproductionstartdate | Date | Actual Production Start Date | |
| actualshipdate | Date | Actual Shipping Date | |
| approvalstatus | String | Approval Status | |
| asofdate | Date | As of Date | |
| autocalculatelag | Boolean | Auto-calculate Lag | |
| billingaddress | String | Billing Address | |
| billingstatus | Boolean | Billing Status | |
| billofmaterials | String | Bill of Materials | |
| billofmaterialsrevision | String | Bill of Materials Revision | |
| buyingreason | String | Buying Reason | |
| buyingtimeframe | String | Buying Time Frame | |
| closedate | Date | Date Closed | |
| committed | Double | Buildable | |
| createdby | String | Created By | |
| createddate | Date | Date Created | |
| currency | String | Currency | |
| daysopen | Double | Days Open | |
| daysoverduesearch | Integer | Days Overdue | |
| duedate | Date | Due Date | |
| employee | String | Sales Rep | |
| enddate | Date | End Date | |
| entity | String | Entity | |
| entitystatus | String | Status (Customer) | |
| estgrossprofit | Decimal | Est. Gross Profit | |
| estgrossprofitpercent | Double | Est. Gross Profit Percent | |
| estimatedbudget | Decimal | Estimated Budget | |
| exchangerate | Decimal | Exchange Rate | |
| expectedclosedate | Date | Expected Close Date | |
| externalid | String | External ID | |
| firmed | Boolean | Firmed | |
| forecasttype | String | Forecast Type | |
| 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) | |
| foreigntotal | Decimal | Total Amount (Transaction Currency) | |
| fulfillmenttype | String | Fulfillment Type | |
| incoterm | String | Incoterm | |
| isactualprodenddateenteredmanually | Boolean | Enter Manually | |
| isactualprodstartdateenteredmanually | Boolean | Enter Manually | |
| isbookspecific | Boolean | Is Book Specific | |
| isbudgetapproved | Boolean | Budget Approved | |
| isfinchrg | Boolean | Finance Charge | |
| isreversal | Boolean | Is Reversal | |
| journaltype | String | Journal Type | |
| lastmodifiedby | String | Last Modified By | |
| lastmodifieddate | Date | Date Last Modified | |
| leadsource | String | Lead Source | |
| linkedtrackingnumberlist | String | Linked Tracking Numbers | |
| manufacturingrouting | String | Manufacturing Routing | |
| memdoc | String | Memorized Transaction Definition | |
| memo | String | Memo | |
| message | String | Message | |
| nextapprover | String | Next Approver | |
| nextbilldate | Date | Next Bill Date | |
| nexus | String | Nexus | |
| number | Long | Document Number | |
| opportunity | String | Opportunity | |
| ordpicked | Boolean | Picked | |
| ordreceived | Boolean | Order Received | |
| otherrefnum | String | PO/Check Number | |
| partner | String | Partner | |
| paymenthold | Boolean | Payment Hold | |
| paymentmethod | String | Payment Method | |
| paymentoption | String | Payment Option | |
| posting | Boolean | Posting | |
| postingperiod | String | Posting Period | |
| printedpickingticket | Boolean | Printed Picking Ticket | |
| probability | Double | Probability (%) | |
| projectedtotal | Decimal | Projected Total | |
| rangehigh | Decimal | Range High | |
| rangelow | Decimal | Range Low | |
| recordtype | String | Record Type | |
| reversal | String | Reversal Doc | |
| reversaldate | Date | Reversal Date | |
| salesreadiness | String | Sales Readiness | |
| schedulingmethod | String | Scheduling Method | |
| shipcomplete | Boolean | Ship Complete | |
| shipdate | Date | Ship Date | |
| shippingaddress | String | Shipping Address | |
| source | String | Source | |
| sourcetransaction | String | Source Transaction | |
| startdate | Date | Start Date | |
| status | String | Status | |
| terms | String | Terms | |
| title | String | Title | |
| tosubsidiary | String | To Subsidiary | |
| totalcostestimate | Decimal | Est. Cost | |
| trackingnumberlist | String | Tracking Numbers | |
| trandate | Date | Date | |
| trandisplayname | String | Transaction | |
| tranid | String | Document Number/ID | |
| transactionnumber | String | Transaction Number | |
| transferlocation | String | Destination Location | |
| type | String | Type | |
| typebaseddocumentnumber | String | Type Based Document Number | |
| useitemcostastransfercost | Boolean | Use Item Cost As Transfer Cost | |
| userevenuearrangement | Boolean | Generates Revenue Arrangement | |
| visibletocustomer | Boolean | Available In Customer Center | |
| void | Boolean | Void | |
| voided | Boolean | Voided | |
| website | String | Website | |
| weightedtotal | Decimal | Weighted Total | |
| winlossreason | String | Win/Loss Reason |