|
This example demonstrates the conversion from a Oracle PO
Fixed-Length Flat file to a
well-formed XML message.
- Input File:
123456789666340010CTCTLEDPPOO STAND
34567896663458 TEST DATA FOR POO CAI 20000427 14241322456
123456789666340020A1TH1
123456789666340030A2TH2
123456789666340040A2TH3
123456789666340050A2TH4
123456789666341000POPO13456789666340 20000426 0754080 STANDARD
123456789666341010POPO2Immediate COD USD US$ UPS United Parcel Servic Origin
FOB-Orig Due DUE NN N
123456789666341020POPO3 47 A-1 Lighting and Interiors
123456789666341030POPO3
123456789666341040A1PO1
123456789666341050A2PO2
123456789666341060A2PO3
123456789666341070A2PO4
123456789666341080A1SU1
123456789666341090A2SU2
123456789666341100A2SU3
123456789666341110A2SU4
123456789666341120A1SS1
123456789666341130A2SS2
123456789666341140A2SS3
123456789666341150A2SS4
123456789666341160ADSU1 74 4201 Beale Street Sacramento 94032 US USACA
123456789666341170CNSS1 916 453-6021 916 502-7833
123456789666341180CNSS2Peterson Phelix 916 453-6022
123456789666341190AXST13 1400 Global Parkway Sacramento 95801 US
USASacramento CA 05-067-294095798Sacrament
123456789666341200CNST1 916-465-7890 916-465-7699
123456789666341210AXBT13 1400 Global Parkway Sacramento 95801 US
USASacramento CA 05-067-294095798Sacramento
- Output File:
<?xml version="1.0" encoding="utf-8"
standalone="yes" ?>
<OraclePOO>
<Control-record>
<Trading-partner-Code-as-defined-in-the-EDI-Transl>58
</Trading-partner-Code-as-defined-in-the-EDI-Transl>
<Purchase-order-number>111111112214 </Purchase-order-number>
<Purchase-order-line-number> </Purchase-order-line-number>
<Shipment-number> </Shipment-number>
<Record-Type--0010->0010</Record-Type--0010->
<Record-layout-code>CT</Record-layout-code>
<Record-layout-qualifier>CTL</Record-layout-qualifier>
<Communication-method>ED</Communication-method>
<Test-indicator>P</Test-indicator>
<Document-ID>POO </Document-ID>
<Document-type>STAND</Document-type>
<Document-purpose-code> </Document-purpose-code>
<Document-code>111111112214 </Document-code>
<Trading-partner-translator-code>58 </Trading-partner-translator-code>
<Trading-partner-location-code> </Trading-partner-location-code>
<Trading-partner-description>TEST DATA FOR POO
</Trading-partner-description>
<Trading-partner-reference-1>CAI </Trading-partner-reference-1>
<Trading-partner-reference-2> </Trading-partner-reference-2>
<Transaction-date-time-2>20000427 142413</Transaction-date-time-2>
<Transaction-run-ID>22456 </Transaction-run-ID>
</Control-record>
<Trading-Partner-Header-FlexFields>
<Trading-partner-Code-as-defined-in-the-EDI-Transl>58
</Trading-partner-Code-as-defined-in-the-EDI-Transl>
<Purchase-order-number>111111112214 </Purchase-order-number>
<Purchase-order-line-number> </Purchase-order-line-number>
<Shipment-number> </Shipment-number>
<Record-Type--0020->0020</Record-Type--0020->
<Record-layout-code>A1</Record-layout-code>
<Record-layout-qualifier>TH1</Record-layout-qualifier>
<Trading-partner-flexfield-context> </Trading-partner-flexfield-context>
<Trading-partner-flexfield-1> </Trading-partner-flexfield-1>
<Trading-partner-flexfield-2> </Trading-partner-flexfield-2>
<Trading-partner-flexfield-3> </Trading-partner-flexfield-3>
<Trading-partner-flexfield-4> </Trading-partner-flexfield-4>
</Trading-Partner-Header-FlexFields>
<Trading-Partner-Header-FlexFields>
<Trading-partner-Code-as-defined-in-the-EDI-Transl>58
</Trading-partner-Code-as-defined-in-the-EDI-Transl>
<Purchase-order-number>111111112214 </Purchase-order-number>
<Purchase-order-line-number> </Purchase-order-line-number>
<Shipment-number> </Shipment-number>
</Trading-Partner-Header-FlexFields>
<Trading-Partner-Header-FlexFields>
<Trading-partner-Code-as-defined-in-the-EDI-Transl>58
</Trading-partner-Code-as-defined-in-the-EDI-Transl>
<Purchase-order-number>111111112214 </Purchase-order-number>
<Purchase-order-line-number> </Purchase-order-line-number>
<Shipment-number> </Shipment-number>
<Record-Type--0040->0040</Record-Type--0040->
<Record-layout-code>A2</Record-layout-code>
<Record-layout-qualifier>TH3</Record-layout-qualifier>
<Trading-partner-flexfield-10> </Trading-partner-flexfield-10>
<Trading-partner-flexfield-11> </Trading-partner-flexfield-11>
<Trading-partner-flexfield-12> </Trading-partner-flexfield-12>
<Trading-partner-flexfield-13> </Trading-partner-flexfield-13>
<Trading-partner-flexfield-14> </Trading-partner-flexfield-14>
</Trading-Partner-Header-FlexFields>
<Trading-Partner-Header-FlexFields>
<Trading-partner-Code-as-defined-in-the-EDI-Transl>58
</Trading-partner-Code-as-defined-in-the-EDI-Transl>
<Purchase-order-number>111111112214 </Purchase-order-number>
<Purchase-order-line-number> </Purchase-order-line-number>
<Shipment-number> </Shipment-number>
<Record-Type--0050->0050</Record-Type--0050->
<Record-layout-code>A2</Record-layout-code>
<Record-layout-qualifier>TH4</Record-layout-qualifier>
<Trading-partner-flexfield-15> </Trading-partner-flexfield-15>
</Trading-Partner-Header-FlexFields>
<Purchase-Order-Basic-Header>
<Trading-partner-Code-as-defined-in-the-EDI-Transl>58
</Trading-partner-Code-as-defined-in-the-EDI-Transl>
<Purchase-order-number>111111112214 </Purchase-order-number>
<Purchase-order-line-number> </Purchase-order-line-number>
<Shipment-number> </Shipment-number>
<Record-Type--1000->1000</Record-Type--1000->
<Record-layout-code>PO</Record-layout-code>
<Record-layout-qualifier>PO1</Record-layout-qualifier>
<Purchase-order-number>111111112214 </Purchase-order-number>
<Release-number>0 </Release-number>
<Release-date> </Release-date>
<Creation-date>20000426 075408</Creation-date>
<Purchase-order-revision-number>0 </Purchase-order-revision-number>
<Purchase-order-revision-date> </Purchase-order-revision-date>
<Purchase-order-description> </Purchase-order-description>
<Record-order-type>STANDARD </Record-order-type>
</Purchase-Order-Basic-Header>
</OraclePOO>
|
