XLA_FSN_DRVDSRCS_HDR_GT

This table is used by the accounting engine to store the input values for the derived transaction header SQL statement. It can store input values for 100 custom sources and for 100 segment values pulled from accounts. In the case of a custom source with multiple inputs, the input values are concatenated together in a new line separated string.

Details

• Schema: FUSION

• Object owner: XLA

• Object type: TABLE

Columns

Name

LOOP_COUNTNUMBER18Loop counter. Makes sure that each set of rows are only processed once. CCID1NUMBER18Code combination identifier for first segment value derived source. CCID2NUMBER18Code combination identifier for second segment value derived source. CCID3NUMBER18Code combination identifier for third segment value derived source. CCID4NUMBER18Code combination identifier for the fourth segment value derived source. CCID5NUMBER18Code combination identifier for the fifth segment value derived source. CCID6NUMBER18Code combination identifier for the sixth segment value derived source. CCID7NUMBER18Code combination identifier for the seventh segment value derived source. CCID8NUMBER18Code combination identifier for the eighth segment value derived source. CCID9NUMBER18Code combination identifier for the ninth segment value derived source. CCID10NUMBER18Code combination identifier for the tenth segment value derived source. CCID11NUMBER18Code combination identifier for the eleventh segment value derived source. CCID12NUMBER18Code combination identifier for the twelfth segment value derived source. CCID13NUMBER18Code combination identifier for the thirteenth segment value derived source. CCID14NUMBER18Code combination identifier for the fourteenth segment value derived source. CCID15NUMBER18Code combination identifier for the fifteenth segment value derived source. CCID16NUMBER18Code combination identifier for the sixteenth segment value derived source. CCID17NUMBER18Code combination identifier for the seventeenth segment value derived source. CCID18NUMBER18Code combination identifier for the eighteenth segment value derived source. CCID19NUMBER18Code combination identifier for the nineteenth segment value derived source. CCID20NUMBER18Code combination identifier for the twentieth segment value derived source. CCID21NUMBER18Code combination identifier for the twenty-first segment value derived source. CCID22NUMBER18Code combination identifier for the twenty-second segment value derived source. CCID23NUMBER18Code combination identifier for the twenty-third segment value derived source. CCID24NUMBER18Code combination identifier for the twenty-fourth segment value derived source. CCID25NUMBER18Code combination identifier for the twenty-fifth segment value derived source. CCID26NUMBER18Code combination identifier for twenty-sixth segment value derived source. CCID27NUMBER18Code combination identifier for twenty-seventh segment value derived source. CCID28NUMBER18Code combination identifier for twenty-eighth segment value derived source. CCID29NUMBER18Code combination identifier for the twenty-ninth segment value derived source. CCID30NUMBER18Code combination identifier for the thirtieth segment value derived source. CCID31NUMBER18Code combination identifier for the thirty-first segment value derived source. CCID32NUMBER18Code combination identifier for the thirty-second segment value derived source. CCID33NUMBER18Code combination identifier for the thirty-third segment value derived source. CCID34NUMBER18Code combination identifier for the thirty-fourth segment value derived source. CCID35NUMBER18Code combination identifier for the thirty-fifth segment value derived source. CCID36NUMBER18Code combination identifier for the thirty-sixth segment value derived source. CCID37NUMBER18Code combination identifier for the thirty-seventh segment value derived source. CCID38NUMBER18Code combination identifier for the thirty-eighth segment value derived source. CCID39NUMBER18Code combination identifier for the thirty-ninth segment value derived source. CCID40NUMBER18Code combination identifier for the fortieth segment value derived source. CCID41NUMBER18Code combination identifier for the forty-first segment value derived source. CCID42NUMBER18Code combination identifier for the fortieth second segment value derived source. CCID43NUMBER18Code combination identifier for the forty-third segment value derived source. CCID44NUMBER18Code combination identifier for the forty fourth segment value derived source. CCID45NUMBER18Code combination identifier for the forty fifth segment value derived source. CCID46NUMBER18Code combination identifier for the forty sixth segment value derived source. CCID47NUMBER18Code combination identifier for the forty seventh segment value derived source. CCID48NUMBER18Code combination identifier for the forty eighth segment value derived source. CCID49NUMBER18Code combination identifier for the forty ninth segment value derived source. CCID50NUMBER18Code combination identifier for the fiftieth segment value derived source. CCID51NUMBER18Code combination identifier for the fifty first segment value derived source. CCID52NUMBER18Code combination identifier for the fifty second segment value derived source. CCID53NUMBER18Code combination identifier for the fifty third segment value derived source. CCID54NUMBER18Code combination identifier for the fifty fourth segment value derived source. CCID55NUMBER18Code combination identifier for the fifty fifth segment value derived source. CCID56NUMBER18Code combination identifier for the fifty sixth segment value derived source. CCID57NUMBER18Code combination identifier for the fifty seventh segment value derived source. CCID58NUMBER18Code combination identifier for the fifty eighth segment value derived source. CCID59NUMBER18Code combination identifier for the fifty ninth segment value derived source. CCID60NUMBER18Code combination identifier for the sixtieth segment value derived source. CCID61NUMBER18Code combination identifier for the sixty first segment value derived source. CCID62NUMBER18Code combination identifier for the sixty second segment value derived source. CCID63NUMBER18Code combination identifier for the sixty third segment value derived source. CCID64NUMBER18Code combination identifier for the sixty fourth segment value derived source. CCID65NUMBER18Code combination identifier for the sixty fifth segment value derived source. CCID66NUMBER18Code combination identifier for the sixty sixth segment value derived source. CCID67NUMBER18Code combination identifier for the sixty seventh segment value derived source. CCID68NUMBER18Code combination identifier for the sixty eighth segment value derived source. CCID69NUMBER18Code combination identifier for the sixty ninth segment value derived source. CCID70NUMBER18Code combination identifier for the seventieth segment value derived source. CCID71NUMBER18Code combination identifier for the seventy first segment value derived source. CCID72NUMBER18Code combination identifier for the seventy second segment value derived source. CCID73NUMBER18Code combination identifier for the seventy third segment value derived source. CCID74NUMBER18Code combination identifier for the seventy fourth segment value derived source. CCID75NUMBER18Code combination identifier for the seventy fifth segment value derived source. CCID76NUMBER18Code combination identifier for the seventy sixth segment value derived source. CCID77NUMBER18Code combination identifier for the seventy seventh segment value derived source. CCID78NUMBER18Code combination identifier for the seventy eighth segment value derived source. CCID79NUMBER18Code combination identifier for the seventy ninth segment value derived source. CCID80NUMBER18Code combination identifier for the eightieth segment value derived source. CCID81NUMBER18Code combination identifier for the eighty first segment value derived source. CCID82NUMBER18Code combination identifier for the eighty second segment value derived source. CCID83NUMBER18Code combination identifier for the eighty third segment value derived source. CCID84NUMBER18Code combination identifier for the eighty fourth segment value derived source. CCID85NUMBER18Code combination identifier for the eighty fifth segment value derived source. CCID86NUMBER18Code combination identifier for the eighty sixth segment value derived source. CCID87NUMBER18Code combination identifier for the eighty seventh segment value derived source. CCID88NUMBER18Code combination identifier for the eighty eighth segment value derived source. CCID89NUMBER18Code combination identifier for the eighty ninth segment value derived source. CCID90NUMBER18Code combination identifier for the ninetieth segment value derived source. CCID91NUMBER18Code combination identifier for the ninety first segment value derived source. CCID92NUMBER18Code combination identifier for the ninety second segment value derived source. CCID93NUMBER18Code combination identifier for the ninety third segment value derived source. CCID94NUMBER18Code combination identifier for the ninety fourth segment value derived source. CCID95NUMBER18Code combination identifier for the ninety fifth segment value derived source. CCID96NUMBER18Code combination identifier for the ninety sixth segment value derived source. CCID97NUMBER18Code combination identifier for the ninety seventh segment value derived source. CCID98NUMBER18Code combination identifier for the ninety eighth segment value derived source. CCID99NUMBER18Code combination identifier for the ninety ninth segment value derived source. CCID100NUMBER18Code combination identifier for the one hundredth segment value derived source. CUSTSRC1_ARGSVARCHAR21000Input value(s) for first custom source. CUSTSRC2_ARGSVARCHAR21000Input value(s) for second custom source. CUSTSRC3_ARGSVARCHAR21000Input value(s) for third custom source. CUSTSRC4_ARGSVARCHAR21000Input value(s) for the fourth custom source. CUSTSRC5_ARGSVARCHAR21000Input value(s) for the fifth custom source. CUSTSRC6_ARGSVARCHAR21000Input value(s) for the sixth custom source. CUSTSRC7_ARGSVARCHAR21000Input value(s) for the seventh custom source. CUSTSRC8_ARGSVARCHAR21000Input value(s) for the eighth custom source. CUSTSRC9_ARGSVARCHAR21000Input value(s) for the ninth custom source. CUSTSRC10_ARGSVARCHAR21000Input value(s) for the tenth custom source. CUSTSRC11_ARGSVARCHAR21000Input value(s) for the eleventh custom source. CUSTSRC12_ARGSVARCHAR21000Input value(s) for the twelfth custom source. CUSTSRC13_ARGSVARCHAR21000Input value(s) for the thirteenth custom source. CUSTSRC14_ARGSVARCHAR21000Input value(s) for the fourteenth custom source. CUSTSRC15_ARGSVARCHAR21000Input value(s) for the fifteenth custom source. CUSTSRC16_ARGSVARCHAR21000Input value(s) for the sixteenth custom source. CUSTSRC17_ARGSVARCHAR21000Input value(s) for the seventeenth custom source. CUSTSRC18_ARGSVARCHAR21000Input value(s) for the eighteenth custom source. CUSTSRC19_ARGSVARCHAR21000Input value(s) for the nineteenth custom source. CUSTSRC20_ARGSVARCHAR21000Input value(s) for the twentieth custom source. CUSTSRC21_ARGSVARCHAR21000Input value(s) for the twenty first custom source. CUSTSRC22_ARGSVARCHAR21000Input value(s) for the twenty second custom source. CUSTSRC23_ARGSVARCHAR21000Input value(s) for the twenty third custom source. CUSTSRC24_ARGSVARCHAR21000Input value(s) for the twenty fourth custom source. CUSTSRC25_ARGSVARCHAR21000Input value(s) for the twenty fifth custom source. CUSTSRC26_ARGSVARCHAR21000Input value(s) for the twenty sixth custom source. CUSTSRC27_ARGSVARCHAR21000Input value(s) for the twenty seventh custom source. CUSTSRC28_ARGSVARCHAR21000Input value(s) for the twenty eighth custom source. CUSTSRC29_ARGSVARCHAR21000Input value(s) for the twenty ninth custom source. CUSTSRC30_ARGSVARCHAR21000Input value(s) for the thirtieth custom source. CUSTSRC31_ARGSVARCHAR21000Input value(s) for the thirty first custom source. CUSTSRC32_ARGSVARCHAR21000Input value(s) for the thirty second custom source. CUSTSRC33_ARGSVARCHAR21000Input value(s) for the thirty third custom source. CUSTSRC34_ARGSVARCHAR21000Input value(s) for the thirty fourth custom source. CUSTSRC35_ARGSVARCHAR21000Input value(s) for the thirty fifth custom source. CUSTSRC36_ARGSVARCHAR21000Input value(s) for the thirty sixth custom source. CUSTSRC37_ARGSVARCHAR21000Input value(s) for the thirty seventh custom source. CUSTSRC38_ARGSVARCHAR21000Input value(s) for the thirty eighth custom source. CUSTSRC39_ARGSVARCHAR21000Input value(s) for the thirty ninth custom source. CUSTSRC40_ARGSVARCHAR21000Input value(s) for the fortieth custom source. CUSTSRC41_ARGSVARCHAR21000Input value(s) for the forty first custom source. CUSTSRC42_ARGSVARCHAR21000Input value(s) for the forty second custom source. CUSTSRC43_ARGSVARCHAR21000Input value(s) for the forty third custom source. CUSTSRC44_ARGSVARCHAR21000Input value(s) for the forty fourth custom source. CUSTSRC45_ARGSVARCHAR21000Input value(s) for the forty fifth custom source. CUSTSRC46_ARGSVARCHAR21000Input value(s) for the forty sixth custom source. CUSTSRC47_ARGSVARCHAR21000Input value(s) for the forty seventh custom source. CUSTSRC48_ARGSVARCHAR21000Input value(s) for the forty eighth custom source. CUSTSRC49_ARGSVARCHAR21000Input value(s) for the forty ninth custom source. CUSTSRC50_ARGSVARCHAR21000Input value(s) for the fiftieth custom source. CUSTSRC51_ARGSVARCHAR21000Input value(s) for the fifty first custom source. CUSTSRC52_ARGSVARCHAR21000Input value(s) for the fifty second custom source. CUSTSRC53_ARGSVARCHAR21000Input value(s) for the fifty third custom source. CUSTSRC54_ARGSVARCHAR21000Input value(s) for the fifty fourth custom source. CUSTSRC55_ARGSVARCHAR21000Input value(s) for the fifty fifth custom source. CUSTSRC56_ARGSVARCHAR21000Input value(s) for the fifty sixth custom source. CUSTSRC57_ARGSVARCHAR21000Input value(s) for the fifty seventh custom source. CUSTSRC58_ARGSVARCHAR21000Input value(s) for the fifty eighth custom source. CUSTSRC59_ARGSVARCHAR21000Input value(s) for the fifty ninth custom source. CUSTSRC60_ARGSVARCHAR21000Input value(s) for the sixtieth custom source. CUSTSRC61_ARGSVARCHAR21000Input value(s) for the sixty first custom source. CUSTSRC62_ARGSVARCHAR21000Input value(s) for the sixty second custom source. CUSTSRC63_ARGSVARCHAR21000Input value(s) for the sixty third custom source. CUSTSRC64_ARGSVARCHAR21000Input value(s) for the sixty fourth custom source. CUSTSRC65_ARGSVARCHAR21000Input value(s) for the sixty fifth custom source. CUSTSRC66_ARGSVARCHAR21000Input value(s) for the sixty sixth custom source. CUSTSRC67_ARGSVARCHAR21000Input value(s) for the sixty seventh custom source. CUSTSRC68_ARGSVARCHAR21000Input value(s) for the sixty eighth custom source. CUSTSRC69_ARGSVARCHAR21000Input value(s) for the sixty ninth custom source. CUSTSRC70_ARGSVARCHAR21000Input value(s) for the seventieth custom source. CUSTSRC71_ARGSVARCHAR21000Input value(s) for the seventy first custom source. CUSTSRC72_ARGSVARCHAR21000Input value(s) for the seventy second custom source. CUSTSRC73_ARGSVARCHAR21000Input value(s) for the seventy third custom source. CUSTSRC74_ARGSVARCHAR21000Input value(s) for the seventy fourth custom source. CUSTSRC75_ARGSVARCHAR21000Input value(s) for the seventy fifth custom source. CUSTSRC76_ARGSVARCHAR21000Input value(s) for the seventy sixth custom source. CUSTSRC77_ARGSVARCHAR21000Input value(s) for the seventy seventh custom source. CUSTSRC78_ARGSVARCHAR21000Input value(s) for the seventy eighth custom source. CUSTSRC79_ARGSVARCHAR21000Input value(s) for the seventy ninth custom source. CUSTSRC80_ARGSVARCHAR21000Input value(s) for the eightieth custom source. CUSTSRC81_ARGSVARCHAR21000Input value(s) for the eighty first custom source. CUSTSRC82_ARGSVARCHAR21000Input value(s) for the eighty second custom source. CUSTSRC83_ARGSVARCHAR21000Input value(s) for the eighty third custom source. CUSTSRC84_ARGSVARCHAR21000Input value(s) for the eighty fourth custom source. CUSTSRC85_ARGSVARCHAR21000Input value(s) for the eighty fifth custom source. CUSTSRC86_ARGSVARCHAR21000Input value(s) for the eighty sixth custom source. CUSTSRC87_ARGSVARCHAR21000Input value(s) for the eighty seventh custom source. CUSTSRC88_ARGSVARCHAR21000Input value(s) for the eighty eighth custom source. CUSTSRC89_ARGSVARCHAR21000Input value(s) for the eighty ninth custom source. CUSTSRC90_ARGSVARCHAR21000Input value(s) for the ninetieth custom source. CUSTSRC91_ARGSVARCHAR21000Input value(s) for the ninety first custom source. CUSTSRC92_ARGSVARCHAR21000Input value(s) for the ninety second custom source. CUSTSRC93_ARGSVARCHAR21000Input value(s) for the ninety third custom source. CUSTSRC94_ARGSVARCHAR21000Input value(s) for the ninety fourth custom source. CUSTSRC95_ARGSVARCHAR21000Input value(s) for the ninety fifth custom source. CUSTSRC96_ARGSVARCHAR21000Input value(s) for the ninety sixth custom source. CUSTSRC97_ARGSVARCHAR21000Input value(s) for the ninety seventh custom source. CUSTSRC98_ARGSVARCHAR21000Input value(s) for the ninety eighth custom source. CUSTSRC99_ARGSVARCHAR21000Input value(s) for the ninety ninth custom source. CUSTSRC100_ARGSVARCHAR21000Input value(s) for the one hundreth custom source.