PO_CNTPRADJ_AET

(SQL Table)
Index Back

Used by PO_CNTPRADJ AE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ABORT_FLAG Character(1) VARCHAR2(1) NOT NULL Abort Process Flag
3 ADJ_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Adjust Item Type
C=Category Specific Adjustment
L=Line Specific Adjustment Set
O=Open Item Adjustment Set
T=Template Adjustment
4 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
5 CHNG_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Change Template
6 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
7 CNTRCT_PROC_OPT Character(4) VARCHAR2(4) NOT NULL Contract Process Option
AP=Recurring Voucher
BPO=Release to Single PO Only
DST=Distributor
GN=General Contract
GRPM=Group Multi Supplier
GRPS=Group Single Supplier
MFG=Manufacturer
PADV=Prepaid Voucher w/ Advance PO
PO=Purchase Order
PPAY=Prepaid Voucher
RPOV=Recurring PO Voucher
SPP=Special Purpose
8 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
9 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
10 COPY_TO_CAT Character(1) VARCHAR2(1) NOT NULL Copy to Categories
11 COPY_TO_ITEM Character(1) VARCHAR2(1) NOT NULL Copy to Line Items
12 COPY_TO_OPEN Character(1) VARCHAR2(1) NOT NULL Copy to Open Items
13 EFFDT Date(10) DATE Effective Date

Default Value: %date

14 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
15 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
16 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
17 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine