AUDITCBHDR_TEO1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
4	CB_CONTRACT_ID	Character(25)	VARCHAR2(25) NOT NULL	Claimback Contract ID Default Value: NEXT Prompt Table: CB_HDR
5	CB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Claimback Contract Status A=Approved C=Cancelled H=Hold L=Closed O=Open Default Value: O
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR
8	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VENDOR_LOC
9	START_DATE	Date(10)	DATE NOT NULL	Start Date for Gen Standing PO
10	END_DATE	Date(10)	DATE NOT NULL	End Date
11	CB_CUST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Customer Type C=Customer G=Customer Group Default Value: C
12	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. Prompt Table: CUSTOMER
13	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group Prompt Table: CB_CST_GROUP_VW
14	CB_PROD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Product Type G=Product Group P=Product Default Value: P
15	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: PROD_ITEM
16	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group Prompt Table: CB_PRD_GROUP_VW
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CB_SETID_OPT.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL
18	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: PROD_UOM
19	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: CB_SETID_OPT.RT_TYPE Prompt Table: RT_TYPE_TBL
20	CB_MAX_QUANTITY	Number(32,4)	DECIMAL(31,4) NOT NULL	Maximum Quantity
21	CB_STOP_AT_MAX	Character(1)	VARCHAR2(1) NOT NULL	Stop Apply At Max Quantity Y/N Table Edit Default Value: Y
22	CB_COST_ON_CON	Character(1)	VARCHAR2(1) NOT NULL	Cost Defined On Contract Y/N Table Edit Default Value: N
23	CB_PURCHASE_COST	Number(16,5)	DECIMAL(15,5) NOT NULL	Purchase Cost
24	CB_COST_FIXED	Character(1)	VARCHAR2(1) NOT NULL	Cost Fixed From Contract Date
25	CB_COST_DATE	Date(10)	DATE	Cost Fixed Date
26	CB_AMOUNT	Number(27,3)	DECIMAL(26,3) NOT NULL	Claimback Amount
27	CB_PERCENTAGE	Number(7,3)	DECIMAL(6,3) NOT NULL	Claimback Percentage
28	CB_MARGIN	Character(1)	VARCHAR2(1) NOT NULL	Claimback Margin Impact B=Primary and Secondary Margin N=None P=Primary Margin S=Secondary Margin Default Value: P
29	SETTLEMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Vendor Rebate Settlement Method (Payment Method) ACH=Automated Clearing House AV=Adjustment Voucher CHK=Check CM=Credit Memo DD=Direct Debit DR=Draft EFT=Electronic Funds Transfer
30	SCHEDULE_ID	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID Default Value: CB_SETID_OPT.SCHEDULE_ID Prompt Table: SCHEDULE_TBL
31	NEXT_CLAIMS_GEN_DT	Date(10)	DATE	Next Claims Generation Date
32	OVERDUE_DEDUCT	Character(1)	VARCHAR2(1) NOT NULL	Overdue Deduction 1=None 2=Adjustment Voucher Default Value: 1
33	CB_INCLUDE_SHIP	Character(1)	VARCHAR2(1) NOT NULL	Include Shipments B=Standard and Direct D=Direct Only S=Standard Only Default Value: S
34	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID Prompt Table: SCON_HDR
35	CNTRCT_ID_TO	Character(25)	VARCHAR2(25) NOT NULL	Contract ID To
36	CB_VENDOR_REF	Character(30)	VARCHAR2(30) NOT NULL	Supplier Reference
37	AP_PAYMENT_TERMS	Character(5)	VARCHAR2(5) NOT NULL	AP Payment Terms Prompt Table: PYMT_TR_EFF_VW
38	AR_PAYMENT_TERMS	Character(5)	VARCHAR2(5) NOT NULL	AR Payment Terms Prompt Table: AR_TRMS_VW
39	CB_MANAGER_ID	Character(30)	VARCHAR2(30) NOT NULL	Claimback Mgr ID Default Value: CB_SETID_OPT.CB_MANAGER_ID
40	CB_MANAGER_NOTIFY	Character(1)	VARCHAR2(1) NOT NULL	Notify Claimback Manager Default Value: CB_SETID_OPT.CB_MANAGER_NOTIFY
41	CB_SETTLE_MGR	Character(30)	VARCHAR2(30) NOT NULL	Claimback Settlement Manager ID Default Value: CB_SETID_OPT.CB_SETTLE_MGR Prompt Table: CB_SETMGDEFN_VW
42	CB_SETTLE_NOTIFY	Character(1)	VARCHAR2(1) NOT NULL	Notify Settlement Manager Default Value: CB_SETID_OPT.CB_SETTLE_NOTIFY
43	CB_RECALC	Character(1)	VARCHAR2(1) NOT NULL	Recalculate Claims Y/N Table Edit Default Value: N
44	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
45	ENTERED_DTTM	DateTime(26)	TIMESTAMP	Created On
46	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.
47	LAST_UPDATE_DTTM	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.
48	COMMENTS	Long Character	CLOB	Comment
49	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code