FT_LAGDAYS_AET

(SQL Table)
Index Back

Document Sequencing State Rec

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PSFT_PRODUCT Character(2) VARCHAR2(2) NOT NULL PeopleSoft Product
3 BU_VAL_OPTN Character(1) VARCHAR2(1) NOT NULL Business Unit value option
0=All Values
1=by Range
2=in Record

Default Value: 0

4 FROM_BU Character(5) VARCHAR2(5) NOT NULL From Buyer
5 TO_BU Character(5) VARCHAR2(5) NOT NULL To Business Unit
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 DT_VAL_OPTN Character(1) VARCHAR2(1) NOT NULL Date Value Option
0=All Dates
1=by Range
2=in Record

Default Value: 0

8 FROM_DT Date(10) DATE From Date

Default Value: %date

9 TO_DT Date(10) DATE To Date

Default Value: %date

10 TRANSACTION_TYPE Character(3) VARCHAR2(3) NOT NULL Transaction Type
11 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
12 FIELDNAME_ACCTDATE Character(18) VARCHAR2(18) NOT NULL Accounting Date field name
13 RETURN_CD Character(1) VARCHAR2(1) NOT NULL Return Code
0=Return OK
1=Return error