CA_BUGL_OPT

(SQL Table)
 Index Back

Contract Business Unit Defn

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

Prompt Table: SP_BU_GL_NONVW

2 APPL_JRNL_ID_REV Character(10) VARCHAR2(10) NOT NULL Revenue Journal

Prompt Table: JRNLGEN_APPL_ID
Set Control Field: BUSINESS_UNIT_GL

3 APPL_JRNL_ID_DFR Character(10) VARCHAR2(10) NOT NULL Defered Revenue Journal

Prompt Table: JRNLGEN_APPL_ID
Set Control Field: BUSINESS_UNIT_GL

4 APPL_JRNL_ID_PC Character(10) VARCHAR2(10) NOT NULL Projects Journal

Prompt Table: JRNLGEN_APPL_ID
Set Control Field: BUSINESS_UNIT_GL

5 DOC_TYPE_CA_REV Character(8) VARCHAR2(8) NOT NULL Fixed-Amount Revenue Doc. Type

Prompt Table: DOC_TYPE_A_VW
Set Control Field: BUSINESS_UNIT_GL

6 DOC_TYPE_CA_RVSL Character(8) VARCHAR2(8) NOT NULL Product revenue rvsl doc. type

Prompt Table: DOC_TYPE_A_VW
Set Control Field: BUSINESS_UNIT_GL

7 DOC_TYPE_DFR Character(8) VARCHAR2(8) NOT NULL Contract Liability Doc. Type

Prompt Table: DOC_TYPE_A_VW
Set Control Field: BUSINESS_UNIT_GL

8 DOC_TYPE_DFR_RVSL Character(8) VARCHAR2(8) NOT NULL Def. revenue rvsl doc. type

Prompt Table: DOC_TYPE_A_VW
Set Control Field: BUSINESS_UNIT_GL

9 DOC_TYPE_PC_RDSTRB Character(8) VARCHAR2(8) NOT NULL Service revenue rvsl doc. type

Prompt Table: DOC_TYPE_A_VW
Set Control Field: BUSINESS_UNIT_GL

10 DOC_TYPE_PC_REV Character(8) VARCHAR2(8) NOT NULL Rate-Based Revenue Doc. Type

Prompt Table: DOC_TYPE_A_VW
Set Control Field: BUSINESS_UNIT_GL

11 DOC_TYPE_CRM_REV Character(8) VARCHAR2(8) NOT NULL CRM Transaction Document Type

Prompt Table: DOC_TYPE_A_VW
Set Control Field: BUSINESS_UNIT_GL