Oracle-1-0-B2B-Invoice-Out

The data mapping and sample payload for the Oracle-1-0-B2B-Invoice-Out message definition are outlined in this section.

Data Mapping

Here's the structure of the payload that's received from the application:

B2B Invoice Outbound Payload Structure

Refer to Figure 1 in Oracle-1-0-B2B-Invoice-In for the structure of the transformed payload that's sent to your trading partner.

This table shows the mapping of the outbound B2B invoice message to the application:

SourcefindTransferDocumentByDocumentCustomerTrxIdResponse/result	TargetB2BInvoiceMessage/B2BInvoice
TrxNumber	InvoiceNumber
TrxDate	InvoiceDate
DocumentType	TypeCode DVM associated with this field is INVOICE_TYPE_CODE.
TrxTypeName	SubTypeCode DVM associated with this field is INVOICE_TRX_TYPE_CODE.
SupplierDescription	Description
TermDueDate	PaymentDueDate
ReceiptMethodName	PaymentMethodCode DVM associated with this field is PAYMENT_METHOD.
CurrencyCode	CurrencyCode DVM associated with this field is CURRENCY_CODE.
TaxExclusiveAmount	TaxExclusiveTotalAmount
TaxAmount	TaxTotalAmount
TransferDocHeaderCharge/ChargeAmount	ChargeTotalAmount sum(TransferDocHeaderCharge/ChargeAmount)
`TransferDocPaymentTerm[DiscountAmount != '']/DiscountAmount`	`DiscountTotalAmount` `sum(TransferDocPaymentTerm[DiscountAmount != '']/DiscountAmount)`
LineExtensionAmount	LineExtensionAmount
InvoiceAmount	TotalAmount
ReferenceNumber	DocumentReferenceNumber
`PurchaseOrder`	OrderNumber
OriginalTrxNumber	OriginalInvoiceNumber
OrigTrxDate	OriginalInvoiceDate
WaybillNumber	WaybillNumber
SupplierRegNumber	Supplier/Number
LegalEntityName	Supplier/Name
LegalEntityTaxpayerId	Supplier/TaxNumber
SupplierAddressLineOne	Supplier/AddressLine1
SupplierAddressLineTwo	Supplier/AddressLine2
SupplierAddressLineThree	Supplier/AddressLine3
SupplierTownOrCity	Supplier/City
SupplierRegionTwo	Supplier/StateOrProvince DVM associated with this field is STATE.
SupplierPostalCode	Supplier/PostalCode
SupplierCountry	Supplier/Country DVM associated with this field is COUNTRY_CODE.
SalesRepresent	Supplier/ContactName
SupplierPhoneNumberOne	Supplier/Phone1
SupplierPhoneNumberTwo	Supplier/Phone2
SupplierPhoneNumberThree	Supplier/Phone3
SalesRepresentEmail	Supplier/EmailAddress
TransferDocPaymentTerm[1]	PaymentTerms
PaymenttermName	PaymentTermName DVM associated with this field is PAYMENT_TERMS.
DueDate	DueDate
DueAmount	DueAmount
`DiscountAmount`	`DiscountAmount`
TransferDocPayerTradeParty[1]	Payer The first occurrence of TransferDocPayerTradeParty is mapped.
PartyName	Name
CustomerTaxRegNumber	TaxRegistrationNumber
`../LegalEntityCountryCode (**) SprfGlobalAttributeCategory SprfGlobalAttribute1`	LocaleTaxNumber If the `LegalEntityCountryCode` is France and the SprfGlobalAttributeCategory is equal to JExFRCustomerProfileInfo, then SprfGlobalAttribute1 is mapped to LocaleTaxNumber.
AddressLineOne	AddressLine1
AddressLineTwo	AddressLine2
AddressLineThree	AddressLine3
AddressLineFour	AddressLine4
City	City
State Province	StateOrProvince If a value for state exists, it is mapped. Otherwise, the province is mapped if it exists. DVM associated with this field is STATE.
PostalCode	PostalCode
CountryCode	Country DVM associated with this field is COUNTRY_CODE.
SiteCpName	ContactName
SiteCpPhoneCountryCode SiteCpPhoneAreaCode SiteCpPhoneNumber SiteCpPhoneExtension	Phone `concatenate(SiteCpPhoneCountryCode, SiteCpPhoneAreaCode, SiteCpPhoneNumber, SiteCpPhoneExtension)`
SiteCpEmailAddress	EmailAddress
TransferDocShipToTradeParty[1]	ShipTo Map the first occurrence of TransferDocShipToTradeParty to ShipTo.
CustomerTaxRegNumber	TaxNumber
AccountNumber	AccountNumber
PartyName	Name
AddressLineOne	AddressLine1
AddressLineTwo	AddressLine2
AddressLineThree	AddressLine3
AddressLineFour	AddressLine4
City	City
State	StateOrProvince If a value for state exists, it is mapped. DVM associated with this field is STATE.
Province	StateOrProvince If a value for Province exists, it is mapped. DVM associated with this field is STATE.
PostalCode	PostalCode
CountryCode	Country DVM associated with this field is COUNTRY_CODE.
Name	ContactName
`concat(PrimaryPhoneAreaCode, '-', PrimaryPhoneNumber)`	Phone
EmailAddress	EmailAddress
TransferDocBillToTradeParty[1]	BillTo Map the first occurrence of TransferDocBillToTradeParty if it exists.
	Number The Number empty tag won't be in the transformed payload, unless $createEmptyNodes is set to True.
PartyName	Name
CustomerTaxRegNumber	TaxRegistrationNumber
`../LegalEntityCountryCode (**) SprfGlobalAttributeCategory SprfGlobalAttribute1`	LocaleTaxNumber If the `LegalEntityCountryCode` is France and the SprfGlobalAttributeCategory is equal to JExFRCustomerProfileInfo, then SprfGlobalAttribute1 is mapped to LocaleTaxNumber.
AccountNumber	AccountNumber
AddressLineOne	AddressLine1
AddressLineTwo	AddressLine2
AddressLineThree	AddressLine3
AddressLineFour	AddressLine4
City	City
State	StateOrProvince If a value for state exists, it is mapped. DVM associated with this field is STATE.
Province	StateOrProvince If a value for Province exists, it is mapped. DVM associated with this field is STATE.
PostalCode	PostalCode
CountryCode	Country DVM associated with this field is COUNTRY_CODE.
Name	ContactName
`concat(PrimaryPhoneAreaCode, '-', PrimaryPhoneNumber)`	Phone
EmailAddress	EmailAddress
TransferDocHeaderCharge	Charge
LineType	TypeCode DVM associated with this field is CHARGE_REASON_CODE.
Description	Description
ChargeAmount	Amount
TransferDocHeaderTax	Tax
TaxableAmount	TaxableAmount
TaxAmount	Amount
TaxRateCode	TaxCode DVM associated with this field is TAX_CATEGORY_CODE.
TaxRate	TaxRate If no value is provided, set to 0.
TaxRegimeCode	TaxRegimeCode
ExemptReasonCode	ExemptReasonCode
ExemptReason	ExemptReason If no value is provided, set to Exempt.
TransferDocLine	Lines
LineNumber	LineNumber
	SupplierItemNumber The SupplierItemNumber tag won't be in the transformed payload, unless $createEmptyNodes is set to True.
Item	CustomerItemNumber
ItemDescription	ItemDescription
Quantity	Quantity
UnitOfMeasure	UnitOfMeasureCode DVM associated with this field is UOM_CODE.
UnitSellingPrice	UnitPriceAmount
LineAmount	LineExtensionAmount
Description	Description
	TaxExclusiveAmount LineAmount - LineTaxAmount
TransferDocLineCharge/ChargeAmount	ChargeTotalAmount sum(TransferDocLineCharge/ChargeAmount)
LineTaxAmount	TaxTotalAmount
`TransferDocPurchaseOrder[1]/PurchaseOrder`	`PurchaseOrderNumber`
	`PurchaseOrderLineNumber`
	`PurchaseOrderScheduleLineNumber`
`TransferDocSalesOrder[1]/SalesOrder`	`SalesOrderNumber`
`TransferDocSalesOrder[1]/SalesOrderLine`	`SalesOrderLineNumber`
OriginalTrxNumber	OriginalInvoiceNumber
OriginalTrxDate	OriginalInvoiceDate
ShipToLocAddress1	ShipTo/AddressLine1
ShipToLocAddress2	ShipTo/AddressLine2
ShipToLocAddress3	ShipTo/AddressLine3
ShipToLocCity	ShipTo/City
ShipToLocPostalCode	ShipTo/PostalCode
ShipToLocCountry	ShipTo/Country DVM associated with this field is COUNTRY_CODE.
TransferDocLine/TransferDocLineCharge	Lines/Charge
ChargeAmount	Amount
Description	Description
LineType	TypeCode DVM associated with this field is CHARGE_REASON_CODE
TransferDocLine/TransferDocTax	Lines/Tax
TaxableAmount	TaxableAmount
TaxAmount	Amount
TaxRateCode	TaxCode DVM associated with this field is TAX_CATEGORY_CODE.
TaxRate	TaxRate
TaxRegimeCode	TaxRegimeCode
ExemptReasonCode	ExemptReasonCode
ExemptReason	ExemptReason
TransferDocHeaderAttachments	Attachments
DmDocumentId	Id Unique DmDocumentId are mapped.
	FileName
	FileTypeCode
	FileSizeQuantity
	EmbeddedBinaryDataObject