|
SELECT A.SETID , A.CUST_ID , A.CLAIM_ID , A.PPRC_PROMO_CD , A.MERCH_TYPE , A.PAYMENT_METHOD_PL , A.TD_STATUS , A.PYMNT_ID_REF , A.BANK_CD , A.BANK_ACCT_KEY , A.VOUCHER_LINE_NUM , A.REFERENCE_NUM , A.CURRENCY_CD , A.BASE_CURRENCY , A.RT_TYPE , A.RATE_MULT , A.RATE_DIV , A.AMOUNT , A.AMOUNT_BSE , A.PAID_AMT , A.PAID_AMT_BSE , A.BUSINESS_UNIT , A.BUSINESS_UNIT_BI , A.BUSINESS_UNIT_GL , A.BUSINESS_UNIT_AP , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.ADDRESS_SEQ_NUM , A.BILL_TO_CUST_ID , A.DST_ID , A.ACCOUNT , A.DEPTID , A.PROJECT_ID , A.RMA_ID , %subrec(CF16_AN_SBR, A) , %subrec(UPDATE_SBR, A) , A.INTFC_LINE_NUM , A.CUST_ID2 FROM PS_TD_CLAIMS_PAY A
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: TD_CLAIMS_HDR.SETID
Prompt Table:
SP_SETTD_NONVW
|
| 2 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Default Value: TD_CLAIMS_HDR.CUST_ID
Prompt Table:
%EDITTABLE
|
| 3 |
CLAIM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Claim ID
Default Value: NEXT
Prompt Table:
TD_CLAIM_AUT_VW
|
| 4 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
Prompt Table:
TD_ALL_PROS_VW1
|
| 5 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
Prompt Table:
%EDITTABLE2
|
| 6 |
PAYMENT_METHOD_PL |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned Payment Method
1=Deduction
2=Check
3=Field Draft
4=Credit Memo
6=Chargeback
Default Value: TD_CLAIMS_HDR.PAYMENT_METHOD_PL
|
| 7 |
TD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status
A=Approved
I=Initial
P=Pending
R=Rejected
Default Value: I
|
| 8 |
PYMNT_ID_REF |
Character(20) |
VARCHAR2(20) NOT NULL |
Payment Reference
|
| 9 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Default Value: TD_CLAIMS_HDR.BANK_CD
Prompt Table:
BANK_CD_VW8
|
| 10 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Default Value: TD_CLAIMS_HDR.BANK_ACCT_KEY
Prompt Table:
TD_BANK_ACCT_VW
|
| 11 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
Default Value: 1
|
| 12 |
REFERENCE_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference
|
| 13 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: TD_CLAIMS_HDR.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 14 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Default Value: TD_SETID_TBL.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 15 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: TD_SETID_TBL.RT_TYPE
|
| 16 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
Default Value: 1
|
| 17 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 18 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 19 |
AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 20 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 21 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 22 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: TD_CLAIMS_HDR.BUSINESS_UNIT
Prompt Table:
SP_BU_TD_NONVW
|
| 23 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
Default Value: TD_CLAIMS_HDR.BUSINESS_UNIT_BI
Prompt Table:
SP_BU_BI_NONVW
|
| 24 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: TD_CLAIMS_HDR.BUSINESS_UNIT_GL
|
| 25 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Default Value: TD_CLAIMS_HDR.BUSINESS_UNIT_AP
Prompt Table:
SP_BU_AP_NONVW
|
| 26 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 27 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VNDR_ACTIVE_VW
|
| 28 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Default Value: VENDOR.DEFAULT_LOC
Prompt Table:
VNDR_LOC_AP_VW
|
| 29 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Default Value: VENDOR.PRIM_ADDR_SEQ_NUM
Prompt Table:
VENDOR_ADDR_VW
|
| 30 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
Default Value: TD_CLAIMS_HDR.BILL_TO_CUST_ID
|
| 31 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
Prompt Table:
DSTCD_DIS_OM_VW
|
| 32 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 33 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_NB_VW
|
| 34 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PROJID_BUGL_VW
|
| 35 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
Prompt Table:
%EDITTABLE3
|
| 36 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 37 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 38 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 39 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 40 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 41 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 42 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 43 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 44 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 45 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 46 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 47 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 48 |
OPRID_ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered By
07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase.
03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!!
FYI - The alternatives to use a User ID as uppercase:
1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID
2) Use %Upper meta-SQL in SQL statements
3) Use Upper function in peoplecodes
|
| 49 |
ENTERED_DT |
Date(10) |
DATE |
Entered on
|
| 50 |
OPRID_MODIFIED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Modify
Entered By
07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
|
| 51 |
LAST_UPDATE_DT |
Date(10) |
DATE |
Last Updated
|
| 52 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 53 |
CUST_ID2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Default Value: TD_PRO_MERC_CUS.CUST_ID2
Prompt Table:
TD_CUST_OPRVW
|