| # |
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
Prompt Table:
SP_BUIN_NONVW
|
| 3 |
TRANSACTION_GROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
|
| 4 |
ACCOUNTING_DT |
Date(10) |
DATE NOT NULL |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 5 |
ACCTG_LINE_NO |
Number(15,0) |
DECIMAL(15) NOT NULL |
Accounting Line Number
|
| 6 |
CM_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Book
|
| 7 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table:
CM_DISTR_TYPE
|
| 8 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table:
CM_ELEMENT
|
| 9 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 10 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
GL_ACCOUNT_TBL
|
| 11 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 12 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 13 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 14 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 15 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 16 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 17 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 18 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 19 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 20 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 21 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 22 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 23 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 24 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 25 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 26 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 27 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 28 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 29 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 30 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 31 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 32 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 33 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 34 |
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.
|
| 35 |
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.
|
| 36 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 37 |
FERC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
FERC Code
|
| 38 |
DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
|
| 39 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 40 |
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
|
| 41 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 42 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 43 |
STAGED_DATE |
Date(10) |
DATE |
Staged Date
|
| 44 |
INV_LOT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Lot ID
|
| 45 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 46 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 47 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 48 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
|
| 49 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
|
| 50 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
|
| 51 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
|
| 52 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 53 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
|
| 54 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 55 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 56 |
COUNTING_EVENT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Counting Event ID
|
| 57 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 58 |
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
|
| 59 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 60 |
JRNL_LN_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
|
| 61 |
LINE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
|
| 62 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 63 |
INTRAUNIT_BAL |
Character(1) |
VARCHAR2(1) NOT NULL |
IntraUnit Balance
Default Value: N
|
| 64 |
REQ_REVERSAL_POST |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition Reversal Posting
Default Value: N
|
| 65 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 66 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 67 |
PRDN_AREA_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area
|
| 68 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
|
| 69 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 70 |
FROM_PRDN_AREA |
Character(10) |
VARCHAR2(10) NOT NULL |
From Production Area
|
| 71 |
FROM_PRDN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
From Production ID
|
| 72 |
FROM_PRDN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
From Production Type
PR=Production
RW=Rework
SV=Service
TD=Teardown
|
| 73 |
TO_PRDN_AREA |
Character(10) |
VARCHAR2(10) NOT NULL |
To Production Area
|
| 74 |
TO_PRDN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
To Production ID
|
| 75 |
TO_PRDN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
To Production Type
PR=Production
RW=Rework
SV=Service
TD=Teardown
|
| 76 |
INTRAUNIT_REF |
Number(15,0) |
DECIMAL(15) NOT NULL |
IntraUnit Reference Nbr
|
| 77 |
TRANSACTION_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Source
|
| 78 |
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
|
| 79 |
AP_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Payables Sequence Number
|
| 80 |
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
|
| 81 |
VARIANCE_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Variance Source
C=Close
O=Re-Open
R=Report
|
| 82 |
MG_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 83 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 84 |
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
|
| 85 |
CONTAINER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Container ID
|
| 86 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 87 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 88 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 89 |
CHARGE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipping Charge Type
F=Freight
M=Misc Chrgs
N=Non-stock
|
| 90 |
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
|
| 91 |
PRODUCTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
|
| 92 |
DESTIN_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination Unit
|
| 93 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
|
| 94 |
DEBIT_CREDIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Debit / Credit Indicator
CR=Credit
DR=Debit
|
| 95 |
CM_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 96 |
CM_DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Receipt dttm.
|
| 97 |
CM_DT_TIMESTAMP_A |
DateTime(26) |
TIMESTAMP |
07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
|
| 98 |
CM_SEQ_NBR_A |
Number(15,0) |
DECIMAL(15) NOT NULL |
07/99 GMG CN800-9.0:
|
| 99 |
CM_SEQ_COST |
Number(15,0) |
DECIMAL(15) NOT NULL |
Cost Sequence Number. Incremented each time the actual cost is updated.
|
| 100 |
TRANS_DATE |
Date(10) |
DATE |
Transaction Date
|
| 101 |
TRANS_TIME |
Time(15) |
TIMESTAMP |
Transaction Time
|
| 102 |
CM_RULE |
Number(2,0) |
SMALLINT NOT NULL |
Accounting Rule Number
|
| 103 |
IU_SYS_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
|
| 104 |
IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
|
| 105 |
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
|
| 106 |
IU_ENTRY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Entry Type
AEAP=IntraEntity Accrued Payable
AECG=IntraEntity Cost of Goods
AECS=IntraEntity Customer Shipments
AEEX=IntraEntity Expense
AEPY=IntraEntity Payable
AERC=IntraEntity Receivable
AERV=IntraEntity Revenue
AETR=IntraEntity In Transit
AUEX=IntraUnit Expense
AUPY=IntraUnit Payable
AURC=IntraUnit Receivable
AURV=IntraUnit Revenue
AUTR=IntraUnit In Transit
IEAP=InterEntity Accrued Payable
IECG=InterEntity Cost of Goods
IECS=InterEntity Customer Shipments
IEEX=InterEntity Expense
IEPY=InterEntity Payable
IERC=InterEntity Receivable
IERV=InterEntity Revenue
IETR=InterEntity In Transit
IUAP=InterUnit Accrued Payable
IUCG=InterUnit Cost of Goods
IUCS=InterUnit Customer Shipments
IUEX=InterUnit Expense
IUPY=InterUnit Payable
IURC=InterUnit Receivable
IURV=InterUnit Revenue
IUTR=InterUnit In Transit
|
| 107 |
CM_ERROR_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Account Line Creation Error
INTR=No InterUnit Rules
PROD=No Production Area Rule
RULE=No Account Distribution Rule
STOR=No Storage Area Rule
|
| 108 |
CM_SYSTEM_TM_STAMP |
DateTime(26) |
TIMESTAMP |
System Timestamp
|
| 109 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|