TGT_BILLTO_VW

(SQL View)

SELECT A.BO_ID , A.BILLING_SPECIALIST , A.COLLECTOR , A.CR_ANALYST , A.DM_SPECIALIST , A.PP_METHOD , A.PYMNT_TERMS_AMT , A.PYMNT_TERMS_CD FROM PS_BC_BILLTO_OPT A WHERE A.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_BC_BILLTO_OPT Z WHERE Z.BO_ID = A.BO_ID AND Z.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist, used in Contracts Integration message

3 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.

4 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.

5 DM_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Deduction Specialist

6 PP_METHOD Character(15) VARCHAR2(15) NOT NULL Payment Predictor Method

7 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

8 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	BILLING_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Billing Specialist, used in Contracts Integration message
3	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments.
4	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.
5	DM_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Deduction Specialist
6	PP_METHOD	Character(15)	VARCHAR2(15) NOT NULL	Payment Predictor Method
7	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
8	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.