MADE_RPT_AET

(SQL Table)
 Index Back

Run Control Record

Run Control Record for FRA Made report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_CA_NONVW

5 CUSTOMER_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.
6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
7 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

Prompt Table: CA_CNTR_SRCH_VW

8 CNTRCT_ID_TO Character(25) VARCHAR2(25) NOT NULL Contract ID To

Prompt Table: CA_CNTR_SRCH_VW

9 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
10 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.
11 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
12 START_DATE Date(10) DATE Start Date for Gen Standing PO
13 END_DATE Date(10) DATE End Date
14 SD_TEXT4_1 Character(4) VARCHAR2(4) NOT NULL Text
15 SD_TEXT4_2 Character(4) VARCHAR2(4) NOT NULL Text
16 SD_TEXT4_3 Character(4) VARCHAR2(4) NOT NULL Text
17 REVISED_GROSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Negotiated Amount
18 EARNED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Earned Amount
19 BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Bill Amount
20 COLLECTED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Collected Amount
21 ADVANCED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Advanced Amount
22 REMAIN_ADV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Advanced Amount Remaining
23 FLDNUMVAL1 Number(20,0) DECIMAL(20) NOT NULL Fld Num1
24 FLDNUMVAL2 Number(20,0) DECIMAL(20) NOT NULL Fld Num1
25 FLDNUMVAL3 Number(20,0) DECIMAL(20) NOT NULL Fld Num1
26 FLDNUMVAL4 Number(20,0) DECIMAL(20) NOT NULL Fld Num1
27 FLDNUMVAL5 Number(20,0) DECIMAL(20) NOT NULL Fld Num1
28 FLDNUMVAL6 Number(20,0) DECIMAL(20) NOT NULL Fld Num1
29 UNBILLED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unbilled Amount
30 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
31 CHG_ID_SRCH Character(10) VARCHAR2(10) NOT NULL Search Change ID.
32 START_DT Date(10) DATE Start Date
33 END_DT Date(10) DATE End Date
34 SD_TEXT4_4 Character(4) VARCHAR2(4) NOT NULL Text
35 SD_TEXT4_5 Character(4) VARCHAR2(4) NOT NULL Text
36 CA_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Obligation status
A=Active
C=Cancelled
P=Pending
R=Renewed
37 CA_DELIVERY_STATUS Character(1) VARCHAR2(1) NOT NULL Contracts Delivery Status
F=Final Delivery
P=Partial Delivery
U=Undelivered
38 LIMIT_AMT_BIL Signed Number(28,3) DECIMAL(26,3) NOT NULL Funded/Billing Limit Amount
39 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
40 TAS_GWA Character(26) VARCHAR2(26) NOT NULL TAS GWA
41 BETC_CD Character(8) VARCHAR2(8) NOT NULL Business Event Type Code
42 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
43 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
44 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
45 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
46 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
47 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
48 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
49 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
50 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address