CUST_OPTION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	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.
6	PYMNT_TERMS_AMT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Amount 1=User Amount 1 2=User Amount 2 G=Gross Voucher Amount I=Item Amount V=VAT Discountable Amount
7	GRACE_DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Due Grace Days
8	GRACE_DISC_DAYS	Number(3,0)	SMALLINT NOT NULL	Discount Grace Days
9	IMMEDIATE_PAYMENT	Character(1)	VARCHAR2(1) NOT NULL	Flag to determine if immediate payment is required. Y/N Table Edit Default Value: N
10	RETENTION_DAYS	Number(3,0)	SMALLINT NOT NULL	Closed Item Retention Days
11	PP_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Payment Predictor Hold Y/N Table Edit Default Value: N
12	PP_METHOD	Character(15)	VARCHAR2(15) NOT NULL	Payment Predictor Method
13	REF_QUALIFIER_CODE	Character(2)	VARCHAR2(2) NOT NULL	Reference Qualifier Code
14	PARTIAL_PY_SW	Character(1)	VARCHAR2(1) NOT NULL	Partial Payment Switch Y/N Table Edit Default Value: N
15	PO_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	PO Required Y/N Table Edit Default Value: N
16	BILL_BY_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill By Identifier, used in Contracts Integration message
17	FREIGHT_BILL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Freight Bill Type OE=Bill Order Entry Est. Freight SH=Bill Shipping Est. Freight Default Value: SH
18	BILL_CYCLE_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Cycle Identifier, field used in Contracts Integration Message
19	BILL_INQUIRY_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Bill Inquiry Phone , used in Contracts Integration Message
20	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Bill Type Identifier.
21	BILLING_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Billing Specialist, used in Contracts Integration message
22	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments.
23	CR_ANALYST	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
24	INVOICE_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Invoice Form
25	DST_ID_AR	Character(10)	VARCHAR2(10) NOT NULL	Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.
26	DRAFT_APPROVAL	Character(1)	VARCHAR2(1) NOT NULL	"Indicates whether or not a draft is pre-approved for payment by a bill-to customer. If the draft is pre-approved then it can be submitted to the customer's bank without the customer's sign-off. Otherwise the draft must be reviewed and approved by the customer before the enterprise can submit it to the bank for payment. This field is used only if the preferred payment method is ""Draft""." P=Preapproved R=Approval Required
27	DRAFT_DOC	Character(1)	VARCHAR2(1) NOT NULL	"A flag that indicates whether or not (C or N) a draft document should be created for a Receivables item when the payment method is ""draft"". If the value is N then the system prints only a draft statement. If the value is C then the system creates a draft document. " C=Create Document N=Do Not Create Document
28	DRAFT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).
29	DD_PROFILE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Profile ID for a Direct Debit
30	DD_GROUP	Character(2)	VARCHAR2(2) NOT NULL	Direct Debit Group %=All Direct Debit Groups A=Group A B=Group B C=Group C D=Group D
31	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. CC=Credit Card CHK=Check DD=Direct Debit DR=Draft EFT=Electronic Fund Transfer INV=Invoice Default Value: CHK
32	DIRECT_INVOICING	Character(1)	VARCHAR2(1) NOT NULL	Direct Invoicing Y/N Table Edit Default Value: Y
33	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
34	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
35	END_DATE	Date(10)	DATE	End date field to store an end date.
36	MICR_ID	Character(30)	VARCHAR2(30) NOT NULL	MICR ID
37	CONSOL_SETID	Character(5)	VARCHAR2(5) NOT NULL	Consolidation Customer SetID Prompt Table: SP_SETID_NONVW
38	CONSOL_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Consolidation Customer ID
39	CONSOL_KEY	Character(22)	VARCHAR2(22) NOT NULL	Invoice Consolidation Key
40	INTERUNIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	InterUnit Y/N Table Edit Default Value: N
41	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	This field stores the General Ledger Business Unit. Used for the Integration with Contracts/Billing from CRM.
42	DM_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Deduction Specialist
43	DM_WRITE_OFF_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Deduction Write-off Amount
44	DM_WRITE_OFF_DAYS	Number(3,0)	SMALLINT NOT NULL	Days Till Write-off
45	DM_WRITE_OFF_PCT	Number(3,0)	SMALLINT NOT NULL	Deduction Write-off Percent
46	HOL_PROC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Holiday Processing Option A=Due After Holiday B=Due Before Holiday N=Not Applicable Default Value: N
47	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
48	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Allow due date in next month Y/N Table Edit Default Value: Y
49	REBATE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Customer Rebate Method C=Pay by Check M=Issue Credit Memo N=No Rebate Method Default Value: N
50	BI_PROMPT_CURR	Character(1)	VARCHAR2(1) NOT NULL	Prompt field for billing currency, used for order capture inherited purchasing options. Y/N Table Edit Default Value: N
51	DEPOSIT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Deposit Percentage
52	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field determines the last user or operator that last changed this item.
53	DATE_LAST_MAINT	Date(10)	DATE	This field determines the date of last maintenance.