Skip to main content

Populating 19 Sheets FBDI Template

 

Populating 19 Sheets FBDI Template

Populating 19 Sheets FBDI Template


*Note: Yellow Colour marked data is common across 7 sheets. Populate the same data in each sheet which is marked in yellow colour.

Sheet

Column

Data

HZ_IMP_PARTIES_T

1.      Batch Identifier               

      2.      Party Original System

3.      Party Original System Reference

4.      Party Type

5.      Organisation Name

         1.      300000004034132

          2.      CSV

3.      CSV-1011PTY ORG_1

 

4.      ORGANIZATION

5.      Dummy Customer 10121

 

 

 

HZ_IMP_PARTYSITES_T

1.      Batch Identifier

2.      Party Original System

3.      Party Original System Reference

4.      Party Site Original System

5.      Party Site Original System Reference

6.      Location Original System

7.      Location Original System Reference

8.      Identifying Address

9.      Relationship Source System

1.      300000004034132

2.      CSV

3.      CSV-1011PTY ORG_1

 

4.      CSV

 

5.      CSV-1011-PS-2

6.      CSV

7.      CSV-1011-LOC-2

 

8.      Y

9.      CSV

 

 

HZ_IMP_PARTYSITEUSES_T

1.      Batch Identifier

2.      Party Original System

3.      Party Original System Reference

4.      Party Site Original System

5.      Party Site Original System Reference

6.      Party Site Use Type*

7.      Primary Indicator

8.      Insert Update Indicator

9.      Party Site Use Original System

10.   Original System Party Site Use Reference

1.      300000004034132

2.      CSV

3.      CSV-1011PTY ORG_1

 

4.      CSV

5.      CSV-1011-PS-2

 

6.      BILL_TO

7.      Y

8.      I

9.      CSV

 

10.   CSV-1011-PSU-2

 

 

HZ_IMP_ACCOUNTS_T

1.      Batch Identifier

2.      Customer Account Source System

3.      Customer Account Source System Reference

4.      Party Original System

5.      Party Original System Reference

6.      Account Type

 

 

7.      Account Description

 

1.      300000004034132

2.      CSV

 

3.      CSV-1011-ACCOUNT-2

 

4.      CSV

5.      CSV-1011PTY ORG_1

 

6.      R

 

 

7.      TEST CUSTOMER

HZ_IMP_ACCTSITES_T

1.      Batch Identifier

2.      Customer Account Source System

3.      Customer Account Source System Reference

4.      Account Site Source System

5.      Account Site Source System Reference

6.      Party Site Original System

7.      Party Site Original System Reference

8.      Account Address Set*

 

1.      300000004034132

2.      CSV

 

3.      CSV-1011-ACCOUNT-2

 

4.      CSV

5.      CSV-1011-AS-2

 

6.      CSV

7.      CSV-1011-PS-2

 

8.      VJ_ITALY_BU_SET

 

HZ_IMP_ACCTSITEUSES_T

1.      Batch Identifier*

2.      Account Site Source System

3.      Account Site Source System Reference

4.      Account Site Purpose Source System

5.      Account Site Purpose Source System Reference

6.      Purpose*

7.      Primary Indicator

8.      Account Address Purpose Set*

 

1.      300000004034132

2.      CSV

3.      CSV-1011-AS-2

 

4.      CSV

 

5.      CSV-1011-ASU-2

 

6.      BILL_TO

7.      Y

8.      VJ_ITALY_BU_SET

 

HZ_IMP_LOCATIONS_T

1.      Batch Identifier

2.      Location Original System

3.      Location Original System Reference

4.      Country

5.      Address Line 1

6.      City

7.      Province

1.      300000004034132

2.      CSV

3.      CSV-1011-LOC-2

 

4.      IT

5.      VIA SEGANTI, 71

6.      FORLI

7.      FO

 

 

Comments

Post a Comment

Popular posts from this blog

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more