Sample MIS

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

Import Data Warehouse Data

SHIPPER NAME VSL SAP/Manual for GTM Vendor's name


INBOUND NO VSL SAP/Manual for GTM Fixed space (in sq. ft.)

LC NO VSL SAP/Manual for GTM Additional space


LC DATE VSL SAP/Manual for GTM Month of bill date
LC RECEIVED DT VSL SAP/Manual for GTM Bill no
INVOICE NO/ VSL SAP/Manual for GTM Bill Date
PO NO(Material) VSL SAP/Manual for GTM Head

B/L NO/ PO no
VSL SAP/VSLL SAP
Container no SRN NO
MANUAL/ Field available
FF VSLL SAP SRN DATE
SHIPPING LINE VSLL SAP ENTRY SHEET NO
Cargo ready date MANUAL AMOUNT
Actual pick Up Dt/ MANUAL SO NO
Shipment Date VSL SAP/Manual for GTM SO AMOUNT
Ocean Freight Manual Remarks
FINAL Ocean Freight Manual
ATA AT TRNSIP VSL SAP
ATD TRANSIP VSL SAP
PROJECTED ETA VSL SAP
ETA MANUAL
ATA VSL SAP
ETA AT PLANT VSL SAP
REQUIRED AT FALTA MANUAL
POL VSL SAP
POD VSL SAP
NO OF CONTAINER VSLL SAP
CONTAINER SIZE MANUAL
INCOTERM VSL SAP
COMMODITY VSL SAP
QNTY ( PCS) VSL SAP
Mother Vessel MANUAL
FEDER VESSEL MANUAL
Document Handover Status CHA MANUAL
Documentstatus MANUAL
INW DATE MANUAL
IGM DETAIS MANUAL
DELIVERY DATE VSL SAP
REMARKS MANUAL
SHIPPING LINE PO NO (All PO against
1 BL), will be multiple VSLL SAP
CONTRACT NO VSLL SAP
SO NO VSLL SAP
ORIGIN VSLL SAP
FREIGHT VSLL SAP
LOCAL CHARGES VSLL SAP
CUSTOMS BROKER VSLL SAP
TRANSPORTATION VSLL SAP
REIMBURSEMENT VSLL SAP
OTHER CHARGES VSLL SAP
CFS VSLL SAP
PORT / CFS RENT VSLL SAP
REFFER ELECTRICITY CHARGES VSLL SAP
REFFER MONITORING CHARGES VSLL SAP
VEHICLE DETENTION VSLL SAP
CONTAINER DETENTION VSLL SAP
OTHER CHARGES VSLL SAP
TOTAL COST VSLL SAP
CREDIT NOTE VSLL SAP
CARGO READY TO SHIPMENT MANUAL
PORT TO PORT Calculated

WAITING TIME AT TRANSHIPMENT MANUAL


MAA PORT ATD TO WH MANUAL
REFFER COST MANUAL
IGM NO MANUAL
BOE NO MANUAL
DATE MANUAL
TOTAL REVENUE Calculated
Warehouse Data Export Data
VSLL SAP Segment (internal/ External) manual
Manual/SAP Text MW manual
Location SAP
Manual/SAP text POL SAP Text/ Manual
VSLL SAP POD SAP Text/ Manual
VSLL SAP SHIPPING LINE SAP
VSLL SAP FORWARDER SAP
VSLL SAP CUSTOMER SAP
VSLL SAP
BOOKING NO. Manual
VSLL SAP
B/LADING NO. SAP
VSLL SAP FEEDER VESSEL Manual
VSLL SAP Expected SAILING DT. Manual
VSLL SAP Actual Sailing Date Manual
VSLL SAP Month Manual
VSLL SAP ETA T/S PORT manual
Manual MAINLINE VESSEL manual
T/S SAILING DT. manual
ETA POD Manual
NO.OF CNTRS SAP Text
AIR / LCL (CBM) SAP Text
CNTR TYPE manual
AGREED RATE/ CONT SAP
TOTAL FREIGHT ( USD ) SAP Text
EXCH RATE SAP Text
FREIGHT ( INR ) SAP
SHIPPING LINE LOCAL CHARGES SAP
GST / TAX SAP
TOTAL FRT + LOCAL CHARGES + Calculated
PO Number SAP
SO Number SAP
Sales Amount SAP
NITCO CHARGES SAP
GST SAP
DET /MISC CHARGES SAP
TTL VENDOR CHRG Calculated
PO Number SAP
SO Number SAP
Sales Invoice No SAP
Invoice Date SAP

Destination charges in USD SAP


Sales Amount without tax SAP
COST WITHOUT TAX SAP
VSL Invoice reference VSL SAP
Reimbursement charges SAP
Transportation Charges SAP
Clearing Charges SAP
CFS SAP
Selling O/F in USD SAP Text
Road Data
Segment
Indent Date Manual s factor

Placement Date Manual s factor


Loading Date/Created Date SAP
Release Date/Exit Date SAP Exception applied/ s factor
Process Owner Manual Not required
Shipment Type Manual
Vehicle Type
SAP
Vehicle No.
SAP
Driver Info. SAP
LR No. SAP
Virtual LR No. SAP
Vendor Name SAP
Client/Project Name SAP
From Manual
To Manual Manualy taken from full address
Zone Manual
Trip Cost (Rs.) SAP PO
Cost Type Manual
Freight Cost/Revenue (Rs.) SAP LE
Material Type SAP
Invoice No. SAP
WP SAP
Quantity (Pcs) SAP
Pallet/Box Qty. Manual Calculated
Total KW SAP
Total WP SAP
Cost/WP/Unit Manual Calculated
E-Way Bill No. SAP
E-waybill Validity Manual
PO SAP
Distance (Kms) Manual
E_TAT_Days Manual
E_TAT_HRS Manual
Actual TAT Manual
Loading Detention_Hrs Manual
Reporting Date Manual
Unloading Date Manual
Unloading Detention_HRS
Manual
EPOD_Status Manual
Transporter Bill No Manual
Bill Date Manual
SRN No. SAP
SRN DATE SAP
Falta SO No. SAP
Dankuni SO No. SAP
Vendor Payment Date SAP
Remarks Manual
Vehicle report date POD/S-factor
Vehicle unloading date POD/S-factor

You might also like