BU_TBL_INV_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BUS_UNIT_TBL_IN |
| # | 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 | Character(5) | VARCHAR2(5) NOT NULL | 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 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 5 | DOWNTIME_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Prohibit Material Movements |
| 6 | IBU_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Unit Group |
| 7 | BU_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
1=Facility Open 2=Facility Closed |
| 8 | WRKFL_SHIPPING | Character(1) | VARCHAR2(1) NOT NULL | Use Ship Notification Workflow |
| 9 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 10 | INVENTORY_TAG_ID | Number(15,0) | DECIMAL(15) NOT NULL | Inventory Tag ID |
| 11 | STAGING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Putaway Staging ID |
| 12 | PICK_BATCH_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Batch ID |
| 13 | SHIPPING_ID | Number(10,0) | DECIMAL(10) NOT NULL | Shipping ID |
| 14 | COUNTING_EVENT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Counting Event ID |
| 15 | REPLENISH_ID | Number(10,0) | DECIMAL(10) NOT NULL | Replenish ID |
| 16 | ACCTG_LINE_NO | Number(15,0) | DECIMAL(15) NOT NULL | Accounting Line Number |
| 17 | CART_COUNT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Par Location Count ID |
| 18 | RUN_CNTL_SEQ_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Run Control Seq Nbr |
| 19 | BUSIN_UNIT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Inventory Type |
| 20 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 21 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 22 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Source |
| 23 | INCL_QUAR_AVAIL | Character(1) | VARCHAR2(1) NOT NULL | Incl Non-Open in Avail Qty |
| 24 | LOT_AUTO_ADD_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Auto-Add of New Lots |
| 25 | LOT_ALLOC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Lot Allocation |
| 26 | LOT_ALLOC_WL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Use Lot Allocation Workflow |
| 27 | COMBO_EDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Edit Combinations |
| 28 | COMBO_VALID_FLG | Character(1) | VARCHAR2(1) NOT NULL |
ChartField Combinatn Valid Flg
?=Validation in Progress V=Valid ChartField Combination X=Invalid ChartField Combo |
| 29 | SPEEDTYPE_LVL | Character(1) | VARCHAR2(1) NOT NULL |
SpeedType Level
0=Off 1=Universal 2=Permission 3=User |
| 30 | FREIGHT_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Freight Product ID |
| 31 | MISC_CHRG_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Misc Charge Product ID |
| 32 | TRANSIT_COST_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Transit Priority Type
C=Percentage of Item Cost F=Fixed Cost Q=Factor of Quantity W=Factor of Weight |
| 33 | DST_ID_REV | Character(10) | VARCHAR2(10) NOT NULL | Revenue Dist Code |
| 34 | DST_ID_DIS | Character(10) | VARCHAR2(10) NOT NULL | Discount Distribution Code |
| 35 | DST_ID_SUR | Character(10) | VARCHAR2(10) NOT NULL | Surcharge Distribution Code |
| 36 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 37 | ALLOW_NEG_INV_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Negative Inventory |
| 38 | DISPLAY_MESSAGE | Character(1) | VARCHAR2(1) NOT NULL | Display Warning Messages |
| 39 | PICK_EXT_FILE_CNT | Number(3,0) | SMALLINT NOT NULL | Picking Extract File ID |
| 40 | CART_REPLEN_OPT | Character(2) | VARCHAR2(2) NOT NULL |
Par Replenishment Option
01=Stock 02=Stockless 03=Non-Stock 04=Not Replenished |
| 41 | CONS_NON_STOCK | Character(1) | VARCHAR2(1) NOT NULL | Consolidate Non-Stock |
| 42 | BCKORDR_CNCL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No Y=Cancel Backorder Yes |
| 43 | PTWY_PLAN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Putaway Plan ID |
| 44 | TAXPAYER_ID | Character(14) | VARCHAR2(14) NOT NULL | Taxpayer ID |
| 45 | MSR_MONTHS | Number(2,0) | SMALLINT NOT NULL | Ship History for MSRs (Months) |
| 46 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 47 | RETURN_TO_IBU | Character(5) | VARCHAR2(5) NOT NULL | Return To IBU |
| 48 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
| 49 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 50 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 51 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 52 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
| 53 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
| 54 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
| 55 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
| 56 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
| 57 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
| 58 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
| 59 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
| 60 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
| 61 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
| 62 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
| 63 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
| 64 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: %EDIT_BU_PC |
| 65 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: %EDIT_PROJECT |
| 66 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: %EDIT_ACTIVITY |
| 67 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
|
| 68 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
|
| 69 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
|
| 70 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
|
| 71 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 72 | TSE_TRIGGER | Character(1) | VARCHAR2(1) NOT NULL | Perform Validation |
| 73 | GENERATE_ASN_FLG | Character(1) | VARCHAR2(1) NOT NULL | Use Advanced Shipment Notice |
| 74 | PICK_RELEASE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Release ID |
| 75 | USE_ROUTE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Determines whether route functionality will be used for a business unit. |
| 76 | BUS_UNIT_BI_TR | Character(5) | VARCHAR2(5) NOT NULL | Billing Xfer Business Unit |
| 77 | BILL_SOURCE_TR | Character(10) | VARCHAR2(10) NOT NULL | Bill Transfer Source |
| 78 | BILL_TYPE_TR | Character(3) | VARCHAR2(3) NOT NULL | Bill Transfer Type |
| 79 | FRT_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL | Freight Rule Code |
| 80 | ALLOW_XFR_INV_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Transfers to Owned Loc |
| 81 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 82 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 83 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |
| 84 | FRT_CHRG_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
Freight Charge Method
01=Order Value 02=Weight 03=Volume 04=Order Quantity |
| 85 | FREIGHT_CALC | Character(1) | VARCHAR2(1) NOT NULL |
Freight Calculation
A=Freight All S=Freight only Bill at Shipment |
| 86 | EXPORT_INT | Character(1) | VARCHAR2(1) NOT NULL | Export Integration |
| 87 | EXPORT_HOLD | Character(1) | VARCHAR2(1) NOT NULL | Export Hold |
| 88 | VALIDATE_ALL | Character(1) | VARCHAR2(1) NOT NULL | Validate All |
| 89 | AUTO_CLOSE_RCV_FLG | Character(1) | VARCHAR2(1) NOT NULL | Auto Close Receipts |
| 90 | AUTO_ROUND_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Automatic UOM Round Option
1=No Warning 2=Warning 3=Error |
| 91 | EST_SHIP_ID_SEQ | Number(10,0) | DECIMAL(10) NOT NULL | Estimated Shipment ID Sequence |
| 92 | EXPORTER_ECCN | Character(16) | VARCHAR2(16) NOT NULL | Export Cntl Classification Nbr |
| 93 | EXPORT_LIC_NBR | Character(18) | VARCHAR2(18) NOT NULL | Export License Nbr |
| 94 | EXT_WHSE_CNTL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Use External Warehouse Control |
| 95 | WARN_TEMPL_CHG | Character(1) | VARCHAR2(1) NOT NULL | Warn if Par Defin Changed |
| 96 | INT_LOC_EXP_RCPT | Character(1) | VARCHAR2(1) NOT NULL | Use Internal Expected Receipt |
| 97 | OMBI_DIS_DTL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Pass Disc/Sur to Billing |
| 98 | PENALTY_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Penalty Product ID |
| 99 | REBATE_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Rebate Product ID |
| 100 | PACK_PARTIAL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Pack Partial Quantity |
| 101 | ORD_CANCEL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Sales Order Cancel Option
1=Allow Shipment 2=Put On Hold |
| 102 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL | Hold Code |
| 103 | RESTOCK_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Restock Product ID |
| 104 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 105 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 106 | AUTO_PUTAWAY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Flag Items for Auto-Putaway |
| 107 | RUN_AUTOPTWY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to determine if AutoPutaway should be run
Y/N Table Edit Default Value: N |
| 108 | RMA_BILL_BY_ID | Character(10) | VARCHAR2(10) NOT NULL | RMA Bill By Identifier |
| 109 | REASON_CD_SHIP | Character(10) | VARCHAR2(10) NOT NULL | Shipping Reason Code |
| 110 | USE_TMS_KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ship Using TMS Reference ID
Y/N Table Edit Default Value: N |
| 111 | VMI_UNIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Managed
Y/N Table Edit Default Value: N |
| 112 | VMI_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL |
04/20/04 EGS: Created
Y/N Table Edit Default Value: N |
| 113 | TRFT_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL |
Arbitration Rule Code.
Prompt Table: IN_TRFT_BRUL_VW |
| 114 | TAX_CD | Character(8) | VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table: IN_TAX_CODE_VW |
| 115 | SSRC_ITEM_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Item Copy Source
1=Copy from source item 2=Copy from IBU template Default Value: 1 |
| 116 | SSRC_ITEM_TMPLT | Character(18) | VARCHAR2(18) NOT NULL |
Transfer Item Copy Template
Prompt Table:
BU_ITEMS_INV
|
| 117 | BU_FSS_FLG | Character(1) | VARCHAR2(1) NOT NULL | 02/15/06 EGS: Created |
| 118 | ALLOW_MV_REL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Rel Allocations Transfer
Y/N Table Edit Default Value: N |
| 119 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 120 | IN_IUT_PRICE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Generate InterUnit Transfer Price table flag
Y/N Table Edit Default Value: N |
| 121 | IN_EXP_TPRC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Expense InterUnit Transfer Fees flag
Y/N Table Edit Default Value: N |
| 122 | IN_SOB_TPRC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Ship on Behalf Transfer Price option
0=Use Item Cost 1=Use Transfer Price Default Value: 0 |