RI_MA_STAT_VW(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 , C.XLATLONGNAME , B.XLATLONGNAME ,0 ,0 ,0 ,0 , %subrec(RB_AUDIT_SBR, A) FROM PS_RBF_MODIF_ACCT A , PSXLATITEM B , PSXLATITEM C WHERE A.TXN_STATUS = B.FIELDVALUE AND B.FIELDNAME = 'TXN_STATUS' AND B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn AND A.MODIFY_ACCT_TYPE = C.FIELDVALUE AND C.FIELDNAME = 'MODIFY_ACCT_TYPE' AND C.EFF_STATUS = 'A' AND C.EFFDT <= %CurrentDateIn |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | RB_XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 12 | BO_ID_PARTNER | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Partner Company. |
| 13 | ROLE_TYPE_ID_PART | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner |
| 14 | BO_ID_PART_CONT | Signed Number(32,0) | DECIMAL(31) NOT NULL | This is the business object identifier for the partner contact. |
| 15 | ROLE_TYPE_ID_PARTC | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner contact |
| 16 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 17 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 18 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 19 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 20 | 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. |
| 21 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |