| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BILL_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Bill entry template ID
|
| 2 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 3 |
BI_HDTL_GRPBX_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill header details group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 4 |
BI_HDTL_GRPBX_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill header details group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 5 |
BI_CURR_GRPBX_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill header level bill currency information group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 6 |
BI_CURR_GRPBX_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill header level bill currency information group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 7 |
BI_OM_GRPBX_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill entry template header level Order Management group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 8 |
BI_OM_GRPBX_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill entry template header level Order Management group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 9 |
BI_PCCA_GRPBX_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill entry template header level Projects/Contracts group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 10 |
BI_PCCA_GRPBX_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill entry template header level Projects/Contracts group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 11 |
BI_SERV_GRPBX_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill entry template header level Service group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 12 |
BI_SERV_GRPBX_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill entry template header level Service group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 13 |
BI_CONSL_GRPBX_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill header level consolidation group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 14 |
BI_CONSL_GRPBX_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill header level consolidation group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 15 |
BI_LINE_TAB_CHKBX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill line grid Charge Details tab hide/unhide checkbox
Y/N Table Edit
Default Value: N
|
| 16 |
BI_NAMT_TAB_CHKBX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill line grid Net Amount tab hide/unhide checkbox
Y/N Table Edit
Default Value: N
|
| 17 |
BI_INFO_TAB_CHKBX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill line grid Line Information tab hide/unhide checkbox
Y/N Table Edit
Default Value: N
|
| 18 |
BI_PROD_TAB_CHKBX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill line grid Product tab switch
Y/N Table Edit
Default Value: N
|
| 19 |
BI_ORDER_TAB_CHKBX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill line grid Order tab hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 20 |
BI_SHIP_TAB_CHKBX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill line grid Shipment tab hide/unhide checkbox
Y/N Table Edit
Default Value: N
|
| 21 |
BI_MISC_TAB_CHKBX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill line grid Miscellaneous tab hide/unhide checkbox
Y/N Table Edit
Default Value: N
|
| 22 |
BI_PROJ_TAB_CHKBX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill line grid Project/Contracts tab switch
Y/N Table Edit
Default Value: N
|
| 23 |
BI_SERVC_TAB_CHKBX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill line grid Service tab hide/unhide checkbox
Y/N Table Edit
Default Value: N
|
| 24 |
BI_USERF_TAB_CHKBX |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill line grid User Fields tab hide/unhide checkbox
Y/N Table Edit
Default Value: N
|
| 25 |
BI_AR_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
AR accounting distribution group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 26 |
BI_AR_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
AR accounting distribution group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 27 |
BI_RR_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenu accounting distribution group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 28 |
BI_RR_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenu accounting distribution group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 29 |
BI_DR_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Deferred revenue accounting distribution group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 30 |
BI_DR_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Deferred revenue accounting distribution group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 31 |
BI_DR_ASW |
Character(1) |
VARCHAR2(1) NOT NULL |
Deferred revenue accounting distribution group box auto hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 32 |
BI_UAR_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Unbilled AR accounting distribution group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 33 |
BI_UAR_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Unbilled AR accounting distribution group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 34 |
BI_UAR_ASW |
Character(1) |
VARCHAR2(1) NOT NULL |
Unbilled AR accounting distribution group box auto hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 35 |
BI_IUE_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit expense accounting distribution group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 36 |
BI_IUE_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit expense accounting distribution group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 37 |
BI_IUE_ASW |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit expense accounting distribution group box auto hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 38 |
BI_IUP_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit payables accounting distribution group box auto collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 39 |
BI_IUP_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit payables accounting distribution group box hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 40 |
BI_IUP_ASW |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit payables accounting distribution group box auto hide/unhide switch
Y/N Table Edit
Default Value: N
|
| 41 |
BI_ST_CSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Statistical accounting distribution group box collapse/uncollapse switch
Y/N Table Edit
Default Value: N
|
| 42 |
BI_ST_HSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Statistical accounting distribution group box hide/unhide switch
Y/N Table Edit
Default Value: N
|