RBTBILLIDPrompt Table: CURRENCY_CD_TBL
Prompt Table: BO
Prompt Table: BO
RBT_PER_BILL_VW(SQL View) |
Index Back |
|---|---|
My Bills ViewSELECT OPR.OPRID ,BILL.RBTINVOICENO ,BILL.RBTBILLDATE ,BILL.RBTPRICURRENCY ,BILL.RBTTOTALDUE ,BILL.RBTBILLDUEDATE FROM PSOPRALIAS OPR ,PS_RD_PERSON PER ,PS_RBT_ACCOUNT ACCT ,PS_RBT_BILL BILL WHERE PER.PERSON_ID=OPR.PERSON_ID AND PER.SETID=ACCT.SETID AND ACCT.RBTCONT_BO_ID=PER.BO_ID AND BILL.RBTACCTID=ACCT.RBTACCTID AND BILL.RBTBILLSTATUS='PEND' |
| SELECT BILL.RBTBILLID ,ACCT.RBTACCTNO ,BILL.RBTBILLNO ,BILL.RBTINVOICENO ,BILL.RBTBILLDATE ,BILL.RBTSTDATE ,BILL.RBTENDDATE ,BILL.RBTPRICURRENCY ,BILL.RBTTOTALDUE ,BILL.RBTBILLDUEDATE ,BILL.RBTPREVTOTAL ,BILL.MARKET ,ACCT.RBTCUST_BO_ID ,ACCT.ROLE_TYPE_ID_CUST ,ACCT.RBTCONT_BO_ID ,ACCT.ROLE_TYPE_ID_CNTCT FROM PS_RBT_ACCOUNT ACCT ,PS_RBT_BILL BILL WHERE BILL.RBTACCTID=ACCT.RBTACCTID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBTBILLID |
Character(15) | VARCHAR2(15) NOT NULL | Bill Id |
| 2 | RBTACCTNO | Character(20) | VARCHAR2(20) NOT NULL | Account No |
| 3 | RBTBILLNO | Character(15) | VARCHAR2(15) NOT NULL | Bill number |
| 4 | RBTINVOICENO | Character(15) | VARCHAR2(15) NOT NULL | Invoice Number |
| 5 | RBTBILLDATE | Date(10) | DATE | Bill Date |
| 6 | RBTSTDATE | Date(10) | DATE | Start Date |
| 7 | RBTENDDATE | Date(10) | DATE | End Date |
| 8 | RBTPRICURRENCY | Character(4) | VARCHAR2(4) NOT NULL |
Primary Currency
Prompt Table: CURRENCY_CD_TBL |
| 9 | RBTTOTALDUE | Number(10,2) | DECIMAL(9,2) NOT NULL | Total Due |
| 10 | RBTBILLDUEDATE | Date(10) | DATE | Bill Due Date |
| 11 | RBTPREVTOTAL | Number(10,2) | DECIMAL(9,2) NOT NULL | prev total |
| 12 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 13 | RBTCUST_BO_ID | Number(31,0) | DECIMAL(31) NOT NULL |
Customer BO ID
Prompt Table: BO |
| 14 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 15 | RBTCONT_BO_ID | Number(31,0) | DECIMAL(31) NOT NULL |
Contact BO ID
Prompt Table: BO |
| 16 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |