|
SELECT A.BUSINESS_UNIT , A.PRODUCTION_ID , A.OP_SEQUENCE , A.CE_COST_CATEGORY , A.CE_RESOURCE , A.DT_TIMESTAMP , A.CM_BOOK , A.TRANS_DATE , A.TRANS_TIME , A.CONVERSION_TYPE , A.MG_PROC_INSTANCE , A.REVALUE_FLAG , A.SEQ_NBR , A.INV_ITEM_ID , A.TRANSACTION_GROUP , A.ACCOUNTING_DT , A.ACCTG_LINE_NO , A.DISTRIB_TYPE , A.INV_ITEM_GROUP , A.COST_ELEMENT , A.TRANS_LINE_TYPE , A.AP_SEQ_NBR , A.DESTIN_BU , A.DEBIT_CREDIT , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF16_AN_SBR,a) , %subrec(PC_CF1_N_SBR,a) , A.STATISTICS_CODE , A.MONETARY_AMOUNT , A.CURRENCY_CD , A.STATISTIC_AMOUNT , A.BUSINESS_UNIT_GL , A.LEDGER , A.JOURNAL_ID , A.JOURNAL_DATE , A.JOURNAL_LINE FROM PS_CM_ACCTG_LINE A , PS_CE_ACTUAL_COST B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND A.OP_SEQUENCE = B.OP_SEQUENCE AND A.CE_COST_CATEGORY = B.CE_COST_CATEGORY AND A.CE_RESOURCE = B.CE_RESOURCE AND A.CM_BOOK = B.CM_BOOK AND A.DT_TIMESTAMP = B.DT_TIMESTAMP AND A.CE_SEQ_NBR = B.CE_SEQ_NBR AND A.COST_ELEMENT = B.COST_ELEMENT AND A.TRANSACTION_GROUP IN ( SELECT TRANSACTION_GROUP FROM PS_CM_ACCTG_GRP_D WHERE CM_SOURCE_RECORD = 'CE_ACTUAL_COST')
|
| # |
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_CMACTG_NONVW
|
| 2 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
Prompt Table:
CM_DRILL_PID_VW
|
| 3 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
Prompt Table:
CM_DRILL_OPS_VW
|
| 4 |
CE_COST_CATEGORY |
Character(4) |
VARCHAR2(4) NOT NULL |
10/07/02 - LLR Added field CE_COST_CATEGORY for Debits to WIP.
%L=% Labor Overhead
%M=% Material Overhead
ADD=Additional Cost
ADJ=Adjustments
CO=Co Product
LAB=Labor Cost
MACH=Machine Cost
MAT=Material Cost
OTH=Other Cost
OVHD=Standard Cost Overhead
PL=Per Labor Overhead
PM=Per Machine Overhead
PO=Subcontracted PO-STD Cost
PRIM=Primary Product
PU=Per Unit Overhead
RB=Recycle By-Products
SCRP=Scrap Cost
STD=Subcontracted Standard Cost
SUBC=Subcontracted Cost
VCHR=Subcontracted VCHR - PO Cost
WB=Waste By-Products
WO=Write-off no cost adj
|
| 5 |
CE_RESOURCE |
Character(18) |
VARCHAR2(18) NOT NULL |
Resource
|
| 6 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 7 |
CM_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Book
Prompt Table:
CM_BU_BOOK_VW
|
| 8 |
TRANS_DATE |
Date(10) |
DATE |
Transaction Date
|
| 9 |
TRANS_TIME |
Time(15) |
TIMESTAMP |
Transaction Time
|
| 10 |
CONVERSION_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Conversion Type
1100=Lab Setup
1200=Lab Fixed
1300=Labor Run
1400=Lab PostPr
1500=Mach Setup
1600=Mach Fixed
1700=Mach Run
1800=MC PostPrd
2100=Ovhd 1
2200=Ovhd 2
2300=Ovhd 3
2400=Ovhd 4
|
| 11 |
MG_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 12 |
REVALUE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.
Y/N Table Edit
|
| 13 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 14 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 15 |
TRANSACTION_GROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
|
| 16 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 17 |
ACCTG_LINE_NO |
Number(15,0) |
DECIMAL(15) NOT NULL |
Accounting Line Number
|
| 18 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
|
| 19 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
|
| 20 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
|
| 21 |
TRANS_LINE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Line Type
0=Regular
1=Interunit Transfer
2=Gain
3=Loss
4=PPV (Favorable)
5=PPV (Unfavorable)
6=ERV (Favorable)
7=ERV (Unfavorable)
8=InterCompany Transfer
|
| 22 |
AP_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Payables Sequence Number
|
| 23 |
DESTIN_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination Unit
|
| 24 |
DEBIT_CREDIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Debit / Credit Indicator
CR=Credit
DR=Debit
|
| 25 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 26 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 27 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_BUGL_VW
|
| 28 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 29 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 30 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 31 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 32 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 33 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 34 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 35 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 36 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 37 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 38 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 39 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 40 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 41 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 42 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 43 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 44 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 45 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 46 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 47 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 48 |
MONETARY_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 49 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 50 |
STATISTIC_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
|
| 51 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 52 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 53 |
JOURNAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
|
| 54 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 55 |
JOURNAL_LINE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
|