Create an Invoice with Split Payment Terms and Add an Attachment
A customer purchases a new autonomous database server and has an agreement with you to pay in installments over 90 days. Instructions on how to install and maintain the server are appended to the invoice.
Example URL
Here's an example of the resource URL:
POST
fscmRestApi/resources/11.13.18.05/receivablesInvoicescURL Command
curl --user <username>:<password> -X POST -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" --data @invoice_with_split_payment_terms_payload.json https://<host>:<port>/fscmRestApi/resources/<version>/receivablesInvoices
Example Request
Here's an example of the request body in JSON format::
{
"AccountingDate": "2017-11-14",
"BillingDate": "2017-11-14",
"BillToCustomerNumber": "1008",
"BillToSite": "Foster City (OPS)",
"BillToContact": "Maggie Munro",
"BusinessUnit": "Vision Operations",
"Comments": "Test comments",
"ConversionDate": "2017-12-15",
"ConversionRate": 0.75,
"ConversionRateType": "User",
"CrossReference": "Test cross reference",
"DueDate": "2017-12-15",
"InternalNotes": "Test internal notes",
"InvoiceCurrencyCode": "EUR",
"InvoicingRule": "Advance Invoice",
"LegalEntityIdentifier": "USSYS12030",
"PaymentTerms": "30/60/90",
"PurchaseOrder": "Test purchase order",
"PurchaseOrderDate": "2017-11-14",
"PurchaseOrderRevision": "Test purchase order revision",
"ShipToCustomerName": "Total Internet",
"ShipToCustomerNumber": "1008",
"ShipToSite": "1042",
"ShipToContact": "Maggie Munro",
"SpecialInstructions": "Test special instructions",
"TransactionDate": "2017-11-14",
"TransactionNumber": "Apr25-1",
"TransactionSource": "AR_Trans Source_08",
"TransactionType": "Invoice_35",
"PrintOption": "No",
"Carrier": "Carrier Value",
"ShipDate": "2017-11-14",
"ShippingReference": "Shipping Reference Value",
"receivablesInvoiceLines": [
{
"AccountingRule": "AR_RevRules_Var_02-NES",
"AccountingRuleDuration": 3,
"Description" : "Database Server",
"LineNumber": 1,
"RuleStartDate": "2017-11-14",
"TaxClassificationCode": "VAT20",
"Quantity": 1,
"UnitOfMeasure": "EA",
"UnitSellingPrice": 2256578,
"Warehouse": "Vision Operations",
"SalesOrder": "900",
"SalesOrderDate": "2017-11-14",
"AllocatedFreightAmount": 200,
}
]
}
Example Response
Here's an example of the response body in JSON format:
{
"CustomerTransactionId": 300100170996512,
"DueDate": "2017-12-15",
"ConversionDate": "2017-12-15",
"ConversionRate": 0.75,
"InvoiceCurrencyCode": "EUR",
"SpecialInstructions": "Test special instructions",
"CrossReference": "Test cross reference",
"DocumentNumber": null,
"TransactionNumber": "Apr25-1",
"TransactionDate": "2017-11-14",
"TransactionType": "Invoice_35",
"TransactionSource": "AR_Trans Source_08",
"BillToCustomerNumber": "1008",
"BillToSite": "Foster City (OPS)",
"Comments": "Test comments",
"InternalNotes": "Test internal notes",
"PaymentTerms": "30/60/90",
"LegalEntityIdentifier": "USSYS12030",
"ConversionRateType": "User",
"PurchaseOrder": "Test purchase order",
"PurchaseOrderDate": "2017-11-14",
"PurchaseOrderRevision": "Test purchase order revision",
"FirstPartyRegistrationNumber": "4567890",
"ThirdPartyRegistrationNumber": null,
"InvoicingRule": "Advance Invoice",
"ShipToCustomerName": "Total Internet",
"ShipToCustomerNumber": "1008",
"BillingDate": "2017-11-14",
"BusinessUnit": "Vision Operations",
"InvoiceStatus": null,
"AccountingDate": "2017-11-14",
"ShipToSite": "1042",
"PayingCustomerName": null,
"PayingCustomerSite": null,
"BillToCustomerName": null,
"FreightAmount": null,
"Carrier": "Carrier Value",
"ShipDate": "2017-11-14",
"ShippingReference": "Shipping Reference Value",
"BillToContact": "Maggie Munro",
"ShipToContact": "Maggie Munro",
"PrintOption": "No",
"CreatedBy": "AR_MGR_OPERATIONS",
"CreationDate": "2018-12-19T06:46:56.003+00:00",
"LastUpdatedBy": "AR_MGR_OPERATIONS",
"LastUpdateDate": "2018-12-19T06:46:56.369+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": 300100170996513,
"LineNumber": 1,
"Description": "Database Server",
"Quantity": 1,
"UnitSellingPrice": 2256578,
"TaxClassificationCode": "VAT20",
"SalesOrder": "900",
"AccountingRuleDuration": 3,
"RuleEndDate": null,
"RuleStartDate": "2017-11-14",
"AccountingRule": "AR_RevRules_Var_02-NES",
"Warehouse": null,
"MemoLine": null,
"UnitOfMeasure": "EA",
"ItemNumber": null,
"AllocatedFreightAmount": 200,
"AssessableValue": null,
"SalesOrderDate": "2017-11-14",
"LineAmount": 2256578,
"CreatedBy": "AR_MGR_OPERATIONS",
"CreationDate": "2018-12-19T06:46:56.254+00:00",
"LastUpdatedBy": "AR_MGR_OPERATIONS",
"LastUpdateDate": "2018-12-19T06:46:56.377+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,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513",
"name": "receivablesInvoiceLines",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513",
"name": "receivablesInvoiceLines",
"kind": "item"
},
{
"rel": "parent",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512",
"name": "receivablesInvoices",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/memoLines",
"name": "memoLines",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/warehouses",
"name": "warehouses",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/itemNumbers",
"name": "itemNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/productCategories",
"name": "productCategories",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/userDefinedFiscClasses",
"name": "userDefinedFiscClasses",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/exemptReasonCodes",
"name": "exemptReasonCodes",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/taxExemptHandlingStatuses",
"name": "taxExemptHandlingStatuses",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/transactionBizCategories",
"name": "transactionBizCategories",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/productFiscClassifications",
"name": "productFiscClassifications",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/accountingRules",
"name": "accountingRules",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/unitOfMeasures",
"name": "unitOfMeasures",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/productTypes",
"name": "productTypes",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/child/receivablesInvoiceLineGdf",
"name": "receivablesInvoiceLineGdf",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/child/receivablesInvoiceLineTaxLines",
"name": "receivablesInvoiceLineTaxLines",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/child/receivablesInvoiceLineDFF",
"name": "receivablesInvoiceLineDFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/child/receivablesInvoiceLineTransactionDFF",
"name": "receivablesInvoiceLineTransactionDFF",
"kind": "collection"
}
]
}
],
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512",
"name": "receivablesInvoices",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512",
"name": "receivablesInvoices",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/transactionSources",
"name": "transactionSources",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/businessUnits",
"name": "businessUnits",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/PaymentTermsVA",
"name": "PaymentTermsVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/thirdPartyTaxRegistrationNumbers",
"name": "thirdPartyTaxRegistrationNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/invoiceStatuses",
"name": "invoiceStatuses",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/shipToCustomers",
"name": "shipToCustomers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/billToCustomers",
"name": "billToCustomers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/legalEntities",
"name": "legalEntities",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/invoicingRules",
"name": "invoicingRules",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/billToSites",
"name": "billToSites",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/taxationCountries",
"name": "taxationCountries",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/firstPartyTaxRegistrationNumbers",
"name": "firstPartyTaxRegistrationNumbers",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/lov/transactionTypes",
"name": "transactionTypes",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceLines",
"name": "receivablesInvoiceLines",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceTransactionDFF",
"name": "receivablesInvoiceTransactionDFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceGdf",
"name": "receivablesInvoiceGdf",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceInstallments",
"name": "receivablesInvoiceInstallments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/receivablesInvoiceDFF",
"name": "receivablesInvoiceDFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996512/child/notes",
"name": "notes",
"kind": "collection"
}
]
}