| # |
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 |
BP_DTL_TMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Plan Detail Template ID
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table:
SP_BU_BI_NONVW
|
| 5 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table:
BI_CYCLE_VW
|
| 6 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table:
BI_TYPE_EF_VW
|
| 7 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table:
BI_SRC_EF_VW
|
| 8 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
Prompt Table:
CA_BILL_TO_ALL
|
| 9 |
ADDR_SEQ_NUM_BILL |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
CABI_ADDR_VW
|
| 10 |
CNTCT_SEQ_BILL |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence - Bill To
Prompt Table:
CUST_CNCT_BI_VW
|
| 11 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
Prompt Table:
BI_BILL_BY
|
| 12 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
Prompt Table:
BI_INQPHONE_VW
|
| 13 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table:
BI_SPECIALST_VW
|
| 14 |
BILL_CUR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Currency
D=Contract Currency
M=Transaction Currency
|
| 15 |
PRE_APPROVAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre Approval Flag
Y/N Table Edit
|
| 16 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
Y/N Table Edit
|
| 17 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
Prompt Table:
BI_IVC_FORM_VW
|
| 18 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
Prompt Table:
BI_AUTH_EF_VW
|
| 19 |
TOLERANCE_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Tolerance Amount
|
| 20 |
LINKING_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Plan Line Creation Opt
I=Create individual lines
S=Create a summary line
Default Value: I
|
| 21 |
SUM_TEMPLATE_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Summarization Template ID
Prompt Table:
BI_SUM_TMPLT_VW
|
| 22 |
SUM_GROUP_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to provide additional grouping criteria for billing summarization. It is related to SUM_GROUP_ID. User defines a list of valid SUM_GROUP_IDs per SUM_GROUP_TYPE value.
Prompt Table:
CA_SGRP_TYP
|
| 23 |
SUM_GROUP_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
This field is used to provide additional grouping criteria for billing summarization. It is to be used with SUM_GROUP_TYPE. User defines a set of Summarization Group IDs per Summarization Group Type.
Prompt Table:
CA_S_GRP_ID
|
| 24 |
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
|
| 25 |
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
|