AV_ORG_FIN_INFO

(SQL Table)
Index Back

Org Financial Info

Org Financial Info

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

Prompt Table: AV_EXT_ORG_SRCH

2 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
4 FROM_DT Date(10) DATE From Date
5 TO_DT Date(10) DATE To Date
6 AV_REVENUE_AMT Number(16,2) DECIMAL(15,2) NOT NULL Revenue Amount
7 AV_EXPENSES_AMT Number(16,2) DECIMAL(15,2) NOT NULL Expenses Amount Base
8 AV_ASSETS_AMT Number(16,2) DECIMAL(15,2) NOT NULL Assets Amount
9 AV_LIABILITY_AMT Number(16,2) DECIMAL(15,2) NOT NULL Liability Amount
10 AV_CONT_TTL Number(16,2) DECIMAL(15,2) NOT NULL Contributions Total
11 SRC_DESCR Character(30) VARCHAR2(30) NOT NULL Source Description
12 AV_DATE Date(10) DATE Date
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: AV_INSTALL_INST.BASE_CURRENCY

14 AV_REVENUE_ENT Number(16,2) DECIMAL(15,2) NOT NULL Revenue Amount Entry
15 AV_EXPENSES_ENT Number(16,2) DECIMAL(15,2) NOT NULL Expenses Amount Entry
16 AV_ASSETS_ENT Number(16,2) DECIMAL(15,2) NOT NULL Assets Amount Entry
17 AV_LIABILITY_ENT Number(16,2) DECIMAL(15,2) NOT NULL Liability Amount Entry
18 CURRENCY_CD_ENTRY Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: AV_INSTALL_INST.BASE_CURRENCY

Prompt Table: CURRENCY_CD_TBL

19 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
20 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor