Description:
Sales & Purchase Order
|
| PRIMARY KEY |
|
C_Order_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 |
AD_Reference_ID=131
| |
|
DocAction
CHAR (2) NOT NULL |
AD_Reference_ID=135
| |
|
Processing
CHAR (1) |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_DocType_ID
NUMBER (10, 0) NOT NULL |
| C_DocType |
|
C_DocTypeTarget_ID
NUMBER (10, 0) NOT NULL |
| C_DocType |
|
Ref_Order_ID
NUMBER (10, 0) |
| C_Order |
|
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
| |
|
IsCreditApproved
CHAR (1) default: 'N' CHECK ( IsCreditApproved in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsDelivered
CHAR (1) default: 'N' CHECK ( IsDelivered in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsInvoiced
CHAR (1) default: 'N' CHECK ( IsInvoiced in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsPrinted
CHAR (1) default: 'N' CHECK ( IsPrinted in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsTransferred
CHAR (1) default: 'N' CHECK ( IsTransferred in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsSelected
CHAR (1) default: 'N' CHECK ( IsSelected in ( 'Y' , 'N' )) NOT NULL |
Manual Invoice generation
| |
|
SalesRep_ID
NUMBER (10, 0) |
| AD_User |
|
DateOrdered
DATE NOT NULL |
| |
|
DatePromised
DATE |
| |
|
DatePrinted
DATE |
| |
|
DateAcct
DATE NOT NULL |
| |
|
C_BPartner_ID
NUMBER (10, 0) NOT NULL |
| C_BPartner |
|
C_BPartner_Location_ID
NUMBER (10, 0) NOT NULL |
| C_BPartner_Location |
|
AD_User_ID
NUMBER (10, 0) |
| AD_User |
|
Bill_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
Bill_Location_ID
NUMBER (10, 0) |
| C_BPartner_Location |
|
BillTo_ID
NUMBER (10, 0) |
| C_BPartner_Location |
|
Bill_User_ID
NUMBER (10, 0) |
| AD_User |
|
Pay_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
Pay_Location_ID
NUMBER (10, 0) |
| C_BPartner_Location |
|
POReference
NVARCHAR2 (20) |
| |
|
IsDiscountPrinted
CHAR (1) default: 'Y' CHECK ( IsDiscountPrinted in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_Currency_ID
NUMBER (10, 0) NOT NULL |
| C_Currency |
|
C_ConversionType_ID
NUMBER (10, 0) |
| C_ConversionType |
|
PaymentRule
CHAR (1) NOT NULL |
AD_Reference_ID=195
| |
|
C_PaymentTerm_ID
NUMBER (10, 0) NOT NULL |
| C_PaymentTerm |
|
InvoiceRule
CHAR (1) NOT NULL |
| |
|
DeliveryRule
CHAR (1) NOT NULL |
| |
|
FreightCostRule
CHAR (1) NOT NULL |
| |
|
FreightAmt
NUMBER default: 0 |
| |
|
DeliveryViaRule
CHAR (1) NOT NULL |
| |
|
M_Shipper_ID
NUMBER (10, 0) |
| M_Shipper |
|
C_Charge_ID
NUMBER (10, 0) |
| C_Charge |
|
ChargeAmt
NUMBER default: 0 |
| |
|
PriorityRule
CHAR (1) NOT NULL |
| |
|
TotalLines
NUMBER default: 0 NOT NULL |
| |
|
GrandTotal
NUMBER default: 0 NOT NULL |
| |
|
M_Warehouse_ID
NUMBER (10, 0) NOT NULL |
| M_Warehouse |
|
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 |
|
C_Payment_ID
NUMBER (10, 0) |
Temporary
| C_Payment |
|
C_CashLine_ID
NUMBER (10, 0) |
Temporary
| C_CashLine |
|
Posted
CHAR (1) default: 'N' NOT NULL |
| |
|
SendEMail
CHAR (1) default: 'N' CHECK ( SendEMail in ( 'Y' , 'N' )) NOT NULL |
| |
|
CopyFrom
CHAR (1) |
Copy from same entity
| |
|
User1_ID
NUMBER (10, 0) |
| C_ElementValue |
|
User2_ID
NUMBER (10, 0) |
| C_ElementValue |
FOREIGN KEY
ADOrg_COrder: AD_Org_ID => AD_Org
ADOrgTrx_COrder: AD_OrgTrx_ID => AD_Org
ADUser_COrder: AD_User_ID => AD_User
ADUser_SR_COrder: SalesRep_ID => AD_User
ADUserBill_COrder: Bill_User_ID => AD_User
C_DocType_COrder: C_DocType_ID => C_DocType
CActivity_COrder: C_Activity_ID => C_Activity
CBPartner_COrder: C_BPartner_ID => C_BPartner
CBPartnerBill_COrder: Bill_BPartner_ID => C_BPartner
CBPartnerLocation_COrder: C_BPartner_Location_ID => C_BPartner_Location
CBPartnerPay_COrder: Pay_BPartner_ID => C_BPartner
CBPLocationBill_COrder: Bill_Location_ID => C_BPartner_Location
CBPLocationBillTo_SOHeader: BillTo_ID => C_BPartner_Location
CBPLocationPay_COrder: Pay_Location_ID => C_BPartner_Location
CCampaign_COrder: C_Campaign_ID => C_Campaign
CCashLine_COrder: C_CashLine_ID => C_CashLine
CCharge_COrder: C_Charge_ID => C_Charge
CConversionType_COrder: C_ConversionType_ID => C_ConversionType
CCurrency_COrder: C_Currency_ID => C_Currency
CDocTypeTarget_COrder: C_DocTypeTarget_ID => C_DocType
CElemenrValueUSer2_COrder: User2_ID => C_ElementValue
CElementValueUser1_COrder: User1_ID => C_ElementValue
COrder_Ref: Ref_Order_ID => C_Order
CPayment_COrder: C_Payment_ID => C_Payment
CPaymentTerm_SOHeader: C_PaymentTerm_ID => C_PaymentTerm
CProject_COrder: C_Project_ID => C_Project
MPriceList_SOHeader: M_PriceList_ID => M_PriceList
MShipper_COrder: M_Shipper_ID => M_Shipper
MWarehouse_COrder: M_Warehouse_ID => M_Warehouse
|
REFERENCED BY
B_BuyerFunds,
B_SellerFunds,
C_Allocation,
C_Invoice,
C_Order,
C_OrderLine,
C_OrderTax,
C_ProjectLine,
C_ProjectLine,
C_ProjectPhase,
C_Recurring,
C_Recurring_Run,
C_RfQ,
C_RfQResponse,
I_Order,
M_InOut,
R_Request,
R_RequestAction |
|