Data Dictionary
Returns Transaction Import Template
Overview
Download Template: Returns Transaction Import Template
File Type: csv
Detail Record
The record below shows the various fields within the record. Each field is linked within the data dictionary which provides additional information including field constraints as well as allowed values.
| Display Name | Field Name | Field Type |
|---|---|---|
| Company Code | Company Code | string |
| Document Number | Document Number | string |
| Fiscal Year | Fiscal Year | string |
| Item Number | Item Number | string |
| Reporting Date | Reporting Date | string |
| United States Tax Category | United States Tax Category | string |
| Material Description | Material Description | string |
| Material Group | Material Group | string |
| Ship From State | Ship From State | string |
| Ship From County | Ship From County | string |
| Ship From City | Ship From City | string |
| Ship From Address | Ship From Address | string |
| Ship From Zip Code | Ship From Zip Code | string |
| Ship To State | Ship To State | string |
| Ship To County | Ship To County | string |
| Ship To City | Ship To City | string |
| Ship To Address | Ship To Address | string |
| Ship To Zip Code | Ship To Zip Code | string |
| Location ID | Location ID | string |
| Gross Amount | Gross Amount | string |
| Tax Rate | Tax Rate | string |
| Taxable Base | Taxable Base | string |
| Exempt Reason Code | Exempt Reason Code | string |
| State Tax | State Tax | string |
| County Tax | County Tax | string |
| City Tax | City Tax | string |
| Local Tax 1 | Local Tax 1 | string |
| Local Tax 2 | Local Tax 2 | string |
| Local Tax 3 | Local Tax 3 | string |