| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 2 |
DESTIN_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination Unit
Prompt Table:
SP_BUIN_NONVW
|
| 3 |
PRICE_EFFECTIVE_DT |
Date(10) |
DATE NOT NULL |
Price Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
ZERO_PRICE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Price Indicator
Y/N Table Edit
Default Value: N
|
| 6 |
ZERO_ADDFEE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Additional Fees Indicator
Y/N Table Edit
Default Value: N
|
| 7 |
TRANSFER_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost
Default Value: 0
|
| 8 |
PRICE_MARKUP_PCT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Price Markup %
|
| 9 |
TRAN_MRKUP_CE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Element Option
A=Add'l Cost
M=Material
Default Value: M
|
| 10 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table:
CE_ELEMENT6_VW
|
| 11 |
ACTL_CST_CALC_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Price Actual Cost calculation option
1=Default Actual Cost
2=Last Actual Cost
3=First Actual Cost
4=Average Day's Receipts
|
| 12 |
NBR_OF_DAYS |
Number(5,0) |
INTEGER NOT NULL |
Number of Days
|
| 13 |
AVG_CST_CALC_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Price Average Cost calculation option
1=Average Purchase Price
2=Average Day's Receipts
|
| 14 |
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. "
|
| 15 |
PRICE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Flag
Y/N Table Edit
Default Value: N
|