ORIGAPOPT_TEO2(SQL Table) |
Index Back |
|---|---|
AP Origin Process Options |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | 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 |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SETID_TBL |
| 4 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL | Origin |
| 5 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 7 | POST_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Posting Option
Y/N Table Edit Default Value: Y |
| 8 | 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 Default Value: D |
| 9 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 11 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: CUR_RT_TYPE_TBL |
| 12 | DUP_INVOICE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Invoice Indicator
D=Default from Higher Level S=Specify at this Level Default Value: D |
| 13 | DUP_INVOICE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Invoice Severity
K=Reject R=Recycle W=Warning Default Value: K |
| 14 | DUP_INV_NUM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Number
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 15 | DUP_INV_DT | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Date
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 16 | DUP_INV_VENDOR_NUM | Character(1) | VARCHAR2(1) NOT NULL |
Vendor ID
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 17 | DUP_INV_GROSS_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Gross Amount
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 18 | DUP_INV_BUS_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 19 | DUP_INV_COMB_CODE | Number(3,0) | SMALLINT NOT NULL | Dupl Invoice Combination Code |
| 20 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_VW |
| 21 | 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
Prompt Table: BANK_ACCT_TBL |
| 22 | GRP_AP_POST_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Post Option
1=Post Vouchers as Group 2=Post Vouchers Individually Default Value: 1 |
| 23 | 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 Default Value: D |
| 24 | 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 Default Value: D |
| 25 | COMBO_EDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit Default Value: N |
| 26 | 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.
Prompt Table: PYMT_TR_EFF_VW |
| 27 | PYMNT_HANDLING_CD | Character(2) | VARCHAR2(2) NOT NULL |
Payment Handling
Prompt Table: PYMNT_HNDL_TBL |
| 28 | DST_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table: DST_CNTRL_VW |
| 29 | 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 Default Value: D |
| 30 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: BUSPROCNAME_VW |
| 31 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table: APPR_RULE_HDR |
| 32 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table: SHIPTO_TBL |
| 33 | SUT_BASE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
Prompt Table: SHIPTO_TBL |
| 34 | SHIP_LOC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ship To/End Location Flag
D=Default from Higher Level S=Specify at this Level Default Value: D |
| 35 | SALETX_TOL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax Tolerance Flag
D=Default from Higher Level S=Specify at this Level Default Value: D |
| 36 | SALETX_TOL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Sales Tax Tolerance Percent |
| 37 | SALETX_TOL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Tolerance Amount |
| 38 | SALETX_TOL_CUR_CD | Character(3) | VARCHAR2(3) NOT NULL |
Sales Tax Tolerance Curr Code
Prompt Table: CURRENCY_CD_TBL |
| 39 | SALETX_TOL_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Sales Tax Tolerance Rate Type
Prompt Table: RT_TYPE_TBL |
| 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.
Prompt Table: DOC_TYPE_TBL |
| 41 | DOC_TYPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Document Type Flag
D=Default from Higher Level S=Specify at This level Default Value: D |
| 42 | DFT_SIGHT_CD | Character(5) | VARCHAR2(5) NOT NULL |
Draft Sight Code
Prompt Table: APD_SIGHTCD_TBL |
| 43 | 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 |
| 44 | PAY_SCHEDULE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Pay Schedule Type
MAN=Manual OTH=Other Non Transportation TRN=Transportation |
| 45 | LATE_CHRG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Late Charges
D=Default from Higher Level S=Specify Default Value: D |
| 46 | LATE_CHRG_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Late Charge Option
C=Compute Charges N=Not Applicable Default Value: N |
| 47 | LATE_CHRG_CD | Character(4) | VARCHAR2(4) NOT NULL |
Late Charge Code
Prompt Table: LATE_CHRG_VW |
| 48 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 49 | 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 |
| 50 | ULTIMATE_USE_CD | Character(8) | VARCHAR2(8) NOT NULL |
Ultimate Use Code
Prompt Table: SUT_USE_CD |
| 51 | ULT_USE_CD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ultimate Use Code
D=Default from higher S=Specified Default Value: D |
| 52 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 53 | MATCH_DELAY_DAYS | Number(3,0) | SMALLINT NOT NULL | Match Delay Days |