CM_CST_SPLT2_VW (SQL View)	Index Back
Component Transfers View 08/05/99 ebn CN#CM800-9.0 Added CM_BOOK

CM_CST_SPLT2_VW

(SQL View)

Component Transfers View

08/05/99 ebn CN#CM800-9.0 Added CM_BOOK

SELECT B.BUSINESS_UNIT , B.INV_ITEM_ID , B.DT_TIMESTAMP , A.FROM_PRDN_ID , A.TO_PRDN_ID , B.SEQ_NBR , B.CM_DT_TIMESTAMP , B.CM_SEQ_NBR , B.CM_DT_TIMESTAMP_A , B.CM_SEQ_NBR_A , B.CM_BOOK , B.COST_ELEMENT , B.CM_SEQ_COST , A.QTY_BASE , A.QTY , A.UNIT_MEASURE_STD , A.DOCUMENT_ID , A.NON_COST_FLAG , A.NON_OWN_FLAG , A.COSTED_FLAG , A.OPRID , A.DISTRIB_TYPE , B.CM_UNIT_COST , B.POSTED_FLAG , B.PROCESS_INSTANCE , B.PROCESS_FLAG , B.TRANSACTION_GROUP , C.BUSINESS_UNIT_GL , C.BASE_CURRENCY , C.BASE_CURRENCY , C.APPL_JRNL_ID , A.TRANSACTION_DATE , A.CONSIGNED_FLAG , A.DESTIN_GL_BU , A.DESTIN_BU , A.SOURCE_BUS_UNIT , A.STORAGE_AREA , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF16_AN_SBR,A) , %subrec(PC_CF1_N_SBR, A) , %subrec(CM_TRANS_IN_SBR, A) , A.SHIP_ID FROM PS_TRANSACTION_INV A , PS_CM_DEPLETE_COST B , PS_BUS_UNIT_TBL_IN C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.DT_TIMESTAMP = B.DT_TIMESTAMP AND A.SEQ_NBR = B.SEQ_NBR AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.TRANSACTION_GROUP = '223' AND B.POSTED_FLAG = 'N' AND B.CM_COST_MODE = 'L' AND A.ADJUST_TYPE = 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

3 DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Date Timestamp

4 FROM_PRDN_ID Character(10) VARCHAR2(10) NOT NULL From Production ID

5 TO_PRDN_ID Character(10) VARCHAR2(10) NOT NULL To Production ID

6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

7 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Receipt dttm.

8 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

9 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP NOT NULL 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.

10 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:

11 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book

12 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

13 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.

14 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity

15 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity

16 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

17 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document

18 NON_COST_FLAG Character(1) VARCHAR2(1) NOT NULL Non Cost

19 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes

20 COSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction
E=Error; Cannot process
N=Transaction is Not Costed
P=Qualified for Purging
X=Transaction Won't be Costed
Y=Transaction is Costed

21 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

22 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

23 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost

24 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted

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

26 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least

27 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.

28 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

30 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

31 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

32 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

33 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag

34 DESTIN_GL_BU Character(5) VARCHAR2(5) NOT NULL Destination GL Business Unit

35 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit

36 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

37 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

38 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

39 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

40 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPTID_BUGL_VW

41 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW

42 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_BUGL_VW

43 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL_VW

44 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASSCF_BUGL_VW

45 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW

46 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_BUGL_VW

47 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

48 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

49 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

50 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL_VW

51 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW

52 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW

53 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDIT_BU_PC

54 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: %EDIT_PROJECT

55 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

56 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

57 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

58 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

59 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

60 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

61 COUNTING_EVENT_ID Number(15,0) DECIMAL(15) NOT NULL Counting Event ID

62 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

63 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

64 FROM_PRDN_AREA Character(10) VARCHAR2(10) NOT NULL From Production Area

65 FROM_PRDN_TYPE Character(2) VARCHAR2(2) NOT NULL From Production Type
PR=Production
RW=Rework
SV=Service
TD=Teardown

66 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

67 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

68 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

69 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

70 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

71 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

72 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown

73 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

74 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

75 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

76 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence

77 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

78 STAGED_DATE Date(10) DATE Staged Date

79 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

80 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

81 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

82 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

83 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

84 TO_PRDN_AREA Character(10) VARCHAR2(10) NOT NULL To Production Area

85 TO_PRDN_TYPE Character(2) VARCHAR2(2) NOT NULL To Production Type
PR=Production
RW=Rework
SV=Service
TD=Teardown

86 TO_STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

87 TO_STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

88 TO_STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

89 TO_STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

90 TO_STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

91 TRANSACTION_SOURCE Character(2) VARCHAR2(2) NOT NULL Transaction Source

92 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

93 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	DT_TIMESTAMP	DateTime(26)	TIMESTAMP NOT NULL	Date Timestamp
4	FROM_PRDN_ID	Character(10)	VARCHAR2(10) NOT NULL	From Production ID
5	TO_PRDN_ID	Character(10)	VARCHAR2(10) NOT NULL	To Production ID
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	CM_DT_TIMESTAMP	DateTime(26)	TIMESTAMP NOT NULL	Receipt dttm.
8	CM_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
9	CM_DT_TIMESTAMP_A	DateTime(26)	TIMESTAMP NOT NULL	07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
10	CM_SEQ_NBR_A	Number(15,0)	DECIMAL(15) NOT NULL	07/99 GMG CN800-9.0:
11	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
12	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
13	CM_SEQ_COST	Number(15,0)	DECIMAL(15) NOT NULL	Cost Sequence Number. Incremented each time the actual cost is updated.
14	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity
15	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
16	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
17	DOCUMENT_ID	Character(12)	VARCHAR2(12) NOT NULL	Document
18	NON_COST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Non Cost
19	NON_OWN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o N=No Y=Yes
20	COSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction E=Error; Cannot process N=Transaction is Not Costed P=Qualified for Purging X=Transaction Won't be Costed Y=Transaction is Costed
21	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
22	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
23	CE_EXTENDED_COST	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	Extended Cost
24	POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program. N=Not Posted X=Don't Post Y=Posted
25	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
26	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least
27	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
28	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
29	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
30	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
31	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
32	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
33	CONSIGNED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Consigned Flag
34	DESTIN_GL_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination GL Business Unit
35	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
36	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
37	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	Storage Area
38	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
39	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
40	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
41	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
42	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
43	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
44	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
45	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
46	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
47	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
48	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
49	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
50	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
51	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
52	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
53	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
54	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
55	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
56	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
57	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
58	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
59	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
60	CONTAINER_ID	Character(10)	VARCHAR2(10) NOT NULL	Container ID
61	COUNTING_EVENT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Counting Event ID
62	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
63	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
64	FROM_PRDN_AREA	Character(10)	VARCHAR2(10) NOT NULL	From Production Area
65	FROM_PRDN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	From Production Type PR=Production RW=Rework SV=Service TD=Teardown
66	INV_LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID
67	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
68	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
69	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
70	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area
71	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
72	PRODUCTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	JNW 11/1/98 (CN#SF800-13) activated teardown xlat PR=Production RW=Rework SV=Service TD=Teardown
73	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
74	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
75	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
76	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
77	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
78	STAGED_DATE	Date(10)	DATE	Staged Date
79	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
80	STOR_LEVEL_1	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 1
81	STOR_LEVEL_2	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 2
82	STOR_LEVEL_3	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 3
83	STOR_LEVEL_4	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 4
84	TO_PRDN_AREA	Character(10)	VARCHAR2(10) NOT NULL	To Production Area
85	TO_PRDN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	To Production Type PR=Production RW=Rework SV=Service TD=Teardown
86	TO_STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	Storage Area
87	TO_STOR_LEVEL_1	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 1
88	TO_STOR_LEVEL_2	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 2
89	TO_STOR_LEVEL_3	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 3
90	TO_STOR_LEVEL_4	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 4
91	TRANSACTION_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Transaction Source
92	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
93	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID