{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["API-SR JSON","API-Fields Details"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"API-SR JSON","index":0,"n_rows":210,"n_cols":1,"rows_kept":210,"cut":false,"hidden":false,"merged":[]}
["Request JSON"]
["["]
["    {"]
["        \"Version\": \"1.1\","]
["        \"TranDtls\": {"]
["            \"Taxsch\": \"GST\","]
["            \"SupTyp\": \"R\","]
["            \"RegRev\": \"Y\","]
["            \"EcmGstin\": null,"]
["            \"IgstOnIntra\": \"N\""]
["        },"]
["        \"DocDtls\": {"]
["            \"Typ\": \"INV\","]
["            \"No\": \"EXT/API/DOC/0488\","]
["            \"Dt\": \"18/02/2023\""]
["        },"]
["        \"SellerDtls\": {"]
["            \"Gstin\": \"27AAACU4276H1Z6\","]
["            \"LglNm\": \"LOGITAX-ANKESKSHAN\","]
["            \"TrdNm\": \"LOGITAX-ANKESKSHAN\","]
["            \"Addr1\": \"27AAAPI3182M002\","]
["            \"Addr2\": \"LOGITAX-ANKESKSHAN\","]
["            \"Loc\": \"27AAAPI3182M002\","]
["            \"Pin\": 411043,"]
["            \"Stcd\": \"27\","]
["            \"Ph\": \"9000000000\","]
["            \"Em\": \"abc@gmail.com\""]
["        },"]
["        \"BuyerDtls\": {"]
["            \"Gstin\": \"27AAACP2389N1ZW\","]
["            \"LglNm\": \"XYZ company pvt ltd\","]
["            \"TrdNm\": \"XYZ Industries\","]
["            \"CusCode\": \"CSUT1251\","]
["            \"Pos\": \"27\","]
["            \"Addr1\": \"7th block, kuvempu layout\","]
["            \"Addr2\": \"kuvempu layout\","]
["            \"Loc\": \"Chakan\","]
["            \"Pin\": 411051,"]
["            \"Stcd\": \"27\","]
["            \"Ph\": \"91111111111\","]
["            \"Em\": \"xyz@yahoo.com\""]
["        },"]
["        \"DispDtls\": {"]
["            \"Gstin\": \"27AAACP2389N1ZW\","]
["            \"Nm\": \"ABC company pvt ltd\","]
["            \"Addr1\": \"7th block, kuvempu layout\","]
["            \"Addr2\": \"kuvempu layout\","]
["            \"Loc\": \"Chakan\","]
["            \"Pin\": 411051,"]
["            \"Stcd\": \"27\","]
["            \"Ph\": \"91111111111\","]
["            \"Em\": \"xyz@yahoo.com\""]
["        },"]
["        \"ShipDtls\": {"]
["            \"Gstin\": \"27AAACP2389N1ZW\","]
["            \"LglNm\": \"ABC company pvt ltd\","]
["            \"TrdNm\": \"ABC company pvt ltd\","]
["            \"Addr1\": \"7th block, kuvempu layout\","]
["            \"Addr2\": \"kuvempu layout\","]
["            \"Loc\": \"Chakan\","]
["            \"Pin\": 411051,"]
["            \"Stcd\": \"27\","]
["            \"Ph\": \"91111111111\","]
["            \"Em\": \"xyz@yahoo.com\""]
["        },"]
["        \"ItemList\": ["]
["            {"]
["                \"SlNo\": \"1\","]
["                \"PrdDesc\": \"Rice\","]
["                \"PrdNm\": \"Rice\","]
["                \"IsServc\": \"N\","]
["                \"HsnCd\": \"1001\","]
["                \"Barcde\": \"123456\","]
["                \"Qty\": 100,"]
["                \"FreeQty\": \"\","]
["                \"Unit\": \"NOS\","]
["                \"UnitPrice\": 1500,"]
["                \"TotAmt\": 15000,"]
["                \"Discount\": \"\","]
["                \"PreTaxVal\": \"\","]
["                \"AssAmt\": 15000,"]
["                \"GstRt\": 18,"]
["                \"IgstAmt\": 0,"]
["                \"CgstAmt\": 1350,"]
["                \"SgstAmt\": 1350,"]
["                \"CesRt\": 0,"]
["                \"CesAmt\": 0.00,"]
["                \"CesNonAdvlAmt\": 0.00,"]
["                \"StateCesRt\": \"\","]
["                \"StateCesAmt\": 0.00,"]
["                \"StateCesNonAdvlAmt\": 0.00,"]
["                \"OthChrg\": 0.00,"]
["                \"TotItemVal\": 17700,"]
["                \"OrdLineRef\": \"3256\","]
["                \"OrgCntry\": \"AG\","]
["                \"PrdSlNo\": \"12345\","]
["                \"BchDtls\": {"]
["                    \"Nm\": \"123456\","]
["                    \"ExpDt\": \"01/08/2022\","]
["                    \"WrDt\": \"01/09/202\""]
["                },"]
["                \"AttribDtls\": ["]
["                    {"]
["                        \"Nm\": \"Rice\","]
["                        \"Val\": \"10000\""]
["                    }"]
["                ]"]
["            }"]
["        ],"]
["        \"ValDtls\": {"]
["            \"AssVal\": 15000.00,"]
["            \"CgstVal\": 0,"]
["            \"SgstVal\": 0,"]
["            \"IgstVal\": 0.00,"]
["            \"CesVal\": 1350,"]
["            \"CesNonAdVal\": 0.00,"]
["            \"StCesVal\": 1350,"]
["            \"Discount\": 0,"]
["            \"OthChrg\": 0,"]
["            \"RndOffAmt\": 0,"]
["            \"TotInvVal\": 17700,"]
["            \"TotInvValFc\": 0"]
["        },"]
["        \"PayDtls\": {"]
["            \"Nm\": \"ABCDE\","]
["            \"AccDet\": \"5697389713210\","]
["            \"Mode\": \"Cash\","]
["            \"FinInsBr\": \"SBIN11000\","]
["            \"PayTerm\": \"100\","]
["            \"PayInstr\": \"Gift\","]
["            \"CrTrn\": \"test\","]
["            \"DirDr\": \"test\","]
["            \"CrDay\": 100,"]
["            \"PayDueDt\": \"01/08/2020\","]
["            \"PaidAmt\": 10000,"]
["            \"PaymtDue\": 5000"]
["        },"]
["        \"RefDtls\": {"]
["            \"InvRm\": \"TEST\","]
["            \"DocPerdDtls\": {"]
["                \"InvStDt\": \"01/08/2020\","]
["                \"InvEndDt\": \"01/09/2020\""]
["            },"]
["            \"PrecDocDtls\": ["]
["                {"]
["                    \"InvNo\": \"DOC/002\","]
["                    \"InvDt\": \"01/08/2020\","]
["                    \"OthRefNo\": \"123456\""]
["                }"]
["            ],"]
["            \"ContrDtls\": ["]
["                {"]
["                    \"RecAdvRefr\": \"Doc/003\","]
["                    \"RecAdvDt\": \"01/08/2020\","]
["                    \"TendRefr\": \"Abc001\","]
["                    \"ContrRefr\": \"Co123\","]
["                    \"ExtRefr\": \"Yo456\","]
["                    \"ProjRefr\": \"Doc-456\","]
["                    \"PORefr\": \"Doc-789\","]
["                    \"PORefDt\": \"01/08/2020\""]
["                }"]
["            ]"]
["        },"]
["        \"AddlDocDtls\": ["]
["            {"]
["                \"Url\": \"https://einv-apisandbox.nic.in\","]
["                \"Docs\": \"Test Doc\","]
["                \"Info\": \"Document Test\""]
["            }"]
["        ],"]
["        \"ExpDtls\": {"]
["            \"Port\": \"INABG1\","]
["            \"RefClm\": \"N\","]
["            \"ForCur\": \"AED\","]
["            \"CntCode\": \"AE\","]
["            \"ExpDuty\": 1200,"]
["            \"ShipBNo\": \"DOC01\","]
["            \"ShipBDt\": \"18/08/2020\""]
["        },"]
["        \"EwbDtls\": {"]
["            \"TransId\": \"12AWGPV7107B1Z1\","]
["            \"TransName\": \"XYZ EXPORTS\","]
["            \"Distance\": 100,"]
["            \"TransDocNo\": \"DOC01\","]
["            \"TransDocDt\": \"18/08/2020\","]
["            \"VehNo\": \"ka123456\","]
["            \"VehType\": \"R\","]
["            \"TransMode\": \"1\","]
["            \"EwayBillNo\": 125125125412,"]
["            \"EwayBillDate\": \"12/08/2021\","]
["            \"EwayBillExpiryDate\": \"12/08/2021\""]
["        },"]
["        \"Extdtls\": {"]
["            \"irnnumber\": \"12AWGPV7107B1Z1\","]
["            \"irndate\": \"18/08/2020\","]
["            \"PlantCode\": \"P01\","]
["            \"glcodesales\": \"Sales\","]
["            \"glcodeliability\": \"Liability\","]
["            \"dateoflinkadvpayment\": \"18/08/2020\","]
["            \"vnooflinkedadvpayment\": \"VCR/00023\","]
["            \"adjamtoflinkadvpayment\": 1000,"]
["            \"businessarea\": \"NORTH\","]
["            \"iscancelled\": \"N\","]
["            \"is_ammendment\": \"N\","]
["            \"Ref1\": \"Ref 1\","]
["            \"Ref2\": \"Ref 2\","]
["            \"Ref3\": \"Ref 3\""]
["        }"]
["    }"]
["]"]

{"sheet":"API-Fields Details","index":1,"n_rows":184,"n_cols":11,"rows_kept":184,"cut":false,"hidden":false,"merged":[[158,1,158,2],[166,1,166,2],[60,1,60,2],[98,1,98,2],[111,1,111,2],[129,1,129,2],[133,1,133,2],[146,1,146,2],[50,1,50,2],[3,1,3,2],[8,1,8,2],[15,1,15,2],[26,1,26,2],[39,1,39,2]]}
["Schema For","Field Group","Field Name","Sub-Field Group","JSON Parameter Name","Pattern","Data Type","Mandatory Conditions","Recommondated Mandatory","Field Description"]
["Request JSON"]
[null,null,"Version",null,"Version",null,"String(Min: 1, Max : 6)","N",null,"JSON Version"]
[null,"Document Details",null,null,"DocDtls"]
[null,null,"Document Type",null,"Typ","\"(?i)^((INV)|(CRN)|(DBN)|(CHL)|(BIL))$\"","String(Min: 3, Max : 3)","Y",null,"Type of Document: \nINV for Invoice, \nCRN for Credit Note, \nDBN for Debit note\nBIL for Bill of Supply\nCHL For Delivery Challan"]
[null,null,"Document Number",null,"No","\"^([a-zA-Z1-9]{1}[a-zA-Z0-9\\/-]{0,15})$\"","String(Min: 1, Max : 16)","Y"]
[null,null,"Document Date",null,"Dt","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String(Min: 10, Max : 10)","Y",null,"Date on which invoice is issued and should be in DD/MM/YYYY Format"]
[null,null,"ERP Document number",null,"erpdocno","\"^([a-zA-Z1-9]{1}[a-zA-Z0-9\\/-]{0,50})$\"","String(Min: 1, Max : 50)","N",null,"document reference Number other than the Invoice number."]
[null,"Transaction Details",null,null,"TranDtls"]
[null,null,"Supply Type",null,"SupTyp","\"(?i)^((R)|(DE)|(SEWP)|(SEWOP)|(CBW)|(WPAY)|(WOPAY)|(OE)|(E)|(NILAMT)|(EXPTAMT)|(NGSUPAMT)|(B2C)|(OTH)|)$\"","String(Min: 3, Max : 10)","Y",null,"One of the Values from:\nR: For Regular B2B Invoices\nDE: For Deemed Exports\nSEWP: For SEZ Exports with payment\nSEWOP: For SEZ exports without payment\nCBW: For Custom Bonded Warehouse\nWPAY: For Export with payment of GST\nWOPAY: For Export with out payment of GST\nOE: For Other than E-Commerce\nE: For E-Commerce\nNILAMT: For Nil Rated Supplies\nEXPTAMT: For Exempted(other than nil rated/non GST supply)\nNGSUPAMT: For Non-GST Supplies\nB2C: For Buisness to Consumer\nOTH: For Others"]
[null,null,"Regular Reverse Charge",null,"RegRev","\"^([Y|N]{1})$\"","String(Min: 1, Max : 1)","Y",null,"Whether the tax liability payable is under Reverse Charge. Value should be from selection-Y/N"]
[null,null,"GSTIN of e-Commerce operator",null,"EcmGstin","\"^([0-9]{2}[0-9A-Z]{13})$\"","String(Min: 15, Max : 15)","N",null,"GSTIN of e-commerce operator, if supply is made through him/her."]
[null,null,"Tax Scheme",null,"Taxsch","“^(GST)$”","String(Min: 3, Max : 10)","N",null,"Tax Scheme To specify the tax/levy applicable – GST (This field is mandatory only if this section is selected)"]
[null,null,"IGSTONIntra",null,"IgstOnIntra","\"^([Y|N]{1})$\"","String (Min:1, Max:1)","N","Y","To Report the Scanarios where supply is chargeable to IGST despite the fact that the Supplier and Recipient are located within same State/UT"]
[null,null,"Customer Type",null,"custtyp","\"(?i)^((CTP)|(UINH))$\"","String(Min: 3, Max : 10)","N",null,"Value from the Master/List as below\nCTP: Composition Taxable Persons\nUINH: UIN Holder"]
[null,"Seller Details",null,null,"sellerdtls"]
[null,null,"Seller_GSTIN",null,"Gstin","\"([0-9]{2}[0-9A-Z]{13})\"","String(Min: 15, Max : 15)","Y",null,"GSTIN of Supplier, i.e. Company who is creating the Invoice"]
[null,null,"Seller_Trade Name",null,"TrdNm","\"^([^\\\\\\\"])*$\"","String(Min: 3, Max : 100)","N","Y","A name by which the Supplier is known, i.e. Business Name, other than legal name"]
[null,null,"Seller_Location Name",null,"loc","\"^([^\\\\\\\"])*$\"","String(Min: 3, Max : 50)","N",null,"Supplier (City/Town/Village)"]
[null,null,"Seller_Addr1",null,"Addr1","\"^([^\\\\\\\"])*$\"","String(Min: 3, Max : 100)","N",null,"Address 1 of the Supplier (Building/Flat no., Road/Street, Locality etc.)"]
[null,null,"Seller_Addr2",null,"Addr2","\"^([^\\\\\\\"])*$\"","String(Min: 3, Max : 100)","N",null,"Address 2 of the Supplier (Building/Flat no., Road/Street, Locality etc.), if an","`"]
[null,null,"Seller_PIN code",null,"Pin",null,"Number (Min: 100000, Max : 999999)","N",null,"PIN Code of the Supplier Locality"]
[null,null,"Seller_State_code",null,"Stcd","\"^(?!0+$)([0-9]{1,2})$\"","String(Min: 1, Max : 2)","Y",null,"State Code of the Supplier as per GST System \nList published and updated from time to time at https://www.icegate.gov.in/Web appl/STATE_ENQ"]
[null,null,"Seller_Phone / Mobile No",null,"Ph","\"^([0-9]{6,12})$\"","String ( Min:10, Max : 12 )","N",null,"Contact number of the Supplier"]
[null,null,"Seller_Email-ID",null,"Em","\"^[a-zA-Z0-9+_.-]+@[a-zA-Z0-9.-]+$\"","String ( Min: 6, Max : 100 )","N","Y","supplier@abc.com e-mail ID of the Supplier, as per REGEX (Regular Expressions) pattern"]
[null,null,"Seller_Legal Name",null,"LglNm","\"^([^\\\\\\\"])*$\"","String(Min: 3, Max : 100)","N","Y","Legal Name, as appearing in PAN of the Supplier"]
[null,"Buyer Details",null,null,"Buyerdtls"]
[null,null,"Buyer_GSTIN",null,"Gstin","\"([0-9]{2}[0-9A-Z]{13})\"","String ( Min: 3, Max : 15 )","Y",null,"GSTIN of the Recipient, if available. \nURP: In case of exports or if supplies are made to unregistered persons"]
[null,null,"Buyer_Trade Name",null,"TrdNm","\"^([^\\\\\\\"])*$\"","String ( Min: 3, Max : 100 )","Y",null,"It will be trade name of recipient, if available."]
[null,null,"Buyer_Location Name",null,"Loc","\"^([^\\\\\\\"])*$\"","String ( Min: 3, Max: 100)","N",null,"Location of the Recipient (City/Town/Village)"]
[null,null,"Buyer_Addr1",null,"Addr1","\"^([^\\\\\\\"])*$\"","String ( Min: 3, Max: 100)","N",null,"Address 1 of the Recipient (Building/Flat no., Road/Street, Locality etc.)"]
[null,null,"Buyer_Addr2",null,"Addr2","\"^([^\\\\\\\"])*$\"","String ( Min: 3, Max: 100)","N",null,"Address 2, if any, of the Recipient (Building/Flat no., Road/Street, Locality etc.), if an"]
[null,null,"Buyer_PIN code",null,"Pin",null,"Number (Min: 100000, Max : 999999)","N",null,"PIN code of the Recipient locality. \n\nIn case of export, Pincode need not be mentioned."]
[null,null,"Buyer_POS",null,"Pos","\"^(?!0+$)([0-9]{1,2})$\"","String ( Min: 1, Max : 2 )","Y",null,"Place of Supply where Material/service is to be delivered"]
[null,null,"Buyer_State_Code",null,"Stcd","\"^(?!0+$)([0-9]{1,2})$\"","String ( Min: 1, Max: 2)","Y",null,"Code/State Code of the Recipient. \n\nList published and updated from time to time at https://www.icegate.gov.in/Web appl/STATE_ENQ"]
[null,null,"Buyer_Phone / Mobile No",null,"Ph","\"^([0-9]{6,12})$\"","String ( Min: 10, Max: 12)","N",null,"Contact number of the Recipient"]
[null,null,"Buyer_Email-ID",null,"Em","\"^[a-zA-Z0-9+_.-]+@[a-zA-Z0-9.-]+$\"","String ( Min: 6, Max: 100)","N",null,"e-mail ID of the Recipient, as per REGEX (Regular Expressions) pattern"]
[null,null,"Buyer_Legal Name",null,"LglNm","\"^([^\\\\\\\"])*$\"","String ( Min: 3, Max : 100 )","N",null,"It will be legal name of recipient, as per PAN."]
[null,null,"Buyer Code",null,"CusCode","\"^([^\\\\\\\"])*$\"","String(Min: 0, Max : 16)","N","Y","Seller Code defined in ERP."]
[null,"Ship To Details",null,null,"ShipDtls"]
[null,null,"GSTIN",null,"Gstin","\"([0-9]{2}[0-9A-Z]{13})\"","String (Min: 15, Max = 15)","N",null,"GSTIN of the Recipientwhere material is shipped"]
[null,null,"ShipTo_Legal_Name",null,"LglNm","\"^([^\\\\\\\"])*$\"","String (Min: 3, Max = 100)","N",null,"Legal Name of the entity to whom the supplies are shipped to. \n\n(This field is mandatory only if this section is selected) \nA"]
[null,null,"ShipTo_Trade Name",null,"TrdNm","\"^([^\\\\\\\"])*$\"","String (Min: 3, Max = 100)","N",null,"Trade Name of the entity to whom the supplies are shipped to."]
[null,null,"ShipTo_Location Name",null,"Loc","\"^([^\\\\\\\"])*$\"","String (Min: 3, Max: 50)","N",null,"Place (City/Town/Village) of entity to whom the supplies are shipped to. \n\n(This field is mandatory only if this section is selected)"]
[null,null,"ShipTo_Addr1",null,"Addr1","\"^([^\\\\\\\"])*$\"","String (Min: 3, Max: 100)","N",null,"Address 1 of the entity to whom the supplies are shipped to \n\n(This field is mandatory only if this section is selected)"]
[null,null,"ShipTo_Addr2",null,"Addr2","\"^([^\\\\\\\"])*$\"","String (Min: 3, Max: 100)",null,null,"Address 2, if any, of the entity to whom the supplies are shipped to"]
[null,null,"ShipTo_PIN code",null,"Pin",null,"Number (Min: 100000, Max: 999999)","N",null,"PIN code of the location to which the supplies are shipped to. \n\n(This field is mandatory only if this section is selected)"]
[null,null,"ShipTo_State_Code",null,"Stcd","\"^(?!0+$)([0-9]{1,2})$\"","String (Min: 1, Max: 2)","N",null,"Code/State Code (as per GST System) to which the supplies are shipped to. \n\nList published and updated from time to time at https://www.icegate.gov.in/Web appl/STATE_ENQ \n\n(This field is mandatory only if this section is selected)"]
[null,null,"Ship_To_Phone / Mobile No",null,"Ph","\"^([0-9]{6,12})$\"","String ( Min: 10, Max: 12)","N",null,"Contact number of the perso of receipient"]
[null,null,"Ship_To_Email-ID",null,"Em","\"^[a-zA-Z0-9+_.-]+@[a-zA-Z0-9.-]+$\"","String ( Min: 6, Max: 100)","N",null,"e-mail ID of the receipient, as per REGEX (Regular Expressions) pattern"]
[null,"Dispatch To Details",null,null,"DispchDtls"]
[null,null,"Dispatch_From_GSTIN",null,"Gstin","\"([0-9]{2}[0-9A-Z]{13})\"","String (Min: 15, Max = 15)","N",null,"GSTIN From where material is to be dispatched."]
[null,null,"DispatchFrom_Trade Name",null,"Nm","\"^([^\\\\\\\"])*$\"","String ( Min: 3, Max = 60)","N",null,"A name by which the dispatcher is known, i.e. Business Name, other than legal name"]
[null,null,"DispatchFrom_Location Name",null,"Loc","\"^([^\\\\\\\"])*$\"","String ( Min: 3, Max = 100 )","N",null,"Place (City/Town/Village) of the entity from which goods are dispatched. (This field is mandatory only if this section is selected)"]
[null,null,"DispatchFrom_Addr1",null,"Addr1","\"^([^\\\\\\\"])*$\"","String ( Min: 3, Max = 100 )","N",null,"Address 1 of the entity from which goods are dispatched. \n\n(This field is mandatory only if this section is selected)"]
[null,null,"DispatchFrom_Addr2",null,"Addr2","\"^([^\\\\\\\"])*$\"","String ( Min: 3, Max = 100 )","N",null,"Address 2 of the entity from which goods are dispatched."]
[null,null,"DispatchFrom_PIN code",null,"Pin",null,"Number (Min: 100000, Max: 999999)","N",null,"Pincode of the locality of entity from where goods are dispatched. \n\n(This field is mandatory only if this section is selected)"]
[null,null,"DispatchFrom_State_code",null,"Stcd","\"^(?!0+$)([0-9]{1,2})$\"","String (Min: 1, Max: 2)","N",null,"Code/State Code of the entity (as per GST System), from which goods are dispatched. List published and updated from time to time at https://www.icegate.gov.in/Web appl/STATE_ENQ (This field is mandatory only if this section is selected)"]
[null,null,"Dispatch_From_Phone / Mobile No",null,"Ph","\"^([0-9]{6,12})$\"","String ( Min: 10, Max: 12)","N",null,"Contact number of the person from where material is dispatched"]
[null,null,"Dispatch_From_Email-ID",null,"Em","\"^[a-zA-Z0-9+_.-]+@[a-zA-Z0-9.-]+$\"","String ( Min: 6, Max: 100)","N",null,"e-mail ID of the sender, as per REGEX (Regular Expressions) pattern"]
[null,"Item Details",null,null,"ItemList",null,null,"N"]
[null,null,"IsServc",null,"IsServc","\"^([Y|N]{1})$\"","String (Min: 1, Max: 1)","N",null,"Specify whether supply is service or not."]
[null,null,"Item Desc",null,"PrdDesc","\"^([^\\\\\\\"])*$\"","String (Min: 3, Max: 300)","N",null,"Description of the item"]
[null,null,"Item Code",null,"PrdNm","\"^([^\\\\\\\"])*$\"","String (Min: 3, Max: 300)","N",null,"Code/Name of the Item"]
[null,null,"HSN Code",null,"HsnCd","\"^(?!0+$)([0-9]{4}|[0-9]{6}|[0-9]{8})$\"","String (Min: 4, Max: 8)","Y",null,"To enter applicable HSN / SAC Code of Goods / Service"]
[null,null,"Quantity",null,"`",null,"Number (Min.: 0, Max: 9999999999.999)","Y",null,"The quantity of items to be mentioned in the invoice. \n\nThis is mandatory only in case of goods. \nA"]
[null,null,"UoM",null,"Unit","\"^([A-Z|a-z]{3,8})$\"","String ( Min: 3, Max: 8)","Y",null,"The Unit of Measurement (UOM), if any, applicable on invoiced goods."]
[null,null,"Taxable Amount",null,"AssAmt",null,"Number [Min: 0, Max = 999999999999.99]","Y",null,"This is the value on which tax is computed. Value cannot be negative."]
[null,null,"CESS Rate",null,"CesRt",null,"Number [Min: 0, Max : 999.999]","N",null,"Cess Rate"]
[null,null,"Bar Code",null,"Barcde","\"^([^\\\\\\\"])*$\"","String (Min: 3, Max: 30)","N",null,"Barcode, if any, of the item."]
[null,null,"Free Quantity",null,"FreeQty",null,"Number ((Min.: 0, Max: 9999999999.999)","N",null,"if any, given free of charge (FOC)"]
[null,null,"Unit Price",null,"UnitPrice",null,"Number [(Min.: 0, Max: 999999999999.999)]","N",null,"Price per unit item."]
[null,null,"Total Amount (Unit Price * Quantity)",null,"TotAMt",null,"Number [Min: 0, Max = 9999999999999.99]","N",null,"The gross price of an item (cost multiplied by quantity - rounded off to 2 decimal), exclusive of taxes."]
[null,null,"Discount",null,"Discount",null,"Number [Min: 0, Max = 999999999999.99]","N",null,"Discount amount, if any, for the item."]
[null,null,"Other charges if any",null,"OthChrg",null,"Number [Min: 0, Max: 999999999999.99]","N",null,"Any other charges applicable at item level. \n\nThese may not be part of taxable value, e.g. in case of pure agent reimbursement."]
[null,null,"Cess Non-Advol Amount",null,"CesNonAdvlAmt",null,"Number [Min: 0, Max: 999999999999.99]","N",null,"GST Compensation Cess amount, computed on the basis other than value of item (i.e. specific cess amount computed based on quantity, number etc.)"]
[null,null,"State CESS Rate",null,"StateCesRt",null,"Number [Min: 0, Max : 999.99]","N","Y","Ad valorem Rate of State/UT Cess, applicable, if any"]
[null,null,"Total Item Value",null,"TotItemVal",null,"Number [Min: 0, Max = 999999999999.99]","N","Y","The item total value that includes all taxes, cesses, as well as other charges.\n\nHowever, this value excludes discount, if any."]
[null,null,"PreTaxVal",null,"PReTaxVal",null,"Number [Min: 0, Max = 999999999999.99]","N",null,"If pre-tax value is different from taxable value, mention the pre-tax value and taxable values separately. \n\nIn some cases, the pre-tax value may be different from taxable value. \n\nFor example, where old goods are exchanged for new ones (e.g. new phone supplied for INR 20,000 along with exchange of old phone, then pre-tax value would be INR 20,000 and taxable value would be INR 24,000, assuming exchange value of old phone is 4,000. \n\nAnother example is in the case of real estate where pre-tax value may be different from taxable value."]
[null,null,"Gst Rate",null,"GstRt",null,"Number [Min: 0, Max = 999.999]","Y",null,"The GST rate, represented as percentage that applies to the invoiced item. It will be IGST rate or sum of CGST & SGST Rates."]
[null,null,"Cess Amount",null,"CesAmt",null,"Number [Min: 0, Max = 999999999999.99]","N","Y","_ Ad_Valorem \n0..1 Compensation Cess Amount, Ad Valorem \nOptional Number (Max length: 12,2) \n56.00 GST Compensation Cess amount, ad valorem (rounded off to 2 decimals) (based on value of the item)"]
[null,null,"Item Sr No",null,"SlNo","\"^([0-9]{1,6})$\"","String (Min: 1, Max: 6)","N",null,"Serial number of the item"]
[null,null,"State CESS Amount",null,"StateCesAmt",null,"Number [Min: 0, Max = 999999999999.99]","N","Y","GST Compensation Cess amount, ad valorem (rounded off to 2 decimals) (based on value of the item)"]
[null,null,"State CESS Non Advol Amount",null,"StateCesNonAdvolAmt",null,"Number [Min: 0, Max = 999999999999.99]","N","Y","State CESS Non advol Amount"]
[null,null,"Order line reference",null,"OrdLineRef","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 50)","N",null,"Reference of Purchase Order Line"]
[null,null,"Origin Country",null,"Orgcntry","\"^([A-Z|a-z]{2})$\"","String(Min:2 : Max: 2)","N",null,"This is to specify country of origin of the item, e.g. mobile phone sold in India could be manufactured in other country;\n\nCode of country of export as per ISO 3166-1 alpha-2 / Indian Customs EDI system (ICES).\n\nList published and updated from time to time at https://www.icegate.gov.in/Weba ppl/COUNTRY_ENQ"]
[null,null,"Serial number each item",null,"PRdSlNo","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 15)","N",null,"Serial number, in case of each item having a unique number."]
[null,null,"Amount of IGST payable",null,"IgstAmt",null,"Number [Min: 0, Max = 999999999999.99]","Y",null,"Amount of IGST payable per item (rounded off to 2 decimals). If IGST is reported, then CGST & SGST/UTGST will be blank. For taxable supplies, either IGST or CGST &SGST/UTGST\nshould be reported."]
[null,null,"Amount of CGST payable",null,"CgstAmt",null,"Number [Min: 0, Max = 999999999999.99]","Y",null,"Amount of CGST payable per item (rounded off to 2 decimals).\n\nIf CGST is reported, then SGST/UTGST has to be reported and IGST will be blank."]
[null,null,"Amount of SGST payable",null,"SgstAmt",null,"Number [Min: 0, Max = 999999999999.99]","Y",null,"Amount of SGST/UTGST payable per item(rounded off to 2 decimals).\n\nIf SGST/UTGST is reported, then CGST must be reported and IGST will be blank."]
[null,null,"Is Nature of supply under section 9(5)",null,"isNtrofSupundr9_5","\"^([Y|N]{1})$\"","String(Min: 1, Max : 1)","N",null,"Whether the supply made is under section 9(5). this is useful to differntate the transaction for GSTR3B Filing., \nValue for the List : Y: Yes\nN: No"]
[null,null,"Item Attribute Details",null,"AttribDtls"]
[null,null,null,"Attribute details of the item","Nm","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 100)","N",null,"Attribute Name of the item."]
[null,null,null,"Attribute value of the item","Val","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 100)","N",null,"Attribute Value of the item."]
[null,null,"Item-Batch Details",null,"BchDtls"]
[null,null,null,"Batch Name","Nm","\"^([^\\\\\\\"])*$\"","String(Min:3 : Max: 20)","N",null,"Certain set of manufacturers may mention batch number details. (This field is mandatory only if this section is selected)"]
[null,null,null,"Batch Expiry Date","ExpDt","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String(Min:10 : Max: 10)","N",null,"Expiry Date of the Batch, if any"]
[null,null,null,"Batch Waranty Date","WrDt","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String(Min:10 : Max: 10)","N",null,"Warranty date for the Item, if any."]
[null,"Total Invoice Value Details",null,null,"ValDtls",null,null,"N"]
[null,null,"Total Value",null,"AssVal",null,"Number [Min: 0, Max: 9999999999999.99 ]","Y",null,"This is the sum of the taxable values of all the items in the document."]
[null,null,"SGST Amount",null,"SgstVal",null,"Number [Min: 0, Max: 9999999999999.99 ]","Y",null,"Total SGST/UTGST amount for the invoice.\nAppropriate taxes based on rule will be applicable. For example, either of CGST & SGST/UTGST or IGST will be mandatory.\nAs it is conditional mandatory, it is marked as ‘optional’"]
[null,null,"CGST Amount",null,"CgstVal",null,"Number [Min: 0, Max: 9999999999999.99 ]","Y",null,"Total CGST amount for the invoice.\nAppropriate taxes based on rule will be applicable.\nFor example, either of CGST & SGST/UTGST or IGST will be mandatory.\nAs this is conditional mandatory, it is marked as ‘optional’"]
[null,null,"IGST Amount",null,"IgstVal",null,"Number [Min: 0, Max: 9999999999999.99 ]","Y",null,"Total IGST amount for the invoice.\n\nAppropriate taxes based on rule will be applicable.\n\nFor example, either of CGST & SGST/UTGST or IGST will be mandatory.\n\nAs this is conditional mandatory, it is marked as ‘optional’"]
[null,null,"CESS Amount",null,"CesVal",null,"Number [Min: 0, Max: 9999999999999.99 ]","Y",null,"Total GST Compensation Cess amount for the invoice (ad valorem as well as non-ad valorem)"]
[null,null,"Other Charge",null,"OthChrg",null,"Number [Min: 0, Max: 9999999999999.99 ]","N","Y","Invoice Level Other Charges"]
[null,null,"Discount",null,"Discount",null,"Number [Min: 0, Max: 9999999999999.99 ]","N","Y","Discount on Invoice Value"]
[null,null,"Total Invoice Value",null,"TotInvVal",null,"Number [Min: 0, Max: 9999999999999.99 ]","Y",null,"The total value of invoice including taxes/GST and rounded to two decimals maximum."]
[null,null,"Total State CESS value of all items",null,"StCesVal",null,"Number [Min: 0, Max: 9999999999999.99 ]","N","Y","Total State cess amount for the invoice (ad valorem as well as non-ad valorem)"]
[null,null,"Total Cess Non-advol value of all items",null,"CesNonAdVal",null,"Number [Min: 0, Max: 9999999999999.99 ]","N","Y","Total cess amount for the invoice (ad valorem as well as non-ad valorem)"]
[null,null,"Total Invoice value in Foreign Currency",null,"TotInvValFc",null,"Number [Min: 0, Max: 9999999999999.99 ]","N",null,"The total value of invoice in Additional Currency"]
[null,null,"Rounding off amount",null,"RndOffAmt",null,"Number [Min: 0, Max: 99.99 ]","N","Y","This is round off amount of total invoice value"]
[null,"Document Reference Details",null,null,"RefDtls"]
[null,null,"Invoice Remarks",null,"InvRm","\"^([^\\\\\\\"])*$\"","String (Min:3:, Max :500)","N"]
[null,null,"Document Period Details",null,"DocPerdDtls"]
[null,null,null,"Invoice Period Start Date","InvStDt","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (Min:10, Max: 10)","N",null,"This is the start date of the document period (delivery/invoice period).\n(This field is mandatory only if this section is selected)"]
[null,null,null,"Invoice Period End Date","InvEndDt","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (Min:10, Max: 10)","N",null,"This is the end date of the document period (delivery/invoice period).\n(This field is mandatory only if this section is selected)"]
[null,null,"Preceding Doc Details",null,"PrecDocDtls"]
[null,null,null,"Preceeding Invoice Number","InvNo","\"^[1-9a-zA-Z]{1}[0-9a-zA-Z\\/-]{1,15}$\"","String (Min: 1, Max: 16]","N",null,"This is the reference of original document/invoice to be provided optionally in the case of debit or credit notes.\nCredit/Debit notes, against invoices can also be referred here.\n(This field is mandatory only if this section is selected)"]
[null,null,null,"Preceding Invoice Date","InvDt","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (Min: 10, max: 10]","N",null,"Date of preceding document/invoice.\n\n(This field is mandatory only if this section is selected)"]
[null,null,null,"Other Reference","OthRefNo","\"^([^\\\\\\\"])*$\"","String (MinLength 1, Maxlength:500)","N",null,"This field is to provide any additional reference e.g. specific branch, their user ID, their employee ID, sales centre reference etc."]
[null,null,"Contract Details",null,"ContrDtls"]
[null,null,null,"Receipt Advice No.","RecAdvRefr","\"^([^\\\\\\\"])*$\"","String (MinLength 1, Maxlength:100)","N",null,"This reference is kept for user to provide number of their receipt\nadvice to their customer, in lieu of advance."]
[null,null,null,"Date of receipt advice","RecAdvDt","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (MinLength 10,Maxlength:10)","N",null,"Date of issue of receipt advice for advance."]
[null,null,null,"Lot/Batch Reference No.","TendRefr","\"^([^\\\\\\\"])*$\"","String (MinLength 1, Maxlength:100)","N",null,"This reference is kept for mentioning number or details of Lot or Tender, if supplies are made under such Lot or tender."]
[null,null,null,"Contract Reference Number","ContrRefr","\"^([^\\\\\\\"])*$\"","String (MinLength 1, Maxlength:100)","N",null,"This reference is kept for mentioning contract number, if supplies are made under any specific Contract"]
[null,null,null,"Any other reference","ExtRefr","\"^([^\\\\\\\"])*$\"","String (MinLength 1, Maxlength:100)","N",null,"An additional field for provision of any additional/external reference number for the supply."]
[null,null,null,"Project Reference Number","ProjRefr","\"^([^\\\\\\\"])*$\"","String (MinLength 1, Maxlength:100)","N",null,"This reference is kept for mentioning project number, if supplies are made under any specific project"]
[null,null,null,"Purchaser PO Reference Number","PORefr","\"^([^\\\\\\\"])*$\"","String (MinLength 1, Maxlength:100)","N",null,"This is the reference number of Purchase Order"]
[null,null,null,"Vendor PO Reference date","PORefDt","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (MinLength 10,Maxlength:10)","N",null,"This is the date of Purchase Order."]
[null,"Additional Document Details",null,null,"AddlDocDtls"]
[null,null,"Supporting document URL",null,"Url","\"^([^\\\\\\\"])*$\"","String (MinLength 10,Maxlength:100)","N",null,"This is to enter URL reference of additional supporting documents, if any."]
[null,null,"Supporting document",null,"Docs","\"^([^\\\\\\\"])*$\"","String (MinLength 10,Maxlength:1000)","N",null,"This is to add any additional document in PDF/Microsoft Word in Base64 encoded format."]
[null,null,"Any additional Information",null,"Info","\"^([^\\\\\\\"])*$\"","String (MinLength 10,Maxlength:1000)","N",null,"Any additional information, names, values, data etc. that is specific for the Supplier- Recipient transaction e.g. CIN, trade-specific information, Drug Licence Reg. No., FOB/CIF etc."]
[null,"Payment Details",null,null,"PayDtls",null,null,"N"]
[null,null,"Payee Name",null,"Nm","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 100)","N",null,"Name of the person to whom payment is to be made"]
[null,null,"Mode of Payment",null,"Mode","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 18)","N",null,"Mode of Payment: Cash/Credit/Direct Transfer etc."]
[null,null,"Branch or IFSC code",null,"FinInsBr","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 11)","N",null,"Indian Financial System Code (IFSC) of Payee‘s Bank Branch"]
[null,null,"Terms of Payment",null,"PayTerm","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 100)","N",null,"Terms of Payment, if any, with the Recipient can be provided."]
[null,null,"Payment Instruction",null,"PayInstr","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 100)","N",null,"Instruction, if any, regarding payment ca Terms"]
[null,null,"Credit Transfer",null,"CrTrn","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 100)","N",null,"to specify credit transfer payments.n be provided"]
[null,null,"Direct Debit",null,"DirDr","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 100)","N",null,"Terms, if any, to specify a direct debit."]
[null,null,"Credit Days",null,"CrDay",null,"Number [Min: 0,Max: 9999]","N",null,"Number of days within which payment is due."]
[null,null,"Due Date of Payment",null,"PayDueDt","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (MinLength 10, MaxLength:10)","N",null,"Payment Due Date in the Format DD/MM/YYYY"]
[null,null,"Balance Amount",null,"PaymtDue",null,"Number [Min: 0, Max: 99999999999999.99 ]","N",null,"The outstanding amount due for payment. It must be rounded to maximum 2 decimals."]
[null,null,"Account Details",null,"AccDet","\"^([^\\\\\\\"])*$\"","String(Min:1 : Max: 18)","N",null,"Bank Account Number of Payee"]
[null,null,"The sum of amount which have been paid in advance",null,"PaidAmt",null,"Number [Min: 0, Max: 99999999999999.99 ]","N",null,"The amount, if any, which has been paid in advance.\n\nIt must be rounded to maximum 2 decimals."]
[null,"Transporter / EWB Details",null,null,"EwbDtls",null,null,"N"]
[null,null,"Transin/GSTIN",null,"Transid","\"^([0-9]{2}[0-9A-Z]{13})$\"","String (MinLength 15, MaxLength:15","N",null,"Registration / Enrolment Number of the transporter\n\n(This field is required if Part-A of E-waybill has to be generated)"]
[null,null,"Transporter Name",null,"TransName","\"^([^\\\\\\\"])*$\"","String (MinLength 3,","N",null,"Name of the Transporter"]
[null,null,"Transport Mode",null,"TransMode","\"^([1-4]{1})?$\"","String (MinLength 1,MaxLength:1)","N",null,"Option to be provided based on mode of transport available on e- Way Bill Portal\n1 for Road;\n2 for Rail;\n3 for Air;\n4 for Ship\n(This field is required if Part-B of e-way bill is also to be generated)"]
[null,null,"Distance",null,"Distance",null,"Number (MinLength 1, Maxlength:4)","N",null,"Distance of Transportation\n\n(This field is mandatory only if this section is selected)"]
[null,null,"Tranport Document Number",null,"TransDocNo","\"^([a-zA-Z0-9\\/-]{1,15})$\"","String (MinLength 1, MaxLength: 15)","N",null,"Transport Document Number\n\n(This field is mandatory if mode of Transport is Rail or Air or Ship)"]
[null,null,"Transport Document Date",null,"TransDocDt","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (MinLength 10, MaxLength:10)","N",null,"Date of Transport document.\n\n(This field is mandatory if mode of Transport is Rail or Air or Ship)"]
[null,null,"Vehicle Number",null,"VehNo","\"^([A-Z|a-z|0-9]{4,20})$\"","String (MinLength 4, MAxLength:20)","N",null,"Vehicle Registration Number\n\n(This field is mandatory if mode of Transport is Road)"]
[null,null,"Vehicle Type",null,"VehType","\"^([O|R]{1})$\"","String (MinLength 1,MaxLength:1)","N",null,"To mention nature of vehicle: O: Over-Dimensional Cargo R: Regular\n(This field is mandatory if Part- B of e-way bill is also to be generated)"]
[null,null,"E-Way Bill No",null,"EwayBillNo",null,"number(12)","N","Y","E-way Bill Number"]
[null,null,"E-Way Bill Date",null,"EwayBillDate","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (MinLength 10, MaxLength:10)","N","Y","E-way Bill Date"]
[null,null,"E-Way Bill Expiry Date",null,"EwayBillExpiryDate","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (MinLength 10, MaxLength:10)","N",null,"E-way Bill Expiry Date"]
[null,"Export Details",null,null,"ExpDtls",null,null,"For Export Details"]
[null,null,"Shipping Bill No",null,"ShipBNo","\"^([^\\\\\\\"])*$\"","String (MinLength 1,MAxLength:15)","Y",null,"Bond Number of a legal document that is filed by Exporters or customs clearance agents on or before the arrival of imported goods."]
[null,null,"Shipping Bill Date",null,"ShipBDt","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (MinLength 10, MaxLength:10)","Y",null,"Bond Date on which a legal document that is filed by Exporters or customs clearance agents on or before the arrival of imported goods."]
[null,null,"Port Code",null,"Port","\"^[0-9|A-Z|a-z]{2,10}$\"","String (MinLength 2,MaxLength:10)","N",null,"In case of Import/supply to SEZ, port code can be mentioned as per Indian Customs EDI System (ICES), if applicable and available at the time of reporting e-invoice.\nLists published and updated from time to time at below URLs:\nEDI Port Codes:\nhttps://www.icegate.gov.in/Web appl/LOCATION_ENQ\nNon-EDI Port Codes:\nhttps://www.icegate.gov.in/Web appl/nonlocation_det_all.jsp"]
[null,null,"Foreign Currency",null,"ForCur","\"^[A-Z|a-z]{3,16}$\"","String (MinLength 3,MaxLength:16)","N",null,"The field is for reporting additional currency, if any, in which all invoice amounts can be given, along with INR.\nOne such additional currency may be used in the invoice, as per list published under ISO 4217 standard.\nList published and updated from time to time at https://www.icegate.gov.in/Web appl/CUR_ENQ"]
[null,null,"Country",null,"CntCode","\"^([A-Z]{2})$\"","String (MinLength 2,MaxLength:2)","N",null,"Code of country of from Imported as per ISO 3166-1 alpha-2 / Indian Customs EDI system.\n\nList published and updated from time to time at https://www.icegate.gov.in/Web appl/COUNTRY_ENQ"]
[null,null,"Refund Claim",null,"RefClm","\"^([Y|N]{1})$\"","String (MinLength 1,MAxLength:1)","N",null,"In case of deemed Import supplies, this field is for mentioning whether supplier can exercise the option of claiming refund or not."]
[null,null,"Export Duty",null,"ExpDuty",null,"Number [Min: 0, Max: 99999999999999.99 ]","N",null,"Amount of Import Duty in INR, if any, applicable (in case of invoices for Import )"]
[null,"Extra Details",null,null,"ExtDtls"]
[null,null,"IRN No",null,"irnnumber",null,"String (MinLength 64,MaxLength:64)","N","Y","IRN Number generated by Seller if seller is E-invoice Applicable and the Document Type is Applicable for for E-invoice"]
[null,null,"IRN Date",null,"irndate","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (MinLength 10, MaxLength:10)","N","Y","IRN Date generated by Seller if seller is E-invoice Applicable and the Document Type is Applicable for for E-invoice"]
[null,null,"Plant Code",null,"plantcode","\"^([^\\\\\\\"])*$\"","String (MinLength 1,MAxLength:15)","N",null,"Plant Code of the Receiver."]
[null,null,"Gl code Sales",null,"glcodesales","\"^([^\\\\\\\"])*$\"","String (MinLength 1,MAxLength:100)","N",null,"GL Code/ Name used for Sales"]
[null,null,"Gl Code- Liability",null,"glcodeliability","\"^([^\\\\\\\"])*$\"","String (MinLength 1,MAxLength:100)","N",null,"GL Code / GL Name used as a Liablity"]
[null,null,"Date of Linked Advance Payment",null,"dateoflinkadvpayment","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (MinLength 10, MaxLength:10)",null,null,"Date of Linked Advance Paymane made"]
[null,null,"Voucher Number of Linked Advance Payment",null,"vnooflinkedadvpayment","\"^([^\\\\\\\"])*$\"","String (MinLength 1,MAxLength:500)","N",null,"Voucher Number of advance payment"]
[null,null,"Adjustment Amount of Linked Advance Payment",null,"adjamtoflinkadvpayment","\"^([^\\\\\\\"])*$\"","String (MinLength 1,MAxLength:500)","N",null,"Adjustment amount made to the reference of advalnce Payment"]
[null,null,"Business Area",null,"businessarea","\"^([^\\\\\\\"])*$\"","String (Min:1:, Max :500)","N",null,"Business Area"]
[null,null,"Is Cancelled",null,"iscancelled","\"^([Y|N]{1})$\"","String (MinLength 1,MAxLength:1)","N",null,"IF the Document is cancelled then Y else N"]
[null,null,"Is Ammendment",null,"is_ammendment","\"^([Y|N]{1})$\"","String (MinLength 1,MAxLength:1)","N",null,"If there is amendment in the document then Y else N"]
[null,null,"Original Document No",null,"org_inv_no","\"([a-zA-Z1-9]{1}[a-zA-Z0-9\\/-]{0,15})$\"","String (MinLength 1,MAxLength:16)","N",null,"Original Invoice Number, required in case of Amendment"]
[null,null,"Original Document Date",null,"org_inv_date","\"^[0-3][0-9]\\/[0-1][0-9]\\/[2][0][1-2][0-9]$\"","String (MinLength 10, MaxLength:10)","N",null,"Original Invoice Date, Required in Case of Amendment."]
[null,null,"Original Return Period",null,"orgretprd","\"^[0-1[0-9][2][0][1-2][0-9]$\"","String (MinLength 6, MaxLength:6)","N",null,"Original Return Month of the Amended Document. Applicabel only for the Amendmend"]
[null,null,"Reference Details 1",null,"Ref1","\"^([^\\\\\\\"])*$\"","String (Min:1:, Max :500)","N",null,"Reference Details 1"]
[null,null,"Reference Details 2",null,"Ref2","\"^([^\\\\\\\"])*$\"","String (Min:1:, Max :500)","N",null,"Reference Details 2"]
[null,null,"Reference Details 3",null,"Ref3","\"^([^\\\\\\\"])*$\"","String (Min:1:, Max :500)","N",null,"Reference Details 3"]