COMPANY_TBL_GL(SQL Table) |
Index Back |
|---|---|
Company Tbl GL dataContains the General Ledger Fields associated with a Company |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GL_FWT | Character(35) | VARCHAR2(35) NOT NULL |
U.S. GL Acct#-FWT
Prompt Table: GL_ACCOUNT_VW |
| 4 | GL_FICA_EE_OASDI | Character(35) | VARCHAR2(35) NOT NULL |
U.S. GL Acct#-FICA OASDI EE
Prompt Table: GL_ACCOUNT_VW |
| 5 | GL_FICA_EE_MED | Character(35) | VARCHAR2(35) NOT NULL |
U.S. GL Acct#-FICA Medicare EE
Prompt Table: GL_ACCOUNT_VW |
| 6 | GL_FICA_ER_OASDI | Character(35) | VARCHAR2(35) NOT NULL |
U.S. GL Acct#-FICA OASDI ER
Prompt Table: GL_ACCOUNT_VW |
| 7 | GL_FICA_ER_MED | Character(35) | VARCHAR2(35) NOT NULL |
U.S. GL Acct#-FICA Medicare ER
Prompt Table: GL_ACCOUNT_VW |
| 8 | GL_FUT | Character(35) | VARCHAR2(35) NOT NULL |
U.S. GL Acct#-FUT
Prompt Table: GL_ACCOUNT_VW |
| 9 | GL_EIC | Character(35) | VARCHAR2(35) NOT NULL |
U.S. GL Acct#-EIC
Prompt Table: GL_ACCOUNT_VW |
| 10 | GL_NET_PAY | Character(35) | VARCHAR2(35) NOT NULL |
GL Acct#-Net Pay
Prompt Table: GL_ACCOUNT_VW |
| 11 | GL_DIR_DEPOSITS | Character(35) | VARCHAR2(35) NOT NULL |
GL Acct#-Direct Deposits
Prompt Table: GL_ACCOUNT_VW |
| 12 | GL_GARN_CMPY_FEE | Character(35) | VARCHAR2(35) NOT NULL |
Garnishment Company Fee
Prompt Table: GL_ACCOUNT_VW |
| 13 | GL_FICA_EXP_OASDI | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FICA OASDI Exp |
| 14 | GL_FICA_EXP_MED | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FICA Medicre Exp |
| 15 | GL_FUT_EXPENSE | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FUT Expense |
| 16 | GL_SUT_EXPENSE | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-SUT Expense |
| 17 | GL_SDI_EXPENSE | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-SDI Expense |
| 18 | GL_VDI_EXPENSE | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-VDI Expense |
| 19 | GL_LCL_EXP | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-Local Expense |
| 20 | PY_DIST_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Distribute Option
Y/N Table Edit Default Value: N |
| 21 | GL_FICA_ADDL_MED | Character(35) | VARCHAR2(35) NOT NULL |
Additional Medicare
Prompt Table: GL_ACCOUNT_VW |