LTTR_OF_CR_VW

(SQL View)
 Index Back

Letter of Credit View

SELECT DISTINCT A.BUSINESS_UNIT,B.BUSINESS_UNIT,A.BILL_TO_CUST_ID,B.LC_ID,B.LAST_MAINT_OPRID,B.LAST_MAINT_DTTM FROM PS_ORD_HEADER A, PS_LC_HDR B WHERE B.BUSINESS_UNIT = (SELECT C.BUSINESS_UNIT_BI FROM PS_BUS_UNIT_TBL_OM C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT) AND B.IMPORT_EXPORT_IND = 'E'

SELECT DISTINCT A.BUSINESS_UNIT ,B.BUSINESS_UNIT ,A.BILL_TO_CUST_ID ,B.LC_ID ,B.LAST_MAINT_OPRID ,B.LAST_MAINT_DTTM FROM PS_ORD_HEADER A , PS_LC_HDR B WHERE B.BUSINESS_UNIT = ( SELECT C.BUSINESS_UNIT_BI FROM PS_BUS_UNIT_TBL_OM C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT) AND B.IMPORT_EXPORT_IND = 'E'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_OM

2 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

Prompt Table: SP_BU_BI_NONVW

3 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: CUST_SLDBLL_VW

4 CR_LTTR_NBR Character(14) VARCHAR2(14) NOT NULL Letter of Credit Number
5 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
6 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified