C360_CTRHDR_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
2	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.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW
4	CA_STATUS	Character(24)	VARCHAR2(24) NOT NULL	Contract Status Prompt Table: %EDITTABLE
5	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
6	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer Prompt Table: CUST_SLD_VW
7	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 Default Value: STD
8	ADDR_SEQ_NUM_BILL	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: CA_CUST_BILL_VW
9	ALLOCATION_DONE	Character(1)	VARCHAR2(1) NOT NULL	Allocation is complete N=Incomplete Y=Complete Default Value: N
10	ADDR_SEQ_NUM_SOLD	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: CA_CUST_ADD_VW
11	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
12	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
13	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: %EDITTABLE2
14	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
15	CONTR_NET_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Net Amount
16	CONTR_TEMPLATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	National or Global Contract Y/N Table Edit Default Value: N
17	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
18	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
19	CNTCT_SEQ_SOLD	Number(5,0)	INTEGER NOT NULL	Primary Contact - Sold To Prompt Table: CA_CUST_CNCT_VW
20	CNTCT_SEQ_BILL	Number(5,0)	INTEGER NOT NULL	Contact Sequence - Bill To Prompt Table: CA_CUST_BIC_VW
21	CONTR_MSTR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Master Contract Y/N Table Edit Default Value: N
22	CONTRACT_SIGN_DT	Date(10)	DATE	Contract Signed Default Value: %DATE
23	CONTRACT_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Contract Type Default Value: BUS_UNIT_TBL_CA.CONTRACT_TYPE Prompt Table: CA_TYPE_TBL
24	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
25	REVISED_GROSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Negotiated Amount
26	REVISED_NET	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revised Net Amount
27	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_CA.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
28	END_DT	Date(10)	DATE	End Date
29	LEGAL_REVIEW_FLG	Character(1)	VARCHAR2(1) NOT NULL	Legal Review Flag Y/N Table Edit Default Value: N
30	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.
31	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.
32	MAST_CONTR_ID	Character(25)	VARCHAR2(25) NOT NULL	Master Contract # Prompt Table: CA_MASTER_VW
33	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
34	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID
35	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
36	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
37	PARENT_CONTR_ID	Character(25)	VARCHAR2(25) NOT NULL	Parent Contract Prompt Table: CA_PARENT_VW
38	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
39	START_DT	Date(10)	DATE	Start Date
40	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
41	TOT_CONTR_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Gross value
42	DFR_REV_ACCT_DT	Date(10)	DATE	Deferred Revenue Acctg Date
43	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
44	COTERMINATION	Character(1)	VARCHAR2(1) NOT NULL	PSIRS-KK Default Value: N
45	LAST_BILL_PLAN_NBR	Number(3,0)	SMALLINT NOT NULL	Last Bill Plan Number Used Default Value: 100
46	LAST_ACCT_PLAN_NBR	Number(3,0)	SMALLINT NOT NULL	Last Acct Plan Number Used Default Value: 100
47	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
48	TOTAL_REDUCTIONS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Discounts
49	AMENDMENT_DT	Date(10)	DATE	Amendment Date
50	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
51	CHG_CMP_DT	DateTime(26)	TIMESTAMP	Amend Completion Date
52	GM_CS_DTL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cost Sharing Detail Y/N Table Edit Default Value: N
53	GM_SAL_DTL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Salary Detail Report Y/N Table Edit Default Value: N
54	GM_METHOD_PAYMENT	Character(3)	VARCHAR2(3) NOT NULL	Method of Payment CST=Cost Reimbursable LOC=Letter of Credit
55	LOC_REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Letter of Credit ID Prompt Table: GM_SPNSR_LC2_VW Set Control Field: BUSINESS_UNIT
56	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
57	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
58	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report