CC_RPTLINE1_T (SQL Table)	Index Back
ProCard Report - Trans Line AE_SECTION = Crystal Report Name, ex POY8010 CRDMEM_ACCT_MSK = Masked or clear card numbers NAME = PERSONAL_DATA.NAME DESCR_LN1 = CC_CARD_TBL_EX.DESCR (in general) CURRENCY_CD1 = CC_CARD_DATA.CURRENCY_CD SHORTNAME = XLAT for CC_CARD_TYPE DESCR_LN2 = COMMOD_CODE.DESCR (in POY8000) DESCR_LN2 = EX_VIS_MCG_MAP.DESCR (in POY806%)

CC_RPTLINE1_T

(SQL Table)

ProCard Report - Trans Line

AE_SECTION = Crystal Report Name, ex POY8010 CRDMEM_ACCT_MSK = Masked or clear card numbers NAME = PERSONAL_DATA.NAME DESCR_LN1 = CC_CARD_TBL_EX.DESCR (in general) CURRENCY_CD1 = CC_CARD_DATA.CURRENCY_CD SHORTNAME = XLAT for CC_CARD_TYPE DESCR_LN2 = COMMOD_CODE.DESCR (in POY8000) DESCR_LN2 = EX_VIS_MCG_MAP.DESCR (in POY806%)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSONAL_DATA

6 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor

7 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
Prompt Table: CC_CARD_DATA_EX
Set Control Field: CREDIT_CARD_VENDOR

8 TRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number

9 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number

10 TRANS_DT Date(10) DATE Transaction Date

11 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

12 DTTM_STAMP 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.

13 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID

14 POST_DT Date(10) DATE The Date a transaction was Posted.

15 BILLING_DATE Date(10) DATE Billing Date

16 CC_STATUS Character(1) VARCHAR2(1) NOT NULL Statement Status
0=Staged
1=Initial
2=Verified
3=Approved
4=Closed
5=Error
6=Processing

17 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code

18 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant

19 MERCHANT_REF Character(30) VARCHAR2(30) NOT NULL Reference Number

20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

22 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

23 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

24 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

25 CITY Character(30) VARCHAR2(30) NOT NULL City

26 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

27 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

28 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

29 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

30 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

31 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

32 COUNTY Character(30) VARCHAR2(30) NOT NULL County

33 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

34 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

35 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

36 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

37 TAXPAYER_ID Character(14) VARCHAR2(14) NOT NULL Taxpayer ID

38 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID

39 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code
Prompt Table: COMMOD_CODE

40 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

41 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
Prompt Table: SHIPTO_TBL

42 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: %EDIT_UOM

43 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity
Default Value: Q

44 CHARGE_CATEGORY Character(3) VARCHAR2(3) NOT NULL Transaction Charge Type
1=New Charge
2=Other Debits
4=Payment
5=Other Credits

45 INCLUDE_TAX Character(1) VARCHAR2(1) NOT NULL Bill Includes Tax if Applied
Y/N Table Edit
Default Value: Y

46 TAX_PAID Character(1) VARCHAR2(1) NOT NULL Tax Paid
Y/N Table Edit
Default Value: Y

47 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity

48 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price

49 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

50 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
Prompt Table: CURRENCY_CD_TBL

51 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price

52 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

53 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

54 CUR_RT_TYPE_BNK Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

55 CUR_EXCHNG_RT Number(16,8) DECIMAL(15,8) NOT NULL Currency Exchange Rate
Default Value: 1

56 CORP_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL Corporate Number

57 CREDIT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Date Init Ref# Descr 112007 LAKM 1717216002 Changed the filed type to enter credit value for Dispute amount field

58 CREDIT_COLLECTED Character(1) VARCHAR2(1) NOT NULL Credit Collected
Y/N Table Edit
Default Value: N

59 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PM_NONVW

60 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

61 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR_POVW1

62 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
Prompt Table: VNDR_LOC_VW1

63 VENDOR_TYPE Character(3) VARCHAR2(3) NOT NULL Vendor Type
ADV=Ads
CNS=Consultant
CNT=Contractor
ENT=Entertain
FRG=Foreign
GVT=Government
MNR=Minority
PR=PR
TRD=Tradesman
TRN=Transport
TRV=Travel

64 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

65 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: %EDIT_ITEM_ID
Set Control Field: ITM_SETID

66 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
Prompt Table: ITM_CAT_VW

67 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount

68 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
Prompt Table: CURRENCY_CD_TBL

69 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

70 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
Default Value: 1

71 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
Default Value: 1

72 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes

73 ENTERED_DT Date(10) DATE Entered on

74 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By

75 APPROVAL_DT Date(10) DATE Date of Approval

76 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.

77 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.

78 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered

79 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number

80 SUT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Applicability
D=Direct Pay
E=Item is Exempt
S=Sales Tax Applicable
U=Use Tax Applicable
X=Purchaser Is Exonerated

81 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
Prompt Table: SUT_BASE_VW

82 SUT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Sales/Use Tax Exception Certif

83 SUT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None

84 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax

85 TAX_CD_SUT_PCT Number(8,4) DECIMAL(7,4) NOT NULL Sales/Use Tax Code Percent

86 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
Default Value: V

87 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic

88 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes

89 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator

90 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime

91 CHRTFLD_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Chartfield Status
R=Recycled
V=Valid
Default Value: V

92 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
Prompt Table: %EDITTABLE2

93 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
Prompt Table: CC_PO_LINE_VW

94 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
Prompt Table: CC_PO_SCHED_VW

95 CC_ORIGINAL_PO Character(1) VARCHAR2(1) NOT NULL Original PO
Y/N Table Edit
Default Value: N

96 MERCHANT_CAT_CODE Character(10) VARCHAR2(10) NOT NULL MCC - Merchant Category Code

97 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

98 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

99 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

100 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

101 MERCHANT_UOM Character(20) VARCHAR2(20) NOT NULL Merchant UOM

102 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1

103 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1

104 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2

105 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3

106 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4

107 CUSTOM_DATE_A Date(10) DATE Custom Date

108 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2

109 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1

110 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1

111 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2

112 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3

113 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4

114 CUSTOM_DATE_B Date(10) DATE Custom Date

115 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2

116 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1

117 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1

118 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2

119 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3

120 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1

121 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2

122 CUSTOM_C1_C Character(1) VARCHAR2(1) NOT NULL Custom Character 2

123 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

124 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
Default Value: G

125 VAT_CREDIT_FLAG Character(1) VARCHAR2(1) NOT NULL Claiming Tax Credit
Y/N Table Edit
Default Value: N

126 VAT_RECEIPT Character(1) VARCHAR2(1) NOT NULL No VAT Receipt
Y/N Table Edit
Default Value: N

127 TAX_CREDIT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Date Init Ref# Descr 112007 LAKM 1717216001 Changed the filed type to enter credit value for Disput tax amount field

128 VAT_TOL_ERROR Character(1) VARCHAR2(1) NOT NULL VAT Tolerance Error

129 REDISTRIB_FLAG Character(1) VARCHAR2(1) NOT NULL Redistribute
Y/N Table Edit
Default Value: N

130 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
Prompt Table: SP_BU_WM_NONVW

131 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
Prompt Table: %EDIT_WO_ID

132 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
Prompt Table: %EDIT_WO_TASK

133 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material

134 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
Prompt Table: %EDIT_RES_LINE

135 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Procurement Card Number

136 PREPAID_REF Character(10) VARCHAR2(10) NOT NULL Prepayment Reference

137 NAME Character(50) VARCHAR2(50) NOT NULL Name

138 CC_TO_ET_GRP Character(10) VARCHAR2(10) NOT NULL Merchant Category Group

139 CC_TO_ET_CD_DESCR Character(36) VARCHAR2(36) NOT NULL Description

140 DESCR_LN1 Character(50) VARCHAR2(50) NOT NULL Description Line 1

141 DESCR_LN2 Character(50) VARCHAR2(50) NOT NULL Description Line 2

142 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code

143 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code

144 CURRENCY_CD3 Character(3) VARCHAR2(3) NOT NULL Currency Code

145 EXPIRATION_DT Date(10) DATE Expiration Date

146 FROM_DATE Date(10) DATE From Date

147 THRU_DATE Date(10) DATE Through Date

148 LIMIT_PO_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Limit Per PO

149 LIMIT_CYCLE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Limit Per Pay Cycle

150 NBR_PO_PER_CYCLE Number(5,0) INTEGER NOT NULL Nbr of Transactions Per Cycle

151 NBR_PO_PER_DAY Number(5,0) INTEGER NOT NULL Nbr of Transactions Per Day

152 CRDMEM_ACCT_MSK Character(20) VARCHAR2(20) NOT NULL Cardmember Number

153 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits

154 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user

155 CC_CARD_TYPE Character(4) VARCHAR2(4) NOT NULL Credit Card Type (e.g Corporate Card, debit Card, Procurement Card, etc.)
AMEX=American Express
CORP=Corporate Card
DEBT=Debit Card
MC=MasterCard
PHON=Phone Card
PRCR=Procurement Card
VISA=Visa

156 CC_CARD_FUNCTION Character(4) VARCHAR2(4) NOT NULL Card's charging function
CORP=Corporate Card
DEBT=Debit Card
PHON=Phone Card
PRCR=Procurement Card

157 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name

158 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Prompt Table: SP_BUPRCR_NONVW

159 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event

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

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

162 ACCOUNT_2 Character(10) VARCHAR2(10) NOT NULL Account

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

164 ALTACCT_2 Character(10) VARCHAR2(10) NOT NULL Alternate Account

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

166 BILL_TO Character(1) VARCHAR2(1) NOT NULL Bill To
C=Company
E=Employee

167 CC_VENDOR_CARD Character(1) VARCHAR2(1) NOT NULL Vendor Card
Y/N Table Edit
Default Value: N

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

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

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

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

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

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

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

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

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

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

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

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

180 DT_ISSUED_TO_EMPL Date(10) DATE Date Issued to Employee

181 LIMIT_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Card Limit Amount

182 LIMIT_AMOUNT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Card Limit Amount

183 LIMIT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Limit per Transaction

184 LIMIT_TRANS_AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Limit per Transaction

185 COUNT_LINES Number(15,0) DECIMAL(15) NOT NULL Count of Lines

186 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

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

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

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

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

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

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

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

194 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

195 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
6	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor
7	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number Prompt Table: CC_CARD_DATA_EX Set Control Field: CREDIT_CARD_VENDOR
8	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
9	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
10	TRANS_DT	Date(10)	DATE	Transaction Date
11	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
12	DTTM_STAMP	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.
13	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID
14	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
15	BILLING_DATE	Date(10)	DATE	Billing Date
16	CC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Statement Status 0=Staged 1=Initial 2=Verified 3=Approved 4=Closed 5=Error 6=Processing
17	SIC_CODE	Character(10)	VARCHAR2(10) NOT NULL	Standard Industry Code
18	MERCHANT	Character(40)	VARCHAR2(40) NOT NULL	Merchant
19	MERCHANT_REF	Character(30)	VARCHAR2(30) NOT NULL	Reference Number
20	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
21	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
22	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
23	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
24	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
25	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
26	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
27	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
28	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
29	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
30	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
31	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
32	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
33	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
34	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
35	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
36	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
37	TAXPAYER_ID	Character(14)	VARCHAR2(14) NOT NULL	Taxpayer ID
38	ITM_ID_VNDR	Character(50)	VARCHAR2(50) NOT NULL	Vendor Item ID
39	COMMODITY_CD	Character(10)	VARCHAR2(10) NOT NULL	Commodity Code Prompt Table: COMMOD_CODE
40	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
41	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location Prompt Table: SHIPTO_TBL
42	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDIT_UOM
43	DISTRIB_MTHD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Distribute by A=Amount Q=Quantity Default Value: Q
44	CHARGE_CATEGORY	Character(3)	VARCHAR2(3) NOT NULL	Transaction Charge Type 1=New Charge 2=Other Debits 4=Payment 5=Other Credits
45	INCLUDE_TAX	Character(1)	VARCHAR2(1) NOT NULL	Bill Includes Tax if Applied Y/N Table Edit Default Value: Y
46	TAX_PAID	Character(1)	VARCHAR2(1) NOT NULL	Tax Paid Y/N Table Edit Default Value: Y
47	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
48	UNIT_PRICE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Unit Price
49	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
50	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Prompt Table: CURRENCY_CD_TBL
51	PRICE_PO	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Purchase Order Price
52	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
53	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
54	CUR_RT_TYPE_BNK	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
55	CUR_EXCHNG_RT	Number(16,8)	DECIMAL(15,8) NOT NULL	Currency Exchange Rate Default Value: 1
56	CORP_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	Corporate Number
57	CREDIT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Date Init Ref# Descr 112007 LAKM 1717216002 Changed the filed type to enter credit value for Dispute amount field
58	CREDIT_COLLECTED	Character(1)	VARCHAR2(1) NOT NULL	Credit Collected Y/N Table Edit Default Value: N
59	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PM_NONVW
60	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
61	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_POVW1
62	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_LOC_VW1
63	VENDOR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Vendor Type ADV=Ads CNS=Consultant CNT=Contractor ENT=Entertain FRG=Foreign GVT=Government MNR=Minority PR=PR TRD=Tradesman TRN=Transport TRV=Travel
64	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
65	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: %EDIT_ITEM_ID Set Control Field: ITM_SETID
66	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID Prompt Table: ITM_CAT_VW
67	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
68	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency Prompt Table: CURRENCY_CD_TBL
69	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
70	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier Default Value: 1
71	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor Default Value: 1
72	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
73	ENTERED_DT	Date(10)	DATE	Entered on
74	OPRID_APPROVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
75	APPROVAL_DT	Date(10)	DATE	Date of Approval
76	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
77	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.
78	COMMENT_ID	DateTime(26)	TIMESTAMP	DtTm Entered
79	RANDOM_CMMT_NBR	Number(4,0)	SMALLINT NOT NULL	Random Comments Number
80	SUT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	Sales/Use Tax Applicability D=Direct Pay E=Item is Exempt S=Sales Tax Applicable U=Use Tax Applicable X=Purchaser Is Exonerated
81	SUT_BASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Tax Destination Prompt Table: SUT_BASE_VW
82	SUT_EXCPTN_CERTIF	Character(20)	VARCHAR2(20) NOT NULL	Sales/Use Tax Exception Certif
83	SUT_EXCPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Sales/Use Tax Exception Type D=Direct Pay E=Exempt/Exonerated N=None
84	TAX_CD_SUT	Character(8)	VARCHAR2(8) NOT NULL	Tax Code - Sales and Use Tax
85	TAX_CD_SUT_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Sales/Use Tax Code Percent
86	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid Default Value: V
87	KK_AMOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Amount Type 0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic
88	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes
89	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Commitment Control source transaction override operator
90	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Commitment Control source transaction override datetime
91	CHRTFLD_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Chartfield Status R=Recycled V=Valid Default Value: V
92	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Prompt Table: %EDITTABLE2
93	PO_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Purchase Order Line Number Prompt Table: CC_PO_LINE_VW
94	PO_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	PO Schedule Number Prompt Table: CC_PO_SCHED_VW
95	CC_ORIGINAL_PO	Character(1)	VARCHAR2(1) NOT NULL	Original PO Y/N Table Edit Default Value: N
96	MERCHANT_CAT_CODE	Character(10)	VARCHAR2(10) NOT NULL	MCC - Merchant Category Code
97	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
98	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
99	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
100	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
101	MERCHANT_UOM	Character(20)	VARCHAR2(20) NOT NULL	Merchant UOM
102	USER_HDR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
103	CUSTOM_C100_A1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
104	CUSTOM_C100_A2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
105	CUSTOM_C100_A3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
106	CUSTOM_C100_A4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
107	CUSTOM_DATE_A	Date(10)	DATE	Custom Date
108	CUSTOM_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
109	USER_LINE_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
110	CUSTOM_C100_B1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
111	CUSTOM_C100_B2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
112	CUSTOM_C100_B3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
113	CUSTOM_C100_B4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
114	CUSTOM_DATE_B	Date(10)	DATE	Custom Date
115	CUSTOM_C1_B	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
116	USER_SCHED_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
117	CUSTOM_C100_C1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
118	CUSTOM_C100_C2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
119	CUSTOM_C100_C3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
120	CUSTOM_DATE_C1	Date(10)	DATE	Custom Date 1
121	CUSTOM_DATE_C2	Date(10)	DATE	Custom Date 2
122	CUSTOM_C1_C	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
123	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
124	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services Default Value: G
125	VAT_CREDIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Claiming Tax Credit Y/N Table Edit Default Value: N
126	VAT_RECEIPT	Character(1)	VARCHAR2(1) NOT NULL	No VAT Receipt Y/N Table Edit Default Value: N
127	TAX_CREDIT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Date Init Ref# Descr 112007 LAKM 1717216001 Changed the filed type to enter credit value for Disput tax amount field
128	VAT_TOL_ERROR	Character(1)	VARCHAR2(1) NOT NULL	VAT Tolerance Error
129	REDISTRIB_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Redistribute Y/N Table Edit Default Value: N
130	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order Prompt Table: SP_BU_WM_NONVW
131	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification Prompt Table: %EDIT_WO_ID
132	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number Prompt Table: %EDIT_WO_TASK
133	RSRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Management Resource Types 1=Labor 2=Tools 3=Material
134	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No. Prompt Table: %EDIT_RES_LINE
135	CC_SECURITY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Procurement Card Number
136	PREPAID_REF	Character(10)	VARCHAR2(10) NOT NULL	Prepayment Reference
137	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
138	CC_TO_ET_GRP	Character(10)	VARCHAR2(10) NOT NULL	Merchant Category Group
139	CC_TO_ET_CD_DESCR	Character(36)	VARCHAR2(36) NOT NULL	Description
140	DESCR_LN1	Character(50)	VARCHAR2(50) NOT NULL	Description Line 1
141	DESCR_LN2	Character(50)	VARCHAR2(50) NOT NULL	Description Line 2
142	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
143	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
144	CURRENCY_CD3	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
145	EXPIRATION_DT	Date(10)	DATE	Expiration Date
146	FROM_DATE	Date(10)	DATE	From Date
147	THRU_DATE	Date(10)	DATE	Through Date
148	LIMIT_PO_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Limit Per PO
149	LIMIT_CYCLE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Limit Per Pay Cycle
150	NBR_PO_PER_CYCLE	Number(5,0)	INTEGER NOT NULL	Nbr of Transactions Per Cycle
151	NBR_PO_PER_DAY	Number(5,0)	INTEGER NOT NULL	Nbr of Transactions Per Day
152	CRDMEM_ACCT_MSK	Character(20)	VARCHAR2(20) NOT NULL	Cardmember Number
153	CR_CARD_DIGITS	Character(4)	VARCHAR2(4) NOT NULL	Card Number's Last Four Digits
154	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user
155	CC_CARD_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Credit Card Type (e.g Corporate Card, debit Card, Procurement Card, etc.) AMEX=American Express CORP=Corporate Card DEBT=Debit Card MC=MasterCard PHON=Phone Card PRCR=Procurement Card VISA=Visa
156	CC_CARD_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Card's charging function CORP=Corporate Card DEBT=Debit Card PHON=Phone Card PRCR=Procurement Card
157	SHORTNAME	Character(15)	VARCHAR2(15) NOT NULL	Field Short Name
158	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BUPRCR_NONVW
159	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
160	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
161	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
162	ACCOUNT_2	Character(10)	VARCHAR2(10) NOT NULL	Account
163	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
164	ALTACCT_2	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
165	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
166	BILL_TO	Character(1)	VARCHAR2(1) NOT NULL	Bill To C=Company E=Employee
167	CC_VENDOR_CARD	Character(1)	VARCHAR2(1) NOT NULL	Vendor Card Y/N Table Edit Default Value: N
168	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
169	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
170	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
171	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
172	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
173	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
174	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
175	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
176	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
177	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
178	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
179	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
180	DT_ISSUED_TO_EMPL	Date(10)	DATE	Date Issued to Employee
181	LIMIT_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Credit Card Limit Amount
182	LIMIT_AMOUNT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Credit Card Limit Amount
183	LIMIT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Limit per Transaction
184	LIMIT_TRANS_AMT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Limit per Transaction
185	COUNT_LINES	Number(15,0)	DECIMAL(15) NOT NULL	Count of Lines
186	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
187	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
188	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
189	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
190	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
191	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
192	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
193	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
194	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
195	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.