PAYMENT_TBL_VW2(SQL View) |
Index Back |
|---|---|
Payment Item Type VW |
| SELECT a.business_unit ,a.common_id ,a.sa_id_type ,a.common_id ,a.ext_org_id ,a.item_type ,a.payment_id_nbr ,a.payment_amt ,a.strm ,a.currency_cd ,a.rate_mult ,a.rate_div ,a.cur_rt_type ,a.orignl_item_amt ,a.orignl_currency_cd ,a.third_party ,a.credit_card_nbr ,a.credit_card_type ,a.credit_card_exp_dt ,a.credit_card_issuer ,a.credit_card_holder ,a.fed_rsrv_bank_id ,a.SSF_BNK_ACCT_NUM ,a.bank_acct_typ ,a.bank_acct_name ,a.check_num_sf ,a.disbursement_date ,a.bank_cd ,A.INVOICE_ID ,A.SSF_RESTRICT_INV FROM PS_PAYMENT_TBL a WHERE a.sf_reversal_ind = 'N' AND a.sa_id_type = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 3 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 5 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 6 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 7 | PAYMENT_ID_NBR |
Number(12,0) | DECIMAL(12) NOT NULL | Payment ID Nbr |
| 8 | PAYMENT_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Payment Amount |
| 9 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 12 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 13 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 14 | ORIGNL_ITEM_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Item Amount |
| 15 | ORIGNL_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | THIRD_PARTY | Character(30) | VARCHAR2(30) NOT NULL | Third Party Check Name |
| 17 | CREDIT_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | Card Number |
| 18 | CREDIT_CARD_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Credit Card Type
AE=American Express DC=Diners' Club DI=Diners Club MC=MasterCard VI=VISA |
| 19 | CREDIT_CARD_EXP_DT | Date(10) | DATE | Expiration Date |
| 20 | CREDIT_CARD_ISSUER | Character(20) | VARCHAR2(20) NOT NULL | Credit Card Issuer |
| 21 | CREDIT_CARD_HOLDER | Character(30) | VARCHAR2(30) NOT NULL | Credit Card Holder |
| 22 | FED_RSRV_BANK_ID | Character(10) | VARCHAR2(10) NOT NULL | Federal Reserve Bank ID |
| 23 | SSF_BNK_ACCT_NUM | Character(44) | VARCHAR2(44) NOT NULL | Bank Account Number |
| 24 | BANK_ACCT_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Bank Account Type
C=Checking S=Savings |
| 25 | BANK_ACCT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Bank Account Holder Name |
| 26 | CHECK_NUM_SF | Character(30) | VARCHAR2(30) NOT NULL | Check Nbr |
| 27 | DISBURSEMENT_DATE | Date(10) | DATE | Disbursement Date |
| 28 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank ID |
| 29 | INVOICE_ID | Character(22) | VARCHAR2(22) NOT NULL | Invoice Number |
| 30 | SSF_RESTRICT_INV | Character(1) | VARCHAR2(1) NOT NULL | This field indicates that the payment will be held until an invoice is provided. |