File Reference Numbers

From UG

Revision as of 01:39, 19 January 2012

Info

Parent Mantis

0000100: (Ops Misc)

Spoke of this wiki

Automate the assignment of file reference numbers (Jaguar export ref, import ref, third party ref) and their file reference sequence that are assigned to CT records.

Glossary

Export_Reference_Number

Import_Reference_Number

Third_Party_Reference_Number

AM

SOW 1

• 0003151: (Ops Misc) Have CT2 generate file ref #'s

Requirements

Gen Tab: Ops functionality

• System can auto generate file reference number

• Reference number consist of:
  • Export Reference #
    • consist of 3 parts:
      • List of Account manager that is tied to default Office- List of Account Manager for particular office
        • i.e. Drop down list with the default Account Manager, such as operator A (NY office) works for Account Manager B, this will be default to Account Manager B's number with dropdown option for all the account managers for NY office only. Do not list Account Managers for other offices on this list.
      • Automate counter - This should consist of 2 parts:
        • 1) The first 2 number XX can be auto assigned as of irrespective specific client company - this can be manged in admin
        • 2) Counter - Automated sequence number 5 digit XXXXX
        • Contents/value of this sequence depend on office/account manager
      • Mode
      • System auto provides default options dropdown once the MODE is selected by operator
        • The pair of MODE and direction with the MOT can be set in Admin
  • Import Reference #
    • consist of 3 parts:
      • List of Account manager that is tied to default Office- List of Account Manager for particular office
        • i.e. Drop down list with the default Account Manager, such as operator Y (UK office) works for Account Manager Z, this will be default to Account Manager Z's number with dropdown option for all the account managers for UK office only. Do not list Account Managers for other offices on this list.
      • Automate counter - This should consist of 2 parts:
        • 1) The first 2 number XX can be auto assigned as of irrespective specific client company - this can be manged in admin
        • 2) Counter - Automated sequence number 5 digit XXXXX
        • Contents/value of this sequence depend on office/account manager
      • Mode
      • System auto provides default options dropdown once the MODE is selected by operator
        • The pair of MODE and direction with the MOT can be set in Admin
  • Jaguar 3rd Reference#
    • consist of 3 parts:
      • List of Account manager that is tied to default Office- List of Account Manager for particular office
        • i.e. Drop down list with the default Account Manager, such as operator M (FR office) works for Account Manager N, this will be default to Account Manager N's number with dropdown option for all the account managers for FR office only. Do not list Account Managers for other offices on this list
      • Automate counter - This should consist of 2 parts:
        • 1) The first 2 number XX can be auto assigned as of irrespective specific client company - this can be manged in admin
        • 2) Counter - Automated sequence number 5 digit XXXXX
        • Contents/value of this sequence depend on office/account manager
      • Mode
      • System auto provides default options dropdown once the MODE is selected by operator
        • The pair of MODE and direction with the MOT can be set in Admin
          • ie. AE - Air Export - this can be applied to Air shipment for example
          • ie. SE - Sea/Ocean Export - this can be applied to Ocean shipment for example

Admin: File Reference #

Provide admin table to assign specific reference number to specific offices and to specific Account Manager.

Provide ability for each office to set their own sequence numbers and link these to specific Account Manager within that office.

Each of office consists of account managers, each account manager is a team leader of a group of operators such as NY office has 3 Account managers: Rob, John and Jeanine. Each account manager has their own team such as Rob has operator A, operator B and operator C work in his team. Provide ability to add/remove operator(s) to each Account Manager

• Sequence and catagory of file reference number can be set via admin

• Admin>File Reference#
• Table to manage File Reference# consist of:
  • Each office: specify by sequence of number such as sequence of range of number below:
    • NY - could be 800 - 899
    • UK - could be 700 - 799
    • FR - could be 600 - 699
    • HK - could be 500 - 599
    • SZ - could be 400 - 499
  • Each Account Manager: specify by number - subset of each office sequence number such as Account Managers below
    • Rob - NY - 801
    • John - NY - 802
    • Jeanine - NY - 803
  • Each operator: to be specified for account manager - list of operators per Account Manager
    • Rob - Operator A, operator B, operator C
    • John - Operator D, operator E, operator G
    • Jeanine - Operator H, operator I, operator J
    • Note: An operator can work for many account managers at the same time such as operator M can work for Rob and John at the same time.
  • Ability to add/remove number of opertors that work under an Account Manager and keep historical changes
  • Automate a mode/direction for the last part of file reference requence numbers
    • Mode of direction table:
      • Export: AE (Air Export), SE (Sea Export), TR(Truck Export)
      • Import: AI (Air Import), SI (Sea Import), TR(Truck Import)
      • Jaguar: CT (Cross Trade - Billing office only)
    • Mode of Transportation should be associate with Mode of direction table such as
      • Air - AE or AI depend on what field
      • Ocean (LCL) - SE or SI depend on what field
      • Ocean (FCL) - SE or SI depend on what field
      • Ocean Vendor Console - SE or SI depend on what field
      • Truck (DT - Dom) - TR
      • Truck (OT - Ocean Truck) - TR
      • Truck (AT - Air Truck) - TR
      • NOTE: This should be default to a correct direction per reference # and MOT such as the field Export Ref#, this part should auto read only default to AE if MOT for Air is selected.
  • Volume Unit per Mode Table - to be used as a report
    • Air - KG - show as KG
    • Ocean FCL - TEU or FEU count - show as TEU
    • Ocean LCL - CBM - show as CBM
    • Ocean vendor console - TEU or FEU count - show as TEU
    • Truck Dom DT - Shipment count - SHPT
    • Truck Ocean - Gross KG/LB
    • Truck Air - Gross KG/LB

Report Functionality

• Ability to report on file reference sequence numbers per Account Manager and/or per office with some information from the system

• Purpose: To know how much frieght Jaguar move, How busy for each operator is. Report for Export is the KEY to control the business.
• Report > File Reference # with ability of down load to excel spreadsheet
  • Filters:
    • Date/year Range: Calendar
    • Office
    • Account Manager - subset of office selected
    • E0. Client Company
    • Mode of Direction
  • Result:
    • Heading - Top part of the report
      • Information per filters set
    • Information Report per column option as of output
      • Office
      • Account Manager
      • E0. Client Company
      • Mode of Direction
      • Volume Unit
      • Gross Margin - refer to Alex's project. This output should be in place once this report value can be reported.

History

0003151: (Ops Misc) Have CT2 generate file ref #'s

• 3151