RECV_ACCR_AET(SQL Table) |
Index Back |
|---|
| # | 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 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 7 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | Entry Event |
| 8 | ORIGIN_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 9 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL | Origin |
| 10 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 11 | RCPT_RUN_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Run Options
B=Business Units O=Origin R=Receiver U=All Business Units |
| 12 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 13 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 14 | APPL_JRNL_ID_RACC | Character(10) | VARCHAR2(10) NOT NULL | Receipt Accrual |
| 15 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 16 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 17 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 18 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 19 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 20 | 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. " |
| 21 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 22 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success |
| 23 | PROCESS_ORIGIN | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Process Origin in Other P=Process Origin in PeopleSoft |
| 24 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 25 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 26 | ACCR_PERIOD | Number(3,0) | SMALLINT NOT NULL | Accrual Period |
| 27 | ACCR_PERIOD1 | Number(3,0) | SMALLINT NOT NULL | Accrual Period |
| 28 | ACCRUAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Accrual Year |
| 29 | ACCRUAL_YEAR1 | Number(4,0) | SMALLINT NOT NULL | Accrual Year |
| 30 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 31 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 32 | DEFAULT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Default Options
D=Default O=Override Default Value: D |
| 33 | COMMITMENT_CNTL_PO | Character(1) | VARCHAR2(1) NOT NULL | Commitment Control on PO |
| 34 | COMMITMENT_RECVACC | Character(1) | VARCHAR2(1) NOT NULL | Receipt Accrual |
| 35 | EE_PO | Character(1) | VARCHAR2(1) NOT NULL |
Entry Event Options PO
N=No EE O=Optional R=Required |
| 36 | NEXT_PERIOD | Number(3,0) | SMALLINT NOT NULL | The Next Highest Period |
| 37 | NEXT_FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year for Next Reversals |
| 38 | CF_INH_OBJ | Character(254) | VARCHAR2(254) NOT NULL | State Record field used to hold the concatenated Charfield Inheritance Setid/Group object. |
| 39 | BEGIN_DT_NEXT_PD | Date(10) | DATE | Next Period Begin Date |
| 40 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 41 | WORKBENCH_ID | Character(10) | VARCHAR2(10) NOT NULL | WorkBench ID |
| 42 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |