{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Asset Transfer Data Entry","AcquisYear","Transfer Variants","INSTRUCTIONS","List of Transfer Variants"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Asset Transfer Data Entry","index":0,"n_rows":7,"n_cols":27,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,2],[1,6,1,10],[1,11,1,13],[1,4,2,4],[1,3,2,3],[1,5,2,5],[1,25,1,26],[1,17,2,17],[1,20,2,20],[1,21,2,24],[1,14,2,14],[1,15,1,16],[1,18,1,19]]}
["Asset Mass Transfer\nUse with transaction ZAA_MASS_TFR",null,null,"        ** This template can be obtained on the Umoja Job Aids website under the Fixed Assets Management section"]
["Asset to be Transferred",null,null,"(1) If transferring Main Asset - Leave this blank for automatic new Asset Number generation\n(2) If transferring Sub-Asset, populate with receiving Main Asset Number","If reclassifying the asset, enter the new asset class here. Otherwise leave it blank.","(1) If transferring Main Asset - Leave this blank\n(2) If transffering to new receiving Sub-Asset, select/populate \"X\" - Selecting it creates a new Sub-Asset for the receiving Asset","Destination Coding Block",null,null,null,null,"Dates",null,null,"(Optional) Enter transfer description text here. This will be included on the posting for information.\n\nNote: For STO, this field is populated with STO Number and corresponding STO Line.","(Optional) These fields can usually be left blank.",null,"Select or enter Asset Transfer Type - Do not leave blank.\nIntra-Volume:\nZ1 Budget-Relevant Transfer - NSP Rev. Intra-Volume\nZ2 Non-Budget Relevant Intra-Volume Transfer (at NBV)\nZ3 Budget-Relevant Transfer - SP Rev. Intra-Volume\nCross-Volume:\nZ5 Budget-Relevant Transfer - NSP Rev. Cross-Volume\nZ6 Non-Budget Relevant Cross-Volume Transfer (at NBV)\nZ7 Budget-Relevant Transfer - SP Rev. Cross-Volume\n","Earmarked Funds Reference - Document Number and Document Item",null,"(Optional) Enter short transfer reference text here. This will be included on the posting.","You may leave all of these blank. These would only be used in the case of a partial transfer.",null,null,null,"Choose one option by marking the letter X in the cell. If no option is selected, it will default to Prior Year Acquisition"]
["List Asset Numbers to be transferred here","If transferring sub-assets, list the corresponding sub-asset numbers here. Otherwise, enter 0","Always = 1000",null,null,null,"Time-Dependent Data",null,null,null,null,"Date this is entered into the system. Ref. Document Date or today's date.","The date of the posting. Must be in an open posting period.","The asset will be transferred with its value as of this date.",null,"Leave blank, it will derive based on the Posting Date","Leave blank, it will default to the correct doc type",null,"Earmarked Funds Document Number:\n\nMandatory for Budget-Relevant STO Transfers.\nRequired if Funds Commitment raised for Asset Transfer.","Earmarked Funds Document Item:\n\nMandatory for Budget-Relevant STO Transfers.\nRequired if Funds Commitment raised for Asset Transfer.",null,null,null,null,null,"The asset was acquired prior to 1-January of this year.","The asset was acquired on or since 1-January of this year."]
["Reference Asset","Reference Sub-Asset Number","Reference Company Code","Asset Number","Asset Class","Subnumber checkbox","Cost Center","Fund","Grant","Internal Order","WBS Element (Costs)","Document Date","Posting Date","Asset Value Date","Text","Posting Period","Document Type","Transfer variant","Earmarked Funds Document Number","Earmarked Funds Document Item","Reference","Allocation","Amount posted","Percentage rate","Quantity","Prior Year Acquisition","Current Year Acquisition"]
[4400000011,0,1000,null,null,null,12831,"10UNA","GMNR",null,null,"2016-06-16","2016-06-16","2016-06-01","Transfer GMNR",null,null,"Z6",1000007031,2,"Tfr GMNR",null,null,null,null,"X"]
[4200000404,0,1000,null,440,null,10517,"32SAU","S1-32SAU-000176",11000541,null,"2016-06-15","2016-06-15","2016-06-01","Transfer to another Class, IO",null,null,"Z2",1000007031,1,"Tfr Class+IO",null,null,null,null,null,"X"]
[4200000403,0,1000,null,null,null,10122,"32HKA","M1-32HKA-000001",null,"SB-000013","2016-07-15","2016-07-15","2016-07-01","Transfer to WBSE",null,null,"Z1",null,null,"Tfr WBSE",null,null,null,null,"X"]

{"sheet":"AcquisYear","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["X"]

{"sheet":"Transfer Variants","index":2,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Z1"]
["Z2"]
["Z3"]
["Z5"]
["Z6"]
["Z7"]

{"sheet":"INSTRUCTIONS","index":3,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[19,5,20,5],[26,1,27,1],[1,1,3,1],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,11,1],[12,1,14,1],[15,1,15,2],[16,1,17,1],[18,1,18,2],[21,1,21,2],[22,1,25,2],[19,1,20,1]]}
["Column","Main Title","Sub-Title","Field","Mandatory","Explanation"]
["A","Asset to be Transferred","List Asset Numbers to be transferred here","Reference Asset","Y","This is the Asset (origin) we are transferring to another Asset (target, receiving). Must be populated for all transfers."]
["B",null,"If transferring sub-assets, list the corresponding sub-asset numbers here. Otherwise, enter 0","Reference Sub-Asset Number","Y","This is the Sub-Asset (origin) we are transferring, e.g., 0001, 0002, etc. If transferring only Main Asset, then enter 0, if transferring the Sub-Asset, then enter its Sub-Asset Number: 1 or 2, or 20, etc."]
["C",null,"Always = 1000","Reference Company Code","Y","Company Code is always 1000"]
["D","(1) If transferring Main Asset - Leave this blank for automatic new Asset Number generation\n(2) If transferring Sub-Asset, populate with receiving Main Asset Number",null,"Asset Number","When origin is Sub-Asset","(1) If transferring Main Asset to another Main Asset - then this field is left blank and new Asset Number will be automatically generated.\n(2) If transferring Sub-Asset, then receiving Main Asset must already exist, so that new Sub-Asset can be associated with it, and have the same Main Asset Number. Sub-Asset Number will be created automatically (you must mark \"Subnumber Checkbox\"."]
["E","If reclassifying the asset, enter the new asset class here. Otherwise leave it blank.",null,"Asset Class","When reclassifying the Asset","This field is used only when moving Asset from one Asset Class to another Asset Class - when it must be populated with correct receiving Asset Class."]
["F","(1) If transferring Main Asset - Leave this blank\n(2) If transffering to new receiving Sub-Asset, select/populate \"X\" - Selecting it creates a new Sub-Asset for the receiving Asset",null,"Subnumber checkbox","When transferring to receiving Sub-Asset","(1) If transferring Main Asset to another Main Asset - then this field is left blank and new Main Asset Number will be automatically generated. No Sub-Assets will be generated.\n(2) If transferring Sub-Asset to Sub-Asset, then this field must contain \"X\" (either populate or select from drop-down list)."]
["G","Destination Coding Block","Time-Dependent Data","Cost Center","Y","Cost Centre for receiving Asset is always required."]
["H",null,null,"Fund","Y","Fund for receiving Asset is always required."]
["I",null,null,"Grant","Y","Grant for receiving Asset is always required (Actual Grant or \"GMNR\")."]
["J",null,null,"Internal Order","When receiving Cost Element is Internal Order","When Cost Element for receiving Asset is Internal Order, this field must be populated. In all other cases leave blank.\nNote: Only one of Internal Order or WBS Element can be populated at the time - another must be blank."]
["K",null,null,"WBS Element (Costs)","When receiving Cost Element WBS Element","When Cost Element for receiving Asset is WBS Element, this field must be populated. In all other cases leave blank.\nNote: Only one of Internal Order or WBS Element can be populated at the time - another must be blank."]
["L","Dates","Date this is entered into the system. Usually today's date.","Document Date","Y","Date of the Document that authorises the transfer or today's date."]
["M",null,"The date of the posting. Must be in an open posting period.","Posting Date","Y","Posting date - which must be in an open posting period."]
["N",null,"The asset will be transferred with its value as of this date.","Asset Value Date","Y","Effective date for the transfer. Can be any date in currently open Calendar Year (i.e., current Asset Accounting Year)."]
["O","(Optional) Enter transfer description text here. This will be included on the posting for information.",null,"Text","N","Please enter Transfer Description - this will be included in the Transaction Description in posted Document.\n\nNote: For STO, this field is populated with STO Number and corresponding STO Line. If STO Fixed Asset Report is used to generate transfer data, it will be automatically populated."]
["P","(Optional) These fields can usually be left blank.","Leave blank, it will derive based on the Posting Date","Posting Period","N","If not entered, the value will be determined based on the Posting Date"]
["Q",null,"Leave blank, it will default to the correct doc type","Document Type","N","If left blank, it will default to correct document type (currently AA)."]
["R","Select or enter Asset Transfer Type - Do not leave blank.\nIntra-Volume:\nZ1 Budget-Relevant Transfer - NSP Rev. Intra-Volume\nZ2 Non-Budget Relevant Intra-Volume Transfer (at NBV)\nZ3 Budget-Relevant Transfer - SP Rev. Intra-Volume\nCross-Volume:\nZ5 Budget-Relevant Transfer - NSP Rev. Cross-Volume\nZ6 Non-Budget Relevant Cross-Volume Transfer (at NBV)\nZ7 Budget-Relevant Transfer - SP Rev. Cross-Volume",null,"Transfer variant","Y","It is important to select correct Transfer Variant, as it will determine correct postings and values to be posted - as per requirements of specific transfer.\n\nFor reference, use the list of available Transfer Variants, in the Header for this field, and also in \"List of Transfer Variants\" reference worksheet.\n\nKeep in mind that Intra- and Cross- Volument differentiation depends if transfer is crossing and of Budget/FI Dimesions.\n"]
["S","Earmarked Funds Reference - Document Number and Document Item","Earmarked Funds Document Number:\n\nMandatory for Budget-Relevant STO Transfers.\nRequired if Funds Commitment raised for Asset Transfer.","Earmarked Funds Document Number","* For Budget Relevant STO (ZSDS and ZBUD)\n\n* When FundsCommitment is raised for this transfer","Earmarked Funds Document reference (Document Number and Document Item) are generally used only in STO Process, when it is necessary and required to do reservation of funds for a longer period. This is NOT relevant for Non-Budget Relevant Transfers.\n\nIn cases when Funds Commitment (Earmarked Funds) Documents are created and approved, but unrelated to STO process (e.g., when entity expects transfer of assets may take relatively long time) these fields need to be used.\n\n** Specifying Earmarked Funds Document and Document Item in these fields, will result in automatic system-effected consumption of committed funds."]
["T",null,"Earmarked Funds Document Item:\n\nMandatory for Budget-Relevant STO Transfers.\nRequired if Funds Commitment raised for Asset Transfer.","Earmarked Funds Document Item","* For Budget Relevant STO (ZSDS and ZBUD)\n\n* When FundsCommitment is raised for this transfer"]
["U","(Optional) Enter short transfer reference text here. This will be included on the posting.",null,"Reference","N","Please enter short Transfer Refered - this will be included in the Transaction Reference in posted Document.\n\nNote: For STO, this field is populated with Outbound Delivery Number. If STO Fixed Asset Report is used to generate transfer data, it will be automatically populated."]
["V","You may leave all of these blank. These would only be used in the case of a partial transfer.",null,"Allocation","N","Not used at this time."]
["W",null,null,"Amount posted","N","Not used at this time."]
["X",null,null,"Percentage rate","N","Not used at this time."]
["Y",null,null,"Quantity","N","Not used at this time."]
["Z","Choose one option by marking the letter X in the cell. If no option is selected, it will default to Prior Year Acquisition","The asset was acquired prior to 1-January of this year.","Prior Year Acquisition","N","Please enter \"X\" or select it from drop-down - if the Asset being transffered has been acquired in Prior calendar year.\nNote: You should only populate one of these fields, Prior or Current. If you leave both blank, it will default to Prior Year Acquisition."]
["AA",null,"The asset was acquired on or since 1-January of this year.","Current Year Acquisition","N","Please enter \"X\" or select it from drop-down - if the Asset being transffered has been acquired in Current calendar year.\nNote: You should only populate one of these fields, Prior or Current. If you leave both blank, it will default to Prior Year Acquisition."]

{"sheet":"List of Transfer Variants","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[8,0,13,0],[8,1,13,1],[8,2,9,2],[8,3,9,3],[10,2,11,2],[10,3,11,3],[12,2,13,2],[12,3,13,3],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[2,0,7,0],[2,1,7,1],[2,2,3,2],[2,3,3,3],[4,2,5,2],[4,3,5,3],[6,2,7,2],[6,3,7,3]]}
["T-Code","T-Code","Transfer Variant (TV)","Transfer Variant Name / Description"]
[]
["Intra-volume","ZAA_MASS_TRF \n(calls ABUMN)","Z1","Budget-Relevant Transfer - NSP Rev. Intra-Volume"]
[]
[null,null,"Z2","Non-Budget Relevant Intra-Volume Transfer (at NBV)"]
[]
[null,null,"Z3","Budget-Relevant Transfer - SP Rev. Intra-Volume"]
[]
["Cross Volume","ZAA_MASS_TRF\n (calls ABT1N)","Z5","Budget-Relevant Transfer - NSP Rev. Cross-Volume"]
[]
[null,null,"Z6","Non-Budget Relevant Cross-Volume Transfer (at NBV)"]
[]
[null,null,"Z7","Budget-Relevant Transfer - SP Rev. Cross-Volume"]