Data Dictionary - Carrier
Table Name CAR_CARRIER_ADDRESS_DTL
Table Comment Entity to Capture all the Address details (could be many ) of the carrier who could possibly operate from different locations
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
CAD_CREATED_OU INT NOT NULL OU WHO CREATES THIS ADDRESS DETAILS ONLY THIS USER CAN MODIFY THE RECORD OTHER OUS WITHIN THIS LO CAN VIEW AND ACCESS THIS DATA- BUT THEY CAN NOT MODIFY IT No No
CAD_CREATED_BY CHAR(30) NOT NULL USER WHO CREATES THIS RECORD No No
CAD_URL CHAR(50) NULL URL No No
CAD_EMAIL CHAR(60) NULL EMAIL No No
CAD_PHONE CHAR(18) NULL PHONE No No
CAD_ADDL1 INT NULL Additional Column for Future maintenance purpose No No
CAD_ADDL2 CHAR(255) NULL Additional column for Address No No
CAD_CREATED_DATE DATETIME NOT NULL DATE OF CREATION No No
CAD_MODIFIED_DATE DATETIME NOT NULL DATE OF MODIFICATION No No
CAD_MODIFIED_BY CHAR(30) NOT NULL USER WHO MODIFIES THIS RECORD No No
CAD_ADDL3 CHAR(255) NULL Additional Column for Future maintenance purpose No No
CAD_ADDRESS_ID CHAR(6) NOT NULL ADDRESS ID OF THE CARRIER ADDRESS IDS UNIQUE WITHIN CARRIER CODE ONLY CREATED OU CAN MODIFY THIS ADDRESS DETAILS Yes No
CAD_ADDR_LINE1 CHAR(40) NOT NULL ADDRESS LINE 1 No No
CAD_ADDR_LINE2 CHAR(40) NULL ADDRESS LINE No No
CAD_CARRIER_CODE CHAR(20) NOT NULL CARRIER CODE Yes Yes
CAD_LO char(20) NOT NULL LO INFO Yes Yes
CAD_ZIPCODE CHAR(20) NOT NULL ZIP CODE No No
CAD_STATE CHAR(40) NOT NULL STATE NAME No No
CAD_COUNTRY CHAR(40) NOT NULL COUNTRY NAME No No
CAD_ADDR_LINE3 CHAR(40) NULL ADDRESS LINE No No
CAD_CITY CHAR(40) NOT NULL CITY NAME No No
CAD_CONTACT_PERSON CHAR(45) NULL CONTACT PESON NAME IN THIS ADDRESS LOCATION No No
Table Name CAR_CARRIER_DELAREA_DTL
Table Comment A Carrier can deliver the goods to different delivery areas. Those areas to which the &nbspcarrier caters to are captured in this entity.
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
CDA_MODIFIED_DATE DATETIME NOT NULL date of modification No No
CDA_MODIFIED_BY CHAR(30) NOT NULL user who modified this record No No
CDA_CREATED_DATE DATETIME NOT NULL date of creation No No
CDA_ADDL1 INT NULL Additional Column for Future maintenance purpose No No
CDA_ADDL2 CHAR(255) NULL Additional column for Address No No
CDA_ADDL3 CHAR(255) NULL Additional column for Address No No
CDA_OU INT NOT NULL OU INFO Yes Yes
CDA_LO char(20) NOT NULL LO INFO Yes Yes
CDA_CREATED_BY CHAR(30) NOT NULL user who created No No
CDA_CARRIER_CODE CHAR(20) NOT NULL CARRIER CODE Yes Yes
CDA_DELIVERY_AREACODE CHAR(18) NOT NULL DELAREA CODE MUST BE A VALID ONE DEFINED IN THE DELAREA COMPONENT Yes No
Table Name CAR_CARRIER_LO_HDR
Table Comment This Entity captures all the information of a carrier along with duration for which it is effective. It contains the delivery area supported by the carrier and the corresponding transportation mode supported for a delivery area by a carrier. Transportation Time is also captured corresponding to each transportation mode, which can be used in estimating the lead time for delivery
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
CAR_LO char(20) NOT NULL LO INFORMATION Yes No
CAR_CARRIER_CODE CHAR(20) NOT NULL CARRIER CODE MAINTAINED @LO NO SPECIAL CHARS ALLOWED Yes No
CAR_SUPPLIER_CODE CHAR(16) NULL SUPPLIER CODE IF THE SUPPLIER HAPPENS TO BE A CARRIER ALSO NO NULL CHECK IF PRESENTS, IT MUST BE A VALID SUPPLIER No No
CAR_CARRIER_NAME CHAR(25) NOT NULL NAME OF THE CARRIER MAINTAINED @ LO CAN HOLD SPECIAL CHAR No No
CAR_CARRIER_NAME_SHD CHAR(25) NOT NULL shadow column for carrier description No No
CAR_CREATED_BY CHAR(30) NOT NULL CREATED USER NAME No No
CAR_CREATED_DATE DATETIME NOT NULL DATE OF CREATION No No
CAR_MODIFIED_BY CHAR(30) NOT NULL USER WHO MODIFIES THE RECORD No No
CAR_MODIFIED_DATE DATETIME NOT NULL DATE OF MODIFICATION No No
CAR_TIMESTAMP_VALUE INT NOT NULL TIMESTAMP VALUE No No
CAR_ADDL1 INT NULL Additional Column for Future maintenance purpose No No
CAR_ADDL2 CHAR(255) NULL Additional column for Address No No
CAR_ADDL3 CHAR(255) NULL Additional column for Address No No
Table Name CAR_CARRIER_OU_HDR
Table Comment This Entity captures all the information of a carrier along with duration for which it is effective. It contains the delivery area supported by the carrier and the corresponding transportation mode supported for a delivery area by a carrier. Transportation Time is also captured corresponding to each transportation mode, which can be used in estimating the lead time for delivery
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
CAR_LO char(20) NOT NULL LO INFO Yes Yes
CAR_OU INT NOT NULL OU INFORMATION OU BELONGS TO THE SAME LO Yes No
CAR_CARRIER_CODE CHAR(20) NOT NULL CARRIER CODE Yes Yes
CAR_LANGUAGE_CODE char(5) NOT NULL LANGUAGE CODE MUST BE A VALID ONE, AVAILABLE AT CATEGORY No No
CAR_CURRENCY CHAR(10) NOT NULL CURRENCY, IN WHICH THIS CARRIER DEALS WITH COMES FROM EMOD MUST BE A VALID CURRENCY (THAT DEFINED IN EMOD) No No
car_effect_from DATETIME NOT NULL CARRIER ACTIVE FROM THIS DATE No No
car_effect_to DATETIME NOT NULL CARRIER VALID TILL THIS DATE GREATER THAN FROM DATE No No
CAR_STATUS CHAR(2) NOT NULL STATUS OF THE CARRIER ACTIVE INACTIVE CANCEL ONLY INACTIVE TO ACTIVE IS POSSIBLE CANCEL MEANS SOFT DELETE TO BE PERFORMED - MARK THE RECORD AS CANCEL No No
CAR_PREV_STATUS CHAR(2) NOT NULL PREVIOUS STATUS OF THE CARRIER No No
CAR_REASON_CODE char(5) NULL REASON CAPTURED WHILE INACTIVATING THE CARRIER MUST BE A VALID REASON DEFINED IN CATEGORY No No
CAR_CREATED_BY CHAR(30) NOT NULL USER WHO CREATES THIS RECORD No No
CAR_CREATED_DATE DATETIME NOT NULL DATE OF CREATION No No
CAR_MODIFIED_BY CHAR(30) NOT NULL USER WHO MODIFIES THIS RECORD No No
CAR_MODIFIED_DATE DATETIME NOT NULL DATE OF MODIFICATION No No
CAR_TIMESTAMP_VALUE INT NOT NULL TIMESTAMP VALUE No No
CAR_ADDL1 INT NULL Additional Column for Future maintenance purpose No No
CAR_ADDL2 CHAR(255) NULL Additional column for Address No No
CAR_ADDL3 CHAR(255) NULL Additional column for Address No No
Table Name CAR_CARRIER_STATUS_HIST
Table Comment STATUS HISTORY CAPTURES HERE THE LATEST STATUS AND THE REASON FOR CHANGING FROM PREVIOUS STATUS WILL BE MAINTAINED IN CARRIER_OU_HDR ENTITY THE PREVIOUS VERSIONS WILL BE MAINTAINED HERE IN FUTURE REPORTING PURPOSE WE CAN USE IT
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
CAR_MODIFIED_BY CHAR(30) NOT NULL USER WHO MODIFIES THIS RECORD No No
CAR_CREATED_DATE DATETIME NOT NULL DATE OF CREATION No No
CAR_CREATED_BY CHAR(30) NOT NULL USER WHO CREATES THIS RECORD No No
CAR_ADDL2 CHAR(255) NULL Additional Column for Future maintenance purpose No No
CAR_MODIFIED_DATE DATETIME NOT NULL DATE OF MODIFICATION No No
CAR_ADDL1 INT NULL Additional Column for Future maintenance purpose No No
CAR_ADDL3 CHAR(255) NULL Additional column for Address No No
CAR_OU INT NOT NULL OU INFORMATION OU BELONGS TO THE SAME LO Yes Yes
CAR_LO char(20) NOT NULL LO INFO Yes Yes
CAR_REASON_CODE char(5) NULL REASON CAPTURED WHILE INACTIVATING THE CARRIER MUST BE A VALID REASON DEFINED IN CATEGORY No No
CAR_PREV_STATUS CHAR(2) NOT NULL PREVIOUS STATUS OF THE CARRIER No No
CAR_CARRIER_CODE CHAR(20) NOT NULL CARRIER CODE Yes Yes
CAR_STATUS CHAR(2) NOT NULL STATUS OF THE CARRIER ACTIVE INACTIVE CANCEL ONLY INACTIVE TO ACTIVE IS POSSIBLE CANCEL MEANS SOFT DELETE TO BE PERFORMED - MARK THE RECORD AS CANCEL No No
Table Name CAR_CARRIER_TRANSPORT_DTL
Table Comment Entity to capture the different transporataion modes by which the carrier operates to each delivery areas. It also capture the time it takes to reach the destination point from the shipping point.
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK
CTR_CREATED_DATE DATETIME NOT NULL date of creation No No
CTR_MODIFIED_BY CHAR(30) NOT NULL user who modifies the record No No
CTR_CREATED_BY CHAR(30) NOT NULL user who created No No
CTR_Time_Days NUMERIC(28,8) NOT NULL computed column convert the time mention in units to days which can be used straight away in further transaction say in NSO No No
CTR_ADDL2 CHAR(255) NULL Additional Column for Future maintenance purpose No No
CTR_MODIFIED_DATE DATETIME NOT NULL date of modification No No
CTR_ADDL1 INT NULL Additional Column for Future maintenance purpose No No
CTR_ADDL3 CHAR(255) NULL Additional column for Address No No
CTR_OU INT NOT NULL OU info Yes Yes
CTR_CARRIER_CODE CHAR(20) NOT NULL Carrier Code Yes Yes
CTR_LO char(20) NOT NULL Lo info Yes Yes
CTR_TRANSPORT_TIME NUMERIC(28,8) NOT NULL Transport Time No No
CTR_Time_Units CHAR(2) NULL Time Units Minutes Hours Days Weeks No No
CTR_DELIVERY_AREACODE CHAR(18) NOT NULL Delivery Area Code Must be exists and valid one Yes Yes
CTR_TRANSPORT_MODE char(5) NOT NULL Transport Mode Yes No
CTR_SHIPPING_POINT INT NOT NULL Shipping Point Load alla Locations wrt to Packslip Locations from CIM Yes No