BOL_INV_VW

(SQL View)
Index Back

Bill of Lading View - INV


select business_unit, ship_manifest_num, carrier_id, bill_of_lading, doc_print_date from PS_BOL_INV

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

2 SHIP_MANIFEST_NUM Character(10) VARCHAR2(10) NOT NULL Shipping Manifest Number
3 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
4 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
5 DOC_PRINT_DATE Date(10) DATE Document Print Date