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 | |
| altsalestotal | Decimal | Alt. Sales Total | |
| approvalstatus | Integer | Approval Status | |
| asofdate | Date | As of Date | |
| autocalculatelag | Boolean | Auto-calculate Lag | |
| balsegstatus | Integer | Balanced by Segments | |
| billingaddress | String | Billing Address | |
| billingstatus | Boolean | Billing Status | |
| billofmaterials | Integer | Bill of Materials | |
| billofmaterialsrevision | Integer | Bill of Materials Revision | |
| buyingreason | Integer | Buying Reason | |
| buyingtimeframe | Integer | Buying Time Frame | |
| closedate | Date | Date Closed | |
| committed | Double | Buildable | |
| createdby | Integer | Created By | |
| createddate | Date | Date Created | |
| currency | Integer | Currency | |
| custbody_cseg1 | Integer | MySegment | |
| custbody_cseg2 | Integer | OtherCustomSegment | |
| custbody_cseg3 | Integer | TestSegment | |
| custbody_cseg4 | Integer | Sub-channel | |
| customform | String | Custom Form | |
| daysopen | Double | Days Open | |
| daysoverduesearch | Integer | Days Overdue | |
| duedate | Date | Due Date | |
| String | |||
| employee | Integer | Sales Rep | |
| enddate | Date | End Date | |
| entity | Integer | Entity | |
| entitystatus | Integer | Status (Customer) | |
| estgrossprofit | Decimal | Est. Gross Profit | |
| estgrossprofitpercent | Double | Est. Gross Profit Percent | |
| estimatedbudget | Decimal | Estimated Budget | |
| exchangerate | String | Exchange Rate | |
| expectedclosedate | Date | Expected Close Date | |
| externalid | String | External ID | |
| fax | String | Fax | |
| firmed | Boolean | Firmed | |
| forecasttype | Integer | 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 | Integer | Fulfillment Type | |
| incoterm | Integer | 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 | |
| iswip | Boolean | WIP | |
| journaltype | String | Journal Type | |
| lastmodifiedby | Integer | Last Modified By | |
| lastmodifieddate | Datetime | Date Last Modified | |
| leadsource | Integer | Lead Source | |
| linkedpo | String | Linked PO | |
| manufacturingrouting | Integer | Manufacturing Routing | |
| memdoc | Integer | Memorized Transaction Definition | |
| memo | String | Memo | |
| message | String | Message | |
| nextapprover | Integer | Next Approver | |
| nextbilldate | Date | Next Bill Date | |
| nexus | Integer | Nexus | |
| number | Double | Document Number | |
| opportunity | Integer | Opportunity | |
| ordpicked | Boolean | Picked | |
| ordreceived | Boolean | Order Received | |
| otherrefnum | String | PO/Check Number | |
| partner | Integer | Partner | |
| paymenthold | Boolean | Payment Hold | |
| paymentmethod | Integer | Payment Method | |
| paymentoption | Integer | Payment Option | |
| posting | Boolean | Posting | |
| postingperiod | Integer | 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 | Integer | Reversal Doc | |
| reversaldate | Date | Reversal Date | |
| salesreadiness | Integer | Sales Readiness | |
| schedulingmethod | String | Scheduling Method | |
| shipcomplete | Boolean | Ship Complete | |
| shipdate | Date | Ship Date | |
| shippingaddress | String | Shipping Address | |
| source | String | Source | |
| sourcetransaction | Integer | Source Transaction | |
| startdate | Date | Start Date | |
| status | String | Status | |
| terms | Integer | Terms | |
| title | String | Title | |
| tosubsidiary | Integer | To Subsidiary | |
| totalcostestimate | Decimal | Est. Cost | |
| trandate | Date | Date | |
| trandisplayname | String | Transaction | |
| tranid | String | Document Number/ID | |
| transactionnumber | String | Transaction Number | |
| transferlocation | Integer | 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 | Integer | Website | |
| weightedtotal | Decimal | Weighted Total | |
| winlossreason | Integer | Win/Loss Reason |