DCSQ_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	DOC_SEQ_BU	Character(1)	VARCHAR2(1) NOT NULL	Business Unit Doc Seq Option
3	MSGNUM	Number(5,0)	INTEGER NOT NULL	Message Number
4	MSGPARM1	Character(30)	VARCHAR2(30) NOT NULL	Message Parm 1
5	MSGPARM2	Character(30)	VARCHAR2(30) NOT NULL	Message Parm 2
6	FIELDNAME_LEDGER	Character(18)	VARCHAR2(18) NOT NULL	Ledger Field Name
7	FIELDNAME_BU	Character(18)	VARCHAR2(18) NOT NULL	Business Unit Field Name
8	FIELDNAME_LEDGRP	Character(18)	VARCHAR2(18) NOT NULL	Ledger Group Fieldname
9	ORDER_BY_LEDGER	Character(36)	VARCHAR2(36) NOT NULL	Order by Ledger
10	LED_GROUP_BY	Character(19)	VARCHAR2(19) NOT NULL	Ledger Group By
11	EXIST_FLD_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	Field LEDGER exits
12	EXIST_FLD_LEDGRP	Character(1)	VARCHAR2(1) NOT NULL	Field LEDGER_GROUP exists
13	BY_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	By Ledger
14	BY_LEDGRP	Character(1)	VARCHAR2(1) NOT NULL	By Ledger Group
15	DEFAULT_LEDGER_GRP	Character(1)	VARCHAR2(1) NOT NULL	Jrnl Generator Dflt Ledger Grp
16	LED_GRP_DEFAULT	Character(10)	VARCHAR2(10) NOT NULL	Default Journal Generator Ledger Group of a Business Unit
17	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
18	BU_FOUND	Character(1)	VARCHAR2(1) NOT NULL	Business Unit Found
19	LEDGER_FOUND	Character(1)	VARCHAR2(1) NOT NULL	Ledger Found
20	LEDGRP_FOUND	Character(1)	VARCHAR2(1) NOT NULL	Ledger Group Found
21	DOC_TYPE_FOUND	Character(1)	VARCHAR2(1) NOT NULL	Document Type Definition Found
22	RANGE_FOUND	Character(1)	VARCHAR2(1) NOT NULL	Range Found Default Value: N
23	LAST_NBR_FOUND	Character(1)	VARCHAR2(1) NOT NULL	Last Number Found Default Value: N
24	DUP_NBR_FOUND	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Number Found Default Value: N
25	DOC_TYPE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Document Type SetId
26	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes
27	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag
28	PREV_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Previous Business Unit
29	PREV_LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Previous Ledger
30	PREV_LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Previous Ledger Group
31	PREV_DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Previous Document Type
32	PREV_DOCTYPE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Document Type SetId
33	PREV_ACCT_DATE	Date(10)	DATE	ACCT_DATE
34	PREV_BEGIN_DT	Date(10)	DATE	Begin Date
35	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
36	ROWCOUNT1	Number(12,0)	DECIMAL(12) NOT NULL	Row Count
37	ROWCOUNT2	Number(12,0)	DECIMAL(12) NOT NULL	Row Count
38	ROWCOUNT3	Number(12,0)	DECIMAL(12) NOT NULL	Row Count
39	CHANGED_BU	Character(1)	VARCHAR2(1) NOT NULL	Business Unit Changed
40	CHANGED_LEDGRP	Character(1)	VARCHAR2(1) NOT NULL	Ledger Group Changed
41	CHANGED_DT_SETID	Character(1)	VARCHAR2(1) NOT NULL	Doc Type Setid Changed
42	CHANGED_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Doc Type Changed
43	CHANGED_ACCT_DATE	Character(1)	VARCHAR2(1) NOT NULL	Accounting Date Changed
44	CHANGED_BEGIN_DT	Character(1)	VARCHAR2(1) NOT NULL	Begin Date Changed
45	SEQ_BY	Character(1)	VARCHAR2(1) NOT NULL	Sequence By C=Journal Code D=Document Type
46	IN_USE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Row in use flag
47	SEQ_RANGE_ID	Character(2)	VARCHAR2(2) NOT NULL	Sequence Range
48	SEQ_RANGE_ID1	Character(2)	VARCHAR2(2) NOT NULL	S
49	SEQ_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Document Sequencing Type A=Automatic Numbering M=Manually Entered
50	SEQ_TYPE1	Character(1)	VARCHAR2(1) NOT NULL	S
51	IN_USE_FLAG_C	Character(1)	VARCHAR2(1) NOT NULL	Journal Code in use flag
52	IN_USE_FLAG_D	Character(1)	VARCHAR2(1) NOT NULL	Document Type in use flag
53	IN_USE_FLAG_S	Character(1)	VARCHAR2(1) NOT NULL	Sequence Range in use flag
54	IN_USE_FLAG_T	Character(1)	VARCHAR2(1) NOT NULL	Journal Type in use flag
55	BEGIN_DT	Date(10)	DATE	Begin Date
56	END_DT	Date(10)	DATE	End Date
57	SEQ_NBR_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Sequence Number Prefix
58	SEQ_NBR_START	Number(12,0)	DECIMAL(12) NOT NULL	Start Sequence Number
59	SEQ_NBR_CRRNT	Number(12,0)	DECIMAL(12) NOT NULL	Current Sequence Number
60	SEQ_NBR_END	Number(12,0)	DECIMAL(12) NOT NULL	End Sequence Number
61	SEQ_NBR_LAST	Number(12,0)	DECIMAL(12) NOT NULL	Last sequence number
62	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
63	DUP_DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
64	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
65	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
66	JRNL_CODE	Character(8)	VARCHAR2(8) NOT NULL	Journal Code
67	LEDGRP_CLAUSE	Character(100)	VARCHAR2(100) NOT NULL	Ledger Group Clause
68	LEDGRP_CLAUSE1	Character(100)	VARCHAR2(100) NOT NULL	Ledger Group Clause
69	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause
70	RETURNCODE	Number(10,0)	DECIMAL(10) NOT NULL	Return Code
71	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes