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:
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 |