BUSINESS_UNITOI_BUSET_MAP(SQL Table) |
Index Back |
|---|---|
Business unit and setid mapnBusiness unit and setid mapping record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ACCOUNT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Account SETID |
| 3 | ALTACCT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Alternate Account SetID |
| 4 | DEPT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 5 | OPRUNT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Operating Unit SetID |
| 6 | PRODUCT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Product SetID |
| 7 | FUNDCD_SETID | Character(5) | VARCHAR2(5) NOT NULL | Fund Code SetID |
| 8 | CLASSFLD_SETID | Character(5) | VARCHAR2(5) NOT NULL | Class Field SetID |
| 9 | PROGCD_SETID | Character(5) | VARCHAR2(5) NOT NULL | Program Code SetID |
| 10 | BUDGREF_SETID | Character(5) | VARCHAR2(5) NOT NULL | Budget Reference SetID |
| 11 | AFFINTR1_SETID | Character(5) | VARCHAR2(5) NOT NULL | Affiliate Intra1 SetID |
| 12 | AFFINTR2_SETID | Character(5) | VARCHAR2(5) NOT NULL | Affiliate Intra2 Setid |
| 13 | PROJECT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Project SetID |
| 14 | BOOKCD_SETID | Character(5) | VARCHAR2(5) NOT NULL | Book Code SetID |
| 15 | ADJTYPE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Adjustment Type SetID |
| 16 | STATCD_SETID | Character(5) | VARCHAR2(5) NOT NULL | Statistics Code SetID |
| 17 | CF1_SETID | Character(5) | VARCHAR2(5) NOT NULL | CF1_SETID |
| 18 | CF2_SETID | Character(5) | VARCHAR2(5) NOT NULL | CF2_SETID |
| 19 | CF3_SETID | Character(5) | VARCHAR2(5) NOT NULL | CF3_SETID |
| 20 | LEDGER_SETID | Character(5) | VARCHAR2(5) NOT NULL | LEDGER_SETID |
| 21 | BD_SCEN_SETID | Character(5) | VARCHAR2(5) NOT NULL | BD_SCEN_SETID |
| 22 | LEDGRP_SETID | Character(5) | VARCHAR2(5) NOT NULL | LEDGRP_SETID |
| 23 | PRJRESTYP_SETID | Character(5) | VARCHAR2(5) NOT NULL | PRJRESTYP_SETID |
| 24 | PRJCATG_SETID | Character(5) | VARCHAR2(5) NOT NULL | PRJCATG_SETID |
| 25 | PRJCATSUB_SETID | Character(5) | VARCHAR2(5) NOT NULL | PRJCATSUB_SETID |
| 26 | PRJANTYP_SETID | Character(5) | VARCHAR2(5) NOT NULL | PRJANTYP_SETID |
| 27 | DOCTYP_SETID | Character(5) | VARCHAR2(5) NOT NULL | DOCTYP_SETID |
| 28 | VATTXN_SETID | Character(5) | VARCHAR2(5) NOT NULL | VATTXN_SETID |
| 29 | VATUSE_SETID | Character(5) | VARCHAR2(5) NOT NULL | VATUSE_SETID |
| 30 | VATCDTAX_SETID | Character(5) | VARCHAR2(5) NOT NULL | VATCDTAX_SETID |
| 31 | ENTEVNT_SETID | Character(5) | VARCHAR2(5) NOT NULL | ENTEVNT_SETID |
| 32 | SPDTYP_SETID | Character(5) | VARCHAR2(5) NOT NULL | SPDTYP_SETID |
| 33 | SPDCHRT_SETID | Character(5) | VARCHAR2(5) NOT NULL | SPDCHRT_SETID |
| 34 | CALDEFN_SETID | Character(5) | VARCHAR2(5) NOT NULL | CALDEFN_SETID |
| 35 | JRNLCLS_SETID | Character(5) | VARCHAR2(5) NOT NULL | JRNLCLS_SETID |
| 36 | JRNLSCH_SETID | Character(5) | VARCHAR2(5) NOT NULL | JRNLSCH_SETID |
| 37 | JRNLEVNT_SETID | Character(5) | VARCHAR2(5) NOT NULL | JRNLEVNT_SETID |
| 38 | AGNLOC_SETID | Character(5) | VARCHAR2(5) NOT NULL | AGNLOC_SETID |
| 39 | SOURCE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Source SETID |
| 40 | TREE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Tree SetID |