SF_SCRAPB_ARCH(SQL Table) |
Index Back |
---|---|
Assembly Scrap Cost Books Arch03/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 |