CB_CONTRACT_VW(SQL View) |
Index Back |
|---|---|
Claimback Contract |
| SELECT A.SETID , A.CB_CONTRACT_ID , A.DESCR , A.VENDOR_ID , A.START_DATE , A.END_DATE , A.CB_AMOUNT , A.CB_PERCENTAGE , A.CB_COST_FIXED , A.UNIT_OF_MEASURE , A.CB_MAX_QUANTITY , A.CB_STOP_AT_MAX , A.CB_INCLUDE_SHIP , A.CNTRCT_ID , A.CUST_ID , A.CUSTOMER_GROUP , A.PRODUCT_ID , A.PRODUCT_GROUP , C.CB_APPLY_SOE , A.ENTERED_DTTM , B.BUSINESS_UNIT_OM , A.CB_MARGIN , A.CB_CUST_TYPE , A.CB_PROD_TYPE , A.CB_VENDOR_REF , A.CB_COST_DATE , A.CB_COST_ON_CON , A.CB_PURCHASE_COST FROM PS_CB_HDR A , PS_CB_OMBU_LIST B , PS_CB_SETID_OPT C WHERE A.SETID = B.SETID AND A.CB_CONTRACT_ID = B.CB_CONTRACT_ID AND C.SETID = A.SETID AND A.CB_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CB_CONTRACT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Claimback Contract ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 6 | END_DATE | Date(10) | DATE | End Date |
| 7 | CB_AMOUNT | Number(27,3) | DECIMAL(26,3) NOT NULL | Claimback Amount |
| 8 | CB_PERCENTAGE | Number(7,3) | DECIMAL(6,3) NOT NULL | Claimback Percentage |
| 9 | CB_COST_FIXED | Character(1) | VARCHAR2(1) NOT NULL | Cost Fixed From Contract Date |
| 10 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 11 | CB_MAX_QUANTITY | Number(32,4) | DECIMAL(31,4) NOT NULL | Maximum Quantity |
| 12 | CB_STOP_AT_MAX | Character(1) | VARCHAR2(1) NOT NULL |
Stop Apply At Max Quantity
Y/N Table Edit Default Value: Y |
| 13 | CB_INCLUDE_SHIP | Character(1) | VARCHAR2(1) NOT NULL |
Include Shipments
B=Standard and Direct D=Direct Only S=Standard Only Default Value: S |
| 14 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table: SCON_HDR |
| 15 | 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. |
| 16 | CUSTOMER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
| 17 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 18 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |
| 19 | CB_APPLY_SOE | Character(1) | VARCHAR2(1) NOT NULL |
Automatically Apply
F=First To Expire L=Largest Claimback Amount N=None |
| 20 | ENTERED_DTTM | DateTime(26) | TIMESTAMP | Created On |
| 21 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 22 | CB_MARGIN | Character(1) | VARCHAR2(1) NOT NULL |
Claimback Margin Impact
B=Primary and Secondary Margin N=None P=Primary Margin S=Secondary Margin |
| 23 | CB_CUST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Customer Type
C=Customer G=Customer Group |
| 24 | CB_PROD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Product Type
G=Product Group P=Product |
| 25 | CB_VENDOR_REF | Character(30) | VARCHAR2(30) NOT NULL | Supplier Reference |
| 26 | CB_COST_DATE | Date(10) | DATE | Cost Fixed Date |
| 27 | CB_COST_ON_CON | Character(1) | VARCHAR2(1) NOT NULL | Cost Defined On Contract |
| 28 | CB_PURCHASE_COST | Number(16,5) | DECIMAL(15,5) NOT NULL | Purchase Cost |