VCHR_RECV_DS_VW(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 , ' ' , g.CURRENCY_CD ,%subrec(CF12_AN_SBR, D) , D.PROJECT_ID , g.vat_txn_type_cd , g.vat_aport_cntrl , g.cost_type , g.vat_applicability , g.tax_cd_vat , g.tax_cd_vat_pct , g.vat_recovery_pct , g.vat_rebate_pct , g.vat_calc_type , g.vat_nrcvr_pro_flg , g.vat_rcvry_pct_src , g.vat_rebate_pct_src , %subrec(pur_usr_dst_sbr, d) , g.entry_event , g.budget_dt , g.business_unit_in , g.peg_status , g.vat_use_id , g.distrib_pct FROM PS_RECV_HDR_FS A , PS_RECV_LN_SHIP_FS C , PS_RECV_LN_DIST_FS D , PS_PO_HDR_FS F , ps_po_line_dist_fs g WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.PO_ID = F.PO_ID AND A.RECEIVER_ID = C.RECEIVER_ID AND A.IN_PROCESS_FLG = 'N' AND (A.ERS_FLAG = 'N' OR A.ERS_FLAG = ' ') AND C.BUSINESS_UNIT_PO = F.BUSINESS_UNIT 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 C.RECV_LN_MATCH_OPT IN ('N', 'P') AND D.DST_ACCT_TYPE = 'DST' AND D.business_unit_po = g.business_unit AND D.po_id = g.po_id AND D.line_nbr = g.line_nbr AND D.sched_nbr = g.sched_nbr AND g.DISTRIB_LINE_NUM = D.PO_DIST_LINE_NUM AND g.dst_acct_type = 'DST' AND F.CC_USE_FLAG IN ('N',' ') |
| # | 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 | VAT_TXN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. |
| 46 | VAT_APORT_CNTRL | Character(1) | VARCHAR2(1) NOT NULL |
VAT Apportionment Control
D=Distribution GL Business Unit G=Transaction GL Business Unit T=Transaction Business Unit |
| 47 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Cost Type |
| 48 | VAT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated |
| 49 | TAX_CD_VAT | Character(8) | VARCHAR2(8) NOT NULL | Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for. |
| 50 | TAX_CD_VAT_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage. |
| 51 | VAT_RECOVERY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Recovery Percent |
| 52 | VAT_REBATE_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Rebate Percent |
| 53 | VAT_CALC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive I=Inclusive |
| 54 | VAT_NRCVR_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Non-Recoverable VAT |
| 55 | VAT_RCVRY_PCT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
VAT Recovery Percent Source
A=Automatically calculated M=Manual Entry |
| 56 | VAT_REBATE_PCT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
VAT Rebate Percent Source
A=Automatically calculated M=Manual Entry |
| 57 | USER_DIST_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 58 | CUSTOM_C100_D1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 59 | CUSTOM_C100_D2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 60 | CUSTOM_C100_D3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 61 | CUSTOM_C100_D4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 62 | CUSTOM_DATE_D | Date(10) | DATE | Custom Date |
| 63 | CUSTOM_C1_D | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 64 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | Entry Event |
| 65 | BUDGET_DT | Date(10) | DATE | Budget Date |
| 66 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 67 | PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Not Pegged |
| 68 | VAT_USE_ID | Character(6) | VARCHAR2(6) NOT NULL | VAT Use Type |
| 69 | DISTRIB_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Distribution Percentage |