@model EasyApp.Models.InvHead @using EasyApp.Models @{ Layout = "~/Views/Shared/_LayoutExcise.cshtml"; } Export Data @**@
Export eInvoice Data
Invoice No : @Model.InvRefID (SYSID:@Model.InvID)
Transaction Reference Number@Model.InvIDExternal Reference Number
Supply Type@Model.SupplyTypeProject Reference Number
Invoice Reference NumberPO Date
Invoice Type@Model.InvoiceTypeSupporting Document URL
Invoice Number@Model.InvRefIDOther Supporting Document
Invoice Date@Convert.ToString(Model.InvDate.Value.ToString("dd-MM-yyyy"))Any Other Additional Information
Invoice Value@Model.GrandAmtTotal Invoice Value in Foreign Currency
Department NameOption for Supplier for Refund
Department IDForeign Currency
PO NumberCustomer Country Code
Transaction Type@Model.TRNTypeTotal Taxable Value@Model.TaxableAmt
Transaction Subtype@Model.TRNSubTypeTotal IGST Amount@Model.ItemIGSTAmt
Place of Supply@Model.OMAddress.State.VechCodeTotal CGST Amount@Model.ItemCGSTAmt
Origin CountryTotal SGST/UTGST Amount@Model.ItemSGSTAmt
Org Code@Model.OMAddress2.GSTCodeTotal Cess Amount
Supplier CodeTotal State Cess Amount
Supplier Location CodeRounding Off Amount
Supplier GSTIN/UIN@Model.OMAddress2.GSTCodeDiscount at Invoice level
Buyer CodeCharges at Invoice level@Model.OtherTaxAmt
Buyer Location CodeFlag for Supply covered under sec7 of IGST Act
Buyer GSTIN/UIN@Model.OMAddress.GSTCodeOriginal Invoice Value@Model.GrandAmt
Supplier PANOriginal POS
Reverse Charge@Model.ReverseChargeOriginal Transaction Type
Supplier Legal Name@Model.OMAddress2.PartyNameOriginal Transaction ID
Supplier Trade NameLALIT PIPESDifferential Percentage
Supplier Address1SURVEY NO. 77, VILLAGE VARASKOL, KHARDI RLY. STN. (CR)Supply Category
Supplier Address2TALUKA SHAHPUR, DIST THANE, 421601Line item ID
Supplier CitySHAHAPURGoods/Services
Supplier StateMHHSN Code
Supplier PINCode421601Schedule Description Code
Supplier EmailIDHSN Description
Supplier Phone NumberExemption Notification No
Buyer Trade NameCompensation Cess Description Code
Buyer Legal Name@Model.OMAddress.PartyNameRCM Description Code
Buyer Address1@Model.OMAddress.Address2Bar code of Product
Buyer Address2@Model.OMAddress.Address3Quantity
Buyer City@Model.OMAddress.CityFree Quantity
Buyer State@Model.OMAddress.State.VechCodeUQC
Buyer PIN Code@Model.OMAddress.PinCodeRate per Quantity
Buyer EmailIDGrossValue
Buyer Phone NumberDiscount Before GST
Dispatch CodePre Taxable Value
Dispatch GSTIN@Model.OMAddress2.GSTCodeTaxable Value
Dispatch Name@Model.OMAddress2.PartyNameBatch Name
Dispatch Address1@Model.OMAddress2.Address2Warranty Date
Dispatch Address2@Model.OMAddress2.Address3Expiry Date
Dispatch City@Model.OMAddress2.CityGSTRate
Dispatch State@Model.OMAddress2.State.VechCodeCess Rate
Dispatch PIN Code@Model.OMAddress2.PinCodeState Cess Rate
Dispatcher EmailIDCess Non Advol Value
Dispatcher Phone NumberIGST Amount
Ship CodeCGST Amount
Ship to Legal Name@Model.OMAddress1.PartyNameSGST/UTGST Amount
Ship to Trade NameCompensation Cess Amount
Ship to GSTIN@Model.OMAddress1.GSTCodeState Cess Amount
Ship to Address1@Model.OMAddress1.Address2State Cess Non Advol Amount
Ship to Address2@Model.OMAddress1.Address3Other Charges
Ship to City@Model.OMAddress1.CityPO Line Reference Number
Ship to State@Model.OMAddress1.State.VechCodeProduct Serial Number
Ship to PINCode@Model.OMAddress1.PinCodeAttribute Details
Receiver EmailIDAttribute Value
Receiver PhoneNumberEWBSubSupply Type@Model.EWB_SUBTYPE
ECommerce GSTINEWB SubSupply Type Description
Payee NameEWB Transaction Type@Model.EWB_TRN_TYPE
Payment ModeTransport Mode@Model.TrnMode
Bank Account NumberType of Cargo@Model.TYPE_OF_CARGO
Bank IFSC codeDistance level(km)@Model.DISTANCE_LEVEL
Payment Terms Transporter Name @if (Model.TransporterID != null) { @Model.OMAddress3.PartyName }
Payment Instructions Transporter ID @if (Model.TransporterID != null) { @Model.OMAddress3.GSTCode }
Credit Transfer TermsTransport Document No@Model.LRNO
Direct Debit TermsTransport Document Date
Credit DaysTransportere-mail@Model.VechNo
Amount PaidVehicle No
Amount DueEntity-1
Due DateEntity-2
Shipping Bill NumberEntity-3
Shipping Bill DateEntity-4
Export Duty AmountInvoice Remarks
Port CodeValidate INV
Tax SchemeGenerate Proforma
Invoice Currency CodeAuto Generate Invoice No
Invoice Period Start Date01-04-2022Auto Generate IRN@Model.AutoGenIRN
Invoice Period End Date31-03-2023Auto Generate EWB@Model.AutoGenEWB
Preceding Invoice Number
Preceding Invoice Date
Other Reference Number
Receipt Advice Number
Receipt Advice Date
Lot/Batch Reference Number
Contract Reference Number
@foreach (var exceldata in Model.InvItems) { }
ID UOM HSN HSNDES GOODSSERVICES SUPPLYCAT Rate QTYUOM QTYValue GST% IGSTAmt SGSTAmt CGSTAmt
@exceldata.InvItemID @exceldata.UOM @exceldata.HSN @exceldata.HSNDES @exceldata.GOODSSERVICES @exceldata.SUPPLYCAT @exceldata.Rate @exceldata.QTYUOM @exceldata.QTYValue @Convert.ToDecimal(exceldata.CGSTRate.Value + exceldata.SGSTRate.Value + exceldata.IGSTRate) @exceldata.IGSTAmt @exceldata.SGSTAmt @exceldata.CGSTAmt
@*Want two space between Buyer and Location word*@ @*Want two space between Transaction and Date word*@ @foreach (var exceldata in Model.InvItems) { }
Transaction Reference Number Supply Type Invoice Reference Number Invoice Type Invoice Number Invoice Date Invoice Value Department Name Department ID PO Number Transaction Type Transaction Subtype Place of Supply Origin Country Org Code Supplier Code Supplier Location Code Supplier GSTIN/UIN Buyer Code Buyer Location Code Buyer GSTIN/UIN Supplier PAN Reverse Charge Supplier Legal Name Supplier Trade Name Supplier Address 1 Supplier Address 2 Supplier City Supplier State Supplier PIN Code Supplier E mail ID Supplier Phone Number Buyer Trade Name Buyer Legal Name Buyer Address 1 Buyer Address 2 Buyer City Buyer State Buyer PIN Code Buyer E mail ID Buyer Phone Number Dispatch Code Dispatch GSTIN Dispatch Name Dispatch Address 1 Dispatch Address 2 Dispatch City Dispatch State Dispatch PIN Code Dispatcher E mail ID Dispatcher Phone Number Ship Code Ship to Legal Name Ship to Trade Name Ship to GSTIN Ship to Address 1 Ship to Address 2 Ship to City Ship to State Ship to PIN Code Receiver E mail ID Receiver Phone Number E Commerce GSTIN Payee Name Payment Mode Bank Account Number Bank IFSC code Payment Terms Payment Instructions Credit Transfer Terms Direct Debit Terms Credit Days Amount Paid Amount Due Due Date Shipping Bill Number Shipping Bill Date Export Duty Amount Port Code Tax Scheme Invoice Currency Code Invoice Period Start Date Invoice Period End Date Preceding Invoice Number Preceding Invoice Date Other Reference Number Receipt Advice Number Receipt Advice Date Lot/Batch Reference Number Contract Reference Number External Reference Number Project Reference Number PO Date Supporting Document URL Other Supporting Document Any Other Additional Information Total Invoice Value in Foreign Currency Option for Supplier for Refund Foreign Currency Customer Country Code Total Taxable Value Total IGST Amount Total CGST Amount Total SGST/UTGST Amount Total Cess Amount Total State Cess Amount Rounding Off Amount Discount at Invoice level Charges at Invoice level Flag for Supply covered under sec 7 of IGST Act Original Invoice Value Original POS Original Transaction Type Original Transaction ID Differential Percentage Supply Category Line item ID Goods/Services HSN Code Schedule Description Code HSN Description Exemption Notification No Compensation Cess Description Code RCM Description Code Bar code of Product Quantity Free Quantity UQC Rate per Quantity Gross Value Discount Before GST Pre Taxable Value Taxable Value Batch Name Warranty Date Expiry Date GST Rate Cess Rate State Cess Rate Cess Non Advol Value IGST Amount CGST Amount SGST/ UTGST Amount Compensation Cess Amount State Cess Amount State Cess Non Advol Amount Other Charges PO Line Reference Number Product Serial Number Attribute Details Attribute Value EWB Sub Supply Type EWB Sub Supply Type Description EWB Transaction Type Transport Mode Type of Cargo Distance level(km) Transporter Name Transporter ID Transport Document No Transport DateTransporter e-mail Vehicle No Entity-1 Entity-2 Entity-3 Entity-4 Invoice Remarks Validate INV Generate Proforma Auto Generate Invoice No Auto Generate IRN Auto Generate EWB
@exceldata.InvID @exceldata.InvHead.SupplyType @exceldata.InvHead.InvoiceType @exceldata.InvHead.InvRefID @Convert.ToString(exceldata.InvHead.InvDate.Value.ToString("dd-MM-yyyy")) @exceldata.InvHead.GrandAmt @exceldata.InvHead.TRNType @exceldata.InvHead.TRNSubType @exceldata.InvHead.OMAddress.State.VechCode @exceldata.InvHead.OMAddress2.GSTCode @exceldata.InvHead.OMAddress2.GSTCode @exceldata.InvHead.OMAddress.GSTCode @exceldata.InvHead.ReverseCharge @exceldata.InvHead.OMAddress2.PartyName LALIT PIPES SURVEY NO. 77, VILLAGE VARASKOL, KHARDI RLY. STN. (CR) TALUKA SHAHPUR, DIST THANE, 421601 SHAHAPUR MH 421601 @exceldata.InvHead.OMAddress.PartyName @exceldata.InvHead.OMAddress.Address2 @exceldata.InvHead.OMAddress.Address3 @exceldata.InvHead.OMAddress.City @exceldata.InvHead.OMAddress.State.VechCode @exceldata.InvHead.OMAddress.PinCode @exceldata.InvHead.OMAddress2.GSTCode @exceldata.InvHead.OMAddress2.PartyName @exceldata.InvHead.OMAddress2.Address2 @exceldata.InvHead.OMAddress2.Address3 @exceldata.InvHead.OMAddress2.City @exceldata.InvHead.OMAddress2.State.VechCode @exceldata.InvHead.OMAddress2.PinCode @exceldata.InvHead.OMAddress1.PartyName @exceldata.InvHead.OMAddress1.GSTCode @exceldata.InvHead.OMAddress1.Address2 @exceldata.InvHead.OMAddress1.Address3 @exceldata.InvHead.OMAddress1.City @exceldata.InvHead.OMAddress1.State.VechCode @exceldata.InvHead.OMAddress1.PinCode 01-04-2023 31-03-2024 @exceldata.InvHead.TaxableAmt @exceldata.InvHead.ItemIGSTAmt @exceldata.InvHead.ItemCGSTAmt @exceldata.InvHead.ItemSGSTAmt @Convert.ToDecimal(exceldata.InvHead.OtherTaxAmt + exceldata.InvHead.TCSAmt) @exceldata.InvHead.GrandAmt @exceldata.SUPPLYCAT @exceldata.InvItemID @exceldata.GOODSSERVICES @exceldata.HSN @exceldata.HSNDES @exceldata.QTYUOM @exceldata.UOM @exceldata.Rate @exceldata.QTYValue @exceldata.QTYValue @Convert.ToDecimal(exceldata.CGSTRate.Value + exceldata.SGSTRate.Value + exceldata.IGSTRate) @exceldata.IGSTAmt @exceldata.CGSTAmt @exceldata.SGSTAmt @exceldata.InvHead.EWB_SUBTYPE @exceldata.InvHead.EWB_TRN_TYPE @exceldata.InvHead.TrnMode @exceldata.InvHead.TYPE_OF_CARGO @exceldata.InvHead.DISTANCE_LEVEL @if (Model.TransporterID != null) { @exceldata.InvHead.OMAddress3.PartyName } @if (Model.TransporterID != null) { @exceldata.InvHead.OMAddress3.GSTCode } @exceldata.InvHead.LRNO @if (exceldata.InvHead.LRDate == null) { } else { @Convert.ToString(exceldata.InvHead.LRDate.Value.ToString("dd-MM-yyyy")) } @exceldata.InvHead.VechNo @exceldata.InvHead.AutoGenIRN @exceldata.InvHead.AutoGenEWB