RBTACCTIDDefault Value: NEXT
RBTBILLIDDefault Value: NEXT
DISP=Disputed
PAID=Paid
PEND=Pending
RBT_ACCTBILL_VW(SQL View) |
Index Back |
|---|---|
View fo Account related BillsView fo Account related Bills |
| SELECT A.RBTACCTID , B.RBTBILLID , A.RBTACCTNO , A.RBTACCTNAME , B.RBTBILLNO , B.RBTBILLSTATUS , B.RBTINVOICENO , B.RBTSTDATE , B.RBTENDDATE , B.RBTBILLDUEDATE , B.RBTBILLDATE , B.RBTTOTALDUE , B.RBTINVFILELINK , B.RBTPRICURRENCY FROM PS_RBT_ACCOUNT A , PS_RBT_BILL B WHERE A.RBTACCTID = B.RBTACCTID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RBTACCTID |
Character(15) | VARCHAR2(15) NOT NULL |
Unique service account indentifier
Default Value: NEXT |
| 2 | RBTBILLID |
Character(15) | VARCHAR2(15) NOT NULL |
Bill Id
Default Value: NEXT |
| 3 | RBTACCTNO | Character(20) | VARCHAR2(20) NOT NULL | Account No |
| 4 | RBTACCTNAME | Character(30) | VARCHAR2(30) NOT NULL | Account Name |
| 5 | RBTBILLNO | Character(15) | VARCHAR2(15) NOT NULL | Bill number |
| 6 | RBTBILLSTATUS | Character(4) | VARCHAR2(4) NOT NULL |
Bill Status
DISP=Disputed PAID=Paid PEND=Pending |
| 7 | RBTINVOICENO | Character(15) | VARCHAR2(15) NOT NULL | Invoice Number |
| 8 | RBTSTDATE | Date(10) | DATE | Start Date |
| 9 | RBTENDDATE | Date(10) | DATE | End Date |
| 10 | RBTBILLDUEDATE | Date(10) | DATE | Bill Due Date |
| 11 | RBTBILLDATE | Date(10) | DATE | Bill Date |
| 12 | RBTTOTALDUE | Number(10,2) | DECIMAL(9,2) NOT NULL | Total Due |
| 13 | RBTINVFILELINK | Character(40) | VARCHAR2(40) NOT NULL | rbtinvfilelink |
| 14 | RBTPRICURRENCY | Character(4) | VARCHAR2(4) NOT NULL | Primary Currency |