You are here: Reference Guide > Table Structures > Creditors > CR_ForwardCover

CR_ForwardCover          

Purpose

This table stores the header record details for each forward cover contract

Path

Purchase Orders Forward Cover Management


Name                                          

Type

Link to/supplied

ForwardCoverID

Char  36

 

LastSavedDateTime

Date/Time

 

ForwardCoverContractNo

Char 50

 

ForwardCoverDescription

Char 255

 

CreditorID

Char 20

CR_Main.CreditorID

CurrencyID

Char 20

FX_Currency.CurrencyID

CurrencyDecimalPlaces

Smallint

 

CurrencyRate

Decimal  16

 

FXAmount

Decimal  16

 

AUDAmount

Decimal   16

 

Reference

Char 50

 

InitiatedDate

Date/Time

 

StartDate

Date/Time

 

EndDate

Date/Time

 

ContractStatus

Smallint

0 = Inactive
1 = Active
2 = Closed

AutoCloseContract

Smallint

 

AmountPaid

Decimal(19,6)

 

FXAmountPaid

Decimal(19,6)

 

Copyright © 2012 Jiwa Financials. All rights reserved.