TransactionLineVats: XAF 3.2
read only per partition XML
- Catalog:
XAF
Can only retrieve data.
API Source
- XML topic:
auditfile - XML path:
/xaf:journal/xaf:transaction/xaf:trLine/xaf:vat
Table Columns
The columns of the table TransactionLineVats are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
AUDIT_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
FILE_ |
varchar2 |
||||
FILE_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
FISCAL_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
INTERFACE_ |
varchar2 |
||||
PRODUCT_ |
varchar2 |
||||
PRODUCT_ |
varchar2 |
||||
TRLINE_ |
varchar2 |
Transaction Line Account ID | |||
TRLINE_ |
decimal |
Transaction Line Amount | |||
TRLINE_ |
varchar2 |
Transaction Line Amount Type | |||
TRLINE_ |
varchar2 |
Transaction Line Article Group ID | |||
TRLINE_ |
varchar2 |
Transaction Line Bank Account Number | |||
TRLINE_ |
varchar2 |
Transaction Line Bank ID Code | |||
TRLINE_ |
varchar2 |
Transaction Line Cost ID | |||
TRLINE_ |
decimal |
||||
TRLINE_ |
varchar2 |
||||
TRLINE_ |
varchar2 |
Transaction Line Identification | |||
TRLINE_ |
varchar2 |
Transaction Line Description | |||
TRLINE_ |
varchar2 |
Transaction Line Document Reference | |||
TRLINE_ |
datetime |
Transaction Line Effective Date | |||
TRLINE_ |
varchar2 |
Transaction Line Invoice Reference | |||
TRLINE_ |
varchar2 |
Transaction Line Match Key ID | |||
TRLINE_ |
varchar2 |
Transaction Line Number | |||
TRLINE_ |
varchar2 |
Transaction Line Order Reference | |||
TRLINE_ |
varchar2 |
Transaction Line Product ID | |||
TRLINE_ |
varchar2 |
Transaction Line Project ID | |||
TRLINE_ |
int64 |
Transaction Line Quantity | |||
TRLINE_ |
varchar2 |
Transaction Line Quantity ID | |||
TRLINE_ |
varchar2 |
Transaction Line Receiving Document Reference | |||
TRLINE_ |
varchar2 |
Transaction Line Record Reference | |||
TRLINE_ |
varchar2 |
Transaction Line Shipping Document Reference | |||
TRLINE_ |
decimal |
Transaction Amount | |||
TRLINE_ |
varchar2 |
Transaction Amount Type | |||
TRLINE_ |
varchar2 |
Transaction Description | |||
TRLINE_ |
varchar2 |
Journal Bank Account Number | |||
TRLINE_ |
varchar2 |
Journal Description | |||
TRLINE_ |
varchar2 |
Journal Journal ID | |||
TRLINE_ |
varchar2 |
Journal Journal Typ | |||
TRLINE_ |
varchar2 |
Journal Offset Account ID | |||
TRLINE_ |
int64 |
Transaction Lines Count | |||
TRLINE_ |
decimal |
Transaction Total Credit | |||
TRLINE_ |
decimal |
Transaction Total Debit | |||
TRLINE_ |
varchar2 |
Transaction Number | |||
TRLINE_ |
int64 |
Transaction Period Number | |||
TRLINE_ |
varchar2 |
Transaction Source ID | |||
TRLINE_ |
datetime |
Transaction Date | |||
TRLINE_ |
varchar2 |
Transaction User ID | |||
TRLINE_ |
varchar2 |
Transaction Line Work Cost Arrangement Reference | |||
VATAMNT |
decimal |
||||
VATAMNTTP |
varchar2 |
||||
VATID |
varchar2 |
||||
VATPERC |
decimal |