File Reference Numbers

From UG

(Difference between revisions)
Jump to: navigation, search
(File Reference Number Sequence per Office)
(Jag NY file reference sequence)
Line 35: Line 35:
*'''Elizabeth Arden Import file ref #'s'''
*'''Elizabeth Arden Import file ref #'s'''
**They begin with the number 87  
**They begin with the number 87  
-
**They are approximately 5 numbers long
+
**Currently they are 5 numbers long
**They end with a 2 letter code according to the MOT  
**They end with a 2 letter code according to the MOT  
***Ocean Imports = SI  
***Ocean Imports = SI  
***Air Imports = AI  
***Air Imports = AI  
 +
****'''IE: 87XXXXXSI'''
*'''Elizabeth Arden Export file ref #'s'''
*'''Elizabeth Arden Export file ref #'s'''
**They begin with the number 82
**They begin with the number 82
-
**They are approximately 5 numbers long
+
**Currently they are 5 numbers long
**They end with a 2 letter code according to the MOT  
**They end with a 2 letter code according to the MOT  
***Ocean Exports = SE
***Ocean Exports = SE
***Air Exports = AE
***Air Exports = AE
 +
****'''IE: 87XXXXXSE'''
*'''Elizabeth Arden Domestic Trucking file ref #’s'''
*'''Elizabeth Arden Domestic Trucking file ref #’s'''
**They begin with the letters DO
**They begin with the letters DO
-
**They are approximately 5 numbers long
+
**Currently they are 5 numbers long
 +
***'''IE: DOXXXXX''
 +
 
*'''Hanover Trucking records (Domestic, Air & Ocean) file ref #’s'''
*'''Hanover Trucking records (Domestic, Air & Ocean) file ref #’s'''
**They begin with the letters HDO  
**They begin with the letters HDO  
-
**They are approximately 3 numbers long
+
**Currently they are 3 numbers long
 +
***'''IE: HDOXXX''
*'''Coty Import file ref #'s'''  
*'''Coty Import file ref #'s'''  
**They begin with the numbers 89
**They begin with the numbers 89
-
**They are approximately 5 number long
+
**Currently they are 5 numbers long
**They end with a 2 letter code according to the MOT  
**They end with a 2 letter code according to the MOT  
***Ocean Imports = SI
***Ocean Imports = SI
***Air Imports = AI
***Air Imports = AI
 +
****'''IE: 89XXXXXSI''
*'''All other client companies ''Import'' file #'s'''
*'''All other client companies ''Import'' file #'s'''
**They begin with 88'''
**They begin with 88'''
-
**They are approximately 5 numbers long
+
**Currently they are 5 numbers long
**They end with a 2 letter code according to the MOT  
**They end with a 2 letter code according to the MOT  
***Ocean Imports = SI  
***Ocean Imports = SI  
***Air Imports = AI
***Air Imports = AI
 +
****'''IE: 88XXXXXSI''
*'''Consolidation Import files from other Jaguar office’s'''
*'''Consolidation Import files from other Jaguar office’s'''
**They begin with 86  
**They begin with 86  
-
**They are approximately 5 numbers long
+
**Currently they are 5 numbers long
**They end with a 2 letter code according to the MOT  
**They end with a 2 letter code according to the MOT  
***Ocean Imports = SI  
***Ocean Imports = SI  
***Air Imports = AI
***Air Imports = AI
 +
****'''IE: 86XXXXXSI''
*'''All other Export file #'s, including client company Coty
*'''All other Export file #'s, including client company Coty
**They begin with 81
**They begin with 81
-
**They are approximately 5 numbers long
+
**Currently they are 5 numbers long
**They end with a 2 letter code according to the MOT  
**They end with a 2 letter code according to the MOT  
***Ocean Exports = SE
***Ocean Exports = SE
***Air Exports = AE
***Air Exports = AE
 +
****'''IE: 81XXXXXSE''
==== Jag UK file reference sequence ====
==== Jag UK file reference sequence ====

Revision as of 17:32, 20 September 2011


Contents

Info

  • parent: 0000100: (Ops Misc)

Glossary

Business Needs

Core need

Automate the assignment of file reference numbers to CT records (Jaguar export ref, import ref, third party ref), to take the burden off individual operators. As well by managing this somewhere inside of the CT2 Admin menu, they do not keep a separate log book per office to record these numbers.

Requirements

These fields are are found on the CT records Gen tab, see CT_bo#References.

  • Have CT automatically generate/create Jaguar's file ref #’s
  • Allow user to add new file sequences
  • Add reporting capabilities
    • to report on the file sequence individually or corporately per office
  • Have some sort of admin ability for each office to set their sequence numbers, with the ability to create new sequences as each office has their own specific sequence. See #File_Reference_Number_Sequence_per_Office

Note phase I functionality would be for the user themselves to select which file reference sequence to apply to their shipment upon CT creation. With phase II for CT to auto assign these sequences according to ops user groups.

File Reference Number Sequence per Office

Each Jaguar office has a sequence of file reference #'s that they use to identify how their office is involved in the shipment, if they are arranging the import or export. Below are the current file ref sequences according to each office and how they are determined:

Jag NY file reference sequence

JFS NY – their file ref #'s are per Client Company, which is according the operation team that handles that specific client company.

  • Elizabeth Arden Import file ref #'s
    • They begin with the number 87
    • Currently they are 5 numbers long
    • They end with a 2 letter code according to the MOT
      • Ocean Imports = SI
      • Air Imports = AI
        • IE: 87XXXXXSI
  • Elizabeth Arden Export file ref #'s
    • They begin with the number 82
    • Currently they are 5 numbers long
    • They end with a 2 letter code according to the MOT
      • Ocean Exports = SE
      • Air Exports = AE
        • IE: 87XXXXXSE
  • Elizabeth Arden Domestic Trucking file ref #’s
    • They begin with the letters DO
    • Currently they are 5 numbers long
      • 'IE: DOXXXXX
  • Hanover Trucking records (Domestic, Air & Ocean) file ref #’s
    • They begin with the letters HDO
    • Currently they are 3 numbers long
      • 'IE: HDOXXX
  • Coty Import file ref #'s
    • They begin with the numbers 89
    • Currently they are 5 numbers long
    • They end with a 2 letter code according to the MOT
      • Ocean Imports = SI
      • Air Imports = AI
        • 'IE: 89XXXXXSI
  • All other client companies Import file #'s
    • They begin with 88
    • Currently they are 5 numbers long
    • They end with a 2 letter code according to the MOT
      • Ocean Imports = SI
      • Air Imports = AI
        • 'IE: 88XXXXXSI
  • Consolidation Import files from other Jaguar office’s
    • They begin with 86
    • Currently they are 5 numbers long
    • They end with a 2 letter code according to the MOT
      • Ocean Imports = SI
      • Air Imports = AI
        • 'IE: 86XXXXXSI
  • All other Export file #'s, including client company Coty
    • They begin with 81
    • Currently they are 5 numbers long
    • They end with a 2 letter code according to the MOT
      • Ocean Exports = SE
      • Air Exports = AE
        • 'IE: 81XXXXXSE

Jag UK file reference sequence

JFS UK - their file ref #'s are per mode of transportation

  • General Air Export
    • They begin with 11AE
    • They are approximately 6 numbers long
    • They end with the CT #
  • General Sea Import
    • They begin with 22SI
    • They are approximately 6 numbers long
    • They end with the CT #
  • Consolidation
    • They begin with 44CO
    • They are approximately 6 numbers long
    • They end with the CT #
  • General Sea Export
    • They begin with 12SE
    • They are approximately 6 numbers long
    • They end with the CT #
  • General Air Import
    • They begin with 21AI
    • They are approximately 6 numbers long
    • They end with the CT #

Jag FR file reference sequence

JFS FR – their file ref #’s are per mode of transportation as follows

  • AIR EXPORT
    • They begin with AE, then the year and the month
    • They are approximately 7 numbers long
    • They end with 3 numbers
        • Example: AI1108001
  • AIR IMPORT
    • They begin with AI, then the year and the month
    • They are approximately 7 numbers long
    • They end with 3 numbers
  • SEA EXPORT
    • They begin with SE, then the year and the month
    • They are approximately 7 numbers long
    • They end with 3 numbers
  • SEA IMPORT
    • They begin with SI, then the year and the month
    • They are approximately 7 numbers long
    • They end with 3 numbers
  • DOMESTIC TRUCK
    • They begin with RE, then the year and the month
    • They are approximately 7 numbers long
    • They end with 3 numbers

Jag HK file reference sequence

JFS HK – their file ref #’s, which they call Job numbers, and are per mode of transportation as follows:

  • Air Export
    • They begin with HK, then the year

HK111xxxxx = Air export HKD112xxxxx = Air import HK113xxxxx = Ocean export HKD114xxxxx = Ocean import

“HK” stands for JFS HK & “11” stands for 2011

Jag Shenzhen file reference sequence

JFS SZX - their file ref #’s, which they call Job register, are per mode of transportation as follows:

SZ111xxxxx = Air export SZ112xxxxx = Air import SZ113xxxxx = Ocean export SZ114xxxxx = Ocean import

“SZ” stands for JFS SZX & “11” stands for 2011

Personal tools