CUSTOPT_TEO3

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for CUST_OPTION Date Init. Issue # Description 10/12/02 JJM F-C1ABANOS-36 Replaced DM write-off fields with MAX write-off fields

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

3 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

4 EFFDT Date(10) DATE NOT NULL Effective Date
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

6 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

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 GRACE_DUE_DAYS Number(3,0) SMALLINT NOT NULL Due Grace Days
9 GRACE_DISC_DAYS Number(3,0) SMALLINT NOT NULL Discount Grace Days
10 IMMEDIATE_PAYMENT Character(1) VARCHAR2(1) NOT NULL Immediate Payment Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

11 RETENTION_DAYS Number(3,0) SMALLINT NOT NULL Closed Item Retention Days
12 PP_HOLD Character(1) VARCHAR2(1) NOT NULL Payment Predictor Hold

Y/N Table Edit

Default Value: N

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

Prompt Table: PP_MET_TBL

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

Prompt Table: AR_FLD_REF_VW

15 PARTIAL_PY_SW Character(1) VARCHAR2(1) NOT NULL Partial Payment Switch

Y/N Table Edit

Default Value: N

16 PO_REQUIRED Character(1) VARCHAR2(1) NOT NULL Purchase Order Required

Y/N Table Edit

Default Value: N

17 BILL_BY_ID Character(10) VARCHAR2(10) NOT NULL Bill By Identifier

Prompt Table: BI_BILL_BY_VW

18 FREIGHT_BILL_TYPE Character(2) VARCHAR2(2) NOT NULL Freight Bill Type
OE=Order Entry
SH=Shipping

Default Value: SH

19 BILL_CYCLE_ID Character(10) VARCHAR2(10) NOT NULL Billing Cycle Identifier

Prompt Table: BI_CYCLE_VW

20 BILL_INQUIRY_PHONE Character(24) VARCHAR2(24) NOT NULL Bill Inquiry Phone

Prompt Table: BI_INQPHN_VW

21 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier

Prompt Table: BI_TYPE_EF_VW

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

Prompt Table: BI_SPCLST_VW

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

Prompt Table: BI_AUTH_EF_VW

24 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

25 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

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

Prompt Table: BI_IVC_FORM

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

Prompt Table: DST_CODE_AR_VW

28 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
29 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
30 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).

Prompt Table: DRAFT_TYPE_TBL

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

Prompt Table: DD_PROFILE_TBL

32 DD_GROUP Character(2) VARCHAR2(2) NOT NULL Direct Debit Group
%=All Groups
A=Group A
B=Group B
C=Group C
D=Group D
33 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

Default Value: CHK

34 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

Y/N Table Edit

Default Value: Y

35 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
36 START_DATE Date(10) DATE Start Date for Gen Standing PO
37 END_DATE Date(10) DATE End Date
38 MICR_ID Character(30) VARCHAR2(30) NOT NULL MICR ID

Prompt Table: REMIT_MICR_VW

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

Prompt Table: SP_SETID_NONVW

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

Prompt Table: CUST_CONSOL_VW

41 CONSOL_KEY Character(22) VARCHAR2(22) NOT NULL Invoice Consolidation Key
42 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes

Y/N Table Edit

Default Value: N

43 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BU_GL_NONVW

44 AR_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Accounts Recievable Specialist - person responsible for an action on an item.

Prompt Table: AR_SPCLST_VW

45 MAX_WRITE_OFF_AMT Number(27,3) DECIMAL(26,3) NOT NULL Maximum amount allowed for write off on worksheet
46 MAX_WRITE_OFF_DAYS Number(3,0) SMALLINT NOT NULL Write off Tolerance Days from Deduction date
47 MAX_WRITE_OFF_PCT Number(3,0) SMALLINT NOT NULL Write off Tolerance Percentage of amount
48 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

49 HOL_PROC_DAYS Number(3,0) SMALLINT NOT NULL Days before/after Holiday
50 HOL_PROC_OVERFL Character(1) VARCHAR2(1) NOT NULL Allow due date in next month

Y/N Table Edit

Default Value: Y

51 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

52 BI_PROMPT_CURR Character(1) VARCHAR2(1) NOT NULL Prompt for Billing Currency

Y/N Table Edit

Default Value: N

53 DEPOSIT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Deposit Percentage
54 DISPLAY_PRICES Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether to display prices.
55 CRCARD_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Credit Card Profile ID
56 PRENOTE_REQD Character(1) VARCHAR2(1) NOT NULL Prenotification Required

Y/N Table Edit

Default Value: N

57 PRENOTE_STATUS Character(1) VARCHAR2(1) NOT NULL Prenotification Status
C=Confirmed
N=New
P=Pending
R=Rejected
S=Submitted
58 PRENOTE_DATE Date(10) DATE Prenotification Date
59 PRENOTE_WAIT_DAYS Number(3,0) SMALLINT NOT NULL Prenote Wait Days (U.S.)
60 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: REASON_CD

61 UPDATED_BY Character(4) VARCHAR2(4) NOT NULL This field describes how the Prenote Status was updated.
BANK=Receive Bank EFT File process
CRDD=Create Direct Debits process
DDWS=Direct Debit Worksheet
FEFT=Format EFT File process
FGDS=Financial Gateway - Dispatched
FGPD=Financial Gateway - Paid
FGRJ=Financial Gateway - Rejected
FGWY=Financial Gateway
USER=User
62 HOLD_NBR_DAYS Number(3,0) SMALLINT NOT NULL Hold Number of Days
63 FED_HWY_FLG Character(1) VARCHAR2(1) NOT NULL Federal Highway File

Y/N Table Edit

Default Value: N

64 EIVC_FLG Character(1) VARCHAR2(1) NOT NULL Electronic Invoice

Y/N Table Edit

Default Value: N

65 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
66 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
67 MAXIMUM_INSTALL Number(3,0) SMALLINT NOT NULL Maximum Installemnts
68 MIN_SOURCE_BAL Number(10,0) DECIMAL(10) NOT NULL Minimum Source Balance
69 PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Plan type
A=Custom
C=Fixed Monthly Amounts
D=Number of Months
70 PROCESSING_FEE Character(1) VARCHAR2(1) NOT NULL Processing fee
F=Fixed Amount
P=Percentage of Plan Balance
71 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code