CWB_PAYOPTS_VW (SQL View)	Index Back
Customer Payment Options View

CWB_PAYOPTS_VW

(SQL View)

Customer Payment Options View

SELECT a.setid ,a.cust_id ,a.pymnt_terms_cd ,a.grace_due_days ,a.grace_disc_days ,a.retention_days ,a.last_maint_oprid ,a.pp_hold ,a.pp_method ,a.ref_qualifier_code ,a.payment_method ,a.draft_approval ,a.draft_doc ,A.BILLING_AUTHORITY ,A.BILLING_SPECIALIST FROM %Table(CUST_OPTION) A WHERE A.EFF_STATUS = 'A' AND %EffdtCheck(CUST_OPTION X, A, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 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

3 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.
Prompt Table: AR_TRMS_VW

4 GRACE_DUE_DAYS Number(3,0) SMALLINT NOT NULL Due Grace Days

5 GRACE_DISC_DAYS Number(3,0) SMALLINT NOT NULL Discount Grace Days

6 RETENTION_DAYS Number(3,0) SMALLINT NOT NULL Closed Item Retention Days

7 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

8 PP_HOLD Character(1) VARCHAR2(1) NOT NULL Payment Predictor Hold
Y/N Table Edit
Default Value: N

9 PP_METHOD Character(15) VARCHAR2(15) NOT NULL Payment Predictor Method
Prompt Table: PP_MET_TBL

10 REF_QUALIFIER_CODE Character(2) VARCHAR2(2) NOT NULL Reference Qualifier Code
Prompt Table: AR_FLD_REF_VW

11 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.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report

12 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

13 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

14 BILLING_AUTHORITY Character(8) VARCHAR2(8) NOT NULL Billing Authority

15 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	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
3	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. Prompt Table: AR_TRMS_VW
4	GRACE_DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Due Grace Days
5	GRACE_DISC_DAYS	Number(3,0)	SMALLINT NOT NULL	Discount Grace Days
6	RETENTION_DAYS	Number(3,0)	SMALLINT NOT NULL	Closed Item Retention Days
7	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
8	PP_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Payment Predictor Hold Y/N Table Edit Default Value: N
9	PP_METHOD	Character(15)	VARCHAR2(15) NOT NULL	Payment Predictor Method Prompt Table: PP_MET_TBL
10	REF_QUALIFIER_CODE	Character(2)	VARCHAR2(2) NOT NULL	Reference Qualifier Code Prompt Table: AR_FLD_REF_VW
11	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. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
12	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
13	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
14	BILLING_AUTHORITY	Character(8)	VARCHAR2(8) NOT NULL	Billing Authority
15	BILLING_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Billing Specialist