Table T_Aging

PRIMARY KEY
AD_PInstance_ID NUMBER (10, 0) NOT NULL		AD_PInstance
C_BPartner_ID NUMBER (10, 0) NOT NULL		C_BPartner
C_Currency_ID NUMBER (10, 0) NOT NULL		C_Currency
C_Invoice_ID NUMBER (10, 0) default: 0 NOT NULL	Used for Invoice Level Reporting only

AD_Client_ID NUMBER (10, 0) NOT NULL
AD_Org_ID NUMBER (10, 0) NOT NULL
IsActive CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL
Created DATE default: SYSDATE NOT NULL
CreatedBy NUMBER (10, 0) NOT NULL
Updated DATE default: SYSDATE NOT NULL
UpdatedBy NUMBER (10, 0) NOT NULL
DueDate DATE NOT NULL	Base Date for Aging calculation
IsSOTrx CHAR (1) default: 'Y' CHECK ( IsSOTrx in ( 'Y' , 'N' )) NOT NULL
PastDue91_Plus NUMBER default: 0 NOT NULL
PastDue61_90 NUMBER default: 0 NOT NULL
PastDue61_Plus NUMBER default: 0 NOT NULL
PastDue31_60 NUMBER default: 0 NOT NULL
PastDue31_Plus NUMBER default: 0 NOT NULL
PastDue1_30 NUMBER default: 0 NOT NULL
PastDue8_30 NUMBER default: 0 NOT NULL
PastDue1_7 NUMBER default: 0 NOT NULL
PastDueAmt NUMBER default: 0 NOT NULL
DueAmt NUMBER default: 0 NOT NULL
Due0 NUMBER default: 0 NOT NULL
Due0_7 NUMBER default: 0 NOT NULL
Due1_7 NUMBER default: 0 NOT NULL
Due8_30 NUMBER default: 0 NOT NULL
Due0_30 NUMBER default: 0 NOT NULL
Due31_Plus NUMBER default: 0 NOT NULL
Due31_60 NUMBER default: 0 NOT NULL
Due61_Plus NUMBER default: 0 NOT NULL
Due61_90 NUMBER default: 0 NOT NULL
Due91_Plus NUMBER default: 0 NOT NULL
C_BP_Group_ID NUMBER (10, 0) NOT NULL		C_BP_Group
IsListInvoices CHAR (1) default: 'N' CHECK ( IsListInvoices in ( 'Y' , 'N' )) NOT NULL
FOREIGN KEY ADPInstance_TAging: AD_PInstance_ID => AD_PInstance CBPartner_TAging: C_BPartner_ID => C_BPartner CBPGroup_TAging: C_BP_Group_ID => C_BP_Group CCurrency_TAging: C_Currency_ID => C_Currency