CM_NP_REC_VW(SQL View) |
Index Back |
|---|---|
Pending CM_RECEIPTS rows |
| SELECT A.BUSINESS_UNIT , A.CM_BOOK , %DatePart(A.DT_TIMESTAMP) , A.INV_ITEM_ID , A.TRANSACTION_GROUP , A.DT_TIMESTAMP , %Substring(B.MESSAGE_TEXT, 1,50) , A.POSTED_FLAG , A.SEQ_NBR , A.CM_DT_TIMESTAMP_A , A.CM_SEQ_NBR_A , %DateTimeNull , 0 , 0 , ' ' , ' ' , ' ' , ' ' , 0 , 0 , 0 , 0 , ' ' , ' ' , 0 , 0 , A.PROCESS_INSTANCE , 0 , 0 , 0 , A.PRODUCTION_ID , 0 , ' ' , %DateNull , %TimeNull , ' ' , ' ' FROM PS_CM_RECEIPTS A , PSMSGCATDEFN B WHERE A.POSTED_FLAG = 'N' AND B.MESSAGE_SET_NBR = 15500 AND B.MESSAGE_NBR = 194 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CM_BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 3 | TRANSACTION_DATE | Date(10) | DATE | Transaction Date |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 6 | DT_TIMESTAMP |
DateTime(26) | TIMESTAMP | Date Timestamp |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 8 | 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 |
| 9 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 10 | CM_DT_TIMESTAMP_A |
DateTime(26) | TIMESTAMP | 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd. |
| 11 | CM_SEQ_NBR_A |
Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 12 | CM_DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Receipt dttm. |
| 13 | CM_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 14 | CM_SEQ_VARIANCE | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 15 | FROM_PRDN_ID | Character(10) | VARCHAR2(10) NOT NULL | From Production ID |
| 16 | TO_PRDN_ID | Character(10) | VARCHAR2(10) NOT NULL | To Production ID |
| 17 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 18 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 19 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 20 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 21 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 22 | CM_SEQ_COST | Number(15,0) | DECIMAL(15) NOT NULL | Cost Sequence Number. Incremented each time the actual cost is updated. |
| 23 | MISC_CHARGE_CODE | Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 24 | RTV_ID | Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 25 | RTV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Return To Vendor Line |
| 26 | RTV_DISTRIB_NUM | Number(5,0) | INTEGER NOT NULL | RTV Distribution Number |
| 27 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 28 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 29 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 30 | MG_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 31 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 32 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 33 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 34 | TRANS_DATE | Date(10) | DATE | Transaction Date |
| 35 | TRANS_TIME | Time(15) | TIMESTAMP | Transaction Time |
| 36 | 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 |
| 37 | 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. |