Here are the file description documents for the invoice and purchase order examples.
<?xml version="1.0" encoding="UTF-8"?> <CSVSourceFileDescription xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="CSVSourceFileDescription.xsd"> <PhysicalCharacteristics> <RecordTerminator value="W"/> <ColumnDelimiter value=","/> <TextDelimiter value="""/> </PhysicalCharacteristics> <XMLOutputCharacteristics> <DocumentBreakColumn value="2"/> <PartnerBreakColumn value="1"/> <SchemaLocationURL value="CSVInvoice.xsd"/> </XMLOutputCharacteristics> <Grammar ElementName="Invoice"> <RowDescription ElementName="InvoiceLine"> <ColumnDescription FieldNumber="1" ElementName="CustomerNumber" DataType="AN"/> <ColumnDescription FieldNumber="2" ElementName="InvoiceNumber" DataType="AN"/> <ColumnDescription FieldNumber="3" ElementName="InvoiceDate" DataType="DMMsDDsYYYY"/> <ColumnDescription FieldNumber="4" ElementName="PONumber" DataType="AN"/> <ColumnDescription FieldNumber="5" ElementName="DueDate" DataType="DMMsDDsYYYY"/> <ColumnDescription FieldNumber="6" ElementName="ShipToName" DataType="AN"/> <ColumnDescription FieldNumber="7" ElementName="ShipToStreet1" DataType="AN"/> <ColumnDescription FieldNumber="8" ElementName="ShipToStreet2" DataType="AN"/> <ColumnDescription FieldNumber="9" ElementName="ShipToCity" DataType="AN"/> <ColumnDescription FieldNumber="10" ElementName="ShipToStateOrProvince" DataType="AN"/> <ColumnDescription FieldNumber="11" ElementName="ShipToPostalCode" DataType="AN"/> <ColumnDescription FieldNumber="12" ElementName="ShipToCountry" DataType="AN"/> <ColumnDescription FieldNumber="13" ElementName="ItemID" DataType="AN"/> <ColumnDescription FieldNumber="14" ElementName="ItemQuantity" DataType="R"/> <ColumnDescription FieldNumber="15" ElementName="UnitPrice" DataType="R"/> <ColumnDescription FieldNumber="16" ElementName="ItemDescription" DataType="AN"/> <ColumnDescription FieldNumber="17" ElementName="ExtendedPrice" DataType="R"/> </RowDescription> </Grammar> </CSVSourceFileDescription> |
<?xml version="1.0" encoding="UTF-8"?> <CSVTargetFileDescription xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="CSVTargetFileDescription.xsd"> <PhysicalCharacteristics> <RecordTerminator value="U"/> <ColumnDelimiter value=","/> <TextDelimiter value="""/> </PhysicalCharacteristics> <Grammar ElementName="PurchaseOrder"> <RowDescription ElementName="POLine"> <ColumnDescription FieldNumber="1" ElementName="CustomerNumber" DataType="AN"/> <ColumnDescription FieldNumber="2" ElementName="PONumber" DataType="AN"/> <ColumnDescription FieldNumber="3" ElementName="PODate" DataType="DMMsDDsYYYY"/> <ColumnDescription FieldNumber="4" ElementName="RequestedDeliveryDate" DataType="DMMsDDsYYYY"/> <ColumnDescription FieldNumber="5" ElementName="ShipToName" DataType="AN" DelimitText="true"/> <ColumnDescription FieldNumber="6" ElementName="ShipToStreet1" DataType="AN" DelimitText="true"/> <ColumnDescription FieldNumber="7" ElementName="ShipToStreet2" DataType="AN" DelimitText="true"/> <ColumnDescription FieldNumber="8" ElementName="ShipToCity" DataType="AN" DelimitText="true"/> <ColumnDescription FieldNumber="9" ElementName="ShipToStateOrProvince" DataType="AN"/> <ColumnDescription FieldNumber="10" ElementName="ShipToPostalCode" DataType="AN"/> <ColumnDescription FieldNumber="11" ElementName="ShipToCountry" DataType="AN"/> <ColumnDescription FieldNumber="12" ElementName="ItemID" DataType="AN"/> <ColumnDescription FieldNumber="13" ElementName="OrderedQty" DataType="R"/> <ColumnDescription FieldNumber="14" ElementName="UnitPrice" DataType="R"/> <ColumnDescription FieldNumber="15" ElementName="ItemDescription" DataType="AN" DelimitText="true"/> </RowDescription> </Grammar> </CSVTargetFileDescription> |
Note that in these documents and in the associated schemas, the URLs for the schema locations are all relative. They specify only the file name and not the full path location. So, a processor would expect these to all reside in the same path. I'll follow this convention in this and the next two chapters.