| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_BI_NONVW
|
| 2 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
Prompt Table:
SP_BUARDS_NONVW
|
| 3 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 4 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table:
CURRENCY_CD_TBL
|
| 5 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 6 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 7 |
IVC_NUM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Invoice Number ID
Prompt Table:
BI_IVC_NUM_VW
|
| 8 |
CON_IVC_NUM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Consolidated Invoice Number ID
Prompt Table:
BI_IVC_NUM_VW
|
| 9 |
BI_PNLSERIES_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Page Series ID
Prompt Table:
BI_PNLSERIESHDR
|
| 10 |
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
|
| 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 |
ENTRY_TYPE_DB |
Character(5) |
VARCHAR2(5) NOT NULL |
Debit Entry Type
Prompt Table:
%EDITTABLE
Set Control Field: BUSINESS_UNIT_AR
|
| 14 |
ENTRY_REASON_DB |
Character(5) |
VARCHAR2(5) NOT NULL |
Debit Entry Reason
Prompt Table:
%EDITTABLE2
Set Control Field: BUSINESS_UNIT_AR
|
| 15 |
ENTRY_TYPE_CR |
Character(5) |
VARCHAR2(5) NOT NULL |
Credit Entry Type
Prompt Table:
%EDITTABLE3
Set Control Field: BUSINESS_UNIT_AR
|
| 16 |
ENTRY_REASON_CR |
Character(5) |
VARCHAR2(5) NOT NULL |
Credit Entry Reason
Prompt Table:
%EDITTABLE4
Set Control Field: BUSINESS_UNIT_AR
|
| 17 |
ENABLE_DFR_REV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Deferred Revenues
Y/N Table Edit
Default Value: N
|
| 18 |
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
|
| 19 |
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
|
| 20 |
DFR_MID_PERIOD_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Mid-Period # of Days
|
| 21 |
ENABLE_ACCRUED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Contract Asset Accrual
Y/N Table Edit
Default Value: N
|
| 22 |
APPL_JRNL_ID_RVRSL |
Character(10) |
VARCHAR2(10) NOT NULL |
Accrued Journal Template
Prompt Table:
BI_JRNL_RVRSL_V
|
| 23 |
DST_ID_UAR |
Character(10) |
VARCHAR2(10) NOT NULL |
Contract Asset Distribution
Prompt Table:
DST_CODE_UAR_VW
|
| 24 |
ACCRUE_UNBILLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Bills of This Level
Y/N Table Edit
|
| 25 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
Prompt Table:
JRNLGEN_APPL_ID
|
| 26 |
GROUP_ID_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Group ID
|
| 27 |
TAX_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Provider
A=Taxware
N=None
V=Vertex
Default Value: N
|
| 28 |
TAX_COMPANY |
Character(5) |
VARCHAR2(5) NOT NULL |
Company for Tax Suppliers
|
| 29 |
TAX_DIVISION |
Character(5) |
VARCHAR2(5) NOT NULL |
Division for Tax Suppliers
|
| 30 |
TAX_DEPARTMENT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department used by Tax Vendors
|
| 31 |
ORD_ACCEPT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Acceptance
Prompt Table:
LOCATION_TBL
|
| 32 |
ORD_ORIGIN_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Origin
Prompt Table:
LOCATION_TBL
|
| 33 |
DST_ID_SUT |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Distribution Code
Prompt Table:
DST_CODE_SUT_VW
|
| 34 |
DST_ID_GST |
Character(10) |
VARCHAR2(10) NOT NULL |
GST Distribution Code
Prompt Table:
DST_CODE_GST_VW
|
| 35 |
ORIGIN_AP |
Character(3) |
VARCHAR2(3) NOT NULL |
AP Origin ID
Prompt Table:
ORIGINAP_BI_VW
|
| 36 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 37 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
Prompt Table:
BI_CF_TMPLT_HDR
|
| 38 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE1_VW
|
| 39 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
Default Value: G
|
| 40 |
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
Default Value: 1
|
| 41 |
AG_CONTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Acceptgiro Contract - inital implementation wil only include type A/S, future enhancements may include additional Acceptgiro types.
0=None
1=A/S Contract
Default Value: 0
|
| 42 |
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: 0
|
| 43 |
BILL_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Bill entry template ID
Prompt Table:
BI_BECFG_HDR
|
| 44 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 45 |
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.
|
| 46 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 47 |
BU_FSS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
02/15/06 EGS: Created
Y/N Table Edit
Default Value: N
|
| 48 |
BI_APPROVAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Invoice Approvals
Y/N Table Edit
Default Value: N
|
| 49 |
ONLY_APPR_CREDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Only Submit Credits
Y/N Table Edit
Default Value: N
|
| 50 |
ACCRUE_USE_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Use Tax
Y/N Table Edit
Default Value: N
|
| 51 |
DST_ID_UT_OFFSET |
Character(10) |
VARCHAR2(10) NOT NULL |
Use Tax Offset Distribution Co
Prompt Table:
DST_CODE_TBL
|
| 52 |
DST_ID_USETAX |
Character(10) |
VARCHAR2(10) NOT NULL |
Use Tax Distribution Code
Prompt Table:
DST_CODE_TBL
|
| 53 |
EOAWPRCS_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table:
BI_EOAW_TXN_VW
|
| 54 |
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
|
| 55 |
SCM_CCI_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Credit Card Group
Prompt Table:
SCM_CC_GROUP_VW
|
| 56 |
CC_TYPE_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Credit Card Type
Y/N Table Edit
|
| 57 |
BI_WRKSHT_APP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Worksheet Approval
Y/N Table Edit
Default Value: N
|
| 58 |
THRESHOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Threshold Checking
Y/N Table Edit
Default Value: N
|
| 59 |
BI_THRESHOLD_LIMIT |
Number(20,0) |
DECIMAL(20) NOT NULL |
Threshold Invoice Amount
|
| 60 |
BI_FROM_EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
From Email Address
|