Trading Community Customer Billing Account

The customer account or billing account associated with a trading community member.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/customerAccountService/}CustomerAccount

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

Trading Community Customer Account SDO Additional Information

Contains

Trading Community Customer Account or Site Role

Contains

Trading Community Customer Billing Account Global Descriptive Flexfield Object

Contains

Trading Community Customer Account Site

Contains

Source System Reference

Contains

Trading Community Customer Account Relationship

Handled by

Trading Community Customer Account

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccountEstablishedDate

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

The date when the customer account was originally established through either an Oracle Application or a legacy system.

AccountName

string

The description chosen by external party (but can be entered internally on behalf on the customer).

AccountNumber

string

The account number.

AccountTerminationDate

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

The date when the customer account was originally terminated through either an Oracle Application or a legacy system.

ArrivalsetsIncludeLinesFlag

boolean

Indicates if lines include arrival sets. Y for lines included on arrival sets, N for lines not automatically included in arrival sets.

AutopayFlag

boolean

Indicates Autopay.

Comments

string

The comments for the record.

CoterminateDayMonth

string

Identifies the date when services ordered by the customer will end. Values for this column will take the form DD-MON.

CreatedBy

string

The user who created the record.

CreatedByModule

string

The module that created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

CustAccountGdf

Trading Community Customer Billing Account Global Descriptive Flexfield Object

Customer Account Regional Information

CustAcctInformation

Trading Community Customer Account Additional Information

The customer account information.

CustomerAccountContact

Trading Community Customer Account or Site Role

The customer account contact information.

CustomerAccountId

long

The unique identifier for the account created for a party. Primary Key for the table.
  • Primary Key

CustomerAccountRelationship

Trading Community Customer Account Relationship

The customer account relationship information.

CustomerAccountSite

Trading Community Customer Account Site

The customer account address information.

CustomerClassCode

string

The customer class identifier. For example, an account created for a reseller or educational customers would have a customer_class_code as reseller or education.

CustomerType

string

The receivables lookup code for the CUSTOMER_TYPE attribute. I for internal customers, R for revenue generating external customers.

DateTypePreference

string

The preference for ship or arrival dates.

DepositRefundMethod

string

The refund method.

HeldBillExpirationDate

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

The held bill expiration date.

HoldBillFlag

boolean

Indicates if the bill receivable should be held or not. If the value is True, then the bill receivables should be held.

LastBatchId

long

The last active batch.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated.

LastUpdateLogin

string

The login of the user who last updated the record.

LastUpdatedBy

string

The user who last updated the record.

NpaNumber

string

Identifies an account with a Number Plan Area (NPA) used in telecommunications.

OrigSystem

string

The source system name.

OrigSystemReference

string

The identifier for the record from the original system.

OriginalSystemReference

Source System Reference

The identifier for the record from the original system.

PartyId

long

The unique identifier of the contact party.

RequestId

long

A system-generated read-only attribute used by the application framework.

SellingPartyId

long

The identifier of the party entering a business relationship as a seller. A selling party can be an individual or an organization. The Selling Party represents the external facing organization with which the customer is doing business, and is not necessarily a legal entity or an operating unit. Its usage within the ebusiness suite will be phased: Phase 1:Products can join to HZ_PARTIES using the SELLING_PARTY_ID to retrieve the PARTY_NAME for use in a UI. e.g. a call center application may run on behalf of several internal organizations - displaying the selling party will allow the user to see context for the customer Phase 2:Products can use SELLING_PARTY_ID as a filtering mechanism. e.g. a profile controls the selling_party_id that a user has access to. The UI would then show accounts matching this party.

SourceCode

string

The promotion that was used to make the party a customer.

Status

string

The status of the record.

StatusUpdateDate

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

The last status update date.

TaxCode

string

The tax code for the customer.

TaxHeaderLevelFlag

boolean

Indicates if item is tax header or a line item. Y for records that are headers for tax purposes, N for records that are lines.

TaxRoundingRule

string

The tax amount rounding rule.