Emplyee Data

Invoice No : @Model.InvRefID (SYSID:@Model.InvID)

Transaction Reference Number	@Model.InvID	External Reference Number
Supply Type	@Model.SupplyType	Project Reference Number
Invoice Reference Number		PO Date
Invoice Type	@Model.InvoiceType	Supporting Document URL
Invoice Number	@Model.InvRefID	Other Supporting Document
Invoice Date	@Convert.ToString(Model.InvDate.Value.ToString("dd-MM-yyyy"))	Any Other Additional Information
Invoice Value	@Model.GrandAmt	Total Invoice Value in Foreign Currency
Department Name		Option for Supplier for Refund
Department ID		Foreign Currency
PO Number		Customer Country Code
Transaction Type	@Model.TRNType	Total Taxable Value	@Model.TaxableAmt
Transaction Subtype	@Model.TRNSubType	Total IGST Amount	@Model.ItemIGSTAmt
Place of Supply	@Model.OMAddress.State.VechCode	Total CGST Amount	@Model.ItemCGSTAmt
Origin Country		Total SGST/UTGST Amount	@Model.ItemSGSTAmt
Org Code	@Model.OMAddress2.GSTCode	Total Cess Amount
Supplier Code		Total State Cess Amount
Supplier Location Code		Rounding Off Amount
Supplier GSTIN/UIN	@Model.OMAddress2.GSTCode	Discount at Invoice level
Buyer Code		Charges at Invoice level	@Model.OtherTaxAmt
Buyer Location Code		Flag for Supply covered under sec7 of IGST Act
Buyer GSTIN/UIN	@Model.OMAddress.GSTCode	Original Invoice Value	@Model.GrandAmt
Supplier PAN		Original POS
Reverse Charge	@Model.ReverseCharge	Original Transaction Type
Supplier Legal Name	@Model.OMAddress2	Original Transaction ID
Supplier Trade Name	LALIT PIPES	Differential Percentage
Supplier Address1	SURVEY NO. 77, VILLAGE VARASKOL, KHARDI RLY. STN. (CR)	Supply Category
Supplier Address2	TALUKA SHAHPUR, DIST THANE, 421601	Line item ID
Supplier City	SHAHAPUR	Goods/Services
Supplier State	MH	HSN Code
Supplier PINCode	421601	Schedule Description Code
Supplier EmailID		HSN Description
Supplier Phone Number		Exemption Notification No
Buyer Trade Name		Compensation Cess Description Code
Buyer Legal Name	@Model.OMAddress.PartyName	RCM Description Code
Buyer Address1	@Model.OMAddress.Address2	Bar code of Product
Buyer Address2	@Model.OMAddress.Address3	Quantity
Buyer City	@Model.OMAddress.City	Free Quantity
Buyer State	@Model.OMAddress.State.VechCode	UQC
Buyer PIN Code	@Model.OMAddress.PinCode	Rate per Quantity
Buyer EmailID		GrossValue
Buyer Phone Number		Discount Before GST
Dispatch Code		Pre Taxable Value
Dispatch GSTIN	@Model.OMAddress2.GSTCode	Taxable Value
Dispatch Name	@Model.OMAddress2.PartyName	Batch Name
Dispatch Address1	@Model.OMAddress2.Address2	Warranty Date
Dispatch Address2	@Model.OMAddress2.Address3	Expiry Date
Dispatch City	@Model.OMAddress2.City	GSTRate
Dispatch State	@Model.OMAddress2.State.VechCode	Cess Rate
Dispatch PIN Code	@Model.OMAddress2.PinCode	State Cess Rate
Dispatcher EmailID		Cess Non Advol Value
Dispatcher Phone Number		IGST Amount
Ship Code		CGST Amount
Ship to Legal Name	@Model.OMAddress1.PartyName	SGST/UTGST Amount
Ship to Trade Name		Compensation Cess Amount
Ship to GSTIN	@Model.OMAddress1.GSTCode	State Cess Amount
Ship to Address1	@Model.OMAddress1.Address2	State Cess Non Advol Amount
Ship to Address2	@Model.OMAddress1.Address3	Other Charges
Ship to City	@Model.OMAddress1.City	PO Line Reference Number
Ship to State	@Model.OMAddress1.State.VechCode	Product Serial Number
Ship to PINCode	@Model.OMAddress1.PinCode	Attribute Details
Receiver EmailID		Attribute Value
Receiver PhoneNumber		EWBSubSupply Type	@Model.EWB_SUBTYPE
ECommerce GSTIN		EWB SubSupply Type Description
Payee Name		EWB Transaction Type	@Model.EWB_TRN_TYPE
Payment Mode		Transport Mode	@Model.TrnMode
Bank Account Number		Type of Cargo	@Model.TYPE_OF_CARGO
Bank IFSC code		Distance 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 Terms		Transport Document No	@Model.LRNO
Direct Debit Terms		Transport Document Date
Credit Days		Transportere-mail	@Model.VechNo
Amount Paid		Vehicle No
Amount Due		Entity-1
Due Date		Entity-2
Shipping Bill Number		Entity-3
Shipping Bill Date		Entity-4
Export Duty Amount		Invoice Remarks
Port Code		Validate INV
Tax Scheme		Generate Proforma
Invoice Currency Code		Auto Generate Invoice No
Invoice Period Start Date	01-04-2022	Auto Generate IRN	@Model.AutoGenIRN
Invoice Period End Date	31-03-2023	Auto 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) { }

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

@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