TD_PAYMENT_VW1

(SQL View)
 Index Back

Promo payment authorizations


SELECT A.SETID , A.PPRC_PROMO_CD , A.CUST_ID , C.EOEP_ADJUST_TYPE , C.EOEP_ADJUST_TYPE , A.PERFORMED , A.DOCUMENT_NAME , A.DOCUMENT_TYPE , A.CLOSED_DT , A.TD_PAYMENT_STATUS , A.AUTHORIZED_BY , A.AUTHORIZED_DT , A.AUTHORIZED_AMT , A.AUTHORIZED_AMT_BSE , A.ORIG_AUTH_AMT , A.CURRENCY_CD , A.RT_TYPE , A.BASE_CURRENCY , A.RATE_MULT , A.RATE_DIV , %subrec(update_sbr, A) , B.TD_AUTH_INCUR , B.FIRST_PERFORM_DT , B.LAST_PERFORM_DT , A.DELETE_FLAG , B.STATUS_TD FROM PS_TD_PAYMENT_TBL A , PS_PPRC_PROMO_TBL B , PS_TD_ALLOW_DISCNT C WHERE (A.SETID = B.SETID AND A.PPRC_PROMO_CD = B.PPRC_PROMO_CD AND B.ALLOW_STATUS IN ('4' , '6') AND PROMO_TYPE = 'A') AND B.SETID = C.SETID AND B.PPRC_PROMO_CD = C.PPRC_PROMO_CD AND A.MERCH_TYPE = C.EOEP_ADJUST_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: PPRC_PROMO_TBL.SETID

Prompt Table: SP_SETTD_NONVW

2 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

Default Value: PPRC_PROMO_TBL.PPRC_PROMO_CD

Prompt Table: PPRC_PROMO_TBL
Set Control Field: SETID

3 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_PROMO_CUST.CUST_ID

Prompt Table: TD_CUST_OPRVW

4 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type

Prompt Table: TD_MERCH_TYPE

5 TD_ADJUST_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Type
AC=Bill Back
GV=Giveaway
LS=Lump Sum
OI=Off-Invoice
6 PERFORMED Character(1) VARCHAR2(1) NOT NULL Performed
7 DOCUMENT_NAME Character(30) VARCHAR2(30) NOT NULL Document Path and Name
8 DOCUMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Document Type
123=Lotus 1-2-3
AVI=Video for Windows
CAD=AutoCad Document
DOC=Microsoft Winword
MPP=MicroSoft Project
NON=No Document Type
PST=PeopleSoft PeopleTools
SCR=Lotus ScreenCam
TLP=TimeLine for Windows
TXT=Notepad for ASCII Text
XLS=Microsoft Excel
9 CLOSED_DT Date(10) DATE Date Closed
10 TD_PAYMENT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
A=Authorized
C=Closed
J=Rejected
N=Not Authorized
P=Pending Approval
R=Released
11 AUTHORIZED_BY Character(30) VARCHAR2(30) NOT NULL Authorized By
12 AUTHORIZED_DT Date(10) DATE Authorized Date
13 AUTHORIZED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Authorized Amount
14 AUTHORIZED_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Authorized Amt
15 ORIG_AUTH_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Original Authorized Amount
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: TD_PROMO_CUST.CURRENCY_CD

17 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.
18 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. "
19 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
20 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
21 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
22 ENTERED_DT Date(10) DATE Entered on
23 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.
24 LAST_UPDATE_DT Date(10) DATE Last Updated
25 TD_AUTH_INCUR Character(1) VARCHAR2(1) NOT NULL Payment Against Authorized Amt
26 FIRST_PERFORM_DT Date(10) DATE First Peformance Date
27 LAST_PERFORM_DT Date(10) DATE Last Performance Date
28 DELETE_FLAG Character(1) VARCHAR2(1) NOT NULL Deletion Flag
29 STATUS_TD Character(2) VARCHAR2(2) NOT NULL Promotion Status
CA=Customer Approved
CE=Customer Cancelled
CL=Closed
CR=Customer Rejected
MA=Management Approved
MR=Management Rejected
PA=Pending Approval
PL=Planned
RE=Recalled
RL=Released