| PRIMARY KEY |
|
I_Order_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' )) |
| |
|
SalesRep_ID
NUMBER (10, 0) |
| AD_User |
|
M_Warehouse_ID
NUMBER (10, 0) |
| M_Warehouse |
|
M_PriceList_ID
NUMBER (10, 0) |
| M_PriceList |
|
C_Currency_ID
NUMBER (10, 0) |
| C_Currency |
|
M_Shipper_ID
NUMBER (10, 0) |
| M_Shipper |
|
IsSOTrx
CHAR (1) default: 'Y' CHECK ( IsSOTrx in ( 'Y' , 'N' )) |
| |
|
C_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
BPartnerValue
NVARCHAR2 (40) |
| |
|
Name
NVARCHAR2 (60) |
| |
|
C_BPartner_Location_ID
NUMBER (10, 0) |
| C_BPartner_Location |
|
BillTo_ID
NUMBER (10, 0) |
| C_BPartner_Location |
|
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) |
| |
|
C_Country_ID
NUMBER (10, 0) |
| C_Country |
|
CountryCode
CHAR (2) |
| |
|
AD_User_ID
NUMBER (10, 0) |
| AD_User |
|
ContactName
NVARCHAR2 (60) |
| |
|
EMail
NVARCHAR2 (60) |
| |
|
Phone
NVARCHAR2 (40) |
| |
|
C_Project_ID
NUMBER (10, 0) |
| C_Project |
|
C_Activity_ID
NUMBER (10, 0) |
| C_Activity |
|
C_DocType_ID
NUMBER (10, 0) |
| C_DocType |
|
DocTypeName
NVARCHAR2 (60) |
| |
|
C_PaymentTerm_ID
NUMBER (10, 0) |
| C_PaymentTerm |
|
PaymentTermValue
NVARCHAR2 (40) |
| |
|
C_Order_ID
NUMBER (10, 0) |
| C_Order |
|
DocumentNo
NVARCHAR2 (30) |
| |
|
DateOrdered
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_OrderLine_ID
NUMBER (10, 0) |
| C_OrderLine |
|
LineDescription
NVARCHAR2 (255) |
| |
|
C_UOM_ID
NUMBER (10, 0) |
| C_UOM |
|
QtyOrdered
NUMBER default: 0 |
| |
|
PriceActual
NUMBER default: 0 |
| |
|
FreightAmt
NUMBER default: 0 |
| |
|
C_Campaign_ID
NUMBER (10, 0) |
| C_Campaign |
FOREIGN KEY
ADOrg_IOrder: AD_Org_ID => AD_Org
ADOrgTrx_IOrder: AD_OrgTrx_ID => AD_Org
ADUser_IOrder: AD_User_ID => AD_User
ADUserSalesRep_IOrder: SalesRep_ID => AD_User
CACtivity_IOrder: C_Activity_ID => C_Activity
CBOLocation_IOrder: C_BPartner_Location_ID => C_BPartner_Location
CBPartner_IOrder: C_BPartner_ID => C_BPartner
CBPartnerLocBillTo_IOrder: BillTo_ID => C_BPartner_Location
CCampaign_IOrder: C_Campaign_ID => C_Campaign
CCountry_IOrder: C_Country_ID => C_Country
CCurrency_IOrder: C_Currency_ID => C_Currency
CDocType_IOrder: C_DocType_ID => C_DocType
CLocation_IOrder: C_Location_ID => C_Location
COrder_IOrder: C_Order_ID => C_Order
COrderLine_IOrder: C_OrderLine_ID => C_OrderLine
CPaymentTerm_IOrder: C_PaymentTerm_ID => C_PaymentTerm
CProject_IOrder: C_Project_ID => C_Project
CRegion_IOrder: C_Region_ID => C_Region
CTax_IOrder: C_Tax_ID => C_Tax
CUOM_IOrder: C_UOM_ID => C_UOM
MPriceList_IOrder: M_PriceList_ID => M_PriceList
MProduct_IOrder: M_Product_ID => M_Product
MShipper_IOrder: M_Shipper_ID => M_Shipper
MWarehouse_IOrder: M_Warehouse_ID => M_Warehouse
|