Process Invoice Line Transactions
The following table describes functions used to process Invoice Line-level transactions in Avalara AvaTax Excise:
| Required |
Function |
Comment |
| R |
Send required data elements:
- Invoice Line
- Product Code
|
- Product Code - Identifying code of the product being transported in the line item which needs to match either a product code or an alternate product code in the Avalara AvaTax Excise application client database.
- Invoice Line – Identifies the given transaction line to a pre-defined invoice line by the calling system
|
| N |
Send optional data elements:
- Movement Start Date
- Movement End Date
- Blend To Product Code
- Unit Price
- Net Units
- Gross Units
- Billed Units
- Line Amount
- Bill of Lading Number
- Bill of Lading Date
- User Data
- Alternative Fuel Content
- Blend to Alternative Fuel Content
- Blend To Indicator
- Currency
- Unit of Measure
- Freight Unit Price
- Freight Type
- Freight Line Amount
- Transaction Line Measures
- Custom String 1, 2, 3
- Custom Numeric 1, 2, 3
- Nth Time Sale
|
- Alternative Fuel Content - Numeric value that represents the percentage of alternative fuel contained in the product.
- Blend to Alternative Fuel Content - Numeric Value that represents the percentage of alternative fuel found in the blend to product.
- Net/Gross/Billed Units – quantities in Net, Gross, or Billed for the given transaction line
- Blend To Indicator - Indicates if this record refers to a blended product.
- Nth Time Sale - Integer to identify how many times a product has been sold in the supply chain.
|
| N |
Send optional data elements for transaction Origin fields:
- Origin Country Code
- Origin Jurisdiction
- Origin County
- Origin City
- Origin Postal Code
- Origin Type
- Origin
- Origin Out City Limit Indicator
- Origin Excise Warehouse
- Origin Special Jurisdiction Indicator
- Origin Address 1,2
- Origin Special Jurisdictions
Send optional data elements for transaction Destination fields:
- Destination Country Code
- Destination Jurisdiction
- Destination County
- Destination City
- Destination Postal Code
- Destination Type
- Destination
- Destination Out City Limit Indicator
- Destination Excise Warehouse
- Destination Special Jurisdiction Indicator
- Destination Address 1,2
- Destination Special Jurisdictions
|
- Origin / Destination - A unique id for the location that should match to a custom_id from the locations table in the Avalara AvaTax Excise application client database.
- Country Code - ISO standard 3 character country code of the location.
- Jurisdiction - State or region code.
- City / County - City/County name of the location that must match a GNIS defined City/County name in the local_jurisdictions table of the Avalara AvaTax Excise application Client database; or a cross reference entry in the common_codes.
- Special Jurisdictions – Indicator if location belongs to a special jurisdiction
|
| N |
Send optional data elements for transaction Sale fields:
- Sale Country Code
- Sale Jurisdiction
- Sale County
- Sale City
- Sale Postal Code
- Sale Type
- Sale Location
- Sale Out City Limit Indicator
- Sale Excise Warehouse
- Sale Special Jurisdiction Indicator
- Sale Address 1,2
- Sale Special Jurisdictions
|
Special Jurisdictions – Indicator if location belongs to a special jurisdiction |
| N |
Send optional data elements for transaction Counter fields:
- Counter Country Code
- Counter Jurisdiction
- Counter County
- Counter City
- Counter Postal Code
- Counter Type
- Counter Party
- Counter Out City Limit Indicator
- Counter Excise Warehouse
- Counter Special Jurisdiction Indicator
- Counter Address 1,2
- Counter Fiscal Rep. Indicator
|
- Special Jurisdictions – Indicator if location belongs to a special jurisdiction
- Counter Fiscal Rep. Indicator – Y/N field to identify if a Counterparty Fiscal Rep is present in the Counterparty country.
|