|
SELECT A.BUSINESS_UNIT , B.DESCR , B.DESCRSHORT , A.ELIMS_ONLY , A.AS_OF_DATE , A.BASE_CURRENCY , A.JRNL_BALANCE_OPTN , A.JRNL_EDIT_ERR_OPTN , A.JRNL_AMT_ERR_OPTN , A.JRNL_DT_ERR_OPTN , A.JRNL_DT_ERR_OPTN2 , A.CONTROL_TOTAL_OPTN , A.CURRENCY_BAL_OPTN , A.BASE_CUR_ADJ_OPTN , A.JRNL_FOREIGN_OPTN , A.ENABLE_UNPOST_DT , A.JRNL_APPRVL_OPTN , A.BD_JRNL_APPR_OPTN , A.BUSPROCNAME , A.APPR_RULE_SET , A.BUSPROCNAME_BD , A.APPR_RULE_SET_BD , A.TR_RVL_RATE_INDEX , A.TR_RVL_RT_TYPE , A.INT_ENTITYCD , A.EXT_ENTITYCD , A.PYMNT_METHOD , A.DOC_SEQ , A.DOC_TYPE , A.VAT_NRCVR_PRO_FLG , A.VAT_NRCVR_ALL_FLG , A.HOLIDAY_LIST_ID , A.POST_DATE_OPTN , A.PROCESS_DATE , A.IU_INTER_TMPLT_CD , A.IU_INTRA_TMPLT_CD , A.IU_LEGAL_ENT_BU , A.BUSINESS_UNIT_AP , A.VENDOR_SETID , A.VENDOR_ID , A.LOCATION , A.BUSINESS_UNIT_BI , A.CUST_ID , %subrec(CF14_AN_SBR, A) , A.PROJECT_ID , A.DEPTID , A.CUST_VNDR_AFFILIAT , A.LED_GRP_DEFAULT , A.PHYSICAL_NATURE FROM PS_BUS_UNIT_TBL_GL A , PS_BUS_UNIT_TBL_FS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 4 |
ELIMS_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
For Eliminations Only
|
| 5 |
AS_OF_DATE |
Date(10) |
DATE NOT NULL |
As of Date
Default Value: %date
|
| 6 |
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
|
| 7 |
JRNL_BALANCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Balance Option
D=Default to Higher Level Value
R=Recycle
S=Suspend
Default Value: R
|
| 8 |
JRNL_EDIT_ERR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Edit Errors Option
D=Default to Higher Level Value
R=Recycle
S=Suspend
Default Value: R
|
| 9 |
JRNL_AMT_ERR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
A Journal Edit option to decide if accept, error or suspense a journal line when foreign amount and monetary amount are different sign (i.e. one positive and the other negative).
A=Accept
D=Default to Higher Level Value
R=Recycle
S=Suspend
Default Value: R
|
| 10 |
JRNL_DT_ERR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Date < Open From Date
C=Change to Open From Date
D=Default to Higher Level Value
R=Recycle
Default Value: R
|
| 11 |
JRNL_DT_ERR_OPTN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Date > Open To Date
C=Change To Open To Date
D=Default to Higher Level Value
R=Recycle
Default Value: R
|
| 12 |
CONTROL_TOTAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Control Total Option
D=Default to Higher Level Value
N=N/A
R=Recycle
Default Value: R
|
| 13 |
CURRENCY_BAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Balancing Option
A=Balance by All Currencies
B=Balance by Base Currency Only
D=Default to Higher Level Value
Default Value: A
|
| 14 |
BASE_CUR_ADJ_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Base Currency Adjust Option
D=Default to Higher Level Value
N=Disallow Base Curr Adjustments
Y=Allow Base Curr Adjustments
Default Value: Y
|
| 15 |
JRNL_FOREIGN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Foreign Currencies per Journal
D=Default to Higher Level Value
M=Multiple Foreign Currencies
N=No Foreign Currencies
O=Only One Foreign Currency
Default Value: M
|
| 16 |
ENABLE_UNPOST_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Different Unpost Date
Y/N Table Edit
Default Value: N
|
| 17 |
JRNL_APPRVL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Approval Option
D=Default to Higher Level
P=Pre-Approved
S=Require Approval
Default Value: P
|
| 18 |
BD_JRNL_APPR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Journal Approval Optn
D=Default to Higher Level
P=Pre-Approved
S=Require Approval
Default Value: P
|
| 19 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table:
BUSPROCNAME_VW
|
| 20 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table:
APPR_RULE_BP_VW
|
| 21 |
BUSPROCNAME_BD |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name - Budget
Prompt Table:
BUSPROC_BD_VW
|
| 22 |
APPR_RULE_SET_BD |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set - Budgets
Prompt Table:
APPR_RULE_BD_VW
|
| 23 |
TR_RVL_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
The market rate index selected as applicable to mark-to-market revaluation events.
Prompt Table:
RT_INDEX_FX_VW
|
| 24 |
TR_RVL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
The market rate type selected as applicable to mark-to-market revaluation events.
Prompt Table:
RT_TYPE_TBL
|
| 25 |
INT_ENTITYCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Represents the EDI Manager internal entity code associated with a given general ledger business un
Prompt Table:
ECENTITYCDS
|
| 26 |
EXT_ENTITYCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Represents the EDI Manager external entity code associated with a given general ledger business un
Prompt Table:
ECENTITYCDS
|
| 27 |
PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
Prompt Table:
PYMNT_MTHD_VW
|
| 28 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
Y/N Table Edit
Default Value: N
|
| 29 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table:
DOC_TYPE_TBL
|
| 30 |
VAT_NRCVR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Non-Recoverable VAT
Y/N Table Edit
Default Value: Y
|
| 31 |
VAT_NRCVR_ALL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Non-Recoverable VAT
Y/N Table Edit
Default Value: N
|
| 32 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
Prompt Table:
BUS_CAL_HOL_DFN
|
| 33 |
POST_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Process Date Option
C=Current Date
P=Process Date
Default Value: C
|
| 34 |
PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 35 |
IU_INTER_TMPLT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Key to the interunit template record. Assigned to a GLBU on the GL business unit table.
Prompt Table:
IU_INTER_TMPLT
|
| 36 |
IU_INTRA_TMPLT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Key field for IntraUnit Template
Prompt Table:
IU_INTRA_TMPLT
|
| 37 |
IU_LEGAL_ENT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
The business unit that represents the legal entity to which the GL Unit belongs. May have the same value as the GL Unit if it is its own legal entity.
Default Value: BUS_UNIT_TBL_GL.BUSINESS_UNIT
Prompt Table:
IU_LEGAL_ENT_VW
|
| 38 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
SP_BUGLAP_NONVW
|
| 39 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table:
SP_SETID_NONVW
|
| 40 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
BI_IU_VNDR_VW
|
| 41 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
BI_IUVNDRLOC_VW
|
| 42 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table:
SP_BUGLBI_NONVW
|
| 43 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
IU_CUST_VW
|
| 44 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPER_UNIT_TBL
|
| 45 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_TBL
|
| 46 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_TBL
|
| 47 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASS_CF_TBL
|
| 48 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_TBL
|
| 49 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_TBL
|
| 50 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 51 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 52 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 53 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CHARTFIELD1_TBL
|
| 54 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CHARTFIELD2_TBL
|
| 55 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CHARTFIELD3_TBL
|
| 56 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PROJID_BUGL_VW
|
| 57 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 58 |
CUST_VNDR_AFFILIAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Vendor Affiliate
Y/N Table Edit
Default Value: N
|
| 59 |
LED_GRP_DEFAULT |
Character(10) |
VARCHAR2(10) NOT NULL |
Default Journal Generator Ledger Group of a Business Unit
|
| 60 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
Default Value: G
|