PO_GC01_AET

(SQL Table)
Index Back

PO_GENCLAIM STATE TABLE

Store VRBT_GC04_T values for further processing

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID
4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
7 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
8 VRBT_TRANS_TYPE Character(4) VARCHAR2(4) NOT NULL Transaction Type
PREV=Previous Period
RCV=Receipt
RTV=Return To Vendor (Supplier)
VCHR=Voucher
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
10 DOC_ID Character(50) VARCHAR2(50) NOT NULL ID
11 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
12 RECV_SHIP_SEQ Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
13 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
14 TOTAL_CLAIM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim Amount
15 TOTAL_CLAIMED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claimed Amount
16 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID
17 TRANS_DATE Date(10) DATE Transaction Date
18 VRBT_RULE_ID Number(5,0) INTEGER NOT NULL Vendor Rebate Agreement Rule ID
19 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
20 COUNT_1 Number(3,0) SMALLINT NOT NULL Count Work Field
21 MAX_LINE_NBR Number(5,0) INTEGER NOT NULL Maximum Line Number
22 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index
23 TERM Number(5,0) INTEGER NOT NULL Term