RECV_MG_TMP1(SQL Table) |
Index Back |
|---|---|
Recv Sub Receipt Interface Tmp |
| # | 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 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 5 | REJECT_ACTION |
Character(1) | VARCHAR2(1) NOT NULL |
Action On Rejection
C=Return for Credit R=Return For Replacement |
| 6 | REJECT_REASON |
Character(10) | VARCHAR2(10) NOT NULL |
Reject Reason Code
DAM=Damaged Goods FAL=Failed Inspection INC=Incomplete Shipment LAT=Late Shipment RLY=Early Shipment WRG=Wrong Goods or Service |
| 7 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 8 | QTY_SF_ACCPT_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Recv Accepted Qty |
| 9 | QTY_SF_REJCT_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Recv Rejected Qty |
| 10 | QTY_UPD_ACCPT_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Prdn Accepted Qty |
| 11 | QTY_UPD_REJCT_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Prdn Rejected Qty |
| 12 | INSERT_ROW_FLG | Character(1) | VARCHAR2(1) NOT NULL | Insert Row Flag |
| 13 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 14 | SUBCONTRACT_COMP | Character(1) | VARCHAR2(1) NOT NULL |
Production Complete indicator for streamline processing
Y/N Table Edit Default Value: Y |
| 15 | RECV_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Receive Source
1=On-line 2=ASN 3=Data Cllct 4=Mobile Default Value: 1 |
| 16 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 17 | REVISION | Character(4) | VARCHAR2(4) NOT NULL | 01/27/2000 RML Added "As of" label |
| 18 | USER_HDR_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 19 | CUSTOM_C100_A1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 20 | CUSTOM_C100_A2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 21 | CUSTOM_C100_A3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 22 | CUSTOM_C100_A4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 23 | CUSTOM_DATE_A | Date(10) | DATE | Custom Date |
| 24 | CUSTOM_C1_A | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 25 | USER_LINE_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 26 | CUSTOM_C100_B1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 27 | CUSTOM_C100_B2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 28 | CUSTOM_C100_B3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 29 | CUSTOM_C100_B4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 30 | CUSTOM_DATE_B | Date(10) | DATE | Custom Date |
| 31 | CUSTOM_C1_B | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 32 | USER_SCHED_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 33 | CUSTOM_C100_C1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 34 | CUSTOM_C100_C2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 35 | CUSTOM_C100_C3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 36 | CUSTOM_DATE_C1 | Date(10) | DATE | Custom Date 1 |
| 37 | CUSTOM_DATE_C2 | Date(10) | DATE | Custom Date 2 |
| 38 | CUSTOM_C1_C | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |