BU_LVL_DFHI_VW

(SQL View)
 Index Back

Bus Unit-Lvl Dflt Hier Opt Vw


SELECT A.BUSINESS_UNIT , A.DST_CNTRL_ID , A.SHIPTO_ID , A.SHIPTO_ID , A.LOCATION , A.VCHR_SUT_MSG_OPT , A.TAX_ADJ_DIFF_OPT , A.HIDE_SUT_FLG , A.ULTIMATE_USE_CD , A.VCHR_VAT_MSG_OPT , A.HIDE_VAT_FLG , A.COPYTO_GROSS_AMT , A.HOL_PROC_LVL , A.HOLIDAY_LIST_ID , A.USE_BUS_DAY_FLG , A.GO_NXT_PRV_FLG , A.PAY_TRM_BSE_DT_OPT , A.LATE_CHRG_OPT , A.LATE_CHRG_CD , A.VOUCHER_NUM_OPTION , A.PROCESS_LINES_FLAG , B.BUSINESS_UNIT , B.BASE_CURRENCY , B.CUST_VNDR_AFFILIAT , C.ACCTG_POLICY , C.ACCR_DSCNT_LOST_FL , C.DOC_TOL_OPT , C.ACCT_DT_EDT_OPT , C.UNPOST_PAID_VCHR , C.SALETX_CHARGE_CODE , C.SALETX_PRORATE_FLG , C.SALETX_ALLOC_FLG , C.USETAX_CHARGE_CODE , C.USETAX_PRORATE_FLG , C.USETAX_ALLOC_FLG , C.FRGHT_CHARGE_CODE , C.FRGHT_PRORATE_FLG , C.FRGHT_ALLOC_FLG , C.MISC_CHARGE_CODE , C.MISC_PRORATE_FLG , C.MISC_ALLOC_FLG , C.VAT_NRCVR_CHRG_CD , C.VAT_NRCVR_PRO_FLG , C.VAT_NRCVR_ALL_FLG , C.APPL_JRNL_ID_ACCR , C.ERS_OPT , C.ERS_INV_DT_OPT , C.SBI_DOC_OPT , C.ERS_TAX_TYPE , D.ACCOUNTING_DT_IND , D.ACCOUNTING_DT , D.VCHR_APPRVL_FLG , D.BUSPROCNAME , D.APPR_RULE_SET , D.CURRENCY_CD , D.CUR_RT_TYPE , D.VENDOR_ID , 'S' , D.DUP_INV_NUM_FLG , D.DUP_INV_DT , D.DUP_INV_VENDOR_NUM , D.DUP_INV_GROSS_AMT , D.DUP_INV_BUS_UNIT , D.DUP_INV_COMB_CODE , D.DUP_INVOICE_ACTION , D.CHART_EDIT_OPTION , D.COMBO_EDIT_FLG , D.VCHR_BALANCE_OPT , D.PYMNT_TERMS_CD , D.PYMNT_METHOD , D.PYMNT_DELAY_DAYS , D.DSCNT_DELAY_DAYS , D.PYMNT_TERMS_CD_PPY , D.DFT_SIGHT_CD , D.BANK_CD , D.BANK_ACCT_KEY , D.PYMNT_HANDLING_CD , D.HOL_PROC_OPT , D.HOL_PROC_DAYS , D.HOL_PROC_OVERFL , D.PAY_SCHEDULE_TYPE , D.DATE_CALC_BASIS , D.SALETX_TOL_PCT , D.SALETX_TOL_AMT , D.SALETX_TOL_CUR_CD , D.SALETX_TOL_RT_TYPE , E.DOC_TYPE_ACCR , E.DOC_TYPE_PREPAY , F.COUNTRY , F.STATE , D.ENABLE_DCM_FLG , D.DCM_AUTO_HOLD , D.DCM_NOTIFY_OPTION , D.DCM_NOTIFY_ROLE , D.DCM_ORIGIN , D.DCM_AUTO_RUN , D.DCM_INC_DIST 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_BU_AP_GL_OPT E , PS_LOCATION_TBL F WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT_GL AND C.BUSINESS_UNIT = B.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.BUSINESS_UNIT = C.BUSINESS_UNIT AND F.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 F.LOCATION = A.LOCATION AND F.EFFDT = ( SELECT MAX(L.EFFDT) FROM PS_LOCATION_TBL L WHERE L.SETID = F.SETID AND L.LOCATION = F.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 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
3 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
4 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
5 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
6 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
7 TAX_ADJ_DIFF_OPT Character(1) VARCHAR2(1) NOT NULL SUT Difference Opt
A=Accrue Difference
N=Not Applicable
S=Short Pay
8 HIDE_SUT_FLG Character(1) VARCHAR2(1) NOT NULL Hide Sales Use Tax
9 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code
10 VCHR_VAT_MSG_OPT Character(1) VARCHAR2(1) NOT NULL Value Added Tax Edit Message
E=Error Message
N=No Messages
W=Warning Message
11 HIDE_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Hide Value Added Tax
12 COPYTO_GROSS_AMT Character(1) VARCHAR2(1) NOT NULL Copy Gross Amount to Voucher
13 HOL_PROC_LVL Character(1) VARCHAR2(1) NOT NULL Holiday Processing level
B=Specify Calendar at Bank level
U=Specify Calendar
14 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.
15 USE_BUS_DAY_FLG Character(1) VARCHAR2(1) NOT NULL Use Business Day
16 GO_NXT_PRV_FLG Character(1) VARCHAR2(1) NOT NULL Go Next or Prior Business Day
N=Next Business Day
P=Prior Business Day
17 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
18 LATE_CHRG_OPT Character(1) VARCHAR2(1) NOT NULL Late Charge Option
C=Compute Charges
N=Not Applicable
19 LATE_CHRG_CD Character(4) VARCHAR2(4) NOT NULL Late Charge Code
20 VOUCHER_NUM_OPTION Character(1) VARCHAR2(1) NOT NULL Voucher Numbering
21 PROCESS_LINES_FLAG Character(1) VARCHAR2(1) NOT NULL Process order lines online
22 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
23 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. "
24 CUST_VNDR_AFFILIAT Character(1) VARCHAR2(1) NOT NULL Customer Vendor Affiliate
25 ACCTG_POLICY Character(1) VARCHAR2(1) NOT NULL Accounting Policy
G=Gross
N=Net
26 ACCR_DSCNT_LOST_FL Character(1) VARCHAR2(1) NOT NULL Used in the Procurement Accounting Controls to determine the method used for Posting Net vouchers. If Yes, use the new German requirement and book the APA at Gross. If No, book the APA at Net.
27 DOC_TOL_OPT Character(1) VARCHAR2(1) NOT NULL Enable Document Tolerance
28 ACCT_DT_EDT_OPT Character(1) VARCHAR2(1) NOT NULL Accounting Date Edit Option
E=Error Message
N=No Message
W=Warning Message
29 UNPOST_PAID_VCHR Character(1) VARCHAR2(1) NOT NULL Allow Unpost Paid Vouchers
30 SALETX_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
31 SALETX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Sales Tax
32 SALETX_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allocate Sales Tax
33 USETAX_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
34 USETAX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Use Tax
35 USETAX_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allocate Use Tax
36 FRGHT_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
37 FRGHT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Freight Charges
38 FRGHT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allocate Freight
39 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
40 MISC_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Miscellaneous Charge
41 MISC_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allocate Miscellaneous Charges
42 VAT_NRCVR_CHRG_CD Character(10) VARCHAR2(10) NOT NULL ProrateVAT Non-Recovery
43 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT
44 VAT_NRCVR_ALL_FLG Character(1) VARCHAR2(1) NOT NULL Allocate Non-Recoverable VAT
45 APPL_JRNL_ID_ACCR Character(10) VARCHAR2(10) NOT NULL Accruals
46 ERS_OPT Character(1) VARCHAR2(1) NOT NULL ERS Option
N=No ERS
Y=Allow ERS
47 ERS_INV_DT_OPT Character(1) VARCHAR2(1) NOT NULL ERS Invoice Date Option
F=Frt Terms
R=Recv Date
48 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
49 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
50 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
51 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
52 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
53 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
54 APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set
55 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
56 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.
57 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
58 DUP_INVOICE_IND Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Indicator
D=Default from Higher Level
S=Specify at this Level
59 DUP_INV_NUM_FLG Character(1) VARCHAR2(1) NOT NULL Invoice Number
N=No
Y=Yes
60 DUP_INV_DT Character(1) VARCHAR2(1) NOT NULL Invoice Date
N=No
Y=Yes
61 DUP_INV_VENDOR_NUM Character(1) VARCHAR2(1) NOT NULL Vendor ID
N=No
Y=Yes
62 DUP_INV_GROSS_AMT Character(1) VARCHAR2(1) NOT NULL Gross Amount
N=No
Y=Yes
63 DUP_INV_BUS_UNIT Character(1) VARCHAR2(1) NOT NULL Business Unit
N=No
Y=Yes
64 DUP_INV_COMB_CODE Number(3,0) SMALLINT NOT NULL Dupl Invoice Combination Code
65 DUP_INVOICE_ACTION Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Severity
K=Reject
R=Recycle
W=Warning
66 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
67 COMBO_EDIT_FLG Character(1) VARCHAR2(1) NOT NULL Edit Combinations
68 VCHR_BALANCE_OPT Character(1) VARCHAR2(1) NOT NULL Voucher Balance Option
D=Default from Higher Level
K=Reject Unbalanced Vouchers
R=Recycle Unbalanced Vouchers
69 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.
70 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
71 PYMNT_DELAY_DAYS Signed Number(5,0) DECIMAL(4) NOT NULL Payment Delay Days
72 DSCNT_DELAY_DAYS Signed Number(5,0) DECIMAL(4) NOT NULL Discount Delay Days
73 PYMNT_TERMS_CD_PPY 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.
74 DFT_SIGHT_CD Character(5) VARCHAR2(5) NOT NULL Draft Sight Code
75 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
76 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
77 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
78 HOL_PROC_OPT Character(1) VARCHAR2(1) NOT NULL Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
79 HOL_PROC_DAYS Number(3,0) SMALLINT NOT NULL Days before/after Holiday
80 HOL_PROC_OVERFL Character(1) VARCHAR2(1) NOT NULL Allow due date in next month
81 PAY_SCHEDULE_TYPE Character(3) VARCHAR2(3) NOT NULL Pay Schedule Type
MAN=Manual
OTH=Other Non Transportation
TRN=Transportation
82 DATE_CALC_BASIS Character(1) VARCHAR2(1) NOT NULL Date Calculation Basis
A=Agricultural Commodities
D=Dairy
M=Meat
O=Poultry
P=Prompt Pay Basis 7 Days
Q=Prompt Pay Basis 14 Days
83 SALETX_TOL_PCT Number(6,2) DECIMAL(5,2) NOT NULL Sales Tax Tolerance Percent
84 SALETX_TOL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Tolerance Amount
85 SALETX_TOL_CUR_CD Character(3) VARCHAR2(3) NOT NULL Sales Tax Tolerance Curr Code
86 SALETX_TOL_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Sales Tax Tolerance Rate Type
87 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.
88 DOC_TYPE_PREPAY Character(8) VARCHAR2(8) NOT NULL Document Type Prepayments
89 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
90 STATE_SHIP_TO Character(6) VARCHAR2(6) NOT NULL Ship To State
91 ENABLE_DCM_FLG Character(1) VARCHAR2(1) NOT NULL Enable Document Content Management Invoice Integration
92 DCM_AUTO_HOLD Character(1) VARCHAR2(1) NOT NULL DCM Auto Hold
H=All Invoices Must Be Reviewed
L=Process Valid Invoices
93 DCM_NOTIFY_OPTION Character(1) VARCHAR2(1) NOT NULL Notification option
E=Email Notification
N=No Notification
94 DCM_NOTIFY_ROLE Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table
95 DCM_ORIGIN Character(3) VARCHAR2(3) NOT NULL Default origin for Imaging invoices
96 DCM_AUTO_RUN Character(1) VARCHAR2(1) NOT NULL Auto Run Voucher Build
97 DCM_INC_DIST Character(1) VARCHAR2(1) NOT NULL Allow Incomplete distribution