ORG_DFHI_OPT_VW(SQL View) |
Index Back |
---|---|
Origin-Lvl Dflt Hier Opt View |
SELECT A.BUSINESS_UNIT , B.ORIGIN , B.ACCOUNTING_DT_IND , B.ACCOUNTING_DT , B.PYMNT_TERMS_CD , B.DFT_SIGHT_CD , B.DST_CNTRL_ID , B.CURRENCY_CD , B.CUR_RT_TYPE , B.VCHR_APPRVL_FLG , B.BUSPROCNAME , B.APPR_RULE_SET , B.DOC_TYPE_FLG , B.DOC_TYPE , B.DUP_INVOICE_IND , B.DUP_INVOICE_ACTION , B.DUP_INV_COMB_CODE , B.CHART_EDIT_OPTION , B.COMBO_EDIT_FLG , B.SHIPTO_ID , B.SUT_BASE_ID , B.SALETX_TOL_FLG , B.SALETX_TOL_PCT , B.SALETX_TOL_AMT , B.SALETX_TOL_CUR_CD , B.SALETX_TOL_RT_TYPE , B.PAY_SCHEDULE_TYPE , B.LATE_CHRG_FLG , B.LATE_CHRG_OPT , B.LATE_CHRG_CD , B.BANK_CD , B.BANK_ACCT_KEY , B.PYMNT_HANDLING_CD , B.PHYSICAL_NATURE , B.ULTIMATE_USE_CD , B.VAT_SVC_PERFRM_FLG , B.MATCH_DELAY_DAYS , B.MATCH_DELAY_FLG FROM PS_BUS_UNIT_TBL_AP A , PS_ORIGIN_AP_OPT B , PS_SET_CNTRL_REC I WHERE B.SETID = I.SETID AND I.SETCNTRLVALUE = A.BUSINESS_UNIT AND I.REC_GROUP_ID = 'AP_04' AND I.RECNAME = 'ORIGIN_AP_OPT' AND B.EFFDT = ( SELECT MAX(J.EFFDT) FROM PS_ORIGIN_AP_OPT J WHERE J.SETID = B.SETID AND J.ORIGIN = B.ORIGIN AND J.EFFDT <= %CurrentDateIn) AND B.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 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL | Origin |
3 | 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 |
4 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
5 | 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. |
6 | DFT_SIGHT_CD | Character(5) | VARCHAR2(5) NOT NULL | Draft Sight Code |
7 | DST_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL | Accounting Template |
8 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
9 | 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. |
10 | 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 |
11 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
12 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
13 | DOC_TYPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Document Type Flag
D=Default from Higher Level S=Specify at This level |
14 | 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. |
15 | DUP_INVOICE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Invoice Indicator
D=Default from Higher Level S=Specify at this Level |
16 | DUP_INVOICE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Invoice Severity
K=Reject R=Recycle W=Warning |
17 | DUP_INV_COMB_CODE | Number(3,0) | SMALLINT NOT NULL | Dupl Invoice Combination Code |
18 | 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 |
19 | COMBO_EDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Edit Combinations |
20 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
21 | SUT_BASE_ID | Character(10) | VARCHAR2(10) NOT NULL | Sales/Use Tax Destination |
22 | SALETX_TOL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax Tolerance Flag
D=Default from Higher Level S=Specify at this Level |
23 | SALETX_TOL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Sales Tax Tolerance Percent |
24 | SALETX_TOL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Tolerance Amount |
25 | SALETX_TOL_CUR_CD | Character(3) | VARCHAR2(3) NOT NULL | Sales Tax Tolerance Curr Code |
26 | SALETX_TOL_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Sales Tax Tolerance Rate Type |
27 | PAY_SCHEDULE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Pay Schedule Type
MAN=Manual OTH=Other Non Transportation TRN=Transportation |
28 | LATE_CHRG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Late Charges
D=Default from Higher Level S=Specify |
29 | LATE_CHRG_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Late Charge Option
C=Compute Charges N=Not Applicable |
30 | LATE_CHRG_CD | Character(4) | VARCHAR2(4) NOT NULL | Late Charge Code |
31 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
32 | 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 |
33 | PYMNT_HANDLING_CD | Character(2) | VARCHAR2(2) NOT NULL | Payment Handling |
34 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
35 | ULTIMATE_USE_CD | Character(8) | VARCHAR2(8) NOT NULL | Ultimate Use Code |
36 | 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 |
37 | MATCH_DELAY_DAYS | Number(3,0) | SMALLINT NOT NULL | Match Delay Days |
38 | MATCH_DELAY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
To indicate whether Match Delay Days is specified at this level or to be defaulted from higher level in the AP defaulting hierarchy.
D=Default from Higher Level S=Specified at This Level |