CB_CLAIM_ACT_VW

(SQL View)
 Index Back

Claim Inquiry View

Claim Inquiry View

SELECT A.SETID , A.CB_CONTRACT_ID , B.BUSINESS_UNIT , B.DEMAND_SOURCE , B.SOURCE_BUS_UNIT , B.ORDER_NO , B.ORDER_INT_LINE_NO , B.SCHED_LINE_NBR , B.INV_ITEM_ID , B.DEMAND_LINE_NO , C.SHIP_TO_CUST_ID , B.CLAIM_ID , D.PRODUCT_ID , D.QTY_ORDERED , D.UNIT_OF_MEASURE , B.QTY_SHIPPED , B.SHIP_ID , C.ORD_SCH_STATUS FROM PS_CB_HDR A , PS_IN_DEMAND B , PS_ORD_SCHEDULE C , PS_SET_CNTRL_REC SC1 , PS_ORD_LINE D WHERE SC1.SETCNTRLVALUE = C.BUSINESS_UNIT AND SC1.RECNAME = 'CB_HDR' AND SC1.SETID = A.SETID AND A.CB_CONTRACT_ID = C.CB_CONTRACT_ID AND B.SOURCE_BUS_UNIT = C.BUSINESS_UNIT AND B.ORDER_NO = C.ORDER_NO AND B.ORDER_INT_LINE_NO = C.ORDER_INT_LINE_NO AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.ORDER_NO = D.ORDER_NO AND C.ORDER_INT_LINE_NO = D.ORDER_INT_LINE_NO

# 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 CB_CONTRACT_ID Character(25) VARCHAR2(25) NOT NULL Claimback Contract ID

Default Value: NEXT

Prompt Table: CB_HDR

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

4 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order

Default Value: OPR_DEF_TBL_IN.DEMAND_SOURCE

5 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Default Value: OPR_DEF_TBL_IN.SOURCE_BUS_UNIT

Prompt Table: SP_BU_FS_NONVW

6 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
7 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
8 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW2

10 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
11 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
12 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID
13 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
14 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
15 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
16 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
17 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
18 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled