CS_DOC_ALL_TVW

(SQL View)
 Index Back

Contract Doc & Tran flds

Used for reporting. This view has xlats instead of prompts on the table.

SELECT PROCESS_INSTANCE ,CS_DOC_ID ,CS_SOURCE_TRANS ,CS_SETID_VAR ,CS_CNTRCT_VAR ,SETID ,CS_ADHOC_ID ,CNTRCT_SETID ,CNTRCT_ID ,BUSINESS_UNIT ,PO_ID ,AUC_ID ,AUC_ROUND ,AUC_VERSION ,DESCR60 ,CS_DOC_STATUS ,CS_DOCUMENT_TYPE ,CS_DOC_OWNER ,CS_SPONSOR ,DEPTID ,CS_SETID ,CS_TEMPLATE_ID ,CS_TEMPLATE_AMEND ,CS_EX_SUMM_TMPL_ID ,CS_VERSION ,CS_AMENDMENT ,CS_TWOFILE_AMEND ,CS_TRANKEY_REC ,CS_DOC_ATT_VER ,CS_DOC_EXT_ATT_VER ,CS_DOC_DISP_VER ,CS_DOC_COLLAB_VER ,CS_DOC_LOG_VER ,CS_DOC_SIGN_VER ,CS_DOC_EXEC_VER ,CS_COLLAB_INSTR ,CLOSE_FLAG ,EXT_LOCK_FLG ,HOLD_FLAG ,CREATED_DTTM ,CREATED_BY_USER ,AMENDED_DTTM ,DATETIME_CHECKOUT ,CHECKED_OUT_BY ,DATETIME_EX_CHKOUT ,CHECKED_OUT_EX_BY ,COMMENT1 ,COLLABED_DTTM ,COLLABED_EXT_DTTM ,CS_COLLAB_DUE_DT ,CS_COLLAB_DUE_TM ,APPROVAL_DTTM ,DATETIME_DISPATCH ,EXECUTED_DTTM ,CS_COMPLETED_DTTM ,CS_IMPORT_CODE ,BUSINESS_UNIT_REQ ,REQ_ID ,CS_REQ_LOCATION ,CS_DOC_ID_ORIG ,ATTACHED_TO_REQ ,CS_DOC_BLD_STATUS ,CS_ROUTE_SIGN_FLG ,CS_SIGN_FILE ,CS_SIGN_PREP_DONE ,CS_INT_SIGN_STATUS ,CS_EXT_SIGN_STATUS ,CS_CHECKOUT_STATUS ,CS_SOURCE_VER ,CS_SOURCE_ROUND ,CS_DOC_DUE_DATE ,CS_DOC_START_DATE ,CS_DOC_STATUS_DATE ,CS_DOC_UFLD_VER ,CS_PROXY_USER ,CS_COLLAB_COMMENTS ,CS_LST_APPSUB ,CS_LST_APPSUB_OPR ,CS_LST_CHKIN ,CS_LST_CHKIN_OPR ,CNTRCT_BEGIN_DT ,CNTRCT_EXPIRE_DT ,VENDOR_SETID ,VENDOR_ID ,CNTRCT_STATUS ,OPRID_APPROVED_BY ,APPROVAL_DT ,CNTRCT_TYPE ,DESCR ,VNDR_CNTRCT_REF ,FILENAME ,FILE_EXTENSION ,AMT_CNTRCT_MAX ,RETENTION_CD ,RETENTION_PCT ,RETENTION_AMT ,TAX_EXEMPT ,TAX_EXEMPT_ID ,CURRENCY_CD ,RT_TYPE ,ORIGIN ,INVOICE_ID ,MSTR_CNTRCT_ID ,ENTERED_DT ,%subrec(LAST_UPDATE_SBR, A) ,OPRID_ENTERED_BY ,ALLOW_OPEN_ITEM ,PRICE_CAN_CHANGE ,ADJ_BEFORE ,GROSS_AMT ,VCHR_TTL_LINES ,BUSINESS_UNIT_AP ,ALLOW_MC_PO ,USE_CNTRCT_RTDT ,RATE_DATE ,CNTRCT_EXPIRY_FLG ,CNTRCT_NOTIFY ,BUYER_ID ,CNTRCT_CORP_FLG ,PYMNT_TERMS_CD ,DST_CNTRL_ID ,CNTRCT_DISP_MTHD ,SALETX_AMT ,FREIGHT_AMT ,MISC_AMT ,CNTCT_SEQ_NUM ,PAY_TRM_BSE_DT_OPT ,TERMS_BASIS_DT ,%subrec(PUR_USR_HDR_SBR, A) ,VCHR_SRC ,CNTRCT_PROC_OPT ,PREPAID_REF ,CNTRCT_CF_LOCK ,NOTIFY_AMT ,VERSION_STATUS ,VERSION_DATE ,RENEWAL_DATE ,RENEWAL_NOTIFY ,CNTRCT_AUTO_DFLT ,DRAFT_DUE_DATE ,DRAFT_NOTIFY ,CHNG_ORD_BATCH ,PO_TYPE ,PO_STATUS ,HOLD_STATUS ,RECV_STATUS ,DISP_ACTION ,DISP_METHOD ,CHANGE_STATUS ,PO_REF ,VNDR_LOC ,PRICE_SETID ,PRICE_VENDOR ,PRICE_LOC ,CHNG_ORD_SEQ ,ADDRESS_SEQ_NUM ,SALES_CNTCT_SEQ_N ,BILL_LOCATION ,APPL_JRNL_ID_ENC ,POST_DOC ,ACCOUNTING_DT ,BUSINESS_UNIT_GL ,ACTIVITY_DATE ,PO_POST_STATUS ,NEXT_MOD_SEQ_NBR ,ERS_ACTION ,ACCRUE_USE_TAX ,CURRENCY_CD_BASE ,RATE_MULT ,RATE_DIV ,VAT_ENTITY ,LC_ID ,PREPAID_PO_FLG ,PREPAID_AMT ,PREPAID_AUTH_STAT ,PREPAID_STATUS_PO ,BACKORDER_STATUS ,DOC_TOL_HDR_STATUS ,MID_ROLL_STATUS ,POA_STATUS ,BUDGET_CHECK ,POA_REQS ,CONTACT_NAME ,CONTACT_PHONE ,AUC_FORMAT ,AUC_TYPE ,AUC_STATUS ,AUC_SAVE_DTTM ,AUC_POST_DTTM ,AUC_DTTM_PREVIEW ,REQUESTOR_ID FROM PS_CS_DOC_ALL_TMP A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
3 CS_SOURCE_TRANS Character(2) VARCHAR2(2) NOT NULL Source Transaction 03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction 01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
01=Ad Hoc
02=Purchasing Contracts
03=Purchase Orders
04=Sourcing Events
97=All Sources
98=Multiple Sources
99=Not Transactional
4 CS_SETID_VAR Character(5) VARCHAR2(5) NOT NULL Variable SetID
5 CS_CNTRCT_VAR Character(25) VARCHAR2(25) NOT NULL Variable Contract Document ID
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 CS_ADHOC_ID Character(25) VARCHAR2(25) NOT NULL Ad Hoc ID
8 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
9 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
12 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
13 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
14 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
15 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
16 CS_DOC_STATUS Character(2) VARCHAR2(2) NOT NULL Document Status
AA=Approved
AD=Denied
AP=Pending Approval
CC=Collaborated
CP=Pending Collaboration
CR=Collaborated, Pending Review
DC=Complete
DR=Draft
DS=Dispatched
EC=Pending External Collaboration
EX=Executed
PI=Pending Internal Review
17 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
18 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator
19 CS_SPONSOR Character(30) VARCHAR2(30) NOT NULL Sponsor
20 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
21 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
22 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
23 CS_TEMPLATE_AMEND Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
24 CS_EX_SUMM_TMPL_ID Character(20) VARCHAR2(20) NOT NULL Executive Summary Configurator
25 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
26 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment
27 CS_TWOFILE_AMEND Character(1) VARCHAR2(1) NOT NULL Amendment Option
1=Amend Contract Only
2=Amend Contract with Amendments
3=Amendment Files Only
28 CS_TRANKEY_REC Character(15) VARCHAR2(15) NOT NULL Source Key Record
29 CS_DOC_ATT_VER Number(3,0) SMALLINT NOT NULL This is the cycle/seq nbr that indicates the change interation/version that the normal attachments are on. Since we want to save them off in history
30 CS_DOC_EXT_ATT_VER Number(3,0) SMALLINT NOT NULL This is the cycle/seq nbr that indicates the change interation/version that the normal attachments are on. Since we want to save them off in history
31 CS_DOC_DISP_VER Number(3,0) SMALLINT NOT NULL Dispatch version/cycle
32 CS_DOC_COLLAB_VER Number(3,0) SMALLINT NOT NULL Collaboration Version
33 CS_DOC_LOG_VER Number(3,0) SMALLINT NOT NULL Logging Version
34 CS_DOC_SIGN_VER Number(5,0) INTEGER NOT NULL Signing Version Number
35 CS_DOC_EXEC_VER Number(3,0) SMALLINT NOT NULL Executed Summary Version
36 CS_COLLAB_INSTR Character(254) VARCHAR2(254) NOT NULL Collaboration Instructions
37 CLOSE_FLAG Character(1) VARCHAR2(1) NOT NULL Close Contract Flag
38 EXT_LOCK_FLG Character(1) VARCHAR2(1) NOT NULL External Lock Flag
39 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
40 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
41 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
42 AMENDED_DTTM DateTime(26) TIMESTAMP Amendment Created On
43 DATETIME_CHECKOUT DateTime(26) TIMESTAMP Checked Out On
44 CHECKED_OUT_BY Character(30) VARCHAR2(30) NOT NULL Checked Out By
45 DATETIME_EX_CHKOUT DateTime(26) TIMESTAMP Summary Checked Out On
46 CHECKED_OUT_EX_BY Character(30) VARCHAR2(30) NOT NULL Checked Out By
47 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
48 COLLABED_DTTM DateTime(26) TIMESTAMP Collaborated On
49 COLLABED_EXT_DTTM DateTime(26) TIMESTAMP Collaborated Externally On
50 CS_COLLAB_DUE_DT Date(10) DATE Collaboration Due Date
51 CS_COLLAB_DUE_TM Time(15) TIMESTAMP Collaboration Due Time
52 APPROVAL_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a given transaction is approved by an oper
53 DATETIME_DISPATCH DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0
54 EXECUTED_DTTM DateTime(26) TIMESTAMP Executed On
55 CS_COMPLETED_DTTM DateTime(26) TIMESTAMP Completed Datetime
56 CS_IMPORT_CODE Character(1) VARCHAR2(1) NOT NULL Import Type
1=Authored
2=Imported
3=Hybrid
4=Automatic Import
57 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
58 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
59 CS_REQ_LOCATION Character(1) VARCHAR2(1) NOT NULL Requisition Transaction
C=Core
E=ePro
60 CS_DOC_ID_ORIG Character(25) VARCHAR2(25) NOT NULL Document ID
61 ATTACHED_TO_REQ Character(1) VARCHAR2(1) NOT NULL Attached to Requisition
62 CS_DOC_BLD_STATUS Character(1) VARCHAR2(1) NOT NULL Used by Copy Doc. All other document create processes automatically set to 1.
1=Complete
2=Refresh Binds
3=Original Copied
4=Exec Summary Copied
5=Wizard Invoked
9=Copy Initiated
63 CS_ROUTE_SIGN_FLG Character(1) VARCHAR2(1) NOT NULL Document in Signature Loop
64 CS_SIGN_FILE Character(1) VARCHAR2(1) NOT NULL File Being Signed
0=No Files
1=Main
2=Amendment
65 CS_SIGN_PREP_DONE Character(1) VARCHAR2(1) NOT NULL Adobe Signature Prep
66 CS_INT_SIGN_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Signature Status
NR=Not Required
PS=Pending Signatures
SS=Signed
67 CS_EXT_SIGN_STATUS Character(2) VARCHAR2(2) NOT NULL External Signature Status
NR=Not Initiated
PS=Pending Signatures
RJ=Declined
SS=Signed
68 CS_CHECKOUT_STATUS Character(1) VARCHAR2(1) NOT NULL 10/02/07 Field created for SCMT release 9.1 - flag to determine the checkout status N - not checked out M - main document is checked out (amendment option 1 or 2) A - amendment file is checked out ((amendment option 2 or 3) B - both files are checked out ((amendment option 2)
A=Checked out amendment file
B=Checked out both files
M=Checked out main document
N=No checkout
69 CS_SOURCE_VER Number(3,0) SMALLINT NOT NULL cel 10/19/2007 - will store the associated source version number that this document is build upon. Both PO and Contracts in 9.1 will have a corresponding version.
70 CS_SOURCE_ROUND Number(5,0) INTEGER NOT NULL Event Round
71 CS_DOC_DUE_DATE Date(10) DATE Cycle Due Date
72 CS_DOC_START_DATE Date(10) DATE Cycle Start Date
73 CS_DOC_STATUS_DATE Date(10) DATE Last Status Change Date
74 CS_DOC_UFLD_VER Number(3,0) SMALLINT NOT NULL User Defined Field Version
75 CS_PROXY_USER Character(30) VARCHAR2(30) NOT NULL Proxy Administrator
76 CS_COLLAB_COMMENTS Long Character CLOB Collaboration Comments
77 CS_LST_APPSUB DateTime(26) TIMESTAMP Last Approval Submit
78 CS_LST_APPSUB_OPR Character(30) VARCHAR2(30) NOT NULL Last Approval Submit Operator
79 CS_LST_CHKIN DateTime(26) TIMESTAMP Last Checked In
80 CS_LST_CHKIN_OPR Character(30) VARCHAR2(30) NOT NULL Last Checked In Operator
81 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
82 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
83 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
84 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
85 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled
86 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
87 APPROVAL_DT Date(10) DATE Date of Approval
88 CNTRCT_TYPE Character(2) VARCHAR2(2) NOT NULL Contract Type
AP=Recurring Voucher
GN=General Contract
MS=Master Contract
PO=Purchase Order
89 DESCR Character(30) VARCHAR2(30) NOT NULL Description
90 VNDR_CNTRCT_REF Character(30) VARCHAR2(30) NOT NULL Supplier Contract Ref
91 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
92 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension
93 AMT_CNTRCT_MAX Number(27,3) DECIMAL(26,3) NOT NULL Maximum Amount of Contract.
94 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
95 RETENTION_PCT Number(7,3) DECIMAL(6,3) NOT NULL Retention Percentage
96 RETENTION_AMT Number(27,3) DECIMAL(26,3) NOT NULL Retention Amount
97 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
98 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
99 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
100 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.
101 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
102 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
103 MSTR_CNTRCT_ID Character(10) VARCHAR2(10) NOT NULL Master Contract ID
104 ENTERED_DT Date(10) DATE Entered on
105 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.
106 LAST_DTTM_UPDATE 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.
107 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
108 ALLOW_OPEN_ITEM Character(1) VARCHAR2(1) NOT NULL Allow Open Item Reference
N=No
Y=Yes
109 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
N=No
Y=Yes
110 ADJ_BEFORE Character(1) VARCHAR2(1) NOT NULL Adjust Supplier Pricing First
N=After Contract Adjustments
Y=Before Contract Adjustments
111 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
112 VCHR_TTL_LINES Number(5,0) INTEGER NOT NULL Lines Entered
113 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
114 ALLOW_MC_PO Character(1) VARCHAR2(1) NOT NULL Allow Multicurrency PO
N=No
Y=Yes
115 USE_CNTRCT_RTDT Character(1) VARCHAR2(1) NOT NULL Must Use Contract Rate Date
N=No
Y=Yes
116 RATE_DATE Date(10) DATE Exchange Rate Date
117 CNTRCT_EXPIRY_FLG Character(1) VARCHAR2(1) NOT NULL Contract Expiry Flag
118 CNTRCT_NOTIFY Number(4,0) SMALLINT NOT NULL Notify Days Before Expires
119 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
120 CNTRCT_CORP_FLG Character(1) VARCHAR2(1) NOT NULL Corporate Contract Flag
N=No
Y=Yes
121 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.
122 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
123 CNTRCT_DISP_MTHD Character(3) VARCHAR2(3) NOT NULL Contract Dispatch Method
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
124 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
125 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
126 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
127 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
128 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
129 TERMS_BASIS_DT Date(10) DATE Payment Terms Basis Date
130 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
131 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
132 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
133 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
134 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
135 CUSTOM_DATE_A Date(10) DATE Custom Date
136 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2
137 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
138 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
139 PREPAID_REF Character(10) VARCHAR2(10) NOT NULL Prepayment Reference
140 CNTRCT_CF_LOCK Character(1) VARCHAR2(1) NOT NULL Lock Chartfields
N=No
Y=Yes
141 NOTIFY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Notify Amount
142 VERSION_STATUS Character(1) VARCHAR2(1) NOT NULL Contract version status
C=Current
D=Draft
H=History
143 VERSION_DATE Date(10) DATE Date version was first approved
144 RENEWAL_DATE Date(10) DATE Renewal Date
145 RENEWAL_NOTIFY Number(4,0) SMALLINT NOT NULL Number of Days for contract renewal date notification workflow
146 CNTRCT_AUTO_DFLT Character(1) VARCHAR2(1) NOT NULL Auto defaulting option on the Procurement Contract
N=No
Y=Yes
147 DRAFT_DUE_DATE Date(10) DATE Draft Due Date
148 DRAFT_NOTIFY Number(4,0) SMALLINT NOT NULL Number of Days for contract renewal date notification workflow
149 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
150 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban
151 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
152 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
153 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
154 DISP_ACTION Character(1) VARCHAR2(1) NOT NULL Allow Dispatch When Appr
155 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
156 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged
157 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
158 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
159 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
160 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
161 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
162 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
163 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
164 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson
165 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
166 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance
167 POST_DOC Character(1) VARCHAR2(1) NOT NULL Post Document
168 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
169 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
170 ACTIVITY_DATE Date(10) DATE Last Activity
171 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
D=Distributed
N=None
172 NEXT_MOD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Next Modification Number
173 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes
174 ACCRUE_USE_TAX Character(1) VARCHAR2(1) NOT NULL Accrue Use Tax
175 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
176 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
177 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
178 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
179 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System
180 PREPAID_PO_FLG Character(1) VARCHAR2(1) NOT NULL Prepaid PO Flag
181 PREPAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepaid Amount
182 PREPAID_AUTH_STAT Character(1) VARCHAR2(1) NOT NULL Prepaid Authorization Status
A=Authorized
N=Not Approved
P=Pending Authorization
183 PREPAID_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Prepaid PO Status
N=Not Processed
P=Processing
V=Vouchered
184 BACKORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Back Order Status
1=Not Backordered
2=Backordered
3=Backordered Received
185 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid
186 MID_ROLL_STATUS Character(1) VARCHAR2(1) NOT NULL Mid Roll Status
187 POA_STATUS Character(2) VARCHAR2(2) NOT NULL po ack status field that will be on po_hdr.
AC=Acknowledged with changes
AK=Acknowledged
BA=Approved, Changes Pending
IN=Initial Dispatch Acknowledged
NR=Not Required
SR=Responded, Awaits Review
WD=Awaiting PO Dispatch
WR=Awaiting Acknowledgement
188 BUDGET_CHECK Character(1) VARCHAR2(1) NOT NULL Budget Checked
N=No
Y=Yes
189 POA_REQS Character(1) VARCHAR2(1) NOT NULL CEL. New field to store POA requirements on the PO Hdr
A=All dispatches
I=Initial dispatch only
N=Not required
190 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
191 CONTACT_PHONE Character(24) VARCHAR2(24) NOT NULL Recepient Phone
192 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
193 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
194 AUC_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
A=Awarded
C=Collaborating Event
D=Collaborating Bid Analysis
E=Evaluating
F=RFI Reviewed
I=Pending RFI Review
N=Not Awarded
O=Open
P=Posted
Q=Paused
R=Pending Scheduled Review
S=Pending Post Approval
T=Pending Award
U=Pending Award Approval
W=Post to Third Party Failed
X=Cancelled
Z=Inactive Version
195 AUC_SAVE_DTTM DateTime(26) TIMESTAMP Save DateTime
196 AUC_POST_DTTM DateTime(26) TIMESTAMP Post DateTime
197 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
198 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id