Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table contains all order level information about a transaction.

Information on Table Data

  • ClassTypeIDs in Table:
    • 10000 - Order/Estimate/Template/Service Tickets
    • 11000 - Purchase Order/Bill/Receiving Document
  • TransactionTypes in Table:
    • 1 - Order
    • 2 - Estimate
    • 3 - Recurring Order
    • 4 - Credit Memo
    • 5 - ?
    • 6 - Service Ticket
    • 7 - Purchase Order
    • 8 - Bill
    • 9 - Receiving Document
    • 10 - Vendor Credit Memo
  • StatusIDs in Table (corresponding transaction type):
    • 0 - New
    • 1 - WIP (order, service ticket)
    • 2 - Built (order)
    • 3 - Sale (order, service ticket)
    • 4 - Closed (order, service ticket, bill, receiving document)
    • 6 - Open (PO, bill)
    • 9 - Voided (order, credit memo, bill, vendor credit memo, receiving document)
    • 11 - Pending (estimate)
    • 12 - Lost (estimate)
    • 13 - Converted (estimate)
    • 14 - Voided (estimate)
    • 20 - Credit Memo (credit memo)
    • 21 - Recurring Order (recurring order)
    • 24 - Vendor Credit Memo (vendor credit memo)
    • 25 - Requested (PO)
    • 26 - Approved (PO)
    • 27 - Ordered (PO)
    • 28 - Closed (PO)
    • 29 - Cancelled (PO)
    • 30 - Rejected (PO)
    • 31 - Received (PO)

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
TransHeader.AccountID int ID of the Customer Account Account.ID
TransHeader.AccountStoreID int Not Used.
TransHeader.ApprovedByID int Employee.ID
TransHeader.ApprovedDate datetime
TransHeader.AssignedToID int Employee.ID
TransHeader.AssociatedOrderNumber int TransHeader.OrderNumber
TransHeader.AuthAmount decimal(18, 4) The amount of the pre-authorization on an order
TransHeader.AuthExpirationDT datetime The date the pre-authorization expires.
TransHeader.AuthCCTransactionID Int ID of the credit card transaction that processed the pre-authorization CCTransaction.ID
TransHeader.BalanceDue decimal(18, 4)
TransHeader.BasePrice decimal(18, 4)
TransHeader.BillDate datetime
TransHeader.BillNumber int
TransHeader.BuiltDate datetime
TransHeader.ClassTypeID int Identifier for the Type of Object
TransHeader.ClosedDate datetime
TransHeader.ContactID int AccountContact.ID
TransHeader.ConvertedDate datetime
TransHeader.CreditMemoAmount float
TransHeader.CreditMemoOrderID int
TransHeader.DefaultOrderClassTypeID int
TransHeader.DefaultOrderID int
TransHeader.DefaultOrderItemClassTypeID int
TransHeader.DefaultOrderItemID int
TransHeader.Description text
TransHeader.DiscountLevel float
TransHeader.DiscountLevelOverridden bit
TransHeader.DiscountPrice decimal(18, 4)
TransHeader.DispositionID int
TransHeader.DivisionID int ID of the Division for this Transaction EmployeeGroup.ID
TransHeader.DivisionIDOverridden bit
TransHeader.DroppedDate datetime
TransHeader.DueDate datetime
TransHeader.EarlyPaymentDiscountOVAmount float
TransHeader.EnteredByID int Employee.ID
TransHeader.EstimateCreatedDate datetime
TransHeader.EstimateGreeting text
TransHeader.EstimateGreetingTemplate text
TransHeader.EstimateNumber int
TransHeader.ExpectedPayClassTypeID int
TransHeader.ExpectedPayID int
TransHeader.FinanceChargeAmount decimal(18, 4)
TransHeader.HTMLLongFormat text
TransHeader.HTMLShortFormat text
TransHeader.ID int Primary Key for the Table
TransHeader.InvoiceAddressID int Address.ID
TransHeader.InvoiceAddressLinkID int
TransHeader.InvoiceAddressOverridden bit
TransHeader.InvoiceCompanyID int Account.ID
TransHeader.InvoiceCompanyOV bit
TransHeader.InvoiceContactID int AccountContact.ID
TransHeader.InvoiceContactOV bit
TransHeader.InvoiceNumber int
TransHeader.IsActive bit Not Used for This Table
TransHeader.IsDirty bit
TransHeader.IsEarlyPaymentDiscountOV bit
TransHeader.IsFirmDueDate bit
TransHeader.IsSystem bit Used to Mark Required Records
TransHeader.IsTaxExempt bit
TransHeader.IsValidTax bit
TransHeader.JobGroupingType TinyInt
TransHeader.JobGroupingTypeOV Bit
TransHeader.LastFinanceChargeDate datetime
TransHeader.LastRecurrence datetime
TransHeader.ManuallyReOpened bit
TransHeader.ModifiedByComputer nvarchar(25) HostName of computer that last modified this record
TransHeader.ModifiedByUser nvarchar(25) Windows User who last modified this record
TransHeader.ModifiedDate datetime DateTime this Record was last modified
TransHeader.ModifierPrice decimal(18, 4)
TransHeader.NextRefNumber int
TransHeader.OrderCreatedDate datetime
TransHeader.OrderedByID int
TransHeader.OrderedDate datetime
TransHeader.OrderNotes text
TransHeader.OrderNotesTemplate text
TransHeader.OrderNumber int
TransHeader.OrderOriginID int
TransHeader.OrderOriginName nchar(25)
TransHeader.OrderTemplateNumber int
TransHeader.PaymentTotal decimal(18, 4)
TransHeader.PayrollClassTypeID int
TransHeader.PayrollID int
TransHeader.PercentComplete float Default value for child TransDetails
TransHeader.PONumber nvarchar(25) Customer's Purchase Order Number
TransHeader.POPaymentTermsID int links to PaymentTerms.ID
TransHeader.POShippingMethodID int before version 04.50.1107.2101: links to Element.ID and Element.ClassTypeID 6130
version 04.50.1107.2101 +: links to ShippingMethod.ID
TransHeader.PricingLevel float
TransHeader.PricingLevelID int
TransHeader.PricingLevelOverridden bit
TransHeader.ProductionDivisionID int The ID of the Production Division on the Production tab EmployeeGroup
TransHeader.ProductionNotes text
TransHeader.ProductionNotesTemplate text
TransHeader.PromotionID int
TransHeader.ProofDate datetime
TransHeader.PurchaseOrderNumber int Your Purchase Order Number
TransHeader.RawSubTotalPrice decimal(18, 4)
TransHeader.ReceivedByID int Employee.ID
TransHeader.ReceivedDate datetime
TransHeader.ReceivingDocNumber int
TransHeader.RecurrenceEndDate datetime
TransHeader.RecurrenceStartDate datetime
TransHeader.RecurrenceType int
TransHeader.RejectedDate datetime Date the estimate was marked Lost
TransHeader.RequestedByID int Employee.ID
TransHeader.RequestedDate datetime
TransHeader.RoundingPrice decimal(18, 4)
TransHeader.SaleDate datetime Date the order was marked Sale (aka “the invoice date”)
TransHeader.SalesDispositionID int
TransHeader.SalesPerson1ID int Employee.ID
TransHeader.SalesPerson2ID int Employee.ID
TransHeader.SalesPerson3ID int Employee.ID
TransHeader.SalesStationClassTypeID int
TransHeader.SalesStationID int Station.ID
TransHeader.ScheduledPaymentDate datetime
TransHeader.ScheduledPaymentIntervals int
TransHeader.ScheduledPaymentPlanID int
TransHeader.ScheduledPayments int
TransHeader.SeqID int
TransHeader.ServiceTicketNumber int
TransHeader.ShipFromAddressID int
TransHeader.ShipFromAddressLinkID int
TransHeader.ShipFromAddressOverridden bit
TransHeader.ShipFromClassTypeID int
TransHeader.ShipFromID int
TransHeader.ShippingAddressID int
TransHeader.ShippingAddressLinkID int
TransHeader.ShippingAddressOverridden bit
TransHeader.ShippingCompanyID int
TransHeader.ShippingCompanyOV bit
TransHeader.ShippingContactID int AccountContact.ID
TransHeader.ShippingContactOV bit
TransHeader.SonsBasePrice decimal(18, 4)
TransHeader.SonsDiscountPrice decimal(18, 4)
TransHeader.SonsModifierPrice decimal(18, 4)
TransHeader.SonsRawSubTotalPrice decimal(18, 4)
TransHeader.SonsRoundingPrice decimal(18, 4)
TransHeader.SonsSubTotalPrice decimal(18, 4)
TransHeader.SonsTaxablePrice float
TransHeader.SonsTaxesPrice decimal(18, 4)
TransHeader.SonsTotalPrice decimal(18, 4)
TransHeader.StationActivityClassTypeID int
TransHeader.StationActivityID int
TransHeader.StationClassTypeID int
TransHeader.StationID int Station.ID
TransHeader.StatusID int
TransHeader.StatusText nvarchar(50)
TransHeader.StoreID int Not Used.
TransHeader.SubTotalPrice decimal(18, 4)
TransHeader.TaxablePrice float
TransHeader.TaxClassID int
TransHeader.TaxClassOverridden bit
TransHeader.TaxesPrice decimal(18, 4)
TransHeader.TaxItems text
TransHeader.TaxNumber nchar(25)
TransHeader.TipsAmount float
TransHeader.TipsPaidOut float
TransHeader.TotalPrice decimal(18, 4)
TransHeader.TransactionType int
TransHeader.UsePaymentPlan bit
TransHeader.UseProgressBilling bit
TransHeader.UseTaxLookup bit
TransHeader.Version int
TransHeader.VoidedDate datetime Date the transaction was marked Voided
TransHeader.WriteOffAmount decimal(18, 4)

Related Tables

You could leave a comment if you were logged in.