ORD_HDR_LCK_VW (SQL View)	Index Back
Order locking record This record will be used to track locking status of orders for batch jobs and will serve as the "true" source of information regarding order processing flags (eg. in_process_flag, background_reqd) and order update information (eg. last_maint_oprid, lastupddttm).

ORD_HDR_LCK_VW

(SQL View)

Order locking record

This record will be used to track locking status of orders for batch jobs and will serve as the "true" source of information regarding order processing flags (eg. in_process_flag, background_reqd) and order update information (eg. last_maint_oprid, lastupddttm).

SELECT H.BUSINESS_UNIT , H.ORDER_NO , L.PROCESS_INSTANCE , L.PROCESS_INSTANCE2 , %subrec(ORD_LOCK_SBR , H) , H.VAT_ENTITY , B.BUSINESS_UNIT_BI , B.TAX_VENDOR FROM PS_ORD_HEADER H , PS_ORD_HEADER_LOCK L , PS_BUS_UNIT_TBL_OM B WHERE %Join(COMMON_KEYS, ORD_HEADER H, ORD_HEADER_LOCK L) AND %Join(COMMON_KEYS, ORD_HEADER H, BUS_UNIT_TBL_OM B)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

4 PROCESS_INSTANCE2 Number(10,0) DECIMAL(10) NOT NULL Process Instance

5 BACKGROUND_REQD Character(1) VARCHAR2(1) NOT NULL Background Process Required
E=OMBCKEND Req'd
N=No
P=Pricing Req'd
Y=Yes
Default Value: N

6 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
Default Value: N

7 HOLD_REQD Character(1) VARCHAR2(1) NOT NULL Hold Processing Required
Default Value: N

8 CREDIT_REQD Character(1) VARCHAR2(1) NOT NULL Credit Check Required
Default Value: N

9 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

11 LAST_DTTM_ORD_UPD DateTime(26) TIMESTAMP Last Order Change Date

12 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

13 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
Default Value: 0

14 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

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

16 TAX_VENDOR Character(1) VARCHAR2(1) NOT NULL Tax Provider
A=Taxware
N=None
V=Vertex

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	PROCESS_INSTANCE2	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
5	BACKGROUND_REQD	Character(1)	VARCHAR2(1) NOT NULL	Background Process Required E=OMBCKEND Req'd N=No P=Pricing Req'd Y=Yes Default Value: N
6	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Default Value: N
7	HOLD_REQD	Character(1)	VARCHAR2(1) NOT NULL	Hold Processing Required Default Value: N
8	CREDIT_REQD	Character(1)	VARCHAR2(1) NOT NULL	Credit Check Required Default Value: N
9	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
10	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
11	LAST_DTTM_ORD_UPD	DateTime(26)	TIMESTAMP	Last Order Change Date
12	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
13	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference Default Value: 0
14	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
15	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
16	TAX_VENDOR	Character(1)	VARCHAR2(1) NOT NULL	Tax Provider A=Taxware N=None V=Vertex