I have which has the following table:
ACCT TYPE DEBIT CREDIT
EXPENSE WITHDRAWAL DEPOSIT
CURRENT ASSET DEPOSIT WITHDRAWAL
CURRENT LIABILITY WITHDRAWAL DEPOSIT
FIXED ASSET WITHDRWAL DEPOSIT
LONG TERM LIABILITY WITHDRAWAL DEPOSIT
REVENUE WITHDRAWAL DEPOSIT
The table above has the fieldnames in the first row. This is a table I created as areference table to help convert a simple accounting ledger into withdrawal/deposit frames based on cash flow, from the company's perspective.
There is another table which has the headings Debit and Credit in two of its fields, the field type however is numerical, as opposed to the text in the above. I would however like to update a table with either withdrwal or deposit based on whether the amount in the amount is entered in the ledger (either debit or credit). I am considering having a table which represents withdrawal/deposit in numerical values and be able to make the decision that way. I am not altogether sure if this is the correct direction to be taking. Please advise.
ACCT TYPE DEBIT CREDIT
EXPENSE WITHDRAWAL DEPOSIT
CURRENT ASSET DEPOSIT WITHDRAWAL
CURRENT LIABILITY WITHDRAWAL DEPOSIT
FIXED ASSET WITHDRWAL DEPOSIT
LONG TERM LIABILITY WITHDRAWAL DEPOSIT
REVENUE WITHDRAWAL DEPOSIT
The table above has the fieldnames in the first row. This is a table I created as areference table to help convert a simple accounting ledger into withdrawal/deposit frames based on cash flow, from the company's perspective.
There is another table which has the headings Debit and Credit in two of its fields, the field type however is numerical, as opposed to the text in the above. I would however like to update a table with either withdrwal or deposit based on whether the amount in the amount is entered in the ledger (either debit or credit). I am considering having a table which represents withdrawal/deposit in numerical values and be able to make the decision that way. I am not altogether sure if this is the correct direction to be taking. Please advise.