BC_BLLTO_OPT_VW

#	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	RETENTION_DAYS	Number(3,0)	SMALLINT NOT NULL	Closed Item Retention Days
9	IMMEDIATE_PAYMENT	Character(1)	VARCHAR2(1) NOT NULL	Flag to determine if immediate payment is required.
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_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
52	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.