CNAO_JRNL_S_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Default Value: ZHS

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
5 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
6 LEDGER_CODE Character(10) VARCHAR2(10) NOT NULL Ledger Code
7 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code
8 BK_CD_LIST Character(254) VARCHAR2(254) NOT NULL Book Code List
9 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
10 PERIOD Number(3,0) SMALLINT NOT NULL Period
11 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
12 LEDGER_SETID Character(5) VARCHAR2(5) NOT NULL LEDGER_SETID
13 RULE_SETID Character(5) VARCHAR2(5) NOT NULL Rule Setid
14 ACCOUNT_SETID Character(5) VARCHAR2(5) NOT NULL Account SETID
15 DOC_TYPE_SETID Character(5) VARCHAR2(5) NOT NULL Document Type SetId
16 CATEGORY_SETID Character(5) VARCHAR2(5) NOT NULL Category SetID
17 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
18 RECNAME_JRNL_LN Character(15) VARCHAR2(15) NOT NULL Journal Line
19 CUR_RT_TYPE_DFLT Character(5) VARCHAR2(5) NOT NULL Exchange Rate Type Default
20 FS_CHK_ENABLED Character(1) VARCHAR2(1) NOT NULL Check box for Enable/Disable
N=Disabled
Y=Enabled
21 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
22 ALTACCT_OPTN Character(1) VARCHAR2(1) NOT NULL Enable Alternate Account
23 FS_EVENT_CODE Character(15) VARCHAR2(15) NOT NULL Event code
24 SUBSDRY_ITM_TP Character(4) VARCHAR2(4) NOT NULL Subsidiary Item Type
C=Customer
D=Department
E=Employee
S=Supplier
25 SUBSDRY_ITM_ID Character(5) VARCHAR2(5) NOT NULL Subsidiary Item ID
26 SUBSDRY_CUST Character(5) VARCHAR2(5) NOT NULL Customer Subsidiary ID
27 SUBSDRY_DEPT Character(5) VARCHAR2(5) NOT NULL Department Subsidiary ID
28 SUBSDRY_EMPL Character(5) VARCHAR2(5) NOT NULL Subsidiary Employee
29 SUBSDRY_SUPL Character(5) VARCHAR2(5) NOT NULL Subsidiary Supplier
30 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
31 AUDIT_LOG_SELECT Character(254) VARCHAR2(254) NOT NULL Audit Log SELECT Clause
32 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
33 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
34 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
35 AUDLOG_DTTM DateTime(26) TIMESTAMP Date and time that the event occurred.
36 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

Default Value: 9999

37 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

38 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
39 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success

Default Value: N

40 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler

Default Value: N

41 AUDIT_LOG_FROM Character(254) VARCHAR2(254) NOT NULL Audit Log FROM Clause
42 AUDIT_LOG_WHERE Character(254) VARCHAR2(254) NOT NULL Audit Log WHERE Clause
43 TRAN_AMT_SELECT Character(254) VARCHAR2(254) NOT NULL Tran Amt SELECT Clause
44 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
45 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
46 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
47 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
48 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
49 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause