# Sage 100 data dictionary

Sample database `sage100` on learnsql.cpetoday.com (SQL Server login: CPE Today course). Each table lists its columns with the type, keys, what the column means, and, for codes and statuses, the values seen in the sample copy (with row counts when the dictionary was written).
11 of 434 tables are described. Undocumented tables are listed at the end.

## AP_InvoiceHistoryHeader

Posted vendor invoices (the payables history). One row per invoice.

Grain: one row per posted vendor invoice

| Column | Type | Key | Meaning | Values seen |
|---|---|---|---|---|
| `InvoiceNo` | nvarchar(10) | PK FK to AP_OpenInvoice | Vendor's invoice number. |  |
| `HeaderSeqNo` | nvarchar(6) | PK |  |  |
| `ModuleCode` | nvarchar(3) |  |  |  |
| `InvoiceType` | nvarchar(1) |  |  |  |
| `APDivisionNo` | nvarchar(2) | FK to AP_OpenInvoice | Division. | 01 (18), 02 (4) |
| `VendorNo` | nvarchar(7) | FK to AP_OpenInvoice | Vendor who sent the invoice. | AIRWAY (6), ANDERS (6), ALLCLIM (5), AIRTRAV (1), AMEX (1), CONSULT (1), OFFICE (1), STEV (1) |
| `InvoiceDate` | datetime2 |  | Invoice date. | 2010-05-01T00:00:00 (13), 2010-05-02T00:00:00 (3), 2010-05-15T00:00:00 (3), 2010-05-17T00:00:00 (2), 2010-05-11T00:00:00 (1) |
| `InvoiceDueDate` | datetime2 |  | Date payment is due. | 2010-05-30T00:00:00 (7), 2010-05-01T00:00:00 (3), 2010-05-11T00:00:00 (3), 2010-05-31T00:00:00 (3), 2010-05-12T00:00:00 (1), 2010-05-25T00:00:00 (1), 2010-06-01T00:00:00 (1), 2010-06-10T00:00:00 (1), 2010-06-14T00:00:00 (1), 2010-06-16T00:00:00 (1) |
| `InvoiceDiscountDate` | datetime2 |  |  |  |
| `TransactionDate` | datetime2 |  |  |  |
| `TermsCode` | nvarchar(2) |  |  |  |
| `HoldPayment` | nvarchar(1) |  |  |  |
| `Comment` | nvarchar(40) |  |  |  |
| `PrepaidApplyToInvoiceNo` | nvarchar(10) |  |  |  |
| `PrepaidPaymentDate` | datetime2 |  |  |  |
| `PrepaidCheckNo` | nvarchar(10) |  |  |  |
| `SourceJournal` | nvarchar(2) | FK to GL_SourceJournal |  |  |
| `SourceJournalNo` | nvarchar(6) |  |  |  |
| `Form1099` | nvarchar(1) |  |  |  |
| `Box1099` | nvarchar(3) |  |  |  |
| `SeparateCheck` | nvarchar(1) |  |  |  |
| `JobNo` | nvarchar(7) |  |  |  |
| `VendorName` | nvarchar(30) |  |  |  |
| `TaxSchedule` | nvarchar(9) |  |  |  |
| `TaxClass` | nvarchar(2) |  |  |  |
| `UseTax` | nvarchar(1) |  |  |  |
| `PurchaseOrderNo` | nvarchar(7) |  |  |  |
| `ReceiptNo` | nvarchar(6) |  |  |  |
| `ReceiptDate` | datetime2 |  |  |  |
| `PurchaseAddressCode` | nvarchar(4) |  |  |  |
| `PurchaseName` | nvarchar(30) |  |  |  |
| `PurchaseAddress1` | nvarchar(30) |  |  |  |
| `PurchaseAddress2` | nvarchar(30) |  |  |  |
| `PurchaseAddress3` | nvarchar(30) |  |  |  |
| `PurchaseCity` | nvarchar(20) |  |  |  |
| `PurchaseState` | nvarchar(2) |  |  |  |
| `PurchaseZipCode` | nvarchar(10) |  |  |  |
| `PurchaseCountryCode` | nvarchar(3) |  |  |  |
| `ShipToCode` | nvarchar(4) |  |  |  |
| `ShipToName` | nvarchar(30) |  |  |  |
| `ShipToAddress1` | nvarchar(30) |  |  |  |
| `ShipToAddress2` | nvarchar(30) |  |  |  |
| `ShipToAddress3` | nvarchar(30) |  |  |  |
| `ShipToCity` | nvarchar(20) |  |  |  |
| `ShipToState` | nvarchar(2) |  |  |  |
| `ShipToZipCode` | nvarchar(10) |  |  |  |
| `ShipToCountryCode` | nvarchar(3) |  |  |  |
| `RequiredDate` | datetime2 |  |  |  |
| `ShipVia` | nvarchar(15) |  |  |  |
| `FOB` | nvarchar(15) |  |  |  |
| `WarehouseCode` | nvarchar(3) |  |  |  |
| `ConfirmTo` | nvarchar(30) |  |  |  |
| `ARDivisionNo` | nvarchar(2) |  |  |  |
| `CustomerNo` | nvarchar(7) |  |  |  |
| `CODCheckNo` | nvarchar(10) |  |  |  |
| `BankCode` | nvarchar(1) |  |  |  |
| `PurchaseOrderType` | nvarchar(1) |  |  |  |
| `PurchaseOrderDate` | datetime2 |  |  |  |
| `CODNo` | nvarchar(10) |  |  |  |
| `UserKey` | nvarchar(10) |  |  |  |
| `InvoiceAmt` | float |  | Invoice amount. |  |
| `NetInvoiceAmt` | float |  | Invoice amount after discounts. |  |
| `DiscountAmt` | float |  | Early-payment discount amount. | 0.0 (16), 70.81 (3), -141.62 (1), 17.96 (1), 24.0 (1) |
| `RetentionAmt` | float |  |  |  |
| `PrepaymentAmt` | float |  |  |  |
| `TaxableAmt` | float |  |  |  |
| `NonTaxableAmt` | float |  |  |  |
| `FreightAmt` | float |  |  |  |
| `TaxAmt` | float |  |  |  |
| `NonRecoverableAmt` | float |  |  |  |
| `TaxableMiscChargeAmt` | float |  |  |  |
| `NonTaxableMiscChargeAmt` | float |  |  |  |
| `TotalCostForFrghtAlloc` | float |  |  |  |
| `PrepaidFreight` | float |  |  |  |
| `CODAmount` | float |  |  |  |
| `DateUpdated` | datetime2 |  |  |  |
| `TimeUpdated` | nvarchar(8) |  |  |  |
| `UserUpdatedKey` | nvarchar(10) |  |  |  |
| `SSMA_TimeStamp` | timestamp |  |  |  |

## AP_Vendor

Accounts payable vendors: name, terms, balances and last-paid information.

Grain: one row per vendor (within a division)

| Column | Type | Key | Meaning | Values seen |
|---|---|---|---|---|
| `APDivisionNo` | nvarchar(2) | PK | Accounts payable division. | 02 (18), 01 (11) |
| `VendorNo` | nvarchar(7) | PK | Vendor number. |  |
| `VendorName` | nvarchar(30) |  | Vendor name. |  |
| `AddressLine1` | nvarchar(30) |  |  |  |
| `AddressLine2` | nvarchar(30) |  |  |  |
| `AddressLine3` | nvarchar(30) |  |  |  |
| `City` | nvarchar(20) |  |  |  |
| `State` | nvarchar(2) |  |  |  |
| `ZipCode` | nvarchar(10) |  |  |  |
| `CountryCode` | nvarchar(3) |  |  |  |
| `PrimaryContact` | nvarchar(10) |  |  |  |
| `TelephoneNo` | nvarchar(17) |  |  |  |
| `TelephoneExt` | nvarchar(5) |  |  |  |
| `FaxNo` | nvarchar(17) |  |  |  |
| `EmailAddress` | nvarchar(50) |  |  |  |
| `URLAddress` | nvarchar(50) |  |  |  |
| `TermsCode` | nvarchar(2) |  | Payment terms code. | 03 (13), 01 (10), 02 (4), 00 (2) |
| `Reference` | nvarchar(15) |  |  |  |
| `TemporaryVendor` | nvarchar(1) |  |  |  |
| `CreditCardVendor` | nvarchar(1) |  |  |  |
| `HoldPayment` | nvarchar(1) |  | Set when payments to the vendor are on hold. |  |
| `ExemptionNoOnFile` | nvarchar(1) |  |  |  |
| `TaxSchedule` | nvarchar(9) |  |  |  |
| `TaxClass` | nvarchar(2) |  |  |  |
| `AccountKey` | nvarchar(9) |  |  |  |
| `SeparateCheck` | nvarchar(1) |  |  |  |
| `Comment` | nvarchar(30) |  |  |  |
| `Sort` | nvarchar(10) |  |  |  |
| `BatchFax` | nvarchar(1) |  |  |  |
| `UsePOReceiptOfInvForVendor` | nvarchar(1) |  |  |  |
| `PrimaryPurchaseAddressCode` | nvarchar(4) |  |  |  |
| `VendorType` | nvarchar(1) |  |  |  |
| `Form1099` | nvarchar(1) |  | Set when the vendor is tracked for Form 1099. | N (26), M (3) |
| `TaxpayerIDSocialSecurityNo` | nvarchar(9) |  |  |  |
| `Box1099` | nvarchar(3) |  |  |  |
| `MiscBox9` | nvarchar(1) |  |  |  |
| `LastPurchaseDate` | datetime2 |  | Date of the most recent purchase. | 2010-05-31T00:00:00 (25), 2010-05-01T00:00:00 (2), (blank) (1), 2010-02-28T00:00:00 (1) |
| `LastPaymentDate` | datetime2 |  | Date of the most recent payment. | 2010-05-31T00:00:00 (15), (blank) (7), 2010-04-30T00:00:00 (3), 2010-05-01T00:00:00 (3), 2010-03-01T00:00:00 (1) |
| `LastCheckNo` | nvarchar(10) |  |  |  |
| `LastCheckAmt` | float |  |  |  |
| `RetentionRate` | float |  |  |  |
| `AverageDaysToPay` | float |  | Average days taken to pay this vendor. | 0.0 (23), 4.0 (1), 5.0 (1), 6.0 (1), 10.0 (1), 15.0 (1), 31.0 (1) |
| `AverageDaysOverDue` | float |  |  |  |
| `BalanceDue` | float |  | Amount currently owed to the vendor. |  |
| `NumberOfInvToUseInCalc` | float |  |  |  |
| `DateCreated` | datetime2 |  |  |  |
| `TimeCreated` | nvarchar(8) |  |  |  |
| `UserCreatedKey` | nvarchar(10) |  |  |  |
| `DateUpdated` | datetime2 |  |  |  |
| `TimeUpdated` | nvarchar(8) |  |  |  |
| `UserUpdatedKey` | nvarchar(10) |  |  |  |
| `SSMA_TimeStamp` | timestamp |  |  |  |

## AR_Customer

Accounts receivable customers: name, terms, credit limit and balances. The balance fields are running totals kept by Sage 100.

Grain: one row per customer (within a division)

| Column | Type | Key | Meaning | Values seen |
|---|---|---|---|---|
| `ARDivisionNo` | nvarchar(2) | PK FK to AR_Division | Accounts receivable division (business unit) that owns the customer. | 02 (10), 01 (6) |
| `CustomerNo` | nvarchar(7) | PK FK to AR_CustomerCreditCard | Customer number. Together with ARDivisionNo it identifies the customer. |  |
| `CustomerName` | nvarchar(30) |  | Customer name. |  |
| `AddressLine1` | nvarchar(30) |  |  |  |
| `AddressLine2` | nvarchar(30) |  |  |  |
| `AddressLine3` | nvarchar(30) |  |  |  |
| `City` | nvarchar(20) |  |  |  |
| `State` | nvarchar(2) |  |  |  |
| `ZipCode` | nvarchar(10) |  |  |  |
| `CountryCode` | nvarchar(3) |  |  |  |
| `TelephoneNo` | nvarchar(17) |  |  |  |
| `TelephoneExt` | nvarchar(5) |  |  |  |
| `FaxNo` | nvarchar(17) |  |  |  |
| `EmailAddress` | nvarchar(50) |  |  |  |
| `URLAddress` | nvarchar(50) |  |  |  |
| `EBMEnabled` | nvarchar(1) |  |  |  |
| `EBMConsumerUserID` | nvarchar(15) |  |  |  |
| `BatchFax` | nvarchar(1) |  |  |  |
| `DefaultCreditCardPmtType` | nvarchar(5) |  |  |  |
| `ContactCode` | nvarchar(10) | FK to AR_CustomerContact |  |  |
| `ShipMethod` | nvarchar(15) |  |  |  |
| `TaxSchedule` | nvarchar(9) |  |  |  |
| `TaxExemptNo` | nvarchar(15) |  |  |  |
| `TermsCode` | nvarchar(2) |  | Payment terms code (AR_TermsCode). | 01 (8), 02 (7), 03 (1) |
| `SalespersonDivisionNo` | nvarchar(2) | FK to AR_Salesperson |  |  |
| `SalespersonNo` | nvarchar(4) | FK to AR_Salesperson | Assigned salesperson number. | 0300 (5), 0400 (5), 0200 (4), 0100 (2) |
| `Comment` | nvarchar(30) |  |  |  |
| `SortField` | nvarchar(10) |  |  |  |
| `TemporaryCustomer` | nvarchar(1) |  |  |  |
| `OpenItemCustomer` | nvarchar(1) |  |  |  |
| `ResidentialAddress` | nvarchar(1) |  |  |  |
| `StatementCycle` | nvarchar(1) |  |  |  |
| `PrintDunningMessage` | nvarchar(1) |  |  |  |
| `CustomerType` | nvarchar(4) |  | Customer type code used for grouping and reports. | A4 (5), A1 (4), A2 (2), A3 (2), (blank) (1), A5 (1), A9 (1) |
| `PriceLevel` | nvarchar(1) |  |  |  |
| `DateLastActivity` | datetime2 |  |  |  |
| `DateLastPayment` | datetime2 |  | Date of the most recent payment. | 2017-05-31T00:00:00 (8), (blank) (5), 2017-05-21T00:00:00 (2), 2017-05-17T00:00:00 (1) |
| `DateLastStatement` | datetime2 |  |  |  |
| `DateLastFinanceChrg` | datetime2 |  |  |  |
| `DateLastAging` | datetime2 |  |  |  |
| `DefaultItemCode` | nvarchar(15) |  |  |  |
| `CreditHold` | nvarchar(1) |  | Set when the customer is on credit hold. |  |
| `PrimaryShipToCode` | nvarchar(4) |  |  |  |
| `DateEstablished` | datetime2 |  |  |  |
| `EncryptedCreditCardNo` | nvarchar(24) | FK to AR_CustomerCreditCard |  |  |
| `DefaultPaymentType` | nvarchar(5) | FK to AR_PaymentType |  |  |
| `EmailStatements` | nvarchar(1) |  |  |  |
| `NumberOfInvToUseInCalc` | float |  |  |  |
| `AvgDaysPaymentInvoice` | float |  |  |  |
| `AvgDaysOverDue` | float |  |  |  |
| `CustomerDiscountRate` | float |  |  |  |
| `ServiceChargeRate` | float |  |  |  |
| `CreditLimit` | float |  | Maximum open balance allowed. | 10000.0 (3), 25000.0 (3), 0.0 (2), 20000.0 (2), 1000.0 (1), 2500.0 (1), 7500.0 (1), 15000.0 (1), 60000.0 (1), 120000.0 (1) |
| `LastPaymentAmt` | float |  |  |  |
| `HighestStmntBalance` | float |  |  |  |
| `UnpaidServiceChrg` | float |  |  |  |
| `BalanceForward` | float |  | Balance carried forward from the last statement cycle. | 0.0 (12), 64.35 (1), 636.24 (1), 3298.75 (1), 7928.89 (1) |
| `CurrentBalance` | float |  | Current open balance. |  |
| `AgingCategory1` | float |  | Open amount in the first aging bucket. | 0.0 (9), 18.95 (1), 1000.0 (1), 1085.98 (1), 1257.4 (1), 3057.64 (1), 4476.31 (1), 6251.31 (1) |
| `AgingCategory2` | float |  | Open amount in the second aging bucket. | 0.0 (10), 31.7 (1), 835.43 (1), 1500.0 (1), 3057.64 (1), 3335.4 (1), 6406.53 (1) |
| `AgingCategory3` | float |  | Open amount in the third aging bucket. | 0.0 (14), 12.75 (1), 4607.18 (1) |
| `AgingCategory4` | float |  | Open amount in the fourth aging bucket. |  |
| `OpenOrderAmt` | float |  |  |  |
| `RetentionCurrent` | float |  |  |  |
| `RetentionAging1` | float |  |  |  |
| `RetentionAging2` | float |  |  |  |
| `RetentionAging3` | float |  |  |  |
| `RetentionAging4` | float |  |  |  |
| `DateCreated` | datetime2 |  |  |  |
| `TimeCreated` | nvarchar(8) |  |  |  |
| `UserCreatedKey` | nvarchar(10) |  |  |  |
| `DateUpdated` | datetime2 |  |  |  |
| `TimeUpdated` | nvarchar(8) |  |  |  |
| `UserUpdatedKey` | nvarchar(10) |  |  |  |
| `SSMA_TimeStamp` | timestamp |  |  |  |

## AR_InvoiceHistoryDetail

Line detail for posted invoices: item, quantity and extended amount.

Grain: one row per invoice line

| Column | Type | Key | Meaning | Values seen |
|---|---|---|---|---|
| `InvoiceNo` | nvarchar(7) | PK | Invoice the line belongs to (AR_InvoiceHistoryHeader.InvoiceNo). |  |
| `HeaderSeqNo` | nvarchar(6) | PK | Header sequence the line belongs to. |  |
| `DetailSeqNo` | nvarchar(6) | PK | Line number within the invoice. | 000000 (18), 000001 (8), 000002 (4), 000003 (1) |
| `ItemCode` | nvarchar(15) |  | Inventory item sold (IM_Item.ItemCode). |  |
| `ItemType` | nvarchar(1) |  |  |  |
| `ItemCodeDesc` | nvarchar(30) |  | Description of the item on the line. | (blank) (12), 8" x 10" Widgets (3), HON 2 DRAWER LETTER FLE W/O LK (3), 22" Widget with Hinges (2), DESK FILE 8" CAP 50 (2), Monthly Maintenance Billing (2), Widget 10 Pack (2), ART SPECIALTY EMP CANDLE LAMP (1), ART SPECIALTY WALNUT CNDL LAMP (1), BOOK BIN W/FLUORESCENT LIGHT (1), DESK 72" X 30" (1), PAPER CADDY 18"W 14"D 3"H (1) |
| `ExtendedDescriptionKey` | nvarchar(10) |  |  |  |
| `SalesAcctKey` | nvarchar(9) |  |  |  |
| `CostOfGoodsSoldAcctKey` | nvarchar(9) |  | Cost of goods sold account the line posts to. | 450010000 (23), 450100000 (8) |
| `InventoryAcctKey` | nvarchar(9) |  |  |  |
| `UnitOfMeasure` | nvarchar(4) |  |  |  |
| `SubjectToExemption` | nvarchar(1) |  |  |  |
| `Commissionable` | nvarchar(1) |  |  |  |
| `TaxClass` | nvarchar(2) |  |  |  |
| `Discount` | nvarchar(1) |  |  |  |
| `DropShip` | nvarchar(1) |  |  |  |
| `WarehouseCode` | nvarchar(3) |  | Warehouse the item shipped from. | 001 (17), (blank) (9), 000 (2), 002 (2), 098 (1) |
| `PriceLevel` | nvarchar(1) |  |  |  |
| `ProductLine` | nvarchar(4) |  |  |  |
| `Valuation` | nvarchar(1) |  |  |  |
| `PriceOverridden` | nvarchar(1) |  |  |  |
| `OrderWarehouse` | nvarchar(3) |  |  |  |
| `Revision` | nvarchar(3) |  |  |  |
| `BillOption1` | nvarchar(2) |  |  |  |
| `BillOption2` | nvarchar(2) |  |  |  |
| `BillOption3` | nvarchar(2) |  |  |  |
| `BillOption4` | nvarchar(2) |  |  |  |
| `BillOption5` | nvarchar(2) |  |  |  |
| `BillOption6` | nvarchar(2) |  |  |  |
| `BillOption7` | nvarchar(2) |  |  |  |
| `BillOption8` | nvarchar(2) |  |  |  |
| `BillOption9` | nvarchar(2) |  |  |  |
| `KitItem` | nvarchar(1) |  |  |  |
| `ExplodedKitItem` | nvarchar(1) |  |  |  |
| `SkipPrintCompLine` | nvarchar(1) |  |  |  |
| `StandardKitBill` | nvarchar(1) |  |  |  |
| `AliasItemNo` | nvarchar(30) |  |  |  |
| `CustomerAction` | nvarchar(1) |  |  |  |
| `ItemAction` | nvarchar(1) |  |  |  |
| `WarrantyCode` | nvarchar(10) |  |  |  |
| `ExpirationDate` | datetime2 |  |  |  |
| `ExpirationOverridden` | nvarchar(1) |  |  |  |
| `CostCode` | nvarchar(9) |  |  |  |
| `CostType` | nvarchar(1) |  |  |  |
| `CommentText` | nvarchar |  |  |  |
| `PromiseDate` | datetime2 |  |  |  |
| `QuantityShipped` | float |  | Quantity shipped. |  |
| `QuantityOrdered` | float |  |  |  |
| `QuantityBackordered` | float |  |  |  |
| `UnitPrice` | float |  | Price per unit. |  |
| `UnitCost` | float |  | Cost per unit, used for gross profit. |  |
| `UnitOfMeasureConvFactor` | float |  |  |  |
| `CommissionAmt` | float |  |  |  |
| `LineDiscountPercent` | float |  |  |  |
| `QuantityPerBill` | float |  |  |  |
| `ExtensionAmt` | float |  | Line amount (quantity times price). |  |
| `SSMA_TimeStamp` | timestamp |  |  |  |

## AR_InvoiceHistoryHeader

Posted sales invoices and credit memos (the history after posting). One row per invoice.

Grain: one row per posted invoice

| Column | Type | Key | Meaning | Values seen |
|---|---|---|---|---|
| `InvoiceNo` | nvarchar(7) | PK | Invoice number. |  |
| `HeaderSeqNo` | nvarchar(6) |  | Sequence of the header record; use it with InvoiceNo as the key. |  |
| `ModuleCode` | nvarchar(3) |  |  |  |
| `InvoiceType` | nvarchar(2) |  | Type of document, such as an invoice (I), a credit memo (C) or a debit memo (D). | IN (15), XD (5), CM (3) |
| `InvoiceDate` | datetime2 |  | Invoice date. | 2010-05-31T00:00:00 (5), 2010-05-01T00:00:00 (3), 2010-05-15T00:00:00 (3), 2010-05-21T00:00:00 (3), 2010-04-01T00:00:00 (2), 2010-05-16T00:00:00 (2), 2010-03-01T00:00:00 (1), 2010-04-15T00:00:00 (1), 2010-05-10T00:00:00 (1), 2010-05-27T00:00:00 (1), 2010-05-30T00:00:00 (1) |
| `TransactionDate` | datetime2 |  |  |  |
| `ARDivisionNo` | nvarchar(2) | FK to SO_ShipToAddress | Division of the customer. | 01 (15), 02 (7), (blank) (1) |
| `CustomerNo` | nvarchar(7) | FK to SO_ShipToAddress | Customer billed (AR_Customer). | ABF (10), BRESLIN (3), ORANGE (3), (blank) (1), AUTOCR (1), AVNET (1), CUSTOM (1), GREALAR (1), JELLCO (1), SHEPARD (1) |
| `TermsCode` | nvarchar(2) |  | Payment terms. | 01 (13), 02 (6), 03 (3), 00 (1) |
| `TaxSchedule` | nvarchar(9) |  |  |  |
| `TaxExemptNo` | nvarchar(15) |  |  |  |
| `SalespersonDivisionNo` | nvarchar(2) | FK to AR_Salesperson |  |  |
| `SalespersonNo` | nvarchar(4) | FK to AR_Salesperson |  |  |
| `CustomerPONo` | nvarchar(15) |  |  |  |
| `ApplyToInvoiceNo` | nvarchar(7) |  |  |  |
| `Comment` | nvarchar(30) |  |  |  |
| `RepetitiveInvoiceRefNo` | nvarchar(4) |  |  |  |
| `JobNo` | nvarchar(7) |  |  |  |
| `InvoiceDueDate` | datetime2 |  | Date payment is due. |  |
| `DiscountDueDate` | datetime2 |  |  |  |
| `SourceJournal` | nvarchar(2) | FK to GL_SourceJournal |  |  |
| `JournalNoGLBatchNo` | nvarchar(6) |  |  |  |
| `BatchFax` | nvarchar(1) |  |  |  |
| `FaxNo` | nvarchar(17) |  |  |  |
| `ShippingInvoice` | nvarchar(1) |  |  |  |
| `SalesOrderNo` | nvarchar(7) |  | Sales order the invoice came from, if any. |  |
| `OrderType` | nvarchar(1) |  |  |  |
| `OrderDate` | datetime2 |  |  |  |
| `BillToName` | nvarchar(30) |  |  |  |
| `BillToAddress1` | nvarchar(30) |  |  |  |
| `BillToAddress2` | nvarchar(30) |  |  |  |
| `BillToAddress3` | nvarchar(30) |  |  |  |
| `BillToCity` | nvarchar(20) |  |  |  |
| `BillToState` | nvarchar(2) |  |  |  |
| `BillToZipCode` | nvarchar(10) |  |  |  |
| `BillToCountryCode` | nvarchar(3) |  |  |  |
| `ShipToCode` | nvarchar(4) | FK to SO_ShipToAddress |  |  |
| `ShipToName` | nvarchar(30) |  |  |  |
| `ShipToAddress1` | nvarchar(30) |  |  |  |
| `ShipToAddress2` | nvarchar(30) |  |  |  |
| `ShipToAddress3` | nvarchar(30) |  |  |  |
| `ShipToCity` | nvarchar(20) |  |  |  |
| `ShipToState` | nvarchar(2) |  |  |  |
| `ShipToZipCode` | nvarchar(10) |  |  |  |
| `ShipToCountryCode` | nvarchar(3) |  |  |  |
| `ShipDate` | datetime2 |  | Date the goods shipped. | (blank) (4), 2009-05-01T00:00:00 (4), 2010-05-30T00:00:00 (4), 2010-05-31T00:00:00 (3), 2010-03-01T00:00:00 (1), 2010-04-01T00:00:00 (1), 2010-04-13T00:00:00 (1), 2010-05-05T00:00:00 (1), 2010-05-10T00:00:00 (1), 2010-05-11T00:00:00 (1), 2010-05-15T00:00:00 (1), 2010-05-22T00:00:00 (1) |
| `ShipVia` | nvarchar(15) |  |  |  |
| `ShipZone` | nvarchar(5) |  |  |  |
| `FOB` | nvarchar(15) |  |  |  |
| `ConfirmTo` | nvarchar(30) |  |  |  |
| `CheckNoForDeposit` | nvarchar(7) |  |  |  |
| `SplitCommissions` | nvarchar(1) |  |  |  |
| `SalespersonDivisionNo2` | nvarchar(2) |  |  |  |
| `SalespersonNo2` | nvarchar(4) |  |  |  |
| `SalespersonDivisionNo3` | nvarchar(2) |  |  |  |
| `SalespersonNo3` | nvarchar(4) |  |  |  |
| `SalespersonDivisionNo4` | nvarchar(2) |  |  |  |
| `SalespersonNo4` | nvarchar(4) |  |  |  |
| `SalespersonDivisionNo5` | nvarchar(2) |  |  |  |
| `SalespersonNo5` | nvarchar(4) |  |  |  |
| `PaymentType` | nvarchar(5) | FK to AR_PaymentType |  |  |
| `PaymentTypeCategory` | nvarchar(1) |  |  |  |
| `OtherPaymentTypeRefNo` | nvarchar(24) |  |  |  |
| `CorporateCustIDPurchOrder` | nvarchar(25) |  |  |  |
| `CorporateTaxOverrd` | nvarchar(1) |  |  |  |
| `DepositCorporateTaxOverrd` | nvarchar(1) |  |  |  |
| `CardholderName` | nvarchar(30) |  |  |  |
| `ExpirationDateYear` | nvarchar(4) |  |  |  |
| `ExpirationDateMonth` | nvarchar(2) |  |  |  |
| `EncryptedCreditCardNo` | nvarchar(24) | FK to AR_CustomerCreditCard |  |  |
| `Last4UnencryptedCreditCardNos` | nvarchar(4) |  |  |  |
| `AuthorizationCode` | nvarchar(16) |  |  |  |
| `AuthorizationCodeForDeposit` | nvarchar(16) |  |  |  |
| `CreditCardTransactionID` | nvarchar(10) |  |  |  |
| `CreditCardTransactionIDForDep` | nvarchar(10) |  |  |  |
| `RMANo` | nvarchar(7) |  |  |  |
| `EBMSubmissionType` | nvarchar(1) |  |  |  |
| `EBMUserIDSubmittingThisOrder` | nvarchar(15) |  |  |  |
| `EBMUserType` | nvarchar(1) |  |  |  |
| `ShipperID` | nvarchar(3) |  |  |  |
| `UserKey` | nvarchar(10) |  |  |  |
| `WarehouseCode` | nvarchar(3) |  |  |  |
| `ShipWeight` | nvarchar(5) |  |  |  |
| `ResidentialAddress` | nvarchar(1) |  |  |  |
| `EmailAddress` | nvarchar(50) |  |  |  |
| `CRMUserID` | nvarchar(11) |  |  |  |
| `CRMCompanyID` | nvarchar(11) |  |  |  |
| `CRMPersonID` | nvarchar(11) |  |  |  |
| `CRMOpportunityID` | nvarchar(11) |  |  |  |
| `TaxableSalesAmt` | float |  | Taxable sales on the invoice. | 0.0 (12), -165.75 (1), -44.66 (1), 132.5 (1), 133.04 (1), 572.5 (1), 916.2 (1), 1075.85 (1), 1601.1 (1), 1800.0 (1), 2350.1 (1), 9130.25 (1) |
| `NonTaxableSalesAmt` | float |  | Non-taxable sales on the invoice. | 0.0 (12), 259.0 (2), -81.48 (1), 33.2 (1), 130.0 (1), 309.85 (1), 407.4 (1), 826.25 (1), 1000.0 (1), 1935.25 (1), 283500.0 (1) |
| `FreightAmt` | float |  | Freight charged. | 0.0 (14), 10.0 (2), -2.78 (1), 3.0 (1), 5.0 (1), 6.0 (1), 32.85 (1), 38.0 (1), 45.0 (1) |
| `SalesTaxAmt` | float |  | Sales tax on the invoice. | 0.0 (13), -10.77 (1), -2.9 (1), 6.63 (1), 28.63 (1), 46.73 (1), 52.72 (1), 86.46 (1), 108.0 (1), 117.51 (1), 456.51 (1) |
| `CostOfSalesAmt` | float |  |  |  |
| `AmountSubjectToDiscount` | float |  |  |  |
| `DiscountRate` | float |  |  |  |
| `DiscountAmt` | float |  | Discount given on the invoice. | 0.0 (16), 38.85 (2), 19.96 (1), 21.52 (1), 46.48 (1), 137.43 (1), 160.11 (1) |
| `SalesSubjectToComm` | float |  |  |  |
| `CostSubjectToComm` | float |  |  |  |
| `CommissionRate` | float |  |  |  |
| `CommissionAmt` | float |  | Commission earned on the invoice. |  |
| `SplitCommRate2` | float |  |  |  |
| `SplitCommRate3` | float |  |  |  |
| `SplitCommRate4` | float |  |  |  |
| `SplitCommRate5` | float |  |  |  |
| `DepositAmt` | float |  |  |  |
| `CreditCardPaymentBalanceAmt` | float |  |  |  |
| `Weight` | float |  |  |  |
| `RetentionAmt` | float |  |  |  |
| `NumberOfPackages` | float |  |  |  |
| `DepositCorporateSalesTax` | float |  |  |  |
| `CorporateSalesTax` | float |  |  |  |
| `DateUpdated` | datetime2 |  |  |  |
| `TimeUpdated` | nvarchar(8) |  |  |  |
| `UserUpdatedKey` | nvarchar(10) |  |  |  |
| `SSMA_TimeStamp` | timestamp |  |  |  |

## AR_OpenInvoice

Invoices that are still open (not fully paid). The aging reports are built from this table.

Grain: one row per open invoice

| Column | Type | Key | Meaning | Values seen |
|---|---|---|---|---|
| `ARDivisionNo` | nvarchar(2) | PK FK to AR_Division |  |  |
| `CustomerNo` | nvarchar(7) | PK | Customer who owes the invoice. |  |
| `InvoiceNo` | nvarchar(7) | PK | Open invoice number. |  |
| `InvoiceType` | nvarchar(2) |  |  |  |
| `InvoiceDate` | datetime2 |  | Invoice date. |  |
| `InvoiceDueDate` | datetime2 |  | Date payment is due. Used for aging. |  |
| `InvoiceDiscountDate` | datetime2 |  | Last date the early-payment discount applies. |  |
| `InvoiceHistoryHeaderSeqNo` | nvarchar(6) |  |  |  |
| `PostingDate` | datetime2 |  |  |  |
| `TermsCode` | nvarchar(2) |  |  |  |
| `TaxSchedule` | nvarchar(9) |  |  |  |
| `SalespersonDivisionNo` | nvarchar(2) | FK to AR_Salesperson |  |  |
| `SalespersonNo` | nvarchar(4) | FK to AR_Salesperson |  |  |
| `SplitCommissionFlag` | nvarchar(1) |  |  |  |
| `Comment` | nvarchar(30) |  |  |  |
| `CreditMemoInvoiceReference` | nvarchar(7) |  |  |  |
| `JobNo` | nvarchar(7) |  |  |  |
| `CustomerPONo` | nvarchar(15) |  | Customer purchase order number. | (blank) (92), 3456 (2), 789 (2), 2233 (1), 9832 (1), AJ-890123 (1), RA1001 (1), VERBAL (1), XX-890200 (1) |
| `PostingReference` | nvarchar(10) |  |  |  |
| `CheckNo` | nvarchar(10) |  |  |  |
| `CommissionRate` | float |  |  |  |
| `TaxableAmt` | float |  |  |  |
| `NonTaxableAmt` | float |  |  |  |
| `FreightAmt` | float |  |  |  |
| `SalesTaxAmt` | float |  |  |  |
| `CostOfSalesAmt` | float |  |  |  |
| `SalesSubjectToComm` | float |  |  |  |
| `CostSubjectToComm` | float |  |  |  |
| `CommissionAmt` | float |  |  |  |
| `DiscountAmt` | float |  |  |  |
| `PaymentsToday` | float |  |  |  |
| `Balance` | float |  | Amount still owed on the invoice. |  |
| `RetentionAmt` | float |  |  |  |
| `DateUpdated` | datetime2 |  |  |  |
| `TimeUpdated` | nvarchar(8) |  |  |  |
| `UserUpdatedKey` | nvarchar(10) |  |  |  |
| `SSMA_TimeStamp` | timestamp |  |  |  |

## GL_Account

The general ledger chart of accounts. Each row is a G/L account with its type and status.

Grain: one row per G/L account

| Column | Type | Key | Meaning | Values seen |
|---|---|---|---|---|
| `AccountKey` | nvarchar(9) | PK | Internal account key (use it for joins). |  |
| `AccountDesc` | nvarchar(50) |  | Account description. |  |
| `Account` | nvarchar(41) |  | Account number as entered (with segments, such as 1000-100). |  |
| `RawAccount` | nvarchar(32) |  |  |  |
| `MainAccountCode` | nvarchar(15) |  |  |  |
| `DateStart` | datetime2 |  |  |  |
| `DateEnd` | datetime2 |  |  |  |
| `Status` | nvarchar(1) |  | Account status, such as Active or Inactive. |  |
| `ClearBalance` | nvarchar(1) |  | Whether the balance clears at year-end (1 = yes). |  |
| `AccountType` | nvarchar(2) | FK to GL_AccountType | Account type code, such as A (asset), L (liability), Q (equity), S (sales) or E (expense). |  |
| `CashFlowsType` | nvarchar(1) |  | How the account is treated in the cash flow statement. | N (148), O (40), C (5), I (5), F (3) |
| `RollupCode1` | nvarchar(20) |  |  |  |
| `RollupCode2` | nvarchar(20) |  |  |  |
| `RollupCode3` | nvarchar(20) |  |  |  |
| `RollupCode4` | nvarchar(20) |  |  |  |
| `AccountGroup` | nvarchar(15) | FK to GL_AccountGroup |  |  |
| `AccountCategory` | nvarchar(1) | FK to GL_AccountCategory | Category used in financial reports. | X (113), A (33), L (22), C (13), R (12), O (4), E (3), I (1) |
| `CompanyCode` | nvarchar(3) |  |  |  |
| `DateCreated` | datetime2 |  |  |  |
| `TimeCreated` | nvarchar(8) |  |  |  |
| `UserCreatedKey` | nvarchar(10) |  |  |  |
| `DateUpdated` | datetime2 |  |  |  |
| `TimeUpdated` | nvarchar(8) |  |  |  |
| `UserUpdatedKey` | nvarchar(10) |  |  |  |

## IM_Item

Inventory items: description, type, cost and price setup.

Grain: one row per item

| Column | Type | Key | Meaning | Values seen |
|---|---|---|---|---|
| `ItemCode` | nvarchar(15) | PK | Item code (primary key). | R1000 (1), R2000 (1), R500 (1), S1000 (1), S2000 (1) |
| `ItemCodeDesc` | nvarchar(30) |  | Item description. | R Boom Floor Crane, Mdl R1000 (1), R Boom Floor Crane, Mdl R2000 (1), R Boom Floor Crane, Mdl R500 (1), Straddle Floor Crane, Mdl 1000 (1), Straddle Floor Crane, Mdl 2000 (1) |
| `ProductLine` | nvarchar(4) |  | Product line the item belongs to (IM_ProductLine). | RBFC (3), SFC (2) |
| `ProductType` | nvarchar(1) |  | Product type code for the item. |  |
| `Valuation` | nvarchar(1) |  |  |  |
| `PriceCode` | nvarchar(4) |  |  |  |
| `BackOrdersAllowed` | nvarchar(1) |  |  |  |
| `EBMEnabled` | nvarchar(1) |  |  |  |
| `DetailSalesHistory` | nvarchar(1) |  |  |  |
| `CalculateCommission` | nvarchar(1) |  |  |  |
| `StandardUnitOfMeasure` | nvarchar(4) |  | Standard unit of measure for the item. |  |
| `PurchaseUnitOfMeasure` | nvarchar(4) |  |  |  |
| `SalesUnitOfMeasure` | nvarchar(4) |  |  |  |
| `DefaultWarehouseCode` | nvarchar(3) |  |  |  |
| `ShipWeight` | nvarchar(10) |  |  |  |
| `PrimaryAPDivisionNo` | nvarchar(2) |  |  |  |
| `PrimaryVendorNo` | nvarchar(7) |  |  |  |
| `ImageFile` | nvarchar(30) |  |  |  |
| `DateLastSold` | datetime2 |  |  |  |
| `DateLastReceipt` | datetime2 |  |  |  |
| `Category1` | nvarchar(10) |  |  |  |
| `Category2` | nvarchar(10) |  |  |  |
| `Category3` | nvarchar(10) |  |  |  |
| `Category4` | nvarchar(10) |  |  |  |
| `NameOfSale` | nvarchar(10) |  |  |  |
| `SaleStartingDate` | datetime2 |  |  |  |
| `SaleEndingDate` | datetime2 |  |  |  |
| `SaleDiscountType` | nvarchar(1) |  |  |  |
| `AlternateItems` | nvarchar(1) |  |  |  |
| `PriceByItem` | nvarchar(1) |  |  |  |
| `PriceByCustPriceLevel` | nvarchar(1) |  |  |  |
| `PriceByCustomerNo` | nvarchar(1) |  |  |  |
| `TradeDiscount` | nvarchar(1) |  |  |  |
| `ExplodeKitItems` | nvarchar(1) |  |  |  |
| `ReturnsAllowed` | nvarchar(1) |  |  |  |
| `RestockingMethod` | nvarchar(1) |  |  |  |
| `NextLotSerialNo` | nvarchar(15) |  |  |  |
| `InventoryCycle` | nvarchar(1) |  |  |  |
| `RoutingNo` | nvarchar(20) |  |  |  |
| `ProcurementType` | nvarchar(1) |  |  |  |
| `PlannerCode` | nvarchar(3) |  |  |  |
| `BuyerCode` | nvarchar(3) |  |  |  |
| `PlannedByMrp` | nvarchar(1) |  |  |  |
| `LowLevelCode` | nvarchar(1) |  |  |  |
| `PrintReceiptLabels` | nvarchar(1) |  |  |  |
| `ExtendedDescription` | nvarchar(1) |  |  |  |
| `DetailReceiptHistory` | nvarchar(1) |  |  |  |
| `AllocateLandedCost` | nvarchar(1) |  |  |  |
| `TaxClass` | nvarchar(2) |  |  |  |
| `AllowOverrideRecptCost` | nvarchar(1) |  |  |  |
| `WarrantyCode` | nvarchar(10) |  |  |  |
| `CommissionRate` | float |  |  |  |
| `BaseCommAmt` | float |  |  |  |
| `PurchaseUMConvFctr` | float |  |  |  |
| `SalesUMConvFctr` | float |  |  |  |
| `SuggestedRetailPrice` | float |  |  |  |
| `StandardUnitPrice` | float |  | Standard selling price. |  |
| `StandardUnitCost` | float |  | Standard cost. |  |
| `LastUnitCost` | float |  |  |  |
| `AverageUnitCost` | float |  |  |  |
| `SalePriceDiscountPercent` | float |  |  |  |
| `TotalQuantityOnHand` | float |  |  |  |
| `AverageBackOrderFillDays` | float |  |  |  |
| `LastAllocatedCost` | float |  |  |  |
| `Volume` | float |  |  |  |
| `RestockingCharge` | float |  |  |  |
| `SSMA_TimeStamp` | timestamp |  |  |  |

## IM_ItemWarehouse

Item quantities by warehouse: on hand, on order, on sales order and year-to-date sales.

Grain: one row per item per warehouse

| Column | Type | Key | Meaning | Values seen |
|---|---|---|---|---|
| `ItemCode` | nvarchar(15) |  | Item (IM_Item.ItemCode). |  |
| `WarehouseCode` | nvarchar(3) |  | Warehouse (IM_Warehouse.WarehouseCode). |  |
| `BinLocation` | nvarchar(10) |  |  |  |
| `ReorderMethod` | nvarchar(1) |  |  |  |
| `EconomicOrderQuantity` | float |  |  |  |
| `ReorderPointQuantity` | float |  | Quantity at which to reorder. |  |
| `MinimumOrderQuantity` | float |  |  |  |
| `MaximumOnHand` | float |  |  |  |
| `BeginningAverageCost` | float |  |  |  |
| `BeginningBalanceQuantity` | float |  |  |  |
| `QuantityReceived` | float |  |  |  |
| `QuantityAdjusted` | float |  |  |  |
| `QuantitySold` | float |  |  |  |
| `QuantityOnHand` | float |  | Quantity on hand now. |  |
| `QuantityOnPurchaseOrder` | float |  | Quantity on open purchase orders. |  |
| `QuantityOnSalesOrder` | float |  | Quantity committed to open sales orders. |  |
| `QuantityOnBackOrder` | float |  | Quantity on backorder. |  |
| `KitQuantityReceivedNextPeriod` | float |  |  |  |
| `PTDQuantitySold` | float |  |  |  |
| `PTDQuantityReturned` | float |  |  |  |
| `PTDDollarsSold` | float |  |  |  |
| `PTDCostOfGoodsSold` | float |  |  |  |
| `YTDQuantitySold` | float |  | Quantity sold this fiscal year. |  |
| `YTDQuantityReturned` | float |  |  |  |
| `YTDDollarsSold` | float |  | Sales dollars this fiscal year. |  |
| `YTDCostOfGoodsSold` | float |  |  |  |
| `PriorYearQuantitySold` | float |  |  |  |
| `PriorYearQuantityReturned` | float |  |  |  |
| `PriorYearDollarsSold` | float |  |  |  |
| `PriorYearCostOfGoodsSold` | float |  |  |  |
| `AverageOnHandQuantity` | float |  |  |  |
| `AverageCost` | float |  | Average cost of the stock on hand. |  |
| `QuantityOnWO` | float |  |  |  |
| `QuantityRequiredForWO` | float |  |  |  |
| `QuantityIssuedPTD` | float |  |  |  |
| `QuantityIssuedYTD` | float |  |  |  |
| `QuantityIssuedPriorYear` | float |  |  |  |
| `QuantitySoldNextPeriod` | float |  |  |  |
| `QuantityReturnedNextPeriod` | float |  |  |  |
| `DollarsSoldNextPeriod` | float |  |  |  |
| `CostOfGoodsSoldNextPeriod` | float |  |  |  |
| `QuantityIssuedNextPeriod` | float |  |  |  |
| `SSMA_TimeStamp` | timestamp |  |  |  |

## PO_PurchaseOrderHeader

Purchase orders sent to vendors.

Grain: one row per purchase order

| Column | Type | Key | Meaning | Values seen |
|---|---|---|---|---|
| `PurchaseOrderNo` | nvarchar(7) |  | Purchase order number. |  |
| `PurchaseOrderDate` | datetime2 |  | Date the order was placed. |  |
| `OrderType` | nvarchar(1) |  |  |  |
| `MasterRepeatingOrderNo` | nvarchar(7) |  |  |  |
| `RequiredExpireDate` | datetime2 |  | Date the goods are required by. |  |
| `APDivisionNo` | nvarchar(2) |  |  |  |
| `VendorNo` | nvarchar(7) |  | Vendor the order is placed with. |  |
| `PurchaseName` | nvarchar(30) |  |  |  |
| `PurchaseAddress1` | nvarchar(30) |  |  |  |
| `PurchaseAddress2` | nvarchar(30) |  |  |  |
| `PurchaseAddress3` | nvarchar(30) |  |  |  |
| `PurchaseCity` | nvarchar(20) |  |  |  |
| `PurchaseState` | nvarchar(2) |  |  |  |
| `PurchaseZipCode` | nvarchar(10) |  |  |  |
| `PurchaseCountryCode` | nvarchar(3) |  |  |  |
| `PurchaseAddressCode` | nvarchar(4) |  |  |  |
| `ShipToCode` | nvarchar(4) |  |  |  |
| `ShipToName` | nvarchar(30) |  |  |  |
| `ShipToAddress1` | nvarchar(30) |  |  |  |
| `ShipToAddress2` | nvarchar(30) |  |  |  |
| `ShipToAddress3` | nvarchar(30) |  |  |  |
| `ShipToCity` | nvarchar(20) |  |  |  |
| `ShipToState` | nvarchar(2) |  |  |  |
| `ShipToZipCode` | nvarchar(10) |  |  |  |
| `ShipToCountryCode` | nvarchar(3) |  |  |  |
| `OrderStatus` | nvarchar(1) |  | Order status (see the values). |  |
| `UseTax` | nvarchar(1) |  |  |  |
| `PrintPurchaseOrders` | nvarchar(1) |  |  |  |
| `OnHold` | nvarchar(1) |  | Set when the order is on hold. |  |
| `BatchFax` | nvarchar(1) |  |  |  |
| `CompletionDate` | datetime2 |  |  |  |
| `ShipVia` | nvarchar(15) |  |  |  |
| `FOB` | nvarchar(15) |  |  |  |
| `WarehouseCode` | nvarchar(3) |  |  |  |
| `ConfirmTo` | nvarchar(30) |  |  |  |
| `Comment` | nvarchar(30) |  |  |  |
| `ARDivisionNo` | nvarchar(2) |  |  |  |
| `CustomerNo` | nvarchar(7) |  |  |  |
| `TermsCode` | nvarchar(2) |  |  |  |
| `LastInvoiceDate` | datetime2 |  |  |  |
| `LastInvoiceNo` | nvarchar(10) |  |  |  |
| `Form1099` | nvarchar(1) |  |  |  |
| `Box1099` | nvarchar(3) |  |  |  |
| `LastReceiptDate` | datetime2 |  |  |  |
| `LastIssueDate` | datetime2 |  |  |  |
| `LastReceiptNo` | nvarchar(7) |  |  |  |
| `LastIssueNo` | nvarchar(7) |  |  |  |
| `PrepaidCheckNo` | nvarchar(10) |  |  |  |
| `FaxNo` | nvarchar(17) |  |  |  |
| `TaxSchedule` | nvarchar(9) |  |  |  |
| `InvalidTaxCalc` | nvarchar(1) |  |  |  |
| `PrepaidAmt` | float |  |  |  |
| `TaxableAmt` | float |  |  |  |
| `NonTaxableAmt` | float |  |  |  |
| `SalesTaxAmt` | float |  |  |  |
| `FreightAmt` | float |  |  |  |
| `PrepaidFreightAmt` | float |  |  |  |
| `InvoicedAmt` | float |  |  |  |
| `ReceivedAmt` | float |  |  |  |
| `FreightSalesTaxInvAmt` | float |  |  |  |
| `BackOrderLostAmt` | float |  |  |  |
| `DateCreated` | datetime2 |  |  |  |
| `TimeCreated` | nvarchar(8) |  |  |  |
| `UserCreatedKey` | nvarchar(10) |  |  |  |
| `DateUpdated` | datetime2 |  |  |  |
| `TimeUpdated` | nvarchar(8) |  |  |  |
| `UserUpdatedKey` | nvarchar(10) |  |  |  |
| `SSMA_TimeStamp` | timestamp |  |  |  |

## SO_SalesOrderHeader

Open sales orders. Lines are in SO_SalesOrderDetail.

Grain: one row per open sales order

| Column | Type | Key | Meaning | Values seen |
|---|---|---|---|---|
| `SalesOrderNo` | nvarchar(7) | PK | Sales order number. |  |
| `OrderDate` | datetime2 |  | Date the order was entered. | 2010-05-15T00:00:00 (4), 2010-05-18T00:00:00 (3), 2010-04-20T00:00:00 (2), 2010-05-01T00:00:00 (2), 2010-05-11T00:00:00 (2), 2010-05-31T00:00:00 (2), 2010-05-03T00:00:00 (1), 2010-05-14T00:00:00 (1), 2010-05-19T00:00:00 (1), 2010-05-22T00:00:00 (1), 2010-05-23T00:00:00 (1) |
| `OrderType` | nvarchar(1) |  | Type of order. | S (13), B (4), R (2), M (1) |
| `OrderStatus` | nvarchar(1) |  | Status of the order (see the values). | N (11), O (7), H (2) |
| `MasterRepeatingOrderNo` | nvarchar(7) |  |  |  |
| `ShipExpireDate` | datetime2 |  | Date the order expires if it has not shipped. | 2010-05-31T00:00:00 (10), 2010-05-01T00:00:00 (3), 2010-04-20T00:00:00 (2), 2010-05-11T00:00:00 (1), 2010-05-13T00:00:00 (1), 2010-05-15T00:00:00 (1), 2010-05-23T00:00:00 (1), 5999-12-31T00:00:00 (1) |
| `ARDivisionNo` | nvarchar(2) | FK to SO_ShipToAddress |  |  |
| `CustomerNo` | nvarchar(7) | FK to SO_ShipToAddress | Customer ordering. |  |
| `BillToName` | nvarchar(30) |  |  |  |
| `BillToAddress1` | nvarchar(30) |  |  |  |
| `BillToAddress2` | nvarchar(30) |  |  |  |
| `BillToAddress3` | nvarchar(30) |  |  |  |
| `BillToCity` | nvarchar(20) |  |  |  |
| `BillToState` | nvarchar(2) |  |  |  |
| `BillToZipCode` | nvarchar(10) |  |  |  |
| `BillToCountryCode` | nvarchar(3) |  |  |  |
| `ShipToCode` | nvarchar(4) | FK to SO_ShipToAddress |  |  |
| `ShipToName` | nvarchar(30) |  |  |  |
| `ShipToAddress1` | nvarchar(30) |  |  |  |
| `ShipToAddress2` | nvarchar(30) |  |  |  |
| `ShipToAddress3` | nvarchar(30) |  |  |  |
| `ShipToCity` | nvarchar(20) |  |  |  |
| `ShipToState` | nvarchar(2) |  |  |  |
| `ShipToZipCode` | nvarchar(10) |  |  |  |
| `ShipToCountryCode` | nvarchar(3) |  |  |  |
| `ShipVia` | nvarchar(15) |  |  |  |
| `ShipZone` | nvarchar(5) |  |  |  |
| `ShipZoneActual` | nvarchar(5) |  |  |  |
| `ShipWeight` | nvarchar(5) |  |  |  |
| `CustomerPONo` | nvarchar(15) |  |  |  |
| `FOB` | nvarchar(15) |  |  |  |
| `WarehouseCode` | nvarchar(3) |  |  |  |
| `ConfirmTo` | nvarchar(30) |  |  |  |
| `Comment` | nvarchar(30) |  |  |  |
| `TermsCode` | nvarchar(2) |  | Payment terms. | 01 (11), 02 (7), 03 (2) |
| `TaxSchedule` | nvarchar(9) |  |  |  |
| `TaxExemptNo` | nvarchar(15) |  |  |  |
| `InvalidTaxCalc` | nvarchar(1) |  |  |  |
| `PrintSalesOrders` | nvarchar(1) |  |  |  |
| `PrintPickingSheets` | nvarchar(1) |  |  |  |
| `LastInvoiceOrderDate` | datetime2 |  |  |  |
| `LastInvoiceOrderNo` | nvarchar(7) |  |  |  |
| `CurrentInvoiceNo` | nvarchar(7) |  |  |  |
| `CheckNoForDeposit` | nvarchar(10) |  |  |  |
| `CycleCode` | nvarchar(2) |  |  |  |
| `FaxNo` | nvarchar(17) |  |  |  |
| `BatchFax` | nvarchar(1) |  |  |  |
| `BatchEmail` | nvarchar(1) |  |  |  |
| `EmailAddress` | nvarchar(50) |  |  |  |
| `FreightCalculationMethod` | nvarchar(1) |  |  |  |
| `LotSerialLinesExist` | nvarchar(1) |  |  |  |
| `SalespersonDivisionNo` | nvarchar(2) | FK to AR_Salesperson |  |  |
| `SalespersonNo` | nvarchar(4) | FK to AR_Salesperson |  |  |
| `SplitCommissions` | nvarchar(1) |  |  |  |
| `SalespersonDivisionNo2` | nvarchar(2) |  |  |  |
| `SalespersonNo2` | nvarchar(4) |  |  |  |
| `SalespersonDivisionNo3` | nvarchar(2) |  |  |  |
| `SalespersonNo3` | nvarchar(4) |  |  |  |
| `SalespersonDivisionNo4` | nvarchar(2) |  |  |  |
| `SalespersonNo4` | nvarchar(4) |  |  |  |
| `SalespersonDivisionNo5` | nvarchar(2) |  |  |  |
| `SalespersonNo5` | nvarchar(4) |  |  |  |
| `EBMUserType` | nvarchar(1) |  |  |  |
| `EBMSubmissionType` | nvarchar(1) |  |  |  |
| `EBMUserIDSubmittingThisOrder` | nvarchar(15) |  |  |  |
| `PaymentType` | nvarchar(5) | FK to AR_PaymentType |  |  |
| `OtherPaymentTypeRefNo` | nvarchar(24) |  |  |  |
| `CorporateCustIDPurchOrder` | nvarchar(25) |  |  |  |
| `CorporateTaxOverrd` | nvarchar(1) |  |  |  |
| `DepositCorporateTaxOverrd` | nvarchar(1) |  |  |  |
| `CardholderName` | nvarchar(30) |  |  |  |
| `ExpirationDateYear` | nvarchar(4) |  |  |  |
| `ExpirationDateMonth` | nvarchar(2) |  |  |  |
| `EncryptedCreditCardNo` | nvarchar(24) |  |  |  |
| `CancelReasonCode` | nvarchar(5) | FK to SO_CancelReasonCode |  |  |
| `CreditCardCVV2No` | nvarchar(5) |  |  |  |
| `Last4UnencryptedCreditCardNos` | nvarchar(4) |  |  |  |
| `CreditCardAuthorizationNo` | nvarchar(16) |  |  |  |
| `CreditCardTransactionID` | nvarchar(10) |  |  |  |
| `AuthorizationDate` | datetime2 |  |  |  |
| `AuthorizationTime` | nvarchar(6) |  |  |  |
| `AuthorizationCodeForDeposit` | nvarchar(16) |  |  |  |
| `CreditCardTransactionIDForDep` | nvarchar(10) |  |  |  |
| `PaymentTypeCategory` | nvarchar(1) |  |  |  |
| `PayBalanceByCreditCard` | nvarchar(1) |  |  |  |
| `AVSAddress` | nvarchar(30) |  |  |  |
| `AVSCity` | nvarchar(20) |  |  |  |
| `AVSState` | nvarchar(2) |  |  |  |
| `AVSZipCode` | nvarchar(10) |  |  |  |
| `CreditCardComment` | nvarchar(30) |  |  |  |
| `AuthorizationRequiredFlag` | nvarchar(1) |  |  |  |
| `RMANo` | nvarchar(7) |  |  |  |
| `JobNo` | nvarchar(7) |  |  |  |
| `ResidentialAddress` | nvarchar(1) |  |  |  |
| `CRMUserID` | nvarchar(11) |  |  |  |
| `CRMPersonID` | nvarchar(11) |  |  |  |
| `CRMOpportunityID` | nvarchar(11) |  |  |  |
| `CRMCompanyID` | nvarchar(11) |  |  |  |
| `CRMProspectID` | nvarchar(11) |  |  |  |
| `TaxableSubjectToDiscount` | float |  |  |  |
| `NonTaxableSubjectToDiscount` | float |  |  |  |
| `TaxSubjToDiscPrcntOfTotSubjTo` | float |  |  |  |
| `DiscountRate` | float |  |  |  |
| `DiscountAmt` | float |  |  |  |
| `TaxableAmt` | float |  |  |  |
| `NonTaxableAmt` | float |  |  |  |
| `SalesTaxAmt` | float |  |  |  |
| `CreditCardPreAuthorizationAmt` | float |  |  |  |
| `Weight` | float |  |  |  |
| `FreightAmt` | float |  |  |  |
| `DepositAmt` | float |  |  |  |
| `CreditCardPaymentBalanceAmt` | float |  |  |  |
| `CommissionRate` | float |  |  |  |
| `SplitCommRate2` | float |  |  |  |
| `SplitCommRate3` | float |  |  |  |
| `SplitCommRate4` | float |  |  |  |
| `SplitCommRate5` | float |  |  |  |
| `NumberOfShippingLabels` | float |  |  |  |
| `LastNoOfShippingLabels` | float |  |  |  |
| `DepositCorporateSalesTax` | float |  |  |  |
| `CorporateSalesTax` | float |  |  |  |
| `DateCreated` | datetime2 |  |  |  |
| `TimeCreated` | nvarchar(8) |  |  |  |
| `UserCreatedKey` | nvarchar(10) |  |  |  |
| `DateUpdated` | datetime2 |  |  |  |
| `TimeUpdated` | nvarchar(8) |  |  |  |
| `UserUpdatedKey` | nvarchar(10) |  |  |  |
| `SSMA_TimeStamp` | timestamp |  |  |  |

## Undocumented tables

`AP_AgedInvoiceWrk`, `AP_Analysis`, `AP_AnalysisReportWrk`, `AP_AnalysisWrk`, `AP_ARClearingDetail`, `AP_ARClearingHeader`, `AP_ARClearingRecapWrk`, `AP_ARClearingRegisterWrk`, `AP_ARClearingRestart`, `AP_AssignVendorTaxSchedListWrk`, `AP_Audit`, `AP_CashRequirementsWrk`, `AP_ChangeVendorsValidate`, `AP_CheckDetail`, `AP_CheckDetailPosting`, `AP_CheckHeader`, `AP_CheckHeaderPosting`, `AP_CheckHistoryDetail`, `AP_CheckHistoryHeader`, `AP_CheckHistoryWrk`, `AP_CheckRegisterWrk`, `AP_CheckRestart`, `AP_CheckStubWrk`, `AP_CheckWrk`, `AP_DailyPostingWork`, `AP_DeleteChangeVendors`, `AP_DeleteChangeVendorsWork`, `AP_Division`, `AP_DivisionListingWrk`, `AP_ExpenseByGLAccountWrk`, `AP_ExtendedStubWrk`, `AP_Form1099PrintingWrk`, `AP_InvoiceDetail`, `AP_InvoiceDetailPosting`, `AP_InvoiceHeader`, `AP_InvoiceHeaderPosting`, `AP_InvoiceHistoryDetail`, `AP_InvoiceHistoryMemo`, `AP_InvoiceHistoryMemoSettings`, `AP_InvoiceHistoryTaxSummary`, `AP_InvoiceHistoryWrk`, `AP_InvoiceMemo`, `AP_InvoiceMemoSettings`, `AP_InvoicePaymentListingWrk`, `AP_InvoiceRegisterWrk`, `AP_InvoiceRestart`, `AP_InvoiceTaxDetail`, `AP_InvoiceTaxSummary`, `AP_JobDistributionDetail`, `AP_LastBankUsed`, `AP_ManualCheckDetail`, `AP_ManualCheckHeader`, `AP_ManualCheckInvDetail`, `AP_ManualCheckInvDetailWork`, `AP_ManualCheckRegisterWrk`, `AP_ManualCheckRestart`, `AP_ManualCheckTaxDetail`, `AP_ManualCheckTaxSummary`, `AP_MonthlyPurchaseWrk`, `AP_OpenInvoice`, `AP_OpenInvoiceByJobWrk`, `AP_OpenInvoiceTaxSummary`, `AP_Options`, `AP_OptionsListingWrk`, `AP_PaymentHistoryWrk`, `AP_RecapByDivisionWrk`, `AP_RepetitiveInvMemoSettings`, `AP_RepetitiveInvoiceDetail`, `AP_RepetitiveInvoiceHeader`, `AP_RepetitiveInvoiceListingWrk`, `AP_RepetitiveInvoiceMemo`, `AP_RepetitiveInvoiceTaxDetail`, `AP_RepetitiveInvoiceTaxSummary`, `AP_SalesTax`, `AP_SalesTaxCalcErrorLogWrk`, `AP_SalesTaxWrk`, `AP_SummaryDrillDownWork`, `AP_TaxJournalWrk`, `AP_TaxSummaryWork`, `AP_TermsCode`, `AP_TransactionPaymentHistory`, `AP_TrialBalanceWrk`, `AP_Vendor1099Payments`, `AP_VendorAuditWrk`, `AP_VendorContact`, `AP_VendorContactListingWrk`, `AP_VendorCustomerLink`, `AP_VendorCustomerLinkListWrk`, `AP_VendorListingBalWrk`, `AP_VendorListingWrk`, `AP_VendorMailingLabelsWrk`, `AP_VendorMemo`, `AP_VendorMemoPrintingWrk`, `AP_VendorMemoSettings`, `AP_VendorPurchaseAnalysisWrk`, `AP_VendorPurchasesHistory`, `AP_VendorPurchHistoryByPdWrk`, `AP_VendorRemit`, `AR_AgedInvoiceReportWrk`, `AR_AlternateInvoice`, `AR_Analysis`, `AR_AnalysisReportWrk`, `AR_AnalysisWrk`, `AR_Audit`, `AR_CashExpectationReportWrk`, `AR_CashReceiptsDeposit`, `AR_CashReceiptsDetail`, `AR_CashReceiptsHeader`, `AR_CashReceiptsHistory`, `AR_CashReceiptsJournalWrk`, `AR_CashReceiptsRestart`, `AR_CashReceiptsWrk`, `AR_CashRecPaymentTypeRecapWrk`, `AR_CashSales`, `AR_ChangeCustomersValidate`, `AR_CommissionRegisterWrk`, `AR_CreditCardSettlementWrk`, `AR_CustomerAuditWrk`, `AR_CustomerContact`, `AR_CustomerContactListingWrk`, `AR_CustomerCreditCard`, `AR_CustomerCreditCardEBMUser`, `AR_CustomerCreditCardListWrk`, `AR_CustomerListingBalWrk`, `AR_CustomerListingWrk`, `AR_CustomerMailingLabelsWrk`, `AR_CustomerMemo`, `AR_CustomerMemoSettings`, `AR_CustomerMemoWrk`, `AR_CustomerRenumber`, `AR_CustomerSalesAnalysisWrk`, `AR_CustomerSalesHistory`, `AR_CustomerSalespersonHistory`, `AR_CustomerShipToTaxExemptions`, `AR_CustomerSlsHistByPerWrk`, `AR_DailyPostingWork`, `AR_DeleteChangeCustomers`, `AR_DeleteChangeCustomersWork`, `AR_DepositHistory`, `AR_DepositHistoryWrk`, `AR_Division`, `AR_DivisionListingWrk`, `AR_FinanceCharge`, `AR_FinanceChargeJournalRestart`, `AR_FinanceChargeJournalWrk`, `AR_GrossProfitJournalWrk`, `AR_InvoiceDetail`, `AR_InvoiceHeader`, `AR_InvoiceHistoryLotSerial`, `AR_InvoiceHistoryMemo`, `AR_InvoiceHistoryMemoSettings`, `AR_InvoiceHistoryTaxSummary`, `AR_InvoiceHistoryTracking`, `AR_InvoiceHistoryWrk`, `AR_InvoiceMemo`, `AR_InvoiceMemoSettings`, `AR_InvoiceRestart`, `AR_InvoiceTaxDetail`, `AR_InvoiceTaxSummary`, `AR_InvoiceWrk`, `AR_MatchCreditsToInvoiceWrk`, `AR_MonthlySalesWrk`, `AR_OpenInvoiceSplitCommissions`, `AR_OpenInvoiceTaxSummary`, `AR_Options`, `AR_OptionsListingWrk`, `AR_PaymentType`, `AR_PaymentTypeWrk`, `AR_RecapByDivisionWrk`, `AR_RepetitiveInvoiceDetail`, `AR_RepetitiveInvoiceHeader`, `AR_RepetitiveInvoiceListingWrk`, `AR_RepetitiveInvoiceTaxDetail`, `AR_RepetitiveInvoiceTaxSummary`, `AR_SalesAnalysisSalespersonWrk`, `AR_SalesJournalWrk`, `AR_Salesperson`, `AR_SalespersonCommission`, `AR_SalespersonCommissionWrk`, `AR_SalespersonHistory`, `AR_SalespersonLink`, `AR_SalespersonListingWrk`, `AR_SalespersonSlsHistByPerWrk`, `AR_SalesTax`, `AR_SalesTaxWrk`, `AR_StatementOptions`, `AR_StatementWrk`, `AR_SummaryDrillDownWork`, `AR_TaxJournalWrk`, `AR_TermsCode`, `AR_TrackingByItemHistory`, `AR_TransactionPaymentHistory`, `AR_TransactionPosting`, `AR_TrialBalanceWrk`, `BR_BankRecapWrk`, `BR_EstimatedCashFlowAnlysWrk`, `BR_Options`, `BR_ReconciliationRegisterWrk`, `BR_Transaction`, `GL_AccountCategory`, `GL_AccountFilterFRxWrk`, `GL_AccountFRxWrk`, `GL_AccountGroup`, `GL_AccountHistory`, `GL_AccountMemo`, `GL_AccountMemoSettings`, `GL_AccountMemoWrk`, `GL_AccountSegment`, `GL_AccountStructure`, `GL_AccountType`, `GL_AllocationDetail`, `GL_AllocationHeader`, `GL_AllocationJournalWrk`, `GL_AllocationSelectionCalc`, `GL_AllocationSelectionDetail`, `GL_AllocationSelectionHeader`, `GL_AllocationSelectionOptions`, `GL_AllocationSelectionRestart`, `GL_AnalysisWrk`, `GL_Audit`, `GL_AuditWrk`, `GL_BalanceFRxWrk`, `GL_Bank`, `GL_Budget`, `GL_BudgetAndHistoryWrk`, `GL_BudgetOptions`, `GL_BudgetReportWrk`, `GL_BudgetRevision`, `GL_BudgetRevisionOptions`, `GL_BudgetRevisionWrk`, `GL_ChangeAccounts`, `GL_ChangeAccountsRestart`, `GL_ChangeAccountsValidate`, `GL_ChangeAccountsWork`, `GL_ChartOfAccountsWrk`, `GL_CheckMicr`, `GL_CompanyActiveBatch`, `GL_CompanyBatchOptions`, `GL_CompanyMemoManagerSettings`, `GL_DailyPosting`, `GL_DailyTransactionRegisterWrk`, `GL_DailyTransactionRestart`, `GL_DataExchange`, `GL_DeleteAccountsWork`, `GL_DetailBySourceWrk`, `GL_DetailPosting`, `GL_DetailReportWrk`, `GL_ErrorLogWrk`, `GL_ExceptionReportWrk`, `GL_Exchange`, `GL_ExchangeAccountWrk`, `GL_ExchangeActivityWrk`, `GL_ExchangeBudgetWrk`, `GL_ExchangeSelection`, `GL_ExchangeTransactionWrk`, `GL_FinancialReport`, `GL_FinancialReportDetailWrk`, `GL_FinancialReportGroup`, `GL_FinancialReportHeaderWrk`, `GL_FinancialReportSelection`, `GL_FinancialReportTokenWrk`, `GL_FinancialTerminology`, `GL_FiscalYear`, `GL_FiscalYearDetail`, `GL_FiscalYearListingWrk`, `GL_GeneralJournalDetail`, `GL_GeneralJournalHeader`, `GL_GeneralJournalHistory`, `GL_GeneralJournalMemo`, `GL_GeneralJournalMemoSettings`, `GL_GeneralJournalRestart`, `GL_GeneralJournalWrk`, `GL_GraphicsWrk`, `GL_JournalDrillDownWrk`, `GL_MainAccount`, `GL_MainAccountListingWrk`, `GL_MainAccountMemo`, `GL_MainAccountMemoSettings`, `GL_MainAccountMemoWrk`, `GL_Options`, `GL_OptionsListingWrk`, `GL_PayAccount`, `GL_PayAccountSelectListingWrk`, `GL_PayActivity`, `GL_PayActivityLogWrk`, `GL_PayBank`, `GL_PayOptions`, `GL_PaySyncAccountWork`, `GL_PaySyncBankCodeWork`, `GL_PayTransactionDetail`, `GL_PayTransactionHeader`, `GL_PeriodBudgetDetail`, `GL_PeriodPostingHistory`, `GL_PostingRecapWrk`, `GL_RecalculateAccountsWork`, `GL_RecurringJournalDetail`, `GL_RecurringJournalHeader`, `GL_RecurringJournalHistory`, `GL_RecurringJournalRestart`, `GL_RecurringJournalUpdate`, `GL_RecurringJournalWrk`, `GL_Rollup`, `GL_SalesTax`, `GL_SourceJournal`, `GL_SourceJournalHistory`, `GL_SourceJournalHistoryWrk`, `GL_StandardJournalDetail`, `GL_StandardJournalHeader`, `GL_StandardJournalListingWrk`, `GL_SubAccount`, `GL_SummaryDetailDrillDown`, `GL_TransactionJournalDetail`, `GL_TransactionJournalHeader`, `GL_TransactionJournalHistory`, `GL_TransactionJournalMemo`, `GL_TransactionJournalRestart`, `GL_TransactionJournalWrk`, `GL_TransJournalMemoSettings`, `GL_TrialBalanceWrk`, `GL_WorksheetWrk`, `IM_AliasItem`, `IM_AlternateItem`, `IM_ItemCost`, `IM_ItemVendor`, `IM_Price`, `IM_ProductLine`, `IM_TransactionPosting`, `IM_UnitOfMeasure`, `IM_Warehouse`, `IM_Warranty`, `PO_VendorPurchaseAddress`, `PO_VendPurchAddressListingWrk`, `SO_AdditionalPackingListWrk`, `SO_ARInvoiceHistoryLink`, `SO_AutoGenerateInvoices`, `SO_AutoGenerateOrders`, `SO_AutoGenInvoicesListingWrk`, `SO_AutoGenOrdersListingWrk`, `SO_BackOrderWrk`, `SO_BatchAuthorizationWrk`, `SO_CancelReasonCode`, `SO_CODLabelsWrk`, `SO_CustomerLastPurchaseListWrk`, `SO_CustomerSalesHistoryWrk`, `SO_CustomerSlsHistByItemWrk`, `SO_CustomerSlsHistByProdLnWrk`, `SO_DailyBackOrderRecapWrk`, `SO_DailyDepositRecapWrk`, `SO_DailyDropShipWrk`, `SO_DailyJobTransactionWrk`, `SO_DailyPostingWork`, `SO_DailyShipment`, `SO_DailyShipmentPackage`, `SO_DailyShipmentWrk`, `SO_GrossProfitJournalWrk`, `SO_InvoiceDefaults`, `SO_InvoiceDetail`, `SO_InvoiceHeader`, `SO_InvoiceHistoryLink`, `SO_InvoiceMemo`, `SO_InvoiceMemoSettings`, `SO_InvoiceRestart`, `SO_InvoiceTaxDetail`, `SO_InvoiceTaxSummary`, `SO_InvoiceTierCostCalcWork`, `SO_InvoiceTierDistribution`, `SO_InvoiceTracking`, `SO_InvoiceWrk`, `SO_LastPurchaseHistory`, `SO_LotSerialHistory`, `SO_LotSerialHistoryWrk`, `SO_OpenOrderDetailByItem`, `SO_OpenOrdersByItemWrk`, `SO_OpenOrdersByPromiseDateWrk`, `SO_OpenOrdersWrk`, `SO_Options`, `SO_OptionsListingWrk`, `SO_PackageTrackingByItem`, `SO_PackingListWrk`, `SO_PickingSheetWrk`, `SO_RecapByDivision`, `SO_RecapByProductLineWhse`, `SO_RecapByWarehouse`, `SO_RecapWrk`, `SO_SalesDailyRecapWork`, `SO_SalesDailyRecapWrk`, `SO_SalesHistory`, `SO_SalesJournalRestart`, `SO_SalesJournalWrk`, `SO_SalesOrderDefaults`, `SO_SalesOrderDetail`, `SO_SalesOrderDropShip`, `SO_SalesOrderHistMemoSettings`, `SO_SalesOrderHistoryDetail`, `SO_SalesOrderHistoryHeader`, `SO_SalesOrderHistoryMemo`, `SO_SalesOrderHistoryTaxDetail`, `SO_SalesOrderHistoryTaxSummary`, `SO_SalesOrderMemo`, `SO_SalesOrderMemoSettings`, `SO_SalesOrderPrint`, `SO_SalesOrderQuoteHistoryWrk`, `SO_SalesOrderRecap`, `SO_SalesOrderTaxDetail`, `SO_SalesOrderTaxSummary`, `SO_SalesOrderWrk`, `SO_SalesRecapByDivisionWrk`, `SO_SalesRecapByProductLineWrk`, `SO_SalesRecapByWarehouseWrk`, `SO_SalesRecapByWhseProdLineWrk`, `SO_SalesTaxJournalWrk`, `SO_ShipperID`, `SO_ShippingExceptionWrk`, `SO_ShippingHistoryWrk`, `SO_ShippingLabelsWrk`, `SO_ShippingOptions`, `SO_ShippingQtyByItem`, `SO_ShippingRateDetail`, `SO_ShippingRateHeader`, `SO_ShippingRateListingWrk`, `SO_ShipToAddress`, `SO_ShipToAddressListingWrk`, `SO_SummaryDrillDownWork`
