PROCESS_INSTANCE1=Advanced Amount
2=Advanced Amount Remaining
3=Billed Amount
4=Earned Amount
5=Unbilled Amount
6=Obligated Amount
7=Expended Amount
8=Collected Amount
9=Committed Amount
A=Apportioned Amount
AR_FEDSTMT_AET(SQL Table) |
Index Back |
|---|---|
AR Fed Cust Stmts AETAET file for the AR Federal Customer Statements app engine extract program. |
| # | 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 | 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. |
| 4 | CRSPD_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Correspondence Customer |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 6 | FROM_DT | Date(10) | DATE | From Date |
| 7 | TO_DT | Date(10) | DATE | To Date |
| 8 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 9 | 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. " |
| 10 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 11 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 12 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 13 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 14 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 15 | 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. |
| 16 | RMC18_ACCT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Reimbursable Agreement Amount
1=Advanced Amount 2=Advanced Amount Remaining 3=Billed Amount 4=Earned Amount 5=Unbilled Amount 6=Obligated Amount 7=Expended Amount 8=Collected Amount 9=Committed Amount A=Apportioned Amount |
| 17 | AE_WHERE | Character(254) | VARCHAR2(254) NOT NULL | AE Generic Where Clause |
| 18 | AE_WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Dynamic where clause |
| 19 | AE_WHERE_CF | Long Character(1024) | VARCHAR2(1024) | AE CF Where Clause |
| 20 | AE_BIND_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Value |
| 21 | COUNT_1 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |
| 22 | COUNT_2 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |
| 23 | TOT_CONTR_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Gross value |
| 24 | AE_EXISTS | Character(1) | VARCHAR2(1) NOT NULL | Exists |