BU_DFHI_OPT_VW

(SQL View)
 Index Back

Bus Unit-Lvl Dflt Hier Opt Vw


SELECT A.BUSINESS_UNIT , B.BUSINESS_UNIT , B.BASE_CURRENCY , B.CUST_VNDR_AFFILIAT , C.DSCNT_PRORATE_FLG , C.MISC_PRORATE_FLG , C.FRGHT_PRORATE_FLG , C.SALETX_PRORATE_FLG , C.USETAX_PRORATE_FLG , C.VAT_NRCVR_PRO_FLG , C.VAT_NRCVR_CHRG_CD , C.SBI_DOC_OPT , A.ERS_TAX_TYPE_DFLT , C.ERS_TAX_TYPE , C.ACCT_DT_EDT_OPT , C.UNPOST_PAID_VCHR , D.ACCOUNTING_DT_IND , D.ACCOUNTING_DT , D.PYMNT_TERMS_CD , D.DFT_SIGHT_CD , D.PYMNT_DELAY_DAYS , D.DSCNT_DELAY_DAYS , D.HOL_PROC_OPT , D.HOL_PROC_DAYS , D.HOL_PROC_OVERFL , A.SHIPTO_ID , A.SHIPTO_ID , A.PAY_TRM_BSE_DT_OPT , A.DST_CNTRL_ID , A.HIDE_SUT_FLG , A.HIDE_VAT_FLG , A.VCHR_SUT_MSG_OPT , A.VCHR_VAT_MSG_OPT , A.SBI_DOC_DFLT , D.CURRENCY_CD , D.CUR_RT_TYPE , D.VCHR_APPRVL_FLG , D.BUSPROCNAME , D.APPR_RULE_SET , F.DOC_TYPE_ACCR , D.DUP_INVOICE_ACTION , D.DUP_INV_COMB_CODE , D.CHART_EDIT_OPTION , D.COMBO_EDIT_FLG , D.BANK_CD , D.BANK_ACCT_KEY , D.PYMNT_METHOD , D.PYMNT_HANDLING_CD , D.SALETX_TOL_PCT , D.SALETX_TOL_AMT , D.SALETX_TOL_CUR_CD , D.SALETX_TOL_RT_TYPE , E.COUNTRY , E.STATE , D.PAY_SCHEDULE_TYPE , A.LATE_CHRG_OPT , A.LATE_CHRG_CD , A.PROCESS_LINES_FLAG , E.COUNTRY , E.STATE , D.PHYSICAL_NATURE , A.ULTIMATE_USE_CD , D.VAT_SVC_PERFRM_FLG , A.MATCH_DELAY_DAYS , D.PREPAID_AUTO_APPLY FROM PS_BUS_UNIT_TBL_AP A , PS_BUS_UNIT_TBL_GL B , PS_BUS_UNIT_INTFC C , PS_BUS_UNIT_OPT_AP D , PS_LOCATION_TBL E , PS_BU_AP_GL_OPT F WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT_GL AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.BUSINESS_UNIT = F.BUSINESS_UNIT AND D.SETID = ( SELECT I.SETID FROM PS_SET_CNTRL_REC I WHERE I.SETCNTRLVALUE = A.BUSINESS_UNIT AND I.REC_GROUP_ID = 'AP_01' AND I.RECNAME = 'BUS_UNIT_OPT_AP') AND D.EFFDT = ( SELECT MAX(J.EFFDT) FROM PS_BUS_UNIT_OPT_AP J WHERE J.SETID = D.SETID AND J.EFFDT <= %CurrentDateIn AND J.EFF_STATUS = 'A') AND E.SETID = ( SELECT K.SETID FROM PS_SET_CNTRL_REC K WHERE K.SETCNTRLVALUE = A.BUSINESS_UNIT AND K.REC_GROUP_ID = 'FS_26' AND K.RECNAME = 'LOCATION_TBL') AND E.LOCATION = A.LOCATION AND E.EFFDT = ( SELECT MAX(L.EFFDT) FROM PS_LOCATION_TBL L WHERE L.SETID = E.SETID AND L.LOCATION = E.LOCATION AND L.EFFDT <= %CurrentDateIn AND L.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
3 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. "
4 CUST_VNDR_AFFILIAT Character(1) VARCHAR2(1) NOT NULL Customer Vendor Affiliate
5 DSCNT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Discount
6 MISC_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Miscellaneous Charge
7 FRGHT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Freight Charges
8 SALETX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Sales Tax
9 USETAX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Use Tax
10 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT
11 VAT_NRCVR_CHRG_CD Character(10) VARCHAR2(10) NOT NULL ProrateVAT Non-Recovery
12 SBI_DOC_OPT2 Character(1) VARCHAR2(1) NOT NULL Cloned from primary SBI_DOC_OPT field to support hierarchy defaulting in Voucher Edit process.
G=Group Vouchers
I=Individual Voucher
P=Invoice Number
13 ERS_TAX_TYPE Character(1) VARCHAR2(1) NOT NULL ERS Tax Type
B=Sales Tax
N=No Taxes
U=Use Tax
V=Value Added Tax
14 ERS_TAX_TYPE_DFLT Character(1) VARCHAR2(1) NOT NULL ERS Tax Type
B=Sales Tax
D=Default from Higher Level
N=No Taxes
U=Use Tax
V=Value Added Tax
15 ACCT_DT_EDT_OPT Character(1) VARCHAR2(1) NOT NULL Accounting Date Edit Option
E=Error Message
N=No Message
W=Warning Message
16 UNPOST_PAID_VCHR Character(1) VARCHAR2(1) NOT NULL Allow Unpost Paid Vouchers
17 ACCOUNTING_DT_IND Character(1) VARCHAR2(1) NOT NULL Accounting Date Indicator
C=Use Current Date
D=Business Unit Default
P=Use Payment Date
S=Use Specific Date
18 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
19 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.
20 DFT_SIGHT_CD Character(5) VARCHAR2(5) NOT NULL Draft Sight Code
21 PYMNT_DELAY_DAYS Signed Number(5,0) DECIMAL(4) NOT NULL Payment Delay Days
22 DSCNT_DELAY_DAYS Signed Number(5,0) DECIMAL(4) NOT NULL Discount Delay Days
23 HOL_PROC_OPT Character(1) VARCHAR2(1) NOT NULL Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
24 HOL_PROC_DAYS Number(3,0) SMALLINT NOT NULL Days before/after Holiday
25 HOL_PROC_OVERFL Character(1) VARCHAR2(1) NOT NULL Allow due date in next month
26 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
27 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
28 PAY_TRM_BSE_DT_OPT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Date Type
A=Acct Date
C=Doc Date
I=Inv Date
R=Recpt Date
S=Ship Date
U=User Date
29 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
30 HIDE_SUT_FLG Character(1) VARCHAR2(1) NOT NULL Hide Sales Use Tax
31 HIDE_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Hide Value Added Tax
32 VCHR_SUT_MSG_OPT Character(1) VARCHAR2(1) NOT NULL Sales and Use Tax Edit Message
E=Error Message
N=No Message
W=Warning Message
33 VCHR_VAT_MSG_OPT Character(1) VARCHAR2(1) NOT NULL Value Added Tax Edit Message
E=Error Message
N=No Messages
W=Warning Message
34 SBI_DOC_OPT Character(1) VARCHAR2(1) NOT NULL SelfBillingNumber
G=Group Vouchers (Auto-Num)
I=Individual Voucher (Auto-Num)
P=Individual Vchr-Invoice Number
35 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
36 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.
37 VCHR_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Voucher Approval Flag
D=Default from Higher Level
P=Pre-Approved
S=Virtual Approver
W=Approval Framework
38 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
39 APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set
40 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.
41 DUP_INVOICE_ACTION Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Severity
K=Reject
R=Recycle
W=Warning
42 DUP_INV_COMB_CODE Number(3,0) SMALLINT NOT NULL Dupl Invoice Combination Code
43 CHART_EDIT_OPTION Character(1) VARCHAR2(1) NOT NULL Chartfield Edit Option
D=Default from Higher Level
K=Reject w/ edit error
N=No Edits
R=Recycle
S=Use suspense account
W=Warning
44 COMBO_EDIT_FLG Character(1) VARCHAR2(1) NOT NULL Edit Combinations
45 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
46 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
47 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
48 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
49 SALETX_TOL_PCT Number(6,2) DECIMAL(5,2) NOT NULL Sales Tax Tolerance Percent
50 SALETX_TOL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Tolerance Amount
51 SALETX_TOL_CUR_CD Character(3) VARCHAR2(3) NOT NULL Sales Tax Tolerance Curr Code
52 SALETX_TOL_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Sales Tax Tolerance Rate Type
53 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
54 STATE_SHIP_TO Character(6) VARCHAR2(6) NOT NULL Ship To State
55 PAY_SCHEDULE_TYPE Character(3) VARCHAR2(3) NOT NULL Pay Schedule Type
MAN=Manual
OTH=Other Non Transportation
TRN=Transportation
56 LATE_CHRG_OPT Character(1) VARCHAR2(1) NOT NULL Late Charge Option
C=Compute Charges
N=Not Applicable
57 LATE_CHRG_CD Character(4) VARCHAR2(4) NOT NULL Late Charge Code
58 PROCESS_LINES_FLAG Character(1) VARCHAR2(1) NOT NULL Process order lines online
59 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner
60 STATE_LOC_BUYER Character(6) VARCHAR2(6) NOT NULL Buyer's Location State - May be either the VAT Entity or the Trading Partner
61 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
62 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code
63 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
64 MATCH_DELAY_DAYS Number(3,0) SMALLINT NOT NULL Match Delay Days
65 PREPAID_AUTO_APPLY Character(1) VARCHAR2(1) NOT NULL Automatically Apply Prepayment

Y/N Table Edit