VED_EDIT_AET(SQL Table) |
Index Back |
|---|---|
Vchr Edit Edit AE State Tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 3 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 4 | SELECT_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | SQL Select Count |
| 5 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 8 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 9 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 10 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 11 | DUP_INV_COMB_CODE | Number(3,0) | SMALLINT NOT NULL | Dupl Invoice Combination Code |
| 12 | DUP_INV_BUS_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit
N=No Y=Yes |
| 13 | DUP_INV_VENDOR_NUM | Character(1) | VARCHAR2(1) NOT NULL |
Vendor ID
N=No Y=Yes |
| 14 | DUP_INV_NUM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Number
N=No Y=Yes |
| 15 | DUP_INV_DT | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Date
N=No Y=Yes |
| 16 | DUP_INV_GROSS_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Gross Amount
N=No Y=Yes |
| 17 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 18 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 19 | COMBO_EDIT_TMPL | Character(10) | VARCHAR2(10) NOT NULL | Record Template |
| 20 | ALTACCT_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Enable Alternate Account |
| 21 | CHART_EDIT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Chart Edit Status
K=Errors - Cannot be saved O=ChartFields Valid R=Errors - Not Postable S=Errors - Suspense Entries |
| 22 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 23 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 24 | VCHR_APPRVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level P=Pre-Approved S=Virtual Approver W=Approval Framework |
| 25 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 26 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 27 | TTL_MERCH_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amount |
| 28 | MISC_AMT_TTL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 29 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity |
| 30 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 31 | TTL_QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity Vouchered |
| 32 | OPEN_ITEM_DESCR | Character(10) | VARCHAR2(10) NOT NULL | Describes the OpenItem key that must be specified in the reference field on journal entry panels when an open item account number is used. It appears on prompt lists, reports, and online inquiries related to an open item account in the general ledger. |
| 33 | OPEN_ITEM_EDIT_REC | Character(15) | VARCHAR2(15) NOT NULL | Specifies the name of the prompt table you want to use to validate the OpenItem search key, and applies only to OpenItem accounts in the general ledger. |
| 34 | OPEN_ITEM_EDIT_FLD | Character(18) | VARCHAR2(18) NOT NULL | Specifies the name of the field in the OpenItem Edit Record (OPEN_ITEM_EDIT_REC) to use for validating the OpenItem search key, and applies only to OpenItem accounts in the general ledger. |
| 35 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 36 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 37 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 38 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 39 | SPENDING_REGION | Character(30) | VARCHAR2(30) NOT NULL | Spending Region |
| 40 | SPNDNG_REG_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Spending Region Edit Option
1=No Edit 2=Required 3=Optional 4=Prohibited |
| 41 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 42 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 43 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 44 | OPEN_ITEM_KEY | Character(30) | VARCHAR2(30) NOT NULL | Open Item Key |
| 45 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 46 | FIELDVALUE1 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 47 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 48 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 49 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 50 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 51 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |