AR_RPT_LINE

(SQL Table)
Index Back

Report Template Line info.

  • Parent record: AR_RPT_TEMPLATE
  • # 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