Copyright (c) 1996, 2015, Oracle and/or its affiliates. All rights reserved.
This material is the confidential property of Oracle Corporation or its licensors and may be used, reproduced, stored or transmitted only in accordance with a valid Oracle license or sublicense agreement.

Field Index SQL Mapping

Class /bulkacct

The bulkacct object represents a set of account and related objects that are created and possibly updated as a named set. The bulkacct object contains information about who created the batch and when, as well as the initial values provided during account creation for each account in the batch.

Notes

  • The system will assign poid ids above 1000 to objects of this class. The range below this is reserved for creating objects with well-known poid ids.
  • This object can be read by the owner or any billing group leader within the brand who is an ancestor of the owner.
  • This object can be modified by the owner or any billing group leader within the brand who is an ancestor of the owner.
  • This object can be created by anyone.

Links



Field Index

Type Field Name
poid PIN_FLD_POID
timestamp PIN_FLD_CREATED_T
timestamp PIN_FLD_MOD_T
string PIN_FLD_READ_ACCESS
string PIN_FLD_WRITE_ACCESS
string PIN_FLD_CREATE_ACCESS
poid PIN_FLD_ACCOUNT_OBJ
string PIN_FLD_ADDRESS
decimal PIN_FLD_BAL_OPERAND
string PIN_FLD_BULKACCT_EFILE
string PIN_FLD_BULKACCT_SFILE
string PIN_FLD_BULKACCT_SLP
string PIN_FLD_CITY
timestamp PIN_FLD_CLOSE_WHEN_T
int PIN_FLD_COUNT
string PIN_FLD_COUNTRY
string PIN_FLD_FIRST_NAME
int PIN_FLD_FLAGS
string PIN_FLD_LAST_NAME
string PIN_FLD_LOGIN_PREFIX
string PIN_FLD_LOGIN_SUFFIX
string PIN_FLD_MIDDLE_NAME
string PIN_FLD_NAME
string PIN_FLD_PASSWD_PATTERN
poid PIN_FLD_PLAN_OBJ
int PIN_FLD_RESOURCE_ID
int PIN_FLD_START_SEQ
string PIN_FLD_STATE
enum PIN_FLD_STATUS
string PIN_FLD_TRACKING_ID
poid PIN_FLD_USERID
string PIN_FLD_ZIP


Field Details

poid PIN_FLD_POID

Object Identifier for an instance of this class. Portal object ids have four pieces of information: database number, class type, sequence id, revision.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_CREATED_T

Time the object was created.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_MOD_T

Time the object was last modified.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

string PIN_FLD_READ_ACCESS

Read Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_WRITE_ACCESS

Write Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_CREATE_ACCESS

Create Access level for object. Valid values are O(BrandOwner), R(Root), N(Any).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

poid PIN_FLD_ACCOUNT_OBJ

Link to account object for which this object was created.

Notes

  • Required on object creation
  • Cannot be modified

Links

string PIN_FLD_ADDRESS

Street address of contact. Multiple lines can be stored with newline separator.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

decimal PIN_FLD_BAL_OPERAND

The balance of credit for each account, specified in units as described in PIN_FLD_RESOURCE_ID.

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_BULKACCT_EFILE

Name of file containing information about accounts not successfully created.

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_BULKACCT_SFILE

Name of file containing information about accounts successfully created.

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_BULKACCT_SLP

This provides the Java class file name for the service login provider that generates service login IDs and passwords.

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_CITY

City portion of contact's address.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

timestamp PIN_FLD_CLOSE_WHEN_T

Date that the accounts in this batch should be automatically closed. Used to schedule account closure in advance. 0 means do not auto-close.

Notes

  • Required on object creation
  • Can be modified

Links

int PIN_FLD_COUNT

The number of accounts in this batch.

Notes

  • Required on object creation
  • Cannot be modified

Links

string PIN_FLD_COUNTRY

Country portion of contact's address.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 60 bytes

Links

string PIN_FLD_FIRST_NAME

First name of contact.

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

int PIN_FLD_FLAGS

1 = Accounts in this batch are currently being modified by user specified in PIN_FLD_USERID.

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_LAST_NAME

Last name of contact.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_LOGIN_PREFIX

The optional prefix to the service login IDs that are generated for the accounts in this batch.

Notes

  • Required on object creation
  • Cannot be modified
  • Maximum length is 60 bytes

Links

string PIN_FLD_LOGIN_SUFFIX

The optional suffix to the service login IDs that are generated for the accounts in this batch.

Notes

  • Required on object creation
  • Cannot be modified
  • Maximum length is 60 bytes

Links

string PIN_FLD_MIDDLE_NAME

Middle name of contact.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

string PIN_FLD_NAME

The name of the batch as known to its creator.

Notes

  • Required on object creation
  • Cannot be modified
  • Maximum length is 60 bytes

Links

string PIN_FLD_PASSWD_PATTERN

The password pattern for generated service login IDs.

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

poid PIN_FLD_PLAN_OBJ

Link to plan object that was purchased containing this product.

Notes

  • Required on object creation
  • Cannot be modified

Links

int PIN_FLD_RESOURCE_ID

Numeric value of the resource that is impacted.

Notes

  • Required on object creation
  • Can be modified

Links

int PIN_FLD_START_SEQ

The first number to be used for the middle portion of the service login IDs for this batch. This number is incremented for each successive account.

Notes

  • Required on object creation
  • Cannot be modified

Links

string PIN_FLD_STATE

State or Province portion of contact's address.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 90 bytes

Links

enum PIN_FLD_STATUS

Status of the accounts in this batch. Legal values are ACTIVE (10100), INACTIVE (10102), and CLOSED (10103). Only active products are assessed cycle fees and participate in usage rating.

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_TRACKING_ID

The Tracking ID associated with the accounts in this batch. This value is kept in /account/PIN_FLD_AAC_VENDOR.

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 60 bytes

Links

poid PIN_FLD_USERID

The user currently modifying or that last modified this object and the accounts in this batch.

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_ZIP

Zip code or postal code portion of contact's address.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 60 bytes

Links



SQL Mapping


Type Field Name Table Column Name
base-class /bulkacct bulkacct_t
poid PIN_FLD_POID poid*
timestamp PIN_FLD_CREATED_T created_t
timestamp PIN_FLD_MOD_T mod_t
string PIN_FLD_READ_ACCESS read_access
string PIN_FLD_WRITE_ACCESS wrtie_access
string PIN_FLD_CREATE_ACCESS create_access
poid PIN_FLD_ACCOUNT_OBJ account_obj*
string PIN_FLD_ADDRESS address
decimal PIN_FLD_BAL_OPERAND bal_operand
string PIN_FLD_BULKACCT_EFILE bulkacct_efile
string PIN_FLD_BULKACCT_SFILE bulkacct_sfile
string PIN_FLD_BULKACCT_SLP bulkacct_slp
string PIN_FLD_CITY city
timestamp PIN_FLD_CLOSE_WHEN_T close_when_t
int PIN_FLD_COUNT count
string PIN_FLD_COUNTRY country
string PIN_FLD_FIRST_NAME first_name
int PIN_FLD_FLAGS flags
string PIN_FLD_LAST_NAME last_name
string PIN_FLD_LOGIN_PREFIX login_prefix
string PIN_FLD_LOGIN_SUFFIX login_suffix
string PIN_FLD_MIDDLE_NAME middle_name
string PIN_FLD_NAME name
string PIN_FLD_PASSWD_PATTERN passwd_pattern
poid PIN_FLD_PLAN_OBJ plan_obj*
int PIN_FLD_RESOURCE_ID resource_id
int PIN_FLD_START_SEQ start_seq
string PIN_FLD_STATE state
enum PIN_FLD_STATUS status
string PIN_FLD_TRACKING_ID tracking_id
poid PIN_FLD_USERID userid*
string PIN_FLD_ZIP zip
Column names marked with * are actually column prefixes. For poid type fields, the column prefix is used to create the columns poid_id0, poid_db and poid_type if the prefix is "poid". For PIN_FLD_POID in the base table, an additional column named poid_rev is created to hold the poid revision. For buffer fields, two columns are created - one in the containing table and one in the buffer table. For example if the prefix is "buf", then the column name in the buffer table is buffer_buf and the column name in the containing table is buffer_size.

Field Index This Class