pears.IQacAllocation

Allocates payments against invoices in cash accounting.

• AllocationDocumentID, AllocatedDocumentID, AllocatedLineNumber

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQacAllocation"
-- Table comment: Allocates payments against invoices in cash accounting.
-- Statement count: 4
 
CREATE TABLE "pears"."IQacAllocation" (
    "AllocationDocumentID"           CHAR(8) NOT NULL
   ,"AllocatedDocumentID"            CHAR(8) NOT NULL
   ,"AllocatedLineNumber"            SMALLINT NOT NULL
   ,"AllocatedAmount"                NUMERIC(12,2) NOT NULL
   ,"AllocatedVAT"                   NUMERIC(12,2) NOT NULL
   ,"AllocationDate"                 DATE NOT NULL
   ,PRIMARY KEY ("AllocationDocumentID" ASC,"AllocatedDocumentID" ASC,"AllocatedLineNumber" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."IQacAllocation" IS 
	'Allocates payments against invoices in cash accounting.'
GO
 
 
ALTER TABLE "pears"."IQacAllocation"
    ADD NOT NULL FOREIGN KEY "Journal" ("AllocatedDocumentID" ASC,"AllocatedLineNumber" ASC)
    REFERENCES "pears"."IQacJournal" ("DocumentID","LineNumber")
GO
 
 
ALTER TABLE "pears"."IQacAllocation"
    ADD NOT NULL FOREIGN KEY "IQacDocument" ("AllocationDocumentID" ASC)
    REFERENCES "pears"."IQacDocument" ("DocumentID")
GO