CA_ACCTGRUL_AET

(SQL Table)
 Index Back

State record for CA_ACCTGRULE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CA_TXN_SOURCE Character(3) VARCHAR2(3) NOT NULL Contracts Transaction Source
CRM=CRM Transaction
FPC=Projects Transaction
FRE=Lease Administration Trans.
3 RECNAME_SOURCE Character(15) VARCHAR2(15) NOT NULL Source Recname
4 RECNAME_TARGET Character(15) VARCHAR2(15) NOT NULL Target Recname
5 RECNAME_TMP Character(15) VARCHAR2(15) NOT NULL Record (Table) Name
6 KEYNAME Character(18) VARCHAR2(18) NOT NULL Key Name
7 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
8 COPY_TO_RULEKEYS Character(1) VARCHAR2(1) NOT NULL Copy data into rule keys
9 ACCT_RULES_TABLE Character(18) VARCHAR2(18) NOT NULL Accounting Rules Tables Name
10 ACCT_RULES_LN_TBL Character(18) VARCHAR2(18) NOT NULL Accounting Rules Line Table Name
11 ACCT_WHERE_TABLE Character(18) VARCHAR2(18) NOT NULL Accounting Rules Where Table Name
12 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • 13 SQLID2 Character(30) VARCHAR2(30) NOT NULL SQL OBJECT WORK FIELD
    14 SQLID3 Character(30) VARCHAR2(30) NOT NULL SQL Object work field
    15 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause
    16 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
    17 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause
    18 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
    19 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
    N=No
    Y=Yes
    20 CF_NAME1 Character(18) VARCHAR2(18) NOT NULL ChartField Name 1
    21 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    22 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    23 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
    24 WEIGHT Number(15,0) DECIMAL(15) NOT NULL Field used to store Weight Points.
    25 DST_USE Character(3) VARCHAR2(3) NOT NULL Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress
    26 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    27 BUSINESS_UNIT_1 Character(5) VARCHAR2(5) NOT NULL Non-Joint Venture BU
    28 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    29 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    30 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
    31 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sequence Number
    32 TMP_FLD1 Character(1) VARCHAR2(1) NOT NULL TMP_FLD1