| # |
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_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table:
BI_TYPE
|
| 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 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
Prompt Table:
BI_IVC_FORM_VW
|
| 8 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
Prompt Table:
BI_BILL_BY_VW
|
| 9 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table:
BI_CYCLE_VW
|
| 10 |
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
|
| 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 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
Prompt Table:
BI_INQPHN_VW
|
| 14 |
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
|
| 15 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table:
BI_SPCLST_VW
|
| 16 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
Prompt Table:
BI_AUTH_EF_VW
|
| 17 |
IVC_NUM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Invoice Number ID
Prompt Table:
BI_IVC_NUM_VW
|
| 18 |
CON_IVC_NUM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Consolidated Invoice Number ID
Prompt Table:
BI_IVC_NUM_VW
|
| 19 |
BI_PNLSERIES_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Page Series ID
Prompt Table:
BI_PNLSERIESHDR
|
| 20 |
GL_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Level
A=AR Creates GL Acct Entries
B=BI Creates GL Acct Entries
N=No GL Accounting Entries
|
| 21 |
AR_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Level
H=Header is AR Open Item
L=Bill Line is AR Open Item
N=No AR Open Items
|
| 22 |
AR_DST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Distribution Option
H=Use Header for Distribution
L=Use Line for Distribution
|
| 23 |
ENABLE_DFR_REV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Deferred Revenues
Y/N Table Edit
Default Value: N
|
| 24 |
DFR_ACCTG_DT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Future Period Accounting Dates
F=First Day in Accounting Period
L=Last Day in Accounting Period
U=User Defined
Default Value: L
|
| 25 |
DFR_REV_PRORATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Proration Method
1=By Days Within Range
2=Evenly Using All Pds
3=Evenly Using Mid-period Rule
4=Evenly/Partial by Days
5=User Defined Proration Method
Default Value: 1
|
| 26 |
REV_RECOG_BASIS |
Character(3) |
VARCHAR2(3) NOT NULL |
Revenue Recognition Basis
CHG=From/To Date Range
CON=Contract Date
INV=Invoice Date
ORD=Order Date
SHP=Ship Date
STE=Start/End Date Range
UD1=User Date 1
UD2=User Date 2
Default Value: INV
|
| 27 |
DFR_MID_PERIOD_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Mid-Period # of Days
|
| 28 |
DST_ID_DFR |
Character(10) |
VARCHAR2(10) NOT NULL |
Deferred Distribution Code
Prompt Table:
DST_CODE_DFR_VW
|
| 29 |
ACCRUE_UNBILLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Bills of This Level
Y/N Table Edit
Default Value: N
|
| 30 |
DST_ID_UAR |
Character(10) |
VARCHAR2(10) NOT NULL |
Contract Asset Distribution
Prompt Table:
DST_CODE_UAR_VW
|
| 31 |
ENTRY_TYPE_DB |
Character(5) |
VARCHAR2(5) NOT NULL |
Debit Entry Type
Prompt Table:
%EDITTABLE
|
| 32 |
ENTRY_REASON_DB |
Character(5) |
VARCHAR2(5) NOT NULL |
Debit Entry Reason
Prompt Table:
%EDITTABLE2
|
| 33 |
ENTRY_TYPE_CR |
Character(5) |
VARCHAR2(5) NOT NULL |
Credit Entry Type
Prompt Table:
%EDITTABLE3
|
| 34 |
ENTRY_REASON_CR |
Character(5) |
VARCHAR2(5) NOT NULL |
Credit Entry Reason
Prompt Table:
%EDITTABLE4
|
| 35 |
INSTALL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Installment Plan ID
Prompt Table:
BI_INSTALL_VW
|
| 36 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
Prompt Table:
BI_CF_TMPLT_HDR
|
| 37 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE1_VW
|
| 38 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 39 |
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
|
| 40 |
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
|
| 41 |
BILL_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Bill entry template ID
Prompt Table:
BI_BECFG_HDR
|
| 42 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 43 |
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.
|
| 44 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 45 |
BI_AP_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit AP Level
H=Header is AP Voucher
L=Bill Line is AP Voucher
N=No AP Voucher
|
| 46 |
USE_PC_CFS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Project ChartFields
Y/N Table Edit
Default Value: N
|
| 47 |
BI_FROM_EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
From Email Address
|
| 48 |
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
|
| 49 |
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
|