Contract Bill Plan

The set of instructions, assigned to one or many contract lines, on how to invoice the project contract customer.

QName: {http://xmlns.oracle.com/apps/projects/billing/contracts/contractPublicService/}BillPlan

Logical Business Objects

  • Projects : Project Billing

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Job Assignment Override SDO

Contains

Job Title Override SDO

Contains

Contract Assigned Billing Extension

Contains

Labor Multiplier Override SDO

Contains

Contract Bill Plan Translations

Contains

Non-labor Rate Override

Contains

Person Rate Override

Contains

Job Rate Override

Contains

Contract Bill Plan Descriptive Flexfields

Contained by

Contract

Handled by

Contract Service Version 2

Attributes

The following table describes attributes in the service data object.

Name Type Description

AssignmentDetail

Contract Assigned Billing Extension

Section that displays the billing extensions assigned to the bill plan.

BillMethodId

long

Unique identifier of the invoice method used to invoice against this bill plan.

BillMethodName

string

The name of the bill method.

BillPlanDescriptiveFlexField

Contract Bill Plan Descriptive Flexfields

A set of configurable fields that captures customer specific business process information on the contract bill plan.

BillPlanId

long

Unique identifier of the contract bill plan.
  • Primary Key

BillPlanName

string

Name of the bill plan that contains details on how contract lines are to be invoiced.

BillPlanTranslation

Contract Bill Plan Translation

A complete set of language translations for the multilingual attributes of a bill plan and revenue plan.

BillSetNumber

decimal

The billing set number used to group invoices.

BillToAccountNumber

string

The customer to whom invoices are sent to and is responsible for the payment.

BillToContactEmail

string

The email of the contact person from the bill-to customer site.

BillToContactId

long

Unique identifier of the bill-to customer contact person on a bill plan.

BillToContactName

string

The contact person of the bill-to customer.

BillToCustomerAccountId

long

The unique identifier of the account of the bill-to customer.

BillToSite

string

The customer site where the invoices are sent.

BillToSiteUseId

long

Unique identifier of the bill-to customer site that is responsible for receiving and paying the invoice amount.

BillingCurrencyType

string

The currency option of the bill plan.

BillingCycle

string

The billing cycle of the contract bill plan.

BillingCycleId

long

Unique identifier of the frequency at which invoices are created for the bill plan.

BurdenSchFixedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

User-specified date used to derive the bill rate from the burden schedule.

BurdenSchId

long

Unique identifier of the burden schedule specified in the bill plan.

BurdenSchedule

string

The burden schedule on the revenue plan.

DocumentNumber

string

The document number on the bill plan for the letter of credit.

EnableLbrBillXtnsnFlag

boolean

Indicator to allow usage of the labor billing extension when deriving the bill rate for labor transactions.

EnableNlBillXtnsnFlag

boolean

Indicator to allow usage of the nonlabor billing extension when deriving the bill rate for nonlabor transactions.

EventInvoiceFormat

string

Events invoice identifier which summarizes invoice distributions into invoice lines. This option is applicable for events transactions.

EventsInvoiceFormatId

long

Unique identifier of the invoice format that is used to group events invoiced against the bill plan into invoice lines.

ExternalReferenceKey

string

Unique identifier of the bill plan in the source application. Used to identify contract bill plans created through external webservices.

ExternalSourceKey

string

Unique identifier of the source application from where the bill plan originates. Used to identify contract bill plans created through external webservices.

FederalInvoiceFormat

string

The invoice format of the GMS contract invoices.

FirstBillingOffsetDays

decimal

The number of days after the commencement of the project, that the first invoice will be generated.

InvoiceComment

string

User-specified text intended for printing on invoices created for this bill plan.

InvoiceCurrencyCode

string

The name of the currency in which the invoice is issued and revenue is recognized. It is also known as the entered currency in Oracle Fusion General Ledger for invoice and revenue accounting entries.

InvoiceCurrencyConversionDateType

string

The type of the invoice currency date.

InvoiceCurrencyConversionRateType

string

The code identifying the invoice currency rate type.

InvoiceCurrencyDateType

string

The code identifying the invoice currency date type.

InvoiceCurrencyExchgDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the invoice currency exchange was set up.

InvoiceCurrencyOptCode

string

The type of currency that is used to determine the invoice and revenue currency for invoices and revenue that are created for the contract lines associated with the bill plan. The billing currency type can be the contract currency, bill transaction currency, or any user-specified currency.

InvoiceCurrencyRateType

string

The code signifying the invoice currency rate type.

InvoiceInstructions

string

Internal billing instructions that will not appear on the customer invoice.

JobAssignmentOverride

Job Assignment Override SDO

Job assignment override linkage

JobBillRateSchId

long

Unique identifier of the job rate schedule used to derive the bill rate for labor transactions.

JobRateOverride

Job Rate Override

Section that displays the job rate overrides for a bill plan.

JobTitleOverride

Job Title Override SDO

Job title override linkage

LaborBillBasisCode

string

Nonlabor cost basis code for cost reimbursable.

LaborCostBasis

string

The labor cost basis for cost reimbursable.

LaborDiscountPercentage

decimal

The factor by which all bill rates derived from the person or job rate schedule for this bill plan are to be discounted.

LaborDiscountReasonCode

string

Explains the reason for the discount percentage offered against the person and job rate schedules specified in the bill plan.

LaborInvoiceFormat

string

The labor invoice format that summarizes the invoice distribution in the invoice lines. This option is applicable for labor transactions.

LaborInvoiceFormatId

long

Unique identifier of the invoice format that is used to group labor expenditure items invoiced against the bill plan into invoice lines.

LaborMarkupPercentage

decimal

Labor markup percentage.

LaborMultiplierOverride

Labor Multiplier Override SDO

Labor multiplier override linkage

LaborRateChangeReason

string

The reason for the change in the labor rate.

LaborSchFixedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

User-specified date used to derive the bill rate from the person or job rate schedule.

LaborTpSchFixedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

User-specified date used to derive the bill rate from the intercompany labor transfer price schedule.

LaborTpScheduleId

long

Unique identifier of the transfer price labor schedule used to derive the bill rate for intercompany labor transactions.

LocFlag

boolean

Indicates the bill plan uses letter of credit for billing.

MajorVersion

long

Version of the contract containing this particular set of bill plan details.
  • Primary Key

NlBillBasisCode

string

The nonlabor cost basis code of the reimbursable cost.

NlBillRateSchId

long

Unique identifier of the nonlabor rate schedule used to derive the bill rate for nonlabor transactions.

NlDiscountPercentage

decimal

The factor by which all bill rates derived from the nonlabor rate schedule for this bill plan are to be discounted.

NlDiscountReasonCode

string

Explains the reason for the discount percentage offered against the nonlabor rate schedule specified in the bill plan.

NlInvoiceFormatId

long

Unique identifier of the invoice format that is used to group nonlabor expenditure items invoiced against the bill plan into invoice lines.

NlMarkupPercentage

decimal

The factor by which the bill amount will be calculated over the nonlabor cost.

NlSchFixedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

User-specified date used to derive the bill rate from the nonlabor rate schedule.

NlTpSchFixedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

User-specified date used to derive the bill rate from the intercompany nonlabor transfer price schedule.

NlTpScheduleId

long

Unique identifier of the transfer price labor schedule used to derive the bill rate for intercompany nonlabor transactions.

NonLaborRateOverride

Non-labor Rate Override

Section that displays the nonlabor rate overrides for a bill plan.

NonlaborCostBasis

string

The nonlabor cost basis of the reimbursable cost.

NonlaborInvoiceFormat

string

The nonlabor invoice format that summarizes the invoice distributions in the invoice lines. This option is applicable for nonlabor transactions.

NonlaborRateChangeReason

string

The reason for change in the nonlabor rate.

OnHoldFlag

boolean

Indicator to check if bill plan is eligible for invoice generation.

PaymentTerms

string

The payment term.

PaymentTermsId

long

The unique identifier of the payment term.

PersonBillRateSchId

long

The unique identifier of the employee bill rate schedule.

PersonRateOverride

Person Rate Override

Section that displays the person rate overrides for a bill plan.

ReportTypeCode

string

Indicates the federal invoice format that is used for bill presentment.