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 |