AR_RPT_LINE(SQL Table) |
Index Back |
---|---|
Report Template Line info. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
2 | TEMPLATE_NAME | Character(10) | VARCHAR2(10) NOT NULL | Template Name |
3 | REPORT_VERSION | Character(10) | VARCHAR2(10) NOT NULL |
Report Version
Prompt Table: AR_RPT_VERSION |
4 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
5 | REPORT_PART_NUMBER | Character(10) | VARCHAR2(10) NOT NULL | Part |
6 | REPORT_SECTION_NBR | Character(3) | VARCHAR2(3) NOT NULL | Section |
7 | REPORT_LINE_NUMBER | Character(3) | VARCHAR2(3) NOT NULL | Line |
8 | REPORT_PART_NAME | Character(200) | VARCHAR2(200) NOT NULL | Part Name |
9 | REPORT_SECTN_NAME | Character(200) | VARCHAR2(200) NOT NULL | Section Name |
10 | REPORT_LINE_NAME | Character(200) | VARCHAR2(200) NOT NULL | Line Name |
11 | DATE_CRITERIA | Character(1) | VARCHAR2(1) NOT NULL |
Date Criteria
A=None B=Previous Fiscal Year C=Reported Fiscal Year D=Reported Accounting Period Default Value: A |
12 | DISPLAY_COUNT | Character(1) | VARCHAR2(1) NOT NULL |
Display Count
Default Value: N |
13 | DISPLAY_AMOUNT | Character(1) | VARCHAR2(1) NOT NULL |
Display Amount
Default Value: N |
14 | SEL_ENTRY_USE_ID | Character(1) | VARCHAR2(1) NOT NULL |
Select Entry Use Ids
N=Unselected Y=Selected Default Value: N |
15 | EXCL_ENTRY_USE_ID | Character(1) | VARCHAR2(1) NOT NULL |
Exclude Entry Use Ids
N=Unselected Y=Selected Default Value: N |
16 | SEL_DELINQNCY_CD | Character(1) | VARCHAR2(1) NOT NULL |
Select Delinquency Code
N=Unselected Y=Selected Default Value: N |
17 | EXCL_DELINQNCY_CD | Character(1) | VARCHAR2(1) NOT NULL |
Exclude Delinquency Code
N=Unselected Y=Selected Default Value: N |
18 | CALCULATION | Character(1) | VARCHAR2(1) NOT NULL |
Calculation
N=Unselected Y=Selected Default Value: N |
19 | INCLD_IN_FOOTNOTE | Character(1) | VARCHAR2(1) NOT NULL |
Include in Footnotes
Y=Selected Default Value: N |
20 | SUBLINE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Subline Flag
L=Line S=Subline |
21 | AMOUNT_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Amount Sign
N=Normal R=Reversed |