Skip to main content
Skip table of contents

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

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.