| PRIMARY KEY |
|
C_DocType_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_PrintFormat_ID
NUMBER (10, 0) |
| AD_PrintFormat |
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| |
|
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 |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
PrintName
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
DocBaseType
CHAR (3) NOT NULL |
| |
|
IsSOTrx
CHAR (1) default: 'Y' CHECK ( IsSOTrx in ( 'Y' , 'N' )) NOT NULL |
| |
|
DocSubTypeSO
CHAR (2) |
| |
|
HasProForma
CHAR (1) default: 'N' CHECK ( HasProForma in ( 'Y' , 'N' )) |
| |
|
C_DocTypeProForma_ID
NUMBER (10, 0) |
| C_DocType |
|
C_DocTypeShipment_ID
NUMBER (10, 0) |
| C_DocType |
|
C_DocTypeInvoice_ID
NUMBER (10, 0) |
| C_DocType |
|
CreatePickList
CHAR (1) default: 'N' CHECK ( CreatePickList in ( 'Y' , 'N' )) |
| |
|
IsApproved
CHAR (1) default: 'N' CHECK ( IsApproved in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_Approval_ID
NUMBER (10, 0) |
| C_Approval |
|
IsDocNoControlled
CHAR (1) default: 'N' CHECK ( IsDocNoControlled in ( 'Y' , 'N' )) NOT NULL |
| |
|
DocNoSequence_ID
NUMBER (10, 0) |
| AD_Sequence |
|
IsBatched
CHAR (1) default: 'N' CHECK ( IsBatched in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsBatchControlEnforced
CHAR (1) default: 'N' CHECK ( IsBatchControlEnforced in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsBatchDocNoControlled
CHAR (1) default: 'N' CHECK ( IsBatchDocNoControlled in ( 'Y' , 'N' )) NOT NULL |
| |
|
BatchNoSequence_ID
NUMBER (10, 0) |
| AD_Sequence |
|
GL_Category_ID
NUMBER (10, 0) NOT NULL |
| GL_Category |
|
IsPrinted
CHAR (1) default: 'Y' CHECK ( IsPrinted in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsTransferred
CHAR (1) default: 'Y' CHECK ( IsTransferred in ( 'Y' , 'N' )) NOT NULL |
| |
|
HasCharges
CHAR (1) default: 'N' CHECK ( HasCharges in ( 'Y' , 'N' )) NOT NULL |
| |
|
DocumentNote
NVARCHAR2 (2000) |
| |
|
IsDefault
CHAR (1) default: 'N' CHECK ( IsDefault in ( 'Y' , 'N' )) NOT NULL |
| |
|
DocumentCopies
NUMBER (10, 0) NOT NULL |
| |
FOREIGN KEY
AD_Sequence_DocTypeBatch: BatchNoSequence_ID => AD_Sequence
AD_Sequence_DocTypeDoc: DocNoSequence_ID => AD_Sequence
ADPrintFormat_CDocType: AD_PrintFormat_ID => AD_PrintFormat
C_Approval_DocType: C_Approval_ID => C_Approval
CDocType_Invoice: C_DocTypeInvoice_ID => C_DocType
CDocType_ProForma: C_DocTypeProForma_ID => C_DocType
CDocType_Shipment: C_DocTypeShipment_ID => C_DocType
GLCategory_CDocType: GL_Category_ID => GL_Category
|
REFERENCED BY
C_DocType,
C_DocType,
C_DocType,
C_DocType_Trl,
C_Invoice,
C_Invoice,
C_Order,
C_Order,
C_Payment,
GL_Journal,
GL_JournalBatch,
I_GLJournal,
I_Invoice,
I_Order,
I_Payment,
M_InOut |
|