| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SUBNODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Subscribing Node
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 3 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 4 |
VERSION_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Version number
|
| 5 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 6 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 7 |
CNTRCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled
|
| 8 |
OPRID_APPROVED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Approved By
|
| 9 |
APPROVAL_DT |
Date(10) |
DATE |
Date of Approval
|
| 10 |
CNTRCT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Contract Type
AP=Recurring Voucher
GN=General Contract
MS=Master Contract
PO=Purchase Order
|
| 11 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 12 |
VNDR_CNTRCT_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Supplier Contract Ref
|
| 13 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 14 |
FILE_EXTENSION |
Character(4) |
VARCHAR2(4) NOT NULL |
File Extension
|
| 15 |
CNTRCT_BEGIN_DT |
Date(10) |
DATE NOT NULL |
Contract Begin Date
|
| 16 |
CNTRCT_EXPIRE_DT |
Date(10) |
DATE |
Expire Date
|
| 17 |
AMT_CNTRCT_MAX |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Maximum Amount of Contract.
|
| 18 |
RETENTION_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Retention
E=Retain on Each Payment
F=Retain on First Payment
L=Retain on Last Payment
N=No Retention
|
| 19 |
RETENTION_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Retention Percentage
|
| 20 |
RETENTION_AMT |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Retention Amount
|
| 21 |
TAX_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
|
| 22 |
TAX_EXEMPT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Tax Exempt ID
|
| 23 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 24 |
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.
|
| 25 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 26 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 27 |
MSTR_CNTRCT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Master Contract ID
|
| 28 |
ENTERED_DT |
Date(10) |
DATE NOT NULL |
Entered on
|
| 29 |
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
|
| 30 |
ALLOW_OPEN_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Open Item Reference
N=No
Y=Yes
Y/N Table Edit
|
| 31 |
PRICE_CAN_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Can Be Changed on Order
N=No
Y=Yes
Y/N Table Edit
|
| 32 |
ADJ_BEFORE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust Supplier Pricing First
N=After Contract Adjustments
Y=Before Contract Adjustments
|
| 33 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 34 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 35 |
VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT Amount
|
| 36 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|
| 37 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|
| 38 |
VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
|
| 39 |
VAT_CALC_GROSS_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
|
| 40 |
VAT_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
Y/N Table Edit
|
| 41 |
VAT_CALC_FRGHT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Freight
Y/N Table Edit
|
| 42 |
VAT_RCRD_INPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a business unit will pay the VAT and recover it later from the VAT tax authority. VAT input is usually associated with purchase transactions.
Y/N Table Edit
|
| 43 |
VAT_RCRD_OUTPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) VAT will be collected by the vendor on behalf of the government. VAT output is usually associated with sales transactions.
Y/N Table Edit
|
| 44 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
|
| 45 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 46 |
VAT_ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
" Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
|
| 47 |
VAT_CALC_MISC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Miscellaneous
Y/N Table Edit
|
| 48 |
ALLOW_MC_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Multicurrency PO
N=No
Y=Yes
Y/N Table Edit
|
| 49 |
USE_CNTRCT_RTDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Must Use Contract Rate Date
N=No
Y=Yes
Y/N Table Edit
|
| 50 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 51 |
CNTRCT_EXPIRY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Expiry Flag
Y/N Table Edit
|
| 52 |
CNTRCT_NOTIFY |
Number(4,0) |
SMALLINT NOT NULL |
Notify Days Before Expires
|
| 53 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
|
| 54 |
CS_PARENT_EMAIL |
Character(70) |
VARCHAR2(70) NOT NULL |
Supplier Contracts - E-mail address for the contract administrator in the parent node.
|
| 55 |
CS_LOCAL_EMAIL |
Character(70) |
VARCHAR2(70) NOT NULL |
Local Email Address
|
| 56 |
CNTRCT_CORP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Corporate Contract Flag
N=No
Y=Yes
Y/N Table Edit
|
| 57 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
|
| 58 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
|
| 59 |
CNTRCT_DISP_MTHD |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Dispatch Method
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
|
| 60 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 61 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 62 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 63 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
|
| 64 |
PAY_TRM_BSE_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Terms Basis Date Type
A=Acct Date
C=Doc Date
I=Inv Date
R=Recpt Date
S=Ship Date
U=User Date
|
| 65 |
TERMS_BASIS_DT |
Date(10) |
DATE |
Payment Terms Basis Date
|
| 66 |
USER_HDR_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 1
|
| 67 |
CUSTOM_C100_A1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 1
|
| 68 |
CUSTOM_C100_A2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 2
|
| 69 |
CUSTOM_C100_A3 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 3
|
| 70 |
CUSTOM_C100_A4 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 4
|
| 71 |
CUSTOM_DATE_A |
Date(10) |
DATE |
Custom Date
|
| 72 |
CUSTOM_C1_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 2
|
| 73 |
VCHR_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Source
|
| 74 |
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
|
| 75 |
PREPAID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Prepayment Reference
|
| 76 |
CNTRCT_CF_LOCK |
Character(1) |
VARCHAR2(1) NOT NULL |
Lock Chartfields
N=No
Y=Yes
Y/N Table Edit
|
| 77 |
NOTIFY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Notify Amount
|
| 78 |
CS_SNDCT_DEFAULTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_DEFAULTS table will be syndicated.
Y/N Table Edit
|
| 79 |
CS_SNDCT_MISC_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_HDR_MISC table will be syndicated.
Y/N Table Edit
|
| 80 |
CS_SNDCT_MILESTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_MILESTN table will be syndicated.
Y/N Table Edit
|
| 81 |
CS_SNDCT_SHP_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_LN_SHIP table will be syndicated.
Y/N Table Edit
|
| 82 |
CS_SNDCT_DISTRIB |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_BU_DSTRB and CNTRCT_DSTRB tables will be syndicated.
Y/N Table Edit
|
| 83 |
CS_CNTRCT_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Load
Default Value: N
|
| 84 |
LAST_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Last Sequence Number
|
| 85 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 86 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 87 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|