1. Tables and Views
  2. PSC_ERP_ACCT_RULE_LINE_F

PSC_ERP_ACCT_RULE_LINE_F

This table contains accounting rule line information

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_ERP_ACCT_RULE_LINE_F_PK

AGENCY_ID, ACCOUNTING_RULE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, LINE_NUMBER

Columns

Name Datatype Length Precision Not-null Comments Status
AGENCY_ID NUMBER 8 Yes This column is used to indicate agency id Active
ACCOUNTING_RULE_ID VARCHAR2 50 Yes This column is used to indicate accounting rule id Active
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. Active
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective. Active
LINE_NUMBER NUMBER 4 Yes This column is used to indicate line number Active
DEBIT_CREDIT_FLAG VARCHAR2 1 Yes This column is used to indicate debit credit flag Active
ACCOUNT_ID VARCHAR2 30 Yes This column is used to indicate account id Active
DIVISION_ID VARCHAR2 30 This column is used to indicate division id Active
DEPARTMENT_ID VARCHAR2 30 This column is used to indicate department id Active
FUND_ID VARCHAR2 30 This column is used to indicate fund id Active
FUNCTION_ID VARCHAR2 30 This column is used to indicate function id Active
PROGRAM_ID VARCHAR2 30 This column is used to indicate program id Active
PERCENTAGE NUMBER 10 Yes This column is used to indicate percentage Active
ROUND_ADJ VARCHAR2 1 Yes This column is used to indicate round adj Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_ERP_ACCT_RULE_LINE_F psc_erp_acct_rule_b AGENCY_ID, ACCOUNTING_RULE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Indexes

Index Uniqueness Tablespace Columns Status
PSC_ERP_ACCT_RULE_LINE_F_PK Unique Default AGENCY_ID, ACCOUNTING_RULE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, LINE_NUMBER Active