REPORT_AET

(SQL Table)
 Index Back

State for Rptg Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 AE_EXISTS Character(1) VARCHAR2(1) NOT NULL Exists
4 RPTG_RECONCILE Character(1) VARCHAR2(1) NOT NULL For Reconcile
5 RPTG_APPL_ID Character(3) VARCHAR2(3) NOT NULL Reporting Application
AP=Accounts Payable
AR=Accounts Receivable
BI=Billing
EX=Expenses
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
8 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
9 ACC_SETID Character(5) VARCHAR2(5) NOT NULL Account SetID
10 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
11 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
12 DOC_TYPE_SETID Character(5) VARCHAR2(5) NOT NULL Document Type SetId
13 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge
14 START_NUMBER Number(18,0) DECIMAL(18) NOT NULL Starting Number
15 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
16 NUMBER_OF_PERIODS Number(3,0) SMALLINT NOT NULL Periods in a Year
17 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
18 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
19 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
20 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.
21 JRNL_TYPE Character(2) VARCHAR2(2) NOT NULL Journal Type
22 JRNL_CODE Character(8) VARCHAR2(8) NOT NULL Journal Code
23 FIELDNAME_BU Character(18) VARCHAR2(18) NOT NULL Business Unit Field Name
24 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • 25 RECNAME_XREF Character(15) VARCHAR2(15) NOT NULL Cross Reference Table
    26 RECNAME_TMP Character(15) VARCHAR2(15) NOT NULL Record (Table) Name
    27 FIRST_TIME Character(1) VARCHAR2(1) NOT NULL First time through process
    28 SQL_STMT Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.
    29 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    30 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    31 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    32 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    33 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    34 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
    35 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
    36 FISCAL_YEAR_WRK Number(4,0) SMALLINT NOT NULL Fiscal Year
    37 BALANCE_FWD_SW Character(1) VARCHAR2(1) NOT NULL A flag that indicates (Y or N) whether or not the YTD balance for an account type or for a statistical account will be rolled forward to Period 0 of the next year.
    N=Not Carry Forward
    O=Other
    Y=Carry Forward
    38 BUSINESS_UNIT_FROM Character(5) VARCHAR2(5) NOT NULL Business Unit From
    39 PRIOR_ACCT_PERIOD Number(3,0) SMALLINT NOT NULL Accounting Period