When creating an integration import script, you must populate the FDM worktable with the values retrieved from the data source.
| Worktable Field Name | Worktable Field Information | Note |
|---|---|---|
| PartitionKey | [ Type=Long, Size=0, Required=Yes] | WL location name (Use the strLoc parameter.) |
| CatKey | [ Type=Long, Size=0, Required=Yes] | WL category key (Use the lngCatKey parameter.) |
| PeriodKey | [ Type=TimeStamp, Size=0, Required=Yes] | WL period key (Use the dblPerKey parameter.) |
| DataView | [ Type=VarWChar, Size=5, Required=Yes] | Load frequency; defaults to YTD |
| Amount | [ Type=Double, Size=0, Required=Yes] | Source amount |
| Desc1 | [ Type=VarWChar, Size=75, Required=No] | Source account description |
| Account | [ Type=VarWChar, Size=75, Required=Yes] | Source account |
| Entity | [ Type=VarWChar, Size=75, Required=Yes] | Source entity |
| ICP | [ Type=VarWChar, Size=75, Required= No] | Source ICP |
| UD1 through UD20 | [Type=VarWChar, Size=75, Required= No] | Source dimension—UserDefined1 through UserDefined20 |
| Attr1 through Attr14 | Type=VarWChar, Size=20, Required=No] | Source attribute dimension—1 through 14 |
| ArchiveID | [ Type=Bigint, Size=8, Required=No] | Archive ID number from the data directory, if an archive is to be associated |