CN
ComplianceDocument
Represents a compliance document. The records of this type are created and edited through the Compliance Management (CL401000) form (which corresponds to the Graphs.ComplianceDocumentEntry graph) and through many other forms that contain the Compliance tab.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | - | |
Description:No description available | ||||
ApCheckID | uniqueidentifier | AP Payment | - | |
Description:No description available | ||||
ApPaymentMethodID | nvarchar(10) | AP Payment Method | PaymentMethod | |
Description:No description available | ||||
ArPaymentID | uniqueidentifier | AR Payment | - | |
Description:No description available | ||||
ArPaymentMethodID | nvarchar(10) | AR Payment Method | PaymentMethod | |
Description:No description available | ||||
BillAmountNonexistent in DB | decimal? | Bill Amount | - | |
Description:No description available | ||||
BillID | uniqueidentifier | Bill | - | |
Description:No description available | ||||
CertificateNumber | nvarchar(255) | Certificate Number | - | |
Description:No description available | ||||
ChangeOrderNumber | nvarchar(15) | Change Order | PMChangeOrder | |
Description:No description available | ||||
CheckNumberNonexistent in DB | string | Payment Ref. | - | |
Description:No description available | ||||
ComplianceDocumentID | int | Document Id | - | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CostTaskID | int | Cost Task | PMProject | |
Description:No description available | ||||
CreatedById | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenId | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CreationDate | datetime | Creation Date | - | |
Description:No description available | ||||
CustomerID | int | Customer | BAccountR | |
Description:No description available | ||||
CustomerNameNonexistent in DB | string | Customer Name | - | |
Description:No description available | ||||
DateIssued | datetime | Date Issued | - | |
Description:No description available | ||||
DocumentType | int | Document Type | ComplianceAttributeType | |
Description:No description available | ||||
DocumentTypeValue | int | Document Category | ComplianceAttribute | |
Description:No description available | ||||
EffectiveDate | datetime | Effective Date | - | |
Description:No description available | ||||
ExpirationDate | datetime | Expiration Date | - | |
Description:No description available | ||||
InsuranceCompany | nvarchar(255) | Insurance Company | - | |
Description:No description available | ||||
InsuranceDocumentTypeIdNonexistent in DB | int? | - | ||
Description:No description available | ||||
InvoiceAmountNonexistent in DB | decimal? | AR Invoice Amount | - | |
Description:No description available | ||||
InvoiceID | uniqueidentifier | AR Invoice | - | |
Description:No description available | ||||
IsCreatedAutomatically | bit | Created Automatically | - | |
Description:No description available | ||||
IsExpiredNonexistent in DB | bool? | Expired | - | |
Description:No description available | ||||
IsProcessed | bit | Processed | - | |
Description:No description available | ||||
IsReceivedFromJointVendor | bit | Received from Joint Payee | - | |
Description:No description available | ||||
IsRequiredJointCheck | bit | Requires Joint Payment | - | |
Description:No description available | ||||
IsVoided | bit | Voided | - | |
Description:No description available | ||||
JointAmount | decimal | Joint Amount Paid | - | |
Description:No description available | ||||
JointLienNoticeAmount | decimal | Joint Lien Notice Amount | - | |
Description:No description available | ||||
JointLienWaiverAmount | decimal | Joint Payee Lien Waiver Amount | - | |
Description:No description available | ||||
JointReceivedDate | datetime | Joint Payee Received Date | - | |
Description:No description available | ||||
JointRelease | nvarchar(255) | Joint Release | - | |
Description:No description available | ||||
JointReleaseReceived | bit | Joint Release Received | - | |
Description:No description available | ||||
JointVendorExternalName | nvarchar(30) | Joint Payee | - | |
Description:No description available | ||||
JointVendorInternalId | int | Joint Payee (Vendor) | BAccountR | |
Description:No description available | ||||
LastModifiedById | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenId | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LienNoticeAmount | decimal | Lien Notice Amount | - | |
Description:No description available | ||||
LienWaiverAmount | decimal | Lien Waiver Amount (Vendor) | - | |
Description:No description available | ||||
Limit | decimal | Limit | - | |
Description:No description available | ||||
LinkToPayment | bit | Link To Payment | - | |
Description:No description available | ||||
MethodSent | nvarchar(255) | Method Sent | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PaymentDate | datetime | Payment Date | - | |
Description:No description available | ||||
Policy | nvarchar(255) | Policy | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ProjectTransactionID | uniqueidentifier | Project Transaction | - | |
Description:No description available | ||||
PurchaseOrder | uniqueidentifier | Purchase Order | - | |
Description:No description available | ||||
PurchaseOrderLineItem | int | Purchase Order Line Item | POLine | |
Description:No description available | ||||
ReceiptDate | datetime | Receipt Date | - | |
Description:No description available | ||||
ReceiveDate | datetime | Receive Date | - | |
Description:No description available | ||||
Received | bit | Received from Vendor | - | |
Description:No description available | ||||
ReceivedBy | nvarchar(255) | Received By | - | |
Description:No description available | ||||
ReceivedDate | datetime | Vendor Received Date | - | |
Description:No description available | ||||
Required | bit | Required | - | |
Description:No description available | ||||
RevenueTaskID | int | Revenue Task | PMProject | |
Description:No description available | ||||
SecondaryVendorID | int | Secondary Vendor | BAccountR | |
Description:No description available | ||||
SecondaryVendorNameNonexistent in DB | string | Secondary Vendor Name | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
SentDate | datetime | Sent Date | - | |
Description:No description available | ||||
SkipInitNonexistent in DB | bool? | - | ||
Description:No description available | ||||
SourceType | nvarchar(10) | Source | - | |
Description:No description available | ||||
SponsorOrganization | nvarchar(255) | Sponsor Organization | - | |
Description:No description available | ||||
Status | int | Status | ComplianceAttribute | |
Description:No description available | ||||
Subcontract | nvarchar(15) | Subcontract | POOrder | |
Description:No description available | ||||
SubcontractLineItem | int | Subcontract Line Item | POLine | |
Description:No description available | ||||
ThroughDate | datetime | Through Date | - | |
Description:No description available | ||||
Tstamp | timestamp | - | ||
Description:No description available | ||||
VendorID | int | Vendor | BAccountR | |
Description:No description available | ||||
VendorNameNonexistent in DB | string | Vendor Name | - | |
Description:No description available | ||||