| Table Name: | MPTaxServiceMapping |
| View Name: | MARITaxServiceMapping |
| Group: | |
| Description: | USA Sales Tax Interface Mapping storage |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| TaxType | TaxType INT Primary |
||
| InternalID | InternalID INT Primary |
||
| Company | Company INT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| FromState | FromState NVARCHAR (100) |
||
| FromCity | FromCity NVARCHAR (100) |
||
| FromZIP | FromZIP NVARCHAR (100) |
||
| FromStreet | FromStreet NVARCHAR (100) |
||
| ToCardCode | ToCardCode NVARCHAR (15) Index |
OCRD.CardCode | |
| ToAddressCode | ToAddressCode NVARCHAR (50) Index |
||
| ToState | ToState NVARCHAR (100) |
||
| ToCity | ToCity NVARCHAR (100) |
||
| ToZIP | ToZIP NVARCHAR (100) |
||
| ToStreet | ToStreet NVARCHAR (100) |
||
| LastUpdate | LastUpdate Datetime Index |
||
| SalesTaxRate | SalesTaxRate NUMERIC(19,6) |
||
| OSTCCode | OSTCCode NVARCHAR (8) Index |
OSTC.Code | |
| Option1 | Option1 NVARCHAR (50) |
||
| Option2 | Option2 INT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPTaxServiceMappingSub | USA Sales Tax Interface Mapping sub table |