CART_CT_INF_INV (SQL Table)	Index Back
Par Loc Count Interface Table This is the primary table used to record par location counts. This table is updated through on-line panels and through the par location count upload SQR.

CART_CT_INF_INV

(SQL Table)

Par Loc Count Interface Table

This is the primary table used to record par location counts. This table is updated through on-line panels and through the par location count upload SQR.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW

2 INV_CART_ID Character(15) VARCHAR2(15) NOT NULL Par Location ID
Prompt Table: CART_ATTRIB_INV

3 CART_COUNT_ID Number(10,0) DECIMAL(10) NOT NULL Par Location Count ID

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

5 COMPARTMENT Character(10) VARCHAR2(10) NOT NULL Compartment

6 COUNT_ORDER Signed Number(5,0) DECIMAL(4) NOT NULL Par Location Count Order

7 CART_COUNT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Par Location Count Quantity

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

9 QTY_OPTIMAL Signed Number(17,4) DECIMAL(15,4) NOT NULL Optimal Qty

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

11 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price

12 CHARGE_CODE Character(20) VARCHAR2(20) NOT NULL Charge Code
Prompt Table: CHARGE_CODE_INV

13 LAST_OPRID Character(30) VARCHAR2(30) NOT NULL Last Response Operator

14 LAST_DTTM_UPDATE 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.

15 DEMAND_DATE Date(10) DATE Demand Date

16 CART_COUNT_STATUS Character(3) VARCHAR2(3) NOT NULL Par Location Count Status
1=Unprocessed
2=In Process
3=In Error
4=Complete
5=Interim Hold
Default Value: 1

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

18 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %

19 CART_REPLEN_OPT Character(2) VARCHAR2(2) NOT NULL Par Replenishment Option
01=Stock
02=Stockless
03=Non-Stock
04=Not Replenished
Default Value: 01

20 QTY_OPTION Character(2) VARCHAR2(2) NOT NULL Qty Option
01=Count Qty
02=Request Qty
Default Value: 01

21 SUFFICIENT_STOCK Character(1) VARCHAR2(1) NOT NULL Sufficient Stock
N=NOT SUFFICIENT STOCK
Y=SUFFICIENT STOCK
Y/N Table Edit
Default Value: N

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

44 FOQ Signed Number(17,4) DECIMAL(15,4) NOT NULL Fixed Order Quantity

45 QTY_MAXIMUM Signed Number(17,4) DECIMAL(15,4) NOT NULL Maximum Qty

46 COUNT_REQUIRED Character(1) VARCHAR2(1) NOT NULL Count Required
Y/N Table Edit

47 CART_REPLEN_CTRL Character(2) VARCHAR2(2) NOT NULL Replenishment Control
01=Par
02=Fixed Order Qty
03=Min/Max

48 CONS_NON_STOCK Character(1) VARCHAR2(1) NOT NULL Consolidate Non-Stock
Y/N Table Edit

49 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes

50 MATERIAL_RECON_FLG Character(1) VARCHAR2(1) NOT NULL Material Reconciliation Flag

51 USG_TRCKNG_METHOD Character(2) VARCHAR2(2) NOT NULL Usage Tracking Method
01=None
02=Billing
03=Costing

52 CHARGE_MARKUP_PCNT Signed Number(16,2) DECIMAL(14,2) NOT NULL Charge Markup %

53 CHARGE_MARKUP_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Charge Markup Amt

54 TRANSFER_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost
Default Value: 0

55 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

56 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

57 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number

58 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number

59 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number

60 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity

61 REPLEN_STATUS Character(1) VARCHAR2(1) NOT NULL Replenish Status
1=Ready
2=Error
3=In Process
4=Processed
5=Canceled

62 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

63 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

64 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1

65 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2

66 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3

67 MESSAGE_PARM4 Character(30) VARCHAR2(30) NOT NULL Message Parameter 4

68 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

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

70 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

71 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
Default Value: %Datetime

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW
2	INV_CART_ID	Character(15)	VARCHAR2(15) NOT NULL	Par Location ID Prompt Table: CART_ATTRIB_INV
3	CART_COUNT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Par Location Count ID
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
5	COMPARTMENT	Character(10)	VARCHAR2(10) NOT NULL	Compartment
6	COUNT_ORDER	Signed Number(5,0)	DECIMAL(4) NOT NULL	Par Location Count Order
7	CART_COUNT_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Par Location Count Quantity
8	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
9	QTY_OPTIMAL	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Optimal Qty
10	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
11	TRANSFER_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Transfer Price
12	CHARGE_CODE	Character(20)	VARCHAR2(20) NOT NULL	Charge Code Prompt Table: CHARGE_CODE_INV
13	LAST_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Response Operator
14	LAST_DTTM_UPDATE	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.
15	DEMAND_DATE	Date(10)	DATE	Demand Date
16	CART_COUNT_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Par Location Count Status 1=Unprocessed 2=In Process 3=In Error 4=Complete 5=Interim Hold Default Value: 1
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	PRICE_MARKUP_PCT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Price Markup %
19	CART_REPLEN_OPT	Character(2)	VARCHAR2(2) NOT NULL	Par Replenishment Option 01=Stock 02=Stockless 03=Non-Stock 04=Not Replenished Default Value: 01
20	QTY_OPTION	Character(2)	VARCHAR2(2) NOT NULL	Qty Option 01=Count Qty 02=Request Qty Default Value: 01
21	SUFFICIENT_STOCK	Character(1)	VARCHAR2(1) NOT NULL	Sufficient Stock N=NOT SUFFICIENT STOCK Y=SUFFICIENT STOCK Y/N Table Edit Default Value: N
22	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
23	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
24	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
25	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
26	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
27	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
28	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
29	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
30	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
31	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
32	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
33	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
34	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
35	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
36	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
37	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
38	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
39	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
40	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
41	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
42	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
43	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
44	FOQ	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Fixed Order Quantity
45	QTY_MAXIMUM	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Maximum Qty
46	COUNT_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Count Required Y/N Table Edit
47	CART_REPLEN_CTRL	Character(2)	VARCHAR2(2) NOT NULL	Replenishment Control 01=Par 02=Fixed Order Qty 03=Min/Max
48	CONS_NON_STOCK	Character(1)	VARCHAR2(1) NOT NULL	Consolidate Non-Stock Y/N Table Edit
49	BCKORDR_CNCL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cancel Backorder N=Cancel Backorder No Y=Cancel Backorder Yes
50	MATERIAL_RECON_FLG	Character(1)	VARCHAR2(1) NOT NULL	Material Reconciliation Flag
51	USG_TRCKNG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Usage Tracking Method 01=None 02=Billing 03=Costing
52	CHARGE_MARKUP_PCNT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Charge Markup %
53	CHARGE_MARKUP_AMT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Charge Markup Amt
54	TRANSFER_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Holds information regarding when the transfer price is calculated. 0=Calculate Cost at Depletions 1=Transfer at Zero Cost Default Value: 0
55	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
56	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
57	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
58	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
59	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
60	QTY_REQ	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition Quantity
61	REPLEN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Replenish Status 1=Ready 2=Error 3=In Process 4=Processed 5=Canceled
62	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
63	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
64	MESSAGE_PARM1	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 1
65	MESSAGE_PARM2	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 2
66	MESSAGE_PARM3	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 3
67	MESSAGE_PARM4	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 4
68	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
69	PROCESS_INSTANCE2	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
70	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
71	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time Default Value: %Datetime