[go: up one dir, main page]
Scribd
Upload
109 views3 pages

EXP Triplicate Data Upload in XML Format

The document describes how to upload export triplicate data in XML format. It provides the data format, including required fields, data types and tags. It also includes sample XML data with two records, and specifies the format to use if bank charges are not applicable. An XSD schema is provided to validate the XML.

Uploaded by

Alvi Ahmed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
109 views3 pages

EXP Triplicate Data Upload in XML Format

The document describes how to upload export triplicate data in XML format. It provides the data format, including required fields, data types and tags. It also includes sample XML data with two records, and specifies the format to use if bank charges are not applicable. An XSD schema is provided to validate the XML.

Uploaded by

Alvi Ahmed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

EXP Triplicate Data Upload in XML Format

EXP Triplicate Data can now be uploaded in XML format. Description of XML data are given
below:

EXP Triplicate XML data Format. All field are mandatory.

Bank Charges Data Format. All fields are mandatory.

SL Column Name Type Description TAG


No.
1 SLNO Number Record Serial NO of the <SLNO>1</SLNO>
XML file
2 ADSCODE Number(8) AD Code <ADSCODE>2554</ADSCODE>
3 EXP_SERIAL Number(6) Exp serial no. <EXP_SERIAL>23</EXP_SERIAL>
4 EXP_YEAR Number(4) Exp Year <EXP_YEAR>2013</EXP_YEAR>
5 AMOUNT_FC Number(10,2) Realized amount in FC <AMOUNT_FC>800</AMOUNT_FC>
6 CURRENCY_CODE Number(3) Currency code, Must <CURRENCY_CODE>001</CURRENC
match with Currency code Y_CODE>
used at EXP Issue
7 REALIZE_DATE Date Date of Export Proceeds <REALIZE_DATE>2016-11-
realization. Format 10</REALIZE_DATE>
(YYYY-MM-DD)
8 BANK_BILL_NO CHAR (25) Bank's Bill no. <BANK_BILL_NO>OBCDAK432588E
B</BANK_BILL_NO>
9 BANK_BILL_DATE Date Bank's Bill Date. Format <BANK_BILL_DATE>2014-02-
(YYYY-MM-DD) 16</BANK_BILL_DATE>
SL Column Name Type Description TAG
No.
1 SLNO Number Bank charges Record <SLNO>1</SLNO>
Serial NO of the current
EXP in XML file
2 CHARGE_CODE Number(2) Bank Charge code, please <CHARGE_CODE>1</CHARGE_CODE
check code information in >
the EXP Online System.
3 CHARGE_AMOUNT Number(10,2) Bank Charge Amount <CHARGE_AMOUNT>10</CHARGE_A
MOUNT>

Sample Data with XSD Schema:


<EXP_TRP>
<DATA>
<SLNO>1</SLNO>
<ADSCODE>2554</ADSCODE>
<EXP_SERIAL>23</EXP_SERIAL>
<EXP_YEAR>2013</EXP_YEAR>
<AMOUNT_FC>800</AMOUNT_FC>
<CURRENCY_CODE>001</CURRENCY_CODE>
<REALIZE_DATE>2016-11-10</REALIZE_DATE>
<BANK_BILL_NO>OBCDAK432588EB</BANK_BILL_NO>
<BANK_BILL_DATE>2014-02-16</BANK_BILL_DATE>
<BANK_CHARGES>
<CHARGES>
<SLNO>1</SLNO>
<CHARGE_CODE>1</CHARGE_CODE>
<CHARGE_AMOUNT>10</CHARGE_AMOUNT>
</CHARGES>
<CHARGES>
<SLNO>2</SLNO>
<CHARGE_CODE>2</CHARGE_CODE>
<CHARGE_AMOUNT>10</CHARGE_AMOUNT>
</CHARGES>
</BANK_CHARGES>
</DATA>
<DATA>
<SLNO>2</SLNO>
<ADSCODE>2554</ADSCODE>
<EXP_SERIAL>224</EXP_SERIAL>
<EXP_YEAR>2013</EXP_YEAR>
<AMOUNT_FC>92000</AMOUNT_FC>
<CURRENCY_CODE>001</CURRENCY_CODE>

Page 1 of 3
EXP Triplicate Data Upload in XML Format
<REALIZE_DATE>2016-11-10</REALIZE_DATE>
<BANK_BILL_NO>123</BANK_BILL_NO>
<BANK_BILL_DATE>2013-09-07</BANK_BILL_DATE>
<BANK_CHARGES>
<CHARGES>
<SLNO>1</SLNO>
<CHARGE_CODE>1</CHARGE_CODE>
<CHARGE_AMOUNT>50</CHARGE_AMOUNT>
</CHARGES>
</BANK_CHARGES>
</DATA>
</EXP_TRP>

In case Bank charges are not applicable then XML Data Format
should be as follows:

<EXP_TRP>
<DATA>
<SLNO>1</SLNO>
<ADSCODE>2554</ADSCODE>
<EXP_SERIAL>23</EXP_SERIAL>
<EXP_YEAR>2013</EXP_YEAR>
<AMOUNT_FC>800</AMOUNT_FC>
<CURRENCY_CODE>001</CURRENCY_CODE>
<REALIZE_DATE>2016-11-10</REALIZE_DATE>
<BANK_BILL_NO>OBCDAK432588EB</BANK_BILL_NO>
<BANK_BILL_DATE>2014-02-16</BANK_BILL_DATE>
</DATA>
<DATA>
<SLNO>2</SLNO>
<ADSCODE>2554</ADSCODE>
<EXP_SERIAL>23</EXP_SERIAL>
<EXP_YEAR>2013</EXP_YEAR>
<AMOUNT_FC>800</AMOUNT_FC>
<CURRENCY_CODE>001</CURRENCY_CODE>
<REALIZE_DATE>2016-11-10</REALIZE_DATE>
<BANK_BILL_NO>OBCDAK432588EB</BANK_BILL_NO>
<BANK_BILL_DATE>2014-02-16</BANK_BILL_DATE>
</DATA>
</EXP_TRP>

---------------------------------XSD--------------------
<xs:element name="EXP_TRP">
<xs:complexType>
<xs:sequence>
<xs:element name="DATA" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="SLNO" type="xs:int"></xs:element>
<xs:element name="ADSCODE" type="xs:int"></xs:element>
<xs:element name="EXP_SERIAL" type="xs:int"></xs:element>
<xs:element name="EXP_YEAR" type="xs:int"></xs:element>
<xs:element name="AMOUNT_FC" type="xs:int"></xs:element>
<xs:element name="CURRENCY_CODE" type="xs:int"></xs:element>
<xs:element name="REALIZE_DATE" type="xs:date"></xs:element>
<xs:element name="BANK_BILL_NO" type="xs:string"></xs:element>
<xs:element name="BANK_BILL_DATE" type="xs:date"></xs:element>
<xs:element name="BANK_CHARGES">
<xs:complexType>
<xs:sequence>
<xs:element name="CHARGES" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="SLNO" type="xs:int"></xs:element>
<xs:element name="CHARGE_CODE" type="xs:int"></xs:element>
<xs:element name="CHARGE_AMOUNT" type="xs:int"></xs:element>
</xs:sequence>

Page 2 of 3
EXP Triplicate Data Upload in XML Format
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

Page 3 of 3

You might also like