FLIST_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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 4 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 5 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 6 | JRNL_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Journal Type |
| 7 | JRNL_CODE | Character(8) | VARCHAR2(8) NOT NULL | Journal Code |
| 8 | 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. |
| 9 | ACCT_DATE | Date(10) | DATE | ACCT_DATE |
| 10 | 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. |
| 11 | 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. |
| 12 | DOC_SEQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status |
| 13 | BUSINESS_UNIT_GRP | Character(5) | VARCHAR2(5) NOT NULL | Group Business Unit |
| 14 | LEDGER_GRP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 15 | LEDGER_GROUP_GRP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group Group |
| 16 | DOC_TYPE_GRP | Character(8) | VARCHAR2(8) NOT NULL | Document Type Group |
| 17 | ACCT_DATE_GRP | Date(10) | DATE | Accounting Date Group |
| 18 | SELECT_CLAUSE_LONG | Long Character(4000) | CLOB | Select Clause |
| 19 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |
| 20 | FLDVALUE1 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 21 | FLDVALUE2 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 22 | FLDVALUE3 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 23 | FLDVALUE4 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 24 | FLDVALUE5 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 25 | FLDVALUE6 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 26 | FLDVALUE7 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 27 | FLDVALUE8 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 28 | FLDVALUE9 | Character(30) | VARCHAR2(30) NOT NULL | Field Value 9 |
| 29 | FLDVALUE10 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 30 | FLDVALUE11 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 31 | FLDVALUE12 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 32 | FLDVALUE13 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 33 | FLDVALUE14 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 34 | FLDVALUE15 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 35 | FLDVALUE16 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 36 | FLDVALUE17 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 37 | FLDVALUE18 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 38 | FLDVALUE19 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 39 | FLDVALUE20 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 40 | FLDVALUE21 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 41 | FLDVALUE22 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 42 | FLDVALUE23 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 43 | FLDVALUE24 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 44 | FLDVALUE25 | Character(30) | VARCHAR2(30) NOT NULL | FldVal |
| 45 | DATEVAL1 | Date(10) | DATE | DateVal1 |
| 46 | DATEVAL2 | Date(10) | DATE | DateVal1 |
| 47 | DATEVAL3 | Date(10) | DATE | DateVal1 |
| 48 | DATEVAL4 | Date(10) | DATE | DateVal1 |
| 49 | DATEVAL5 | Date(10) | DATE | DateVal1 |
| 50 | DATEVAL6 | Date(10) | DATE | DateVal1 |
| 51 | DATETIMEVAL1 | DateTime(26) | TIMESTAMP | DateTime Value |
| 52 | DATETIMEVAL2 | DateTime(26) | TIMESTAMP | DateTime Value |
| 53 | DATETIMEVAL3 | DateTime(26) | TIMESTAMP | DateTime Value |
| 54 | DATETIMEVAL4 | DateTime(26) | TIMESTAMP | DateTime Value |
| 55 | DATETIMEVAL5 | DateTime(26) | TIMESTAMP | DateTime Value |
| 56 | TIMEVAL1 | Time(15) | TIMESTAMP | Time Value |
| 57 | TIMEVAL2 | Time(15) | TIMESTAMP | Time Value |
| 58 | TIMEVAL3 | Time(15) | TIMESTAMP | Time Value |
| 59 | TIMEVAL4 | Time(15) | TIMESTAMP | Time Value |
| 60 | TIMEVAL5 | Time(15) | TIMESTAMP | Time Value |
| 61 | FLDNUMVAL1 | Number(20,0) | DECIMAL(20) NOT NULL | Fld Num1 |
| 62 | FLDNUMVAL2 | Number(20,0) | DECIMAL(20) NOT NULL | Fld Num1 |
| 63 | FLDNUMVAL3 | Number(20,0) | DECIMAL(20) NOT NULL | Fld Num1 |
| 64 | FLDNUMVAL4 | Number(20,0) | DECIMAL(20) NOT NULL | Fld Num1 |
| 65 | FLDNUMVAL5 | Number(20,0) | DECIMAL(20) NOT NULL | Fld Num1 |
| 66 | FLDNUMVAL6 | Number(20,0) | DECIMAL(20) NOT NULL | Fld Num1 |
| 67 | FLDNUMVAL7 | Number(20,0) | DECIMAL(20) NOT NULL | Fld Num1 |
| 68 | FLDNUMVAL8 | Number(20,0) | DECIMAL(20) NOT NULL | Fld Num1 |
| 69 | FLDNUMVAL9 | Number(20,0) | DECIMAL(20) NOT NULL | Fld Num1 |