Contract Bill Plans

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/contractService/}BillPlan

Logical Business Objects

  • Projects

  • 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

Non-labor Rate Override Deprecated

Contains

Contract Assigned Billing Extension Deprecated

Contains

Contract Bill Plan Translation Deprecated

Contains

Contract Job Assignment Override

Contains

Job Title Override

Contains

Labor Multiplier Override

Contains

Contract Job Rate Override

Contains

Person Rate Override

Contains

Contract Bill Plan Descriptive Flexfields

Contained by

Contract Deprecated

Handled by

Contract Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

AssignmentDetail

Contract Assigned Billing Extension Deprecated

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.

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 Deprecated

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

BillSetNum

decimal

Indicates which bill plans for the same contract can be invoiced together. Transactions for bill plans with a common bill set number will be invoiced on the same invoice.

BillToContactId

long

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

BillToCustAcctId

long

Unique identifier of the bill-to customer account that receives the invoice and pays the invoice amount.

BillToSiteUseId

long

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

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.

DocNumber

string

A unique identifier of the letter of credit document issued to the award on the bill plan.

EmpBillRateSchId

long

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

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.

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.

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.

InvoiceCurrDateType

string

The source of the bill transaction to invoice and revenue currency conversion date for a bill plan, such as transaction date or fixed date.

InvoiceCurrExchgDate

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

The date on a bill plan from which a conversion rate is used to convert the amount in the bill transaction currency into the invoice and revenue currency.

InvoiceCurrRateType

string

The source of the bill transaction to invoice and revenue currency conversion rate for a bill plan, such as user defined, spot, or corporate.

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.

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.

InvoiceInstructions

string

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

JobAssignmentOverride

Contract Job Assignment Override

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

JobBillRateSchId

long

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

JobRateOverride

Contract Job Rate Override

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

JobTitleOverride

Job Title Override

Name of the object that stores all the job title overrides for a bill plan or revenue plan.

LaborBillBasisCode

string

Labor cost basis code 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.

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

Section that displays the labor multiplier overrides for a bill plan.

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

Nonlabor cost basis code for cost reimbursable.

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

The fixed date used to determine the effective bill rates of the standard non labor bill rate schedule

NlTpSchFixedDate

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

User-specified date used to derive the bill rate from the nonlabor rate 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 Deprecated

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

OnHoldFlag

boolean

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

PaymentTermId

long

Terms used to schedule payments and to calculate due dates, discount dates, and discount amounts for each invoice.

PersonRateOverride

Person Rate Override Deprecated

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

ReportTypeCode

string

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