22.02 DB Schema Changes

Owned by Kalyn Galloway
Feb 15, 2022
1 min read

Added Columns(s)

[tbl_Res_Revenue_Payment]

Field

Data Type

NULLABLE

[str_IATA_Nmbr]VARCHAR (12)YES
[mny_Currency_Payment_Amt]MONEYYES
[mny_Exchange_Rate]FLOAT (53)YES
[str_Payment_Currency_Ident]VARCHAR (5)YES

Added Table(s)

[tbl_Payment_Method]

Field

Data Type

NULLABLE

[str_GL_Payment_Method_Ident]VARCHAR (7)NO
[str_GL_Payment_Method_Desc]VARCHAR (20)NO
[str_GL_Payment_Method_Flag]VARCHAR (2)NO
[str_Payment_Type]VARCHAR (13)NO
[str_Sales_Report_Payment_Method]VARCHAR (20)NO
[str_ETDB_FOP]VARCHAR (2)NO
[str_ETDB_FOP_Document_Prefix]VARCHAR (2)NO