BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
DESTIN_BUINV_ITEM_IDCOST_ELEMENTEFFDTDefault Value: %date
A=Active
I=Inactive
CM_TRAN_PRICE(SQL Table) |
Index Back |
|---|---|
Transfer Price Table |
| # | 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 |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | COST_ELEMENT |
Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 5 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | TRANSFER_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Transfer Price |
| 8 | 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. " |
| 9 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |