GVT_BETC_LNG(SQL Table) |
Index Back |
|---|---|
BETCRelated Language record for GVT_BETC_DEFN. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL | TAS Agency Identifier | |
| 2 | Character(4) | VARCHAR2(4) NOT NULL | Main Account | |
| 3 | Character(2) | VARCHAR2(2) NOT NULL | Sub-Level Prefix | |
| 4 | Character(3) | VARCHAR2(3) NOT NULL | Allocation Transfer Agency | |
| 5 | Character(4) | VARCHAR2(4) NOT NULL | Begin Period of Availability | |
| 6 | Character(4) | VARCHAR2(4) NOT NULL | End Period of Availability | |
| 7 | Character(1) | VARCHAR2(1) NOT NULL |
Availability Type
A=Treasury Central Summ Account C=Cancelled F=Clearing/Suspense Account M=Merged Surplus Account X=No-Year Account |
|
| 8 | Character(3) | VARCHAR2(3) NOT NULL | Sub Account | |
| 9 | Character(8) | VARCHAR2(8) NOT NULL | Business Event Type Code | |
| 10 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 11 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |