PAYMENTBATCH¶
This source table stores information about CLASSIC / Back Office Payment Batches.
Columns¶
| Column | Data type | Description |
|---|---|---|
ACCOUNTINGPERIODSTAFFINGSUPPLIERGUID |
VARCHAR | The unique identifier for the Accounting Period Staffing Supplier, formatted as a GUID. |
ACHGENERATEDDATE |
TIMESTAMP_NTZ | The date the ACH was generated. |
ADPFILESTATUS |
VARCHAR | The ADP file status. |
ADPGENERATEDBY |
VARCHAR | The identifier for the user that generated the ADP file, formatted as a GUID. |
APPLYSTATEMINIMUMWAGE |
NUMBER | A flag indicating whether to apply state minimum wage or not. |
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. |
CHECKCOUNT |
NUMBER | The number of checks in the batch. |
CHECKDATE |
TIMESTAMP_NTZ | The date for the checks in the batch. |
CREATEDDATE |
TIMESTAMP_NTZ | The date the payment batch was created. |
DESCRIPTION |
VARCHAR | The description for the payment batch. |
DISCARDBYUSERGUID |
VARCHAR | The unique identifier for the user that discarded the payment batch, formatted as a GUID. |
DISCARDDATE |
TIMESTAMP_NTZ | The date the payment batch was discarded. |
ERRORBATCHOFGUID |
VARCHAR | The Foreign Key GUID to the PaymentBatchError table. Note: The PaymentBatchError table has not yet been surfaced as a DataLink table. |
EXTERNALDB |
VARCHAR | For Avionté internal use only. Non-null values typically mean the row was imported from another data source. |
EXTERNALID |
VARCHAR | For Avionté internal use only. Non-null values typically mean the row was imported from another data source. |
FLAGPRINTCOMPLETE |
NUMBER | A flag indicating whether printing is complete for the batch. |
GENERATEORIGINALPAYUNITS |
NUMBER | A flag indicating whether original pay units should be generated. |
IGNOREPERMANENTDEDUCTIONSETUP |
NUMBER | A flag indicating whether permanent deductions should be ignored. |
ISACTIVE |
NUMBER | A flag indicating whether the payment batch is active. |
LASTUPDATEDDATE |
TIMESTAMP_NTZ | The timestamp when the row was last updated. |
LIVECHECKONLY |
NUMBER | A flag indicating whether the payment is live-check only. |
LOCKEDBYUSERGUID |
VARCHAR | The unique identifier for the user who locked the payment batch, formatted as a GUID. The value is stored when the payment batch is locked. |
LOCKPRINTINGCHECK |
NUMBER | A flag indicating whether check printing is locked. |
OFFSETVALUE |
NUMBER | For Avionté internal use only. |
PARENTPAYMENTBATCHGUID |
VARCHAR | The unique identifier for the parent payment batch, formatted as a GUID. |
PAYMENTBANKID |
NUMBER | The identifier for the payment bank. |
PAYMENTBATCHGUID |
VARCHAR | The unique identifier for the payment batch, formatted as a GUID. |
PAYMENTBATCHID |
NUMBER | The identifier for the payment batch. |
PAYMENTBATCHSTATUSCONFIGSYSTEMCHOICEID |
NUMBER | The configuration system choice identifier for the status of the payment batch. |
PAYMENTBATCHTYPECONFIGSYSTEMCHOICEID |
NUMBER | The configuration system choice identifier for the type of the payment batch. |
PAYMENTCHECKMESSAGE |
VARCHAR | The payment check message. |
POSITIVEPAYGENERATEDDATE |
TIMESTAMP_NTZ | The date when positive pay was generated. |
POSTEDDATE |
TIMESTAMP_NTZ | The date when the payment batch was posted. |
PRINTDATE |
TIMESTAMP_NTZ | The print date for the payment batch. |
PRINTSTARTDATETIME |
TIMESTAMP_NTZ | The timestamp when printing started for the payment batch. |
PROCESSDATE |
TIMESTAMP_NTZ | The date when the payment batch was processed. |
TRANSACTIONCOUNT |
NUMBER | The number of transactions in the payment batch. |
USERGUID |
VARCHAR | The unique identifier for the user associated with the payment batch, formatted as a GUID. |