CM Amendments to Encumbrance
|
No |
CM_ENCUM_ITEM |
CM_AMEND_ITEM |
|---|---|---|
|
1 |
cont_number |
cont_number |
|
2 |
item_number |
item_number |
|
3 |
fiscal_year |
fiscal_year |
|
4 |
enc_description |
cm_comments |
|
5 |
approval_date |
cm_amend_chg.approved_date |
|
6 |
division_cd |
The latest division_cd from cm_encum_item |
|
7 |
post_flag |
"N" |
|
8 |
pr_number |
"" |
|
9 |
request_date |
Today |
|
No |
CM_ENCUM_ACCT |
CM_AMEND_ACCT |
|---|---|---|
|
1 |
cont_number |
cont_number |
|
2 |
item_number |
item_number |
|
3 |
enc_amount |
change_amount |
|
4 |
gl_gr |
gl_gr |
|
5 |
gl_key |
gl_key |
|
6 |
gl_obj |
gl_obj |
|
7 |
jl_gr |
jl_gr |
|
8 |
jl_key |
jl_key |
|
9 |
jl_obj |
jl_obj |
|
10 |
work_order |
work_order |
|
No |
CM_MCONTR |
CM_AMEND_CHG |
|---|---|---|
|
1 |
currend |
new_end_date |
CM to PO Encumbrance Data
|
No |
POP_PV_DTL Fields |
CM Data |
|---|---|---|
|
1 |
pop_pr_prefix |
"PR" |
|
2 |
pop_pr_num |
If the PR Number Field in CMUPCM screen is populated use that number, else create a new PR number using seed "SYNO/PR.SEED" from common code. Customize the seed with SYNO/PR.XXXX where XXXX describes the custom seed generator, and configure the custom code with "CM" within the 5th Associated Codes field. |
|
3 |
pop_po_prefix |
"PO" |
|
4 |
pop_po_num |
cm_mcontr.contnum (Contract Number in the CMUPCM screen) |
|
5 |
pop_pe_id |
cm_mcontr.peid (Contractor ID in CMUPCM screen) |
|
6 |
pop_addr_cd |
This will be calculated. Get the Address hierarchy from short description of common code "POAH/ADDRESS." Get the Address code from pe_addr_dtl for the cm_mcontr.peid. Loop through the pe_addr_dtl.pe_addr_cd to see if it is equal to any 2 letter codes of common code short description. (e.g: If common code short description is "BLPRR1R2," loop through pe_addr_dtl.pe_addr_cd to see if it is equal to "BL" or "PR" or "R1" or "R2"). If there is one use that, else use the pe_addr_cd. If pe_addr_cd is not defined, use "". |
|
7 |
pop_rqr_dt |
cm_mcontr.origbegin |
|
8 |
pop_entry_dt |
Today |
|
9 |
pop_en_flag |
"Y" |
|
10 |
pop_contract |
cm_mcontr.contnum |
|
11 |
pop_ship_id |
If cd_assoc_code01 is populated for "CMPO/DEFAULT" common code setting, use that value, else default it to "". |
|
12 |
pop_bill_id |
If cd_assoc_code02 is populated for "CMPO/DEFAULT" common code setting, use that value, else default it to "". |
|
13 |
pop_rqs_by |
BusinessPLUS user ID |
|
14 |
pop_sec_cd |
cm_mcontr.contmgr (From CMUPCM screen) |
|
15 |
pop_status |
"PR" |
|
16 |
pop_pedb_code |
"P" |
|
17 |
pop_bill_addr_cd |
Same method as #6 (In this case it looks pe_addr_dtl address code for pop_bill_id.) |
|
18 |
pop_ship_addr_cd |
Same method as #6 (In this case it looks pe_addr_dtl address code for pop_ship_id.) |
|
19 |
pop_en_div |
"GEN" |
|
20 |
pop_type |
"C" |
|
21 |
pop_rqs_dt |
Today |
|
22 |
pop_exp_dt |
Current End date (cm_mcontr.currend) of CMUPCM, which is updated by the latest new_end_date of cm_amend_chg during Amendment Processing. |
POI_ITEM_DTL Table
|
No |
POI_ITEM_DTL Fields |
CM Data |
|---|---|---|
|
1 |
poi_pr_prefix |
"PR" |
|
2 |
poi_pr_no |
cm_mcontr.prnum (PR Number on CMUPCM) |
|
3 |
poi_po_prefix |
"PO" |
|
4 |
poi_po_no |
cm_mcontr.contnum (Contract Number in the CMUPCM screen) |
|
5 |
poi_gl_gr |
The first record of cm_encum_acct.gl_gr |
|
6 |
poi_gl_key |
The first record of cm_encum_acct.gl_key |
|
7 |
poi_gl_obj |
The first record of cm_encum_acct.gl_obj |
|
8 |
poi_jl_gr |
The first record of cm_encum_acct.jl_gr |
|
9 |
poi_jl_key |
The first record of cm_encum_acct.jl_key |
|
10 |
poi_jl_obj |
The first record of cm_encum_acct.jl_obj |
|
11 |
poi_wo |
The first record of cm_encum_acct.work_order |
|
12 |
poi_pe_id |
" " |
|
13 |
poi_com_cd |
" " |
|
14 |
poi_po_item |
" " |
|
15 |
poi_ref_prefix |
"PR" |
|
16 |
poi_ref_pr_no |
Same as poi_pr_no |
|
17 |
poi_ref_item_no |
cm_encum_item.item_number |
|
18 |
poi_amt |
Sum of (cm_encum_acct.enc_amount) for this cm_encum_item record |
|
19 |
poi_qty |
1 |
|
20 |
poi_term |
0 |
|
21 |
poi_disc |
0 |
|
22 |
poi_tax |
0 |
|
23 |
poi_tax2 |
0 |
|
24 |
poi_charges |
0 |
|
25 |
poi_duty |
0 |
|
26 |
poi_units |
|
|
26 |
poi_en_dt |
Fiscal Year Beginning (FYB) will be calculated. FiscalFlag of glg_gen_mstr will be read for the given gl_gr and if the fiscal_flag is "LS," 1 will be subtracted from the fiscal year of the screen (cm_encum_item.fiscal_year), else the same year will be kept. Using this fiscal year, glg_gen_mstr.fiscal_mo, and 1st will be used to create FYB. If FYB is less than today use today as FYB, else FYB. |
|
27 |
poi_print |
"Y" |
|
28 |
poi_delete |
" " |
|
29 |
poi_change |
"N" |
|
30 |
poi_brand_cd |
|
|
31 |
poi_rqs_by |
|
|
32 |
poi_rqr_dt |
|
|
33 |
poi_job_no |
|
|
34 |
poi_term |
|
|
35 |
poi_desc |
|
|
36 |
poi_tax |
|
|
37 |
poi_tax_cd |
|
|
38 |
poi_pedb_code |
|
|
39 |
poi_pe_id |
|
PON_EN_DTL Table
|
No |
PON_EN_DTL Fields |
CM Data |
|---|---|---|
|
1 |
pon_ref_prefix |
"PR" |
|
2 |
pon_ref_no |
cm_mcontr.prnum (PR Number on CMUPCM same as pop_pv_dtl) |
|
3 |
pon_item |
cm_encum_acct.item_number |
|
4 |
pon_gl_gr |
cm_encum_acct.gl_gr |
|
5 |
pon_gl_key |
cm_encum_acct.gl_key |
|
6 |
pon_gl_obj |
cm_encum_acct.gl_obj |
|
7 |
pon_jl_gr |
cm_encum_acct.jl_gr |
|
8 |
pon_jl_key |
cm_encum_acct.jl_key |
|
9 |
pon_jl_obj |
cm_encum_acct.jl_obj |
|
10 |
pon_wo |
cm_encum_acct.work_order |
|
11 |
pon_amt |
cm_encum_acct.enc_amount |
|
12 |
pon_percent |
|
|
13 |
pon_sort_dt |
|
|
14 |
pon_sort_time |
|
POT_TEXT_DTL
Depending on the settings about PO format, the 70-character cm_encum_item.enc_description will be wrapped into multiple records and saved into pot_text_dtl.
|
No |
POT_TEXT_DTL Fields |
CM Data |
|---|---|---|
|
1 |
pot_ref_prefix |
"PR" |
|
2 |
pot_ref_pr_no |
cm_mcontr.prnum (Same as pop_pv_dtl) |
|
3 |
pot_ref_item_no |
cm_encum_item.item_number |
|
4 |
pot_text |
cm_encum.enc_description |
|
5 |
pot_seq_no |
Sequential number, depending on the number of records. If there are more than one record, starts from 01 to 99. |
|
6 |
pot_type |
"01" |
|
7 |
pot_sort_date |
|
|
8 |
pot_sort_time |
|