BUS_UNT_EX_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BUS_UNIT_TBL_EX |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 3 | ALLOW_ADV | Character(1) | VARCHAR2(1) NOT NULL | Allow Advance |
| 4 | BU_ADV_MAX_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Max Advance Amount for BU |
| 5 | DST_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL | Accounting Template |
| 6 | MIN_RCPT_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Minimum Receipt Amount |
| 7 | 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. " |
| 8 | DB_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
| 9 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 10 | APPL_JRNL_ID_ACCR | Character(10) | VARCHAR2(10) NOT NULL | Accruals |
| 11 | APPL_JRNL_ID_PEACR | Character(10) | VARCHAR2(10) NOT NULL | Period End Accruals |
| 12 | APPL_JRNL_ID_CASH | Character(10) | VARCHAR2(10) NOT NULL | Payments |
| 13 | APPL_JRNL_ID_CLOSE | Character(10) | VARCHAR2(10) NOT NULL | Closes |
| 14 | APPL_JRNL_ID_VOID | Character(10) | VARCHAR2(10) NOT NULL | Cancels |
| 15 | VAT_NRCVR_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Non-Recoverable VAT |
| 16 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 17 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 18 | DFLT_ADV_DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Default Doc Type |
| 19 | DFLT_SHT_DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Default Doc Type |
| 20 | DFLT_ADV_CLSDOCTYP | Character(8) | VARCHAR2(8) NOT NULL | Default DOC Type |
| 21 | DFLT_SHT_CLSDOCTYP | Character(8) | VARCHAR2(8) NOT NULL | Default Doc Type |
| 22 | DFLT_UNPOST_DOCTYP | Character(8) | VARCHAR2(8) NOT NULL | Default DOC Type |
| 23 | GROSS_UP_EST_PCT | Number(7,4) | DECIMAL(6,4) NOT NULL | Gross Up Percent |
| 24 | TIME_RPT_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Time Report Period
B=Biweekly D=Daily S=Semi-Monthly W=Weekly |
| 25 | END_DAY_OF_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Ending Day of Period
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday |
| 26 | HOURS_PER_DAY | Number(3,0) | SMALLINT NOT NULL | Hours Per Day |
| 27 | AIR_TKT_GRACE_PRD | Number(3,0) | SMALLINT NOT NULL | Airline Ticket Grace Period |
| 28 | ADVANCE_OVERDUE | Number(3,0) | SMALLINT NOT NULL | Advance Overdue in days |
| 29 | CC_DATA_OVERDUE | Number(3,0) | SMALLINT NOT NULL | Limit in days before an employee is notified that they have overdue corporate card transactions. |
| 30 | UPPER_LIMIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Upper Limit Threshold Action
R=Error W=Warning |
| 31 | LOWER_LIMIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Lower Limit Threshold Action
R=Error W=Warning |
| 32 | MAX_HRS_PER_PERIOD | Number(7,2) | DECIMAL(6,2) NOT NULL | Maximum Hours Per Period |
| 33 | MIN_HRS_PER_PERIOD | Number(7,2) | DECIMAL(6,2) NOT NULL | Minimum Hours Per Period |
| 34 | SHOW_DESCR_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Show Descriptions Option
D=Default : N=Codes Y=Descriptions |
| 35 | TIME_RPT_LIMIT | Number(3,0) | SMALLINT NOT NULL | Time Submission Grace Days |
| 36 | EXP_RPT_LIMIT | Number(3,0) | SMALLINT NOT NULL | Expense Submission Grace Days |
| 37 | PER_DIEM_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL | Override Per Diem |
| 38 | AUTH_AMT_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL | Override Authorized Amounts |
| 39 | VAT_RCRD_FRGN_FLG | Character(1) | VARCHAR2(1) NOT NULL | Record Foreign VAT |
| 40 | VAT_NRCVR_ALL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allocate Non-Recoverable VAT |
| 41 | BU_EXP_MAX_AMT_PRE | Number(27,3) | DECIMAL(26,3) NOT NULL | Prepayment Amount |
| 42 | BU_EXP_MAX_AMT_PST | Number(27,3) | DECIMAL(26,3) NOT NULL | Post-Payment Amount |
| 43 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 44 | OVERRIDE_DCAA_FLG | Character(1) | VARCHAR2(1) NOT NULL | Disable DCAA |
| 45 | FUTURE_ENTRY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Disable Future Entry |
| 46 | CUTOFF_DAYS | Number(3,0) | SMALLINT NOT NULL | Cutoff Days |
| 47 | CUTOFF_TIME | Time(15) | TIMESTAMP | The settlement cutoff time for a given bank/counterparty. |
| 48 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 49 | COMMENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Comment Flag
1=Multiple GeoCodes 2=Invalid Postal Code |
| 50 | AMOUNT_THRESHOLD | Number(27,3) | DECIMAL(26,3) NOT NULL | Monetary amount threshold. |
| 51 | TAUTH_VAR_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent variance from travel authorization. |
| 52 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 53 | ETC_ENTRY | Character(1) | VARCHAR2(1) NOT NULL | Allow Entry of ETC |
| 54 | TIME_GRID_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
Used to set with grid(s) display for time reports
B=Both Time Grids C=Policy Time Grid Only P=Project Time Grid Only |
| 55 | EX_ACCRL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Accrue Unprocessed Expenses |
| 56 | EX_WALLET_ACRL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Accrue Wallet Entries |
| 57 | EX_KK_ACCRL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Commitment Control for Accrual |
| 58 | EX_ACCRL_BILL_EXP | Character(1) | VARCHAR2(1) NOT NULL | Accrue for Billable Expenses |
| 59 | AUTO_APPR_RISK_FLG | Character(1) | VARCHAR2(1) NOT NULL | Auto Approve Only if No Risk |
| 60 | EX_TIME_TO_PC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Process Time to Projects When
H=Entire Timesheet is Approved L=Timesheet Line is Approved |
| 61 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |