A_PM_JOB_APPROVAL_HISTORY

Name: A_PM_JOB_APPROVAL_HISTORY
Creator: Ryan Brents
License: https://creativecommons.org/licenses/by/4.0/

Archived PM Job Approval Audit Table

tableMANPM

A_PM_JOB_APPROVAL_HISTORY — Archived PM Job Approval Audit Table. MAN table in the standard Ross ERP 8.0 schema: 22 columns, used by 3 programs. Columns, data types, keys, foreign keys and relationships.

Open A_PM_JOB_APPROVAL_HISTORY in the interactive Data Dictionary →

Part of PM tables & objects · all tables, views & procedures

Columns

#	Column	Type	Description
1	GEM_DBKEY	int	GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2	ARCHIVE_ID	varchar(1)	Prefix Fields for Archive Tables
3	COMPANY_CODE	varchar(10)	Company Code
4	FACTORY	varchar(2)	Factory Code
5	JOB_NUMBER	varchar(10)	Job Number
6	PROCESS_SPEC	varchar(15)	Process Specification
7	PROCESS_STAGE	varchar(6)	Process Stage
8	SYS_VERSION_NUMBER	int	Version Number
9	PM_EXEC_APPROVAL_STATUS	varchar(1)	Execution Approval Status
10	PM_MFG_APPROVAL_STATUS	varchar(1)	Manufacturing Approval Status
11	PM_SHIP_APPROVAL_STATUS	varchar(1)	Shipping Approval Status
12	PM_EXEC_APPROVAL_DATE	datetime
13	PM_MFG_APPROVAL_DATE	datetime
14	PM_SHIP_APPROVAL_DATE	datetime
15	PM_SHIP_APPROVAL_INCL_UNLOT	varchar(1)	Include Unlotted in Shipping Approval Requirement
16	PM_SHIP_APPROVAL_INCL_REPL	varchar(1)	Include Replenishable Lots in Shipping Approval Requirement
17	PM_EXEC_USERNAME	varchar(20)	Execution Approved by
18	PM_MFG_USERNAME	varchar(20)	Manufacturing Approved by
19	PM_SHIP_USERNAME	varchar(20)	Shipping Approved by
20	ARCHIVE_DATE	datetime	Archive Date
21	ARCHIVE_USERNAME	varchar(20)	Username recorded when the row was moved to the archive.
22	GEM_ARCHIVE_FLAG	varchar(20)	System flag indicating whether the row has been archived by the GEMBASE archive process.