| PRIMARY KEY |
|
I_Invoice_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) |
| |
|
AD_Org_ID
NUMBER (10, 0) |
| AD_Org |
|
AD_OrgTrx_ID
NUMBER (10, 0) |
| AD_Org |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) |
| |
|
Created
DATE default: SYSDATE |
| |
|
CreatedBy
NUMBER (10, 0) |
| |
|
Updated
DATE default: SYSDATE |
| |
|
UpdatedBy
NUMBER (10, 0) |
| |
|
I_IsImported
CHAR (1) default: 'N' NOT NULL |
| |
|
I_ErrorMsg
NVARCHAR2 (2000) |
| |
|
Processing
CHAR (1) |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) |
| |
|
M_PriceList_ID
NUMBER (10, 0) |
| M_PriceList |
|
C_Currency_ID
NUMBER (10, 0) |
| C_Currency |
|
SalesRep_ID
NUMBER (10, 0) |
| AD_User |
|
IsSOTrx
CHAR (1) default: 'Y' CHECK ( IsSOTrx in ( 'Y' , 'N' )) |
| |
|
C_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
C_BPartner_Location_ID
NUMBER (10, 0) |
| C_BPartner_Location |
|
BPartnerValue
NVARCHAR2 (40) |
| |
|
Name
NVARCHAR2 (60) |
| |
|
C_Location_ID
NUMBER (10, 0) |
| C_Location |
|
Address1
NVARCHAR2 (60) |
| |
|
Address2
NVARCHAR2 (60) |
| |
|
Postal
VARCHAR2 (10) |
| |
|
City
NVARCHAR2 (60) |
| |
|
C_Region_ID
NUMBER (10, 0) |
| C_Region |
|
RegionName
NVARCHAR2 (60) |
| |
|
AD_User_ID
NUMBER (10, 0) |
| AD_User |
|
EMail
NVARCHAR2 (60) |
| |
|
ContactName
NVARCHAR2 (60) |
| |
|
Phone
NVARCHAR2 (40) |
| |
|
C_Country_ID
NUMBER (10, 0) |
| C_Country |
|
CountryCode
CHAR (2) |
| |
|
C_DocType_ID
NUMBER (10, 0) |
| C_DocType |
|
DocTypeName
NVARCHAR2 (60) |
| |
|
C_PaymentTerm_ID
NUMBER (10, 0) |
| C_PaymentTerm |
|
PaymentTermValue
NVARCHAR2 (40) |
| |
|
C_Project_ID
NUMBER (10, 0) |
| C_Project |
|
C_Campaign_ID
NUMBER (10, 0) |
| C_Campaign |
|
C_Activity_ID
NUMBER (10, 0) |
| C_Activity |
|
C_Invoice_ID
NUMBER (10, 0) |
| C_Invoice |
|
DocumentNo
NVARCHAR2 (30) |
| |
|
DateInvoiced
DATE |
| |
|
DateAcct
DATE |
| |
|
Description
NVARCHAR2 (255) |
| |
|
M_Product_ID
NUMBER (10, 0) |
| M_Product |
|
ProductValue
NVARCHAR2 (40) |
| |
|
UPC
NVARCHAR2 (30) |
| |
|
SKU
NVARCHAR2 (30) |
| |
|
C_Tax_ID
NUMBER (10, 0) |
| C_Tax |
|
TaxIndicator
VARCHAR2 (5) |
| |
|
TaxAmt
NUMBER default: 0 |
| |
|
C_InvoiceLine_ID
NUMBER (10, 0) |
| C_InvoiceLine |
|
LineDescription
NVARCHAR2 (255) |
| |
|
QtyOrdered
NUMBER default: 0 |
| |
|
PriceActual
NUMBER default: 0 |
| |
FOREIGN KEY
ADOrg_IInvoice: AD_Org_ID => AD_Org
ADOrgTrx_IInvoice: AD_OrgTrx_ID => AD_Org
ADUser_IInvoice: AD_User_ID => AD_User
ADUserSalesRep_IInvoice: SalesRep_ID => AD_User
CActivity_IInvoice: C_Activity_ID => C_Activity
CBPartner_IInvoice: C_BPartner_ID => C_BPartner
CBPLocation_IInvoice: C_BPartner_Location_ID => C_BPartner_Location
CCampaign_IInvoice: C_Campaign_ID => C_Campaign
CCountry_IInvoice: C_Country_ID => C_Country
CCurrency_IInvoice: C_Currency_ID => C_Currency
CDocType_IInvoice: C_DocType_ID => C_DocType
CInvliceLine_IInvoice: C_InvoiceLine_ID => C_InvoiceLine
CInvoice_IInvoice: C_Invoice_ID => C_Invoice
CLocation_IInvoice: C_Location_ID => C_Location
CPaymentTerm_IInvoice: C_PaymentTerm_ID => C_PaymentTerm
CProject_IInvoice: C_Project_ID => C_Project
CRegion_IInvoice: C_Region_ID => C_Region
CTax_IInvoice: C_Tax_ID => C_Tax
MPriceList_IInvoice: M_PriceList_ID => M_PriceList
NProduct_IInvoice: M_Product_ID => M_Product
|