BC_FLAGS_VW(SQL View) |
Index Back |
|---|---|
Business ContactBusiness Contact defines the various business contacts. |
| SELECT A.BO_ID , A.SETID , A.CUST_ID , A.CUSTOMER_IND , A.CUST_STATUS , A.CUST_STATUS_DT , A.CUR_RT_TYPE , A.CURRENCY_CD , A.VAT_TXN_TYPE_CD , A.CR_RATING , A.SINCE_DT , A.ADD_DT , decode (( SELECT 'X' FROM PS_BO_ROLE B WHERE B.BO_ID = A.BO_ID AND B.ROLE_TYPE_ID IN (41 , 45) AND B.ROLE_START_DT <= %CurrentDateIn AND B.ROLE_END_DT > %CurrentDateIn),'X','Y','N'), decode (( SELECT 'X' FROM PS_BO_ROLE C WHERE C.BO_ID = A.BO_ID AND C.ROLE_TYPE_ID IN (42 , 46) AND C.ROLE_START_DT <= %CurrentDateIn AND C.ROLE_END_DT > %CurrentDateIn),'X','Y','N'), decode (( SELECT 'X' FROM PS_BO_ROLE D WHERE D.BO_ID = A.BO_ID AND D.ROLE_TYPE_ID IN (43 , 47) AND D.ROLE_START_DT <= %CurrentDateIn AND D.ROLE_END_DT > %CurrentDateIn), 'X', 'Y', 'N'), A.SEGMENT, A.DO_NOT_CONTACT, A.DO_NOT_EMAIL, A.DO_NOT_MAIL, A.DO_NOT_CALL, A.KPI_ID, A.OBJ_ID, A.PF_OBJ_TYPE, A.RESOLVED_VALUE, A.ASSESS_ID, A.PCT_OF_TARGET, A.CURRENT_TARGET, A.ASSESS_DESCR, A.ASSESS_IMAGE_ID, A.ROW_ADDED_DTTM, A.ROW_ADDED_OPRID, A.ROW_LASTMANT_DTTM, A.ROW_LASTMANT_OPRID, A.SYNCID, A.SYNCDTTM FROM PS_BC A |
| # | 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 | SHIP_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
A flag indicating that the customer or address is a valid Ship To customer or address.
Y/N Table Edit Default Value: N |
| 14 | SOLD_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
A boolean that flags whether or not the customer is a valid Sold To customer.
Y/N Table Edit Default Value: N |
| 15 | BILL_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
A boolean that flags whether or not the customer is a valid Bill To customer.
Y/N Table Edit Default Value: N |
| 16 | SEGMENT | Character(4) | VARCHAR2(4) NOT NULL |
Segment code for customer data
Prompt Table: RD_SEGMENT |
| 17 | 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 |
| 18 | DO_NOT_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Do Not Email
N=No Y=Yes |
| 19 | DO_NOT_MAIL | Character(1) | VARCHAR2(1) NOT NULL |
Do Not Mail
N=No Y=Yes |
| 20 | DO_NOT_CALL | Character(1) | VARCHAR2(1) NOT NULL |
channel flag of privacy preference
N=No Y=Yes |
| 21 | KPI_ID | Character(10) | VARCHAR2(10) NOT NULL | KPI ID |
| 22 | OBJ_ID | Character(20) | VARCHAR2(20) NOT NULL | Dimension |
| 23 | PF_OBJ_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Object type. Also used for Chunking. |
| 24 | 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. |
| 25 | ASSESS_ID | Character(10) | VARCHAR2(10) NOT NULL | Assessment ID |
| 26 | 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. |
| 27 | CURRENT_TARGET | Signed Number(26,6) | DECIMAL(24,6) NOT NULL | Current Target |
| 28 | ASSESS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | ASSESS_DESCR |
| 29 | ASSESS_IMAGE_ID | Character(30) | VARCHAR2(30) NOT NULL | ASSESS_IMAGE_ID |
| 30 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 31 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 32 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 33 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 34 | 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. |
| 35 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |