| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
EOEP_ARB_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Arbitration Plan
Prompt Table:
EOEP_ARB_SO_VW
|
| 6 |
FRT_CHRG_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
|
| 7 |
GRACE_PRICE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Grace Pricing Discount Days
|
| 8 |
LABEL_FORMAT_ID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Carton Label Format ID
Prompt Table:
BCT_SHL_INV_VW
|
| 9 |
LABEL_FORMAT_ID3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Ship Container Label Format ID
Prompt Table:
BCT_SHC_INV_VW
|
| 10 |
LOAD_PRICE_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Load Arbitration Plan
Prompt Table:
EOEP_ARB_LP_VW
|
| 11 |
PROD_ID_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Source
C=Customer
P=UPC
S=System
U=Universal
Default Value: S
|
| 12 |
PROD_SUBSTITUTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Product Substitutions
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 13 |
PRICE_PROGRAM |
Character(10) |
VARCHAR2(10) NOT NULL |
Date Initials Issue Description
111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
Prompt Table:
EOEP_ARB_PR_VW
|
| 14 |
RESTOCK_FEE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Restocking Fee
Y/N Table Edit
Default Value: N
|
| 15 |
ADJUST_BAPRC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Buying Agreement Price Flag
N=No
Y=Yes
|
| 16 |
VMI_ORDER_CONSOL |
Character(1) |
VARCHAR2(1) NOT NULL |
VMI Order Consolidation
1=Sold To Customer
2=Ship To Customer
3=None
|
| 17 |
VMI_ORDER_VERIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Verification
Y/N Table Edit
Default Value: N
|
| 18 |
RECEIPT_TRACK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Track Receipt
Y/N Table Edit
Default Value: N
|
| 19 |
UPN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Universal Product Number Format Type
Prompt Table:
UPN_TYPE_FS
|
| 20 |
DATE_LAST_MAINT |
Date(10) |
DATE |
Date Last Maintained
|
| 21 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 22 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|