O2O Invoices – Ingen Software

This document describes the XML data used by OASIS internally to share invoice information with a trading partner. An O2O may be generated and shared in the following ways:

generated by the manufacturer version of OASIS and transmitted to the representative version of OASIS
generated by the representative version of OASIS and transmitted to the distributor version of OASIS

The definition below may be used to do basic validation of the XML. For more information, please contact OASIS support by email at support@oasissalessoftware.com or by phone at 501-843-6750.

Definition

The XSD is downloadable here: O2O-Invoice.xsd (5 KB download)

Example

The example is downloadable here: InvoiceExample.xml (2 KB download)

Note: the file suffix of .o2o is used to indicate the file content is a native OASIS document. Otherwise, it is possible the file may be rejected, especially if the file is to be manually "dropped" onto the OASIS application.

Field Descriptions

The following fields are defined:

InvoiceType Fields

Name	Description	Data Values
VERSION	See "VERSIONTYPE"
DocumentDate	Date the document was created	Date
From	Business entity the quote is being sent from; see "PartyType"
FromDBID	Database ID assigned by Ingen Software (don't make anything up - results are not predictable)	String:32
To	Business entity the quote is being sent to; see "PartyType"
ProjectName	The name of the project	String:255
STAMP	Short message with importance, e.g.: "NEXT DAY AIR!"	String:32
MyPOID	Used to uniquely identify the PO in OASIS	Integer
MyPODBID	Used to uniquely identify the PO in OASIS	String:32
PONumber	The customer PO number	String:32
EntryDate	The order "entry" date	Date
InvoiceNumber	The invoice number	String:32
InvoiceDate	Date of the invoice	String:32
SoldTo	Sold to name and address	See "PartyType"
BillTo	Bill to name and address	See "PartyType"
ShipTo	Ship to name and address	See "PartyType"
FreightType	Generic description of the shipping type, e.g.: Ground, Will Call, Next Day Air, or shipping product	String:32
FreightAccount	Customer freight account to use	String:32
Remarks	Basic notes on the order	String:256
Notes	Notes to communicate about the order - typically build related notes	String
Lines	The lines of the invoice	See "LineType"

VERSIONTYPE Fields

Name	Description	Data Values
v	OASIS version being used	MUST BE '2.7.0'
dbv	OASIS database version being used	String:32
r	OASIS version release	String:32

PartyType Fields

Name	Description	Data Values
NAME	Company Name	String:255
LINE1	Address line 1	String:255
LINE2	Address line 2	String:255
CITY	City Name	String:255
STATE	State of provence	String:2
COUNTY	County	String:32
COUNTRY	Country	String:3 - prefer ISO code
Contacts	Listing of contacts; see "ContactType"

ContactType Fields

Name	Description	Data Value
FullName	Name of contact	String:32
Email	Email address for contact	String:32
Phone	Contacts phone number	String:32

InvoiceLineType Fileds

Name	Description	Data Value
InvoiceLineCode	Omit or blank if part/fixture; otherwise, this indicates note, lot, or other line code
MyLineUID	Internal OASIS line identifier	Integer
YourLineUID	Internal OASIS line identifier	Integer
Quantity	Count of items	Decimal:12,2
FixtureType	Fixture type	String:32
MyManufacturerID	Manufacturer ID used by the sender	String:32
CatalogNumber	The catalog number only (no description, etc.)	String:128
Description	Marketing description of the item	String
Notes	Build and other notes about fixture	String
UnitQuantityCount	For "per 100" pricing, use the value 100; default is 1	Decimal
PartQuantity	Lable for quantity (e.g. foot, meter, etc); no standards	String:32
SellPrice	Invoice sell Price	Decimal:14,4
SellCommissionRate	Commission Rate for Sell Price. Value is stored as ##.##. 50.25 is 50.25%	Decimal:5,2

Article attachments:

O2O-Invoice.xsd
5 KB Download
InvoiceExample.xml
2 KB Download