GL_SEG_VAL_INTF(SQL Table) |
Index Back |
|---|---|
GL Segment Values InterfaceUsed by the FAH to PS Integration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VALUE_SET_CODE | Character(60) | VARCHAR2(60) NOT NULL | Fusion Value Set Code |
| 2 | SEG_VALUE | Character(25) | VARCHAR2(25) NOT NULL | Segment Value |
| 3 | START_DT | Date(10) | DATE | Start Date |
| 4 | END_DT | Date(10) | DATE | End Date |
| 5 | SUMMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Summary Flag
Default Value: N |
| 6 | ENABLED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Enabled |
| 7 | ACCOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Identifies a category of accounts that appears on the balance sheet or income statement of the enterprise. Each general ledger account (ACCOUNT) is associated with an account type (also called a ""monetary account type""). PeopleSoft delivers standard account types such as asset, liability, expense, and revenue. |
| 8 | ALLOW_POSTING | Character(1) | VARCHAR2(1) NOT NULL |
Allow Posting
Default Value: Y |
| 9 | ALLOW_BUDGETING | Character(1) | VARCHAR2(1) NOT NULL |
Allow Budgeting
Default Value: N |
| 10 | 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.
Default Value: N |
| 11 | RECONCILE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Reconcile Flag |
| 12 | FINANCIAL_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | Financial Category |
| 13 | DESCR_ENG | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 14 | DESCR_ARA | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 15 | DESCR_CZE | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 16 | DESCR_GER | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 17 | DESCR_DAN | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 18 | DESCR_ESP | Character(30) | VARCHAR2(30) NOT NULL | Spanish |
| 19 | DESCR_GRK | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 20 | DESCR_FRA | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 21 | DESCR_CFR | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 22 | DESCR_CRO | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 23 | DESCR_HUN | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 24 | DESCR_ITA | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 25 | DESCR_HEB | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 26 | DESCR_JPN | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 27 | DESCR_KOR | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 28 | DESCR_DUT | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 29 | DESCR_POL | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 30 | DESCR_POR | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 31 | DESCR_NOR | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 32 | DESCR_ROM | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 33 | DESCR_RUS | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 34 | DESCR_SVE | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 35 | DESCR_FIN | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 36 | DESCR_SLK | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 37 | DESCR_SLV | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 38 | DESCR_THA | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 39 | DESCR_TUR | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 40 | DESCR_ZHS | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |
| 41 | DESCR_ZHT | Character(30) | VARCHAR2(30) NOT NULL | Used in the Chartfield to Fusion integration. This field stores the chartfield description for a specific language. |