ACCT_DEF_SETIDPrompt Table: SP_SETID_NONVW
ACCTG_DEF_NAMELANGUAGE_CDCA_JGEN_DEFN_LG(SQL View) |
Index Back |
|---|---|
CA Journal Generator Defn RLR |
| SELECT setid , acctg_def_name , language_cd , descr FROM PS_JGEN_DEFN_LANG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCT_DEF_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Acctg Definition SetID
Prompt Table: SP_SETID_NONVW |
| 2 | ACCTG_DEF_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Defines the content and source of the accounting transactions that the Journal Generator program of PeopleSoft General Ledger uses to create journal entries. Accounting transactions are populated by PeopleSoft applications or third-party systems for input to the general ledger. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |