BUSINESS_UNITORDER_NOE=OMBCKEND Req'd
N=No
P=Pricing Req'd
Y=Yes
Default Value: N
Default Value: N
Default Value: N
Default Value: N
Default Value: 0
ORD_HEADER_LOCK(SQL Table) |
Index Back |
|---|---|
Order locking recordThis 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). Date Initials Issue Description 111506 dms 1576506002 New record |
| # | 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 |