\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{Heather (Milollmax)}
\pdfinfo{
  /Title (banner-finance-shortcuts-and-codes.pdf)
  /Creator (Cheatography)
  /Author (Heather (Milollmax))
  /Subject (BANNER FINANCE shortcuts and codes Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{3333CC}
\definecolor{LightBackground}{HTML}{F2F2FB}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{BANNER FINANCE shortcuts and codes Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{Heather (Milollmax)} via \textcolor{DarkBackground}{\uline{cheatography.com/214345/cs/46984/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}Heather (Milollmax) \\
  \uline{cheatography.com/milollmax} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Published 4th September, 2025.\\
   Updated 4th September, 2025.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{3}

\begin{tabularx}{5.377cm}{p{0.89586 cm} x{4.08114 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Vendor - Banner Number}}  \tn
% Row 0
\SetRowColor{LightBackground}
35300 & Advanced Office \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
98220 & Aqua Science \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
93260 & BioAnalytical Labs \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
93900 & BioMed Plus (James Blount) \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
2150 & Caplan's \tn 
% Row Count 5 (+ 1)
% Row 5
\SetRowColor{white}
37570 & Cintas \tn 
% Row Count 6 (+ 1)
% Row 6
\SetRowColor{LightBackground}
42460 & Cole Parmer \tn 
% Row Count 7 (+ 1)
% Row 7
\SetRowColor{white}
85560 & Culligan (Delta) \tn 
% Row Count 8 (+ 1)
% Row 8
\SetRowColor{LightBackground}
56210 & Environmental Express \tn 
% Row Count 9 (+ 1)
% Row 9
\SetRowColor{white}
31710 & ERA Waters \tn 
% Row Count 10 (+ 1)
% Row 10
\SetRowColor{LightBackground}
102130 & Eurofins \tn 
% Row Count 11 (+ 1)
% Row 11
\SetRowColor{white}
3830 & FedEx \tn 
% Row Count 12 (+ 1)
% Row 12
\SetRowColor{LightBackground}
16690 & Fisher Scientific \tn 
% Row Count 13 (+ 1)
% Row 13
\SetRowColor{white}
4570 & HACH \tn 
% Row Count 14 (+ 1)
% Row 14
\SetRowColor{LightBackground}
36240 & IDEXX \tn 
% Row Count 15 (+ 1)
% Row 15
\SetRowColor{white}
103080 & J M Test \tn 
% Row Count 16 (+ 1)
% Row 16
\SetRowColor{LightBackground}
85730 & Microgenics \tn 
% Row Count 17 (+ 1)
% Row 17
\SetRowColor{white}
39520 & Office Depot \tn 
% Row Count 18 (+ 1)
% Row 18
\SetRowColor{LightBackground}
62630 & Progressive Security (gate) \tn 
% Row Count 19 (+ 1)
% Row 19
\SetRowColor{white}
30790 & Sigma Aldrich RTC \tn 
% Row Count 20 (+ 1)
% Row 20
\SetRowColor{LightBackground}
102370 & SPL Kilgore \tn 
% Row Count 21 (+ 1)
% Row 21
\SetRowColor{white}
97040 & Swift Comply \tn 
% Row Count 22 (+ 1)
% Row 22
\SetRowColor{LightBackground}
92670 & ThermoElectron North America \tn 
% Row Count 23 (+ 1)
% Row 23
\SetRowColor{white}
97560 & ThermoFisher (Asheville) \tn 
% Row Count 24 (+ 1)
% Row 24
\SetRowColor{LightBackground}
19390 & VWR Scientific \tn 
% Row Count 25 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{3.43413 cm} x{1.54287 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{OPEN Purchase Orders  -  FY26}}  \tn
% Row 0
\SetRowColor{LightBackground}
Advanced Office & P1145977 \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
BioAnalytical Labs & P1145978 \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Cintas & P1145980 \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
Eurofins & P1145979 \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
Express Employment & P1145989 \tn 
% Row Count 5 (+ 1)
% Row 5
\SetRowColor{white}
FedEx & P1145981 \tn 
% Row Count 6 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.4977 cm} p{0.4977 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{OPEN Purchase Orders  -  FY28}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{Advanced Office} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{BioAnalytical Labs} \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{Cintas} \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{Eurofins} \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{} \tn 
% Row Count 4 (+ 0)
% Row 5
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{FedEx} \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.89586 cm} x{4.08114 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{General Ledger - Departmental Accouting Codes}}  \tn
% Row 0
\SetRowColor{LightBackground}
520105 & Contract Lsbor \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
520204 & Uniforms \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
520400 & Office Supplies \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
520500 & Operating Supplies \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
520503 & Operating Chemicals \tn 
% Row Count 5 (+ 1)
% Row 5
\SetRowColor{white}
531206 & Services-Other \tn 
% Row Count 6 (+ 1)
% Row 6
\SetRowColor{LightBackground}
531215 & Fees, Licenses and Permits \tn 
% Row Count 7 (+ 1)
% Row 7
\SetRowColor{white}
531301 & Vehicle-Oil\&Gas \tn 
% Row Count 8 (+ 1)
% Row 8
\SetRowColor{LightBackground}
531304 & \seqsplit{Vehicle-Repairs\&Maintenance} \tn 
% Row Count 9 (+ 1)
% Row 9
\SetRowColor{white}
531410 & Telephone \tn 
% Row Count 10 (+ 1)
% Row 10
\SetRowColor{LightBackground}
531500 & Printing \tn 
% Row Count 11 (+ 1)
% Row 11
\SetRowColor{white}
543002 & Dues \& Subscriptions \tn 
% Row Count 12 (+ 1)
% Row 12
\SetRowColor{LightBackground}
543003 & Travel \& Training \tn 
% Row Count 13 (+ 1)
% Row 13
\SetRowColor{white}
605106 & Maintenance-Equipment \tn 
% Row Count 14 (+ 1)
% Row 14
\SetRowColor{LightBackground}
707405 & Building Improvements \tn 
% Row Count 15 (+ 1)
% Row 15
\SetRowColor{white}
707500 & Vehicle \tn 
% Row Count 16 (+ 1)
% Row 16
\SetRowColor{LightBackground}
707600 & Machinary \& Equipment \tn 
% Row Count 17 (+ 1)
% Row 17
\SetRowColor{white}
707700 & Office Furniture \& Fixture \tn 
% Row Count 18 (+ 1)
% Row 18
\SetRowColor{LightBackground}
707702 & Computer Software \tn 
% Row Count 19 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{FUND - ORGANIZATION - GL/ACCOUNTING  \newline   401  -       258103          - (choose appropriate code) \newline  \newline Example: Invoice for ink cartridges would be coded as follows: \newline                  401-258103-520400}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.4977 cm} p{0.4977 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{OPEN Purchase Orders  -  FY27}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{Advanced Office} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{BioAnalytical Labs} \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{Cintas} \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{Eurofins} \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{} \tn 
% Row Count 4 (+ 0)
% Row 5
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{FedEx} \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.4977 cm} p{0.4977 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{OPEN Purchase Orders  -  FY 29}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{Advanced Office} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{BioAnalytical Labs} \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{Cintas} \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{Eurofins} \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{} \tn 
% Row Count 4 (+ 0)
% Row 5
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{FedEx} \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.74655 cm} x{4.23045 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Most Used Banner Pages}}  \tn
% Row 0
\SetRowColor{LightBackground}
\seqsplit{FPIOPOV} & PO by Vendor \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\seqsplit{FGIOENC} & Open PO by Department \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\seqsplit{FAIVNDH} & Invoice paid to vendor \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
\seqsplit{FGIENCD} & PO Activity/Balance \tn 
% Row Count 8 (+ 2)
% Row 4
\SetRowColor{LightBackground}
\seqsplit{FGIBAVL} & Available Budget \tn 
% Row Count 10 (+ 2)
% Row 5
\SetRowColor{white}
\seqsplit{FTIIDEN} & Vendor Search \tn 
% Row Count 12 (+ 2)
% Row 6
\SetRowColor{LightBackground}
\seqsplit{FOAAINP} & Requisition Approval level \tn 
% Row Count 14 (+ 2)
% Row 7
\SetRowColor{white}
\seqsplit{FOAUAPP} & Approve Requisitions \tn 
% Row Count 16 (+ 2)
% Row 8
\SetRowColor{LightBackground}
\seqsplit{FGITRND} & Detailed activity listing by department \tn 
% Row Count 18 (+ 2)
% Row 9
\SetRowColor{white}
\seqsplit{FPAREQN} & Enter Requisition \tn 
% Row Count 20 (+ 2)
% Row 10
\SetRowColor{LightBackground}
\seqsplit{FPIOPOF} & Open Po's by account number \tn 
% Row Count 22 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{PO Increase - Email Format}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{5.377cm}}{Please increase the following purchase order: \newline % Row Count 1 (+ 1)
             - Purchase order \# and Vendor name \newline % Row Count 2 (+ 1)
             - Increase reason \newline % Row Count 3 (+ 1)
             - Increase amount \newline % Row Count 4 (+ 1)
             - Fund-Org-GL% Row Count 5 (+ 1)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{5.377cm}}{Increase requests under \$1000 can go straight to purchasing for processing.  \newline Increase requests over \$1000 must be approved by division director and finance manager before being processed by purchasing. \newline  \newline Requests are to be emailed to the two PO's and invoice techs.  \newline They are currently as follows: \newline Robert Winters \newline Robert.Winters@cityofalex.com \newline Floyd Rue - Floyd.Rue@cityofalex.com \newline UPDATE CONTACTS WHEN NEEDED: \newline  \newline  \newline  \newline -{}-}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.4977 cm} p{0.4977 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{OPEN Purchase Orders  -  FY30}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{Advanced Office} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{BioAnalytical Labs} \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{Cintas} \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{Eurofins} \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{} \tn 
% Row Count 4 (+ 0)
% Row 5
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{FedEx} \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}