Create an invoice data
post
/fscmRestApi/resources/11.13.18.05/publicSectorInvoices
Create an invoice data
Request
Supported Media Types
- application/vnd.oracle.adf.resourceitem+json
- application/json
The following table describes the body parameters in the request for this task.
Root Schema : publicSectorInvoices-item
Type:
Show Source
object-
AccountingDate(optional):
string(date)
The accounting date.
-
Address1(optional):
string
Maximum Length:
240The first line of the applicant or customer address. -
Address2(optional):
string
Maximum Length:
240The second line of the applicant or customer address. -
Address3(optional):
string
Maximum Length:
240The third line of the applicant or customer address. -
Address4(optional):
string
Maximum Length:
240The fourth line of the applicant or customer address. -
AgencyId(optional):
integer(int64)
Unique identifier of the agency associated with the row.
-
BalanceAmount(optional):
number
Balance amount to be paid.
-
BankAccountKey(optional):
string
Maximum Length:
30The remit to bank account type. -
BankCode(optional):
string
Maximum Length:
30The remit to bank code for the organization. -
Billable(optional):
string
Maximum Length:
1Indicates whether an invoice is billable. The default value is Yes. -
BillLine(optional):
array Bill Lines
Title:
Bill LinesThe bill lines resource is used to view, create or update invoice lines. -
BillStatus(optional):
string
Maximum Length:
30The current status of the bill. -
BillToContactId(optional):
integer(int64)
Bill to customer site use identifier on an invoice in Fusion Receivables.
-
BillToCustomerId(optional):
integer(int64)
Bill to customer identifier on an invoice in Fusion Receivables.
-
BillToMedia(optional):
string
Maximum Length:
20Indicates the media used for billing such as print or email. -
BillToSiteUseId(optional):
integer(int64)
Bill to site use identifier on an invoice in Fusion Receivables.
-
BillType(optional):
string
Maximum Length:
15Determines the default invoice values for invoice form and invoice number ID. Passed from the source application. -
BusBusinessName(optional):
string
Maximum Length:
100Business entity name. -
BusDbaBusinessName(optional):
string
Maximum Length:
100The doing business as name of the business entity. -
BusinessEntityId(optional):
string
Maximum Length:
50Unique identifier for the business entity. -
BusinessEntityPartyId(optional):
integer(int64)
Unique identifier for the business party.
-
BusinessLocationPartyId(optional):
integer(int64)
Unique identifier for the business location party ID.
-
BusinessProfileId(optional):
integer(int64)
Unique identifier for the business profile.
-
City(optional):
string
Maximum Length:
60City of the applicant or customer address. -
Country(optional):
string
Maximum Length:
3Country for the applicant or customer address. -
County(optional):
string
Maximum Length:
60County for the applicant or customer address. -
CurrencyCode(optional):
string
Maximum Length:
3Indicates the currency used for the transaction. Passed from the source application. -
CustomerTrxId(optional):
integer(int64)
Transaction identifier on an invoice in Fusion Receivables.
-
CustTrxTypeId(optional):
integer(int64)
Transaction type identifier on an invoice in Fusion Receivables.
-
Description(optional):
string
Maximum Length:
50Description of the invoice. -
DueDate(optional):
string(date)
The date on which the payment is due.
-
EmailAddress(optional):
string
Maximum Length:
320The applicant or customer email address. -
FirstName(optional):
string
Maximum Length:
150The applicant or customer first name. -
Invoice(optional):
string
Maximum Length:
50Unique invoice value generated using Auto Number Rule configured for the bill type for this transaction. RULE_ID is derived from the BNP_BILL_TYPE table. -
InvoiceAmount(optional):
number
The sum of all invoice line amounts.
-
InvoiceDate(optional):
string(date)
The invoice date.
-
InvoiceFormId(optional):
string
Maximum Length:
20Unique identifier for the invoice form layout to print. Derived from BNP_BILL_TYPE. -
InvoiceStatus(optional):
string
Maximum Length:
30The current status of the invoice system. -
InvoiceSystem(optional):
string
Maximum Length:
30The invoice system to which the bill has been sent. -
InvoiceType(optional):
string
Maximum Length:
30The type of invoice. -
LastName(optional):
string
Maximum Length:
150The applicant or customer last name. -
LatestInvoice(optional):
string
Maximum Length:
50Most recent invoice adjusted in the chain of adjustments. -
links(optional):
array Items
Title:
ItemsLink Relations -
LocationId(optional):
integer(int64)
Unique identifier for the party address information. Derived from PBL_PARTY_LOCATION_USE using PARTY_ID.
-
MiddleName(optional):
string
Maximum Length:
60The applicant or customer middle name. -
NameSuffix(optional):
string
Maximum Length:
30The applicant or customer name suffix. -
NextAdjustmentInvoice(optional):
string
Maximum Length:
50Invoice adjusted subsequently in the chain of adjustments. -
OrgId(optional):
integer(int64)
The unique identifier of the business unit associated with an invoice in Fusion Receivables.
-
OriginalInvoice(optional):
string
Maximum Length:
50Original invoice number. -
OwnerAddress1(optional):
string
Maximum Length:
240First line of the owner address. -
OwnerAddress2(optional):
string
Maximum Length:
240Second line of the owner address. -
OwnerAddress3(optional):
string
Maximum Length:
240Third line of the owner address. -
OwnerAddress4(optional):
string
Maximum Length:
240Fourth line of the owner address. -
OwnerCity(optional):
string
Maximum Length:
60City associated with the owner address. -
OwnerCountry(optional):
string
Maximum Length:
3Country associated with the owner address. -
OwnerCounty(optional):
string
Maximum Length:
60County associated with the owner address. -
OwnerPostalCode(optional):
string
Maximum Length:
60Postal code associated with the owner address. -
OwnerPostalPlusFourCode(optional):
string
Maximum Length:
10Postal plus-four code associated with the owner address. -
OwnerProvince(optional):
string
Maximum Length:
60Province associated with the owner address. -
OwnerState(optional):
string
Maximum Length:
60State associated with the owner address. -
PartyId(optional):
integer(int64)
Attribute used to derive party information for a person, group or organization. Passed from the source application.
-
PaymentStatus(optional):
string
Maximum Length:
30The payment status of the bill. -
PersonName(optional):
string
Maximum Length:
450The applicant or customer name. -
PostalCode(optional):
string
Maximum Length:
20Postal code for applicant or customer address. -
PostalPlus4Code(optional):
string
Maximum Length:
10The Postal plus4 code for applicant or customer address. -
PreferredContactMethod(optional):
string
Maximum Length:
30The method by which a person prefers to be contacted. Passed from the source application. -
PreferredContactPersonId(optional):
integer(int64)
Unique identifier of the preferred contact for a given party. Used to derive PARTY_ID from table PBL_PARTY_CONTACT_POINTS in order to derive contact name from PBL_PERSON_PROFILE table. Passed from source application.
-
PriorAdjustmentInvoice(optional):
string
Maximum Length:
50Invoice adjusted previously in the chain of adjustments. -
ProfileId(optional):
integer(int64)
Attribute used to derive cashier id information if payment is made through a cashier.
-
Province(optional):
string
Maximum Length:
60Region code for the applicant or customer address in non-US countries. -
SourceTransactionKey(optional):
integer(int64)
Unique identifier of the source transaction. Passed from the source application.
-
State(optional):
string
Maximum Length:
60The state for applicant or customer address. -
TermId(optional):
integer(int64)
The payment terms applicable to a fee item that assessed and due.
-
TransactionOrigin(optional):
string
Maximum Length:
30Indicates where a transaction originated. Passed from the source application.
Nested Schema : Bill Lines
Type:
arrayTitle:
Bill LinesThe bill lines resource is used to view, create or update invoice lines.
Show Source
Nested Schema : publicSectorInvoices-BillLine-item
Type:
Show Source
object-
AgencyId(optional):
integer(int64)
Unique identifier of the agency associated with the row.
-
BillType(optional):
string
Maximum Length:
15Determines default invoice values, such as invoice form and invoice number ID. Passed from the source application. -
Classification(optional):
string
Maximum Length:
3The classification passed from the source application. -
CurrencyCode(optional):
string
Maximum Length:
3Indicates the currency used for the transaction. Passed from the source application. -
CustomerTrxLineId(optional):
integer(int64)
Transaction line identifier on an invoice line in Fusion Receivables.
-
DepartmentId(optional):
string
Maximum Length:
30Unique identifier of the department. -
Description(optional):
string
Maximum Length:
100Description of the fee passed from the source application or of the fee (service charge) passed from the payment application. -
DiscountAmount(optional):
number
The discount to the amount paid. Passed from the source application.
-
ExpirationDate(optional):
string(date-time)
The expiration date of the license.
-
FeeItemId(optional):
string
Maximum Length:
30Unique identifier for the fee item. -
Invoice(optional):
string
Maximum Length:
50The invoice number for the associated bill header. -
InvoiceLine(optional):
integer(int64)
The invoice line number.
-
InvoiceLineAmount(optional):
number
Amount that represents the quantity times the price, plus any discounts, minus any surcharges.
-
IssueDate(optional):
string(date-time)
Invoice issue date.
-
LatestInvoice(optional):
string
Maximum Length:
50Most recent Invoice adjusted in the chain of adjustments. -
LatestLine(optional):
integer(int64)
Most recent Invoice line adjusted in the chain of adjustments.
-
links(optional):
array Items
Title:
ItemsLink Relations -
MemoLineId(optional):
integer(int64)
Memo line identifier on an invoice line in Fusion Receivables.
-
NextAdjustmentInvoice(optional):
string
Maximum Length:
50Invoice adjusted next in the chain of adjustments. -
NextAdjustmentLine(optional):
integer(int64)
Invoice line adjusted next in the chain of adjustments.
-
OriginalInvoice(optional):
string
Maximum Length:
50Original invoice number. -
OriginalLine(optional):
integer(int64)
Original invoice line.
-
Price(optional):
number
The fee amount or unit price.
-
PriorAdjustmentInvoice(optional):
string
Maximum Length:
50Invoice adjusted prior in the chain of adjustments. -
PriorAdjustmentLine(optional):
integer(int64)
Invoice line adjusted prior in the chain of adjustments.
-
Quantity(optional):
integer(int64)
The unit quantity.
-
RecordId(optional):
string
Maximum Length:
50Unique identifier for the record. -
RecordType(optional):
string
Maximum Length:
30The type of record passed from the source application. -
RenewalDate(optional):
string(date-time)
The renewal date of the license.
-
SurchargeAmount(optional):
number
The surcharge on the amount paid. Passed from the source application.
Nested Schema : link
Type:
Show Source
object-
href(optional):
string
Title:
hyperlink referenceThe URI to the related resource. -
rel(optional):
string
Title:
relationThe name of the relation to the resource instance. Example: self.
Response
Supported Media Types
- application/vnd.oracle.adf.resourceitem+json
- application/json
Default Response
The following table describes the default response for this task.
Root Schema : publicSectorInvoices-item
Type:
Show Source
object-
AccountingDate(optional):
string(date)
The accounting date.
-
Address1(optional):
string
Maximum Length:
240The first line of the applicant or customer address. -
Address2(optional):
string
Maximum Length:
240The second line of the applicant or customer address. -
Address3(optional):
string
Maximum Length:
240The third line of the applicant or customer address. -
Address4(optional):
string
Maximum Length:
240The fourth line of the applicant or customer address. -
AgencyId(optional):
integer(int64)
Unique identifier of the agency associated with the row.
-
BalanceAmount(optional):
number
Balance amount to be paid.
-
BankAccountKey(optional):
string
Maximum Length:
30The remit to bank account type. -
BankCode(optional):
string
Maximum Length:
30The remit to bank code for the organization. -
Billable(optional):
string
Maximum Length:
1Indicates whether an invoice is billable. The default value is Yes. -
BillLine(optional):
array Bill Lines
Title:
Bill LinesThe bill lines resource is used to view, create or update invoice lines. -
BillStatus(optional):
string
Maximum Length:
30The current status of the bill. -
BillToContactId(optional):
integer(int64)
Bill to customer site use identifier on an invoice in Fusion Receivables.
-
BillToCustomerId(optional):
integer(int64)
Bill to customer identifier on an invoice in Fusion Receivables.
-
BillToMedia(optional):
string
Maximum Length:
20Indicates the media used for billing such as print or email. -
BillToSiteUseId(optional):
integer(int64)
Bill to site use identifier on an invoice in Fusion Receivables.
-
BillType(optional):
string
Maximum Length:
15Determines the default invoice values for invoice form and invoice number ID. Passed from the source application. -
BusBusinessName(optional):
string
Maximum Length:
100Business entity name. -
BusDbaBusinessName(optional):
string
Maximum Length:
100The doing business as name of the business entity. -
BusinessEntityId(optional):
string
Maximum Length:
50Unique identifier for the business entity. -
BusinessEntityPartyId(optional):
integer(int64)
Unique identifier for the business party.
-
BusinessLocationPartyId(optional):
integer(int64)
Unique identifier for the business location party ID.
-
BusinessProfileId(optional):
integer(int64)
Unique identifier for the business profile.
-
City(optional):
string
Maximum Length:
60City of the applicant or customer address. -
Country(optional):
string
Maximum Length:
3Country for the applicant or customer address. -
County(optional):
string
Maximum Length:
60County for the applicant or customer address. -
CurrencyCode(optional):
string
Maximum Length:
3Indicates the currency used for the transaction. Passed from the source application. -
CustomerTrxId(optional):
integer(int64)
Transaction identifier on an invoice in Fusion Receivables.
-
CustTrxTypeId(optional):
integer(int64)
Transaction type identifier on an invoice in Fusion Receivables.
-
Description(optional):
string
Maximum Length:
50Description of the invoice. -
DueDate(optional):
string(date)
The date on which the payment is due.
-
EmailAddress(optional):
string
Maximum Length:
320The applicant or customer email address. -
FirstName(optional):
string
Maximum Length:
150The applicant or customer first name. -
Invoice(optional):
string
Maximum Length:
50Unique invoice value generated using Auto Number Rule configured for the bill type for this transaction. RULE_ID is derived from the BNP_BILL_TYPE table. -
InvoiceAmount(optional):
number
The sum of all invoice line amounts.
-
InvoiceDate(optional):
string(date)
The invoice date.
-
InvoiceFormId(optional):
string
Maximum Length:
20Unique identifier for the invoice form layout to print. Derived from BNP_BILL_TYPE. -
InvoiceStatus(optional):
string
Maximum Length:
30The current status of the invoice system. -
InvoiceSystem(optional):
string
Maximum Length:
30The invoice system to which the bill has been sent. -
InvoiceType(optional):
string
Maximum Length:
30The type of invoice. -
LastName(optional):
string
Maximum Length:
150The applicant or customer last name. -
LatestInvoice(optional):
string
Maximum Length:
50Most recent invoice adjusted in the chain of adjustments. -
links(optional):
array Items
Title:
ItemsLink Relations -
LocationId(optional):
integer(int64)
Unique identifier for the party address information. Derived from PBL_PARTY_LOCATION_USE using PARTY_ID.
-
MiddleName(optional):
string
Maximum Length:
60The applicant or customer middle name. -
NameSuffix(optional):
string
Maximum Length:
30The applicant or customer name suffix. -
NextAdjustmentInvoice(optional):
string
Maximum Length:
50Invoice adjusted subsequently in the chain of adjustments. -
OrgId(optional):
integer(int64)
The unique identifier of the business unit associated with an invoice in Fusion Receivables.
-
OriginalInvoice(optional):
string
Maximum Length:
50Original invoice number. -
OwnerAddress1(optional):
string
Maximum Length:
240First line of the owner address. -
OwnerAddress2(optional):
string
Maximum Length:
240Second line of the owner address. -
OwnerAddress3(optional):
string
Maximum Length:
240Third line of the owner address. -
OwnerAddress4(optional):
string
Maximum Length:
240Fourth line of the owner address. -
OwnerCity(optional):
string
Maximum Length:
60City associated with the owner address. -
OwnerCountry(optional):
string
Maximum Length:
3Country associated with the owner address. -
OwnerCounty(optional):
string
Maximum Length:
60County associated with the owner address. -
OwnerPostalCode(optional):
string
Maximum Length:
60Postal code associated with the owner address. -
OwnerPostalPlusFourCode(optional):
string
Maximum Length:
10Postal plus-four code associated with the owner address. -
OwnerProvince(optional):
string
Maximum Length:
60Province associated with the owner address. -
OwnerState(optional):
string
Maximum Length:
60State associated with the owner address. -
PartyId(optional):
integer(int64)
Attribute used to derive party information for a person, group or organization. Passed from the source application.
-
PaymentStatus(optional):
string
Maximum Length:
30The payment status of the bill. -
PersonName(optional):
string
Maximum Length:
450The applicant or customer name. -
PostalCode(optional):
string
Maximum Length:
20Postal code for applicant or customer address. -
PostalPlus4Code(optional):
string
Maximum Length:
10The Postal plus4 code for applicant or customer address. -
PreferredContactMethod(optional):
string
Maximum Length:
30The method by which a person prefers to be contacted. Passed from the source application. -
PreferredContactPersonId(optional):
integer(int64)
Unique identifier of the preferred contact for a given party. Used to derive PARTY_ID from table PBL_PARTY_CONTACT_POINTS in order to derive contact name from PBL_PERSON_PROFILE table. Passed from source application.
-
PriorAdjustmentInvoice(optional):
string
Maximum Length:
50Invoice adjusted previously in the chain of adjustments. -
ProfileId(optional):
integer(int64)
Attribute used to derive cashier id information if payment is made through a cashier.
-
Province(optional):
string
Maximum Length:
60Region code for the applicant or customer address in non-US countries. -
SourceTransactionKey(optional):
integer(int64)
Unique identifier of the source transaction. Passed from the source application.
-
State(optional):
string
Maximum Length:
60The state for applicant or customer address. -
TermId(optional):
integer(int64)
The payment terms applicable to a fee item that assessed and due.
-
TransactionOrigin(optional):
string
Maximum Length:
30Indicates where a transaction originated. Passed from the source application.
Nested Schema : Bill Lines
Type:
arrayTitle:
Bill LinesThe bill lines resource is used to view, create or update invoice lines.
Show Source
Nested Schema : publicSectorInvoices-BillLine-item
Type:
Show Source
object-
AgencyId(optional):
integer(int64)
Unique identifier of the agency associated with the row.
-
BillType(optional):
string
Maximum Length:
15Determines default invoice values, such as invoice form and invoice number ID. Passed from the source application. -
Classification(optional):
string
Maximum Length:
3The classification passed from the source application. -
CurrencyCode(optional):
string
Maximum Length:
3Indicates the currency used for the transaction. Passed from the source application. -
CustomerTrxLineId(optional):
integer(int64)
Transaction line identifier on an invoice line in Fusion Receivables.
-
DepartmentId(optional):
string
Maximum Length:
30Unique identifier of the department. -
Description(optional):
string
Maximum Length:
100Description of the fee passed from the source application or of the fee (service charge) passed from the payment application. -
DiscountAmount(optional):
number
The discount to the amount paid. Passed from the source application.
-
ExpirationDate(optional):
string(date-time)
The expiration date of the license.
-
FeeItemId(optional):
string
Maximum Length:
30Unique identifier for the fee item. -
Invoice(optional):
string
Maximum Length:
50The invoice number for the associated bill header. -
InvoiceLine(optional):
integer(int64)
The invoice line number.
-
InvoiceLineAmount(optional):
number
Amount that represents the quantity times the price, plus any discounts, minus any surcharges.
-
IssueDate(optional):
string(date-time)
Invoice issue date.
-
LatestInvoice(optional):
string
Maximum Length:
50Most recent Invoice adjusted in the chain of adjustments. -
LatestLine(optional):
integer(int64)
Most recent Invoice line adjusted in the chain of adjustments.
-
links(optional):
array Items
Title:
ItemsLink Relations -
MemoLineId(optional):
integer(int64)
Memo line identifier on an invoice line in Fusion Receivables.
-
NextAdjustmentInvoice(optional):
string
Maximum Length:
50Invoice adjusted next in the chain of adjustments. -
NextAdjustmentLine(optional):
integer(int64)
Invoice line adjusted next in the chain of adjustments.
-
OriginalInvoice(optional):
string
Maximum Length:
50Original invoice number. -
OriginalLine(optional):
integer(int64)
Original invoice line.
-
Price(optional):
number
The fee amount or unit price.
-
PriorAdjustmentInvoice(optional):
string
Maximum Length:
50Invoice adjusted prior in the chain of adjustments. -
PriorAdjustmentLine(optional):
integer(int64)
Invoice line adjusted prior in the chain of adjustments.
-
Quantity(optional):
integer(int64)
The unit quantity.
-
RecordId(optional):
string
Maximum Length:
50Unique identifier for the record. -
RecordType(optional):
string
Maximum Length:
30The type of record passed from the source application. -
RenewalDate(optional):
string(date-time)
The renewal date of the license.
-
SurchargeAmount(optional):
number
The surcharge on the amount paid. Passed from the source application.
Nested Schema : link
Type:
Show Source
object-
href(optional):
string
Title:
hyperlink referenceThe URI to the related resource. -
rel(optional):
string
Title:
relationThe name of the relation to the resource instance. Example: self.