Statement Fee Detail List Export

Added On:  11/07/18 

SQL Table:  STATEMENT_FEE_DETAIL_LIST_EXPORT 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  StatementFeeDetailListExport 

Available Fields:

• Account Id
• Caption
• Data Registry Export Code
• Id
• Per Item

• Percentage Rate P 4
• Position
• Statement Id
• Stereotype
• Submission Id

• Submission Type
• Tax Amount
• Total Amount
• Transaction Amount
• Transaction Count

Account Id

Added On:  11/06/18

SQL Column:  ACCOUNT_ID

Java Field:  accountId

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Caption

Added On:  11/06/18

SQL Column:  CAPTION

Java Field:  caption

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Data Registry Export Code

Added On:  11/06/18

SQL Column:  DATA_REGISTRY_EXPORT_CODE

Java Field:  dataRegistryExportCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Id

Added On:  11/06/18

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

Per Item

Added On:  11/06/18

SQL Column:  PER_ITEM

Java Field:  perItem

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Percentage Rate P 4

Added On:  11/06/18

SQL Column:  PERCENTAGE_RATE_P4

Java Field:  percentageRateP4

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Position

Added On:  11/06/18

SQL Column:  POSITION

Java Field:  position

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Statement Id

Added On:  11/06/18

SQL Column:  STATEMENT_ID

Java Field:  statementId

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Stereotype

Added On:  11/06/18

SQL Column:  STEREOTYPE

Java Field:  stereotype

Status:  Active

SQL Type:  varchar(70)

Java Type:  String

Attributes:

Submission Id

Added On:  11/06/18

SQL Column:  SUBMISSION_ID

Java Field:  submissionId

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Submission Type

Added On:  11/06/18

SQL Column:  SUBMISSION_TYPE

Java Field:  submissionType

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

References Submission Classifier

Attributes:

Tax Amount

Added On:  02/08/24

SQL Column:  TAX_AMOUNT

Java Field:  taxAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Total Amount

Added On:  11/06/18

SQL Column:  TOTAL_AMOUNT

Java Field:  totalAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Transaction Amount

Added On:  11/06/18

SQL Column:  TRANSACTION_AMOUNT

Java Field:  transactionAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Transaction Count

Added On:  11/06/18

SQL Column:  TRANSACTION_COUNT

Java Field:  transactionCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes: