Mapping CSF to OneSource

Batch level

Element name Type Required Infor table/field
<USERNAME> Alpha (60) Yes, if OneSourceVersionType=Generic TaxConfiguratioVersion/

UserName

<PASSWORD> Alpha (16) Yes, if OneSourceVersionType=Generic TaxConfigVersion/

OneSourcePassword

<INVOICE> Structural Yes n/a

Invoice level

Element name Type Required Infor table/field
<HOST_SYSTEM> Alpha (100) Yes TaxEntity/

HostSystem

<EXTERNAL_COMPANY_ID> Alpha (100) Yes TaxEntity/

ExternalCompanyId

<COMPANY_NAME> Alpha (100) Yes TaxEntity/

ExternalCompanyIdName

<COMPANY_ROLE> Alpha (20) Yes TaxEntity/

CompanyRole

<FILTER_GROUP_NAME Alpha (50) No TaxEntity/

FilterGroupName

<FILTER_GROUP_OWNER> Alpha (40) No TaxEntity/

FilterGroupOwner

<PRODUCT_MAPPING_GROUP_OWNER> Alpha (40) No TaxEntity/

ProductMappingGroupOwner

<PRODUCT_MAPPING_GROUP_NAME> Alpha (40) No TaxEntity/

ProductMappingGroupName

<CURRENCY_CODE> Alpha (3) Yes <calling system>/

Currency

<IS_AUDITED> Boolean No n/a
<INVOICE_DATE> Date Yes <calling system>/

InvoiceDate

<FISCAL_DATE> Date No <calling system>/

PostDate

<DOCUMENT_TYPE> Alpha (50) No <calling system>/

DocumentType

<INVOICE_NUMBER> Alpha (200) Yes <calling system>/

InvoiceNumber

<VENDOR_NUMBER> Alpha (100) Yes <calling system>/

Vendor

<VENDOR_NAME> Alpha (100) Yes <calling system>/

VendorName

<CUSTOMER_NUMBER> Alpha (100) Yes, for Recievables <calling system>/

Customer

<CUSTOMER_NAME> Alpha (100) Yes, for Recievables <calling system>/

CustomerName

<END_USER_NAME> Alpha (100) No <calling system>/

Actor

<TRANSACTION_TYPE> Alpha (2) Yes Hard Coded “GS”/

n/a

Line level

Element name Type Required Infor table/field
<LINE_ID="N"> Structural Yes <calling system>/

LineNumber

<PRODUCT_CODE> Alpha 15 Yes <calling system>/

ProductTaxCategory, ICN Code, or TaxUsageCode

<GROSS_AMOUNT> Number Yes <calling system>/

TaxableAmount

<COMMODITY_CODE> Alpha 5 Yes <calling system>/

CommodityCode

<DELIVERY_TERMS> Alpha Upper 3 Yes <calling system>/

DeliveryTerms/ShipTerms

<PART_NUMBER> AlphaUpper 32 Yes <calling system>/

Item

<SHIP_TO> Structural Yes <calling system>/

Ship To Address

<COUNTRY> Alpha (50) Yes <calling system>/

Ship To Address Country

<PROVINCE> Alpha (50) Yes, Canada <calling system>/

Ship To Address Province

<STATE> Alpha (50) Yes <calling system>/

Ship To Address State

<COUNTY> Alpha (50) No <calling system>/

Ship To Address County

<CITY> Alpha (50) No <calling system>/

Ship To Address City

<POSTCODE> Alpha (50) Yes <calling system>/

Ship To Address Postal Code

<GEOCODE> Alpha (50) Yes <calling system>/

Ship To Address Postal Code last 4 digits

<SHIP_FROM> Structural Yes n/a
<COUNTRY> Alpha (50) Yes <calling system>/Ship From Address Country
<PROVINCE> Alpha (50) Yes, Canada <calling system>/Ship From Address Province
<STATE> Alpha (50) Yes <calling system>/Ship From Address State
<COUNTY> Alpha (50) No <calling system>/Ship From Address County
<CITY> Alpha (50) No <calling system>/Ship From Address City
<POSTCODE> Alpha (50) No <calling system>/Ship From Address Postal Code
<GEOCODE> Alpha (50) No <calling system>/Ship From Address Zip last 4 digits
<QUANTITIES> Structural No n/a
<QUANTITY> Structural No n/a/

Quantity

<AMOUNT> Number No <calling system>/

Quantity Amount

<UOM> Alpha (25) No <calling system>/

Unit of Measure

<USER_ELEMENT> Structural Yes n/a
<NAME> Alpha (200) Yes, if Attribute is passed <calling system>/

ATTRIBUTE1-50

<VALUE> Alpha (200) Yes, if Attribute is passed n/a/

Attribute value

Element name explanations are located in the OneSource programmers guide.

If the OneSource user guide already has a mapping, just add the missing fields.