DS_NETHDR_TBL(SQL Table) |
Index Back |
---|---|
Ship From IBU HierarchyThis table is the parent of the DS_NETDET_TBL, and stores the Distribution Network Code for the IBU (warehouse) hierarchy. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
|
2 | Character(6) | VARCHAR2(6) NOT NULL | Distribution Network Code | |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | 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. |
5 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
6 | DATETIME_ADDED | DateTime(26) | TIMESTAMP | DateTime Added |