RECV_ACCOUNT_VW

(SQL View)
 Index Back

Receipt Distribution View


SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.DISTRIB_LINE_NUM , A.ACCOUNT , A.ALTACCT , A.DEPTID , A.BUSINESS_UNIT_AM , A.BUSINESS_UNIT_GL , A.BUSINESS_UNIT_IN , A.BUSINESS_UNIT_PO , A.CHARTFIELD_STATUS , A.CONSIGNED_FLAG , A.COST_TYPE , A.COSTED_FLAG , A.CURRENCY_CD , A.CURRENCY_CD_BASE , A.DELIVERED_DT , A.DELIVERED_FLG , A.DELIVERED_TO , A.DISTRIB_TYPE , A.DST_ACCT_TYPE , A.FINANCIAL_ASSET_SW , A.LINE_NBR , A.LOCATION , A.LOC_RECV_LBL_FLG , A.MERCH_AMT_BSE , A.MERCHANDISE_AMT , A.MERCHANDISE_AMT_PO , A.MOV_DS_ACCPT_SUOM , A.PO_DIST_LINE_NUM , A.PO_ID , A.PROCESS_INSTANCE , A.PROFILE_ID , A.QTY_DS_ACCPT_SUOM , A.QTY_DS_ACCPT_VUOM , A.QTY_PO , A.RATE_DIV , A.RATE_MULT , A.RECV_DS_STATUS , A.REQ_ID , A.RT_TYPE , A.SCHED_NBR , A.STATISTICS_CODE , A.STATISTIC_AMOUNT , %subrec(CF15_AN_SBR,A) , %subrec(PC_CF1_N_SBR,A) FROM PS_RECV_LN_DISTRIB A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT

7 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: %EDIT_ALTACCT

8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: %EDIT_DEPT

9 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BUPRCR_NONVW

11 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
12 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
13 CHARTFIELD_STATUS Character(1) VARCHAR2(1) NOT NULL Chartfield Status
R=Recycled
V=Valid
14 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag

Y/N Table Edit

Default Value: N

15 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

Prompt Table: COST_TYPE_TBL

16 COSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction
E=Error; Cannot process
N=Transaction is Not Costed
P=Qualified for Purging
X=Transaction Won't be Costed
Y=Transaction is Costed

Y/N Table Edit

17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
18 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
19 DELIVERED_DT Date(10) DATE Delivered Date
20 DELIVERED_FLG Character(1) VARCHAR2(1) NOT NULL Delivered Flag

Y/N Table Edit

21 DELIVERED_TO Character(30) VARCHAR2(30) NOT NULL Delivered To
22 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
23 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
24 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
N=Non Cap
Y=Capitalize
25 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
26 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
27 LOC_RECV_LBL_FLG Character(1) VARCHAR2(1) NOT NULL Location Labels Processed

Y/N Table Edit

28 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
29 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
30 MERCHANDISE_AMT_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Merchandise Amount
31 MOV_DS_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Interfaced Qty
32 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
33 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
34 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
35 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
36 QTY_DS_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Distributed Quantity
37 QTY_DS_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Distributed Qty in Supp UOM
38 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
39 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
40 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
41 RECV_DS_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Closed
H=Hold
M=Moved
O=Open
R=Received
X=Cancelled
42 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
43 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
44 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
45 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
46 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.
47 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: %EDIT_OPER_UNIT

48 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: %EDIT_PRODUCT

49 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: %EDIT_FUND_CODE

50 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: %EDIT_CLASS_FLD

51 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: %EDIT_PROG_CODE

52 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: %EDIT_BUD_REF

53 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

54 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

55 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

56 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: %EDIT_CHARTFLD1

57 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: %EDIT_CHARTFLD2

58 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: %EDIT_CHARTFLD3

59 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

60 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

61 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

62 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

63 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

64 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

65 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC