INSTALLATION_BI(SQL Table) |
Index Back |
|---|---|
System Options - PS/Billing |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INVOICE_NUMBERING | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Numbering Option
B=Business Unit O=Bill Source S=System T=Bill Type U=User Defined Default Value: B |
| 2 | CON_INV_NUM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Manual Line Numbering
Y/N Table Edit Default Value: N |
| 3 | IVC_NUM_ID | Character(8) | VARCHAR2(8) NOT NULL |
Invoice Number ID
Prompt Table: BI_IVC_NUM_VW |
| 4 | CON_IVC_NUM_ID | Character(8) | VARCHAR2(8) NOT NULL |
Consolidated Invoice Number ID
Prompt Table: BI_IVC_NUM_VW |
| 5 | TMP_IVC_NUM_ID | Character(8) | VARCHAR2(8) NOT NULL |
Temp Bill Invoice Num ID
Default Value: NBR-TMP Prompt Table: BI_IVC_NUM_VW |
| 6 | PNLSERIES_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Panel Series Option
B=Business Unit O=Bill Source S=System T=Bill Type Default Value: S |
| 7 | BI_PNLSERIES_ID | Character(8) | VARCHAR2(8) NOT NULL |
Page Series ID
Prompt Table: BI_PNLSERIESHDR |
| 8 | GL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
GL Options
B=Business Unit S=System T=Bill Type Default Value: S |
| 9 | 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 |
| 10 | AR_OPT | Character(1) | VARCHAR2(1) NOT NULL |
AR Options
B=Business Unit S=System T=Bill Type Default Value: S |
| 11 | 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 |
| 12 | AR_DST_OPT | Character(1) | VARCHAR2(1) NOT NULL |
AR Distribution Option
H=Use Header for Distribution L=Use Line for Distribution |
| 13 | 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 |
| 14 | 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 |
| 15 | ENABLE_DFR_REV_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Deferred Revenues
Y/N Table Edit Default Value: N |
| 16 | DFR_MID_PERIOD_DAY | Number(2,0) | SMALLINT NOT NULL | Mid-Period # of Days |
| 17 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: USA Prompt Table: COUNTRY_TBL |
| 18 | CURRENCY_CD_XEU | Character(3) | VARCHAR2(3) NOT NULL |
Euro Currency
Default Value: EUR Prompt Table: CURRENCY_CD_TBL |
| 19 | MAX_ROWS_SCROLL | Number(5,0) | INTEGER NOT NULL |
Max Number of Rows in Scrolls
Default Value: 20 |
| 20 | BI_ENTRY_MAX_ROWS | Number(5,0) | INTEGER NOT NULL |
Bill Entry Max Rows
Default Value: 5 |
| 21 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 22 | DTTM_STAMP | 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. |
| 23 | IVC_PRO_TOGGLE | Character(1) | VARCHAR2(1) NOT NULL | Invoice/Proforma Demand Toggle |
| 24 | COMBO_EDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit Default Value: Y |
| 25 | LAST_INTFC_ID | Number(8,0) | INTEGER NOT NULL | Last Interface ID |
| 26 | DATA_PARTITION_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Data Partition Option
0=No Partitioning 1=By Business Unit Default Value: 0 |
| 27 | ENABLE_FAX_IVC | Character(1) | VARCHAR2(1) NOT NULL |
Enable Fax Invoicing
Y/N Table Edit Default Value: N |
| 28 | SETID_FAX | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 29 | FAX_ID | Character(10) | VARCHAR2(10) NOT NULL |
Fax Location
Prompt Table:
FAX_LOCATION
|
| 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 | MANUAL_LIN_NUM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Manual Line Numbering
Y/N Table Edit Default Value: N |
| 35 | ACCTG_DISP_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Display Options
B=Business Unit O=Bill Source S=System T=Bill Type Default Value: S |
| 36 | TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL |
Project Template
Prompt Table: BI_CF_TMPLT_HDR |
| 37 | BI_HYPERLINK_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Bill Entry Hyperlink Option
E=Express Bill Entry S=Standard Bill Entry Default Value: S |
| 38 | BILL_LINE_ADD | Number(3,0) | SMALLINT NOT NULL |
Lines to Add
Default Value: 5 |
| 39 | ENABLE_EFFDT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Effdated Bill Entry
Y/N Table Edit Default Value: N |
| 40 | BUS_UNIT_LOOP_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Looping Option Flag
Y/N Table Edit Default Value: N |
| 41 | UPD_PC_FOR_AR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Update AR with PC Chartfield
Y/N Table Edit Default Value: N |
| 42 | UPD_PC_FOR_VT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Update VT with PC Chartfield
Y/N Table Edit Default Value: N |
| 43 | PROC_FTR_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Process Feature Security
Y/N Table Edit Default Value: N |
| 44 | ONLINE_IVC_RENDER | Character(1) | VARCHAR2(1) NOT NULL |
Enable Online Rendering
Y/N Table Edit Default Value: N |
| 45 | SF1034_1035_FLG | Character(1) | VARCHAR2(1) NOT NULL |
SF 1034/35 Invoice
Default Value: N |
| 46 | REGION_CODE | Character(2) | VARCHAR2(2) NOT NULL | Region Code identifies a specific region within a State. |
| 47 | STATE_US_NBR | Number(2,0) | SMALLINT NOT NULL | Numeric 2 position US state code. |
| 48 | FEDERAL_APPROP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
An indicator to specify which PC Chartfield is used to store the Federal Appropriation Number.
C=Category N=None S=SubCategory T=Source Type Default Value: T |
| 49 | FEDERAL_PROJ_FLG | Character(1) | VARCHAR2(1) NOT NULL |
An indicator to specify which PC Chartfield is used to store the Federal Appropriation Number.
C=Contract Number N=None P=Project ID Default Value: C |
| 50 | DEMO_ID_FLG | Character(1) | VARCHAR2(1) NOT NULL |
An indicator to specify which PC Chartfield is used to store the Federal Demo ID.
C=Category N=None S=SubCategory T=Source Type Default Value: N |
| 51 | SUMMARIZE_IVC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Summarize Invoice Flag
Y/N Table Edit Default Value: Y |
| 52 | DATE_OVERRIDE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow override of Id Date
Y/N Table Edit Default Value: N |
| 53 | COMBO_EDIT_BATCH | Character(1) | VARCHAR2(1) NOT NULL |
Combo Edit Batch
Y/N Table Edit Default Value: N |
| 54 | COMBO_EDIT_ONLINE | Character(1) | VARCHAR2(1) NOT NULL |
Combo Edit Online
Y/N Table Edit Default Value: N |
| 55 | CR_IVC_CHG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow CR Invoice Hdr Changes
Y/N Table Edit Default Value: Y |
| 56 | BI_AP_OPT | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit AP Options
B=Business Unit S=System T=Bill Type Default Value: S |
| 57 | 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 |
| 58 | BI_TO_PC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
manual billing requires contract info to write to Projects
Y/N Table Edit Default Value: Y |
| 59 | BI_PC_BATCH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
manual billing requires contract infor to write to Projects
Y/N Table Edit Default Value: Y |
| 60 | BI_DESCR_UPD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Update Bill Line Description
Y/N Table Edit Default Value: N |
| 61 | UPD_PC_FOR_GST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Update GST with PC Chartfield
Y/N Table Edit Default Value: N |
| 62 | BI_ACCT_DT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Accounting date edit option - billing installation
E=Error on Closed Period W=Warning on Closed Period Default Value: W |
| 63 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 64 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 65 | BI_DEL_ATT_AUTH | Character(1) | VARCHAR2(1) NOT NULL |
Authorize Delete Attachments
Y/N Table Edit Default Value: N |
| 66 | BI_OVR_CO_AN_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
Field for overriding collector and credit analyst default
Y/N Table Edit Default Value: N |