Spreadsheet: 117721d1312986150-printing-certain-areas-temp
Sheet: INPUT

 |  |  |  | Store # | Amount DR/(CR) | Co. Code | Alternate Doc. Dates (YYYY/MM/DD) | Alternate Reference Texts | Alternate Line Texts | Invoice # | Alternate Tax Codes | Alternate 4200 GL | Alternate 4200 PC (xxxx-xxx) | Alternate Retail GL | Alternate Retail PC ('-xxx)
 | DATA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tax Codes |  | Profitability Segment GL's
 | Doc Date (YYYYMMDD) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AJ - HST 13% ([NAME]) |  | 301100 | Credit Sales - external
 | Post Date (YYYYMMDD) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CJ - HST 13% (DO NOT USE) |  | 301105 | Sales - manual adjustments
 | Bline Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SH - HST 13% (Full) |  | 301500 | Drop Shipment Sales - external
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 302100 | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 331100 | Tobacco Terms Equalization
 | Assgn Txt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 331700 | Drop Shipment Purchases
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Retail Profit Centres |  | 332100 | Cost of Goods Sold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 001 - Meat |  | 332207 | Offset to Perishable MM Inventory |  | -001
 | Tax Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 002 - Produce |  | 333150 | CS Promo Reimbursement |  | -002
 | [NAME] | CAON |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 003 - Grocery |  | 333850 | National Merchandising Allowance Income |  | -003
 | Prov Tax Ind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 004 - GM |  | 334710 | Purchases - Tobacco Tax |  | -004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 005 - Bakery |  | 334800 | Rebates Paid |  | -005
 | 4200 GL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 006 - Front End |  | 334805 | [NAME] by store |  | -006
 | 4200 PC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 007 - Admin |  | 335200 | Volume Rebate |  | -007
 | Retail GL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 008 - Seafood |  | 335210 | Volume Rebate manual adj to store level |  | -008
 | Retail PC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 009 - Bulk |  | 335901 | Goods Issued - Inventory Change |  | -009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 014 - Floral |  | 384850 | [NAME] |  | -014
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 017 - Deli |  |  |  |  | -017
 |  | REQUIRED FIELDS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 018 - Tobacco |  |  |  |  | -018
 |  | CHOICE FIELDS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 023 - OTC & HABA |  |  |  |  | -023
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 071 - Gas |  |  |  |  | -071
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 073 - Lottery |  |  |  |  | -073
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 117 - Beer |  |  |  |  | -117
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 203 - Commercial Bakery |  |  |  |  | -203
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 225 - Liquor |  |  |  |  | -225
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 232 - Natural Foods |  |  |  |  | -232
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 249 - Other Front End Services |  |  |  |  | -249
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 250 - Books & Magazines |  |  |  |  | -250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 326 - Workforce Management |  |  |  |  | -326