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 |
|
Contains |
Trading Community Customer Billing Account Global Descriptive Flexfield Object |
Contains |
Trading Community Customer Account SDO Additional Information |
Contains |
|
Contains |
|
Contains |
|
Handled by |
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 |
The customer account information. |
|
CustomerAccountContact |
The customer account contact information. |
|
CustomerAccountId |
long |
The unique identifier for the account created for a party. Primary Key for the table.
|
CustomerAccountRelationship |
The customer account relationship information. |
|
CustomerAccountSite |
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 |
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. |