CA_RULES_HDR_VW

(SQL View)
 Index Back

Accounting Rules Header (TBP)

Search record for TBP Accounting Rules

SELECT A.CA_TXN_SOURCE , A.BUSINESS_UNIT , A.CRIT_SEQ , A.BUSINESS_UNIT_GL , A.BUS_UNIT_GL_FROM , A.CA_RULE_KEY1 , A.CA_RULE_KEY2 , A.CA_RULE_KEY3 , A.CA_RULE_KEY4 , A.CA_RULE_KEY5 , A.CA_RULE_KEY6 , A.CA_RULE_KEY7 , A.CA_RULE_KEY8 , A.CA_RULE_KEY9 , A.CA_RULE_KEY10 , A.CA_RULE_KEY11 , A.CA_RULE_KEY12 , A.CA_RULE_KEY13 , A.CA_RULE_KEY14 , A.CA_RULE_KEY15 , A.CA_RULE_KEY16 , A.CONTRACT_NUM , A.DESCR , A.ACTIVE_STATUS FROM PS_CA_RULES_HDR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CA_TXN_SOURCE Character(3) VARCHAR2(3) NOT NULL Contracts Transaction Source
CRM=CRM Transaction
FPC=Projects Transaction
FRE=Lease Administration Trans.
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: %EDITTABLE40

3 CRIT_SEQ Number(8,0) INTEGER NOT NULL Criteria Sequence
4 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BU_GL_NONVW

5 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL

Prompt Table: SP_BU_GL_NONVW

6 CA_RULE_KEY1 Character(30) VARCHAR2(30) NOT NULL CA_RULE_KEY1

Prompt Table: %EDITTABLE

7 CA_RULE_KEY2 Character(30) VARCHAR2(30) NOT NULL CA_RULE_KEY1

Prompt Table: %EDITTABLE2

8 CA_RULE_KEY3 Character(30) VARCHAR2(30) NOT NULL CA_RULE_KEY3

Prompt Table: %EDITTABLE3

9 CA_RULE_KEY4 Character(30) VARCHAR2(30) NOT NULL CA_RULE_KEY4

Prompt Table: %EDITTABLE4

10 CA_RULE_KEY5 Character(30) VARCHAR2(30) NOT NULL CA_RULE_KEY5

Prompt Table: %EDITTABLE5

11 CA_RULE_KEY6 Character(30) VARCHAR2(30) NOT NULL CA TBP Accounting Rules Generic Keys

Prompt Table: %EDITTABLE6

12 CA_RULE_KEY7 Character(30) VARCHAR2(30) NOT NULL CA TBP Accounting Rules Generic Keys

Prompt Table: %EDITTABLE7

13 CA_RULE_KEY8 Character(30) VARCHAR2(30) NOT NULL CA TBP Accounting Rules Generic Keys

Prompt Table: %EDITTABLE8

14 CA_RULE_KEY9 Character(30) VARCHAR2(30) NOT NULL CA TBP Accounting Rules Generic Keys

Prompt Table: %EDITTABLE9

15 CA_RULE_KEY10 Character(30) VARCHAR2(30) NOT NULL CA TBP Accounting Rules Generic Keys

Prompt Table: %EDITTABLE10

16 CA_RULE_KEY11 Character(30) VARCHAR2(30) NOT NULL CA TBP Accounting Rules Generic Keys

Prompt Table: %EDITTABLE11

17 CA_RULE_KEY12 Character(30) VARCHAR2(30) NOT NULL CA TBP Accounting Rules Generic Keys

Prompt Table: %EDITTABLE12

18 CA_RULE_KEY13 Character(30) VARCHAR2(30) NOT NULL CA TBP Accounting Rules Generic Keys

Prompt Table: %EDITTABLE13

19 CA_RULE_KEY14 Character(30) VARCHAR2(30) NOT NULL CA TBP Accounting Rules Generic Keys

Prompt Table: %EDITTABLE14

20 CA_RULE_KEY15 Character(30) VARCHAR2(30) NOT NULL CA TBP Accounting Rules Generic Keys

Prompt Table: %EDITTABLE15

21 CA_RULE_KEY16 Character(30) VARCHAR2(30) NOT NULL CA TBP Accounting Rules Generic Keys

Prompt Table: %EDITTABLE16

22 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_CONTR_HDR

23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
24 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Template Status
A=Active
I=Inactive

Default Value: A