BC

(SQL Table)
 Index Back

Business Contact

Business Contact defines the various business contacts.

  • Parent Record Of BC_BILLTO_CI_VW BC_BILLTO_OPT BC_BLLTO_OPT_VW BC_CNTCT BC_SHIPTO_CI_VW BC_SHIPTO_OPT BC_SHPTO_OPT_VW BC_SLDTO_OPT_VW BC_SOLDTO_CI_VW BC_SOLDTO_OPT FBC FBC_CI_VW FBC_SBR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
    4 CUSTOMER_IND Character(1) VARCHAR2(1) NOT NULL Customer Indicator for Business Contacts.
    N=No
    Y=Yes
    5 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status Indicator. BC.CUST_STATUS
    A=Active
    I=Inactive

    Default Value: A

    6 CUST_STATUS_DT Date(10) DATE The date that the status of a customer takes effect.

    Default Value: %date

    7 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

    Default Value: INSTALLATION.DEF_CUR_RT_TYPE

    Prompt Table: RT_TYPE_TBL

    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    9 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.

    Prompt Table: VAT_TXN_CD

    10 CR_RATING Number(5,0) INTEGER NOT NULL Credit Rating Field. Used to store Credit Rating of a Company Or Consumer. It is used in BC (Business Contact) Record
    11 SINCE_DT Date(10) DATE The customer has been a customer since this date.

    Default Value: %date

    12 ADD_DT Date(10) DATE The date the customer was added to the system.

    Default Value: %date

    13 SEGMENT Character(4) VARCHAR2(4) NOT NULL Segment code for customer data

    Prompt Table: RD_SEGMENT

    14 DO_NOT_CONTACT Character(1) VARCHAR2(1) NOT NULL DO_NOT_CONTACT is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994.
    N=Contact Permitted
    Y=Do not contact

    Default Value: N

    15 DO_NOT_SMS Character(1) VARCHAR2(1) NOT NULL DO_NOT_SMS is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994.
    N=SMS Permitted
    Y=Do not SMS

    Default Value: N

    16 DO_NOT_EMAIL Character(1) VARCHAR2(1) NOT NULL Do Not Email
    N=No
    Y=Yes

    Default Value: N

    17 DO_NOT_MAIL Character(1) VARCHAR2(1) NOT NULL Do Not Mail
    N=No
    Y=Yes

    Default Value: N

    18 DO_NOT_CALL Character(1) VARCHAR2(1) NOT NULL channel flag of privacy preference
    N=No
    Y=Yes

    Default Value: N

    19 KPI_ID Character(10) VARCHAR2(10) NOT NULL KPI ID
    20 OBJ_ID Character(20) VARCHAR2(20) NOT NULL Dimension
    21 PF_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL Object type. Also used for Chunking.
    22 RESOLVED_VALUE Signed Number(26,6) DECIMAL(24,6) NOT NULL Contains a number which is the value for the KPI/Object for the current Scenario, Fiscal Year and Accounting Period.
    23 ASSESS_ID Character(10) VARCHAR2(10) NOT NULL Assessment ID
    24 PCT_OF_TARGET Signed Number(8,2) DECIMAL(6,2) NOT NULL is the Percent that the Actual Value of the KPI/Object is of it's Target Value.
    25 CURRENT_TARGET Signed Number(26,6) DECIMAL(24,6) NOT NULL Current Target
    26 ASSESS_DESCR Character(30) VARCHAR2(30) NOT NULL ASSESS_DESCR
    27 ASSESS_IMAGE_ID Character(30) VARCHAR2(30) NOT NULL ASSESS_IMAGE_ID
    28 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    29 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    30 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    31 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    32 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    33 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time