| PRIMARY KEY |
|
C_Invoice_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| AD_Org |
|
AD_OrgTrx_ID
NUMBER (10, 0) |
| AD_Org |
|
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 |
| |
|
IsSOTrx
CHAR (1) default: 'Y' CHECK ( IsSOTrx in ( 'Y' , 'N' )) NOT NULL |
| |
|
DocumentNo
NVARCHAR2 (30) NOT NULL |
| |
|
DocStatus
CHAR (2) NOT NULL |
| |
|
DocAction
CHAR (2) NOT NULL |
| |
|
Processing
CHAR (1) |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) NOT NULL |
| |
|
Posted
CHAR (1) default: 'N' NOT NULL |
| |
|
C_DocType_ID
NUMBER (10, 0) NOT NULL |
| C_DocType |
|
C_DocTypeTarget_ID
NUMBER (10, 0) NOT NULL |
| C_DocType |
|
C_Order_ID
NUMBER (10, 0) |
Will only be filled if 1:1 Relationship
| C_Order |
|
Ref_Invoice_ID
NUMBER (10, 0) |
| C_Invoice |
|
Description
NVARCHAR2 (255) |
| |
|
IsApproved
CHAR (1) default: 'Y' CHECK ( IsApproved in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsSelfService
CHAR (1) default: 'N' CHECK ( IsSelfService in ( 'Y' , 'N' )) NOT NULL |
Was entered and/or can be edited by user via Self Service
| |
|
IsTransferred
CHAR (1) default: 'N' CHECK ( IsTransferred in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsPrinted
CHAR (1) default: 'N' CHECK ( IsPrinted in ( 'Y' , 'N' )) NOT NULL |
| |
|
SalesRep_ID
NUMBER (10, 0) |
| AD_User |
|
DateInvoiced
DATE NOT NULL |
| |
|
DatePrinted
DATE |
| |
|
DateAcct
DATE NOT NULL |
| |
|
C_BPartner_ID
NUMBER (10, 0) NOT NULL |
| C_BPartner |
|
AD_User_ID
NUMBER (10, 0) |
| AD_User |
|
C_BPartner_Location_ID
NUMBER (10, 0) NOT NULL |
| C_BPartner_Location |
|
POReference
NVARCHAR2 (20) |
| |
|
IsDiscountPrinted
CHAR (1) default: 'Y' CHECK ( IsDiscountPrinted in ( 'Y' , 'N' )) NOT NULL |
| |
|
SendEMail
CHAR (1) default: 'N' CHECK ( SendEMail in ( 'Y' , 'N' )) NOT NULL |
| |
|
DateOrdered
DATE |
| |
|
C_Currency_ID
NUMBER (10, 0) NOT NULL |
| C_Currency |
|
C_ConversionType_ID
NUMBER (10, 0) |
| C_ConversionType |
|
PaymentRule
CHAR (1) NOT NULL |
| |
|
C_PaymentTerm_ID
NUMBER (10, 0) NOT NULL |
| C_PaymentTerm |
|
IsPayScheduleValid
CHAR (1) default: 'N' CHECK ( IsPayScheduleValid in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_Charge_ID
NUMBER (10, 0) |
| C_Charge |
|
ChargeAmt
NUMBER default: 0 |
| |
|
TotalLines
NUMBER default: 0 NOT NULL |
| |
|
GrandTotal
NUMBER default: 0 NOT NULL |
| |
|
M_PriceList_ID
NUMBER (10, 0) NOT NULL |
| M_PriceList |
|
IsTaxIncluded
CHAR (1) default: 'N' CHECK ( IsTaxIncluded in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_Campaign_ID
NUMBER (10, 0) |
| C_Campaign |
|
C_Project_ID
NUMBER (10, 0) |
| C_Project |
|
C_Activity_ID
NUMBER (10, 0) |
| C_Activity |
|
IsPaid
CHAR (1) default: 'N' CHECK ( IsPaid in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_Payment_ID
NUMBER (10, 0) |
Temporary
| C_Payment |
|
C_CashLine_ID
NUMBER (10, 0) |
Temporary
| C_CashLine |
|
CreateFrom
CHAR (1) |
Create From another entity
| |
|
GenerateTo
CHAR (1) CHECK ( GenerateTo in ( 'Y' , 'N' )) |
| |
|
CopyFrom
CHAR (1) |
Copy from same entity
| |
|
User1_ID
NUMBER (10, 0) |
| C_ElementValue |
|
User2_ID
NUMBER (10, 0) |
| C_ElementValue |
FOREIGN KEY
ADOrg_CInvoice: AD_Org_ID => AD_Org
ADOrgTrx_CInvoice: AD_OrgTrx_ID => AD_Org
ADUser_CInvoice: AD_User_ID => AD_User
ADUser_SR_CInvoice: SalesRep_ID => AD_User
C_BPLocation_CInvoice: C_BPartner_Location_ID => C_BPartner_Location
CActivity_CInvoice: C_Activity_ID => C_Activity
CBPartner_CInvoice: C_BPartner_ID => C_BPartner
CCampaign_CInvoice: C_Campaign_ID => C_Campaign
CCashLine_CInvoice: C_CashLine_ID => C_CashLine
CCharge_CInvoice: C_Charge_ID => C_Charge
CConversionType_CInvoice: C_ConversionType_ID => C_ConversionType
CCurrency_CInvoice: C_Currency_ID => C_Currency
CDocType_CInvoice: C_DocType_ID => C_DocType
CDocTypeTarget_CInvoice: C_DocTypeTarget_ID => C_DocType
CElementValueUser1_CInvoice: User1_ID => C_ElementValue
CElementValueUser2_CInvoice: User2_ID => C_ElementValue
CInvoice_Ref: Ref_Invoice_ID => C_Invoice
COrder_CInvoice: C_Order_ID => C_Order
CPayment_CInvoice: C_Payment_ID => C_Payment
CPaymentTerm_CInvoice: C_PaymentTerm_ID => C_PaymentTerm
CProject_CInvoice: C_Project_ID => C_Project
MPriceList_CInvoice: M_PriceList_ID => M_PriceList
|
REFERENCED BY
C_Allocation,
C_BankStatementLine,
C_CashLine,
C_DunningRunLine,
C_Invoice,
C_InvoiceLine,
C_InvoicePaySchedule,
C_InvoiceTax,
C_PaySelectionLine,
C_Recurring,
C_Recurring_Run,
I_BankStatement,
I_Invoice,
I_Payment,
R_Request,
R_RequestAction |
|