| # |
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:
TD_ALL_PROS_VW
|
| 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 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 6 |
PERFORMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Performed
Y/N Table Edit
|
| 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
Prompt Table:
FILE_DIR_VW
|
| 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
Default Value: N
|
| 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.
Default Value: TD_PROMO_CUST.RT_TYPE
|
| 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. "
Default Value: TD_SETID_TBL.BASE_CURRENCY
|
| 19 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
Default Value: 1
|
| 20 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 21 |
DELETE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deletion Flag
Default Value: Y
|
| 22 |
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
|
| 23 |
ENTERED_DT |
Date(10) |
DATE |
Entered on
|
| 24 |
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.
|
| 25 |
LAST_UPDATE_DT |
Date(10) |
DATE |
Last Updated
|
| 26 |
PERFORMANCE_PROOF |
Long Character |
CLOB |
Performance proof
|