VRBT_CLAIM_SRCH(SQL View) |
Index Back |
|---|
| SELECT a.setid , a.claim_id , a.claim_status , a.overdue_flg , a.claim_due_dt , a.vendor_setid , a.vendor_id , a.vrbt_id FROM PS_VRBT_CLAIM_HDR a WHERE a.claim_type = 'R' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | CLAIM_ID |
Character(15) | VARCHAR2(15) NOT NULL | Claim ID |
| 3 | CLAIM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Claim Status
1=Open 3=Approved 5=Deferred 6=Cancelled 7=Pending Payment 8=Partially Paid 9=Paid |
| 4 | OVERDUE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Overdue Status
C=Current O=Overdue Y/N Table Edit Default Value: N |
| 5 | CLAIM_DUE_DT | Date(10) | DATE | Claim Due Date |
| 6 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_PO_VW
|
| 8 | VRBT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Vendor Rebate ID
Prompt Table: VRBT_HDR |