EMPLIDBENEFIT_PLANSP_IDMSG_NBRO=Post-Tax
R=Pre-Tax
CNL=Cancel Item
CRT=Create Open Item
GBA=Goal Balance Attained
PAY=Pay an Item
REV=Reversal of Payment
RFD=Refund Item
E=Error
N=No Errors
Default Value: N
PA_SP_MSG_HDR(SQL Table) |
Index Back |
|---|---|
Service Purchase Int. MessagesService Purchase Integration Message Log Header. This stores the message data that was sent and received by AR and Pensions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 3 | SP_ID |
Number(11,0) | DECIMAL(11) NOT NULL | Service Purchase ID |
| 4 | MSG_NBR |
Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 5 | INSTALL_NBR | Number(2,0) | SMALLINT NOT NULL | Installation Number for Service Purchase Installment Payments. |
| 6 | DUE_DT | Date(10) | DATE | Expected Birth Date |
| 7 | SP_AMT | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Amount sent to AR for Service Purchase processing to create open items in AR. |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | ACCOUNTING_DT | Date(10) | DATE | Accounting Date |
| 10 | EACCT_TRAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Tax Type of Pension amounts.
O=Post-Tax R=Pre-Tax |
| 11 | SP_MSG_CD | Character(3) | VARCHAR2(3) NOT NULL |
Service Purchase Message Codes to indicate purpose of integration message.
CNL=Cancel Item CRT=Create Open Item GBA=Goal Balance Attained PAY=Pay an Item REV=Reversal of Payment RFD=Refund Item |
| 12 | ERROR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Error Status used to display status of communication between Pensions and Financials Accounts Receivables for Service Purchase functionality.
E=Error N=No Errors Default Value: N |