AR_RPT_LINE(SQL Table) | 
Index Back | 
|---|---|
Report Template Line info. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | 
SetID
 Prompt Table: SP_SETID_NONVW  | 
|
| 2 | Character(10) | VARCHAR2(10) NOT NULL | Template Name | |
| 3 | Character(10) | VARCHAR2(10) NOT NULL | 
Report Version
 Prompt Table: AR_RPT_VERSION  | 
|
| 4 | Date(10) | DATE NOT NULL | 
Effective Date
 Default Value: %date  | 
|
| 5 | Character(10) | VARCHAR2(10) NOT NULL | Part | |
| 6 | Character(3) | VARCHAR2(3) NOT NULL | Section | |
| 7 | 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  |