You are here: File Descriptions > Resource Manager > RMTDxxx - Tax Location Detail File

# RMTDxxx - Tax Location Detail File

The Tax Location Detail file contains information about tax locations. These records are updated when transactions are posted. The general ledger account in this file is used when transactions are posted to General Ledger.

| Template: | DIM RMTD:"LOCID:C(6*), TXCLS:C(2*), TXLVL:N(1*), TAXP:N(7*), REFP:N(7*), TSALES:N(14*), NSALES:N(14*), TCOLL:N(14*), TPURCH:N(14*), NPURCH:N(14*), TPAID:N(14*), TREF:N(14*), RSV1:N(14*), GLACTT:C(12*), PTAXP:N(7*), ISVA:C(1*), ISVN[2]:N(1*)"
| IOLIST: | 0999 RMTDXXX: IOLIST TD0$, TD1$, TD2, TD3, TD4, TD5[ALL], TD6$, TD7, TD99$[ALL], TD99[ALL]
| Array Sizes: | DIM TD5[7], TD99$[0], TD99[0]
| String Sizes: | DIM TD0$(6), TD1$(2), TD6$(12)

Key Definitions

| Key Number | Field | Description
| 0 | [1:1:6] + | Tax Location ID +
|  | [2:1:2] | Tax Class
| 1 | [3:1:1] + | Tax Level +
|  | [1:1:6] + | Tax Location ID +
|  | [2:1:2] | Tax Class
|  | __________ |
|  | 5 segments |

Tax Location Detail File

| File Name: | RMTDxxx | Record Size: | 175(192)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 2

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1 | LOCID | TD0$ | Tax Location ID | A | 6 |
| 2 | TXCLS | TD1$ | Tax Class | A | 2 | "00"-"99"
| 3 | TXLVL | TD2 | Tax Level | N | 1 |
| 4 | TAXP | TD3 | Tax Percentage | N | 7 | 999.999
| 5 | REFP | TD4 | Tax Refundable Percentage | N | 7 | 999.999
| 6 | TSALES | TD5[0] | Taxable Sales | N | 14 | DOLL
| 7 | NSALES | TD5[1] | Nontaxable Sales | N | 14 | DOLL
| 8 | TCOLL | TD5[2] | Tax Collected | N | 14 | DOLL
| 9 | TPURCH | TD5[3] | Taxable Purchases | N | 14 | DOLL
| 10 | NPURCH | TD5[4] | Nontaxable Purchases | N | 14 | DOLL
| 11 | TPAID | TD5[5] | Tax Paid | N | 14 | DOLL
| 12 | TREF | TD5[6] | Tax Refundable | N | 14 | DOLL
| 13 | RSV1 | TD5[7] | Reserved for OSD | N | 14 |
| 14 | GLACTT | TD6$ | Tax Expense Account | A | 12 |
| 15 | PTAXP | TD7 | Purchase Tax Percentage | N | 7 | 999.999
| 16 | ISVA | TD99$[0] | Reserved for ISV | A | 1 |
| 17 | ISVN[1] | TD99[0] | Reserved for ISV | N | 1 |
| 18 | ISVN[2] | TD99[0] | Reserved for ISV | N | 1 |