FS_BP_ABDA_AET(SQL Table) |
Index Back |
|---|---|
Budget Atrribute AttributesThe record stores the attributes from PS_KK_BD_ATTRIB & PS_KK_BD_ATTRIB_BP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CNTRL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control Option
0=Control 1=Tracking w/ Budget 2=Track w/o Budget 3=Default from Higher Level 4=Control Initial Document Default Value: 3 |
| 3 | DFLT_TOLR | Character(1) | VARCHAR2(1) NOT NULL |
Default Tolerance
Y/N Table Edit Default Value: Y |
| 4 | TOLERANCE | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | Tolerance Percent |
| 5 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | End Date |
| 7 | BUDGET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Status
0=Open 1=Closed 2=Hold 3=Default |
| 8 | KK_DERIVE_DATES | Character(1) | VARCHAR2(1) NOT NULL |
Derive Cumulative Date Range
0=Derive Yes 1=Derive No 2=Default Default Value: 2 |
| 9 | KK_CUM_CAL_ID | Character(2) | VARCHAR2(2) NOT NULL |
Cumulative Calendar
Prompt Table: CAL_BP_VW |
| 10 | KK_CUM_BEGIN_DT | Date(10) | DATE | Begin Date |
| 11 | KK_CUM_END_DT | Date(10) | DATE | End Date |