F2_MAF_TBL(SQL Table) |
Index Back |
---|---|
FACTS II MAF |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | F2_MAF_TSYMBOL | Character(18) | VARCHAR2(18) NOT NULL | MAF Treasury Symbol |
2 | MAF_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | MAF Sequence Number |
3 | RECORD_TYPE_7 | Character(15) | VARCHAR2(15) NOT NULL | Record Type 7 TAS |
4 | DEPT_REGULAR | Character(2) | VARCHAR2(2) NOT NULL | Dept Regular - TAS |
5 | DEPT_TRANSFER | Character(2) | VARCHAR2(2) NOT NULL | Department Transfer - TAS |
6 | FISCAL_YR_TAS | Character(4) | VARCHAR2(4) NOT NULL | Fiscal Year TAS |
7 | MAIN_ACCOUNT | Character(4) | VARCHAR2(4) NOT NULL | Main Account TAS |
8 | SUB_ACCOUNT | Character(3) | VARCHAR2(3) NOT NULL | Sub Account TAS |
9 | ACCT_SPLIT_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Account Split Seq Number |
10 | MASTER_PREPARE_IND | Character(1) | VARCHAR2(1) NOT NULL | Master Preparer Ind |
11 | ACCT_SPLIT_ALL_IND | Character(1) | VARCHAR2(1) NOT NULL | Acct Split Alloc Ind |
12 | PREPARER_ID | Character(8) | VARCHAR2(8) NOT NULL |
Preparer Identification
Prompt Table: F2_CONTACT_INFO |
13 | PRE_CLOSE_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pre-closing Balance |
14 | F2_NET_OUTLAYS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 03/15/2002 - WDR_FACTSII - For JFMIP Testing - Added to contain Net Outlays, to date, as reported by the Treasury. |
15 | CHAPTER | Character(2) | VARCHAR2(2) NOT NULL | Chapter |
16 | GOALS_FLAG | Character(1) | VARCHAR2(1) NOT NULL | GOALS Flag |
17 | APPROP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Appropriation Flag |
18 | CERTIFY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Certify Flag |
19 | BORROW_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Borrow Flag |
20 | BULK_NONBULK_IND | Character(1) | VARCHAR2(1) NOT NULL | Bulk/Non-Bulk Flag |
21 | FMS_SOURCE_IND | Character(1) | VARCHAR2(1) NOT NULL | FMS Source Indicator |
22 | OMB_SOURCE_IND | Character(1) | VARCHAR2(1) NOT NULL | OMB Source Indicator |
23 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: USD |