OPEN_LIAB_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 | REPORT_ID | Character(8) | VARCHAR2(8) NOT NULL | Report Identifier |
| 5 | AS_OF_DATE | Date(10) | DATE NOT NULL |
As of Date
Default Value: %date |
| 6 | AS_OF_DT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
As Of Date used for Open Liability Reports.
10/16/2002 - Removed Due Date from available Translates.
A=Accounting Date D=Due Date I=Invoice Date Default Value: A |
| 7 | BUSINESS_UNIT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Option
A=All Business Units V=Specific Business Unit Default Value: V |
| 8 | VENDOR_SELECT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Selection option
A=Select All Suppliers S=Specify Supplier(s) Default Value: A |
| 9 | UNREC_LIAB_IND | Character(1) | VARCHAR2(1) NOT NULL |
Include Unrecorded Liabilities
Y/N Table Edit Default Value: N |
| 10 | APAGING_CYCLE_ID | Character(5) | VARCHAR2(5) NOT NULL |
Aging Cycle ID
Prompt Table: AP_AGING_CYCLE |
| 11 | CURRENCY_OPTION4 | Character(1) | VARCHAR2(1) NOT NULL |
Currency option field
B=Base Currency S=Selected Foreign Currency T=Transaction Currency Default Value: B |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURR_TXN_VW |
| 13 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: RT_TYPE_TBL |
| 14 | CUR_EFFDT | Date(10) | DATE | Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header. |
| 15 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 16 | DAY_INCREMENT1 | Signed Number(4,0) | DECIMAL(3) NOT NULL | Day Increment 1 |
| 17 | DAY_INCREMENT2 | Signed Number(4,0) | DECIMAL(3) NOT NULL | Day Increment 2 |
| 18 | APAGING_AGE_BUCKET | Number(3,0) | SMALLINT NOT NULL | Aging Category |
| 19 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 20 | FIELDNAME_ACCTDATE | Character(18) | VARCHAR2(18) NOT NULL | Accounting Date field name |
| 21 | INCREMENT1_DT | Date(10) | DATE | Increment 1 Date |
| 22 | INCREMENT2_DT | Date(10) | DATE | Increment 2 Date |
| 23 | INCLUDE_DRAFT | Character(1) | VARCHAR2(1) NOT NULL |
Include Unmatured Drafts Paid
Y/N Table Edit Default Value: N |
| 24 | INCLUDE_DISCOUNT | Character(1) | VARCHAR2(1) NOT NULL | Include Available Discount |
| 25 | BASIS_DT_AGE | Character(1) | VARCHAR2(1) NOT NULL |
Aging Basis Date
N=Net Due Date S=Scheduled Pay Date |
| 26 | FIELDVAL1 | Character(30) | VARCHAR2(30) NOT NULL | Field Value 1 |