SF_SCRAPB_ARCH

(SQL Table)
Index Back

Assembly Scrap Cost Books Arch

03/18/03 PWF MG Archive Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
6 TRANS_DATE Date(10) DATE Transaction Date
7 TRANS_TIME Time(15) TIMESTAMP Transaction Time
8 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
9 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

10 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
11 CM_COST_MODE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
L=Live
S=Simulated
12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
13 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least

Y/N Table Edit

Default Value: N

14 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted

Default Value: N