API Catalog

Create multiple AR Invoices

01 Oct 2025
7 Minutes to read

Print
Dark
Light

Create multiple AR Invoices

Updated on 01 Oct 2025
7 Minutes to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback!

Post

/ar-rest-api/rest/1/arinvoice

Create Multiple Invoices

UI Location: Financials - Accounts Receivable - Invoice - Enter Invoices

Security

HTTP

Type basic

Basic authentication

Header parameters

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourceItem+json

Body parameters

object

Example{ "parts": [ { "id": "part1", "path": "/1/arinvoice", "operation": "create", "payload": { "InvCustCode": "AXIS", "InvJobCode": "JOBST", "InvNum": "AR-AXIS281", "InvVUuid": "HA2020101022-281", "InvDate": "2020-08-17", "InvOrdNum": "FP-OrderNum", "InvDesc1": "JSON Invoice -- ITS", "InvSalesAmt": 100, "InvTaxes": "10", "InvHldbkAmt": "0", "InvNetAmt": "110", "InvCompCode": "ZZ", "InvSerCode": "AR", "InvDueDate": "2020-10-12", "InvDiscDate": "2020-10-12", "InvCurrCode": "US", "InvCollCode": "ZZ1", "InvChargeCode": "10", "InvAmt": "110", "InvCostCode": "0103-01-01", "InvCatCode": "2000", "InvBchPstFlag": "N" } }, { "id": "part2", "path": "/1/arinvoice", "operation": "create", "payload": { "InvCustCode": "AXIS", "InvJobCode": "JOBST", "InvNum": "AR-AXIS282", "InvVUuid": "HA2020101022-282", "InvDate": "2020-08-19", "InvOrdNum": "FP-OrderNum", "InvDesc1": "JSON Invoice -- ITS", "InvSalesAmt": "100", "InvTaxes": "10", "InvHldbkAmt": "0", "InvNetAmt": "110", "InvCompCode": "ZZ", "InvSerCode": "AR", "InvDueDate": "2020-10-12", "InvDiscDate": "2020-10-12", "InvCurrCode": "US", "InvCollCode": "ZZ1", "InvChargeCode": "10", "InvAmt": "110", "InvCostCode": "0103-01-01", "InvCatCode": "2000", "InvBchPstFlag": "Y" } } ] }

InvInvoiceNewFlag

string

Max length1

InvDesc1

string

Invoice Description 1

💻 UI Fieldname: Description

Max length60

InvWoAmt

number

Max length18

InvTaxes

number

Taxes

💻 UI Fieldname: Taxes

InvSman1CommPc

number

Not Used

Max length6

InvTax1TaxableFlag

string

Flag to indicate that a tax code exists but the tax amount will be calculated as zero. Valid values are (Y)es - meaning taxable and (N)o - meaning non taxable.

Max length1

InvInsAmt

number

Insurance Amount

Max length18

InvDueDate

string

Invoice Due Date

💻 UI Fieldname: Due Date

InvRlsDate

string

InvCRlsTaxAmt

number

C Rls Tax Amount

InvTax1Amt

number

Invoice Tax 1 Amount

Max length18

InvDiscAmt

number

Discount Amount

💻 UI Fieldname: Discount

Max length18

InvTax2Name

string

Tax2 Name

Max length4000

InvAddTypeCode

string

Max length5

InvOriginalDueDateUpdUser

string

The user who updated the original (very first) invoice due date the first time.

Max length30

InvDesc2

string

Invoice Description 2

Max length60

InvPostDate

string

Invoice Post Date

InvStatusCode

string

Status Code

Max length1

InvChargeCode

string

Interest Charge Code

Max length3

InvOutstandAmt

number

Outstanding Amount

Max length18

InvDiscDays

number

Discount Days

InvNum

string

Invoice Code

💻 UI Fieldname: *Invoice Number

Max length11

InvRlsTaxAmt

number

Rls Tax Amount

InvDelinqCode

string

Max length1

InvRlsInvNum

string

Max length11

InvTax1HldbkAmtUpd

number

Tax1 Hldbk Amount Update

Max length18

InvAverageDaysToPay

number

Average days to pay weighted by payed amount.

Max length10

InvOriginalDesc1UpdUser

string

The user who updated the original (very first) invoice description the first time.

Max length30

InvTermPc

number

Max length5

InvReasonDueDateChange

string

Max length200

InvTaxDiscCode

string

Max length1

InvHldbkPc

number

Retainage Percent

💻 UI Fieldname: Retainage

Max length18

InvMiscAmt

number

Miscellaneous Amount

Max length18

InvTax1HldbkAmt

number

Tax 1 Retainage Amount

Max length18

InvRevDate

string

Invoice Void Date

InvHldbkAmtUpd

number

Hldbk Amount Update

Max length18

InvDetTaxAmt

number

Max length18

InvFinAmt

number

Max length18

InvDueDateUpd

string

Due Date Update

InvIuUpdateDate

string

InvTax2TaxableFlag

string

Flag to indicate that a tax code exists but the tax amount will be calculated as zero. Valid values are (Y)es - meaning taxable and (N)o - meaning non taxable.

Max length1

InvTax3Amt

number

Tax 3 Amount

Max length18

InvHldbkPaidAmt

number

Retainage Paid Amount

Max length18

InvRlsTax1AmtUpd

number

Rls Tax1 Amount Update

Max length18

InvSman1CommAmt

number

Not Used

Max length18

InvSman2CommAmt

number

Not Used

Max length18

InvIuCreateDate

string

InvCreditAmt

number

Credit Amount

Max length18

InvDeptCode

string

Max length6

InvBchNum

number

Batch Number

Max length11

InvCurrCode

string

Currency Code

Max length3

InvDetailsExistFlag

string

Max length1

InvOriginalDesc1

string

The original (very first) invoice description that was updated.

Max length60

InvSman2CommPc

number

Not Used

Max length6

InvTax1TaxableAmt

number

Tax1 Taxable Amount

Max length18

InvNetAmt

number

Net Amount

💻 UI Fieldname: Net Amount

InvInsDiscCode

string

Max length1

InvFrtDiscCode

string

Max length1

InvVUuid

string

Max length64

InvCreditTax1HldbkAmt

number

Max length18

InvImageFilename

string

Max length255

InvSman2Code

string

Not Used

Max length4

InvIuUpdateUser

string

Max length30

InvOriginalDueDateUpdDate

string

The date the original (very first) invoice due date was first updated.

InvRlsWAmt

number

Max length18

InvTax2Code

string

Tax 2 Code

Max length11

InvOtherTaxes

number

Other Taxes

InvTax3TaxableFlag

string

Flag to indicate that a tax code exists but the tax amount will be calculated as zero. Valid values are (Y)es - meaning taxable and (N)o - meaning non taxable.

Max length1

InvRlsAmtUpd

number

Rls Amount Update

InvTotalRlsTaxAmt

number

Max length18

InvTermPcUpd

number

Term Pc Update

Max length5

InvDisputedFlag

string

Max length1

InvContCode

string

Max length10

InvIuCreateUser

string

Max length30

InvOePrtCode

string

Max length1

InvLastPayAmt

number

Last Amount Paid on this Invoice

Max length18

InvCashAccCode

string

Cash Account Code

Max length16

InvNetAmtUpd

number

Net Amount Update

InvCurFactorNum

number

Currency Exhange Factor

Max length16

InvDiscDate

string

Discount Date

💻 UI Fieldname: Discount Date

InvDiscTakenAmt

number

Discount Amount Taken

Max length18

InvAllowAmt

number

Max length18

InvDistributionExistFlag

string

Max length1

InvTax1Name

string

Tax1 Name

Max length4000

InvTax3TaxableAmt

number

Tax3 Taxable Amount

Max length18

InvSalesAmt

number

💻 UI Fieldname: Invoice Amount

Max length18

InvOrigTax1HldbkAmt

number

Max length18

InvRlsTax1Amt

number

Max length18

InvCostCode

string

Max length20

InvCollCode

string

Collector Code

Max length4

InvMiscDiscCode

string

Max length1

InvRevBchNum

number

Max length11

InvNodiscAmt

number

No Discount Available on This Amount

Max length18

InvRlsBchNum

number

Max length11

InvJobCode

string

Job code

💻 UI Fieldname: Job

Max length10

InvBnkAccCode

string

Max length16

InvTax3Name

string

Tax3 Name

Max length4000

InvStmtDate

string

InvTax2TaxableAmt

number

Tax2 Taxable Amount

Max length18

InvSman3CommPc

number

Not Used

Max length6

InvApprovedDate

string

Approve Date

InvTax2Amt

number

Tax 2 Amount

Max length18

InvRlsAmt

number

InvCRlsAmt

number

C Rls Amount

InvPlantCode

string

This column is no longer used.

Max length5

InvCatCode

string

Max length20

InvOrdNum

string

Order Nuimber

Max length16

InvArAmt

number

Max length18

InvTax3Code

string

Tax 3 Code

Max length11

InvTranCode

string

Tran Code

Max length1

InvOriginalDesc1UpdDate

string

The date the original (very first) invoice description was first updated.

InvCreditHldbkAmt

number

Max length18

InvAcctDescription

string

Max length500

InvCompCode

string

Company Code

Max length8

InvSman3CommAmt

number

Not Used

Max length18

InvHldbkAmt

number

Retainage Amount

Max length18

InvSerCode

string

Invoice Series Code

Max length4

InvArLessHldbkAmt

number

AR Less Holdback Amount

InvHldbkPcUpd

number

Hldbk Pc Update

Max length18

InvPaidAmt

number

Paid Amount

Max length18

InvTermCode

string

Invoice Terms Code

Max length6

InvSman1Code

string

Not Used

Max length4

InvSdiscAmt

number

Max length18

InvAmt

number

Invoice Amount

Max length18

InvFrtAmt

number

Freight Amount

Max length18

InvDate

string

Invoice Date

💻 UI Fieldname: *Invoice Date

InvObjectOraseq

number

Oraseq Num for Notes Attachment by da.dbk_sys_info.oraseq

InvDiscAmtUpd

number

Disc Amount Update

Max length18

InvCustCode

string

Customer Code

💻 UI Fieldname: *Customer

Max length8

InvDiscDateUpd

string

Discount Date Update

InvOriginalDueDate

string

The original (very first) invoice due date that was updated.

InvTax1Code

string

Tax 1 Code

Max length11

InvSdiscPercent

number

Max length7

InvSeparateBillingRefCode

string

Job Separate Billing Reference Code

Max length60

InvDrawNum

number

Progress Billing AIA Draw Number

Max length6

InvOrigHldbkAmt

number

Original Retainage Amount

Max length18

InvDueDays

number

Due Days

InvSourceCode

string

Max length1

InvSman3Code

string

Not Used

Max length4

Responses

201

Created

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourceitem+json

example-0

Successful Response

{
  "InvAcctDescription": null,
  "InvAddTypeCode": null,
  "InvAllowAmt": null,
  "InvAmt": 0,
  "InvApprovedDate": null,
  "InvArAmt": null,
  "InvArLessHldbkAmt": null,
  "InvAverageDaysToPay": null,
  "InvBchNum": 4461233,
  "InvBchPstFlag": null,
  "InvCRlsAmt": null,
  "InvCRlsTaxAmt": null,
  "InvCashAccCode": null,
  "InvCatCode": null,
  "InvChargeCode": "NA",
  "InvCollCode": "ACCT",
  "InvCompCode": "001",
  "InvContCode": null,
  "InvCostCode": null,
  "InvCreditAmt": null,
  "InvCreditHldbkAmt": null,
  "InvCreditTax1HldbkAmt": null,
  "InvCurFactorNum": null,
  "InvCurrCode": "USD",
  "InvCustCode": "1020",
  "InvDate": "2016-09-01",
  "InvDelinqCode": null,
  "InvDeptCode": null,
  "InvDesc1": null,
  "InvDesc2": null,
  "InvDetTaxAmt": null,
  "InvDetailsExistFlag": null,
  "InvDiscAmt": null,
  "InvDiscAmtUpd": null,
  "InvDiscDate": "2016-09-02",
  "InvDiscDateUpd": null,
  "InvDiscDays": null,
  "InvDiscTakenAmt": null,
  "InvDisputedFlag": null,
  "InvDistributionExistFlag": null,
  "InvDrawNum": null,
  "InvDueDate": "2016-10-01",
  "InvDueDateUpd": null,
  "InvDueDays": null,
  "InvFinAmt": null,
  "InvFrtAmt": null,
  "InvFrtDiscCode": null,
  "InvHldbkAmt": null,
  "InvHldbkAmtUpd": null,
  "InvHldbkPaidAmt": null,
  "InvHldbkPc": null,
  "InvHldbkPcUpd": null,
  "InvImageFilename": null,
  "InvInsAmt": null,
  "InvInsDiscCode": null,
  "InvInvoiceNewFlag": null,
  "InvIuCreateDate": null,
  "InvIuCreateUser": null,
  "InvIuUpdateDate": null,
  "InvIuUpdateUser": null,
  "InvJobCode": null,
  "InvLastPayAmt": null,
  "InvMiscAmt": null,
  "InvMiscDiscCode": null,
  "InvNetAmt": null,
  "InvNetAmtUpd": null,
  "InvNodiscAmt": null,
  "InvNum": "06201.0110",
  "InvObjectOraseq": 833688184,
  "InvOePrtCode": null,
  "InvOrdNum": null,
  "InvOrigHldbkAmt": null,
  "InvOrigTax1HldbkAmt": null,
  "InvOriginalDesc1": null,
  "InvOriginalDesc1UpdDate": null,
  "InvOriginalDesc1UpdUser": null,
  "InvOriginalDueDate": null,
  "InvOriginalDueDateUpdDate": null,
  "InvOriginalDueDateUpdUser": null,
  "InvOtherTaxes": null,
  "InvOutstandAmt": null,
  "InvPaidAmt": null,
  "InvPlantCode": null,
  "InvPostDate": null,
  "InvReasonDueDateChange": null,
  "InvRevBchNum": null,
  "InvRevDate": null,
  "InvRlsAmt": null,
  "InvRlsAmtUpd": null,
  "InvRlsBchNum": null,
  "InvRlsDate": null,
  "InvRlsInvNum": null,
  "InvRlsTax1Amt": null,
  "InvRlsTax1AmtUpd": null,
  "InvRlsTaxAmt": null,
  "InvRlsWAmt": null,
  "InvSalesAmt": 46177.36,
  "InvSdiscAmt": null,
  "InvSdiscPercent": null,
  "InvSeparateBillingRefCode": null,
  "InvSerCode": null,
  "InvSman1Code": null,
  "InvSman1CommAmt": null,
  "InvSman1CommPc": null,
  "InvSman2Code": null,
  "InvSman2CommAmt": null,
  "InvSman2CommPc": null,
  "InvSman3Code": null,
  "InvSman3CommAmt": null,
  "InvSman3CommPc": null,
  "InvSourceCode": null,
  "InvStatusCode": null,
  "InvStmtDate": null,
  "InvTax1Amt": null,
  "InvTax1Code": null,
  "InvTax1HldbkAmt": null,
  "InvTax1HldbkAmtUpd": null,
  "InvTax1Name": null,
  "InvTax1TaxableAmt": null,
  "InvTax1TaxableFlag": null,
  "InvTax2Amt": null,
  "InvTax2Code": null,
  "InvTax2Name": null,
  "InvTax2TaxableAmt": null,
  "InvTax2TaxableFlag": null,
  "InvTax3Amt": null,
  "InvTax3Code": null,
  "InvTax3Name": null,
  "InvTax3TaxableAmt": null,
  "InvTax3TaxableFlag": null,
  "InvTaxDiscCode": null,
  "InvTaxes": null,
  "InvTermCode": "NET30",
  "InvTermPc": null,
  "InvTermPcUpd": null,
  "InvTotalRlsTaxAmt": null,
  "InvTranCode": null,
  "InvVUuid": "F22B8A96715329CCE05316821FACB966",
  "InvWoAmt": null,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoice/F22B8A96715329CCE05316821FACB966",
      "name": "arinvoice",
      "kind": "item"
    },
    {
      "rel": "canonical",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoice/F22B8A96715329CCE05316821FACB966",
      "name": "arinvoice",
      "kind": "item"
    }
  ]
}

example-1

Successful Response

{
  "InvAcctDescription": null,
  "InvAddTypeCode": null,
  "InvAllowAmt": null,
  "InvAmt": 0,
  "InvApprovedDate": null,
  "InvArAmt": null,
  "InvArLessHldbkAmt": null,
  "InvAverageDaysToPay": null,
  "InvBchNum": 4461233,
  "InvBchPstFlag": null,
  "InvCRlsAmt": null,
  "InvCRlsTaxAmt": null,
  "InvCashAccCode": null,
  "InvCatCode": null,
  "InvChargeCode": "NA",
  "InvCollCode": "ACCT",
  "InvCompCode": "001",
  "InvContCode": null,
  "InvCostCode": null,
  "InvCreditAmt": null,
  "InvCreditHldbkAmt": null,
  "InvCreditTax1HldbkAmt": null,
  "InvCurFactorNum": null,
  "InvCurrCode": "USD",
  "InvCustCode": "1020",
  "InvDate": "2016-09-01",
  "InvDelinqCode": null,
  "InvDeptCode": null,
  "InvDesc1": null,
  "InvDesc2": null,
  "InvDetTaxAmt": null,
  "InvDetailsExistFlag": null,
  "InvDiscAmt": null,
  "InvDiscAmtUpd": null,
  "InvDiscDate": "2016-09-02",
  "InvDiscDateUpd": null,
  "InvDiscDays": null,
  "InvDiscTakenAmt": null,
  "InvDisputedFlag": null,
  "InvDistributionExistFlag": null,
  "InvDrawNum": null,
  "InvDueDate": "2016-10-01",
  "InvDueDateUpd": null,
  "InvDueDays": null,
  "InvFinAmt": null,
  "InvFrtAmt": null,
  "InvFrtDiscCode": null,
  "InvHldbkAmt": null,
  "InvHldbkAmtUpd": null,
  "InvHldbkPaidAmt": null,
  "InvHldbkPc": null,
  "InvHldbkPcUpd": null,
  "InvImageFilename": null,
  "InvInsAmt": null,
  "InvInsDiscCode": null,
  "InvInvoiceNewFlag": null,
  "InvIuCreateDate": null,
  "InvIuCreateUser": null,
  "InvIuUpdateDate": null,
  "InvIuUpdateUser": null,
  "InvJobCode": null,
  "InvLastPayAmt": null,
  "InvMiscAmt": null,
  "InvMiscDiscCode": null,
  "InvNetAmt": null,
  "InvNetAmtUpd": null,
  "InvNodiscAmt": null,
  "InvNum": "06201.0110",
  "InvObjectOraseq": 833688184,
  "InvOePrtCode": null,
  "InvOrdNum": null,
  "InvOrigHldbkAmt": null,
  "InvOrigTax1HldbkAmt": null,
  "InvOriginalDesc1": null,
  "InvOriginalDesc1UpdDate": null,
  "InvOriginalDesc1UpdUser": null,
  "InvOriginalDueDate": null,
  "InvOriginalDueDateUpdDate": null,
  "InvOriginalDueDateUpdUser": null,
  "InvOtherTaxes": null,
  "InvOutstandAmt": null,
  "InvPaidAmt": null,
  "InvPlantCode": null,
  "InvPostDate": null,
  "InvReasonDueDateChange": null,
  "InvRevBchNum": null,
  "InvRevDate": null,
  "InvRlsAmt": null,
  "InvRlsAmtUpd": null,
  "InvRlsBchNum": null,
  "InvRlsDate": null,
  "InvRlsInvNum": null,
  "InvRlsTax1Amt": null,
  "InvRlsTax1AmtUpd": null,
  "InvRlsTaxAmt": null,
  "InvRlsWAmt": null,
  "InvSalesAmt": 46177.36,
  "InvSdiscAmt": null,
  "InvSdiscPercent": null,
  "InvSeparateBillingRefCode": null,
  "InvSerCode": null,
  "InvSman1Code": null,
  "InvSman1CommAmt": null,
  "InvSman1CommPc": null,
  "InvSman2Code": null,
  "InvSman2CommAmt": null,
  "InvSman2CommPc": null,
  "InvSman3Code": null,
  "InvSman3CommAmt": null,
  "InvSman3CommPc": null,
  "InvSourceCode": null,
  "InvStatusCode": null,
  "InvStmtDate": null,
  "InvTax1Amt": null,
  "InvTax1Code": null,
  "InvTax1HldbkAmt": null,
  "InvTax1HldbkAmtUpd": null,
  "InvTax1Name": null,
  "InvTax1TaxableAmt": null,
  "InvTax1TaxableFlag": null,
  "InvTax2Amt": null,
  "InvTax2Code": null,
  "InvTax2Name": null,
  "InvTax2TaxableAmt": null,
  "InvTax2TaxableFlag": null,
  "InvTax3Amt": null,
  "InvTax3Code": null,
  "InvTax3Name": null,
  "InvTax3TaxableAmt": null,
  "InvTax3TaxableFlag": null,
  "InvTaxDiscCode": null,
  "InvTaxes": null,
  "InvTermCode": "NET30",
  "InvTermPc": null,
  "InvTermPcUpd": null,
  "InvTotalRlsTaxAmt": null,
  "InvTranCode": null,
  "InvVUuid": "F22B8A96715329CCE05316821FACB966",
  "InvWoAmt": null,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoice/F22B8A96715329CCE05316821FACB966",
      "name": "arinvoice",
      "kind": "item"
    },
    {
      "rel": "canonical",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ar-rest-api/rest/1/arinvoice/F22B8A96715329CCE05316821FACB966",
      "name": "arinvoice",
      "kind": "item"
    }
  ]
}

object

What's Next

Retrieve Specific AR Invoice by Code

Create multiple AR Invoices

Create Multiple Invoices

What's Next

Contact Us