RI_MA_STATLVW(SQL View) |
Index Back |
|---|---|
Account ModificationsTransactions related to the Account Modifications. Used in 360-Degree View |
| SELECT A.BO_ID , 9 , 0 , 0 ,0 , A.TXN_STATUS , A.TRANSACTION_NO , A.MODIFY_ACCT_TYPE , A.FIN_ACCOUNT_ID , xlatl.LANGUAGE_CD , xlat2.XLATLONGNAME , xlat2.XLATLONGNAME ,0 ,0 ,0 ,0 , %subrec(RB_AUDIT_SBR, A) FROM PS_RBF_MODIF_ACCT A , PSXLATITEM xlat , PSXLATITEMLANG xlatl , PSXLATITEMLANG xlat2 WHERE A.TXN_STATUS = xlat.FIELDVALUE AND xlat.FIELDNAME = xlatl.FIELDNAME AND xlat.FIELDVALUE = xlatl.FIELDVALUE AND xlat.FIELDNAME = 'TXN_STATUS' AND xlat.EFF_STATUS = 'A' AND xlat.EFFDT <= %CurrentDateIn AND A.MODIFY_ACCT_TYPE = xlat.FIELDVALUE AND xlat.FIELDNAME = xlat2.FIELDNAME AND xlat.FIELDVALUE = xlat2.FIELDVALUE AND xlat.FIELDNAME = 'MODIFY_ACCT_TYPE' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BO_ID_CUST |
Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 2 | ROLE_TYPE_ID_CUST |
Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 3 | BO_ID_CONTACT |
Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 4 | ROLE_TYPE_ID_CNTCT |
Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 5 | BO_ID_SITE | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 6 | TXN_STATUS |
Character(4) | VARCHAR2(4) NOT NULL |
Transaction status used in Modify account process
CL=Close OP=Open |
| 7 | TRANSACTION_NO |
Character(15) | VARCHAR2(15) NOT NULL |
Transaction table's primary key.
Default Value: NEXT |
| 8 | MODIFY_ACCT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Modify account Type
CRDT=Credit Card Parameters CURR=Currency FEE=Account Fee PROD=Product RELN=Account Relationships STAT=Status TIN=TIN Type and Number |
| 9 | FIN_ACCOUNT_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Financial Account Number
Prompt Table: RBF_MOD_ACCT_VW |
| 10 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | RB_XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 13 | BO_ID_PARTNER | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Partner Company. |
| 14 | ROLE_TYPE_ID_PART | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner |
| 15 | BO_ID_PART_CONT | Signed Number(32,0) | DECIMAL(31) NOT NULL | This is the business object identifier for the partner contact. |
| 16 | ROLE_TYPE_ID_PARTC | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner contact |
| 17 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 18 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 19 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 20 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 21 | 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. |
| 22 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |