F2_MAF_TBL(SQL Table) |
Index Back |
|---|---|
FACTS II MAF |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(18) | VARCHAR2(18) NOT NULL | MAF Treasury Symbol | |
| 2 | Number(3,0) | SMALLINT NOT NULL | MAF Sequence Number | |
| 3 | 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 |