TRANSACTIONENTRYITEM¶
This source table stores information about CLASSIC / Back Office Transaction Entry Items.
Columns¶
| Column | Data type | Description |
|---|---|---|
ADJUSTEDTRANSACTIONENTRYITEMGUID |
VARCHAR | The unique identifier for the adjusted transaction entry item, formatted as a GUID. |
BILLADJUSTEDBYTRANSACTIONENTRYITEMGUID |
VARCHAR | The unique identifier for the bill adjusted by transaction entry item, formatted as a GUID. |
BILLRATE |
NUMBER | The bill rate for the transaction entry item. |
BILLUNIT |
NUMBER | The bill unit for the transaction entry item. |
BUILDID |
VARCHAR | Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows. |
CDCSTATUS |
VARCHAR | For Avionté internal use only. |
CONFIGTRANSACTIONTYPEID |
NUMBER | The identifier for the config transaction type. |
COSTRATE |
NUMBER | The cost rate for the transaction entry item. |
COSTUNIT |
NUMBER | The cost unit for the transaction entry item. |
EXTERNALLABEL |
VARCHAR | The external label for the transaction entry item. |
FKGUID |
VARCHAR | The foreign key GUID for the transaction entry item. |
ITEMBILL |
NUMBER | The item bill for the transaction entry item. |
ITEMCOST |
NUMBER | The item cost for the transaction entry item. |
ITEMPAY |
NUMBER | The item pay for the transaction entry item. |
ITEMTEXT |
VARCHAR | The item text for the transaction entry item. |
LASTMODIFIEDBYUSERGUID |
VARCHAR | The user identifier for the last user that updated the transaction entry item, formatted as a GUID. |
LASTUPDATEDDATE |
TIMESTAMP_NTZ | The timestamp when the row was last updated. |
OFFSETVALUE |
NUMBER | For Avionté internal use only. |
PAYADJUSTEDBYTRANSACTIONENTRYITEMGUID |
VARCHAR | The unique identifier for the pay adjusted by transaction entry item, formatted as a GUID. |
PAYRATE |
NUMBER | The pay rate for the transaction entry item. |
PAYUNIT |
NUMBER | The pay unit for the transaction entry item. |
SHOWZEROBILL |
NUMBER | A flag indicating whether to show zero bill or not. |
TRANSACTIONENTRYITEMGUID |
VARCHAR | The unique identifier for the transaction entry item, formatted as a GUID. |
TRANSACTIONGUID |
VARCHAR | The unique identifier for the transaction, formatted as a GUID. |