ERP/3.0/Developers Guide/Database Model/org.openbravo.advpaymentmngt/APRM FinAcc Transaction acct v
ERP/3.0/Developers Guide/Database Model/org.openbravo.advpaymentmngt |
|
APRM_FinAcc_Transaction_acct_v
Accounting entries related to a particular financial account
- Name:APRM_FinAcc_Transaction_acct_v
- Classname:FinAccTransactionAccounting
This table contains the following columns:
Name | Nullable | Data Type | Description |
FIN_Finacc_Transaction_Acct_ID | N | VARCHAR2(32) | null |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
Isactive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
Created | N | DATE | The date that this record is completed. |
Createdby | N | VARCHAR2(32) | User who created this records |
Updated | N | DATE | x not implemented |
Updatedby | N | VARCHAR2(32) | User who updated this records |
C_Acctschema_ID | N | VARCHAR2(32) | The structure used in accounting including costing methods, currencies, and the calendar. |
C_Elementvalue_ID | N | VARCHAR2(32) | A identification code for an account type. |
Datetrx | N | DATE | The date that a specified transaction is entered into the application. |
Dateacct | N | DATE | The date this transaction is recorded for in the general ledger. |
C_Period_ID | Y | VARCHAR2(32) | A specified time period. |
AD_Table_ID | N | VARCHAR2(32) | A dictionary table used for this tab that points to the database table. |
FIN_Finacc_Transaction_ID | N | VARCHAR2(32) | null |
FIN_Financial_Account_ID | N | VARCHAR2(32) | Financial account used to deposit / withdrawal money such as bank accounts or petty cash |
GL_Category_ID | Y | VARCHAR2(32) | A classification used to group lines in the general ledger. |
C_Tax_ID | Y | VARCHAR2(32) | The percentage of money requested by the government for this specified product or transaction. |
M_Locator_ID | Y | VARCHAR2(32) | A set of coordinates (x, y, z) which help locate an item in a warehouse. |
Postingtype | N | VARCHAR2(60) | A distinct posting amount characteristic used for processes and sometimes grouped within a category. |
C_Currency_ID | N | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
Amtsourcedr | N | NUMBER | The amount debited from the account, given in provider currency. |
Amtsourcecr | N | NUMBER | The amount credited from the account, given in provider currency. |
Amtacctdr | N | NUMBER | The amount debited to an account, converted to the organization default currency. |
Amtacctcr | N | NUMBER | The amount credited to an account, converted to the organization default currency. |
C_Uom_ID | Y | VARCHAR2(32) | A non monetary unit of measure. |
Qty | Y | NUMBER | The number of a certain item. |
M_Product_ID | Y | VARCHAR2(32) | An item produced by a process. |
C_Bpartner_ID | Y | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
AD_Orgtrx_ID | Y | VARCHAR2(32) | The organization which performs or initiates the transaction. |
C_Locfrom_ID | Y | VARCHAR2(32) | The location where items are sent from. |
C_Locto_ID | Y | VARCHAR2(32) | The location where items are sent to. |
C_Salesregion_ID | Y | VARCHAR2(32) | A defined section of the world where sales efforts will be focused. |
C_Project_ID | Y | VARCHAR2(32) | Identifier of a project defined within the Project & Service Management module. |
C_Campaign_ID | Y | VARCHAR2(32) | An advertising effort aimed at increasing sales. |
C_Activity_ID | Y | VARCHAR2(32) | A distinct activity defined and used in activity based management. |
User1_ID | Y | VARCHAR2(32) | A display of optional elements that are previously defined for this account combination. |
User2_ID | Y | VARCHAR2(32) | A display of optional elements that are previously defined for this account combination. |
Description | Y | NVARCHAR2(255) | A space to write additional related information. |
A_Asset_ID | Y | VARCHAR2(32) | An item which is owned and exchangeable for cash. |
Fact_Acct_Group_ID | N | VARCHAR2(32) | Accounting entry group ID |
Seqno | N | NUMBER(10, 0) | The order of records in a specified document. |
Factaccttype | Y | CHAR(1) | Type of entry (Normal, Closing, Opening, Regularization) |
Docbasetype | Y | NVARCHAR2(40) | A classification of document types that are shown and processed in the same window. |
Acctvalue | Y | NVARCHAR2(40) | Value of the account used in the entry. |
Acctdescription | Y | NVARCHAR2(255) | Description of the accounting entry |
C_Withholding_ID | Y | VARCHAR2(32) | Withholding |
Columns
FIN_Finacc_Transaction_Acct_ID
- Physical column name: FIN_Finacc_Transaction_Acct_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: Search
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:
AD_Client.AD_Client_ID IN (@#User_Client@)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: Search
- Default value: @AD_ORG_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Validation Rule AD_Org Security validation: Organizations of the Client with user acces rights. With the following code:
(@AD_Client_ID@='0' AND AD_Org.AD_Org_ID='0') OR (@AD_Client_ID@!='0' AND ((AD_Org.AD_Client_ID IN (@#User_Client@) AND AD_Org.AD_Org_ID IN (@#User_Org@)) OR AD_Org.AD_Org_ID='0' AND AD_Org.IsSummary='N'))
Active
There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.
- Physical column name: Isactive
- Property Name: active
- Reference: YesNo
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: Createdby
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: Updatedby
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Accounting Schema
- Physical column name: C_Acctschema_ID
- Property Name: accountingSchema
- Reference: Search
- This column is part of the table's identifier
Foreign key column to C_Acctschema table, (column: C_AcctSchema_ID)
Account Element
- Physical column name: C_Elementvalue_ID
- Property Name: accountElement
- Reference: Search
- This column is part of the table's identifier
Foreign key column to C_Elementvalue table, (column: C_ElementValue_ID)
Transaction Date
The Transaction Date indicates the date of the transaction.
- Physical column name: Datetrx
- Property Name: transactionDate
- Reference: Date
Accounting Date
The date this transaction is recorded on in the general ledger. This date also indicates which accounting period within the fiscal year this transaction will be part of.
- Physical column name: Dateacct
- Property Name: accountingDate
- Reference: Date
Period
- Physical column name: C_Period_ID
- Property Name: period
- Reference: Search
Foreign key column to C_Period table, (column: C_Period_ID)
Table
- Physical column name: AD_Table_ID
- Property Name: table
- Reference: Search
Foreign key column to AD_Table table, (column: AD_Table_ID)
Financial account transaction
- Physical column name: FIN_Finacc_Transaction_ID
- Property Name: financialAccountTransaction
- Reference: Search
Foreign key column to FIN_Finacc_Transaction table, (column: Fin_Finacc_Transaction_ID)
Financial Account
- Physical column name: FIN_Financial_Account_ID
- Property Name: financialAccount
- Reference: Search
- This column is a child for a buisiness object (is Parent)
Foreign key column to FIN_Financial_Account table, (column: Fin_Financial_Account_ID)
G/L Category
- Physical column name: GL_Category_ID
- Property Name: gLCategory
- Reference: Search
Foreign key column to GL_Category table, (column: GL_Category_ID)
Tax
- Physical column name: C_Tax_ID
- Property Name: tax
- Reference: Search
Foreign key column to C_Tax table, (column: C_Tax_ID)
Storage Bin
- Physical column name: M_Locator_ID
- Property Name: storageBin
- Reference: Search
Foreign key column to M_Locator table, (column: M_Locator_ID)
Posting Type
The Posting Type indicates the type of amount (Actual, Encumbrance, Budget) this journal updated.
- Physical column name: Postingtype
- Property Name: postingType
- Reference: String
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: Search
Foreign key column to C_Currency table, (column: C_Currency_ID)
Foreign Currency Debit
The Source Debit Amount indicates the credit amount for this line in the source currency.
- Physical column name: Amtsourcedr
- Property Name: foreignCurrencyDebit
- Reference: Amount
Foreign Currency Credit
The Source Credit Amount indicates the credit amount for this line in the source currency.
- Physical column name: Amtsourcecr
- Property Name: foreignCurrencyCredit
- Reference: Amount
Debit
The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency
- Physical column name: Amtacctdr
- Property Name: debit
- Reference: Amount
- This column is part of the table's identifier
Credit
The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency
- Physical column name: Amtacctcr
- Property Name: credit
- Reference: Amount
- This column is part of the table's identifier
UOM
- Physical column name: C_Uom_ID
- Property Name: uOM
- Reference: Search
Foreign key column to C_Uom table, (column: C_UOM_ID)
Quantity
The Quantity indicates the number of a specific product or item for this document.
- Physical column name: Qty
- Property Name: quantity
- Reference: Quantity
Product
- Physical column name: M_Product_ID
- Property Name: product
- Reference: Search
Foreign key column to M_Product table, (column: M_Product_ID)
Business Partner
- Physical column name: C_Bpartner_ID
- Property Name: businessPartner
- Reference: Search
Foreign key column to C_Bpartner table, (column: C_BPartner_ID)
Trx Organization
- Physical column name: AD_Orgtrx_ID
- Property Name: trxOrganization
- Reference: Table
Foreign key column to AD_Org table, (column: AD_Org_ID)
Reference Table AD_Org (Trx) With the following where clause:
AD_Org.IsSummary='N' AND AD_Org_ID <> '0'
Location from Address
- Physical column name: C_Locfrom_ID
- Property Name: locationFromAddress
- Reference: Table
Foreign key column to C_Location table, (column: C_Location_ID)
Reference Table C_Location
Location to Address
- Physical column name: C_Locto_ID
- Property Name: locationToAddress
- Reference: Table
Foreign key column to C_Location table, (column: C_Location_ID)
Reference Table C_Location
Sales Region
- Physical column name: C_Salesregion_ID
- Property Name: salesRegion
- Reference: Search
Foreign key column to C_Salesregion table, (column: C_SalesRegion_ID)
Project
- Physical column name: C_Project_ID
- Property Name: project
- Reference: Search
Foreign key column to C_Project table, (column: C_Project_ID)
Sales Campaign
- Physical column name: C_Campaign_ID
- Property Name: salesCampaign
- Reference: Search
Foreign key column to C_Campaign table, (column: C_Campaign_ID)
Activity
- Physical column name: C_Activity_ID
- Property Name: activity
- Reference: Search
Foreign key column to C_Activity table, (column: C_Activity_ID)
1st Dimension
The user defined element displays the optional elements that have been defined for this account combination.
- Physical column name: User1_ID
- Property Name: stDimension
- Reference: String
2nd Dimension
The user defined element displays the optional elements that have been defined for this account combination.
- Physical column name: User2_ID
- Property Name: ndDimension
- Reference: String
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: Memo
Asset
- Physical column name: A_Asset_ID
- Property Name: asset
- Reference: Search
Foreign key column to A_Asset table, (column: A_Asset_ID)
Group ID
Accounting entry group ID. Used to group a set of entries
- Physical column name: Fact_Acct_Group_ID
- Property Name: groupID
- Reference: String
Sequence Number
The Sequence indicates the order of records
- Physical column name: Seqno
- Property Name: sequenceNumber
- Reference: Integer
Type
Type of entry (Normal, Closing, Opening, Regularization)
- Physical column name: Factaccttype
- Property Name: type
- Reference: String
Document Category
The Document Base Type identifies the base or starting point for a document. Multiple document types may share a single document base type.
- Physical column name: Docbasetype
- Property Name: documentCategory
- Reference: String
Value
Value of the account used in the entry.
- Physical column name: Acctvalue
- Property Name: value
- Reference: String
Accounting entry Description
Description of the accounting entry
- Physical column name: Acctdescription
- Property Name: accountingEntryDescription
- Reference: String
Withholding
- Physical column name: C_Withholding_ID
- Property Name: withholding
- Reference: Search
Foreign key column to C_Withholding table, (column: C_Withholding_ID)