Data Mapping
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 |
|