FT_DOCSQ_AET

(SQL Table)
Index Back

Document Sequencing State Rec

Interface state record between calling programs and doc sequencing program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Broadcast
D=log Deletedsequence number
E=Check doc seq enable option
G=Generate sequence number
R=Reset for 1099C Submission
X=Deleted from 1099C Prep Table
3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
5 RECNAME_BASE Character(15) VARCHAR2(15) NOT NULL Base record name
6 FIELDNAME_BU_GL Character(18) VARCHAR2(18) NOT NULL Business Unit GL Field Name
7 FIELDNAME_ACCTDATE Character(18) VARCHAR2(18) NOT NULL Accounting Date field name
8 WHERE_OPTION Character(1) VARCHAR2(1) NOT NULL Where Option
B=Both
N=None
P=Process Instance
V=By Value
9 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
10 DEBUG_SW Character(1) VARCHAR2(1) NOT NULL Debug Swt
11 DOC_SEQ Character(1) VARCHAR2(1) NOT NULL Enable Document Sequencing

Default Value: Y

12 RETURN_CD Character(1) VARCHAR2(1) NOT NULL Return Code
0=Return OK
1=Return error

Default Value: 0

13 SELECT_PARM_LONG Long Character(4000) CLOB SELECT_PARM_LONG
14 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
15 MSGNUM Number(5,0) INTEGER NOT NULL Message Number
16 MSGPARM1 Character(30) VARCHAR2(30) NOT NULL Message Parm 1
17 MSGPARM2 Character(30) VARCHAR2(30) NOT NULL Message Parm 2