CB_CLAIM_HDR_VW(SQL View) |
Index Back |
|---|---|
Claimbacks View of Claims |
| SELECT SETID , CLAIM_ID , CLAIM_STATUS , CLAIM_TYPE , CLAIM_DT , VENDOR_SETID , VENDOR_ID , VNDR_LOC , CUST_SETID , CUST_ID , CB_CONTRACT_SETID , CB_CONTRACT_ID , TOTAL_CLAIM_AMT , CURRENCY_CD , BUSINESS_UNIT_AP , BUSINESS_UNIT_AR , BUSINESS_UNIT_GL FROM PS_VRBT_CLAIM_HDR WHERE CLAIM_TYPE = 'C' |
| # | 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: OPR_DEF_TBL_FS |
| 2 | CLAIM_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Claim ID
Prompt Table: VRBT_CLAIM_SRCH |
| 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 | CLAIM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Claim Type
C=Claimbacks R=Vendor Rebate |
| 5 | CLAIM_DT | Date(10) | DATE | Claim 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 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 9 | CUST_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Customer SetID
Default Value: VENDOR.SETID Prompt Table: SETID_TBL |
| 10 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUSTOMER_FS |
| 11 | CB_CONTRACT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Claimback Contract Setid
Prompt Table: CB_SETID_VW |
| 12 | CB_CONTRACT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Claimback Contract ID
Prompt Table: CB_CON_VW |
| 13 | TOTAL_CLAIM_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Claim Amount |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 15 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 16 | BUSINESS_UNIT_AR | Character(5) | VARCHAR2(5) NOT NULL | AR Business Unit |
| 17 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |