Table Name: WS10801
Other stored procedures called: wsiWSTransactionHeaderCreatePre, wsiWSTransactionHeaderCreatePost, taGLTransactionHeaderInsert
Description:
This procedure will insert new WS transaction header records into the WS10801 table.
|
Element Name |
Data Type |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
|
@I_vBatchNumber |
char |
15 |
Yes |
|
Validated |
|
@I_vBatchSource |
char |
15 |
Yes |
GL_Normal' |
|
|
@I_vJournalEntry |
int |
10 |
Yes |
|
Validated |
|
@I_vRecurringTRXSequence |
numeric |
19,5 |
No |
|
|
|
@I_vSourceDocument |
char |
11 |
No |
GJ' |
Validated |
|
@I_vReference |
char |
31 |
No |
None' |
|
|
@I_vTRXDate |
datetime |
|
Yes |
|
Validated |
|
@I_vReversingDate |
datetime |
|
No |
1/1/1900' |
|
|
@I_vRecurringTRX |
tinyint |
3 |
No |
0 |
|
|
@I_vBalanceForCalculation |
smallint |
5 |
No |
0 |
|
|
@I_vLastUser |
char |
15 |
No |
' |
|
|
@I_vLastDateEdited |
datetime |
|
No |
1/1/1900' |
|
|
@I_vTransactionType |
smallint |
2 |
No |
0 |
|
|
@I_vSequenceLine |
numeric |
19,5 |
No |
0 |
|
|
@I_vGLHDRMessages |
binary |
4 |
No |
|
|
|
@I_vGLHDRMessages2 |
binary |
4 |
No |
|
|
|
@I_vTRXSource |
char |
13 |
No |
' |
|
|
@I_vOriginatingTRXType |
smallint |
5 |
No |
0 |
|
|
@I_vOriginatingControlNumber |
char |
21 |
No |
' |
|
|
@I_vOriginatingMasterID |
char |
31 |
No |
' |
|
|
@I_vOriginatingMasterName |
char |
65 |
No |
' |
|
|
@I_vOriginatingDocumentNumber |
char |
21 |
No |
' |
|
|
@I_vOriginatingPostedDate |
datetime |
|
No |
1/1/1900' |
|
|
@I_vOriginatingTRXSource |
char |
13 |
No |
' |
|
|
@I_vCurrencyID |
char |
15 |
No |
Z-US$' |
|
|
@I_vClosedYear |
smallint |
5 |
No |
0 |
|
|
@I_vHistoryTRX |
tinyint |
3 |
No |
0 |
|
|
@I_vReversingPeriodID |
smallint |
5 |
No |
0 |
|
|
@I_vReversingYear |
smallint |
5 |
No |
0 |
|
|
@I_vReversingClosedYear |
smallint |
5 |
No |
0 |
|
|
@I_vReversingHistoryTRX |
tinyint |
3 |
No |
0 |
|
|
@I_vICTRX |
tinyint |
3 |
No |
0 |
|
|
@I_vUserDefine1 |
char |
31 |
No |
' |
|
|
@I_vUserDefine2 |
char |
31 |
No |
' |
|
|
@I_vUserDefined1 |
char |
21 |
No |
' |
|
|
@I_vUserDefined2 |
char |
21 |
No |
' |
|
|
@I_vUserDefinedInteger1 |
int |
10 |
No |
0 |
|
|
@I_vUserDefinedInteger2 |
int |
10 |
No |
0 |
|
|
@I_vUserDefinedInteger3 |
int |
10 |
No |
0 |
|
|
@I_vUserDefinedInteger4 |
int |
10 |
No |
0 |
|
|
@I_vUserDefinedDollar1 |
numeric |
19,5 |
No |
0 |
|
|
@I_vUserDefinedDollar2 |
numeric |
19,5 |
No |
0 |
|
|
@I_vUserDefinedDollar3 |
numeric |
19,5 |
No |
0 |
|
|
@I_vUserDefinedDollar4 |
numeric |
19,5 |
No |
0 |
|
|
@I_vUserDefinedDate1 |
datetime |
|
No |
1/1/1900' |
|
|
@I_vUserDefinedDate2 |
datetime |
|
No |
1/1/1900' |
|
|
@I_vUserDefinedDate3 |
datetime |
|
No |
1/1/1900' |
|
|
@I_vUserDefinedDate4 |
datetime |
|
No |
1/1/1900' |
|
|
@I_vUserDefinedCB1 |
tinyint |
3 |
No |
0 |
|
|
@I_vUserDefinedCB2 |
tinyint |
3 |
No |
0 |
|
|
@I_vUserDefinedCB3 |
tinyint |
3 |
No |
0 |
|
|
@I_vUserDefinedCB4 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB1 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB2 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB3 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB4 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB5 |
tinyint |
3 |
No |
0 |
|
|
@I_vWennSoftTablesOnly |
tinyint |
3 |
No |
0 |
|
|
@I_vOnlyValidate |
tinyint |
3 |
No |
0 |
|
|
@I_vUSRDEFND1 |
char |
50 |
No |
' |
|
|
@I_vUSRDEFND2 |
char |
50 |
No |
' |
|
|
@I_vUSRDEFND3 |
char |
50 |
No |
' |
|
|
@I_vUSRDEFND4 |
varchar |
8000 |
No |
' |
|
|
@I_vUSRDEFND5 |
varchar |
8000 |
No |
' |
|
|
@I_vReturnErrorText |
tinyint |
1 |
No |
1 |
|
|
@O_iErrorState |
int |
10 |
No |
0 |
|
|
@oErrString |
varchar |
255 |
No |
' |
|