Column: Account - Revision history

Nguyentanphong: /* Column: Account */

2012-02-07T04:35:45Z

Column: Account

← Older revision		Revision as of 04:35, 7 February 2012
Line 2:		Line 2:


	===Column: Account===		=== Column: Account ===

	{\| class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101~~" width="1067" border="1" cellpadding="2~~"		{\| width="1067" cellpadding="2" border="1" class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101"
	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Column		Column
	\| style="border: 1px solid #010101~~" width="839~~" \|
	Account		\| width="839" style="border: 1px solid #010101" \|
			Account

	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Source		Source
	\| style="border: 1px solid #010101~~" width="839~~" \|
	The id of the account added for account detail record of a returned invoice resource		\| width="839" style="border: 1px solid #010101" \|
			The id of the account added for account detail record of a returned invoice resource

	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Automatically given column name		Automatically given column name
	\| style="border: 1px solid #010101~~" width="839~~" \|
	Account		\| width="839" style="border: 1px solid #010101" \|
			Account

	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Column type		Column type
	\| style="border: 1px solid #010101~~" width="839~~" \|
	Number		\| width="839" style="border: 1px solid #010101" \|
			Number

	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Resource types that use it		Resource types that use it
	\| style="border: 1px solid #010101~~" width="839~~" \|
	Invoice		\| width="839" style="border: 1px solid #010101" \|
			Invoice

	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	~~How axis set information is built~~		How axis set information is built
	\| style="border: 1px solid #010101~~" width="839~~" \|
	~~This column is what we call a "search string dependent axis option". This means that the~~ axis set ~~for it~~ is rebuilt each time that the resource cache is rebuilt. The reason for this is, that the number of possible option outcomes for the column is changing each time the column is updated. For this column it will not make sense if you try to update its options directly in the axis set, since these will be reset on resource cache rebuild anyway.

	~~The axis set is built upon first extracting all the IDs that are in the~~ "~~Account~~" column~~, then creating one~~ option in the axis set for each ~~unique value~~. The option ~~will be named~~ the ~~same as~~ the ~~account in Catglobe that owns the ID~~. ~~Let us say that the system finds the value "12" in~~ this column~~. The system~~ will ~~then look up the name of the account record with this ID and creates an option~~ in the axis ~~that is automatically generated for the column~~.		\| width="839" style="border: 1px solid #010101" \|
			This column is what we call a "search string dependent axis option". This means that the axis set for it is rebuilt each time that the resource cache is rebuilt. The reason for this is, that the number of possible option outcomes for the column is changing each time the column is updated. For this column it will not make sense if you try to update its options directly in the axis set, since these will be reset on resource cache rebuild anyway.

	~~Typically~~ the axis for this column will look ~~something like~~ the ~~below:~~		The axis set is built upon first extracting all the IDs that are in the "Account" column, then creating one option in the axis set for each unique value. The option will be named the same as the account in Catglobe that owns the ID. Let us say that the system finds the value "12" in this column. The system will then look up the name of the account record with this ID and creates an option in the axis that is automatically generated for the column.

	Axis text: "Account"Math base: "Account"Pct base: "Account!=empty"		Typically the axis for this column will look something like the below:

			Axis text: "Account"

			Math base: "Account"

			Pct base: "Account!=empty"

			<br>

			Option 1: Name="Revenue from consultancy work"; Value="Account==123"

			Option 2: Name="...."; Value="Account==...", etc.

	~~Option 1: Name="Revenue from consultancy work"; Value="Account==123"Option 2: Name="...."; Value="Account==...", etc.~~
	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Comment		Comment
	\| style="border: 1px solid #010101~~" width="839~~" \|
	N/A		\| width="839" style="border: 1px solid #010101" \|
	__NOTOC__		N/A __NOTOC__ <!-- imported from file: 7770.htm-->
	<!-- imported from file: 7770.htm-->
			\|}

Cg huyphong at 04:38, 26 April 2011

2011-04-26T04:38:12Z

← Older revision		Revision as of 04:38, 26 April 2011
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		[[Category:Resource data caches]]

Catglobe: jrfconvert import

2011-03-07T08:47:31Z

jrfconvert import

New page

[[Category:HelpBooks]]

===Column: Account===

{| class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101" width="1067" border="1" cellpadding="2"
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Column
| style="border: 1px solid #010101" width="839" |
Account
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Source
| style="border: 1px solid #010101" width="839" |
The id of the account added for account detail record of a returned invoice resource
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Automatically given column name
| style="border: 1px solid #010101" width="839" |
Account
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Column type
| style="border: 1px solid #010101" width="839" |
Number
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Resource types that use it
| style="border: 1px solid #010101" width="839" |
Invoice
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
How axis set information is built
| style="border: 1px solid #010101" width="839" |
This column is what we call a "search string dependent axis option". This means that the axis set for it is rebuilt each time that the resource cache is rebuilt. The reason for this is, that the number of possible option outcomes for the column is changing each time the column is updated. For this column it will not make sense if you try to update its options directly in the axis set, since these will be reset on resource cache rebuild anyway.

The axis set is built upon first extracting all the IDs that are in the "Account" column, then creating one option in the axis set for each unique value. The option will be named the same as the account in Catglobe that owns the ID. Let us say that the system finds the value "12" in this column. The system will then look up the name of the account record with this ID and creates an option in the axis that is automatically generated for the column.

Typically the axis for this column will look something like the below:

Axis text: "Account"Math base: "Account"Pct base: "Account!=empty"

Option 1: Name="Revenue from consultancy work"; Value="Account==123"Option 2: Name="...."; Value="Account==...", etc.
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Comment
| style="border: 1px solid #010101" width="839" |
N/A
__NOTOC__