2020/01/27 #勘定科目のグループ分け
皆様おはようございます、
#猫でもできるPowerShell(備忘録)
#勘定科目のグループ分け
<#
元ネタ
gitlab.besco.vn > odoo > addons > data > account.account.template.csv
Mr King / Odoo Community - GitLab
#>
PS> import-csv `
"~\Downloads\account.template.csv" -Encoding Default |
SELECT `
@{La='type';Ex={$_.'user_type_id/id'.substring($_.'user_type_id/id'.LastIndexOf("_")+1,6)}},* |
FT -AutoSize
type id code name user_type_id/id tax_ids/id reconcile currency_id/id chart_template_id/id
---- -- ---- ---- --------------- ---------- --------- -------------- --------------------
liquid A11101 A11101 普通預金 account.data_account_type_liquidity FALSE l10n_jp1
liquid A11103 A11103 定期預金 account.data_account_type_liquidity FALSE l10n_jp1
receiv A11211 A11211 売掛金 account.data_account_type_receivable TRUE l10n_jp1
receiv A11212 A11212 売掛金(USD) account.data_account_type_receivable TRUE base.USD l10n_jp1
receiv A11215 A11215 受取手形 account.data_account_type_receivable TRUE l10n_jp1
receiv A11216 A11216 割引手形 account.data_account_type_receivable TRUE l10n_jp1
assets A11219 A11219 出庫請求仮 account.data_account_type_current_assets FALSE l10n_jp1
assets A11301 A11301 未収収益 account.data_account_type_current_assets FALSE l10n_jp1
:
:
とりあえず user_type_idのお尻から少し切り出して
勘定科目のグループ分けをしてみました
ではまた;
#猫でもできるPowerShell(備忘録)
#勘定科目のグループ分け
<#
元ネタ
gitlab.besco.vn > odoo > addons > data > account.account.template.csv
Mr King / Odoo Community - GitLab
#>
PS> import-csv `
"~\Downloads\account.template.csv" -Encoding Default |
SELECT `
@{La='type';Ex={$_.'user_type_id/id'.substring($_.'user_type_id/id'.LastIndexOf("_")+1,6)}},* |
FT -AutoSize
type id code name user_type_id/id tax_ids/id reconcile currency_id/id chart_template_id/id
---- -- ---- ---- --------------- ---------- --------- -------------- --------------------
liquid A11101 A11101 普通預金 account.data_account_type_liquidity FALSE l10n_jp1
liquid A11103 A11103 定期預金 account.data_account_type_liquidity FALSE l10n_jp1
receiv A11211 A11211 売掛金 account.data_account_type_receivable TRUE l10n_jp1
receiv A11212 A11212 売掛金(USD) account.data_account_type_receivable TRUE base.USD l10n_jp1
receiv A11215 A11215 受取手形 account.data_account_type_receivable TRUE l10n_jp1
receiv A11216 A11216 割引手形 account.data_account_type_receivable TRUE l10n_jp1
assets A11219 A11219 出庫請求仮 account.data_account_type_current_assets FALSE l10n_jp1
assets A11301 A11301 未収収益 account.data_account_type_current_assets FALSE l10n_jp1
:
:
とりあえず user_type_idのお尻から少し切り出して
勘定科目のグループ分けをしてみました
ではまた;