EX_PY_ACK_AET(SQL Table) |
Index Back |
|---|---|
State record - EX_PYACKSUBState record - EX_PYACKSUB |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | MONETARY_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account. |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | EX_DOC_ID | Character(10) | VARCHAR2(10) NOT NULL | Documentation ID |
| 7 | EX_DOC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Identifies Expenses Document Type
A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization |
| 8 | EX_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number |
| 9 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 10 | GROSSUP | Character(1) | VARCHAR2(1) NOT NULL | Gross Up Indicator |
| 11 | SEPCHK | Number(1,0) | SMALLINT NOT NULL | Separate Check Indicator |
| 12 | ACCEPTANCE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Acceptance Message Status
R=Message Rejected T=Message Taken |
| 13 | REJECTED_REASON | Character(2) | VARCHAR2(2) NOT NULL |
Rejected Reason
01=Invalid Earnings Code 02=Invalid Empl. ID or Empl. Rec# 03=Invalid Currency Code 04=Problem Loading Transaction 05=Transaction Already Exist 06=Other line(s) rejected. |
| 14 | DATE_ACKNOWLEDGE | DateTime(26) | TIMESTAMP | Acknowledgment Datetime stamp |