BUSINESS_UNIT_RECVRECEIVER_IDRECV_LN_NBRRECV_SHIP_SEQ_NBRBUSINESS_UNIT_POPO_IDLINE_NBRSCHED_NBRDISTRIB_LINE_NUMVCHR_RC_DS_VW3(SQL View) |
Index Back |
|---|---|
Voucher PO/Recv Distrib Line |
| SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , C.RECV_LN_NBR , C.RECV_SHIP_SEQ_NBR , D.BUSINESS_UNIT_PO , C.PO_ID , C.LINE_NBR , D.SCHED_NBR , D.DISTRIB_LINE_NUM , D.PO_DIST_LINE_NUM , D.DISTRIB_LINE_NUM , D.ACCOUNT , D.ALTACCT , D.DEPTID , D.BUSINESS_UNIT_GL , %Substring(C.DESCR254_MIXED,1,30) , D.QTY_DS_ACCPT_VUOM , D.QTY_DS_ACCPT_VUOM , D.STATISTICS_CODE , D.STATISTIC_AMOUNT , D.MERCHANDISE_AMT , D.BUSINESS_UNIT_PC , D.ACTIVITY_ID , D.ANALYSIS_TYPE , D.RESOURCE_TYPE , D.RESOURCE_CATEGORY , D.RESOURCE_SUB_CAT , D.BUSINESS_UNIT_AM , D.PROFILE_ID , ' ' , ' ' ,%subrec(CF12_AN_SBR, D) , D.PROJECT_ID , %subrec(PUR_USR_DST_SBR, D) , %DateNull FROM PS_RECV_HDR_FS A , PS_RECV_LN_SHIP_FS C , PS_RECV_LN_DIST_FS D WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RECEIVER_ID = C.RECEIVER_ID AND A.IN_PROCESS_FLG = 'N' AND (A.ERS_FLAG = 'N' OR A.ERS_FLAG = ' ') AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.RECEIVER_ID = D.RECEIVER_ID AND C.RECV_LN_NBR = D.RECV_LN_NBR AND C.RECV_SHIP_SEQ_NBR = D.RECV_SHIP_SEQ_NBR AND C.RECV_SHIP_STATUS IN ('R','O','M','C') AND D.DST_ACCT_TYPE = 'DST' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RECV |
Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | RECV_SHIP_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 5 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 6 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 7 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 8 | SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 9 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 10 | PO_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | PO Distribution Line Number |
| 11 | RECV_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Receiver Distrib Line |
| 12 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 13 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 14 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 15 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 16 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 17 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 18 | QTY_DS_ACCPT_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Distributed Qty in Supp UOM |
| 19 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 20 | 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. |
| 21 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 22 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 23 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 24 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 25 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 26 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 27 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 28 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 29 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 30 | ASSET_FLG | Character(1) | VARCHAR2(1) NOT NULL | Assets Applicable |
| 31 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 32 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 33 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 34 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 35 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 36 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 37 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 38 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 39 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 40 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 41 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 42 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 43 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 44 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 45 | USER_DIST_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 46 | CUSTOM_C100_D1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 47 | CUSTOM_C100_D2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 48 | CUSTOM_C100_D3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 49 | CUSTOM_C100_D4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 50 | CUSTOM_DATE_D | Date(10) | DATE | Custom Date |
| 51 | CUSTOM_C1_D | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 52 | BUDGET_DT | Date(10) | DATE | Budget Date |