Transactions Interface Table Structure
This table lists the details of the Project Transaction Interface table structure:
| Field Number | Field Name | Type | Criteria | Description |
|---|---|---|---|---|
|
1 |
INTFC_ID |
Number |
Required |
Batch interface identifier. |
|
2 |
INTFC_LINE_NUM |
Number |
Required |
Unique batch line identifier. |
|
3 |
PC_RES_INTF_SBR |
Subrecord |
||
|
1 (PC_RES_INTF_SBR) |
BUSINESS_UNIT |
Character |
Required |
Prompts from the SP_BU_PC_NONVW table. |
|
2 (PC_RES_INTF_SBR) |
PROJECT_ID |
Character |
Required |
Prompts from the SP_PROJ_NONVW table. |
|
3 (PC_RES_INTF_SBR) |
ACTIVITY_ID |
Character |
Required |
Prompts from the PROJ_ACT_VW table. |
|
4 (PC_RES_INTF_SBR) |
RESOURCE_ID |
Character |
Optional |
Resource ID. |
|
5 (PC_RES_INTF_SBR) |
RESOURCE_ID_FROM |
Character |
Optional |
Resource ID from. |
|
6 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_GL |
Character |
Required |
Prompts from the SP_BUPCIT_NONVW table. |
|
7 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_PC |
Character |
Optional |
Project business unit. |
|
8 (PC_RES_INTF_SBR) |
JOURNAL_ID |
Character |
Optional |
Journal ID. |
|
9 (PC_RES_INTF_SBR) |
JOURNAL_DATE |
Date |
Optional |
Journal date. |
|
10 (PC_RES_INTF_SBR) |
UNPOST_SEQ |
Number |
Optional |
Unpost sequence. |
|
11 (PC_RES_INTF_SBR) |
JOURNAL_LINE |
Number |
Optional |
General ledger journal line number. |
|
12 (PC_RES_INTF_SBR) |
FISCAL_YEAR |
Number |
Optional |
Fiscal year. |
|
13 (PC_RES_INTF_SBR) |
ACCOUNTING_PERIOD |
Number |
Optional |
Accounting period. |
|
14 (PC_RES_INTF_SBR) |
ACCOUNT |
Character |
Optional |
Prompts from the GL_ACCT_BUGL_VW table. |
|
15 (PC_RES_INTF_SBR) |
ALTACCT |
Character |
Optional |
Prompts from the ALT_BUGL_VW table. |
|
16 (PC_RES_INTF_SBR) |
DEPTID |
Character |
Optional |
Prompts from the DEPTID_BUGL_VW table. |
|
17 (PC_RES_INTF_SBR) |
CF16_AN_SBR |
Character |
Optional |
ChartField subrecord. |
|
1 (CF16_AN_SBR) |
OPERATING_UNIT |
Character |
Optional |
Prompts from the OPERUNT_BUGL_VW table. |
|
2 (CF16_AN_SBR) |
PRODUCT |
Character |
Optional |
Prompts from the PRODUCT_BUGL_VW table. |
|
3 (CF16_AN_SBR) |
FUND_CODE |
Character |
Optional |
Prompts from the FUND_BUGL_VW table. |
|
4 (CF16_AN_SBR) |
CLASS_FLD |
Character |
Optional |
Prompts from the CLASSCF_BUGL_VW table. |
|
5 (CF16_AN_SBR) |
PROGRAM_CODE |
Character |
Optional |
Prompts from the PROGRAM_BUGL_VW table. |
|
6 (CF16_AN_SBR) |
BUDGET_REF |
Character |
Optional |
Prompts from the BUD_REF_BUGL_VW table. |
|
7 (CF16_AN_SBR) |
AFFILIATE |
Character |
Optional |
Prompts from the AFFILIATE_VW table. |
|
8 (CF16_AN_SBR) |
AFFILIATE_INTRA1 |
Character |
Optional |
Intraunit affiliate 1. |
|
9 (CF16_AN_SBR) |
AFFILIATE_INTRA2 |
Character |
Optional |
Intraunit affiliate 2. |
|
10 (CF16_AN_SBR) |
CHARTFIELD1 |
Character |
Optional |
Prompts from the CF1_BUGL_VW table. |
|
11 (CF16_AN_SBR) |
CHARTFIELD2 |
Character |
Optional |
Prompts from the CF2_BUGL_VW table. |
|
12 (CF16_AN_SBR) |
CHARTFIELD3 |
Character |
Optional |
Prompts from the CF3_BUGL_VW table. |
|
18 (PC_RES_INTF_SBR) |
BUS_UNIT_GL_FROM |
Character |
Optional |
Prompts from the Integration Template General Ledger table (PC_INT_TMPL_GL). |
|
19 (PC_RES_INTF_SBR) |
CURRENCY_CD |
Character |
Optional |
Prompts from the Currency Codes table (CURRENCY_CD_TBL). |
|
20 (PC_RES_INTF_SBR) |
STATISTICS_CODE |
Character |
Optional |
Prompts from the STAT_BUGL_VW table. |
|
21 (PC_RES_INTF_SBR) |
LEDGER_GROUP |
Character |
Optional |
Prompts from the SP_LEDGPC_NONVW table. |
|
22 (PC_RES_INTF_SBR) |
ANALYSIS_TYPE |
Character |
Required |
Analysis type. |
|
23 (PC_RES_INTF_SBR) |
RESOURCE_TYPE |
Character |
Optional |
Prompts from the Project Resource Type table (PROJ_RES_TYPE). |
|
24 (PC_RES_INTF_SBR) |
RESOURCE_CATEGORY |
Character |
Optional |
Category. |
|
25 (PC_RES_INTF_SBR) |
RESOURCE_SUB_CAT |
Character |
Optional |
Subcategory. |
|
26 (PC_RES_INTF_SBR) |
RES_USER1 |
Character |
Optional |
Transaction user 1. |
|
27 (PC_RES_INTF_SBR) |
RES_USER2 |
Character |
Optional |
Transaction user 2. |
|
28 (PC_RES_INTF_SBR) |
RES_USER3 |
Character |
Optional |
Transaction user 3. |
|
29 (PC_RES_INTF_SBR) |
RES_USER4 |
Character |
Optional |
Transaction user 4. |
|
30 (PC_RES_INTF_SBR) |
RES_USER5 |
Character |
Optional |
Transaction user 5. |
|
31 (PC_RES_INTF_SBR) |
TRANS_DT |
Date |
Optional |
Transaction date. |
|
32 (PC_RES_INTF_SBR) |
ACCOUNTING_DT |
Date |
Optional |
Accounting date. |
|
33 (PC_RES_INTF_SBR) |
JRNL_LN_REF |
Character |
Optional |
Journal line reference. |
|
34 (PC_RES_INTF_SBR) |
OPEN_ITEM_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
35 (PC_RES_INTF_SBR) |
LINE_DESCR |
Character |
Optional |
Journal line description. |
|
36 (PC_RES_INTF_SBR) |
JRNL_LINE_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
37 (PC_RES_INTF_SBR) |
JOURNAL_LINE_DATE |
Date |
Optional |
Journal line date. |
|
38 (PC_RES_INTF_SBR) |
FOREIGN_CURRENCY |
Character |
Optional |
Prompts from the FRGN_CURR_VW table. |
|
39 (PC_RES_INTF_SBR) |
RT_TYPE |
Character |
Optional |
Prompts from the Market Rate Data Types table (RT_TYPE_TBL). |
|
40 (PC_RES_INTF_SBR) |
FOREIGN_AMOUNT |
Sign |
Optional |
Foreign amount. |
|
41 (PC_RES_INTF_SBR) |
RATE_MULT |
Sign |
Optional |
Rate multiplier. |
|
42 (PC_RES_INTF_SBR) |
RATE_DIV |
Number |
Optional |
Rate divisor. |
|
43 (PC_RES_INTF_SBR) |
CUR_EFFDT |
Date |
Optional |
Currency effective date. |
|
44 (PC_RES_INTF_SBR) |
PROCESS_INSTANCE |
Number |
Optional |
Process instance. |
|
45 (PC_RES_INTF_SBR) |
PC_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
46 (PC_RES_INTF_SBR) |
GL_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
47 (PC_RES_INTF_SBR) |
PROJ_TRANS_TYPE |
Character |
Optional |
Prompts from the Project Transaction Types table (PROJ_TRANS_TYPE). |
|
48 (PC_RES_INTF_SBR) |
PROJ_TRANS_CODE |
Character |
Optional |
Prompts from the Project Transaction Codes table (PROJ_TRANS_CODE). |
|
49 (PC_RES_INTF_SBR) |
RESOURCE_STATUS |
Character |
Optional |
Transaction status. |
|
50 (PC_RES_INTF_SBR) |
DESCR |
Character |
Optional |
Description. |
|
51 (PC_RES_INTF_SBR) |
SYSTEM_SOURCE |
Character |
Optional |
Prompts from the field's translate values. |
|
52 (PC_RES_INTF_SBR) |
UNIT_OF_MEASURE |
Character |
Optional |
Prompts from the Units of Measure table (UNITS_TBL). |
|
53 (PC_RES_INTF_SBR) |
EMPLID |
Character |
Optional |
Prompts from the PROJ_TEAM_VW table. |
|
54 (PC_RES_INTF_SBR) |
EMPL_RCD |
Number |
Optional |
Employee record number. |
|
55 (PC_RES_INTF_SBR) |
SEQ_NBR |
Number |
Optional |
Sequence number. |
|
56 (PC_RES_INTF_SBR) |
TIME_RPTG_CD |
Character |
Optional |
Time reporting code. |
|
57 (PC_RES_INTF_SBR) |
JOBCODE |
Character |
Optional |
Job code. |
|
58 (PC_RES_INTF_SBR) |
COMPANY |
Character |
Optional |
Company. |
|
59 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_AP |
Character |
Optional |
Prompts from the SP_BU_AP_NONVW table. |
|
60 (PC_RES_INTF_SBR) |
VENDOR_ID |
Character |
Optional |
Prompts from the PROJ_VENDOR_VW table. |
|
61 (PC_RES_INTF_SBR) |
VOUCHER_ID |
Character |
Optional |
Voucher ID. |
|
62 (PC_RES_INTF_SBR) |
VOUCHER_LINE_NUM |
Number |
Optional |
Voucher line number. |
|
63 (PC_RES_INTF_SBR) |
APPL_JRNL_ID |
Character |
Optional |
Prompts from the Journal Generator template table (JRNLGEN_APPL_ID). |
|
64 (PC_RES_INTF_SBR) |
PYMNT_CNT |
Number |
Optional |
Payments. |
|
65 (PC_RES_INTF_SBR) |
DST_ACCT_TYPE |
Character |
Optional |
Prompts from the field's translate values. |
|
66 (PC_RES_INTF_SBR) |
PO_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
67 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_PO |
Character |
Optional |
Prompts from the SP_BU_PM_NONVW table. |
|
68 (PC_RES_INTF_SBR) |
REQ_ID |
Character |
Optional |
Requisition ID. |
|
69 (PC_RES_INTF_SBR) |
REQ_LINE_NBR |
Number |
Optional |
Requisition line number. |
|
70 (PC_RES_INTF_SBR) |
REQ_SCHED_NBR |
Number |
Optional |
Requisition schedule number. |
|
71 (PC_RES_INTF_SBR) |
REQ_DISTRIB_NBR |
Number |
Optional |
Requisition distribution number. |
|
72 (PC_RES_INTF_SBR) |
PO_ID |
Character |
Optional |
Purchase order number. |
|
73 (PC_RES_INTF_SBR) |
DUE_DATE |
Date |
Optional |
Delivery due date from. |
|
74 (PC_RES_INTF_SBR) |
LINE_NBR |
Number |
Optional |
Line number. |
|
75 (PC_RES_INTF_SBR) |
SCHED_NBR |
Number |
Optional |
Schedule number. |
|
76 (PC_RES_INTF_SBR) |
DISTRIB_LINE_NUM |
Number |
Optional |
Distribution line. |
|
77 (PC_RES_INTF_SBR) |
AM_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
78 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_AM |
Character |
Optional |
Prompts from the SP_BU_AM_NONVW table. |
|
79 (PC_RES_INTF_SBR) |
ASSET_ID |
Character |
Optional |
Prompts from the PROJ_ASSET_VW table. |
|
80 (PC_RES_INTF_SBR) |
PROFILE_ID |
Character |
Optional |
Prompts from the PROFILE_PCAM_VW table. |
|
81 (PC_RES_INTF_SBR) |
COST_TYPE |
Character |
Optional |
Prompts from the Asset Cost Type Definition table (COST_TYPE_TBL). |
|
82 (PC_RES_INTF_SBR) |
BOOK |
Character |
Optional |
Asset book name. |
|
83 (PC_RES_INTF_SBR) |
INCENTIVE_ID |
Character |
Optional |
Prompts from the PC_PROJ_GNT_VW table. |
|
84 (PC_RES_INTF_SBR) |
MSTONE_SEQ |
Number |
Optional |
Milestone sequence. |
|
85 (PC_RES_INTF_SBR) |
CONTRACT_NUM |
Character |
Optional |
Prompts from the CA_CONTRACT_VW table. |
|
86 (PC_RES_INTF_SBR) |
CONTRACT_LINE_NUM |
Number |
Optional |
Contract line number. |
|
87 (PC_RES_INTF_SBR) |
CONTRACT_PPD_SEQ |
Number |
Optional |
Prepaid add sequence. |
|
88 (PC_RES_INTF_SBR) |
BI_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
89 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_BI |
Character |
Optional |
Prompts from the SP_BU_BI_NONVW table. |
|
90 (PC_RES_INTF_SBR) |
BILLING_DATE |
Date |
Optional |
Billing date. |
|
91 (PC_RES_INTF_SBR) |
INVOICE |
Character |
Optional |
Invoice. |
|
92 (PC_RES_INTF_SBR) |
REV_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
93 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_AR |
Character |
Optional |
Prompts from the SP_BUARED_NONVW table. |
|
94 (PC_RES_INTF_SBR) |
CUST_ID |
Character |
Optional |
Prompts from the PROJ_CUST_VW table. |
|
95 (PC_RES_INTF_SBR) |
ITEM |
Character |
Optional |
Prompts from the ITEM_OPEN_PC_VW table. |
|
96 (PC_RES_INTF_SBR) |
ITEM_LINE |
Number |
Optional |
Item line. |
|
97 (PC_RES_INTF_SBR) |
ITEM_SEQ_NUM |
Number |
Optional |
Item sequence number. |
|
98 (PC_RES_INTF_SBR) |
DST_SEQ_NUM |
Number |
Optional |
Distribution sequence. |
|
99 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_IN |
Character |
Optional |
Prompts from the SP_BUIN_NONVW table. |
|
100 (PC_RES_INTF_SBR) |
SCHED_LINE_NO |
Number |
Optional |
Schedule line number. |
|
101 (PC_RES_INTF_SBR) |
DEMAND_LINE_NO |
Number |
Optional |
Demand line number. |
|
102 (PC_RES_INTF_SBR) |
INV_ITEM_ID |
Character |
Optional |
Prompts from the PROJ_ITEM_VW table. |
|
103 (PC_RES_INTF_SBR) |
PAY_END_DT |
Date |
Optional |
Pay period end date. |
|
104 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_OM |
Character |
Optional |
Prompts from the SP_BUPCOM_NONVW table. |
|
105 (PC_RES_INTF_SBR) |
ORDER_NO |
Character |
Optional |
Order number. |
|
106 (PC_RES_INTF_SBR) |
ORDER_INT_LINE_NO |
Number |
Optional |
Order line number. |
|
107 (PC_RES_INTF_SBR) |
EX_DOC_ID |
Character |
Optional |
PeopleSoft Expenses document ID. |
|
108 (PC_RES_INTF_SBR) |
EX_DOC_TYPE |
Character |
Optional |
Prompts from the field's translate values. |
|
109 (PC_RES_INTF_SBR) |
RESOURCE_QUANTITY |
Sign |
Optional |
Quantity. |
|
110 (PC_RES_INTF_SBR) |
RESOURCE_AMOUNT |
Sign |
Optional |
Project business unit amount. |
|
111 (PC_RES_INTF_SBR) |
BUDGET_HDR_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
112 (PC_RES_INTF_SBR) |
KK_AMOUNT_TYPE |
Character |
Optional |
Prompts from the field's translate values. |
|
113 (PC_RES_INTF_SBR) |
KK_TRAN_OVER_FLAG |
Character |
Optional |
Override transaction. |
|
114 (PC_RES_INTF_SBR) |
KK_TRAN_OVER_OPRID |
Character |
Optional |
Override user ID. |
|
115 (PC_RES_INTF_SBR) |
KK_TRAN_OVER_DTTM |
DtTm |
Optional |
Override date. |
|
116 (PC_RES_INTF_SBR) |
BUDGET_OVER_ALLOW |
Character |
Optional |
Budget overrun allowed. |
|
117 (PC_RES_INTF_SBR) |
BUDGET_LINE_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
118 (PC_RES_INTF_SBR) |
BUDGET_DT |
Date |
Optional |
Budget date. |
|
119 (PC_RES_INTF_SBR) |
LEDGER |
Character |
Optional |
Prompts from the SP_LEDPC_NONVW table. |
|
120 (PC_RES_INTF_SBR) |
BD_DISTRIB_STATUS |
Character |
Optional |
Prompts from the translate values of the field. |
|
121 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_BD |
Character |
Optional |
Prompts from the SP_BUPCBD_NONVW table. |
|
122 (PC_RES_INTF_SBR) |
FA_STATUS |
Character |
Optional |
F&A status. |
|
123 (PC_RES_INTF_SBR) |
TIME_SHEET_ID |
Character |
Optional |
Time report ID. |
|
124 (PC_RES_INTF_SBR) |
SHEET_ID |
Character |
Optional |
Report ID. |
|
125 (PC_RES_INTF_SBR) |
DT_TIMESTAMP |
DtTm |
Optional |
Date timestamp. |
|
126 (PC_RES_INTF_SBR) |
VCHR_DIST_LINE_NUM |
Number |
Optional |
Distribution line number. |
|
127 (PC_RES_INTF_SBR) |
PM_REVIEWED |
Character |
Optional |
Prompts from the field's translate values. |
|
128 (PC_RES_INTF_SBR) |
PRICED_RATE |
Sign |
Optional |
Priced rate. |
|
129 (PC_RES_INTF_SBR) |
ACTIVITY_ID_DETAIL |
Character |
Optional |
Prompts from the Activity ID Detail Prompt table (PC_ACT_DETAIL). |
|
130 (PC_RES_INTF_SBR) |
CST_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
131 (PC_RES_INTF_SBR) |
TXN_LMT_TRANS_ID |
Character |
Optional |
Transaction limit ID. |
|
132 (PC_RES_INTF_SBR) |
EVENT_NUM |
Number |
Optional |
Event number. |
|
133 (PC_RES_INTF_SBR) |
CA_FEE_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
|
134 (PC_RES_INTF_SBR) |
WM_WO_SBR |
Subrecord |
Optional |
PeopleSoft Maintenance Management work order subrecord. |
|
1 (WM_WO_SBR) |
BUSINESS_UNIT_WO |
Character |
Optional |
Work order business unit. Prompts from the SP_BU_WM_NONVW table. |
|
2 (WM_WO_SBR) |
WO_ID |
Character |
Optional |
Work order ID. Prompts from the WM_WO_NOT_CLSD table. |
|
3 (WM_WO_SBR) |
WO_TASK_ID |
Number |
Optional |
Task number. Prompts from the WM_WO_TSK_NCLSD table. |
|
4 (WM_WO_SBR) |
RSRC_TYPE |
Character |
Optional |
Resource type. Prompts from the translate values of the field. |
|
5 (WM_WO_SBR) |
RES_LN_NBR |
Number |
Optional |
Resource line number. |
|
135 (PC_RES_INTF_SBR) |
FMS_WHO_SBR |
Subrecord |
Optional |
Date, time, and operator subrecord. |
|
1 (FMS_WHO_SBR) |
FMS_DTTM_STAMP |
DtTm |
Optional |
Date/time stamp. |
|
2 (FMS_WHO_SBR) |
FMS_OPRID |
Character |
Optional |
Operator ID. |
|
3 (FMS_WHO_SBR) |
FMS_LASTUPDDTTM |
DtTm |
Optional |
Last update date/time. |
|
4 (FMS_WHO_SBR) |
FMS_LASTUPDOPRID |
Character |
Optional |
Last update user ID. |
|
4 |
INTFC_TYPE |
Character |
Optional |
Not used in the transactions interface. |
|
5 |
PC_INTFC_STATUS |
Character |
Required |
Populate the field with NEW. |
|
6 |
PC_LOAD_STATUS |
Character |
Required |
Populate the field with NEW. |
|
7 |
START_DT |
Date |
|
|
|
8 |
ORIG_INTFC_ID |
Number |
Optional |
Not used in the transactions interface. |
|
9 |
ORIG_LINE_NUM |
Number |
Optional |
Not used in the transactions interface. |
|
10 |
INTEGRATION_TMPL |
Character |
Optional |
Not used in the transactions interface. |
|
11 |
QUANTITY |
Sign |
|
Quantity interface. |
|
12 |
DESCR254 |
Character |
Optional |
Not used in the transactions interface. |
|
13 |
SETID |
Character |
System-maintained |
Not used in the transactions interface. |
|
14 |
MESSAGE_SET_NBR |
Number |
System-maintained |
Edit errors message set. |
|
15 |
MESSAGE_NBR |
Number |
System-maintained |
Edit errors message number. |
|
16 |
COMBO_STATUS |
Character |
Conditional |
Populate the field with V (valid) if ChartField combination edits are performed. |
|
17 |
CURRENCY_CD_GL |
Character |
System-maintained |
Used in Commitment Control budgeting. |
|
18 |
MONETARY_AMOUNT |
Sign |
System-maintained |
Used in Commitment Control budgeting. |
|
19 |
KK_DISTRIB_STATUS |
Character |
Optional |
Populate this field with N (none) if the transaction is to be billed. If the transaction needs to be budget checked, provide a value of B. The default value is N if a value is not provided in the source table. |
|
20 |
KK_SOURCE_TRAN |
Character |
Optional |
Not used in the transactions interface. |
|
21 |
PC_MSP_AE6 |
Character |
Optional |
Not used in the transactions interface. |
|
22 |
PC_MSP_AE2 |
Character |
Optional |
Not used in the transactions interface. |
|
23 |
PC_MSP_AE6 |
Character |
Conditional |
Not used in the transactions interface. |
|
24 |
FIELDNAME |
Character |
System-maintained |
Edit errors field name. |
|
25 |
PC_BUDGET_ID |
Number |
Optional |
Budget plan ID. If the budget ID does not exist in the Project Budget Plan table (PC_BUD_PLAN), the process creates a budget ID, indicating that a new budget is being integrated. |
|
26 |
BUDGET_PERIOD |
Character |
Conditional |
Budget period. This field is required if the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
|
27 |
PC_BUDGET_ITEM |
Character |
Conditional |
Project budget item. Prompts from the PC_BUD_ITM_VW table. This field is required if the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
|
28 |
BUDGET_LN |
Number |
Conditional |
Budget line number. This field is required if the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
|
29 |
PROJ_ROLE |
Character |
Optional |
Project role. Prompts from the PROJ_ROLE_SECVW table. |
|
30 |
KK_BUDG_LN_TYPE |
Character |
Conditional |
Budget line code. If Commitment Control is enabled, populate this field based on the translate values of the KK_BUDG_LN_TYPE field. |
|
31 |
BD_HDR_STATUS |
Character |
Optional |
Budget header status. The default value is N (the posting has not been run against the journal). |
|
32 |
GM_FA_SEQ_FLG |
Character |
Optional |
Fixed and administrative flag that is used by the PeopleSoft Grants system. |
|
33 |
GM_CS_SEQ_FLG |
Character |
Optional |
Cost sharing flag that is used by the PeopleSoft Grants system. |
|
34 |
FUND_SOURCE |
Character |
Optional |
Funding source. Prompts from the Funding Source table (KK_FUND_SOURCE). |
|
35 |
GM_DISTRIB_STATUS |
Character |
Optional |
Distribution status that is used by the PeopleSoft Grants system. |
|
36 |
PC_BUD_TYPE |
Character |
Optional |
If a budget type does not exist in the source file, the default value is cost budget. |
|
37 |
BUDGET_CATEGORY |
Character |
Conditional |
Budget item. Prompts from the Budget Category Control table (GM_BUD_CATEGORY). This field is required if the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
|
38 |
NUM_PERIODS |
Number |
Optional |
Number of time periods. |
|
39 |
ACT_UID |
Character |
Optional |
Task ID. |
|
40 |
RES_UID |
Character |
Optional |
Resource ID. |
|
41 |
PC_HOURS_PER_DAY |
Number |
Optional |
Hours per day. |
|
42 |
PC_FORECAST |
Number |
Optional |
Forecast units to load into Forecasting. |
|
43 |
PC_FORCAST_REMAIN |
Number |
Optional |
Remaining forecast units to load into Forecasting. |
|
44 |
STATUS_STRING |
Character |
Optional |
String text. |
|
45 |
START_DATE |
Date |
Optional |
Start date for Gen Stand. |
|
46 |
END_DATE |
Date |
Optional |
End date. |
|
47 |
LOAD_STATUS |
Character |
Optional |
Load status. |
|
48 |
CALENDAR_ID |
Character |
Conditional |
Calendar ID. This field is required if the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
|
49 |
ENTRY_EVENT |
Character |
Conditional |
Prompts from the EE_BUD_CODES_VW table. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
|
50 |
KK_DEFAULT_EE |
Character |
Conditional |
Default entry event. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
|
51 |
KK_GEN_PARENT |
Character |
Conditional |
Generate parent budget. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
|
52 |
KK_PARENT_ENT_TYPE |
Character |
Conditional |
Parent budget entry type, such as original or adjustment. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
|
53 |
KK_BUDG_TRANS_TYPE |
Character |
Conditional |
Budget entry type, such as original, adjustment, transfer, and so on. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
|
54 |
PC_KK_AE_TYPE |
Character |
Conditional |
Commitment Control type, such as budget creation or budget check. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
|
55 |
EE_PROC_STATUS |
Character |
Optional |
Entry Event line status. |