Create an Invoice with Foreign Currency and Descriptive Flexfield
A visitor to the US, where the ledger currency is USD, logs into your web store to browse for laptops and support services. They submit an order for a high-speed processor computer, with 12 GB memory, and adds information about the preferred color (green) and where they are located (Paris), for the laptop they wish to purchase with a foreign currency.
Example URL
Here's an example of the resource URL:
POST
fscmRestApi/resources/11.13.18.05/receivablesInvoices
cURL Command
curl --user <username>:<password> -X POST -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" --data @invoice_with_foreign_currency_and_dff_payload.json https://<host>:<port>/fscmRestApi/resources/<version>/receivablesInvoices
Example Request
Here's an example of the request body in JSON format::
{
"BillToCustomerNumber": "1003",
"BusinessUnit": "Vision Operations",
"InvoiceCurrencyCode": "EUR",
"ConversionDate": "2017-12-15",
"ConversionRate": 0.75,
"ConversionRateType": "User",
"TransactionNumber": "Dec 8(4)",
"TransactionSource": "AR_Trans Source_08",
"TransactionType": "Invoice_35",
"receivablesInvoiceLines": [
{
"Description" : "Laptop-Highspeed",
"Quantity": 10,
"UnitSellingPrice": 100,
"receivablesInvoiceLineDFF": [
{
"__FLEX_Context": "Invoice Lines",
"_Data__on__the__Project": "Test Data",
"_PCN": "Test PCN",
"_Name": "Test Name",
"_resource__type": "Test Type",
"_Line5": "Test Line"
}
]
}
],
"receivablesInvoiceDFF": [
{
"__FLEX_Context": "Transactions",
"_Transactions1": "Transaction 1",
"_Transactions2": "Transaction 2",
"_Transactions3": "Transaction 3"
}
]
}
Example Response
Here's an example of the response body in JSON format:
{
"CustomerTransactionId": 300100170996529,
"DueDate": null,
"ConversionDate": "2017-12-15",
"ConversionRate": 0.75,
"InvoiceCurrencyCode": "EUR",
"SpecialInstructions": null,
"CrossReference": null,
"DocumentNumber": null,
"TransactionNumber": "Dec 8(4)",
"TransactionDate": "2018-12-19",
"TransactionType": "Invoice_35",
"TransactionSource": "AR_Trans Source_08",
"BillToCustomerNumber": "1003",
"BillToSite": "Atlanta (OPS)",
"Comments": null,
"InternalNotes": null,
"PaymentTerms": "30 Net",
"LegalEntityIdentifier": "USSYS12030",
"ConversionRateType": "User",
"PurchaseOrder": null,
"PurchaseOrderDate": null,
"PurchaseOrderRevision": null,
"FirstPartyRegistrationNumber": "4567890",
"ThirdPartyRegistrationNumber": "EST22335566",
"InvoicingRule": null,
"ShipToCustomerName": "UNITED PARCEL SERVICE, INC",
"ShipToCustomerNumber": "1003",
"BillingDate": null,
"BusinessUnit": "Vision Operations",
"InvoiceStatus": null,
"AccountingDate": null,
"ShipToSite": null,
"PayingCustomerName": null,
"PayingCustomerSite": null,
"BillToCustomerName": null,
"FreightAmount": null,
"Carrier": null,
"ShipDate": null,
"ShippingReference": null,
"BillToContact": null,
"ShipToContact": null,
"PrintOption": null,
"CreatedBy": "AR_MGR_OPERATIONS",
"CreationDate": "2018-12-19T06:50:15.004+00:00",
"LastUpdatedBy": "AR_MGR_OPERATIONS",
"LastUpdateDate": "2018-12-19T06:50:15.572+00:00",
"PayingCustomerAccount": null,
"SoldToPartyNumber": null,
"RemitToAddress": null,
"DefaultTaxationCountry": null,
"EnteredAmount": null,
"InvoiceBalanceAmount": null,
"Prepayment": null,
"Intercompany": null,
"DocumentFiscalClassification": null,
"BankAccountNumber": null,
"CreditCardAuthorizationRequestIdentifier": null,
"CreditCardExpirationDate": null,
"CreditCardIssuerCode": null,
"CreditCardTokenNumber": null,
"CreditCardVoiceAuthorizationCode": null,
"CreditCardErrorCode": null,
"CreditCardErrorText": null,
"CardHolderLastName": null,
"CardHolderFirstName": null,
"ReceiptMethod": null,
"SalesPersonNumber": null,
"StructuredPaymentReference": null,
"receivablesInvoiceLines": [
{
"CustomerTransactionLineId": 300100170996530,
"LineNumber": 1,
"Description": "Laptop-Highspeed",
"Quantity": 10,
"UnitSellingPrice": 100,
"TaxClassificationCode": null,
"SalesOrder": null,
"AccountingRuleDuration": null,
"RuleEndDate": null,
"RuleStartDate": null,
"AccountingRule": null,
"Warehouse": null,
"MemoLine": null,
"UnitOfMeasure": null,
"ItemNumber": null,
"AllocatedFreightAmount": null,
"AssessableValue": null,
"SalesOrderDate": null,
"LineAmount": null,
"CreatedBy": "AR_MGR_OPERATIONS",
"CreationDate": "2018-12-19T06:50:15.255+00:00",
"LastUpdatedBy": "AR_MGR_OPERATIONS",
"LastUpdateDate": "2018-12-19T06:50:15.578+00:00",
"TransacationBusinessCategory": null,
"UserDefinedFiscalClassification": null,
"ProductFiscalClassification": null,
"ProductCategory": null,
"ProductType": null,
"LineIntendedUse": null,
"LineAmountIncludesTax": null,
"TaxInvoiceDate": null,
"TaxInvoiceNumber": null,
"TaxExemptionCertificateNumber": null,
"TaxExemptionHandling": null,
"TaxExemptionReason": null,
"receivablesInvoiceLineDFF": [
{
"CustomerTrxLineId": 300100170996530,
"__FLEX_Context": "Invoice Lines",
"__FLEX_Context_DisplayValue": "Invoice Lines",
"_Data__on__the__Project": "Test Data",
"_PCN": "Test PCN",
"_Name": "Test Name",
"_resource__type": "Test Type",
"_Line5": "Test Line",
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/child/receivablesInvoiceLineDFF/300100170996530",
"name": "receivablesInvoiceLineDFF",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/child/receivablesInvoiceLineDFF/300100170996530",
"name": "receivablesInvoiceLineDFF",
"kind": "item"
},
{
"rel": "parent",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530",
"name": "receivablesInvoiceLines",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/child/receivablesInvoiceLineDFF/300100170996530/lov/LVVO___FLEX_Context",
"name": "LVVO___FLEX_Context",
"kind": "collection"
}
]
}
],
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530",
"name": "receivablesInvoiceLines",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530",
"name": "receivablesInvoiceLines",
"kind": "item"
},
{
"rel": "parent",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529",
"name": "receivablesInvoices",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/memoLines",
"name": "memoLines",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/warehouses",
"name": "warehouses",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/itemNumbers",
"name": "itemNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/productCategories",
"name": "productCategories",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/userDefinedFiscClasses",
"name": "userDefinedFiscClasses",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/exemptReasonCodes",
"name": "exemptReasonCodes",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/taxExemptHandlingStatuses",
"name": "taxExemptHandlingStatuses",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/transactionBizCategories",
"name": "transactionBizCategories",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/productFiscClassifications",
"name": "productFiscClassifications",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/accountingRules",
"name": "accountingRules",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/unitOfMeasures",
"name": "unitOfMeasures",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/productTypes",
"name": "productTypes",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/child/receivablesInvoiceLineGdf",
"name": "receivablesInvoiceLineGdf",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/child/receivablesInvoiceLineTaxLines",
"name": "receivablesInvoiceLineTaxLines",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/child/receivablesInvoiceLineDFF",
"name": "receivablesInvoiceLineDFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/child/receivablesInvoiceLineTransactionDFF",
"name": "receivablesInvoiceLineTransactionDFF",
"kind": "collection"
}
]
}
],
"receivablesInvoiceDFF": [
{
"CustomerTrxId": 300100170996529,
"__FLEX_Context": "Transactions",
"__FLEX_Context_DisplayValue": "Transactions",
"_Transactions1": "Transaction 1",
"_Transactions2": "Transaction 2",
"_Transactions3": "Transaction 3",
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceDFF/300100170996529",
"name": "receivablesInvoiceDFF",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceDFF/300100170996529",
"name": "receivablesInvoiceDFF",
"kind": "item"
},
{
"rel": "parent",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529",
"name": "receivablesInvoices",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceDFF/300100170996529/lov/LVVO___FLEX_Context",
"name": "LVVO___FLEX_Context",
"kind": "collection"
}
]
}
],
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529",
"name": "receivablesInvoices",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529",
"name": "receivablesInvoices",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/transactionSources",
"name": "transactionSources",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/businessUnits",
"name": "businessUnits",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/PaymentTermsVA",
"name": "PaymentTermsVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/thirdPartyTaxRegistrationNumbers",
"name": "thirdPartyTaxRegistrationNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/invoiceStatuses",
"name": "invoiceStatuses",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/shipToCustomers",
"name": "shipToCustomers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/billToCustomers",
"name": "billToCustomers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/legalEntities",
"name": "legalEntities",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/invoicingRules",
"name": "invoicingRules",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/billToSites",
"name": "billToSites",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/taxationCountries",
"name": "taxationCountries",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/firstPartyTaxRegistrationNumbers",
"name": "firstPartyTaxRegistrationNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/lov/transactionTypes",
"name": "transactionTypes",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceLines",
"name": "receivablesInvoiceLines",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceTransactionDFF",
"name": "receivablesInvoiceTransactionDFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceGdf",
"name": "receivablesInvoiceGdf",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceInstallments",
"name": "receivablesInvoiceInstallments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/receivablesInvoiceDFF",
"name": "receivablesInvoiceDFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996529/child/notes",
"name": "notes",
"kind": "collection"
}
]
}