CS_DOC_ALL_VW

(SQL View)
 Index Back

Contract Document Header & Key

Joins cs_doc_hdr to cs_doc_all_keys

SELECT D.CS_DOC_ID , D.CS_SOURCE_TRANS , CASE D.CS_SOURCE_TRANS WHEN '01' THEN A3.CS_SETID WHEN '02' THEN C.SETID WHEN '03' THEN P.BUSINESS_UNIT END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN A3.CS_ADHOC_ID WHEN '02' THEN C.CNTRCT_ID WHEN '03' THEN P.PO_ID END , A3.CS_SETID , A3.CS_ADHOC_ID , C.SETID , C.CNTRCT_ID , P.BUSINESS_UNIT , P.PO_ID , CASE D.CS_SOURCE_TRANS WHEN '01' THEN D.CNTRCT_BEGIN_DT WHEN '02' THEN C.CNTRCT_BEGIN_DT WHEN '03' THEN P.PO_DT END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN D.CNTRCT_EXPIRE_DT WHEN '02' THEN C.CNTRCT_EXPIRE_DT END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.VENDOR_SETID WHEN '03' THEN P.VENDOR_SETID END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.VENDOR_ID WHEN '03' THEN P.VENDOR_ID END , C.CNTRCT_STATUS , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.OPRID_APPROVED_BY WHEN '03' THEN P.OPRID_APPROVED_BY END , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.APPROVAL_DT WHEN '03' THEN P.APPROVAL_DT END , C.AMT_RELSD_OITM_CUM , C.CNTRCT_TYPE , C.DESCR , C.VNDR_CNTRCT_REF , C.FILENAME , C.FILE_EXTENSION , C.AMT_CNTRCT_MAX , C.RETENTION_CD , C.RETENTION_PCT , C.RETENTION_AMT , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.TAX_EXEMPT WHEN '03' THEN P.TAX_EXEMPT END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.TAX_EXEMPT_ID WHEN '03' THEN P.TAX_EXEMPT_ID END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.CURRENCY_CD WHEN '03' THEN P.CURRENCY_CD END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.RT_TYPE WHEN '03' THEN C.RT_TYPE END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.ORIGIN WHEN '03' THEN P.ORIGIN END , C.INVOICE_ID , C.MSTR_CNTRCT_ID , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.ENTERED_DT WHEN '03' THEN P.ENTERED_DT END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN D.LASTUPDOPRID WHEN '02' THEN C.OPRID_MODIFIED_BY WHEN '03' THEN P.OPRID_MODIFIED_BY END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN D.LAST_MODIFIED_DATE WHEN '02' THEN C.LAST_DTTM_UPDATE WHEN '03' THEN P.LAST_DTTM_UPDATE END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.OPRID_ENTERED_BY WHEN '03' THEN P.OPRID_ENTERED_BY END , C.ALLOW_OPEN_ITEM , C.PRICE_CAN_CHANGE , C.ADJ_BEFORE , C.GROSS_AMT , C.VCHR_TTL_LINES , C.BUSINESS_UNIT_AP , C.VAT_ENTRD_AMT , C.TAX_CD_VAT , C.VAT_DCLRTN_POINT , C.VAT_CALC_TYPE , C.VAT_CALC_GROSS_NET , C.VAT_RECALC_FLG , C.VAT_CALC_FRGHT_FLG , C.VAT_RCRD_INPT_FLG , C.VAT_RCRD_OUTPT_FLG , C.VAT_TXN_TYPE_CD , C.VAT_RECOVERY_PCT , C.VAT_ROUND_RULE , C.VAT_CALC_MISC_FLG , C.ALLOW_MC_PO , C.USE_CNTRCT_RTDT , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.RATE_DATE WHEN '03' THEN P.RATE_DATE END , C.CNTRCT_EXPIRY_FLG , C.CNTRCT_NOTIFY , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.BUYER_ID WHEN '03' THEN P.BUYER_ID END , C.CNTRCT_CORP_FLG , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.PYMNT_TERMS_CD WHEN '03' THEN P.PYMNT_TERMS_CD END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.DST_CNTRL_ID WHEN '03' THEN P.DST_CNTRL_ID END , C.CNTRCT_DISP_MTHD , C.SALETX_AMT , C.FREIGHT_AMT , C.MISC_AMT , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.CNTCT_SEQ_NUM WHEN '03' THEN P.CNTCT_SEQ_NUM END , CASE D.CS_SOURCE_TRANS WHEN '01' THEN ' ' WHEN '02' THEN C.PAY_TRM_BSE_DT_OPT WHEN '03' THEN P.PAY_TRM_BSE_DT_OPT END , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.TERMS_BASIS_DT WHEN '03' THEN P.TERMS_BASIS_DT END , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.USER_HDR_CHAR1 WHEN '03' THEN P.USER_HDR_CHAR1 END , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.CUSTOM_C100_A1 WHEN '03' THEN P.CUSTOM_C100_A1 END , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.CUSTOM_C100_A2 WHEN '03' THEN P.CUSTOM_C100_A2 END , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.CUSTOM_C100_A3 WHEN '03' THEN P.CUSTOM_C100_A3 END , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.CUSTOM_C100_A4 WHEN '03' THEN P.CUSTOM_C100_A4 END , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.CUSTOM_DATE_A WHEN '03' THEN P.CUSTOM_DATE_A END , CASE D.CS_SOURCE_TRANS WHEN '02' THEN C.CUSTOM_C1_A WHEN '03' THEN P.CUSTOM_C1_A END , C.VCHR_SRC , C.CNTRCT_PROC_OPT , C.PREPAID_REF , C.CNTRCT_CF_LOCK , C.NOTIFY_AMT , C.VERSION_STATUS , C.VERSION_DATE , C.RENEWAL_DATE , C.RENEWAL_NOTIFY , C.CNTRCT_AUTO_DFLT , C.DRAFT_DUE_DATE , C.DRAFT_NOTIFY , P.PO_DT , P.PO_TYPE , P.PO_STATUS , P.HOLD_STATUS , P.RECV_STATUS , P.DISP_ACTION , P.DISP_METHOD , P.CHANGE_STATUS , P.PO_REF , P.VNDR_LOC , P.CHNG_ORD_SEQ , P.ADDRESS_SEQ_NUM , P.SALES_CNTCT_SEQ_N , P.BILL_LOCATION , P.MATCH_ACTION , P.MATCH_CNTRL_ID , P.MATCH_STATUS_PO , P.MATCH_PROCESS_FLG , P.APPL_JRNL_ID_ENC , P.ACCOUNTING_DT , P.BUSINESS_UNIT_GL , P.ACTIVITY_DATE , P.PO_POST_STATUS , P.ERS_ACTION , P.ACCRUE_USE_TAX , P.CURRENCY_CD_BASE , P.VAT_ENTITY , P.LC_ID , P.PREPAID_PO_FLG , P.PREPAID_AMT , P.PREPAID_AUTH_STAT , P.PREPAID_STATUS_PO , P.BACKORDER_STATUS , P.DOC_TOL_HDR_STATUS , P.MID_ROLL_STATUS , P.POA_STATUS , P.BUDGET_CHECK , P.POA_REQS , P.CC_DISP_OPTION , P.CONTACT_NAME , P.CONTACT_PHONE FROM PS_CS_DOC_HDR D , (PS_CS_DOC_ALL_KEYS A1 LEFT OUTER JOIN PS_CNTRCT_HDR C ON C.SETID = A1.CNTRCT_SETID AND C.CNTRCT_ID = A1.CNTRCT_ID AND C.VERSION_NBR = A1.VERSION_NBR ) , (PS_CS_DOC_ALL_KEYS A2 LEFT OUTER JOIN PS_PO_HDR P ON P.BUSINESS_UNIT = A2.BUSINESS_UNIT AND P.PO_ID = A2.PO_ID ) , PS_CS_DOC_ALL_KEYS A3 WHERE D.CS_DOC_ID = A1.CS_DOC_ID AND D.CS_DOC_ID = A2.CS_DOC_ID AND D.CS_DOC_ID = A3.CS_DOC_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
2 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
3 CS_SETID_VAR Character(5) VARCHAR2(5) NOT NULL Variable SetID
4 CS_CNTRCT_VAR Character(25) VARCHAR2(25) NOT NULL Variable Contract Document ID
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 CS_ADHOC_ID Character(25) VARCHAR2(25) NOT NULL Ad Hoc ID
7 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
8 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
10 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
11 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
12 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
13 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
14 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
15 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled
16 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
17 APPROVAL_DT Date(10) DATE Date of Approval
18 AMT_RELSD_OITM_CUM Number(27,3) DECIMAL(26,3) NOT NULL Cumulative Relsd for Open Item
19 CNTRCT_TYPE Character(2) VARCHAR2(2) NOT NULL Contract Type
AP=Recurring Voucher
GN=General Contract
MS=Master Contract
PO=Purchase Order
20 DESCR Character(30) VARCHAR2(30) NOT NULL Description
21 VNDR_CNTRCT_REF Character(30) VARCHAR2(30) NOT NULL Supplier Contract Ref
22 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
23 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension
24 AMT_CNTRCT_MAX Number(27,3) DECIMAL(26,3) NOT NULL Maximum Amount of Contract.
25 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
26 RETENTION_PCT Number(7,3) DECIMAL(6,3) NOT NULL Retention Percentage
27 RETENTION_AMT Number(27,3) DECIMAL(26,3) NOT NULL Retention Amount
28 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
29 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
30 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
31 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.
32 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
33 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
34 MSTR_CNTRCT_ID Character(10) VARCHAR2(10) NOT NULL Master Contract ID
35 ENTERED_DT Date(10) DATE Entered on
36 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.
37 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.
38 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
39 ALLOW_OPEN_ITEM Character(1) VARCHAR2(1) NOT NULL Allow Open Item Reference
N=No
Y=Yes
40 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
N=No
Y=Yes
41 ADJ_BEFORE Character(1) VARCHAR2(1) NOT NULL Adjust Supplier Pricing First
N=After Contract Adjustments
Y=Before Contract Adjustments
42 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
43 VCHR_TTL_LINES Number(5,0) INTEGER NOT NULL Lines Entered
44 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
45 VAT_ENTRD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Entered VAT Amount
46 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.
47 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
48 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
49 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
50 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.
51 VAT_CALC_FRGHT_FLG Character(1) VARCHAR2(1) NOT NULL Include Freight
52 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.
53 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.
54 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.
55 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
56 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
57 VAT_CALC_MISC_FLG Character(1) VARCHAR2(1) NOT NULL Include Miscellaneous
58 ALLOW_MC_PO Character(1) VARCHAR2(1) NOT NULL Allow Multicurrency PO
N=No
Y=Yes
59 USE_CNTRCT_RTDT Character(1) VARCHAR2(1) NOT NULL Must Use Contract Rate Date
N=No
Y=Yes
60 RATE_DATE Date(10) DATE Exchange Rate Date
61 CNTRCT_EXPIRY_FLG Character(1) VARCHAR2(1) NOT NULL Contract Expiry Flag
62 CNTRCT_NOTIFY Number(4,0) SMALLINT NOT NULL Notify Days Before Expires
63 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
64 CNTRCT_CORP_FLG Character(1) VARCHAR2(1) NOT NULL Corporate Contract Flag
N=No
Y=Yes
65 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.
66 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
67 CNTRCT_DISP_MTHD Character(3) VARCHAR2(3) NOT NULL Contract Dispatch Method
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
68 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
69 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
70 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
71 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
72 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
73 TERMS_BASIS_DT Date(10) DATE Payment Terms Basis Date
74 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
75 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
76 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
77 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
78 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
79 CUSTOM_DATE_A Date(10) DATE Custom Date
80 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2
81 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
82 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
83 PREPAID_REF Character(10) VARCHAR2(10) NOT NULL Prepayment Reference
84 CNTRCT_CF_LOCK Character(1) VARCHAR2(1) NOT NULL Lock Chartfields
N=No
Y=Yes
85 NOTIFY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Notify Amount
86 VERSION_STATUS Character(1) VARCHAR2(1) NOT NULL Contract version status
C=Current
D=Draft
H=History
87 VERSION_DATE Date(10) DATE Date version was first approved
88 RENEWAL_DATE Date(10) DATE Renewal Date
89 RENEWAL_NOTIFY Number(4,0) SMALLINT NOT NULL Number of Days for contract renewal date notification workflow
90 CNTRCT_AUTO_DFLT Character(1) VARCHAR2(1) NOT NULL Auto defaulting option on the Procurement Contract
N=No
Y=Yes
91 DRAFT_DUE_DATE Date(10) DATE Draft Due Date
92 DRAFT_NOTIFY Number(4,0) SMALLINT NOT NULL Number of Days for contract renewal date notification workflow
93 PO_DT Date(10) DATE Date
94 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban
95 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
96 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
97 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
98 DISP_ACTION Character(1) VARCHAR2(1) NOT NULL Allow Dispatch When Appr
99 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
100 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged
101 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
102 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
103 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
104 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
105 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson
106 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
107 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
N=No Match
Y=Standard
108 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
109 MATCH_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Match Status
M=Matched
N=Not Required
P=Partially Matched
T=To Match
110 MATCH_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Match In Process
I=In Process
N=No
111 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance
112 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
113 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
114 ACTIVITY_DATE Date(10) DATE Last Activity
115 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
D=Distributed
N=None
116 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes
117 ACCRUE_USE_TAX Character(1) VARCHAR2(1) NOT NULL Accrue Use Tax
118 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
119 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.
120 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System
121 PREPAID_PO_FLG Character(1) VARCHAR2(1) NOT NULL Prepaid PO Flag
122 PREPAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepaid Amount
123 PREPAID_AUTH_STAT Character(1) VARCHAR2(1) NOT NULL Prepaid Authorization Status
A=Authorized
N=Not Approved
P=Pending Authorization
124 PREPAID_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Prepaid PO Status
N=Not Processed
P=Processing
V=Vouchered
125 BACKORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Back Order Status
1=Not Backordered
2=Backordered
3=Backordered Received
126 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid
127 MID_ROLL_STATUS Character(1) VARCHAR2(1) NOT NULL Mid Roll Status
128 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
129 BUDGET_CHECK Character(1) VARCHAR2(1) NOT NULL Budget Checked
N=No
Y=Yes
130 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
131 CC_DISP_OPTION Character(1) VARCHAR2(1) NOT NULL ProCard Dispatch Option
A=Default
B=Include Masked Card Info
C=Contact Buyer
D=Contact Cardholder
E=Charge to Card on File
F=No Reference
132 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
133 CONTACT_PHONE Character(24) VARCHAR2(24) NOT NULL Recepient Phone