File Reference Numbers

From UG

Contents 1 Info 2 Glossary 3 Business Needs 3.1 Core need 4 Requirements 4.1 Admin Functionality 4.2 Ops Functionality 5 Marc's Mockup IE 5.1 Admin Mockup 5.2 Gen Tab Mockup

Info

• parent: 0000100: (Ops Misc)
• Mantis Task info: 3151

Glossary

Export_Reference_Number

Import_Reference_Number

Third_Party_Reference_Number

AM

Business Needs

Core need

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.

Requirements

Admin Functionality

• Add Admin Table to assign specific reference numbers, to specific offices and to specific AM.
• Add ability for each office to set their own sequence numbers and link these to specific AM within that office.
  • IE given by Marc is to set a specific "100" number to each AM, allowing them to create up to 99 more sequences associated with their team.
• Add ability to associate a file reference sequence to an AM, including the JFS office that the AM is a part of.
• Add ability to list the number of operators that work under an AM and keeping historical changes.
• Number preferred to be in half numbers, 0.5,1,1.5,2,2.5, etc, as some operators handle work for 2 separate AM's.
  • IE, user Gabrielle O'Flaherty handles ALL air export shipments. She handles both the Elizabeth Arden Air Export shipments, which are under AM Robert Link's responsibilities and the Coty Air Export shipments, which are under AM Jeanine Favia's responsibilities.
• Add ability to record the Mode/Direction for file reference sequence numbers associated with each AM.
• Add ability to report on file reference sequence numbers per AM and/or per office See #Admin_Mockup

• See #Admin_Mockup

Ops Functionality

These file reference numbers are entered by ops users on the Gen Tab under CT_bo#References.

• Add ability for ops user to select file reference sequence numbers on Gen Tab's CT_bo#References fields.
• Have system automatically generate the file reference number.
• Have the system auto assign the Mode/Direction according to the selected/set CT_bo#MOT in the CT.
• System should record the update to reference numbers in the CT updates log.
• System should allow user to change the MOT after a reference number is assigned.
• System should automatically change the Mode/Direction that's assigned to their reference number after user changes the MOT.

File ref IE, given by Marc - Numbering: Should be displayed as follows:
801	(3 digit ID code)
199999 (numerical – actual ‘ref’ number
XX (mode/direction)
Example:   80199999XX

Marc's Mockup IE

Admin Mockup

Gen Tab Mockup