Description:
Shipment & Customer Returns, Receipts & Vendor Returns
|
| PRIMARY KEY |
|
M_InOut_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 |
| |
|
DocAction
CHAR (2) NOT NULL |
| |
|
DocStatus
CHAR (2) NOT NULL |
| |
|
Posted
CHAR (1) default: 'N' NOT NULL |
| |
|
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 |
|
Description
NVARCHAR2 (255) |
| |
|
C_Order_ID
NUMBER (10, 0) |
| C_Order |
|
Ref_InOut_ID
NUMBER (10, 0) |
| M_InOut |
|
DateOrdered
DATE |
| |
|
SalesRep_ID
NUMBER (10, 0) |
| AD_User |
|
IsPrinted
CHAR (1) default: 'N' CHECK ( IsPrinted in ( 'Y' , 'N' )) NOT NULL |
| |
|
MovementType
CHAR (2) NOT NULL |
| |
|
MovementDate
DATE NOT NULL |
| |
|
IsInTransit
CHAR (1) default: 'N' CHECK ( IsInTransit in ( 'Y' , 'N' )) NOT NULL |
| |
|
DateReceived
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 |
|
M_Warehouse_ID
NUMBER (10, 0) NOT NULL |
| M_Warehouse |
|
POReference
NVARCHAR2 (20) |
| |
|
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 |
|
TrackingNo
NVARCHAR2 (60) |
| |
|
NoPackages
NUMBER (10, 0) |
| |
|
PickDate
DATE |
| |
|
ShipDate
DATE |
| |
|
C_Charge_ID
NUMBER (10, 0) |
| C_Charge |
|
ChargeAmt
NUMBER default: 0 |
| |
|
PriorityRule
CHAR (1) NOT NULL |
| |
|
DatePrinted
DATE |
| |
|
C_Invoice_ID
NUMBER (10, 0) |
| |
|
CreateFrom
CHAR (1) |
Create From another entity
| |
|
GenerateTo
CHAR (1) CHECK ( GenerateTo in ( 'Y' , 'N' )) |
| |
|
SendEMail
CHAR (1) default: 'N' CHECK ( SendEMail in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_Project_ID
NUMBER (10, 0) |
| C_Project |
|
C_Campaign_ID
NUMBER (10, 0) |
| C_Campaign |
|
C_Activity_ID
NUMBER (10, 0) |
| C_Activity |
|
User2_ID
NUMBER (10, 0) |
| C_ElementValue |
|
User1_ID
NUMBER (10, 0) |
| C_ElementValue |
FOREIGN KEY
ADOrg_MInOut: AD_Org_ID => AD_Org
ADOrgTrx_MInOut: AD_OrgTrx_ID => AD_Org
ADUser_MInOut: AD_User_ID => AD_User
ADUser_SR_MInOut: SalesRep_ID => AD_User
CActivity_MInOut: C_Activity_ID => C_Activity
CBPartner_MInOut: C_BPartner_ID => C_BPartner
CCampaign_MInOut: C_Campaign_ID => C_Campaign
CCharge_MInOut: C_Charge_ID => C_Charge
CDocType_MInOut: C_DocType_ID => C_DocType
CElementValueUser1_MInOut: User1_ID => C_ElementValue
CElementValueUser2_MInOut: User2_ID => C_ElementValue
COrder_MInOut: C_Order_ID => C_Order
CProject_MInOut: C_Project_ID => C_Project
MInOut_Ref: Ref_InOut_ID => M_InOut
MShipper_MInOut: M_Shipper_ID => M_Shipper
MWarehouse_MInOut: M_Warehouse_ID => M_Warehouse
VBPLocation_MInOut: C_BPartner_Location_ID => C_BPartner_Location
|
REFERENCED BY
M_InOut,
M_InOutLine,
M_Package,
M_RMA |
|