PROCESS_INSTANCEFS_BP_XLAT_AET(SQL Table) |
Index Back |
|---|---|
BP - Translate CF's State RecThe following state record is used in the FS Budget Processor (FS_BP). This state record contains the state record work fields for the ChartField translation sub-program. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SUBTYPE | Character(10) | VARCHAR2(10) NOT NULL | Ruleset |
| 3 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 4 | SQLROWS_XCFTAO | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 5 | TRANSLATE_ERR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Translate Error Flag |
| 6 | CONTROL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | This flag in used to desginate an Account or Alternate Account as Control Accounts and Control Alternate Accounts, respectively. |
| 7 | SUBTYPE_SAVE | Character(10) | VARCHAR2(10) NOT NULL | Ruleset |