| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
CM_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Book
|
| 4 |
TRANSACTION_GROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
|
| 5 |
ADJUST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Type
0=CM Only
A=VMI Return
D=Decrease
I=Increase
M=Misc Issue
R=Misc Return
S=Scrap
V=Scrap RTV
|
| 6 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 7 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 8 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 9 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 10 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
|
| 11 |
CM_DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Receipt dttm.
|
| 12 |
CM_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 13 |
CM_DT_TIMESTAMP_A |
DateTime(26) |
TIMESTAMP |
07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
|
| 14 |
CM_SEQ_NBR_A |
Number(15,0) |
DECIMAL(15) NOT NULL |
07/99 GMG CN800-9.0:
|
| 15 |
CM_SEQ_COST |
Number(15,0) |
DECIMAL(15) NOT NULL |
Cost Sequence Number. Incremented each time the actual cost is updated.
|
| 16 |
MG_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 17 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
|
| 18 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 19 |
REVALUE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
1/25/99 - CRC EN800-6.0 : added revalue type = '05' for co/by product
01=Inventory
02=Inspection
03=WIP - Comp
04=WIP - Assy
05=WIP - Waste
|
| 20 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 21 |
FROM_PRDN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
From Production ID
|
| 22 |
TO_PRDN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
To Production ID
|
| 23 |
VARIANCE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
9/9/02 CRC: added variance type '15' for Yield Variance
01=Configuration Variance
02=Usage Variance
03=Component Yield Variance
04=Labor Lot Size Variance
05=Process Routing Variance
06=Efficiency Variance
07=Rate Variance
08=Material Lot Size Variance
09=Rework Expense
10=Rework Labor Expense
11=Outside Processing PPV
12=Mix Variance
13=Teardown Material Expense
14=Teardown Conversion Expense
15=Yield Variance
16=Co-Product Rate Var
17=Material Rate Variance
|
| 24 |
VARIANCE_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Variance Source
C=Close
O=Re-Open
R=Report
|
| 25 |
TRANS_DATE |
Date(10) |
DATE |
Transaction Date
|
| 26 |
TRANS_TIME |
Time(15) |
TIMESTAMP |
Transaction Time
|
| 27 |
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
|
| 28 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 29 |
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
Default Value: N
|
| 30 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 31 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 32 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 33 |
DESTIN_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination Unit
|
| 34 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 35 |
CHARGE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipping Charge Type
F=Freight
M=Misc Chrgs
N=Non-stock
|
| 36 |
DELIVERY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Delivery ID
|
| 37 |
ACCTG_LINE_NO |
Number(15,0) |
DECIMAL(15) NOT NULL |
Accounting Line Number
|