| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TEST_CASE |
Character(30) |
VARCHAR2(30) NOT NULL |
BTF Test Case
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.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. "
Default Value: USD
Prompt Table:
CURRENCY_CD_TBL
|
| 4 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 5 |
DOWNTIME_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prohibit Material Movements
Y/N Table Edit
Default Value: N
|
| 6 |
IBU_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Unit Group
Prompt Table:
IBU_GROUP_INV
|
| 7 |
BU_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status
1=Facility Open
2=Facility Closed
Default Value: 2
|
| 8 |
WRKFL_SHIPPING |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Ship Notification Workflow
Y/N Table Edit
Default Value: N
|
| 9 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 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
Prompt Table:
BU_TYPE_INV
|
| 20 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table:
%EDITTABLE
|
| 21 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table:
%EDITTABLE5
|
| 22 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table:
%EDITTABLE6
|
| 23 |
INCL_QUAR_AVAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Incl Non-Open in Avail Qty
Y/N Table Edit
Default Value: Y
|
| 24 |
LOT_AUTO_ADD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Auto-Add of New Lots
Y/N Table Edit
Default Value: N
|
| 25 |
LOT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Lot Allocation
Y/N Table Edit
Default Value: N
|
| 26 |
LOT_ALLOC_WL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Lot Allocation Workflow
Y/N Table Edit
Default Value: N
|
| 27 |
COMBO_EDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit
Default Value: N
|
| 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
Default Value: 0
|
| 30 |
FREIGHT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Freight Product ID
Prompt Table:
PRODITEM_INV_VW
|
| 31 |
MISC_CHRG_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Misc Charge Product ID
Prompt Table:
PRODITEM_INV_VW
|
| 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
Default Value: F
|
| 33 |
DST_ID_REV |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Dist Code
Prompt Table:
%EDITTABLE2
|
| 34 |
DST_ID_DIS |
Character(10) |
VARCHAR2(10) NOT NULL |
Discount Distribution Code
Prompt Table:
%EDITTABLE3
|
| 35 |
DST_ID_SUR |
Character(10) |
VARCHAR2(10) NOT NULL |
Surcharge Distribution Code
Prompt Table:
%EDITTABLE4
|
| 36 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
Prompt Table:
JRNLGEN_APPL_ID
|
| 37 |
ALLOW_NEG_INV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Negative Inventory
Y/N Table Edit
Default Value: N
|
| 38 |
DISPLAY_MESSAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Warning Messages
Y/N Table Edit
Default Value: N
|
| 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
Default Value: 01
|
| 41 |
CONS_NON_STOCK |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidate Non-Stock
Y/N Table Edit
Default Value: N
|
| 42 |
BCKORDR_CNCL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
Y/N Table Edit
Default Value: N
|
| 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
Prompt Table:
RMA_REASON_VW
|
| 47 |
RETURN_TO_IBU |
Character(5) |
VARCHAR2(5) NOT NULL |
Return To IBU
Prompt Table:
SP_BUIN_NONVW
|
| 48 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table:
DISTR_IBU_VW
|
| 49 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
%EDIT_ACCOUNT
|
| 50 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table:
%EDIT_ALTACCT
|
| 51 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_BUGL_VW
|
| 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
Set Control Field: BUSINESS_UNIT_PC
|
| 68 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 69 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 70 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 71 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
Prompt Table:
STAT_TBL
|
| 72 |
TSE_TRIGGER |
Character(1) |
VARCHAR2(1) NOT NULL |
Perform Validation
Y/N Table Edit
Default Value: N
|
| 73 |
GENERATE_ASN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Advanced Shipment Notice
Y/N Table Edit
Default Value: N
|
| 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.
Y/N Table Edit
Default Value: N
|
| 76 |
BUS_UNIT_BI_TR |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Xfer Business Unit
Prompt Table:
%EDITTABLE
|
| 77 |
BILL_SOURCE_TR |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Transfer Source
Prompt Table:
%EDITTABLE6
|
| 78 |
BILL_TYPE_TR |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Transfer Type
Prompt Table:
%EDITTABLE5
|
| 79 |
FRT_RULE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Rule Code
Prompt Table:
FRT_RULE_VW
|
| 80 |
ALLOW_XFR_INV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Transfers to Owned Loc
Y/N Table Edit
Default Value: N
|
| 81 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
SP_BU_AP_NONVW
|
| 82 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 83 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table:
FREIGHT_TERMS
|
| 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
Default Value: S
|
| 86 |
EXPORT_INT |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Integration
Y/N Table Edit
Default Value: N
|
| 87 |
EXPORT_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Hold
Y/N Table Edit
Default Value: N
|
| 88 |
VALIDATE_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Validate All
Y/N Table Edit
Default Value: N
|
| 89 |
AUTO_CLOSE_RCV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Close Receipts
Y/N Table Edit
Default Value: N
|
| 90 |
AUTO_ROUND_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic UOM Round Option
1=No Warning
2=Warning
3=Error
Default Value: 2
|
| 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
Y/N Table Edit
Default Value: N
|
| 95 |
WARN_TEMPL_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Warn if Par Defin Changed
Y/N Table Edit
Default Value: N
|
| 96 |
INT_LOC_EXP_RCPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Internal Expected Receipt
Y/N Table Edit
Default Value: N
|
| 97 |
OMBI_DIS_DTL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pass Disc/Sur to Billing
Y/N Table Edit
Default Value: N
|
| 98 |
PENALTY_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Penalty Product ID
Prompt Table:
PRODITEM_INV_VW
|
| 99 |
REBATE_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Rebate Product ID
Prompt Table:
PRODITEM_INV_VW
|
| 100 |
PACK_PARTIAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pack Partial Quantity
Y/N Table Edit
Default Value: N
|
| 101 |
ORD_CANCEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Order Cancel Option
1=Allow Shipment
2=Put On Hold
Default Value: 1
|
| 102 |
HOLD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Hold Code
Prompt Table:
HOLD_CD
|
| 103 |
RESTOCK_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Restock Product ID
Prompt Table:
PRODITEM_INV_VW
|
| 104 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table:
%EDITTABLE11
|
| 105 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
%EDITTABLE12
|
| 106 |
AUTO_PUTAWAY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Items for Auto-Putaway
Y/N Table Edit
Default Value: N
|
| 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
Prompt Table:
BI_BILL_BY
|
| 109 |
REASON_CD_SHIP |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping Reason Code
Prompt Table:
REASON_SHIP_VW
|
| 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:
TAX_HDR_TBL_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
Set Control Field: INV_ITEM_ID
|