192x Filetype XLSX File size 0.12 MB Source: www.oregon.gov
Sheet 1: Out-of-state Sch_Transaction
| | Tobacco Schedule Transactions | ||||||||||||||||||||||||||||||||||||||||||||||
Enter the count of rows you need and the click "Increase Rows" button to increase rows. | For guidance refer to the 'ODOR Excel Template User Guide' | ||||||||||||||||||||||||||||||||||||||||||||||
Row Count | Enter Rows Needed | ||||||||||||||||||||||||||||||||||||||||||||||
Increase Rows | 100 | Validate | Copy Last Schedule | ||||||||||||||||||||||||||||||||||||||||||||
Do you have any Schedules? | YES | If “NO” is selected, delete all data in Sch_Transaction to validate the tab. | |||||||||||||||||||||||||||||||||||||||||||||
Transaction Document | Name and Address | Transactions | Delivery Service | ||||||||||||||||||||||||||||||||||||||||||||
Schedule Type | Date | Document Type | Document Number | Customer Type | EIN | State EIN | Customer ID | Business Name Line 1 | Business Name Line 2 | Type of Address | Foreign Address? | Address Line 1 | Address Line 2 | City | State (or Province) | Country Code* | Zip (or Postal Code) | Federal Description | State Description | MSA Status | Price | Tax Jurisdicion | Product Description | Manufacturer | Manufacturer EIN | Brand Family | Unit | Unit Description | Weight Volume | Value | Quantity | Stick Count | Extended Taxable Amount | Is Delivery Service Used? | Business Name Line 1 * | Business Name Line 2 | EIN | Foreign Address? * | Address Line 1* | Address Line 2 | City* | State (or Province)* | Country Code* | Zip (or Postal Code) * | In Care of Name | Phone Number * | |
1A | 2019-01-10 | Invoice | 5009 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Roll Your Own | OR-TP1 | N/A | 98.64 | OR | Ciggy's Tobacco | Manufacturer 1 | 123456789 | Ciggy's | 1.00 | PCH | 0.65 | 2.74 | 36 | 0 | 98.64 | NO | ||||||||||||||||
1A | 2019-01-10 | Invoice | 5009 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Pipe Tobacco | OR-TP1 | N/A | 32.00 | OR | Smokey's Pipe Tobacco | Manufacturer 1 | 123456789 | Smokey's | 1.00 | BAG | 6.00 | 4.00 | 8 | 0 | 32.00 | NO | ||||||||||||||||
1A | 2019-01-10 | Invoice | 5009 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Snuff | OR-MS1 | N/A | 83.30 | OR | Penguin Fine Cut | Manufacturer 2 | 567890123 | Penguin | 1.00 | CAN | 1.20 | 2.38 | 35 | 0 | 35.00 | NO | ||||||||||||||||
1A | 2019-01-10 | Invoice | 5009 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Snuff | OR-MS1 | N/A | 29.85 | OR | Penguin Pouch Straight | Manufacturer 2 | 567890123 | Penguin | 1.00 | CAN | 0.82 | 1.99 | 15 | 0 | 15.00 | NO | ||||||||||||||||
1A | 2019-01-10 | Invoice | 5009 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Snuff | OR-MS2 | N/A | 48.06 | OR | Penguin Straight Big TUB | Manufacturer 2 | 567890123 | Penguin | 1.00 | TUB | 7.20 | 16.02 | 3 | 0 | 21.60 | NO | ||||||||||||||||
1A | 2019-01-10 | Invoice | 5009 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Chewing Tobacco | OR-MS3 | N/A | 13.80 | OR | M.L Mini Chew | Manufacturer 2 | 567890123 | M.L | 1.00 | PCH | 1.15 | 2.43 | 12 | 0 | 12.00 | NO | ||||||||||||||||
1A | 2019-01-10 | Invoice | 5009 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Chewing Tobacco | OR-MS4 | N/A | 111.84 | OR | M.L Chew | Manufacturer 2 | 567890123 | M.L. | 1.00 | PCH | 3.00 | 4.66 | 24 | 0 | 72.00 | NO | ||||||||||||||||
1A | 2019-01-10 | Invoice | 5009 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Chewing Tobacco | OR-MS4 | N/A | 35.04 | OR | Pluggy Plug Chewing Tobacco | Manufacturer 2 | 567890123 | M.L. | 1.00 | PLG | 2.00 | 2.92 | 12 | 0 | 24.00 | NO | ||||||||||||||||
1A | 2019-01-10 | Invoice | 5009 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Large Cigar | OR-CGR1 | N/A | 92.50 | OR | Big O's Cigar | Manufacturer 3 | 890123456 | Big O | 1.00 | STK | 0.34 | 3.70 | 25 | 25 | 25.00 | NO | ||||||||||||||||
1A | 2019-01-10 | Invoice | 5009 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Small Cigar | OR-CGR2 | N/A | 86.00 | OR | Big O's Cigarillo JR 2pk | Manufacturer 3 | 890123456 | Big O | 1.00 | FOI | 0.00 | 0.86 | 100 | 200 | 86.00 | NO | ||||||||||||||||
1A | 2019-01-15 | Invoice | 5013 | Retailer | 787878787 | 999999999 | 789999 | Tobacco 4 Less | Location | NO | 98922 Center St. | Salem | OR | 97301 | Snuff | OR-MS1 | N/A | 119.00 | OR | Penguin Fine Cut | Manufacturer 2 | 567890123 | Penguin | 1.00 | CAN | 1.20 | 2.38 | 50 | 0 | 50.00 | NO | ||||||||||||||||
1A | 2019-01-15 | Invoice | 5013 | Retailer | 787878787 | 999999999 | 789999 | Tobacco 4 Less | Location | NO | 98922 Center St. | Salem | OR | 97301 | Snuff | OR-MS1 | N/A | 69.65 | OR | Penguin Pouch Straight | Manufacturer 2 | 567890123 | Penguin | 1.00 | CAN | 0.82 | 1.99 | 35 | 0 | 35.00 | NO | ||||||||||||||||
1A | 2019-01-15 | Invoice | 5013 | Retailer | 787878787 | 999999999 | 789999 | Tobacco 4 Less | Location | NO | 98922 Center St. | Salem | OR | 97301 | Chewing Tobacco | OR-MS4 | N/A | 111.84 | OR | M.L Chew | Manufacturer 2 | 567890123 | M.L | 1.00 | PCH | 3.00 | 4.66 | 24 | 0 | 72.00 | NO | ||||||||||||||||
2D | 2019-01-22 | Credit Memo | CM5020 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Roll Your Own | OR-TP1 | N/A | 16.44 | OR | Ciggy's Tobacco | Manufacturer 1 | 123456789 | Ciggy's | 1.00 | PCH | 0.65 | 2.74 | 6 | 0 | 16.44 | NO | ||||||||||||||||
2D | 2019-01-22 | Credit Memo | CM5020 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Snuff | OR-MS1 | N/A | 11.90 | OR | Penguin Fine Cut | Manufacturer 2 | 567890123 | Penguin | 1.00 | CAN | 1.20 | 2.38 | 5 | 0 | 5.00 | NO | ||||||||||||||||
2D | 2019-01-22 | Credit Memo | CM5020 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Chewing Tobacco | OR-MS4 | N/A | 55.92 | OR | M.L. Chew | Manufacturer 2 | 567890123 | M.L. | 1.00 | PCH | 3.00 | 4.66 | 12 | 0 | 36.00 | NO | ||||||||||||||||
2D | 2019-01-22 | Credit Memo | CM5020 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Large Cigar | OR-CGR1 | N/A | 92.50 | OR | Big O's Cigar | Manufacturer 3 | 890123456 | Big O | 1.00 | STK | 0.34 | 3.70 | 25 | 25 | 25.00 | NO | ||||||||||||||||
2D | 2019-01-22 | Credit Memo | CM5020 | Retailer | 666666666 | 999999999 | 987987 | Tobacco Store | Location | NO | 555 1st 2nd St | Portland | OR | 97203 | Small Cigar | OR-CGR2 | N/A | 8.60 | OR | Big O's Cigarillo JR 2pk | Manufacturer 3 | 890123456 | Big O | 1.00 | FOI | 0.00 | 0.86 | 10 | 20 | 8.60 | NO | ||||||||||||||||
Out of State Tobacco Distributor | ||||
Invoice #: | 5009 | |||
Customer (Buyer) | Date: | 1/10/2019 | ||
Tobacco Store | ||||
5252 Portland St. | ||||
Portland, OR 97203 | ||||
Invoice Total: | $1,266.50 | |||
Out of State Tobacco Distributor | ||||
Invoice #: | 5013 | |||
Customer (Buyer) | Date: | 1/15/2019 | ||
Tobacco 4 Less | ||||
98922 Center St | ||||
Salem, OR 97301 | ||||
Invoice Total: | $666.75 | |||
Out of State Tobacco Distributor | ||||
CREDIT MEMO - Return Product from Inv.4500 | Invoice #: | CM5020 | ||
Customer (Buyer) | Date: | 1/22/2019 | ||
Tobacco Store | ||||
5252 Portland St. | ||||
Portland, OR 97203 | ||||
Invoice Total: | ($342.75) | |||
no reviews yet
Please Login to review.