Use this function to create a Customer type service and warranty record in F1797 table.
Oracle Doc: Setting Up Service Management (oracle.com)
Data Structure:
|
Name |
Data Type |
Inclusion |
Direction |
Parameter Notes |
|---|---|---|---|---|
|
mnAddressNumber |
ADDRESSNUMBER |
REQUIRED |
IN |
A/B number used for creating record |
|
cInformationType1 |
CHARACTER |
REQUIRED |
IN |
Must be “C” for this type |
|
szCompany |
COMPANY |
REQUIRED |
IN |
|
|
szTimeZoes |
UDC |
REQUIRED |
BOTH |
UDC H91|TZ |
|
szDaylightSavingsRuleName |
STRING |
OPTIONAL |
BOTH |
Value from F00085 table |
|
cSuppressErrors_EV01 |
CHARACTER |
OPTIONAL |
IN |
|
|
cErrorCode_EV01 |
CHARACTER |
OPTIONAL |
OUT |
|
|
szErrorDataItem_DTAI |
ERRORALIAS |
OPTIONAL |
OUT |
|
|
szPriceAdjustScheduleCN |
UDC |
OPTIONAL |
BOTH |
UDC 40|AS |
|
szPriceAdjustScheduleServi |
UDC |
OPTIONAL |
BOTH |
UDC 40|AS |
|
szPriceAdjustScheduleServi_2 |
UDC |
OPTIONAL |
BOTH |
UDC 40|AS |
|
szPriceAdjustScheduleFour |
UDC |
OPTIONAL |
BOTH |
UDC 40|AS |
|
szPriceAdjustScheduleFive |
UDC |
OPTIONAL |
BOTH |
UDC 40|AS |
|
mnSupervisor |
ADDRESSNUMBER |
OPTIONAL |
BOTH |
|
|
mnDefaultDealer |
ADDRESSNUMBER |
OPTIONAL |
BOTH |
|
|
cTypeWo |
UDC |
OPTIONAL |
BOTH |
UDC 00|TY |
|
szGeographicRegion |
UDC |
OPTIONAL |
BOTH |
UDC 17|GR |
|
szStandardCarrierAlphaCode |
STRING |
OPTIONAL |
BOTH |
|
|
szShipmentTrackingBusiness |
STRING |
OPTIONAL |
BOTH |
|
|
cActiveInactive |
CHARACTER |
OPTIONAL |
BOTH |
|
|
szPhoneNumber |
STRING |
OPTIONAL |
BOTH |
|
|
szMailBoxDesignator |
UDC |
OPTIONAL |
BOTH |
UDC 02|MB |
|
szRemark1 |
STRING |
OPTIONAL |
BOTH |
|
|
szCostCenterHome |
BUSINESSUNIT |
OPTIONAL |
BOTH |
|
|
szObjectAccount |
STRING |
OPTIONAL |
BOTH |
|
|
szSubsidiary |
STRING |
OPTIONAL |
BOTH |
|
|
szServiceGroup |
UDC |
OPTIONAL |
BOTH |
UDC 17|SG |
|
szCatCode1 |
UDC |
OPTIONAL |
BOTH |
UDC 17|01 |
|
szCatCode2 |
UDC |
OPTIONAL |
BOTH |
UDC 17|02 |
|
szCatCode3 |
UDC |
OPTIONAL |
BOTH |
UDC 17|03 |
|
szCatCode4 |
UDC |
OPTIONAL |
BOTH |
UDC 17|04 |
|
szCatCode5 |
UDC |
OPTIONAL |
BOTH |
UDC 17|05 |
|
szCatCode6 |
UDC |
OPTIONAL |
BOTH |
UDC 17|06 |
|
szCatCode7 |
UDC |
OPTIONAL |
BOTH |
UDC 17|07 |
|
szCatCode8 |
UDC |
OPTIONAL |
BOTH |
UDC 17|08 |
|
szCatCode9 |
UDC |
OPTIONAL |
BOTH |
UDC 17|09 |
|
szCatCode10 |
UDC |
OPTIONAL |
BOTH |
UDC 17|00 |
|
cMethodofPricing |
UDC |
OPTIONAL |
BOTH |
UDC 17|MP |
|
cServProviderPayMethod |
UDC |
OPTIONAL |
BOTH |
UDC 17|PY |
|
cPayServProviderForParts |
UDC |
OPTIONAL |
BOTH |
UDC 17|YN |
|
szCostCenter |
BUSINESSUNIT |
OPTIONAL |
BOTH |
|
|
mnUserReservedNumber |
INTEGER |
OPTIONAL |
BOTH |
|
|
szUserReservedCode |
STRING |
OPTIONAL |
BOTH |
|
|
mnUserReservedAmount |
FLOAT |
OPTIONAL |
BOTH |
|
|
jdUserReservedDate |
DATE |
OPTIONAL |
BOTH |
|
|
szUserReservedReference |
STRING |
OPTIONAL |
BOTH |
|
|
szCreatedByUser |
STRING |
OPTIONAL |
BOTH |
|
|
cReimbursementMethod |
CHARACTER |
OPTIONAL |
BOTH |
C = Credit Memo
|
|
cYesOrNoEntry1 |
CHARACTER |
OPTIONAL |
BOTH |
Must be “Y” |
|
ActionCode_EV01 |
CHARACTER |
REQUIRED |
IN |
1 = Add record 2 = Update record 3 = Delete record |