| # |
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 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table:
BI_SRC
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 7 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table:
BI_CYCLE_VW
|
| 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.
Prompt Table:
AR_TRMS_VW
|
| 9 |
DESTINATION_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Destination
|
| 10 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
Prompt Table:
BI_INQPHN_VW
|
| 11 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_BI_BR_VW
|
| 12 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table:
BI_BANK_R_VW
|
| 13 |
IVC_NUM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Invoice Number ID
Prompt Table:
BI_IVC_NUM_VW
|
| 14 |
CON_IVC_NUM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Consolidated Invoice Number ID
Prompt Table:
BI_IVC_NUM_VW
|
| 15 |
BI_PNLSERIES_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Page Series ID
Prompt Table:
BI_PNLSERIESHDR
|
| 16 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
Prompt Table:
BI_IVC_FORM_VW
|
| 17 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
Prompt Table:
BI_BILL_BY_VW
|
| 18 |
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_VW2
|
| 19 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table:
BI_SPECIALIST
|
| 20 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
Prompt Table:
BI_AUTH_EF_VW
|
| 21 |
ENTRY_TYPE_DB |
Character(5) |
VARCHAR2(5) NOT NULL |
Debit Entry Type
Prompt Table:
%EDITTABLE
|
| 22 |
ENTRY_REASON_DB |
Character(5) |
VARCHAR2(5) NOT NULL |
Debit Entry Reason
Prompt Table:
%EDITTABLE2
|
| 23 |
ENTRY_TYPE_CR |
Character(5) |
VARCHAR2(5) NOT NULL |
Credit Entry Type
Prompt Table:
%EDITTABLE3
|
| 24 |
ENTRY_REASON_CR |
Character(5) |
VARCHAR2(5) NOT NULL |
Credit Entry Reason
Prompt Table:
%EDITTABLE4
|
| 25 |
INSTALL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Installment Plan ID
Prompt Table:
BI_INSTALL_VW
|
| 26 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
Prompt Table:
BI_CF_TMPLT_HDR
|
| 27 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 28 |
VAT_SVC_PERFRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
|
| 29 |
ATT_IVC_IMG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Attach Invoice Image Option
0=Do not Attach Invoice Image
1=Attach Invoice Image
9=Not Defined at this level
Default Value: 9
|
| 30 |
BILL_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Bill entry template ID
Prompt Table:
BI_BECFG_HDR
|
| 31 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 32 |
LAST_UPDATE_DTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 33 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 34 |
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_TBL
|
| 35 |
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_TBL
|