VCHR_RCV_CSD_VW

(SQL View)
Index Back

Voucher Rcv Custom Duty


SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , C.RECV_LN_NBR , C.RECV_SHIP_SEQ_NBR , C.BUSINESS_UNIT_PO , C.PO_ID , C.LINE_NBR , C.SCHED_NBR , D.CSD_APPL_FLG , D.CSD_TAX_RATE_CD , D.CSD_TPRTNR_CATG_CD , D.CSD_ITM_CATG_CD , D.EXS_TAX_TXN_TYPE , D.ORG_SETID , D.ORG_CODE , D.ORG_TAX_LOC_CD FROM PS_RECV_HDR_FS A , PS_RECV_LN_SHIP_FS C , PS_VCHR_PO_CSD_VW D WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RECEIVER_ID = C.RECEIVER_ID AND C.BUSINESS_UNIT_PO = D.BUSINESS_UNIT_PO AND C.PO_ID = D.PO_ID AND C.LINE_NBR = D.LINE_NBR AND C.SCHED_NBR = D.SCHED_NBR AND D.CSD_APPL_FLG = 'Y'

# 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 CSD_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Customs Duty applicable flag
10 CSD_TAX_RATE_CD Character(10) VARCHAR2(10) NOT NULL Customs Tax Rate Code
11 CSD_TPRTNR_CATG_CD Character(10) VARCHAR2(10) NOT NULL Customs Duty Tax Category
12 CSD_ITM_CATG_CD Character(10) VARCHAR2(10) NOT NULL Customs Duty Item Category Code
13 EXS_TAX_TXN_TYPE Character(4) VARCHAR2(4) NOT NULL Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import
14 ORG_SETID Character(5) VARCHAR2(5) NOT NULL Organization SetID.
15 ORG_CODE Character(6) VARCHAR2(6) NOT NULL Organization Code. This will be unique to an Organization.
16 ORG_TAX_LOC_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code. An Organization can have multiple Tax Location Codes.