CA_HDR_RQST_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_CONTR_HDR_VW
2	ADDR_SEQ_NUM_BILL	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: CA_CUST_BILL_VW
3	ALLOCATION_DONE	Character(1)	VARCHAR2(1) NOT NULL	Allocation is complete N=Incomplete Y=Complete Default Value: N
4	ADDR_SEQ_NUM_SOLD	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: CA_CUST_ADD_VW
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW
6	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit Default Value: BUS_UNIT_TBL_CA.BUSINESS_UNIT_BI Prompt Table: SP_BUCABI_NONVW
7	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier Default Value: BUS_UNIT_TBL_CA.BILL_TYPE_ID Prompt Table: BI_TYPE_EF_VW Set Control Field: BUSINESS_UNIT_BI
8	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: CA_BILL_TO_VW
9	CONTR_LEGAL_ENTITY	Character(15)	VARCHAR2(15) NOT NULL	Contract Legal Entity Default Value: BUS_UNIT_TBL_CA.CONTR_LEGAL_ENTITY Prompt Table: CA_LEGAL_ENTITY
10	CONTR_NET_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Net Amount
11	CONTR_TEMPLATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	National or Global Contract Y/N Table Edit Default Value: N
12	SUBCUST_QUAL1	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2. Prompt Table: SUBCUST_Q1_TBL
13	SUBCUST_QUAL2	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2. Prompt Table: SUBCUST_Q2_TBL
14	CNTCT_SEQ_SOLD	Number(5,0)	INTEGER NOT NULL	Primary Contact - Sold To Prompt Table: CA_CUST_CNCT_VW
15	CNTCT_SEQ_BILL	Number(5,0)	INTEGER NOT NULL	Contact Sequence - Bill To Prompt Table: CA_CUST_BIC_VW
16	CONTR_MSTR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Master Contract Y/N Table Edit Default Value: N
17	CONTRACT_SIGN_DT	Date(10)	DATE	Contract Signed Default Value: %DATE
18	CA_STATUS	Character(24)	VARCHAR2(24) NOT NULL	Contract Status Prompt Table: %EDITTABLE
19	CA_PROC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available. A=Active C=Closed P=Pending Default Value: P
20	CONTRACT_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Contract Type Default Value: BUS_UNIT_TBL_CA.CONTRACT_TYPE Prompt Table: CA_TYPE_TBL
21	CREDIT_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Credit Check N=Credit Check No Y=Credit Check Yes Y/N Table Edit Default Value: N
22	REVISED_GROSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Negotiated Amount
23	REVISED_NET	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revised Net Amount
24	REVISED_REDUCT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discounts/Surcharges
25	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_CA.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
26	END_DT	Date(10)	DATE	End Date
27	LEGAL_REVIEW_FLG	Character(1)	VARCHAR2(1) NOT NULL	Legal Review Flag Y/N Table Edit Default Value: N
28	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
29	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
30	MAST_CONTR_ID	Character(25)	VARCHAR2(25) NOT NULL	Master Contract # Prompt Table: CA_MASTER_VW
31	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. Prompt Table: AR_TRMS_VW
32	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID
33	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
34	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
35	PARENT_CONTR_ID	Character(25)	VARCHAR2(25) NOT NULL	Parent Contract Prompt Table: CA_PARENT_VW
36	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. Default Value: OPR_DEF_TBL_CA.REGION_CD Prompt Table: CA_REGION_CD_VW
37	START_DT	Date(10)	DATE	Start Date
38	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer Prompt Table: CUST_SLD_VW
39	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
40	TOT_CONTR_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Gross value
41	DFR_REV_ACCT_DT	Date(10)	DATE	Deferred Revenue Acctg Date
42	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Default Value: BUS_UNIT_TBL_CA.RT_TYPE Prompt Table: RT_TYPE_TBL
43	COTERMINATION	Character(1)	VARCHAR2(1) NOT NULL	PSIRS-KK Default Value: N
44	LAST_BILL_PLAN_NBR	Number(3,0)	SMALLINT NOT NULL	Last Bill Plan Number Used Default Value: 100
45	LAST_ACCT_PLAN_NBR	Number(3,0)	SMALLINT NOT NULL	Last Acct Plan Number Used Default Value: 100
46	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
47	TOTAL_REDUCTIONS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Discounts
48	AMENDMENT_DT	Date(10)	DATE	Amendment Date
49	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
50	CHG_CMP_DT	DateTime(26)	TIMESTAMP	Amend Completion Date
51	GM_CS_DTL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cost Sharing Detail Y/N Table Edit Default Value: N
52	GM_SAL_DTL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Salary Detail Report Y/N Table Edit Default Value: N
53	GM_METHOD_PAYMENT	Character(3)	VARCHAR2(3) NOT NULL	Method of Payment CST=Cost Reimbursable LOC=Letter of Credit
54	LOC_REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Letter of Credit ID Prompt Table: GM_SPNSR_LC2_VW Set Control Field: BUSINESS_UNIT
55	CONTRACT_ADMIN	Character(40)	VARCHAR2(40) NOT NULL	Contract Administrator defined on CABU. Default Value: BUS_UNIT_TBL_CA.CONTRACT_ADMIN Prompt Table: MEMBER_VW
56	CA_REIMB_AGREE	Character(1)	VARCHAR2(1) NOT NULL	Indicator that the installation of Contracts is for Reimbursabale Agreements Y/N Table Edit Default Value: INSTALLATION_CA.CA_REIMB_AGREE
57	CA_RQST_SRC	Character(3)	VARCHAR2(3) NOT NULL	Contract Classification FED=Federal Reimbursable Agreement GEN=Generic Application GOV=Government INT=Internal OND=CRM Field Services On Demand STD=Standard