FO_CA_PROFILE

(SQL Table)
 Index Back

Contract Profile record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

2 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type

Prompt Table: FO_ORDER_TYPE

3 CONTR_LEGAL_ENTITY Character(15) VARCHAR2(15) NOT NULL Contract Legal Entity

Prompt Table: FO_LGL_ENTY_VW
Set Control Field: BUSINESS_UNIT

4 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status

Prompt Table: CA_STATUS_TBL
Set Control Field: BUSINESS_UNIT

5 FO_CA_STATUS_OPEN Character(24) VARCHAR2(24) NOT NULL Contract Open Status

Prompt Table: CA_STATUS_TBL
Set Control Field: BUSINESS_UNIT

6 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type

Prompt Table: FO_CA_TYPE_VW

7 CHG_REASON Character(4) VARCHAR2(4) NOT NULL Amendment Reason

Prompt Table: CA_CHG_RSN_TBL
Set Control Field: BUSINESS_UNIT

8 CHG_TYPE Character(4) VARCHAR2(4) NOT NULL Change Type is the key to change management functionality. It dictates which fields will be ungrayed and available for edit. This is a key to CA_CHG_TMPL, the change template.
CTRL=Contract Activated

Prompt Table: CA_CHG_TYPE_TBL
Set Control Field: BUSINESS_UNIT

9 BILL_PLAN_DESCR Character(30) VARCHAR2(30) NOT NULL Varying grid hyperlink
10 REV_REC_PLAN_DESCR Character(30) VARCHAR2(30) NOT NULL Varying grid hyperlink
11 BILL_CYCLE_ID Character(10) VARCHAR2(10) NOT NULL Billing Cycle Identifier

Prompt Table: BI_CYCLE_VW
Set Control Field: BUSINESS_UNIT

12 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier

Prompt Table: BI_TYPE_EF_VW
Set Control Field: BUSINESS_UNIT

13 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source

Prompt Table: BI_SRC_EF_VW
Set Control Field: BUSINESS_UNIT

14 BILL_BY_ID Character(10) VARCHAR2(10) NOT NULL Bill By Identifier

Prompt Table: FO_BILL_BY_VW
Set Control Field: BUSINESS_UNIT

15 BILL_INQUIRY_PHONE Character(24) VARCHAR2(24) NOT NULL Bill Inquiry Phone

Prompt Table: BI_INQPHONE_VW

16 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist

Prompt Table: BI_SPECIALST_VW
Set Control Field: BUSINESS_UNIT

17 INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Invoice Form

Prompt Table: BI_IVC_FORM_VW
Set Control Field: BUSINESS_UNIT

18 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: %EDITTABLE
Set Control Field: BUSINESS_UNIT

19 ENCUMBRANCE_PCT Number(6,3) DECIMAL(5,3) NOT NULL Encumbrance %
20 FO_BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Fall-off Bill Type Identifier

Prompt Table: BI_TYPE_EF_VW
Set Control Field: BUSINESS_UNIT_BI

21 FO_BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Fall-off Bill Source

Prompt Table: BI_SRC_EF_VW
Set Control Field: BUSINESS_UNIT_BI

22 FO_INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Fall-off Invoice Form

Prompt Table: BI_IVC_FORM_VW
Set Control Field: BUSINESS_UNIT_BI

23 BI_HDR_CURR_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency

Prompt Table: CURRENCY_CD_TBL

24 IDENTIFIER_SEL Character(3) VARCHAR2(3) NOT NULL Identifier Selector
D=Discount Table
ID=PS/Billing Charge Id
S=Surcharge Table
25 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier

Prompt Table: %EDITTABLE4
Set Control Field: BUSINESS_UNIT_BI

26 DESCR Character(30) VARCHAR2(30) NOT NULL Description
27 PRE_APPROVAL_FLG Character(1) VARCHAR2(1) NOT NULL Pre Approval Flag

Y/N Table Edit

28 RATE_PROFILE_NAH Character(10) VARCHAR2(10) NOT NULL NA Payroll Hourly Employee

Prompt Table: FO_RT_PROFH_VW

29 RATE_PROFILE_NAS Character(10) VARCHAR2(10) NOT NULL NA Payroll Salaried Employee

Prompt Table: FO_RT_PROFS_VW

30 RATE_PROFILE_NEE Character(10) VARCHAR2(10) NOT NULL Non-Employee

Prompt Table: FO_RT_PROFN_VW

31 RATE_PROFILE_GP Character(10) VARCHAR2(10) NOT NULL Global Payroll Employee

Prompt Table: FO_RT_PROFG_VW

32 SEPARATE_BIL_REV Character(1) VARCHAR2(1) NOT NULL Flag used by Governement Contracts to separate Billing and Revenue transactions

Default Value: N

33 SEPARATE_BIL_REV_F Character(1) VARCHAR2(1) NOT NULL Flag used to separate Billing and Revenue for Amount based contract lines.

Default Value: N

34 USE_PC_CFS Character(1) VARCHAR2(1) NOT NULL Use Project ChartFields

Y/N Table Edit

Default Value: Y