BC_BILLTO_CI_VW (SQL View)	Index Back
BC_BILLTO_CI_VW This view: BC_BILLTO_CI_VW has the same structure as the record: BC_BILLTO_OPTS. As delivered, this view does not contain any PeopleCode and is used in Component Interface (CI) components only. Whenever the structure of the underlying record changes, this view must be modified accordingly.

BC_BILLTO_CI_VW

(SQL View)

BC_BILLTO_CI_VW

This view: BC_BILLTO_CI_VW has the same structure as the record: BC_BILLTO_OPTS. As delivered, this view does not contain any PeopleCode and is used in Component Interface (CI) components only. Whenever the structure of the underlying record changes, this view must be modified accordingly.

SELECT A.BO_ID , A.EFFDT , A.EFF_STATUS , A.PYMNT_TERMS_CD , A.PYMNT_TERMS_AMT , A.GRACE_DUE_DAYS , A.GRACE_DISC_DAYS ,A.IMMEDIATE_PAYMENT , A.RETENTION_DAYS , A.PP_HOLD , A.PP_METHOD , A.REF_QUALIFIER_CODE , A.PARTIAL_PY_SW , A.PO_REQUIRED , A.BILL_BY_ID , A.FREIGHT_BILL_TYPE , A.BILL_CYCLE_ID , A.BILL_INQUIRY_PHONE , A.BILL_TYPE_ID , A.BILLING_SPECIALIST , A.COLLECTOR , A.CR_ANALYST , A.INVOICE_FORM_ID , A.DST_ID_AR , A.DRAFT_APPROVAL , A.DRAFT_DOC , A.DRAFT_TYPE , A.DD_PROFILE_ID , A.DD_GROUP , A.PAYMENT_METHOD , A.DIRECT_INVOICING , A.CUSTOMER_PO , A.START_DATE , A.END_DATE , A.MICR_ID , A.CONSOL_SETID , A.CONSOL_CUST_ID , A.CONSOL_KEY , A.INTERUNIT_FLG , A.BUSINESS_UNIT_GL , A.DM_SPECIALIST , A.DM_WRITE_OFF_AMT , A.DM_WRITE_OFF_DAYS , A.DM_WRITE_OFF_PCT , A.HOL_PROC_OPT , A.HOL_PROC_DAYS , A.HOL_PROC_OVERFL , A.REBATE_METHOD , A.BI_PROMPT_CURR ,A.DEPOSIT_PCT , %subrec(RB_AUDIT_SBR, A) FROM PS_BC_BILLTO_OPT A

Parent record: BC

# 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 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 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: PAY_TRMS_VW

5 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

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

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

8 IMMEDIATE_PAYMENT Character(1) VARCHAR2(1) NOT NULL Flag to determine if immediate payment is required.
Y/N Table Edit
Default Value: N

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

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

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

12 REF_QUALIFIER_CODE Character(2) VARCHAR2(2) NOT NULL Reference Qualifier Code

13 PARTIAL_PY_SW Character(1) VARCHAR2(1) NOT NULL Partial Payment Switch
Y/N Table Edit
Default Value: N

14 PO_REQUIRED Character(1) VARCHAR2(1) NOT NULL PO Required
Y/N Table Edit
Default Value: N

15 BILL_BY_ID Character(10) VARCHAR2(10) NOT NULL Bill By Identifier, used in Contracts Integration message

16 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

17 BILL_CYCLE_ID Character(10) VARCHAR2(10) NOT NULL Billing Cycle Identifier, field used in Contracts Integration Message

18 BILL_INQUIRY_PHONE Character(24) VARCHAR2(24) NOT NULL Bill Inquiry Phone , used in Contracts Integration Message

19 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL This field stores the Bill Type Identifier.

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

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

22 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.
Prompt Table: CR_ANALYST_VW

23 INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Invoice Form

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

25 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

26 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

27 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).

28 DD_PROFILE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the Profile ID for a Direct Debit

29 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

30 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

31 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing
Y/N Table Edit
Default Value: Y

32 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO

33 START_DATE Date(10) DATE Start Date for Gen Standing PO

34 END_DATE Date(10) DATE End date field to store an end date.

35 MICR_ID Character(30) VARCHAR2(30) NOT NULL MICR ID

36 CONSOL_SETID Character(5) VARCHAR2(5) NOT NULL Consolidation Customer SetID

37 CONSOL_CUST_ID Character(15) VARCHAR2(15) NOT NULL Consolidation Customer ID

38 CONSOL_KEY Character(22) VARCHAR2(22) NOT NULL Invoice Consolidation Key

39 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
Y/N Table Edit
Default Value: N

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

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

42 DM_WRITE_OFF_AMT Number(27,3) DECIMAL(26,3) NOT NULL Deduction Write-off Amount

43 DM_WRITE_OFF_DAYS Number(3,0) SMALLINT NOT NULL Days Till Write-off

44 DM_WRITE_OFF_PCT Number(3,0) SMALLINT NOT NULL Deduction Write-off Percent

45 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

46 HOL_PROC_DAYS Number(3,0) SMALLINT NOT NULL Days before/after Holiday

47 HOL_PROC_OVERFL Character(1) VARCHAR2(1) NOT NULL Allow due date in next month
Y/N Table Edit
Default Value: Y

48 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

49 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

50 DEPOSIT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Deposit Percentage

51 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

52 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

53 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

54 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

55 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

56 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	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: PAY_TRMS_VW
5	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
6	GRACE_DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Due Grace Days
7	GRACE_DISC_DAYS	Number(3,0)	SMALLINT NOT NULL	Discount Grace Days
8	IMMEDIATE_PAYMENT	Character(1)	VARCHAR2(1) NOT NULL	Flag to determine if immediate payment is required. Y/N Table Edit Default Value: N
9	RETENTION_DAYS	Number(3,0)	SMALLINT NOT NULL	Closed Item Retention Days
10	PP_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Payment Predictor Hold Y/N Table Edit Default Value: N
11	PP_METHOD	Character(15)	VARCHAR2(15) NOT NULL	Payment Predictor Method
12	REF_QUALIFIER_CODE	Character(2)	VARCHAR2(2) NOT NULL	Reference Qualifier Code
13	PARTIAL_PY_SW	Character(1)	VARCHAR2(1) NOT NULL	Partial Payment Switch Y/N Table Edit Default Value: N
14	PO_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	PO Required Y/N Table Edit Default Value: N
15	BILL_BY_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill By Identifier, used in Contracts Integration message
16	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
17	BILL_CYCLE_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Cycle Identifier, field used in Contracts Integration Message
18	BILL_INQUIRY_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Bill Inquiry Phone , used in Contracts Integration Message
19	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Bill Type Identifier.
20	BILLING_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Billing Specialist, used in Contracts Integration message
21	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments. Prompt Table: COLLECTOR_VW
22	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. Prompt Table: CR_ANALYST_VW
23	INVOICE_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Invoice Form
24	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.
25	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
26	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
27	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).
28	DD_PROFILE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Profile ID for a Direct Debit
29	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
30	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
31	DIRECT_INVOICING	Character(1)	VARCHAR2(1) NOT NULL	Direct Invoicing Y/N Table Edit Default Value: Y
32	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
33	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
34	END_DATE	Date(10)	DATE	End date field to store an end date.
35	MICR_ID	Character(30)	VARCHAR2(30) NOT NULL	MICR ID
36	CONSOL_SETID	Character(5)	VARCHAR2(5) NOT NULL	Consolidation Customer SetID
37	CONSOL_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Consolidation Customer ID
38	CONSOL_KEY	Character(22)	VARCHAR2(22) NOT NULL	Invoice Consolidation Key
39	INTERUNIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	InterUnit Y/N Table Edit Default Value: N
40	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.
41	DM_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Deduction Specialist
42	DM_WRITE_OFF_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Deduction Write-off Amount
43	DM_WRITE_OFF_DAYS	Number(3,0)	SMALLINT NOT NULL	Days Till Write-off
44	DM_WRITE_OFF_PCT	Number(3,0)	SMALLINT NOT NULL	Deduction Write-off Percent
45	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
46	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
47	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Allow due date in next month Y/N Table Edit Default Value: Y
48	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
49	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
50	DEPOSIT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Deposit Percentage
51	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
52	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
53	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
54	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
55	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
56	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time